APPS.AMS_SCHEDULER_B_PKG dependencies on AMS_SCHEDULER

Line 1: PACKAGE BODY AMS_SCHEDULER_B_PKG as

1: PACKAGE BODY AMS_SCHEDULER_B_PKG as
2: /* $Header: amstrptb.pls 120.0 2005/07/01 03:51:43 appldev noship $ */
3:
4: -- ===============================================================
5: -- Start of Comments

Line 7: -- AMS_SCHEDULER_B_PKG

3:
4: -- ===============================================================
5: -- Start of Comments
6: -- Package name
7: -- AMS_SCHEDULER_B_PKG
8: --
9: -- Purpose
10: -- Private api created to Update/insert/Delete the repeating schedule details.
11: --

Line 22: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_SCHEDULER_B_PKG';

18: -- End of Comments
19: -- ===============================================================
20:
21:
22: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_SCHEDULER_B_PKG';
23: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amstrptb.pls';
24:
25:
26:

Line 66: INSERT INTO AMS_SCHEDULER(

62: END IF;
63:
64: AMS_UTILITY_PVT.debug_message('ANIRBAN table handler '||l_last_update_date);
65:
66: INSERT INTO AMS_SCHEDULER(
67: scheduler_id,
68: created_by,
69: creation_date,
70: last_updated_by,

Line 121: Update AMS_SCHEDULER

117: p_frequency NUMBER,
118: p_frequency_type VARCHAR2)
119: IS
120: BEGIN
121: Update AMS_SCHEDULER
122: SET
123: scheduler_id = DECODE( p_scheduler_id, FND_API.g_miss_num, scheduler_id, p_scheduler_id),
124: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
125: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),

Line 157: DELETE FROM AMS_SCHEDULER

153: p_scheduler_id NUMBER)
154:
155: IS
156: BEGIN
157: DELETE FROM AMS_SCHEDULER
158: WHERE SCHEDULER_ID = p_scheduler_id;
159: If (SQL%NOTFOUND) then
160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
161: END IF;

Line 183: FROM AMS_SCHEDULER

179:
180: IS
181: CURSOR C IS
182: SELECT *
183: FROM AMS_SCHEDULER
184: WHERE SCHEDULER_ID = p_scheduler_id
185: FOR UPDATE of SCHEDULER_ID NOWAIT;
186: Recinfo C%ROWTYPE;
187: BEGIN

Line 200: END AMS_SCHEDULER_B_PKG;

196:
197: END Lock_Row;
198:
199:
200: END AMS_SCHEDULER_B_PKG;