APPS.IGS_GE_CFG_TAB_PKG dependencies on IGS_GE_CFG_TAB

Line 1: PACKAGE BODY IGS_GE_CFG_TAB_PKG AS

1: PACKAGE BODY IGS_GE_CFG_TAB_PKG AS
2: /* $Header: IGSNIA1B.pls 120.1 2005/09/08 15:46:17 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ge_cfg_tab%ROWTYPE;
5: new_references igs_ge_cfg_tab%ROWTYPE;

Line 4: old_references igs_ge_cfg_tab%ROWTYPE;

1: PACKAGE BODY IGS_GE_CFG_TAB_PKG AS
2: /* $Header: IGSNIA1B.pls 120.1 2005/09/08 15:46:17 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ge_cfg_tab%ROWTYPE;
5: new_references igs_ge_cfg_tab%ROWTYPE;
6: PROCEDURE set_column_values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2,

Line 5: new_references igs_ge_cfg_tab%ROWTYPE;

1: PACKAGE BODY IGS_GE_CFG_TAB_PKG AS
2: /* $Header: IGSNIA1B.pls 120.1 2005/09/08 15:46:17 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ge_cfg_tab%ROWTYPE;
5: new_references igs_ge_cfg_tab%ROWTYPE;
6: PROCEDURE set_column_values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2,
9: x_responsibility_id IN NUMBER,

Line 30: FROM igs_ge_cfg_tab

26: || (reverse chronological order - newest change first)
27: */
28: CURSOR cur_old_ref_values IS
29: SELECT *
30: FROM igs_ge_cfg_tab
31: WHERE rowid = x_rowid;
32: BEGIN
33: l_rowid := x_rowid;
34: -- Code for setting the Old and New Reference Values.

Line 103: FROM igs_ge_cfg_tab

99: || (reverse chronological order - newest change first)
100: */
101: CURSOR cur_rowid IS
102: SELECT rowid
103: FROM igs_ge_cfg_tab
104: WHERE responsibility_id = x_responsibility_id
105: AND form_code = x_form_code
106: AND tab_code = x_tab_code
107: FOR UPDATE NOWAIT;

Line 136: FROM igs_ge_cfg_tab

132: || (reverse chronological order - newest change first)
133: */
134: CURSOR cur_rowid IS
135: SELECT rowid
136: FROM igs_ge_cfg_tab
137: WHERE ((form_code = x_form_code) AND
138: (responsibility_id = x_responsibility_id));
139: lv_rowid cur_rowid%RowType;
140: BEGIN

Line 271: INSERT INTO igs_ge_cfg_tab (

267: x_last_update_date => x_last_update_date,
268: x_last_updated_by => x_last_updated_by,
269: x_last_update_login => x_last_update_login
270: );
271: INSERT INTO igs_ge_cfg_tab (
272: responsibility_id,
273: form_code,
274: tab_code,
275: config_opt,

Line 312: FROM igs_ge_cfg_tab

308: */
309: CURSOR c1 IS
310: SELECT
311: config_opt
312: FROM igs_ge_cfg_tab
313: WHERE rowid = x_rowid
314: FOR UPDATE NOWAIT;
315: tlinfo c1%ROWTYPE;
316: BEGIN

Line 390: UPDATE igs_ge_cfg_tab

386: x_last_update_date => x_last_update_date,
387: x_last_updated_by => x_last_updated_by,
388: x_last_update_login => x_last_update_login
389: );
390: UPDATE igs_ge_cfg_tab
391: SET
392: config_opt = new_references.config_opt,
393: last_update_date = x_last_update_date,
394: last_updated_by = x_last_updated_by,

Line 420: FROM igs_ge_cfg_tab

416: || (reverse chronological order - newest change first)
417: */
418: CURSOR c1 IS
419: SELECT rowid
420: FROM igs_ge_cfg_tab
421: WHERE responsibility_id = x_responsibility_id
422: AND form_code = x_form_code
423: AND tab_code = x_tab_code;
424: BEGIN

Line 466: DELETE FROM igs_ge_cfg_tab

462: before_dml (
463: p_action => 'DELETE',
464: x_rowid => x_rowid
465: );
466: DELETE FROM igs_ge_cfg_tab
467: WHERE rowid = x_rowid;
468: IF (SQL%NOTFOUND) THEN
469: RAISE NO_DATA_FOUND;
470: END IF;

Line 472: END igs_ge_cfg_tab_pkg;

468: IF (SQL%NOTFOUND) THEN
469: RAISE NO_DATA_FOUND;
470: END IF;
471: END delete_row;
472: END igs_ge_cfg_tab_pkg;