eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_EN_ELGB_OVR_UOO_PKG dependencies on IGS_EN_ELGB_OVR

Line 1: PACKAGE BODY igs_en_elgb_ovr_uoo_pkg AS

1: PACKAGE BODY igs_en_elgb_ovr_uoo_pkg AS
2: /* $Header: IGSEI69B.pls 120.10 2006/05/25 10:29:50 amuthu ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_elgb_ovr_uoo%ROWTYPE;

Line 5: old_references igs_en_elgb_ovr_uoo%ROWTYPE;

1: PACKAGE BODY igs_en_elgb_ovr_uoo_pkg AS
2: /* $Header: IGSEI69B.pls 120.10 2006/05/25 10:29:50 amuthu ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_elgb_ovr_uoo%ROWTYPE;
6: new_references igs_en_elgb_ovr_uoo%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_en_elgb_ovr_uoo%ROWTYPE;

2: /* $Header: IGSEI69B.pls 120.10 2006/05/25 10:29:50 amuthu ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_elgb_ovr_uoo%ROWTYPE;
6: new_references igs_en_elgb_ovr_uoo%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 35: FROM igs_en_elgb_ovr_uoo

31: */
32:
33: CURSOR cur_old_ref_values IS
34: SELECT *
35: FROM igs_en_elgb_ovr_uoo
36: WHERE rowid = x_rowid;
37:
38: BEGIN
39:

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 1036: FROM igs_en_elgb_ovr_uoo

1032: */
1033:
1034: CURSOR cur_rowid IS
1035: SELECT rowid
1036: FROM igs_en_elgb_ovr_uoo
1037: WHERE ((elgb_ovr_step_id = x_elgb_ovr_step_id ));
1038:
1039: lv_rowid cur_rowid%RowType;
1040:

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 1145: FROM igs_en_elgb_ovr_uoo

1141: || (reverse chronological order - newest change first)
1142: */
1143: CURSOR cur_rowid IS
1144: SELECT rowid
1145: FROM igs_en_elgb_ovr_uoo
1146: WHERE elgb_ovr_step_uoo_id = x_elgb_ovr_step_uoo_id
1147: FOR UPDATE NOWAIT;
1148:
1149: lv_rowid cur_rowid%RowType;

Line 1183: FROM igs_en_elgb_ovr_uoo

1179: || (reverse chronological order - newest change first)
1180: */
1181: CURSOR cur_rowid IS
1182: SELECT rowid
1183: FROM igs_en_elgb_ovr_uoo
1184: WHERE elgb_ovr_step_id = x_elgb_ovr_step_id
1185: AND unit_cd = x_unit_cd
1186: AND version_number = x_version_number
1187: AND ( uoo_id = x_uoo_id or ( x_uoo_id IS NULL AND uoo_id = -1))

Line 1342: fnd_message.set_token ('ROUTINE', 'IGS_EN_ELGB_OVR_UOO_PKG.INSERT_ROW');

1338: x_last_update_login := -1;
1339: END IF;
1340: ELSE
1341: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
1342: fnd_message.set_token ('ROUTINE', 'IGS_EN_ELGB_OVR_UOO_PKG.INSERT_ROW');
1343: igs_ge_msg_stack.add;
1344: app_exception.raise_exception;
1345: END IF;
1346:

Line 1369: INSERT INTO igs_en_elgb_ovr_uoo (

1365: IF new_references.uoo_id IS NULL THEN
1366: new_references.uoo_id := -1 ;
1367: END IF ;
1368:
1369: INSERT INTO igs_en_elgb_ovr_uoo (
1370: elgb_ovr_step_uoo_id,
1371: elgb_ovr_step_id,
1372: unit_cd,
1373: version_number,

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,

Line 1428: FROM igs_en_elgb_ovr_uoo

1424: unit_cd,
1425: version_number,
1426: uoo_id,
1427: step_override_limit
1428: FROM igs_en_elgb_ovr_uoo
1429: WHERE rowid = x_rowid
1430: FOR UPDATE NOWAIT;
1431:
1432: tlinfo c1%ROWTYPE;

Line 1506: fnd_message.set_token ('ROUTINE', 'IGS_EN_ELGB_OVR_UOO_PKG.UPDATE_ROW');

1502: x_last_update_login := -1;
1503: END IF;
1504: ELSE
1505: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1506: fnd_message.set_token ('ROUTINE', 'IGS_EN_ELGB_OVR_UOO_PKG.UPDATE_ROW');
1507: igs_ge_msg_stack.add;
1508: app_exception.raise_exception;
1509: END IF;
1510:

Line 1533: UPDATE igs_en_elgb_ovr_uoo

1529: IF new_references.uoo_id IS NULL THEN
1530: new_references.uoo_id := -1 ;
1531: END IF ;
1532:
1533: UPDATE igs_en_elgb_ovr_uoo
1534: SET
1535: elgb_ovr_step_id = new_references.elgb_ovr_step_id,
1536: unit_cd = new_references.unit_cd,
1537: version_number = new_references.version_number,

Line 1577: FROM igs_en_elgb_ovr_uoo

1573: || (reverse chronological order - newest change first)
1574: */
1575: CURSOR c1 IS
1576: SELECT rowid
1577: FROM igs_en_elgb_ovr_uoo
1578: WHERE elgb_ovr_step_uoo_id = x_elgb_ovr_step_uoo_id;
1579:
1580: BEGIN
1581:

Line 1634: DELETE FROM igs_en_elgb_ovr_uoo

1630: p_action => 'DELETE',
1631: x_rowid => x_rowid
1632: );
1633:
1634: DELETE FROM igs_en_elgb_ovr_uoo
1635: WHERE rowid = x_rowid;
1636:
1637: IF (SQL%NOTFOUND) THEN
1638: RAISE NO_DATA_FOUND;

Line 1647: END igs_en_elgb_ovr_uoo_pkg;

1643: x_rowid => X_ROWID );
1644:
1645: END delete_row;
1646:
1647: END igs_en_elgb_ovr_uoo_pkg;