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 232: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;

228: p_api_name => 'validate_owner_reference');
229:
230: x_return_status := fnd_api.g_ret_sts_success;
231:
232: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
233:
234: IF p_txn_instances_tbl.COUNT > 0 THEN
235: FOR l_i_ind IN p_txn_instances_tbl.FIRST .. p_txn_instances_tbl.LAST
236: LOOP

Line 612: x_instance_query_rec OUT NOCOPY csi_datastructures_pub.instance_query_rec,

608: p_sub_type_rec IN csi_txn_sub_types%rowtype,
609: p_instance_rec IN csi_process_txn_grp.txn_instance_rec,
610: p_dest_location_rec IN csi_process_txn_grp.dest_location_rec,
611: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,
612: x_instance_query_rec OUT NOCOPY csi_datastructures_pub.instance_query_rec,
613: x_return_status OUT NOCOPY varchar2)
614: IS
615:
616: l_inst_query_rec csi_datastructures_pub.instance_query_rec;

Line 616: l_inst_query_rec csi_datastructures_pub.instance_query_rec;

612: x_instance_query_rec OUT NOCOPY csi_datastructures_pub.instance_query_rec,
613: x_return_status OUT NOCOPY varchar2)
614: IS
615:
616: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
617:
618: BEGIN
619:
620: x_return_status := fnd_api.g_ret_sts_success;

Line 723: p_txn_rec in OUT NOCOPY csi_datastructures_pub.transaction_rec,

719: END get_negative_code;
720:
721: PROCEDURE create_zero_qty_instance(
722: p_instance_rec in csi_process_txn_grp.txn_instance_rec,
723: p_txn_rec in OUT NOCOPY csi_datastructures_pub.transaction_rec,
724: x_instance_id OUT NOCOPY number,
725: x_return_status OUT NOCOPY varchar2)
726: IS
727:

Line 728: l_transaction_rec csi_datastructures_pub.transaction_rec;

724: x_instance_id OUT NOCOPY number,
725: x_return_status OUT NOCOPY varchar2)
726: IS
727:
728: l_transaction_rec csi_datastructures_pub.transaction_rec;
729: l_instance_rec csi_datastructures_pub.instance_rec;
730: l_parties_tbl csi_datastructures_pub.party_tbl;
731: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
732: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;

Line 729: l_instance_rec csi_datastructures_pub.instance_rec;

725: x_return_status OUT NOCOPY varchar2)
726: IS
727:
728: l_transaction_rec csi_datastructures_pub.transaction_rec;
729: l_instance_rec csi_datastructures_pub.instance_rec;
730: l_parties_tbl csi_datastructures_pub.party_tbl;
731: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
732: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
733: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 730: l_parties_tbl csi_datastructures_pub.party_tbl;

726: IS
727:
728: l_transaction_rec csi_datastructures_pub.transaction_rec;
729: l_instance_rec csi_datastructures_pub.instance_rec;
730: l_parties_tbl csi_datastructures_pub.party_tbl;
731: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
732: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
733: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
734: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 731: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

727:
728: l_transaction_rec csi_datastructures_pub.transaction_rec;
729: l_instance_rec csi_datastructures_pub.instance_rec;
730: l_parties_tbl csi_datastructures_pub.party_tbl;
731: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
732: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
733: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
734: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
735: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;

Line 732: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;

728: l_transaction_rec csi_datastructures_pub.transaction_rec;
729: l_instance_rec csi_datastructures_pub.instance_rec;
730: l_parties_tbl csi_datastructures_pub.party_tbl;
731: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
732: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
733: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
734: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
735: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
736:

Line 733: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

729: l_instance_rec csi_datastructures_pub.instance_rec;
730: l_parties_tbl csi_datastructures_pub.party_tbl;
731: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
732: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
733: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
734: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
735: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
736:
737: l_internal_party_id number;

Line 734: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

730: l_parties_tbl csi_datastructures_pub.party_tbl;
731: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
732: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
733: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
734: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
735: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
736:
737: l_internal_party_id number;
738:

Line 735: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;

731: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
732: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
733: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
734: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
735: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
736:
737: l_internal_party_id number;
738:
739: l_u_instance_rec csi_datastructures_pub.instance_rec;

Line 739: l_u_instance_rec csi_datastructures_pub.instance_rec;

735: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
736:
737: l_internal_party_id number;
738:
739: l_u_instance_rec csi_datastructures_pub.instance_rec;
740: l_u_parties_tbl csi_datastructures_pub.party_tbl;
741: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
742: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
743: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 740: l_u_parties_tbl csi_datastructures_pub.party_tbl;

736:
737: l_internal_party_id number;
738:
739: l_u_instance_rec csi_datastructures_pub.instance_rec;
740: l_u_parties_tbl csi_datastructures_pub.party_tbl;
741: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
742: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
743: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
744: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 741: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

737: l_internal_party_id number;
738:
739: l_u_instance_rec csi_datastructures_pub.instance_rec;
740: l_u_parties_tbl csi_datastructures_pub.party_tbl;
741: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
742: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
743: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
744: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
745: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;

Line 742: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;

738:
739: l_u_instance_rec csi_datastructures_pub.instance_rec;
740: l_u_parties_tbl csi_datastructures_pub.party_tbl;
741: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
742: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
743: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
744: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
745: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
746: l_instance_ids_list csi_datastructures_pub.id_tbl;

Line 743: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

739: l_u_instance_rec csi_datastructures_pub.instance_rec;
740: l_u_parties_tbl csi_datastructures_pub.party_tbl;
741: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
742: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
743: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
744: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
745: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
746: l_instance_ids_list csi_datastructures_pub.id_tbl;
747:

Line 744: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

740: l_u_parties_tbl csi_datastructures_pub.party_tbl;
741: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
742: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
743: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
744: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
745: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
746: l_instance_ids_list csi_datastructures_pub.id_tbl;
747:
748: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 745: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;

741: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
742: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
743: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
744: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
745: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
746: l_instance_ids_list csi_datastructures_pub.id_tbl;
747:
748: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
749: l_msg_count number;

Line 746: l_instance_ids_list csi_datastructures_pub.id_tbl;

742: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
743: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
744: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
745: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
746: l_instance_ids_list csi_datastructures_pub.id_tbl;
747:
748: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
749: l_msg_count number;
750: l_msg_data varchar2(2000);

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

753: x_return_status := fnd_api.g_ret_sts_success;
754:
755: api_log('create_zero_qty_instance');
756:
757: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
758:
759: l_instance_rec.inventory_item_id := p_instance_rec.inventory_item_id;
760: l_instance_rec.inventory_revision := p_instance_rec.inventory_revision;
761: l_instance_rec.inv_subinventory_name := p_instance_rec.inv_subinventory_name;

Line 877: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

873: p_sub_type_rec IN csi_txn_sub_types%rowtype,
874: p_instance_rec IN csi_process_txn_grp.txn_instance_rec,
875: p_dest_location_rec IN csi_process_txn_grp.dest_location_rec,
876: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,
877: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
878: x_instance_id OUT NOCOPY number,
879: x_return_status OUT NOCOPY varchar2)
880: IS
881:

Line 882: l_instance_query_rec csi_datastructures_pub.instance_query_rec;

878: x_instance_id OUT NOCOPY number,
879: x_return_status OUT NOCOPY varchar2)
880: IS
881:
882: l_instance_query_rec csi_datastructures_pub.instance_query_rec;
883: l_party_query_rec csi_datastructures_pub.party_query_rec;
884: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
885:
886: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;

Line 883: l_party_query_rec csi_datastructures_pub.party_query_rec;

879: x_return_status OUT NOCOPY varchar2)
880: IS
881:
882: l_instance_query_rec csi_datastructures_pub.instance_query_rec;
883: l_party_query_rec csi_datastructures_pub.party_query_rec;
884: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
885:
886: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;
887: l_change_owner varchar2(1);

Line 884: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;

880: IS
881:
882: l_instance_query_rec csi_datastructures_pub.instance_query_rec;
883: l_party_query_rec csi_datastructures_pub.party_query_rec;
884: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
885:
886: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;
887: l_change_owner varchar2(1);
888: l_owner_to_code varchar2(1);

Line 886: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;

882: l_instance_query_rec csi_datastructures_pub.instance_query_rec;
883: l_party_query_rec csi_datastructures_pub.party_query_rec;
884: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
885:
886: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;
887: l_change_owner varchar2(1);
888: l_owner_to_code varchar2(1);
889: l_negative_code number;
890: l_pty_override_flag varchar2(1) := 'N';

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

1028: -- if it is return for repair from customer and item is serialized and
1029: -- the CSI Profile to process the txn is set to 'Y' then a source instance is not required
1030: -- Added this for the ER 2482219. Return for repair
1031:
1032: l_pty_override_flag:= csi_datastructures_pub.g_install_param_rec.ownership_override_at_txn;
1033:
1034: debug(' ownership_override_at_txn : '||l_pty_override_flag);
1035:
1036: IF p_item_attr_rec.src_serial_control_flag = 'Y'

Line 1148: l_instance_query_rec csi_datastructures_pub.instance_query_rec;

1144: x_return_status OUT NOCOPY varchar2)
1145:
1146: IS
1147:
1148: l_instance_query_rec csi_datastructures_pub.instance_query_rec;
1149: l_party_query_rec csi_datastructures_pub.party_query_rec;
1150: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1151:
1152: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;

Line 1149: l_party_query_rec csi_datastructures_pub.party_query_rec;

1145:
1146: IS
1147:
1148: l_instance_query_rec csi_datastructures_pub.instance_query_rec;
1149: l_party_query_rec csi_datastructures_pub.party_query_rec;
1150: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1151:
1152: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;
1153: l_change_owner varchar2(1);

Line 1150: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;

1146: IS
1147:
1148: l_instance_query_rec csi_datastructures_pub.instance_query_rec;
1149: l_party_query_rec csi_datastructures_pub.party_query_rec;
1150: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1151:
1152: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;
1153: l_change_owner varchar2(1);
1154: l_owner_to_code varchar2(1);

Line 1152: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;

1148: l_instance_query_rec csi_datastructures_pub.instance_query_rec;
1149: l_party_query_rec csi_datastructures_pub.party_query_rec;
1150: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1151:
1152: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;
1153: l_change_owner varchar2(1);
1154: l_owner_to_code varchar2(1);
1155:
1156: instance_not_found exception;

Line 1256: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,

1252: p_sub_type_rec IN csi_txn_sub_types%rowtype,
1253: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,
1254: p_instance_rec IN csi_process_txn_grp.txn_instance_rec,
1255: p_dest_location_rec IN csi_process_txn_grp.dest_location_rec,
1256: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,
1257: x_process_mode OUT NOCOPY varchar2,
1258: x_return_status OUT NOCOPY varchar2)
1259: IS
1260: l_instance_rec csi_datastructures_pub.instance_rec;

Line 1260: l_instance_rec csi_datastructures_pub.instance_rec;

1256: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,
1257: x_process_mode OUT NOCOPY varchar2,
1258: x_return_status OUT NOCOPY varchar2)
1259: IS
1260: l_instance_rec csi_datastructures_pub.instance_rec;
1261: l_process_mode varchar2(30);
1262: BEGIN
1263:
1264: x_return_status := fnd_api.g_ret_sts_success;

Line 1386: x_parties_tbl OUT NOCOPY csi_datastructures_pub.party_tbl,

1382: PROCEDURE build_parties_for_index(
1383: p_instance_index IN binary_integer,
1384: p_i_parties_tbl IN csi_process_txn_grp.txn_i_parties_tbl,
1385: p_ip_accounts_tbl IN csi_process_txn_grp.txn_ip_accounts_tbl,
1386: x_parties_tbl OUT NOCOPY csi_datastructures_pub.party_tbl,
1387: x_pty_accts_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
1388: x_return_status OUT NOCOPY varchar2)
1389: IS
1390:

Line 1387: x_pty_accts_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,

1383: p_instance_index IN binary_integer,
1384: p_i_parties_tbl IN csi_process_txn_grp.txn_i_parties_tbl,
1385: p_ip_accounts_tbl IN csi_process_txn_grp.txn_ip_accounts_tbl,
1386: x_parties_tbl OUT NOCOPY csi_datastructures_pub.party_tbl,
1387: x_pty_accts_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
1388: x_return_status OUT NOCOPY varchar2)
1389: IS
1390:
1391: c_ind binary_integer;

Line 1394: l_pty_tbl csi_datastructures_pub.party_tbl;

1390:
1391: c_ind binary_integer;
1392: c_a_ind binary_integer;
1393:
1394: l_pty_tbl csi_datastructures_pub.party_tbl;
1395: l_pty_acct_tbl csi_datastructures_pub.party_account_tbl;
1396:
1397: BEGIN
1398:

Line 1395: l_pty_acct_tbl csi_datastructures_pub.party_account_tbl;

1391: c_ind binary_integer;
1392: c_a_ind binary_integer;
1393:
1394: l_pty_tbl csi_datastructures_pub.party_tbl;
1395: l_pty_acct_tbl csi_datastructures_pub.party_account_tbl;
1396:
1397: BEGIN
1398:
1399: c_ind := 0;

Line 1506: x_ea_values_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,

1502:
1503: PROCEDURE build_ext_vals_for_index(
1504: p_instance_index IN binary_integer,
1505: p_ext_attrib_vals_tbl IN csi_process_txn_grp.txn_ext_attrib_values_tbl,
1506: x_ea_values_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
1507: x_return_status OUT NOCOPY varchar2)
1508: IS
1509: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1510: c_ind binary_integer;

Line 1509: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;

1505: p_ext_attrib_vals_tbl IN csi_process_txn_grp.txn_ext_attrib_values_tbl,
1506: x_ea_values_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
1507: x_return_status OUT NOCOPY varchar2)
1508: IS
1509: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1510: c_ind binary_integer;
1511: BEGIN
1512: c_ind :=0;
1513:

Line 1567: x_pricing_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,

1563:
1564: PROCEDURE build_price_tbl_for_index(
1565: p_instance_index IN binary_integer,
1566: p_pricing_attribs_tbl IN csi_process_txn_grp.txn_pricing_attribs_tbl,
1567: x_pricing_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
1568: x_return_status OUT NOCOPY varchar2)
1569: IS
1570: l_price_tbl csi_datastructures_pub.pricing_attribs_tbl;
1571: c_ind binary_integer;

Line 1570: l_price_tbl csi_datastructures_pub.pricing_attribs_tbl;

1566: p_pricing_attribs_tbl IN csi_process_txn_grp.txn_pricing_attribs_tbl,
1567: x_pricing_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
1568: x_return_status OUT NOCOPY varchar2)
1569: IS
1570: l_price_tbl csi_datastructures_pub.pricing_attribs_tbl;
1571: c_ind binary_integer;
1572: BEGIN
1573:
1574: IF p_pricing_attribs_tbl.COUNT > 0 THEN

Line 1726: x_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,

1722:
1723: PROCEDURE build_org_units_for_index(
1724: p_instance_index IN binary_integer,
1725: p_org_units_tbl IN csi_process_txn_grp.txn_org_units_tbl,
1726: x_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
1727: x_return_status OUT NOCOPY varchar2)
1728: IS
1729: c_ind binary_integer;
1730: l_ou_tbl csi_datastructures_pub.organization_units_tbl;

Line 1730: l_ou_tbl csi_datastructures_pub.organization_units_tbl;

1726: x_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
1727: x_return_status OUT NOCOPY varchar2)
1728: IS
1729: c_ind binary_integer;
1730: l_ou_tbl csi_datastructures_pub.organization_units_tbl;
1731: BEGIN
1732:
1733: c_ind := 0;
1734: IF p_org_units_tbl.COUNT > 0 THEN

Line 1787: x_assets_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_tbl,

1783:
1784: PROCEDURE build_assets_for_index(
1785: p_instance_index IN binary_integer,
1786: p_instance_asset_tbl IN csi_process_txn_grp.txn_instance_asset_tbl,
1787: x_assets_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_tbl,
1788: x_return_status OUT NOCOPY varchar2)
1789: IS
1790: c_ind binary_integer;
1791: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;

Line 1791: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;

1787: x_assets_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_tbl,
1788: x_return_status OUT NOCOPY varchar2)
1789: IS
1790: c_ind binary_integer;
1791: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1792: BEGIN
1793: debug('Just in the asset build');
1794: IF p_instance_asset_tbl.COUNT > 0 THEN
1795: FOR l_ind IN p_instance_asset_tbl.FIRST .. p_instance_asset_tbl.LAST

Line 1827: p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,

1823:
1824: PROCEDURE get_ids_for_instance(
1825: p_in_out_flag IN varchar2,
1826: p_sub_type_rec IN csi_txn_sub_types%rowtype,
1827: p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,
1828: p_parties_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl,
1829: p_pty_accts_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,
1830: p_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
1831: p_ea_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,

Line 1828: p_parties_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl,

1824: PROCEDURE get_ids_for_instance(
1825: p_in_out_flag IN varchar2,
1826: p_sub_type_rec IN csi_txn_sub_types%rowtype,
1827: p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,
1828: p_parties_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl,
1829: p_pty_accts_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,
1830: p_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
1831: p_ea_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
1832: p_pricing_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,

Line 1829: p_pty_accts_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,

1825: p_in_out_flag IN varchar2,
1826: p_sub_type_rec IN csi_txn_sub_types%rowtype,
1827: p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,
1828: p_parties_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl,
1829: p_pty_accts_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,
1830: p_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
1831: p_ea_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
1832: p_pricing_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
1833: p_assets_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl,

Line 1830: p_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,

1826: p_sub_type_rec IN csi_txn_sub_types%rowtype,
1827: p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,
1828: p_parties_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl,
1829: p_pty_accts_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,
1830: p_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
1831: p_ea_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
1832: p_pricing_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
1833: p_assets_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl,
1834: x_return_status OUT NOCOPY varchar2)

Line 1831: p_ea_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,

1827: p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,
1828: p_parties_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl,
1829: p_pty_accts_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,
1830: p_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
1831: p_ea_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
1832: p_pricing_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
1833: p_assets_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl,
1834: x_return_status OUT NOCOPY varchar2)
1835: IS

Line 1832: p_pricing_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,

1828: p_parties_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl,
1829: p_pty_accts_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,
1830: p_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
1831: p_ea_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
1832: p_pricing_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
1833: p_assets_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl,
1834: x_return_status OUT NOCOPY varchar2)
1835: IS
1836: l_parties_tbl csi_datastructures_pub.party_tbl;

Line 1833: p_assets_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl,

1829: p_pty_accts_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,
1830: p_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
1831: p_ea_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
1832: p_pricing_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
1833: p_assets_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl,
1834: x_return_status OUT NOCOPY varchar2)
1835: IS
1836: l_parties_tbl csi_datastructures_pub.party_tbl;
1837: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

Line 1836: l_parties_tbl csi_datastructures_pub.party_tbl;

1832: p_pricing_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
1833: p_assets_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl,
1834: x_return_status OUT NOCOPY varchar2)
1835: IS
1836: l_parties_tbl csi_datastructures_pub.party_tbl;
1837: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1838: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1839: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1840: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 1837: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

1833: p_assets_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl,
1834: x_return_status OUT NOCOPY varchar2)
1835: IS
1836: l_parties_tbl csi_datastructures_pub.party_tbl;
1837: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1838: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1839: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1840: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1841: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;

Line 1838: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;

1834: x_return_status OUT NOCOPY varchar2)
1835: IS
1836: l_parties_tbl csi_datastructures_pub.party_tbl;
1837: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1838: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1839: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1840: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1841: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1842:

Line 1839: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

1835: IS
1836: l_parties_tbl csi_datastructures_pub.party_tbl;
1837: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1838: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1839: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1840: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1841: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1842:
1843: l_debug_level number;

Line 1840: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

1836: l_parties_tbl csi_datastructures_pub.party_tbl;
1837: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1838: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1839: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1840: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1841: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1842:
1843: l_debug_level number;
1844: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 1841: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;

1837: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1838: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1839: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1840: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1841: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1842:
1843: l_debug_level number;
1844: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1845: l_msg_count number;

Line 2073: p_parties_tbl OUT NOCOPY csi_datastructures_pub.party_tbl,

2069:
2070:
2071: PROCEDURE get_internal_party_tbl(
2072: p_instance_id IN number,
2073: p_parties_tbl OUT NOCOPY csi_datastructures_pub.party_tbl,
2074: x_return_status OUT NOCOPY varchar2)
2075: IS
2076: l_internal_party_id number;
2077: l_instance_party_id number;

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

2081: x_return_status := fnd_api.g_ret_sts_success;
2082:
2083: api_log('get_internal_party_tbl');
2084:
2085: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
2086:
2087: SELECT instance_party_id,
2088: object_version_number
2089: INTO l_instance_party_id,

Line 2113: p_transaction_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,

2109: -- code modification for 3681856;parameter added to determine whether or not to invoke contracts API
2110: PROCEDURE unexpire_instance(
2111: p_instance_id IN number,
2112: p_call_contracts IN varchar2 := fnd_api.g_true,
2113: p_transaction_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
2114: x_return_status OUT nocopy varchar2)
2115: IS
2116: l_u_instance_rec csi_datastructures_pub.instance_rec;
2117: l_u_parties_tbl csi_datastructures_pub.party_tbl;

Line 2116: l_u_instance_rec csi_datastructures_pub.instance_rec;

2112: p_call_contracts IN varchar2 := fnd_api.g_true,
2113: p_transaction_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
2114: x_return_status OUT nocopy varchar2)
2115: IS
2116: l_u_instance_rec csi_datastructures_pub.instance_rec;
2117: l_u_parties_tbl csi_datastructures_pub.party_tbl;
2118: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2119: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2120: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 2117: l_u_parties_tbl csi_datastructures_pub.party_tbl;

2113: p_transaction_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
2114: x_return_status OUT nocopy varchar2)
2115: IS
2116: l_u_instance_rec csi_datastructures_pub.instance_rec;
2117: l_u_parties_tbl csi_datastructures_pub.party_tbl;
2118: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2119: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2120: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2121: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 2118: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

2114: x_return_status OUT nocopy varchar2)
2115: IS
2116: l_u_instance_rec csi_datastructures_pub.instance_rec;
2117: l_u_parties_tbl csi_datastructures_pub.party_tbl;
2118: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2119: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2120: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2121: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2122: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;

Line 2119: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;

2115: IS
2116: l_u_instance_rec csi_datastructures_pub.instance_rec;
2117: l_u_parties_tbl csi_datastructures_pub.party_tbl;
2118: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2119: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2120: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2121: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2122: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2123: l_instance_ids_list csi_datastructures_pub.id_tbl;

Line 2120: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

2116: l_u_instance_rec csi_datastructures_pub.instance_rec;
2117: l_u_parties_tbl csi_datastructures_pub.party_tbl;
2118: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2119: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2120: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2121: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2122: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2123: l_instance_ids_list csi_datastructures_pub.id_tbl;
2124:

Line 2121: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

2117: l_u_parties_tbl csi_datastructures_pub.party_tbl;
2118: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2119: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2120: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2121: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2122: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2123: l_instance_ids_list csi_datastructures_pub.id_tbl;
2124:
2125: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 2122: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;

2118: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2119: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2120: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2121: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2122: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2123: l_instance_ids_list csi_datastructures_pub.id_tbl;
2124:
2125: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2126: l_msg_count number;

Line 2123: l_instance_ids_list csi_datastructures_pub.id_tbl;

2119: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2120: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2121: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2122: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2123: l_instance_ids_list csi_datastructures_pub.id_tbl;
2124:
2125: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2126: l_msg_count number;
2127: l_msg_data varchar2(2000);

Line 2182: p_instance_rec IN csi_datastructures_pub.instance_rec,

2178: END unexpire_instance;
2179:
2180: PROCEDURE preserve_ownership(
2181: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,
2182: p_instance_rec IN csi_datastructures_pub.instance_rec,
2183: px_parties_tbl IN OUT nocopy csi_datastructures_pub.party_tbl,
2184: px_pty_accts_tbl IN OUT nocopy csi_datastructures_pub.party_account_tbl,
2185: x_return_status OUT nocopy varchar2)
2186: IS

Line 2183: px_parties_tbl IN OUT nocopy csi_datastructures_pub.party_tbl,

2179:
2180: PROCEDURE preserve_ownership(
2181: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,
2182: p_instance_rec IN csi_datastructures_pub.instance_rec,
2183: px_parties_tbl IN OUT nocopy csi_datastructures_pub.party_tbl,
2184: px_pty_accts_tbl IN OUT nocopy csi_datastructures_pub.party_account_tbl,
2185: x_return_status OUT nocopy varchar2)
2186: IS
2187: l_internal_party_id number;

Line 2184: px_pty_accts_tbl IN OUT nocopy csi_datastructures_pub.party_account_tbl,

2180: PROCEDURE preserve_ownership(
2181: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,
2182: p_instance_rec IN csi_datastructures_pub.instance_rec,
2183: px_parties_tbl IN OUT nocopy csi_datastructures_pub.party_tbl,
2184: px_pty_accts_tbl IN OUT nocopy csi_datastructures_pub.party_account_tbl,
2185: x_return_status OUT nocopy varchar2)
2186: IS
2187: l_internal_party_id number;
2188: l_parties_tbl csi_datastructures_pub.party_tbl;

Line 2188: l_parties_tbl csi_datastructures_pub.party_tbl;

2184: px_pty_accts_tbl IN OUT nocopy csi_datastructures_pub.party_account_tbl,
2185: x_return_status OUT nocopy varchar2)
2186: IS
2187: l_internal_party_id number;
2188: l_parties_tbl csi_datastructures_pub.party_tbl;
2189: l_p_ind binary_integer := 0;
2190: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2191: l_pa_ind binary_integer := 0;
2192: BEGIN

Line 2190: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

2186: IS
2187: l_internal_party_id number;
2188: l_parties_tbl csi_datastructures_pub.party_tbl;
2189: l_p_ind binary_integer := 0;
2190: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2191: l_pa_ind binary_integer := 0;
2192: BEGIN
2193:
2194: x_return_status := fnd_api.g_ret_sts_success;

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

2193:
2194: x_return_status := fnd_api.g_ret_sts_success;
2195: api_log('preserve_ownership');
2196:
2197: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
2198:
2199: IF nvl(p_instance_rec.instance_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
2200:
2201: IF p_item_attr_rec.src_serial_control_flag = 'Y' AND

Line 2303: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

2299: p_ext_attrib_vals_tbl IN OUT NOCOPY csi_process_txn_grp.txn_ext_attrib_values_tbl,
2300: p_pricing_attribs_tbl IN OUT NOCOPY csi_process_txn_grp.txn_pricing_attribs_tbl,
2301: p_org_units_tbl IN OUT NOCOPY csi_process_txn_grp.txn_org_units_tbl,
2302: p_instance_asset_tbl IN OUT NOCOPY csi_process_txn_grp.txn_instance_asset_tbl,
2303: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
2304: px_txn_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,
2305: x_return_status OUT NOCOPY varchar2)
2306:
2307: IS

Line 2304: px_txn_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,

2300: p_pricing_attribs_tbl IN OUT NOCOPY csi_process_txn_grp.txn_pricing_attribs_tbl,
2301: p_org_units_tbl IN OUT NOCOPY csi_process_txn_grp.txn_org_units_tbl,
2302: p_instance_asset_tbl IN OUT NOCOPY csi_process_txn_grp.txn_instance_asset_tbl,
2303: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
2304: px_txn_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,
2305: x_return_status OUT NOCOPY varchar2)
2306:
2307: IS
2308:

Line 2311: l_transaction_rec csi_datastructures_pub.transaction_rec;

2307: IS
2308:
2309: l_process_mode varchar2(20);
2310:
2311: l_transaction_rec csi_datastructures_pub.transaction_rec;
2312: l_instance_rec csi_datastructures_pub.instance_rec;
2313: l_parties_tbl csi_datastructures_pub.party_tbl;
2314: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2315: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;

Line 2312: l_instance_rec csi_datastructures_pub.instance_rec;

2308:
2309: l_process_mode varchar2(20);
2310:
2311: l_transaction_rec csi_datastructures_pub.transaction_rec;
2312: l_instance_rec csi_datastructures_pub.instance_rec;
2313: l_parties_tbl csi_datastructures_pub.party_tbl;
2314: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2315: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2316: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 2313: l_parties_tbl csi_datastructures_pub.party_tbl;

2309: l_process_mode varchar2(20);
2310:
2311: l_transaction_rec csi_datastructures_pub.transaction_rec;
2312: l_instance_rec csi_datastructures_pub.instance_rec;
2313: l_parties_tbl csi_datastructures_pub.party_tbl;
2314: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2315: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2316: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2317: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 2314: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

2310:
2311: l_transaction_rec csi_datastructures_pub.transaction_rec;
2312: l_instance_rec csi_datastructures_pub.instance_rec;
2313: l_parties_tbl csi_datastructures_pub.party_tbl;
2314: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2315: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2316: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2317: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2318: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;

Line 2315: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;

2311: l_transaction_rec csi_datastructures_pub.transaction_rec;
2312: l_instance_rec csi_datastructures_pub.instance_rec;
2313: l_parties_tbl csi_datastructures_pub.party_tbl;
2314: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2315: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2316: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2317: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2318: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2319: l_systems_tbl csi_datastructures_pub.systems_tbl;

Line 2316: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

2312: l_instance_rec csi_datastructures_pub.instance_rec;
2313: l_parties_tbl csi_datastructures_pub.party_tbl;
2314: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2315: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2316: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2317: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2318: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2319: l_systems_tbl csi_datastructures_pub.systems_tbl;
2320:

Line 2317: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

2313: l_parties_tbl csi_datastructures_pub.party_tbl;
2314: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2315: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2316: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2317: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2318: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2319: l_systems_tbl csi_datastructures_pub.systems_tbl;
2320:
2321: l_dest_instance_id number;

Line 2318: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;

2314: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2315: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2316: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2317: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2318: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2319: l_systems_tbl csi_datastructures_pub.systems_tbl;
2320:
2321: l_dest_instance_id number;
2322: l_src_instance_id number;

Line 2319: l_systems_tbl csi_datastructures_pub.systems_tbl;

2315: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2316: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2317: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2318: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2319: l_systems_tbl csi_datastructures_pub.systems_tbl;
2320:
2321: l_dest_instance_id number;
2322: l_src_instance_id number;
2323: l_returned_instance_id number;

Line 2324: l_instance_ids_list csi_datastructures_pub.id_tbl;

2320:
2321: l_dest_instance_id number;
2322: l_src_instance_id number;
2323: l_returned_instance_id number;
2324: l_instance_ids_list csi_datastructures_pub.id_tbl;
2325: l_location_type_code varchar2(30);
2326: l_instance_usage_code varchar2(30);
2327:
2328: l_object_version_number number;

Line 2336: l_dummy_instance_rec csi_datastructures_pub.instance_rec;

2332: l_mfg_serial_number_flag varchar2(1);
2333: l_active_end_date date;
2334: l_owner_party_account_id number;
2335:
2336: l_dummy_instance_rec csi_datastructures_pub.instance_rec;
2337:
2338: l_u_instance_rec csi_datastructures_pub.instance_rec;
2339: l_u_parties_tbl csi_datastructures_pub.party_tbl;
2340: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

Line 2338: l_u_instance_rec csi_datastructures_pub.instance_rec;

2334: l_owner_party_account_id number;
2335:
2336: l_dummy_instance_rec csi_datastructures_pub.instance_rec;
2337:
2338: l_u_instance_rec csi_datastructures_pub.instance_rec;
2339: l_u_parties_tbl csi_datastructures_pub.party_tbl;
2340: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2341: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2342: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 2339: l_u_parties_tbl csi_datastructures_pub.party_tbl;

2335:
2336: l_dummy_instance_rec csi_datastructures_pub.instance_rec;
2337:
2338: l_u_instance_rec csi_datastructures_pub.instance_rec;
2339: l_u_parties_tbl csi_datastructures_pub.party_tbl;
2340: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2341: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2342: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2343: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 2340: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

2336: l_dummy_instance_rec csi_datastructures_pub.instance_rec;
2337:
2338: l_u_instance_rec csi_datastructures_pub.instance_rec;
2339: l_u_parties_tbl csi_datastructures_pub.party_tbl;
2340: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2341: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2342: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2343: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2344: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;

Line 2341: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;

2337:
2338: l_u_instance_rec csi_datastructures_pub.instance_rec;
2339: l_u_parties_tbl csi_datastructures_pub.party_tbl;
2340: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2341: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2342: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2343: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2344: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2345: l_u_systems_tbl csi_datastructures_pub.systems_tbl;

Line 2342: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

2338: l_u_instance_rec csi_datastructures_pub.instance_rec;
2339: l_u_parties_tbl csi_datastructures_pub.party_tbl;
2340: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2341: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2342: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2343: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2344: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2345: l_u_systems_tbl csi_datastructures_pub.systems_tbl;
2346:

Line 2343: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

2339: l_u_parties_tbl csi_datastructures_pub.party_tbl;
2340: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2341: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2342: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2343: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2344: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2345: l_u_systems_tbl csi_datastructures_pub.systems_tbl;
2346:
2347: l_config_return varchar2(1) := 'N';

Line 2344: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;

2340: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2341: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2342: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2343: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2344: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2345: l_u_systems_tbl csi_datastructures_pub.systems_tbl;
2346:
2347: l_config_return varchar2(1) := 'N';
2348:

Line 2345: l_u_systems_tbl csi_datastructures_pub.systems_tbl;

2341: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2342: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2343: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2344: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2345: l_u_systems_tbl csi_datastructures_pub.systems_tbl;
2346:
2347: l_config_return varchar2(1) := 'N';
2348:
2349: l_current_procedure varchar2(30);

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

3386: l_instance_rec.inv_organization_id := p_instance_rec.inv_organization_id;
3387: l_instance_rec.inv_subinventory_name := p_instance_rec.inv_subinventory_name;
3388:
3389: l_parties_tbl(1).party_source_table := 'HZ_PARTIES' ;
3390: l_parties_tbl(1).party_id := csi_datastructures_pub.g_install_param_rec.Internal_Party_Id;
3391: l_parties_tbl(1).relationship_type_code := 'OWNER';
3392: l_parties_tbl(1).contact_flag := 'N';
3393: END IF;
3394: END IF;

Line 3839: x_ii_rltns_rec OUT NOCOPY csi_datastructures_pub.ii_relationship_rec,

3835:
3836: PROCEDURE build_ii_rltns_rec(
3837: p_txn_ii_rltns_rec IN csi_process_txn_grp.txn_ii_relationship_rec,
3838: p_instances_tbl IN csi_process_txn_grp.txn_instances_tbl,
3839: x_ii_rltns_rec OUT NOCOPY csi_datastructures_pub.ii_relationship_rec,
3840: x_return_status OUT NOCOPY varchar2)
3841: IS
3842:
3843: l_ii_rltns_rec csi_datastructures_pub.ii_relationship_rec;

Line 3843: l_ii_rltns_rec csi_datastructures_pub.ii_relationship_rec;

3839: x_ii_rltns_rec OUT NOCOPY csi_datastructures_pub.ii_relationship_rec,
3840: x_return_status OUT NOCOPY varchar2)
3841: IS
3842:
3843: l_ii_rltns_rec csi_datastructures_pub.ii_relationship_rec;
3844:
3845: l_obj_ind binary_integer;
3846: l_sub_ind binary_integer;
3847: l_sub_inst_id number;

Line 3921: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

3917:
3918: PROCEDURE process_relation(
3919: p_instances_tbl IN csi_process_txn_grp.txn_instances_tbl,
3920: p_ii_relationships_tbl IN csi_process_txn_grp.txn_ii_relationships_tbl,
3921: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
3922: x_return_status OUT NOCOPY varchar2)
3923: IS
3924:
3925: l_ii_rltns_rec csi_datastructures_pub.ii_relationship_rec;

Line 3925: l_ii_rltns_rec csi_datastructures_pub.ii_relationship_rec;

3921: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
3922: x_return_status OUT NOCOPY varchar2)
3923: IS
3924:
3925: l_ii_rltns_rec csi_datastructures_pub.ii_relationship_rec;
3926: l_comp_iir_tbl csi_datastructures_pub.ii_relationship_tbl;
3927: l_comp_ind binary_integer := 0;
3928:
3929: l_oth_iir_tbl csi_datastructures_pub.ii_relationship_tbl;

Line 3926: l_comp_iir_tbl csi_datastructures_pub.ii_relationship_tbl;

3922: x_return_status OUT NOCOPY varchar2)
3923: IS
3924:
3925: l_ii_rltns_rec csi_datastructures_pub.ii_relationship_rec;
3926: l_comp_iir_tbl csi_datastructures_pub.ii_relationship_tbl;
3927: l_comp_ind binary_integer := 0;
3928:
3929: l_oth_iir_tbl csi_datastructures_pub.ii_relationship_tbl;
3930: l_oth_ind binary_integer := 0;

Line 3929: l_oth_iir_tbl csi_datastructures_pub.ii_relationship_tbl;

3925: l_ii_rltns_rec csi_datastructures_pub.ii_relationship_rec;
3926: l_comp_iir_tbl csi_datastructures_pub.ii_relationship_tbl;
3927: l_comp_ind binary_integer := 0;
3928:
3929: l_oth_iir_tbl csi_datastructures_pub.ii_relationship_tbl;
3930: l_oth_ind binary_integer := 0;
3931:
3932: l_current_procedure varchar2(30);
3933: l_return_status varchar2(1);

Line 4037: p_csi_txn_rec in OUT NOCOPY csi_datastructures_pub.transaction_rec,

4033: --Non RMA txns . shegde. Bug 2443204
4034:
4035: PROCEDURE check_and_break_relation(
4036: p_instance_id in number,
4037: p_csi_txn_rec in OUT NOCOPY csi_datastructures_pub.transaction_rec,
4038: x_return_status OUT NOCOPY varchar2)
4039: IS
4040: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;
4041: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;

Line 4040: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;

4036: p_instance_id in number,
4037: p_csi_txn_rec in OUT NOCOPY csi_datastructures_pub.transaction_rec,
4038: x_return_status OUT NOCOPY varchar2)
4039: IS
4040: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;
4041: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
4042: l_time_stamp date := null;
4043:
4044: l_exp_relationship_rec csi_datastructures_pub.ii_relationship_rec;

Line 4041: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;

4037: p_csi_txn_rec in OUT NOCOPY csi_datastructures_pub.transaction_rec,
4038: x_return_status OUT NOCOPY varchar2)
4039: IS
4040: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;
4041: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
4042: l_time_stamp date := null;
4043:
4044: l_exp_relationship_rec csi_datastructures_pub.ii_relationship_rec;
4045: l_instance_id_lst csi_datastructures_pub.id_tbl;

Line 4044: l_exp_relationship_rec csi_datastructures_pub.ii_relationship_rec;

4040: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;
4041: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
4042: l_time_stamp date := null;
4043:
4044: l_exp_relationship_rec csi_datastructures_pub.ii_relationship_rec;
4045: l_instance_id_lst csi_datastructures_pub.id_tbl;
4046:
4047: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4048: l_msg_count number := 0;

Line 4045: l_instance_id_lst csi_datastructures_pub.id_tbl;

4041: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
4042: l_time_stamp date := null;
4043:
4044: l_exp_relationship_rec csi_datastructures_pub.ii_relationship_rec;
4045: l_instance_id_lst csi_datastructures_pub.id_tbl;
4046:
4047: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4048: l_msg_count number := 0;
4049: l_msg_data varchar2(2000);