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.

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 4442: l_header_rec oe_order_pub.header_rec_type;

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

Line 4443: l_old_header_rec oe_order_pub.header_rec_type;

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;
4445: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
4446: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
4447: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;

Line 4444: l_header_adj_tbl oe_order_pub.header_adj_tbl_type;

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;
4445: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
4446: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
4447: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
4448: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;

Line 4445: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;

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;
4445: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
4446: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
4447: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
4448: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
4449: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;

Line 4446: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;

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;
4445: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
4446: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
4447: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
4448: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
4449: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
4450: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;

Line 4447: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;

4443: l_old_header_rec oe_order_pub.header_rec_type;
4444: l_header_adj_tbl oe_order_pub.header_adj_tbl_type;
4445: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
4446: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
4447: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
4448: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
4449: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
4450: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
4451: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;

Line 4448: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;

4444: l_header_adj_tbl oe_order_pub.header_adj_tbl_type;
4445: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
4446: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
4447: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
4448: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
4449: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
4450: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
4451: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
4452: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;

Line 4449: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;

4445: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
4446: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
4447: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
4448: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
4449: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
4450: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
4451: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
4452: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
4453: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;

Line 4450: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;

4446: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
4447: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
4448: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
4449: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
4450: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
4451: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
4452: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
4453: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
4454: l_line_tbl oe_order_pub.line_tbl_type;

Line 4451: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;

4447: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
4448: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
4449: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
4450: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
4451: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
4452: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
4453: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
4454: l_line_tbl oe_order_pub.line_tbl_type;
4455: l_old_line_tbl oe_order_pub.line_tbl_type;

Line 4452: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;

4448: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
4449: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
4450: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
4451: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
4452: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
4453: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
4454: l_line_tbl oe_order_pub.line_tbl_type;
4455: l_old_line_tbl oe_order_pub.line_tbl_type;
4456: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;

Line 4453: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;

4449: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
4450: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
4451: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
4452: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
4453: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
4454: l_line_tbl oe_order_pub.line_tbl_type;
4455: l_old_line_tbl oe_order_pub.line_tbl_type;
4456: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
4457: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;

Line 4454: l_line_tbl oe_order_pub.line_tbl_type;

4450: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
4451: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
4452: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
4453: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
4454: l_line_tbl oe_order_pub.line_tbl_type;
4455: l_old_line_tbl oe_order_pub.line_tbl_type;
4456: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
4457: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
4458: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;

Line 4455: l_old_line_tbl oe_order_pub.line_tbl_type;

4451: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
4452: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
4453: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
4454: l_line_tbl oe_order_pub.line_tbl_type;
4455: l_old_line_tbl oe_order_pub.line_tbl_type;
4456: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
4457: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
4458: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
4459: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;

Line 4456: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;

4452: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
4453: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
4454: l_line_tbl oe_order_pub.line_tbl_type;
4455: l_old_line_tbl oe_order_pub.line_tbl_type;
4456: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
4457: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
4458: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
4459: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
4460: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;

Line 4457: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;

4453: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
4454: l_line_tbl oe_order_pub.line_tbl_type;
4455: l_old_line_tbl oe_order_pub.line_tbl_type;
4456: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
4457: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
4458: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
4459: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
4460: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
4461: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;

Line 4458: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;

4454: l_line_tbl oe_order_pub.line_tbl_type;
4455: l_old_line_tbl oe_order_pub.line_tbl_type;
4456: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
4457: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
4458: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
4459: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
4460: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
4461: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
4462: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;

Line 4459: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;

4455: l_old_line_tbl oe_order_pub.line_tbl_type;
4456: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
4457: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
4458: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
4459: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
4460: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
4461: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
4462: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
4463: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;

Line 4460: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;

4456: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
4457: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
4458: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
4459: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
4460: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
4461: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
4462: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
4463: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
4464: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;

Line 4461: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;

4457: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
4458: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
4459: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
4460: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
4461: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
4462: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
4463: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
4464: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
4465: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;

Line 4462: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;

4458: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
4459: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
4460: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
4461: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
4462: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
4463: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
4464: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
4465: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
4466: l_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;

Line 4463: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;

4459: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
4460: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
4461: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
4462: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
4463: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
4464: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
4465: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
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;

Line 4464: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;

4460: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
4461: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
4462: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
4463: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
4464: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
4465: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
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;

Line 4465: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;

4461: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
4462: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
4463: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
4464: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
4465: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
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;

Line 4466: l_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;

4462: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
4463: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
4464: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
4465: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
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;

Line 4467: l_old_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;

4463: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
4464: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
4465: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
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)

Line 4468: l_action_request_tbl oe_order_pub.request_tbl_type;

4464: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
4465: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
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;

Line 4469: l_oe_line_rec oe_order_pub.line_rec_type;

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