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_RU_GEN_001 dependencies on IGS_PS_STAGE

Line 777: FROM IGS_PS_STAGE_RU

773: v_rule_number NUMBER;
774: BEGIN
775: SELECT rul_sequence_number
776: INTO v_rule_number
777: FROM IGS_PS_STAGE_RU
778: WHERE course_cd = p_course_cd
779: AND version_number = p_course_version
780: AND cst_sequence_number = p_cst_sequence_number
781: AND s_rule_call_cd = p_rule_call_name;

Line 813: v_cst_sequence_number IGS_PS_STAGE.sequence_number%TYPE;

809: */
810: FUNCTION do_course_stage (
811: p_course_stage_type VARCHAR2
812: ) RETURN VARCHAR2 IS
813: v_cst_sequence_number IGS_PS_STAGE.sequence_number%TYPE;
814: BEGIN
815: /*
816: get sequence number for stage type
817: */

Line 820: FROM IGS_PS_STAGE cst

816: get sequence number for stage type
817: */
818: SELECT cst.sequence_number
819: INTO v_cst_sequence_number
820: FROM IGS_PS_STAGE cst
821: WHERE cst.course_cd = p_course_cd
822: AND cst.version_number = p_course_version
823: AND cst.course_stage_type = p_course_stage_type;
824: /*

Line 3192: CURSOR c_igs_ps_stage(lc_course_cd igs_ps_stage.course_cd%TYPE,

3188: l_member BINARY_INTEGER ;
3189: l_result VARCHAR2(100) ;
3190: l_tds r_tds ;
3191:
3192: CURSOR c_igs_ps_stage(lc_course_cd igs_ps_stage.course_cd%TYPE,
3193: lc_version_number igs_ps_stage.version_number%TYPE,
3194: lc_course_stage_type igs_ps_stage.course_stage_type%TYPE) IS
3195: SELECT cst.sequence_number
3196: FROM igs_ps_stage cst

Line 3193: lc_version_number igs_ps_stage.version_number%TYPE,

3189: l_result VARCHAR2(100) ;
3190: l_tds r_tds ;
3191:
3192: CURSOR c_igs_ps_stage(lc_course_cd igs_ps_stage.course_cd%TYPE,
3193: lc_version_number igs_ps_stage.version_number%TYPE,
3194: lc_course_stage_type igs_ps_stage.course_stage_type%TYPE) IS
3195: SELECT cst.sequence_number
3196: FROM igs_ps_stage cst
3197: WHERE cst.course_cd = lc_course_cd

Line 3194: lc_course_stage_type igs_ps_stage.course_stage_type%TYPE) IS

3190: l_tds r_tds ;
3191:
3192: CURSOR c_igs_ps_stage(lc_course_cd igs_ps_stage.course_cd%TYPE,
3193: lc_version_number igs_ps_stage.version_number%TYPE,
3194: lc_course_stage_type igs_ps_stage.course_stage_type%TYPE) IS
3195: SELECT cst.sequence_number
3196: FROM igs_ps_stage cst
3197: WHERE cst.course_cd = lc_course_cd
3198: AND cst.version_number = lc_version_number

Line 3196: FROM igs_ps_stage cst

3192: CURSOR c_igs_ps_stage(lc_course_cd igs_ps_stage.course_cd%TYPE,
3193: lc_version_number igs_ps_stage.version_number%TYPE,
3194: lc_course_stage_type igs_ps_stage.course_stage_type%TYPE) IS
3195: SELECT cst.sequence_number
3196: FROM igs_ps_stage cst
3197: WHERE cst.course_cd = lc_course_cd
3198: AND cst.version_number = lc_version_number
3199: AND cst.course_stage_type = lc_course_stage_type ;
3200:

Line 3201: l_cst_sequence_number igs_ps_stage.sequence_number%TYPE ;

3197: WHERE cst.course_cd = lc_course_cd
3198: AND cst.version_number = lc_version_number
3199: AND cst.course_stage_type = lc_course_stage_type ;
3200:
3201: l_cst_sequence_number igs_ps_stage.sequence_number%TYPE ;
3202:
3203: v_rule_text VARCHAR2(2000);
3204:
3205: CURSOR c_csr (lc_course_cd igs_ps_stage.course_cd%TYPE,

Line 3205: CURSOR c_csr (lc_course_cd igs_ps_stage.course_cd%TYPE,

3201: l_cst_sequence_number igs_ps_stage.sequence_number%TYPE ;
3202:
3203: v_rule_text VARCHAR2(2000);
3204:
3205: CURSOR c_csr (lc_course_cd igs_ps_stage.course_cd%TYPE,
3206: lc_version_number igs_ps_stage.version_number%TYPE,
3207: lc_cst_sequence_number igs_ps_stage.sequence_number%TYPE,
3208: lc_course_stage_type igs_ps_stage.course_stage_type%TYPE) IS
3209: SELECT igs_ru_gen_003.rulp_get_rule (rul_sequence_number)

Line 3206: lc_version_number igs_ps_stage.version_number%TYPE,

3202:
3203: v_rule_text VARCHAR2(2000);
3204:
3205: CURSOR c_csr (lc_course_cd igs_ps_stage.course_cd%TYPE,
3206: lc_version_number igs_ps_stage.version_number%TYPE,
3207: lc_cst_sequence_number igs_ps_stage.sequence_number%TYPE,
3208: lc_course_stage_type igs_ps_stage.course_stage_type%TYPE) IS
3209: SELECT igs_ru_gen_003.rulp_get_rule (rul_sequence_number)
3210: FROM igs_ps_stage_ru

Line 3207: lc_cst_sequence_number igs_ps_stage.sequence_number%TYPE,

3203: v_rule_text VARCHAR2(2000);
3204:
3205: CURSOR c_csr (lc_course_cd igs_ps_stage.course_cd%TYPE,
3206: lc_version_number igs_ps_stage.version_number%TYPE,
3207: lc_cst_sequence_number igs_ps_stage.sequence_number%TYPE,
3208: lc_course_stage_type igs_ps_stage.course_stage_type%TYPE) IS
3209: SELECT igs_ru_gen_003.rulp_get_rule (rul_sequence_number)
3210: FROM igs_ps_stage_ru
3211: WHERE course_cd = lc_course_cd

Line 3208: lc_course_stage_type igs_ps_stage.course_stage_type%TYPE) IS

3204:
3205: CURSOR c_csr (lc_course_cd igs_ps_stage.course_cd%TYPE,
3206: lc_version_number igs_ps_stage.version_number%TYPE,
3207: lc_cst_sequence_number igs_ps_stage.sequence_number%TYPE,
3208: lc_course_stage_type igs_ps_stage.course_stage_type%TYPE) IS
3209: SELECT igs_ru_gen_003.rulp_get_rule (rul_sequence_number)
3210: FROM igs_ps_stage_ru
3211: WHERE course_cd = lc_course_cd
3212: AND version_number = lc_version_number

Line 3210: FROM igs_ps_stage_ru

3206: lc_version_number igs_ps_stage.version_number%TYPE,
3207: lc_cst_sequence_number igs_ps_stage.sequence_number%TYPE,
3208: lc_course_stage_type igs_ps_stage.course_stage_type%TYPE) IS
3209: SELECT igs_ru_gen_003.rulp_get_rule (rul_sequence_number)
3210: FROM igs_ps_stage_ru
3211: WHERE course_cd = lc_course_cd
3212: AND version_number = lc_version_number
3213: AND cst_sequence_number = lc_cst_sequence_number
3214: AND s_rule_call_cd = lc_course_stage_type;

Line 3227: OPEN c_igs_ps_stage(p_course_cd, p_course_version,l_tds.unit_cd);

3223: l_tds.member_index := l_member ; -- get the index for pl/sql table
3224: l_tds.unit_cd := gv_member(l_member).f1 ; -- get the value of code defined in rules in local variable
3225:
3226: -- Checking if the Stage is attached to the Program
3227: OPEN c_igs_ps_stage(p_course_cd, p_course_version,l_tds.unit_cd);
3228: FETCH c_igs_ps_stage INTO l_cst_sequence_number;
3229: IF c_igs_ps_stage%NOTFOUND THEN
3230: CLOSE c_igs_ps_stage;
3231: RETURN 'false';

Line 3228: FETCH c_igs_ps_stage INTO l_cst_sequence_number;

3224: l_tds.unit_cd := gv_member(l_member).f1 ; -- get the value of code defined in rules in local variable
3225:
3226: -- Checking if the Stage is attached to the Program
3227: OPEN c_igs_ps_stage(p_course_cd, p_course_version,l_tds.unit_cd);
3228: FETCH c_igs_ps_stage INTO l_cst_sequence_number;
3229: IF c_igs_ps_stage%NOTFOUND THEN
3230: CLOSE c_igs_ps_stage;
3231: RETURN 'false';
3232: END IF;

Line 3229: IF c_igs_ps_stage%NOTFOUND THEN

3225:
3226: -- Checking if the Stage is attached to the Program
3227: OPEN c_igs_ps_stage(p_course_cd, p_course_version,l_tds.unit_cd);
3228: FETCH c_igs_ps_stage INTO l_cst_sequence_number;
3229: IF c_igs_ps_stage%NOTFOUND THEN
3230: CLOSE c_igs_ps_stage;
3231: RETURN 'false';
3232: END IF;
3233: CLOSE c_igs_ps_stage;

Line 3230: CLOSE c_igs_ps_stage;

3226: -- Checking if the Stage is attached to the Program
3227: OPEN c_igs_ps_stage(p_course_cd, p_course_version,l_tds.unit_cd);
3228: FETCH c_igs_ps_stage INTO l_cst_sequence_number;
3229: IF c_igs_ps_stage%NOTFOUND THEN
3230: CLOSE c_igs_ps_stage;
3231: RETURN 'false';
3232: END IF;
3233: CLOSE c_igs_ps_stage;
3234:

Line 3233: CLOSE c_igs_ps_stage;

3229: IF c_igs_ps_stage%NOTFOUND THEN
3230: CLOSE c_igs_ps_stage;
3231: RETURN 'false';
3232: END IF;
3233: CLOSE c_igs_ps_stage;
3234:
3235: -- Checking if the Stage attached to the Program has a Rule
3236: OPEN c_csr(p_course_cd, p_course_version,l_cst_sequence_number,'STG-COMP');
3237: FETCH c_csr INTO v_rule_text;