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_RMA_RECEIPT_PUB dependencies on CSI_DATASTRUCTURES_PUB

Line 859: x_instance_query_rec OUT NOCOPY csi_datastructures_pub.instance_query_rec,

855: END get_mtl_txn_recs;
856:
857: PROCEDURE build_instance_query_rec(
858: p_mtl_txn_rec IN mtl_txn_rec,
859: x_instance_query_rec OUT NOCOPY csi_datastructures_pub.instance_query_rec,
860: x_party_query_rec OUT NOCOPY csi_datastructures_pub.party_query_rec,
861: x_pty_acct_query_rec OUT NOCOPY csi_datastructures_pub.party_account_query_rec,
862: x_return_status OUT NOCOPY varchar2)
863: IS

Line 860: x_party_query_rec OUT NOCOPY csi_datastructures_pub.party_query_rec,

856:
857: PROCEDURE build_instance_query_rec(
858: p_mtl_txn_rec IN mtl_txn_rec,
859: x_instance_query_rec OUT NOCOPY csi_datastructures_pub.instance_query_rec,
860: x_party_query_rec OUT NOCOPY csi_datastructures_pub.party_query_rec,
861: x_pty_acct_query_rec OUT NOCOPY csi_datastructures_pub.party_account_query_rec,
862: x_return_status OUT NOCOPY varchar2)
863: IS
864:

Line 861: x_pty_acct_query_rec OUT NOCOPY csi_datastructures_pub.party_account_query_rec,

857: PROCEDURE build_instance_query_rec(
858: p_mtl_txn_rec IN mtl_txn_rec,
859: x_instance_query_rec OUT NOCOPY csi_datastructures_pub.instance_query_rec,
860: x_party_query_rec OUT NOCOPY csi_datastructures_pub.party_query_rec,
861: x_pty_acct_query_rec OUT NOCOPY csi_datastructures_pub.party_account_query_rec,
862: x_return_status OUT NOCOPY varchar2)
863: IS
864:
865: l_inv_location_id number;

Line 866: l_inst_query_rec csi_datastructures_pub.instance_query_rec;

862: x_return_status OUT NOCOPY varchar2)
863: IS
864:
865: l_inv_location_id number;
866: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
867: l_party_query_rec csi_datastructures_pub.party_query_rec;
868:
869: BEGIN
870:

Line 867: l_party_query_rec csi_datastructures_pub.party_query_rec;

863: IS
864:
865: l_inv_location_id number;
866: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
867: l_party_query_rec csi_datastructures_pub.party_query_rec;
868:
869: BEGIN
870:
871: x_return_status := fnd_api.g_ret_sts_success;

Line 913: l_instance_query_rec csi_datastructures_pub.instance_query_rec;

909: px_mtl_txn_rec IN OUT NOCOPY mtl_txn_rec,
910: p_item_control_rec IN item_control_rec, -- Added for Multi WIP Job ER
911: x_return_status OUT NOCOPY varchar2)
912: IS
913: l_instance_query_rec csi_datastructures_pub.instance_query_rec;
914: l_party_query_rec csi_datastructures_pub.party_query_rec;
915: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
916: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;
917: l_assm_qty number;

Line 914: l_party_query_rec csi_datastructures_pub.party_query_rec;

910: p_item_control_rec IN item_control_rec, -- Added for Multi WIP Job ER
911: x_return_status OUT NOCOPY varchar2)
912: IS
913: l_instance_query_rec csi_datastructures_pub.instance_query_rec;
914: l_party_query_rec csi_datastructures_pub.party_query_rec;
915: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
916: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;
917: l_assm_qty number;
918: l_qry_exp_inst varchar2(1) := fnd_api.g_false;

Line 915: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;

911: x_return_status OUT NOCOPY varchar2)
912: IS
913: l_instance_query_rec csi_datastructures_pub.instance_query_rec;
914: l_party_query_rec csi_datastructures_pub.party_query_rec;
915: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
916: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;
917: l_assm_qty number;
918: l_qry_exp_inst varchar2(1) := fnd_api.g_false;
919: l_wip_entity_type number;

Line 916: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;

912: IS
913: l_instance_query_rec csi_datastructures_pub.instance_query_rec;
914: l_party_query_rec csi_datastructures_pub.party_query_rec;
915: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
916: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;
917: l_assm_qty number;
918: l_qry_exp_inst varchar2(1) := fnd_api.g_false;
919: l_wip_entity_type number;
920:

Line 1119: x_txn_rec OUT NOCOPY csi_datastructures_pub.transaction_rec,

1115: PROCEDURE build_process_tables_TD(
1116: p_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
1117: p_mtl_txn_tbl IN mtl_txn_tbl,
1118: p_item_control_rec IN item_control_rec,
1119: x_txn_rec OUT NOCOPY csi_datastructures_pub.transaction_rec,
1120: x_instances_tbl OUT NOCOPY csi_process_txn_grp.txn_instances_tbl,
1121: x_i_parties_tbl OUT NOCOPY csi_process_txn_grp.txn_i_parties_tbl,
1122: x_ip_accounts_tbl OUT NOCOPY csi_process_txn_grp.txn_ip_accounts_tbl,
1123: x_org_units_tbl OUT NOCOPY csi_process_txn_grp.txn_org_units_tbl,

Line 1142: l_txn_rec csi_datastructures_pub.transaction_rec;

1138: l_master_organization_id number;
1139: l_instance_quantity number;
1140:
1141: l_rma_order_rec mtl_trx_type;
1142: l_txn_rec csi_datastructures_pub.transaction_rec;
1143: l_instances_tbl csi_process_txn_grp.txn_instances_tbl;
1144: l_i_parties_tbl csi_process_txn_grp.txn_i_parties_tbl;
1145: l_ip_accounts_tbl csi_process_txn_grp.txn_ip_accounts_tbl;
1146: l_org_units_tbl csi_process_txn_grp.txn_org_units_tbl;

Line 1514: x_txn_rec OUT NOCOPY csi_datastructures_pub.transaction_rec,

1510:
1511: PROCEDURE build_process_tables_NOTD(
1512: p_mtl_txn_tbl IN mtl_txn_tbl,
1513: p_item_control_rec IN item_control_rec,
1514: x_txn_rec OUT NOCOPY csi_datastructures_pub.transaction_rec,
1515: x_instances_tbl OUT NOCOPY csi_process_txn_grp.txn_instances_tbl,
1516: x_i_parties_tbl OUT NOCOPY csi_process_txn_grp.txn_i_parties_tbl,
1517: x_ip_accounts_tbl OUT NOCOPY csi_process_txn_grp.txn_ip_accounts_tbl,
1518: x_org_units_tbl OUT NOCOPY csi_process_txn_grp.txn_org_units_tbl,

Line 1539: l_txn_rec csi_datastructures_pub.transaction_rec;

1535:
1536: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1537: l_error_message varchar2(2000);
1538:
1539: l_txn_rec csi_datastructures_pub.transaction_rec;
1540: l_instances_tbl csi_process_txn_grp.txn_instances_tbl;
1541: l_i_parties_tbl csi_process_txn_grp.txn_i_parties_tbl;
1542: l_ip_accounts_tbl csi_process_txn_grp.txn_ip_accounts_tbl;
1543: l_org_units_tbl csi_process_txn_grp.txn_org_units_tbl;

Line 2495: px_trx_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec)

2491: PROCEDURE rma_receipt(
2492: p_mtl_txn_id IN number,
2493: p_message_id IN number,
2494: x_return_status OUT NOCOPY varchar2,
2495: px_trx_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec)
2496: IS
2497:
2498: l_api_name varchar2(30) := 'rma_receipt';
2499: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 2522: l_chg_instance_rec csi_datastructures_pub.instance_rec;

2518: l_cur_owner_party_id number;
2519: l_cur_owner_acct_id number;
2520:
2521: -- added as part of fix for Bug 2733128
2522: l_chg_instance_rec csi_datastructures_pub.instance_rec;
2523: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2524: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2525: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2526: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

Line 2523: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

2519: l_cur_owner_acct_id number;
2520:
2521: -- added as part of fix for Bug 2733128
2522: l_chg_instance_rec csi_datastructures_pub.instance_rec;
2523: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2524: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2525: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2526: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2527: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;

Line 2524: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

2520:
2521: -- added as part of fix for Bug 2733128
2522: l_chg_instance_rec csi_datastructures_pub.instance_rec;
2523: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2524: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2525: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2526: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2527: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;
2528:

Line 2525: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;

2521: -- added as part of fix for Bug 2733128
2522: l_chg_instance_rec csi_datastructures_pub.instance_rec;
2523: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2524: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2525: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2526: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2527: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;
2528:
2529:

Line 2526: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

2522: l_chg_instance_rec csi_datastructures_pub.instance_rec;
2523: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2524: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2525: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2526: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2527: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;
2528:
2529:
2530: l_owner_pty_ip_id number;

Line 2527: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;

2523: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2524: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2525: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2526: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2527: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;
2528:
2529:
2530: l_owner_pty_ip_id number;
2531: l_owner_pty_obj_ver_num number;

Line 2537: l_crt_instance_rec csi_datastructures_pub.instance_rec;

2533: l_owner_acct_obj_ver_num number;
2534:
2535: l_pty_override_flag varchar2(1) := 'N';
2536:
2537: l_crt_instance_rec csi_datastructures_pub.instance_rec;
2538: l_crt_parties_tbl csi_datastructures_pub.party_tbl;
2539: l_crt_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2540: l_crt_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2541: l_crt_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 2538: l_crt_parties_tbl csi_datastructures_pub.party_tbl;

2534:
2535: l_pty_override_flag varchar2(1) := 'N';
2536:
2537: l_crt_instance_rec csi_datastructures_pub.instance_rec;
2538: l_crt_parties_tbl csi_datastructures_pub.party_tbl;
2539: l_crt_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2540: l_crt_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2541: l_crt_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2542: l_crt_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 2539: l_crt_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

2535: l_pty_override_flag varchar2(1) := 'N';
2536:
2537: l_crt_instance_rec csi_datastructures_pub.instance_rec;
2538: l_crt_parties_tbl csi_datastructures_pub.party_tbl;
2539: l_crt_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2540: l_crt_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2541: l_crt_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2542: l_crt_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2543: l_crt_assets_tbl csi_datastructures_pub.instance_asset_tbl;

Line 2540: l_crt_org_units_tbl csi_datastructures_pub.organization_units_tbl;

2536:
2537: l_crt_instance_rec csi_datastructures_pub.instance_rec;
2538: l_crt_parties_tbl csi_datastructures_pub.party_tbl;
2539: l_crt_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2540: l_crt_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2541: l_crt_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2542: l_crt_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2543: l_crt_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2544: l_upd_parties_tbl csi_datastructures_pub.party_tbl;

Line 2541: l_crt_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

2537: l_crt_instance_rec csi_datastructures_pub.instance_rec;
2538: l_crt_parties_tbl csi_datastructures_pub.party_tbl;
2539: l_crt_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2540: l_crt_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2541: l_crt_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2542: l_crt_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2543: l_crt_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2544: l_upd_parties_tbl csi_datastructures_pub.party_tbl;
2545: l_upd_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

Line 2542: l_crt_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

2538: l_crt_parties_tbl csi_datastructures_pub.party_tbl;
2539: l_crt_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2540: l_crt_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2541: l_crt_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2542: l_crt_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2543: l_crt_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2544: l_upd_parties_tbl csi_datastructures_pub.party_tbl;
2545: l_upd_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2546:

Line 2543: l_crt_assets_tbl csi_datastructures_pub.instance_asset_tbl;

2539: l_crt_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2540: l_crt_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2541: l_crt_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2542: l_crt_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2543: l_crt_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2544: l_upd_parties_tbl csi_datastructures_pub.party_tbl;
2545: l_upd_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2546:
2547: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;

Line 2544: l_upd_parties_tbl csi_datastructures_pub.party_tbl;

2540: l_crt_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2541: l_crt_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2542: l_crt_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2543: l_crt_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2544: l_upd_parties_tbl csi_datastructures_pub.party_tbl;
2545: l_upd_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2546:
2547: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
2548: l_td_found boolean := FALSE;

Line 2545: l_upd_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

2541: l_crt_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2542: l_crt_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2543: l_crt_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2544: l_upd_parties_tbl csi_datastructures_pub.party_tbl;
2545: l_upd_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2546:
2547: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
2548: l_td_found boolean := FALSE;
2549: l_partial_receipt boolean := FALSE; -- Added for bug 4244887

Line 2569: l_instance_rec csi_datastructures_pub.instance_header_rec;

2565:
2566:
2567: -- get_item_instance_details variables
2568:
2569: l_instance_rec csi_datastructures_pub.instance_header_rec;
2570: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
2571: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
2572: l_org_assignments_tbl csi_datastructures_pub.org_units_header_tbl;
2573: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 2570: l_party_header_tbl csi_datastructures_pub.party_header_tbl;

2566:
2567: -- get_item_instance_details variables
2568:
2569: l_instance_rec csi_datastructures_pub.instance_header_rec;
2570: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
2571: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
2572: l_org_assignments_tbl csi_datastructures_pub.org_units_header_tbl;
2573: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2574: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 2571: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;

2567: -- get_item_instance_details variables
2568:
2569: l_instance_rec csi_datastructures_pub.instance_header_rec;
2570: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
2571: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
2572: l_org_assignments_tbl csi_datastructures_pub.org_units_header_tbl;
2573: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2574: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2575: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;

Line 2572: l_org_assignments_tbl csi_datastructures_pub.org_units_header_tbl;

2568:
2569: l_instance_rec csi_datastructures_pub.instance_header_rec;
2570: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
2571: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
2572: l_org_assignments_tbl csi_datastructures_pub.org_units_header_tbl;
2573: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2574: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2575: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
2576: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_header_tbl;

Line 2573: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;

2569: l_instance_rec csi_datastructures_pub.instance_header_rec;
2570: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
2571: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
2572: l_org_assignments_tbl csi_datastructures_pub.org_units_header_tbl;
2573: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2574: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2575: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
2576: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_header_tbl;
2577: l_time_stamp date;

Line 2574: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;

2570: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
2571: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
2572: l_org_assignments_tbl csi_datastructures_pub.org_units_header_tbl;
2573: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2574: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2575: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
2576: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_header_tbl;
2577: l_time_stamp date;
2578:

Line 2575: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;

2571: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
2572: l_org_assignments_tbl csi_datastructures_pub.org_units_header_tbl;
2573: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2574: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2575: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
2576: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_header_tbl;
2577: l_time_stamp date;
2578:
2579: -- process_transaction variables

Line 2576: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_header_tbl;

2572: l_org_assignments_tbl csi_datastructures_pub.org_units_header_tbl;
2573: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2574: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2575: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
2576: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_header_tbl;
2577: l_time_stamp date;
2578:
2579: -- process_transaction variables
2580:

Line 2588: l_txn_rec csi_datastructures_pub.transaction_rec;

2584: l_validation_level NUMBER := fnd_api.g_valid_level_full;
2585: l_validate_only_flag VARCHAR2(1) := fnd_api.g_false;
2586: l_in_out_flag VARCHAR2(30) := 'IN';
2587:
2588: l_txn_rec csi_datastructures_pub.transaction_rec;
2589: l_instances_tbl csi_process_txn_grp.txn_instances_tbl;
2590: l_i_parties_tbl csi_process_txn_grp.txn_i_parties_tbl;
2591: l_ip_accounts_tbl csi_process_txn_grp.txn_ip_accounts_tbl;
2592: l_org_units_tbl csi_process_txn_grp.txn_org_units_tbl;

Line 2600: l_error_rec csi_datastructures_pub.transaction_error_rec;

2596: l_ii_relationships_tbl csi_process_txn_grp.txn_ii_relationships_tbl;
2597: l_dest_location_rec csi_process_txn_grp.dest_location_rec;
2598:
2599: l_error_message varchar2(4000);
2600: l_error_rec csi_datastructures_pub.transaction_error_rec;
2601:
2602: l_split_src_inst_rec csi_datastructures_pub.instance_rec;
2603: l_split_src_trx_rec csi_datastructures_pub.transaction_rec;
2604: l_split_new_inst_rec csi_datastructures_pub.instance_rec;

Line 2602: l_split_src_inst_rec csi_datastructures_pub.instance_rec;

2598:
2599: l_error_message varchar2(4000);
2600: l_error_rec csi_datastructures_pub.transaction_error_rec;
2601:
2602: l_split_src_inst_rec csi_datastructures_pub.instance_rec;
2603: l_split_src_trx_rec csi_datastructures_pub.transaction_rec;
2604: l_split_new_inst_rec csi_datastructures_pub.instance_rec;
2605: l_quantity1 NUMBER;
2606: l_quantity2 NUMBER;

Line 2603: l_split_src_trx_rec csi_datastructures_pub.transaction_rec;

2599: l_error_message varchar2(4000);
2600: l_error_rec csi_datastructures_pub.transaction_error_rec;
2601:
2602: l_split_src_inst_rec csi_datastructures_pub.instance_rec;
2603: l_split_src_trx_rec csi_datastructures_pub.transaction_rec;
2604: l_split_new_inst_rec csi_datastructures_pub.instance_rec;
2605: l_quantity1 NUMBER;
2606: l_quantity2 NUMBER;
2607: -- multi srl control variables

Line 2604: l_split_new_inst_rec csi_datastructures_pub.instance_rec;

2600: l_error_rec csi_datastructures_pub.transaction_error_rec;
2601:
2602: l_split_src_inst_rec csi_datastructures_pub.instance_rec;
2603: l_split_src_trx_rec csi_datastructures_pub.transaction_rec;
2604: l_split_new_inst_rec csi_datastructures_pub.instance_rec;
2605: l_quantity1 NUMBER;
2606: l_quantity2 NUMBER;
2607: -- multi srl control variables
2608: l_inst_pa_rec inst_pa_rec;

Line 2610: l_u_instance_rec csi_datastructures_pub.instance_rec;

2606: l_quantity2 NUMBER;
2607: -- multi srl control variables
2608: l_inst_pa_rec inst_pa_rec;
2609: l_tld_inst_tbl tld_inst_tbl;
2610: l_u_instance_rec csi_datastructures_pub.instance_rec;
2611: l_u_party_tbl csi_datastructures_pub.party_tbl;
2612: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
2613: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2614: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 2611: l_u_party_tbl csi_datastructures_pub.party_tbl;

2607: -- multi srl control variables
2608: l_inst_pa_rec inst_pa_rec;
2609: l_tld_inst_tbl tld_inst_tbl;
2610: l_u_instance_rec csi_datastructures_pub.instance_rec;
2611: l_u_party_tbl csi_datastructures_pub.party_tbl;
2612: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
2613: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2614: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2615: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;

Line 2612: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;

2608: l_inst_pa_rec inst_pa_rec;
2609: l_tld_inst_tbl tld_inst_tbl;
2610: l_u_instance_rec csi_datastructures_pub.instance_rec;
2611: l_u_party_tbl csi_datastructures_pub.party_tbl;
2612: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
2613: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2614: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2615: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2616: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

Line 2613: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

2609: l_tld_inst_tbl tld_inst_tbl;
2610: l_u_instance_rec csi_datastructures_pub.instance_rec;
2611: l_u_party_tbl csi_datastructures_pub.party_tbl;
2612: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
2613: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2614: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2615: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2616: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2617: l_u_inst_id_lst csi_datastructures_pub.id_tbl;

Line 2614: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

2610: l_u_instance_rec csi_datastructures_pub.instance_rec;
2611: l_u_party_tbl csi_datastructures_pub.party_tbl;
2612: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
2613: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2614: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2615: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2616: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2617: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
2618: l_u_txn_rec csi_datastructures_pub.transaction_rec;

Line 2615: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;

2611: l_u_party_tbl csi_datastructures_pub.party_tbl;
2612: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
2613: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2614: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2615: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2616: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2617: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
2618: l_u_txn_rec csi_datastructures_pub.transaction_rec;
2619: l_upd_inst_tbl csi_datastructures_pub.instance_tbl;

Line 2616: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

2612: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
2613: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2614: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2615: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2616: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2617: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
2618: l_u_txn_rec csi_datastructures_pub.transaction_rec;
2619: l_upd_inst_tbl csi_datastructures_pub.instance_tbl;
2620: l_split_nsrc_inst_rec csi_datastructures_pub.instance_rec;

Line 2617: l_u_inst_id_lst csi_datastructures_pub.id_tbl;

2613: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2614: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2615: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2616: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2617: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
2618: l_u_txn_rec csi_datastructures_pub.transaction_rec;
2619: l_upd_inst_tbl csi_datastructures_pub.instance_tbl;
2620: l_split_nsrc_inst_rec csi_datastructures_pub.instance_rec;
2621: l_split_nsrc_trx_rec csi_datastructures_pub.transaction_rec;

Line 2618: l_u_txn_rec csi_datastructures_pub.transaction_rec;

2614: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2615: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2616: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2617: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
2618: l_u_txn_rec csi_datastructures_pub.transaction_rec;
2619: l_upd_inst_tbl csi_datastructures_pub.instance_tbl;
2620: l_split_nsrc_inst_rec csi_datastructures_pub.instance_rec;
2621: l_split_nsrc_trx_rec csi_datastructures_pub.transaction_rec;
2622: l_new_nsrc_inst_rec csi_datastructures_pub.instance_rec;

Line 2619: l_upd_inst_tbl csi_datastructures_pub.instance_tbl;

2615: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2616: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2617: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
2618: l_u_txn_rec csi_datastructures_pub.transaction_rec;
2619: l_upd_inst_tbl csi_datastructures_pub.instance_tbl;
2620: l_split_nsrc_inst_rec csi_datastructures_pub.instance_rec;
2621: l_split_nsrc_trx_rec csi_datastructures_pub.transaction_rec;
2622: l_new_nsrc_inst_rec csi_datastructures_pub.instance_rec;
2623: l_obj_ver_num NUMBER;

Line 2620: l_split_nsrc_inst_rec csi_datastructures_pub.instance_rec;

2616: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2617: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
2618: l_u_txn_rec csi_datastructures_pub.transaction_rec;
2619: l_upd_inst_tbl csi_datastructures_pub.instance_tbl;
2620: l_split_nsrc_inst_rec csi_datastructures_pub.instance_rec;
2621: l_split_nsrc_trx_rec csi_datastructures_pub.transaction_rec;
2622: l_new_nsrc_inst_rec csi_datastructures_pub.instance_rec;
2623: l_obj_ver_num NUMBER;
2624: l_end_date DATE;

Line 2621: l_split_nsrc_trx_rec csi_datastructures_pub.transaction_rec;

2617: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
2618: l_u_txn_rec csi_datastructures_pub.transaction_rec;
2619: l_upd_inst_tbl csi_datastructures_pub.instance_tbl;
2620: l_split_nsrc_inst_rec csi_datastructures_pub.instance_rec;
2621: l_split_nsrc_trx_rec csi_datastructures_pub.transaction_rec;
2622: l_new_nsrc_inst_rec csi_datastructures_pub.instance_rec;
2623: l_obj_ver_num NUMBER;
2624: l_end_date DATE;
2625: u_ind number := 0;

Line 2622: l_new_nsrc_inst_rec csi_datastructures_pub.instance_rec;

2618: l_u_txn_rec csi_datastructures_pub.transaction_rec;
2619: l_upd_inst_tbl csi_datastructures_pub.instance_tbl;
2620: l_split_nsrc_inst_rec csi_datastructures_pub.instance_rec;
2621: l_split_nsrc_trx_rec csi_datastructures_pub.transaction_rec;
2622: l_new_nsrc_inst_rec csi_datastructures_pub.instance_rec;
2623: l_obj_ver_num NUMBER;
2624: l_end_date DATE;
2625: u_ind number := 0;
2626: l_srl_qty NUMBER;

Line 2633: l_exp_instance_rec csi_datastructures_pub.instance_rec;

2629: l_i_ind number := 1;
2630: l_pi_ind number := 1;
2631: l_count NUMBER;
2632: l_active_end_date date;
2633: l_exp_instance_rec csi_datastructures_pub.instance_rec;
2634: l_literal1 VARCHAR2(30) ;
2635: l_literal2 VARCHAR2(30) ;
2636: l_instance_rev_num NUMBER;
2637: l_lock_id NUMBER;

Line 2664: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

2660: debug(' Transaction ID :'||p_mtl_txn_id);
2661:
2662: csi_utility_grp.check_ib_active;
2663:
2664: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
2665: csi_gen_utility_pvt.populate_install_param_rec;
2666: END IF;
2667:
2668: l_error_rec := px_trx_error_rec;

Line 2705: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;

2701:
2702: /* start of ER 2646086 + RMA for Repair with different party */
2703: /* Get the value for the source of truth flag */
2704:
2705: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
2706: l_pty_override_flag := csi_datastructures_pub.g_install_param_rec.ownership_override_at_txn;
2707:
2708: /* end of ER 2646086 + RMA for Repair with different party */
2709:

Line 2706: l_pty_override_flag := csi_datastructures_pub.g_install_param_rec.ownership_override_at_txn;

2702: /* start of ER 2646086 + RMA for Repair with different party */
2703: /* Get the value for the source of truth flag */
2704:
2705: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
2706: l_pty_override_flag := csi_datastructures_pub.g_install_param_rec.ownership_override_at_txn;
2707:
2708: /* end of ER 2646086 + RMA for Repair with different party */
2709:
2710: l_error_rec.inventory_item_id := l_item_control_rec.inventory_item_id;

Line 3130: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;

3126:
3127: /* start of ER 2646086 + RMA for Repair with different party */
3128: /* Get the value for the source of truth flag */
3129:
3130: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
3131: l_pty_override_flag := csi_datastructures_pub.g_install_param_rec.ownership_override_at_txn;
3132:
3133: /* end of ER 2646086 + RMA for Repair with different party */
3134:

Line 3131: l_pty_override_flag := csi_datastructures_pub.g_install_param_rec.ownership_override_at_txn;

3127: /* start of ER 2646086 + RMA for Repair with different party */
3128: /* Get the value for the source of truth flag */
3129:
3130: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
3131: l_pty_override_flag := csi_datastructures_pub.g_install_param_rec.ownership_override_at_txn;
3132:
3133: /* end of ER 2646086 + RMA for Repair with different party */
3134:
3135: -- Added the complete FOR piece for ER 2482219. Return for repair