APPS.PA_FUND_REVAL_PVT dependencies on PA_EVENTS

Line 1124: DELETE FROM pa_events

1120:
1121: IF l_ThisFetch > 0 THEN
1122:
1123: FORALL i IN l_FundingIdTab.FIRST..l_FundingIdTab.LAST
1124: DELETE FROM pa_events
1125: WHERE project_funding_id = l_FundingIdTab(i)
1126: AND Project_ID = l_ProjectIdTab(i);
1127:
1128: FORALL i IN l_FundingIdTab.FIRST..l_FundingIdTab.LAST

Line 9535: FROM pa_events

9531: CURSOR check_all_non_zero_amt(l_EventId NUMBER) IS
9532: SELECT 'Y' non_zero_amt
9533: FROM DUAL
9534: WHERE EXISTS ( SELECT NULL
9535: FROM pa_events
9536: WHERE event_id = l_EventId
9537: AND bill_trans_rev_amount <> 0
9538: /* mrc migration to SLA bug 4571438 UNION
9539: SELECT NULL

Line 9575: FROM pa_events

9571:
9572: IF ((p_bill_trans_rev_amount <> 0) OR (G_PRIMARY_ONLY = 'N')) THEN
9573:
9574: SELECT nvl(max(event_num),0) into l_EventNum
9575: FROM pa_events
9576: WHERE project_id = G_RevalCompTab(l_SobId).project_id
9577: AND nvl(task_id,0) = nvl(G_RevalCompTab(l_SobId).task_id,0);
9578:
9579: l_EventNum := l_EventNum + 1;

Line 9588: pa_events_pkg.insert_row (

9584: PA_FUND_REVAL_UTIL.Log_Message(p_message=>l_LogMsg);
9585:
9586: END IF;
9587:
9588: pa_events_pkg.insert_row (
9589: X_Rowid => l_RowId ,
9590: X_Event_Id => l_EventId ,
9591: X_Task_Id => p_task_id ,
9592: X_Event_Num => l_EventNum ,

Line 9681: DELETE FROM pa_events

9677: END IF;
9678:
9679: IF NVL(l_NonZeroExists, 'N') = 'N' THEN
9680:
9681: DELETE FROM pa_events
9682: WHERE event_id = l_EventId;
9683:
9684: END IF;
9685: