DBA Data[Home] [Help]

APPS.IGS_RU_GEN_001 dependencies on IGS_PR_GEN_002

Line 827: RETURN igs_pr_gen_002.prgp_get_stg_comp (

823: AND cst.course_stage_type = p_course_stage_type;
824: /*
825: get alternative stage completion method
826: */
827: RETURN igs_pr_gen_002.prgp_get_stg_comp (
828: p_person_id,
829: p_course_cd,
830: p_course_version,
831: v_cst_sequence_number

Line 3245: IF IGS_PR_GEN_002.PRGP_GET_STG_COMP(p_person_id => p_person_id,

3241: END IF;
3242: CLOSE c_csr;
3243:
3244: --Checking Rule Status
3245: IF IGS_PR_GEN_002.PRGP_GET_STG_COMP(p_person_id => p_person_id,
3246: p_course_cd => p_course_cd,
3247: p_crv_version_number => p_course_version,
3248: p_course_stage_type => l_cst_sequence_number) = 'N' THEN
3249: l_result := 'false';

Line 4213: l_flag := igs_pr_gen_002.prgp_get_sua_prg_num (

4209: FOR sua_rec IN cur_sua
4210: LOOP
4211: l_flag := 'Y';
4212: IF (p_rule_type IN ('NCPCPP', 'NCPPNPP')) THEN
4213: l_flag := igs_pr_gen_002.prgp_get_sua_prg_num (
4214: p_cal_type,
4215: p_ci_sequence_number,
4216: p_progression_period + 1,
4217: p_person_id,

Line 5434: --svanukur 30-jul-2003 replaced the function IGS_PR_GEN_002.PRGP_GET_SUA_GPA_VAL that calculates the gpa with the new function

5430: --smadathi 07-JUN-2001 The changes are as per enhancement bug No. 1775394 . The turin functions for person reference set evaluation,
5431: -- unit placement set evaluation, program stage set evaluation, person id group set evaluation added .
5432: --nalkumar 18-JUN-2001 This function has been modified as per the requirement of Enrolment eligibility and Validations DLD(Bug# 1830175).
5433: -- The turin functions for pct_mx_ald added.
5434: --svanukur 30-jul-2003 replaced the function IGS_PR_GEN_002.PRGP_GET_SUA_GPA_VAL that calculates the gpa with the new function
5435: -- igs_pr_cp_gpa.get_sua_all as per bug 3031749
5436: --svanukur 08-aug-2003 removed the cursor to get the unit version number since it is already available in gv_member(p_tds.member_index).f2
5437: --svanukur 18-AUG-2003 Modified the '_ER' case to pop the parameters into a PL/SQL table,t_params declared in the main function rulp_val_senna.
5438: -- Also modified the cases , p_param_1 and p_param_2 to push these into the stack. BUG# 3049903

Line 5928: push(b_to_t(IGS_PR_GEN_002.prgp_get_sua_prg_num(p_cal_type,

5924: push(l_gpa_value);
5925:
5926: ELSIF rule_items.turin_function = 'prg_prd'
5927: THEN
5928: push(b_to_t(IGS_PR_GEN_002.prgp_get_sua_prg_num(p_cal_type,
5929: p_ci_sequence_number,
5930: pop + 1, /* 1 is current period, i like 0 */
5931: p_person_id,
5932: p_course_cd,

Line 5948: push(igs_pr_gen_002.prgp_get_sua_wam(p_person_id,

5944: THEN
5945: push(wam_weighting(p_tds.member_index));
5946: ELSIF rule_items.turin_function = 'wam'
5947: THEN
5948: push(igs_pr_gen_002.prgp_get_sua_wam(p_person_id,
5949: p_course_cd,
5950: gv_member(p_tds.member_index).f1,
5951: gv_member(p_tds.member_index).f3,
5952: gv_member(p_tds.member_index).f4,