APPS.IGR_I_ENTRY_LVLS_PKG dependencies on IGR_I_ENTRY_LVLS

Line 1: PACKAGE BODY igr_i_entry_lvls_pkg AS

1: PACKAGE BODY igr_i_entry_lvls_pkg AS
2: /* $Header: IGSRH01B.pls 120.0 2005/06/01 17:26:14 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igr_i_entry_lvls%ROWTYPE;

Line 5: old_references igr_i_entry_lvls%ROWTYPE;

1: PACKAGE BODY igr_i_entry_lvls_pkg AS
2: /* $Header: IGSRH01B.pls 120.0 2005/06/01 17:26:14 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igr_i_entry_lvls%ROWTYPE;
6: new_references igr_i_entry_lvls%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igr_i_entry_lvls%ROWTYPE;

2: /* $Header: IGSRH01B.pls 120.0 2005/06/01 17:26:14 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igr_i_entry_lvls%ROWTYPE;
6: new_references igr_i_entry_lvls%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 33: FROM IGR_I_ENTRY_LVLS

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

Line 109: igr_i_appl_pkg.get_fk_igr_i_entry_lvls (

105: || (reverse chronological order - newest change first)
106: */
107: BEGIN
108:
109: igr_i_appl_pkg.get_fk_igr_i_entry_lvls (
110: old_references.inq_entry_level_id
111: );
112: END check_child_existance;
113:

Line 130: FROM igr_i_entry_lvls

126: || (reverse chronological order - newest change first)
127: */
128: CURSOR cur_rowid IS
129: SELECT rowid
130: FROM igr_i_entry_lvls
131: WHERE inq_entry_level_id = x_inq_entry_level_id AND
132: closed_ind = NVL(x_closed_ind,closed_ind);
133:
134: lv_rowid cur_rowid%RowType;

Line 166: FROM igr_i_entry_lvls

162: || (reverse chronological order - newest change first)
163: */
164: CURSOR cur_rowid IS
165: SELECT rowid
166: FROM igr_i_entry_lvls
167: WHERE inq_entry_level = x_inq_entry_level
168: AND ((l_rowid IS NULL) OR (rowid <> l_rowid))
169: AND closed_ind = NVL(x_closed_ind,closed_ind);
170:

Line 283: FROM igr_i_entry_lvls

279: || (reverse chronological order - newest change first)
280: */
281: CURSOR c IS
282: SELECT rowid
283: FROM igr_i_entry_lvls
284: WHERE inq_entry_level_id = x_inq_entry_level_id;
285:
286: x_last_update_date DATE;
287: x_last_updated_by NUMBER;

Line 325: INSERT INTO igr_i_entry_lvls (

321: x_last_updated_by => x_last_updated_by,
322: x_last_update_login => x_last_update_login
323: );
324:
325: INSERT INTO igr_i_entry_lvls (
326: inq_entry_level_id,
327: inq_entry_level,
328: description,
329: closed_ind,

Line 336: IGR_I_ENTRY_LVLS_S.NEXTVAL,

332: last_update_date,
333: last_updated_by,
334: last_update_login
335: ) VALUES (
336: IGR_I_ENTRY_LVLS_S.NEXTVAL,
337: new_references.inq_entry_level,
338: new_references.description,
339: new_references.closed_ind,
340: x_last_update_date,

Line 379: FROM igr_i_entry_lvls

375: SELECT
376: inq_entry_level,
377: description,
378: closed_ind
379: FROM igr_i_entry_lvls
380: WHERE rowid = x_rowid
381: FOR UPDATE NOWAIT;
382:
383: tlinfo c1%ROWTYPE;

Line 471: UPDATE igr_i_entry_lvls

467: x_last_updated_by => x_last_updated_by,
468: x_last_update_login => x_last_update_login
469: );
470:
471: UPDATE igr_i_entry_lvls
472: SET
473: inq_entry_level = new_references.inq_entry_level,
474: description = new_references.description,
475: closed_ind = new_references.closed_ind,

Line 507: FROM igr_i_entry_lvls

503: || (reverse chronological order - newest change first)
504: */
505: CURSOR c1 IS
506: SELECT rowid
507: FROM igr_i_entry_lvls
508: WHERE inq_entry_level_id = x_inq_entry_level_id;
509:
510: BEGIN
511:

Line 560: DELETE FROM igr_i_entry_lvls

556: p_action => 'DELETE',
557: x_rowid => x_rowid
558: );
559:
560: DELETE FROM igr_i_entry_lvls
561: WHERE rowid = x_rowid;
562:
563: IF (SQL%NOTFOUND) THEN
564: RAISE NO_DATA_FOUND;

Line 570: END igr_i_entry_lvls_pkg;

566:
567: END delete_row;
568:
569:
570: END igr_i_entry_lvls_pkg;