APPS.IGS_PS_UNIT_OFR_OPT_PKG dependencies on IGS_GE_REF_CD

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 1855: igs_ge_ref_cd

1851: IS
1852: SELECT
1853: reference_cd_type,reference_cd,description
1854: FROM
1855: igs_ge_ref_cd
1856: WHERE
1857: reference_cd_type = p_c_reference_cd_type
1858: AND
1859: default_flag = 'Y';

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 (

Line 1955: x_reference_code_type => cur_igs_ge_ref_cd.reference_cd_type,

1951: X_ROWID => l_c_rowid2,
1952: X_UNIT_SECTION_REFERENCE_CD_ID => ln_usec_ref_cd_id,
1953: X_UNIT_SECTION_REFERENCE_ID => ln_usec_ref_id,
1954: X_MODE => 'R',
1955: x_reference_code_type => cur_igs_ge_ref_cd.reference_cd_type,
1956: x_reference_code => cur_igs_ge_ref_cd.reference_cd,
1957: x_reference_code_desc => cur_igs_ge_ref_cd.description
1958:
1959: );

Line 1956: x_reference_code => cur_igs_ge_ref_cd.reference_cd,

1952: X_UNIT_SECTION_REFERENCE_CD_ID => ln_usec_ref_cd_id,
1953: X_UNIT_SECTION_REFERENCE_ID => ln_usec_ref_id,
1954: X_MODE => 'R',
1955: x_reference_code_type => cur_igs_ge_ref_cd.reference_cd_type,
1956: x_reference_code => cur_igs_ge_ref_cd.reference_cd,
1957: x_reference_code_desc => cur_igs_ge_ref_cd.description
1958:
1959: );
1960: END LOOP;

Line 1957: x_reference_code_desc => cur_igs_ge_ref_cd.description

1953: X_UNIT_SECTION_REFERENCE_ID => ln_usec_ref_id,
1954: X_MODE => 'R',
1955: x_reference_code_type => cur_igs_ge_ref_cd.reference_cd_type,
1956: x_reference_code => cur_igs_ge_ref_cd.reference_cd,
1957: x_reference_code_desc => cur_igs_ge_ref_cd.description
1958:
1959: );
1960: END LOOP;
1961: END LOOP;