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_DA_XML_PKG dependencies on IGS_PR_STU_ACAD_STAT_INT

Line 1315: p_batch_id IN igs_pr_stu_acad_stat_int.batch_id%TYPE,

1311: END;
1312:
1313: PROCEDURE insert_gpa
1314: (
1315: p_batch_id IN igs_pr_stu_acad_stat_int.batch_id%TYPE,
1316: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
1317: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
1318: p_program_code IN igs_da_req_stdnts.program_code%TYPE,
1319: p_alternate_code IN igs_pr_stu_acad_stat_int.alternate_code%TYPE,

Line 1319: p_alternate_code IN igs_pr_stu_acad_stat_int.alternate_code%TYPE,

1315: p_batch_id IN igs_pr_stu_acad_stat_int.batch_id%TYPE,
1316: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
1317: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
1318: p_program_code IN igs_da_req_stdnts.program_code%TYPE,
1319: p_alternate_code IN igs_pr_stu_acad_stat_int.alternate_code%TYPE,
1320: p_stat_type IN igs_pr_stu_acad_stat_int.stat_type%TYPE,
1321: p_timeframe IN igs_pr_stu_acad_stat_int.timeframe%TYPE,
1322: p_attempted_credit_points IN igs_pr_stu_acad_stat_int.attempted_credit_points%TYPE,
1323: p_earned_credit_points IN igs_pr_stu_acad_stat_int.earned_credit_points%TYPE,

Line 1320: p_stat_type IN igs_pr_stu_acad_stat_int.stat_type%TYPE,

1316: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
1317: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
1318: p_program_code IN igs_da_req_stdnts.program_code%TYPE,
1319: p_alternate_code IN igs_pr_stu_acad_stat_int.alternate_code%TYPE,
1320: p_stat_type IN igs_pr_stu_acad_stat_int.stat_type%TYPE,
1321: p_timeframe IN igs_pr_stu_acad_stat_int.timeframe%TYPE,
1322: p_attempted_credit_points IN igs_pr_stu_acad_stat_int.attempted_credit_points%TYPE,
1323: p_earned_credit_points IN igs_pr_stu_acad_stat_int.earned_credit_points%TYPE,
1324: p_gpa IN igs_pr_stu_acad_stat_int.gpa%TYPE,

Line 1321: p_timeframe IN igs_pr_stu_acad_stat_int.timeframe%TYPE,

1317: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
1318: p_program_code IN igs_da_req_stdnts.program_code%TYPE,
1319: p_alternate_code IN igs_pr_stu_acad_stat_int.alternate_code%TYPE,
1320: p_stat_type IN igs_pr_stu_acad_stat_int.stat_type%TYPE,
1321: p_timeframe IN igs_pr_stu_acad_stat_int.timeframe%TYPE,
1322: p_attempted_credit_points IN igs_pr_stu_acad_stat_int.attempted_credit_points%TYPE,
1323: p_earned_credit_points IN igs_pr_stu_acad_stat_int.earned_credit_points%TYPE,
1324: p_gpa IN igs_pr_stu_acad_stat_int.gpa%TYPE,
1325: p_gpa_credit_points IN igs_pr_stu_acad_stat_int.gpa_credit_points%TYPE,

Line 1322: p_attempted_credit_points IN igs_pr_stu_acad_stat_int.attempted_credit_points%TYPE,

1318: p_program_code IN igs_da_req_stdnts.program_code%TYPE,
1319: p_alternate_code IN igs_pr_stu_acad_stat_int.alternate_code%TYPE,
1320: p_stat_type IN igs_pr_stu_acad_stat_int.stat_type%TYPE,
1321: p_timeframe IN igs_pr_stu_acad_stat_int.timeframe%TYPE,
1322: p_attempted_credit_points IN igs_pr_stu_acad_stat_int.attempted_credit_points%TYPE,
1323: p_earned_credit_points IN igs_pr_stu_acad_stat_int.earned_credit_points%TYPE,
1324: p_gpa IN igs_pr_stu_acad_stat_int.gpa%TYPE,
1325: p_gpa_credit_points IN igs_pr_stu_acad_stat_int.gpa_credit_points%TYPE,
1326: p_gpa_quality_points IN igs_pr_stu_acad_stat_int.gpa_quality_points%TYPE,

Line 1323: p_earned_credit_points IN igs_pr_stu_acad_stat_int.earned_credit_points%TYPE,

1319: p_alternate_code IN igs_pr_stu_acad_stat_int.alternate_code%TYPE,
1320: p_stat_type IN igs_pr_stu_acad_stat_int.stat_type%TYPE,
1321: p_timeframe IN igs_pr_stu_acad_stat_int.timeframe%TYPE,
1322: p_attempted_credit_points IN igs_pr_stu_acad_stat_int.attempted_credit_points%TYPE,
1323: p_earned_credit_points IN igs_pr_stu_acad_stat_int.earned_credit_points%TYPE,
1324: p_gpa IN igs_pr_stu_acad_stat_int.gpa%TYPE,
1325: p_gpa_credit_points IN igs_pr_stu_acad_stat_int.gpa_credit_points%TYPE,
1326: p_gpa_quality_points IN igs_pr_stu_acad_stat_int.gpa_quality_points%TYPE,
1327: x_return_status OUT NOCOPY VARCHAR2

Line 1324: p_gpa IN igs_pr_stu_acad_stat_int.gpa%TYPE,

1320: p_stat_type IN igs_pr_stu_acad_stat_int.stat_type%TYPE,
1321: p_timeframe IN igs_pr_stu_acad_stat_int.timeframe%TYPE,
1322: p_attempted_credit_points IN igs_pr_stu_acad_stat_int.attempted_credit_points%TYPE,
1323: p_earned_credit_points IN igs_pr_stu_acad_stat_int.earned_credit_points%TYPE,
1324: p_gpa IN igs_pr_stu_acad_stat_int.gpa%TYPE,
1325: p_gpa_credit_points IN igs_pr_stu_acad_stat_int.gpa_credit_points%TYPE,
1326: p_gpa_quality_points IN igs_pr_stu_acad_stat_int.gpa_quality_points%TYPE,
1327: x_return_status OUT NOCOPY VARCHAR2
1328: ) IS

Line 1325: p_gpa_credit_points IN igs_pr_stu_acad_stat_int.gpa_credit_points%TYPE,

1321: p_timeframe IN igs_pr_stu_acad_stat_int.timeframe%TYPE,
1322: p_attempted_credit_points IN igs_pr_stu_acad_stat_int.attempted_credit_points%TYPE,
1323: p_earned_credit_points IN igs_pr_stu_acad_stat_int.earned_credit_points%TYPE,
1324: p_gpa IN igs_pr_stu_acad_stat_int.gpa%TYPE,
1325: p_gpa_credit_points IN igs_pr_stu_acad_stat_int.gpa_credit_points%TYPE,
1326: p_gpa_quality_points IN igs_pr_stu_acad_stat_int.gpa_quality_points%TYPE,
1327: x_return_status OUT NOCOPY VARCHAR2
1328: ) IS
1329:

Line 1326: p_gpa_quality_points IN igs_pr_stu_acad_stat_int.gpa_quality_points%TYPE,

1322: p_attempted_credit_points IN igs_pr_stu_acad_stat_int.attempted_credit_points%TYPE,
1323: p_earned_credit_points IN igs_pr_stu_acad_stat_int.earned_credit_points%TYPE,
1324: p_gpa IN igs_pr_stu_acad_stat_int.gpa%TYPE,
1325: p_gpa_credit_points IN igs_pr_stu_acad_stat_int.gpa_credit_points%TYPE,
1326: p_gpa_quality_points IN igs_pr_stu_acad_stat_int.gpa_quality_points%TYPE,
1327: x_return_status OUT NOCOPY VARCHAR2
1328: ) IS
1329:
1330: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_GPA';

Line 1333: l_program_code igs_pr_stu_acad_stat_int.course_cd%TYPE;

1329:
1330: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_GPA';
1331: l_person_id hz_parties.party_id%TYPE;
1332: l_person_number hz_parties.party_number%TYPE;
1333: l_program_code igs_pr_stu_acad_stat_int.course_cd%TYPE;
1334:
1335: CURSOR c1 IS
1336: SELECT drs.program_code
1337: FROM igs_da_req_stdnts drs

Line 1352: INSERT INTO igs_pr_stu_acad_stat_int

1348: FOR v_dummy IN c1 LOOP
1349: l_program_code := v_dummy.program_code;
1350: END LOOP;
1351:
1352: INSERT INTO igs_pr_stu_acad_stat_int
1353: (BATCH_ID,
1354: COURSE_CD,
1355: PERSON_NUMBER,
1356: ALTERNATE_CODE,