APPS.IGS_PS_UNIT_OFR_OPT_PKG dependencies on IGS_PS_USEC_REF_CD

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