DBA Data[Home] [Help]

APPS.CSI_ML_CREATE_PUB dependencies on CSI_DATASTRUCTURES_PUB

Line 14: l_txn_tbl CSI_DATASTRUCTURES_PUB.TRANSACTION_TBL;

10: p_batch_name IN VARCHAR2,
11: p_source_system_name IN VARCHAR2,
12: p_resolve_ids IN VARCHAR2) IS
13:
14: l_txn_tbl CSI_DATASTRUCTURES_PUB.TRANSACTION_TBL;
15: l_return_status VARCHAR2(1);
16: l_error_message VARCHAR2(2000);
17: l_instance_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_TBL;
18: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

Line 17: l_instance_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_TBL;

13:
14: l_txn_tbl CSI_DATASTRUCTURES_PUB.TRANSACTION_TBL;
15: l_return_status VARCHAR2(1);
16: l_error_message VARCHAR2(2000);
17: l_instance_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_TBL;
18: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
19: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
20: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
21: l_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;

Line 18: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

14: l_txn_tbl CSI_DATASTRUCTURES_PUB.TRANSACTION_TBL;
15: l_return_status VARCHAR2(1);
16: l_error_message VARCHAR2(2000);
17: l_instance_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_TBL;
18: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
19: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
20: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
21: l_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
22: l_price_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;

Line 19: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;

15: l_return_status VARCHAR2(1);
16: l_error_message VARCHAR2(2000);
17: l_instance_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_TBL;
18: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
19: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
20: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
21: l_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
22: l_price_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
23: l_org_assign_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;

Line 20: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;

16: l_error_message VARCHAR2(2000);
17: l_instance_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_TBL;
18: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
19: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
20: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
21: l_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
22: l_price_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
23: l_org_assign_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
24: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;

Line 21: l_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;

17: l_instance_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_TBL;
18: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
19: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
20: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
21: l_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
22: l_price_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
23: l_org_assign_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
24: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
25: l_grp_error_tbl CSI_DATASTRUCTURES_PUB.GRP_ERROR_TBL;

Line 22: l_price_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;

18: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
19: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
20: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
21: l_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
22: l_price_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
23: l_org_assign_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
24: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
25: l_grp_error_tbl CSI_DATASTRUCTURES_PUB.GRP_ERROR_TBL;
26: l_api_version NUMBER := 1.0;

Line 23: l_org_assign_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;

19: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
20: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
21: l_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
22: l_price_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
23: l_org_assign_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
24: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
25: l_grp_error_tbl CSI_DATASTRUCTURES_PUB.GRP_ERROR_TBL;
26: l_api_version NUMBER := 1.0;
27: l_commit VARCHAR2(1) := fnd_api.g_false;

Line 24: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;

20: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
21: l_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
22: l_price_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
23: l_org_assign_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
24: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
25: l_grp_error_tbl CSI_DATASTRUCTURES_PUB.GRP_ERROR_TBL;
26: l_api_version NUMBER := 1.0;
27: l_commit VARCHAR2(1) := fnd_api.g_false;
28: l_init_msg_list VARCHAR2(1) := fnd_api.g_true;

Line 25: l_grp_error_tbl CSI_DATASTRUCTURES_PUB.GRP_ERROR_TBL;

21: l_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
22: l_price_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
23: l_org_assign_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
24: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
25: l_grp_error_tbl CSI_DATASTRUCTURES_PUB.GRP_ERROR_TBL;
26: l_api_version NUMBER := 1.0;
27: l_commit VARCHAR2(1) := fnd_api.g_false;
28: l_init_msg_list VARCHAR2(1) := fnd_api.g_true;
29: l_validation_level NUMBER := fnd_api.g_valid_level_full;

Line 282: l_txn_tbl CSI_DATASTRUCTURES_PUB.TRANSACTION_TBL;

278: p_source_system_name IN VARCHAR2,
279: p_worker_id IN NUMBER,
280: p_resolve_ids IN VARCHAR2) IS
281:
282: l_txn_tbl CSI_DATASTRUCTURES_PUB.TRANSACTION_TBL;
283: l_return_status VARCHAR2(1);
284: l_error_message VARCHAR2(2000);
285: l_instance_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_TBL;
286: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

Line 285: l_instance_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_TBL;

281:
282: l_txn_tbl CSI_DATASTRUCTURES_PUB.TRANSACTION_TBL;
283: l_return_status VARCHAR2(1);
284: l_error_message VARCHAR2(2000);
285: l_instance_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_TBL;
286: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
287: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
288: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
289: l_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;

Line 286: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

282: l_txn_tbl CSI_DATASTRUCTURES_PUB.TRANSACTION_TBL;
283: l_return_status VARCHAR2(1);
284: l_error_message VARCHAR2(2000);
285: l_instance_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_TBL;
286: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
287: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
288: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
289: l_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
290: l_price_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;

Line 287: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;

283: l_return_status VARCHAR2(1);
284: l_error_message VARCHAR2(2000);
285: l_instance_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_TBL;
286: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
287: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
288: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
289: l_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
290: l_price_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
291: l_org_assign_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;

Line 288: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;

284: l_error_message VARCHAR2(2000);
285: l_instance_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_TBL;
286: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
287: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
288: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
289: l_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
290: l_price_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
291: l_org_assign_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
292: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;

Line 289: l_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;

285: l_instance_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_TBL;
286: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
287: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
288: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
289: l_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
290: l_price_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
291: l_org_assign_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
292: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
293: l_grp_error_tbl CSI_DATASTRUCTURES_PUB.GRP_ERROR_TBL;

Line 290: l_price_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;

286: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
287: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
288: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
289: l_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
290: l_price_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
291: l_org_assign_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
292: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
293: l_grp_error_tbl CSI_DATASTRUCTURES_PUB.GRP_ERROR_TBL;
294: l_api_version NUMBER := 1.0;

Line 291: l_org_assign_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;

287: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
288: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
289: l_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
290: l_price_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
291: l_org_assign_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
292: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
293: l_grp_error_tbl CSI_DATASTRUCTURES_PUB.GRP_ERROR_TBL;
294: l_api_version NUMBER := 1.0;
295: l_commit VARCHAR2(1) := fnd_api.g_false;

Line 292: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;

288: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
289: l_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
290: l_price_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
291: l_org_assign_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
292: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
293: l_grp_error_tbl CSI_DATASTRUCTURES_PUB.GRP_ERROR_TBL;
294: l_api_version NUMBER := 1.0;
295: l_commit VARCHAR2(1) := fnd_api.g_false;
296: l_init_msg_list VARCHAR2(1) := fnd_api.g_true;

Line 293: l_grp_error_tbl CSI_DATASTRUCTURES_PUB.GRP_ERROR_TBL;

289: l_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
290: l_price_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
291: l_org_assign_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
292: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
293: l_grp_error_tbl CSI_DATASTRUCTURES_PUB.GRP_ERROR_TBL;
294: l_api_version NUMBER := 1.0;
295: l_commit VARCHAR2(1) := fnd_api.g_false;
296: l_init_msg_list VARCHAR2(1) := fnd_api.g_true;
297: l_validation_level NUMBER := fnd_api.g_valid_level_full;

Line 667: l_relationship_tbl CSI_DATASTRUCTURES_PUB.II_RELATIONSHIP_TBL;

663: p_source_system_name IN VARCHAR2) IS
664:
665: l_return_status VARCHAR2(10);
666: l_error_message VARCHAR2(2000);
667: l_relationship_tbl CSI_DATASTRUCTURES_PUB.II_RELATIONSHIP_TBL;
668: l_txn_tbl CSI_DATASTRUCTURES_PUB.TRANSACTION_TBL;
669: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
670: l_api_version NUMBER := 1.0;
671: l_commit VARCHAR2(1) := fnd_api.g_false;

Line 668: l_txn_tbl CSI_DATASTRUCTURES_PUB.TRANSACTION_TBL;

664:
665: l_return_status VARCHAR2(10);
666: l_error_message VARCHAR2(2000);
667: l_relationship_tbl CSI_DATASTRUCTURES_PUB.II_RELATIONSHIP_TBL;
668: l_txn_tbl CSI_DATASTRUCTURES_PUB.TRANSACTION_TBL;
669: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
670: l_api_version NUMBER := 1.0;
671: l_commit VARCHAR2(1) := fnd_api.g_false;
672: l_init_msg_list VARCHAR2(1) := fnd_api.g_true;

Line 669: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;

665: l_return_status VARCHAR2(10);
666: l_error_message VARCHAR2(2000);
667: l_relationship_tbl CSI_DATASTRUCTURES_PUB.II_RELATIONSHIP_TBL;
668: l_txn_tbl CSI_DATASTRUCTURES_PUB.TRANSACTION_TBL;
669: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
670: l_api_version NUMBER := 1.0;
671: l_commit VARCHAR2(1) := fnd_api.g_false;
672: l_init_msg_list VARCHAR2(1) := fnd_api.g_true;
673: l_validation_level NUMBER := fnd_api.g_valid_level_full;