APPS.IGS_DA_RQST_PKG dependencies on IGS_DA_RQST

Line 1: PACKAGE BODY igs_da_rqst_pkg AS

1: PACKAGE BODY igs_da_rqst_pkg AS
2: /* $Header: IGSKI41B.pls 115.2 2003/04/17 11:22:29 smanglm noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_da_rqst%ROWTYPE;

Line 5: old_references igs_da_rqst%ROWTYPE;

1: PACKAGE BODY igs_da_rqst_pkg AS
2: /* $Header: IGSKI41B.pls 115.2 2003/04/17 11:22:29 smanglm noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_da_rqst%ROWTYPE;
6: new_references igs_da_rqst%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_da_rqst%ROWTYPE;

2: /* $Header: IGSKI41B.pls 115.2 2003/04/17 11:22:29 smanglm noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_da_rqst%ROWTYPE;
6: new_references igs_da_rqst%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 61: FROM igs_da_rqst

57: */
58:
59: CURSOR cur_old_ref_values IS
60: SELECT *
61: FROM igs_da_rqst
62: WHERE rowid = x_rowid;
63:
64: BEGIN
65:

Line 179: igs_da_req_wif_pkg.get_fk_igs_da_rqst (

175: || (reverse chronological order - newest change first)
176: */
177: BEGIN
178:
179: igs_da_req_wif_pkg.get_fk_igs_da_rqst (
180: old_references.batch_id
181: );
182:
183: igs_da_req_ftrs_pkg.get_fk_igs_da_rqst (

Line 183: igs_da_req_ftrs_pkg.get_fk_igs_da_rqst (

179: igs_da_req_wif_pkg.get_fk_igs_da_rqst (
180: old_references.batch_id
181: );
182:
183: igs_da_req_ftrs_pkg.get_fk_igs_da_rqst (
184: old_references.batch_id
185: );
186:
187: END check_child_existance;

Line 204: FROM igs_da_rqst

200: || (reverse chronological order - newest change first)
201: */
202: CURSOR cur_rowid IS
203: SELECT rowid
204: FROM igs_da_rqst
205: WHERE batch_id = x_batch_id
206: FOR UPDATE NOWAIT;
207:
208: lv_rowid cur_rowid%RowType;

Line 239: FROM igs_da_rqst

235: || (reverse chronological order - newest change first)
236: */
237: CURSOR cur_rowid IS
238: SELECT rowid
239: FROM igs_da_rqst
240: WHERE ((request_type_id = x_request_type_id));
241:
242: lv_rowid cur_rowid%RowType;
243:

Line 274: FROM igs_da_rqst

270: || (reverse chronological order - newest change first)
271: */
272: CURSOR cur_rowid IS
273: SELECT rowid
274: FROM igs_da_rqst
275: WHERE ((person_id_group_id = x_group_id));
276:
277: lv_rowid cur_rowid%RowType;
278:

Line 491: fnd_message.set_token ('ROUTINE', 'IGS_DA_RQST_PKG.INSERT_ROW');

487: x_last_update_login := -1;
488: END IF;
489: ELSE
490: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
491: fnd_message.set_token ('ROUTINE', 'IGS_DA_RQST_PKG.INSERT_ROW');
492: igs_ge_msg_stack.add;
493: app_exception.raise_exception;
494: END IF;
495: -- x_batch_id := NULL;

Line 538: INSERT INTO igs_da_rqst (

534: x_last_update_date => x_last_update_date,
535: x_last_updated_by => x_last_updated_by,
536: x_last_update_login => x_last_update_login
537: );
538: INSERT INTO igs_da_rqst (
539: batch_id,
540: request_type_id,
541: request_mode,
542: program_comparison_type,

Line 735: FROM igs_da_rqst

731: attribute17,
732: attribute18,
733: attribute19,
734: attribute20
735: FROM igs_da_rqst
736: WHERE rowid = x_rowid
737: FOR UPDATE NOWAIT;
738:
739: tlinfo c1%ROWTYPE;

Line 901: fnd_message.set_token ('ROUTINE', 'IGS_DA_RQST_PKG.UPDATE_ROW');

897: x_last_update_login := -1;
898: END IF;
899: ELSE
900: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
901: fnd_message.set_token ('ROUTINE', 'IGS_DA_RQST_PKG.UPDATE_ROW');
902: igs_ge_msg_stack.add;
903: app_exception.raise_exception;
904: END IF;
905:

Line 950: UPDATE igs_da_rqst

946: x_last_updated_by => x_last_updated_by,
947: x_last_update_login => x_last_update_login
948: );
949:
950: UPDATE igs_da_rqst
951: SET
952: request_type_id = new_references.request_type_id,
953: request_mode = new_references.request_mode,
954: program_comparison_type = new_references.program_comparison_type,

Line 1077: FROM igs_da_rqst

1073: || (reverse chronological order - newest change first)
1074: */
1075: CURSOR c1 IS
1076: SELECT rowid
1077: FROM igs_da_rqst
1078: WHERE batch_id = x_batch_id;
1079: L_RETURN_STATUS VARCHAR2(10);
1080: L_MSG_DATA VARCHAR2(2000);
1081: L_MSG_COUNT NUMBER(10);

Line 1197: DELETE FROM igs_da_rqst

1193: p_action => 'DELETE',
1194: x_rowid => x_rowid
1195: );
1196:
1197: DELETE FROM igs_da_rqst
1198: WHERE rowid = x_rowid;
1199:
1200: IF (SQL%NOTFOUND) THEN
1201: RAISE NO_DATA_FOUND;

Line 1242: END igs_da_rqst_pkg;

1238:
1239: END delete_row;
1240:
1241:
1242: END igs_da_rqst_pkg;