eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.OKS_OCINT_PUB dependencies on OE_ORDER_PUB

Line 94: l_header_rec oe_order_pub.header_rec_type;

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;
97: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
98: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;

Line 95: l_old_header_rec oe_order_pub.header_rec_type;

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;
97: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
98: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
99: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;

Line 96: l_header_adj_tbl oe_order_pub.header_adj_tbl_type;

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;
97: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
98: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
99: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
100: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;

Line 97: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;

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;
97: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
98: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
99: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
100: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
101: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;

Line 98: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;

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;
97: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
98: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
99: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
100: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
101: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
102: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;

Line 99: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;

95: l_old_header_rec oe_order_pub.header_rec_type;
96: l_header_adj_tbl oe_order_pub.header_adj_tbl_type;
97: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
98: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
99: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
100: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
101: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
102: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
103: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;

Line 100: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;

96: l_header_adj_tbl oe_order_pub.header_adj_tbl_type;
97: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
98: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
99: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
100: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
101: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
102: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
103: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
104: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;

Line 101: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;

97: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
98: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
99: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
100: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
101: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
102: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
103: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
104: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
105: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;

Line 102: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;

98: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
99: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
100: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
101: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
102: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
103: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
104: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
105: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
106: l_line_tbl oe_order_pub.line_tbl_type;

Line 103: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;

99: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
100: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
101: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
102: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
103: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
104: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
105: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
106: l_line_tbl oe_order_pub.line_tbl_type;
107: l_old_line_tbl oe_order_pub.line_tbl_type;

Line 104: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;

100: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
101: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
102: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
103: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
104: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
105: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
106: l_line_tbl oe_order_pub.line_tbl_type;
107: l_old_line_tbl oe_order_pub.line_tbl_type;
108: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;

Line 105: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;

101: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
102: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
103: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
104: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
105: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
106: l_line_tbl oe_order_pub.line_tbl_type;
107: l_old_line_tbl oe_order_pub.line_tbl_type;
108: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
109: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;

Line 106: l_line_tbl oe_order_pub.line_tbl_type;

102: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
103: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
104: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
105: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
106: l_line_tbl oe_order_pub.line_tbl_type;
107: l_old_line_tbl oe_order_pub.line_tbl_type;
108: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
109: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
110: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;

Line 107: l_old_line_tbl oe_order_pub.line_tbl_type;

103: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
104: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
105: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
106: l_line_tbl oe_order_pub.line_tbl_type;
107: l_old_line_tbl oe_order_pub.line_tbl_type;
108: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
109: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
110: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
111: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;

Line 108: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;

104: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
105: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
106: l_line_tbl oe_order_pub.line_tbl_type;
107: l_old_line_tbl oe_order_pub.line_tbl_type;
108: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
109: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
110: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
111: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
112: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;

Line 109: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;

105: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
106: l_line_tbl oe_order_pub.line_tbl_type;
107: l_old_line_tbl oe_order_pub.line_tbl_type;
108: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
109: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
110: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
111: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
112: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
113: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;

Line 110: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;

106: l_line_tbl oe_order_pub.line_tbl_type;
107: l_old_line_tbl oe_order_pub.line_tbl_type;
108: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
109: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
110: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
111: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
112: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
113: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
114: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;

Line 111: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;

107: l_old_line_tbl oe_order_pub.line_tbl_type;
108: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
109: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
110: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
111: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
112: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
113: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
114: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
115: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;

Line 112: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;

108: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
109: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
110: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
111: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
112: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
113: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
114: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
115: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
116: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;

Line 113: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;

109: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
110: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
111: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
112: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
113: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
114: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
115: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
116: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
117: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;

Line 114: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;

110: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
111: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
112: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
113: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
114: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
115: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
116: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
117: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
118: l_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;

Line 115: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;

111: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
112: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
113: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
114: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
115: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
116: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
117: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
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;

Line 116: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;

112: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
113: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
114: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
115: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
116: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
117: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
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;

Line 117: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;

113: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
114: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
115: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
116: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
117: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
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;

Line 118: l_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;

114: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
115: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
116: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
117: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
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;

Line 119: l_old_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;

115: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
116: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
117: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
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)

Line 120: l_action_request_tbl oe_order_pub.request_tbl_type;

116: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
117: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
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;

Line 121: l_oe_line_rec oe_order_pub.line_rec_type;

117: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
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;

Line 3798: l_header_rec oe_order_pub.header_rec_type;

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;
3801: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
3802: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;

Line 3799: l_old_header_rec oe_order_pub.header_rec_type;

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;
3801: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
3802: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
3803: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;

Line 3800: l_header_adj_tbl oe_order_pub.header_adj_tbl_type;

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;
3801: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
3802: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
3803: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
3804: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;

Line 3801: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;

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;
3801: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
3802: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
3803: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
3804: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
3805: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;

Line 3802: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;

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;
3801: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
3802: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
3803: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
3804: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
3805: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
3806: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;

Line 3803: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;

3799: l_old_header_rec oe_order_pub.header_rec_type;
3800: l_header_adj_tbl oe_order_pub.header_adj_tbl_type;
3801: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
3802: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
3803: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
3804: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
3805: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
3806: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
3807: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;

Line 3804: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;

3800: l_header_adj_tbl oe_order_pub.header_adj_tbl_type;
3801: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
3802: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
3803: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
3804: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
3805: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
3806: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
3807: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
3808: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;

Line 3805: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;

3801: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
3802: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
3803: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
3804: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
3805: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
3806: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
3807: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
3808: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
3809: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;

Line 3806: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;

3802: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
3803: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
3804: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
3805: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
3806: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
3807: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
3808: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
3809: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
3810: l_line_tbl oe_order_pub.line_tbl_type;

Line 3807: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;

3803: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
3804: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
3805: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
3806: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
3807: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
3808: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
3809: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
3810: l_line_tbl oe_order_pub.line_tbl_type;
3811: l_old_line_tbl oe_order_pub.line_tbl_type;

Line 3808: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;

3804: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
3805: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
3806: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
3807: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
3808: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
3809: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
3810: l_line_tbl oe_order_pub.line_tbl_type;
3811: l_old_line_tbl oe_order_pub.line_tbl_type;
3812: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;

Line 3809: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;

3805: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
3806: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
3807: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
3808: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
3809: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
3810: l_line_tbl oe_order_pub.line_tbl_type;
3811: l_old_line_tbl oe_order_pub.line_tbl_type;
3812: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
3813: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;

Line 3810: l_line_tbl oe_order_pub.line_tbl_type;

3806: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
3807: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
3808: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
3809: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
3810: l_line_tbl oe_order_pub.line_tbl_type;
3811: l_old_line_tbl oe_order_pub.line_tbl_type;
3812: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
3813: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
3814: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;

Line 3811: l_old_line_tbl oe_order_pub.line_tbl_type;

3807: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
3808: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
3809: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
3810: l_line_tbl oe_order_pub.line_tbl_type;
3811: l_old_line_tbl oe_order_pub.line_tbl_type;
3812: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
3813: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
3814: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
3815: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;

Line 3812: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;

3808: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
3809: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
3810: l_line_tbl oe_order_pub.line_tbl_type;
3811: l_old_line_tbl oe_order_pub.line_tbl_type;
3812: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
3813: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
3814: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
3815: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
3816: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;

Line 3813: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;

3809: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
3810: l_line_tbl oe_order_pub.line_tbl_type;
3811: l_old_line_tbl oe_order_pub.line_tbl_type;
3812: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
3813: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
3814: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
3815: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
3816: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
3817: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;

Line 3814: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;

3810: l_line_tbl oe_order_pub.line_tbl_type;
3811: l_old_line_tbl oe_order_pub.line_tbl_type;
3812: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
3813: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
3814: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
3815: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
3816: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
3817: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
3818: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;

Line 3815: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;

3811: l_old_line_tbl oe_order_pub.line_tbl_type;
3812: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
3813: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
3814: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
3815: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
3816: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
3817: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
3818: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
3819: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;

Line 3816: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;

3812: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
3813: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
3814: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
3815: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
3816: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
3817: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
3818: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
3819: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
3820: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;

Line 3817: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;

3813: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
3814: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
3815: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
3816: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
3817: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
3818: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
3819: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
3820: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
3821: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;

Line 3818: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;

3814: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
3815: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
3816: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
3817: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
3818: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
3819: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
3820: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
3821: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
3822: l_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;

Line 3819: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;

3815: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
3816: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
3817: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
3818: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
3819: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
3820: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
3821: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
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;

Line 3820: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;

3816: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
3817: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
3818: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
3819: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
3820: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
3821: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
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;

Line 3821: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;

3817: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
3818: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
3819: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
3820: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
3821: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
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;

Line 3822: l_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;

3818: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
3819: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
3820: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
3821: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
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;

Line 3823: l_old_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;

3819: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
3820: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
3821: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
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)

Line 3824: l_action_request_tbl oe_order_pub.request_tbl_type;

3820: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
3821: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
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;

Line 3825: l_oe_line_rec oe_order_pub.line_rec_type;

3821: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
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;