APPS.IGS_HE_UT_LVL_AWARD_PKG dependencies on IGS_HE_UT_LVL_AWARD

Line 1: PACKAGE BODY igs_he_ut_lvl_award_pkg AS

1: PACKAGE BODY igs_he_ut_lvl_award_pkg AS
2: /* $Header: IGSWI35B.pls 115.0 2003/02/14 15:59:36 bayadav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_ut_lvl_award%ROWTYPE;

Line 5: old_references igs_he_ut_lvl_award%ROWTYPE;

1: PACKAGE BODY igs_he_ut_lvl_award_pkg AS
2: /* $Header: IGSWI35B.pls 115.0 2003/02/14 15:59:36 bayadav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_ut_lvl_award%ROWTYPE;
6: new_references igs_he_ut_lvl_award%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_he_ut_lvl_award%ROWTYPE;

2: /* $Header: IGSWI35B.pls 115.0 2003/02/14 15:59:36 bayadav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_ut_lvl_award%ROWTYPE;
6: new_references igs_he_ut_lvl_award%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 34: FROM igs_he_ut_lvl_award

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

Line 132: FROM igs_he_ut_lvl_award

128: || (reverse chronological order - newest change first)
129: */
130: CURSOR cur_rowid IS
131: SELECT rowid
132: FROM igs_he_ut_lvl_award
133: WHERE tariff_calc_type_cd = x_tariff_calc_type_cd
134: AND tariff_level_cd = x_tariff_level_cd
135: AND award_cd = x_award_cd ;
136:

Line 272: fnd_message.set_token ('ROUTINE', 'IGS_HE_UT_LVL_AWARD_PKG.INSERT_ROW');

268: x_last_update_login := -1;
269: END IF;
270: ELSE
271: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
272: fnd_message.set_token ('ROUTINE', 'IGS_HE_UT_LVL_AWARD_PKG.INSERT_ROW');
273: igs_ge_msg_stack.add;
274: app_exception.raise_exception;
275: END IF;
276:

Line 292: INSERT INTO igs_he_ut_lvl_award (

288: x_last_updated_by => x_last_updated_by,
289: x_last_update_login => x_last_update_login
290: );
291:
292: INSERT INTO igs_he_ut_lvl_award (
293: tariff_calc_type_cd,
294: tariff_level_cd,
295: award_cd,
296: default_award_ind,

Line 340: FROM igs_he_ut_lvl_award

336: CURSOR c1 IS
337: SELECT
338: default_award_ind,
339: closed_ind
340: FROM igs_he_ut_lvl_award
341: WHERE rowid = x_rowid
342: FOR UPDATE NOWAIT;
343:
344: tlinfo c1%ROWTYPE;

Line 414: fnd_message.set_token ('ROUTINE', 'IGS_HE_UT_LVL_AWARD_PKG.UPDATE_ROW');

410: x_last_update_login := -1;
411: END IF;
412: ELSE
413: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
414: fnd_message.set_token ('ROUTINE', 'IGS_HE_UT_LVL_AWARD_PKG.UPDATE_ROW');
415: igs_ge_msg_stack.add;
416: app_exception.raise_exception;
417: END IF;
418:

Line 434: UPDATE igs_he_ut_lvl_award

430: x_last_updated_by => x_last_updated_by,
431: x_last_update_login => x_last_update_login
432: );
433:
434: UPDATE igs_he_ut_lvl_award
435: SET
436: default_award_ind = new_references.default_award_ind,
437: closed_ind = new_references.closed_ind,
438: last_update_date = x_last_update_date,

Line 470: FROM igs_he_ut_lvl_award

466: || (reverse chronological order - newest change first)
467: */
468: CURSOR c1 IS
469: SELECT rowid
470: FROM igs_he_ut_lvl_award
471: WHERE tariff_calc_type_cd = x_tariff_calc_type_cd
472: AND tariff_level_cd = x_tariff_level_cd
473: AND award_cd = x_award_cd;
474:

Line 509: END igs_he_ut_lvl_award_pkg;

505: END add_row;
506:
507:
508:
509: END igs_he_ut_lvl_award_pkg;