APPS.IGR_I_PKG_ITEM_PKG dependencies on IGR_I_PKG_ITEM

Line 1: package body IGR_I_PKG_ITEM_PKG AS

1: package body IGR_I_PKG_ITEM_PKG AS
2: /* $Header: IGSRH03B.pls 120.0 2005/06/01 16:02:39 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGR_I_PKG_ITEM%RowType;

Line 5: old_references IGR_I_PKG_ITEM%RowType;

1: package body IGR_I_PKG_ITEM_PKG AS
2: /* $Header: IGSRH03B.pls 120.0 2005/06/01 16:02:39 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGR_I_PKG_ITEM%RowType;
6: new_references IGR_I_PKG_ITEM%RowType;
7:
8:
9: PROCEDURE Set_Column_Values (

Line 6: new_references IGR_I_PKG_ITEM%RowType;

2: /* $Header: IGSRH03B.pls 120.0 2005/06/01 16:02:39 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGR_I_PKG_ITEM%RowType;
6: new_references IGR_I_PKG_ITEM%RowType;
7:
8:
9: PROCEDURE Set_Column_Values (
10: p_action IN VARCHAR2,

Line 23: FROM IGR_I_PKG_ITEM

19: ) AS
20:
21: CURSOR cur_old_ref_values IS
22: SELECT *
23: FROM IGR_I_PKG_ITEM
24: WHERE rowid = x_rowid;
25:
26: BEGIN
27:

Line 102: CURSOR c_ams_deliverables (p_package_item_id igr_i_pkg_item.package_item_id%TYPE) IS

98: PROCEDURE check_parent_existance AS
99: BEGIN
100: DECLARE
101:
102: CURSOR c_ams_deliverables (p_package_item_id igr_i_pkg_item.package_item_id%TYPE) IS
103: SELECT deliverable_id
104: FROM ams_deliverables_all_b
105: WHERE deliverable_id = p_package_item_id;
106: l_deliverable_id AMS_DELIVERABLES_ALL_B.deliverable_id%TYPE;

Line 136: igr_i_inquiry_types_pkg.get_fk_igr_i_pkg_item (old_references.package_item_id);

132: || Who When What
133: || (reverse chronological order - newest change first)
134: */
135: BEGIN
136: igr_i_inquiry_types_pkg.get_fk_igr_i_pkg_item (old_references.package_item_id);
137: igr_i_pkgitm_assign_pkg.get_fk_igr_i_pkg_item (old_references.package_item_id);
138:
139: END Check_Child_Existance;
140:

Line 137: igr_i_pkgitm_assign_pkg.get_fk_igr_i_pkg_item (old_references.package_item_id);

133: || (reverse chronological order - newest change first)
134: */
135: BEGIN
136: igr_i_inquiry_types_pkg.get_fk_igr_i_pkg_item (old_references.package_item_id);
137: igr_i_pkgitm_assign_pkg.get_fk_igr_i_pkg_item (old_references.package_item_id);
138:
139: END Check_Child_Existance;
140:
141: FUNCTION get_pk_for_validation (

Line 147: FROM IGR_I_PKG_ITEM

143: ) RETURN BOOLEAN AS
144:
145: CURSOR cur_rowid IS
146: SELECT rowid
147: FROM IGR_I_PKG_ITEM
148: WHERE package_item_id = x_package_item_id;
149:
150: lv_rowid cur_rowid%RowType;
151:

Line 173: FROM IGR_I_PKG_ITEM

169: ) AS
170:
171: CURSOR cur_rowid IS
172: SELECT rowid
173: FROM IGR_I_PKG_ITEM
174: WHERE package_item_id = x_package_item_id ;
175:
176: lv_rowid cur_rowid%RowType;
177:

Line 254: SELECT rowid FROM IGR_I_PKG_ITEM

250: x_publish_ss_ind IN VARCHAR2 DEFAULT NULL,
251: x_mode IN VARCHAR2 DEFAULT 'R'
252: ) AS
253: CURSOR C IS
254: SELECT rowid FROM IGR_I_PKG_ITEM
255: WHERE package_item_id = x_package_item_id;
256: x_last_update_date DATE;
257: x_last_updated_by NUMBER;
258: x_last_update_login NUMBER;

Line 290: insert into IGR_I_PKG_ITEM (

286: x_last_update_date=>x_last_update_date,
287: x_last_updated_by=>x_last_updated_by,
288: x_last_update_login=>x_last_update_login
289: );
290: insert into IGR_I_PKG_ITEM (
291: package_item_id,
292: publish_ss_ind,
293: creation_date,
294: created_by,

Line 326: FROM igr_i_pkg_item

322: ) AS
323: CURSOR c1 IS
324: SELECT package_item_id,
325: publish_ss_ind
326: FROM igr_i_pkg_item
327: WHERE rowid = x_rowid;
328: tlinfo c1%rowtype;
329:
330: BEGIN

Line 396: update IGR_I_PKG_ITEM set

392: x_last_update_date=>X_LAST_UPDATE_DATE,
393: x_last_updated_by=>X_LAST_UPDATED_BY,
394: x_last_update_login=>X_LAST_UPDATE_LOGIN
395: );
396: update IGR_I_PKG_ITEM set
397: package_item_id = new_references.package_item_id,
398: publish_ss_ind = new_references.publish_ss_ind,
399: last_update_date = x_last_update_date,
400: last_updated_by = x_last_updated_by,

Line 415: SELECT rowid FROM IGR_I_PKG_ITEM

411: x_publish_ss_ind IN VARCHAR2 DEFAULT NULL,
412: x_mode IN VARCHAR2 DEFAULT 'R'
413: ) AS
414: CURSOR c1 IS
415: SELECT rowid FROM IGR_I_PKG_ITEM
416: WHERE package_item_id = x_package_item_id;
417: BEGIN
418: OPEN c1;
419: FETCH c1 INTO x_rowid;

Line 445: DELETE FROM IGR_I_PKG_ITEM

441: before_dml(
442: p_action => 'DELETE',
443: x_rowid => x_rowid
444: );
445: DELETE FROM IGR_I_PKG_ITEM
446: WHERE rowid = x_rowid;
447: IF (sql%NOTFOUND) THEN
448: raise no_data_found;
449: END IF;

Line 454: END IGR_I_PKG_ITEM_PKG;

450:
451: END delete_row;
452:
453:
454: END IGR_I_PKG_ITEM_PKG;