DBA Data[Home] [Help]

APPS.PER_CAL_ENTRY_VALUES_LOAD_PKG dependencies on PER_CAL_ENTRY_VALUES_S

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 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,