APPS.IGS_DA_REQ_WIF_PKG dependencies on IGS_DA_REQ_WIF

Line 1: PACKAGE BODY igs_da_req_wif_pkg AS

1: PACKAGE BODY igs_da_req_wif_pkg AS
2: /* $Header: IGSKI43B.pls 115.1 2003/04/16 05:40:10 smanglm noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_da_req_wif%ROWTYPE;

Line 5: old_references igs_da_req_wif%ROWTYPE;

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

Line 6: new_references igs_da_req_wif%ROWTYPE;

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

Line 43: FROM igs_da_req_wif

39: */
40:
41: CURSOR cur_old_ref_values IS
42: SELECT *
43: FROM igs_da_req_wif
44: WHERE rowid = x_rowid;
45:
46: BEGIN
47:

Line 154: igs_da_req_stdnts_pkg.get_fk_igs_da_req_wif (

150: || (reverse chronological order - newest change first)
151: */
152: BEGIN
153:
154: igs_da_req_stdnts_pkg.get_fk_igs_da_req_wif (
155: old_references.batch_id,
156: old_references.wif_id
157: );
158:

Line 177: FROM igs_da_req_wif

173: || (reverse chronological order - newest change first)
174: */
175: CURSOR cur_rowid IS
176: SELECT rowid
177: FROM igs_da_req_wif
178: WHERE batch_id = x_batch_id
179: AND wif_id = x_wif_id
180: FOR UPDATE NOWAIT;
181:

Line 213: FROM igs_da_req_wif

209: || (reverse chronological order - newest change first)
210: */
211: CURSOR cur_rowid IS
212: SELECT rowid
213: FROM igs_da_req_wif
214: WHERE ((batch_id = x_batch_id));
215:
216: lv_rowid cur_rowid%RowType;
217:

Line 248: FROM igs_da_req_wif

244: || (reverse chronological order - newest change first)
245: */
246: CURSOR cur_rowid IS
247: SELECT rowid
248: FROM igs_da_req_wif
249: WHERE ((program_code = x_course_cd));
250:
251: lv_rowid cur_rowid%RowType;
252:

Line 284: FROM igs_da_req_wif

280: || (reverse chronological order - newest change first)
281: */
282: CURSOR cur_rowid IS
283: SELECT rowid
284: FROM igs_da_req_wif
285: WHERE ((catalog_cal_type = x_cal_type) AND
286: (catalog_ci_seq_num = x_sequence_number));
287:
288: lv_rowid cur_rowid%RowType;

Line 451: fnd_message.set_token ('ROUTINE', 'IGS_DA_REQ_WIF_PKG.INSERT_ROW');

447: x_last_update_login := -1;
448: END IF;
449: ELSE
450: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
451: fnd_message.set_token ('ROUTINE', 'IGS_DA_REQ_WIF_PKG.INSERT_ROW');
452: igs_ge_msg_stack.add;
453: app_exception.raise_exception;
454: END IF;
455: before_dml(

Line 478: INSERT INTO igs_da_req_wif (

474: x_last_update_date => x_last_update_date,
475: x_last_updated_by => x_last_updated_by,
476: x_last_update_login => x_last_update_login
477: );
478: INSERT INTO igs_da_req_wif (
479: batch_id,
480: wif_id,
481: program_code,
482: catalog_cal_type,

Line 600: FROM igs_da_req_wif

596: minor_unit_set_cd3,
597: track_unit_set_cd1,
598: track_unit_set_cd2,
599: track_unit_set_cd3
600: FROM igs_da_req_wif
601: WHERE rowid = x_rowid
602: FOR UPDATE NOWAIT;
603:
604: tlinfo c1%ROWTYPE;

Line 730: fnd_message.set_token ('ROUTINE', 'IGS_DA_REQ_WIF_PKG.UPDATE_ROW');

726: x_last_update_login := -1;
727: END IF;
728: ELSE
729: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
730: fnd_message.set_token ('ROUTINE', 'IGS_DA_REQ_WIF_PKG.UPDATE_ROW');
731: igs_ge_msg_stack.add;
732: app_exception.raise_exception;
733: END IF;
734:

Line 759: UPDATE igs_da_req_wif

755: x_last_updated_by => x_last_updated_by,
756: x_last_update_login => x_last_update_login
757: );
758:
759: UPDATE igs_da_req_wif
760: SET
761: program_code = new_references.program_code,
762: catalog_cal_type = new_references.catalog_cal_type,
763: catalog_ci_seq_num = new_references.catalog_ci_seq_num,

Line 848: FROM igs_da_req_wif

844: || (reverse chronological order - newest change first)
845: */
846: CURSOR c1 IS
847: SELECT rowid
848: FROM igs_da_req_wif
849: WHERE batch_id = x_batch_id
850: AND wif_id = x_wif_id;
851: L_RETURN_STATUS VARCHAR2(10);
852: L_MSG_DATA VARCHAR2(2000);

Line 933: DELETE FROM igs_da_req_wif

929: p_action => 'DELETE',
930: x_rowid => x_rowid
931: );
932:
933: DELETE FROM igs_da_req_wif
934: WHERE rowid = x_rowid;
935:
936: IF (SQL%NOTFOUND) THEN
937: RAISE NO_DATA_FOUND;

Line 978: END igs_da_req_wif_pkg;

974:
975: END delete_row;
976:
977:
978: END igs_da_req_wif_pkg;