APPS.IEC_O_VALIDATION_RECOMM_PKG dependencies on IEC_O_VALIDATION_RECOMM_B

Line 16: cursor C is select ROWID from IEC_O_VALIDATION_RECOMM_B

12: X_LAST_UPDATE_DATE in DATE,
13: X_LAST_UPDATED_BY in NUMBER,
14: X_LAST_UPDATE_LOGIN in NUMBER
15: ) is
16: cursor C is select ROWID from IEC_O_VALIDATION_RECOMM_B
17: where RECOMMENDATION_CODE = X_RECOMMENDATION_CODE
18: ;
19: begin
20: x_rowid := NULL;

Line 22: insert into IEC_O_VALIDATION_RECOMM_B (

18: ;
19: begin
20: x_rowid := NULL;
21:
22: insert into IEC_O_VALIDATION_RECOMM_B (
23: RECOMMENDATION_CODE,
24: OBJECT_VERSION_NUMBER,
25: CREATION_DATE,
26: CREATED_BY,

Line 88: from IEC_O_VALIDATION_RECOMM_B

84: X_RECOMMENDATION in VARCHAR2
85: ) is
86: cursor c is select
87: OBJECT_VERSION_NUMBER
88: from IEC_O_VALIDATION_RECOMM_B
89: where RECOMMENDATION_CODE = X_RECOMMENDATION_CODE
90: for update of RECOMMENDATION_CODE nowait;
91: recinfo c%rowtype;
92:

Line 142: update IEC_O_VALIDATION_RECOMM_B set

138: X_LAST_UPDATED_BY in NUMBER,
139: X_LAST_UPDATE_LOGIN in NUMBER
140: ) is
141: begin
142: update IEC_O_VALIDATION_RECOMM_B set
143: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
144: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
145: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
146: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 179: delete from IEC_O_VALIDATION_RECOMM_B

175: if (sql%notfound) then
176: raise no_data_found;
177: end if;
178:
179: delete from IEC_O_VALIDATION_RECOMM_B
180: where RECOMMENDATION_CODE = X_RECOMMENDATION_CODE;
181:
182: if (sql%notfound) then
183: raise no_data_found;

Line 195: from IEC_O_VALIDATION_RECOMM_B B

191: begin
192: delete from IEC_O_VALIDATION_RECOMM_TL T
193: where not exists
194: (select NULL
195: from IEC_O_VALIDATION_RECOMM_B B
196: where B.RECOMMENDATION_CODE = T.RECOMMENDATION_CODE
197: );
198:
199: update IEC_O_VALIDATION_RECOMM_TL T set (