[Home] [Help]
63: is 'S'
64: - wwbug 210697
65: 80.5 (70.8) 11-AUG-94 JRHODES #226211 Changed del from pay_element_entries_f
66: to improve performance
67: 70.9 01-FEB-95 JRHODES Delete PER_PAY_PROPOSALS (G1773)
68: 70.10 06-APR-95 JRHODES Bug 271369
69: Use effective_start_date in
70: closed_element_entry_check
71: 70.11 14-jun-95 TMathers Added moderate_predel_validation
85: to delete per_pay_proposal_components
86: in the case of a multi-component
87: proposal, to maintain referential
88: integrity. The original delete from
89: per_pay_proposals follows as before.
90: 70.16 22-Oct-96 Ty Hayden Added section to delete phones.
91: 70.17 06-Nov-96 BSanders 410245 Performance modifications to delete
92: statements replacing the exists statement
93: with 'in' to prevent full table scan of
1420: FOR UPDATE;
1421: --
1422: cursor DELETE_COMPONENTS is
1423: select pp.pay_proposal_id
1424: from per_pay_proposals pp,
1425: per_assignments_f pa
1426: where pa.person_id = P_PERSON_ID
1427: and pa.assignment_id = pp.assignment_id
1428: FOR UPDATE;
1853: --
1854: begin
1855: --
1856: -- Bug 349818. Delete from per_pay_proposal_components before
1857: -- deleting from the parent record in per_pay_proposals to
1858: -- maintain referential integrity, using the cursor DELETE_COMPONENTS
1859: -- and the original per_pay_proposals delete.
1860: --
1861: open DELETE_COMPONENTS;
1855: --
1856: -- Bug 349818. Delete from per_pay_proposal_components before
1857: -- deleting from the parent record in per_pay_proposals to
1858: -- maintain referential integrity, using the cursor DELETE_COMPONENTS
1859: -- and the original per_pay_proposals delete.
1860: --
1861: open DELETE_COMPONENTS;
1862: LOOP
1863: FETCH DELETE_COMPONENTS INTO v_proposal_id;
1868: close DELETE_COMPONENTS;
1869: --
1870: -- Now delete the parent proposal record.
1871: --
1872: delete from per_pay_proposals p
1873: where exists (
1874: select null
1875: from per_assignments_f ass
1876: where ass.assignment_id = p.assignment_id