APPS.PSP_ROLLBACK_EFF_REPORTS dependencies on PSP_EFF_REPORT_DETAILS

Line 27: psp_eff_report_details perd,

23: where ITEM_TYPE = 'PSPERAVL'
24: and ITEM_KEY in (
25: select pera.WF_ITEM_KEY --into l_itemkey
26: from psp_eff_Report_approvals pera,
27: psp_eff_report_details perd,
28: psp_eff_reports per
29: where pera.EFFORT_REPORT_DETAIL_ID = perd.EFFORT_REPORT_DETAIL_ID
30: and perd.EFFORT_REPORT_ID = per.EFFORT_REPORT_ID
31: and per.request_id = p_request_id );

Line 137: from psp_eff_report_details where

133: /*
134:
135: FORALL i in 1..eff_report_master_rec.effort_report_id.count
136: select effort_report_detail_id BULK COLLECT into eff_report_details_rec.effort_report_detail_id
137: from psp_eff_report_details where
138: effort_report_id =eff_report_master_rec.effort_report_id(i) ;
139:
140: Implementation Restriction forall, BULK COLLECT and SELECT do not work together
141: */

Line 146: select effort_report_detail_id from psp_eff_report_details where effort_report_id

142:
143:
144: FORALL i in 1.. eff_report_master_rec.effort_report_id.count
145: delete from psp_eff_report_approvals where effort_report_detail_id in (
146: select effort_report_detail_id from psp_eff_report_details where effort_report_id
147: = eff_report_master_rec.effort_report_id(i));
148:
149: FORALL i in 1.. eff_report_master_rec.effort_report_id.count
150: delete from psp_eff_report_details where effort_report_detail_id in (

Line 150: delete from psp_eff_report_details where effort_report_detail_id in (

146: select effort_report_detail_id from psp_eff_report_details where effort_report_id
147: = eff_report_master_rec.effort_report_id(i));
148:
149: FORALL i in 1.. eff_report_master_rec.effort_report_id.count
150: delete from psp_eff_report_details where effort_report_detail_id in (
151: select effort_report_detail_id from psp_eff_report_details where effort_report_id
152: = eff_report_master_rec.effort_report_id(i));
153:
154:

Line 151: select effort_report_detail_id from psp_eff_report_details where effort_report_id

147: = eff_report_master_rec.effort_report_id(i));
148:
149: FORALL i in 1.. eff_report_master_rec.effort_report_id.count
150: delete from psp_eff_report_details where effort_report_detail_id in (
151: select effort_report_detail_id from psp_eff_report_details where effort_report_id
152: = eff_report_master_rec.effort_report_id(i));
153:
154:
155: FORALL i in 1..eff_report_master_rec.effort_report_id.count

Line 161: delete from psp_eff_report_details where effort_report_detail_id = eff_report_details_rec.effort_report_detail_id(i);

157:
158: /*
159:
160: FORALL i in 1.. eff_report_details_rec.effort_report_detail_id.count
161: delete from psp_eff_report_details where effort_report_detail_id = eff_report_details_rec.effort_report_detail_id(i);
162:
163: */
164: Delete from psp_report_errors where request_id = p_request_id;
165: