DBA Data[Home] [Help]

APPS.IGS_PS_GEN_008 dependencies on IGS_PS_UNIT_CROS_REF

Line 2075: FROM igs_ps_unit_cros_ref

2071: p_version_number IN igs_ps_unit_ver.version_number%TYPE )
2072: AS
2073: CURSOR c_unit_cros_ref_det IS
2074: SELECT *
2075: FROM igs_ps_unit_cros_ref
2076: WHERE parent_unit_code = p_unit_cd
2077: AND parent_unit_version_number = p_version_number;
2078: v_unit_cross_reference_id igs_ps_unit_cros_ref.unit_cross_reference_id%TYPE;
2079: BEGIN

Line 2078: v_unit_cross_reference_id igs_ps_unit_cros_ref.unit_cross_reference_id%TYPE;

2074: SELECT *
2075: FROM igs_ps_unit_cros_ref
2076: WHERE parent_unit_code = p_unit_cd
2077: AND parent_unit_version_number = p_version_number;
2078: v_unit_cross_reference_id igs_ps_unit_cros_ref.unit_cross_reference_id%TYPE;
2079: BEGIN
2080:
2081: FOR c_unit_cros_ref_rec IN c_unit_cros_ref_det
2082: LOOP

Line 2084: igs_ps_unit_cros_ref_pkg.Insert_Row(

2080:
2081: FOR c_unit_cros_ref_rec IN c_unit_cros_ref_det
2082: LOOP
2083: x_rowid := NULL;
2084: igs_ps_unit_cros_ref_pkg.Insert_Row(
2085: x_rowid => x_rowid,
2086: x_unit_cross_reference_id => v_unit_cross_reference_id,
2087: x_parent_unit_code => p_new_unit_cd,
2088: x_parent_unit_version_number => p_new_version_number,