DBA Data[Home] [Help]

APPS.XLA_ACCOUNTING_PKG dependencies on DBMS_AQADM

Line 3499: dbms_aqadm.create_queue

3495: ,p_level => C_LEVEL_EVENT
3496: ,p_module => l_log_module);
3497: END IF;
3498:
3499: dbms_aqadm.create_queue
3500: (queue_name => g_queue_name
3501: ,queue_table => g_queue_table_name); --C_QUEUE_TABLE);
3502: print_logfile(to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')||' - Queue Created = '||g_queue_name);
3503:

Line 3504: dbms_aqadm.create_queue

3500: (queue_name => g_queue_name
3501: ,queue_table => g_queue_table_name); --C_QUEUE_TABLE);
3502: print_logfile(to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')||' - Queue Created = '||g_queue_name);
3503:
3504: dbms_aqadm.create_queue
3505: (queue_name => g_comp_queue_name
3506: ,queue_table => g_queue_table_name); --C_QUEUE_TABLE);
3507: print_logfile(to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')||' - Queue Created = '||g_comp_queue_name);
3508:

Line 3522: dbms_aqadm.start_queue

3518: ,p_level => C_LEVEL_EVENT
3519: ,p_module => l_log_module);
3520: END IF;
3521:
3522: dbms_aqadm.start_queue
3523: (queue_name => g_queue_name);
3524: print_logfile(to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')||' - Queue Started = '||g_queue_name);
3525:
3526: dbms_aqadm.start_queue

Line 3526: dbms_aqadm.start_queue

3522: dbms_aqadm.start_queue
3523: (queue_name => g_queue_name);
3524: print_logfile(to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')||' - Queue Started = '||g_queue_name);
3525:
3526: dbms_aqadm.start_queue
3527: (queue_name => g_comp_queue_name);
3528: print_logfile(to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')||' - Queue Started = '||g_comp_queue_name);
3529:
3530: l_queue_started_flag := 'Y';

Line 4152: dbms_aqadm.stop_queue(queue_name => g_queue_name

4148: ,p_level => C_LEVEL_EVENT
4149: ,p_module => l_log_module);
4150: END IF;
4151:
4152: dbms_aqadm.stop_queue(queue_name => g_queue_name
4153: ,wait => TRUE); --5056507
4154: print_logfile(to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')||' - Queue stopped = '||g_queue_name);
4155: dbms_aqadm.stop_queue(queue_name => g_comp_queue_name
4156: ,wait => TRUE); --5056507

Line 4155: dbms_aqadm.stop_queue(queue_name => g_comp_queue_name

4151:
4152: dbms_aqadm.stop_queue(queue_name => g_queue_name
4153: ,wait => TRUE); --5056507
4154: print_logfile(to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')||' - Queue stopped = '||g_queue_name);
4155: dbms_aqadm.stop_queue(queue_name => g_comp_queue_name
4156: ,wait => TRUE); --5056507
4157: print_logfile(to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')||' - Queue stopped = '||g_comp_queue_name);
4158: p_queue_started_flag := 'N';
4159:

Line 4176: dbms_aqadm.drop_queue(queue_name => g_queue_name);

4172: ,p_level => C_LEVEL_EVENT
4173: ,p_module => l_log_module);
4174: END IF;
4175:
4176: dbms_aqadm.drop_queue(queue_name => g_queue_name);
4177: print_logfile(to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')||' - Queue dropped = '||g_queue_name);
4178: dbms_aqadm.drop_queue(queue_name => g_comp_queue_name);
4179: print_logfile(to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')||' - Queue dropped = '||g_comp_queue_name);
4180: p_queue_created_flag := 'N';

Line 4178: dbms_aqadm.drop_queue(queue_name => g_comp_queue_name);

4174: END IF;
4175:
4176: dbms_aqadm.drop_queue(queue_name => g_queue_name);
4177: print_logfile(to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')||' - Queue dropped = '||g_queue_name);
4178: dbms_aqadm.drop_queue(queue_name => g_comp_queue_name);
4179: print_logfile(to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')||' - Queue dropped = '||g_comp_queue_name);
4180: p_queue_created_flag := 'N';
4181:
4182: IF (C_LEVEL_EVENT >= g_log_level) THEN