APPS.IGS_DA_REQ_FTRS_PKG dependencies on IGS_DA_REQ_FTRS

Line 1: PACKAGE BODY igs_da_req_ftrs_pkg AS

1: PACKAGE BODY igs_da_req_ftrs_pkg AS
2: /* $Header: IGSKI42B.pls 115.1 2003/04/16 05:39:48 smanglm noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_da_req_ftrs%ROWTYPE;

Line 5: old_references igs_da_req_ftrs%ROWTYPE;

1: PACKAGE BODY igs_da_req_ftrs_pkg AS
2: /* $Header: IGSKI42B.pls 115.1 2003/04/16 05:39:48 smanglm noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_da_req_ftrs%ROWTYPE;
6: new_references igs_da_req_ftrs%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_da_req_ftrs%ROWTYPE;

2: /* $Header: IGSKI42B.pls 115.1 2003/04/16 05:39:48 smanglm noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_da_req_ftrs%ROWTYPE;
6: new_references igs_da_req_ftrs%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 32: FROM igs_da_req_ftrs

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

Line 113: FROM igs_da_req_ftrs

109: || (reverse chronological order - newest change first)
110: */
111: CURSOR cur_rowid IS
112: SELECT rowid
113: FROM igs_da_req_ftrs
114: WHERE batch_id = x_batch_id
115: AND feature_code = x_feature_code
116: FOR UPDATE NOWAIT;
117:

Line 149: FROM igs_da_req_ftrs

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

Line 183: FROM igs_da_req_ftrs

179: || (reverse chronological order - newest change first)
180: */
181: CURSOR cur_rowid IS
182: SELECT rowid
183: FROM igs_da_req_ftrs
184: WHERE ((batch_id = x_batch_id));
185:
186: lv_rowid cur_rowid%RowType;
187:

Line 312: fnd_message.set_token ('ROUTINE', 'IGS_DA_REQ_FTRS_PKG.INSERT_ROW');

308: x_last_update_login := -1;
309: END IF;
310: ELSE
311: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
312: fnd_message.set_token ('ROUTINE', 'IGS_DA_REQ_FTRS_PKG.INSERT_ROW');
313: igs_ge_msg_stack.add;
314: app_exception.raise_exception;
315: END IF;
316:

Line 330: INSERT INTO igs_da_req_ftrs (

326: x_last_updated_by => x_last_updated_by,
327: x_last_update_login => x_last_update_login
328: );
329:
330: INSERT INTO igs_da_req_ftrs (
331: batch_id,
332: feature_code,
333: feature_value,
334: creation_date,

Line 409: FROM igs_da_req_ftrs

405: */
406: CURSOR c1 IS
407: SELECT
408: feature_value
409: FROM igs_da_req_ftrs
410: WHERE rowid = x_rowid
411: FOR UPDATE NOWAIT;
412:
413: tlinfo c1%ROWTYPE;

Line 515: fnd_message.set_token ('ROUTINE', 'IGS_DA_REQ_FTRS_PKG.UPDATE_ROW');

511: x_last_update_login := -1;
512: END IF;
513: ELSE
514: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
515: fnd_message.set_token ('ROUTINE', 'IGS_DA_REQ_FTRS_PKG.UPDATE_ROW');
516: igs_ge_msg_stack.add;
517: app_exception.raise_exception;
518: END IF;
519:

Line 533: UPDATE igs_da_req_ftrs

529: x_last_updated_by => x_last_updated_by,
530: x_last_update_login => x_last_update_login
531: );
532:
533: UPDATE igs_da_req_ftrs
534: SET
535: feature_value = new_references.feature_value,
536: last_update_date = x_last_update_date,
537: last_updated_by = x_last_updated_by,

Line 601: FROM igs_da_req_ftrs

597: || (reverse chronological order - newest change first)
598: */
599: CURSOR c1 IS
600: SELECT rowid
601: FROM igs_da_req_ftrs
602: WHERE batch_id = x_batch_id
603: AND feature_code = x_feature_code;
604:
605: L_RETURN_STATUS VARCHAR2(10);

Line 665: DELETE FROM igs_da_req_ftrs

661: p_action => 'DELETE',
662: x_rowid => x_rowid
663: );
664:
665: DELETE FROM igs_da_req_ftrs
666: WHERE rowid = x_rowid;
667:
668: IF (SQL%NOTFOUND) THEN
669: RAISE NO_DATA_FOUND;

Line 710: END igs_da_req_ftrs_pkg;

706:
707: END delete_row;
708:
709:
710: END igs_da_req_ftrs_pkg;