APPS.IGS_FI_ELM_RNG_ORDS_PKG dependencies on IGS_FI_ELM_RNG_ORDS

Line 1: PACKAGE BODY igs_fi_elm_rng_ords_pkg AS

1: PACKAGE BODY igs_fi_elm_rng_ords_pkg AS
2: /* $Header: IGSSIF3B.pls 120.0 2005/09/09 20:03:50 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_elm_rng_ords%ROWTYPE;

Line 5: old_references igs_fi_elm_rng_ords%ROWTYPE;

1: PACKAGE BODY igs_fi_elm_rng_ords_pkg AS
2: /* $Header: IGSSIF3B.pls 120.0 2005/09/09 20:03:50 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_elm_rng_ords%ROWTYPE;
6: new_references igs_fi_elm_rng_ords%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_fi_elm_rng_ords%ROWTYPE;

2: /* $Header: IGSSIF3B.pls 120.0 2005/09/09 20:03:50 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_elm_rng_ords%ROWTYPE;
6: new_references igs_fi_elm_rng_ords%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 33: FROM igs_fi_elm_rng_ords

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

Line 86: igs_fi_er_ord_dtls_pkg.get_fk_igs_fi_elm_rng_ords (

82: || (reverse chronological order - newest change first)
83: */
84: BEGIN
85:
86: igs_fi_er_ord_dtls_pkg.get_fk_igs_fi_elm_rng_ords (
87: old_references.elm_rng_order_name
88: );
89:
90: END check_child_existance;

Line 107: FROM igs_fi_elm_rng_ords

103: || (reverse chronological order - newest change first)
104: */
105: CURSOR cur_rowid IS
106: SELECT rowid
107: FROM igs_fi_elm_rng_ords
108: WHERE elm_rng_order_name = x_elm_rng_order_name
109: FOR UPDATE NOWAIT;
110:
111: lv_rowid cur_rowid%RowType;

Line 236: fnd_message.set_token ('ROUTINE', 'IGS_FI_ELM_RNG_ORDS_PKG.INSERT_ROW');

232: x_last_update_login := -1;
233: END IF;
234: ELSE
235: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
236: fnd_message.set_token ('ROUTINE', 'IGS_FI_ELM_RNG_ORDS_PKG.INSERT_ROW');
237: igs_ge_msg_stack.add;
238: app_exception.raise_exception;
239: END IF;
240:

Line 255: INSERT INTO igs_fi_elm_rng_ords (

251: x_last_updated_by => x_last_updated_by,
252: x_last_update_login => x_last_update_login
253: );
254:
255: INSERT INTO igs_fi_elm_rng_ords (
256: elm_rng_order_name,
257: elm_rng_order_desc,
258: elm_rng_order_attr_code,
259: closed_flag,

Line 301: FROM igs_fi_elm_rng_ords

297: SELECT
298: elm_rng_order_desc,
299: elm_rng_order_attr_code,
300: closed_flag
301: FROM igs_fi_elm_rng_ords
302: WHERE rowid = x_rowid
303: FOR UPDATE NOWAIT;
304:
305: tlinfo c1%ROWTYPE;

Line 375: fnd_message.set_token ('ROUTINE', 'IGS_FI_ELM_RNG_ORDS_PKG.UPDATE_ROW');

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

Line 394: UPDATE igs_fi_elm_rng_ords

390: x_last_updated_by => x_last_updated_by,
391: x_last_update_login => x_last_update_login
392: );
393:
394: UPDATE igs_fi_elm_rng_ords
395: SET
396: elm_rng_order_desc = new_references.elm_rng_order_desc,
397: elm_rng_order_attr_code = new_references.elm_rng_order_attr_code,
398: closed_flag = new_references.closed_flag,

Line 430: FROM igs_fi_elm_rng_ords

426: || (reverse chronological order - newest change first)
427: */
428: CURSOR c1 IS
429: SELECT rowid
430: FROM igs_fi_elm_rng_ords
431: WHERE elm_rng_order_name = x_elm_rng_order_name;
432:
433: BEGIN
434:

Line 483: DELETE FROM igs_fi_elm_rng_ords

479: p_action => 'DELETE',
480: x_rowid => x_rowid
481: );
482:
483: DELETE FROM igs_fi_elm_rng_ords
484: WHERE rowid = x_rowid;
485:
486: IF (SQL%NOTFOUND) THEN
487: RAISE NO_DATA_FOUND;

Line 493: END igs_fi_elm_rng_ords_pkg;

489:
490: END delete_row;
491:
492:
493: END igs_fi_elm_rng_ords_pkg;