DBA Data[Home] [Help]

APPS.XLA_ACCOUNTING_PKG dependencies on DBMS_AQADM

Line 1519: dbms_aqadm.stop_queue(queue_name => g_queue_name

1515: ,p_level => C_LEVEL_EVENT
1516: ,p_module => l_log_module);
1517: END IF;
1518:
1519: dbms_aqadm.stop_queue(queue_name => g_queue_name
1520: ,wait => TRUE); --5056507
1521: print_logfile(to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')||' - Queue stopped = '||g_queue_name);
1522: dbms_aqadm.stop_queue(queue_name => g_comp_queue_name
1523: ,wait => TRUE); --5056507

Line 1522: dbms_aqadm.stop_queue(queue_name => g_comp_queue_name

1518:
1519: dbms_aqadm.stop_queue(queue_name => g_queue_name
1520: ,wait => TRUE); --5056507
1521: print_logfile(to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')||' - Queue stopped = '||g_queue_name);
1522: dbms_aqadm.stop_queue(queue_name => g_comp_queue_name
1523: ,wait => TRUE); --5056507
1524: print_logfile(to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')||' - Queue stopped = '||g_comp_queue_name);
1525: g_queue_started_flag := 'N';
1526:

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

1539: ,p_level => C_LEVEL_EVENT
1540: ,p_module => l_log_module);
1541: END IF;
1542:
1543: dbms_aqadm.drop_queue(queue_name => g_queue_name);
1544: print_logfile(to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')||' - Queue dropped = '||g_queue_name);
1545: dbms_aqadm.drop_queue(queue_name => g_comp_queue_name);
1546: print_logfile(to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')||' - Queue dropped = '||g_comp_queue_name);
1547: g_queue_created_flag := 'N';

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

1541: END IF;
1542:
1543: dbms_aqadm.drop_queue(queue_name => g_queue_name);
1544: print_logfile(to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')||' - Queue dropped = '||g_queue_name);
1545: dbms_aqadm.drop_queue(queue_name => g_comp_queue_name);
1546: print_logfile(to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')||' - Queue dropped = '||g_comp_queue_name);
1547: g_queue_created_flag := 'N';
1548:
1549: IF (C_LEVEL_EVENT >= g_log_level) THEN

Line 3735: dbms_aqadm.create_queue

3731: ,p_level => C_LEVEL_EVENT
3732: ,p_module => l_log_module);
3733: END IF;
3734:
3735: dbms_aqadm.create_queue
3736: (queue_name => g_queue_name
3737: ,queue_table => g_queue_table_name); --C_QUEUE_TABLE);
3738: print_logfile(to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')||' - Queue Created = '||g_queue_name);
3739:

Line 3740: dbms_aqadm.create_queue

3736: (queue_name => g_queue_name
3737: ,queue_table => g_queue_table_name); --C_QUEUE_TABLE);
3738: print_logfile(to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')||' - Queue Created = '||g_queue_name);
3739:
3740: dbms_aqadm.create_queue
3741: (queue_name => g_comp_queue_name
3742: ,queue_table => g_queue_table_name); --C_QUEUE_TABLE);
3743: print_logfile(to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')||' - Queue Created = '||g_comp_queue_name);
3744:

Line 3758: dbms_aqadm.start_queue

3754: ,p_level => C_LEVEL_EVENT
3755: ,p_module => l_log_module);
3756: END IF;
3757:
3758: dbms_aqadm.start_queue
3759: (queue_name => g_queue_name);
3760: print_logfile(to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')||' - Queue Started = '||g_queue_name);
3761:
3762: dbms_aqadm.start_queue

Line 3762: dbms_aqadm.start_queue

3758: dbms_aqadm.start_queue
3759: (queue_name => g_queue_name);
3760: print_logfile(to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')||' - Queue Started = '||g_queue_name);
3761:
3762: dbms_aqadm.start_queue
3763: (queue_name => g_comp_queue_name);
3764: print_logfile(to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')||' - Queue Started = '||g_comp_queue_name);
3765:
3766: g_queue_started_flag := 'Y';

Line 4422: dbms_aqadm.stop_queue(queue_name => g_queue_name

4418: ,p_level => C_LEVEL_EVENT
4419: ,p_module => l_log_module);
4420: END IF;
4421:
4422: dbms_aqadm.stop_queue(queue_name => g_queue_name
4423: ,wait => TRUE); --5056507
4424: print_logfile(to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')||' - Queue stopped = '||g_queue_name);
4425: dbms_aqadm.stop_queue(queue_name => g_comp_queue_name
4426: ,wait => TRUE); --5056507

Line 4425: dbms_aqadm.stop_queue(queue_name => g_comp_queue_name

4421:
4422: dbms_aqadm.stop_queue(queue_name => g_queue_name
4423: ,wait => TRUE); --5056507
4424: print_logfile(to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')||' - Queue stopped = '||g_queue_name);
4425: dbms_aqadm.stop_queue(queue_name => g_comp_queue_name
4426: ,wait => TRUE); --5056507
4427: print_logfile(to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')||' - Queue stopped = '||g_comp_queue_name);
4428: p_queue_started_flag := 'N';
4429:

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

4442: ,p_level => C_LEVEL_EVENT
4443: ,p_module => l_log_module);
4444: END IF;
4445:
4446: dbms_aqadm.drop_queue(queue_name => g_queue_name);
4447: print_logfile(to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')||' - Queue dropped = '||g_queue_name);
4448: dbms_aqadm.drop_queue(queue_name => g_comp_queue_name);
4449: print_logfile(to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')||' - Queue dropped = '||g_comp_queue_name);
4450: p_queue_created_flag := 'N';

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

4444: END IF;
4445:
4446: dbms_aqadm.drop_queue(queue_name => g_queue_name);
4447: print_logfile(to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')||' - Queue dropped = '||g_queue_name);
4448: dbms_aqadm.drop_queue(queue_name => g_comp_queue_name);
4449: print_logfile(to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')||' - Queue dropped = '||g_comp_queue_name);
4450: p_queue_created_flag := 'N';
4451:
4452: IF (C_LEVEL_EVENT >= g_log_level) THEN