APPS.PA_BUDGET_ACCOUNT_PKG dependencies on PA_BUDGET_ACCT_LINES

Line 375: -- Delete all account lines from PA_BUDGET_ACCT_LINES

371: END IF;
372:
373: PA_FCK_UTIL.debug_msg('after calling insert into budget lines ..........');
374: ------------------------------------------------------------+
375: -- Delete all account lines from PA_BUDGET_ACCT_LINES
376: -- pertaining to a given Current Budget Version ID
377: ------------------------------------------------------------+
378: IF P_Calling_Mode in ('SUBMIT','GENERATE_ACCOUNT') then
379: DELETE FROM PA_BUDGET_ACCT_LINES

Line 379: DELETE FROM PA_BUDGET_ACCT_LINES

375: -- Delete all account lines from PA_BUDGET_ACCT_LINES
376: -- pertaining to a given Current Budget Version ID
377: ------------------------------------------------------------+
378: IF P_Calling_Mode in ('SUBMIT','GENERATE_ACCOUNT') then
379: DELETE FROM PA_BUDGET_ACCT_LINES
380: WHERE Budget_Version_ID = p_Budget_Version_ID;
381: END IF;
382:
383: PA_FCK_UTIL.debug_msg('after deleting from budget acct lines ..........');

Line 663: INSERT INTO PA_BUDGET_ACCT_LINES (

659:
660: BEGIN
661: X_Return_Status := FND_API.G_RET_STS_SUCCESS ;
662: IF (l_Prev_Budget_Version_ID IS NOT NULL and P_Calling_Mode in ('SUBMIT','GENERATE_ACCOUNT')) then
663: INSERT INTO PA_BUDGET_ACCT_LINES (
664: Budget_Acct_Line_ID,
665: Budget_Version_ID,
666: GL_Period_Name,
667: Start_Date,

Line 682: PA_BUDGET_ACCT_LINES_S.nextval,

678: CREATION_DATE,
679: CREATED_BY
680: )
681: SELECT
682: PA_BUDGET_ACCT_LINES_S.nextval,
683: P_Budget_Version_ID,
684: BL1.GL_Period_Name,
685: BL1.Start_Date,
686: BL1.End_Date,

Line 701: PA_BUDGET_ACCT_LINES BL1

697: -1,
698: sysdate,
699: -1
700: FROM
701: PA_BUDGET_ACCT_LINES BL1
702: WHERE
703: BL1.Budget_Version_ID = l_Prev_Budget_Version_ID
704: AND NOT EXISTS
705: ( SELECT 'x'

Line 706: FROM PA_BUDGET_ACCT_LINES BL2

702: WHERE
703: BL1.Budget_Version_ID = l_Prev_Budget_Version_ID
704: AND NOT EXISTS
705: ( SELECT 'x'
706: FROM PA_BUDGET_ACCT_LINES BL2
707: WHERE BL2.Code_Combination_ID = BL1.Code_Combination_ID
708: AND BL2.Budget_Version_ID = P_Budget_Version_ID
709: AND BL2.Start_Date = BL1.Start_Date ) ;
710: END IF;

Line 1272: PA_BUDGET_ACCT_LINES

1268:
1269: PA_FCK_UTIL.debug_msg(' bdg_ver, p_start_date, p_ccid .. '||to_char(p_Budget_Version_ID)||' , '||to_char(p_Start_Date,'DD-MON-YYYY')||' , '||to_char(p_CCID));
1270: BEGIN
1271: UPDATE
1272: PA_BUDGET_ACCT_LINES
1273: SET
1274: Curr_Ver_Budget_Amount = Curr_Ver_Budget_Amount + p_Amount,
1275: Curr_Ver_Available_Amount = Curr_Ver_Available_Amount + p_Amount,
1276: accounted_amount = accounted_amount + p_Amount

Line 1289: -- Check the prev. Baselined budget record in PA_BUDGET_ACCT_LINES table

1285: PA_FCK_UTIL.debug_msg('previous budget version id ......row '||to_char(p_prev_budget_version_id));
1286:
1287: IF l_update_count = 0 THEN
1288: PA_FCK_UTIL.debug_msg(' record not found ');
1289: -- Check the prev. Baselined budget record in PA_BUDGET_ACCT_LINES table
1290: IF p_Prev_Budget_Version_ID IS NOT NULL
1291: THEN
1292: BEGIN
1293: SELECT

Line 1300: PA_BUDGET_ACCT_LINES

1296: INTO
1297: l_Prev_Ver_Budget_Amount,
1298: l_Prev_Ver_Available_Amount
1299: FROM
1300: PA_BUDGET_ACCT_LINES
1301: WHERE
1302: Budget_Version_ID = p_Prev_Budget_Version_ID
1303: AND Start_Date = p_Start_Date
1304: AND Code_Combination_ID = p_CCID;

Line 1316: INSERT INTO PA_BUDGET_ACCT_LINES (

1312: END IF;
1313:
1314: PA_FCK_UTIL.debug_msg(' p_b_amt, p_av_amt '||to_char(l_Prev_Ver_Budget_Amount)||','||to_char(l_Prev_Ver_Budget_Amount) );
1315:
1316: INSERT INTO PA_BUDGET_ACCT_LINES (
1317: Budget_Acct_Line_ID,
1318: Budget_Version_ID,
1319: GL_Period_Name,
1320: Start_Date,

Line 1335: PA_BUDGET_ACCT_LINES_S.nextval,

1331: CREATION_DATE,
1332: CREATED_BY
1333: )
1334: VALUES (
1335: PA_BUDGET_ACCT_LINES_S.nextval,
1336: p_Budget_Version_ID,
1337: p_Period_Name,
1338: p_Start_Date,
1339: p_End_Date,