APPS.IGS_HE_UT_PRS_CALCS_PKG dependencies on IGS_HE_UT_PRS_CALCS

Line 1: PACKAGE BODY igs_he_ut_prs_calcs_pkg AS

1: PACKAGE BODY igs_he_ut_prs_calcs_pkg AS
2: /* $Header: IGSWI39B.pls 120.2 2005/07/03 18:44:45 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_ut_prs_calcs%ROWTYPE;

Line 5: old_references igs_he_ut_prs_calcs%ROWTYPE;

1: PACKAGE BODY igs_he_ut_prs_calcs_pkg AS
2: /* $Header: IGSWI39B.pls 120.2 2005/07/03 18:44:45 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_ut_prs_calcs%ROWTYPE;
6: new_references igs_he_ut_prs_calcs%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_he_ut_prs_calcs%ROWTYPE;

2: /* $Header: IGSWI39B.pls 120.2 2005/07/03 18:44:45 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_ut_prs_calcs%ROWTYPE;
6: new_references igs_he_ut_prs_calcs%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 32: FROM igs_he_ut_prs_calcs

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

Line 109: igs_he_ut_prs_dtls_pkg.get_fk_igs_he_ut_prs_calcs (

105: || (reverse chronological order - newest change first)
106: */
107: BEGIN
108:
109: igs_he_ut_prs_dtls_pkg.get_fk_igs_he_ut_prs_calcs (
110: old_references.tariff_calc_type_cd ,
111: old_references.person_id
112: );
113:

Line 131: FROM igs_he_ut_prs_calcs

127: || (reverse chronological order - newest change first)
128: */
129: CURSOR cur_rowid IS
130: SELECT rowid
131: FROM igs_he_ut_prs_calcs
132: WHERE tariff_calc_type_cd = x_tariff_calc_type_cd
133: AND person_id = x_person_id
134: FOR UPDATE NOWAIT;
135:

Line 266: fnd_message.set_token ('ROUTINE', 'IGS_HE_UT_PRS_CALCS_PKG.INSERT_ROW');

262: x_last_update_login := -1;
263: END IF;
264: ELSE
265: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
266: fnd_message.set_token ('ROUTINE', 'IGS_HE_UT_PRS_CALCS_PKG.INSERT_ROW');
267: igs_ge_msg_stack.add;
268: app_exception.raise_exception;
269: END IF;
270:

Line 287: INSERT INTO igs_he_ut_prs_calcs (

283:
284: IF (x_mode = 'S') THEN
285: igs_sc_gen_001.set_ctx('R');
286: END IF;
287: INSERT INTO igs_he_ut_prs_calcs (
288: tariff_calc_type_cd,
289: person_id,
290: calc_date,
291: creation_date,

Line 347: FROM igs_he_ut_prs_calcs

343: */
344: CURSOR c1 IS
345: SELECT
346: calc_date
347: FROM igs_he_ut_prs_calcs
348: WHERE rowid = x_rowid
349: FOR UPDATE NOWAIT;
350:
351: tlinfo c1%ROWTYPE;

Line 418: fnd_message.set_token ('ROUTINE', 'IGS_HE_UT_PRS_CALCS_PKG.UPDATE_ROW');

414: x_last_update_login := -1;
415: END IF;
416: ELSE
417: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
418: fnd_message.set_token ('ROUTINE', 'IGS_HE_UT_PRS_CALCS_PKG.UPDATE_ROW');
419: igs_ge_msg_stack.add;
420: app_exception.raise_exception;
421: END IF;
422:

Line 439: UPDATE igs_he_ut_prs_calcs

435:
436: IF (x_mode = 'S') THEN
437: igs_sc_gen_001.set_ctx('R');
438: END IF;
439: UPDATE igs_he_ut_prs_calcs
440: SET
441: calc_date = new_references.calc_date,
442: last_update_date = x_last_update_date,
443: last_updated_by = x_last_updated_by,

Line 494: FROM igs_he_ut_prs_calcs

490: || (reverse chronological order - newest change first)
491: */
492: CURSOR c1 IS
493: SELECT rowid
494: FROM igs_he_ut_prs_calcs
495: WHERE tariff_calc_type_cd = x_tariff_calc_type_cd
496: AND person_id = x_person_id;
497:
498: BEGIN

Line 550: DELETE FROM igs_he_ut_prs_calcs

546:
547: IF (x_mode = 'S') THEN
548: igs_sc_gen_001.set_ctx('R');
549: END IF;
550: DELETE FROM igs_he_ut_prs_calcs
551: WHERE rowid = x_rowid;
552:
553: IF (SQL%NOTFOUND) THEN
554: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

Line 569: END igs_he_ut_prs_calcs_pkg;

565:
566: END delete_row;
567:
568:
569: END igs_he_ut_prs_calcs_pkg;