APPS.IGS_DA_CNFG_PKG dependencies on IGS_DA_CNFG

Line 1: PACKAGE BODY igs_da_cnfg_pkg AS

1: PACKAGE BODY igs_da_cnfg_pkg AS
2: /* $Header: IGSKI45B.pls 115.0 2003/04/15 09:21:52 ddey noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_da_cnfg%ROWTYPE;

Line 5: old_references igs_da_cnfg%ROWTYPE;

1: PACKAGE BODY igs_da_cnfg_pkg AS
2: /* $Header: IGSKI45B.pls 115.0 2003/04/15 09:21:52 ddey noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_da_cnfg%ROWTYPE;
6: new_references igs_da_cnfg%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_da_cnfg%ROWTYPE;

2: /* $Header: IGSKI45B.pls 115.0 2003/04/15 09:21:52 ddey noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_da_cnfg%ROWTYPE;
6: new_references igs_da_cnfg%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 32: FROM igs_da_cnfg

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

Line 87: ELSIF NOT igs_da_cnfg_req_typ_pkg.get_pk_for_validation (

83:
84: IF (((old_references.request_type_id = new_references.request_type_id)) OR
85: ((new_references.request_type_id IS NULL))) THEN
86: NULL;
87: ELSIF NOT igs_da_cnfg_req_typ_pkg.get_pk_for_validation (
88: new_references.request_type_id
89: ) THEN
90: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
91: igs_ge_msg_stack.add;

Line 113: FROM igs_da_cnfg

109: || (reverse chronological order - newest change first)
110: */
111: CURSOR cur_rowid IS
112: SELECT rowid
113: FROM igs_da_cnfg
114: WHERE request_type_id = x_request_type_id
115: AND responsibility_name = x_responsibility_name
116: FOR UPDATE NOWAIT;
117:

Line 135: PROCEDURE get_fk_igs_da_cnfg_req_typ (

131:
132: END get_pk_for_validation;
133:
134:
135: PROCEDURE get_fk_igs_da_cnfg_req_typ (
136: x_request_type_id IN NUMBER
137: ) AS
138: /*
139: || Created By :

Line 149: FROM igs_da_cnfg

145: || (reverse chronological order - newest change first)
146: */
147: CURSOR cur_rowid IS
148: SELECT rowid
149: FROM igs_da_cnfg
150: WHERE ((request_type_id = x_request_type_id));
151:
152: lv_rowid cur_rowid%RowType;
153:

Line 160: fnd_message.set_name ('IGS', 'IGS_DA_CNFG_REQ_CNFG_FK');

156: OPEN cur_rowid;
157: FETCH cur_rowid INTO lv_rowid;
158: IF (cur_rowid%FOUND) THEN
159: CLOSE cur_rowid;
160: fnd_message.set_name ('IGS', 'IGS_DA_CNFG_REQ_CNFG_FK');
161: igs_ge_msg_stack.add;
162: app_exception.raise_exception;
163: RETURN;
164: END IF;

Line 167: END get_fk_igs_da_cnfg_req_typ;

163: RETURN;
164: END IF;
165: CLOSE cur_rowid;
166:
167: END get_fk_igs_da_cnfg_req_typ;
168:
169:
170: PROCEDURE before_dml (
171: p_action IN VARCHAR2,

Line 276: fnd_message.set_token ('ROUTINE', 'IGS_DA_CNFG_PKG.INSERT_ROW');

272: x_last_update_login := -1;
273: END IF;
274: ELSE
275: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
276: fnd_message.set_token ('ROUTINE', 'IGS_DA_CNFG_PKG.INSERT_ROW');
277: igs_ge_msg_stack.add;
278: app_exception.raise_exception;
279: END IF;
280:

Line 294: INSERT INTO igs_da_cnfg (

290: x_last_updated_by => x_last_updated_by,
291: x_last_update_login => x_last_update_login
292: );
293:
294: INSERT INTO igs_da_cnfg (
295: request_type_id,
296: responsibility_name,
297: access_level,
298: creation_date,

Line 335: FROM igs_da_cnfg

331: */
332: CURSOR c1 IS
333: SELECT
334: access_level
335: FROM igs_da_cnfg
336: WHERE rowid = x_rowid
337: FOR UPDATE NOWAIT;
338:
339: tlinfo c1%ROWTYPE;

Line 406: fnd_message.set_token ('ROUTINE', 'IGS_DA_CNFG_PKG.UPDATE_ROW');

402: x_last_update_login := -1;
403: END IF;
404: ELSE
405: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
406: fnd_message.set_token ('ROUTINE', 'IGS_DA_CNFG_PKG.UPDATE_ROW');
407: igs_ge_msg_stack.add;
408: app_exception.raise_exception;
409: END IF;
410:

Line 424: UPDATE igs_da_cnfg

420: x_last_updated_by => x_last_updated_by,
421: x_last_update_login => x_last_update_login
422: );
423:
424: UPDATE igs_da_cnfg
425: SET
426: access_level = new_references.access_level,
427: last_update_date = x_last_update_date,
428: last_updated_by = x_last_updated_by,

Line 457: FROM igs_da_cnfg

453: || (reverse chronological order - newest change first)
454: */
455: CURSOR c1 IS
456: SELECT rowid
457: FROM igs_da_cnfg
458: WHERE request_type_id = x_request_type_id
459: AND responsibility_name = x_responsibility_name;
460:
461: BEGIN

Line 509: DELETE FROM igs_da_cnfg

505: p_action => 'DELETE',
506: x_rowid => x_rowid
507: );
508:
509: DELETE FROM igs_da_cnfg
510: WHERE rowid = x_rowid;
511:
512: IF (SQL%NOTFOUND) THEN
513: RAISE NO_DATA_FOUND;

Line 519: END igs_da_cnfg_pkg;

515:
516: END delete_row;
517:
518:
519: END igs_da_cnfg_pkg;