APPS.PA_YEAR_END_ROLLOVER_PKG dependencies on PA_BUDGET_ACCT_LINES

Line 61: PA_Budget_Acct_Lines

57: ---------------------------------------------------------------------------------
58: -- Update the Budget Summary Account's Current version Available Amount
59: ---------------------------------------------------------------------------------
60: UPDATE
61: PA_Budget_Acct_Lines
62: SET
63: Curr_Ver_Budget_Amount = nvl(Curr_Ver_Budget_Amount,0) + P_Transfer_Amount,
64: Curr_Ver_Available_Amount = nvl(Curr_Ver_Available_Amount,0) + P_Transfer_Amount,
65: Request_ID = P_Request_ID

Line 83: -- No new records should be created in pa_budget_acct_lines as the records created for the new

79:
80: END;
81:
82: /* ============================================================================================== +
83: -- No new records should be created in pa_budget_acct_lines as the records created for the new
84: -- period will not have ccid. CCID is generated when account generator called in SUBMIT MODE.
85: -- Acct. generator in SUBMIT mode will also create data into pa_budget_acct_lines table
86:
87: IF l_Update_Count = 0 -- No Data found and no records are updated

Line 85: -- Acct. generator in SUBMIT mode will also create data into pa_budget_acct_lines table

81:
82: /* ============================================================================================== +
83: -- No new records should be created in pa_budget_acct_lines as the records created for the new
84: -- period will not have ccid. CCID is generated when account generator called in SUBMIT MODE.
85: -- Acct. generator in SUBMIT mode will also create data into pa_budget_acct_lines table
86:
87: IF l_Update_Count = 0 -- No Data found and no records are updated
88: THEN
89: ---------------------------------------------------------------------------------

Line 93: PA_BUDGET_ACCT_LINES (

89: ---------------------------------------------------------------------------------
90: -- Create new Budget Summary Account's data for the non-existent details
91: ---------------------------------------------------------------------------------
92: INSERT INTO
93: PA_BUDGET_ACCT_LINES (
94: Budget_Acct_Line_ID,
95: Budget_Version_ID,
96: GL_Period_Name,
97: Start_Date,

Line 113: PA_BUDGET_ACCT_LINES_S.NextVal,

109: Request_ID,
110: Last_Update_Login
111: )
112: VALUES (
113: PA_BUDGET_ACCT_LINES_S.NextVal,
114: P_Budget_Version_ID,
115: P_Period_Name,
116: P_Period_Start_Date,
117: P_Period_End_Date,

Line 1993: Delete from PA_Budget_Acct_Lines where Budget_version_ID = l_Work_Budget_Version_ID;

1989: END;
1990: -------------------------------------------------------------------------------
1991: -- Delete if account lines exist ..
1992: -------------------------------------------------------------------------------
1993: Delete from PA_Budget_Acct_Lines where Budget_version_ID = l_Work_Budget_Version_ID;
1994:
1995: -------------------------------------------------------------------------------
1996: -- Insert new Account Lines
1997: -------------------------------------------------------------------------------

Line 2000: log_message('Year_End_Rollover: ' || 'Inserting new records into PA_Budget_Acct_Lines for newly created Draft Budget Version = '|| l_Work_Budget_Version_ID );

1996: -- Insert new Account Lines
1997: -------------------------------------------------------------------------------
1998: IF P_DEBUG_MODE = 'Y' THEN
1999: log_message('Year_End_Rollover: ' || '--');
2000: log_message('Year_End_Rollover: ' || 'Inserting new records into PA_Budget_Acct_Lines for newly created Draft Budget Version = '|| l_Work_Budget_Version_ID );
2001: log_message('Year_End_Rollover: ' || '--');
2002: END IF;
2003:
2004: BEGIN

Line 2005: INSERT INTO PA_Budget_Acct_Lines (

2001: log_message('Year_End_Rollover: ' || '--');
2002: END IF;
2003:
2004: BEGIN
2005: INSERT INTO PA_Budget_Acct_Lines (
2006: Budget_Acct_Line_ID,
2007: Budget_version_ID,
2008: GL_Period_Name,
2009: Start_Date,

Line 2025: PA_Budget_Acct_Lines_S.NEXTVAL,

2021: Last_Update_Login,
2022: Request_ID
2023: )
2024: SELECT
2025: PA_Budget_Acct_Lines_S.NEXTVAL,
2026: l_Work_Budget_Version_ID, -- Should be working Budget Version
2027: GL_Period_Name,
2028: Start_Date,
2029: End_Date,

Line 2043: PA_Budget_Acct_Lines

2039: 1234,
2040: 1234,
2041: P_Request_ID
2042: FROM
2043: PA_Budget_Acct_Lines
2044: WHERE
2045: Budget_Version_ID = P_Budget_Version_ID ;
2046:
2047: IF SQL%ROWCOUNT = 0