DBA Data[Home] [Help]

APPS.FND_MANAGER dependencies on FND_CONCURRENT_PROCESSORS

Line 184: lib_id fnd_concurrent_processors.concurrent_processor_id%type;

180: -- Get a concurrent library ID given appl ID and name
181: --
182: FUNCTION library_id_f(lib_appl_id number,
183: lib_name varchar2) return number is
184: lib_id fnd_concurrent_processors.concurrent_processor_id%type;
185: begin
186: select concurrent_processor_id
187: into lib_id
188: from fnd_concurrent_processors

Line 188: from fnd_concurrent_processors

184: lib_id fnd_concurrent_processors.concurrent_processor_id%type;
185: begin
186: select concurrent_processor_id
187: into lib_id
188: from fnd_concurrent_processors
189: where application_id = lib_appl_id
190: and lib_name = concurrent_processor_name;
191:
192: return lib_id;

Line 427: lib_id fnd_concurrent_processors.concurrent_processor_id%TYPE;

423: mgr_id fnd_concurrent_queues.concurrent_queue_id%TYPE;
424: type_code fnd_concurrent_queues.manager_type%TYPE;
425: dg_id fnd_data_groups.data_group_id%TYPE;
426: lib_appl_id fnd_application.application_id%TYPE;
427: lib_id fnd_concurrent_processors.concurrent_processor_id%TYPE;
428:
429: last_update_login fnd_concurrent_queues.last_update_login%TYPE
430: := last_update_login_f;
431: l_update_date fnd_concurrent_queues.last_update_date%TYPE

Line 849: lib_id fnd_concurrent_processors.concurrent_processor_id%TYPE;

845: mgr_id fnd_concurrent_queues.concurrent_queue_id%TYPE;
846: ws_id fnd_concurrent_time_periods.concurrent_time_period_id%TYPE;
847: dg_id fnd_data_groups.data_group_id%TYPE;
848: lib_appl_id fnd_application.application_id%TYPE;
849: lib_id fnd_concurrent_processors.concurrent_processor_id%TYPE;
850: mgr_type fnd_concurrent_queues.manager_type%TYPE;
851:
852: last_update_login fnd_concurrent_queue_size.last_update_login%TYPE
853: := last_update_login_f;

Line 968: lib_id fnd_concurrent_processors.concurrent_processor_id%TYPE;

964: description IN VARCHAR2 DEFAULT NULL,
965: type IN VARCHAR2) is
966:
967: lib_appl_id fnd_application.application_id%TYPE;
968: lib_id fnd_concurrent_processors.concurrent_processor_id%TYPE;
969: type_code fnd_concurrent_processors.library_type%type;
970:
971: last_update_login fnd_concurrent_queues.last_update_login%TYPE
972: := last_update_login_f;

Line 969: type_code fnd_concurrent_processors.library_type%type;

965: type IN VARCHAR2) is
966:
967: lib_appl_id fnd_application.application_id%TYPE;
968: lib_id fnd_concurrent_processors.concurrent_processor_id%TYPE;
969: type_code fnd_concurrent_processors.library_type%type;
970:
971: last_update_login fnd_concurrent_queues.last_update_login%TYPE
972: := last_update_login_f;
973: last_update_date fnd_concurrent_queues.last_update_date%TYPE

Line 1005: select fnd_concurrent_processors_s.nextval

1001: raise bad_parameter;
1002: end;
1003:
1004: /* Get new library ID */
1005: select fnd_concurrent_processors_s.nextval
1006: into lib_id
1007: from sys.dual;
1008:
1009: insert into fnd_concurrent_processors

Line 1009: insert into fnd_concurrent_processors

1005: select fnd_concurrent_processors_s.nextval
1006: into lib_id
1007: from sys.dual;
1008:
1009: insert into fnd_concurrent_processors
1010: (application_id, concurrent_processor_id,
1011: concurrent_processor_name, last_update_date,
1012: last_updated_by, creation_date, created_by,
1013: last_update_login, description, library_type)

Line 1040: lib_id fnd_concurrent_processors.concurrent_processor_id%TYPE;

1036: program IN VARCHAR2,
1037: program_application IN VARCHAR2)
1038: is
1039: lib_appl_id fnd_application.application_id%TYPE;
1040: lib_id fnd_concurrent_processors.concurrent_processor_id%TYPE;
1041: prg_appl_id fnd_application.application_id%TYPE;
1042: prg_id fnd_concurrent_programs.concurrent_program_id%TYPE;
1043:
1044: last_update_login fnd_concurrent_queues.last_update_login%TYPE

Line 1355: from fnd_concurrent_processors

1351: lib_appl_id := application_id_f(application);
1352:
1353: select 'Y'
1354: into dummy
1355: from fnd_concurrent_processors
1356: where application_id = lib_appl_id
1357: and concurrent_processor_name = library;
1358:
1359: return TRUE;

Line 1386: lib_id fnd_concurrent_processors.concurrent_processor_id%TYPE;

1382: program_application IN VARCHAR2)
1383: RETURN BOOLEAN is
1384: lib_appl_id fnd_application.application_id%TYPE;
1385: prg_appl_id fnd_application.application_id%TYPE;
1386: lib_id fnd_concurrent_processors.concurrent_processor_id%TYPE;
1387: dummy varchar2(4);
1388: begin
1389: message_init;
1390:

Line 1608: lib_id fnd_concurrent_processors.concurrent_processor_id%TYPE;

1604: PROCEDURE delete_library(library IN VARCHAR2,
1605: application IN VARCHAR2) is
1606:
1607: lib_appl_id fnd_application.application_id%TYPE;
1608: lib_id fnd_concurrent_processors.concurrent_processor_id%TYPE;
1609:
1610: i number;
1611: begin
1612: message_init;

Line 1642: delete from fnd_concurrent_processors

1638: where concurrent_processor_id = lib_id
1639: and processor_application_id = lib_appl_id;
1640:
1641: /* Delete library */
1642: delete from fnd_concurrent_processors
1643: where concurrent_processor_id = lib_id
1644: and application_id = lib_appl_id;
1645: end delete_library;
1646: