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 2050: Delete from PA_Budget_Acct_Lines where Budget_version_ID = l_Work_Budget_Version_ID;

2046: END;
2047: -------------------------------------------------------------------------------
2048: -- Delete if account lines exist ..
2049: -------------------------------------------------------------------------------
2050: Delete from PA_Budget_Acct_Lines where Budget_version_ID = l_Work_Budget_Version_ID;
2051:
2052: -------------------------------------------------------------------------------
2053: -- Insert new Account Lines
2054: -------------------------------------------------------------------------------

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

2053: -- Insert new Account Lines
2054: -------------------------------------------------------------------------------
2055: IF P_DEBUG_MODE = 'Y' THEN
2056: log_message('Year_End_Rollover: ' || '--');
2057: log_message('Year_End_Rollover: ' || 'Inserting new records into PA_Budget_Acct_Lines for newly created Draft Budget Version = '|| l_Work_Budget_Version_ID );
2058: log_message('Year_End_Rollover: ' || '--');
2059: END IF;
2060:
2061: BEGIN

Line 2062: INSERT INTO PA_Budget_Acct_Lines (

2058: log_message('Year_End_Rollover: ' || '--');
2059: END IF;
2060:
2061: BEGIN
2062: INSERT INTO PA_Budget_Acct_Lines (
2063: Budget_Acct_Line_ID,
2064: Budget_version_ID,
2065: GL_Period_Name,
2066: Start_Date,

Line 2082: PA_Budget_Acct_Lines_S.NEXTVAL,

2078: Last_Update_Login,
2079: Request_ID
2080: )
2081: SELECT
2082: PA_Budget_Acct_Lines_S.NEXTVAL,
2083: l_Work_Budget_Version_ID, -- Should be working Budget Version
2084: GL_Period_Name,
2085: Start_Date,
2086: End_Date,

Line 2100: PA_Budget_Acct_Lines

2096: 1234,
2097: 1234,
2098: P_Request_ID
2099: FROM
2100: PA_Budget_Acct_Lines
2101: WHERE
2102: Budget_Version_ID = P_Budget_Version_ID ;
2103:
2104: IF SQL%ROWCOUNT = 0