APPS.IGS_FI_WAV_PR_PREQS_PKG dependencies on IGS_FI_WAV_PR_PREQS

Line 1: PACKAGE BODY igs_fi_wav_pr_preqs_pkg AS

1: PACKAGE BODY igs_fi_wav_pr_preqs_pkg AS
2: /* $Header: IGSSIF7B.pls 120.0 2005/09/09 20:00:40 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_wav_pr_preqs%ROWTYPE;

Line 5: old_references igs_fi_wav_pr_preqs%ROWTYPE;

1: PACKAGE BODY igs_fi_wav_pr_preqs_pkg AS
2: /* $Header: IGSSIF7B.pls 120.0 2005/09/09 20:00:40 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_wav_pr_preqs%ROWTYPE;
6: new_references igs_fi_wav_pr_preqs%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_fi_wav_pr_preqs%ROWTYPE;

2: /* $Header: IGSSIF7B.pls 120.0 2005/09/09 20:00:40 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_wav_pr_preqs%ROWTYPE;
6: new_references igs_fi_wav_pr_preqs%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 35: FROM igs_fi_wav_pr_preqs

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

Line 141: FROM igs_fi_wav_pr_preqs

137: || (reverse chronological order - newest change first)
138: */
139: CURSOR cur_rowid IS
140: SELECT rowid
141: FROM igs_fi_wav_pr_preqs
142: WHERE waiver_relation_id = x_waiver_relation_id
143: FOR UPDATE NOWAIT;
144:
145: lv_rowid cur_rowid%RowType;

Line 178: FROM igs_fi_wav_pr_preqs

174: || (reverse chronological order - newest change first)
175: */
176: CURSOR cur_rowid IS
177: SELECT rowid
178: FROM igs_fi_wav_pr_preqs
179: WHERE ((fee_cal_type = x_fee_cal_type) AND
180: (fee_ci_sequence_number = x_fee_ci_sequence_number) AND
181: (sub_waiver_name = x_waiver_name))
182: OR ((fee_cal_type = x_fee_cal_type) AND

Line 316: fnd_message.set_token ('ROUTINE', 'IGS_FI_WAV_PR_PREQS_PKG.INSERT_ROW');

312: x_last_update_login := -1;
313: END IF;
314: ELSE
315: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
316: fnd_message.set_token ('ROUTINE', 'IGS_FI_WAV_PR_PREQS_PKG.INSERT_ROW');
317: igs_ge_msg_stack.add;
318: app_exception.raise_exception;
319: END IF;
320:

Line 339: INSERT INTO igs_fi_wav_pr_preqs (

335: x_last_updated_by => x_last_updated_by,
336: x_last_update_login => x_last_update_login
337: );
338:
339: INSERT INTO igs_fi_wav_pr_preqs (
340: waiver_relation_id,
341: object_version_number,
342: fee_cal_type,
343: fee_ci_sequence_number,

Line 352: igs_fi_wav_pr_preqs_s.NEXTVAL,

348: last_update_date,
349: last_updated_by,
350: last_update_login
351: ) VALUES (
352: igs_fi_wav_pr_preqs_s.NEXTVAL,
353: new_references.object_version_number,
354: new_references.fee_cal_type,
355: new_references.fee_ci_sequence_number,
356: new_references.sup_waiver_name,

Line 393: FROM igs_fi_wav_pr_preqs

389: fee_cal_type,
390: fee_ci_sequence_number,
391: sup_waiver_name,
392: sub_waiver_name
393: FROM igs_fi_wav_pr_preqs
394: WHERE rowid = x_rowid
395: FOR UPDATE NOWAIT;
396:
397: tlinfo c1%ROWTYPE;

Line 455: FROM igs_fi_wav_pr_preqs

451: x_last_update_login NUMBER;
452:
453: CURSOR cur_wav_pr_preqs(cp_rowid varchar2) IS
454: SELECT object_version_number
455: FROM igs_fi_wav_pr_preqs
456: WHERE rowid = cp_rowid
457: FOR UPDATE NOWAIT;
458:
459: l_n_object_version_number igs_fi_wav_pr_preqs.object_version_number%TYPE;

Line 459: l_n_object_version_number igs_fi_wav_pr_preqs.object_version_number%TYPE;

455: FROM igs_fi_wav_pr_preqs
456: WHERE rowid = cp_rowid
457: FOR UPDATE NOWAIT;
458:
459: l_n_object_version_number igs_fi_wav_pr_preqs.object_version_number%TYPE;
460:
461: BEGIN
462:
463: OPEN cur_wav_pr_preqs(x_rowid);

Line 482: fnd_message.set_token ('ROUTINE', 'IGS_FI_WAV_PR_PREQS_PKG.UPDATE_ROW');

478: x_last_update_login := -1;
479: END IF;
480: ELSE
481: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
482: fnd_message.set_token ('ROUTINE', 'IGS_FI_WAV_PR_PREQS_PKG.UPDATE_ROW');
483: igs_ge_msg_stack.add;
484: app_exception.raise_exception;
485: END IF;
486:

Line 503: UPDATE igs_fi_wav_pr_preqs

499: x_last_updated_by => x_last_updated_by,
500: x_last_update_login => x_last_update_login
501: );
502:
503: UPDATE igs_fi_wav_pr_preqs
504: SET
505: object_version_number = l_n_object_version_number + 1 ,
506: fee_cal_type = new_references.fee_cal_type,
507: fee_ci_sequence_number = new_references.fee_ci_sequence_number,

Line 543: FROM igs_fi_wav_pr_preqs

539: || (reverse chronological order - newest change first)
540: */
541: CURSOR c1 IS
542: SELECT rowid
543: FROM igs_fi_wav_pr_preqs
544: WHERE waiver_relation_id = x_waiver_relation_id;
545:
546: BEGIN
547:

Line 580: END igs_fi_wav_pr_preqs_pkg;

576: END add_row;
577:
578:
579:
580: END igs_fi_wav_pr_preqs_pkg;