DBA Data[Home] [Help]

APPS.IGC_UPGRADE_DATA_R12 dependencies on GL_SETS_OF_BOOKS

Line 125: p_period_set_name IN gl_sets_of_books.period_set_name%type,

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,

Line 126: p_accounted_period_type IN gl_sets_of_books.accounted_period_type%type);

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,

Line 157: l_period_set_name gl_sets_of_books.period_set_name%TYPE;

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:

Line 158: l_accounted_period_type gl_sets_of_books.accounted_period_type%TYPE;

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);

Line 197: FROM gl_sets_of_books

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);

Line 582: p_period_set_name IN gl_sets_of_books.period_set_name%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;

Line 583: p_accounted_period_type IN gl_sets_of_books.accounted_period_type%type) IS

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;