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

Line 17: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)

13:
14: PROCEDURE misc_receipt(p_transaction_id IN NUMBER,
15: p_message_id IN NUMBER,
16: x_return_status OUT NOCOPY VARCHAR2,
17: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
18: IS
19:
20: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
21: l_api_name VARCHAR2(100) := 'CSI_INV_TRXS_PKG.MISC_RECEIPT';

Line 34: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;

30: l_object_version_number NUMBER := 1;
31: l_sysdate DATE := SYSDATE;
32: l_master_organization_id NUMBER;
33: l_depreciable VARCHAR2(1);
34: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
35: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
36: l_api_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
37: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
38: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;

Line 35: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

31: l_sysdate DATE := SYSDATE;
32: l_master_organization_id NUMBER;
33: l_depreciable VARCHAR2(1);
34: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
35: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
36: l_api_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
37: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
38: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
39: l_return_status VARCHAR2(1);

Line 36: l_api_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

32: l_master_organization_id NUMBER;
33: l_depreciable VARCHAR2(1);
34: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
35: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
36: l_api_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
37: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
38: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
39: l_return_status VARCHAR2(1);
40: l_error_code VARCHAR2(50);

Line 37: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

33: l_depreciable VARCHAR2(1);
34: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
35: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
36: l_api_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
37: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
38: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
39: l_return_status VARCHAR2(1);
40: l_error_code VARCHAR2(50);
41: l_error_message VARCHAR2(4000);

Line 38: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;

34: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
35: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
36: l_api_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
37: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
38: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
39: l_return_status VARCHAR2(1);
40: l_error_code VARCHAR2(50);
41: l_error_message VARCHAR2(4000);
42: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;

Line 42: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;

38: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
39: l_return_status VARCHAR2(1);
40: l_error_code VARCHAR2(50);
41: l_error_message VARCHAR2(4000);
42: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
43: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
44: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
45: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
46: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;

Line 43: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;

39: l_return_status VARCHAR2(1);
40: l_error_code VARCHAR2(50);
41: l_error_message VARCHAR2(4000);
42: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
43: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
44: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
45: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
46: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
47: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;

Line 44: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;

40: l_error_code VARCHAR2(50);
41: l_error_message VARCHAR2(4000);
42: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
43: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
44: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
45: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
46: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
47: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
48: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;

Line 45: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;

41: l_error_message VARCHAR2(4000);
42: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
43: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
44: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
45: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
46: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
47: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
48: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
49: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;

Line 46: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;

42: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
43: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
44: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
45: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
46: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
47: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
48: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
49: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
50: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;

Line 47: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;

43: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
44: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
45: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
46: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
47: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
48: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
49: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
50: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
51: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;

Line 48: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;

44: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
45: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
46: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
47: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
48: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
49: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
50: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
51: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
52: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 49: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;

45: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
46: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
47: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
48: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
49: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
50: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
51: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
52: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
53: l_fnd_warning VARCHAR2(1) := 'W';

Line 50: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;

46: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
47: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
48: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
49: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
50: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
51: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
52: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
53: l_fnd_warning VARCHAR2(1) := 'W';
54: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

Line 51: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;

47: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
48: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
49: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
50: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
51: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
52: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
53: l_fnd_warning VARCHAR2(1) := 'W';
54: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
55: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

Line 91: l_instance_header_rec csi_datastructures_pub.instance_header_rec;

87: l_owner_party_id NUMBER; --added code for bug #5868111
88: l_redeploy_flag VARCHAR2(1);
89: l_upd_error_instance_id NUMBER := NULL;
90:
91: l_instance_header_rec csi_datastructures_pub.instance_header_rec;
92: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
93: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
94: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
95: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 92: l_party_header_tbl csi_datastructures_pub.party_header_tbl;

88: l_redeploy_flag VARCHAR2(1);
89: l_upd_error_instance_id NUMBER := NULL;
90:
91: l_instance_header_rec csi_datastructures_pub.instance_header_rec;
92: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
93: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
94: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
95: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
96: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 93: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;

89: l_upd_error_instance_id NUMBER := NULL;
90:
91: l_instance_header_rec csi_datastructures_pub.instance_header_rec;
92: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
93: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
94: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
95: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
96: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;
97: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;

Line 94: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;

90:
91: l_instance_header_rec csi_datastructures_pub.instance_header_rec;
92: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
93: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
94: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
95: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
96: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;
97: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
98: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;

Line 95: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;

91: l_instance_header_rec csi_datastructures_pub.instance_header_rec;
92: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
93: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
94: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
95: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
96: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;
97: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
98: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
99:

Line 96: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;

92: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
93: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
94: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
95: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
96: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;
97: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
98: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
99:
100: cursor c_id is

Line 97: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;

93: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
94: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
95: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
96: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;
97: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
98: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
99:
100: cursor c_id is
101: SELECT instance_status_id

Line 98: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;

94: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
95: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
96: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;
97: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
98: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
99:
100: cursor c_id is
101: SELECT instance_status_id
102: FROM csi_instance_statuses

Line 248: l_ownership_party := csi_datastructures_pub.g_install_param_rec.ownership_override_at_txn;

244: debug('The Quantity is: '||l_quantity);
245: debug('The Transaction Status will be - Complete or Pending: '||l_trans_status_code);
246:
247: -- Get Party ownership Flag
248: l_ownership_party := csi_datastructures_pub.g_install_param_rec.ownership_override_at_txn;
249: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id; --added code for bug #5868111
250:
251: debug('Ownership Party FLag is: '||l_ownership_party);
252: debug('Internal Party Id is : '||l_internal_party_id); --added code for bug #5868111

Line 249: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id; --added code for bug #5868111

245: debug('The Transaction Status will be - Complete or Pending: '||l_trans_status_code);
246:
247: -- Get Party ownership Flag
248: l_ownership_party := csi_datastructures_pub.g_install_param_rec.ownership_override_at_txn;
249: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id; --added code for bug #5868111
250:
251: debug('Ownership Party FLag is: '||l_ownership_party);
252: debug('Internal Party Id is : '||l_internal_party_id); --added code for bug #5868111
253:

Line 1130: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)

1126:
1127: PROCEDURE receipt_inventory(p_transaction_id IN NUMBER,
1128: p_message_id IN NUMBER,
1129: x_return_status OUT NOCOPY VARCHAR2,
1130: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
1131: IS
1132:
1133: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
1134: l_api_name VARCHAR2(100) := 'CSI_INV_TRXS_PKG.RECEIPT_INVENTORY';

Line 1147: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;

1143: l_object_version_number NUMBER := 1;
1144: l_sysdate DATE := SYSDATE;
1145: l_master_organization_id NUMBER;
1146: l_depreciable VARCHAR2(1);
1147: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
1148: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1149: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1150: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
1151: l_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

Line 1148: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

1144: l_sysdate DATE := SYSDATE;
1145: l_master_organization_id NUMBER;
1146: l_depreciable VARCHAR2(1);
1147: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
1148: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1149: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1150: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
1151: l_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1152: l_api_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

Line 1149: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

1145: l_master_organization_id NUMBER;
1146: l_depreciable VARCHAR2(1);
1147: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
1148: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1149: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1150: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
1151: l_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1152: l_api_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1153: l_return_status VARCHAR2(1);

Line 1150: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;

1146: l_depreciable VARCHAR2(1);
1147: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
1148: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1149: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1150: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
1151: l_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1152: l_api_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1153: l_return_status VARCHAR2(1);
1154: l_error_code VARCHAR2(50);

Line 1151: l_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

1147: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
1148: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1149: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1150: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
1151: l_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1152: l_api_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1153: l_return_status VARCHAR2(1);
1154: l_error_code VARCHAR2(50);
1155: l_error_message VARCHAR2(4000);

Line 1152: l_api_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

1148: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1149: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1150: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
1151: l_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1152: l_api_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1153: l_return_status VARCHAR2(1);
1154: l_error_code VARCHAR2(50);
1155: l_error_message VARCHAR2(4000);
1156: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;

Line 1156: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;

1152: l_api_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1153: l_return_status VARCHAR2(1);
1154: l_error_code VARCHAR2(50);
1155: l_error_message VARCHAR2(4000);
1156: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
1157: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
1158: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
1159: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1160: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;

Line 1157: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;

1153: l_return_status VARCHAR2(1);
1154: l_error_code VARCHAR2(50);
1155: l_error_message VARCHAR2(4000);
1156: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
1157: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
1158: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
1159: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1160: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1161: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;

Line 1158: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;

1154: l_error_code VARCHAR2(50);
1155: l_error_message VARCHAR2(4000);
1156: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
1157: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
1158: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
1159: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1160: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1161: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
1162: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;

Line 1159: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;

1155: l_error_message VARCHAR2(4000);
1156: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
1157: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
1158: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
1159: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1160: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1161: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
1162: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
1163: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;

Line 1160: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;

1156: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
1157: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
1158: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
1159: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1160: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1161: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
1162: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
1163: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
1164: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;

Line 1161: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;

1157: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
1158: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
1159: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1160: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1161: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
1162: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
1163: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
1164: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
1165: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;

Line 1162: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;

1158: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
1159: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1160: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1161: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
1162: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
1163: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
1164: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
1165: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
1166: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 1163: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;

1159: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1160: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1161: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
1162: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
1163: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
1164: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
1165: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
1166: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1167: l_fnd_warning VARCHAR2(1) := 'W';

Line 1164: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;

1160: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1161: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
1162: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
1163: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
1164: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
1165: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
1166: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1167: l_fnd_warning VARCHAR2(1) := 'W';
1168: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

Line 1165: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;

1161: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
1162: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
1163: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
1164: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
1165: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
1166: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1167: l_fnd_warning VARCHAR2(1) := 'W';
1168: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1169: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1203: l_instance_header_rec csi_datastructures_pub.instance_header_rec;

1199: l_owner_party_id NUMBER; --added code for bug #5868111
1200: l_redeploy_flag VARCHAR2(1);
1201: l_upd_error_instance_id NUMBER := NULL;
1202:
1203: l_instance_header_rec csi_datastructures_pub.instance_header_rec;
1204: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
1205: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
1206: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
1207: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 1204: l_party_header_tbl csi_datastructures_pub.party_header_tbl;

1200: l_redeploy_flag VARCHAR2(1);
1201: l_upd_error_instance_id NUMBER := NULL;
1202:
1203: l_instance_header_rec csi_datastructures_pub.instance_header_rec;
1204: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
1205: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
1206: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
1207: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
1208: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 1205: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;

1201: l_upd_error_instance_id NUMBER := NULL;
1202:
1203: l_instance_header_rec csi_datastructures_pub.instance_header_rec;
1204: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
1205: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
1206: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
1207: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
1208: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1209: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;

Line 1206: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;

1202:
1203: l_instance_header_rec csi_datastructures_pub.instance_header_rec;
1204: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
1205: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
1206: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
1207: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
1208: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1209: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
1210: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;

Line 1207: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;

1203: l_instance_header_rec csi_datastructures_pub.instance_header_rec;
1204: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
1205: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
1206: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
1207: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
1208: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1209: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
1210: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
1211:

Line 1208: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;

1204: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
1205: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
1206: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
1207: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
1208: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1209: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
1210: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
1211:
1212: CURSOR c_po_info (pc_po_distribution_id in number) is

Line 1209: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;

1205: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
1206: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
1207: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
1208: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1209: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
1210: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
1211:
1212: CURSOR c_po_info (pc_po_distribution_id in number) is
1213: SELECT pod.po_header_id po_header_id,

Line 1210: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;

1206: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
1207: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
1208: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1209: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
1210: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
1211:
1212: CURSOR c_po_info (pc_po_distribution_id in number) is
1213: SELECT pod.po_header_id po_header_id,
1214: pod.po_line_id po_line_id,

Line 1313: l_ownership_party := csi_datastructures_pub.g_install_param_rec.ownership_override_at_txn;

1309: l_quantity := 1;
1310: END IF;
1311:
1312: -- Get Party ownership Flag
1313: l_ownership_party := csi_datastructures_pub.g_install_param_rec.ownership_override_at_txn;
1314: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id; --added code for bug #5868111
1315:
1316: debug('Ownership Flag is: '||l_ownership_party);
1317: debug('Internal Party Id is : '||l_internal_party_id); --added code for bug #5868111

Line 1314: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id; --added code for bug #5868111

1310: END IF;
1311:
1312: -- Get Party ownership Flag
1313: l_ownership_party := csi_datastructures_pub.g_install_param_rec.ownership_override_at_txn;
1314: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id; --added code for bug #5868111
1315:
1316: debug('Ownership Flag is: '||l_ownership_party);
1317: debug('Internal Party Id is : '||l_internal_party_id); --added code for bug #5868111
1318:

Line 2115: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)

2111:
2112: PROCEDURE misc_issue(p_transaction_id IN NUMBER,
2113: p_message_id IN NUMBER,
2114: x_return_status OUT NOCOPY VARCHAR2,
2115: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
2116: IS
2117:
2118: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
2119: l_api_name VARCHAR2(100) := 'CSI_INV_TRXS_PKG.MISC_ISSUE';

Line 2131: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;

2127: l_object_version_number NUMBER := 1;
2128: l_sysdate DATE := SYSDATE;
2129: l_master_organization_id NUMBER;
2130: l_depreciable VARCHAR2(1);
2131: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2132: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2133: l_api_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2134: l_api_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2135: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

Line 2132: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

2128: l_sysdate DATE := SYSDATE;
2129: l_master_organization_id NUMBER;
2130: l_depreciable VARCHAR2(1);
2131: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2132: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2133: l_api_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2134: l_api_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2135: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2136: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

Line 2133: l_api_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

2129: l_master_organization_id NUMBER;
2130: l_depreciable VARCHAR2(1);
2131: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2132: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2133: l_api_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2134: l_api_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2135: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2136: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2137: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

Line 2134: l_api_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

2130: l_depreciable VARCHAR2(1);
2131: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2132: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2133: l_api_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2134: l_api_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2135: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2136: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2137: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2138: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;

Line 2135: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

2131: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2132: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2133: l_api_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2134: l_api_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2135: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2136: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2137: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2138: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
2139: l_return_status VARCHAR2(1);

Line 2136: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

2132: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2133: l_api_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2134: l_api_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2135: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2136: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2137: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2138: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
2139: l_return_status VARCHAR2(1);
2140: l_error_code VARCHAR2(50);

Line 2137: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

2133: l_api_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2134: l_api_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2135: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2136: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2137: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2138: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
2139: l_return_status VARCHAR2(1);
2140: l_error_code VARCHAR2(50);
2141: l_error_message VARCHAR2(4000);

Line 2138: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;

2134: l_api_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2135: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2136: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2137: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2138: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
2139: l_return_status VARCHAR2(1);
2140: l_error_code VARCHAR2(50);
2141: l_error_message VARCHAR2(4000);
2142: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;

Line 2142: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;

2138: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
2139: l_return_status VARCHAR2(1);
2140: l_error_code VARCHAR2(50);
2141: l_error_message VARCHAR2(4000);
2142: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
2143: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
2144: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
2145: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2146: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;

Line 2143: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;

2139: l_return_status VARCHAR2(1);
2140: l_error_code VARCHAR2(50);
2141: l_error_message VARCHAR2(4000);
2142: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
2143: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
2144: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
2145: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2146: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2147: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;

Line 2144: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;

2140: l_error_code VARCHAR2(50);
2141: l_error_message VARCHAR2(4000);
2142: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
2143: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
2144: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
2145: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2146: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2147: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2148: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;

Line 2145: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;

2141: l_error_message VARCHAR2(4000);
2142: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
2143: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
2144: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
2145: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2146: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2147: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2148: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
2149: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;

Line 2146: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;

2142: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
2143: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
2144: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
2145: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2146: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2147: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2148: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
2149: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2150: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;

Line 2147: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;

2143: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
2144: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
2145: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2146: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2147: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2148: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
2149: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2150: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
2151: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;

Line 2148: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;

2144: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
2145: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2146: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2147: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2148: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
2149: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2150: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
2151: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
2152: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 2149: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;

2145: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2146: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2147: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2148: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
2149: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2150: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
2151: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
2152: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2153: l_fnd_warning VARCHAR2(1) := 'W';

Line 2150: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;

2146: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2147: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2148: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
2149: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2150: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
2151: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
2152: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2153: l_fnd_warning VARCHAR2(1) := 'W';
2154: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

Line 2151: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;

2147: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2148: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
2149: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2150: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
2151: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
2152: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2153: l_fnd_warning VARCHAR2(1) := 'W';
2154: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
2155: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2791: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)

2787:
2788: PROCEDURE cycle_count(p_transaction_id IN NUMBER,
2789: p_message_id IN NUMBER,
2790: x_return_status OUT NOCOPY VARCHAR2,
2791: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
2792: IS
2793:
2794: l_api_name VARCHAR2(100) := 'CSI_INV_TRXS_PKG.CYCLE_COUNT';
2795: l_return_status VARCHAR2(1);

Line 2804: l_trx_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;

2800: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
2801: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
2802: l_sql_error VARCHAR2(2000);
2803: r_quantity NUMBER := 0;
2804: l_trx_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
2805:
2806: cursor C_QUANTITY is
2807: select transaction_quantity
2808: from mtl_material_transactions

Line 2879: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)

2875:
2876: PROCEDURE physical_inventory(p_transaction_id IN NUMBER,
2877: p_message_id IN NUMBER,
2878: x_return_status OUT NOCOPY VARCHAR2,
2879: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
2880: IS
2881:
2882: l_api_name VARCHAR2(100) := 'CSI_INV_TRXS_PKG.PHYSICAL_INVENTORY';
2883: l_return_status VARCHAR2(1);

Line 2892: l_trx_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;

2888: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
2889: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
2890: l_sql_error VARCHAR2(2000);
2891: r_quantity NUMBER := 0;
2892: l_trx_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
2893:
2894: cursor C_QUANTITY is
2895: select transaction_quantity
2896: from mtl_material_transactions

Line 3475: FUNCTION Init_Instance_Query_Rec RETURN CSI_DATASTRUCTURES_PUB.Instance_Query_Rec IS

3471: tag_delimeter_pos - (tag_pos + LENGTH(token))) ;
3472:
3473: END get_string_value;
3474:
3475: FUNCTION Init_Instance_Query_Rec RETURN CSI_DATASTRUCTURES_PUB.Instance_Query_Rec IS
3476: l_Instance_Query_Rec CSI_DataStructures_Pub.Instance_Query_Rec;
3477: BEGIN
3478: RETURN l_Instance_Query_Rec;
3479: END Init_Instance_Query_Rec;

Line 3476: l_Instance_Query_Rec CSI_DataStructures_Pub.Instance_Query_Rec;

3472:
3473: END get_string_value;
3474:
3475: FUNCTION Init_Instance_Query_Rec RETURN CSI_DATASTRUCTURES_PUB.Instance_Query_Rec IS
3476: l_Instance_Query_Rec CSI_DataStructures_Pub.Instance_Query_Rec;
3477: BEGIN
3478: RETURN l_Instance_Query_Rec;
3479: END Init_Instance_Query_Rec;
3480:

Line 3481: FUNCTION Init_Instance_Create_Rec RETURN CSI_DATASTRUCTURES_PUB.Instance_Rec IS

3477: BEGIN
3478: RETURN l_Instance_Query_Rec;
3479: END Init_Instance_Query_Rec;
3480:
3481: FUNCTION Init_Instance_Create_Rec RETURN CSI_DATASTRUCTURES_PUB.Instance_Rec IS
3482: l_Instance_Rec CSI_DATASTRUCTURES_PUB.Instance_Rec;
3483: BEGIN
3484: l_instance_rec.version_label := 'AS-CREATED';
3485: l_instance_rec.creation_complete_flag := NULL;

Line 3482: l_Instance_Rec CSI_DATASTRUCTURES_PUB.Instance_Rec;

3478: RETURN l_Instance_Query_Rec;
3479: END Init_Instance_Query_Rec;
3480:
3481: FUNCTION Init_Instance_Create_Rec RETURN CSI_DATASTRUCTURES_PUB.Instance_Rec IS
3482: l_Instance_Rec CSI_DATASTRUCTURES_PUB.Instance_Rec;
3483: BEGIN
3484: l_instance_rec.version_label := 'AS-CREATED';
3485: l_instance_rec.creation_complete_flag := NULL;
3486: RETURN l_Instance_Rec;

Line 3489: FUNCTION Init_Instance_Update_Rec RETURN CSI_DATASTRUCTURES_PUB.Instance_Rec IS

3485: l_instance_rec.creation_complete_flag := NULL;
3486: RETURN l_Instance_Rec;
3487: END Init_Instance_Create_Rec;
3488:
3489: FUNCTION Init_Instance_Update_Rec RETURN CSI_DATASTRUCTURES_PUB.Instance_Rec IS
3490: l_Instance_Rec CSI_DATASTRUCTURES_PUB.Instance_Rec;
3491: BEGIN
3492: RETURN l_Instance_Rec;
3493: END Init_Instance_Update_Rec;

Line 3490: l_Instance_Rec CSI_DATASTRUCTURES_PUB.Instance_Rec;

3486: RETURN l_Instance_Rec;
3487: END Init_Instance_Create_Rec;
3488:
3489: FUNCTION Init_Instance_Update_Rec RETURN CSI_DATASTRUCTURES_PUB.Instance_Rec IS
3490: l_Instance_Rec CSI_DATASTRUCTURES_PUB.Instance_Rec;
3491: BEGIN
3492: RETURN l_Instance_Rec;
3493: END Init_Instance_Update_Rec;
3494:

Line 3495: FUNCTION Init_Party_Tbl RETURN CSI_DATASTRUCTURES_PUB.Party_Tbl IS

3491: BEGIN
3492: RETURN l_Instance_Rec;
3493: END Init_Instance_Update_Rec;
3494:
3495: FUNCTION Init_Party_Tbl RETURN CSI_DATASTRUCTURES_PUB.Party_Tbl IS
3496: l_Party_Tbl CSI_DATASTRUCTURES_PUB.Party_Tbl;
3497: l_source_table VARCHAR2(30);
3498: l_Party_Id NUMBER;
3499: l_relation_code VARCHAR2(30);

Line 3496: l_Party_Tbl CSI_DATASTRUCTURES_PUB.Party_Tbl;

3492: RETURN l_Instance_Rec;
3493: END Init_Instance_Update_Rec;
3494:
3495: FUNCTION Init_Party_Tbl RETURN CSI_DATASTRUCTURES_PUB.Party_Tbl IS
3496: l_Party_Tbl CSI_DATASTRUCTURES_PUB.Party_Tbl;
3497: l_source_table VARCHAR2(30);
3498: l_Party_Id NUMBER;
3499: l_relation_code VARCHAR2(30);
3500:

Line 3517: l_Party_ID := csi_datastructures_pub.g_install_param_rec.internal_party_id;

3513: OPEN Source_Table_Cur;
3514: FETCH Source_Table_Cur INTO l_source_table;
3515: CLOSE Source_Table_Cur;
3516:
3517: l_Party_ID := csi_datastructures_pub.g_install_param_rec.internal_party_id;
3518:
3519: OPEN Relationship_Cur;
3520: FETCH Relationship_Cur INTO l_relation_code;
3521: CLOSE Relationship_Cur;

Line 3530: FUNCTION Init_Account_Tbl RETURN CSI_DATASTRUCTURES_PUB.Party_Account_Tbl IS

3526: l_Party_Tbl(1).contact_flag := 'N';
3527: RETURN l_Party_Tbl;
3528: END Init_Party_Tbl;
3529:
3530: FUNCTION Init_Account_Tbl RETURN CSI_DATASTRUCTURES_PUB.Party_Account_Tbl IS
3531: l_Account_Tbl CSI_DATASTRUCTURES_PUB.Party_Account_Tbl;
3532: BEGIN
3533: RETURN l_Account_Tbl;
3534: END Init_Account_Tbl;

Line 3531: l_Account_Tbl CSI_DATASTRUCTURES_PUB.Party_Account_Tbl;

3527: RETURN l_Party_Tbl;
3528: END Init_Party_Tbl;
3529:
3530: FUNCTION Init_Account_Tbl RETURN CSI_DATASTRUCTURES_PUB.Party_Account_Tbl IS
3531: l_Account_Tbl CSI_DATASTRUCTURES_PUB.Party_Account_Tbl;
3532: BEGIN
3533: RETURN l_Account_Tbl;
3534: END Init_Account_Tbl;
3535:

Line 3536: FUNCTION Init_ext_attrib_values_tbl RETURN CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl IS

3532: BEGIN
3533: RETURN l_Account_Tbl;
3534: END Init_Account_Tbl;
3535:
3536: FUNCTION Init_ext_attrib_values_tbl RETURN CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl IS
3537: l_extend_attrib_values_tbl CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
3538: BEGIN
3539: RETURN l_extend_attrib_values_tbl;
3540: END Init_ext_attrib_values_tbl;

Line 3537: l_extend_attrib_values_tbl CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;

3533: RETURN l_Account_Tbl;
3534: END Init_Account_Tbl;
3535:
3536: FUNCTION Init_ext_attrib_values_tbl RETURN CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl IS
3537: l_extend_attrib_values_tbl CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
3538: BEGIN
3539: RETURN l_extend_attrib_values_tbl;
3540: END Init_ext_attrib_values_tbl;
3541:

Line 3542: FUNCTION Init_Pricing_Attribs_Tbl RETURN CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl IS

3538: BEGIN
3539: RETURN l_extend_attrib_values_tbl;
3540: END Init_ext_attrib_values_tbl;
3541:
3542: FUNCTION Init_Pricing_Attribs_Tbl RETURN CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl IS
3543: l_Pricing_Attribs_Tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
3544: BEGIN
3545: RETURN l_Pricing_Attribs_Tbl;
3546: END Init_Pricing_Attribs_Tbl;

Line 3543: l_Pricing_Attribs_Tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;

3539: RETURN l_extend_attrib_values_tbl;
3540: END Init_ext_attrib_values_tbl;
3541:
3542: FUNCTION Init_Pricing_Attribs_Tbl RETURN CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl IS
3543: l_Pricing_Attribs_Tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
3544: BEGIN
3545: RETURN l_Pricing_Attribs_Tbl;
3546: END Init_Pricing_Attribs_Tbl;
3547:

Line 3548: FUNCTION Init_Org_Assignments_Tbl RETURN CSI_DATASTRUCTURES_PUB.organization_units_tbl IS

3544: BEGIN
3545: RETURN l_Pricing_Attribs_Tbl;
3546: END Init_Pricing_Attribs_Tbl;
3547:
3548: FUNCTION Init_Org_Assignments_Tbl RETURN CSI_DATASTRUCTURES_PUB.organization_units_tbl IS
3549: l_Org_Assignments_Tbl CSI_DATASTRUCTURES_PUB.organization_units_tbl;
3550: BEGIN
3551: RETURN l_Org_Assignments_Tbl;
3552: END Init_Org_Assignments_Tbl;

Line 3549: l_Org_Assignments_Tbl CSI_DATASTRUCTURES_PUB.organization_units_tbl;

3545: RETURN l_Pricing_Attribs_Tbl;
3546: END Init_Pricing_Attribs_Tbl;
3547:
3548: FUNCTION Init_Org_Assignments_Tbl RETURN CSI_DATASTRUCTURES_PUB.organization_units_tbl IS
3549: l_Org_Assignments_Tbl CSI_DATASTRUCTURES_PUB.organization_units_tbl;
3550: BEGIN
3551: RETURN l_Org_Assignments_Tbl;
3552: END Init_Org_Assignments_Tbl;
3553:

Line 3554: FUNCTION Init_Asset_Assignment_Tbl RETURN CSI_DATASTRUCTURES_PUB.instance_asset_tbl IS

3550: BEGIN
3551: RETURN l_Org_Assignments_Tbl;
3552: END Init_Org_Assignments_Tbl;
3553:
3554: FUNCTION Init_Asset_Assignment_Tbl RETURN CSI_DATASTRUCTURES_PUB.instance_asset_tbl IS
3555: l_Asset_Assignment_Tbl CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
3556: BEGIN
3557: RETURN l_Asset_Assignment_Tbl;
3558: END Init_Asset_Assignment_Tbl;

Line 3555: l_Asset_Assignment_Tbl CSI_DATASTRUCTURES_PUB.instance_asset_tbl;

3551: RETURN l_Org_Assignments_Tbl;
3552: END Init_Org_Assignments_Tbl;
3553:
3554: FUNCTION Init_Asset_Assignment_Tbl RETURN CSI_DATASTRUCTURES_PUB.instance_asset_tbl IS
3555: l_Asset_Assignment_Tbl CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
3556: BEGIN
3557: RETURN l_Asset_Assignment_Tbl;
3558: END Init_Asset_Assignment_Tbl;
3559:

Line 3560: FUNCTION Init_Instance_Asset_Query_Rec RETURN CSI_DATASTRUCTURES_PUB.instance_asset_Query_Rec IS

3556: BEGIN
3557: RETURN l_Asset_Assignment_Tbl;
3558: END Init_Asset_Assignment_Tbl;
3559:
3560: FUNCTION Init_Instance_Asset_Query_Rec RETURN CSI_DATASTRUCTURES_PUB.instance_asset_Query_Rec IS
3561: l_instance_asset_Query_Rec CSI_DATASTRUCTURES_PUB.instance_asset_Query_Rec;
3562: BEGIN
3563: RETURN l_instance_asset_Query_Rec;
3564: END Init_Instance_Asset_Query_Rec;

Line 3561: l_instance_asset_Query_Rec CSI_DATASTRUCTURES_PUB.instance_asset_Query_Rec;

3557: RETURN l_Asset_Assignment_Tbl;
3558: END Init_Asset_Assignment_Tbl;
3559:
3560: FUNCTION Init_Instance_Asset_Query_Rec RETURN CSI_DATASTRUCTURES_PUB.instance_asset_Query_Rec IS
3561: l_instance_asset_Query_Rec CSI_DATASTRUCTURES_PUB.instance_asset_Query_Rec;
3562: BEGIN
3563: RETURN l_instance_asset_Query_Rec;
3564: END Init_Instance_Asset_Query_Rec;
3565:

Line 3566: FUNCTION Init_Instance_Asset_Rec RETURN CSI_DATASTRUCTURES_PUB.instance_asset_Rec IS

3562: BEGIN
3563: RETURN l_instance_asset_Query_Rec;
3564: END Init_Instance_Asset_Query_Rec;
3565:
3566: FUNCTION Init_Instance_Asset_Rec RETURN CSI_DATASTRUCTURES_PUB.instance_asset_Rec IS
3567: l_instance_asset_Rec CSI_DATASTRUCTURES_PUB.instance_asset_Rec;
3568: BEGIN
3569: RETURN l_instance_asset_Rec;
3570: END Init_Instance_Asset_Rec;

Line 3567: l_instance_asset_Rec CSI_DATASTRUCTURES_PUB.instance_asset_Rec;

3563: RETURN l_instance_asset_Query_Rec;
3564: END Init_Instance_Asset_Query_Rec;
3565:
3566: FUNCTION Init_Instance_Asset_Rec RETURN CSI_DATASTRUCTURES_PUB.instance_asset_Rec IS
3567: l_instance_asset_Rec CSI_DATASTRUCTURES_PUB.instance_asset_Rec;
3568: BEGIN
3569: RETURN l_instance_asset_Rec;
3570: END Init_Instance_Asset_Rec;
3571:

Line 3638: l_project_location_id := csi_datastructures_pub.g_install_param_rec.project_location_id;

3634: l_project_location_id NUMBER := NULL;
3635:
3636: BEGIN
3637:
3638: l_project_location_id := csi_datastructures_pub.g_install_param_rec.project_location_id;
3639:
3640: RETURN l_project_location_id;
3641: END Get_Dflt_Project_Location_Id;
3642:

Line 3697: FUNCTION Init_Txn_Rec RETURN CSI_DATASTRUCTURES_PUB.TRANSACTION_Rec IS

3693: CLOSE c_id;
3694: RETURN l_employee_id;
3695: END Get_Fnd_Employee_Id;
3696:
3697: FUNCTION Init_Txn_Rec RETURN CSI_DATASTRUCTURES_PUB.TRANSACTION_Rec IS
3698: l_Txn_Rec CSI_DATASTRUCTURES_PUB.TRANSACTION_Rec;
3699: BEGIN
3700: RETURN l_Txn_Rec;
3701: END Init_Txn_Rec;

Line 3698: l_Txn_Rec CSI_DATASTRUCTURES_PUB.TRANSACTION_Rec;

3694: RETURN l_employee_id;
3695: END Get_Fnd_Employee_Id;
3696:
3697: FUNCTION Init_Txn_Rec RETURN CSI_DATASTRUCTURES_PUB.TRANSACTION_Rec IS
3698: l_Txn_Rec CSI_DATASTRUCTURES_PUB.TRANSACTION_Rec;
3699: BEGIN
3700: RETURN l_Txn_Rec;
3701: END Init_Txn_Rec;
3702:

Line 3703: FUNCTION Init_Txn_Error_Rec RETURN CSI_DATASTRUCTURES_PUB.TRANSACTION_Error_Rec IS

3699: BEGIN
3700: RETURN l_Txn_Rec;
3701: END Init_Txn_Rec;
3702:
3703: FUNCTION Init_Txn_Error_Rec RETURN CSI_DATASTRUCTURES_PUB.TRANSACTION_Error_Rec IS
3704: l_Txn_Error_Rec CSI_DATASTRUCTURES_PUB.TRANSACTION_Error_Rec;
3705: BEGIN
3706: l_Txn_Error_Rec.processed_flag := CSI_INV_TRXS_PKG.G_TXN_ERROR;
3707: RETURN l_Txn_Error_Rec;

Line 3704: l_Txn_Error_Rec CSI_DATASTRUCTURES_PUB.TRANSACTION_Error_Rec;

3700: RETURN l_Txn_Rec;
3701: END Init_Txn_Rec;
3702:
3703: FUNCTION Init_Txn_Error_Rec RETURN CSI_DATASTRUCTURES_PUB.TRANSACTION_Error_Rec IS
3704: l_Txn_Error_Rec CSI_DATASTRUCTURES_PUB.TRANSACTION_Error_Rec;
3705: BEGIN
3706: l_Txn_Error_Rec.processed_flag := CSI_INV_TRXS_PKG.G_TXN_ERROR;
3707: RETURN l_Txn_Error_Rec;
3708: END Init_Txn_Error_Rec;

Line 3710: FUNCTION Init_Party_Query_Rec RETURN CSI_DATASTRUCTURES_PUB.Party_Query_Rec IS

3706: l_Txn_Error_Rec.processed_flag := CSI_INV_TRXS_PKG.G_TXN_ERROR;
3707: RETURN l_Txn_Error_Rec;
3708: END Init_Txn_Error_Rec;
3709:
3710: FUNCTION Init_Party_Query_Rec RETURN CSI_DATASTRUCTURES_PUB.Party_Query_Rec IS
3711: l_Party_Query_Rec CSI_DATASTRUCTURES_PUB.Party_Query_Rec;
3712: l_Party_Id NUMBER;
3713: l_relation_code VARCHAR2(30);
3714:

Line 3711: l_Party_Query_Rec CSI_DATASTRUCTURES_PUB.Party_Query_Rec;

3707: RETURN l_Txn_Error_Rec;
3708: END Init_Txn_Error_Rec;
3709:
3710: FUNCTION Init_Party_Query_Rec RETURN CSI_DATASTRUCTURES_PUB.Party_Query_Rec IS
3711: l_Party_Query_Rec CSI_DATASTRUCTURES_PUB.Party_Query_Rec;
3712: l_Party_Id NUMBER;
3713: l_relation_code VARCHAR2(30);
3714:
3715: CURSOR Relationship_Cur IS

Line 3723: l_Party_ID := csi_datastructures_pub.g_install_param_rec.internal_party_id;

3719:
3720: BEGIN
3721:
3722:
3723: l_Party_ID := csi_datastructures_pub.g_install_param_rec.internal_party_id;
3724:
3725: OPEN Relationship_Cur;
3726: FETCH Relationship_Cur INTO l_relation_code;
3727: CLOSE Relationship_Cur;

Line 3860: PROCEDURE log_csi_error(p_trx_error_rec IN CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC) IS

3856:
3857: RETURN l_inv_name;
3858: END get_inv_name;
3859:
3860: PROCEDURE log_csi_error(p_trx_error_rec IN CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC) IS
3861:
3862: l_api_version NUMBER := 1.0;
3863: l_commit VARCHAR2(1) := FND_API.G_FALSE;
3864: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;

Line 3870: l_trx_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;

3866: l_msg_count NUMBER;
3867: l_msg_data VARCHAR2(2000);
3868: l_txn_error_id NUMBER;
3869: l_return_status VARCHAR2(1);
3870: l_trx_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
3871: no_error_logged EXCEPTION;
3872: x_transaction_error_id NUMBER;
3873:
3874: BEGIN

Line 3988: CSI_DATASTRUCTURES_PUB.TRANSACTION_REC,

3984: END;
3985: END log_csi_error;
3986:
3987: PROCEDURE create_csi_txn(px_txn_rec IN OUT NOCOPY
3988: CSI_DATASTRUCTURES_PUB.TRANSACTION_REC,
3989: x_error_message OUT NOCOPY VARCHAR2,
3990: x_return_status OUT NOCOPY VARCHAR2) IS
3991:
3992:

Line 4559: x_instance_query_rec OUT NOCOPY csi_datastructures_pub.instance_query_rec,

4555: PROCEDURE set_item_attr_query_values(
4556: l_mtl_item_tbl IN CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE,
4557: table_index IN NUMBER,
4558: p_source IN VARCHAR2,
4559: x_instance_query_rec OUT NOCOPY csi_datastructures_pub.instance_query_rec,
4560: x_return_status OUT NOCOPY varchar2)
4561: IS
4562:
4563: l_instance_query_rec csi_datastructures_pub.instance_query_rec;

Line 4563: l_instance_query_rec csi_datastructures_pub.instance_query_rec;

4559: x_instance_query_rec OUT NOCOPY csi_datastructures_pub.instance_query_rec,
4560: x_return_status OUT NOCOPY varchar2)
4561: IS
4562:
4563: l_instance_query_rec csi_datastructures_pub.instance_query_rec;
4564:
4565: BEGIN
4566:
4567: x_return_status := fnd_api.g_ret_sts_success;