APPS.CSI_RMA_RECEIPT_PUB dependencies on CSI_DATASTRUCTURES_PUB

Line 860: x_instance_query_rec OUT NOCOPY csi_datastructures_pub.instance_query_rec,

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

Line 861: x_party_query_rec OUT NOCOPY csi_datastructures_pub.party_query_rec,

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

Line 862: x_pty_acct_query_rec OUT NOCOPY csi_datastructures_pub.party_account_query_rec,

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

Line 867: l_inst_query_rec csi_datastructures_pub.instance_query_rec;

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

Line 868: l_party_query_rec csi_datastructures_pub.party_query_rec;

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

Line 918: l_instance_query_rec csi_datastructures_pub.instance_query_rec;

914: px_mtl_txn_rec IN OUT NOCOPY mtl_txn_rec,
915: p_item_control_rec IN item_control_rec, -- Added for Multi WIP Job ER
916: x_return_status OUT NOCOPY varchar2)
917: IS
918: l_instance_query_rec csi_datastructures_pub.instance_query_rec;
919: l_party_query_rec csi_datastructures_pub.party_query_rec;
920: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
921: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;
922: l_assm_qty number;

Line 919: l_party_query_rec csi_datastructures_pub.party_query_rec;

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

Line 920: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;

916: x_return_status OUT NOCOPY varchar2)
917: IS
918: l_instance_query_rec csi_datastructures_pub.instance_query_rec;
919: l_party_query_rec csi_datastructures_pub.party_query_rec;
920: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
921: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;
922: l_assm_qty number;
923: l_qry_exp_inst varchar2(1) := fnd_api.g_false;
924: l_wip_entity_type number;

Line 921: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;

917: IS
918: l_instance_query_rec csi_datastructures_pub.instance_query_rec;
919: l_party_query_rec csi_datastructures_pub.party_query_rec;
920: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
921: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;
922: l_assm_qty number;
923: l_qry_exp_inst varchar2(1) := fnd_api.g_false;
924: l_wip_entity_type number;
925:

Line 1127: x_txn_rec OUT NOCOPY csi_datastructures_pub.transaction_rec,

1123: PROCEDURE build_process_tables_TD(
1124: p_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
1125: p_mtl_txn_tbl IN mtl_txn_tbl,
1126: p_item_control_rec IN item_control_rec,
1127: x_txn_rec OUT NOCOPY csi_datastructures_pub.transaction_rec,
1128: x_instances_tbl OUT NOCOPY csi_process_txn_grp.txn_instances_tbl,
1129: x_i_parties_tbl OUT NOCOPY csi_process_txn_grp.txn_i_parties_tbl,
1130: x_ip_accounts_tbl OUT NOCOPY csi_process_txn_grp.txn_ip_accounts_tbl,
1131: x_org_units_tbl OUT NOCOPY csi_process_txn_grp.txn_org_units_tbl,

Line 1150: l_txn_rec csi_datastructures_pub.transaction_rec;

1146: l_master_organization_id number;
1147: l_instance_quantity number;
1148:
1149: l_rma_order_rec mtl_trx_type;
1150: l_txn_rec csi_datastructures_pub.transaction_rec;
1151: l_instances_tbl csi_process_txn_grp.txn_instances_tbl;
1152: l_i_parties_tbl csi_process_txn_grp.txn_i_parties_tbl;
1153: l_ip_accounts_tbl csi_process_txn_grp.txn_ip_accounts_tbl;
1154: l_org_units_tbl csi_process_txn_grp.txn_org_units_tbl;

Line 1522: x_txn_rec OUT NOCOPY csi_datastructures_pub.transaction_rec,

1518:
1519: PROCEDURE build_process_tables_NOTD(
1520: p_mtl_txn_tbl IN mtl_txn_tbl,
1521: p_item_control_rec IN item_control_rec,
1522: x_txn_rec OUT NOCOPY csi_datastructures_pub.transaction_rec,
1523: x_instances_tbl OUT NOCOPY csi_process_txn_grp.txn_instances_tbl,
1524: x_i_parties_tbl OUT NOCOPY csi_process_txn_grp.txn_i_parties_tbl,
1525: x_ip_accounts_tbl OUT NOCOPY csi_process_txn_grp.txn_ip_accounts_tbl,
1526: x_org_units_tbl OUT NOCOPY csi_process_txn_grp.txn_org_units_tbl,

Line 1547: l_txn_rec csi_datastructures_pub.transaction_rec;

1543:
1544: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1545: l_error_message varchar2(2000);
1546:
1547: l_txn_rec csi_datastructures_pub.transaction_rec;
1548: l_instances_tbl csi_process_txn_grp.txn_instances_tbl;
1549: l_i_parties_tbl csi_process_txn_grp.txn_i_parties_tbl;
1550: l_ip_accounts_tbl csi_process_txn_grp.txn_ip_accounts_tbl;
1551: l_org_units_tbl csi_process_txn_grp.txn_org_units_tbl;

Line 2534: px_trx_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec)

2530: PROCEDURE rma_receipt(
2531: p_mtl_txn_id IN number,
2532: p_message_id IN number,
2533: x_return_status OUT NOCOPY varchar2,
2534: px_trx_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec)
2535: IS
2536:
2537: l_api_name varchar2(30) := 'rma_receipt';
2538: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 2561: l_chg_instance_rec csi_datastructures_pub.instance_rec;

2557: l_cur_owner_party_id number;
2558: l_cur_owner_acct_id number;
2559:
2560: -- added as part of fix for Bug 2733128
2561: l_chg_instance_rec csi_datastructures_pub.instance_rec;
2562: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2563: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2564: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2565: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

Line 2562: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

2558: l_cur_owner_acct_id number;
2559:
2560: -- added as part of fix for Bug 2733128
2561: l_chg_instance_rec csi_datastructures_pub.instance_rec;
2562: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2563: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2564: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2565: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2566: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;

Line 2563: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

2559:
2560: -- added as part of fix for Bug 2733128
2561: l_chg_instance_rec csi_datastructures_pub.instance_rec;
2562: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2563: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2564: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2565: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2566: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;
2567:

Line 2564: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;

2560: -- added as part of fix for Bug 2733128
2561: l_chg_instance_rec csi_datastructures_pub.instance_rec;
2562: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2563: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2564: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2565: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2566: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;
2567:
2568:

Line 2565: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

2561: l_chg_instance_rec csi_datastructures_pub.instance_rec;
2562: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2563: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2564: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2565: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2566: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;
2567:
2568:
2569: l_owner_pty_ip_id number;

Line 2566: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;

2562: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2563: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2564: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2565: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2566: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;
2567:
2568:
2569: l_owner_pty_ip_id number;
2570: l_owner_pty_obj_ver_num number;

Line 2576: l_crt_instance_rec csi_datastructures_pub.instance_rec;

2572: l_owner_acct_obj_ver_num number;
2573:
2574: l_pty_override_flag varchar2(1) := 'N';
2575:
2576: l_crt_instance_rec csi_datastructures_pub.instance_rec;
2577: l_crt_parties_tbl csi_datastructures_pub.party_tbl;
2578: l_crt_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2579: l_crt_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2580: l_crt_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 2577: l_crt_parties_tbl csi_datastructures_pub.party_tbl;

2573:
2574: l_pty_override_flag varchar2(1) := 'N';
2575:
2576: l_crt_instance_rec csi_datastructures_pub.instance_rec;
2577: l_crt_parties_tbl csi_datastructures_pub.party_tbl;
2578: l_crt_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2579: l_crt_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2580: l_crt_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2581: l_crt_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 2578: l_crt_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

2574: l_pty_override_flag varchar2(1) := 'N';
2575:
2576: l_crt_instance_rec csi_datastructures_pub.instance_rec;
2577: l_crt_parties_tbl csi_datastructures_pub.party_tbl;
2578: l_crt_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2579: l_crt_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2580: l_crt_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2581: l_crt_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2582: l_crt_assets_tbl csi_datastructures_pub.instance_asset_tbl;

Line 2579: l_crt_org_units_tbl csi_datastructures_pub.organization_units_tbl;

2575:
2576: l_crt_instance_rec csi_datastructures_pub.instance_rec;
2577: l_crt_parties_tbl csi_datastructures_pub.party_tbl;
2578: l_crt_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2579: l_crt_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2580: l_crt_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2581: l_crt_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2582: l_crt_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2583: l_upd_parties_tbl csi_datastructures_pub.party_tbl;

Line 2580: l_crt_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

2576: l_crt_instance_rec csi_datastructures_pub.instance_rec;
2577: l_crt_parties_tbl csi_datastructures_pub.party_tbl;
2578: l_crt_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2579: l_crt_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2580: l_crt_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2581: l_crt_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2582: l_crt_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2583: l_upd_parties_tbl csi_datastructures_pub.party_tbl;
2584: l_upd_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

Line 2581: l_crt_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

2577: l_crt_parties_tbl csi_datastructures_pub.party_tbl;
2578: l_crt_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2579: l_crt_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2580: l_crt_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2581: l_crt_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2582: l_crt_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2583: l_upd_parties_tbl csi_datastructures_pub.party_tbl;
2584: l_upd_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2585:

Line 2582: l_crt_assets_tbl csi_datastructures_pub.instance_asset_tbl;

2578: l_crt_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2579: l_crt_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2580: l_crt_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2581: l_crt_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2582: l_crt_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2583: l_upd_parties_tbl csi_datastructures_pub.party_tbl;
2584: l_upd_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2585:
2586: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;

Line 2583: l_upd_parties_tbl csi_datastructures_pub.party_tbl;

2579: l_crt_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2580: l_crt_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2581: l_crt_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2582: l_crt_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2583: l_upd_parties_tbl csi_datastructures_pub.party_tbl;
2584: l_upd_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2585:
2586: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
2587: l_td_found boolean := FALSE;

Line 2584: l_upd_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

2580: l_crt_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2581: l_crt_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2582: l_crt_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2583: l_upd_parties_tbl csi_datastructures_pub.party_tbl;
2584: l_upd_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2585:
2586: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
2587: l_td_found boolean := FALSE;
2588: l_partial_receipt boolean := FALSE; -- Added for bug 4244887

Line 2608: l_instance_rec csi_datastructures_pub.instance_header_rec;

2604:
2605:
2606: -- get_item_instance_details variables
2607:
2608: l_instance_rec csi_datastructures_pub.instance_header_rec;
2609: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
2610: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
2611: l_org_assignments_tbl csi_datastructures_pub.org_units_header_tbl;
2612: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 2609: l_party_header_tbl csi_datastructures_pub.party_header_tbl;

2605:
2606: -- get_item_instance_details variables
2607:
2608: l_instance_rec csi_datastructures_pub.instance_header_rec;
2609: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
2610: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
2611: l_org_assignments_tbl csi_datastructures_pub.org_units_header_tbl;
2612: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2613: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 2610: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;

2606: -- get_item_instance_details variables
2607:
2608: l_instance_rec csi_datastructures_pub.instance_header_rec;
2609: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
2610: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
2611: l_org_assignments_tbl csi_datastructures_pub.org_units_header_tbl;
2612: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2613: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2614: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;

Line 2611: l_org_assignments_tbl csi_datastructures_pub.org_units_header_tbl;

2607:
2608: l_instance_rec csi_datastructures_pub.instance_header_rec;
2609: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
2610: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
2611: l_org_assignments_tbl csi_datastructures_pub.org_units_header_tbl;
2612: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2613: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2614: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
2615: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_header_tbl;

Line 2612: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;

2608: l_instance_rec csi_datastructures_pub.instance_header_rec;
2609: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
2610: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
2611: l_org_assignments_tbl csi_datastructures_pub.org_units_header_tbl;
2612: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2613: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2614: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
2615: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_header_tbl;
2616: l_time_stamp date;

Line 2613: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;

2609: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
2610: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
2611: l_org_assignments_tbl csi_datastructures_pub.org_units_header_tbl;
2612: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2613: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2614: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
2615: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_header_tbl;
2616: l_time_stamp date;
2617:

Line 2614: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;

2610: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
2611: l_org_assignments_tbl csi_datastructures_pub.org_units_header_tbl;
2612: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2613: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2614: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
2615: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_header_tbl;
2616: l_time_stamp date;
2617:
2618: -- process_transaction variables

Line 2615: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_header_tbl;

2611: l_org_assignments_tbl csi_datastructures_pub.org_units_header_tbl;
2612: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2613: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2614: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
2615: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_header_tbl;
2616: l_time_stamp date;
2617:
2618: -- process_transaction variables
2619:

Line 2627: l_txn_rec csi_datastructures_pub.transaction_rec;

2623: l_validation_level NUMBER := fnd_api.g_valid_level_full;
2624: l_validate_only_flag VARCHAR2(1) := fnd_api.g_false;
2625: l_in_out_flag VARCHAR2(30) := 'IN';
2626:
2627: l_txn_rec csi_datastructures_pub.transaction_rec;
2628: l_instances_tbl csi_process_txn_grp.txn_instances_tbl;
2629: l_i_parties_tbl csi_process_txn_grp.txn_i_parties_tbl;
2630: l_ip_accounts_tbl csi_process_txn_grp.txn_ip_accounts_tbl;
2631: l_org_units_tbl csi_process_txn_grp.txn_org_units_tbl;

Line 2639: l_error_rec csi_datastructures_pub.transaction_error_rec;

2635: l_ii_relationships_tbl csi_process_txn_grp.txn_ii_relationships_tbl;
2636: l_dest_location_rec csi_process_txn_grp.dest_location_rec;
2637:
2638: l_error_message varchar2(4000);
2639: l_error_rec csi_datastructures_pub.transaction_error_rec;
2640:
2641: l_split_src_inst_rec csi_datastructures_pub.instance_rec;
2642: l_split_src_trx_rec csi_datastructures_pub.transaction_rec;
2643: l_split_new_inst_rec csi_datastructures_pub.instance_rec;

Line 2641: l_split_src_inst_rec csi_datastructures_pub.instance_rec;

2637:
2638: l_error_message varchar2(4000);
2639: l_error_rec csi_datastructures_pub.transaction_error_rec;
2640:
2641: l_split_src_inst_rec csi_datastructures_pub.instance_rec;
2642: l_split_src_trx_rec csi_datastructures_pub.transaction_rec;
2643: l_split_new_inst_rec csi_datastructures_pub.instance_rec;
2644: l_quantity1 NUMBER;
2645: l_quantity2 NUMBER;

Line 2642: l_split_src_trx_rec csi_datastructures_pub.transaction_rec;

2638: l_error_message varchar2(4000);
2639: l_error_rec csi_datastructures_pub.transaction_error_rec;
2640:
2641: l_split_src_inst_rec csi_datastructures_pub.instance_rec;
2642: l_split_src_trx_rec csi_datastructures_pub.transaction_rec;
2643: l_split_new_inst_rec csi_datastructures_pub.instance_rec;
2644: l_quantity1 NUMBER;
2645: l_quantity2 NUMBER;
2646: -- multi srl control variables

Line 2643: l_split_new_inst_rec csi_datastructures_pub.instance_rec;

2639: l_error_rec csi_datastructures_pub.transaction_error_rec;
2640:
2641: l_split_src_inst_rec csi_datastructures_pub.instance_rec;
2642: l_split_src_trx_rec csi_datastructures_pub.transaction_rec;
2643: l_split_new_inst_rec csi_datastructures_pub.instance_rec;
2644: l_quantity1 NUMBER;
2645: l_quantity2 NUMBER;
2646: -- multi srl control variables
2647: l_inst_pa_rec inst_pa_rec;

Line 2649: l_u_instance_rec csi_datastructures_pub.instance_rec;

2645: l_quantity2 NUMBER;
2646: -- multi srl control variables
2647: l_inst_pa_rec inst_pa_rec;
2648: l_tld_inst_tbl tld_inst_tbl;
2649: l_u_instance_rec csi_datastructures_pub.instance_rec;
2650: l_u_party_tbl csi_datastructures_pub.party_tbl;
2651: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
2652: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2653: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 2650: l_u_party_tbl csi_datastructures_pub.party_tbl;

2646: -- multi srl control variables
2647: l_inst_pa_rec inst_pa_rec;
2648: l_tld_inst_tbl tld_inst_tbl;
2649: l_u_instance_rec csi_datastructures_pub.instance_rec;
2650: l_u_party_tbl csi_datastructures_pub.party_tbl;
2651: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
2652: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2653: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2654: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;

Line 2651: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;

2647: l_inst_pa_rec inst_pa_rec;
2648: l_tld_inst_tbl tld_inst_tbl;
2649: l_u_instance_rec csi_datastructures_pub.instance_rec;
2650: l_u_party_tbl csi_datastructures_pub.party_tbl;
2651: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
2652: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2653: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2654: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2655: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

Line 2652: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

2648: l_tld_inst_tbl tld_inst_tbl;
2649: l_u_instance_rec csi_datastructures_pub.instance_rec;
2650: l_u_party_tbl csi_datastructures_pub.party_tbl;
2651: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
2652: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2653: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2654: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2655: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2656: l_u_inst_id_lst csi_datastructures_pub.id_tbl;

Line 2653: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

2649: l_u_instance_rec csi_datastructures_pub.instance_rec;
2650: l_u_party_tbl csi_datastructures_pub.party_tbl;
2651: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
2652: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2653: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2654: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2655: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2656: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
2657: l_u_txn_rec csi_datastructures_pub.transaction_rec;

Line 2654: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;

2650: l_u_party_tbl csi_datastructures_pub.party_tbl;
2651: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
2652: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2653: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2654: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2655: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2656: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
2657: l_u_txn_rec csi_datastructures_pub.transaction_rec;
2658: l_upd_inst_tbl csi_datastructures_pub.instance_tbl;

Line 2655: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

2651: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
2652: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2653: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2654: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2655: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2656: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
2657: l_u_txn_rec csi_datastructures_pub.transaction_rec;
2658: l_upd_inst_tbl csi_datastructures_pub.instance_tbl;
2659: l_split_nsrc_inst_rec csi_datastructures_pub.instance_rec;

Line 2656: l_u_inst_id_lst csi_datastructures_pub.id_tbl;

2652: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2653: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2654: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2655: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2656: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
2657: l_u_txn_rec csi_datastructures_pub.transaction_rec;
2658: l_upd_inst_tbl csi_datastructures_pub.instance_tbl;
2659: l_split_nsrc_inst_rec csi_datastructures_pub.instance_rec;
2660: l_split_nsrc_trx_rec csi_datastructures_pub.transaction_rec;

Line 2657: l_u_txn_rec csi_datastructures_pub.transaction_rec;

2653: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2654: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2655: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2656: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
2657: l_u_txn_rec csi_datastructures_pub.transaction_rec;
2658: l_upd_inst_tbl csi_datastructures_pub.instance_tbl;
2659: l_split_nsrc_inst_rec csi_datastructures_pub.instance_rec;
2660: l_split_nsrc_trx_rec csi_datastructures_pub.transaction_rec;
2661: l_new_nsrc_inst_rec csi_datastructures_pub.instance_rec;

Line 2658: l_upd_inst_tbl csi_datastructures_pub.instance_tbl;

2654: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2655: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2656: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
2657: l_u_txn_rec csi_datastructures_pub.transaction_rec;
2658: l_upd_inst_tbl csi_datastructures_pub.instance_tbl;
2659: l_split_nsrc_inst_rec csi_datastructures_pub.instance_rec;
2660: l_split_nsrc_trx_rec csi_datastructures_pub.transaction_rec;
2661: l_new_nsrc_inst_rec csi_datastructures_pub.instance_rec;
2662: l_obj_ver_num NUMBER;

Line 2659: l_split_nsrc_inst_rec csi_datastructures_pub.instance_rec;

2655: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2656: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
2657: l_u_txn_rec csi_datastructures_pub.transaction_rec;
2658: l_upd_inst_tbl csi_datastructures_pub.instance_tbl;
2659: l_split_nsrc_inst_rec csi_datastructures_pub.instance_rec;
2660: l_split_nsrc_trx_rec csi_datastructures_pub.transaction_rec;
2661: l_new_nsrc_inst_rec csi_datastructures_pub.instance_rec;
2662: l_obj_ver_num NUMBER;
2663: l_end_date DATE;

Line 2660: l_split_nsrc_trx_rec csi_datastructures_pub.transaction_rec;

2656: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
2657: l_u_txn_rec csi_datastructures_pub.transaction_rec;
2658: l_upd_inst_tbl csi_datastructures_pub.instance_tbl;
2659: l_split_nsrc_inst_rec csi_datastructures_pub.instance_rec;
2660: l_split_nsrc_trx_rec csi_datastructures_pub.transaction_rec;
2661: l_new_nsrc_inst_rec csi_datastructures_pub.instance_rec;
2662: l_obj_ver_num NUMBER;
2663: l_end_date DATE;
2664: u_ind number := 0;

Line 2661: l_new_nsrc_inst_rec csi_datastructures_pub.instance_rec;

2657: l_u_txn_rec csi_datastructures_pub.transaction_rec;
2658: l_upd_inst_tbl csi_datastructures_pub.instance_tbl;
2659: l_split_nsrc_inst_rec csi_datastructures_pub.instance_rec;
2660: l_split_nsrc_trx_rec csi_datastructures_pub.transaction_rec;
2661: l_new_nsrc_inst_rec csi_datastructures_pub.instance_rec;
2662: l_obj_ver_num NUMBER;
2663: l_end_date DATE;
2664: u_ind number := 0;
2665: l_srl_qty NUMBER;

Line 2672: l_exp_instance_rec csi_datastructures_pub.instance_rec;

2668: l_i_ind number := 1;
2669: l_pi_ind number := 1;
2670: l_count NUMBER;
2671: l_active_end_date date;
2672: l_exp_instance_rec csi_datastructures_pub.instance_rec;
2673: l_literal1 VARCHAR2(30) ;
2674: l_literal2 VARCHAR2(30) ;
2675: l_instance_rev_num NUMBER;
2676: l_lock_id NUMBER;

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

2699: debug(' Transaction ID :'||p_mtl_txn_id);
2700:
2701: csi_utility_grp.check_ib_active;
2702:
2703: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
2704: csi_gen_utility_pvt.populate_install_param_rec;
2705: END IF;
2706:
2707: l_error_rec := px_trx_error_rec;

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

2740:
2741: /* start of ER 2646086 + RMA for Repair with different party */
2742: /* Get the value for the source of truth flag */
2743:
2744: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
2745: l_pty_override_flag := csi_datastructures_pub.g_install_param_rec.ownership_override_at_txn;
2746:
2747: /* end of ER 2646086 + RMA for Repair with different party */
2748:

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

2741: /* start of ER 2646086 + RMA for Repair with different party */
2742: /* Get the value for the source of truth flag */
2743:
2744: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
2745: l_pty_override_flag := csi_datastructures_pub.g_install_param_rec.ownership_override_at_txn;
2746:
2747: /* end of ER 2646086 + RMA for Repair with different party */
2748:
2749: l_error_rec.inventory_item_id := l_item_control_rec.inventory_item_id;

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

3165:
3166: /* start of ER 2646086 + RMA for Repair with different party */
3167: /* Get the value for the source of truth flag */
3168:
3169: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
3170: l_pty_override_flag := csi_datastructures_pub.g_install_param_rec.ownership_override_at_txn;
3171:
3172: /* end of ER 2646086 + RMA for Repair with different party */
3173:

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

3166: /* start of ER 2646086 + RMA for Repair with different party */
3167: /* Get the value for the source of truth flag */
3168:
3169: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
3170: l_pty_override_flag := csi_datastructures_pub.g_install_param_rec.ownership_override_at_txn;
3171:
3172: /* end of ER 2646086 + RMA for Repair with different party */
3173:
3174: -- Added the complete FOR piece for ER 2482219. Return for repair