DBA Data[Home] [Help]

APPS.CSI_ML_PROGRAM_PUB dependencies on CSI_ML_UTIL_PVT

Line 325: l_inst_id_tbl CSI_ML_UTIL_PVT.INST_INTERFACE_TBL_TYPE;

321: l_fnd_error VARCHAR2(1);
322: l_fnd_unexpected VARCHAR2(1);
323: l_api_name VARCHAR2(255) :=
324: 'CSI_ML_CREATE_PUB.EXECUTE_PARALLEL_CREATE';
325: l_inst_id_tbl CSI_ML_UTIL_PVT.INST_INTERFACE_TBL_TYPE;
326: ii PLS_INTEGER;
327: j PLS_INTEGER;
328: l_tbl_count NUMBER :=0;
329: l_dummy NUMBER;

Line 686: FND_File.Put_Line(Fnd_File.LOG,'Before calling csi_ml_util_pvt.resolve_rel_ids');

682: COMMIT;
683: END LOOP;
684:
685: IF(l_debug_level>1) THEN
686: FND_File.Put_Line(Fnd_File.LOG,'Before calling csi_ml_util_pvt.resolve_rel_ids');
687: END IF;
688: -- To resolve id columns
689: csi_ml_util_pvt.resolve_rel_ids
690: (p_source_system => p_source_system_name

Line 689: csi_ml_util_pvt.resolve_rel_ids

685: IF(l_debug_level>1) THEN
686: FND_File.Put_Line(Fnd_File.LOG,'Before calling csi_ml_util_pvt.resolve_rel_ids');
687: END IF;
688: -- To resolve id columns
689: csi_ml_util_pvt.resolve_rel_ids
690: (p_source_system => p_source_system_name
691: ,p_txn_from_date => p_txn_from_date
692: ,p_txn_to_date => p_txn_to_date
693: ,x_return_status => l_return_status

Line 697: FND_File.Put_Line(Fnd_File.LOG,'After calling csi_ml_util_pvt.resolve_rel_ids');

693: ,x_return_status => l_return_status
694: ,x_error_message => l_error_message
695: );
696: IF(l_debug_level>1) THEN
697: FND_File.Put_Line(Fnd_File.LOG,'After calling csi_ml_util_pvt.resolve_rel_ids');
698: END IF;
699:
700: csi_ml_util_pvt.eliminate_dup_records;
701: csi_ml_util_pvt.eliminate_dup_subject;

Line 700: csi_ml_util_pvt.eliminate_dup_records;

696: IF(l_debug_level>1) THEN
697: FND_File.Put_Line(Fnd_File.LOG,'After calling csi_ml_util_pvt.resolve_rel_ids');
698: END IF;
699:
700: csi_ml_util_pvt.eliminate_dup_records;
701: csi_ml_util_pvt.eliminate_dup_subject;
702: csi_ml_util_pvt.check_cyclic;
703:
704: OPEN relations_exist_cur;

Line 701: csi_ml_util_pvt.eliminate_dup_subject;

697: FND_File.Put_Line(Fnd_File.LOG,'After calling csi_ml_util_pvt.resolve_rel_ids');
698: END IF;
699:
700: csi_ml_util_pvt.eliminate_dup_records;
701: csi_ml_util_pvt.eliminate_dup_subject;
702: csi_ml_util_pvt.check_cyclic;
703:
704: OPEN relations_exist_cur;
705: FETCH relations_exist_cur INTO l_rel_dummy;

Line 702: csi_ml_util_pvt.check_cyclic;

698: END IF;
699:
700: csi_ml_util_pvt.eliminate_dup_records;
701: csi_ml_util_pvt.eliminate_dup_subject;
702: csi_ml_util_pvt.check_cyclic;
703:
704: OPEN relations_exist_cur;
705: FETCH relations_exist_cur INTO l_rel_dummy;
706: IF relations_exist_cur%NOTFOUND

Line 945: FND_File.Put_Line(Fnd_File.LOG,'Before calling csi_ml_util_pvt.resolve_rel_ids');

941: COMMIT;
942: END LOOP;
943:
944: IF(l_debug_level>1) THEN
945: FND_File.Put_Line(Fnd_File.LOG,'Before calling csi_ml_util_pvt.resolve_rel_ids');
946: END IF;
947: -- To resolve id columns
948: csi_ml_util_pvt.resolve_rel_ids
949: (p_source_system => p_source_system_name

Line 948: csi_ml_util_pvt.resolve_rel_ids

944: IF(l_debug_level>1) THEN
945: FND_File.Put_Line(Fnd_File.LOG,'Before calling csi_ml_util_pvt.resolve_rel_ids');
946: END IF;
947: -- To resolve id columns
948: csi_ml_util_pvt.resolve_rel_ids
949: (p_source_system => p_source_system_name
950: ,p_txn_from_date => p_txn_from_date
951: ,p_txn_to_date => p_txn_to_date
952: ,x_return_status => l_return_status

Line 956: FND_File.Put_Line(Fnd_File.LOG,'After calling csi_ml_util_pvt.resolve_rel_ids');

952: ,x_return_status => l_return_status
953: ,x_error_message => l_error_message
954: );
955: IF(l_debug_level>1) THEN
956: FND_File.Put_Line(Fnd_File.LOG,'After calling csi_ml_util_pvt.resolve_rel_ids');
957: END IF;
958:
959: csi_ml_util_pvt.eliminate_dup_records;
960: csi_ml_util_pvt.eliminate_dup_subject;

Line 959: csi_ml_util_pvt.eliminate_dup_records;

955: IF(l_debug_level>1) THEN
956: FND_File.Put_Line(Fnd_File.LOG,'After calling csi_ml_util_pvt.resolve_rel_ids');
957: END IF;
958:
959: csi_ml_util_pvt.eliminate_dup_records;
960: csi_ml_util_pvt.eliminate_dup_subject;
961: csi_ml_util_pvt.check_cyclic;
962:
963: OPEN relations_exist_cur;

Line 960: csi_ml_util_pvt.eliminate_dup_subject;

956: FND_File.Put_Line(Fnd_File.LOG,'After calling csi_ml_util_pvt.resolve_rel_ids');
957: END IF;
958:
959: csi_ml_util_pvt.eliminate_dup_records;
960: csi_ml_util_pvt.eliminate_dup_subject;
961: csi_ml_util_pvt.check_cyclic;
962:
963: OPEN relations_exist_cur;
964: FETCH relations_exist_cur INTO l_rel_dummy;

Line 961: csi_ml_util_pvt.check_cyclic;

957: END IF;
958:
959: csi_ml_util_pvt.eliminate_dup_records;
960: csi_ml_util_pvt.eliminate_dup_subject;
961: csi_ml_util_pvt.check_cyclic;
962:
963: OPEN relations_exist_cur;
964: FETCH relations_exist_cur INTO l_rel_dummy;
965: IF relations_exist_cur%NOTFOUND