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_BILLING_MESSAGES

Line 3570: -- Function : Archive and Purge data for table PA_Billing_Messages

3566: -- Start of comments
3567: -- API name : PA_BillingMessages
3568: -- Type : Private
3569: -- Pre-reqs : None
3570: -- Function : Archive and Purge data for table PA_Billing_Messages
3571: -- Parameters : See common list above
3572: -- End of comments
3573: procedure PA_BillingMessages
3574: ( p_purge_batch_id IN NUMBER,

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 3683: from pa_billing_messages bm

3679: LINE_NUM,
3680: PROGRAM_APPLICATION_ID,
3681: PROGRAM_ID,
3682: PROGRAM_UPDATE_DATE
3683: from pa_billing_messages bm
3684: where (
3685: bm.project_id = p_project_id
3686: and rownum <= l_commit_size
3687: ) ;

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 3705: pa_debug.debug( ' ->Before delete from pa_billing_messages ') ;

3701: -- selected because if archive option is selected the the records
3702: -- being purged will be those records which are already archived.
3703: -- table and
3704:
3705: pa_debug.debug( ' ->Before delete from pa_billing_messages ') ;
3706: /* commented and modified as below for performance reasons. Archive Purge 11.5
3707: delete from pa_billing_messages bm
3708: where (bm.rowid)
3709: in

Line 3707: delete from pa_billing_messages bm

3703: -- table and
3704:
3705: pa_debug.debug( ' ->Before delete from pa_billing_messages ') ;
3706: /* commented and modified as below for performance reasons. Archive Purge 11.5
3707: delete from pa_billing_messages bm
3708: where (bm.rowid)
3709: in
3710: ( select bm1.rowid
3711: from pa_billing_messages bm1,

Line 3711: from pa_billing_messages bm1,

3707: delete from pa_billing_messages bm
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: ) ;

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 3717: delete from pa_billing_messages bm

3713: where bm2.purge_project_id = p_project_id
3714: and bm1.project_id = bm2.project_id
3715: ) ;
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

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 ;

Line 3726: pa_debug.debug( ' ->After delete from pa_billing_messages ') ;

3722: ) ;
3723: /*Code Changes for Bug No.2984871 start */
3724: l_NoOfRecordsDel := SQL%ROWCOUNT ;
3725: /*Code Changes for Bug No.2984871 end */
3726: pa_debug.debug( ' ->After delete from pa_billing_messages ') ;
3727:
3728: end if ;
3729: else
3730:

Line 3736: pa_debug.debug( ' ->Before delete from pa_billing_messages ') ;

3732:
3733: -- If the archive option is not selected then the delete will
3734: -- be based on the commit size.
3735:
3736: pa_debug.debug( ' ->Before delete from pa_billing_messages ') ;
3737:
3738: /* commented and modified as below for performance reasons. Archive Purge 11.5
3739: delete from pa_billing_messages bm
3740: where (bm.rowid)

Line 3739: delete from pa_billing_messages bm

3735:
3736: pa_debug.debug( ' ->Before delete from pa_billing_messages ') ;
3737:
3738: /* commented and modified as below for performance reasons. Archive Purge 11.5
3739: delete from pa_billing_messages bm
3740: where (bm.rowid)
3741: in
3742: ( select bm1.rowid
3743: from pa_billing_messages bm1

Line 3743: from pa_billing_messages bm1

3739: delete from pa_billing_messages bm
3740: where (bm.rowid)
3741: in
3742: ( select bm1.rowid
3743: from pa_billing_messages bm1
3744: where bm1.project_id = p_project_id
3745: and rownum <= l_commit_size
3746: ) ;
3747: */

Line 3748: delete from pa_billing_messages bm

3744: where bm1.project_id = p_project_id
3745: and rownum <= l_commit_size
3746: ) ;
3747: */
3748: delete from pa_billing_messages bm
3749: where bm.project_id = p_project_id
3750: and rownum <= l_commit_size;
3751:
3752: /*Code Changes for Bug No.2984871 start */

Line 3755: pa_debug.debug( ' ->After delete from pa_billing_messages ') ;

3751:
3752: /*Code Changes for Bug No.2984871 start */
3753: l_NoOfRecordsDel := SQL%ROWCOUNT ;
3754: /*Code Changes for Bug No.2984871 end */
3755: pa_debug.debug( ' ->After delete from pa_billing_messages ') ;
3756:
3757: end if ;
3758:
3759: if l_NoOfRecordsDel = 0 then

Line 3775: p_table_name => 'PA_BILLING_MESSAGES',

3771: pa_debug.debug( ' ->Calling pa_purge.CommitProcess ') ;
3772: pa_purge.CommitProcess
3773: (p_purge_batch_id => p_purge_batch_id,
3774: p_project_id => p_project_id,
3775: p_table_name => 'PA_BILLING_MESSAGES',
3776: p_NoOfRecordsIns => l_NoOfRecordsIns,
3777: p_NoOfRecordsDel => l_NoOfRecordsDel,
3778: x_err_code => x_err_code,
3779: x_err_stack => x_err_stack,