1: TRIGGER igi_bud_journal_lines_t2
2: AFTER UPDATE ON IGI_BUD_JOURNAL_LINES
3: FOR EACH ROW
4: WHEN (NEW.RECORD_TYPE = 'B')
5: BEGIN
1: TRIGGER igi_bud_journal_lines_t2
2: AFTER UPDATE ON IGI_BUD_JOURNAL_LINES
3: FOR EACH ROW
4: WHEN (NEW.RECORD_TYPE = 'B')
5: BEGIN
6:
5: BEGIN
6:
7: IF IGI_GEN.IS_REQ_INSTALLED('BUD') THEN
8:
9: DELETE IGI_BUD_JOURNAL_PERIODS
10: WHERE BE_HEADER_ID = :OLD.BE_HEADER_ID
11: AND BE_LINE_NUM = :OLD.BE_LINE_NUM;
12:
13: DELETE GL_INTERFACE
14: WHERE REFERENCE22 = to_char(:OLD.BE_BATCH_ID)
15: AND REFERENCE29 = to_char(:OLD.BE_HEADER_ID)
16: AND REFERENCE30 = to_char(:OLD.BE_LINE_NUM);
17:
18: IGI_BUD.bud_profile_insert
19: ( :NEW.SET_OF_BOOKS_ID
20: , :NEW.BE_BATCH_ID
21: , :NEW.BE_HEADER_ID
22: , :NEW.BE_LINE_NUM