APPS.PA_PURGE_COSTING dependencies on PA_EXPENDITURES_ALL

Line 3750: from pa_expenditures_all x

3746: p_project_id
3747: from pa_routings ro
3748: where not exists
3749: ( select x.expenditure_id
3750: from pa_expenditures_all x
3751: where ro.expenditure_id = x.expenditure_id)
3752: and rownum < l_commit_size ;
3753:
3754: l_NoOfRecordsIns := SQL%ROWCOUNT ;

Line 3784: from pa_expenditures_all x

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

Line 3984: from pa_expenditures_all x

3980: p_purge_release,
3981: p_project_id,
3982: x.Person_Type -- CWK and FPM Changes
3983:
3984: from pa_expenditures_all x
3985: where (x.rowid ) in
3986: ( select x1.rowid
3987: from pa_expenditures_all x1
3988: where not exists ( select ei.expenditure_id

Line 3987: from pa_expenditures_all x1

3983:
3984: from pa_expenditures_all x
3985: where (x.rowid ) in
3986: ( select x1.rowid
3987: from pa_expenditures_all x1
3988: where not exists ( select ei.expenditure_id
3989: from pa_expenditure_items_all ei
3990: where ei.expenditure_id = x1.expenditure_id)
3991: and x1.expenditure_status_code = 'APPROVED'

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

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

Line 4004: delete from pa_expenditures_all x

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

Line 4007: from pa_expenditures_all x1,

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

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

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

Line 4023: delete from pa_expenditures_all x

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

Line 4026: from pa_expenditures_all x1

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

Line 4053: 'PA_EXPENDITURES_ALL',

4049:
4050: x_err_stage := 'PA_Expenditures1: Commiting the transaction' ;
4051: pa_purge.CommitProcess(p_purge_batch_id,
4052: p_project_id,
4053: 'PA_EXPENDITURES_ALL',
4054: l_NoOfRecordsIns,
4055: l_NoOfRecordsDel,
4056: x_err_code,
4057: x_err_stack,