APPS.IGF_AW_COA_GEN dependencies on HZ_PARTIES

Line 1243: l_person_id hz_parties.party_id%TYPE;

1239: l_term_end DATE;
1240:
1241: lv_usage VARCHAR2(1); -- 1 -> Actual, 2 -> Actual,if not available then Anticipated, 3 -> Anticipated.
1242:
1243: l_person_id hz_parties.party_id%TYPE;
1244:
1245: l_base_det base_details;
1246:
1247: -- Get person_id

Line 1281: cp_person_id hz_parties.party_id%TYPE,

1277: l_anticip c_anticip%ROWTYPE;
1278:
1279: -- Get org unit
1280: CURSOR c_org(
1281: cp_person_id hz_parties.party_id%TYPE,
1282: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
1283: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
1284: ) IS
1285: SELECT ps.responsible_org_unit_cd,1 record_order

Line 1307: cp_person_id hz_parties.party_id%TYPE,

1303: ORDER BY record_order;
1304:
1305: -- Get program type
1306: CURSOR c_prg_type(
1307: cp_person_id hz_parties.party_id%TYPE,
1308: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
1309: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
1310: ) IS
1311: SELECT pt.course_type,1 record_order

Line 1336: cp_person_id hz_parties.party_id%TYPE,

1332: ORDER BY record_order;
1333:
1334: -- Get program location
1335: CURSOR c_prog_loc(
1336: cp_person_id hz_parties.party_id%TYPE,
1337: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
1338: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
1339: ) IS
1340: SELECT location_cd,

Line 1357: cp_person_id hz_parties.party_id%TYPE,

1353: ORDER BY record_order;
1354:
1355: -- Get get program code
1356: CURSOR c_prog_code(
1357: cp_person_id hz_parties.party_id%TYPE,
1358: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
1359: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
1360: ) IS
1361: SELECT program_cd,

Line 1381: cp_person_id hz_parties.party_id%TYPE,

1377:
1378:
1379: -- Get attendance type
1380: CURSOR c_att_type(
1381: cp_person_id hz_parties.party_id%TYPE,
1382: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
1383: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
1384: ) IS
1385: SELECT attendance_type,

Line 1402: cp_person_id hz_parties.party_id%TYPE,

1398: ORDER BY record_order;
1399:
1400: -- Get attendance mode
1401: CURSOR c_att_mode(
1402: cp_person_id hz_parties.party_id%TYPE,
1403: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
1404: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
1405: ) IS
1406: SELECT attendance_mode,

Line 1431: cp_person_id hz_parties.party_id%TYPE,

1427: l_residency_class igs_pe_res_dtls.residency_class_cd%TYPE;
1428:
1429: -- Get housing status
1430: CURSOR c_housing_status(
1431: cp_person_id hz_parties.party_id%TYPE,
1432: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
1433: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
1434: ) IS
1435: SELECT teach_period_resid_stat_cd

Line 1831: p_person_id hz_parties.party_id%TYPE,

1827: app_exception.raise_exception;
1828: END getBaseDetails;
1829:
1830: PROCEDURE ins_coa_todo(
1831: p_person_id hz_parties.party_id%TYPE,
1832: p_calling_module VARCHAR2,
1833: p_program_code igs_ps_ver.course_cd%TYPE,
1834: p_version_number igs_ps_ver.version_number%TYPE
1835: ) AS

Line 1862: cp_person_id hz_parties.party_id%TYPE

1858: -------------------------------------------------------------------
1859:
1860: -- Get all open award years
1861: CURSOR c_base_records(
1862: cp_person_id hz_parties.party_id%TYPE
1863: ) IS
1864: SELECT batch.ci_cal_type,
1865: batch.ci_sequence_number
1866: FROM igf_ap_batch_aw_map_all batch,