APPS.AMS_TCOP_ENGINE_PKG dependencies on AMS_TCOP_FATIGUED_BY

Line 682: -- SELECT AMS_TCOP_FATIGUED_BY_S.NEXTVAL

678:
679: -- Get the Sequence value
680: -- CURSOR C_GET_NEXT_FATIGUE_BY_SEQ
681: -- IS
682: -- SELECT AMS_TCOP_FATIGUED_BY_S.NEXTVAL
683: -- FROM DUAL;
684:
685: TYPE Number_Table is Table of Number INDEX BY BINARY_INTEGER;
686:

Line 1048: 'Ready to create entries in AMS_TCOP_FATIGUED_BY. Number of entries = '||to_char(l_count)

1044: l_count := G_Fatigue_By_Entry_List.count;
1045: write_debug_message(LOG_LEVEL_PROCEDURE,
1046: PROCEDURE_NAME,
1047: l_label,
1048: 'Ready to create entries in AMS_TCOP_FATIGUED_BY. Number of entries = '||to_char(l_count)
1049: );
1050: AMS_Utility_PVT.Write_Conc_Log('AMS_TCOP_ENGINE_PKG.Apply_Fatigue_Rules ====> Ready to create entries in AMS_TCOP_FATIGUED_BY. Number of entries = '||to_char(l_count));
1051:
1052:

Line 1050: AMS_Utility_PVT.Write_Conc_Log('AMS_TCOP_ENGINE_PKG.Apply_Fatigue_Rules ====> Ready to create entries in AMS_TCOP_FATIGUED_BY. Number of entries = '||to_char(l_count));

1046: PROCEDURE_NAME,
1047: l_label,
1048: 'Ready to create entries in AMS_TCOP_FATIGUED_BY. Number of entries = '||to_char(l_count)
1049: );
1050: AMS_Utility_PVT.Write_Conc_Log('AMS_TCOP_ENGINE_PKG.Apply_Fatigue_Rules ====> Ready to create entries in AMS_TCOP_FATIGUED_BY. Number of entries = '||to_char(l_count));
1051:
1052:
1053: --Bulk Insert into AMS_TCOP_FATIGUED_BY table
1054: IF(l_count > 0) THEN

Line 1053: --Bulk Insert into AMS_TCOP_FATIGUED_BY table

1049: );
1050: AMS_Utility_PVT.Write_Conc_Log('AMS_TCOP_ENGINE_PKG.Apply_Fatigue_Rules ====> Ready to create entries in AMS_TCOP_FATIGUED_BY. Number of entries = '||to_char(l_count));
1051:
1052:
1053: --Bulk Insert into AMS_TCOP_FATIGUED_BY table
1054: IF(l_count > 0) THEN
1055: -- Create an array of Sequence number
1056: -- FOR i in G_Fatigue_By_Entry_List.FIRST .. G_Fatigue_By_Entry_List.LAST
1057: -- LOOP

Line 1087: AMS_TCOP_FATIGUED_BY

1083: -- Do a Bulk Insert into AMS_TCOP_FATIGUE_BY Table
1084: FOR i in G_Fatigue_By_Entry_List.FIRST .. G_Fatigue_By_Entry_List.LAST
1085: LOOP
1086: INSERT INTO
1087: AMS_TCOP_FATIGUED_BY
1088: (fatigued_by_id,
1089: list_entry_id,
1090: schedule_id,
1091: creation_date,

Line 1099: AMS_TCOP_FATIGUED_BY_S.NEXTVAL,

1095: last_update_login
1096: )
1097: VALUES
1098: (--l_fatigue_by_id_list(i),
1099: AMS_TCOP_FATIGUED_BY_S.NEXTVAL,
1100: G_Fatigue_By_Entry_List(i),
1101: G_Fatigue_By_Schedule_List(i),
1102: sysdate,
1103: FND_GLOBAL.USER_ID,

Line 1113: 'After Calling BULK Insert into AMS_TCOP_FATIGUED_BY'

1109:
1110: write_debug_message(LOG_LEVEL_EVENT,
1111: PROCEDURE_NAME,
1112: l_label,
1113: 'After Calling BULK Insert into AMS_TCOP_FATIGUED_BY'
1114: );
1115:
1116: write_debug_message(LOG_LEVEL_EVENT,
1117: PROCEDURE_NAME,