APPS.IBY_FNDCPT_MLSUTL_PVT dependencies on IBY_FORMATS_B

Line 323: cursor C is select ROWID from IBY_FORMATS_B

319: X_LAST_UPDATE_DATE in DATE,
320: X_LAST_UPDATED_BY in NUMBER,
321: X_LAST_UPDATE_LOGIN in NUMBER
322: ) is
323: cursor C is select ROWID from IBY_FORMATS_B
324: where FORMAT_CODE = X_FORMAT_CODE
325: ;
326: begin
327: insert into IBY_FORMATS_B (

Line 327: insert into IBY_FORMATS_B (

323: cursor C is select ROWID from IBY_FORMATS_B
324: where FORMAT_CODE = X_FORMAT_CODE
325: ;
326: begin
327: insert into IBY_FORMATS_B (
328: FORMAT_CODE,
329: FORMAT_TYPE_CODE,
330: FORMAT_TEMPLATE_CODE,
331: EXTRACT_ID,

Line 457: update IBY_FORMATS_B set

453: X_LAST_UPDATED_BY in NUMBER,
454: X_LAST_UPDATE_LOGIN in NUMBER
455: ) is
456: begin
457: update IBY_FORMATS_B set
458: FORMAT_TYPE_CODE = X_FORMAT_TYPE_CODE,
459: FORMAT_TEMPLATE_CODE = X_FORMAT_TEMPLATE_CODE,
460: EXTRACT_ID = X_EXTRACT_ID,
461: REFERENCE_FORMAT_CODE = X_REFERENCE_FORMAT_CODE,

Line 514: delete from IBY_FORMATS_B

510: if (sql%notfound) then
511: raise no_data_found;
512: end if;
513:
514: delete from IBY_FORMATS_B
515: where FORMAT_CODE = X_FORMAT_CODE;
516:
517: if (sql%notfound) then
518: raise no_data_found;

Line 528: from IBY_FORMATS_B B

524: begin
525: delete from IBY_FORMATS_TL T
526: where not exists
527: (select NULL
528: from IBY_FORMATS_B B
529: where B.FORMAT_CODE = T.FORMAT_CODE
530: );
531:
532: update IBY_FORMATS_TL T set (