APPS.IGC_UPGRADE_DATA_R12 dependencies on GL_BUDGET_VERSIONS

Line 98: P_BUDGET_VERSION_ID OUT NOCOPY GL_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

94: P_NEW_NAME IN OUT NOCOPY VARCHAR2);
95:
96: PROCEDURE MIGRATE_GL_BUDGETS ( P_OLD_BUD_NAME IN VARCHAR2,
97: P_MASTER_BUD_VER_ID IN NUMBER,
98: P_BUDGET_VERSION_ID OUT NOCOPY GL_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
99: P_LATEST_OPENED_YEAR OUT NOCOPY Gl_BUDGETS_V.LATEST_OPENED_YEAR%TYPE);
100:
101:
102: PROCEDURE GL_BUDGET_ORG ( P_BUDGET_NAME IN GL_BUDGETS.BUDGET_NAME%TYPE,

Line 589: v_budget_version_id gl_budget_versions.budget_version_id%type;

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;
591:
592: v_bud_entity_id gl_budget_entities.budget_entity_id%type;
593: l_full_path VARCHAR2(255);

Line 732: p_budget_version_id Out NOCOPY gl_budget_versions.budget_version_id%type,

728: end get_new_name;
729:
730:
731: PROCEDURE Migrate_GL_Budgets(p_old_bud_name in varchar2, p_Master_Bud_Ver_Id in number,
732: p_budget_version_id Out NOCOPY gl_budget_versions.budget_version_id%type,
733: p_latest_opened_year OUT NOCOPY gl_budgets_v.LATEST_OPENED_YEAR%type) is
734:
735: v_new_budget gl_budgets.budget_name%type;
736:

Line 737: --p_budget_version_id gl_budget_versions.budget_version_id%type;

733: p_latest_opened_year OUT NOCOPY gl_budgets_v.LATEST_OPENED_YEAR%type) is
734:
735: v_new_budget gl_budgets.budget_name%type;
736:
737: --p_budget_version_id gl_budget_versions.budget_version_id%type;
738:
739: V_Master_Budget_Version_Id gl_budget_versions.budget_version_id%type;
740: BUDGET gl_budgets%rowtype;
741:

Line 739: V_Master_Budget_Version_Id gl_budget_versions.budget_version_id%type;

735: v_new_budget gl_budgets.budget_name%type;
736:
737: --p_budget_version_id gl_budget_versions.budget_version_id%type;
738:
739: V_Master_Budget_Version_Id gl_budget_versions.budget_version_id%type;
740: BUDGET gl_budgets%rowtype;
741:
742: v_row_id varchar2(50) := NULL;
743: l_full_path VARCHAR2(255);

Line 905: FROM gl_budgets b, gl_budget_versions bv

901: SELECT p_budget_entity_id, bv.budget_version_id, 'N',
902: bud_org_rec.last_updated_by, sysdate,
903: bud_org_rec.last_updated_by, sysdate,
904: bud_org_rec.last_update_login
905: FROM gl_budgets b, gl_budget_versions bv
906: WHERE b.ledger_id = bud_org_rec.Ledger_Id
907: AND bv.budget_name = b.budget_name
908: AND bv.budget_type = b.budget_type;
909:

Line 1574: GL_BUDGET_VERSIONS BV ,

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
1578: WHERE asg.range_id = boc.range_id

Line 1628: GL_BUDGET_VERSIONS BV ,

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
1632: WHERE asg.range_id = boc.range_id

Line 1993: GL_BUDGET_VERSIONS BV ,

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
1997: WHERE asg.range_id = boc.range_id