DBA Data[Home] [Help]

APPS.PA_FUND_REVAL_PVT dependencies on PA_EVENTS

Line 1126: DELETE FROM pa_events

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

Line 9568: FROM pa_events

9564: CURSOR check_all_non_zero_amt(l_EventId NUMBER) IS
9565: SELECT 'Y' non_zero_amt
9566: FROM DUAL
9567: WHERE EXISTS ( SELECT NULL
9568: FROM pa_events
9569: WHERE event_id = l_EventId
9570: AND bill_trans_rev_amount <> 0
9571: /* mrc migration to SLA bug 4571438 UNION
9572: SELECT NULL

Line 9608: FROM pa_events

9604:
9605: IF ((p_bill_trans_rev_amount <> 0) OR (G_PRIMARY_ONLY = 'N')) THEN
9606:
9607: SELECT nvl(max(event_num),0) into l_EventNum
9608: FROM pa_events
9609: WHERE project_id = G_RevalCompTab(l_SobId).project_id
9610: AND nvl(task_id,0) = nvl(G_RevalCompTab(l_SobId).task_id,0);
9611:
9612: l_EventNum := l_EventNum + 1;

Line 9621: pa_events_pkg.insert_row (

9617: PA_FUND_REVAL_UTIL.Log_Message(p_message=>l_LogMsg);
9618:
9619: END IF;
9620:
9621: pa_events_pkg.insert_row (
9622: X_Rowid => l_RowId ,
9623: X_Event_Id => l_EventId ,
9624: X_Task_Id => p_task_id ,
9625: X_Event_Num => l_EventNum ,

Line 9714: DELETE FROM pa_events

9710: END IF;
9711:
9712: IF NVL(l_NonZeroExists, 'N') = 'N' THEN
9713:
9714: DELETE FROM pa_events
9715: WHERE event_id = l_EventId;
9716:
9717: END IF;
9718: