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_PS_GEN_008 dependencies on IGS_AS_GRD_SCHEMA

Line 1413: cp_gs_cd IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE) IS

1409: version_number = p_version_number AND
1410: cal_type = p_cal_type AND
1411: ci_sequence_number = p_ci_sequence_number;
1412: CURSOR c_latest_gs_version (
1413: cp_gs_cd IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE) IS
1414: SELECT MAX(gs.version_number)
1415: FROM IGS_AS_GRD_SCHEMA gs
1416: WHERE gs.grading_schema_cd = cp_gs_cd;
1417:

Line 1415: FROM IGS_AS_GRD_SCHEMA gs

1411: ci_sequence_number = p_ci_sequence_number;
1412: CURSOR c_latest_gs_version (
1413: cp_gs_cd IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE) IS
1414: SELECT MAX(gs.version_number)
1415: FROM IGS_AS_GRD_SCHEMA gs
1416: WHERE gs.grading_schema_cd = cp_gs_cd;
1417:
1418: l_org_id NUMBER(15);
1419: l_c_usec_status igs_ps_unit_ofr_opt_all.unit_section_status%TYPE;

Line 1576: CURSOR cur_latest_gs_ver (cp_grad_schema_cd IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE) IS

1572: uai.cal_type = p_cal_type AND
1573: uai.ci_sequence_number = p_ci_sequence_number AND
1574: uai.unit_ass_item_group_id = cp_unit_ass_item_group_id AND
1575: uai.logical_delete_dt IS NULL;
1576: CURSOR cur_latest_gs_ver (cp_grad_schema_cd IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE) IS
1577: SELECT max(gs.version_number) maxm
1578: FROM igs_as_grd_schema gs
1579: WHERE gs.grading_schema_cd = cp_grad_schema_cd;
1580:

Line 1578: FROM igs_as_grd_schema gs

1574: uai.unit_ass_item_group_id = cp_unit_ass_item_group_id AND
1575: uai.logical_delete_dt IS NULL;
1576: CURSOR cur_latest_gs_ver (cp_grad_schema_cd IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE) IS
1577: SELECT max(gs.version_number) maxm
1578: FROM igs_as_grd_schema gs
1579: WHERE gs.grading_schema_cd = cp_grad_schema_cd;
1580:
1581: l_message_name fnd_new_messages.message_name%TYPE;
1582: v_latest_gs_ver cur_latest_gs_ver%ROWTYPE;

Line 2213: FROM igs_as_grd_schema

2209: CURSOR c_max_ver_grd_sch(
2210: p_grading_schema_cd igs_as_appr_grd_sch.grading_schema_cd%TYPE)
2211: IS
2212: SELECT MAX(version_number)
2213: FROM igs_as_grd_schema
2214: WHERE grading_schema_cd = p_grading_schema_cd;
2215: l_appr_grd_sch igs_as_appr_grd_sch%ROWTYPE;
2216: l_max_ver_grd_sch igs_as_grd_schema.version_number%TYPE;
2217: l_message_name fnd_new_messages.message_name%TYPE;

Line 2216: l_max_ver_grd_sch igs_as_grd_schema.version_number%TYPE;

2212: SELECT MAX(version_number)
2213: FROM igs_as_grd_schema
2214: WHERE grading_schema_cd = p_grading_schema_cd;
2215: l_appr_grd_sch igs_as_appr_grd_sch%ROWTYPE;
2216: l_max_ver_grd_sch igs_as_grd_schema.version_number%TYPE;
2217: l_message_name fnd_new_messages.message_name%TYPE;
2218: l_rowid VARCHAR(30);
2219:
2220: BEGIN

Line 2511: v_latest_gs_version igs_as_grd_schema.version_number%TYPE;

2507: v_ret_val BOOLEAN ;
2508: v_successful_pattern_mbr BOOLEAN ;
2509: v_exam_cal_type igs_ca_inst.cal_type%TYPE;
2510: v_exam_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
2511: v_latest_gs_version igs_as_grd_schema.version_number%TYPE;
2512: v_unit_contact igs_ps_unit_ofr_opt.unit_contact%TYPE;
2513: v_assessment_type igs_as_assessmnt_typ.assessment_type%TYPE;
2514: v_reference igs_as_unitass_item.reference%TYPE;
2515: v_uai_seq_num igs_as_unitass_item.sequence_number%TYPE;

Line 2538: CURSOR c_latest_gs_version (cp_grad_schema_cd igs_as_grd_schema.grading_schema_cd%TYPE) IS

2534: AND uoo.cal_type = p_source_cal_type
2535: AND uoo.ci_sequence_number = p_source_ci_sequence_number;
2536: v_uoo_rec c_uoo_source_rec%ROWTYPE;
2537:
2538: CURSOR c_latest_gs_version (cp_grad_schema_cd igs_as_grd_schema.grading_schema_cd%TYPE) IS
2539: SELECT MAX(gs.version_number)
2540: FROM igs_as_grd_schema gs
2541: WHERE gs.grading_schema_cd = cp_grad_schema_cd;
2542:

Line 2540: FROM igs_as_grd_schema gs

2536: v_uoo_rec c_uoo_source_rec%ROWTYPE;
2537:
2538: CURSOR c_latest_gs_version (cp_grad_schema_cd igs_as_grd_schema.grading_schema_cd%TYPE) IS
2539: SELECT MAX(gs.version_number)
2540: FROM igs_as_grd_schema gs
2541: WHERE gs.grading_schema_cd = cp_grad_schema_cd;
2542:
2543:
2544: CURSOR cur_unit_ass_group(cp_unit_cd igs_as_unit_ai_grp.unit_cd%TYPE,