APPS.IGI_BUD dependencies on IGI_BUD_NY_BALANCES

Line 642: This proceedure updates or inserts igi_bud_ny_balances

638: raise_application_error (-20000, err_msg);
639:
640: END; -- Of bud_profile_default
641: /* =============================================================
642: This proceedure updates or inserts igi_bud_ny_balances
643: Parameters: JE_HEADER_ID of Posted Budget Journal */
644:
645: PROCEDURE bud_next_year_budget
646: ( p_je_header_id NUMBER

Line 666: INSERT INTO IGI_BUD_NY_BALANCES

662: l_line_reference_3 gl_je_lines.reference_3%type;
663: BEGIN
664: FOR line IN lines LOOP
665: BEGIN
666: INSERT INTO IGI_BUD_NY_BALANCES
667: ( SET_OF_BOOKS_ID
668: , CODE_COMBINATION_ID
669: , BUDGET_VERSION_ID
670: , PERIOD_NAME

Line 703: UPDATE IGI_BUD_NY_BALANCES nyb

699: FROM GL_JE_LINES
700: WHERE JE_HEADER_ID = p_je_header_id
701: AND JE_LINE_NUM = line.JE_LINE_NUM;
702:
703: UPDATE IGI_BUD_NY_BALANCES nyb
704: SET NEXT_YEAR_BUDGET =
705: (SELECT nyb.NEXT_YEAR_BUDGET +
706: NVL(gjl.REFERENCE_8,0)
707: FROM GL_JE_LINES gjl