APPS.PA_PURGE_COSTING dependencies on PA_MC_CC_DIST_LINES_AR

Line 821: from pa_mc_cc_dist_lines_ar cdar

817: x_err_stage := 'Before deleting records from PA_MC_CC_DIST_LINES_ALL' ;
818: delete from pa_mc_cc_dist_lines_all cdl
819: where (cdl.cc_dist_line_id) in
820: ( select cdar.cc_dist_line_id
821: from pa_mc_cc_dist_lines_ar cdar
822: where cdar.purge_project_id = p_project_id ) ;
823: l_MRC_NoOfRecordsDel := SQL%ROWCOUNT;
824: End if;
825:

Line 872: /* 'PA_MC_CC_DIST_LINES_AR', */

868: l_NoOfRecordsDel,
869: x_err_code,
870: x_err_stack,
871: x_err_stage,
872: /* 'PA_MC_CC_DIST_LINES_AR', */
873: 'PA_MC_CC_DIST_LINES',
874: x_MRC_NoOfRecordsIns,
875: l_MRC_NoOfRecordsDel
876: ) ;

Line 4385: x_err_stack := x_err_stack || ' ->Before insert into MRC PA_MC_CC_DIST_LINES_AR ' ;

4381: BEGIN
4382:
4383: l_old_err_stack := x_err_stack;
4384:
4385: x_err_stack := x_err_stack || ' ->Before insert into MRC PA_MC_CC_DIST_LINES_AR ' ;
4386:
4387: x_err_stage := 'Before insert into PA_MC_CC_DIST_LINES_AR' ;
4388: INSERT INTO PA_MC_CC_DIST_LINES_AR
4389: (PURGE_BATCH_ID,

Line 4387: x_err_stage := 'Before insert into PA_MC_CC_DIST_LINES_AR' ;

4383: l_old_err_stack := x_err_stack;
4384:
4385: x_err_stack := x_err_stack || ' ->Before insert into MRC PA_MC_CC_DIST_LINES_AR ' ;
4386:
4387: x_err_stage := 'Before insert into PA_MC_CC_DIST_LINES_AR' ;
4388: INSERT INTO PA_MC_CC_DIST_LINES_AR
4389: (PURGE_BATCH_ID,
4390: PURGE_RELEASE,
4391: PURGE_PROJECT_ID,

Line 4388: INSERT INTO PA_MC_CC_DIST_LINES_AR

4384:
4385: x_err_stack := x_err_stack || ' ->Before insert into MRC PA_MC_CC_DIST_LINES_AR ' ;
4386:
4387: x_err_stage := 'Before insert into PA_MC_CC_DIST_LINES_AR' ;
4388: INSERT INTO PA_MC_CC_DIST_LINES_AR
4389: (PURGE_BATCH_ID,
4390: PURGE_RELEASE,
4391: PURGE_PROJECT_ID,
4392: SET_OF_BOOKS_ID,

Line 4444: PA_MC_CC_DIST_LINES_AR MC_AR_CDL

4440: AND AR_CDL.PURGE_PROJECT_ID = P_PROJECT_ID
4441: AND NOT EXISTS (
4442: SELECT MC_CDL.expenditure_item_id
4443: FROM
4444: PA_MC_CC_DIST_LINES_AR MC_AR_CDL
4445: WHERE
4446: MC_AR_CDL.purge_project_id = P_PROJECT_ID
4447: AND MC_AR_CDL.expenditure_item_id = MC_CDL.expenditure_item_id
4448: AND MC_AR_CDL.line_num = MC_CDL.line_num