APPS.PA_PURGE_COSTING dependencies on PA_EXPENDITURES_ALL

Line 3746: from pa_expenditures_all x

3742: p_project_id
3743: from pa_routings ro
3744: where not exists
3745: ( select x.expenditure_id
3746: from pa_expenditures_all x
3747: where ro.expenditure_id = x.expenditure_id)
3748: and rownum < l_commit_size ;
3749:
3750: l_NoOfRecordsIns := SQL%ROWCOUNT ;

Line 3780: from pa_expenditures_all x

3776: x_err_stage := 'PA_Routings1: Before deleting records from pa_routings' ;
3777: delete from pa_routings ro
3778: where not exists
3779: ( select x.expenditure_id
3780: from pa_expenditures_all x
3781: where ro.expenditure_id = x.expenditure_id)
3782: and rownum < l_commit_size ;
3783:
3784: l_NoOfRecordsDel := SQL%ROWCOUNT ;

Line 3980: from pa_expenditures_all x

3976: p_purge_release,
3977: p_project_id,
3978: x.Person_Type -- CWK and FPM Changes
3979:
3980: from pa_expenditures_all x
3981: where (x.rowid ) in
3982: ( select x1.rowid
3983: from pa_expenditures_all x1
3984: where not exists ( select ei.expenditure_id

Line 3983: from pa_expenditures_all x1

3979:
3980: from pa_expenditures_all x
3981: where (x.rowid ) in
3982: ( select x1.rowid
3983: from pa_expenditures_all x1
3984: where not exists ( select ei.expenditure_id
3985: from pa_expenditure_items_all ei
3986: where ei.expenditure_id = x1.expenditure_id)
3987: and x1.expenditure_status_code = 'APPROVED'

Line 3999: x_err_stage := 'PA_Expenditures1: Before deleting records from pa_expenditures_all' ;

3995: -- selected because if archive option is selected the the records
3996: -- being purged will be those records which are already archived.
3997: -- table and
3998:
3999: x_err_stage := 'PA_Expenditures1: Before deleting records from pa_expenditures_all' ;
4000: delete from pa_expenditures_all x
4001: where (x.rowid ) in
4002: ( select x1.rowid
4003: from pa_expenditures_all x1,

Line 4000: delete from pa_expenditures_all x

3996: -- being purged will be those records which are already archived.
3997: -- table and
3998:
3999: x_err_stage := 'PA_Expenditures1: Before deleting records from pa_expenditures_all' ;
4000: delete from pa_expenditures_all x
4001: where (x.rowid ) in
4002: ( select x1.rowid
4003: from pa_expenditures_all x1,
4004: pa_expenditures_ar x2

Line 4003: from pa_expenditures_all x1,

3999: x_err_stage := 'PA_Expenditures1: Before deleting records from pa_expenditures_all' ;
4000: delete from pa_expenditures_all x
4001: where (x.rowid ) in
4002: ( select x1.rowid
4003: from pa_expenditures_all x1,
4004: pa_expenditures_ar x2
4005: where x2.expenditure_id = x1.expenditure_id
4006: and x2.purge_project_id = p_project_id
4007: ) ;

Line 4018: x_err_stage := 'PA_Expenditures1: Before deleting records from pa_expenditures_all' ;

4014:
4015: -- If the archive option is not selected then the delete will
4016: -- be based on the commit size.
4017:
4018: x_err_stage := 'PA_Expenditures1: Before deleting records from pa_expenditures_all' ;
4019: delete from pa_expenditures_all x
4020: where (x.rowid ) in
4021: ( select x1.rowid
4022: from pa_expenditures_all x1

Line 4019: delete from pa_expenditures_all x

4015: -- If the archive option is not selected then the delete will
4016: -- be based on the commit size.
4017:
4018: x_err_stage := 'PA_Expenditures1: Before deleting records from pa_expenditures_all' ;
4019: delete from pa_expenditures_all x
4020: where (x.rowid ) in
4021: ( select x1.rowid
4022: from pa_expenditures_all x1
4023: where not exists ( select ei.expenditure_id

Line 4022: from pa_expenditures_all x1

4018: x_err_stage := 'PA_Expenditures1: Before deleting records from pa_expenditures_all' ;
4019: delete from pa_expenditures_all x
4020: where (x.rowid ) in
4021: ( select x1.rowid
4022: from pa_expenditures_all x1
4023: where not exists ( select ei.expenditure_id
4024: from pa_expenditure_items_all ei
4025: where ei.expenditure_id = x1.expenditure_id)
4026: and x1.expenditure_status_code = 'APPROVED'

Line 4049: 'PA_EXPENDITURES_ALL',

4045:
4046: x_err_stage := 'PA_Expenditures1: Commiting the transaction' ;
4047: pa_purge.CommitProcess(p_purge_batch_id,
4048: p_project_id,
4049: 'PA_EXPENDITURES_ALL',
4050: l_NoOfRecordsIns,
4051: l_NoOfRecordsDel,
4052: x_err_code,
4053: x_err_stack,