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 HZ_PARTIES

Line 28: p_person_id HZ_PARTIES.party_id%TYPE,

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,
32: p_start_dt DATE)

Line 444: p_person_id hz_parties.party_id%TYPE,

440:
441: PROCEDURE admp_val_offer_future_term(
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,

Line 490: l_person_number hz_parties.party_number%TYPE;

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:
493: ---End Variable Declarations--------------------------------------------------------------------------------------------
494:

Line 534: CURSOR c_appl_inst(p_person_id hz_parties.party_id%TYPE) IS

530: fut_acad_adm_alt_code VARCHAR2(200);
531:
532: -- Cursor to get the current application attributes -----
533:
534: CURSOR c_appl_inst(p_person_id hz_parties.party_id%TYPE) IS
535: SELECT
536: acai.*
537: FROM
538: igs_ad_appl aa,

Line 561: CURSOR c_group_id(p_person_id hz_parties.party_id%TYPE,p_group_id igs_pe_persid_group.group_id%TYPE) IS

557: AND NVL(acai.adm_ci_sequence_number,aa.adm_ci_sequence_number) = NVL ( p_prev_adm_cal_seq_no, acai.adm_ci_sequence_number)
558: AND aa.APPLICATION_TYPE = NVL(p_application_type,aa.APPLICATION_TYPE)
559: AND aa.APPLICATION_ID = NVL(p_application_id,aa.APPLICATION_ID);
560:
561: CURSOR c_group_id(p_person_id hz_parties.party_id%TYPE,p_group_id igs_pe_persid_group.group_id%TYPE) IS
562: SELECT 'X'
563: FROM igs_pe_prsid_grp_mem
564: WHERE person_id = p_person_id
565: AND group_id = p_group_id

Line 938: p_person_id hz_parties.party_id%TYPE,

934: RETURN;
935: END admp_val_offer_future_term;
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,

Line 1189: p_person_id HZ_PARTIES.party_id%TYPE,

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,
1193: p_start_dt DATE,

Line 1217: CURSOR c_unitsets_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,

1213: rrengara 13-sep-2002 Added p_process to the procedure. If p_process is 'D' then copy the fee details fee status as 'WAIVED'
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

Line 1241: CURSOR c_othinst_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,

1237: admission_appl_number = cp_admission_appl_number;
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,

Line 1260: CURSOR c_edugoal_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,

1256: admission_appl_number = cp_admission_appl_number;
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

Line 1289: CURSOR c_perstat_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,

1285: -- So cursor to select the values from the old applicaiton has been removed
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,

Line 1306: CURSOR c_acadint_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,

1302: admission_appl_number = cp_admission_appl_number;
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 ,

Line 1321: CURSOR c_appint_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,

1317: person_id = cp_person_id and
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,

Line 1358: CURSOR c_splint_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,

1354: admission_appl_number = cp_admission_appl_number;
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 ,

Line 1373: CURSOR c_spltal_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,

1369: person_id = cp_person_id and
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 ,

Line 1388: CURSOR c_splcns_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,

1384: person_id = cp_person_id and
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

Line 1409: CURSOR c_fee_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,

1405: sequence_number = cp_sequence_number and
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 ,

Line 1443: CURSOR c_tracking_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,

1439: person_id = cp_person_id AND
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

Line 1464: CURSOR c_pgmapp_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,

1460: sequence_number = cp_sequence_number and
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

Line 1490: CURSOR c_test_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,

1486: sequence_number = cp_sequence_number and
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

Line 1533: CURSOR c_notes_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,

1529: admission_appl_number = cp_admission_appl_number;
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

Line 1554: CURSOR c_evaluators_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,

1550: nominated_course_cd = cp_nominated_course_cd and
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:

Line 1585: CURSOR c_applrep_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,

1581: sequence_number = cp_sequence_number and
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:

Line 1623: CURSOR c_appl_qual_code(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,

1619: AND ccl.system_default = 'Y'
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

Line 2049: FUNCTION validate_offer_validations(p_person_id HZ_PARTIES.PARTY_ID%TYPE,

2045:
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,

Line 2510: FUNCTION copy_entrycomp_qual_status(p_person_id HZ_PARTIES.PARTY_ID%TYPE,

2506: fnd_file.put_line(fnd_file.log, SQLERRM);
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,