APPS.PA_BUDGET_ACCOUNT_PKG dependencies on PA_BUDGET_LINES

Line 204: PA_Budget_Lines BL,

200: 0 ) Total_Amount,
201: BL.txn_currency_code
202: FROM
203: PA_Resource_Types RTYPE,
204: PA_Budget_Lines BL,
205: PA_Resources RS,
206: PA_Resource_List_Members RM,
207: PA_Resource_Assignments RA,
208: PA_Resource_Txn_Attributes RT,

Line 236: l_prev_ccid pa_budget_lines.code_combination_id%type;

232: AND PBV.Budget_Type_Code = PBCO.Budget_Type_Code
233: AND PBV.Budget_Type_Code = PBT.Budget_Type_Code;
234:
235: l_txn_exists_against_project varchar2(1);
236: l_prev_ccid pa_budget_lines.code_combination_id%type;
237: BEGIN
238:
239: PA_FCK_UTIL.debug_msg('Entering Gen_Acct_All_Lines ..........');
240: l_Return_Status := FND_API.G_RET_STS_SUCCESS;

Line 358: -- Create Budget Line records in PA_BUDGET_LINES

354:
355: IF P_Calling_Mode = 'BASELINE'
356: THEN
357: --------------------------------------------------+
358: -- Create Budget Line records in PA_BUDGET_LINES
359: -- whose GL Periods are not existing ...
360: -- NOT REQUIRED TO GENERATE : 04/23/01
361: --------------------------------------------------+
362: PA_FCK_UTIL.debug_msg(' before calling .... Insert_Into_Budget_Lines ');

Line 503: from pa_budget_lines pbl,

499: PA_FCK_UTIL.debug_msg('Retrieve ccid from latest budget version');
500:
501: select code_combination_id
502: into l_prev_ccid
503: from pa_budget_lines pbl,
504: pa_resource_assignments pra
505: where pra.budget_version_id = l_Prev_Budget_Version_ID
506: and pra.resource_list_member_id = bl.resource_list_member_id
507: and pra.project_id = p_project_id

Line 578: UPDATE PA_BUDGET_LINES

574: End If; -- I
575:
576: IF l_Return_Status = FND_API.G_RET_STS_SUCCESS
577: THEN
578: UPDATE PA_BUDGET_LINES
579: SET Code_Combination_ID = l_CCID,
580: CCID_Gen_Status_Code = 'Y'
581: WHERE Resource_Assignment_ID = bl.Resource_Assignment_ID AND
582: Start_Date = bl.Start_Date ;

Line 588: UPDATE PA_BUDGET_LINES

584: l_Error_Flag := 'Y' ;
585:
586: if ( l_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR ) then
587:
588: UPDATE PA_BUDGET_LINES
589: SET CCID_Gen_Rej_Message = l_Msg_Data,
590: CCID_Gen_Status_Code = 'N'
591: WHERE Resource_Assignment_ID = bl.Resource_Assignment_ID AND
592: Start_Date = bl.Start_Date ;

Line 596: UPDATE PA_BUDGET_LINES

592: Start_Date = bl.Start_Date ;
593:
594: else
595:
596: UPDATE PA_BUDGET_LINES
597: SET CCID_Gen_Rej_Message = l_Error_message,
598: CCID_Gen_Status_Code = 'N'
599: WHERE Resource_Assignment_ID = bl.Resource_Assignment_ID AND
600: Start_Date = bl.Start_Date ;

Line 652: -- if atleast one row exists in pa_budget_lines with

648:
649: X_Msg_Count := l_Msg_Count ;
650: X_Msg_Data := l_Msg_Data ;
651: -----------------------------------------------------------+
652: -- if atleast one row exists in pa_budget_lines with
653: -- CCID_Gen_Status_Code as 'N' then return error message
654: -----------------------------------------------------------+
655: IF l_Error_Flag = 'Y'
656: THEN

Line 756: P_Resource_Assign_ID IN PA_Budget_Lines.Resource_Assignment_Id%TYPE,

752:
753: P_Resource_List_Flag IN VARCHAR2,
754: P_Resource_Type_ID IN PA_Resource_Types.Resource_Type_Code%TYPE,
755: P_Resource_Group_ID IN PA_Resource_Types.Resource_Type_ID%TYPE,
756: P_Resource_Assign_ID IN PA_Budget_Lines.Resource_Assignment_Id%TYPE,
757: P_Start_Date IN PA_Budget_Lines.Start_Date%TYPE,
758:
759: P_Person_ID IN PER_All_People_F.Person_ID%TYPE,
760: P_Expenditure_Category IN PA_Expenditure_Categories.Expenditure_Category%TYPE,

Line 757: P_Start_Date IN PA_Budget_Lines.Start_Date%TYPE,

753: P_Resource_List_Flag IN VARCHAR2,
754: P_Resource_Type_ID IN PA_Resource_Types.Resource_Type_Code%TYPE,
755: P_Resource_Group_ID IN PA_Resource_Types.Resource_Type_ID%TYPE,
756: P_Resource_Assign_ID IN PA_Budget_Lines.Resource_Assignment_Id%TYPE,
757: P_Start_Date IN PA_Budget_Lines.Start_Date%TYPE,
758:
759: P_Person_ID IN PER_All_People_F.Person_ID%TYPE,
760: P_Expenditure_Category IN PA_Expenditure_Categories.Expenditure_Category%TYPE,
761: P_Expenditure_Type IN PA_Expenditure_Types.Expenditure_Type%TYPE,

Line 1447: PA_Budget_Lines BL2,

1443: BL2.Period_Name PERIOD_NAME,
1444: BL2.Start_Date START_DATE,
1445: BL2.End_Date END_DATE
1446: FROM
1447: PA_Budget_Lines BL2,
1448: PA_Resource_Assignments RA2,
1449: GL_Period_Statuses GLPRD2,
1450: PA_Implementations IMP2
1451: WHERE

Line 1490: FROM PA_Budget_Lines BL

1486: PA_FCK_UTIL.debug_msg(' Boundary code is Year');
1487:
1488: SELECT MAX(BL.End_Date)
1489: INTO l_BL_Max_Date
1490: FROM PA_Budget_Lines BL
1491: WHERE BL.Budget_Version_ID = p_Budget_Version_ID;
1492:
1493: PA_FCK_UTIL.debug_msg(' Max. end date is:'||l_BL_Max_Date);
1494:

Line 1519: PA_Budget_Lines BL,

1515: INTO
1516: t_GL_Start_Date,
1517: t_GL_End_Date
1518: FROM
1519: PA_Budget_Lines BL,
1520: PA_Resource_Assignments RA
1521: WHERE
1522: RA.Budget_Version_ID = p_Budget_Version_ID
1523: AND RA.Resource_Assignment_ID = BL.Resource_Assignment_ID ;

Line 1552: -- Call table handler for inserting into PA_BUDGET_LINES with amount=0

1548: LOOP
1549:
1550: l_Resource_Assignment_ID := GlPrds.Resource_Assignment_ID ;
1551: ----------------------------------------------------------------------+
1552: -- Call table handler for inserting into PA_BUDGET_LINES with amount=0
1553: ----------------------------------------------------------------------+
1554: BEGIN
1555:
1556: PA_FCK_UTIL.debug_msg(' res_id '||to_char(l_Resource_Assignment_ID)||' start date '||to_char(GlPrds.Start_Date));

Line 1566: PA_BUDGET_LINES_V_PKG.Insert_Row(

1562: ELSE
1563: l_Task_ID := GlPrds.Task_ID ;
1564: END IF;
1565:
1566: PA_BUDGET_LINES_V_PKG.Insert_Row(
1567: X_ROWID => l_rowid,
1568: X_Resource_Assignment_Id => l_Resource_Assignment_ID,
1569: X_Budget_Version_Id => P_Budget_Version_ID,
1570: X_Project_Id => P_Project_ID,