APPS.PA_PURGE_BILLING dependencies on PA_BILLING_MESSAGES_AR

Line 3609: pa_debug.debug( ' ->Before insert into PA_Billing_Messages_AR') ;

3605: -- in the commit size.
3606:
3607: l_commit_size := pa_utils2.arpur_mrc_commit_size / 2 ;
3608:
3609: pa_debug.debug( ' ->Before insert into PA_Billing_Messages_AR') ;
3610: insert into PA_Billing_Messages_AR (
3611: PURGE_BATCH_ID,
3612: PURGE_RELEASE,
3613: PURGE_PROJECT_ID,

Line 3610: insert into PA_Billing_Messages_AR (

3606:
3607: l_commit_size := pa_utils2.arpur_mrc_commit_size / 2 ;
3608:
3609: pa_debug.debug( ' ->Before insert into PA_Billing_Messages_AR') ;
3610: insert into PA_Billing_Messages_AR (
3611: PURGE_BATCH_ID,
3612: PURGE_RELEASE,
3613: PURGE_PROJECT_ID,
3614: INSERTING_PROCEDURE_NAME,

Line 3692: pa_debug.debug( ' ->After insert into pa_billing_messages_AR') ;

3688: /*Code Changes for Bug No.2984871 start */
3689: l_NoOfRecordsIns := SQL%ROWCOUNT ;
3690: /*Code Changes for Bug No.2984871 end */
3691:
3692: pa_debug.debug( ' ->After insert into pa_billing_messages_AR') ;
3693:
3694: /* Commented for Bug 2984871
3695: if SQL%ROWCOUNT > 0 then */
3696:

Line 3712: pa_billing_messages_ar bm2

3708: where (bm.rowid)
3709: in
3710: ( select bm1.rowid
3711: from pa_billing_messages bm1,
3712: pa_billing_messages_ar bm2
3713: where bm2.purge_project_id = p_project_id
3714: and bm1.project_id = bm2.project_id
3715: ) ;
3716: */

Line 3720: from pa_billing_messages_ar bm2

3716: */
3717: delete from pa_billing_messages bm
3718: where (bm.project_id) in
3719: ( select bm2.project_id
3720: from pa_billing_messages_ar bm2
3721: where bm2.purge_project_id = p_project_id
3722: ) ;
3723: /*Code Changes for Bug No.2984871 start */
3724: l_NoOfRecordsDel := SQL%ROWCOUNT ;