APPS.IBY_PP_MLSUTL_PVT dependencies on IBY_VALIDATION_SETS_B

Line 19: cursor C is select ROWID from IBY_VALIDATION_SETS_B

15: X_LAST_UPDATE_DATE in DATE,
16: X_LAST_UPDATED_BY in NUMBER,
17: X_LAST_UPDATE_LOGIN in NUMBER
18: ) is
19: cursor C is select ROWID from IBY_VALIDATION_SETS_B
20: where VALIDATION_SET_CODE = X_VALIDATION_SET_CODE
21: ;
22: begin
23: insert into IBY_VALIDATION_SETS_B (

Line 23: insert into IBY_VALIDATION_SETS_B (

19: cursor C is select ROWID from IBY_VALIDATION_SETS_B
20: where VALIDATION_SET_CODE = X_VALIDATION_SET_CODE
21: ;
22: begin
23: insert into IBY_VALIDATION_SETS_B (
24: VALIDATION_SET_CODE,
25: VALIDATION_LEVEL_CODE,
26: VALIDATION_CODE_PACKAGE,
27: VALIDATION_CODE_ENTRY_POINT,

Line 102: update IBY_VALIDATION_SETS_B set

98: X_LAST_UPDATED_BY in NUMBER,
99: X_LAST_UPDATE_LOGIN in NUMBER
100: ) is
101: begin
102: update IBY_VALIDATION_SETS_B set
103: VALIDATION_LEVEL_CODE = X_VALIDATION_LEVEL_CODE,
104: VALIDATION_CODE_PACKAGE = X_VALIDATION_CODE_PACKAGE,
105: VALIDATION_CODE_ENTRY_POINT = X_VALIDATION_CODE_ENTRY_POINT,
106: VALIDATION_CODE_LANGUAGE = X_VALIDATION_CODE_LANGUAGE,

Line 142: delete from IBY_VALIDATION_SETS_B

138: if (sql%notfound) then
139: raise no_data_found;
140: end if;
141:
142: delete from IBY_VALIDATION_SETS_B
143: where VALIDATION_SET_CODE = X_VALIDATION_SET_CODE;
144:
145: if (sql%notfound) then
146: raise no_data_found;

Line 156: from IBY_VALIDATION_SETS_B B

152: begin
153: delete from IBY_VALIDATION_SETS_TL T
154: where not exists
155: (select NULL
156: from IBY_VALIDATION_SETS_B B
157: where B.VALIDATION_SET_CODE = T.VALIDATION_SET_CODE
158: );
159:
160: update IBY_VALIDATION_SETS_TL T set (