APPS.IGS_FI_WAV_STD_PGMS_PKG dependencies on IGS_FI_WAV_STD_PGMS

Line 1: PACKAGE BODY igs_fi_wav_std_pgms_pkg AS

1: PACKAGE BODY igs_fi_wav_std_pgms_pkg AS
2: /* $Header: IGSSIF8B.pls 120.0 2005/09/09 18:36:44 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_wav_std_pgms%ROWTYPE;

Line 5: old_references igs_fi_wav_std_pgms%ROWTYPE;

1: PACKAGE BODY igs_fi_wav_std_pgms_pkg AS
2: /* $Header: IGSSIF8B.pls 120.0 2005/09/09 18:36:44 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_wav_std_pgms%ROWTYPE;
6: new_references igs_fi_wav_std_pgms%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_fi_wav_std_pgms%ROWTYPE;

2: /* $Header: IGSSIF8B.pls 120.0 2005/09/09 18:36:44 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_wav_std_pgms%ROWTYPE;
6: new_references igs_fi_wav_std_pgms%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 36: FROM igs_fi_wav_std_pgms

32: */
33:
34: CURSOR cur_old_ref_values IS
35: SELECT *
36: FROM igs_fi_wav_std_pgms
37: WHERE rowid = x_rowid;
38:
39: BEGIN
40:

Line 126: FROM igs_fi_wav_std_pgms

122: || (reverse chronological order - newest change first)
123: */
124: CURSOR cur_rowid IS
125: SELECT rowid
126: FROM igs_fi_wav_std_pgms
127: WHERE waiver_student_id = x_waiver_student_id
128: FOR UPDATE NOWAIT;
129:
130: lv_rowid cur_rowid%RowType;

Line 163: FROM igs_fi_wav_std_pgms

159: || (reverse chronological order - newest change first)
160: */
161: CURSOR cur_rowid IS
162: SELECT rowid
163: FROM igs_fi_wav_std_pgms
164: WHERE ((fee_cal_type = x_fee_cal_type) AND
165: (fee_ci_sequence_number = x_fee_ci_sequence_number) AND
166: (waiver_name = x_waiver_name));
167:

Line 301: fnd_message.set_token ('ROUTINE', 'IGS_FI_WAV_STD_PGMS_PKG.INSERT_ROW');

297: x_last_update_login := -1;
298: END IF;
299: ELSE
300: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
301: fnd_message.set_token ('ROUTINE', 'IGS_FI_WAV_STD_PGMS_PKG.INSERT_ROW');
302: igs_ge_msg_stack.add;
303: app_exception.raise_exception;
304: END IF;
305:

Line 325: INSERT INTO igs_fi_wav_std_pgms (

321: x_last_updated_by => x_last_updated_by,
322: x_last_update_login => x_last_update_login
323: );
324:
325: INSERT INTO igs_fi_wav_std_pgms (
326: waiver_student_id,
327: object_version_number,
328: fee_cal_type,
329: fee_ci_sequence_number,

Line 339: igs_fi_wav_std_pgms_s.NEXTVAL,

335: last_update_date,
336: last_updated_by,
337: last_update_login
338: ) VALUES (
339: igs_fi_wav_std_pgms_s.NEXTVAL,
340: new_references.object_version_number,
341: new_references.fee_cal_type,
342: new_references.fee_ci_sequence_number,
343: new_references.waiver_name,

Line 383: FROM igs_fi_wav_std_pgms

379: fee_ci_sequence_number,
380: waiver_name,
381: person_id,
382: assignment_status_code
383: FROM igs_fi_wav_std_pgms
384: WHERE rowid = x_rowid
385: FOR UPDATE NOWAIT;
386:
387: tlinfo c1%ROWTYPE;

Line 447: FROM igs_fi_wav_std_pgms

443: x_last_update_login NUMBER;
444:
445: CURSOR cur_wav_std_pgms(cp_rowid varchar2) IS
446: SELECT object_version_number
447: FROM igs_fi_wav_std_pgms
448: WHERE rowid = cp_rowid
449: FOR UPDATE NOWAIT;
450:
451: l_n_object_version_number igs_fi_wav_std_pgms.object_version_number%TYPE;

Line 451: l_n_object_version_number igs_fi_wav_std_pgms.object_version_number%TYPE;

447: FROM igs_fi_wav_std_pgms
448: WHERE rowid = cp_rowid
449: FOR UPDATE NOWAIT;
450:
451: l_n_object_version_number igs_fi_wav_std_pgms.object_version_number%TYPE;
452:
453: BEGIN
454:
455: OPEN cur_wav_std_pgms(x_rowid);

Line 474: fnd_message.set_token ('ROUTINE', 'IGS_FI_WAV_STD_PGMS_PKG.UPDATE_ROW');

470: x_last_update_login := -1;
471: END IF;
472: ELSE
473: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
474: fnd_message.set_token ('ROUTINE', 'IGS_FI_WAV_STD_PGMS_PKG.UPDATE_ROW');
475: igs_ge_msg_stack.add;
476: app_exception.raise_exception;
477: END IF;
478:

Line 496: UPDATE igs_fi_wav_std_pgms

492: x_last_updated_by => x_last_updated_by,
493: x_last_update_login => x_last_update_login
494: );
495:
496: UPDATE igs_fi_wav_std_pgms
497: SET
498: object_version_number = l_n_object_version_number + 1,
499: fee_cal_type = new_references.fee_cal_type,
500: fee_ci_sequence_number = new_references.fee_ci_sequence_number,

Line 538: FROM igs_fi_wav_std_pgms

534: || (reverse chronological order - newest change first)
535: */
536: CURSOR c1 IS
537: SELECT rowid
538: FROM igs_fi_wav_std_pgms
539: WHERE waiver_student_id = x_waiver_student_id;
540:
541: BEGIN
542:

Line 575: END igs_fi_wav_std_pgms_pkg;

571: );
572:
573: END add_row;
574:
575: END igs_fi_wav_std_pgms_pkg;