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 4440: l_wait NUMBER DEFAULT DBMS_AQ.no_wait;

4436: l_commit VARCHAR2 (1) DEFAULT fnd_api.g_false;
4437: l_return_status VARCHAR2 (1);
4438: l_msg_count NUMBER;
4439: l_msg_data VARCHAR2 (2000);
4440: l_wait NUMBER DEFAULT DBMS_AQ.no_wait;
4441: l_no_more_messages VARCHAR2 (240);
4442: l_header_rec oe_order_pub.header_rec_type;
4443: l_old_header_rec oe_order_pub.header_rec_type;
4444: l_header_adj_tbl oe_order_pub.header_adj_tbl_type;

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

4466: l_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
4467: l_old_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
4468: l_action_request_tbl oe_order_pub.request_tbl_type;
4469: l_oe_line_rec oe_order_pub.line_rec_type;
4470: l_dequeue_mode VARCHAR2 (240) DEFAULT DBMS_AQ.remove;
4471: l_navigation VARCHAR2 (240)
4472: DEFAULT DBMS_AQ.next_message;
4473: l_repv_rec oks_rep_pvt.repv_rec_type;
4474: l_out_repv_rec oks_rep_pvt.repv_rec_type;

Line 4472: DEFAULT DBMS_AQ.next_message;

4468: l_action_request_tbl oe_order_pub.request_tbl_type;
4469: l_oe_line_rec oe_order_pub.line_rec_type;
4470: l_dequeue_mode VARCHAR2 (240) DEFAULT DBMS_AQ.remove;
4471: l_navigation VARCHAR2 (240)
4472: DEFAULT DBMS_AQ.next_message;
4473: l_repv_rec oks_rep_pvt.repv_rec_type;
4474: l_out_repv_rec oks_rep_pvt.repv_rec_type;
4475: l_request_id NUMBER;
4476: --General Variables