APPS.PA_YEAR_END_ROLLOVER_PKG dependencies on PA_BC_PACKETS

Line 332: -- from PA_BC_PACKETS to PA_BC_BALANCES

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

Line 591: -- Calculate the unswept amounts from PA_BC_PACKETS

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

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

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

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

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

Line 633: -- Fetch the UnSwept amount from PA_BC_PACKETS

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

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

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

Line 649: PA_BC_PACKETS

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