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

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

287: p_api_name => 'validate_owner_reference');
288:
289: x_return_status := fnd_api.g_ret_sts_success;
290:
291: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
292:
293: IF p_txn_instances_tbl.COUNT > 0 THEN
294: FOR l_i_ind IN p_txn_instances_tbl.FIRST .. p_txn_instances_tbl.LAST
295: LOOP

Line 712: x_instance_query_rec OUT NOCOPY csi_datastructures_pub.instance_query_rec,

708: p_sub_type_rec IN csi_txn_sub_types%rowtype,
709: p_instance_rec IN csi_process_txn_grp.txn_instance_rec,
710: p_dest_location_rec IN csi_process_txn_grp.dest_location_rec,
711: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,
712: x_instance_query_rec OUT NOCOPY csi_datastructures_pub.instance_query_rec,
713: x_return_status OUT NOCOPY varchar2)
714: IS
715:
716: l_inst_query_rec csi_datastructures_pub.instance_query_rec;

Line 716: l_inst_query_rec csi_datastructures_pub.instance_query_rec;

712: x_instance_query_rec OUT NOCOPY csi_datastructures_pub.instance_query_rec,
713: x_return_status OUT NOCOPY varchar2)
714: IS
715:
716: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
717:
718: BEGIN
719:
720: x_return_status := fnd_api.g_ret_sts_success;

Line 871: p_txn_rec in OUT NOCOPY csi_datastructures_pub.transaction_rec,

867: END get_negative_code;
868:
869: PROCEDURE create_zero_qty_instance(
870: p_instance_rec in csi_process_txn_grp.txn_instance_rec,
871: p_txn_rec in OUT NOCOPY csi_datastructures_pub.transaction_rec,
872: x_instance_id OUT NOCOPY number,
873: x_return_status OUT NOCOPY varchar2)
874: IS
875:

Line 876: l_transaction_rec csi_datastructures_pub.transaction_rec;

872: x_instance_id OUT NOCOPY number,
873: x_return_status OUT NOCOPY varchar2)
874: IS
875:
876: l_transaction_rec csi_datastructures_pub.transaction_rec;
877: l_instance_rec csi_datastructures_pub.instance_rec;
878: l_parties_tbl csi_datastructures_pub.party_tbl;
879: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
880: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;

Line 877: l_instance_rec csi_datastructures_pub.instance_rec;

873: x_return_status OUT NOCOPY varchar2)
874: IS
875:
876: l_transaction_rec csi_datastructures_pub.transaction_rec;
877: l_instance_rec csi_datastructures_pub.instance_rec;
878: l_parties_tbl csi_datastructures_pub.party_tbl;
879: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
880: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
881: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 878: l_parties_tbl csi_datastructures_pub.party_tbl;

874: IS
875:
876: l_transaction_rec csi_datastructures_pub.transaction_rec;
877: l_instance_rec csi_datastructures_pub.instance_rec;
878: l_parties_tbl csi_datastructures_pub.party_tbl;
879: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
880: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
881: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
882: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 879: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

875:
876: l_transaction_rec csi_datastructures_pub.transaction_rec;
877: l_instance_rec csi_datastructures_pub.instance_rec;
878: l_parties_tbl csi_datastructures_pub.party_tbl;
879: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
880: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
881: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
882: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
883: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;

Line 880: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;

876: l_transaction_rec csi_datastructures_pub.transaction_rec;
877: l_instance_rec csi_datastructures_pub.instance_rec;
878: l_parties_tbl csi_datastructures_pub.party_tbl;
879: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
880: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
881: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
882: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
883: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
884:

Line 881: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

877: l_instance_rec csi_datastructures_pub.instance_rec;
878: l_parties_tbl csi_datastructures_pub.party_tbl;
879: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
880: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
881: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
882: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
883: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
884:
885: l_internal_party_id number;

Line 882: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

878: l_parties_tbl csi_datastructures_pub.party_tbl;
879: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
880: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
881: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
882: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
883: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
884:
885: l_internal_party_id number;
886:

Line 883: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;

879: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
880: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
881: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
882: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
883: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
884:
885: l_internal_party_id number;
886:
887: l_u_instance_rec csi_datastructures_pub.instance_rec;

Line 887: l_u_instance_rec csi_datastructures_pub.instance_rec;

883: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
884:
885: l_internal_party_id number;
886:
887: l_u_instance_rec csi_datastructures_pub.instance_rec;
888: l_u_parties_tbl csi_datastructures_pub.party_tbl;
889: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
890: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
891: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 888: l_u_parties_tbl csi_datastructures_pub.party_tbl;

884:
885: l_internal_party_id number;
886:
887: l_u_instance_rec csi_datastructures_pub.instance_rec;
888: l_u_parties_tbl csi_datastructures_pub.party_tbl;
889: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
890: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
891: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
892: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 889: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

885: l_internal_party_id number;
886:
887: l_u_instance_rec csi_datastructures_pub.instance_rec;
888: l_u_parties_tbl csi_datastructures_pub.party_tbl;
889: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
890: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
891: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
892: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
893: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;

Line 890: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;

886:
887: l_u_instance_rec csi_datastructures_pub.instance_rec;
888: l_u_parties_tbl csi_datastructures_pub.party_tbl;
889: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
890: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
891: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
892: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
893: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
894: l_instance_ids_list csi_datastructures_pub.id_tbl;

Line 891: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

887: l_u_instance_rec csi_datastructures_pub.instance_rec;
888: l_u_parties_tbl csi_datastructures_pub.party_tbl;
889: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
890: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
891: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
892: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
893: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
894: l_instance_ids_list csi_datastructures_pub.id_tbl;
895:

Line 892: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

888: l_u_parties_tbl csi_datastructures_pub.party_tbl;
889: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
890: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
891: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
892: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
893: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
894: l_instance_ids_list csi_datastructures_pub.id_tbl;
895:
896: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 893: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;

889: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
890: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
891: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
892: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
893: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
894: l_instance_ids_list csi_datastructures_pub.id_tbl;
895:
896: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
897: l_msg_count number;

Line 894: l_instance_ids_list csi_datastructures_pub.id_tbl;

890: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
891: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
892: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
893: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
894: l_instance_ids_list csi_datastructures_pub.id_tbl;
895:
896: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
897: l_msg_count number;
898: l_msg_data varchar2(2000);

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

901: x_return_status := fnd_api.g_ret_sts_success;
902:
903: api_log('create_zero_qty_instance');
904:
905: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
906:
907: l_instance_rec.inventory_item_id := p_instance_rec.inventory_item_id;
908: l_instance_rec.inventory_revision := p_instance_rec.inventory_revision;
909: l_instance_rec.inv_subinventory_name := p_instance_rec.inv_subinventory_name;

Line 1025: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

1021: p_sub_type_rec IN csi_txn_sub_types%rowtype,
1022: p_instance_rec IN csi_process_txn_grp.txn_instance_rec,
1023: p_dest_location_rec IN csi_process_txn_grp.dest_location_rec,
1024: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,
1025: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
1026: x_instance_id OUT NOCOPY number,
1027: x_return_status OUT NOCOPY varchar2)
1028: IS
1029:

Line 1030: l_instance_query_rec csi_datastructures_pub.instance_query_rec;

1026: x_instance_id OUT NOCOPY number,
1027: x_return_status OUT NOCOPY varchar2)
1028: IS
1029:
1030: l_instance_query_rec csi_datastructures_pub.instance_query_rec;
1031: l_party_query_rec csi_datastructures_pub.party_query_rec;
1032: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1033:
1034: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;

Line 1031: l_party_query_rec csi_datastructures_pub.party_query_rec;

1027: x_return_status OUT NOCOPY varchar2)
1028: IS
1029:
1030: l_instance_query_rec csi_datastructures_pub.instance_query_rec;
1031: l_party_query_rec csi_datastructures_pub.party_query_rec;
1032: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1033:
1034: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;
1035: l_change_owner varchar2(1);

Line 1032: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;

1028: IS
1029:
1030: l_instance_query_rec csi_datastructures_pub.instance_query_rec;
1031: l_party_query_rec csi_datastructures_pub.party_query_rec;
1032: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1033:
1034: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;
1035: l_change_owner varchar2(1);
1036: l_owner_to_code varchar2(1);

Line 1034: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;

1030: l_instance_query_rec csi_datastructures_pub.instance_query_rec;
1031: l_party_query_rec csi_datastructures_pub.party_query_rec;
1032: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1033:
1034: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;
1035: l_change_owner varchar2(1);
1036: l_owner_to_code varchar2(1);
1037: l_negative_code number;
1038: l_pty_override_flag varchar2(1) := 'N';

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

1224: -- if it is return for repair from customer and item is serialized and
1225: -- the CSI Profile to process the txn is set to 'Y' then a source instance is not required
1226: -- Added this for the ER 2482219. Return for repair
1227:
1228: l_pty_override_flag:= csi_datastructures_pub.g_install_param_rec.ownership_override_at_txn;
1229:
1230: debug(' ownership_override_at_txn : '||l_pty_override_flag);
1231:
1232: IF p_item_attr_rec.src_serial_control_flag = 'Y'

Line 1359: l_instance_query_rec csi_datastructures_pub.instance_query_rec;

1355: x_return_status OUT NOCOPY varchar2)
1356:
1357: IS
1358:
1359: l_instance_query_rec csi_datastructures_pub.instance_query_rec;
1360: l_party_query_rec csi_datastructures_pub.party_query_rec;
1361: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1362:
1363: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;

Line 1360: l_party_query_rec csi_datastructures_pub.party_query_rec;

1356:
1357: IS
1358:
1359: l_instance_query_rec csi_datastructures_pub.instance_query_rec;
1360: l_party_query_rec csi_datastructures_pub.party_query_rec;
1361: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1362:
1363: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;
1364: l_change_owner varchar2(1);

Line 1361: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;

1357: IS
1358:
1359: l_instance_query_rec csi_datastructures_pub.instance_query_rec;
1360: l_party_query_rec csi_datastructures_pub.party_query_rec;
1361: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1362:
1363: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;
1364: l_change_owner varchar2(1);
1365: l_owner_to_code varchar2(1);

Line 1363: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;

1359: l_instance_query_rec csi_datastructures_pub.instance_query_rec;
1360: l_party_query_rec csi_datastructures_pub.party_query_rec;
1361: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1362:
1363: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;
1364: l_change_owner varchar2(1);
1365: l_owner_to_code varchar2(1);
1366:
1367: instance_not_found exception;

Line 1518: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,

1514: p_sub_type_rec IN csi_txn_sub_types%rowtype,
1515: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,
1516: p_instance_rec IN csi_process_txn_grp.txn_instance_rec,
1517: p_dest_location_rec IN csi_process_txn_grp.dest_location_rec,
1518: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,
1519: x_process_mode OUT NOCOPY varchar2,
1520: x_return_status OUT NOCOPY varchar2)
1521: IS
1522: l_instance_rec csi_datastructures_pub.instance_rec;

Line 1522: l_instance_rec csi_datastructures_pub.instance_rec;

1518: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,
1519: x_process_mode OUT NOCOPY varchar2,
1520: x_return_status OUT NOCOPY varchar2)
1521: IS
1522: l_instance_rec csi_datastructures_pub.instance_rec;
1523: l_process_mode varchar2(30);
1524: BEGIN
1525:
1526: x_return_status := fnd_api.g_ret_sts_success;

Line 1648: x_parties_tbl OUT NOCOPY csi_datastructures_pub.party_tbl,

1644: PROCEDURE build_parties_for_index(
1645: p_instance_index IN binary_integer,
1646: p_i_parties_tbl IN csi_process_txn_grp.txn_i_parties_tbl,
1647: p_ip_accounts_tbl IN csi_process_txn_grp.txn_ip_accounts_tbl,
1648: x_parties_tbl OUT NOCOPY csi_datastructures_pub.party_tbl,
1649: x_pty_accts_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
1650: x_return_status OUT NOCOPY varchar2)
1651: IS
1652:

Line 1649: x_pty_accts_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,

1645: p_instance_index IN binary_integer,
1646: p_i_parties_tbl IN csi_process_txn_grp.txn_i_parties_tbl,
1647: p_ip_accounts_tbl IN csi_process_txn_grp.txn_ip_accounts_tbl,
1648: x_parties_tbl OUT NOCOPY csi_datastructures_pub.party_tbl,
1649: x_pty_accts_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
1650: x_return_status OUT NOCOPY varchar2)
1651: IS
1652:
1653: c_ind binary_integer;

Line 1656: l_pty_tbl csi_datastructures_pub.party_tbl;

1652:
1653: c_ind binary_integer;
1654: c_a_ind binary_integer;
1655:
1656: l_pty_tbl csi_datastructures_pub.party_tbl;
1657: l_pty_acct_tbl csi_datastructures_pub.party_account_tbl;
1658:
1659: BEGIN
1660:

Line 1657: l_pty_acct_tbl csi_datastructures_pub.party_account_tbl;

1653: c_ind binary_integer;
1654: c_a_ind binary_integer;
1655:
1656: l_pty_tbl csi_datastructures_pub.party_tbl;
1657: l_pty_acct_tbl csi_datastructures_pub.party_account_tbl;
1658:
1659: BEGIN
1660:
1661: c_ind := 0;

Line 1768: x_ea_values_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,

1764:
1765: PROCEDURE build_ext_vals_for_index(
1766: p_instance_index IN binary_integer,
1767: p_ext_attrib_vals_tbl IN csi_process_txn_grp.txn_ext_attrib_values_tbl,
1768: x_ea_values_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
1769: x_return_status OUT NOCOPY varchar2)
1770: IS
1771: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1772: c_ind binary_integer;

Line 1771: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;

1767: p_ext_attrib_vals_tbl IN csi_process_txn_grp.txn_ext_attrib_values_tbl,
1768: x_ea_values_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
1769: x_return_status OUT NOCOPY varchar2)
1770: IS
1771: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1772: c_ind binary_integer;
1773: BEGIN
1774: c_ind :=0;
1775:

Line 1829: x_pricing_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,

1825:
1826: PROCEDURE build_price_tbl_for_index(
1827: p_instance_index IN binary_integer,
1828: p_pricing_attribs_tbl IN csi_process_txn_grp.txn_pricing_attribs_tbl,
1829: x_pricing_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
1830: x_return_status OUT NOCOPY varchar2)
1831: IS
1832: l_price_tbl csi_datastructures_pub.pricing_attribs_tbl;
1833: c_ind binary_integer;

Line 1832: l_price_tbl csi_datastructures_pub.pricing_attribs_tbl;

1828: p_pricing_attribs_tbl IN csi_process_txn_grp.txn_pricing_attribs_tbl,
1829: x_pricing_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
1830: x_return_status OUT NOCOPY varchar2)
1831: IS
1832: l_price_tbl csi_datastructures_pub.pricing_attribs_tbl;
1833: c_ind binary_integer;
1834: BEGIN
1835:
1836: IF p_pricing_attribs_tbl.COUNT > 0 THEN

Line 1988: x_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,

1984:
1985: PROCEDURE build_org_units_for_index(
1986: p_instance_index IN binary_integer,
1987: p_org_units_tbl IN csi_process_txn_grp.txn_org_units_tbl,
1988: x_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
1989: x_return_status OUT NOCOPY varchar2)
1990: IS
1991: c_ind binary_integer;
1992: l_ou_tbl csi_datastructures_pub.organization_units_tbl;

Line 1992: l_ou_tbl csi_datastructures_pub.organization_units_tbl;

1988: x_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
1989: x_return_status OUT NOCOPY varchar2)
1990: IS
1991: c_ind binary_integer;
1992: l_ou_tbl csi_datastructures_pub.organization_units_tbl;
1993: BEGIN
1994:
1995: c_ind := 0;
1996: IF p_org_units_tbl.COUNT > 0 THEN

Line 2049: x_assets_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_tbl,

2045:
2046: PROCEDURE build_assets_for_index(
2047: p_instance_index IN binary_integer,
2048: p_instance_asset_tbl IN csi_process_txn_grp.txn_instance_asset_tbl,
2049: x_assets_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_tbl,
2050: x_return_status OUT NOCOPY varchar2)
2051: IS
2052: c_ind binary_integer;
2053: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;

Line 2053: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;

2049: x_assets_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_tbl,
2050: x_return_status OUT NOCOPY varchar2)
2051: IS
2052: c_ind binary_integer;
2053: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2054: BEGIN
2055: debug('Just in the asset build');
2056: IF p_instance_asset_tbl.COUNT > 0 THEN
2057: FOR l_ind IN p_instance_asset_tbl.FIRST .. p_instance_asset_tbl.LAST

Line 2089: p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,

2085:
2086: PROCEDURE get_ids_for_instance(
2087: p_in_out_flag IN varchar2,
2088: p_sub_type_rec IN csi_txn_sub_types%rowtype,
2089: p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,
2090: p_parties_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl,
2091: p_pty_accts_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,
2092: p_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
2093: p_ea_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,

Line 2090: p_parties_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl,

2086: PROCEDURE get_ids_for_instance(
2087: p_in_out_flag IN varchar2,
2088: p_sub_type_rec IN csi_txn_sub_types%rowtype,
2089: p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,
2090: p_parties_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl,
2091: p_pty_accts_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,
2092: p_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
2093: p_ea_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
2094: p_pricing_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,

Line 2091: p_pty_accts_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,

2087: p_in_out_flag IN varchar2,
2088: p_sub_type_rec IN csi_txn_sub_types%rowtype,
2089: p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,
2090: p_parties_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl,
2091: p_pty_accts_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,
2092: p_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
2093: p_ea_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
2094: p_pricing_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
2095: p_assets_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl,

Line 2092: p_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,

2088: p_sub_type_rec IN csi_txn_sub_types%rowtype,
2089: p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,
2090: p_parties_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl,
2091: p_pty_accts_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,
2092: p_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
2093: p_ea_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
2094: p_pricing_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
2095: p_assets_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl,
2096: x_return_status OUT NOCOPY varchar2)

Line 2093: p_ea_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,

2089: p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,
2090: p_parties_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl,
2091: p_pty_accts_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,
2092: p_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
2093: p_ea_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
2094: p_pricing_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
2095: p_assets_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl,
2096: x_return_status OUT NOCOPY varchar2)
2097: IS

Line 2094: p_pricing_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,

2090: p_parties_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl,
2091: p_pty_accts_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,
2092: p_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
2093: p_ea_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
2094: p_pricing_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
2095: p_assets_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl,
2096: x_return_status OUT NOCOPY varchar2)
2097: IS
2098: l_parties_tbl csi_datastructures_pub.party_tbl;

Line 2095: p_assets_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl,

2091: p_pty_accts_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,
2092: p_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
2093: p_ea_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
2094: p_pricing_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
2095: p_assets_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl,
2096: x_return_status OUT NOCOPY varchar2)
2097: IS
2098: l_parties_tbl csi_datastructures_pub.party_tbl;
2099: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

Line 2098: l_parties_tbl csi_datastructures_pub.party_tbl;

2094: p_pricing_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
2095: p_assets_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl,
2096: x_return_status OUT NOCOPY varchar2)
2097: IS
2098: l_parties_tbl csi_datastructures_pub.party_tbl;
2099: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2100: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2101: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2102: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 2099: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

2095: p_assets_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl,
2096: x_return_status OUT NOCOPY varchar2)
2097: IS
2098: l_parties_tbl csi_datastructures_pub.party_tbl;
2099: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2100: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2101: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2102: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2103: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;

Line 2100: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;

2096: x_return_status OUT NOCOPY varchar2)
2097: IS
2098: l_parties_tbl csi_datastructures_pub.party_tbl;
2099: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2100: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2101: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2102: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2103: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2104:

Line 2101: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

2097: IS
2098: l_parties_tbl csi_datastructures_pub.party_tbl;
2099: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2100: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2101: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2102: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2103: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2104:
2105: l_debug_level number;

Line 2102: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

2098: l_parties_tbl csi_datastructures_pub.party_tbl;
2099: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2100: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2101: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2102: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2103: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2104:
2105: l_debug_level number;
2106: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 2103: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;

2099: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2100: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2101: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2102: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2103: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2104:
2105: l_debug_level number;
2106: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2107: l_msg_count number;

Line 2335: p_parties_tbl OUT NOCOPY csi_datastructures_pub.party_tbl,

2331:
2332:
2333: PROCEDURE get_internal_party_tbl(
2334: p_instance_id IN number,
2335: p_parties_tbl OUT NOCOPY csi_datastructures_pub.party_tbl,
2336: x_return_status OUT NOCOPY varchar2)
2337: IS
2338: l_internal_party_id number;
2339: l_instance_party_id number;

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

2343: x_return_status := fnd_api.g_ret_sts_success;
2344:
2345: api_log('get_internal_party_tbl');
2346:
2347: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
2348:
2349: SELECT instance_party_id,
2350: object_version_number
2351: INTO l_instance_party_id,

Line 2375: p_transaction_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,

2371: -- code modification for 3681856;parameter added to determine whether or not to invoke contracts API
2372: PROCEDURE unexpire_instance(
2373: p_instance_id IN number,
2374: p_call_contracts IN varchar2 := fnd_api.g_true,
2375: p_transaction_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
2376: x_return_status OUT nocopy varchar2)
2377: IS
2378: l_u_instance_rec csi_datastructures_pub.instance_rec;
2379: l_u_parties_tbl csi_datastructures_pub.party_tbl;

Line 2378: l_u_instance_rec csi_datastructures_pub.instance_rec;

2374: p_call_contracts IN varchar2 := fnd_api.g_true,
2375: p_transaction_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
2376: x_return_status OUT nocopy varchar2)
2377: IS
2378: l_u_instance_rec csi_datastructures_pub.instance_rec;
2379: l_u_parties_tbl csi_datastructures_pub.party_tbl;
2380: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2381: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2382: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 2379: l_u_parties_tbl csi_datastructures_pub.party_tbl;

2375: p_transaction_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
2376: x_return_status OUT nocopy varchar2)
2377: IS
2378: l_u_instance_rec csi_datastructures_pub.instance_rec;
2379: l_u_parties_tbl csi_datastructures_pub.party_tbl;
2380: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2381: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2382: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2383: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 2380: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

2376: x_return_status OUT nocopy varchar2)
2377: IS
2378: l_u_instance_rec csi_datastructures_pub.instance_rec;
2379: l_u_parties_tbl csi_datastructures_pub.party_tbl;
2380: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2381: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2382: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2383: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2384: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;

Line 2381: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;

2377: IS
2378: l_u_instance_rec csi_datastructures_pub.instance_rec;
2379: l_u_parties_tbl csi_datastructures_pub.party_tbl;
2380: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2381: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2382: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2383: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2384: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2385: l_instance_ids_list csi_datastructures_pub.id_tbl;

Line 2382: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

2378: l_u_instance_rec csi_datastructures_pub.instance_rec;
2379: l_u_parties_tbl csi_datastructures_pub.party_tbl;
2380: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2381: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2382: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2383: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2384: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2385: l_instance_ids_list csi_datastructures_pub.id_tbl;
2386:

Line 2383: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

2379: l_u_parties_tbl csi_datastructures_pub.party_tbl;
2380: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2381: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2382: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2383: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2384: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2385: l_instance_ids_list csi_datastructures_pub.id_tbl;
2386:
2387: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 2384: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;

2380: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2381: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2382: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2383: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2384: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2385: l_instance_ids_list csi_datastructures_pub.id_tbl;
2386:
2387: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2388: l_msg_count number;

Line 2385: l_instance_ids_list csi_datastructures_pub.id_tbl;

2381: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2382: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2383: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2384: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2385: l_instance_ids_list csi_datastructures_pub.id_tbl;
2386:
2387: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2388: l_msg_count number;
2389: l_msg_data varchar2(2000);

Line 2444: p_instance_rec IN csi_datastructures_pub.instance_rec,

2440: END unexpire_instance;
2441:
2442: PROCEDURE preserve_ownership(
2443: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,
2444: p_instance_rec IN csi_datastructures_pub.instance_rec,
2445: px_parties_tbl IN OUT nocopy csi_datastructures_pub.party_tbl,
2446: px_pty_accts_tbl IN OUT nocopy csi_datastructures_pub.party_account_tbl,
2447: x_return_status OUT nocopy varchar2)
2448: IS

Line 2445: px_parties_tbl IN OUT nocopy csi_datastructures_pub.party_tbl,

2441:
2442: PROCEDURE preserve_ownership(
2443: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,
2444: p_instance_rec IN csi_datastructures_pub.instance_rec,
2445: px_parties_tbl IN OUT nocopy csi_datastructures_pub.party_tbl,
2446: px_pty_accts_tbl IN OUT nocopy csi_datastructures_pub.party_account_tbl,
2447: x_return_status OUT nocopy varchar2)
2448: IS
2449: l_internal_party_id number;

Line 2446: px_pty_accts_tbl IN OUT nocopy csi_datastructures_pub.party_account_tbl,

2442: PROCEDURE preserve_ownership(
2443: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,
2444: p_instance_rec IN csi_datastructures_pub.instance_rec,
2445: px_parties_tbl IN OUT nocopy csi_datastructures_pub.party_tbl,
2446: px_pty_accts_tbl IN OUT nocopy csi_datastructures_pub.party_account_tbl,
2447: x_return_status OUT nocopy varchar2)
2448: IS
2449: l_internal_party_id number;
2450: l_parties_tbl csi_datastructures_pub.party_tbl;

Line 2450: l_parties_tbl csi_datastructures_pub.party_tbl;

2446: px_pty_accts_tbl IN OUT nocopy csi_datastructures_pub.party_account_tbl,
2447: x_return_status OUT nocopy varchar2)
2448: IS
2449: l_internal_party_id number;
2450: l_parties_tbl csi_datastructures_pub.party_tbl;
2451: l_p_ind binary_integer := 0;
2452: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2453: l_pa_ind binary_integer := 0;
2454: BEGIN

Line 2452: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

2448: IS
2449: l_internal_party_id number;
2450: l_parties_tbl csi_datastructures_pub.party_tbl;
2451: l_p_ind binary_integer := 0;
2452: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2453: l_pa_ind binary_integer := 0;
2454: BEGIN
2455:
2456: x_return_status := fnd_api.g_ret_sts_success;

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

2455:
2456: x_return_status := fnd_api.g_ret_sts_success;
2457: api_log('preserve_ownership');
2458:
2459: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
2460:
2461: IF nvl(p_instance_rec.instance_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
2462:
2463: IF p_item_attr_rec.src_serial_control_flag = 'Y' AND

Line 2565: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

2561: p_ext_attrib_vals_tbl IN OUT NOCOPY csi_process_txn_grp.txn_ext_attrib_values_tbl,
2562: p_pricing_attribs_tbl IN OUT NOCOPY csi_process_txn_grp.txn_pricing_attribs_tbl,
2563: p_org_units_tbl IN OUT NOCOPY csi_process_txn_grp.txn_org_units_tbl,
2564: p_instance_asset_tbl IN OUT NOCOPY csi_process_txn_grp.txn_instance_asset_tbl,
2565: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
2566: px_txn_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,
2567: x_return_status OUT NOCOPY varchar2)
2568:
2569: IS

Line 2566: px_txn_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,

2562: p_pricing_attribs_tbl IN OUT NOCOPY csi_process_txn_grp.txn_pricing_attribs_tbl,
2563: p_org_units_tbl IN OUT NOCOPY csi_process_txn_grp.txn_org_units_tbl,
2564: p_instance_asset_tbl IN OUT NOCOPY csi_process_txn_grp.txn_instance_asset_tbl,
2565: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
2566: px_txn_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,
2567: x_return_status OUT NOCOPY varchar2)
2568:
2569: IS
2570:

Line 2573: l_transaction_rec csi_datastructures_pub.transaction_rec;

2569: IS
2570:
2571: l_process_mode varchar2(20);
2572:
2573: l_transaction_rec csi_datastructures_pub.transaction_rec;
2574: l_instance_rec csi_datastructures_pub.instance_rec;
2575: l_parties_tbl csi_datastructures_pub.party_tbl;
2576: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2577: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;

Line 2574: l_instance_rec csi_datastructures_pub.instance_rec;

2570:
2571: l_process_mode varchar2(20);
2572:
2573: l_transaction_rec csi_datastructures_pub.transaction_rec;
2574: l_instance_rec csi_datastructures_pub.instance_rec;
2575: l_parties_tbl csi_datastructures_pub.party_tbl;
2576: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2577: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2578: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 2575: l_parties_tbl csi_datastructures_pub.party_tbl;

2571: l_process_mode varchar2(20);
2572:
2573: l_transaction_rec csi_datastructures_pub.transaction_rec;
2574: l_instance_rec csi_datastructures_pub.instance_rec;
2575: l_parties_tbl csi_datastructures_pub.party_tbl;
2576: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2577: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2578: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2579: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 2576: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

2572:
2573: l_transaction_rec csi_datastructures_pub.transaction_rec;
2574: l_instance_rec csi_datastructures_pub.instance_rec;
2575: l_parties_tbl csi_datastructures_pub.party_tbl;
2576: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2577: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2578: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2579: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2580: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;

Line 2577: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;

2573: l_transaction_rec csi_datastructures_pub.transaction_rec;
2574: l_instance_rec csi_datastructures_pub.instance_rec;
2575: l_parties_tbl csi_datastructures_pub.party_tbl;
2576: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2577: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2578: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2579: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2580: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2581: l_systems_tbl csi_datastructures_pub.systems_tbl;

Line 2578: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

2574: l_instance_rec csi_datastructures_pub.instance_rec;
2575: l_parties_tbl csi_datastructures_pub.party_tbl;
2576: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2577: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2578: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2579: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2580: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2581: l_systems_tbl csi_datastructures_pub.systems_tbl;
2582:

Line 2579: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

2575: l_parties_tbl csi_datastructures_pub.party_tbl;
2576: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2577: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2578: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2579: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2580: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2581: l_systems_tbl csi_datastructures_pub.systems_tbl;
2582:
2583: l_dest_instance_id number;

Line 2580: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;

2576: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2577: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2578: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2579: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2580: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2581: l_systems_tbl csi_datastructures_pub.systems_tbl;
2582:
2583: l_dest_instance_id number;
2584: l_src_instance_id number;

Line 2581: l_systems_tbl csi_datastructures_pub.systems_tbl;

2577: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2578: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2579: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2580: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2581: l_systems_tbl csi_datastructures_pub.systems_tbl;
2582:
2583: l_dest_instance_id number;
2584: l_src_instance_id number;
2585: l_returned_instance_id number;

Line 2586: l_instance_ids_list csi_datastructures_pub.id_tbl;

2582:
2583: l_dest_instance_id number;
2584: l_src_instance_id number;
2585: l_returned_instance_id number;
2586: l_instance_ids_list csi_datastructures_pub.id_tbl;
2587: l_location_type_code varchar2(30);
2588: l_instance_usage_code varchar2(30);
2589:
2590: l_object_version_number number;

Line 2598: l_dummy_instance_rec csi_datastructures_pub.instance_rec;

2594: l_mfg_serial_number_flag varchar2(1);
2595: l_active_end_date date;
2596: l_owner_party_account_id number;
2597:
2598: l_dummy_instance_rec csi_datastructures_pub.instance_rec;
2599:
2600: l_u_instance_rec csi_datastructures_pub.instance_rec;
2601: l_u_parties_tbl csi_datastructures_pub.party_tbl;
2602: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

Line 2600: l_u_instance_rec csi_datastructures_pub.instance_rec;

2596: l_owner_party_account_id number;
2597:
2598: l_dummy_instance_rec csi_datastructures_pub.instance_rec;
2599:
2600: l_u_instance_rec csi_datastructures_pub.instance_rec;
2601: l_u_parties_tbl csi_datastructures_pub.party_tbl;
2602: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2603: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2604: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 2601: l_u_parties_tbl csi_datastructures_pub.party_tbl;

2597:
2598: l_dummy_instance_rec csi_datastructures_pub.instance_rec;
2599:
2600: l_u_instance_rec csi_datastructures_pub.instance_rec;
2601: l_u_parties_tbl csi_datastructures_pub.party_tbl;
2602: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2603: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2604: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2605: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 2602: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

2598: l_dummy_instance_rec csi_datastructures_pub.instance_rec;
2599:
2600: l_u_instance_rec csi_datastructures_pub.instance_rec;
2601: l_u_parties_tbl csi_datastructures_pub.party_tbl;
2602: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2603: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2604: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2605: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2606: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;

Line 2603: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;

2599:
2600: l_u_instance_rec csi_datastructures_pub.instance_rec;
2601: l_u_parties_tbl csi_datastructures_pub.party_tbl;
2602: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2603: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2604: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2605: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2606: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2607: l_u_systems_tbl csi_datastructures_pub.systems_tbl;

Line 2604: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

2600: l_u_instance_rec csi_datastructures_pub.instance_rec;
2601: l_u_parties_tbl csi_datastructures_pub.party_tbl;
2602: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2603: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2604: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2605: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2606: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2607: l_u_systems_tbl csi_datastructures_pub.systems_tbl;
2608:

Line 2605: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

2601: l_u_parties_tbl csi_datastructures_pub.party_tbl;
2602: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2603: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2604: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2605: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2606: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2607: l_u_systems_tbl csi_datastructures_pub.systems_tbl;
2608:
2609: l_config_return varchar2(1) := 'N';

Line 2606: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;

2602: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2603: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2604: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2605: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2606: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2607: l_u_systems_tbl csi_datastructures_pub.systems_tbl;
2608:
2609: l_config_return varchar2(1) := 'N';
2610:

Line 2607: l_u_systems_tbl csi_datastructures_pub.systems_tbl;

2603: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2604: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2605: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2606: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2607: l_u_systems_tbl csi_datastructures_pub.systems_tbl;
2608:
2609: l_config_return varchar2(1) := 'N';
2610:
2611: l_current_procedure varchar2(30);

Line 3708: l_parties_tbl(1).party_id := csi_datastructures_pub.g_install_param_rec.Internal_Party_Id;

3704: l_instance_rec.inv_organization_id := p_instance_rec.inv_organization_id;
3705: l_instance_rec.inv_subinventory_name := p_instance_rec.inv_subinventory_name;
3706:
3707: l_parties_tbl(1).party_source_table := 'HZ_PARTIES' ;
3708: l_parties_tbl(1).party_id := csi_datastructures_pub.g_install_param_rec.Internal_Party_Id;
3709: l_parties_tbl(1).relationship_type_code := 'OWNER';
3710: l_parties_tbl(1).contact_flag := 'N';
3711: -- Serial Tagging
3712: -- Bug 10049662 Added 72 Transaction type id for WIP return

Line 3718: l_parties_tbl(1).party_id := csi_datastructures_pub.g_install_param_rec.Internal_Party_Id;

3714: --l_instance_rec.inv_organization_id := p_instance_rec.inv_organization_id;
3715: --l_instance_rec.inv_subinventory_name := p_instance_rec.inv_subinventory_name;
3716:
3717: l_parties_tbl(1).party_source_table := 'HZ_PARTIES' ;
3718: l_parties_tbl(1).party_id := csi_datastructures_pub.g_install_param_rec.Internal_Party_Id;
3719: l_parties_tbl(1).relationship_type_code := 'OWNER';
3720: l_parties_tbl(1).contact_flag := 'N';
3721: END IF;
3722:

Line 4203: x_ii_rltns_rec OUT NOCOPY csi_datastructures_pub.ii_relationship_rec,

4199:
4200: PROCEDURE build_ii_rltns_rec(
4201: p_txn_ii_rltns_rec IN csi_process_txn_grp.txn_ii_relationship_rec,
4202: p_instances_tbl IN csi_process_txn_grp.txn_instances_tbl,
4203: x_ii_rltns_rec OUT NOCOPY csi_datastructures_pub.ii_relationship_rec,
4204: x_return_status OUT NOCOPY varchar2)
4205: IS
4206:
4207: l_ii_rltns_rec csi_datastructures_pub.ii_relationship_rec;

Line 4207: l_ii_rltns_rec csi_datastructures_pub.ii_relationship_rec;

4203: x_ii_rltns_rec OUT NOCOPY csi_datastructures_pub.ii_relationship_rec,
4204: x_return_status OUT NOCOPY varchar2)
4205: IS
4206:
4207: l_ii_rltns_rec csi_datastructures_pub.ii_relationship_rec;
4208:
4209: l_obj_ind binary_integer;
4210: l_sub_ind binary_integer;
4211: l_sub_inst_id number;

Line 4285: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

4281:
4282: PROCEDURE process_relation(
4283: p_instances_tbl IN csi_process_txn_grp.txn_instances_tbl,
4284: p_ii_relationships_tbl IN csi_process_txn_grp.txn_ii_relationships_tbl,
4285: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
4286: x_return_status OUT NOCOPY varchar2)
4287: IS
4288:
4289: l_ii_rltns_rec csi_datastructures_pub.ii_relationship_rec;

Line 4289: l_ii_rltns_rec csi_datastructures_pub.ii_relationship_rec;

4285: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
4286: x_return_status OUT NOCOPY varchar2)
4287: IS
4288:
4289: l_ii_rltns_rec csi_datastructures_pub.ii_relationship_rec;
4290: l_comp_iir_tbl csi_datastructures_pub.ii_relationship_tbl;
4291: l_comp_ind binary_integer := 0;
4292:
4293: l_oth_iir_tbl csi_datastructures_pub.ii_relationship_tbl;

Line 4290: l_comp_iir_tbl csi_datastructures_pub.ii_relationship_tbl;

4286: x_return_status OUT NOCOPY varchar2)
4287: IS
4288:
4289: l_ii_rltns_rec csi_datastructures_pub.ii_relationship_rec;
4290: l_comp_iir_tbl csi_datastructures_pub.ii_relationship_tbl;
4291: l_comp_ind binary_integer := 0;
4292:
4293: l_oth_iir_tbl csi_datastructures_pub.ii_relationship_tbl;
4294: l_oth_ind binary_integer := 0;

Line 4293: l_oth_iir_tbl csi_datastructures_pub.ii_relationship_tbl;

4289: l_ii_rltns_rec csi_datastructures_pub.ii_relationship_rec;
4290: l_comp_iir_tbl csi_datastructures_pub.ii_relationship_tbl;
4291: l_comp_ind binary_integer := 0;
4292:
4293: l_oth_iir_tbl csi_datastructures_pub.ii_relationship_tbl;
4294: l_oth_ind binary_integer := 0;
4295:
4296: l_current_procedure varchar2(30);
4297: l_return_status varchar2(1);

Line 4401: p_csi_txn_rec in OUT NOCOPY csi_datastructures_pub.transaction_rec,

4397: --Non RMA txns . shegde. Bug 2443204
4398:
4399: PROCEDURE check_and_break_relation(
4400: p_instance_id in number,
4401: p_csi_txn_rec in OUT NOCOPY csi_datastructures_pub.transaction_rec,
4402: x_return_status OUT NOCOPY varchar2)
4403: IS
4404: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;
4405: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;

Line 4404: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;

4400: p_instance_id in number,
4401: p_csi_txn_rec in OUT NOCOPY csi_datastructures_pub.transaction_rec,
4402: x_return_status OUT NOCOPY varchar2)
4403: IS
4404: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;
4405: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
4406: l_time_stamp date := null;
4407:
4408: l_exp_relationship_rec csi_datastructures_pub.ii_relationship_rec;

Line 4405: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;

4401: p_csi_txn_rec in OUT NOCOPY csi_datastructures_pub.transaction_rec,
4402: x_return_status OUT NOCOPY varchar2)
4403: IS
4404: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;
4405: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
4406: l_time_stamp date := null;
4407:
4408: l_exp_relationship_rec csi_datastructures_pub.ii_relationship_rec;
4409: l_instance_id_lst csi_datastructures_pub.id_tbl;

Line 4408: l_exp_relationship_rec csi_datastructures_pub.ii_relationship_rec;

4404: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;
4405: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
4406: l_time_stamp date := null;
4407:
4408: l_exp_relationship_rec csi_datastructures_pub.ii_relationship_rec;
4409: l_instance_id_lst csi_datastructures_pub.id_tbl;
4410:
4411: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4412: l_msg_count number := 0;

Line 4409: l_instance_id_lst csi_datastructures_pub.id_tbl;

4405: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
4406: l_time_stamp date := null;
4407:
4408: l_exp_relationship_rec csi_datastructures_pub.ii_relationship_rec;
4409: l_instance_id_lst csi_datastructures_pub.id_tbl;
4410:
4411: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4412: l_msg_count number := 0;
4413: l_msg_data varchar2(2000);