146:
147: --PROCEDURE IMPLEMENTATION DETAILS
148: --While deleting the records from access table we are not considering the counter value
149: --in the access table this is because we do delete only for the accounts which
150: --doesnot have the corresponding party_id in the CSM_PARTIES_ACC Table.
151: --ie.The Delete depends only the pary acccess table.This delete procedure is called
152: --whenever the pary delete is called
153: PROCEDURE CUST_ACCOUNTS_DEL (p_party_id NUMBER , p_user_id NUMBER)
154: IS
160: WHERE acc.USER_ID = c_user_id
161: AND NOT EXISTS
162: (
163: SELECT 1
164: FROM CSM_PARTIES_ACC acc
165: WHERE acc.USER_ID = c_user_id
166: AND acc.party_ID = c_party_id
167: );
168: