DBA Data[Home] [Help]

APPS.PA_XLA_SWEEP_TXN_PKG dependencies on PA_DRAFT_REVENUES_ALL

Line 164: Update PA_DRAFT_REVENUES_ALL

160: End If;
161:
162: If NVL(P_TRAN_TYPE,'REVENUE') = 'REVENUE' Then
163: FORALL i IN 1..g_event_tab.count
164: Update PA_DRAFT_REVENUES_ALL
165: SET TRANSFER_STATUS_CODE = 'X' ,
166: Request_Id = g_request_id
167: Where Event_ID = g_event_tab(i);
168: Log_Message ( SQL%ROWCOUNT || ' Updated RDLs with X');

Line 488: Update PA_Draft_Revenues_All

484:
485: END IF;
486:
487: IF NVL(g_tran_type, 'REVENUE') = 'REVENUE' Then
488: Update PA_Draft_Revenues_All
489: set gl_date = g_new_period_date ,
490: gl_period_name = g_new_period_name ,
491: transfer_status_code = 'A'
492: Where request_id = g_request_id