eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGC_UPGRADE_DATA_R12 dependencies on GL_PERIODS

Line 585: v_period_start_num gl_periods.period_num%type;

581: p_org_id IN Number,
582: p_period_set_name IN gl_sets_of_books.period_set_name%type,
583: p_accounted_period_type IN gl_sets_of_books.accounted_period_type%type) IS
584:
585: v_period_start_num gl_periods.period_num%type;
586: v_period_end_num gl_periods.period_num%type;
587: v_period_start_name gl_budgets.first_valid_period_name%type;
588: v_period_end_name gl_budgets.last_valid_period_name%type;
589: v_budget_version_id gl_budget_versions.budget_version_id%type;

Line 586: v_period_end_num gl_periods.period_num%type;

582: p_period_set_name IN gl_sets_of_books.period_set_name%type,
583: p_accounted_period_type IN gl_sets_of_books.accounted_period_type%type) IS
584:
585: v_period_start_num gl_periods.period_num%type;
586: v_period_end_num gl_periods.period_num%type;
587: v_period_start_name gl_budgets.first_valid_period_name%type;
588: v_period_end_name gl_budgets.last_valid_period_name%type;
589: v_budget_version_id gl_budget_versions.budget_version_id%type;
590: v_latest_opened_year gl_budgets_v.LATEST_OPENED_YEAR%type;

Line 617: from gl_periods

613: Put_Debug_Msg(l_full_path, 'Primary Ledger ID ' || g_sob_id );
614: END IF;
615: select min(period_num),max(period_num)
616: into v_period_start_num,v_period_end_num
617: from gl_periods
618: where period_set_name = p_period_set_name
619: and period_year = p_fiscal_year
620: and Period_type = p_accounted_period_type ;
621:

Line 622: select period_name into v_period_start_name from gl_periods where period_num = v_period_start_num

618: where period_set_name = p_period_set_name
619: and period_year = p_fiscal_year
620: and Period_type = p_accounted_period_type ;
621:
622: select period_name into v_period_start_name from gl_periods where period_num = v_period_start_num
623: and period_set_name = p_period_set_name
624: and period_year = p_fiscal_year
625: and Period_type = p_accounted_period_type;
626:

Line 627: select period_name into v_period_end_name from gl_periods where period_num = v_period_end_num

623: and period_set_name = p_period_set_name
624: and period_year = p_fiscal_year
625: and Period_type = p_accounted_period_type;
626:
627: select period_name into v_period_end_name from gl_periods where period_num = v_period_end_num
628: and period_set_name = p_period_set_name
629: and period_year = p_fiscal_year
630: and Period_type = p_accounted_period_type;
631: