APPS.IGR_I_E_CHARTYP_PKG dependencies on IGR_I_E_CHARTYP

Line 1: PACKAGE BODY igr_i_e_chartyp_pkg AS

1: PACKAGE BODY igr_i_e_chartyp_pkg AS
2: /* $Header: IGSRH04B.pls 120.0 2005/06/01 15:59:53 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGR_I_E_CHARTYP%RowType;

Line 5: old_references IGR_I_E_CHARTYP%RowType;

1: PACKAGE BODY igr_i_e_chartyp_pkg AS
2: /* $Header: IGSRH04B.pls 120.0 2005/06/01 15:59:53 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGR_I_E_CHARTYP%RowType;
6: new_references IGR_I_E_CHARTYP%RowType;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references IGR_I_E_CHARTYP%RowType;

2: /* $Header: IGSRH04B.pls 120.0 2005/06/01 15:59:53 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGR_I_E_CHARTYP%RowType;
6: new_references IGR_I_E_CHARTYP%RowType;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 23: FROM igr_i_e_chartyp

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

Line 62: igr_i_a_chartyp_pkg.igr_i_e_chartyp (

58: END set_column_values;
59:
60: PROCEDURE check_child_existance AS
61: BEGIN
62: igr_i_a_chartyp_pkg.igr_i_e_chartyp (
63: old_references.enquiry_characteristic_type
64: );
65: END check_child_existance;
66:

Line 74: FROM igr_i_e_chartyp

70: ) RETURN BOOLEAN AS
71:
72: CURSOR cur_rowid IS
73: SELECT ROWID
74: FROM igr_i_e_chartyp
75: WHERE enquiry_characteristic_type = x_enquiry_characteristic_type AND
76: closed_ind = NVL(x_closed_ind,closed_ind);
77:
78: lv_rowid cur_rowid%ROWTYPE;

Line 198: CURSOR c IS SELECT ROWID FROM IGR_I_E_CHARTYP

194: X_DESCRIPTION in VARCHAR2,
195: X_CLOSED_IND in VARCHAR2,
196: X_MODE in VARCHAR2 default 'R'
197: ) as
198: CURSOR c IS SELECT ROWID FROM IGR_I_E_CHARTYP
199: where ENQUIRY_CHARACTERISTIC_TYPE = X_ENQUIRY_CHARACTERISTIC_TYPE;
200: X_LAST_UPDATE_DATE DATE;
201: X_LAST_UPDATED_BY NUMBER;
202: X_LAST_UPDATE_LOGIN NUMBER;

Line 236: INSERT INTO IGR_I_E_CHARTYP (

232: x_last_updated_by=>X_LAST_UPDATED_BY,
233: x_last_update_login=>X_LAST_UPDATE_LOGIN
234: );
235:
236: INSERT INTO IGR_I_E_CHARTYP (
237: ENQUIRY_CHARACTERISTIC_TYPE,
238: DESCRIPTION,
239: CLOSED_IND,
240: CREATION_DATE,

Line 275: FROM IGR_I_E_CHARTYP

271: ) as
272: CURSOR c1 IS SELECT
273: DESCRIPTION,
274: CLOSED_IND
275: FROM IGR_I_E_CHARTYP
276: WHERE ROWID = X_ROWID
277: FOR UPDATE NOWAIT;
278: tlinfo c1%rowtype;
279:

Line 347: UPDATE IGR_I_E_CHARTYP SET

343: x_last_updated_by=>X_LAST_UPDATED_BY,
344: x_last_update_login=>X_LAST_UPDATE_LOGIN
345: );
346:
347: UPDATE IGR_I_E_CHARTYP SET
348: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
349: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
350: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
351: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 367: CURSOR c1 IS SELECT ROWID FROM IGR_I_E_CHARTYP

363: X_DESCRIPTION in VARCHAR2,
364: X_CLOSED_IND in VARCHAR2,
365: X_MODE in VARCHAR2 default 'R'
366: ) as
367: CURSOR c1 IS SELECT ROWID FROM IGR_I_E_CHARTYP
368: WHERE ENQUIRY_CHARACTERISTIC_TYPE = X_ENQUIRY_CHARACTERISTIC_TYPE
369: ;
370:
371: BEGIN

Line 393: END IGR_I_E_CHARTYP_PKG;

389: X_CLOSED_IND,
390: X_MODE);
391: END ADD_ROW;
392:
393: END IGR_I_E_CHARTYP_PKG;