APPS.IGS_GE_CFG_FORM_PKG dependencies on IGS_GE_CFG_FORM

Line 1: PACKAGE BODY IGS_GE_CFG_FORM_PKG AS

1: PACKAGE BODY IGS_GE_CFG_FORM_PKG AS
2: /* $Header: IGSNIA0B.pls 120.0 2005/06/02 00:17:52 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ge_cfg_form%ROWTYPE;
5: new_references igs_ge_cfg_form%ROWTYPE;

Line 4: old_references igs_ge_cfg_form%ROWTYPE;

1: PACKAGE BODY IGS_GE_CFG_FORM_PKG AS
2: /* $Header: IGSNIA0B.pls 120.0 2005/06/02 00:17:52 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ge_cfg_form%ROWTYPE;
5: new_references igs_ge_cfg_form%ROWTYPE;
6: PROCEDURE set_column_values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2,

Line 5: new_references igs_ge_cfg_form%ROWTYPE;

1: PACKAGE BODY IGS_GE_CFG_FORM_PKG AS
2: /* $Header: IGSNIA0B.pls 120.0 2005/06/02 00:17:52 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ge_cfg_form%ROWTYPE;
5: new_references igs_ge_cfg_form%ROWTYPE;
6: PROCEDURE set_column_values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2,
9: x_responsibility_id IN NUMBER,

Line 29: FROM igs_ge_cfg_form

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

Line 71: igs_ge_cfg_tab_pkg.get_fk_igs_ge_cfg_form (

67: || Who When What
68: || (reverse chronological order - newest change first)
69: */
70: BEGIN
71: igs_ge_cfg_tab_pkg.get_fk_igs_ge_cfg_form (
72: old_references.responsibility_id,
73: old_references.form_code
74: );
75: END check_child_existance;

Line 91: FROM igs_ge_cfg_form

87: || (reverse chronological order - newest change first)
88: */
89: CURSOR cur_rowid IS
90: SELECT rowid
91: FROM igs_ge_cfg_form
92: WHERE responsibility_id = x_responsibility_id
93: AND form_code = x_form_code
94: FOR UPDATE NOWAIT;
95: lv_rowid cur_rowid%RowType;

Line 223: INSERT INTO igs_ge_cfg_form (

219: x_last_update_date => x_last_update_date,
220: x_last_updated_by => x_last_updated_by,
221: x_last_update_login => x_last_update_login
222: );
223: INSERT INTO igs_ge_cfg_form (
224: responsibility_id,
225: form_code,
226: query_only_ind,
227: creation_date,

Line 261: FROM igs_ge_cfg_form

257: */
258: CURSOR c1 IS
259: SELECT
260: query_only_ind
261: FROM igs_ge_cfg_form
262: WHERE rowid = x_rowid
263: FOR UPDATE NOWAIT;
264: tlinfo c1%ROWTYPE;
265: BEGIN

Line 337: UPDATE igs_ge_cfg_form

333: x_last_update_date => x_last_update_date,
334: x_last_updated_by => x_last_updated_by,
335: x_last_update_login => x_last_update_login
336: );
337: UPDATE igs_ge_cfg_form
338: SET
339: query_only_ind = new_references.query_only_ind,
340: last_update_date = x_last_update_date,
341: last_updated_by = x_last_updated_by,

Line 366: FROM igs_ge_cfg_form

362: || (reverse chronological order - newest change first)
363: */
364: CURSOR c1 IS
365: SELECT rowid
366: FROM igs_ge_cfg_form
367: WHERE responsibility_id = x_responsibility_id
368: AND form_code = x_form_code;
369: BEGIN
370: OPEN c1;

Line 409: DELETE FROM igs_ge_cfg_form

405: before_dml (
406: p_action => 'DELETE',
407: x_rowid => x_rowid
408: );
409: DELETE FROM igs_ge_cfg_form
410: WHERE rowid = x_rowid;
411: IF (SQL%NOTFOUND) THEN
412: RAISE NO_DATA_FOUND;
413: END IF;

Line 440: For i in (SELECT rowid FROM igs_ge_cfg_form WHERE responsibility_id = x_to_responsibility_id) LOOP

436: i.rowid
437: );
438: END LOOP;
439: -- Delete from Form Configuration
440: For i in (SELECT rowid FROM igs_ge_cfg_form WHERE responsibility_id = x_to_responsibility_id) LOOP
441: igs_ge_cfg_form_pkg.delete_row (
442: i.rowid
443: );
444:

Line 441: igs_ge_cfg_form_pkg.delete_row (

437: );
438: END LOOP;
439: -- Delete from Form Configuration
440: For i in (SELECT rowid FROM igs_ge_cfg_form WHERE responsibility_id = x_to_responsibility_id) LOOP
441: igs_ge_cfg_form_pkg.delete_row (
442: i.rowid
443: );
444:
445: END LOOP;

Line 454: For i in (SELECT form_code,query_only_ind FROM igs_ge_cfg_form WHERE responsibility_id = x_from_responsibility_id) LOOP

450: );
451: END LOOP;
452:
453: -- Insert for the Form Configuration
454: For i in (SELECT form_code,query_only_ind FROM igs_ge_cfg_form WHERE responsibility_id = x_from_responsibility_id) LOOP
455: lv_rowid := Null;
456: igs_ge_cfg_form_pkg.insert_row (
457: lv_rowid,
458: x_to_responsibility_id,

Line 456: igs_ge_cfg_form_pkg.insert_row (

452:
453: -- Insert for the Form Configuration
454: For i in (SELECT form_code,query_only_ind FROM igs_ge_cfg_form WHERE responsibility_id = x_from_responsibility_id) LOOP
455: lv_rowid := Null;
456: igs_ge_cfg_form_pkg.insert_row (
457: lv_rowid,
458: x_to_responsibility_id,
459: i.form_code,
460: i.query_only_ind,

Line 494: END igs_ge_cfg_form_pkg;

490: END LOOP;
491:
492: END do_copy;
493:
494: END igs_ge_cfg_form_pkg;