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.IGF_SL_CL_ORIG_ACK dependencies on HZ_PARTIES

Line 234: p_n_person_id OUT NOCOPY hz_parties.party_id%TYPE,

230: PROCEDURE process_borrow_stud_rec (p_rec_resp_r1 IN igf_sl_cl_resp_r1_all%ROWTYPE);
231:
232: PROCEDURE perform_ssn_match(p_rec_resp_r1 IN igf_sl_cl_resp_r1_all%ROWTYPE,
233: p_c_pers_typ_ind IN VARCHAR2,
234: p_n_person_id OUT NOCOPY hz_parties.party_id%TYPE,
235: p_n_person_number OUT NOCOPY hz_parties.party_number%TYPE,
236: p_c_pers_exists OUT NOCOPY BOOLEAN
237: ) ;
238:

Line 235: p_n_person_number OUT NOCOPY hz_parties.party_number%TYPE,

231:
232: PROCEDURE perform_ssn_match(p_rec_resp_r1 IN igf_sl_cl_resp_r1_all%ROWTYPE,
233: p_c_pers_typ_ind IN VARCHAR2,
234: p_n_person_id OUT NOCOPY hz_parties.party_id%TYPE,
235: p_n_person_number OUT NOCOPY hz_parties.party_number%TYPE,
236: p_c_pers_exists OUT NOCOPY BOOLEAN
237: ) ;
238:
239: FUNCTION create_person_record(p_rec_resp_r1 IN igf_sl_cl_resp_r1_all%ROWTYPE,

Line 241: p_n_person_id OUT NOCOPY hz_parties.party_id%TYPE,

237: ) ;
238:
239: FUNCTION create_person_record(p_rec_resp_r1 IN igf_sl_cl_resp_r1_all%ROWTYPE,
240: p_c_pers_typ_ind IN VARCHAR2,
241: p_n_person_id OUT NOCOPY hz_parties.party_id%TYPE,
242: p_n_person_number OUT NOCOPY hz_parties.party_number%TYPE
243: ) RETURN BOOLEAN ;
244:
245: FUNCTION create_person_addr_record(p_n_person_id IN hz_parties.party_id%TYPE,

Line 242: p_n_person_number OUT NOCOPY hz_parties.party_number%TYPE

238:
239: FUNCTION create_person_record(p_rec_resp_r1 IN igf_sl_cl_resp_r1_all%ROWTYPE,
240: p_c_pers_typ_ind IN VARCHAR2,
241: p_n_person_id OUT NOCOPY hz_parties.party_id%TYPE,
242: p_n_person_number OUT NOCOPY hz_parties.party_number%TYPE
243: ) RETURN BOOLEAN ;
244:
245: FUNCTION create_person_addr_record(p_n_person_id IN hz_parties.party_id%TYPE,
246: p_v_person_number IN hz_parties.party_number%TYPE,

Line 245: FUNCTION create_person_addr_record(p_n_person_id IN hz_parties.party_id%TYPE,

241: p_n_person_id OUT NOCOPY hz_parties.party_id%TYPE,
242: p_n_person_number OUT NOCOPY hz_parties.party_number%TYPE
243: ) RETURN BOOLEAN ;
244:
245: FUNCTION create_person_addr_record(p_n_person_id IN hz_parties.party_id%TYPE,
246: p_v_person_number IN hz_parties.party_number%TYPE,
247: p_rec_resp_r1 IN igf_sl_cl_resp_r1_all%ROWTYPE
248: ) RETURN BOOLEAN ;
249:

Line 246: p_v_person_number IN hz_parties.party_number%TYPE,

242: p_n_person_number OUT NOCOPY hz_parties.party_number%TYPE
243: ) RETURN BOOLEAN ;
244:
245: FUNCTION create_person_addr_record(p_n_person_id IN hz_parties.party_id%TYPE,
246: p_v_person_number IN hz_parties.party_number%TYPE,
247: p_rec_resp_r1 IN igf_sl_cl_resp_r1_all%ROWTYPE
248: ) RETURN BOOLEAN ;
249:
250: -- bvisvana - Bug # 4120082 - Telphone Number not created

Line 252: FUNCTION create_person_telephone_record (p_n_person_id IN hz_parties.party_id%TYPE,

248: ) RETURN BOOLEAN ;
249:
250: -- bvisvana - Bug # 4120082 - Telphone Number not created
251:
252: FUNCTION create_person_telephone_record (p_n_person_id IN hz_parties.party_id%TYPE,
253: p_rec_resp_r1 IN igf_sl_cl_resp_r1_all%ROWTYPE
254: ) RETURN BOOLEAN;
255:
256: FUNCTION create_borrow_stud_rel ( p_n_borrower_id IN hz_parties.party_id%TYPE,

Line 256: FUNCTION create_borrow_stud_rel ( p_n_borrower_id IN hz_parties.party_id%TYPE,

252: FUNCTION create_person_telephone_record (p_n_person_id IN hz_parties.party_id%TYPE,
253: p_rec_resp_r1 IN igf_sl_cl_resp_r1_all%ROWTYPE
254: ) RETURN BOOLEAN;
255:
256: FUNCTION create_borrow_stud_rel ( p_n_borrower_id IN hz_parties.party_id%TYPE,
257: p_v_borrower_number IN hz_parties.party_number%TYPE,
258: p_n_student_id IN hz_parties.party_id%TYPE,
259: p_v_student_number IN hz_parties.party_number%TYPE
260: ) RETURN BOOLEAN;

Line 257: p_v_borrower_number IN hz_parties.party_number%TYPE,

253: p_rec_resp_r1 IN igf_sl_cl_resp_r1_all%ROWTYPE
254: ) RETURN BOOLEAN;
255:
256: FUNCTION create_borrow_stud_rel ( p_n_borrower_id IN hz_parties.party_id%TYPE,
257: p_v_borrower_number IN hz_parties.party_number%TYPE,
258: p_n_student_id IN hz_parties.party_id%TYPE,
259: p_v_student_number IN hz_parties.party_number%TYPE
260: ) RETURN BOOLEAN;
261:

Line 258: p_n_student_id IN hz_parties.party_id%TYPE,

254: ) RETURN BOOLEAN;
255:
256: FUNCTION create_borrow_stud_rel ( p_n_borrower_id IN hz_parties.party_id%TYPE,
257: p_v_borrower_number IN hz_parties.party_number%TYPE,
258: p_n_student_id IN hz_parties.party_id%TYPE,
259: p_v_student_number IN hz_parties.party_number%TYPE
260: ) RETURN BOOLEAN;
261:
262: PROCEDURE raise_scr_event ( p_rec_resp_r1 IN igf_sl_cl_resp_r1_all%ROWTYPE,

Line 259: p_v_student_number IN hz_parties.party_number%TYPE

255:
256: FUNCTION create_borrow_stud_rel ( p_n_borrower_id IN hz_parties.party_id%TYPE,
257: p_v_borrower_number IN hz_parties.party_number%TYPE,
258: p_n_student_id IN hz_parties.party_id%TYPE,
259: p_v_student_number IN hz_parties.party_number%TYPE
260: ) RETURN BOOLEAN;
261:
262: PROCEDURE raise_scr_event ( p_rec_resp_r1 IN igf_sl_cl_resp_r1_all%ROWTYPE,
263: p_c_borrow_created IN VARCHAR2,

Line 271: p_v_person_number IN hz_parties.party_number%TYPE,

267:
268: PROCEDURE raise_gamt_event ( p_v_ci_alternate_code IN igs_ca_inst_all.alternate_code%TYPE,
269: p_d_ci_start_dt IN igs_ca_inst_all.start_dt%TYPE,
270: p_d_ci_end_dt IN igs_ca_inst_all.end_dt%TYPE,
271: p_v_person_number IN hz_parties.party_number%TYPE,
272: p_v_person_name IN hz_parties.party_name%TYPE,
273: p_v_ssn IN igf_ap_isir_ints_all.current_ssn_txt%TYPE,
274: p_v_loan_number IN igf_sl_loans_all.loan_number%TYPE,
275: p_d_loan_per_begin_date IN igf_sl_loans_all.loan_per_begin_date%TYPE,

Line 272: p_v_person_name IN hz_parties.party_name%TYPE,

268: PROCEDURE raise_gamt_event ( p_v_ci_alternate_code IN igs_ca_inst_all.alternate_code%TYPE,
269: p_d_ci_start_dt IN igs_ca_inst_all.start_dt%TYPE,
270: p_d_ci_end_dt IN igs_ca_inst_all.end_dt%TYPE,
271: p_v_person_number IN hz_parties.party_number%TYPE,
272: p_v_person_name IN hz_parties.party_name%TYPE,
273: p_v_ssn IN igf_ap_isir_ints_all.current_ssn_txt%TYPE,
274: p_v_loan_number IN igf_sl_loans_all.loan_number%TYPE,
275: p_d_loan_per_begin_date IN igf_sl_loans_all.loan_per_begin_date%TYPE,
276: p_d_loan_per_end_date IN igf_sl_loans_all.loan_per_end_date%TYPE,

Line 626: hz_parties pe

622: igs_pe_alt_pers_id api_2
623: WHERE api_2.person_id_type = pit_2.person_id_type
624: AND pit_2.s_person_id_type = 'SSN'
625: AND SYSDATE BETWEEN api_2.start_dt AND NVL (api_2.end_dt,SYSDATE)) pit,
626: hz_parties pe
627: WHERE fmast.fund_code = fcat.fund_code
628: AND fmast.ci_cal_type = ci.cal_type
629: AND fmast.ci_sequence_number = ci.sequence_number
630: AND awd.base_id = facon.base_id

Line 4396: l_n_student_id hz_parties.party_id%TYPE;

4392: l_b_ret_status BOOLEAN;
4393: l_c_borrow_created VARCHAR2(1);
4394: l_c_student_created VARCHAR2(1);
4395: l_c_rel_created VARCHAR2(1);
4396: l_n_student_id hz_parties.party_id%TYPE;
4397: l_n_borrower_id hz_parties.party_id%TYPE;
4398: l_v_student_number hz_parties.party_number%TYPE;
4399: l_v_borrower_number hz_parties.party_number%TYPE;
4400: l_n_person_id hz_parties.party_id%TYPE;

Line 4397: l_n_borrower_id hz_parties.party_id%TYPE;

4393: l_c_borrow_created VARCHAR2(1);
4394: l_c_student_created VARCHAR2(1);
4395: l_c_rel_created VARCHAR2(1);
4396: l_n_student_id hz_parties.party_id%TYPE;
4397: l_n_borrower_id hz_parties.party_id%TYPE;
4398: l_v_student_number hz_parties.party_number%TYPE;
4399: l_v_borrower_number hz_parties.party_number%TYPE;
4400: l_n_person_id hz_parties.party_id%TYPE;
4401: l_v_person_number hz_parties.party_number%TYPE;

Line 4398: l_v_student_number hz_parties.party_number%TYPE;

4394: l_c_student_created VARCHAR2(1);
4395: l_c_rel_created VARCHAR2(1);
4396: l_n_student_id hz_parties.party_id%TYPE;
4397: l_n_borrower_id hz_parties.party_id%TYPE;
4398: l_v_student_number hz_parties.party_number%TYPE;
4399: l_v_borrower_number hz_parties.party_number%TYPE;
4400: l_n_person_id hz_parties.party_id%TYPE;
4401: l_v_person_number hz_parties.party_number%TYPE;
4402: BEGIN

Line 4399: l_v_borrower_number hz_parties.party_number%TYPE;

4395: l_c_rel_created VARCHAR2(1);
4396: l_n_student_id hz_parties.party_id%TYPE;
4397: l_n_borrower_id hz_parties.party_id%TYPE;
4398: l_v_student_number hz_parties.party_number%TYPE;
4399: l_v_borrower_number hz_parties.party_number%TYPE;
4400: l_n_person_id hz_parties.party_id%TYPE;
4401: l_v_person_number hz_parties.party_number%TYPE;
4402: BEGIN
4403: log_to_fnd(p_v_module => 'process_borrow_stud_rec',

Line 4400: l_n_person_id hz_parties.party_id%TYPE;

4396: l_n_student_id hz_parties.party_id%TYPE;
4397: l_n_borrower_id hz_parties.party_id%TYPE;
4398: l_v_student_number hz_parties.party_number%TYPE;
4399: l_v_borrower_number hz_parties.party_number%TYPE;
4400: l_n_person_id hz_parties.party_id%TYPE;
4401: l_v_person_number hz_parties.party_number%TYPE;
4402: BEGIN
4403: log_to_fnd(p_v_module => 'process_borrow_stud_rec',
4404: p_v_string => ' p_rec_resp_r1.b_ssn : ' || p_rec_resp_r1.b_ssn ||

Line 4401: l_v_person_number hz_parties.party_number%TYPE;

4397: l_n_borrower_id hz_parties.party_id%TYPE;
4398: l_v_student_number hz_parties.party_number%TYPE;
4399: l_v_borrower_number hz_parties.party_number%TYPE;
4400: l_n_person_id hz_parties.party_id%TYPE;
4401: l_v_person_number hz_parties.party_number%TYPE;
4402: BEGIN
4403: log_to_fnd(p_v_module => 'process_borrow_stud_rec',
4404: p_v_string => ' p_rec_resp_r1.b_ssn : ' || p_rec_resp_r1.b_ssn ||
4405: ' p_rec_resp_r1.b_last_name : ' || p_rec_resp_r1.b_last_name ||

Line 4794: p_n_person_id OUT NOCOPY hz_parties.party_id%TYPE,

4790:
4791:
4792: PROCEDURE perform_ssn_match(p_rec_resp_r1 IN igf_sl_cl_resp_r1_all%ROWTYPE,
4793: p_c_pers_typ_ind IN VARCHAR2,
4794: p_n_person_id OUT NOCOPY hz_parties.party_id%TYPE,
4795: p_n_person_number OUT NOCOPY hz_parties.party_number%TYPE,
4796: p_c_pers_exists OUT NOCOPY BOOLEAN
4797: ) AS
4798: ------------------------------------------------------------------

Line 4795: p_n_person_number OUT NOCOPY hz_parties.party_number%TYPE,

4791:
4792: PROCEDURE perform_ssn_match(p_rec_resp_r1 IN igf_sl_cl_resp_r1_all%ROWTYPE,
4793: p_c_pers_typ_ind IN VARCHAR2,
4794: p_n_person_id OUT NOCOPY hz_parties.party_id%TYPE,
4795: p_n_person_number OUT NOCOPY hz_parties.party_number%TYPE,
4796: p_c_pers_exists OUT NOCOPY BOOLEAN
4797: ) AS
4798: ------------------------------------------------------------------
4799: --Created by : Sanil Madathil, Oracle IDC

Line 4825: ,hz_parties hz

4821: ,hz.person_first_name firstname
4822: ,hz.person_last_name lastname
4823: FROM igs_pe_alt_pers_id api
4824: ,igs_pe_person_id_typ pit
4825: ,hz_parties hz
4826: WHERE api.person_id_type = pit.person_id_type
4827: AND pit.s_person_id_type = 'SSN'
4828: AND hz.party_id = api.pe_person_id
4829: AND (SYSDATE) BETWEEN api.start_dt AND NVL (api.end_dt, SYSDATE)

Line 4841: ,hz_parties hz

4837: ,hz.person_last_name lastname
4838: FROM per_all_people_f ppf
4839: ,per_business_groups_perf pbg
4840: ,per_person_types ppt
4841: ,hz_parties hz
4842: ,hz_person_profiles hp
4843: WHERE igs_en_gen_001.check_hrms_installed = 'Y'
4844: AND pbg.legislation_code = 'US'
4845: AND ppt.system_person_type = 'EMP'

Line 4853: TYPE tab_firstname_typ IS TABLE OF hz_parties.person_first_name%TYPE;

4849: AND ppf.party_id = hz.party_id
4850: AND hp.effective_end_date IS NULL
4851: AND igf_ap_matching_process_pkg.remove_spl_chr(ppf.national_identifier) = cp_v_ssn;
4852:
4853: TYPE tab_firstname_typ IS TABLE OF hz_parties.person_first_name%TYPE;
4854: TYPE tab_lastname_typ IS TABLE OF hz_parties.person_last_name%TYPE;
4855: TYPE tab_prsn_ssn_typ IS TABLE OF igs_pe_alt_pers_id.api_person_id_uf%TYPE;
4856: TYPE tab_personid_typ IS TABLE OF hz_parties.party_id%TYPE;
4857: TYPE tab_personnum_typ IS TABLE OF hz_parties.party_number%TYPE;

Line 4854: TYPE tab_lastname_typ IS TABLE OF hz_parties.person_last_name%TYPE;

4850: AND hp.effective_end_date IS NULL
4851: AND igf_ap_matching_process_pkg.remove_spl_chr(ppf.national_identifier) = cp_v_ssn;
4852:
4853: TYPE tab_firstname_typ IS TABLE OF hz_parties.person_first_name%TYPE;
4854: TYPE tab_lastname_typ IS TABLE OF hz_parties.person_last_name%TYPE;
4855: TYPE tab_prsn_ssn_typ IS TABLE OF igs_pe_alt_pers_id.api_person_id_uf%TYPE;
4856: TYPE tab_personid_typ IS TABLE OF hz_parties.party_id%TYPE;
4857: TYPE tab_personnum_typ IS TABLE OF hz_parties.party_number%TYPE;
4858: TYPE tab_rec_typ IS TABLE OF VARCHAR2(30);

Line 4856: TYPE tab_personid_typ IS TABLE OF hz_parties.party_id%TYPE;

4852:
4853: TYPE tab_firstname_typ IS TABLE OF hz_parties.person_first_name%TYPE;
4854: TYPE tab_lastname_typ IS TABLE OF hz_parties.person_last_name%TYPE;
4855: TYPE tab_prsn_ssn_typ IS TABLE OF igs_pe_alt_pers_id.api_person_id_uf%TYPE;
4856: TYPE tab_personid_typ IS TABLE OF hz_parties.party_id%TYPE;
4857: TYPE tab_personnum_typ IS TABLE OF hz_parties.party_number%TYPE;
4858: TYPE tab_rec_typ IS TABLE OF VARCHAR2(30);
4859:
4860: v_tab_firstname_typ tab_firstname_typ;

Line 4857: TYPE tab_personnum_typ IS TABLE OF hz_parties.party_number%TYPE;

4853: TYPE tab_firstname_typ IS TABLE OF hz_parties.person_first_name%TYPE;
4854: TYPE tab_lastname_typ IS TABLE OF hz_parties.person_last_name%TYPE;
4855: TYPE tab_prsn_ssn_typ IS TABLE OF igs_pe_alt_pers_id.api_person_id_uf%TYPE;
4856: TYPE tab_personid_typ IS TABLE OF hz_parties.party_id%TYPE;
4857: TYPE tab_personnum_typ IS TABLE OF hz_parties.party_number%TYPE;
4858: TYPE tab_rec_typ IS TABLE OF VARCHAR2(30);
4859:
4860: v_tab_firstname_typ tab_firstname_typ;
4861: v_tab_lastname_typ tab_lastname_typ ;

Line 4978: p_n_person_id OUT NOCOPY hz_parties.party_id%TYPE,

4974: END perform_ssn_match;
4975:
4976: FUNCTION create_person_record(p_rec_resp_r1 IN igf_sl_cl_resp_r1_all%ROWTYPE,
4977: p_c_pers_typ_ind IN VARCHAR2,
4978: p_n_person_id OUT NOCOPY hz_parties.party_id%TYPE,
4979: p_n_person_number OUT NOCOPY hz_parties.party_number%TYPE
4980: )
4981: RETURN BOOLEAN AS
4982: ------------------------------------------------------------------

Line 4979: p_n_person_number OUT NOCOPY hz_parties.party_number%TYPE

4975:
4976: FUNCTION create_person_record(p_rec_resp_r1 IN igf_sl_cl_resp_r1_all%ROWTYPE,
4977: p_c_pers_typ_ind IN VARCHAR2,
4978: p_n_person_id OUT NOCOPY hz_parties.party_id%TYPE,
4979: p_n_person_number OUT NOCOPY hz_parties.party_number%TYPE
4980: )
4981: RETURN BOOLEAN AS
4982: ------------------------------------------------------------------
4983: --Created by : Sanil Madathil, Oracle IDC

Line 4990: -- Parameters : p_hz_parties_rec : IN parameter. Required.

4986: -- Purpose:
4987: -- Invoked : from within process_borrow_stud_rec procedure
4988: -- Function : Private function for creating person record
4989: --
4990: -- Parameters : p_hz_parties_rec : IN parameter. Required.
4991: -- p_n_person_id : OUT parameter.
4992: -- p_n_person_number : OUT parameter.
4993: --
4994: --

Line 5010: l_n_person_id hz_parties.party_id%TYPE;

5006: l_n_msg_count NUMBER ;
5007: l_v_msg_data VARCHAR2(1000);
5008: l_v_return_status VARCHAR2(10);
5009: l_v_rowid ROWID;
5010: l_n_person_id hz_parties.party_id%TYPE;
5011: l_v_person_number hz_parties.party_number%TYPE;
5012: l_v_person_id_type igs_pe_person_id_typ.person_id_type%TYPE;
5013: l_n_location_ovn hz_locations.object_version_number%TYPE;
5014: l_rec_resp_r1 igf_sl_cl_resp_r1_all%ROWTYPE;

Line 5011: l_v_person_number hz_parties.party_number%TYPE;

5007: l_v_msg_data VARCHAR2(1000);
5008: l_v_return_status VARCHAR2(10);
5009: l_v_rowid ROWID;
5010: l_n_person_id hz_parties.party_id%TYPE;
5011: l_v_person_number hz_parties.party_number%TYPE;
5012: l_v_person_id_type igs_pe_person_id_typ.person_id_type%TYPE;
5013: l_n_location_ovn hz_locations.object_version_number%TYPE;
5014: l_rec_resp_r1 igf_sl_cl_resp_r1_all%ROWTYPE;
5015: l_v_ssn igf_ap_isir_ints_all.current_ssn_txt%TYPE;

Line 5016: l_v_person_first_name hz_parties.person_first_name%TYPE;

5012: l_v_person_id_type igs_pe_person_id_typ.person_id_type%TYPE;
5013: l_n_location_ovn hz_locations.object_version_number%TYPE;
5014: l_rec_resp_r1 igf_sl_cl_resp_r1_all%ROWTYPE;
5015: l_v_ssn igf_ap_isir_ints_all.current_ssn_txt%TYPE;
5016: l_v_person_first_name hz_parties.person_first_name%TYPE;
5017: l_v_person_last_name hz_parties.person_last_name%TYPE;
5018: l_v_person_middle_name hz_parties.person_middle_name%TYPE;
5019: l_d_date_of_birth igs_pe_person.birth_dt%TYPE;
5020: l_b_ret_status BOOLEAN;

Line 5017: l_v_person_last_name hz_parties.person_last_name%TYPE;

5013: l_n_location_ovn hz_locations.object_version_number%TYPE;
5014: l_rec_resp_r1 igf_sl_cl_resp_r1_all%ROWTYPE;
5015: l_v_ssn igf_ap_isir_ints_all.current_ssn_txt%TYPE;
5016: l_v_person_first_name hz_parties.person_first_name%TYPE;
5017: l_v_person_last_name hz_parties.person_last_name%TYPE;
5018: l_v_person_middle_name hz_parties.person_middle_name%TYPE;
5019: l_d_date_of_birth igs_pe_person.birth_dt%TYPE;
5020: l_b_ret_status BOOLEAN;
5021: BEGIN

Line 5018: l_v_person_middle_name hz_parties.person_middle_name%TYPE;

5014: l_rec_resp_r1 igf_sl_cl_resp_r1_all%ROWTYPE;
5015: l_v_ssn igf_ap_isir_ints_all.current_ssn_txt%TYPE;
5016: l_v_person_first_name hz_parties.person_first_name%TYPE;
5017: l_v_person_last_name hz_parties.person_last_name%TYPE;
5018: l_v_person_middle_name hz_parties.person_middle_name%TYPE;
5019: l_d_date_of_birth igs_pe_person.birth_dt%TYPE;
5020: l_b_ret_status BOOLEAN;
5021: BEGIN
5022:

Line 5117: x_hz_parties_ovn => l_n_location_ovn,

5113: x_email_addr => NULL,
5114: x_level_of_qual_id => NULL,
5115: x_military_service_reg => NULL,
5116: x_veteran => NULL,
5117: x_hz_parties_ovn => l_n_location_ovn,
5118: x_attribute_category => NULL,
5119: x_attribute1 => NULL,
5120: x_attribute2 => NULL,
5121: x_attribute3 => NULL,

Line 5201: FUNCTION create_person_addr_record(p_n_person_id IN hz_parties.party_id%TYPE,

5197:
5198:
5199: END create_person_record;
5200:
5201: FUNCTION create_person_addr_record(p_n_person_id IN hz_parties.party_id%TYPE,
5202: p_v_person_number IN hz_parties.party_number%TYPE,
5203: p_rec_resp_r1 IN igf_sl_cl_resp_r1_all%ROWTYPE
5204: ) RETURN BOOLEAN AS
5205: ------------------------------------------------------------------

Line 5202: p_v_person_number IN hz_parties.party_number%TYPE,

5198:
5199: END create_person_record;
5200:
5201: FUNCTION create_person_addr_record(p_n_person_id IN hz_parties.party_id%TYPE,
5202: p_v_person_number IN hz_parties.party_number%TYPE,
5203: p_rec_resp_r1 IN igf_sl_cl_resp_r1_all%ROWTYPE
5204: ) RETURN BOOLEAN AS
5205: ------------------------------------------------------------------
5206: --Created by : Sanil Madathil, Oracle IDC

Line 5215: -- p_hz_parties_rec : IN parameter. Required.

5211: -- Function : Private function for creating person address
5212: -- records
5213: -- Parameters : p_n_person_id : IN parameter. Required.
5214: -- p_v_person_number : IN parameter. Required.
5215: -- p_hz_parties_rec : IN parameter. Required.
5216: --
5217: --Known limitations/enhancements and/or remarks:
5218: --
5219: --Change History:

Line 5232: l_n_person_id hz_parties.party_id%TYPE;

5228: l_n_party_site_id igs_pe_person_addr.party_site_id%TYPE;
5229: l_n_location_ovn hz_locations.object_version_number%TYPE;
5230: l_n_party_site_ovn igs_pe_person_addr.party_site_ovn%TYPE;
5231: l_d_last_update_date DATE;
5232: l_n_person_id hz_parties.party_id%TYPE;
5233: l_v_person_number hz_parties.party_number%TYPE;
5234: l_v_party_site_use hz_party_site_uses.site_use_type%TYPE;
5235: l_n_party_site_use_id hz_party_site_uses.party_site_use_id%TYPE;
5236: l_d_site_use_last_upd_dt DATE;

Line 5233: l_v_person_number hz_parties.party_number%TYPE;

5229: l_n_location_ovn hz_locations.object_version_number%TYPE;
5230: l_n_party_site_ovn igs_pe_person_addr.party_site_ovn%TYPE;
5231: l_d_last_update_date DATE;
5232: l_n_person_id hz_parties.party_id%TYPE;
5233: l_v_person_number hz_parties.party_number%TYPE;
5234: l_v_party_site_use hz_party_site_uses.site_use_type%TYPE;
5235: l_n_party_site_use_id hz_party_site_uses.party_site_use_id%TYPE;
5236: l_d_site_use_last_upd_dt DATE;
5237: l_d_profile_last_upd_dt DATE;

Line 5240: l_v_permt_city hz_parties.city%TYPE;

5236: l_d_site_use_last_upd_dt DATE;
5237: l_d_profile_last_upd_dt DATE;
5238: l_v_permt_addr1 igs_pe_person_addr.addr_line_1%TYPE;
5239: l_v_permt_addr2 igs_pe_person_addr.addr_line_2%TYPE;
5240: l_v_permt_city hz_parties.city%TYPE;
5241: l_v_permt_state hz_parties.state%TYPE;
5242: l_v_postal_code igs_pe_person_addr.postal_code%TYPE;
5243: l_rec_resp_r1 igf_sl_cl_resp_r1_all%ROWTYPE;
5244: BEGIN

Line 5241: l_v_permt_state hz_parties.state%TYPE;

5237: l_d_profile_last_upd_dt DATE;
5238: l_v_permt_addr1 igs_pe_person_addr.addr_line_1%TYPE;
5239: l_v_permt_addr2 igs_pe_person_addr.addr_line_2%TYPE;
5240: l_v_permt_city hz_parties.city%TYPE;
5241: l_v_permt_state hz_parties.state%TYPE;
5242: l_v_postal_code igs_pe_person_addr.postal_code%TYPE;
5243: l_rec_resp_r1 igf_sl_cl_resp_r1_all%ROWTYPE;
5244: BEGIN
5245: log_to_fnd(p_v_module => 'create_person_addr_record',

Line 5396: FUNCTION create_person_telephone_record (p_n_person_id IN hz_parties.party_id%TYPE,

5392: );
5393: RETURN TRUE;
5394: END create_person_addr_record;
5395:
5396: FUNCTION create_person_telephone_record (p_n_person_id IN hz_parties.party_id%TYPE,
5397: p_rec_resp_r1 IN igf_sl_cl_resp_r1_all%ROWTYPE
5398: ) RETURN BOOLEAN AS
5399: ------------------------------------------------------------------
5400: --Created by : bvisvana, Oracle IDC

Line 5454: p_owner_table_name => 'HZ_PARTIES',

5450: igs_pe_contact_point_pkg.hz_contact_points_akp(
5451: p_action => 'INSERT',
5452: p_rowid => l_rowid,
5453: p_status => 'A',
5454: p_owner_table_name => 'HZ_PARTIES',
5455: p_owner_table_id => p_n_person_id,
5456: p_primary_flag => 'N',
5457: p_phone_country_code => NULL,
5458: p_phone_area_code => l_area_code,

Line 5503: FUNCTION create_borrow_stud_rel ( p_n_borrower_id IN hz_parties.party_id%TYPE,

5499: END IF;
5500: END create_person_telephone_record;
5501:
5502:
5503: FUNCTION create_borrow_stud_rel ( p_n_borrower_id IN hz_parties.party_id%TYPE,
5504: p_v_borrower_number IN hz_parties.party_number%TYPE,
5505: p_n_student_id IN hz_parties.party_id%TYPE,
5506: p_v_student_number IN hz_parties.party_number%TYPE
5507: ) RETURN BOOLEAN AS

Line 5504: p_v_borrower_number IN hz_parties.party_number%TYPE,

5500: END create_person_telephone_record;
5501:
5502:
5503: FUNCTION create_borrow_stud_rel ( p_n_borrower_id IN hz_parties.party_id%TYPE,
5504: p_v_borrower_number IN hz_parties.party_number%TYPE,
5505: p_n_student_id IN hz_parties.party_id%TYPE,
5506: p_v_student_number IN hz_parties.party_number%TYPE
5507: ) RETURN BOOLEAN AS
5508: ------------------------------------------------------------------

Line 5505: p_n_student_id IN hz_parties.party_id%TYPE,

5501:
5502:
5503: FUNCTION create_borrow_stud_rel ( p_n_borrower_id IN hz_parties.party_id%TYPE,
5504: p_v_borrower_number IN hz_parties.party_number%TYPE,
5505: p_n_student_id IN hz_parties.party_id%TYPE,
5506: p_v_student_number IN hz_parties.party_number%TYPE
5507: ) RETURN BOOLEAN AS
5508: ------------------------------------------------------------------
5509: --Created by : Sanil Madathil, Oracle IDC

Line 5506: p_v_student_number IN hz_parties.party_number%TYPE

5502:
5503: FUNCTION create_borrow_stud_rel ( p_n_borrower_id IN hz_parties.party_id%TYPE,
5504: p_v_borrower_number IN hz_parties.party_number%TYPE,
5505: p_n_student_id IN hz_parties.party_id%TYPE,
5506: p_v_student_number IN hz_parties.party_number%TYPE
5507: ) RETURN BOOLEAN AS
5508: ------------------------------------------------------------------
5509: --Created by : Sanil Madathil, Oracle IDC
5510: --Date created: 21 October 2004

Line 5545: l_n_party_id hz_parties.party_id%TYPE;

5541: l_v_return_status VARCHAR2(10);
5542: l_d_last_update_date DATE;
5543: l_n_location_ovn hz_locations.object_version_number%TYPE;
5544: l_n_relationship_id hz_relationships.relationship_id%TYPE;
5545: l_n_party_id hz_parties.party_id%TYPE;
5546: l_v_party_number hz_parties.party_number%TYPE;
5547:
5548:
5549: BEGIN

Line 5546: l_v_party_number hz_parties.party_number%TYPE;

5542: l_d_last_update_date DATE;
5543: l_n_location_ovn hz_locations.object_version_number%TYPE;
5544: l_n_relationship_id hz_relationships.relationship_id%TYPE;
5545: l_n_party_id hz_parties.party_id%TYPE;
5546: l_v_party_number hz_parties.party_number%TYPE;
5547:
5548:
5549: BEGIN
5550: log_to_fnd(p_v_module => 'create_borrow_stud_rel',

Line 6365: p_v_person_number IN hz_parties.party_number%TYPE,

6361:
6362: PROCEDURE raise_gamt_event ( p_v_ci_alternate_code IN igs_ca_inst_all.alternate_code%TYPE,
6363: p_d_ci_start_dt IN igs_ca_inst_all.start_dt%TYPE,
6364: p_d_ci_end_dt IN igs_ca_inst_all.end_dt%TYPE,
6365: p_v_person_number IN hz_parties.party_number%TYPE,
6366: p_v_person_name IN hz_parties.party_name%TYPE,
6367: p_v_ssn IN igf_ap_isir_ints_all.current_ssn_txt%TYPE,
6368: p_v_loan_number IN igf_sl_loans_all.loan_number%TYPE,
6369: p_d_loan_per_begin_date IN igf_sl_loans_all.loan_per_begin_date%TYPE,

Line 6366: p_v_person_name IN hz_parties.party_name%TYPE,

6362: PROCEDURE raise_gamt_event ( p_v_ci_alternate_code IN igs_ca_inst_all.alternate_code%TYPE,
6363: p_d_ci_start_dt IN igs_ca_inst_all.start_dt%TYPE,
6364: p_d_ci_end_dt IN igs_ca_inst_all.end_dt%TYPE,
6365: p_v_person_number IN hz_parties.party_number%TYPE,
6366: p_v_person_name IN hz_parties.party_name%TYPE,
6367: p_v_ssn IN igf_ap_isir_ints_all.current_ssn_txt%TYPE,
6368: p_v_loan_number IN igf_sl_loans_all.loan_number%TYPE,
6369: p_d_loan_per_begin_date IN igf_sl_loans_all.loan_per_begin_date%TYPE,
6370: p_d_loan_per_end_date IN igf_sl_loans_all.loan_per_end_date%TYPE,