APPS.IGS_RU_GEN_001 dependencies on IGS_RU_SET_MEMBER

Line 39: smanglm 10-05-2002 modified expand_gsch_set to segrgate grading schema and grad as both are stored together in unit_cd of igs_ru_set_member as per fix of bug 2287084

35: knaraset 28-May-2003 Modified the functions/procedure/record group for MUS build bug 2829262
36: smvk 28-Aug-2002 Removed the existing code in the function get_fdfr_rule and it is modified to return NULL always.
37: as per SFCR005_Cleanup_Build TD (Enhancement Bug # 2531390). Removed Default values of the parameters
38: in the function rulp_val_senna to avoid gscc warning 'File.Pkg.22'
39: smanglm 10-05-2002 modified expand_gsch_set to segrgate grading schema and grad as both are stored together in unit_cd of igs_ru_set_member as per fix of bug 2287084
40: smanglm 19-Apr-2002 Modified the cursor cur_gscd_set_members in the function
41: expand_gsch_set to include DISTINCT in select query as the
42: rule got modified as per bug 2287084
43: svenkata 12-Dec-2001 Added prgp_cal_cp(), pr_rul_msg() Functions. Modified turing() Function

Line 3380: igs_ru_set_member rsm

3376: uvr.unit_cd uvr_unit_cd,
3377: uvr.version_number uvr_version_number
3378: FROM IGS_PS_UNIT_VER_RU uvr,
3379: igs_ru_item rui,
3380: igs_ru_set_member rsm
3381: WHERE rsm.unit_cd = p_unit_cd
3382: AND uvr.s_rule_call_cd = 'TRANS'
3383: AND rui.rul_sequence_number = uvr.rul_sequence_number
3384: AND rsm.rs_sequence_number = rui.set_number

Line 3425: FROM IGS_RU_SET_MEMBER

3421: v_set2 := new_set;
3422: FOR set_members IN (
3423: SELECT unit_cd,
3424: versions
3425: FROM IGS_RU_SET_MEMBER
3426: WHERE rs_sequence_number = p_set1
3427: ORDER BY unit_cd )
3428: LOOP
3429: /*

Line 3450: FROM IGS_RU_SET_MEMBER

3446: v_set2 := new_set;
3447: FOR set_members IN (
3448: SELECT unit_cd,
3449: versions
3450: FROM IGS_RU_SET_MEMBER
3451: WHERE rs_sequence_number = p_set1
3452: ORDER BY unit_cd )
3453: LOOP
3454: FOR US IN (

Line 3488: FROM IGS_RU_SET_MEMBER

3484: v_set2 := new_set;
3485: FOR set_members IN (
3486: SELECT unit_cd,
3487: versions
3488: FROM IGS_RU_SET_MEMBER
3489: WHERE rs_sequence_number = p_set1
3490: ORDER BY unit_cd )
3491: LOOP
3492: FOR CRS IN (

Line 3529: FROM igs_ru_set_member

3525:
3526: -- Get the Grading Schema Code given in the Rule Definition
3527: CURSOR cur_rul_set_member IS
3528: SELECT unit_cd
3529: FROM igs_ru_set_member
3530: WHERE rs_sequence_number = p_set1
3531: ORDER BY unit_cd ;
3532:
3533: -- Get All the Grading Schema Code, Grade pairs for the Grading Schema Code given in Rule Definition.

Line 3545: l_unit_cd igs_ru_set_member.unit_cd%TYPE;

3541: AND grade = cp_grade
3542: ORDER BY grading_schema_cd;
3543:
3544: l_set2 BINARY_INTEGER;
3545: l_unit_cd igs_ru_set_member.unit_cd%TYPE;
3546:
3547: BEGIN
3548:
3549: l_set2 := new_set;

Line 3614: FROM IGS_RU_SET_MEMBER

3610: */
3611: v_set2 := new_set;
3612: FOR set_members IN (
3613: SELECT unit_cd
3614: FROM IGS_RU_SET_MEMBER
3615: WHERE rs_sequence_number = p_set1
3616: ORDER BY unit_cd )
3617: LOOP
3618: v_set2 := add_member(v_set2,