APPS.FND_LOOKUP_ASSIGNMENTS_PKG dependencies on FND_LOOKUP_ASSIGNMENTS

Line 1: package body FND_LOOKUP_ASSIGNMENTS_PKG as

1: package body FND_LOOKUP_ASSIGNMENTS_PKG as
2: /* $Header: AFLVFLAB.pls 115.0 2004/08/04 21:03:35 stopiwal noship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_LOOKUP_ASSIGNMENT_ID in NUMBER,

Line 21: cursor C is select ROWID from FND_LOOKUP_ASSIGNMENTS

17: X_LAST_UPDATE_DATE in DATE,
18: X_LAST_UPDATED_BY in NUMBER,
19: X_LAST_UPDATE_LOGIN in NUMBER
20: ) is
21: cursor C is select ROWID from FND_LOOKUP_ASSIGNMENTS
22: where LOOKUP_ASSIGNMENT_ID = X_LOOKUP_ASSIGNMENT_ID
23: ;
24: begin
25: insert into FND_LOOKUP_ASSIGNMENTS (

Line 25: insert into FND_LOOKUP_ASSIGNMENTS (

21: cursor C is select ROWID from FND_LOOKUP_ASSIGNMENTS
22: where LOOKUP_ASSIGNMENT_ID = X_LOOKUP_ASSIGNMENT_ID
23: ;
24: begin
25: insert into FND_LOOKUP_ASSIGNMENTS (
26: LOOKUP_ASSIGNMENT_ID,
27: INSTANCE_PK1_VALUE,
28: OBJ_NAME,
29: INSTANCE_PK4_VALUE,

Line 91: from FND_LOOKUP_ASSIGNMENTS

87: LOOKUP_CODE,
88: LOOKUP_TYPE,
89: INSTANCE_PK2_VALUE,
90: INSTANCE_PK3_VALUE
91: from FND_LOOKUP_ASSIGNMENTS
92: where LOOKUP_ASSIGNMENT_ID = X_LOOKUP_ASSIGNMENT_ID
93: for update of LOOKUP_ASSIGNMENT_ID nowait;
94: recinfo c%rowtype;
95:

Line 145: update FND_LOOKUP_ASSIGNMENTS set

141: X_LAST_UPDATED_BY in NUMBER,
142: X_LAST_UPDATE_LOGIN in NUMBER
143: ) is
144: begin
145: update FND_LOOKUP_ASSIGNMENTS set
146: INSTANCE_PK1_VALUE = X_INSTANCE_PK1_VALUE,
147: OBJ_NAME = X_OBJ_NAME,
148: INSTANCE_PK4_VALUE = X_INSTANCE_PK4_VALUE,
149: INSTANCE_PK5_VALUE = X_INSTANCE_PK5_VALUE,

Line 170: delete from FND_LOOKUP_ASSIGNMENTS

166: procedure DELETE_ROW (
167: X_LOOKUP_ASSIGNMENT_ID in NUMBER
168: ) is
169: begin
170: delete from FND_LOOKUP_ASSIGNMENTS
171: where LOOKUP_ASSIGNMENT_ID = X_LOOKUP_ASSIGNMENT_ID;
172:
173: if (sql%notfound) then
174: raise no_data_found;

Line 211: from fnd_lookup_assignments

207: -- check the db last update fields for each record in the cursor
208: begin
209: select Lookup_assignment_id, LAST_UPDATED_BY, LAST_UPDATE_DATE
210: into db_luid, db_luby, db_ludate
211: from fnd_lookup_assignments
212: where LOOKUP_TYPE = X_LOOKUP_TYPE
213: and OBJ_NAME = x_obj_name
214: and INSTANCE_PK1_VALUE = X_INSTANCE_PK1_VALUE
215: and LOOKUP_CODE = X_LOOKUP_CODE;

Line 219: Fnd_lookup_assignments_Pkg.Update_Row (

215: and LOOKUP_CODE = X_LOOKUP_CODE;
216:
217: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
218: db_ludate, X_CUSTOM_MODE)) then
219: Fnd_lookup_assignments_Pkg.Update_Row (
220: X_LOOKUP_ASSIGNMENT_ID => db_luid,
221: X_LOOKUP_TYPE => x_lookup_type,
222: X_LOOKUP_CODE => x_lookup_code,
223: X_OBJ_NAME => x_obj_name,

Line 237: select FND_LOOKUP_ASSIGNMENTS_S.NEXTVAL

233: end if;
234:
235: exception
236: when no_data_found then
237: select FND_LOOKUP_ASSIGNMENTS_S.NEXTVAL
238: into db_luid
239: from dual;
240:
241: Fnd_lookup_assignments_Pkg.Insert_Row(

Line 241: Fnd_lookup_assignments_Pkg.Insert_Row(

237: select FND_LOOKUP_ASSIGNMENTS_S.NEXTVAL
238: into db_luid
239: from dual;
240:
241: Fnd_lookup_assignments_Pkg.Insert_Row(
242: X_ROWID => row_id,
243: X_LOOKUP_ASSIGNMENT_ID => db_luid,
244: X_LOOKUP_TYPE => x_lookup_type,
245: X_LOOKUP_CODE => x_lookup_code,

Line 263: end FND_LOOKUP_ASSIGNMENTS_PKG;

259: end;
260:
261: end Load_Row;
262:
263: end FND_LOOKUP_ASSIGNMENTS_PKG;