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_DRAFT_REVENUES_AR

Line 2710: PA_Draft_Revenues_AR ar

2706: mc.REALIZED_LOSSES_AMOUNT,
2707: mc.REALIZED_GAINS_BATCH_NAME,
2708: mc.REALIZED_LOSSES_BATCH_NAME
2709: from Pa_MC_Draft_Revs_All mc,
2710: PA_Draft_Revenues_AR ar
2711: where ar.Purge_Project_Id = p_project_id
2712: and mc.Project_Id = ar.Purge_Project_Id
2713: and mc.Draft_Revenue_Num = ar.Draft_Revenue_Num;
2714:

Line 2784: pa_debug.debug( ' ->Before insert into PA_Draft_Revenues_AR') ;

2780: -- in the commit size.
2781:
2782: l_commit_size := pa_utils2.arpur_mrc_commit_size / 2 ;
2783:
2784: pa_debug.debug( ' ->Before insert into PA_Draft_Revenues_AR') ;
2785: insert into PA_Draft_Revenues_AR (
2786: PURGE_BATCH_ID,
2787: PURGE_RELEASE,
2788: PURGE_PROJECT_ID,

Line 2785: insert into PA_Draft_Revenues_AR (

2781:
2782: l_commit_size := pa_utils2.arpur_mrc_commit_size / 2 ;
2783:
2784: pa_debug.debug( ' ->Before insert into PA_Draft_Revenues_AR') ;
2785: insert into PA_Draft_Revenues_AR (
2786: PURGE_BATCH_ID,
2787: PURGE_RELEASE,
2788: PURGE_PROJECT_ID,
2789: LAST_UPDATE_LOGIN,

Line 2889: pa_debug.debug( ' ->After insert into PA_Draft_Revenues_AR') ;

2885: and rownum <= l_commit_size
2886: ) ;
2887:
2888: l_NoOfRecordsIns := SQL%ROWCOUNT ;
2889: pa_debug.debug( ' ->After insert into PA_Draft_Revenues_AR') ;
2890:
2891: if l_NoOfRecordsIns > 0 then
2892: -- First call the MRC procedure to archive the MC table
2893: -- We have a seperate delete statement if the archive option is

Line 2916: pa_draft_revenues_ar dr2

2912: where (dr.rowid)
2913: in
2914: ( select dr1.rowid
2915: from pa_draft_revenues_all dr1,
2916: pa_draft_revenues_ar dr2
2917: where dr2.draft_revenue_num = dr1.draft_revenue_num
2918: and dr1.project_id = dr2.project_id
2919: and dr2.purge_project_id = p_project_id
2920: ) ;

Line 2925: from pa_draft_revenues_ar dr2

2921: */
2922: delete from pa_draft_revenues_all dr
2923: where (dr.project_id, dr.draft_revenue_num) in
2924: ( select dr2.project_id, dr2.draft_revenue_num
2925: from pa_draft_revenues_ar dr2
2926: where dr2.purge_project_id = p_project_id
2927: ) ;
2928:
2929: /*Code Changes for Bug No.2984871 start */