Tuesday, May 7, 2013

create concurrent programs from database


Concurrent program register from Back End using FND API's

API's used are
1)FND_PROGRAM.executable  is used for defining executable .

Tables Affecting FND_EXECUTABLES and FND_EXECUTABLES_TL

BEGIN
  FND_PROGRAM.executable(executable => XX_TT_TEST' ,    -- Executable Name
  application=>'XXTT' ,    -- Application Short Name
  short_name=>'XX_TT_TEST' ,    -- Executable Short Name
  description=>'Test Executable created from Backend' ,     -- Description,DEFAULT NULL
  execution_method=>'PL/SQL Stored Procedure',              -- Execution Method
  execution_file_name=>'XXTT_TEST_PROCEDURE' ,              -- Execution File Name,DEFAULT NULL
  subroutine_name=>NULL ,                                   -- Subroutine Name,DEFAULT NULL
  icon_name=>NULL ,                                         -- Icon Name,DEFAULT NULL
  language_code=>'US' ,                                     -- Language Code,DEFAULT 'US'
  execution_file_path=>NULL                                 -- Execution File Path, DEFAULT NULL
  );
  COMMIT;
END;