DBA Data[Home] [Help]

APPS.CSI_ML_CREATE_PUB dependencies on CSI_ML_UTIL_PVT

Line 44: l_inst_id_tbl CSI_ML_UTIL_PVT.INST_INTERFACE_TBL_TYPE;

40: l_count NUMBER := 0;
41: l_commit_recs NUMBER := 0;
42: l_ext_tbl_count NUMBER := 0;
43:
44: l_inst_id_tbl CSI_ML_UTIL_PVT.INST_INTERFACE_TBL_TYPE;
45: l_party_contact_tbl CSI_ML_UTIL_PVT.PARTY_CONTACT_TBL_TYPE;
46: i PLS_INTEGER;
47: j PLS_INTEGER;
48: d PLS_INTEGER;

Line 45: l_party_contact_tbl CSI_ML_UTIL_PVT.PARTY_CONTACT_TBL_TYPE;

41: l_commit_recs NUMBER := 0;
42: l_ext_tbl_count NUMBER := 0;
43:
44: l_inst_id_tbl CSI_ML_UTIL_PVT.INST_INTERFACE_TBL_TYPE;
45: l_party_contact_tbl CSI_ML_UTIL_PVT.PARTY_CONTACT_TBL_TYPE;
46: i PLS_INTEGER;
47: j PLS_INTEGER;
48: d PLS_INTEGER;
49: c PLS_INTEGER;

Line 125: CSI_ML_UTIL_PVT.resolve_ids(p_txn_from_date,

121: IF nvl(p_resolve_ids,'Y') = 'Y'
122: THEN
123: -- Resolve all ID fields from Descriptive Fields
124:
125: CSI_ML_UTIL_PVT.resolve_ids(p_txn_from_date,
126: p_txn_to_date,
127: p_batch_name,
128: p_source_system_name,
129: l_return_status,

Line 228: CSI_ML_UTIL_PVT.log_create_errors(p_txn_from_date,

224: COMMIT;
225: END LOOP; -- End of For Loop
226:
227: -- Display errors in Concurrent Manager Log
228: CSI_ML_UTIL_PVT.log_create_errors(p_txn_from_date,
229: p_txn_to_date,
230: l_return_status,
231: l_error_message);
232:

Line 312: l_inst_id_tbl CSI_ML_UTIL_PVT.INST_INTERFACE_TBL_TYPE;

308: l_count NUMBER := 0;
309: l_commit_recs NUMBER := 0;
310: l_ext_tbl_count NUMBER := 0;
311:
312: l_inst_id_tbl CSI_ML_UTIL_PVT.INST_INTERFACE_TBL_TYPE;
313: l_party_contact_tbl CSI_ML_UTIL_PVT.PARTY_CONTACT_TBL_TYPE;
314: i PLS_INTEGER;
315: j PLS_INTEGER;
316: d PLS_INTEGER;

Line 313: l_party_contact_tbl CSI_ML_UTIL_PVT.PARTY_CONTACT_TBL_TYPE;

309: l_commit_recs NUMBER := 0;
310: l_ext_tbl_count NUMBER := 0;
311:
312: l_inst_id_tbl CSI_ML_UTIL_PVT.INST_INTERFACE_TBL_TYPE;
313: l_party_contact_tbl CSI_ML_UTIL_PVT.PARTY_CONTACT_TBL_TYPE;
314: i PLS_INTEGER;
315: j PLS_INTEGER;
316: d PLS_INTEGER;
317: c PLS_INTEGER;

Line 434: CSI_ML_UTIL_PVT.resolve_pw_ids(p_txn_from_date,

430: END IF;
431: IF l_tbl_count>0 -- Added
432: THEN
433: IF NVL(p_resolve_ids,'Y') = 'Y' THEN
434: CSI_ML_UTIL_PVT.resolve_pw_ids(p_txn_from_date,
435: p_txn_to_date,
436: p_source_system_name,
437: p_worker_id,
438: l_return_status,

Line 585: CSI_ML_UTIL_PVT.log_create_pw_errors(p_txn_from_date,

581: END; -- Bug 11073343
582:
583: END LOOP; -- End of For Loop
584:
585: CSI_ML_UTIL_PVT.log_create_pw_errors(p_txn_from_date,
586: p_txn_to_date,
587: p_source_system_name,
588: p_worker_id,
589: l_return_status,