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_UNITASS_ITEM_ALL

Line 1583: l_unit_ass_item_id igs_as_unitass_item_all.unit_ass_item_id%TYPE;

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;
1583: l_unit_ass_item_id igs_as_unitass_item_all.unit_ass_item_id%TYPE;
1584:
1585: BEGIN
1586: -- Assigning initial values to local variables which were being initialised using DEFAULT
1587: -- clause.Done as part of bug #2563596 to remove GSCC warning.

Line 2517: l_unit_ass_item_id igs_as_unitass_item_all.unit_ass_item_id%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;
2516: l_org_id NUMBER(15);
2517: l_unit_ass_item_id igs_as_unitass_item_all.unit_ass_item_id%TYPE;
2518:
2519:
2520: CURSOR c_uop_dest_rec IS
2521: SELECT 'x'

Line 3386: CURSOR cur_ass_item(cp_unit_cd igs_as_unitass_item_all.unit_cd%TYPE,

3382: AND group_name = cp_group_name;
3383: l_rowid1 VARCHAR2(25);
3384: l_unit_ass_item_group_id NUMBER;
3385:
3386: CURSOR cur_ass_item(cp_unit_cd igs_as_unitass_item_all.unit_cd%TYPE,
3387: cp_version_number igs_as_unitass_item_all.version_number%TYPE,
3388: cp_cal_type igs_as_unitass_item_all.cal_type%TYPE,
3389: cp_ci_sequence_number igs_as_unitass_item_all.ci_sequence_number%TYPE,
3390: cp_unit_ass_item_group_id igs_as_unitass_item_all.unit_ass_item_group_id%TYPE) IS

Line 3387: cp_version_number igs_as_unitass_item_all.version_number%TYPE,

3383: l_rowid1 VARCHAR2(25);
3384: l_unit_ass_item_group_id NUMBER;
3385:
3386: CURSOR cur_ass_item(cp_unit_cd igs_as_unitass_item_all.unit_cd%TYPE,
3387: cp_version_number igs_as_unitass_item_all.version_number%TYPE,
3388: cp_cal_type igs_as_unitass_item_all.cal_type%TYPE,
3389: cp_ci_sequence_number igs_as_unitass_item_all.ci_sequence_number%TYPE,
3390: cp_unit_ass_item_group_id igs_as_unitass_item_all.unit_ass_item_group_id%TYPE) IS
3391: SELECT 'X'

Line 3388: cp_cal_type igs_as_unitass_item_all.cal_type%TYPE,

3384: l_unit_ass_item_group_id NUMBER;
3385:
3386: CURSOR cur_ass_item(cp_unit_cd igs_as_unitass_item_all.unit_cd%TYPE,
3387: cp_version_number igs_as_unitass_item_all.version_number%TYPE,
3388: cp_cal_type igs_as_unitass_item_all.cal_type%TYPE,
3389: cp_ci_sequence_number igs_as_unitass_item_all.ci_sequence_number%TYPE,
3390: cp_unit_ass_item_group_id igs_as_unitass_item_all.unit_ass_item_group_id%TYPE) IS
3391: SELECT 'X'
3392: FROM igs_as_unitass_item_all

Line 3389: cp_ci_sequence_number igs_as_unitass_item_all.ci_sequence_number%TYPE,

3385:
3386: CURSOR cur_ass_item(cp_unit_cd igs_as_unitass_item_all.unit_cd%TYPE,
3387: cp_version_number igs_as_unitass_item_all.version_number%TYPE,
3388: cp_cal_type igs_as_unitass_item_all.cal_type%TYPE,
3389: cp_ci_sequence_number igs_as_unitass_item_all.ci_sequence_number%TYPE,
3390: cp_unit_ass_item_group_id igs_as_unitass_item_all.unit_ass_item_group_id%TYPE) IS
3391: SELECT 'X'
3392: FROM igs_as_unitass_item_all
3393: WHERE unit_cd = cp_unit_cd

Line 3390: cp_unit_ass_item_group_id igs_as_unitass_item_all.unit_ass_item_group_id%TYPE) IS

3386: CURSOR cur_ass_item(cp_unit_cd igs_as_unitass_item_all.unit_cd%TYPE,
3387: cp_version_number igs_as_unitass_item_all.version_number%TYPE,
3388: cp_cal_type igs_as_unitass_item_all.cal_type%TYPE,
3389: cp_ci_sequence_number igs_as_unitass_item_all.ci_sequence_number%TYPE,
3390: cp_unit_ass_item_group_id igs_as_unitass_item_all.unit_ass_item_group_id%TYPE) IS
3391: SELECT 'X'
3392: FROM igs_as_unitass_item_all
3393: WHERE unit_cd = cp_unit_cd
3394: AND version_number = cp_version_number

Line 3392: FROM igs_as_unitass_item_all

3388: cp_cal_type igs_as_unitass_item_all.cal_type%TYPE,
3389: cp_ci_sequence_number igs_as_unitass_item_all.ci_sequence_number%TYPE,
3390: cp_unit_ass_item_group_id igs_as_unitass_item_all.unit_ass_item_group_id%TYPE) IS
3391: SELECT 'X'
3392: FROM igs_as_unitass_item_all
3393: WHERE unit_cd = cp_unit_cd
3394: AND version_number = cp_version_number
3395: AND cal_type = cp_cal_type
3396: AND ci_sequence_number = cp_ci_sequence_number