APPS.PA_PURGE_BILLING dependencies on PA_DRAFT_INVOICES_AR

Line 3062: pa_debug.debug( ' ->Before insert into PA_Draft_Invoices_AR') ;

3058: -- in the commit size.
3059:
3060: l_commit_size := pa_utils2.arpur_mrc_commit_size / 2 ;
3061:
3062: pa_debug.debug( ' ->Before insert into PA_Draft_Invoices_AR') ;
3063: insert into PA_Draft_Invoices_AR (
3064: PURGE_BATCH_ID,
3065: PURGE_RELEASE,
3066: PURGE_PROJECT_ID,

Line 3063: insert into PA_Draft_Invoices_AR (

3059:
3060: l_commit_size := pa_utils2.arpur_mrc_commit_size / 2 ;
3061:
3062: pa_debug.debug( ' ->Before insert into PA_Draft_Invoices_AR') ;
3063: insert into PA_Draft_Invoices_AR (
3064: PURGE_BATCH_ID,
3065: PURGE_RELEASE,
3066: PURGE_PROJECT_ID,
3067: SYSTEM_REFERENCE,

Line 3246: pa_debug.debug( ' ->After insert into PA_Draft_Invoices_AR') ;

3242: ) ;
3243:
3244: l_NoOfRecordsIns := SQL%ROWCOUNT ;
3245:
3246: pa_debug.debug( ' ->After insert into PA_Draft_Invoices_AR') ;
3247: if l_NoOfRecordsIns > 0 then
3248: -- We have a seperate delete statement if the archive option is
3249: -- selected because if archive option is selected the the records
3250: -- being purged will be those records which are already archived.

Line 3260: pa_draft_invoices_ar di2

3256: where (di.rowid)
3257: in
3258: ( select di1.rowid
3259: from pa_draft_invoices_all di1,
3260: pa_draft_invoices_ar di2
3261: where di2.draft_invoice_num = di1.draft_invoice_num
3262: and di1.project_id = di2.project_id
3263: and di2.purge_project_id = p_project_id
3264: ) ;

Line 3270: from pa_draft_invoices_ar di2

3266:
3267: delete from pa_draft_invoices_all di
3268: where (di.project_id, di.draft_invoice_num) in
3269: ( select di2.project_id, di2.draft_invoice_num
3270: from pa_draft_invoices_ar di2
3271: where di2.purge_project_id = p_project_id
3272: ) ;
3273:
3274: pa_debug.debug( ' ->After delete from pa_draft_invoices_all ') ;