eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PURGE_BILLING dependencies on PA_CUST_EVENT_RDL_AR

Line 643: PA_Cust_Event_RDL_AR ar

639: mc.Draft_Invoice_Num,
640: mc.Prc_Assignment_Id,
641: mc.Rate_Type
642: from pa_mc_cust_event_rdl_all mc,
643: PA_Cust_Event_RDL_AR ar
644: where ar.Purge_Project_Id = p_project_id
645: and mc.project_id = ar.Purge_Project_Id
646: and mc.event_num = ar.event_num
647: and nvl(mc.task_id,-99) = nvl(ar.task_id,-99)

Line 745: pa_debug.debug( ' ->Before insert into PA_Cust_Event_RDL_AR') ;

741: -- in the commit size.
742:
743: /* l_commit_size := pa_utils2.arpur_mrc_commit_size / 2 ; */
744:
745: pa_debug.debug( ' ->Before insert into PA_Cust_Event_RDL_AR') ;
746: FORALL l_erdl_ind IN l_erdl_rowid_tab.FIRST .. l_erdl_rowid_tab.LAST
747: insert into PA_Cust_Event_RDL_AR
748: (
749: PURGE_BATCH_ID,

Line 747: insert into PA_Cust_Event_RDL_AR

743: /* l_commit_size := pa_utils2.arpur_mrc_commit_size / 2 ; */
744:
745: pa_debug.debug( ' ->Before insert into PA_Cust_Event_RDL_AR') ;
746: FORALL l_erdl_ind IN l_erdl_rowid_tab.FIRST .. l_erdl_rowid_tab.LAST
747: insert into PA_Cust_Event_RDL_AR
748: (
749: PURGE_BATCH_ID,
750: PURGE_RELEASE,
751: PURGE_PROJECT_ID,

Line 905: pa_debug.debug( ' ->After insert into PA_Cust_Event_RDL_AR') ;

901: and rownum < l_commit_size
902: ) ;
903: */
904:
905: pa_debug.debug( ' ->After insert into PA_Cust_Event_RDL_AR') ;
906: /* l_NoOfRecordsIns := SQL%ROWCOUNT ; */
907:
908: if l_NoOfRecordsIns > 0 then
909: -- First call the MRC procedure to archive the MC table

Line 933: pa_cust_event_rdl_ar erdl2

929: where (erdl.rowid)
930: in
931: ( select erdl1.rowid
932: from pa_cust_event_rdl_all erdl1,
933: pa_cust_event_rdl_ar erdl2
934: where nvl(erdl2.task_id,-99) = nvl(erdl1.task_id,-99)
935: and erdl2.event_num = erdl1.event_num
936: and erdl2.line_num = erdl1.line_num
937: and erdl1.project_id = erdl2.project_id

Line 944: from pa_cust_event_rdl_ar erdl2

940: */
941: /* delete from pa_cust_event_rdl_all erdl
942: where (erdl.project_id, erdl.event_num) in
943: ( select erdl2.project_id, erdl2.event_num
944: from pa_cust_event_rdl_ar erdl2
945: where nvl(erdl2.task_id,-99) = nvl(erdl.task_id,-99)
946: and erdl2.line_num = erdl.line_num
947: and erdl2.purge_project_id = p_project_id
948: )