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 1306: x_line_tbl OUT NOCOPY oe_order_pub.line_tbl_type)

1302:
1303:
1304: PROCEDURE query_immediate_children (
1305: p_parent_line_id IN number,
1306: x_line_tbl OUT NOCOPY oe_order_pub.line_tbl_type)
1307: IS
1308:
1309: l_line_rec oe_order_pub.line_rec_type := oe_order_pub.g_miss_line_rec;
1310:

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

1305: p_parent_line_id IN number,
1306: x_line_tbl OUT NOCOPY oe_order_pub.line_tbl_type)
1307: IS
1308:
1309: l_line_rec oe_order_pub.line_rec_type := oe_order_pub.g_miss_line_rec;
1310:
1311: CURSOR op_cur is
1312: SELECT line_id
1313: FROM oe_order_lines_all

Line 1359: x_trackable_line_tbl OUT NOCOPY oe_order_pub.line_tbl_type,

1355:
1356: PROCEDURE get_ib_trackable_children(
1357: p_current_line_id IN number,
1358: p_om_vld_org_id IN number,
1359: x_trackable_line_tbl OUT NOCOPY oe_order_pub.line_tbl_type,
1360: x_return_status OUT NOCOPY varchar2)
1361: IS
1362:
1363: l_line_tbl oe_order_pub.line_tbl_type;

Line 1363: l_line_tbl oe_order_pub.line_tbl_type;

1359: x_trackable_line_tbl OUT NOCOPY oe_order_pub.line_tbl_type,
1360: x_return_status OUT NOCOPY varchar2)
1361: IS
1362:
1363: l_line_tbl oe_order_pub.line_tbl_type;
1364: l_line_tbl_nxt_lvl oe_order_pub.line_tbl_type;
1365: l_line_tbl_temp oe_order_pub.line_tbl_type;
1366: l_line_tbl_final oe_order_pub.line_tbl_type;
1367:

Line 1364: l_line_tbl_nxt_lvl oe_order_pub.line_tbl_type;

1360: x_return_status OUT NOCOPY varchar2)
1361: IS
1362:
1363: l_line_tbl oe_order_pub.line_tbl_type;
1364: l_line_tbl_nxt_lvl oe_order_pub.line_tbl_type;
1365: l_line_tbl_temp oe_order_pub.line_tbl_type;
1366: l_line_tbl_final oe_order_pub.line_tbl_type;
1367:
1368: l_config_line_rec oe_order_pub.line_rec_type := oe_order_pub.g_miss_line_rec;

Line 1365: l_line_tbl_temp oe_order_pub.line_tbl_type;

1361: IS
1362:
1363: l_line_tbl oe_order_pub.line_tbl_type;
1364: l_line_tbl_nxt_lvl oe_order_pub.line_tbl_type;
1365: l_line_tbl_temp oe_order_pub.line_tbl_type;
1366: l_line_tbl_final oe_order_pub.line_tbl_type;
1367:
1368: l_config_line_rec oe_order_pub.line_rec_type := oe_order_pub.g_miss_line_rec;
1369:

Line 1366: l_line_tbl_final oe_order_pub.line_tbl_type;

1362:
1363: l_line_tbl oe_order_pub.line_tbl_type;
1364: l_line_tbl_nxt_lvl oe_order_pub.line_tbl_type;
1365: l_line_tbl_temp oe_order_pub.line_tbl_type;
1366: l_line_tbl_final oe_order_pub.line_tbl_type;
1367:
1368: l_config_line_rec oe_order_pub.line_rec_type := oe_order_pub.g_miss_line_rec;
1369:
1370: l_nxt_ind binary_integer;

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

1364: l_line_tbl_nxt_lvl oe_order_pub.line_tbl_type;
1365: l_line_tbl_temp oe_order_pub.line_tbl_type;
1366: l_line_tbl_final oe_order_pub.line_tbl_type;
1367:
1368: l_config_line_rec oe_order_pub.line_rec_type := oe_order_pub.g_miss_line_rec;
1369:
1370: l_nxt_ind binary_integer;
1371: l_final_ind binary_integer;
1372:

Line 1479: x_trackable_line_tbl OUT NOCOPY oe_order_pub.line_tbl_type,

1475:
1476: PROCEDURE get_all_ib_trackable_children(
1477: p_model_line_id IN number,
1478: p_om_vld_org_id IN number,
1479: x_trackable_line_tbl OUT NOCOPY oe_order_pub.line_tbl_type,
1480: x_return_status OUT NOCOPY varchar2)
1481: IS
1482:
1483: l_line_tbl oe_order_pub.line_tbl_type;

Line 1483: l_line_tbl oe_order_pub.line_tbl_type;

1479: x_trackable_line_tbl OUT NOCOPY oe_order_pub.line_tbl_type,
1480: x_return_status OUT NOCOPY varchar2)
1481: IS
1482:
1483: l_line_tbl oe_order_pub.line_tbl_type;
1484: l_line_tbl_nxt_lvl oe_order_pub.line_tbl_type;
1485: l_line_tbl_temp oe_order_pub.line_tbl_type;
1486: l_line_tbl_final oe_order_pub.line_tbl_type;
1487:

Line 1484: l_line_tbl_nxt_lvl oe_order_pub.line_tbl_type;

1480: x_return_status OUT NOCOPY varchar2)
1481: IS
1482:
1483: l_line_tbl oe_order_pub.line_tbl_type;
1484: l_line_tbl_nxt_lvl oe_order_pub.line_tbl_type;
1485: l_line_tbl_temp oe_order_pub.line_tbl_type;
1486: l_line_tbl_final oe_order_pub.line_tbl_type;
1487:
1488: l_nxt_ind binary_integer;

Line 1485: l_line_tbl_temp oe_order_pub.line_tbl_type;

1481: IS
1482:
1483: l_line_tbl oe_order_pub.line_tbl_type;
1484: l_line_tbl_nxt_lvl oe_order_pub.line_tbl_type;
1485: l_line_tbl_temp oe_order_pub.line_tbl_type;
1486: l_line_tbl_final oe_order_pub.line_tbl_type;
1487:
1488: l_nxt_ind binary_integer;
1489: l_final_ind binary_integer;

Line 1486: l_line_tbl_final oe_order_pub.line_tbl_type;

1482:
1483: l_line_tbl oe_order_pub.line_tbl_type;
1484: l_line_tbl_nxt_lvl oe_order_pub.line_tbl_type;
1485: l_line_tbl_temp oe_order_pub.line_tbl_type;
1486: l_line_tbl_final oe_order_pub.line_tbl_type;
1487:
1488: l_nxt_ind binary_integer;
1489: l_final_ind binary_integer;
1490:

Line 1968: x_parent_line_rec OUT NOCOPY oe_order_pub.line_rec_type,

1964:
1965: PROCEDURE get_ib_trackable_parent(
1966: p_current_line_id IN number,
1967: p_om_vld_org_id IN number,
1968: x_parent_line_rec OUT NOCOPY oe_order_pub.line_rec_type,
1969: x_return_status OUT NOCOPY varchar2)
1970: IS
1971: l_org_id number;
1972: l_parent_line_id number;

Line 1977: l_parent_line_rec oe_order_pub.line_rec_type;

1973: l_next_parent_line_id number;
1974: l_inventory_item_id number;
1975: l_ib_trackable_flag varchar2(1) := 'N';
1976:
1977: l_parent_line_rec oe_order_pub.line_rec_type;
1978:
1979: BEGIN
1980:
1981: x_return_status := fnd_api.g_ret_sts_success;

Line 2234: px_line_tbl IN OUT nocopy oe_order_pub.line_tbl_type,

2230: x_return_status := fnd_api.g_ret_sts_error;
2231: END get_tld;
2232:
2233: PROCEDURE get_ato_options_only(
2234: px_line_tbl IN OUT nocopy oe_order_pub.line_tbl_type,
2235: x_return_status OUT nocopy varchar2)
2236: IS
2237: o_line_tbl oe_order_pub.line_tbl_type;
2238: o_ind binary_integer := 0;

Line 2237: o_line_tbl oe_order_pub.line_tbl_type;

2233: PROCEDURE get_ato_options_only(
2234: px_line_tbl IN OUT nocopy oe_order_pub.line_tbl_type,
2235: x_return_status OUT nocopy varchar2)
2236: IS
2237: o_line_tbl oe_order_pub.line_tbl_type;
2238: o_ind binary_integer := 0;
2239: BEGIN
2240: x_return_status := fnd_api.g_ret_sts_success;
2241: api_log('get_ato_options_only');

Line 3079: p_parent_line_rec IN oe_order_pub.line_rec_type,

3075: END get_wip_instances;
3076:
3077: PROCEDURE get_wip_instances_for_line(
3078: p_option_line_rec IN oe_order_lines_all%rowtype,
3079: p_parent_line_rec IN oe_order_pub.line_rec_type,
3080: p_option_serial_code IN number,
3081: p_class_option_ratio IN number,
3082: p_config_rec IN config_rec,
3083: p_config_instances IN config_serial_inst_tbl,

Line 3500: p_parent_line_rec IN oe_order_pub.line_rec_type,

3496: -- enhancements to be made in the genealogy area in this routine
3497: PROCEDURE distribute_wip_instances(
3498: p_qty_ratio IN number,
3499: p_option_serial_code IN number,
3500: p_parent_line_rec IN oe_order_pub.line_rec_type,
3501: p_parent_instances IN parent_instances,
3502: p_wip_instances IN wip_instances,
3503: px_default_info_rec IN OUT nocopy default_info_rec,
3504: x_ii_rltns_tbl OUT nocopy csi_datastructures_pub.ii_relationship_tbl,

Line 4932: p_option_line_rec IN oe_order_pub.line_rec_type,

4928: x_return_status := fnd_api.g_ret_sts_error;
4929: END mark_and_get_srl_option;
4930:
4931: PROCEDURE filter_option_instances(
4932: p_option_line_rec IN oe_order_pub.line_rec_type,
4933: p_option_serial_code IN number,
4934: p_config_rec IN config_rec,
4935: p_transaction_line_id IN number,
4936: px_ii_rltns_tbl IN OUT nocopy csi_datastructures_pub.ii_relationship_tbl,

Line 5138: ,x_child_line_tbl OUT NOCOPY oe_order_pub.line_tbl_type

5134: ,p_organization_id IN NUMBER
5135: ,p_wip_job_id IN NUMBER
5136: ,p_explosion_level IN NUMBER
5137: ,p_phantom_option_item_ord_qty IN NUMBER --Added for bug 12673745
5138: ,x_child_line_tbl OUT NOCOPY oe_order_pub.line_tbl_type
5139: ,x_return_status OUT NOCOPY VARCHAR2
5140: )
5141: IS
5142: --

Line 5147: l_child_line_tbl oe_order_pub.line_tbl_type;

5143: l_err_msg VARCHAR2(2000) := NULL;
5144: l_error_code VARCHAR2(30) := NULL;
5145: l_group_id NUMBER;
5146: l_csi_bom_explosion_level NUMBER;
5147: l_child_line_tbl oe_order_pub.line_tbl_type;
5148: l_loop_count binary_integer := 0;
5149: l_bom_found VARCHAR2(1); -- Added for bug 11744133
5150: no_explosion EXCEPTION;-- Added for bug 11744133
5151: type inv_assembly_tbl is table of number index by VARCHAR2(100);

Line 5318: l_child_line_tbl oe_order_pub.line_tbl_type;

5314: l_err_msg VARCHAR2(2000) := NULL;
5315: l_error_code VARCHAR2(30) := NULL;
5316: l_group_id NUMBER;
5317: l_csi_bom_explosion_level NUMBER;
5318: l_child_line_tbl oe_order_pub.line_tbl_type;
5319: l_loop_count binary_integer := 0;
5320:
5321: CURSOR BOM_CSR (p_group_id NUMBER)
5322: IS

Line 5433: l_child_line_tbl oe_order_pub.line_tbl_type;

5429: l_config_instance config_serial_inst_rec;
5430:
5431: l_sub_config_instances config_serial_inst_tbl;
5432: l_sub_config_instance config_serial_inst_rec;
5433: l_child_line_tbl oe_order_pub.line_tbl_type;
5434: l_parent_line_rec oe_order_pub.line_rec_type;
5435:
5436: l_config_ns_tld_id number;
5437: l_sub_config_ns_tld_id number;

Line 5434: l_parent_line_rec oe_order_pub.line_rec_type;

5430:
5431: l_sub_config_instances config_serial_inst_tbl;
5432: l_sub_config_instance config_serial_inst_rec;
5433: l_child_line_tbl oe_order_pub.line_tbl_type;
5434: l_parent_line_rec oe_order_pub.line_rec_type;
5435:
5436: l_config_ns_tld_id number;
5437: l_sub_config_ns_tld_id number;
5438:

Line 5463: l_non_wip_child_line_tbl oe_order_pub.line_tbl_type;

5459: l_instance_id_lst csi_datastructures_pub.id_tbl;
5460:
5461: l_t_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5462: l_wip_processing boolean := FALSE;
5463: l_non_wip_child_line_tbl oe_order_pub.line_tbl_type;
5464: l_child_ind binary_integer := 0;
5465:
5466: l_msg_count number := 0;
5467: l_msg_data varchar2(2000);

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

6222:
6223: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6224: l_t_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6225:
6226: l_parent_line_rec oe_order_pub.line_rec_type := oe_order_pub.g_miss_line_rec;
6227: l_child_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;
6228: l_ns_tld_id number;
6229:
6230: l_qty_ratio number;

Line 6595: p_child_line_tbl IN oe_order_pub.line_tbl_type,

6591:
6592: -- Bug 10248175
6593: PROCEDURE build_child_relation_lines (
6594: p_order_line_rec IN oe_order_lines_all%ROWTYPE,
6595: p_child_line_tbl IN oe_order_pub.line_tbl_type,
6596: px_default_info_rec IN OUT NOCOPY default_info_rec,
6597: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
6598: x_return_status OUT NOCOPY varchar2)
6599: IS

Line 6602: l_temp_child_line_rec oe_order_pub.Line_Rec_Type;

6598: x_return_status OUT NOCOPY varchar2)
6599: IS
6600: l_qty_ratio NUMBER;
6601: l_order_line_qty number;
6602: l_temp_child_line_rec oe_order_pub.Line_Rec_Type;
6603: l_next_item_id number := 0;
6604: l_temp_idx number := 0;
6605: l_temp_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
6606: l_temp_index number := 0;

Line 6607: l_child_line_tbl oe_order_pub.line_tbl_type;

6603: l_next_item_id number := 0;
6604: l_temp_idx number := 0;
6605: l_temp_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
6606: l_temp_index number := 0;
6607: l_child_line_tbl oe_order_pub.line_tbl_type;
6608:
6609: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
6610: l_party_query_rec csi_datastructures_pub.party_query_rec;
6611: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;

Line 6886: l_child_line_tbl oe_order_pub.line_tbl_type;

6882:
6883:
6884: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6885:
6886: l_child_line_tbl oe_order_pub.line_tbl_type;
6887: l_grand_child_line_tbl oe_order_pub.line_tbl_type;
6888: l_qty_ratio number;
6889:
6890: l_model_order_qty number;

Line 6887: l_grand_child_line_tbl oe_order_pub.line_tbl_type;

6883:
6884: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6885:
6886: l_child_line_tbl oe_order_pub.line_tbl_type;
6887: l_grand_child_line_tbl oe_order_pub.line_tbl_type;
6888: l_qty_ratio number;
6889:
6890: l_model_order_qty number;
6891:

Line 6905: l_temp_child_line_rec oe_order_pub.Line_Rec_Type;

6901: l_msg_count number;
6902:
6903: --fix for bug5096435
6904: l_order_line_qty number;
6905: l_temp_child_line_rec oe_order_pub.Line_Rec_Type;
6906: l_next_item_id number := 0;
6907: l_temp_idx number := 0;
6908: l_temp_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
6909: l_temp_index number := 0;

Line 7160: l_parent_line_rec oe_order_pub.line_rec_type;

7156: IS
7157:
7158: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
7159:
7160: l_parent_line_rec oe_order_pub.line_rec_type;
7161: l_option_serial_code number;
7162:
7163: l_wip_instances wip_instances;
7164: l_parent_instances parent_instances;

Line 7541: l_parent_line_rec oe_order_pub.line_rec_type;

7537: IS
7538:
7539: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
7540:
7541: l_parent_line_rec oe_order_pub.line_rec_type;
7542: l_option_serial_code number;
7543:
7544: l_wip_instances wip_instances;
7545: l_parent_instances parent_instances;

Line 9051: l_trk_child_tbl oe_order_pub.line_tbl_type;

9047: l_config_reship_count number := 0;
9048:
9049: l_option_instances csi_datastructures_pub.instance_tbl;
9050:
9051: l_trk_child_tbl oe_order_pub.line_tbl_type;
9052: l_trk_parent_rec oe_order_pub.line_rec_type;
9053:
9054: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
9055: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;

Line 9052: l_trk_parent_rec oe_order_pub.line_rec_type;

9048:
9049: l_option_instances csi_datastructures_pub.instance_tbl;
9050:
9051: l_trk_child_tbl oe_order_pub.line_tbl_type;
9052: l_trk_parent_rec oe_order_pub.line_rec_type;
9053:
9054: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
9055: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
9056: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;

Line 11690: l_header_rec OE_Order_PUB.Header_Rec_Type;

11686: l_dequeue_mode VARCHAR2(240) DEFAULT DBMS_AQ.REMOVE;
11687: l_navigation VARCHAR2(240) DEFAULT DBMS_AQ.NEXT_MESSAGE;
11688: l_wait NUMBER DEFAULT DBMS_AQ.NO_WAIT;
11689: l_no_more_messages VARCHAR2(240);
11690: l_header_rec OE_Order_PUB.Header_Rec_Type;
11691: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
11692: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
11693: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
11694: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

Line 11691: l_old_header_rec OE_Order_PUB.Header_Rec_Type;

11687: l_navigation VARCHAR2(240) DEFAULT DBMS_AQ.NEXT_MESSAGE;
11688: l_wait NUMBER DEFAULT DBMS_AQ.NO_WAIT;
11689: l_no_more_messages VARCHAR2(240);
11690: l_header_rec OE_Order_PUB.Header_Rec_Type;
11691: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
11692: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
11693: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
11694: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
11695: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

Line 11692: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

11688: l_wait NUMBER DEFAULT DBMS_AQ.NO_WAIT;
11689: l_no_more_messages VARCHAR2(240);
11690: l_header_rec OE_Order_PUB.Header_Rec_Type;
11691: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
11692: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
11693: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
11694: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
11695: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
11696: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

Line 11693: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

11689: l_no_more_messages VARCHAR2(240);
11690: l_header_rec OE_Order_PUB.Header_Rec_Type;
11691: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
11692: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
11693: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
11694: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
11695: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
11696: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
11697: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

Line 11694: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

11690: l_header_rec OE_Order_PUB.Header_Rec_Type;
11691: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
11692: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
11693: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
11694: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
11695: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
11696: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
11697: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
11698: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

Line 11695: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

11691: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
11692: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
11693: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
11694: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
11695: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
11696: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
11697: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
11698: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
11699: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

Line 11696: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

11692: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
11693: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
11694: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
11695: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
11696: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
11697: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
11698: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
11699: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
11700: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 11697: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

11693: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
11694: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
11695: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
11696: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
11697: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
11698: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
11699: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
11700: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
11701: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 11698: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

11694: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
11695: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
11696: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
11697: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
11698: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
11699: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
11700: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
11701: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
11702: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 11699: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

11695: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
11696: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
11697: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
11698: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
11699: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
11700: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
11701: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
11702: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
11703: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 11700: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

11696: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
11697: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
11698: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
11699: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
11700: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
11701: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
11702: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
11703: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
11704: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 11701: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

11697: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
11698: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
11699: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
11700: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
11701: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
11702: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
11703: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
11704: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11705: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 11702: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

11698: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
11699: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
11700: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
11701: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
11702: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
11703: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
11704: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11705: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11706: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

Line 11703: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

11699: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
11700: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
11701: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
11702: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
11703: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
11704: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11705: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11706: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
11707: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

Line 11704: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

11700: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
11701: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
11702: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
11703: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
11704: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11705: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11706: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
11707: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
11708: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

Line 11705: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

11701: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
11702: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
11703: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
11704: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11705: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11706: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
11707: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
11708: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
11709: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

Line 11706: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

11702: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
11703: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
11704: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11705: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11706: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
11707: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
11708: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
11709: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
11710: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 11707: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

11703: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
11704: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11705: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11706: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
11707: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
11708: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
11709: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
11710: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
11711: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 11708: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

11704: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11705: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11706: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
11707: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
11708: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
11709: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
11710: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
11711: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
11712: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 11709: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

11705: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11706: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
11707: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
11708: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
11709: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
11710: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
11711: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
11712: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
11713: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 11710: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

11706: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
11707: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
11708: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
11709: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
11710: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
11711: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
11712: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
11713: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
11714: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 11711: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

11707: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
11708: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
11709: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
11710: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
11711: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
11712: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
11713: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
11714: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
11715: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 11712: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

11708: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
11709: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
11710: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
11711: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
11712: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
11713: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
11714: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
11715: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
11716: l_action_request_tbl OE_Order_PUB.request_tbl_type;

Line 11713: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

11709: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
11710: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
11711: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
11712: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
11713: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
11714: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
11715: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
11716: l_action_request_tbl OE_Order_PUB.request_tbl_type;
11717: --

Line 11714: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

11710: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
11711: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
11712: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
11713: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
11714: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
11715: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
11716: l_action_request_tbl OE_Order_PUB.request_tbl_type;
11717: --
11718: l_exp_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 11715: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

11711: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
11712: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
11713: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
11714: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
11715: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
11716: l_action_request_tbl OE_Order_PUB.request_tbl_type;
11717: --
11718: l_exp_line_tbl OE_Order_PUB.Line_Tbl_Type;
11719: l_exp_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 11716: l_action_request_tbl OE_Order_PUB.request_tbl_type;

11712: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
11713: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
11714: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
11715: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
11716: l_action_request_tbl OE_Order_PUB.request_tbl_type;
11717: --
11718: l_exp_line_tbl OE_Order_PUB.Line_Tbl_Type;
11719: l_exp_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
11720: l_exp_count NUMBER;

Line 11718: l_exp_line_tbl OE_Order_PUB.Line_Tbl_Type;

11714: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
11715: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
11716: l_action_request_tbl OE_Order_PUB.request_tbl_type;
11717: --
11718: l_exp_line_tbl OE_Order_PUB.Line_Tbl_Type;
11719: l_exp_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
11720: l_exp_count NUMBER;
11721: l_exp_flag VARCHAR2(1);
11722: l_line_count NUMBER;

Line 11719: l_exp_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

11715: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
11716: l_action_request_tbl OE_Order_PUB.request_tbl_type;
11717: --
11718: l_exp_line_tbl OE_Order_PUB.Line_Tbl_Type;
11719: l_exp_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
11720: l_exp_count NUMBER;
11721: l_exp_flag VARCHAR2(1);
11722: l_line_count NUMBER;
11723: l_multi_org_flag VARCHAR2(1);