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_AV_LGCY_UNT_INT

Line 45: p_program_code IN igs_av_lgcy_unt_int.program_cd%TYPE,

41:
42: PROCEDURE notify_error (
43: p_batch_id IN igs_da_rqst.batch_id%TYPE,
44: p_person_id IN hz_parties.party_id%TYPE,
45: p_program_code IN igs_av_lgcy_unt_int.program_cd%TYPE,
46: p_msg IN VARCHAR2
47: )
48: IS
49:

Line 1010: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,

1006:
1007: FUNCTION process_term_unit_details (
1008: p_batch_id IN igs_da_req_stdnts.batch_id%TYPE,
1009: p_person_id IN hz_parties.party_id%TYPE,
1010: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,
1011: p_trans_cur_rec IN OUT NOCOPY trans_cur_rec
1012: )
1013: RETURN igs_ad_term_unitdtls.unit_details_id%TYPE
1014: AS

Line 1283: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,

1279:
1280: PROCEDURE process_term_details (
1281: p_batch_id IN igs_da_req_stdnts.batch_id%TYPE,
1282: p_person_id IN hz_parties.party_id%TYPE,
1283: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,
1284: p_trans_cur_rec IN OUT NOCOPY trans_cur_rec
1285: )
1286: AS
1287: CURSOR c_dup_cur

Line 1340: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,

1336: END process_term_details;
1337:
1338: PROCEDURE create_acad_hist_rec (
1339: p_batch_id IN igs_da_req_stdnts.batch_id%TYPE,
1340: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,
1341: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
1342: p_person_id_code_type IN igs_pe_alt_pers_id.api_person_id%TYPE,
1343: p_term_type IN VARCHAR2,
1344: p_term IN igs_ad_term_details.term%TYPE,

Line 1659: p_person_number IN igs_av_lgcy_unt_int.person_number%TYPE,

1655:
1656: FUNCTION validate_parameters (
1657: p_batch_id IN igs_da_rqst.batch_id%TYPE,
1658: p_person_id IN igs_da_rqst.person_id%TYPE,
1659: p_person_number IN igs_av_lgcy_unt_int.person_number%TYPE,
1660: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,
1661: p_unit_cd IN igs_av_lgcy_unt_int.unit_cd%TYPE, --- advstnd unit
1662: p_version_number IN igs_av_lgcy_unt_int.version_number%TYPE
1663: )

Line 1660: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,

1656: FUNCTION validate_parameters (
1657: p_batch_id IN igs_da_rqst.batch_id%TYPE,
1658: p_person_id IN igs_da_rqst.person_id%TYPE,
1659: p_person_number IN igs_av_lgcy_unt_int.person_number%TYPE,
1660: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,
1661: p_unit_cd IN igs_av_lgcy_unt_int.unit_cd%TYPE, --- advstnd unit
1662: p_version_number IN igs_av_lgcy_unt_int.version_number%TYPE
1663: )
1664: RETURN BOOLEAN

Line 1661: p_unit_cd IN igs_av_lgcy_unt_int.unit_cd%TYPE, --- advstnd unit

1657: p_batch_id IN igs_da_rqst.batch_id%TYPE,
1658: p_person_id IN igs_da_rqst.person_id%TYPE,
1659: p_person_number IN igs_av_lgcy_unt_int.person_number%TYPE,
1660: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,
1661: p_unit_cd IN igs_av_lgcy_unt_int.unit_cd%TYPE, --- advstnd unit
1662: p_version_number IN igs_av_lgcy_unt_int.version_number%TYPE
1663: )
1664: RETURN BOOLEAN
1665: IS

Line 1662: p_version_number IN igs_av_lgcy_unt_int.version_number%TYPE

1658: p_person_id IN igs_da_rqst.person_id%TYPE,
1659: p_person_number IN igs_av_lgcy_unt_int.person_number%TYPE,
1660: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,
1661: p_unit_cd IN igs_av_lgcy_unt_int.unit_cd%TYPE, --- advstnd unit
1662: p_version_number IN igs_av_lgcy_unt_int.version_number%TYPE
1663: )
1664: RETURN BOOLEAN
1665: IS
1666: /*===========================================================================+

Line 1749: p_person_number IN igs_av_lgcy_unt_int.person_number%TYPE,

1745: END validate_parameters;
1746:
1747: FUNCTION derive_unit_data (
1748: p_batch_id IN igs_da_rqst.batch_id%TYPE,
1749: p_person_number IN igs_av_lgcy_unt_int.person_number%TYPE,
1750: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,
1751: p_unit_cd IN igs_av_lgcy_unt_int.unit_cd%TYPE, --- advstnd unit
1752: p_version_number IN igs_av_lgcy_unt_int.version_number%TYPE,
1753: p_institution_cd IN igs_av_lgcy_unt_int.institution_cd%TYPE,

Line 1750: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,

1746:
1747: FUNCTION derive_unit_data (
1748: p_batch_id IN igs_da_rqst.batch_id%TYPE,
1749: p_person_number IN igs_av_lgcy_unt_int.person_number%TYPE,
1750: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,
1751: p_unit_cd IN igs_av_lgcy_unt_int.unit_cd%TYPE, --- advstnd unit
1752: p_version_number IN igs_av_lgcy_unt_int.version_number%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,

Line 1751: p_unit_cd IN igs_av_lgcy_unt_int.unit_cd%TYPE, --- advstnd unit

1747: FUNCTION derive_unit_data (
1748: p_batch_id IN igs_da_rqst.batch_id%TYPE,
1749: p_person_number IN igs_av_lgcy_unt_int.person_number%TYPE,
1750: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,
1751: p_unit_cd IN igs_av_lgcy_unt_int.unit_cd%TYPE, --- advstnd unit
1752: p_version_number IN igs_av_lgcy_unt_int.version_number%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,

Line 1752: p_version_number IN igs_av_lgcy_unt_int.version_number%TYPE,

1748: p_batch_id IN igs_da_rqst.batch_id%TYPE,
1749: p_person_number IN igs_av_lgcy_unt_int.person_number%TYPE,
1750: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,
1751: p_unit_cd IN igs_av_lgcy_unt_int.unit_cd%TYPE, --- advstnd unit
1752: p_version_number IN igs_av_lgcy_unt_int.version_number%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,

Line 1753: p_institution_cd IN igs_av_lgcy_unt_int.institution_cd%TYPE,

1749: p_person_number IN igs_av_lgcy_unt_int.person_number%TYPE,
1750: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,
1751: p_unit_cd IN igs_av_lgcy_unt_int.unit_cd%TYPE, --- advstnd unit
1752: p_version_number IN igs_av_lgcy_unt_int.version_number%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,

Line 1754: p_load_cal_alt_code IN igs_av_lgcy_unt_int.load_cal_alt_code%TYPE,

1750: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,
1751: p_unit_cd IN igs_av_lgcy_unt_int.unit_cd%TYPE, --- advstnd unit
1752: p_version_number IN igs_av_lgcy_unt_int.version_number%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,

Line 1755: p_avstnd_grade IN igs_av_lgcy_unt_int.grade%TYPE,

1751: p_unit_cd IN igs_av_lgcy_unt_int.unit_cd%TYPE, --- advstnd unit
1752: p_version_number IN igs_av_lgcy_unt_int.version_number%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,

Line 1756: p_achievable_credit_points IN OUT NOCOPY igs_av_lgcy_unt_int.achievable_credit_points%TYPE,

1752: p_version_number IN igs_av_lgcy_unt_int.version_number%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,

Line 1779: cp_unit_cd igs_av_lgcy_unt_int.unit_cd%TYPE,

1775: +===========================================================================*/
1776: l_n_rec_count NUMBER := 0;
1777:
1778: CURSOR c_credit_points (
1779: cp_unit_cd igs_av_lgcy_unt_int.unit_cd%TYPE,
1780: cp_version_number igs_av_lgcy_unt_int.version_number%TYPE
1781: )
1782: IS
1783: SELECT NVL (achievable_credit_points,

Line 1780: cp_version_number igs_av_lgcy_unt_int.version_number%TYPE

1776: l_n_rec_count NUMBER := 0;
1777:
1778: CURSOR c_credit_points (
1779: cp_unit_cd igs_av_lgcy_unt_int.unit_cd%TYPE,
1780: cp_version_number igs_av_lgcy_unt_int.version_number%TYPE
1781: )
1782: IS
1783: SELECT NVL (achievable_credit_points,
1784: enrolled_credit_points

Line 1890: p_person_number IN igs_av_lgcy_unt_int.person_number%TYPE,

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,
1894: p_load_cal_alt_code IN igs_av_lgcy_unt_int.load_cal_alt_code%TYPE,

Line 1891: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,

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,
1894: p_load_cal_alt_code IN igs_av_lgcy_unt_int.load_cal_alt_code%TYPE,
1895: p_achievable_credit_points IN igs_av_lgcy_unt_int.achievable_credit_points%TYPE

Line 1892: p_unit_cd IN igs_av_lgcy_unt_int.unit_cd%TYPE, --- advstnd unit

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,
1894: p_load_cal_alt_code IN igs_av_lgcy_unt_int.load_cal_alt_code%TYPE,
1895: p_achievable_credit_points IN igs_av_lgcy_unt_int.achievable_credit_points%TYPE
1896: )

Line 1893: p_version_number IN igs_av_lgcy_unt_int.version_number%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,
1894: p_load_cal_alt_code IN igs_av_lgcy_unt_int.load_cal_alt_code%TYPE,
1895: p_achievable_credit_points IN igs_av_lgcy_unt_int.achievable_credit_points%TYPE
1896: )
1897: RETURN BOOLEAN

Line 1894: p_load_cal_alt_code IN igs_av_lgcy_unt_int.load_cal_alt_code%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,
1894: p_load_cal_alt_code IN igs_av_lgcy_unt_int.load_cal_alt_code%TYPE,
1895: p_achievable_credit_points IN igs_av_lgcy_unt_int.achievable_credit_points%TYPE
1896: )
1897: RETURN BOOLEAN
1898: IS

Line 1895: p_achievable_credit_points IN igs_av_lgcy_unt_int.achievable_credit_points%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,
1894: p_load_cal_alt_code IN igs_av_lgcy_unt_int.load_cal_alt_code%TYPE,
1895: p_achievable_credit_points IN igs_av_lgcy_unt_int.achievable_credit_points%TYPE
1896: )
1897: RETURN BOOLEAN
1898: IS
1899: /*===========================================================================+

Line 1949: p_person_number IN igs_av_lgcy_unt_int.person_number%TYPE,

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,
1953: p_prev_institution_code IN igs_ad_acad_history_v.institution_code%TYPE

Line 1950: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,

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,
1953: p_prev_institution_code IN igs_ad_acad_history_v.institution_code%TYPE
1954: )

Line 1951: p_unit_cd IN igs_av_lgcy_unt_int.unit_cd%TYPE, --- advstnd unit

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,
1953: p_prev_institution_code IN igs_ad_acad_history_v.institution_code%TYPE
1954: )
1955: RETURN BOOLEAN

Line 1952: p_version_number IN igs_av_lgcy_unt_int.version_number%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,
1953: p_prev_institution_code IN igs_ad_acad_history_v.institution_code%TYPE
1954: )
1955: RETURN BOOLEAN
1956: IS

Line 2182: p_person_number IN igs_av_lgcy_unt_int.person_number%TYPE,

2178: END validate_adv_stnd;
2179:
2180: FUNCTION validate_std_unt_db_cons (
2181: p_batch_id IN igs_da_rqst.batch_id%TYPE,
2182: p_person_number IN igs_av_lgcy_unt_int.person_number%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,

Line 2183: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,

2179:
2180: FUNCTION validate_std_unt_db_cons (
2181: p_batch_id IN igs_da_rqst.batch_id%TYPE,
2182: p_person_number IN igs_av_lgcy_unt_int.person_number%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,

Line 2184: p_unit_cd IN igs_av_lgcy_unt_int.unit_cd%TYPE, --- advstnd unit

2180: FUNCTION validate_std_unt_db_cons (
2181: p_batch_id IN igs_da_rqst.batch_id%TYPE,
2182: p_person_number IN igs_av_lgcy_unt_int.person_number%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,

Line 2185: p_version_number IN igs_av_lgcy_unt_int.version_number%TYPE,

2181: p_batch_id IN igs_da_rqst.batch_id%TYPE,
2182: p_person_number IN igs_av_lgcy_unt_int.person_number%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,

Line 2186: p_institution_cd IN igs_av_lgcy_unt_int.institution_cd%TYPE,

2182: p_person_number IN igs_av_lgcy_unt_int.person_number%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,

Line 2316: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,

2312:
2313: END validate_std_unt_db_cons;
2314:
2315: FUNCTION validate_unit (
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,

Line 2317: p_unit_cd IN igs_av_lgcy_unt_int.unit_cd%TYPE, --- advstnd unit

2313: END validate_std_unt_db_cons;
2314:
2315: FUNCTION validate_unit (
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,

Line 2318: p_version_number IN igs_av_lgcy_unt_int.version_number%TYPE,

2314:
2315: FUNCTION validate_unit (
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,

Line 2319: p_achievable_credit_points IN igs_av_lgcy_unt_int.achievable_credit_points%TYPE,

2315: FUNCTION validate_unit (
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,

Line 2506: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,

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
2508: p_version_number IN igs_av_lgcy_unt_int.version_number%TYPE,
2509: p_batch_id igs_da_rqst.batch_id%TYPE,
2510: p_prev_institution_code IN igs_ad_acad_history_v.institution_code%TYPE

Line 2507: p_unit_cd IN igs_av_lgcy_unt_int.unit_cd%TYPE, --- advstnd 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
2508: p_version_number IN igs_av_lgcy_unt_int.version_number%TYPE,
2509: p_batch_id igs_da_rqst.batch_id%TYPE,
2510: p_prev_institution_code IN igs_ad_acad_history_v.institution_code%TYPE
2511: )

Line 2508: p_version_number IN igs_av_lgcy_unt_int.version_number%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
2508: p_version_number IN igs_av_lgcy_unt_int.version_number%TYPE,
2509: p_batch_id igs_da_rqst.batch_id%TYPE,
2510: p_prev_institution_code IN igs_ad_acad_history_v.institution_code%TYPE
2511: )
2512: RETURN BOOLEAN

Line 2617: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,

2613: p_batch_id IN igs_da_rqst.batch_id%TYPE,
2614: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%TYPE,
2615: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
2616: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
2617: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,
2618: p_load_cal_alt_code IN igs_av_lgcy_unt_int.load_cal_alt_code%TYPE,
2619: p_avstnd_grade IN igs_av_lgcy_unt_int.grade%TYPE,
2620: p_achievable_credit_points IN igs_av_lgcy_unt_int.achievable_credit_points%TYPE,
2621: p_target_course_subject IN VARCHAR2,

Line 2618: p_load_cal_alt_code IN igs_av_lgcy_unt_int.load_cal_alt_code%TYPE,

2614: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%TYPE,
2615: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
2616: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
2617: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,
2618: p_load_cal_alt_code IN igs_av_lgcy_unt_int.load_cal_alt_code%TYPE,
2619: p_avstnd_grade IN igs_av_lgcy_unt_int.grade%TYPE,
2620: p_achievable_credit_points IN igs_av_lgcy_unt_int.achievable_credit_points%TYPE,
2621: p_target_course_subject IN VARCHAR2,
2622: p_target_course_num IN VARCHAR2,

Line 2619: p_avstnd_grade IN igs_av_lgcy_unt_int.grade%TYPE,

2615: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
2616: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
2617: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,
2618: p_load_cal_alt_code IN igs_av_lgcy_unt_int.load_cal_alt_code%TYPE,
2619: p_avstnd_grade IN igs_av_lgcy_unt_int.grade%TYPE,
2620: p_achievable_credit_points IN igs_av_lgcy_unt_int.achievable_credit_points%TYPE,
2621: p_target_course_subject IN VARCHAR2,
2622: p_target_course_num IN VARCHAR2,
2623: p_inst_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,

Line 2620: p_achievable_credit_points IN igs_av_lgcy_unt_int.achievable_credit_points%TYPE,

2616: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
2617: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,
2618: p_load_cal_alt_code IN igs_av_lgcy_unt_int.load_cal_alt_code%TYPE,
2619: p_avstnd_grade IN igs_av_lgcy_unt_int.grade%TYPE,
2620: p_achievable_credit_points IN igs_av_lgcy_unt_int.achievable_credit_points%TYPE,
2621: p_target_course_subject IN VARCHAR2,
2622: p_target_course_num IN VARCHAR2,
2623: p_inst_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
2624: p_inst_id_code_type IN igs_pe_alt_pers_id.api_person_id%TYPE

Line 2655: l_unit_cd igs_av_lgcy_unt_int.unit_cd%TYPE; --- advstnd unit

2651: l_program_update_date igs_av_stnd_unit_all.program_update_date%TYPE;
2652: duplicate_record_exists EXCEPTION;
2653: l_granted_dt igs_av_stnd_unit_all.granted_dt%TYPE
2654: := NULL;
2655: l_unit_cd igs_av_lgcy_unt_int.unit_cd%TYPE; --- advstnd unit
2656: l_version_number igs_av_lgcy_unt_int.version_number%TYPE;
2657: l_person_number igs_av_lgcy_unt_int.person_number%TYPE;
2658: l_return_status VARCHAR2 (30);
2659: l_msg_count NUMBER;

Line 2656: l_version_number igs_av_lgcy_unt_int.version_number%TYPE;

2652: duplicate_record_exists EXCEPTION;
2653: l_granted_dt igs_av_stnd_unit_all.granted_dt%TYPE
2654: := NULL;
2655: l_unit_cd igs_av_lgcy_unt_int.unit_cd%TYPE; --- advstnd unit
2656: l_version_number igs_av_lgcy_unt_int.version_number%TYPE;
2657: l_person_number igs_av_lgcy_unt_int.person_number%TYPE;
2658: l_return_status VARCHAR2 (30);
2659: l_msg_count NUMBER;
2660: l_msg_data VARCHAR2 (200);

Line 2657: l_person_number igs_av_lgcy_unt_int.person_number%TYPE;

2653: l_granted_dt igs_av_stnd_unit_all.granted_dt%TYPE
2654: := NULL;
2655: l_unit_cd igs_av_lgcy_unt_int.unit_cd%TYPE; --- advstnd unit
2656: l_version_number igs_av_lgcy_unt_int.version_number%TYPE;
2657: l_person_number igs_av_lgcy_unt_int.person_number%TYPE;
2658: l_return_status VARCHAR2 (30);
2659: l_msg_count NUMBER;
2660: l_msg_data VARCHAR2 (200);
2661: l_prev_institution_code igs_ad_acad_history_v.institution_code%TYPE;

Line 2662: l_achievable_credit_points igs_av_lgcy_unt_int.achievable_credit_points%TYPE;

2658: l_return_status VARCHAR2 (30);
2659: l_msg_count NUMBER;
2660: l_msg_data VARCHAR2 (200);
2661: l_prev_institution_code igs_ad_acad_history_v.institution_code%TYPE;
2662: l_achievable_credit_points igs_av_lgcy_unt_int.achievable_credit_points%TYPE;
2663: l_institution_cd igs_av_lgcy_unt_int.institution_cd%TYPE;
2664: l_dmmy_rowid ROWID;
2665:
2666: CURSOR c_unit_ver

Line 2663: l_institution_cd igs_av_lgcy_unt_int.institution_cd%TYPE;

2659: l_msg_count NUMBER;
2660: l_msg_data VARCHAR2 (200);
2661: l_prev_institution_code igs_ad_acad_history_v.institution_code%TYPE;
2662: l_achievable_credit_points igs_av_lgcy_unt_int.achievable_credit_points%TYPE;
2663: l_institution_cd igs_av_lgcy_unt_int.institution_cd%TYPE;
2664: l_dmmy_rowid ROWID;
2665:
2666: CURSOR c_unit_ver
2667: IS

Line 3307: p_program_code IN igs_av_lgcy_unt_int.program_cd%TYPE,

3303: PROCEDURE create_or_get_batch_id (
3304: p_batch_id IN igs_da_rqst.batch_id%TYPE,
3305: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
3306: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
3307: p_program_code IN igs_av_lgcy_unt_int.program_cd%TYPE,
3308: transaction_sub_type IN VARCHAR2,
3309: p_out_batch_id OUT NOCOPY igs_da_rqst.batch_id%TYPE
3310: )
3311: IS