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.CSI_ORDER_FULFILL_PUB dependencies on OE_ORDER_PUB

Line 1266: x_line_tbl OUT NOCOPY oe_order_pub.line_tbl_type)

1262:
1263:
1264: PROCEDURE query_immediate_children (
1265: p_parent_line_id IN number,
1266: x_line_tbl OUT NOCOPY oe_order_pub.line_tbl_type)
1267: IS
1268:
1269: l_line_rec oe_order_pub.line_rec_type := oe_order_pub.g_miss_line_rec;
1270:

Line 1269: l_line_rec oe_order_pub.line_rec_type := oe_order_pub.g_miss_line_rec;

1265: p_parent_line_id IN number,
1266: x_line_tbl OUT NOCOPY oe_order_pub.line_tbl_type)
1267: IS
1268:
1269: l_line_rec oe_order_pub.line_rec_type := oe_order_pub.g_miss_line_rec;
1270:
1271: CURSOR op_cur is
1272: SELECT line_id
1273: FROM oe_order_lines_all

Line 1319: x_trackable_line_tbl OUT NOCOPY oe_order_pub.line_tbl_type,

1315:
1316: PROCEDURE get_ib_trackable_children(
1317: p_current_line_id IN number,
1318: p_om_vld_org_id IN number,
1319: x_trackable_line_tbl OUT NOCOPY oe_order_pub.line_tbl_type,
1320: x_return_status OUT NOCOPY varchar2)
1321: IS
1322:
1323: l_line_tbl oe_order_pub.line_tbl_type;

Line 1323: l_line_tbl oe_order_pub.line_tbl_type;

1319: x_trackable_line_tbl OUT NOCOPY oe_order_pub.line_tbl_type,
1320: x_return_status OUT NOCOPY varchar2)
1321: IS
1322:
1323: l_line_tbl oe_order_pub.line_tbl_type;
1324: l_line_tbl_nxt_lvl oe_order_pub.line_tbl_type;
1325: l_line_tbl_temp oe_order_pub.line_tbl_type;
1326: l_line_tbl_final oe_order_pub.line_tbl_type;
1327:

Line 1324: l_line_tbl_nxt_lvl oe_order_pub.line_tbl_type;

1320: x_return_status OUT NOCOPY varchar2)
1321: IS
1322:
1323: l_line_tbl oe_order_pub.line_tbl_type;
1324: l_line_tbl_nxt_lvl oe_order_pub.line_tbl_type;
1325: l_line_tbl_temp oe_order_pub.line_tbl_type;
1326: l_line_tbl_final oe_order_pub.line_tbl_type;
1327:
1328: l_config_line_rec oe_order_pub.line_rec_type := oe_order_pub.g_miss_line_rec;

Line 1325: l_line_tbl_temp oe_order_pub.line_tbl_type;

1321: IS
1322:
1323: l_line_tbl oe_order_pub.line_tbl_type;
1324: l_line_tbl_nxt_lvl oe_order_pub.line_tbl_type;
1325: l_line_tbl_temp oe_order_pub.line_tbl_type;
1326: l_line_tbl_final oe_order_pub.line_tbl_type;
1327:
1328: l_config_line_rec oe_order_pub.line_rec_type := oe_order_pub.g_miss_line_rec;
1329:

Line 1326: l_line_tbl_final oe_order_pub.line_tbl_type;

1322:
1323: l_line_tbl oe_order_pub.line_tbl_type;
1324: l_line_tbl_nxt_lvl oe_order_pub.line_tbl_type;
1325: l_line_tbl_temp oe_order_pub.line_tbl_type;
1326: l_line_tbl_final oe_order_pub.line_tbl_type;
1327:
1328: l_config_line_rec oe_order_pub.line_rec_type := oe_order_pub.g_miss_line_rec;
1329:
1330: l_nxt_ind binary_integer;

Line 1328: l_config_line_rec oe_order_pub.line_rec_type := oe_order_pub.g_miss_line_rec;

1324: l_line_tbl_nxt_lvl oe_order_pub.line_tbl_type;
1325: l_line_tbl_temp oe_order_pub.line_tbl_type;
1326: l_line_tbl_final oe_order_pub.line_tbl_type;
1327:
1328: l_config_line_rec oe_order_pub.line_rec_type := oe_order_pub.g_miss_line_rec;
1329:
1330: l_nxt_ind binary_integer;
1331: l_final_ind binary_integer;
1332:

Line 1439: x_trackable_line_tbl OUT NOCOPY oe_order_pub.line_tbl_type,

1435:
1436: PROCEDURE get_all_ib_trackable_children(
1437: p_model_line_id IN number,
1438: p_om_vld_org_id IN number,
1439: x_trackable_line_tbl OUT NOCOPY oe_order_pub.line_tbl_type,
1440: x_return_status OUT NOCOPY varchar2)
1441: IS
1442:
1443: l_line_tbl oe_order_pub.line_tbl_type;

Line 1443: l_line_tbl oe_order_pub.line_tbl_type;

1439: x_trackable_line_tbl OUT NOCOPY oe_order_pub.line_tbl_type,
1440: x_return_status OUT NOCOPY varchar2)
1441: IS
1442:
1443: l_line_tbl oe_order_pub.line_tbl_type;
1444: l_line_tbl_nxt_lvl oe_order_pub.line_tbl_type;
1445: l_line_tbl_temp oe_order_pub.line_tbl_type;
1446: l_line_tbl_final oe_order_pub.line_tbl_type;
1447:

Line 1444: l_line_tbl_nxt_lvl oe_order_pub.line_tbl_type;

1440: x_return_status OUT NOCOPY varchar2)
1441: IS
1442:
1443: l_line_tbl oe_order_pub.line_tbl_type;
1444: l_line_tbl_nxt_lvl oe_order_pub.line_tbl_type;
1445: l_line_tbl_temp oe_order_pub.line_tbl_type;
1446: l_line_tbl_final oe_order_pub.line_tbl_type;
1447:
1448: l_nxt_ind binary_integer;

Line 1445: l_line_tbl_temp oe_order_pub.line_tbl_type;

1441: IS
1442:
1443: l_line_tbl oe_order_pub.line_tbl_type;
1444: l_line_tbl_nxt_lvl oe_order_pub.line_tbl_type;
1445: l_line_tbl_temp oe_order_pub.line_tbl_type;
1446: l_line_tbl_final oe_order_pub.line_tbl_type;
1447:
1448: l_nxt_ind binary_integer;
1449: l_final_ind binary_integer;

Line 1446: l_line_tbl_final oe_order_pub.line_tbl_type;

1442:
1443: l_line_tbl oe_order_pub.line_tbl_type;
1444: l_line_tbl_nxt_lvl oe_order_pub.line_tbl_type;
1445: l_line_tbl_temp oe_order_pub.line_tbl_type;
1446: l_line_tbl_final oe_order_pub.line_tbl_type;
1447:
1448: l_nxt_ind binary_integer;
1449: l_final_ind binary_integer;
1450:

Line 1928: x_parent_line_rec OUT NOCOPY oe_order_pub.line_rec_type,

1924:
1925: PROCEDURE get_ib_trackable_parent(
1926: p_current_line_id IN number,
1927: p_om_vld_org_id IN number,
1928: x_parent_line_rec OUT NOCOPY oe_order_pub.line_rec_type,
1929: x_return_status OUT NOCOPY varchar2)
1930: IS
1931: l_org_id number;
1932: l_parent_line_id number;

Line 1937: l_parent_line_rec oe_order_pub.line_rec_type;

1933: l_next_parent_line_id number;
1934: l_inventory_item_id number;
1935: l_ib_trackable_flag varchar2(1) := 'N';
1936:
1937: l_parent_line_rec oe_order_pub.line_rec_type;
1938:
1939: BEGIN
1940:
1941: x_return_status := fnd_api.g_ret_sts_success;

Line 2194: px_line_tbl IN OUT nocopy oe_order_pub.line_tbl_type,

2190: x_return_status := fnd_api.g_ret_sts_error;
2191: END get_tld;
2192:
2193: PROCEDURE get_ato_options_only(
2194: px_line_tbl IN OUT nocopy oe_order_pub.line_tbl_type,
2195: x_return_status OUT nocopy varchar2)
2196: IS
2197: o_line_tbl oe_order_pub.line_tbl_type;
2198: o_ind binary_integer := 0;

Line 2197: o_line_tbl oe_order_pub.line_tbl_type;

2193: PROCEDURE get_ato_options_only(
2194: px_line_tbl IN OUT nocopy oe_order_pub.line_tbl_type,
2195: x_return_status OUT nocopy varchar2)
2196: IS
2197: o_line_tbl oe_order_pub.line_tbl_type;
2198: o_ind binary_integer := 0;
2199: BEGIN
2200: x_return_status := fnd_api.g_ret_sts_success;
2201: api_log('get_ato_options_only');

Line 3033: p_parent_line_rec IN oe_order_pub.line_rec_type,

3029: END get_wip_instances;
3030:
3031: PROCEDURE get_wip_instances_for_line(
3032: p_option_line_rec IN oe_order_lines_all%rowtype,
3033: p_parent_line_rec IN oe_order_pub.line_rec_type,
3034: p_option_serial_code IN number,
3035: p_class_option_ratio IN number,
3036: p_config_rec IN config_rec,
3037: p_config_instances IN config_serial_inst_tbl,

Line 3452: p_parent_line_rec IN oe_order_pub.line_rec_type,

3448: -- enhancements to be made in the genealogy area in this routine
3449: PROCEDURE distribute_wip_instances(
3450: p_qty_ratio IN number,
3451: p_option_serial_code IN number,
3452: p_parent_line_rec IN oe_order_pub.line_rec_type,
3453: p_parent_instances IN parent_instances,
3454: p_wip_instances IN wip_instances,
3455: px_default_info_rec IN OUT nocopy default_info_rec,
3456: x_ii_rltns_tbl OUT nocopy csi_datastructures_pub.ii_relationship_tbl,

Line 4884: p_option_line_rec IN oe_order_pub.line_rec_type,

4880: x_return_status := fnd_api.g_ret_sts_error;
4881: END mark_and_get_srl_option;
4882:
4883: PROCEDURE filter_option_instances(
4884: p_option_line_rec IN oe_order_pub.line_rec_type,
4885: p_option_serial_code IN number,
4886: p_config_rec IN config_rec,
4887: p_transaction_line_id IN number,
4888: px_ii_rltns_tbl IN OUT nocopy csi_datastructures_pub.ii_relationship_tbl,

Line 5051: l_child_line_tbl oe_order_pub.line_tbl_type;

5047: l_config_instance config_serial_inst_rec;
5048:
5049: l_sub_config_instances config_serial_inst_tbl;
5050: l_sub_config_instance config_serial_inst_rec;
5051: l_child_line_tbl oe_order_pub.line_tbl_type;
5052: l_parent_line_rec oe_order_pub.line_rec_type;
5053:
5054: l_config_ns_tld_id number;
5055: l_sub_config_ns_tld_id number;

Line 5052: l_parent_line_rec oe_order_pub.line_rec_type;

5048:
5049: l_sub_config_instances config_serial_inst_tbl;
5050: l_sub_config_instance config_serial_inst_rec;
5051: l_child_line_tbl oe_order_pub.line_tbl_type;
5052: l_parent_line_rec oe_order_pub.line_rec_type;
5053:
5054: l_config_ns_tld_id number;
5055: l_sub_config_ns_tld_id number;
5056:

Line 5729: l_parent_line_rec oe_order_pub.line_rec_type := oe_order_pub.g_miss_line_rec;

5725:
5726: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5727: l_t_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5728:
5729: l_parent_line_rec oe_order_pub.line_rec_type := oe_order_pub.g_miss_line_rec;
5730: l_child_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;
5731: l_ns_tld_id number;
5732:
5733: l_qty_ratio number;

Line 6116: l_child_line_tbl oe_order_pub.line_tbl_type;

6112:
6113:
6114: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6115:
6116: l_child_line_tbl oe_order_pub.line_tbl_type;
6117: l_grand_child_line_tbl oe_order_pub.line_tbl_type;
6118: l_qty_ratio number;
6119:
6120: l_model_order_qty number;

Line 6117: l_grand_child_line_tbl oe_order_pub.line_tbl_type;

6113:
6114: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6115:
6116: l_child_line_tbl oe_order_pub.line_tbl_type;
6117: l_grand_child_line_tbl oe_order_pub.line_tbl_type;
6118: l_qty_ratio number;
6119:
6120: l_model_order_qty number;
6121:

Line 6135: l_temp_child_line_rec oe_order_pub.Line_Rec_Type;

6131: l_msg_count number;
6132:
6133: --fix for bug5096435
6134: l_order_line_qty number;
6135: l_temp_child_line_rec oe_order_pub.Line_Rec_Type;
6136: l_next_item_id number := 0;
6137: l_temp_idx number := 0;
6138: l_temp_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
6139: l_temp_index number := 0;

Line 6390: l_parent_line_rec oe_order_pub.line_rec_type;

6386: IS
6387:
6388: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
6389:
6390: l_parent_line_rec oe_order_pub.line_rec_type;
6391: l_option_serial_code number;
6392:
6393: l_wip_instances wip_instances;
6394: l_parent_instances parent_instances;

Line 6771: l_parent_line_rec oe_order_pub.line_rec_type;

6767: IS
6768:
6769: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
6770:
6771: l_parent_line_rec oe_order_pub.line_rec_type;
6772: l_option_serial_code number;
6773:
6774: l_wip_instances wip_instances;
6775: l_parent_instances parent_instances;

Line 8151: l_trk_child_tbl oe_order_pub.line_tbl_type;

8147: l_config_reship_count number := 0;
8148:
8149: l_option_instances csi_datastructures_pub.instance_tbl;
8150:
8151: l_trk_child_tbl oe_order_pub.line_tbl_type;
8152: l_trk_parent_rec oe_order_pub.line_rec_type;
8153:
8154: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
8155: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;

Line 8152: l_trk_parent_rec oe_order_pub.line_rec_type;

8148:
8149: l_option_instances csi_datastructures_pub.instance_tbl;
8150:
8151: l_trk_child_tbl oe_order_pub.line_tbl_type;
8152: l_trk_parent_rec oe_order_pub.line_rec_type;
8153:
8154: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
8155: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
8156: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;

Line 10674: l_header_rec OE_Order_PUB.Header_Rec_Type;

10670: l_dequeue_mode VARCHAR2(240) DEFAULT DBMS_AQ.REMOVE;
10671: l_navigation VARCHAR2(240) DEFAULT DBMS_AQ.NEXT_MESSAGE;
10672: l_wait NUMBER DEFAULT DBMS_AQ.NO_WAIT;
10673: l_no_more_messages VARCHAR2(240);
10674: l_header_rec OE_Order_PUB.Header_Rec_Type;
10675: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
10676: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
10677: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
10678: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

Line 10675: l_old_header_rec OE_Order_PUB.Header_Rec_Type;

10671: l_navigation VARCHAR2(240) DEFAULT DBMS_AQ.NEXT_MESSAGE;
10672: l_wait NUMBER DEFAULT DBMS_AQ.NO_WAIT;
10673: l_no_more_messages VARCHAR2(240);
10674: l_header_rec OE_Order_PUB.Header_Rec_Type;
10675: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
10676: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
10677: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
10678: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
10679: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

Line 10676: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

10672: l_wait NUMBER DEFAULT DBMS_AQ.NO_WAIT;
10673: l_no_more_messages VARCHAR2(240);
10674: l_header_rec OE_Order_PUB.Header_Rec_Type;
10675: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
10676: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
10677: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
10678: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
10679: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
10680: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

Line 10677: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

10673: l_no_more_messages VARCHAR2(240);
10674: l_header_rec OE_Order_PUB.Header_Rec_Type;
10675: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
10676: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
10677: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
10678: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
10679: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
10680: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
10681: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

Line 10678: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

10674: l_header_rec OE_Order_PUB.Header_Rec_Type;
10675: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
10676: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
10677: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
10678: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
10679: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
10680: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
10681: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
10682: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

Line 10679: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

10675: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
10676: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
10677: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
10678: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
10679: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
10680: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
10681: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
10682: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
10683: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

Line 10680: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

10676: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
10677: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
10678: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
10679: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
10680: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
10681: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
10682: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
10683: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
10684: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 10681: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

10677: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
10678: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
10679: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
10680: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
10681: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
10682: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
10683: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
10684: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
10685: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 10682: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

10678: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
10679: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
10680: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
10681: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
10682: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
10683: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
10684: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
10685: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
10686: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 10683: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

10679: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
10680: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
10681: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
10682: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
10683: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
10684: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
10685: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
10686: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
10687: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 10684: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

10680: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
10681: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
10682: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
10683: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
10684: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
10685: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
10686: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
10687: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
10688: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 10685: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

10681: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
10682: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
10683: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
10684: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
10685: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
10686: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
10687: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
10688: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
10689: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 10686: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

10682: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
10683: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
10684: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
10685: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
10686: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
10687: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
10688: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
10689: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
10690: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

Line 10687: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

10683: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
10684: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
10685: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
10686: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
10687: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
10688: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
10689: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
10690: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
10691: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

Line 10688: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

10684: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
10685: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
10686: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
10687: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
10688: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
10689: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
10690: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
10691: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
10692: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

Line 10689: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

10685: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
10686: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
10687: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
10688: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
10689: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
10690: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
10691: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
10692: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
10693: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

Line 10690: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

10686: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
10687: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
10688: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
10689: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
10690: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
10691: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
10692: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
10693: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
10694: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 10691: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

10687: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
10688: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
10689: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
10690: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
10691: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
10692: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
10693: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
10694: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
10695: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 10692: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

10688: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
10689: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
10690: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
10691: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
10692: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
10693: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
10694: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
10695: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
10696: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 10693: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

10689: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
10690: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
10691: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
10692: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
10693: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
10694: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
10695: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
10696: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
10697: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 10694: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

10690: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
10691: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
10692: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
10693: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
10694: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
10695: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
10696: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
10697: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
10698: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 10695: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

10691: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
10692: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
10693: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
10694: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
10695: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
10696: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
10697: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
10698: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
10699: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 10696: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

10692: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
10693: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
10694: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
10695: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
10696: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
10697: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
10698: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
10699: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
10700: l_action_request_tbl OE_Order_PUB.request_tbl_type;

Line 10697: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

10693: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
10694: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
10695: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
10696: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
10697: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
10698: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
10699: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
10700: l_action_request_tbl OE_Order_PUB.request_tbl_type;
10701: --

Line 10698: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

10694: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
10695: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
10696: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
10697: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
10698: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
10699: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
10700: l_action_request_tbl OE_Order_PUB.request_tbl_type;
10701: --
10702: l_exp_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 10699: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

10695: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
10696: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
10697: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
10698: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
10699: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
10700: l_action_request_tbl OE_Order_PUB.request_tbl_type;
10701: --
10702: l_exp_line_tbl OE_Order_PUB.Line_Tbl_Type;
10703: l_exp_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 10700: l_action_request_tbl OE_Order_PUB.request_tbl_type;

10696: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
10697: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
10698: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
10699: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
10700: l_action_request_tbl OE_Order_PUB.request_tbl_type;
10701: --
10702: l_exp_line_tbl OE_Order_PUB.Line_Tbl_Type;
10703: l_exp_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
10704: l_exp_count NUMBER;

Line 10702: l_exp_line_tbl OE_Order_PUB.Line_Tbl_Type;

10698: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
10699: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
10700: l_action_request_tbl OE_Order_PUB.request_tbl_type;
10701: --
10702: l_exp_line_tbl OE_Order_PUB.Line_Tbl_Type;
10703: l_exp_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
10704: l_exp_count NUMBER;
10705: l_exp_flag VARCHAR2(1);
10706: l_line_count NUMBER;

Line 10703: l_exp_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

10699: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
10700: l_action_request_tbl OE_Order_PUB.request_tbl_type;
10701: --
10702: l_exp_line_tbl OE_Order_PUB.Line_Tbl_Type;
10703: l_exp_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
10704: l_exp_count NUMBER;
10705: l_exp_flag VARCHAR2(1);
10706: l_line_count NUMBER;
10707: l_multi_org_flag VARCHAR2(1);