APPS.IGS_PS_UNIT_OFR_OPT_PKG dependencies on IGS_PS_USEC_REF

Line 1221: igs_ps_usec_ref_pkg.get_ufk_igs_ps_unit_ofr_opt (old_references.uoo_id);

1217: igs_ps_usec_tch_resp_pkg.get_ufk_igs_ps_unit_ofr_opt (old_references.uoo_id);
1218:
1219: igs_ps_usec_as_pkg.get_ufk_igs_ps_unit_ofr_opt (old_references.uoo_id);
1220:
1221: igs_ps_usec_ref_pkg.get_ufk_igs_ps_unit_ofr_opt (old_references.uoo_id);
1222:
1223: igs_ps_us_exam_meet_pkg.get_ufk_igs_ps_unit_ofr_opt (old_references.uoo_id);
1224:
1225: igs_ps_us_unsched_cl_pkg.get_ufk_igs_ps_unit_ofr_opt (old_references.uoo_id);

Line 1826: Purpose : Inserts into table IGS_PS_USEC_REF values inherited from igs_ps_unit_ver and IGS_PS_USEC_REF_CD

1822:
1823: /************************************************************************
1824: Created By : Aiyer
1825: Date Created By : 14/06/2001
1826: Purpose : Inserts into table IGS_PS_USEC_REF values inherited from igs_ps_unit_ver and IGS_PS_USEC_REF_CD
1827: : mandatory ref code types for unit_section with default ref code id's for the current uoo_id
1828: : at unit_section level
1829: Known limitations, enhancements or remarks:
1830: Change History :

Line 1833: to igs_ps_usec_ref_pkg.INSERT_ROW

1829: Known limitations, enhancements or remarks:
1830: Change History :
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

Line 1900: ln_usec_ref_id IGS_PS_USEC_REF.UNIT_SECTION_REFERENCE_ID%TYPE := NULL;

1896: AND
1897: uv.version_number = uoo.version_number
1898: AND
1899: uoo.uoo_id = p_n_uoo_id;
1900: ln_usec_ref_id IGS_PS_USEC_REF.UNIT_SECTION_REFERENCE_ID%TYPE := NULL;
1901: ln_usec_ref_cd_id IGS_PS_USEC_REF_CD.UNIT_SECTION_REFERENCE_CD_ID%TYPE := NULL;
1902: l_c_rowid1 VARCHAR2(25) :=NULL;
1903: l_c_rowid2 VARCHAR2(25) :=NULL;
1904: BEGIN

Line 1901: ln_usec_ref_cd_id IGS_PS_USEC_REF_CD.UNIT_SECTION_REFERENCE_CD_ID%TYPE := NULL;

1897: uv.version_number = uoo.version_number
1898: AND
1899: uoo.uoo_id = p_n_uoo_id;
1900: ln_usec_ref_id IGS_PS_USEC_REF.UNIT_SECTION_REFERENCE_ID%TYPE := NULL;
1901: ln_usec_ref_cd_id IGS_PS_USEC_REF_CD.UNIT_SECTION_REFERENCE_CD_ID%TYPE := NULL;
1902: l_c_rowid1 VARCHAR2(25) :=NULL;
1903: l_c_rowid2 VARCHAR2(25) :=NULL;
1904: BEGIN
1905: FOR cur_igs_ps_unit_ver IN c_igs_ps_unit_ver

Line 1909: igs_ps_usec_ref_pkg.INSERT_ROW (

1905: FOR cur_igs_ps_unit_ver IN c_igs_ps_unit_ver
1906: LOOP
1907: BEGIN
1908: l_c_rowid1:=NULL;
1909: igs_ps_usec_ref_pkg.INSERT_ROW (
1910: X_ROWID => l_c_rowid1,
1911: X_UNIT_SECTION_REFERENCE_ID => ln_usec_ref_id,
1912: X_UOO_ID => p_n_uoo_id,
1913: X_CLASS_SCHED_EXCLUSION_FLAG => 'N',

Line 1950: igs_ps_usec_ref_cd_pkg.INSERT_ROW (

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

Line 1990: -- After inserting value into igs_ps_unit_ofr_opt insert values into igs_ps_usec_ref and mandatory reference_cd_types of unit_section type

1986:
1987: (reverse chronological order - newest change first)
1988: ***************************************************************/
1989: -- This code has been added by aiyer.
1990: -- After inserting value into igs_ps_unit_ofr_opt insert values into igs_ps_usec_ref and mandatory reference_cd_types of unit_section type
1991: -- a having default reference_cd in the table igs_ps_usec_ref_cd
1992: CURSOR c_igs_ps_unit_ofr_opt
1993: IS
1994: SELECT uoo_id

Line 1991: -- a having default reference_cd in the table igs_ps_usec_ref_cd

1987: (reverse chronological order - newest change first)
1988: ***************************************************************/
1989: -- This code has been added by aiyer.
1990: -- After inserting value into igs_ps_unit_ofr_opt insert values into igs_ps_usec_ref and mandatory reference_cd_types of unit_section type
1991: -- a having default reference_cd in the table igs_ps_usec_ref_cd
1992: CURSOR c_igs_ps_unit_ofr_opt
1993: IS
1994: SELECT uoo_id
1995: FROM