igi_bud_journal_lines_t3
AFTER DELETE ON IGI_BUD_JOURNAL_LINES
FOR EACH ROW
Type
AFTER EACH ROW
Event
DELETE
Column
When
Referencing
REFERENCING NEW AS NEW OLD AS OLD
Body
BEGIN
IF IGI_GEN.IS_REQ_INSTALLED('BUD') THEN
DELETE IGI_BUD_JOURNAL_PERIODS
WHERE BE_HEADER_ID = :OLD.BE_HEADER_ID
AND BE_LINE_NUM = :OLD.BE_LINE_NUM;
DELETE GL_INTERFACE
WHERE REFERENCE22 = to_char(:OLD.BE_BATCH_ID)
AND REFERENCE29 = to_char(:OLD.BE_HEADER_ID)
AND REFERENCE30 = to_char(:OLD.BE_LINE_NUM);
END IF; -- is req installed check
END;