APPS.IGS_FI_SUB_ELM_RNG_PKG dependencies on IGS_FI_SUB_ELM_RNG

Line 1: PACKAGE BODY igs_fi_sub_elm_rng_pkg AS

1: PACKAGE BODY igs_fi_sub_elm_rng_pkg AS
2: /* $Header: IGSSIF1B.pls 120.0 2005/09/09 18:47:06 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_sub_elm_rng%ROWTYPE;

Line 5: old_references igs_fi_sub_elm_rng%ROWTYPE;

1: PACKAGE BODY igs_fi_sub_elm_rng_pkg AS
2: /* $Header: IGSSIF1B.pls 120.0 2005/09/09 18:47:06 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_sub_elm_rng%ROWTYPE;
6: new_references igs_fi_sub_elm_rng%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_fi_sub_elm_rng%ROWTYPE;

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

Line 36: FROM igs_fi_sub_elm_rng

32: */
33:
34: CURSOR cur_old_ref_values IS
35: SELECT *
36: FROM igs_fi_sub_elm_rng
37: WHERE rowid = x_rowid;
38:
39: BEGIN
40:

Line 144: FROM igs_fi_sub_elm_rng

140: || (reverse chronological order - newest change first)
141: */
142: CURSOR cur_rowid IS
143: SELECT rowid
144: FROM igs_fi_sub_elm_rng
145: WHERE sub_er_id = x_sub_er_id
146: FOR UPDATE NOWAIT;
147:
148: lv_rowid cur_rowid%RowType;

Line 180: FROM igs_fi_sub_elm_rng

176: || (reverse chronological order - newest change first)
177: */
178: CURSOR cur_rowid IS
179: SELECT rowid
180: FROM igs_fi_sub_elm_rng
181: WHERE er_id = x_er_id
182: AND sub_range_num = x_sub_range_num
183: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
184:

Line 323: fnd_message.set_token ('ROUTINE', 'IGS_FI_SUB_ELM_RNG_PKG.INSERT_ROW');

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

Line 347: INSERT INTO igs_fi_sub_elm_rng (

343: x_last_updated_by => x_last_updated_by,
344: x_last_update_login => x_last_update_login
345: );
346:
347: INSERT INTO igs_fi_sub_elm_rng (
348: sub_er_id,
349: er_id,
350: sub_range_num,
351: sub_lower_range,

Line 361: igs_fi_sub_elm_rng_s.NEXTVAL,

357: last_update_date,
358: last_updated_by,
359: last_update_login
360: ) VALUES (
361: igs_fi_sub_elm_rng_s.NEXTVAL,
362: new_references.er_id,
363: new_references.sub_range_num,
364: new_references.sub_lower_range,
365: new_references.sub_upper_range,

Line 405: FROM igs_fi_sub_elm_rng

401: sub_lower_range,
402: sub_upper_range,
403: sub_chg_method_code,
404: logical_delete_date
405: FROM igs_fi_sub_elm_rng
406: WHERE rowid = x_rowid
407: FOR UPDATE NOWAIT;
408:
409: tlinfo c1%ROWTYPE;

Line 485: fnd_message.set_token ('ROUTINE', 'IGS_FI_SUB_ELM_RNG_PKG.UPDATE_ROW');

481: x_last_update_login := -1;
482: END IF;
483: ELSE
484: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
485: fnd_message.set_token ('ROUTINE', 'IGS_FI_SUB_ELM_RNG_PKG.UPDATE_ROW');
486: igs_ge_msg_stack.add;
487: app_exception.raise_exception;
488: END IF;
489:

Line 507: UPDATE igs_fi_sub_elm_rng

503: x_last_updated_by => x_last_updated_by,
504: x_last_update_login => x_last_update_login
505: );
506:
507: UPDATE igs_fi_sub_elm_rng
508: SET
509: er_id = new_references.er_id,
510: sub_range_num = new_references.sub_range_num,
511: sub_lower_range = new_references.sub_lower_range,

Line 549: FROM igs_fi_sub_elm_rng

545: || (reverse chronological order - newest change first)
546: */
547: CURSOR c1 IS
548: SELECT rowid
549: FROM igs_fi_sub_elm_rng
550: WHERE sub_er_id = x_sub_er_id;
551:
552: BEGIN
553:

Line 644: END igs_fi_sub_elm_rng_pkg;

640: END IF;
641: END IF;
642: END Check_Constraints;
643:
644: END igs_fi_sub_elm_rng_pkg;