APPS.IGS_PS_GEN_008 dependencies on IGS_PS_UNIT_LOCATION

Line 1993: FROM igs_ps_unit_location

1989: p_version_number IN igs_ps_unit_ver.version_number%TYPE )
1990: AS
1991: CURSOR c_unit_loc_det IS
1992: SELECT *
1993: FROM igs_ps_unit_location
1994: WHERE unit_code = p_unit_cd
1995: AND unit_version_number = p_version_number;
1996: v_unit_location_id igs_ps_unit_location.unit_location_id%TYPE;
1997: BEGIN

Line 1996: v_unit_location_id igs_ps_unit_location.unit_location_id%TYPE;

1992: SELECT *
1993: FROM igs_ps_unit_location
1994: WHERE unit_code = p_unit_cd
1995: AND unit_version_number = p_version_number;
1996: v_unit_location_id igs_ps_unit_location.unit_location_id%TYPE;
1997: BEGIN
1998:
1999: FOR c_unit_loc_rec IN c_unit_loc_det
2000: LOOP

Line 2002: igs_ps_unit_location_pkg.Insert_Row(

1998:
1999: FOR c_unit_loc_rec IN c_unit_loc_det
2000: LOOP
2001: x_rowid := NULL;
2002: igs_ps_unit_location_pkg.Insert_Row(
2003: x_rowid => x_rowid,
2004: x_unit_location_id => v_unit_location_id,
2005: x_unit_code => p_new_unit_cd,
2006: x_unit_version_number => p_new_version_number,