APPS.IGS_PS_GEN_001 dependencies on IGS_PS_US_REQ_REF_CD_PKG

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 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,