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_AD_VAL_ACAI_FTR_OFFER dependencies on IGS_AD_PS_APPL

Line 27: p_new_sequence_number IGS_AD_PS_APPL_INST_ALL.sequence_number%TYPE,

23: and in the call to insert row of igs_ad_appl_eval_pkg
24: *******************************************************************************/
25:
26: FUNCTION copy_candidacy_records(p_new_admission_appl_number IGS_AD_APPL_ALL.admission_appl_number%TYPE,
27: p_new_sequence_number IGS_AD_PS_APPL_INST_ALL.sequence_number%TYPE,
28: p_person_id HZ_PARTIES.party_id%TYPE,
29: p_old_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,
30: p_old_sequence_number IGS_AD_PS_APPL_INST_ALL.sequence_number%TYPE,
31: p_nominated_course_cd IGS_AD_PS_APPL_ALL.nominated_course_cd%TYPE,

Line 30: p_old_sequence_number IGS_AD_PS_APPL_INST_ALL.sequence_number%TYPE,

26: FUNCTION copy_candidacy_records(p_new_admission_appl_number IGS_AD_APPL_ALL.admission_appl_number%TYPE,
27: p_new_sequence_number IGS_AD_PS_APPL_INST_ALL.sequence_number%TYPE,
28: p_person_id HZ_PARTIES.party_id%TYPE,
29: p_old_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,
30: p_old_sequence_number IGS_AD_PS_APPL_INST_ALL.sequence_number%TYPE,
31: p_nominated_course_cd IGS_AD_PS_APPL_ALL.nominated_course_cd%TYPE,
32: p_start_dt DATE)
33: RETURN BOOLEAN AS
34:

Line 31: p_nominated_course_cd IGS_AD_PS_APPL_ALL.nominated_course_cd%TYPE,

27: p_new_sequence_number IGS_AD_PS_APPL_INST_ALL.sequence_number%TYPE,
28: p_person_id HZ_PARTIES.party_id%TYPE,
29: p_old_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,
30: p_old_sequence_number IGS_AD_PS_APPL_INST_ALL.sequence_number%TYPE,
31: p_nominated_course_cd IGS_AD_PS_APPL_ALL.nominated_course_cd%TYPE,
32: p_start_dt DATE)
33: RETURN BOOLEAN AS
34:
35: /*******************************************************************************

Line 446: p_nominated_course_cd igs_ad_ps_appl.nominated_course_cd%TYPE,

442: errbuf out NOCOPY varchar2,
443: retcode out NOCOPY number ,
444: p_person_id hz_parties.party_id%TYPE,
445: p_group_id igs_pe_persid_group.group_id%TYPE,
446: p_nominated_course_cd igs_ad_ps_appl.nominated_course_cd%TYPE,
447: p_prev_acad_adm_cal VARCHAR2,
448: p_future_acad_adm_cal VARCHAR2,
449: p_offer_dt VARCHAR2,
450: p_offer_response_dt VARCHAR2,

Line 483: l_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE;

479: p_fut_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE;
480: p_fut_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;
481: p_fut_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE;
482:
483: l_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE;
484: l_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE;
485:
486: l_message_name VARCHAR2(1000);
487: l_new_admission_appl_number igs_ad_appl.admission_appl_number%TYPE;

Line 484: l_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE;

480: p_fut_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;
481: p_fut_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE;
482:
483: l_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE;
484: l_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE;
485:
486: l_message_name VARCHAR2(1000);
487: l_new_admission_appl_number igs_ad_appl.admission_appl_number%TYPE;
488: l_new_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE;

Line 488: l_new_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE;

484: l_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE;
485:
486: l_message_name VARCHAR2(1000);
487: l_new_admission_appl_number igs_ad_appl.admission_appl_number%TYPE;
488: l_new_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE;
489:
490: l_person_number hz_parties.party_number%TYPE;
491: l_group_desc igs_pe_persid_group.description%TYPE;
492:

Line 539: igs_ad_ps_appl_inst acai, /* Replaced igs_ad_ps_appl_inst_aplinst_v with igs_ad_ps_appl_inst Bug 3150054 */

535: SELECT
536: acai.*
537: FROM
538: igs_ad_appl aa,
539: igs_ad_ps_appl_inst acai, /* Replaced igs_ad_ps_appl_inst_aplinst_v with igs_ad_ps_appl_inst Bug 3150054 */
540: igs_ad_ou_stat aous
541: WHERE
542: acai.adm_outcome_status = aous.adm_outcome_status
543: AND aous.s_adm_outcome_status = 'OFFER-FUTURE-TERM'

Line 940: p_nominated_course_cd igs_ad_ps_appl.nominated_course_cd%TYPE,

936:
937: FUNCTION handle_application(
938: p_person_id hz_parties.party_id%TYPE,
939: p_admission_appl_number igs_ad_appl.admission_appl_number%TYPE,
940: p_nominated_course_cd igs_ad_ps_appl.nominated_course_cd%TYPE,
941: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
942: p_fut_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
943: p_fut_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
944: p_fut_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,

Line 941: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,

937: FUNCTION handle_application(
938: p_person_id hz_parties.party_id%TYPE,
939: p_admission_appl_number igs_ad_appl.admission_appl_number%TYPE,
940: p_nominated_course_cd igs_ad_ps_appl.nominated_course_cd%TYPE,
941: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
942: p_fut_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
943: p_fut_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
944: p_fut_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
945: p_fut_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,

Line 947: p_new_sequence_number OUT NOCOPY igs_ad_ps_appl_inst.sequence_number%TYPE

943: p_fut_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
944: p_fut_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
945: p_fut_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
946: p_new_admission_appl_number OUT NOCOPY igs_ad_appl.admission_appl_number%TYPE,
947: p_new_sequence_number OUT NOCOPY igs_ad_ps_appl_inst.sequence_number%TYPE
948: ) RETURN BOOLEAN IS
949: /*******************************************************************************
950: Created by : Ramesh Rengarajan
951: Date created: 20 FEB 2002

Line 982: igs_ad_ps_appl_inst acai, /* Replaced igs_ad_ps_appl_inst_aplinst_v with igs_ad_ps_appl_inst Bug 3150054 */

978: aca.req_for_adv_standing_ind,
979: NVL(acai.adm_cal_type,aa.adm_cal_type) final_adm_cal_type,
980: NVL(acai.adm_ci_sequence_number,aa.adm_ci_sequence_number) final_adm_ci_sequence_number
981: FROM
982: igs_ad_ps_appl_inst acai, /* Replaced igs_ad_ps_appl_inst_aplinst_v with igs_ad_ps_appl_inst Bug 3150054 */
983: igs_ad_appl aa,
984: igs_ad_ps_appl aca
985: WHERE
986: acai.admission_appl_number = p_admission_appl_number

Line 984: igs_ad_ps_appl aca

980: NVL(acai.adm_ci_sequence_number,aa.adm_ci_sequence_number) final_adm_ci_sequence_number
981: FROM
982: igs_ad_ps_appl_inst acai, /* Replaced igs_ad_ps_appl_inst_aplinst_v with igs_ad_ps_appl_inst Bug 3150054 */
983: igs_ad_appl aa,
984: igs_ad_ps_appl aca
985: WHERE
986: acai.admission_appl_number = p_admission_appl_number
987: AND acai.sequence_number = p_sequence_number
988: AND acai.nominated_course_cd = p_nominated_course_cd

Line 1013: l_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE;

1009:
1010: -------------------Variable Declarations------------------------------------------------------
1011: l_message_name VARCHAR2(1000);
1012: l_adm_fee_status igs_ad_appl.adm_fee_status%TYPE;
1013: l_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE;
1014: l_return_type VARCHAR2(100);
1015: l_error_code VARCHAR2(100);
1016: l_adm_appl_status igs_ad_appl.adm_appl_status%TYPE;
1017: l_admission_appl_number igs_ad_appl.admission_appl_number%TYPE;

Line 1188: p_new_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,

1184: RETURN FALSE;
1185: END handle_application;
1186:
1187: FUNCTION copy_child_records(p_new_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,
1188: p_new_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
1189: p_person_id HZ_PARTIES.party_id%TYPE,
1190: p_old_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,
1191: p_old_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
1192: p_nominated_course_cd IGS_AD_PS_APPL.nominated_course_cd%TYPE,

Line 1191: p_old_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,

1187: FUNCTION copy_child_records(p_new_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,
1188: p_new_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
1189: p_person_id HZ_PARTIES.party_id%TYPE,
1190: p_old_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,
1191: p_old_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
1192: p_nominated_course_cd IGS_AD_PS_APPL.nominated_course_cd%TYPE,
1193: p_start_dt DATE,
1194: p_process VARCHAR2)
1195: RETURN BOOLEAN IS

Line 1192: p_nominated_course_cd IGS_AD_PS_APPL.nominated_course_cd%TYPE,

1188: p_new_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
1189: p_person_id HZ_PARTIES.party_id%TYPE,
1190: p_old_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,
1191: p_old_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
1192: p_nominated_course_cd IGS_AD_PS_APPL.nominated_course_cd%TYPE,
1193: p_start_dt DATE,
1194: p_process VARCHAR2)
1195: RETURN BOOLEAN IS
1196: /*******************************************************************************

Line 1218: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,

1214: *******************************************************************************/
1215: -------------------------Cursor Declarations-------------------------------------------------------------------
1216: -- Unitsets
1217: CURSOR c_unitsets_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
1218: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
1219: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
1220: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE )
1221: IS
1222: SELECT

Line 1219: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,

1215: -------------------------Cursor Declarations-------------------------------------------------------------------
1216: -- Unitsets
1217: CURSOR c_unitsets_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
1218: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
1219: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
1220: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE )
1221: IS
1222: SELECT
1223: unit_set_id,

Line 1220: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE )

1216: -- Unitsets
1217: CURSOR c_unitsets_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
1218: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
1219: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
1220: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE )
1221: IS
1222: SELECT
1223: unit_set_id,
1224: person_id ,

Line 1242: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE)

1238:
1239: -- other institutitons
1240:
1241: CURSOR c_othinst_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
1242: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE)
1243: IS
1244: SELECT
1245: other_inst_id,
1246: person_id ,

Line 1261: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,

1257:
1258:
1259: -- education goals
1260: CURSOR c_edugoal_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
1261: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
1262: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
1263: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE )
1264: IS
1265: SELECT

Line 1262: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,

1258:
1259: -- education goals
1260: CURSOR c_edugoal_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
1261: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
1262: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
1263: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE )
1264: IS
1265: SELECT
1266: post_edugoal_id ,

Line 1263: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE )

1259: -- education goals
1260: CURSOR c_edugoal_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
1261: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
1262: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
1263: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE )
1264: IS
1265: SELECT
1266: post_edugoal_id ,
1267: person_id ,

Line 1290: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE)

1286:
1287:
1288: -- personal statements
1289: CURSOR c_perstat_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
1290: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE)
1291: IS
1292: SELECT
1293: appl_perstat_id,
1294: person_id ,

Line 1307: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE)

1303:
1304:
1305: -- academic interests
1306: CURSOR c_acadint_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
1307: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE)
1308: IS
1309: SELECT
1310: acad_interest_id ,
1311: person_id ,

Line 1322: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE)

1318: admission_appl_number = cp_admission_appl_number;
1319:
1320: --applicant intent
1321: CURSOR c_appint_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
1322: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE)
1323: IS
1324: SELECT
1325: app_intent_id,
1326: person_id ,

Line 1359: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE)

1355:
1356:
1357: -- Special Interests
1358: CURSOR c_splint_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
1359: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE)
1360: IS
1361: SELECT
1362: spl_interest_id ,
1363: person_id ,

Line 1374: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE)

1370: admission_appl_number = cp_admission_appl_number;
1371:
1372: --spl talents
1373: CURSOR c_spltal_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
1374: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE)
1375: IS
1376: SELECT
1377: spl_talent_id ,
1378: person_id ,

Line 1389: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,

1385: admission_appl_number = cp_admission_appl_number;
1386:
1387: -- special consideration
1388: CURSOR c_splcns_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
1389: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
1390: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
1391: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE )
1392: IS
1393: SELECT

Line 1390: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,

1386:
1387: -- special consideration
1388: CURSOR c_splcns_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
1389: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
1390: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
1391: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE )
1392: IS
1393: SELECT
1394: spl_adm_cat_id ,

Line 1391: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE )

1387: -- special consideration
1388: CURSOR c_splcns_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
1389: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
1390: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
1391: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE )
1392: IS
1393: SELECT
1394: spl_adm_cat_id ,
1395: person_id ,

Line 1410: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE

1406: admission_appl_number = cp_admission_appl_number;
1407:
1408: -- Fees
1409: CURSOR c_fee_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
1410: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE
1411: )IS
1412: SELECT
1413: app_req_id ,
1414: person_id ,

Line 1444: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,

1440: admission_appl_number = cp_admission_appl_number;
1441:
1442: -- Trackings
1443: CURSOR c_tracking_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
1444: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
1445: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
1446: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE )
1447: IS
1448: SELECT

Line 1445: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,

1441:
1442: -- Trackings
1443: CURSOR c_tracking_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
1444: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
1445: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
1446: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE )
1447: IS
1448: SELECT
1449: aplins_admreq_id ,

Line 1446: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE )

1442: -- Trackings
1443: CURSOR c_tracking_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
1444: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
1445: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
1446: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE )
1447: IS
1448: SELECT
1449: aplins_admreq_id ,
1450: person_id ,

Line 1465: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,

1461: admission_appl_number = cp_admission_appl_number;
1462:
1463: -- program approval
1464: CURSOR c_pgmapp_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
1465: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
1466: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
1467: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE )
1468: IS
1469: SELECT

Line 1466: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,

1462:
1463: -- program approval
1464: CURSOR c_pgmapp_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
1465: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
1466: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
1467: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE )
1468: IS
1469: SELECT
1470: appl_pgmapprv_id ,

Line 1467: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE )

1463: -- program approval
1464: CURSOR c_pgmapp_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
1465: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
1466: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
1467: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE )
1468: IS
1469: SELECT
1470: appl_pgmapprv_id ,
1471: person_id ,

Line 1491: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,

1487: admission_appl_number = cp_admission_appl_number;
1488:
1489: -- Test Scores
1490: CURSOR c_test_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
1491: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
1492: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
1493: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE )
1494: IS
1495: SELECT

Line 1492: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,

1488:
1489: -- Test Scores
1490: CURSOR c_test_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
1491: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
1492: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
1493: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE )
1494: IS
1495: SELECT
1496: tstscr_used_id ,

Line 1493: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE )

1489: -- Test Scores
1490: CURSOR c_test_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
1491: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
1492: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
1493: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE )
1494: IS
1495: SELECT
1496: tstscr_used_id ,
1497: comments ,

Line 1534: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,

1530:
1531:
1532: -- notes
1533: CURSOR c_notes_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
1534: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
1535: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
1536: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE )
1537: IS
1538: SELECT

Line 1535: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,

1531:
1532: -- notes
1533: CURSOR c_notes_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
1534: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
1535: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
1536: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE )
1537: IS
1538: SELECT
1539: appl_notes_id ,

Line 1536: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE )

1532: -- notes
1533: CURSOR c_notes_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
1534: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
1535: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
1536: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE )
1537: IS
1538: SELECT
1539: appl_notes_id ,
1540: person_id ,

Line 1555: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,

1551: sequence_number = cp_sequence_number and
1552: admission_appl_number = cp_admission_appl_number;
1553:
1554: CURSOR c_evaluators_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
1555: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
1556: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
1557: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE )
1558:
1559: IS

Line 1556: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,

1552: admission_appl_number = cp_admission_appl_number;
1553:
1554: CURSOR c_evaluators_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
1555: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
1556: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
1557: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE )
1558:
1559: IS
1560: SELECT

Line 1557: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE )

1553:
1554: CURSOR c_evaluators_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
1555: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
1556: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
1557: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE )
1558:
1559: IS
1560: SELECT
1561: appl_eval_id,

Line 1586: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,

1582: admission_appl_number = cp_admission_appl_number;
1583:
1584:
1585: CURSOR c_applrep_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
1586: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
1587: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
1588: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE )
1589:
1590: IS

Line 1587: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,

1583:
1584:
1585: CURSOR c_applrep_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
1586: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
1587: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
1588: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE )
1589:
1590: IS
1591: SELECT

Line 1588: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE )

1584:
1585: CURSOR c_applrep_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
1586: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
1587: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
1588: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE )
1589:
1590: IS
1591: SELECT
1592: appl_arp_id ,

Line 1624: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,

1620: AND ccl.CLASS_TYPE_CODE='ADM_CODE_CLASSES';
1621:
1622:
1623: CURSOR c_appl_qual_code(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
1624: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
1625: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
1626: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE ) IS
1627: SELECT QUALIFYING_TYPE_CODE,QUALIFYING_CODE_ID,QUALIFYING_VALUE ,PERSON_ID,NOMINATED_COURSE_CD
1628: FROM igs_ad_appqual_code

Line 1625: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,

1621:
1622:
1623: CURSOR c_appl_qual_code(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
1624: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
1625: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
1626: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE ) IS
1627: SELECT QUALIFYING_TYPE_CODE,QUALIFYING_CODE_ID,QUALIFYING_VALUE ,PERSON_ID,NOMINATED_COURSE_CD
1628: FROM igs_ad_appqual_code
1629: WHERE person_id = cp_person_id

Line 1626: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE ) IS

1622:
1623: CURSOR c_appl_qual_code(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
1624: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
1625: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
1626: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE ) IS
1627: SELECT QUALIFYING_TYPE_CODE,QUALIFYING_CODE_ID,QUALIFYING_VALUE ,PERSON_ID,NOMINATED_COURSE_CD
1628: FROM igs_ad_appqual_code
1629: WHERE person_id = cp_person_id
1630: AND nominated_course_cd = cp_nominated_course_cd

Line 2050: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,

2046: RETURN FALSE;
2047: END copy_child_records;
2048:
2049: FUNCTION validate_offer_validations(p_person_id HZ_PARTIES.PARTY_ID%TYPE,
2050: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
2051: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
2052: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
2053: p_old_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
2054: p_old_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,

Line 2051: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,

2047: END copy_child_records;
2048:
2049: FUNCTION validate_offer_validations(p_person_id HZ_PARTIES.PARTY_ID%TYPE,
2050: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
2051: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
2052: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
2053: p_old_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
2054: p_old_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
2055: p_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE,

Line 2052: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,

2048:
2049: FUNCTION validate_offer_validations(p_person_id HZ_PARTIES.PARTY_ID%TYPE,
2050: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
2051: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
2052: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
2053: p_old_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
2054: p_old_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
2055: p_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE,
2056: p_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE,

Line 2053: p_old_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,

2049: FUNCTION validate_offer_validations(p_person_id HZ_PARTIES.PARTY_ID%TYPE,
2050: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
2051: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
2052: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
2053: p_old_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
2054: p_old_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
2055: p_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE,
2056: p_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE,
2057: p_fut_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,

Line 2054: p_old_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,

2050: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
2051: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
2052: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
2053: p_old_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
2054: p_old_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
2055: p_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE,
2056: p_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE,
2057: p_fut_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
2058: p_fut_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,

Line 2055: p_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE,

2051: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
2052: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
2053: p_old_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
2054: p_old_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
2055: p_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE,
2056: p_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE,
2057: p_fut_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
2058: p_fut_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
2059: p_fut_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,

Line 2056: p_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE,

2052: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
2053: p_old_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
2054: p_old_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
2055: p_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE,
2056: p_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE,
2057: p_fut_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
2058: p_fut_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
2059: p_fut_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
2060: p_fut_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,

Line 2082: igs_ad_ps_appl_inst apai

2078: CURSOR c_appl_inst_old_cur IS
2079: SELECT
2080: apai.*
2081: FROM
2082: igs_ad_ps_appl_inst apai
2083: WHERE
2084: apai.person_id = p_person_id
2085: AND apai.admission_appl_number = p_old_admission_appl_number
2086: AND apai.nominated_course_cd = p_nominated_course_cd

Line 2099: igs_ad_ps_appl_inst acai /* Replaced igs_ad_ps_appl_inst_aplinst_v with igs_ad_ps_appl_inst Bug 3150054 */

2095: NVL(acai.adm_cal_type,aa.adm_cal_type) final_adm_cal_type,
2096: NVL(acai.adm_ci_sequence_number,aa.adm_ci_sequence_number) final_adm_ci_sequence_number
2097: FROM
2098: igs_ad_appl aa,
2099: igs_ad_ps_appl_inst acai /* Replaced igs_ad_ps_appl_inst_aplinst_v with igs_ad_ps_appl_inst Bug 3150054 */
2100: WHERE
2101: acai.person_id = p_person_id AND
2102: acai.nominated_course_cd = p_nominated_course_cd AND
2103: acai.sequence_number = p_sequence_number AND

Line 2138: igs_ad_ps_appl_inst apai

2134: CURSOR c_upd_acai_cur IS
2135: SELECT
2136: ROWID, APAI.*
2137: FROM
2138: igs_ad_ps_appl_inst apai
2139: WHERE
2140: apai.person_id = p_person_id
2141: AND apai.admission_appl_number = p_admission_appl_number
2142: AND apai.nominated_course_cd = p_nominated_course_cd

Line 2148: l_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE;

2144: -- End Cursor Declarations ----------------------------------------------------------------------------
2145:
2146: -- Variable Declarations -------------------------------------------------------------------------------
2147:
2148: l_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE;
2149: v_pref_allowed_ind VARCHAR2 (1);
2150: v_pref_limit NUMBER;
2151: v_cond_offer_doc_allowed_ind VARCHAR2 (1);
2152: v_cond_offer_fee_allowed_ind VARCHAR2 (1);

Line 2340: Igs_Ad_Ps_Appl_Inst_Pkg.UPDATE_ROW (

2336:
2337: FOR c_upd_acai_rec IN c_upd_acai_cur LOOP
2338:
2339: -- Offer validations is successful then update the offer
2340: Igs_Ad_Ps_Appl_Inst_Pkg.UPDATE_ROW (
2341: x_rowid => c_upd_acai_rec.row_id ,
2342: x_person_id => c_upd_acai_rec.person_id ,
2343: x_admission_appl_number => c_upd_acai_rec.admission_appl_number ,
2344: x_nominated_course_cd => c_upd_acai_rec.nominated_course_cd ,

Line 2511: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,

2507: RETURN FALSE;
2508: END validate_offer_validations;
2509:
2510: FUNCTION copy_entrycomp_qual_status(p_person_id HZ_PARTIES.PARTY_ID%TYPE,
2511: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
2512: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
2513: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
2514: p_new_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
2515: p_new_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE ) RETURN BOOLEAN IS

Line 2512: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,

2508: END validate_offer_validations;
2509:
2510: FUNCTION copy_entrycomp_qual_status(p_person_id HZ_PARTIES.PARTY_ID%TYPE,
2511: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
2512: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
2513: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
2514: p_new_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
2515: p_new_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE ) RETURN BOOLEAN IS
2516: /*******************************************************************************

Line 2513: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,

2509:
2510: FUNCTION copy_entrycomp_qual_status(p_person_id HZ_PARTIES.PARTY_ID%TYPE,
2511: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
2512: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
2513: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
2514: p_new_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
2515: p_new_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE ) RETURN BOOLEAN IS
2516: /*******************************************************************************
2517: Created by : Ramesh Rengarajan

Line 2514: p_new_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,

2510: FUNCTION copy_entrycomp_qual_status(p_person_id HZ_PARTIES.PARTY_ID%TYPE,
2511: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
2512: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
2513: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
2514: p_new_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
2515: p_new_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE ) RETURN BOOLEAN IS
2516: /*******************************************************************************
2517: Created by : Ramesh Rengarajan
2518: Date created: 20 FEB 2002

Line 2515: p_new_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE ) RETURN BOOLEAN IS

2511: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
2512: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
2513: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
2514: p_new_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
2515: p_new_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE ) RETURN BOOLEAN IS
2516: /*******************************************************************************
2517: Created by : Ramesh Rengarajan
2518: Date created: 20 FEB 2002
2519:

Line 2532: igs_ad_ps_appl_inst apai

2528: CURSOR c_upd_acai_new_cur IS
2529: SELECT
2530: apai.*
2531: FROM
2532: igs_ad_ps_appl_inst apai
2533: WHERE
2534: apai.person_id = p_person_id
2535: AND apai.admission_appl_number = p_new_admission_appl_number
2536: AND apai.nominated_course_cd = p_nominated_course_cd

Line 2544: igs_ad_ps_appl_inst apai

2540: CURSOR c_upd_acai_old_cur IS
2541: SELECT
2542: apai.*
2543: FROM
2544: igs_ad_ps_appl_inst apai
2545: WHERE
2546: apai.person_id = p_person_id
2547: AND apai.admission_appl_number = p_admission_appl_number
2548: AND apai.nominated_course_cd = p_nominated_course_cd

Line 2556: Igs_Ad_Ps_Appl_Inst_Pkg.UPDATE_ROW (

2552:
2553: -- This procedure updates only entry qualification status from old to new future term application
2554: FOR c_upd_acai_old_rec IN c_upd_acai_old_cur LOOP
2555: FOR c_upd_acai_new_rec IN c_upd_acai_new_cur LOOP
2556: Igs_Ad_Ps_Appl_Inst_Pkg.UPDATE_ROW (
2557: x_rowid => c_upd_acai_new_rec.row_id ,
2558: x_person_id => c_upd_acai_new_rec.person_id ,
2559: x_admission_appl_number => c_upd_acai_new_rec.admission_appl_number ,
2560: x_nominated_course_cd => c_upd_acai_new_rec.nominated_course_cd ,

Line 2673: Igs_Ad_Ps_Appl_Inst_Pkg.UPDATE_ROW (

2669: x_decline_ofr_reason => c_upd_acai_old_rec.decline_ofr_reason
2670: );
2671:
2672: -- Also update the future application number in the old application number for link
2673: Igs_Ad_Ps_Appl_Inst_Pkg.UPDATE_ROW (
2674: x_rowid => c_upd_acai_old_rec.row_id ,
2675: x_person_id => c_upd_acai_old_rec.person_id ,
2676: x_admission_appl_number => c_upd_acai_old_rec.admission_appl_number ,
2677: x_nominated_course_cd => c_upd_acai_old_rec.nominated_course_cd ,