[Home] [Help]
18: pkpatel 9-Nov-2004 Bug 3993967 (Modified signature of procedure CHANGE_RESIDENCE. Modified process_residency as per new
19: Notification message. Stubbed the procedure get_res_details.)
20: pkpatel 19=Sep-2005 Bug 4618459 (Removed the reference of HZ_PARAM_TAB. Commented the procedure get_address_dtls.
21: stubbed the procedures address_update and primary_address_ind_update)
22: pkpatel 21-Feb-2006 Bug 4938278 (Added the cursor in the create_address to retrieve the Dates from igs_pe_hz_pty_sites)
23: vskumar 24-May-2006 Bug 5211157 Added two procdeures specs raise_acad_intent_event and process_acad_intent
24: ******************************************************************/
25:
26:
344: lookup_code=cp_lk_code;
345:
346: CURSOR get_effective_dates_cur (cp_party_site_id NUMBER) IS
347: SELECT start_date, end_date
348: FROM igs_pe_hz_pty_sites
349: WHERE party_site_id = cp_party_site_id;
350:
351: cur_get_party_id_rec cur_get_party_id%ROWTYPE;
352: get_location_dets_rec get_location_dets%ROWTYPE;
583: WHERE location_id = cp_location_id;
584:
585: CURSOR get_effective_dates (cp_party_site_id NUMBER) IS
586: SELECT start_date, end_date
587: FROM igs_pe_hz_pty_sites
588: WHERE party_site_id = cp_party_site_id;
589:
590: CURSOR get_old_addr_dtls(cp_location_id NUMBER) IS
591: SELECT address1, address2, address3, address4, city,
722: aname => 'NEW_DEL_POINT',
723: avalue => rec_location_dtls.DELIVERY_POINT_CODE
724: );
725:
726: --Get the start and end date of the Address from the IGS_PE_HZ_PTY_SITES table and set the M_NEW_ start and end date parameters.
727: OPEN get_effective_dates(l_party_site_id);
728: FETCH get_effective_dates INTO rec_effective_dates;
729: CLOSE get_effective_dates;
730: