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_ALL

Line 679: -- Function : Archive and Purge data for table PA_CUST_EVENT_RDL_ALL

675: -- Start of comments
676: -- API name : PA_EventRevDistLines
677: -- Type : Private
678: -- Pre-reqs : None
679: -- Function : Archive and Purge data for table PA_CUST_EVENT_RDL_ALL
680: -- Parameters : See common list above
681: -- End of comments
682: procedure PA_EventRevDistLines
683: ( p_purge_batch_id IN NUMBER,

Line 706: select erdl.rowid from pa_cust_event_rdl_all erdl

702: l_fetch_complete BOOLEAN := FALSE;
703: l_erdl_ind NUMBER;
704:
705: cursor c_erdl_records is
706: select erdl.rowid from pa_cust_event_rdl_all erdl
707: where erdl.project_id = p_project_id;
708:
709: begin
710:

Line 893: from pa_cust_event_rdl_all erdl

889: RETN_DRAFT_INVOICE_NUM,
890: RETN_DRAFT_INVOICE_LINE_NUM,
891: RETAINED_AMOUNT,
892: RETENTION_RULE_ID
893: from pa_cust_event_rdl_all erdl
894: where erdl.rowid = l_erdl_rowid_tab(l_erdl_ind);
895:
896: l_NoOfRecordsIns := SQL%ROWCOUNT ;
897: END IF;

Line 926: pa_debug.debug( ' ->Before delete from pa_cust_event_rdl_all ') ;

922: x_err_stack => x_err_stack,
923: x_err_stage => x_err_stage
924: ) ;
925: end if;
926: pa_debug.debug( ' ->Before delete from pa_cust_event_rdl_all ') ;
927: /* commented and modified as below for performance reasons. Archive Purge 11.5
928: delete from pa_cust_event_rdl_all erdl
929: where (erdl.rowid)
930: in

Line 928: delete from pa_cust_event_rdl_all erdl

924: ) ;
925: end if;
926: pa_debug.debug( ' ->Before delete from pa_cust_event_rdl_all ') ;
927: /* commented and modified as below for performance reasons. Archive Purge 11.5
928: delete from pa_cust_event_rdl_all erdl
929: where (erdl.rowid)
930: in
931: ( select erdl1.rowid
932: from pa_cust_event_rdl_all erdl1,

Line 932: from pa_cust_event_rdl_all erdl1,

928: delete from pa_cust_event_rdl_all erdl
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

Line 941: /* delete from pa_cust_event_rdl_all erdl

937: and erdl1.project_id = erdl2.project_id
938: and erdl2.purge_project_id = p_project_id
939: ) ;
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)

Line 951: pa_debug.debug( ' ->After delete from pa_cust_event_rdl_all ') ;

947: and erdl2.purge_project_id = p_project_id
948: )
949: and erdl.project_id = p_project_id; -- Perf Bug 2695202
950:
951: pa_debug.debug( ' ->After delete from pa_cust_event_rdl_all ') ;
952: */
953: FORALL l_erdl_ind IN l_erdl_rowid_tab.FIRST .. l_erdl_rowid_tab.LAST
954: DELETE FROM PA_CUST_EVENT_RDL_ALL ERDL
955: WHERE ERDL.rowid = l_erdl_rowid_tab(l_erdl_ind);

Line 954: DELETE FROM PA_CUST_EVENT_RDL_ALL ERDL

950:
951: pa_debug.debug( ' ->After delete from pa_cust_event_rdl_all ') ;
952: */
953: FORALL l_erdl_ind IN l_erdl_rowid_tab.FIRST .. l_erdl_rowid_tab.LAST
954: DELETE FROM PA_CUST_EVENT_RDL_ALL ERDL
955: WHERE ERDL.rowid = l_erdl_rowid_tab(l_erdl_ind);
956:
957: l_NoOfRecordsDel := SQL%ROWCOUNT ;
958: l_MC_NoOfRecordsDel := PA_UTILS2.mrc_row_count;

Line 967: pa_debug.debug( ' ->Before delete from pa_cust_event_rdl_all ') ;

963:
964: -- If the archive option is not selected then the delete will
965: -- be based on the commit size.
966:
967: pa_debug.debug( ' ->Before delete from pa_cust_event_rdl_all ') ;
968: */
969: /* commented and modified as below for performance reasons. Archive Purge 11.5
970: delete from pa_cust_event_rdl_all erdl
971: where (erdl.rowid)

Line 970: delete from pa_cust_event_rdl_all erdl

966:
967: pa_debug.debug( ' ->Before delete from pa_cust_event_rdl_all ') ;
968: */
969: /* commented and modified as below for performance reasons. Archive Purge 11.5
970: delete from pa_cust_event_rdl_all erdl
971: where (erdl.rowid)
972: in
973: ( select erdl1.rowid
974: from pa_cust_event_rdl_all erdl1

Line 974: from pa_cust_event_rdl_all erdl1

970: delete from pa_cust_event_rdl_all erdl
971: where (erdl.rowid)
972: in
973: ( select erdl1.rowid
974: from pa_cust_event_rdl_all erdl1
975: where erdl1.project_id = p_project_id
976: and rownum <= l_commit_size
977: ) ;
978: */

Line 980: delete from pa_cust_event_rdl_all erdl

976: and rownum <= l_commit_size
977: ) ;
978: */
979: /*
980: delete from pa_cust_event_rdl_all erdl
981: where erdl.project_id = p_project_id
982: and rownum <= l_commit_size;
983: l_NoOfRecordsDel := SQL%ROWCOUNT ;
984: l_MC_NoOfRecordsDel := PA_UTILS2.mrc_row_count;

Line 985: pa_debug.debug( ' ->After delete from pa_cust_event_rdl_all ') ;

981: where erdl.project_id = p_project_id
982: and rownum <= l_commit_size;
983: l_NoOfRecordsDel := SQL%ROWCOUNT ;
984: l_MC_NoOfRecordsDel := PA_UTILS2.mrc_row_count;
985: pa_debug.debug( ' ->After delete from pa_cust_event_rdl_all ') ;
986: end if ;
987:
988:
989: if SQL%ROWCOUNT = 0 then

Line 1006: p_table_name => 'PA_CUST_EVENT_RDL_ALL',

1002: pa_debug.debug( ' ->Calling pa_purge.CommitProcess ') ;
1003: pa_purge.CommitProcess
1004: (p_purge_batch_id => p_purge_batch_id,
1005: p_project_id => p_project_id,
1006: p_table_name => 'PA_CUST_EVENT_RDL_ALL',
1007: p_NoOfRecordsIns => l_NoOfRecordsIns,
1008: p_NoOfRecordsDel => l_NoOfRecordsDel,
1009: x_err_code => x_err_code,
1010: x_err_stack => x_err_stack,