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.IGF_SL_GEN dependencies on HZ_PARTIES

Line 480: p_party_id hz_parties.party_id%TYPE

476: ***************************************************************/
477: CURSOR cur_cl_version (p_ci_cal_type igf_sl_cl_setup_all.ci_cal_type%TYPE,
478: p_ci_seq_num igf_sl_cl_setup_all.ci_sequence_number%TYPE,
479: p_relationship_cd igf_sl_cl_setup_all.relationship_cd%TYPE,
480: p_party_id hz_parties.party_id%TYPE
481: ) IS
482: SELECT cl_version
483: FROM igf_sl_cl_setup_all
484: WHERE ci_cal_type = p_ci_cal_type

Line 490: l_v_party_number hz_parties.party_number%TYPE;

486: AND relationship_cd = p_relationship_cd
487: AND NVL(PARTY_ID, -99) = NVL(p_party_id, -99);
488:
489: lv_cl_version igf_sl_cl_setup_all.cl_version%TYPE;
490: l_v_party_number hz_parties.party_number%TYPE;
491: l_v_org_party_id hz_parties.party_id%TYPE;
492: l_v_module VARCHAR2(1024);
493: l_v_return_status VARCHAR2(1024);
494: l_v_msg_data VARCHAR2(1024);

Line 491: l_v_org_party_id hz_parties.party_id%TYPE;

487: AND NVL(PARTY_ID, -99) = NVL(p_party_id, -99);
488:
489: lv_cl_version igf_sl_cl_setup_all.cl_version%TYPE;
490: l_v_party_number hz_parties.party_number%TYPE;
491: l_v_org_party_id hz_parties.party_id%TYPE;
492: l_v_module VARCHAR2(1024);
493: l_v_return_status VARCHAR2(1024);
494: l_v_msg_data VARCHAR2(1024);
495:

Line 1273: x_org_unit_cd OUT NOCOPY hz_parties.party_number%TYPE,

1269:
1270: END check_rel;
1271:
1272: PROCEDURE get_associated_org (p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
1273: x_org_unit_cd OUT NOCOPY hz_parties.party_number%TYPE,
1274: x_org_party_id OUT NOCOPY hz_parties.party_id%TYPE,
1275: x_module OUT NOCOPY VARCHAR2,
1276: x_return_status OUT NOCOPY VARCHAR2,
1277: x_msg_data OUT NOCOPY VARCHAR2)

Line 1274: x_org_party_id OUT NOCOPY hz_parties.party_id%TYPE,

1270: END check_rel;
1271:
1272: PROCEDURE get_associated_org (p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
1273: x_org_unit_cd OUT NOCOPY hz_parties.party_number%TYPE,
1274: x_org_party_id OUT NOCOPY hz_parties.party_id%TYPE,
1275: x_module OUT NOCOPY VARCHAR2,
1276: x_return_status OUT NOCOPY VARCHAR2,
1277: x_msg_data OUT NOCOPY VARCHAR2)
1278: AS

Line 1299: hz_parties hz

1295: cp_version_number igs_ps_ver_all.version_number%TYPE) IS
1296: SELECT ps.responsible_org_unit_cd org_unit_cd,
1297: hz.party_id
1298: FROM igs_ps_ver_all ps,
1299: hz_parties hz
1300: WHERE hz.party_number = ps.responsible_org_unit_cd
1301: AND ps.course_cd = cp_course_cd
1302: AND ps.version_number = cp_version_number;
1303:

Line 1307: CURSOR cur_get_num_appl (p_person_id HZ_PARTIES.PARTY_ID%TYPE) IS

1303:
1304: c_get_org_enr_rec c_get_org_enr%ROWTYPE;
1305:
1306: -- get number of applications for the Person
1307: CURSOR cur_get_num_appl (p_person_id HZ_PARTIES.PARTY_ID%TYPE) IS
1308: SELECT count(ADMISSION_APPL_NUMBER) num_of_appls
1309: FROM IGS_AD_APPL_ALL appl,
1310: IGS_AD_APPL_STAT_V stat
1311: WHERE appl.ADM_APPL_STATUS = stat.ADM_APPL_STATUS

Line 1317: CURSOR cur_get_num_applinst(p_person_id HZ_PARTIES.PARTY_ID%TYPE) IS

1313: AND PERSON_ID = p_person_id;
1314: rec_get_num_appl cur_get_num_appl%ROWTYPE;
1315:
1316: -- get total number of application instances.
1317: CURSOR cur_get_num_applinst(p_person_id HZ_PARTIES.PARTY_ID%TYPE) IS
1318: SELECT count(*) num_of_records
1319: FROM IGS_AD_APPL_ALL appl,
1320: IGS_AD_PS_APPL_INST applinst,
1321: IGS_AD_OU_STAT_V igsl2

Line 1330: CURSOR c_get_org_adm (p_person_id hz_parties.party_id%TYPE) IS

1326: AND applinst.person_id = p_person_id;
1327: rec_get_num_applinst cur_get_num_applinst%ROWTYPE;
1328:
1329: -- get Org Unit from Admissions.
1330: CURSOR c_get_org_adm (p_person_id hz_parties.party_id%TYPE) IS
1331: SELECT ps.responsible_org_unit_cd,
1332: hz.party_name,
1333: hz.party_id,
1334: count(*) NUM_OF_RECORDS

Line 1336: hz_parties hz,

1332: hz.party_name,
1333: hz.party_id,
1334: count(*) NUM_OF_RECORDS
1335: FROM igs_ps_ver_all ps,
1336: hz_parties hz,
1337: igs_ad_appl_all appl,
1338: igs_ad_ps_appl_inst applinst,
1339: igs_ad_appl_stat_v igsl1,
1340: igs_ad_ou_stat_v igsl2

Line 1364: hz_parties hz

1360: hz.party_number,
1361: hz.party_name,
1362: hz.party_id
1363: FROM igf_ap_fa_base_rec_all fa,
1364: hz_parties hz
1365: WHERE fa.base_id = p_base_id
1366: AND fa.assoc_org_num = hz.party_id;
1367: c_get_assoc_org_rec c_get_assoc_org%ROWTYPE;
1368:

Line 1369: l_person_id hz_parties.party_id%TYPE;

1365: WHERE fa.base_id = p_base_id
1366: AND fa.assoc_org_num = hz.party_id;
1367: c_get_assoc_org_rec c_get_assoc_org%ROWTYPE;
1368:
1369: l_person_id hz_parties.party_id%TYPE;
1370: x_key_program_course_cd igs_ps_ver_all.course_cd%TYPE;
1371: x_version_number igs_ps_ver_all.version_number%TYPE;
1372:
1373:

Line 1516: CURSOR c_get_fa_office( p_org_unit_cd IN hz_parties.party_number%TYPE,

1512: || Who When What
1513: || (reverse chronological order - newest change first)
1514: */
1515:
1516: CURSOR c_get_fa_office( p_org_unit_cd IN hz_parties.party_number%TYPE,
1517: p_office_type IN igs_lookups_view.lookup_code%TYPE) IS
1518: SELECT org.org_alternate_id office_cd
1519: FROM igs_or_org_alt_ids org,
1520: igs_or_org_alt_idtyp idt

Line 1527: l_org_unit_cd hz_parties.party_number%TYPE;

1523: AND SYSDATE BETWEEN org.start_date AND NVL(org.end_date, SYSDATE)
1524: AND idt.system_id_type = p_office_type;
1525: c_get_fa_office_rec c_get_fa_office%ROWTYPE;
1526:
1527: l_org_unit_cd hz_parties.party_number%TYPE;
1528: l_module VARCHAR2(2);
1529: l_ret_status VARCHAR2(1);
1530: l_msg_data VARCHAR2(30);
1531: l_org_party_id hz_parties.party_id%TYPE;

Line 1531: l_org_party_id hz_parties.party_id%TYPE;

1527: l_org_unit_cd hz_parties.party_number%TYPE;
1528: l_module VARCHAR2(2);
1529: l_ret_status VARCHAR2(1);
1530: l_msg_data VARCHAR2(30);
1531: l_org_party_id hz_parties.party_id%TYPE;
1532:
1533: BEGIN
1534:
1535: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 2041: CURSOR c_get_fa_office( p_org_unit_cd IN hz_parties.party_number%TYPE,

2037: prog.version_number DESC;
2038:
2039: l_get_ant_org_unit_rec c_get_ant_org_unit%ROWTYPE;
2040:
2041: CURSOR c_get_fa_office( p_org_unit_cd IN hz_parties.party_number%TYPE,
2042: p_office_type IN igs_lookups_view.lookup_code%TYPE) IS
2043: SELECT org.org_alternate_id office_cd
2044: FROM igs_or_org_alt_ids org,
2045: igs_or_org_alt_idtyp idt