APPS.IGF_AP_GEN_SETUP_PKG dependencies on IGF_AP_GEN_SETUP_ALL

Line 5: old_references igf_ap_gen_setup_all%ROWTYPE;

1: PACKAGE BODY igf_ap_gen_setup_pkg AS
2: /* $Header: IGFAI36B.pls 120.1 2005/09/08 14:40:50 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_ap_gen_setup_all%ROWTYPE;
6: new_references igf_ap_gen_setup_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2 ,

Line 6: new_references igf_ap_gen_setup_all%ROWTYPE;

2: /* $Header: IGFAI36B.pls 120.1 2005/09/08 14:40:50 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_ap_gen_setup_all%ROWTYPE;
6: new_references igf_ap_gen_setup_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2 ,
10: x_rowid IN VARCHAR2 ,

Line 32: FROM IGF_AP_GEN_SETUP_ALL

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

Line 86: FROM igf_ap_gen_setup_all

82: || (reverse chronological order - newest change first)
83: */
84: CURSOR cur_rowid IS
85: SELECT rowid
86: FROM igf_ap_gen_setup_all
87: WHERE genst_id = x_genst_id
88: FOR UPDATE NOWAIT;
89:
90: lv_rowid cur_rowid%RowType;

Line 187: FROM igf_ap_gen_setup_all

183: || (reverse chronological order - newest change first)
184: */
185: CURSOR c IS
186: SELECT rowid
187: FROM igf_ap_gen_setup_all
188: WHERE genst_id = x_genst_id;
189:
190: x_last_update_date DATE;
191: x_last_updated_by NUMBER;

Line 215: SELECT igf_ap_gen_setup_all_s.NEXTVAL

211: igs_ge_msg_stack.add;
212: app_exception.raise_exception;
213: END IF;
214:
215: SELECT igf_ap_gen_setup_all_s.NEXTVAL
216: INTO x_genst_id
217: FROM dual;
218:
219: new_references.org_id := igs_ge_gen_003.get_org_id;

Line 234: INSERT INTO igf_ap_gen_setup_all (

230: x_last_updated_by => x_last_updated_by,
231: x_last_update_login => x_last_update_login
232: );
233:
234: INSERT INTO igf_ap_gen_setup_all (
235: genst_id,
236: org_id,
237: ssn_required,
238: auto_na_complete,

Line 286: FROM igf_ap_gen_setup_all

282: CURSOR c1 IS
283: SELECT
284: ssn_required,
285: auto_na_complete
286: FROM igf_ap_gen_setup_all
287: WHERE rowid = x_rowid
288: FOR UPDATE NOWAIT;
289:
290: tlinfo c1%ROWTYPE;

Line 375: UPDATE igf_ap_gen_setup_all

371: x_last_updated_by => x_last_updated_by,
372: x_last_update_login => x_last_update_login
373: );
374:
375: UPDATE igf_ap_gen_setup_all
376: SET
377: ssn_required = new_references.ssn_required,
378: auto_na_complete = new_references.auto_na_complete,
379: last_update_date = x_last_update_date,

Line 409: FROM igf_ap_gen_setup_all

405: || (reverse chronological order - newest change first)
406: */
407: CURSOR c1 IS
408: SELECT rowid
409: FROM igf_ap_gen_setup_all
410: WHERE genst_id = x_genst_id;
411:
412: BEGIN
413:

Line 460: DELETE FROM igf_ap_gen_setup_all

456: p_action => 'DELETE',
457: x_rowid => x_rowid
458: );
459:
460: DELETE FROM igf_ap_gen_setup_all
461: WHERE rowid = x_rowid;
462:
463: IF (SQL%NOTFOUND) THEN
464: RAISE NO_DATA_FOUND;