APPS.PA_YEAR_END_ROLLOVER_PKG dependencies on PA_BC_PACKETS

Line 333: -- from PA_BC_PACKETS to PA_BC_BALANCES

329: END IF;
330:
331: -----------------------------------------------------------------------------------+
332: -- Invoke the Sweeper process to sweep all the encumbrance etries
333: -- from PA_BC_PACKETS to PA_BC_BALANCES
334: -----------------------------------------------------------------------------------+
335: PA_Sweeper.Update_Act_Enc_Balance (
336: X_Return_Status => l_Return_Status,
337: X_Error_Message_Code => l_Msg_Data

Line 592: -- Calculate the unswept amounts from PA_BC_PACKETS

588: log_message('Year_End_Rollover: ' || 'Transfer Amount : '|| l_Transfer_Amount);
589: log_message('Year_End_Rollover: ' || '--');
590: END IF;
591:
592: -- Calculate the unswept amounts from PA_BC_PACKETS
593: BEGIN
594:
595: -- Derive Top Task ID
596: BEGIN

Line 604: log_message('Year_End_Rollover: ' || 'PA_BC_PACKETS: Top Task ID : '|| l_Top_Task_ID );

600: WHERE Task_ID = l_Task_ID
601: AND Project_ID = l_Project_ID ;
602:
603: IF P_DEBUG_MODE = 'Y' THEN
604: log_message('Year_End_Rollover: ' || 'PA_BC_PACKETS: Top Task ID : '|| l_Top_Task_ID );
605: END IF;
606:
607: EXCEPTION
608: WHEN NO_DATA_FOUND THEN

Line 623: log_message('Year_End_Rollover: ' || 'PA_BC_PACKETS: Parent Member ID : '|| l_Parent_Member_ID );

619: FROM PA_RESOURCE_LIST_MEMBERS
620: WHERE Resource_List_Member_ID = l_Resource_List_Member_ID;
621:
622: IF P_DEBUG_MODE = 'Y' THEN
623: log_message('Year_End_Rollover: ' || 'PA_BC_PACKETS: Parent Member ID : '|| l_Parent_Member_ID );
624: END IF;
625: EXCEPTION
626: WHEN NO_DATA_FOUND THEN
627: IF P_DEBUG_MODE = 'Y' THEN

Line 634: -- Fetch the UnSwept amount from PA_BC_PACKETS

630: END IF;
631: raise; --bug 2838796
632: END;
633:
634: -- Fetch the UnSwept amount from PA_BC_PACKETS
635: l_UnSwept_Amount := 0;
636:
637: BEGIN
638: IF P_DEBUG_MODE = 'Y' THEN

Line 639: log_message('Year_End_Rollover: ' || 'Fetching amounts from PA_BC_PACKETS');

635: l_UnSwept_Amount := 0;
636:
637: BEGIN
638: IF P_DEBUG_MODE = 'Y' THEN
639: log_message('Year_End_Rollover: ' || 'Fetching amounts from PA_BC_PACKETS');
640: log_message('Year_End_Rollover: ' || 'Budget_Version_ID : ' || l_Work_Budget_Version_ID );
641: log_message('Year_End_Rollover: ' || 'Project_ID : ' || l_Project_ID );
642: log_message('Year_End_Rollover: ' || 'Top_Task_ID : ' || l_Top_Task_ID );
643: END IF;

Line 650: PA_BC_PACKETS

646: SUM(Accounted_DR - Accounted_CR)
647: INTO
648: l_UnSwept_Amount
649: FROM
650: PA_BC_PACKETS
651: WHERE
652: Budget_Version_ID = l_Bslnd_Budget_Version_ID
653: AND Project_ID = l_Project_ID
654: -- AND nvl(Top_Task_ID,0) = l_Top_Task_ID --bug 2838796 start change