DBA Data[Home] [Help]

PACKAGE: APPS.HR_ITEM_CONTEXTS_PKG

Source


1 package HR_ITEM_CONTEXTS_PKG AUTHID CURRENT_USER as
2 /* $Header: hricxlct.pkh 115.1 2002/12/10 12:25:13 hjonnala noship $ */
3 procedure OWNER_TO_WHO (
4   X_OWNER in VARCHAR2,
5   X_CREATION_DATE out nocopy DATE,
6   X_CREATED_BY out nocopy NUMBER,
7   X_LAST_UPDATE_DATE out nocopy DATE,
8   X_LAST_UPDATED_BY out nocopy NUMBER,
9   X_LAST_UPDATE_LOGIN out nocopy NUMBER
10 );
11 procedure INSERT_ROW (
12   X_ROWID in out nocopy VARCHAR2,
13   X_ITEM_CONTEXT_ID in NUMBER,
14   X_SEGMENT1 in VARCHAR2,
15   X_SEGMENT2 in VARCHAR2,
16   X_SEGMENT3 in VARCHAR2,
17   X_SEGMENT4 in VARCHAR2,
18   X_SEGMENT5 in VARCHAR2,
19   X_SEGMENT6 in VARCHAR2,
20   X_SEGMENT7 in VARCHAR2,
21   X_SEGMENT8 in VARCHAR2,
22   X_SEGMENT9 in VARCHAR2,
23   X_SEGMENT10 in VARCHAR2,
24   X_SEGMENT11 in VARCHAR2,
25   X_SEGMENT12 in VARCHAR2,
26   X_SEGMENT13 in VARCHAR2,
27   X_SEGMENT14 in VARCHAR2,
28   X_SEGMENT15 in VARCHAR2,
29   X_SEGMENT16 in VARCHAR2,
30   X_SEGMENT17 in VARCHAR2,
31   X_SEGMENT18 in VARCHAR2,
32   X_SEGMENT19 in VARCHAR2,
33   X_SEGMENT20 in VARCHAR2,
34   X_SEGMENT21 in VARCHAR2,
35   X_SEGMENT22 in VARCHAR2,
36   X_SEGMENT23 in VARCHAR2,
37   X_SEGMENT24 in VARCHAR2,
38   X_SEGMENT25 in VARCHAR2,
39   X_SEGMENT26 in VARCHAR2,
40   X_SEGMENT27 in VARCHAR2,
41   X_SUMMARY_FLAG in VARCHAR2,
42   X_ID_FLEX_NUM in NUMBER,
43   X_END_DATE_ACTIVE in DATE,
44   X_SEGMENT28 in VARCHAR2,
45   X_SEGMENT29 in VARCHAR2,
46   X_SEGMENT30 in VARCHAR2,
47   X_START_DATE_ACTIVE in DATE,
48   X_ENABLED_FLAG in VARCHAR2,
49   X_CREATION_DATE in DATE,
50   X_CREATED_BY in NUMBER,
51   X_LAST_UPDATE_DATE in DATE,
52   X_LAST_UPDATED_BY in NUMBER,
53   X_LAST_UPDATE_LOGIN in NUMBER);
54 procedure LOCK_ROW (
55   X_ITEM_CONTEXT_ID in NUMBER,
56   X_SEGMENT1 in VARCHAR2,
57   X_SEGMENT2 in VARCHAR2,
58   X_SEGMENT3 in VARCHAR2,
59   X_SEGMENT4 in VARCHAR2,
60   X_SEGMENT5 in VARCHAR2,
61   X_SEGMENT6 in VARCHAR2,
62   X_SEGMENT7 in VARCHAR2,
63   X_SEGMENT8 in VARCHAR2,
64   X_SEGMENT9 in VARCHAR2,
65   X_SEGMENT10 in VARCHAR2,
66   X_SEGMENT11 in VARCHAR2,
67   X_SEGMENT12 in VARCHAR2,
68   X_SEGMENT13 in VARCHAR2,
69   X_SEGMENT14 in VARCHAR2,
70   X_SEGMENT15 in VARCHAR2,
71   X_SEGMENT16 in VARCHAR2,
72   X_SEGMENT17 in VARCHAR2,
73   X_SEGMENT18 in VARCHAR2,
74   X_SEGMENT19 in VARCHAR2,
75   X_SEGMENT20 in VARCHAR2,
76   X_SEGMENT21 in VARCHAR2,
77   X_SEGMENT22 in VARCHAR2,
78   X_SEGMENT23 in VARCHAR2,
79   X_SEGMENT24 in VARCHAR2,
80   X_SEGMENT25 in VARCHAR2,
81   X_SEGMENT26 in VARCHAR2,
82   X_SEGMENT27 in VARCHAR2,
83   X_SUMMARY_FLAG in VARCHAR2,
84   X_ID_FLEX_NUM in NUMBER,
85   X_END_DATE_ACTIVE in DATE,
86   X_SEGMENT28 in VARCHAR2,
87   X_SEGMENT29 in VARCHAR2,
88   X_SEGMENT30 in VARCHAR2,
89   X_START_DATE_ACTIVE in DATE,
90   X_ENABLED_FLAG in VARCHAR2
91 );
92 procedure UPDATE_ROW (
93   X_ITEM_CONTEXT_ID in NUMBER,
94   X_SEGMENT1 in VARCHAR2,
95   X_SEGMENT2 in VARCHAR2,
96   X_SEGMENT3 in VARCHAR2,
97   X_SEGMENT4 in VARCHAR2,
98   X_SEGMENT5 in VARCHAR2,
99   X_SEGMENT6 in VARCHAR2,
100   X_SEGMENT7 in VARCHAR2,
101   X_SEGMENT8 in VARCHAR2,
102   X_SEGMENT9 in VARCHAR2,
103   X_SEGMENT10 in VARCHAR2,
104   X_SEGMENT11 in VARCHAR2,
105   X_SEGMENT12 in VARCHAR2,
106   X_SEGMENT13 in VARCHAR2,
107   X_SEGMENT14 in VARCHAR2,
108   X_SEGMENT15 in VARCHAR2,
109   X_SEGMENT16 in VARCHAR2,
110   X_SEGMENT17 in VARCHAR2,
111   X_SEGMENT18 in VARCHAR2,
112   X_SEGMENT19 in VARCHAR2,
113   X_SEGMENT20 in VARCHAR2,
114   X_SEGMENT21 in VARCHAR2,
115   X_SEGMENT22 in VARCHAR2,
116   X_SEGMENT23 in VARCHAR2,
117   X_SEGMENT24 in VARCHAR2,
118   X_SEGMENT25 in VARCHAR2,
119   X_SEGMENT26 in VARCHAR2,
120   X_SEGMENT27 in VARCHAR2,
121   X_SUMMARY_FLAG in VARCHAR2,
122   X_ID_FLEX_NUM in NUMBER,
123   X_END_DATE_ACTIVE in DATE,
124   X_SEGMENT28 in VARCHAR2,
125   X_SEGMENT29 in VARCHAR2,
126   X_SEGMENT30 in VARCHAR2,
127   X_START_DATE_ACTIVE in DATE,
128   X_ENABLED_FLAG in VARCHAR2,
129   X_LAST_UPDATE_DATE in DATE,
130   X_LAST_UPDATED_BY in NUMBER,
131   X_LAST_UPDATE_LOGIN in NUMBER
132 );
133 procedure DELETE_ROW (
134   X_ITEM_CONTEXT_ID in NUMBER
135 );
136 procedure LOAD_ROW (
137   X_APPLICATION_SHORT_NAME in VARCHAR2,
138   X_SEGMENT1 in VARCHAR2,
139   X_SEGMENT2 in VARCHAR2,
140   X_SEGMENT3 in VARCHAR2,
141   X_SEGMENT4 in VARCHAR2,
142   X_SEGMENT5 in VARCHAR2,
143   X_SEGMENT6 in VARCHAR2,
144   X_SEGMENT7 in VARCHAR2,
145   X_SEGMENT8 in VARCHAR2,
146   X_SEGMENT9 in VARCHAR2,
147   X_SEGMENT10 in VARCHAR2,
148   X_SEGMENT11 in VARCHAR2,
149   X_SEGMENT12 in VARCHAR2,
150   X_SEGMENT13 in VARCHAR2,
151   X_SEGMENT14 in VARCHAR2,
152   X_SEGMENT15 in VARCHAR2,
153   X_SEGMENT16 in VARCHAR2,
154   X_SEGMENT17 in VARCHAR2,
155   X_SEGMENT18 in VARCHAR2,
156   X_SEGMENT19 in VARCHAR2,
157   X_SEGMENT20 in VARCHAR2,
158   X_SEGMENT21 in VARCHAR2,
159   X_SEGMENT22 in VARCHAR2,
160   X_SEGMENT23 in VARCHAR2,
161   X_SEGMENT24 in VARCHAR2,
162   X_SEGMENT25 in VARCHAR2,
163   X_SEGMENT26 in VARCHAR2,
164   X_SEGMENT27 in VARCHAR2,
165   X_SEGMENT28 in VARCHAR2,
166   X_SEGMENT29 in VARCHAR2,
167   X_SEGMENT30 in VARCHAR2,
168   X_ID_FLEX_STRUCTURE_CODE in VARCHAR2,
169   X_ID_FLEX_CODE in VARCHAR2,
170   X_OWNER in VARCHAR2,
171   X_SUMMARY_FLAG in VARCHAR2,
172   X_ENABLED_FLAG in VARCHAR2,
173   X_START_DATE_ACTIVE in VARCHAR2,
174   X_END_DATE_ACTIVE in VARCHAR2);
175 end HR_ITEM_CONTEXTS_PKG;