APPS.IGS_PS_GEN_001 dependencies on IGS_PS_USEC_RU

Line 2284: FROM igs_ps_usec_ru_v

2280:
2281: -- 19
2282: CURSOR usec_pre_co_req_rule (cp_uoo_id NUMBER) IS
2283: SELECT *
2284: FROM igs_ps_usec_ru_v
2285: WHERE uoo_id = cp_uoo_id;
2286:
2287: -- 20
2288: CURSOR usec_cat (cp_uoo_id NUMBER) IS

Line 3704: CURSOR cur_usec_pre_co_req_rule_new (cp_uoo_id igs_ps_usec_ru.uoo_id%TYPE,

3700:
3701: -- Rollover of unit section rule records
3702: FOR usec_pre_co_req_rule_rec IN usec_pre_co_req_rule (p_old_uoo_id ) LOOP
3703: DECLARE
3704: CURSOR cur_usec_pre_co_req_rule_new (cp_uoo_id igs_ps_usec_ru.uoo_id%TYPE,
3705: cp_s_rule_call_cd igs_ps_usec_ru.s_rule_call_cd%TYPE) IS
3706: SELECT 'X'
3707: FROM igs_ps_usec_ru
3708: WHERE uoo_id = cp_uoo_id

Line 3705: cp_s_rule_call_cd igs_ps_usec_ru.s_rule_call_cd%TYPE) IS

3701: -- Rollover of unit section rule records
3702: FOR usec_pre_co_req_rule_rec IN usec_pre_co_req_rule (p_old_uoo_id ) LOOP
3703: DECLARE
3704: CURSOR cur_usec_pre_co_req_rule_new (cp_uoo_id igs_ps_usec_ru.uoo_id%TYPE,
3705: cp_s_rule_call_cd igs_ps_usec_ru.s_rule_call_cd%TYPE) IS
3706: SELECT 'X'
3707: FROM igs_ps_usec_ru
3708: WHERE uoo_id = cp_uoo_id
3709: AND s_rule_call_cd = cp_s_rule_call_cd

Line 3707: FROM igs_ps_usec_ru

3703: DECLARE
3704: CURSOR cur_usec_pre_co_req_rule_new (cp_uoo_id igs_ps_usec_ru.uoo_id%TYPE,
3705: cp_s_rule_call_cd igs_ps_usec_ru.s_rule_call_cd%TYPE) IS
3706: SELECT 'X'
3707: FROM igs_ps_usec_ru
3708: WHERE uoo_id = cp_uoo_id
3709: AND s_rule_call_cd = cp_s_rule_call_cd
3710: AND ROWNUM = 1;
3711: l_cur_usec_pre_co_req_rule_new cur_usec_pre_co_req_rule_new%ROWTYPE;

Line 3716: ln_rule_number igs_ps_usec_ru.rul_sequence_number%TYPE;

3712:
3713: lv_rowid VARCHAR2(25);
3714: l_usecru_id NUMBER;
3715: lv_rule_unprocessed VARCHAR2(4500);
3716: ln_rule_number igs_ps_usec_ru.rul_sequence_number%TYPE;
3717: ln_lov_number NUMBER;
3718: x BOOLEAN;
3719: BEGIN
3720:

Line 3751: -- returns a TRUE or FALSE.Only if it returns TRUE then insert into igs_ps_usec_ru

3747: -- NEW Unit section.
3748:
3749: -- As part of bug fix bug#2563596
3750: -- Added an IF condition that checks if the function igs_ru_gen_002.rulp_ins_parser
3751: -- returns a TRUE or FALSE.Only if it returns TRUE then insert into igs_ps_usec_ru
3752:
3753: IF x THEN
3754: igs_ps_usec_ru_pkg.insert_row (
3755: x_rowid => lv_rowid,

Line 3754: igs_ps_usec_ru_pkg.insert_row (

3750: -- Added an IF condition that checks if the function igs_ru_gen_002.rulp_ins_parser
3751: -- returns a TRUE or FALSE.Only if it returns TRUE then insert into igs_ps_usec_ru
3752:
3753: IF x THEN
3754: igs_ps_usec_ru_pkg.insert_row (
3755: x_rowid => lv_rowid,
3756: x_usecru_id => l_usecru_id,
3757: x_uoo_id => p_new_uoo_id,
3758: x_s_rule_call_cd => usec_pre_co_req_rule_rec.s_rule_call_cd,