APPS.PER_CALENDAR_ENTRIES_LOAD_PKG dependencies on PER_CALENDAR_ENTRIES

Line 1: package body PER_CALENDAR_ENTRIES_LOAD_PKG as

1: package body PER_CALENDAR_ENTRIES_LOAD_PKG as
2: /* $Header: peentlct.pkb 120.0 2005/05/31 08:08 appldev noship $ */
3:
4: procedure KEY_TO_IDS (
5: X_IDENTIFIER_KEY in VARCHAR2,

Line 36: from PER_CALENDAR_ENTRIES ENT

32: cursor CSR_CALENDAR_ENTRY (
33: X_IDENTIFIER_KEY in VARCHAR2
34: ) is
35: select ENT.CALENDAR_ENTRY_ID
36: from PER_CALENDAR_ENTRIES ENT
37: where ENT.IDENTIFIER_KEY = X_IDENTIFIER_KEY;
38:
39: cursor CSR_SEQUENCE is
40: select PER_CALENDAR_ENTRIES_S.nextval

Line 40: select PER_CALENDAR_ENTRIES_S.nextval

36: from PER_CALENDAR_ENTRIES ENT
37: where ENT.IDENTIFIER_KEY = X_IDENTIFIER_KEY;
38:
39: cursor CSR_SEQUENCE is
40: select PER_CALENDAR_ENTRIES_S.nextval
41: from dual;
42:
43: cursor CSR_BUS_GRP (
44: X_BUS_GRP_NAME in VARCHAR2

Line 142: cursor C is select ROWID from PER_CALENDAR_ENTRIES

138: X_BUS_GRP_ID in NUMBER,
139: X_IDENTIFIER_KEY in VARCHAR2,
140: X_LEGISLATION_CODE in VARCHAR2
141: ) is
142: cursor C is select ROWID from PER_CALENDAR_ENTRIES
143: where CALENDAR_ENTRY_ID = X_CALENDAR_ENTRY_ID
144: ;
145: csr_row C%rowtype;
146: begin

Line 147: insert into PER_CALENDAR_ENTRIES (

143: where CALENDAR_ENTRY_ID = X_CALENDAR_ENTRY_ID
144: ;
145: csr_row C%rowtype;
146: begin
147: insert into PER_CALENDAR_ENTRIES (
148: CALENDAR_ENTRY_ID,
149: NAME,
150: TYPE,
151: START_DATE,

Line 263: PER_CALENDAR_ENTRIES_LOAD_PKG.UPDATE_ROW (

259: else
260: user_id := 0;
261: end if;
262:
263: PER_CALENDAR_ENTRIES_LOAD_PKG.UPDATE_ROW (
264: X_CALENDAR_ENTRY_ID => X_CALENDAR_ENTRY_ID
265: ,X_NAME => X_NAME
266: ,X_TYPE => X_TYPE
267: ,X_START_DATE => to_date(X_START_DATE,'DD/MM/YYYY')

Line 287: PER_CALENDAR_ENTRIES_LOAD_PKG.INSERT_ROW (

283: when NO_DATA_FOUND then
284: -- insert a row with NULL business group (meaningless)
285: -- as data is created at Legislation level.
286: -- (UI restricts on BG, or Leg Code).
287: PER_CALENDAR_ENTRIES_LOAD_PKG.INSERT_ROW (
288: X_CALENDAR_ENTRY_ID => X_CALENDAR_ENTRY_ID
289: ,X_NAME => X_NAME
290: ,X_TYPE => X_TYPE
291: ,X_START_DATE => to_date(X_START_DATE,'DD/MM/YYYY')

Line 332: update PER_CALENDAR_ENTRIES set

328: X_LAST_UPDATE_DATE in DATE,
329: X_LAST_UPDATED_BY in NUMBER,
330: X_LAST_UPDATE_LOGIN in NUMBER) is
331: begin
332: update PER_CALENDAR_ENTRIES set
333: NAME = X_NAME,
334: TYPE = X_TYPE,
335: START_DATE = X_START_DATE,
336: END_DATE = X_END_DATE,

Line 357: end PER_CALENDAR_ENTRIES_LOAD_PKG;

353: end if;
354:
355: end UPDATE_ROW;
356:
357: end PER_CALENDAR_ENTRIES_LOAD_PKG;