DBA Data[Home] [Help]

APPS.IGS_PS_GEN_008 dependencies on IGS_PS_UNIT_FACILITY

Line 2035: FROM igs_ps_unit_facility

2031: p_version_number IN igs_ps_unit_ver.version_number%TYPE )
2032: AS
2033: CURSOR c_unit_fac_det IS
2034: SELECT *
2035: FROM igs_ps_unit_facility
2036: WHERE unit_code = p_unit_cd
2037: AND unit_version_number = p_version_number;
2038: v_unit_media_id igs_ps_unit_facility.unit_media_id%TYPE;
2039: BEGIN

Line 2038: v_unit_media_id igs_ps_unit_facility.unit_media_id%TYPE;

2034: SELECT *
2035: FROM igs_ps_unit_facility
2036: WHERE unit_code = p_unit_cd
2037: AND unit_version_number = p_version_number;
2038: v_unit_media_id igs_ps_unit_facility.unit_media_id%TYPE;
2039: BEGIN
2040:
2041: FOR c_unit_fac_rec IN c_unit_fac_det
2042: LOOP

Line 2044: igs_ps_unit_facility_pkg.Insert_Row(

2040:
2041: FOR c_unit_fac_rec IN c_unit_fac_det
2042: LOOP
2043: x_rowid := NULL;
2044: igs_ps_unit_facility_pkg.Insert_Row(
2045: x_rowid => x_rowid,
2046: x_unit_media_id => v_unit_media_id,
2047: x_unit_code => p_new_unit_cd,
2048: x_unit_version_number => p_new_version_number,