APPS.IGS_FI_A_HIERARCHIES_PKG dependencies on IGS_FI_A_HIERARCHIES

Line 1: PACKAGE BODY igs_fi_a_hierarchies_pkg AS

1: PACKAGE BODY igs_fi_a_hierarchies_pkg AS
2: /* $Header: IGSSI89B.pls 120.1 2005/09/22 03:37:17 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_a_hierarchies%ROWTYPE;

Line 5: old_references igs_fi_a_hierarchies%ROWTYPE;

1: PACKAGE BODY igs_fi_a_hierarchies_pkg AS
2: /* $Header: IGSSI89B.pls 120.1 2005/09/22 03:37:17 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_a_hierarchies%ROWTYPE;
6: new_references igs_fi_a_hierarchies%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_fi_a_hierarchies%ROWTYPE;

2: /* $Header: IGSSI89B.pls 120.1 2005/09/22 03:37:17 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_a_hierarchies%ROWTYPE;
6: new_references igs_fi_a_hierarchies%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 35: FROM IGS_FI_A_HIERARCHIES

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

Line 114: igs_fi_applications_pkg.get_fk_igs_fi_a_hierarchies (

110: || (reverse chronological order - newest change first)
111: */
112: BEGIN
113:
114: igs_fi_applications_pkg.get_fk_igs_fi_a_hierarchies (
115: old_references.appl_hierarchy_id
116: );
117:
118: igs_fi_app_rules_pkg.get_fk_igs_fi_a_hierarchies (

Line 118: igs_fi_app_rules_pkg.get_fk_igs_fi_a_hierarchies (

114: igs_fi_applications_pkg.get_fk_igs_fi_a_hierarchies (
115: old_references.appl_hierarchy_id
116: );
117:
118: igs_fi_app_rules_pkg.get_fk_igs_fi_a_hierarchies (
119: old_references.appl_hierarchy_id
120: );
121:
122: END check_child_existance;

Line 140: FROM igs_fi_a_hierarchies

136: || vvutukur 30-Dec-2002 Bug#2725955.Removed FOR UPDATE from cursor cur_rowid.
137: */
138: CURSOR cur_rowid IS
139: SELECT rowid
140: FROM igs_fi_a_hierarchies
141: WHERE appl_hierarchy_id = x_appl_hierarchy_id;
142:
143: lv_rowid cur_rowid%RowType;
144:

Line 175: FROM igs_fi_a_hierarchies

171: || (reverse chronological order - newest change first)
172: */
173: CURSOR cur_rowid IS
174: SELECT rowid
175: FROM igs_fi_a_hierarchies
176: WHERE hierarchy_name = x_hierarchy_name
177: AND version_number = x_version_number
178: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
179:

Line 298: FROM igs_fi_a_hierarchies

294: || (reverse chronological order - newest change first)
295: */
296: CURSOR c IS
297: SELECT rowid
298: FROM igs_fi_a_hierarchies
299: WHERE appl_hierarchy_id = x_appl_hierarchy_id;
300:
301: x_last_update_date DATE;
302: x_last_updated_by NUMBER;

Line 326: SELECT igs_fi_a_hierarchies_s.NEXTVAL

322: igs_ge_msg_stack.add;
323: app_exception.raise_exception;
324: END IF;
325:
326: SELECT igs_fi_a_hierarchies_s.NEXTVAL
327: INTO x_appl_hierarchy_id
328: FROM dual;
329:
330: before_dml(

Line 346: INSERT INTO igs_fi_a_hierarchies (

342: x_last_updated_by => x_last_updated_by,
343: x_last_update_login => x_last_update_login
344: );
345:
346: INSERT INTO igs_fi_a_hierarchies (
347: appl_hierarchy_id,
348: hierarchy_name,
349: version_number,
350: effective_start_date,

Line 408: FROM igs_fi_a_hierarchies

404: version_number,
405: effective_start_date,
406: effective_end_date,
407: description
408: FROM igs_fi_a_hierarchies
409: WHERE rowid = x_rowid
410: FOR UPDATE NOWAIT;
411:
412: tlinfo c1%ROWTYPE;

Line 506: UPDATE igs_fi_a_hierarchies

502: x_last_updated_by => x_last_updated_by,
503: x_last_update_login => x_last_update_login
504: );
505:
506: UPDATE igs_fi_a_hierarchies
507: SET
508: hierarchy_name = new_references.hierarchy_name,
509: version_number = new_references.version_number,
510: effective_start_date = new_references.effective_start_date,

Line 546: FROM igs_fi_a_hierarchies

542: || (reverse chronological order - newest change first)
543: */
544: CURSOR c1 IS
545: SELECT rowid
546: FROM igs_fi_a_hierarchies
547: WHERE appl_hierarchy_id = x_appl_hierarchy_id;
548:
549: BEGIN
550:

Line 603: DELETE FROM igs_fi_a_hierarchies

599: p_action => 'DELETE',
600: x_rowid => x_rowid
601: );
602:
603: DELETE FROM igs_fi_a_hierarchies
604: WHERE rowid = x_rowid;
605:
606: IF (SQL%NOTFOUND) THEN
607: RAISE NO_DATA_FOUND;

Line 613: END igs_fi_a_hierarchies_pkg;

609:
610: END delete_row;
611:
612:
613: END igs_fi_a_hierarchies_pkg;