APPS.AMS_TCOP_PERIODS_PKG dependencies on AMS_TCOP_FR_PERIODS_B

Line 17: cursor c is select ROWID from AMS_TCOP_FR_PERIODS_B

13: X_CREATED_BY in NUMBER,
14: X_LAST_UPDATE_LOGIN in NUMBER,
15: X_OBJECT_VERSION_NUMBER in NUMBER
16: ) is
17: cursor c is select ROWID from AMS_TCOP_FR_PERIODS_B
18: where PERIOD_ID = X_PERIOD_ID
19: ;
20: cursor ctl is select ROWID from AMS_TCOP_FR_PERIODS_TL
21: where PERIOD_ID = X_PERIOD_ID

Line 24: insert into AMS_TCOP_FR_PERIODS_B (

20: cursor ctl is select ROWID from AMS_TCOP_FR_PERIODS_TL
21: where PERIOD_ID = X_PERIOD_ID
22: ;
23: begin
24: insert into AMS_TCOP_FR_PERIODS_B (
25: PERIOD_ID,
26: NO_OF_DAYS,
27: ENABLED_FLAG,
28: LAST_UPDATE_DATE,

Line 115: from AMS_TCOP_FR_PERIODS_B

111: LAST_UPDATED_BY,
112: CREATION_DATE,
113: CREATED_BY,
114: LAST_UPDATE_LOGIN
115: from AMS_TCOP_FR_PERIODS_B
116: where PERIOD_ID = X_PERIOD_ID
117: for update of PERIOD_ID nowait;
118: recinfo c%rowtype;
119:

Line 185: update AMS_TCOP_FR_PERIODS_B set

181: X_LAST_UPDATED_BY in NUMBER,
182: X_LAST_UPDATE_LOGIN in NUMBER
183: ) is
184: begin
185: update AMS_TCOP_FR_PERIODS_B set
186: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER
187: ,NO_OF_DAYS = X_NO_OF_DAYS
188: ,ENABLED_FLAG = X_ENABLED_FLAG
189: ,LAST_UPDATE_DATE = X_LAST_UPDATE_DATE

Line 226: delete from AMS_TCOP_FR_PERIODS_B

222: if (sql%notfound) then
223: raise no_data_found;
224: end if;
225:
226: delete from AMS_TCOP_FR_PERIODS_B
227: where PERIOD_ID = X_PERIOD_ID;
228:
229: if (sql%notfound) then
230: raise no_data_found;

Line 256: from AMS_TCOP_FR_PERIODS_B

252:
253: cursor c_obj_verno is
254: select OBJECT_VERSION_NUMBER,
255: last_updated_by
256: from AMS_TCOP_FR_PERIODS_B
257: where PERIOD_ID = X_PERIOD_ID;
258:
259: cursor c_chk_prd_exists is
260: select 'x'

Line 261: from AMS_TCOP_FR_PERIODS_B

257: where PERIOD_ID = X_PERIOD_ID;
258:
259: cursor c_chk_prd_exists is
260: select 'x'
261: from AMS_TCOP_FR_PERIODS_B
262: where PERIOD_ID = X_PERIOD_ID;
263:
264: cursor ctl_chk_prd_exists is
265: select 'x'

Line 376: FROM AMS_TCOP_FR_PERIODS_B B

372: BEGIN
373: DELETE FROM AMS_TCOP_FR_PERIODS_TL T
374: WHERE NOT EXISTS
375: (SELECT NULL
376: FROM AMS_TCOP_FR_PERIODS_B B
377: WHERE B.PERIOD_ID = T.PERIOD_ID
378: );
379:
380: UPDATE AMS_TCOP_FR_PERIODS_TL T SET (