APPS.IGS_HE_UT_CALC_LVL_PKG dependencies on IGS_HE_UT_CALC_LVL

Line 1: PACKAGE BODY igs_he_ut_calc_lvl_pkg AS

1: PACKAGE BODY igs_he_ut_calc_lvl_pkg AS
2: /* $Header: IGSWI34B.pls 115.1 2003/09/02 15:31:18 smaddali noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_ut_calc_lvl%ROWTYPE;

Line 5: old_references igs_he_ut_calc_lvl%ROWTYPE;

1: PACKAGE BODY igs_he_ut_calc_lvl_pkg AS
2: /* $Header: IGSWI34B.pls 115.1 2003/09/02 15:31:18 smaddali noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_ut_calc_lvl%ROWTYPE;
6: new_references igs_he_ut_calc_lvl%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_he_ut_calc_lvl%ROWTYPE;

2: /* $Header: IGSWI34B.pls 115.1 2003/09/02 15:31:18 smaddali noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_ut_calc_lvl%ROWTYPE;
6: new_references igs_he_ut_calc_lvl%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 32: FROM igs_he_ut_calc_lvl

28: */
29:
30: CURSOR cur_old_ref_values IS
31: SELECT *
32: FROM igs_he_ut_calc_lvl
33: WHERE rowid = x_rowid;
34:
35: BEGIN
36:

Line 115: FROM igs_he_ut_calc_lvl

111: || (reverse chronological order - newest change first)
112: */
113: CURSOR cur_rowid IS
114: SELECT rowid
115: FROM igs_he_ut_calc_lvl
116: WHERE tariff_calc_type_cd = x_tariff_calc_type_cd
117: AND tariff_level_cd = x_tariff_level_cd ;
118:
119: lv_rowid cur_rowid%RowType;

Line 242: fnd_message.set_token ('ROUTINE', 'IGS_HE_UT_CALC_LVL_PKG.INSERT_ROW');

238: x_last_update_login := -1;
239: END IF;
240: ELSE
241: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
242: fnd_message.set_token ('ROUTINE', 'IGS_HE_UT_CALC_LVL_PKG.INSERT_ROW');
243: igs_ge_msg_stack.add;
244: app_exception.raise_exception;
245: END IF;
246:

Line 261: INSERT INTO igs_he_ut_calc_lvl (

257: x_last_update_login => x_last_update_login
258: );
259:
260:
261: INSERT INTO igs_he_ut_calc_lvl (
262: tariff_calc_type_cd,
263: tariff_level_cd,
264: closed_ind,
265: creation_date,

Line 302: FROM igs_he_ut_calc_lvl

298: */
299: CURSOR c1 IS
300: SELECT
301: closed_ind
302: FROM igs_he_ut_calc_lvl
303: WHERE rowid = x_rowid
304: FOR UPDATE NOWAIT;
305:
306: tlinfo c1%ROWTYPE;

Line 373: fnd_message.set_token ('ROUTINE', 'IGS_HE_UT_CALC_LVL_PKG.UPDATE_ROW');

369: x_last_update_login := -1;
370: END IF;
371: ELSE
372: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
373: fnd_message.set_token ('ROUTINE', 'IGS_HE_UT_CALC_LVL_PKG.UPDATE_ROW');
374: igs_ge_msg_stack.add;
375: app_exception.raise_exception;
376: END IF;
377:

Line 391: UPDATE igs_he_ut_calc_lvl

387: x_last_updated_by => x_last_updated_by,
388: x_last_update_login => x_last_update_login
389: );
390:
391: UPDATE igs_he_ut_calc_lvl
392: SET
393: closed_ind = new_references.closed_ind,
394: last_update_date = x_last_update_date,
395: last_updated_by = x_last_updated_by,

Line 424: FROM igs_he_ut_calc_lvl

420: || (reverse chronological order - newest change first)
421: */
422: CURSOR c1 IS
423: SELECT rowid
424: FROM igs_he_ut_calc_lvl
425: WHERE tariff_calc_type_cd = x_tariff_calc_type_cd
426: AND tariff_level_cd = x_tariff_level_cd;
427:
428: BEGIN

Line 460: END igs_he_ut_calc_lvl_pkg;

456:
457:
458:
459:
460: END igs_he_ut_calc_lvl_pkg;