APPS.IGS_PE_GEN_003 dependencies on IGS_PE_RES_DTLS

Line 16: p_old_record IN igs_pe_res_dtls_all%ROWTYPE,

12: || Added procedure raise_person_type_event and resp_assignment to handle person type responsibility enhancements
13: */
14: PROCEDURE process_res_dtls(
15: p_action IN VARCHAR2 , -- I/U I-INSERT U-UPDATE,
16: p_old_record IN igs_pe_res_dtls_all%ROWTYPE,
17: p_new_record IN igs_pe_res_dtls_all%ROWTYPE
18: ) AS
19: l_label VARCHAR2(100);
20: l_debug_str VARCHAR2(2000);

Line 17: p_new_record IN igs_pe_res_dtls_all%ROWTYPE

13: */
14: PROCEDURE process_res_dtls(
15: p_action IN VARCHAR2 , -- I/U I-INSERT U-UPDATE,
16: p_old_record IN igs_pe_res_dtls_all%ROWTYPE,
17: p_new_record IN igs_pe_res_dtls_all%ROWTYPE
18: ) AS
19: l_label VARCHAR2(100);
20: l_debug_str VARCHAR2(2000);
21: l_residency_class igs_pe_res_dtls.residency_class_cd%TYPE;

Line 21: l_residency_class igs_pe_res_dtls.residency_class_cd%TYPE;

17: p_new_record IN igs_pe_res_dtls_all%ROWTYPE
18: ) AS
19: l_label VARCHAR2(100);
20: l_debug_str VARCHAR2(2000);
21: l_residency_class igs_pe_res_dtls.residency_class_cd%TYPE;
22: BEGIN
23: fnd_profile.get('IGS_FI_RES_CLASS_ID',l_residency_class);
24: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
25: fnd_log.string(fnd_log.level_statement,'igs.plsql.igs_pe_gen_003.process_res_dtls.debug','l_residency_class:'||l_residency_class);