APPS.AMS_TCOP_SCHEDULER_PKG dependencies on AMS_TCOP_SCHEDULER_PKG

Line 1: PACKAGE BODY AMS_TCOP_SCHEDULER_PKG AS

1: PACKAGE BODY AMS_TCOP_SCHEDULER_PKG AS
2: /* $Header: amsvtcsb.pls 120.0.12010000.2 2008/09/25 05:25:24 amlal ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_TCOP_SCHEDULER_PKG

2: /* $Header: amsvtcsb.pls 120.0.12010000.2 2008/09/25 05:25:24 amlal ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMS_TCOP_SCHEDULER_PKG
7: -- Purpose
8: --
9: -- This package contains all the program units for traffic cop
10: -- Scheduler

Line 134: AMS_Utility_PVT.Write_Conc_Log('AMS_TCOP_SCHEDULER_PKG.DEQUEUE ==> Entered DEQUEUE');

130:
131:
132:
133: BEGIN
134: AMS_Utility_PVT.Write_Conc_Log('AMS_TCOP_SCHEDULER_PKG.DEQUEUE ==> Entered DEQUEUE');
135:
136: FOR C1 IN C_GET_QUEUED_REQUESTS
137: LOOP
138: UPDATE_STATUS(C1.SCHEDULE_ID,'SCHEDULED');

Line 140: AMS_Utility_PVT.Write_Conc_Log('AMS_TCOP_SCHEDULER_PKG.DEQUEUE ==> Starting to apply Fatigue Rules for Schedule Id = ' || C1.SCHEDULE_ID);

136: FOR C1 IN C_GET_QUEUED_REQUESTS
137: LOOP
138: UPDATE_STATUS(C1.SCHEDULE_ID,'SCHEDULED');
139: AMS_Utility_PVT.Write_Conc_Log('========= ' || C1.SCHEDULE_ID || ' =========');
140: AMS_Utility_PVT.Write_Conc_Log('AMS_TCOP_SCHEDULER_PKG.DEQUEUE ==> Starting to apply Fatigue Rules for Schedule Id = ' || C1.SCHEDULE_ID);
141: WF_ENGINE.COMPLETEACTIVITY(C1.WF_ITEM_TYPE,
142: C1.WF_ITEM_ID,
143: 'AMS_TRAFFIC_COP:BLOCK1',
144: wf_engine.eng_null);

Line 145: AMS_Utility_PVT.Write_Conc_Log('AMS_TCOP_SCHEDULER_PKG.DEQUEUE ==> Before Commiting Fatigue Rules for Schedule Id = ' || C1.SCHEDULE_ID);

141: WF_ENGINE.COMPLETEACTIVITY(C1.WF_ITEM_TYPE,
142: C1.WF_ITEM_ID,
143: 'AMS_TRAFFIC_COP:BLOCK1',
144: wf_engine.eng_null);
145: AMS_Utility_PVT.Write_Conc_Log('AMS_TCOP_SCHEDULER_PKG.DEQUEUE ==> Before Commiting Fatigue Rules for Schedule Id = ' || C1.SCHEDULE_ID);
146: commit;
147: AMS_Utility_PVT.Write_Conc_Log('AMS_TCOP_SCHEDULER_PKG.DEQUEUE ==> After Commiting Fatigue Rules for Schedule Id = ' || C1.SCHEDULE_ID);
148: AMS_Utility_PVT.Write_Conc_Log('========= ' || C1.SCHEDULE_ID || ' =========');
149:

Line 147: AMS_Utility_PVT.Write_Conc_Log('AMS_TCOP_SCHEDULER_PKG.DEQUEUE ==> After Commiting Fatigue Rules for Schedule Id = ' || C1.SCHEDULE_ID);

143: 'AMS_TRAFFIC_COP:BLOCK1',
144: wf_engine.eng_null);
145: AMS_Utility_PVT.Write_Conc_Log('AMS_TCOP_SCHEDULER_PKG.DEQUEUE ==> Before Commiting Fatigue Rules for Schedule Id = ' || C1.SCHEDULE_ID);
146: commit;
147: AMS_Utility_PVT.Write_Conc_Log('AMS_TCOP_SCHEDULER_PKG.DEQUEUE ==> After Commiting Fatigue Rules for Schedule Id = ' || C1.SCHEDULE_ID);
148: AMS_Utility_PVT.Write_Conc_Log('========= ' || C1.SCHEDULE_ID || ' =========');
149:
150: END LOOP;
151:

Line 152: AMS_Utility_PVT.Write_Conc_Log('AMS_TCOP_SCHEDULER_PKG.DEQUEUE ==> Exiting DEQUEUE');

148: AMS_Utility_PVT.Write_Conc_Log('========= ' || C1.SCHEDULE_ID || ' =========');
149:
150: END LOOP;
151:
152: AMS_Utility_PVT.Write_Conc_Log('AMS_TCOP_SCHEDULER_PKG.DEQUEUE ==> Exiting DEQUEUE');
153:
154:
155: END DEQUEUE;
156:

Line 169: END AMS_TCOP_SCHEDULER_PKG;

165: WHERE schedule_id=p_schedule_id;
166:
167: END UPDATE_STATUS;
168:
169: END AMS_TCOP_SCHEDULER_PKG;