APPS.PA_PURGE_BILLING dependencies on PA_DISTRIBUTION_WARNINGS

Line 3357: -- Function : Archive and Purge data for table PA_Distribution_Warnings

3353: -- Start of comments
3354: -- API name : PA_DistWarnings
3355: -- Type : Private
3356: -- Pre-reqs : None
3357: -- Function : Archive and Purge data for table PA_Distribution_Warnings
3358: -- Parameters : See common list above
3359: -- End of comments
3360: procedure PA_DistWarnings
3361: ( p_purge_batch_id IN NUMBER,

Line 3438: from pa_distribution_warnings dw

3434: WARNING_MESSAGE,
3435: WARNING_MESSAGE_CODE,
3436: AGREEMENT_ID,
3437: TASK_ID
3438: from pa_distribution_warnings dw
3439: where (
3440: dw.project_id = p_project_id
3441: and rownum <= l_commit_size
3442: ) ;

Line 3455: pa_debug.debug( ' ->Before delete from pa_distribution_warnings ') ;

3451: -- selected because if archive option is selected the the records
3452: -- being purged will be those records which are already archived.
3453: -- table and
3454:
3455: pa_debug.debug( ' ->Before delete from pa_distribution_warnings ') ;
3456: /* commented and modified as below for performance reasons. Archive Purge 11.5
3457: delete from pa_distribution_warnings dw
3458: where (dw.rowid)
3459: in

Line 3457: delete from pa_distribution_warnings dw

3453: -- table and
3454:
3455: pa_debug.debug( ' ->Before delete from pa_distribution_warnings ') ;
3456: /* commented and modified as below for performance reasons. Archive Purge 11.5
3457: delete from pa_distribution_warnings dw
3458: where (dw.rowid)
3459: in
3460: ( select dw1.rowid
3461: from pa_distribution_warnings dw1,

Line 3461: from pa_distribution_warnings dw1,

3457: delete from pa_distribution_warnings dw
3458: where (dw.rowid)
3459: in
3460: ( select dw1.rowid
3461: from pa_distribution_warnings dw1,
3462: PA_DIST_WARNINGS_AR dw2
3463: where dw1.project_id = dw2.project_id
3464: and dw2.purge_project_id = p_project_id
3465: and nvl(dw1.draft_revenue_num,-99)

Line 3472: delete from pa_distribution_warnings dw

3468: = nvl(dw2.draft_invoice_num, -99)
3469: ) ;
3470: */
3471:
3472: delete from pa_distribution_warnings dw
3473: where (dw.project_id) in
3474: ( select dw2.project_id
3475: from PA_DIST_WARNINGS_AR dw2
3476: where dw2.purge_project_id = p_project_id

Line 3487: pa_debug.debug( ' ->After delete from pa_distribution_warnings ') ;

3483:
3484: /*Code Changes for Bug No.2984871 start */
3485: l_NoOfRecordsDel := SQL%ROWCOUNT ;
3486: /*Code Changes for Bug No.2984871 end */
3487: pa_debug.debug( ' ->After delete from pa_distribution_warnings ') ;
3488:
3489: end if ;
3490: else
3491:

Line 3497: pa_debug.debug( ' ->Before delete from pa_distribution_warnings ') ;

3493:
3494: -- If the archive option is not selected then the delete will
3495: -- be based on the commit size.
3496:
3497: pa_debug.debug( ' ->Before delete from pa_distribution_warnings ') ;
3498: /* commented and modified as below for performance reasons. Archive Purge 11.5
3499: delete from pa_distribution_warnings dw
3500: where (dw.rowid)
3501: in

Line 3499: delete from pa_distribution_warnings dw

3495: -- be based on the commit size.
3496:
3497: pa_debug.debug( ' ->Before delete from pa_distribution_warnings ') ;
3498: /* commented and modified as below for performance reasons. Archive Purge 11.5
3499: delete from pa_distribution_warnings dw
3500: where (dw.rowid)
3501: in
3502: ( select dw1.rowid
3503: from pa_distribution_warnings dw1

Line 3503: from pa_distribution_warnings dw1

3499: delete from pa_distribution_warnings dw
3500: where (dw.rowid)
3501: in
3502: ( select dw1.rowid
3503: from pa_distribution_warnings dw1
3504: where dw1.project_id = p_project_id
3505: and rownum <= l_commit_size
3506: ) ;
3507: */

Line 3508: delete from pa_distribution_warnings dw

3504: where dw1.project_id = p_project_id
3505: and rownum <= l_commit_size
3506: ) ;
3507: */
3508: delete from pa_distribution_warnings dw
3509: where dw.project_id = p_project_id
3510: and rownum <= l_commit_size;
3511: /*Code Changes for Bug No.2984871 start */
3512: l_NoOfRecordsDel := SQL%ROWCOUNT ;

Line 3514: pa_debug.debug( ' ->After delete from pa_distribution_warnings ') ;

3510: and rownum <= l_commit_size;
3511: /*Code Changes for Bug No.2984871 start */
3512: l_NoOfRecordsDel := SQL%ROWCOUNT ;
3513: /*Code Changes for Bug No.2984871 end */
3514: pa_debug.debug( ' ->After delete from pa_distribution_warnings ') ;
3515:
3516: end if ;
3517:
3518: if l_NoOfRecordsDel = 0 then

Line 3534: p_table_name => 'PA_DISTRIBUTION_WARNINGS',

3530: pa_debug.debug( ' ->Calling pa_purge.CommitProcess ') ;
3531: pa_purge.CommitProcess
3532: (p_purge_batch_id => p_purge_batch_id,
3533: p_project_id => p_project_id,
3534: p_table_name => 'PA_DISTRIBUTION_WARNINGS',
3535: p_NoOfRecordsIns => l_NoOfRecordsIns,
3536: p_NoOfRecordsDel => l_NoOfRecordsDel,
3537: x_err_code => x_err_code,
3538: x_err_stack => x_err_stack,