APPS.ALR_LOOKUPS_PKG dependencies on ALR_LOOKUPS

Line 1: package body ALR_LOOKUPS_PKG as

1: package body ALR_LOOKUPS_PKG as
2: /* $Header: ALRLKUPB.pls 120.3.12010000.1 2008/07/27 06:58:44 appldev ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_LOOKUP_TYPE in VARCHAR2,

Line 18: cursor C is select ROWID from ALR_LOOKUPS

14: X_LAST_UPDATE_DATE in DATE,
15: X_LAST_UPDATED_BY in NUMBER,
16: X_LAST_UPDATE_LOGIN in NUMBER
17: ) is
18: cursor C is select ROWID from ALR_LOOKUPS
19: where LOOKUP_TYPE = X_LOOKUP_TYPE
20: and LOOKUP_CODE = X_LOOKUP_CODE
21: ;
22: begin

Line 23: insert into ALR_LOOKUPS (

19: where LOOKUP_TYPE = X_LOOKUP_TYPE
20: and LOOKUP_CODE = X_LOOKUP_CODE
21: ;
22: begin
23: insert into ALR_LOOKUPS (
24: LOOKUP_TYPE,
25: LOOKUP_CODE,
26: LAST_UPDATE_DATE,
27: LAST_UPDATED_BY,

Line 91: from ALR_LOOKUPS

87: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
88:
89: select last_updated_by, last_update_date
90: into db_luby, db_ludate
91: from ALR_LOOKUPS
92: where lookup_code = X_LOOKUP_CODE
93: and lookup_type = X_LOOKUP_TYPE;
94:
95: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,

Line 99: ALR_LOOKUPS_PKG.UPDATE_ROW (

95: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,
96: x_custom_mode)) then
97:
98:
99: ALR_LOOKUPS_PKG.UPDATE_ROW (
100: X_LOOKUP_TYPE => X_LOOKUP_TYPE,
101: X_LOOKUP_CODE => X_LOOKUP_CODE,
102: X_MEANING => X_MEANING,
103: X_ENABLED_FLAG => X_ENABLED_FLAG,

Line 117: ALR_LOOKUPS_PKG.INSERT_ROW (

113: end if;
114: exception
115: when NO_DATA_FOUND then
116:
117: ALR_LOOKUPS_PKG.INSERT_ROW (
118: X_ROWID => l_row_id,
119: X_LOOKUP_TYPE => X_LOOKUP_TYPE,
120: X_LOOKUP_CODE => X_LOOKUP_CODE,
121: X_MEANING => X_MEANING,

Line 153: from ALR_LOOKUPS

149: START_DATE_ACTIVE,
150: END_DATE_ACTIVE,
151: LOOKUP_TYPE,
152: LOOKUP_CODE
153: from ALR_LOOKUPS
154: where LOOKUP_TYPE = X_LOOKUP_TYPE
155: and LOOKUP_CODE = X_LOOKUP_CODE
156: for update of LOOKUP_TYPE nowait;
157: begin

Line 194: update ALR_LOOKUPS set

190: X_LAST_UPDATED_BY in NUMBER,
191: X_LAST_UPDATE_LOGIN in NUMBER
192: ) is
193: begin
194: update ALR_LOOKUPS set
195: MEANING = X_MEANING,
196: ENABLED_FLAG = X_ENABLED_FLAG,
197: DESCRIPTION = X_DESCRIPTION,
198: START_DATE_ACTIVE = X_START_DATE_ACTIVE,

Line 218: delete from ALR_LOOKUPS

214: X_LOOKUP_TYPE in VARCHAR2,
215: X_LOOKUP_CODE in VARCHAR2
216: ) is
217: begin
218: delete from ALR_LOOKUPS
219: where LOOKUP_TYPE = X_LOOKUP_TYPE
220: and LOOKUP_CODE = X_LOOKUP_CODE;
221:
222: if (sql%notfound) then

Line 229: end ALR_LOOKUPS_PKG;

225:
226: end DELETE_ROW;
227:
228:
229: end ALR_LOOKUPS_PKG;