APPS.IGS_EN_ELGB_OVR_UOO_PKG dependencies on IGS_EN_ELGB_OVR_STEP

Line 128: FROM igs_en_elgb_ovr eo ,igs_en_elgb_ovr_step eos

124: uoo.uoo_id = cp_uoo_id;
125:
126: CURSOR cur_step_cal IS
127: SELECT person_id,cal_type,ci_sequence_number
128: FROM igs_en_elgb_ovr eo ,igs_en_elgb_ovr_step eos
129: WHERE eos.elgb_override_id = eo.elgb_override_id AND
130: eos.elgb_ovr_step_id = new_references.elgb_ovr_step_id;
131:
132: l_cur_step_cal_rec cur_step_cal%ROWTYPE;

Line 951: FROM igs_en_elgb_ovr_step eos

947: ) AS
948:
949: CURSOR get_step_type is
950: SELECT eos.step_override_type
951: FROM igs_en_elgb_ovr_step eos
952: WHERE eos.elgb_ovr_step_id = NEW_REFERENCES.elgb_ovr_step_id ;
953:
954: l_step_override_type igs_en_elgb_ovr_step.step_override_type%TYPE := NULL;
955:

Line 954: l_step_override_type igs_en_elgb_ovr_step.step_override_type%TYPE := NULL;

950: SELECT eos.step_override_type
951: FROM igs_en_elgb_ovr_step eos
952: WHERE eos.elgb_ovr_step_id = NEW_REFERENCES.elgb_ovr_step_id ;
953:
954: l_step_override_type igs_en_elgb_ovr_step.step_override_type%TYPE := NULL;
955:
956: BEGIN
957:
958: IF p_inserting OR p_updating THEN

Line 985: ELSIF NOT igs_en_elgb_ovr_step_pkg.get_pk_for_validation (

981:
982: IF (((old_references.elgb_ovr_step_id = new_references.elgb_ovr_step_id)) OR
983: ((new_references.elgb_ovr_step_id IS NULL))) THEN
984: NULL;
985: ELSIF NOT igs_en_elgb_ovr_step_pkg.get_pk_for_validation (
986: new_references.elgb_ovr_step_id
987: ) THEN
988: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
989: igs_ge_msg_stack.add;

Line 1021: PROCEDURE get_fk_igs_en_elgb_ovr_step (

1017:
1018: END check_parent_existance;
1019:
1020:
1021: PROCEDURE get_fk_igs_en_elgb_ovr_step (
1022: x_elgb_ovr_step_id IN NUMBER
1023: ) AS
1024: /*
1025: || Created By : [email protected]

Line 1054: END get_fk_igs_en_elgb_ovr_step;

1050: RETURN;
1051: END IF;
1052: CLOSE cur_rowid;
1053:
1054: END get_fk_igs_en_elgb_ovr_step;
1055:
1056:
1057: PROCEDURE get_ufk_igs_ps_unit_ofr_opt (
1058: x_uoo_id IN NUMBER

Line 1072: FROM igs_en_elgb_ovr_step

1068: */
1069:
1070: CURSOR cur_rowid IS
1071: SELECT rowid
1072: FROM igs_en_elgb_ovr_step
1073: WHERE ((uoo_id = x_uoo_id));
1074:
1075: lv_rowid cur_rowid%RowType;
1076:

Line 1109: FROM igs_en_elgb_ovr_step

1105: */
1106:
1107: CURSOR cur_rowid IS
1108: SELECT rowid
1109: FROM igs_en_elgb_ovr_step
1110: WHERE ((unit_cd = x_unit_cd) AND
1111: (version_number = x_version_number));
1112:
1113: lv_rowid cur_rowid%RowType;

Line 1382: igs_en_elgb_ovr_step_uoo_s.NEXTVAL,

1378: last_update_date,
1379: last_updated_by,
1380: last_update_login
1381: ) VALUES (
1382: igs_en_elgb_ovr_step_uoo_s.NEXTVAL,
1383: new_references.elgb_ovr_step_id,
1384: new_references.unit_cd,
1385: new_references.version_number,
1386: new_references.uoo_id,