APPS.IGS_PS_UNIT_OFR_OPT_PKG dependencies on IGS_GE_REF_CD_TYPE

Line 1835: CURSOR c_igs_ge_ref_cd_type

1831: Who When What
1832: stutta 14-May-2004 Passing 'N' as default value for X_CLASS_SCHED_EXCLUSION_FLAG in call
1833: to igs_ps_usec_ref_pkg.INSERT_ROW
1834: *************************************************************************/
1835: CURSOR c_igs_ge_ref_cd_type
1836: IS
1837: SELECT
1838: reference_cd_type
1839: FROM

Line 1840: igs_ge_ref_cd_type

1836: IS
1837: SELECT
1838: reference_cd_type
1839: FROM
1840: igs_ge_ref_cd_type
1841: WHERE
1842: mandatory_flag ='Y'
1843: AND
1844: unit_section_flag ='Y'

Line 1850: CURSOR c_igs_ge_ref_cd (p_c_reference_cd_type IGS_GE_REF_CD_TYPE.REFERENCE_CD_TYPE%TYPE)

1846: restricted_flag='Y'
1847: AND
1848: closed_ind = 'N';
1849:
1850: CURSOR c_igs_ge_ref_cd (p_c_reference_cd_type IGS_GE_REF_CD_TYPE.REFERENCE_CD_TYPE%TYPE)
1851: IS
1852: SELECT
1853: reference_cd_type,reference_cd,description
1854: FROM

Line 1944: FOR cur_igs_ge_ref_cd_type IN c_igs_ge_ref_cd_type

1940: X_ATTRIBUTE19 => cur_igs_ps_unit_ver.Attribute19 ,
1941: X_ATTRIBUTE20 => cur_igs_ps_unit_ver.Attribute20 ,
1942: X_MODE => 'R'
1943: );
1944: FOR cur_igs_ge_ref_cd_type IN c_igs_ge_ref_cd_type
1945: LOOP
1946: FOR cur_igs_ge_ref_cd IN c_igs_ge_ref_cd (cur_igs_ge_ref_cd_type.reference_cd_type)
1947: LOOP
1948: l_c_rowid2:=NULL;

Line 1946: FOR cur_igs_ge_ref_cd IN c_igs_ge_ref_cd (cur_igs_ge_ref_cd_type.reference_cd_type)

1942: X_MODE => 'R'
1943: );
1944: FOR cur_igs_ge_ref_cd_type IN c_igs_ge_ref_cd_type
1945: LOOP
1946: FOR cur_igs_ge_ref_cd IN c_igs_ge_ref_cd (cur_igs_ge_ref_cd_type.reference_cd_type)
1947: LOOP
1948: l_c_rowid2:=NULL;
1949: ln_usec_ref_cd_id:=NULL;
1950: igs_ps_usec_ref_cd_pkg.INSERT_ROW (