APPS.PER_CAL_ENTRY_VALUES_LOAD_PKG dependencies on PER_CAL_ENTRY_VALUES

Line 1: package body PER_CAL_ENTRY_VALUES_LOAD_PKG as

1: package body PER_CAL_ENTRY_VALUES_LOAD_PKG as
2: /* $Header: peenvlct.pkb 120.0 2005/05/31 08:10 appldev noship $ */
3:
4:
5: procedure KEY_TO_IDS (

Line 24: from PER_CAL_ENTRY_VALUES ENV

20: X_ORGANIZATION_ID out nocopy NUMBER) IS
21:
22: cursor CSR_CAL_ENTRY_VALUES (X_VALUE IN VARCHAR2) is
23: select ENV.CAL_ENTRY_VALUE_ID
24: from PER_CAL_ENTRY_VALUES ENV
25: where ENV.IDENTIFIER_KEY = X_VALUE;
26:
27: cursor CSR_SEQUENCE is
28: select PER_CAL_ENTRY_VALUES_S.nextval

Line 28: select PER_CAL_ENTRY_VALUES_S.nextval

24: from PER_CAL_ENTRY_VALUES ENV
25: where ENV.IDENTIFIER_KEY = X_VALUE;
26:
27: cursor CSR_SEQUENCE is
28: select PER_CAL_ENTRY_VALUES_S.nextval
29: from dual;
30:
31: cursor CSR_CALENDAR_ENTRY is
32: select ENT.CALENDAR_ENTRY_ID

Line 137: cursor C is select ROWID from PER_CAL_ENTRY_VALUES

133: X_LAST_UPDATE_LOGIN in NUMBER,
134: X_CREATION_DATE in DATE,
135: X_IDENTIFIER_KEY in VARCHAR2) is
136:
137: cursor C is select ROWID from PER_CAL_ENTRY_VALUES
138: where CAL_ENTRY_VALUE_ID = X_CAL_ENTRY_VALUE_ID;
139: csr_row C%rowtype;
140: begin
141: insert into PER_CAL_ENTRY_VALUES (

Line 141: insert into PER_CAL_ENTRY_VALUES (

137: cursor C is select ROWID from PER_CAL_ENTRY_VALUES
138: where CAL_ENTRY_VALUE_ID = X_CAL_ENTRY_VALUE_ID;
139: csr_row C%rowtype;
140: begin
141: insert into PER_CAL_ENTRY_VALUES (
142: CAL_ENTRY_VALUE_ID,
143: CALENDAR_ENTRY_ID,
144: HIERARCHY_NODE_ID,
145: IDVALUE,

Line 243: PER_CAL_ENTRY_VALUES_LOAD_PKG.UPDATE_ROW (

239: else
240: user_id := 0;
241: end if;
242:
243: PER_CAL_ENTRY_VALUES_LOAD_PKG.UPDATE_ROW (
244: X_CAL_ENTRY_VALUE_ID => X_CAL_ENTRY_VALUE_ID
245: ,X_HIERARCHY_NODE_ID => X_HIERARCHY_NODE_ID
246: ,X_IDVALUE => X_IDVALUE
247: ,X_ORG_STRUCTURE_ELEMENT_ID => X_ORG_STRUCTURE_ELEMENT_ID

Line 258: PER_CAL_ENTRY_VALUES_LOAD_PKG.INSERT_ROW (

254: ,X_LAST_UPDATE_LOGIN => user_id);
255:
256: exception
257: when NO_DATA_FOUND then
258: PER_CAL_ENTRY_VALUES_LOAD_PKG.INSERT_ROW (
259: X_CAL_ENTRY_VALUE_ID => X_CAL_ENTRY_VALUE_ID
260: ,X_CALENDAR_ENTRY_ID => X_CALENDAR_ENTRY_ID
261: ,X_HIERARCHY_NODE_ID => X_HIERARCHY_NODE_ID
262: ,X_IDVALUE => X_IDVALUE

Line 292: update PER_CAL_ENTRY_VALUES set

288: X_LAST_UPDATED_BY in NUMBER,
289: X_LAST_UPDATE_LOGIN in NUMBER) IS
290:
291: begin
292: update PER_CAL_ENTRY_VALUES set
293: HIERARCHY_NODE_ID = X_HIERARCHY_NODE_ID,
294: IDVALUE = X_IDVALUE,
295: ORG_STRUCTURE_ELEMENT_ID = X_ORG_STRUCTURE_ELEMENT_ID,
296: ORGANIZATION_ID = X_ORGANIZATION_ID,

Line 311: end PER_CAL_ENTRY_VALUES_LOAD_PKG;

307: end if;
308:
309: end UPDATE_ROW;
310:
311: end PER_CAL_ENTRY_VALUES_LOAD_PKG;