APPS.IGS_HE_UT_CALC_TYPE_PKG dependencies on IGS_HE_UT_CALC_TYPE

Line 1: PACKAGE BODY igs_he_ut_calc_type_pkg AS

1: PACKAGE BODY igs_he_ut_calc_type_pkg AS
2: /* $Header: IGSWI33B.pls 120.0 2005/06/01 18:40:55 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_ut_calc_type%ROWTYPE;

Line 5: old_references igs_he_ut_calc_type%ROWTYPE;

1: PACKAGE BODY igs_he_ut_calc_type_pkg AS
2: /* $Header: IGSWI33B.pls 120.0 2005/06/01 18:40:55 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_ut_calc_type%ROWTYPE;
6: new_references igs_he_ut_calc_type%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_he_ut_calc_type%ROWTYPE;

2: /* $Header: IGSWI33B.pls 120.0 2005/06/01 18:40:55 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_ut_calc_type%ROWTYPE;
6: new_references igs_he_ut_calc_type%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 34: FROM igs_he_ut_calc_type

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

Line 88: igs_he_ut_excl_qals_pkg.get_fk_igs_he_ut_calc_type (

84: || (reverse chronological order - newest change first)
85: */
86: BEGIN
87:
88: igs_he_ut_excl_qals_pkg.get_fk_igs_he_ut_calc_type (
89: old_references.tariff_calc_type_cd
90: );
91:
92: END check_child_existance;

Line 110: FROM igs_he_ut_calc_type

106: || (reverse chronological order - newest change first)
107: */
108: CURSOR cur_rowid IS
109: SELECT rowid
110: FROM igs_he_ut_calc_type
111: WHERE tariff_calc_type_cd = x_tariff_calc_type_cd
112: AND closed_ind = NVL(x_closed_ind,closed_ind)
113: FOR UPDATE NOWAIT ;
114:

Line 148: FROM igs_he_ut_calc_type

144: */
145: -- get all open external calculation types
146: CURSOR cur_rowid IS
147: SELECT rowid
148: FROM igs_he_ut_calc_type
149: WHERE external_calc_ind = 'Y'
150: AND closed_ind = 'N'
151: AND ((l_rowid IS NULL) OR (rowid <> l_rowid)) ;
152:

Line 242: fnd_message.set_name('IGS','IGS_HE_UT_CALC_TYPE_EXISTS');

238: new_references.tariff_calc_type_cd,
239: NULL
240: )
241: ) THEN
242: fnd_message.set_name('IGS','IGS_HE_UT_CALC_TYPE_EXISTS');
243: fnd_message.set_token('CALCTYPE', new_references.tariff_calc_type_cd );
244: igs_ge_msg_stack.add;
245: app_exception.raise_exception;
246: END IF;

Line 261: fnd_message.set_name('IGS','IGS_HE_UT_CALC_TYPE_EXISTS');

257: new_references.tariff_calc_type_cd,
258: NULL
259: )
260: ) THEN
261: fnd_message.set_name('IGS','IGS_HE_UT_CALC_TYPE_EXISTS');
262: fnd_message.set_token('CALCTYPE', new_references.tariff_calc_type_cd );
263: igs_ge_msg_stack.add;
264: app_exception.raise_exception;
265: END IF;

Line 320: fnd_message.set_token ('ROUTINE', 'IGS_HE_UT_CALC_TYPE_PKG.INSERT_ROW');

316: x_last_update_login := -1;
317: END IF;
318: ELSE
319: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
320: fnd_message.set_token ('ROUTINE', 'IGS_HE_UT_CALC_TYPE_PKG.INSERT_ROW');
321: igs_ge_msg_stack.add;
322: app_exception.raise_exception;
323: END IF;
324:

Line 340: INSERT INTO igs_he_ut_calc_type (

336: x_last_update_login => x_last_update_login,
337: x_report_all_hierarchy_flag => x_report_all_hierarchy_flag
338: );
339:
340: INSERT INTO igs_he_ut_calc_type (
341: tariff_calc_type_cd,
342: tariff_calc_type_desc,
343: external_calc_ind,
344: closed_ind,

Line 392: FROM igs_he_ut_calc_type

388: tariff_calc_type_desc,
389: external_calc_ind,
390: closed_ind,
391: report_all_hierarchy_flag
392: FROM igs_he_ut_calc_type
393: WHERE rowid = x_rowid
394: FOR UPDATE NOWAIT;
395:
396: tlinfo c1%ROWTYPE;

Line 468: fnd_message.set_token ('ROUTINE', 'IGS_HE_UT_CALC_TYPE_PKG.UPDATE_ROW');

464: x_last_update_login := -1;
465: END IF;
466: ELSE
467: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
468: fnd_message.set_token ('ROUTINE', 'IGS_HE_UT_CALC_TYPE_PKG.UPDATE_ROW');
469: igs_ge_msg_stack.add;
470: app_exception.raise_exception;
471: END IF;
472:

Line 488: UPDATE igs_he_ut_calc_type

484: x_last_update_login => x_last_update_login,
485: x_report_all_hierarchy_flag => x_report_all_hierarchy_flag
486: );
487:
488: UPDATE igs_he_ut_calc_type
489: SET
490: tariff_calc_type_desc = new_references.tariff_calc_type_desc,
491: external_calc_ind = new_references.external_calc_ind,
492: closed_ind = new_references.closed_ind,

Line 528: FROM igs_he_ut_calc_type

524: || (reverse chronological order - newest change first)
525: */
526: CURSOR c1 IS
527: SELECT rowid
528: FROM igs_he_ut_calc_type
529: WHERE tariff_calc_type_cd = x_tariff_calc_type_cd;
530:
531: BEGIN
532:

Line 583: DELETE FROM igs_he_ut_calc_type

579: p_action => 'DELETE',
580: x_rowid => x_rowid
581: );
582:
583: DELETE FROM igs_he_ut_calc_type
584: WHERE rowid = x_rowid;
585:
586: IF (SQL%NOTFOUND) THEN
587: RAISE NO_DATA_FOUND;

Line 595: END igs_he_ut_calc_type_pkg;

591:
592: END delete_row;
593:
594:
595: END igs_he_ut_calc_type_pkg;