DBA Data[Home] [Help]

APPS.IGS_PS_UNIT_VER_PKG dependencies on IGS_HE_ST_UNT_VS_ALL_PKG

Line 46: -- smaddali 21-jan-04 Modified procedure Check_Child_Existance , to remove cursor c_hesa and call igs_he_st_unt_vs_all_pkg.get_fk_igs_ps_unit_ver_all

42: -- smvk 16-Dec-2002 Function Call IGS_PS_VAL_US.crsp_val_ver_dt,IGS_PS_VAL_UV.crsp_val_uv_pnt_ovrd and IGS_PS_VAL_UV.crsp_val_uv_unit_sts
43: -- are modified with additional parameter value 'FALSE'. for Bug # 2696207
44: -- smvk 19-Dec-2002 Removed the OWNER_ORG_UNIT_CD checking for upper case
45: -- from check_constraints procedure. Bug # 2487149
46: -- smaddali 21-jan-04 Modified procedure Check_Child_Existance , to remove cursor c_hesa and call igs_he_st_unt_vs_all_pkg.get_fk_igs_ps_unit_ver_all
47: -- and igs_he_st_uv_cc_all_pkg.get_fk_igs_ps_unit_ver_all directly instead of thru execute immediate for bug#3306063
48:
49: l_rowid VARCHAR2(25);
50: old_references IGS_PS_UNIT_VER_ALL%RowType;

Line 2589: igs_he_st_unt_vs_all_pkg.get_fk_igs_ps_unit_ver_all(x_unit_cd => old_references.unit_cd,

2585: old_references.version_number);
2586:
2587: -- Added the following check chaild existance for the HESA requirment, pmarada
2588: -- smaddali removed the Execute immediate statement and calling packages directly, bug#3306063
2589: igs_he_st_unt_vs_all_pkg.get_fk_igs_ps_unit_ver_all(x_unit_cd => old_references.unit_cd,
2590: x_version_number => old_references.version_number);
2591:
2592: END Check_Child_Existance;
2593: --------------------------------------------------------------