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_DA_TRNS_IMP dependencies on IGS_PE_PERSON

Line 1757: p_person_id IN OUT NOCOPY igs_pe_person.person_id%TYPE,

1753: p_institution_cd IN igs_av_lgcy_unt_int.institution_cd%TYPE,
1754: p_load_cal_alt_code IN igs_av_lgcy_unt_int.load_cal_alt_code%TYPE,
1755: p_avstnd_grade IN igs_av_lgcy_unt_int.grade%TYPE,
1756: p_achievable_credit_points IN OUT NOCOPY igs_av_lgcy_unt_int.achievable_credit_points%TYPE,
1757: p_person_id IN OUT NOCOPY igs_pe_person.person_id%TYPE,
1758: p_s_adv_stnd_type IN OUT NOCOPY igs_av_stnd_unit_all.s_adv_stnd_type%TYPE,
1759: p_cal_type IN OUT NOCOPY igs_ca_inst.cal_type%TYPE,
1760: p_seq_number IN OUT NOCOPY igs_ca_inst.sequence_number%TYPE,
1761: p_auth_pers_id IN OUT NOCOPY igs_pe_person.person_id%TYPE,

Line 1761: p_auth_pers_id IN OUT NOCOPY igs_pe_person.person_id%TYPE,

1757: p_person_id IN OUT NOCOPY igs_pe_person.person_id%TYPE,
1758: p_s_adv_stnd_type IN OUT NOCOPY igs_av_stnd_unit_all.s_adv_stnd_type%TYPE,
1759: p_cal_type IN OUT NOCOPY igs_ca_inst.cal_type%TYPE,
1760: p_seq_number IN OUT NOCOPY igs_ca_inst.sequence_number%TYPE,
1761: p_auth_pers_id IN OUT NOCOPY igs_pe_person.person_id%TYPE,
1762: p_as_version_number IN OUT NOCOPY igs_en_stdnt_ps_att.version_number%TYPE
1763: )
1764: RETURN BOOLEAN
1765: IS

Line 1889: p_person_id IN igs_pe_person.person_id%TYPE,

1885: END derive_unit_data;
1886:
1887: FUNCTION validate_adv_std_db_cons (
1888: p_batch_id IN igs_da_rqst.batch_id%TYPE,
1889: p_person_id IN igs_pe_person.person_id%TYPE,
1890: p_person_number IN igs_av_lgcy_unt_int.person_number%TYPE,
1891: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,
1892: p_unit_cd IN igs_av_lgcy_unt_int.unit_cd%TYPE, --- advstnd unit
1893: p_version_number IN igs_av_lgcy_unt_int.version_number%TYPE,

Line 1948: p_person_id IN igs_pe_person.person_id%TYPE,

1944: END validate_adv_std_db_cons;
1945:
1946: FUNCTION validate_adv_stnd (
1947: p_batch_id IN igs_da_rqst.batch_id%TYPE,
1948: p_person_id IN igs_pe_person.person_id%TYPE,
1949: p_person_number IN igs_av_lgcy_unt_int.person_number%TYPE,
1950: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,
1951: p_unit_cd IN igs_av_lgcy_unt_int.unit_cd%TYPE, --- advstnd unit
1952: p_version_number IN igs_av_lgcy_unt_int.version_number%TYPE,

Line 2187: p_person_id IN igs_pe_person.person_id%TYPE,

2183: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,
2184: p_unit_cd IN igs_av_lgcy_unt_int.unit_cd%TYPE, --- advstnd unit
2185: p_version_number IN igs_av_lgcy_unt_int.version_number%TYPE,
2186: p_institution_cd IN igs_av_lgcy_unt_int.institution_cd%TYPE,
2187: p_person_id IN igs_pe_person.person_id%TYPE,
2188: p_auth_pers_id IN igs_pe_person.person_id%TYPE,
2189: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%TYPE,
2190: p_as_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,
2191: p_prev_institution_code IN igs_ad_acad_history_v.institution_code%TYPE

Line 2188: p_auth_pers_id IN igs_pe_person.person_id%TYPE,

2184: p_unit_cd IN igs_av_lgcy_unt_int.unit_cd%TYPE, --- advstnd unit
2185: p_version_number IN igs_av_lgcy_unt_int.version_number%TYPE,
2186: p_institution_cd IN igs_av_lgcy_unt_int.institution_cd%TYPE,
2187: p_person_id IN igs_pe_person.person_id%TYPE,
2188: p_auth_pers_id IN igs_pe_person.person_id%TYPE,
2189: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%TYPE,
2190: p_as_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,
2191: p_prev_institution_code IN igs_ad_acad_history_v.institution_code%TYPE
2192: )

Line 2243: -- Foreign Key with AUTHORIZING_PERSON_ID exists in table IGS_PE_PERSON

2239: END IF;
2240:
2241: write_message ('p_auth_pers_id=' || p_auth_pers_id);
2242:
2243: -- Foreign Key with AUTHORIZING_PERSON_ID exists in table IGS_PE_PERSON
2244: IF p_auth_pers_id IS NULL
2245: THEN
2246: fnd_message.set_name ('IGS', 'IGS_AV_INVALID_PERS_AUTH_NUM');
2247: fnd_msg_pub.ADD;

Line 2320: p_person_id IN igs_pe_person.person_id%TYPE,

2316: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,
2317: p_unit_cd IN igs_av_lgcy_unt_int.unit_cd%TYPE, --- advstnd unit
2318: p_version_number IN igs_av_lgcy_unt_int.version_number%TYPE,
2319: p_achievable_credit_points IN igs_av_lgcy_unt_int.achievable_credit_points%TYPE,
2320: p_person_id IN igs_pe_person.person_id%TYPE,
2321: p_auth_pers_id IN igs_pe_person.person_id%TYPE,
2322: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%TYPE,
2323: p_as_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,
2324: p_batch_id IN igs_da_rqst.batch_id%TYPE,

Line 2321: p_auth_pers_id IN igs_pe_person.person_id%TYPE,

2317: p_unit_cd IN igs_av_lgcy_unt_int.unit_cd%TYPE, --- advstnd unit
2318: p_version_number IN igs_av_lgcy_unt_int.version_number%TYPE,
2319: p_achievable_credit_points IN igs_av_lgcy_unt_int.achievable_credit_points%TYPE,
2320: p_person_id IN igs_pe_person.person_id%TYPE,
2321: p_auth_pers_id IN igs_pe_person.person_id%TYPE,
2322: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%TYPE,
2323: p_as_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,
2324: p_batch_id IN igs_da_rqst.batch_id%TYPE,
2325: p_prev_institution_code IN igs_ad_acad_history_v.institution_code%TYPE

Line 2503: p_person_id IN igs_pe_person.person_id%TYPE,

2499:
2500: END validate_unit;
2501:
2502: FUNCTION create_post_unit (
2503: p_person_id IN igs_pe_person.person_id%TYPE,
2504: p_course_version IN igs_ps_ver.version_number%TYPE,
2505: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%TYPE,
2506: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,
2507: p_unit_cd IN igs_av_lgcy_unt_int.unit_cd%TYPE, --- advstnd unit

Line 2641: l_person_id igs_pe_person.person_id%TYPE;

2637: l_api_name CONSTANT VARCHAR2 (30) := 'create_adv_stnd_unit';
2638: l_api_version CONSTANT NUMBER := 1.0;
2639: l_ret_status BOOLEAN;
2640: l_b_av_stnd_alt_unit_pk_exist BOOLEAN := TRUE;
2641: l_person_id igs_pe_person.person_id%TYPE;
2642: l_s_adv_stnd_type igs_av_stnd_unit_all.s_adv_stnd_type%TYPE;
2643: l_cal_type igs_ca_inst.cal_type%TYPE;
2644: l_seq_number igs_ca_inst.sequence_number%TYPE;
2645: l_auth_pers_id igs_pe_person.person_id%TYPE;

Line 2645: l_auth_pers_id igs_pe_person.person_id%TYPE;

2641: l_person_id igs_pe_person.person_id%TYPE;
2642: l_s_adv_stnd_type igs_av_stnd_unit_all.s_adv_stnd_type%TYPE;
2643: l_cal_type igs_ca_inst.cal_type%TYPE;
2644: l_seq_number igs_ca_inst.sequence_number%TYPE;
2645: l_auth_pers_id igs_pe_person.person_id%TYPE;
2646: l_as_version_number igs_en_stdnt_ps_att.version_number%TYPE;
2647: l_av_stnd_unit_lvl_id igs_av_stnd_unit_all.av_stnd_unit_id%TYPE;
2648: l_request_id igs_av_stnd_unit_all.request_id%TYPE;
2649: l_program_id igs_av_stnd_unit_all.program_id%TYPE;