APPS.IGS_AD_PRC_TAC_OFFER dependencies on IGS_PE_PERSON_ADDR_PKG

Line 22: asbala 12-nov-03 3227107: address changes - signature of igs_pe_person_addr_pkg.insert_row and update_row changed

18: pkpatel 01-DEC-2002 Bug NO: 2599109 (Sevis DLD)
19: Modified the the signatute of call to TBH IGS_PE_ALT_PERS_ID_PKG.INSERT_ROW
20: anilk 18-FEB-2003 Bug#2784198
21: Added closed_ind = 'N' to where clause for cursor c_hl
22: asbala 12-nov-03 3227107: address changes - signature of igs_pe_person_addr_pkg.insert_row and update_row changed
23: gmaheswa 19-Nov-2003 3227107: Modified cursor c_pa in admp_ins_person_addr to select records having active status.
24: ******************************************************************/
25:
26: --

Line 2316: -- ssawhney : 2225917 SWCR008, made changes due to change in IGS_PE_PERSON_ADDR_PKG

2312: App_Exception.Raise_Exception;
2313: END admp_ins_tac_prsn;
2314: --
2315: -- Insert a new PERSON address record and end date the previous record
2316: -- ssawhney : 2225917 SWCR008, made changes due to change in IGS_PE_PERSON_ADDR_PKG
2317: --
2318: FUNCTION admp_ins_person_addr(
2319: p_person_id IN NUMBER ,
2320: p_addr_type IN VARCHAR2 ,

Line 2377: IGS_PE_PERSON_ADDR_PKG.Update_Row(

2373:
2374: l_party_site_ovn := Rec_IGS_PE_PERSON_Addr.party_site_ovn;
2375: l_location_ovn := Rec_IGS_PE_PERSON_Addr.location_ovn;
2376:
2377: IGS_PE_PERSON_ADDR_PKG.Update_Row(
2378: P_ACTION => 'U',
2379: P_ROWID => lv_RowId,
2380: P_LOCATION_ID => l_location_Id, -- This is wrong: location_id should not be null
2381: P_START_DT => Rec_IGS_PE_PERSON_Addr.Start_Dt,

Line 2420: IGS_PE_PERSON_ADDR_PKG.Insert_Row(

2416: RETURN FALSE;
2417: END IF;
2418: END IF;
2419:
2420: IGS_PE_PERSON_ADDR_PKG.Insert_Row(
2421: P_ACTION => 'I',
2422: P_ROWID => lv_RowId,
2423: P_LOCATION_ID => l_location_Id,
2424: P_START_DT => NULL,