APPS.PA_PURGE_BILLING dependencies on PA_DIST_WARNINGS_AR

Line 3396: pa_debug.debug( ' ->Before insert into PA_DIST_WARNINGS_AR') ;

3392: -- in the commit size.
3393:
3394: l_commit_size := pa_utils2.arpur_mrc_commit_size / 2 ;
3395:
3396: pa_debug.debug( ' ->Before insert into PA_DIST_WARNINGS_AR') ;
3397: insert into PA_DIST_WARNINGS_AR (
3398: PURGE_BATCH_ID,
3399: PURGE_RELEASE,
3400: PURGE_PROJECT_ID,

Line 3397: insert into PA_DIST_WARNINGS_AR (

3393:
3394: l_commit_size := pa_utils2.arpur_mrc_commit_size / 2 ;
3395:
3396: pa_debug.debug( ' ->Before insert into PA_DIST_WARNINGS_AR') ;
3397: insert into PA_DIST_WARNINGS_AR (
3398: PURGE_BATCH_ID,
3399: PURGE_RELEASE,
3400: PURGE_PROJECT_ID,
3401: PROJECT_ID,

Line 3445: pa_debug.debug( ' ->After insert into PA_DIST_WARNINGS_AR') ;

3441: and rownum <= l_commit_size
3442: ) ;
3443:
3444: l_NoOfRecordsIns := SQL%ROWCOUNT ;
3445: pa_debug.debug( ' ->After insert into PA_DIST_WARNINGS_AR') ;
3446:
3447: /*Code Changes for Bug No.2984871 start */
3448: if l_NoOfRecordsIns > 0 then
3449: /*Code Changes for Bug No.2984871 end */

Line 3462: PA_DIST_WARNINGS_AR dw2

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)
3466: = nvl(dw2.draft_revenue_num,-99)

Line 3475: from PA_DIST_WARNINGS_AR dw2

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
3477: and nvl(dw.draft_revenue_num,-99)
3478: = nvl(dw2.draft_revenue_num,-99)
3479: and nvl(dw.draft_invoice_num,-99)