APPS.OKS_OCINT_PUB dependencies on DBMS_AQ

Line 92: l_wait NUMBER DEFAULT DBMS_AQ.no_wait;

88: l_commit VARCHAR2 (1) DEFAULT fnd_api.g_false;
89: l_return_status VARCHAR2 (1);
90: l_msg_count NUMBER;
91: l_msg_data VARCHAR2 (2000);
92: l_wait NUMBER DEFAULT DBMS_AQ.no_wait;
93: l_no_more_messages VARCHAR2 (240);
94: l_header_rec oe_order_pub.header_rec_type;
95: l_old_header_rec oe_order_pub.header_rec_type;
96: l_header_adj_tbl oe_order_pub.header_adj_tbl_type;

Line 122: l_dequeue_mode VARCHAR2 (240) DEFAULT DBMS_AQ.remove;

118: l_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
119: l_old_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
120: l_action_request_tbl oe_order_pub.request_tbl_type;
121: l_oe_line_rec oe_order_pub.line_rec_type;
122: l_dequeue_mode VARCHAR2 (240) DEFAULT DBMS_AQ.remove;
123: l_navigation VARCHAR2 (240)
124: DEFAULT DBMS_AQ.next_message;
125: l_repv_rec oks_rep_pvt.repv_rec_type;
126: l_out_repv_rec oks_rep_pvt.repv_rec_type;

Line 124: DEFAULT DBMS_AQ.next_message;

120: l_action_request_tbl oe_order_pub.request_tbl_type;
121: l_oe_line_rec oe_order_pub.line_rec_type;
122: l_dequeue_mode VARCHAR2 (240) DEFAULT DBMS_AQ.remove;
123: l_navigation VARCHAR2 (240)
124: DEFAULT DBMS_AQ.next_message;
125: l_repv_rec oks_rep_pvt.repv_rec_type;
126: l_out_repv_rec oks_rep_pvt.repv_rec_type;
127: l_request_id NUMBER;
128: --General Variables

Line 638: l_wait NUMBER DEFAULT DBMS_AQ.no_wait;

634: l_commit VARCHAR2 (1) DEFAULT fnd_api.g_false;
635: l_return_status VARCHAR2 (1);
636: l_msg_count NUMBER;
637: l_msg_data VARCHAR2 (2000);
638: l_wait NUMBER DEFAULT DBMS_AQ.no_wait;
639: l_dequeue_mode VARCHAR2 (240) DEFAULT DBMS_AQ.remove;
640: l_navigation VARCHAR2 (240) DEFAULT DBMS_AQ.next_message;
641: --General Variables
642: l_ctr NUMBER;

Line 639: l_dequeue_mode VARCHAR2 (240) DEFAULT DBMS_AQ.remove;

635: l_return_status VARCHAR2 (1);
636: l_msg_count NUMBER;
637: l_msg_data VARCHAR2 (2000);
638: l_wait NUMBER DEFAULT DBMS_AQ.no_wait;
639: l_dequeue_mode VARCHAR2 (240) DEFAULT DBMS_AQ.remove;
640: l_navigation VARCHAR2 (240) DEFAULT DBMS_AQ.next_message;
641: --General Variables
642: l_ctr NUMBER;
643: l_line_count NUMBER;

Line 640: l_navigation VARCHAR2 (240) DEFAULT DBMS_AQ.next_message;

636: l_msg_count NUMBER;
637: l_msg_data VARCHAR2 (2000);
638: l_wait NUMBER DEFAULT DBMS_AQ.no_wait;
639: l_dequeue_mode VARCHAR2 (240) DEFAULT DBMS_AQ.remove;
640: l_navigation VARCHAR2 (240) DEFAULT DBMS_AQ.next_message;
641: --General Variables
642: l_ctr NUMBER;
643: l_line_count NUMBER;
644: l_user_id NUMBER;

Line 3796: l_wait NUMBER DEFAULT DBMS_AQ.no_wait;

3792: l_commit VARCHAR2 (1) DEFAULT fnd_api.g_false;
3793: l_return_status VARCHAR2 (1);
3794: l_msg_count NUMBER;
3795: l_msg_data VARCHAR2 (2000);
3796: l_wait NUMBER DEFAULT DBMS_AQ.no_wait;
3797: l_no_more_messages VARCHAR2 (240);
3798: l_header_rec oe_order_pub.header_rec_type;
3799: l_old_header_rec oe_order_pub.header_rec_type;
3800: l_header_adj_tbl oe_order_pub.header_adj_tbl_type;

Line 3826: l_dequeue_mode VARCHAR2 (240) DEFAULT DBMS_AQ.remove;

3822: l_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
3823: l_old_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
3824: l_action_request_tbl oe_order_pub.request_tbl_type;
3825: l_oe_line_rec oe_order_pub.line_rec_type;
3826: l_dequeue_mode VARCHAR2 (240) DEFAULT DBMS_AQ.remove;
3827: l_navigation VARCHAR2 (240)
3828: DEFAULT DBMS_AQ.next_message;
3829: l_repv_rec oks_rep_pvt.repv_rec_type;
3830: l_out_repv_rec oks_rep_pvt.repv_rec_type;

Line 3828: DEFAULT DBMS_AQ.next_message;

3824: l_action_request_tbl oe_order_pub.request_tbl_type;
3825: l_oe_line_rec oe_order_pub.line_rec_type;
3826: l_dequeue_mode VARCHAR2 (240) DEFAULT DBMS_AQ.remove;
3827: l_navigation VARCHAR2 (240)
3828: DEFAULT DBMS_AQ.next_message;
3829: l_repv_rec oks_rep_pvt.repv_rec_type;
3830: l_out_repv_rec oks_rep_pvt.repv_rec_type;
3831: l_request_id NUMBER;
3832: --General Variables