121: /*Moved this procedure definition from the package spec to the package body - Bug 6847410*/
122:
123: PROCEDURE Migrate_Budgets(p_fiscal_year IN Number,
124: p_org_id IN Number,
125: p_period_set_name IN gl_sets_of_books.period_set_name%type,
126: p_accounted_period_type IN gl_sets_of_books.accounted_period_type%type);
127:
128: PROCEDURE validate_basic(p_org_id IN Number,
129: p_fin_year IN NUMBER,
122:
123: PROCEDURE Migrate_Budgets(p_fiscal_year IN Number,
124: p_org_id IN Number,
125: p_period_set_name IN gl_sets_of_books.period_set_name%type,
126: p_accounted_period_type IN gl_sets_of_books.accounted_period_type%type);
127:
128: PROCEDURE validate_basic(p_org_id IN Number,
129: p_fin_year IN NUMBER,
130: p_balance_type IN VARCHAR2,
153: p_balance_type IN VARCHAR2,
154: p_mode IN VARCHAR2,
155: p_fiscal_year IN NUMBER) IS
156:
157: l_period_set_name gl_sets_of_books.period_set_name%TYPE;
158: l_accounted_period_type gl_sets_of_books.accounted_period_type%TYPE;
159: l_number_per_fiscal_year gl_period_types.number_per_fiscal_year%TYPE;
160: l_open_periods NUMBER;
161:
154: p_mode IN VARCHAR2,
155: p_fiscal_year IN NUMBER) IS
156:
157: l_period_set_name gl_sets_of_books.period_set_name%TYPE;
158: l_accounted_period_type gl_sets_of_books.accounted_period_type%TYPE;
159: l_number_per_fiscal_year gl_period_types.number_per_fiscal_year%TYPE;
160: l_open_periods NUMBER;
161:
162: l_full_path VARCHAR2(255);
193: END IF;
194:
195: SELECT period_set_name, accounted_period_type
196: INTO l_period_set_name, l_accounted_period_type
197: FROM gl_sets_of_books
198: WHERE set_of_books_id = g_sob_id;
199:
200: IF (g_debug_mode = 'Y') THEN
201: Put_Debug_Msg(l_full_path, 'Accounting Period Type: ' || l_accounted_period_type);
578: /* Start of changes for Budgets Migration */
579:
580: PROCEDURE Migrate_Budgets(p_fiscal_year IN Number,
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;
579:
580: PROCEDURE Migrate_Budgets(p_fiscal_year IN Number,
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;