APPS.IGS_PS_GEN_001 dependencies on IGS_PS_US_REQ_REF_CD

Line 2123: --sarakshi 25-Apr-2003 Enh#2858431,modified call to igs_ps_us_req_ref_cd_pkg.insert_row

2119: -- refers to table igs_ps_usec_rpt_cond which is obsoleted as part of this design.
2120: --smvk 25-jun-2003 Enh bug#2918094. Added column cancel_flag.
2121: --shtatiko 23-MAY-2003 Enh# 2831572, Removed cursor cur_usec_accts and also removed code to rollover Revenue Account
2122: -- Code into igs_ps_usec_accts
2123: --sarakshi 25-Apr-2003 Enh#2858431,modified call to igs_ps_us_req_ref_cd_pkg.insert_row
2124: --vvutukur 01-Nov-2002 Enh#2636716.Added new column max_auditors_allowd in the tbh call to
2125: -- igs_ps_usec_lim_wlst_pkg.insert_row.
2126: --vvutukur 28-Oct-2002 Enh#2613933.Modified cursor usec_x_grpmem to select 2 new columns max_enr_group,
2127: -- max_ovr_group.Also modified the tbh call to igs_ps_usec_x_grp_pkg.insert_row.

Line 2265: FROM igs_ps_us_req_ref_cd

2261:
2262: --16
2263: CURSOR us_req_refcd ( cp_usec_ref_id NUMBER) IS
2264: SELECT *
2265: FROM igs_ps_us_req_ref_cd
2266: WHERE unit_section_reference_id = cp_usec_ref_id;
2267:
2268: --17
2269: CURSOR usec_grdsch ( p_uoo_id NUMBER ) IS

Line 3473: --only igs_ps_us_req_ref_cd insertion is required

3469: l_usec_ref usec_reference%ROWTYPE;
3470: BEGIN
3471: --added by sarakshi, bug#2332807
3472: --Unit section TBH automatically inserts in igs_ps_usec_ref and igs_ps_usec_ref_cd, so removed those inserts
3473: --only igs_ps_us_req_ref_cd insertion is required
3474:
3475: OPEN usec_reference(p_new_uoo_id);
3476: FETCH usec_reference INTO l_usec_ref;
3477: CLOSE usec_reference;

Line 3533: CURSOR cur_us_req_refcd_new (cp_unit_section_reference_id igs_ps_us_req_ref_cd.unit_section_reference_id%TYPE,

3529: --Enhancement bug no 1800179 , pmarada
3530: -- Rollover of unit section requirement reference code records
3531: FOR us_req_refcd_rec IN us_req_refcd (usec_ref_rec.unit_section_reference_id ) LOOP
3532: DECLARE
3533: CURSOR cur_us_req_refcd_new (cp_unit_section_reference_id igs_ps_us_req_ref_cd.unit_section_reference_id%TYPE,
3534: cp_reference_cd_type igs_ps_us_req_ref_cd.reference_cd_type%TYPE,
3535: cp_reference_code igs_ps_us_req_ref_cd.reference_code%TYPE) IS
3536: SELECT 'X'
3537: FROM igs_ps_us_req_ref_cd

Line 3534: cp_reference_cd_type igs_ps_us_req_ref_cd.reference_cd_type%TYPE,

3530: -- Rollover of unit section requirement reference code records
3531: FOR us_req_refcd_rec IN us_req_refcd (usec_ref_rec.unit_section_reference_id ) LOOP
3532: DECLARE
3533: CURSOR cur_us_req_refcd_new (cp_unit_section_reference_id igs_ps_us_req_ref_cd.unit_section_reference_id%TYPE,
3534: cp_reference_cd_type igs_ps_us_req_ref_cd.reference_cd_type%TYPE,
3535: cp_reference_code igs_ps_us_req_ref_cd.reference_code%TYPE) IS
3536: SELECT 'X'
3537: FROM igs_ps_us_req_ref_cd
3538: WHERE unit_section_reference_id = cp_unit_section_reference_id

Line 3535: cp_reference_code igs_ps_us_req_ref_cd.reference_code%TYPE) IS

3531: FOR us_req_refcd_rec IN us_req_refcd (usec_ref_rec.unit_section_reference_id ) LOOP
3532: DECLARE
3533: CURSOR cur_us_req_refcd_new (cp_unit_section_reference_id igs_ps_us_req_ref_cd.unit_section_reference_id%TYPE,
3534: cp_reference_cd_type igs_ps_us_req_ref_cd.reference_cd_type%TYPE,
3535: cp_reference_code igs_ps_us_req_ref_cd.reference_code%TYPE) IS
3536: SELECT 'X'
3537: FROM igs_ps_us_req_ref_cd
3538: WHERE unit_section_reference_id = cp_unit_section_reference_id
3539: AND reference_cd_type = cp_reference_cd_type

Line 3537: FROM igs_ps_us_req_ref_cd

3533: CURSOR cur_us_req_refcd_new (cp_unit_section_reference_id igs_ps_us_req_ref_cd.unit_section_reference_id%TYPE,
3534: cp_reference_cd_type igs_ps_us_req_ref_cd.reference_cd_type%TYPE,
3535: cp_reference_code igs_ps_us_req_ref_cd.reference_code%TYPE) IS
3536: SELECT 'X'
3537: FROM igs_ps_us_req_ref_cd
3538: WHERE unit_section_reference_id = cp_unit_section_reference_id
3539: AND reference_cd_type = cp_reference_cd_type
3540: AND reference_code = cp_reference_code
3541: AND ROWNUM = 1;

Line 3551: igs_ps_us_req_ref_cd_pkg.insert_row (

3547:
3548: OPEN cur_us_req_refcd_new(l_usec_ref.unit_section_reference_id,us_req_refcd_rec.reference_cd_type, us_req_refcd_rec.reference_code);
3549: FETCH cur_us_req_refcd_new INTO l_cur_us_req_refcd_new;
3550: IF cur_us_req_refcd_new%NOTFOUND THEN
3551: igs_ps_us_req_ref_cd_pkg.insert_row (
3552: x_rowid => lv_rowid,
3553: x_unit_section_req_ref_cd_id => l_unit_section_req_ref_cd_id,
3554: x_unit_section_reference_id => l_usec_ref.unit_section_reference_id,
3555: x_reference_cd_type => us_req_refcd_rec.reference_cd_type,