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

Line 82: p_person_id OUT NOCOPY igs_pe_person.person_id%type,

78:
79: PROCEDURE derive_level_data
80: (
81: p_lgcy_adstlvl_rec IN lgcy_adstlvl_rec_type,
82: p_person_id OUT NOCOPY igs_pe_person.person_id%type,
83: p_s_adv_stnd_unit_level OUT NOCOPY igs_av_stnd_unit_lvl.s_adv_stnd_type%type,
84: p_cal_type OUT NOCOPY igs_ca_inst.cal_type%type,
85: p_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%type,
86: p_auth_pers_id OUT NOCOPY igs_pe_person.person_id%type,

Line 86: p_auth_pers_id OUT NOCOPY igs_pe_person.person_id%type,

82: p_person_id OUT NOCOPY igs_pe_person.person_id%type,
83: p_s_adv_stnd_unit_level OUT NOCOPY igs_av_stnd_unit_lvl.s_adv_stnd_type%type,
84: p_cal_type OUT NOCOPY igs_ca_inst.cal_type%type,
85: p_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%type,
86: p_auth_pers_id OUT NOCOPY igs_pe_person.person_id%type,
87: p_unit_details_id OUT NOCOPY igs_ad_term_unitdtls.unit_details_id%type,
88: p_tst_rslt_dtls_id OUT NOCOPY igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,
89: p_qual_dets_id OUT NOCOPY igs_uc_qual_dets.qual_dets_id%type,
90: p_as_version_number OUT NOCOPY igs_en_stdnt_ps_att.version_number%type

Line 98: p_person_id IN igs_pe_person.person_id%type,

94: validate_adv_std_db_cons function performs all the data integrity validation
95: */
96: FUNCTION validate_adv_std_db_cons
97: (
98: p_person_id IN igs_pe_person.person_id%type,
99: p_version_number IN igs_ps_ver_all.version_number%type,
100: p_lgcy_adstlvl_rec IN lgcy_adstlvl_rec_type
101: )
102: RETURN BOOLEAN;

Line 110: p_person_id IN igs_pe_person.person_id%type,

106: inserting a record in the table IGS_AV_ADV_STANDING_ALL
107: */
108: FUNCTION validate_adv_stnd
109: (
110: p_person_id IN igs_pe_person.person_id%type,
111: p_version_number IN igs_ps_ver.version_number%type,
112: p_lgcy_adstlvl_rec IN lgcy_adstlvl_rec_type
113: )
114: RETURN BOOLEAN;

Line 122: p_person_id IN igs_pe_person.person_id%type,

118: before entering into the table IGS_AV_STND_UNIT_LVL_ALL
119: */
120: FUNCTION validate_lvl_db_cons
121: (
122: p_person_id IN igs_pe_person.person_id%type,
123: p_s_adv_stnd_unit_level IN igs_ps_unit_level.unit_level%type,
124: p_cal_type IN igs_ca_inst.cal_type%type,
125: p_seq_number IN igs_ca_inst.sequence_number%type,
126: p_auth_pers_id IN igs_pe_person.person_id%type,

Line 126: p_auth_pers_id IN igs_pe_person.person_id%type,

122: p_person_id IN igs_pe_person.person_id%type,
123: p_s_adv_stnd_unit_level IN igs_ps_unit_level.unit_level%type,
124: p_cal_type IN igs_ca_inst.cal_type%type,
125: p_seq_number IN igs_ca_inst.sequence_number%type,
126: p_auth_pers_id IN igs_pe_person.person_id%type,
127: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%type,
128: p_tst_rslt_dtls_id IN igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,
129: p_qual_dets_id IN igs_uc_qual_dets.qual_dets_id%type,
130: p_course_version IN igs_ps_ver.version_number%type,

Line 142: p_person_id IN igs_pe_person.person_id%type,

138: inserting a record into the table IGS_AV_STND_UNIT_LVL_ALL
139: */
140: FUNCTION validate_level
141: (
142: p_person_id IN igs_pe_person.person_id%type,
143: p_unit_level IN igs_ps_unit_level.unit_level%type,
144: p_cal_type IN igs_ca_inst.cal_type%type,
145: p_seq_number IN igs_ca_inst.sequence_number%type,
146: p_auth_pers_id IN igs_pe_person.person_id%type,

Line 146: p_auth_pers_id IN igs_pe_person.person_id%type,

142: p_person_id IN igs_pe_person.person_id%type,
143: p_unit_level IN igs_ps_unit_level.unit_level%type,
144: p_cal_type IN igs_ca_inst.cal_type%type,
145: p_seq_number IN igs_ca_inst.sequence_number%type,
146: p_auth_pers_id IN igs_pe_person.person_id%type,
147: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%type,
148: p_tst_rslt_dtls_id IN igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,
149: p_qual_dets_id IN igs_uc_qual_dets.qual_dets_id%type,
150: p_course_version IN igs_ps_ver.version_number%type,

Line 161: p_person_id IN igs_pe_person.person_id%type,

157: validations on the table IGS_AV_STND_UNIT_LVL_ALL
158: */
159: FUNCTION create_post_lvl
160: (
161: p_person_id IN igs_pe_person.person_id%type,
162: p_course_version IN igs_ps_ver.version_number%type,
163: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%type,
164: p_tst_rslt_dtls_id IN igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,
165: p_lgcy_adstlvl_rec IN lgcy_adstlvl_rec_type

Line 175: p_person_id IN igs_pe_person.person_id%type,

171: before inserting into the table IGS_AV_STD_ULVLBASIS_ALL
172: */
173: FUNCTION validate_lvl_bas_db_cons
174: (
175: p_person_id IN igs_pe_person.person_id%type,
176: p_av_stnd_unit_lvl_id IN igs_av_std_ulvlbasis_all.av_stnd_unit_lvl_id%type,
177: p_lgcy_adstlvl_rec IN lgcy_adstlvl_rec_type
178: )
179: RETURN VARCHAR2;

Line 247: l_person_id igs_pe_person.person_id%type;

243: l_api_name CONSTANT VARCHAR2(30) := 'create_adv_stnd_level';
244: l_api_version CONSTANT NUMBER := 1.0;
245:
246: -- variables declared to fetch data from derive_level_data
247: l_person_id igs_pe_person.person_id%type;
248: l_s_adv_stnd_unit_level igs_av_stnd_unit_lvl.s_adv_stnd_type%type;
249: l_cal_type igs_ca_inst.cal_type%type;
250: l_sequence_number igs_ca_inst.sequence_number%type;
251: l_auth_pers_id igs_pe_person.person_id%type;

Line 251: l_auth_pers_id igs_pe_person.person_id%type;

247: l_person_id igs_pe_person.person_id%type;
248: l_s_adv_stnd_unit_level igs_av_stnd_unit_lvl.s_adv_stnd_type%type;
249: l_cal_type igs_ca_inst.cal_type%type;
250: l_sequence_number igs_ca_inst.sequence_number%type;
251: l_auth_pers_id igs_pe_person.person_id%type;
252: l_unit_details_id igs_ad_term_unitdtls.unit_details_id%type;
253: l_tst_rslt_dtls_id igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type;
254: l_qual_dets_id igs_uc_qual_dets.qual_dets_id%type;
255: l_as_version_number igs_en_stdnt_ps_att.version_number%type;

Line 883: p_person_id OUT NOCOPY igs_pe_person.person_id%type,

879:
880: PROCEDURE derive_level_data
881: (
882: p_lgcy_adstlvl_rec IN lgcy_adstlvl_rec_type,
883: p_person_id OUT NOCOPY igs_pe_person.person_id%type,
884: p_s_adv_stnd_unit_level OUT NOCOPY igs_av_stnd_unit_lvl.s_adv_stnd_type%type,
885: p_cal_type OUT NOCOPY igs_ca_inst.cal_type%type,
886: p_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%type,
887: p_auth_pers_id OUT NOCOPY igs_pe_person.person_id%type,

Line 887: p_auth_pers_id OUT NOCOPY igs_pe_person.person_id%type,

883: p_person_id OUT NOCOPY igs_pe_person.person_id%type,
884: p_s_adv_stnd_unit_level OUT NOCOPY igs_av_stnd_unit_lvl.s_adv_stnd_type%type,
885: p_cal_type OUT NOCOPY igs_ca_inst.cal_type%type,
886: p_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%type,
887: p_auth_pers_id OUT NOCOPY igs_pe_person.person_id%type,
888: p_unit_details_id OUT NOCOPY igs_ad_term_unitdtls.unit_details_id%type,
889: p_tst_rslt_dtls_id OUT NOCOPY igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,
890: p_qual_dets_id OUT NOCOPY igs_uc_qual_dets.qual_dets_id%type,
891: p_as_version_number OUT NOCOPY igs_en_stdnt_ps_att.version_number%type

Line 1014: cp_person_id igs_pe_person.person_id%TYPE,

1010: CURSOR c_unit_details_id (cp_unit igs_ad_term_unitdtls.unit%TYPE,
1011: cp_prev_term igs_av_lgcy_lvl_int.prev_term%TYPE,
1012: cp_start_date igs_av_lgcy_lvl_int.start_date%TYPE,
1013: cp_end_date igs_av_lgcy_lvl_int.end_date%TYPE,
1014: cp_person_id igs_pe_person.person_id%TYPE,
1015: cp_inst_cd igs_av_acad_history_v.institution_code%TYPE) IS
1016: SELECT ahv.unit_details_id
1017: FROM igs_av_acad_history_v ahv,
1018: igs_ad_term_details td

Line 1119: p_person_id IN igs_pe_person.person_id%type,

1115: END derive_level_data;
1116:
1117: FUNCTION validate_adv_std_db_cons
1118: (
1119: p_person_id IN igs_pe_person.person_id%type,
1120: p_version_number IN igs_ps_ver_all.version_number%type,
1121: p_lgcy_adstlvl_rec IN lgcy_adstlvl_rec_type
1122: )
1123: RETURN BOOLEAN

Line 1152: p_person_id IN igs_pe_person.person_id%type,

1148: END validate_adv_std_db_cons;
1149:
1150: FUNCTION validate_adv_stnd
1151: (
1152: p_person_id IN igs_pe_person.person_id%type,
1153: p_version_number IN igs_ps_ver.version_number%type,
1154: p_lgcy_adstlvl_rec IN lgcy_adstlvl_rec_type
1155: )
1156: RETURN BOOLEAN

Line 1326: p_person_id IN igs_pe_person.person_id%type,

1322:
1323:
1324: FUNCTION validate_lvl_db_cons
1325: (
1326: p_person_id IN igs_pe_person.person_id%type,
1327: p_s_adv_stnd_unit_level IN igs_ps_unit_level.unit_level%type,
1328: p_cal_type IN igs_ca_inst.cal_type%type,
1329: p_seq_number IN igs_ca_inst.sequence_number%type,
1330: p_auth_pers_id IN igs_pe_person.person_id%type,

Line 1330: p_auth_pers_id IN igs_pe_person.person_id%type,

1326: p_person_id IN igs_pe_person.person_id%type,
1327: p_s_adv_stnd_unit_level IN igs_ps_unit_level.unit_level%type,
1328: p_cal_type IN igs_ca_inst.cal_type%type,
1329: p_seq_number IN igs_ca_inst.sequence_number%type,
1330: p_auth_pers_id IN igs_pe_person.person_id%type,
1331: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%type,
1332: p_tst_rslt_dtls_id IN igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,
1333: p_qual_dets_id IN igs_uc_qual_dets.qual_dets_id%type,
1334: p_course_version IN igs_ps_ver.version_number%type,

Line 1389: Foreign Key with AUTHORIZING_PERSON_ID exists in table IGS_PE_PERSON

1385: FND_MSG_PUB.ADD;
1386: x_return_status := FALSE;
1387: END IF;
1388: /*
1389: Foreign Key with AUTHORIZING_PERSON_ID exists in table IGS_PE_PERSON
1390: */
1391: IF p_auth_pers_id IS NULL THEN
1392: FND_MESSAGE.SET_NAME('IGS','IGS_AV_INVALID_PERS_AUTH_NUM');
1393: FND_MSG_PUB.ADD;

Line 1529: p_person_id IN igs_pe_person.person_id%type,

1525:
1526:
1527: FUNCTION validate_level
1528: (
1529: p_person_id IN igs_pe_person.person_id%type,
1530: p_unit_level IN igs_ps_unit_level.unit_level%type,
1531: p_cal_type IN igs_ca_inst.cal_type%type,
1532: p_seq_number IN igs_ca_inst.sequence_number%type,
1533: p_auth_pers_id IN igs_pe_person.person_id%type,

Line 1533: p_auth_pers_id IN igs_pe_person.person_id%type,

1529: p_person_id IN igs_pe_person.person_id%type,
1530: p_unit_level IN igs_ps_unit_level.unit_level%type,
1531: p_cal_type IN igs_ca_inst.cal_type%type,
1532: p_seq_number IN igs_ca_inst.sequence_number%type,
1533: p_auth_pers_id IN igs_pe_person.person_id%type,
1534: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%type,
1535: p_tst_rslt_dtls_id IN igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,
1536: p_qual_dets_id IN igs_uc_qual_dets.qual_dets_id%type,
1537: p_course_version IN igs_ps_ver.version_number%type,

Line 1701: p_person_id IN igs_pe_person.person_id%type,

1697:
1698:
1699: FUNCTION create_post_lvl
1700: (
1701: p_person_id IN igs_pe_person.person_id%type,
1702: p_course_version IN igs_ps_ver.version_number%type,
1703: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%type,
1704: p_tst_rslt_dtls_id IN igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,
1705: p_lgcy_adstlvl_rec IN lgcy_adstlvl_rec_type

Line 1777: p_person_id IN igs_pe_person.person_id%type,

1773:
1774:
1775: FUNCTION validate_lvl_bas_db_cons
1776: (
1777: p_person_id IN igs_pe_person.person_id%type,
1778: p_av_stnd_unit_lvl_id IN igs_av_std_ulvlbasis_all.av_stnd_unit_lvl_id%type,
1779: p_lgcy_adstlvl_rec IN lgcy_adstlvl_rec_type
1780: )
1781: RETURN VARCHAR2