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 249: l_ownership_party := csi_datastructures_pub.g_install_param_rec.ownership_override_at_txn;

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

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

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

Line 1157: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)

1153:
1154: PROCEDURE receipt_inventory(p_transaction_id IN NUMBER,
1155: p_message_id IN NUMBER,
1156: x_return_status OUT NOCOPY VARCHAR2,
1157: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
1158: IS
1159:
1160: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
1161: l_api_name VARCHAR2(100) := 'CSI_INV_TRXS_PKG.RECEIPT_INVENTORY';

Line 1174: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;

1170: l_object_version_number NUMBER := 1;
1171: l_sysdate DATE := SYSDATE;
1172: l_master_organization_id NUMBER;
1173: l_depreciable VARCHAR2(1);
1174: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
1175: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1176: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1177: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
1178: l_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

Line 1175: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

1171: l_sysdate DATE := SYSDATE;
1172: l_master_organization_id NUMBER;
1173: l_depreciable VARCHAR2(1);
1174: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
1175: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1176: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1177: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
1178: l_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1179: l_api_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

Line 1176: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

1172: l_master_organization_id NUMBER;
1173: l_depreciable VARCHAR2(1);
1174: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
1175: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1176: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1177: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
1178: l_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1179: l_api_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1180: l_return_status VARCHAR2(1);

Line 1177: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;

1173: l_depreciable VARCHAR2(1);
1174: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
1175: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1176: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1177: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
1178: l_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1179: l_api_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1180: l_return_status VARCHAR2(1);
1181: l_error_code VARCHAR2(50);

Line 1178: l_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

1174: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
1175: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1176: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1177: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
1178: l_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1179: l_api_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1180: l_return_status VARCHAR2(1);
1181: l_error_code VARCHAR2(50);
1182: l_error_message VARCHAR2(4000);

Line 1179: l_api_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

1175: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1176: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1177: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
1178: l_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1179: l_api_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1180: l_return_status VARCHAR2(1);
1181: l_error_code VARCHAR2(50);
1182: l_error_message VARCHAR2(4000);
1183: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;

Line 1183: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;

1179: l_api_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1180: l_return_status VARCHAR2(1);
1181: l_error_code VARCHAR2(50);
1182: l_error_message VARCHAR2(4000);
1183: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
1184: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
1185: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
1186: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1187: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;

Line 1184: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;

1180: l_return_status VARCHAR2(1);
1181: l_error_code VARCHAR2(50);
1182: l_error_message VARCHAR2(4000);
1183: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
1184: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
1185: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
1186: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1187: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1188: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;

Line 1185: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;

1181: l_error_code VARCHAR2(50);
1182: l_error_message VARCHAR2(4000);
1183: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
1184: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
1185: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
1186: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1187: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1188: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
1189: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;

Line 1186: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;

1182: l_error_message VARCHAR2(4000);
1183: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
1184: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
1185: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
1186: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1187: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1188: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
1189: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
1190: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;

Line 1187: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;

1183: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
1184: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
1185: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
1186: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1187: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1188: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
1189: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
1190: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
1191: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;

Line 1188: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;

1184: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
1185: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
1186: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1187: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1188: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
1189: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
1190: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
1191: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
1192: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;

Line 1189: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;

1185: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
1186: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1187: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1188: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
1189: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
1190: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
1191: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
1192: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
1193: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 1190: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;

1186: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1187: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1188: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
1189: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
1190: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
1191: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
1192: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
1193: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1194: l_fnd_warning VARCHAR2(1) := 'W';

Line 1191: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;

1187: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1188: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
1189: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
1190: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
1191: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
1192: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
1193: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1194: l_fnd_warning VARCHAR2(1) := 'W';
1195: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

Line 1192: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;

1188: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
1189: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
1190: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
1191: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
1192: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
1193: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1194: l_fnd_warning VARCHAR2(1) := 'W';
1195: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1196: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1230: l_instance_header_rec csi_datastructures_pub.instance_header_rec;

1226: l_owner_party_id NUMBER; --added code for bug #5868111
1227: l_redeploy_flag VARCHAR2(1);
1228: l_upd_error_instance_id NUMBER := NULL;
1229:
1230: l_instance_header_rec csi_datastructures_pub.instance_header_rec;
1231: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
1232: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
1233: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
1234: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 1231: l_party_header_tbl csi_datastructures_pub.party_header_tbl;

1227: l_redeploy_flag VARCHAR2(1);
1228: l_upd_error_instance_id NUMBER := NULL;
1229:
1230: l_instance_header_rec csi_datastructures_pub.instance_header_rec;
1231: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
1232: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
1233: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
1234: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
1235: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 1232: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;

1228: l_upd_error_instance_id NUMBER := NULL;
1229:
1230: l_instance_header_rec csi_datastructures_pub.instance_header_rec;
1231: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
1232: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
1233: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
1234: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
1235: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1236: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;

Line 1233: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;

1229:
1230: l_instance_header_rec csi_datastructures_pub.instance_header_rec;
1231: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
1232: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
1233: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
1234: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
1235: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1236: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
1237: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;

Line 1234: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;

1230: l_instance_header_rec csi_datastructures_pub.instance_header_rec;
1231: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
1232: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
1233: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
1234: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
1235: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1236: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
1237: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
1238:

Line 1235: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;

1231: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
1232: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
1233: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
1234: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
1235: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1236: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
1237: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
1238:
1239: CURSOR c_po_info (pc_po_distribution_id in number) is

Line 1236: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;

1232: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
1233: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
1234: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
1235: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1236: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
1237: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
1238:
1239: CURSOR c_po_info (pc_po_distribution_id in number) is
1240: SELECT pod.po_header_id po_header_id,

Line 1237: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;

1233: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
1234: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
1235: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1236: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
1237: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
1238:
1239: CURSOR c_po_info (pc_po_distribution_id in number) is
1240: SELECT pod.po_header_id po_header_id,
1241: pod.po_line_id po_line_id,

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

1337: l_quantity := 1;
1338: END IF;
1339:
1340: -- Get Party ownership Flag
1341: l_ownership_party := csi_datastructures_pub.g_install_param_rec.ownership_override_at_txn;
1342: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id; --added code for bug #5868111
1343:
1344: debug('Ownership Flag is: '||l_ownership_party);
1345: debug('Internal Party Id is : '||l_internal_party_id); --added code for bug #5868111

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

1338: END IF;
1339:
1340: -- Get Party ownership Flag
1341: l_ownership_party := csi_datastructures_pub.g_install_param_rec.ownership_override_at_txn;
1342: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id; --added code for bug #5868111
1343:
1344: debug('Ownership Flag is: '||l_ownership_party);
1345: debug('Internal Party Id is : '||l_internal_party_id); --added code for bug #5868111
1346:

Line 2166: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)

2162:
2163: PROCEDURE misc_issue(p_transaction_id IN NUMBER,
2164: p_message_id IN NUMBER,
2165: x_return_status OUT NOCOPY VARCHAR2,
2166: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
2167: IS
2168:
2169: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
2170: l_api_name VARCHAR2(100) := 'CSI_INV_TRXS_PKG.MISC_ISSUE';

Line 2182: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;

2178: l_object_version_number NUMBER := 1;
2179: l_sysdate DATE := SYSDATE;
2180: l_master_organization_id NUMBER;
2181: l_depreciable VARCHAR2(1);
2182: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2183: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2184: l_api_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2185: l_api_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2186: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

Line 2183: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

2179: l_sysdate DATE := SYSDATE;
2180: l_master_organization_id NUMBER;
2181: l_depreciable VARCHAR2(1);
2182: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2183: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2184: l_api_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2185: l_api_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2186: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2187: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

Line 2184: l_api_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

2180: l_master_organization_id NUMBER;
2181: l_depreciable VARCHAR2(1);
2182: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2183: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2184: l_api_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2185: l_api_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2186: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2187: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2188: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

Line 2185: l_api_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

2181: l_depreciable VARCHAR2(1);
2182: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2183: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2184: l_api_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2185: l_api_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2186: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2187: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2188: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2189: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;

Line 2186: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

2182: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2183: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2184: l_api_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2185: l_api_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2186: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2187: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2188: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2189: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
2190: l_return_status VARCHAR2(1);

Line 2187: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

2183: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2184: l_api_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2185: l_api_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2186: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2187: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2188: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2189: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
2190: l_return_status VARCHAR2(1);
2191: l_error_code VARCHAR2(50);

Line 2188: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

2184: l_api_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2185: l_api_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2186: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2187: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2188: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2189: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
2190: l_return_status VARCHAR2(1);
2191: l_error_code VARCHAR2(50);
2192: l_error_message VARCHAR2(4000);

Line 2189: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;

2185: l_api_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2186: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2187: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2188: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2189: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
2190: l_return_status VARCHAR2(1);
2191: l_error_code VARCHAR2(50);
2192: l_error_message VARCHAR2(4000);
2193: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;

Line 2193: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;

2189: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
2190: l_return_status VARCHAR2(1);
2191: l_error_code VARCHAR2(50);
2192: l_error_message VARCHAR2(4000);
2193: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
2194: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
2195: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
2196: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2197: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;

Line 2194: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;

2190: l_return_status VARCHAR2(1);
2191: l_error_code VARCHAR2(50);
2192: l_error_message VARCHAR2(4000);
2193: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
2194: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
2195: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
2196: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2197: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2198: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;

Line 2195: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;

2191: l_error_code VARCHAR2(50);
2192: l_error_message VARCHAR2(4000);
2193: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
2194: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
2195: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
2196: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2197: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2198: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2199: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;

Line 2196: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;

2192: l_error_message VARCHAR2(4000);
2193: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
2194: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
2195: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
2196: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2197: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2198: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2199: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
2200: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;

Line 2197: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;

2193: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
2194: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
2195: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
2196: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2197: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2198: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2199: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
2200: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2201: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;

Line 2198: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;

2194: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
2195: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
2196: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2197: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2198: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2199: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
2200: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2201: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
2202: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;

Line 2199: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;

2195: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
2196: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2197: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2198: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2199: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
2200: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2201: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
2202: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
2203: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 2200: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;

2196: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2197: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2198: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2199: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
2200: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2201: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
2202: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
2203: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2204: l_fnd_warning VARCHAR2(1) := 'W';

Line 2201: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;

2197: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2198: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2199: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
2200: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2201: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
2202: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
2203: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2204: l_fnd_warning VARCHAR2(1) := 'W';
2205: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

Line 2202: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;

2198: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2199: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
2200: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2201: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
2202: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
2203: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2204: l_fnd_warning VARCHAR2(1) := 'W';
2205: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
2206: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2235: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;

2231: l_trans_type_code VARCHAR2(25);
2232: l_trans_app_code VARCHAR2(5);
2233: l_redeploy_flag VARCHAR2(1);
2234: l_upd_error_instance_id NUMBER := NULL;
2235: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2236:
2237: l_serial_tagged NUMBER := 1;
2238: l_return_item VARCHAR2(1) := 'N';
2239: cursor c_id is

Line 3197: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)

3193:
3194: PROCEDURE cycle_count(p_transaction_id IN NUMBER,
3195: p_message_id IN NUMBER,
3196: x_return_status OUT NOCOPY VARCHAR2,
3197: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
3198: IS
3199:
3200: l_api_name VARCHAR2(100) := 'CSI_INV_TRXS_PKG.CYCLE_COUNT';
3201: l_return_status VARCHAR2(1);

Line 3210: l_trx_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;

3206: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
3207: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
3208: l_sql_error VARCHAR2(2000);
3209: r_quantity NUMBER := 0;
3210: l_trx_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
3211:
3212: cursor C_QUANTITY is
3213: select transaction_quantity
3214: from mtl_material_transactions

Line 3285: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)

3281:
3282: PROCEDURE physical_inventory(p_transaction_id IN NUMBER,
3283: p_message_id IN NUMBER,
3284: x_return_status OUT NOCOPY VARCHAR2,
3285: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
3286: IS
3287:
3288: l_api_name VARCHAR2(100) := 'CSI_INV_TRXS_PKG.PHYSICAL_INVENTORY';
3289: l_return_status VARCHAR2(1);

Line 3298: l_trx_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;

3294: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
3295: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
3296: l_sql_error VARCHAR2(2000);
3297: r_quantity NUMBER := 0;
3298: l_trx_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
3299:
3300: cursor C_QUANTITY is
3301: select transaction_quantity
3302: from mtl_material_transactions

Line 4120: FUNCTION Init_Instance_Query_Rec RETURN CSI_DATASTRUCTURES_PUB.Instance_Query_Rec IS

4116: tag_delimeter_pos - (tag_pos + LENGTH(token))) ;
4117:
4118: END get_string_value;
4119:
4120: FUNCTION Init_Instance_Query_Rec RETURN CSI_DATASTRUCTURES_PUB.Instance_Query_Rec IS
4121: l_Instance_Query_Rec CSI_DataStructures_Pub.Instance_Query_Rec;
4122: BEGIN
4123: RETURN l_Instance_Query_Rec;
4124: END Init_Instance_Query_Rec;

Line 4121: l_Instance_Query_Rec CSI_DataStructures_Pub.Instance_Query_Rec;

4117:
4118: END get_string_value;
4119:
4120: FUNCTION Init_Instance_Query_Rec RETURN CSI_DATASTRUCTURES_PUB.Instance_Query_Rec IS
4121: l_Instance_Query_Rec CSI_DataStructures_Pub.Instance_Query_Rec;
4122: BEGIN
4123: RETURN l_Instance_Query_Rec;
4124: END Init_Instance_Query_Rec;
4125:

Line 4126: FUNCTION Init_Instance_Create_Rec RETURN CSI_DATASTRUCTURES_PUB.Instance_Rec IS

4122: BEGIN
4123: RETURN l_Instance_Query_Rec;
4124: END Init_Instance_Query_Rec;
4125:
4126: FUNCTION Init_Instance_Create_Rec RETURN CSI_DATASTRUCTURES_PUB.Instance_Rec IS
4127: l_Instance_Rec CSI_DATASTRUCTURES_PUB.Instance_Rec;
4128: BEGIN
4129: l_instance_rec.version_label := 'AS-CREATED';
4130: l_instance_rec.creation_complete_flag := NULL;

Line 4127: l_Instance_Rec CSI_DATASTRUCTURES_PUB.Instance_Rec;

4123: RETURN l_Instance_Query_Rec;
4124: END Init_Instance_Query_Rec;
4125:
4126: FUNCTION Init_Instance_Create_Rec RETURN CSI_DATASTRUCTURES_PUB.Instance_Rec IS
4127: l_Instance_Rec CSI_DATASTRUCTURES_PUB.Instance_Rec;
4128: BEGIN
4129: l_instance_rec.version_label := 'AS-CREATED';
4130: l_instance_rec.creation_complete_flag := NULL;
4131: RETURN l_Instance_Rec;

Line 4134: FUNCTION Init_Instance_Update_Rec RETURN CSI_DATASTRUCTURES_PUB.Instance_Rec IS

4130: l_instance_rec.creation_complete_flag := NULL;
4131: RETURN l_Instance_Rec;
4132: END Init_Instance_Create_Rec;
4133:
4134: FUNCTION Init_Instance_Update_Rec RETURN CSI_DATASTRUCTURES_PUB.Instance_Rec IS
4135: l_Instance_Rec CSI_DATASTRUCTURES_PUB.Instance_Rec;
4136: BEGIN
4137: RETURN l_Instance_Rec;
4138: END Init_Instance_Update_Rec;

Line 4135: l_Instance_Rec CSI_DATASTRUCTURES_PUB.Instance_Rec;

4131: RETURN l_Instance_Rec;
4132: END Init_Instance_Create_Rec;
4133:
4134: FUNCTION Init_Instance_Update_Rec RETURN CSI_DATASTRUCTURES_PUB.Instance_Rec IS
4135: l_Instance_Rec CSI_DATASTRUCTURES_PUB.Instance_Rec;
4136: BEGIN
4137: RETURN l_Instance_Rec;
4138: END Init_Instance_Update_Rec;
4139:

Line 4140: FUNCTION Init_Party_Tbl RETURN CSI_DATASTRUCTURES_PUB.Party_Tbl IS

4136: BEGIN
4137: RETURN l_Instance_Rec;
4138: END Init_Instance_Update_Rec;
4139:
4140: FUNCTION Init_Party_Tbl RETURN CSI_DATASTRUCTURES_PUB.Party_Tbl IS
4141: l_Party_Tbl CSI_DATASTRUCTURES_PUB.Party_Tbl;
4142: l_source_table VARCHAR2(30);
4143: l_Party_Id NUMBER;
4144: l_relation_code VARCHAR2(30);

Line 4141: l_Party_Tbl CSI_DATASTRUCTURES_PUB.Party_Tbl;

4137: RETURN l_Instance_Rec;
4138: END Init_Instance_Update_Rec;
4139:
4140: FUNCTION Init_Party_Tbl RETURN CSI_DATASTRUCTURES_PUB.Party_Tbl IS
4141: l_Party_Tbl CSI_DATASTRUCTURES_PUB.Party_Tbl;
4142: l_source_table VARCHAR2(30);
4143: l_Party_Id NUMBER;
4144: l_relation_code VARCHAR2(30);
4145:

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

4158: OPEN Source_Table_Cur;
4159: FETCH Source_Table_Cur INTO l_source_table;
4160: CLOSE Source_Table_Cur;
4161:
4162: l_Party_ID := csi_datastructures_pub.g_install_param_rec.internal_party_id;
4163:
4164: OPEN Relationship_Cur;
4165: FETCH Relationship_Cur INTO l_relation_code;
4166: CLOSE Relationship_Cur;

Line 4175: FUNCTION Init_Account_Tbl RETURN CSI_DATASTRUCTURES_PUB.Party_Account_Tbl IS

4171: l_Party_Tbl(1).contact_flag := 'N';
4172: RETURN l_Party_Tbl;
4173: END Init_Party_Tbl;
4174:
4175: FUNCTION Init_Account_Tbl RETURN CSI_DATASTRUCTURES_PUB.Party_Account_Tbl IS
4176: l_Account_Tbl CSI_DATASTRUCTURES_PUB.Party_Account_Tbl;
4177: BEGIN
4178: RETURN l_Account_Tbl;
4179: END Init_Account_Tbl;

Line 4176: l_Account_Tbl CSI_DATASTRUCTURES_PUB.Party_Account_Tbl;

4172: RETURN l_Party_Tbl;
4173: END Init_Party_Tbl;
4174:
4175: FUNCTION Init_Account_Tbl RETURN CSI_DATASTRUCTURES_PUB.Party_Account_Tbl IS
4176: l_Account_Tbl CSI_DATASTRUCTURES_PUB.Party_Account_Tbl;
4177: BEGIN
4178: RETURN l_Account_Tbl;
4179: END Init_Account_Tbl;
4180:

Line 4181: FUNCTION Init_ext_attrib_values_tbl RETURN CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl IS

4177: BEGIN
4178: RETURN l_Account_Tbl;
4179: END Init_Account_Tbl;
4180:
4181: FUNCTION Init_ext_attrib_values_tbl RETURN CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl IS
4182: l_extend_attrib_values_tbl CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
4183: BEGIN
4184: RETURN l_extend_attrib_values_tbl;
4185: END Init_ext_attrib_values_tbl;

Line 4182: l_extend_attrib_values_tbl CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;

4178: RETURN l_Account_Tbl;
4179: END Init_Account_Tbl;
4180:
4181: FUNCTION Init_ext_attrib_values_tbl RETURN CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl IS
4182: l_extend_attrib_values_tbl CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
4183: BEGIN
4184: RETURN l_extend_attrib_values_tbl;
4185: END Init_ext_attrib_values_tbl;
4186:

Line 4187: FUNCTION Init_Pricing_Attribs_Tbl RETURN CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl IS

4183: BEGIN
4184: RETURN l_extend_attrib_values_tbl;
4185: END Init_ext_attrib_values_tbl;
4186:
4187: FUNCTION Init_Pricing_Attribs_Tbl RETURN CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl IS
4188: l_Pricing_Attribs_Tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
4189: BEGIN
4190: RETURN l_Pricing_Attribs_Tbl;
4191: END Init_Pricing_Attribs_Tbl;

Line 4188: l_Pricing_Attribs_Tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;

4184: RETURN l_extend_attrib_values_tbl;
4185: END Init_ext_attrib_values_tbl;
4186:
4187: FUNCTION Init_Pricing_Attribs_Tbl RETURN CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl IS
4188: l_Pricing_Attribs_Tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
4189: BEGIN
4190: RETURN l_Pricing_Attribs_Tbl;
4191: END Init_Pricing_Attribs_Tbl;
4192:

Line 4193: FUNCTION Init_Org_Assignments_Tbl RETURN CSI_DATASTRUCTURES_PUB.organization_units_tbl IS

4189: BEGIN
4190: RETURN l_Pricing_Attribs_Tbl;
4191: END Init_Pricing_Attribs_Tbl;
4192:
4193: FUNCTION Init_Org_Assignments_Tbl RETURN CSI_DATASTRUCTURES_PUB.organization_units_tbl IS
4194: l_Org_Assignments_Tbl CSI_DATASTRUCTURES_PUB.organization_units_tbl;
4195: BEGIN
4196: RETURN l_Org_Assignments_Tbl;
4197: END Init_Org_Assignments_Tbl;

Line 4194: l_Org_Assignments_Tbl CSI_DATASTRUCTURES_PUB.organization_units_tbl;

4190: RETURN l_Pricing_Attribs_Tbl;
4191: END Init_Pricing_Attribs_Tbl;
4192:
4193: FUNCTION Init_Org_Assignments_Tbl RETURN CSI_DATASTRUCTURES_PUB.organization_units_tbl IS
4194: l_Org_Assignments_Tbl CSI_DATASTRUCTURES_PUB.organization_units_tbl;
4195: BEGIN
4196: RETURN l_Org_Assignments_Tbl;
4197: END Init_Org_Assignments_Tbl;
4198:

Line 4199: FUNCTION Init_Asset_Assignment_Tbl RETURN CSI_DATASTRUCTURES_PUB.instance_asset_tbl IS

4195: BEGIN
4196: RETURN l_Org_Assignments_Tbl;
4197: END Init_Org_Assignments_Tbl;
4198:
4199: FUNCTION Init_Asset_Assignment_Tbl RETURN CSI_DATASTRUCTURES_PUB.instance_asset_tbl IS
4200: l_Asset_Assignment_Tbl CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
4201: BEGIN
4202: RETURN l_Asset_Assignment_Tbl;
4203: END Init_Asset_Assignment_Tbl;

Line 4200: l_Asset_Assignment_Tbl CSI_DATASTRUCTURES_PUB.instance_asset_tbl;

4196: RETURN l_Org_Assignments_Tbl;
4197: END Init_Org_Assignments_Tbl;
4198:
4199: FUNCTION Init_Asset_Assignment_Tbl RETURN CSI_DATASTRUCTURES_PUB.instance_asset_tbl IS
4200: l_Asset_Assignment_Tbl CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
4201: BEGIN
4202: RETURN l_Asset_Assignment_Tbl;
4203: END Init_Asset_Assignment_Tbl;
4204:

Line 4205: FUNCTION Init_Instance_Asset_Query_Rec RETURN CSI_DATASTRUCTURES_PUB.instance_asset_Query_Rec IS

4201: BEGIN
4202: RETURN l_Asset_Assignment_Tbl;
4203: END Init_Asset_Assignment_Tbl;
4204:
4205: FUNCTION Init_Instance_Asset_Query_Rec RETURN CSI_DATASTRUCTURES_PUB.instance_asset_Query_Rec IS
4206: l_instance_asset_Query_Rec CSI_DATASTRUCTURES_PUB.instance_asset_Query_Rec;
4207: BEGIN
4208: RETURN l_instance_asset_Query_Rec;
4209: END Init_Instance_Asset_Query_Rec;

Line 4206: l_instance_asset_Query_Rec CSI_DATASTRUCTURES_PUB.instance_asset_Query_Rec;

4202: RETURN l_Asset_Assignment_Tbl;
4203: END Init_Asset_Assignment_Tbl;
4204:
4205: FUNCTION Init_Instance_Asset_Query_Rec RETURN CSI_DATASTRUCTURES_PUB.instance_asset_Query_Rec IS
4206: l_instance_asset_Query_Rec CSI_DATASTRUCTURES_PUB.instance_asset_Query_Rec;
4207: BEGIN
4208: RETURN l_instance_asset_Query_Rec;
4209: END Init_Instance_Asset_Query_Rec;
4210:

Line 4211: FUNCTION Init_Instance_Asset_Rec RETURN CSI_DATASTRUCTURES_PUB.instance_asset_Rec IS

4207: BEGIN
4208: RETURN l_instance_asset_Query_Rec;
4209: END Init_Instance_Asset_Query_Rec;
4210:
4211: FUNCTION Init_Instance_Asset_Rec RETURN CSI_DATASTRUCTURES_PUB.instance_asset_Rec IS
4212: l_instance_asset_Rec CSI_DATASTRUCTURES_PUB.instance_asset_Rec;
4213: BEGIN
4214: RETURN l_instance_asset_Rec;
4215: END Init_Instance_Asset_Rec;

Line 4212: l_instance_asset_Rec CSI_DATASTRUCTURES_PUB.instance_asset_Rec;

4208: RETURN l_instance_asset_Query_Rec;
4209: END Init_Instance_Asset_Query_Rec;
4210:
4211: FUNCTION Init_Instance_Asset_Rec RETURN CSI_DATASTRUCTURES_PUB.instance_asset_Rec IS
4212: l_instance_asset_Rec CSI_DATASTRUCTURES_PUB.instance_asset_Rec;
4213: BEGIN
4214: RETURN l_instance_asset_Rec;
4215: END Init_Instance_Asset_Rec;
4216:

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

4279: l_project_location_id NUMBER := NULL;
4280:
4281: BEGIN
4282:
4283: l_project_location_id := csi_datastructures_pub.g_install_param_rec.project_location_id;
4284:
4285: RETURN l_project_location_id;
4286: END Get_Dflt_Project_Location_Id;
4287:

Line 4342: FUNCTION Init_Txn_Rec RETURN CSI_DATASTRUCTURES_PUB.TRANSACTION_Rec IS

4338: CLOSE c_id;
4339: RETURN l_employee_id;
4340: END Get_Fnd_Employee_Id;
4341:
4342: FUNCTION Init_Txn_Rec RETURN CSI_DATASTRUCTURES_PUB.TRANSACTION_Rec IS
4343: l_Txn_Rec CSI_DATASTRUCTURES_PUB.TRANSACTION_Rec;
4344: BEGIN
4345: RETURN l_Txn_Rec;
4346: END Init_Txn_Rec;

Line 4343: l_Txn_Rec CSI_DATASTRUCTURES_PUB.TRANSACTION_Rec;

4339: RETURN l_employee_id;
4340: END Get_Fnd_Employee_Id;
4341:
4342: FUNCTION Init_Txn_Rec RETURN CSI_DATASTRUCTURES_PUB.TRANSACTION_Rec IS
4343: l_Txn_Rec CSI_DATASTRUCTURES_PUB.TRANSACTION_Rec;
4344: BEGIN
4345: RETURN l_Txn_Rec;
4346: END Init_Txn_Rec;
4347:

Line 4348: FUNCTION Init_Txn_Error_Rec RETURN CSI_DATASTRUCTURES_PUB.TRANSACTION_Error_Rec IS

4344: BEGIN
4345: RETURN l_Txn_Rec;
4346: END Init_Txn_Rec;
4347:
4348: FUNCTION Init_Txn_Error_Rec RETURN CSI_DATASTRUCTURES_PUB.TRANSACTION_Error_Rec IS
4349: l_Txn_Error_Rec CSI_DATASTRUCTURES_PUB.TRANSACTION_Error_Rec;
4350: BEGIN
4351: l_Txn_Error_Rec.processed_flag := CSI_INV_TRXS_PKG.G_TXN_ERROR;
4352: RETURN l_Txn_Error_Rec;

Line 4349: l_Txn_Error_Rec CSI_DATASTRUCTURES_PUB.TRANSACTION_Error_Rec;

4345: RETURN l_Txn_Rec;
4346: END Init_Txn_Rec;
4347:
4348: FUNCTION Init_Txn_Error_Rec RETURN CSI_DATASTRUCTURES_PUB.TRANSACTION_Error_Rec IS
4349: l_Txn_Error_Rec CSI_DATASTRUCTURES_PUB.TRANSACTION_Error_Rec;
4350: BEGIN
4351: l_Txn_Error_Rec.processed_flag := CSI_INV_TRXS_PKG.G_TXN_ERROR;
4352: RETURN l_Txn_Error_Rec;
4353: END Init_Txn_Error_Rec;

Line 4355: FUNCTION Init_Party_Query_Rec RETURN CSI_DATASTRUCTURES_PUB.Party_Query_Rec IS

4351: l_Txn_Error_Rec.processed_flag := CSI_INV_TRXS_PKG.G_TXN_ERROR;
4352: RETURN l_Txn_Error_Rec;
4353: END Init_Txn_Error_Rec;
4354:
4355: FUNCTION Init_Party_Query_Rec RETURN CSI_DATASTRUCTURES_PUB.Party_Query_Rec IS
4356: l_Party_Query_Rec CSI_DATASTRUCTURES_PUB.Party_Query_Rec;
4357: l_Party_Id NUMBER;
4358: l_relation_code VARCHAR2(30);
4359:

Line 4356: l_Party_Query_Rec CSI_DATASTRUCTURES_PUB.Party_Query_Rec;

4352: RETURN l_Txn_Error_Rec;
4353: END Init_Txn_Error_Rec;
4354:
4355: FUNCTION Init_Party_Query_Rec RETURN CSI_DATASTRUCTURES_PUB.Party_Query_Rec IS
4356: l_Party_Query_Rec CSI_DATASTRUCTURES_PUB.Party_Query_Rec;
4357: l_Party_Id NUMBER;
4358: l_relation_code VARCHAR2(30);
4359:
4360: CURSOR Relationship_Cur IS

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

4364:
4365: BEGIN
4366:
4367:
4368: l_Party_ID := csi_datastructures_pub.g_install_param_rec.internal_party_id;
4369:
4370: OPEN Relationship_Cur;
4371: FETCH Relationship_Cur INTO l_relation_code;
4372: CLOSE Relationship_Cur;

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

4503:
4504: RETURN l_inv_name;
4505: END get_inv_name;
4506:
4507: PROCEDURE log_csi_error(p_trx_error_rec IN CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC) IS
4508:
4509: l_api_version NUMBER := 1.0;
4510: l_commit VARCHAR2(1) := FND_API.G_FALSE;
4511: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;

Line 4517: l_trx_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;

4513: l_msg_count NUMBER;
4514: l_msg_data VARCHAR2(2000);
4515: l_txn_error_id NUMBER;
4516: l_return_status VARCHAR2(1);
4517: l_trx_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
4518: no_error_logged EXCEPTION;
4519: x_transaction_error_id NUMBER;
4520:
4521: BEGIN

Line 4635: CSI_DATASTRUCTURES_PUB.TRANSACTION_REC,

4631: END;
4632: END log_csi_error;
4633:
4634: PROCEDURE create_csi_txn(px_txn_rec IN OUT NOCOPY
4635: CSI_DATASTRUCTURES_PUB.TRANSACTION_REC,
4636: x_error_message OUT NOCOPY VARCHAR2,
4637: x_return_status OUT NOCOPY VARCHAR2) IS
4638:
4639:

Line 5224: x_instance_query_rec OUT NOCOPY csi_datastructures_pub.instance_query_rec,

5220: PROCEDURE set_item_attr_query_values(
5221: l_mtl_item_tbl IN CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE,
5222: table_index IN NUMBER,
5223: p_source IN VARCHAR2,
5224: x_instance_query_rec OUT NOCOPY csi_datastructures_pub.instance_query_rec,
5225: x_return_status OUT NOCOPY varchar2)
5226: IS
5227:
5228: l_instance_query_rec csi_datastructures_pub.instance_query_rec;

Line 5228: l_instance_query_rec csi_datastructures_pub.instance_query_rec;

5224: x_instance_query_rec OUT NOCOPY csi_datastructures_pub.instance_query_rec,
5225: x_return_status OUT NOCOPY varchar2)
5226: IS
5227:
5228: l_instance_query_rec csi_datastructures_pub.instance_query_rec;
5229: l_serial_tagged NUMBER := 1;
5230: l_returned_item varchar2(1) := 'N';
5231:
5232: BEGIN