APPS.IBY_PP_MLSUTL_PVT dependencies on IBY_VALIDATION_PARAMS_B

Line 287: cursor C is select ROWID from IBY_VALIDATION_PARAMS_B

283: X_LAST_UPDATE_DATE in DATE,
284: X_LAST_UPDATED_BY in NUMBER,
285: X_LAST_UPDATE_LOGIN in NUMBER
286: ) is
287: cursor C is select ROWID from IBY_VALIDATION_PARAMS_B
288: where VALIDATION_SET_CODE = X_VALIDATION_SET_CODE
289: and VALIDATION_PARAMETER_CODE = X_VALIDATION_PARAMETER_CODE
290: ;
291: begin

Line 292: insert into IBY_VALIDATION_PARAMS_B (

288: where VALIDATION_SET_CODE = X_VALIDATION_SET_CODE
289: and VALIDATION_PARAMETER_CODE = X_VALIDATION_PARAMETER_CODE
290: ;
291: begin
292: insert into IBY_VALIDATION_PARAMS_B (
293: VALIDATION_SET_CODE,
294: VALIDATION_PARAMETER_CODE,
295: VALIDATION_PARAMETER_TYPE,
296: VALIDATION_PARAM_DISPLAY_ORDER,

Line 371: update IBY_VALIDATION_PARAMS_B set

367: X_LAST_UPDATED_BY in NUMBER,
368: X_LAST_UPDATE_LOGIN in NUMBER
369: ) is
370: begin
371: update IBY_VALIDATION_PARAMS_B set
372: VALIDATION_PARAMETER_TYPE = X_VALIDATION_PARAMETER_TYPE,
373: VALIDATION_PARAM_DISPLAY_ORDER = X_VALIDATION_PARAM_DISPLAY_ORD,
374: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
375: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 413: delete from IBY_VALIDATION_PARAMS_B

409: if (sql%notfound) then
410: raise no_data_found;
411: end if;
412:
413: delete from IBY_VALIDATION_PARAMS_B
414: where VALIDATION_SET_CODE = X_VALIDATION_SET_CODE
415: and VALIDATION_PARAMETER_CODE = X_VALIDATION_PARAMETER_CODE;
416:
417: if (sql%notfound) then

Line 428: from IBY_VALIDATION_PARAMS_B B

424: begin
425: delete from IBY_VALIDATION_PARAMS_TL T
426: where not exists
427: (select NULL
428: from IBY_VALIDATION_PARAMS_B B
429: where B.VALIDATION_SET_CODE = T.VALIDATION_SET_CODE
430: and B.VALIDATION_PARAMETER_CODE = T.VALIDATION_PARAMETER_CODE
431: );
432: