APPS.IGS_EN_UNIT_SET_PKG dependencies on IGS_EN_UNIT_SET_STAT

Line 26: igs_en_unit_set_stat uss

22: cp_n_version_number igs_en_unit_set_all.version_number%TYPE)
23: IS
24: SELECT 'x'
25: FROM igs_en_unit_set_all usv,
26: igs_en_unit_set_stat uss
27: WHERE usv.unit_set_status = uss.unit_set_status
28: AND uss.s_unit_set_status = 'PLANNED'
29: AND usv.unit_set_cd = cp_c_unit_set_cd
30: AND usv.version_number = cp_n_version_number;

Line 60: CURSOR cur_get_status (cp_c_unit_set_status igs_en_unit_set_stat.unit_set_status%TYPE)

56: --
57: --Change History:
58: --Who When What
59: -------------------------------------------------------------------
60: CURSOR cur_get_status (cp_c_unit_set_status igs_en_unit_set_stat.unit_set_status%TYPE)
61: IS
62: SELECT s_unit_set_status
63: FROM igs_en_unit_set_stat
64: WHERE unit_set_status = cp_c_unit_set_status;

Line 63: FROM igs_en_unit_set_stat

59: -------------------------------------------------------------------
60: CURSOR cur_get_status (cp_c_unit_set_status igs_en_unit_set_stat.unit_set_status%TYPE)
61: IS
62: SELECT s_unit_set_status
63: FROM igs_en_unit_set_stat
64: WHERE unit_set_status = cp_c_unit_set_status;
65:
66: l_c_sys_status igs_en_unit_set_stat.s_unit_set_status%TYPE;
67:

Line 66: l_c_sys_status igs_en_unit_set_stat.s_unit_set_status%TYPE;

62: SELECT s_unit_set_status
63: FROM igs_en_unit_set_stat
64: WHERE unit_set_status = cp_c_unit_set_status;
65:
66: l_c_sys_status igs_en_unit_set_stat.s_unit_set_status%TYPE;
67:
68: CURSOR cur_check_update (cp_c_unit_set_cd igs_en_unit_set_all.unit_set_cd%TYPE,
69: cp_n_version_number igs_en_unit_set_all.version_number%TYPE)
70: IS

Line 73: igs_en_unit_set_stat uss

69: cp_n_version_number igs_en_unit_set_all.version_number%TYPE)
70: IS
71: SELECT 'x'
72: FROM igs_en_unit_set_all usv,
73: igs_en_unit_set_stat uss
74: WHERE usv.unit_set_status=uss.unit_set_status
75: AND uss.s_unit_set_status <> 'PLANNED'
76: AND usv.unit_set_cd = cp_c_unit_set_cd
77: AND usv.version_number = cp_n_version_number;

Line 554: IF NOT IGS_EN_UNIT_SET_STAT_PKG.Get_PK_For_Validation (

550: IF (((old_references.UNIT_SET_STATUS = new_references.UNIT_SET_STATUS)) OR
551: ((new_references.UNIT_SET_STATUS IS NULL))) THEN
552: NULL;
553: ELSE
554: IF NOT IGS_EN_UNIT_SET_STAT_PKG.Get_PK_For_Validation (
555: new_references.UNIT_SET_STATUS
556: ) THEN
557:
558: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

Line 718: igs_en_unit_set_stat uss

714:
715: CURSOR cur_get_status IS
716: SELECT uss.s_unit_set_status
717: FROM igs_en_unit_set_all usv,
718: igs_en_unit_set_stat uss
719: WHERE usv.unit_set_status = uss.unit_set_status
720: AND usv.unit_set_cd = x_unit_set_cd
721: AND usv.version_number = x_version_number;
722:

Line 723: l_c_unit_set_status igs_en_unit_set_stat.s_unit_set_status%TYPE;

719: WHERE usv.unit_set_status = uss.unit_set_status
720: AND usv.unit_set_cd = x_unit_set_cd
721: AND usv.version_number = x_version_number;
722:
723: l_c_unit_set_status igs_en_unit_set_stat.s_unit_set_status%TYPE;
724:
725: CURSOR cur_rowid IS
726: SELECT rowid
727: FROM IGS_EN_UNIT_SET_ALL

Line 814: PROCEDURE GET_FK_IGS_EN_UNIT_SET_STAT (

810: Close cur_rowid;
811:
812: END GET_FK_IGS_EN_UNIT_SET_CAT;
813:
814: PROCEDURE GET_FK_IGS_EN_UNIT_SET_STAT (
815: x_unit_set_status IN VARCHAR2
816: ) as
817:
818: CURSOR cur_rowid IS

Line 837: END GET_FK_IGS_EN_UNIT_SET_STAT;

833: App_Exception.Raise_Exception;
834: Return;
835: END IF;
836: Close cur_rowid;
837: END GET_FK_IGS_EN_UNIT_SET_STAT;
838:
839:
840: PROCEDURE Before_DML (
841: p_action IN VARCHAR2,