APPS.HR_ITEM_CONTEXTS_PKG dependencies on HR_ITEM_CONTEXTS

Line 1: package body HR_ITEM_CONTEXTS_PKG as

1: package body HR_ITEM_CONTEXTS_PKG as
2: /* $Header: hricxlct.pkb 115.1 2002/12/10 12:29:00 hjonnala noship $ */
3: procedure OWNER_TO_WHO (
4: X_OWNER in VARCHAR2,
5: X_CREATION_DATE out nocopy DATE,

Line 67: cursor C is select ROWID from HR_ITEM_CONTEXTS

63: X_LAST_UPDATE_DATE in DATE,
64: X_LAST_UPDATED_BY in NUMBER,
65: X_LAST_UPDATE_LOGIN in NUMBER
66: ) is
67: cursor C is select ROWID from HR_ITEM_CONTEXTS
68: where ITEM_CONTEXT_ID = X_ITEM_CONTEXT_ID
69: ;
70: begin
71: insert into HR_ITEM_CONTEXTS (

Line 71: insert into HR_ITEM_CONTEXTS (

67: cursor C is select ROWID from HR_ITEM_CONTEXTS
68: where ITEM_CONTEXT_ID = X_ITEM_CONTEXT_ID
69: ;
70: begin
71: insert into HR_ITEM_CONTEXTS (
72: LAST_UPDATED_BY,
73: LAST_UPDATE_LOGIN,
74: CREATED_BY,
75: CREATION_DATE,

Line 240: from HR_ITEM_CONTEXTS

236: SEGMENT29,
237: SEGMENT30,
238: START_DATE_ACTIVE,
239: ENABLED_FLAG
240: from HR_ITEM_CONTEXTS
241: where ITEM_CONTEXT_ID = X_ITEM_CONTEXT_ID
242: for update of ITEM_CONTEXT_ID nowait;
243: begin
244: for tlinfo in c1 loop

Line 364: update HR_ITEM_CONTEXTS set

360: X_LAST_UPDATED_BY in NUMBER,
361: X_LAST_UPDATE_LOGIN in NUMBER
362: ) is
363: begin
364: update HR_ITEM_CONTEXTS set
365: SEGMENT1 = X_SEGMENT1,
366: SEGMENT2 = X_SEGMENT2,
367: SEGMENT3 = X_SEGMENT3,
368: SEGMENT4 = X_SEGMENT4,

Line 414: delete from HR_ITEM_CONTEXTS

410: procedure DELETE_ROW (
411: X_ITEM_CONTEXT_ID in NUMBER
412: ) is
413: begin
414: delete from HR_ITEM_CONTEXTS
415: where ITEM_CONTEXT_ID = X_ITEM_CONTEXT_ID;
416:
417: if (sql%notfound) then
418: raise no_data_found;

Line 497: from hr_item_contexts hic

493: begin
494:
495: select item_context_id
496: into x_item_context_id
497: from hr_item_contexts hic
498: where nvl(hic.segment1,hr_api.g_varchar2) = nvl(x_segment1,hr_api.g_varchar2)
499: and nvl(hic.segment2,hr_api.g_varchar2) = nvl(x_segment2,hr_api.g_varchar2)
500: and nvl(hic.segment3,hr_api.g_varchar2) = nvl(x_segment3,hr_api.g_varchar2)
501: and nvl(hic.segment4,hr_api.g_varchar2) = nvl(x_segment4,hr_api.g_varchar2)

Line 532: select hr_item_contexts_s.nextval

528: and hic.id_flex_num = x_id_flex_num;
529:
530: exception
531: when no_data_found then
532: select hr_item_contexts_s.nextval
533: into x_item_context_id
534: from dual;
535: end;
536:

Line 627: end HR_ITEM_CONTEXTS_PKG;

623: X_LAST_UPDATED_BY,
624: X_LAST_UPDATE_LOGIN);
625: end;
626: end LOAD_ROW;
627: end HR_ITEM_CONTEXTS_PKG;