eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_PRC_TAC_OFFER dependencies on IGS_PE_PERSON

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 1504: -- this IGS_PE_PERSON via the TAC process in this admission period (this may be a

1500: p_course_cd := v_course_cd;
1501: END IF;
1502: -------------------------------------------------------------------------------
1503: -- Validate that a matching admission COURSE has not already been inserted for
1504: -- this IGS_PE_PERSON via the TAC process in this admission period (this may be a
1505: -- result of different payment options)
1506: -------------------------------------------------------------------------------
1507: OPEN c_aa_acai (v_course_cd);
1508: FETCH c_aa_acai INTO

Line 2126: -- Inserts a IGS_PE_PERSON and alternate PERSON ID record with data from TAC

2122: IGS_GE_MSG_STACK.ADD;
2123: App_Exception.Raise_Exception;
2124: END admp_ins_alt_prsn_id;
2125: --
2126: -- Inserts a IGS_PE_PERSON and alternate PERSON ID record with data from TAC
2127: -- ssawhney 2225917 : remove customer creation
2128: FUNCTION admp_ins_tac_prsn(
2129: p_person_id IN NUMBER ,
2130: p_tac_person_id IN VARCHAR2 ,

Line 2152: -- to create IGS_PE_PERSON and alternate PERSON ID records if they

2148: ******************************************************************/
2149:
2150: BEGIN -- admp_ins_tac_prsn
2151: -- This module uses information from the TAC offer load process
2152: -- to create IGS_PE_PERSON and alternate PERSON ID records if they
2153: -- don't already exist.
2154: DECLARE
2155: v_new_person_id IGS_PE_PERSON.person_id%TYPE;
2156: v_new_person_number IGS_PE_PERSON.person_number%TYPE;

Line 2155: v_new_person_id IGS_PE_PERSON.person_id%TYPE;

2151: -- This module uses information from the TAC offer load process
2152: -- to create IGS_PE_PERSON and alternate PERSON ID records if they
2153: -- don't already exist.
2154: DECLARE
2155: v_new_person_id IGS_PE_PERSON.person_id%TYPE;
2156: v_new_person_number IGS_PE_PERSON.person_number%TYPE;
2157: v_message_name VARCHAR2(30);
2158: v_api_x VARCHAR2(1) DEFAULT NULL;
2159: v_new_sex VARCHAR2(1) DEFAULT NULL;

Line 2156: v_new_person_number IGS_PE_PERSON.person_number%TYPE;

2152: -- to create IGS_PE_PERSON and alternate PERSON ID records if they
2153: -- don't already exist.
2154: DECLARE
2155: v_new_person_id IGS_PE_PERSON.person_id%TYPE;
2156: v_new_person_number IGS_PE_PERSON.person_number%TYPE;
2157: v_message_name VARCHAR2(30);
2158: v_api_x VARCHAR2(1) DEFAULT NULL;
2159: v_new_sex VARCHAR2(1) DEFAULT NULL;
2160: l_sex Varchar2(30) DEFAULT NULL;

Line 2233: IGS_PE_PERSON_PKG.Insert_Row(

2229: ELSE
2230: l_sex := 'UNKNOWN';
2231: END IF;
2232:
2233: IGS_PE_PERSON_PKG.Insert_Row(
2234: X_MSG_COUNT => l_msg_count,
2235: X_MSG_DATA => l_msg_data,
2236: X_RETURN_STATUS => l_return_status,
2237: X_ROWID => lv_rowId,

Line 2303: END IF; -- insert of new IGS_PE_PERSON

2299: p_alt_person_id_type,
2300: v_new_person_id,
2301: SYSDATE,
2302: NULL);
2303: END IF; -- insert of new IGS_PE_PERSON
2304: END IF; -- matched person_id <> 0
2305: RETURN TRUE;
2306: END;
2307: EXCEPTION

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 2338: FROM IGS_PE_PERSON_ADDR_V pa

2334: DECLARE
2335: CURSOR c_pa IS
2336: -- SELECT pa.start_dt
2337: SELECT pa.*
2338: FROM IGS_PE_PERSON_ADDR_V pa
2339: WHERE pa.person_id = p_person_id AND
2340: pa.end_dt IS NULL AND
2341: pa.status = 'A' AND
2342: pa.addr_type IN ( SELECT adt.addr_type

Line 2343: FROM IGS_PE_PERSON_ADDR adt

2339: WHERE pa.person_id = p_person_id AND
2340: pa.end_dt IS NULL AND
2341: pa.status = 'A' AND
2342: pa.addr_type IN ( SELECT adt.addr_type
2343: FROM IGS_PE_PERSON_ADDR adt
2344: WHERE adt.correspondence_ind = 'Y');
2345: -- FOR UPDATE OF pa.end_dt NOWAIT;
2346: /* This logic will not work as expected because this cursor may retrieve more than one record
2347: Also, the update will not take place since l_location_id is null */

Line 2351: Rec_IGS_PE_PERSON_Addr c_pa%ROWTYPE;

2347: Also, the update will not take place since l_location_id is null */
2348:
2349: v_pa_rec c_pa%ROWTYPE;
2350: v_aust_postcode NUMBER;
2351: Rec_IGS_PE_PERSON_Addr c_pa%ROWTYPE;
2352: lv_rowid VARCHAR2(25);
2353:
2354: l_party_site_ovn hz_party_sites.object_version_number%TYPE;
2355: l_location_ovn hz_locations.object_version_number%TYPE;

Line 2366: --Set the end date for the previous IGS_PE_PERSON_ADDR record

2362: l_LAST_UPDATE_DATE DATE;
2363: l_location_id NUMBER;
2364:
2365: BEGIN
2366: --Set the end date for the previous IGS_PE_PERSON_ADDR record
2367: --of this address type
2368: OPEN c_pa;
2369: -- FETCH c_pa INTO v_pa_rec;
2370: FETCH c_pa INTO Rec_IGS_PE_PERSON_Addr;

Line 2370: FETCH c_pa INTO Rec_IGS_PE_PERSON_Addr;

2366: --Set the end date for the previous IGS_PE_PERSON_ADDR record
2367: --of this address type
2368: OPEN c_pa;
2369: -- FETCH c_pa INTO v_pa_rec;
2370: FETCH c_pa INTO Rec_IGS_PE_PERSON_Addr;
2371: IF (c_pa%FOUND) THEN
2372: IF TRUNC(v_pa_rec.start_dt) <> TRUNC(p_start_dt) THEN
2373:
2374: l_party_site_ovn := Rec_IGS_PE_PERSON_Addr.party_site_ovn;

Line 2374: l_party_site_ovn := Rec_IGS_PE_PERSON_Addr.party_site_ovn;

2370: FETCH c_pa INTO Rec_IGS_PE_PERSON_Addr;
2371: IF (c_pa%FOUND) THEN
2372: IF TRUNC(v_pa_rec.start_dt) <> TRUNC(p_start_dt) THEN
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',

Line 2375: l_location_ovn := Rec_IGS_PE_PERSON_Addr.location_ovn;

2371: IF (c_pa%FOUND) THEN
2372: IF TRUNC(v_pa_rec.start_dt) <> TRUNC(p_start_dt) THEN
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,

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 2381: P_START_DT => Rec_IGS_PE_PERSON_Addr.Start_Dt,

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,
2382: P_END_DT => TRUNC(p_start_dt - 1),
2383: P_COUNTRY => Rec_IGS_PE_PERSON_Addr.COUNTRY,
2384: P_ADDRESS_STYLE => NULL,
2385: P_ADDR_LINE_1 => Rec_IGS_PE_PERSON_Addr.Addr_Line_1,

Line 2383: P_COUNTRY => Rec_IGS_PE_PERSON_Addr.COUNTRY,

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,
2382: P_END_DT => TRUNC(p_start_dt - 1),
2383: P_COUNTRY => Rec_IGS_PE_PERSON_Addr.COUNTRY,
2384: P_ADDRESS_STYLE => NULL,
2385: P_ADDR_LINE_1 => Rec_IGS_PE_PERSON_Addr.Addr_Line_1,
2386: P_ADDR_LINE_2=> Rec_IGS_PE_PERSON_Addr.Addr_Line_2,
2387: P_ADDR_LINE_3 => Rec_IGS_PE_PERSON_Addr.Addr_Line_3,

Line 2385: P_ADDR_LINE_1 => Rec_IGS_PE_PERSON_Addr.Addr_Line_1,

2381: P_START_DT => Rec_IGS_PE_PERSON_Addr.Start_Dt,
2382: P_END_DT => TRUNC(p_start_dt - 1),
2383: P_COUNTRY => Rec_IGS_PE_PERSON_Addr.COUNTRY,
2384: P_ADDRESS_STYLE => NULL,
2385: P_ADDR_LINE_1 => Rec_IGS_PE_PERSON_Addr.Addr_Line_1,
2386: P_ADDR_LINE_2=> Rec_IGS_PE_PERSON_Addr.Addr_Line_2,
2387: P_ADDR_LINE_3 => Rec_IGS_PE_PERSON_Addr.Addr_Line_3,
2388: P_ADDR_LINE_4 => Rec_IGS_PE_PERSON_Addr.Addr_Line_4,
2389: P_DATE_LAST_VERIFIED => Rec_IGS_PE_PERSON_Addr.DATE_LAST_VERIFIED,

Line 2386: P_ADDR_LINE_2=> Rec_IGS_PE_PERSON_Addr.Addr_Line_2,

2382: P_END_DT => TRUNC(p_start_dt - 1),
2383: P_COUNTRY => Rec_IGS_PE_PERSON_Addr.COUNTRY,
2384: P_ADDRESS_STYLE => NULL,
2385: P_ADDR_LINE_1 => Rec_IGS_PE_PERSON_Addr.Addr_Line_1,
2386: P_ADDR_LINE_2=> Rec_IGS_PE_PERSON_Addr.Addr_Line_2,
2387: P_ADDR_LINE_3 => Rec_IGS_PE_PERSON_Addr.Addr_Line_3,
2388: P_ADDR_LINE_4 => Rec_IGS_PE_PERSON_Addr.Addr_Line_4,
2389: P_DATE_LAST_VERIFIED => Rec_IGS_PE_PERSON_Addr.DATE_LAST_VERIFIED,
2390: P_CORRESPONDENCE => Rec_IGS_PE_PERSON_Addr.CORRESPONDENCE_ind,

Line 2387: P_ADDR_LINE_3 => Rec_IGS_PE_PERSON_Addr.Addr_Line_3,

2383: P_COUNTRY => Rec_IGS_PE_PERSON_Addr.COUNTRY,
2384: P_ADDRESS_STYLE => NULL,
2385: P_ADDR_LINE_1 => Rec_IGS_PE_PERSON_Addr.Addr_Line_1,
2386: P_ADDR_LINE_2=> Rec_IGS_PE_PERSON_Addr.Addr_Line_2,
2387: P_ADDR_LINE_3 => Rec_IGS_PE_PERSON_Addr.Addr_Line_3,
2388: P_ADDR_LINE_4 => Rec_IGS_PE_PERSON_Addr.Addr_Line_4,
2389: P_DATE_LAST_VERIFIED => Rec_IGS_PE_PERSON_Addr.DATE_LAST_VERIFIED,
2390: P_CORRESPONDENCE => Rec_IGS_PE_PERSON_Addr.CORRESPONDENCE_ind,
2391: P_CITY => Rec_IGS_PE_PERSON_Addr.CITY,

Line 2388: P_ADDR_LINE_4 => Rec_IGS_PE_PERSON_Addr.Addr_Line_4,

2384: P_ADDRESS_STYLE => NULL,
2385: P_ADDR_LINE_1 => Rec_IGS_PE_PERSON_Addr.Addr_Line_1,
2386: P_ADDR_LINE_2=> Rec_IGS_PE_PERSON_Addr.Addr_Line_2,
2387: P_ADDR_LINE_3 => Rec_IGS_PE_PERSON_Addr.Addr_Line_3,
2388: P_ADDR_LINE_4 => Rec_IGS_PE_PERSON_Addr.Addr_Line_4,
2389: P_DATE_LAST_VERIFIED => Rec_IGS_PE_PERSON_Addr.DATE_LAST_VERIFIED,
2390: P_CORRESPONDENCE => Rec_IGS_PE_PERSON_Addr.CORRESPONDENCE_ind,
2391: P_CITY => Rec_IGS_PE_PERSON_Addr.CITY,
2392: P_STATE => Rec_IGS_PE_PERSON_Addr.STATE,

Line 2389: P_DATE_LAST_VERIFIED => Rec_IGS_PE_PERSON_Addr.DATE_LAST_VERIFIED,

2385: P_ADDR_LINE_1 => Rec_IGS_PE_PERSON_Addr.Addr_Line_1,
2386: P_ADDR_LINE_2=> Rec_IGS_PE_PERSON_Addr.Addr_Line_2,
2387: P_ADDR_LINE_3 => Rec_IGS_PE_PERSON_Addr.Addr_Line_3,
2388: P_ADDR_LINE_4 => Rec_IGS_PE_PERSON_Addr.Addr_Line_4,
2389: P_DATE_LAST_VERIFIED => Rec_IGS_PE_PERSON_Addr.DATE_LAST_VERIFIED,
2390: P_CORRESPONDENCE => Rec_IGS_PE_PERSON_Addr.CORRESPONDENCE_ind,
2391: P_CITY => Rec_IGS_PE_PERSON_Addr.CITY,
2392: P_STATE => Rec_IGS_PE_PERSON_Addr.STATE,
2393: P_PROVINCE => Rec_IGS_PE_PERSON_Addr.PROVINCE,

Line 2390: P_CORRESPONDENCE => Rec_IGS_PE_PERSON_Addr.CORRESPONDENCE_ind,

2386: P_ADDR_LINE_2=> Rec_IGS_PE_PERSON_Addr.Addr_Line_2,
2387: P_ADDR_LINE_3 => Rec_IGS_PE_PERSON_Addr.Addr_Line_3,
2388: P_ADDR_LINE_4 => Rec_IGS_PE_PERSON_Addr.Addr_Line_4,
2389: P_DATE_LAST_VERIFIED => Rec_IGS_PE_PERSON_Addr.DATE_LAST_VERIFIED,
2390: P_CORRESPONDENCE => Rec_IGS_PE_PERSON_Addr.CORRESPONDENCE_ind,
2391: P_CITY => Rec_IGS_PE_PERSON_Addr.CITY,
2392: P_STATE => Rec_IGS_PE_PERSON_Addr.STATE,
2393: P_PROVINCE => Rec_IGS_PE_PERSON_Addr.PROVINCE,
2394: P_COUNTY => Rec_IGS_PE_PERSON_Addr.COUNTY,

Line 2391: P_CITY => Rec_IGS_PE_PERSON_Addr.CITY,

2387: P_ADDR_LINE_3 => Rec_IGS_PE_PERSON_Addr.Addr_Line_3,
2388: P_ADDR_LINE_4 => Rec_IGS_PE_PERSON_Addr.Addr_Line_4,
2389: P_DATE_LAST_VERIFIED => Rec_IGS_PE_PERSON_Addr.DATE_LAST_VERIFIED,
2390: P_CORRESPONDENCE => Rec_IGS_PE_PERSON_Addr.CORRESPONDENCE_ind,
2391: P_CITY => Rec_IGS_PE_PERSON_Addr.CITY,
2392: P_STATE => Rec_IGS_PE_PERSON_Addr.STATE,
2393: P_PROVINCE => Rec_IGS_PE_PERSON_Addr.PROVINCE,
2394: P_COUNTY => Rec_IGS_PE_PERSON_Addr.COUNTY,
2395: P_POSTAL_CODE => Rec_IGS_PE_PERSON_Addr.postal_code,

Line 2392: P_STATE => Rec_IGS_PE_PERSON_Addr.STATE,

2388: P_ADDR_LINE_4 => Rec_IGS_PE_PERSON_Addr.Addr_Line_4,
2389: P_DATE_LAST_VERIFIED => Rec_IGS_PE_PERSON_Addr.DATE_LAST_VERIFIED,
2390: P_CORRESPONDENCE => Rec_IGS_PE_PERSON_Addr.CORRESPONDENCE_ind,
2391: P_CITY => Rec_IGS_PE_PERSON_Addr.CITY,
2392: P_STATE => Rec_IGS_PE_PERSON_Addr.STATE,
2393: P_PROVINCE => Rec_IGS_PE_PERSON_Addr.PROVINCE,
2394: P_COUNTY => Rec_IGS_PE_PERSON_Addr.COUNTY,
2395: P_POSTAL_CODE => Rec_IGS_PE_PERSON_Addr.postal_code,
2396: P_ADDRESS_LINES_PHONETIC => NULL,

Line 2393: P_PROVINCE => Rec_IGS_PE_PERSON_Addr.PROVINCE,

2389: P_DATE_LAST_VERIFIED => Rec_IGS_PE_PERSON_Addr.DATE_LAST_VERIFIED,
2390: P_CORRESPONDENCE => Rec_IGS_PE_PERSON_Addr.CORRESPONDENCE_ind,
2391: P_CITY => Rec_IGS_PE_PERSON_Addr.CITY,
2392: P_STATE => Rec_IGS_PE_PERSON_Addr.STATE,
2393: P_PROVINCE => Rec_IGS_PE_PERSON_Addr.PROVINCE,
2394: P_COUNTY => Rec_IGS_PE_PERSON_Addr.COUNTY,
2395: P_POSTAL_CODE => Rec_IGS_PE_PERSON_Addr.postal_code,
2396: P_ADDRESS_LINES_PHONETIC => NULL,
2397: P_DELIVERY_POINT_CODE => Rec_IGS_PE_PERSON_Addr.DELIVERY_POINT_CODE,

Line 2394: P_COUNTY => Rec_IGS_PE_PERSON_Addr.COUNTY,

2390: P_CORRESPONDENCE => Rec_IGS_PE_PERSON_Addr.CORRESPONDENCE_ind,
2391: P_CITY => Rec_IGS_PE_PERSON_Addr.CITY,
2392: P_STATE => Rec_IGS_PE_PERSON_Addr.STATE,
2393: P_PROVINCE => Rec_IGS_PE_PERSON_Addr.PROVINCE,
2394: P_COUNTY => Rec_IGS_PE_PERSON_Addr.COUNTY,
2395: P_POSTAL_CODE => Rec_IGS_PE_PERSON_Addr.postal_code,
2396: P_ADDRESS_LINES_PHONETIC => NULL,
2397: P_DELIVERY_POINT_CODE => Rec_IGS_PE_PERSON_Addr.DELIVERY_POINT_CODE,
2398: P_OTHER_DETAILS_1 => Rec_IGS_PE_PERSON_Addr.other_details_1,

Line 2395: P_POSTAL_CODE => Rec_IGS_PE_PERSON_Addr.postal_code,

2391: P_CITY => Rec_IGS_PE_PERSON_Addr.CITY,
2392: P_STATE => Rec_IGS_PE_PERSON_Addr.STATE,
2393: P_PROVINCE => Rec_IGS_PE_PERSON_Addr.PROVINCE,
2394: P_COUNTY => Rec_IGS_PE_PERSON_Addr.COUNTY,
2395: P_POSTAL_CODE => Rec_IGS_PE_PERSON_Addr.postal_code,
2396: P_ADDRESS_LINES_PHONETIC => NULL,
2397: P_DELIVERY_POINT_CODE => Rec_IGS_PE_PERSON_Addr.DELIVERY_POINT_CODE,
2398: P_OTHER_DETAILS_1 => Rec_IGS_PE_PERSON_Addr.other_details_1,
2399: P_OTHER_DETAILS_2 => Rec_IGS_PE_PERSON_Addr.other_details_2,

Line 2397: P_DELIVERY_POINT_CODE => Rec_IGS_PE_PERSON_Addr.DELIVERY_POINT_CODE,

2393: P_PROVINCE => Rec_IGS_PE_PERSON_Addr.PROVINCE,
2394: P_COUNTY => Rec_IGS_PE_PERSON_Addr.COUNTY,
2395: P_POSTAL_CODE => Rec_IGS_PE_PERSON_Addr.postal_code,
2396: P_ADDRESS_LINES_PHONETIC => NULL,
2397: P_DELIVERY_POINT_CODE => Rec_IGS_PE_PERSON_Addr.DELIVERY_POINT_CODE,
2398: P_OTHER_DETAILS_1 => Rec_IGS_PE_PERSON_Addr.other_details_1,
2399: P_OTHER_DETAILS_2 => Rec_IGS_PE_PERSON_Addr.other_details_2,
2400: P_OTHER_DETAILS_3 => Rec_IGS_PE_PERSON_Addr.other_details_3,
2401: L_RETURN_STATUS => l_return_status,

Line 2398: P_OTHER_DETAILS_1 => Rec_IGS_PE_PERSON_Addr.other_details_1,

2394: P_COUNTY => Rec_IGS_PE_PERSON_Addr.COUNTY,
2395: P_POSTAL_CODE => Rec_IGS_PE_PERSON_Addr.postal_code,
2396: P_ADDRESS_LINES_PHONETIC => NULL,
2397: P_DELIVERY_POINT_CODE => Rec_IGS_PE_PERSON_Addr.DELIVERY_POINT_CODE,
2398: P_OTHER_DETAILS_1 => Rec_IGS_PE_PERSON_Addr.other_details_1,
2399: P_OTHER_DETAILS_2 => Rec_IGS_PE_PERSON_Addr.other_details_2,
2400: P_OTHER_DETAILS_3 => Rec_IGS_PE_PERSON_Addr.other_details_3,
2401: L_RETURN_STATUS => l_return_status,
2402: L_MSG_DATA => l_msg_data,

Line 2399: P_OTHER_DETAILS_2 => Rec_IGS_PE_PERSON_Addr.other_details_2,

2395: P_POSTAL_CODE => Rec_IGS_PE_PERSON_Addr.postal_code,
2396: P_ADDRESS_LINES_PHONETIC => NULL,
2397: P_DELIVERY_POINT_CODE => Rec_IGS_PE_PERSON_Addr.DELIVERY_POINT_CODE,
2398: P_OTHER_DETAILS_1 => Rec_IGS_PE_PERSON_Addr.other_details_1,
2399: P_OTHER_DETAILS_2 => Rec_IGS_PE_PERSON_Addr.other_details_2,
2400: P_OTHER_DETAILS_3 => Rec_IGS_PE_PERSON_Addr.other_details_3,
2401: L_RETURN_STATUS => l_return_status,
2402: L_MSG_DATA => l_msg_data,
2403: P_PARTY_ID => Rec_IGS_PE_PERSON_Addr.Person_Id,

Line 2400: P_OTHER_DETAILS_3 => Rec_IGS_PE_PERSON_Addr.other_details_3,

2396: P_ADDRESS_LINES_PHONETIC => NULL,
2397: P_DELIVERY_POINT_CODE => Rec_IGS_PE_PERSON_Addr.DELIVERY_POINT_CODE,
2398: P_OTHER_DETAILS_1 => Rec_IGS_PE_PERSON_Addr.other_details_1,
2399: P_OTHER_DETAILS_2 => Rec_IGS_PE_PERSON_Addr.other_details_2,
2400: P_OTHER_DETAILS_3 => Rec_IGS_PE_PERSON_Addr.other_details_3,
2401: L_RETURN_STATUS => l_return_status,
2402: L_MSG_DATA => l_msg_data,
2403: P_PARTY_ID => Rec_IGS_PE_PERSON_Addr.Person_Id,
2404: P_PARTY_SITE_ID => l_party_site_id,

Line 2403: P_PARTY_ID => Rec_IGS_PE_PERSON_Addr.Person_Id,

2399: P_OTHER_DETAILS_2 => Rec_IGS_PE_PERSON_Addr.other_details_2,
2400: P_OTHER_DETAILS_3 => Rec_IGS_PE_PERSON_Addr.other_details_3,
2401: L_RETURN_STATUS => l_return_status,
2402: L_MSG_DATA => l_msg_data,
2403: P_PARTY_ID => Rec_IGS_PE_PERSON_Addr.Person_Id,
2404: P_PARTY_SITE_ID => l_party_site_id,
2405: P_PARTY_TYPE => l_party_type,
2406: P_LAST_UPDATE_DATE => l_last_update_date,
2407: p_party_site_ovn => l_party_site_ovn,

Line 2409: p_status => Rec_IGS_PE_PERSON_Addr.status

2405: P_PARTY_TYPE => l_party_type,
2406: P_LAST_UPDATE_DATE => l_last_update_date,
2407: p_party_site_ovn => l_party_site_ovn,
2408: p_location_ovn => l_location_ovn,
2409: p_status => Rec_IGS_PE_PERSON_Addr.status
2410: );
2411:
2412: CLOSE c_pa;
2413: ELSE

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,

Line 2426: P_COUNTRY => Rec_IGS_PE_PERSON_Addr.COUNTRY,

2422: P_ROWID => lv_RowId,
2423: P_LOCATION_ID => l_location_Id,
2424: P_START_DT => NULL,
2425: P_END_DT => TRUNC(p_start_dt - 1),
2426: P_COUNTRY => Rec_IGS_PE_PERSON_Addr.COUNTRY,
2427: P_ADDRESS_STYLE => NULL,
2428: P_ADDR_LINE_1 => P_Addr_Line_1,
2429: P_ADDR_LINE_2=> P_Addr_Line_2,
2430: P_ADDR_LINE_3 => P_Addr_Line_3,

Line 2432: P_DATE_LAST_VERIFIED => Rec_IGS_PE_PERSON_Addr.DATE_LAST_VERIFIED,

2428: P_ADDR_LINE_1 => P_Addr_Line_1,
2429: P_ADDR_LINE_2=> P_Addr_Line_2,
2430: P_ADDR_LINE_3 => P_Addr_Line_3,
2431: P_ADDR_LINE_4 => P_Addr_Line_4,
2432: P_DATE_LAST_VERIFIED => Rec_IGS_PE_PERSON_Addr.DATE_LAST_VERIFIED,
2433: P_CORRESPONDENCE => Rec_IGS_PE_PERSON_Addr.CORRESPONDENCE_ind,
2434: P_CITY => Rec_IGS_PE_PERSON_Addr.CITY,
2435: P_STATE => Rec_IGS_PE_PERSON_Addr.STATE,
2436: P_PROVINCE => Rec_IGS_PE_PERSON_Addr.PROVINCE,

Line 2433: P_CORRESPONDENCE => Rec_IGS_PE_PERSON_Addr.CORRESPONDENCE_ind,

2429: P_ADDR_LINE_2=> P_Addr_Line_2,
2430: P_ADDR_LINE_3 => P_Addr_Line_3,
2431: P_ADDR_LINE_4 => P_Addr_Line_4,
2432: P_DATE_LAST_VERIFIED => Rec_IGS_PE_PERSON_Addr.DATE_LAST_VERIFIED,
2433: P_CORRESPONDENCE => Rec_IGS_PE_PERSON_Addr.CORRESPONDENCE_ind,
2434: P_CITY => Rec_IGS_PE_PERSON_Addr.CITY,
2435: P_STATE => Rec_IGS_PE_PERSON_Addr.STATE,
2436: P_PROVINCE => Rec_IGS_PE_PERSON_Addr.PROVINCE,
2437: P_COUNTY => Rec_IGS_PE_PERSON_Addr.COUNTY,

Line 2434: P_CITY => Rec_IGS_PE_PERSON_Addr.CITY,

2430: P_ADDR_LINE_3 => P_Addr_Line_3,
2431: P_ADDR_LINE_4 => P_Addr_Line_4,
2432: P_DATE_LAST_VERIFIED => Rec_IGS_PE_PERSON_Addr.DATE_LAST_VERIFIED,
2433: P_CORRESPONDENCE => Rec_IGS_PE_PERSON_Addr.CORRESPONDENCE_ind,
2434: P_CITY => Rec_IGS_PE_PERSON_Addr.CITY,
2435: P_STATE => Rec_IGS_PE_PERSON_Addr.STATE,
2436: P_PROVINCE => Rec_IGS_PE_PERSON_Addr.PROVINCE,
2437: P_COUNTY => Rec_IGS_PE_PERSON_Addr.COUNTY,
2438: P_POSTAL_CODE => Rec_IGS_PE_PERSON_Addr.postal_code,

Line 2435: P_STATE => Rec_IGS_PE_PERSON_Addr.STATE,

2431: P_ADDR_LINE_4 => P_Addr_Line_4,
2432: P_DATE_LAST_VERIFIED => Rec_IGS_PE_PERSON_Addr.DATE_LAST_VERIFIED,
2433: P_CORRESPONDENCE => Rec_IGS_PE_PERSON_Addr.CORRESPONDENCE_ind,
2434: P_CITY => Rec_IGS_PE_PERSON_Addr.CITY,
2435: P_STATE => Rec_IGS_PE_PERSON_Addr.STATE,
2436: P_PROVINCE => Rec_IGS_PE_PERSON_Addr.PROVINCE,
2437: P_COUNTY => Rec_IGS_PE_PERSON_Addr.COUNTY,
2438: P_POSTAL_CODE => Rec_IGS_PE_PERSON_Addr.postal_code,
2439: P_ADDRESS_LINES_PHONETIC => NULL,

Line 2436: P_PROVINCE => Rec_IGS_PE_PERSON_Addr.PROVINCE,

2432: P_DATE_LAST_VERIFIED => Rec_IGS_PE_PERSON_Addr.DATE_LAST_VERIFIED,
2433: P_CORRESPONDENCE => Rec_IGS_PE_PERSON_Addr.CORRESPONDENCE_ind,
2434: P_CITY => Rec_IGS_PE_PERSON_Addr.CITY,
2435: P_STATE => Rec_IGS_PE_PERSON_Addr.STATE,
2436: P_PROVINCE => Rec_IGS_PE_PERSON_Addr.PROVINCE,
2437: P_COUNTY => Rec_IGS_PE_PERSON_Addr.COUNTY,
2438: P_POSTAL_CODE => Rec_IGS_PE_PERSON_Addr.postal_code,
2439: P_ADDRESS_LINES_PHONETIC => NULL,
2440: P_DELIVERY_POINT_CODE => Rec_IGS_PE_PERSON_Addr.DELIVERY_POINT_CODE,

Line 2437: P_COUNTY => Rec_IGS_PE_PERSON_Addr.COUNTY,

2433: P_CORRESPONDENCE => Rec_IGS_PE_PERSON_Addr.CORRESPONDENCE_ind,
2434: P_CITY => Rec_IGS_PE_PERSON_Addr.CITY,
2435: P_STATE => Rec_IGS_PE_PERSON_Addr.STATE,
2436: P_PROVINCE => Rec_IGS_PE_PERSON_Addr.PROVINCE,
2437: P_COUNTY => Rec_IGS_PE_PERSON_Addr.COUNTY,
2438: P_POSTAL_CODE => Rec_IGS_PE_PERSON_Addr.postal_code,
2439: P_ADDRESS_LINES_PHONETIC => NULL,
2440: P_DELIVERY_POINT_CODE => Rec_IGS_PE_PERSON_Addr.DELIVERY_POINT_CODE,
2441: P_OTHER_DETAILS_1 => Rec_IGS_PE_PERSON_Addr.other_details_1,

Line 2438: P_POSTAL_CODE => Rec_IGS_PE_PERSON_Addr.postal_code,

2434: P_CITY => Rec_IGS_PE_PERSON_Addr.CITY,
2435: P_STATE => Rec_IGS_PE_PERSON_Addr.STATE,
2436: P_PROVINCE => Rec_IGS_PE_PERSON_Addr.PROVINCE,
2437: P_COUNTY => Rec_IGS_PE_PERSON_Addr.COUNTY,
2438: P_POSTAL_CODE => Rec_IGS_PE_PERSON_Addr.postal_code,
2439: P_ADDRESS_LINES_PHONETIC => NULL,
2440: P_DELIVERY_POINT_CODE => Rec_IGS_PE_PERSON_Addr.DELIVERY_POINT_CODE,
2441: P_OTHER_DETAILS_1 => Rec_IGS_PE_PERSON_Addr.other_details_1,
2442: P_OTHER_DETAILS_2 => Rec_IGS_PE_PERSON_Addr.other_details_2,

Line 2440: P_DELIVERY_POINT_CODE => Rec_IGS_PE_PERSON_Addr.DELIVERY_POINT_CODE,

2436: P_PROVINCE => Rec_IGS_PE_PERSON_Addr.PROVINCE,
2437: P_COUNTY => Rec_IGS_PE_PERSON_Addr.COUNTY,
2438: P_POSTAL_CODE => Rec_IGS_PE_PERSON_Addr.postal_code,
2439: P_ADDRESS_LINES_PHONETIC => NULL,
2440: P_DELIVERY_POINT_CODE => Rec_IGS_PE_PERSON_Addr.DELIVERY_POINT_CODE,
2441: P_OTHER_DETAILS_1 => Rec_IGS_PE_PERSON_Addr.other_details_1,
2442: P_OTHER_DETAILS_2 => Rec_IGS_PE_PERSON_Addr.other_details_2,
2443: P_OTHER_DETAILS_3 => Rec_IGS_PE_PERSON_Addr.other_details_3,
2444: L_RETURN_STATUS => l_return_status,

Line 2441: P_OTHER_DETAILS_1 => Rec_IGS_PE_PERSON_Addr.other_details_1,

2437: P_COUNTY => Rec_IGS_PE_PERSON_Addr.COUNTY,
2438: P_POSTAL_CODE => Rec_IGS_PE_PERSON_Addr.postal_code,
2439: P_ADDRESS_LINES_PHONETIC => NULL,
2440: P_DELIVERY_POINT_CODE => Rec_IGS_PE_PERSON_Addr.DELIVERY_POINT_CODE,
2441: P_OTHER_DETAILS_1 => Rec_IGS_PE_PERSON_Addr.other_details_1,
2442: P_OTHER_DETAILS_2 => Rec_IGS_PE_PERSON_Addr.other_details_2,
2443: P_OTHER_DETAILS_3 => Rec_IGS_PE_PERSON_Addr.other_details_3,
2444: L_RETURN_STATUS => l_return_status,
2445: L_MSG_DATA => l_msg_data,

Line 2442: P_OTHER_DETAILS_2 => Rec_IGS_PE_PERSON_Addr.other_details_2,

2438: P_POSTAL_CODE => Rec_IGS_PE_PERSON_Addr.postal_code,
2439: P_ADDRESS_LINES_PHONETIC => NULL,
2440: P_DELIVERY_POINT_CODE => Rec_IGS_PE_PERSON_Addr.DELIVERY_POINT_CODE,
2441: P_OTHER_DETAILS_1 => Rec_IGS_PE_PERSON_Addr.other_details_1,
2442: P_OTHER_DETAILS_2 => Rec_IGS_PE_PERSON_Addr.other_details_2,
2443: P_OTHER_DETAILS_3 => Rec_IGS_PE_PERSON_Addr.other_details_3,
2444: L_RETURN_STATUS => l_return_status,
2445: L_MSG_DATA => l_msg_data,
2446: P_PARTY_ID => Rec_IGS_PE_PERSON_Addr.Person_Id,

Line 2443: P_OTHER_DETAILS_3 => Rec_IGS_PE_PERSON_Addr.other_details_3,

2439: P_ADDRESS_LINES_PHONETIC => NULL,
2440: P_DELIVERY_POINT_CODE => Rec_IGS_PE_PERSON_Addr.DELIVERY_POINT_CODE,
2441: P_OTHER_DETAILS_1 => Rec_IGS_PE_PERSON_Addr.other_details_1,
2442: P_OTHER_DETAILS_2 => Rec_IGS_PE_PERSON_Addr.other_details_2,
2443: P_OTHER_DETAILS_3 => Rec_IGS_PE_PERSON_Addr.other_details_3,
2444: L_RETURN_STATUS => l_return_status,
2445: L_MSG_DATA => l_msg_data,
2446: P_PARTY_ID => Rec_IGS_PE_PERSON_Addr.Person_Id,
2447: P_PARTY_SITE_ID => l_party_site_id,

Line 2446: P_PARTY_ID => Rec_IGS_PE_PERSON_Addr.Person_Id,

2442: P_OTHER_DETAILS_2 => Rec_IGS_PE_PERSON_Addr.other_details_2,
2443: P_OTHER_DETAILS_3 => Rec_IGS_PE_PERSON_Addr.other_details_3,
2444: L_RETURN_STATUS => l_return_status,
2445: L_MSG_DATA => l_msg_data,
2446: P_PARTY_ID => Rec_IGS_PE_PERSON_Addr.Person_Id,
2447: P_PARTY_SITE_ID => l_party_site_id,
2448: P_PARTY_TYPE => l_party_type,
2449: p_last_update_date => l_last_update_date,
2450: p_party_site_ovn => l_party_site_ovn,

Line 2452: p_status => Rec_IGS_PE_PERSON_Addr.status

2448: P_PARTY_TYPE => l_party_type,
2449: p_last_update_date => l_last_update_date,
2450: p_party_site_ovn => l_party_site_ovn,
2451: p_location_ovn => l_location_ovn,
2452: p_status => Rec_IGS_PE_PERSON_Addr.status
2453: );
2454:
2455:
2456: IF v_aust_postcode = 9999 THEN