APPS.IGS_EN_ELGB_OVR_UOO_PKG dependencies on IGS_EN_ELGB_OVR_UOO

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 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 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 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;