APPS.IGC_UPGRADE_DATA_R12 dependencies on GL_BUDORG_BC_OPTIONS

Line 839: Select * from GL_BUDORG_BC_OPTIONS

835: WHERE budget_entity_id = v_budget_entity_id;
836:
837: /* Cursor to loop through all funding budgets assigned to a specific account range */
838: CURSOR BC_CUR(p_range_id IN Number) IS
839: Select * from GL_BUDORG_BC_OPTIONS
840: Where RANGE_ID = p_range_id;
841: v_range_id varchar2(100) := NULL;
842: V_Org_Description gl_budget_entities.description%type;
843: v_cbc_override gl_budorg_bc_options.funds_check_level_code%type;

Line 843: v_cbc_override gl_budorg_bc_options.funds_check_level_code%type;

839: Select * from GL_BUDORG_BC_OPTIONS
840: Where RANGE_ID = p_range_id;
841: v_range_id varchar2(100) := NULL;
842: V_Org_Description gl_budget_entities.description%type;
843: v_cbc_override gl_budorg_bc_options.funds_check_level_code%type;
844: v_coa_id gl_ledgers.chart_of_accounts_id%type;
845: v_new_range_id GL_BUDGET_ASSIGNMENT_RANGES.range_id%type;
846: l_full_path VARCHAR2(255);
847: /* Cursor to check whether the new organization is already migrated */

Line 863: ( Select range_id From GL_BUDORG_BC_OPTIONS_V

859: BEGIN
860: SELECT distinct budget_entity_id into v_budget_entity_id
861: FROM GL_BUDGET_ASSIGNMENT_RANGES_V
862: WHERE range_id IN
863: ( Select range_id From GL_BUDORG_BC_OPTIONS_V
864: Where FUNDING_BUDGET_NAME= P_BUDGET_NAME);
865: EXCEPTION
866: WHEN NO_DATA_FOUND THEN
867: return;

Line 1132: /********** Insert in to GL_BUDORG_BC_OPTIONS */

1128: X_Attribute14 => RANGES.Attribute14,
1129: X_Attribute15 => RANGES.Attribute15,
1130: X_Chart_Of_Accounts_Id => v_coa_id);
1131:
1132: /********** Insert in to GL_BUDORG_BC_OPTIONS */
1133: FOR budctrl_rec in BC_CUR(RANGES.range_id)
1134: LOOP
1135:
1136: BEGIN

Line 1147: GL_BUDORG_BC_OPTIONS_PKG.Insert_Row(

1143: when No_data_found then
1144: v_cbc_override := budctrl_rec.Funds_Check_Level_Code;
1145: END;
1146:
1147: GL_BUDORG_BC_OPTIONS_PKG.Insert_Row(
1148: X_Rowid => v_range_id,
1149: X_Range_Id => v_new_range_id,
1150: X_Last_Update_Date => budctrl_rec.Last_Update_Date,
1151: X_Created_By => budctrl_rec.Created_By,

Line 1573: GL_BUDORG_BC_OPTIONS boc,

1569: ,igc.cbc_je_batch_id reference21
1570: ,igc.cbc_je_line_num reference22
1571: FROM igc_cbc_je_lines igc,
1572: gl_budget_assignments asg,
1573: GL_BUDORG_BC_OPTIONS boc,
1574: GL_BUDGET_VERSIONS BV ,
1575: gl_budgets bud,
1576: gl_period_statuses per_f,
1577: gl_period_statuses per_s

Line 1627: GL_BUDORG_BC_OPTIONS boc,

1623: AND set_of_books_id = g_sob_id
1624: AND NOT EXISTS
1625: ( SELECT 1
1626: FROM gl_budget_assignments asg,
1627: GL_BUDORG_BC_OPTIONS boc,
1628: GL_BUDGET_VERSIONS BV ,
1629: gl_budgets bud,
1630: gl_period_statuses per_f,
1631: gl_period_statuses per_s

Line 1992: GL_BUDORG_BC_OPTIONS boc,

1988: AND mig_request_id IS NULL
1989: AND NOT EXISTS
1990: ( SELECT 1
1991: FROM gl_budget_assignments asg,
1992: GL_BUDORG_BC_OPTIONS boc,
1993: GL_BUDGET_VERSIONS BV ,
1994: gl_budgets bud,
1995: gl_period_statuses per_f,
1996: gl_period_statuses per_s