APPS.IGS_FI_WAIVER_PGMS_PKG dependencies on IGS_FI_WAIVER_PGMS

Line 1: PACKAGE BODY igs_fi_waiver_pgms_pkg AS

1: PACKAGE BODY igs_fi_waiver_pgms_pkg AS
2: /* $Header: IGSSIF6B.pls 120.0 2005/09/09 18:34:21 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_waiver_pgms%ROWTYPE;

Line 5: old_references igs_fi_waiver_pgms%ROWTYPE;

1: PACKAGE BODY igs_fi_waiver_pgms_pkg AS
2: /* $Header: IGSSIF6B.pls 120.0 2005/09/09 18:34:21 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_waiver_pgms%ROWTYPE;
6: new_references igs_fi_waiver_pgms%ROWTYPE;
7:
8: PROCEDURE check_parent_existance AS
9: /*

Line 6: new_references igs_fi_waiver_pgms%ROWTYPE;

2: /* $Header: IGSSIF6B.pls 120.0 2005/09/09 18:34:21 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_waiver_pgms%ROWTYPE;
6: new_references igs_fi_waiver_pgms%ROWTYPE;
7:
8: PROCEDURE check_parent_existance AS
9: /*
10: || Created By : [email protected]

Line 146: FROM igs_fi_waiver_pgms

142: */
143:
144: CURSOR cur_old_ref_values IS
145: SELECT *
146: FROM igs_fi_waiver_pgms
147: WHERE rowid = x_rowid;
148:
149: BEGIN
150:

Line 213: FROM igs_fi_waiver_pgms

209: || (reverse chronological order - newest change first)
210: */
211: CURSOR cur_rowid IS
212: SELECT rowid
213: FROM igs_fi_waiver_pgms
214: WHERE fee_cal_type = x_fee_cal_type
215: AND fee_ci_sequence_number = x_fee_ci_sequence_number
216: AND waiver_name = x_waiver_name
217: FOR UPDATE NOWAIT;

Line 374: fnd_message.set_token ('ROUTINE', 'IGS_FI_WAIVER_PGMS_PKG.INSERT_ROW');

370: x_last_update_login := -1;
371: END IF;
372: ELSE
373: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
374: fnd_message.set_token ('ROUTINE', 'IGS_FI_WAIVER_PGMS_PKG.INSERT_ROW');
375: igs_ge_msg_stack.add;
376: app_exception.raise_exception;
377: END IF;
378:

Line 403: INSERT INTO igs_fi_waiver_pgms (

399: x_last_updated_by => x_last_updated_by,
400: x_last_update_login => x_last_update_login
401: );
402:
403: INSERT INTO igs_fi_waiver_pgms (
404: fee_cal_type,
405: fee_ci_sequence_number,
406: waiver_name,
407: object_version_number,

Line 487: FROM igs_fi_waiver_pgms

483: waiver_mode_code,
484: waiver_criteria_code,
485: waiver_percent_alloc,
486: rule_fee_type
487: FROM igs_fi_waiver_pgms
488: WHERE rowid = x_rowid
489: FOR UPDATE NOWAIT;
490:
491: tlinfo c1%ROWTYPE;

Line 563: FROM igs_fi_waiver_pgms

559: x_last_update_login NUMBER;
560:
561: CURSOR cur_waiver_pgms(cp_rowid varchar2) IS
562: SELECT object_version_number
563: FROM igs_fi_waiver_pgms
564: WHERE rowid = cp_rowid
565: FOR UPDATE NOWAIT;
566: l_n_object_version_number igs_fi_waiver_pgms.object_version_number%TYPE;
567:

Line 566: l_n_object_version_number igs_fi_waiver_pgms.object_version_number%TYPE;

562: SELECT object_version_number
563: FROM igs_fi_waiver_pgms
564: WHERE rowid = cp_rowid
565: FOR UPDATE NOWAIT;
566: l_n_object_version_number igs_fi_waiver_pgms.object_version_number%TYPE;
567:
568: BEGIN
569:
570: OPEN cur_waiver_pgms(x_rowid);

Line 589: fnd_message.set_token ('ROUTINE', 'IGS_FI_WAIVER_PGMS_PKG.UPDATE_ROW');

585: x_last_update_login := -1;
586: END IF;
587: ELSE
588: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
589: fnd_message.set_token ('ROUTINE', 'IGS_FI_WAIVER_PGMS_PKG.UPDATE_ROW');
590: igs_ge_msg_stack.add;
591: app_exception.raise_exception;
592: END IF;
593:

Line 618: UPDATE igs_fi_waiver_pgms

614: x_last_updated_by => x_last_updated_by,
615: x_last_update_login => x_last_update_login
616: );
617:
618: UPDATE igs_fi_waiver_pgms
619: SET
620: object_version_number = l_n_object_version_number +1, --Made this Change to Maintain the OVN Sync
621: waiver_desc = new_references.waiver_desc,
622: waiver_status_code = new_references.waiver_status_code,

Line 672: FROM igs_fi_waiver_pgms

668: || (reverse chronological order - newest change first)
669: */
670: CURSOR c1 IS
671: SELECT rowid
672: FROM igs_fi_waiver_pgms
673: WHERE fee_cal_type = x_fee_cal_type
674: AND fee_ci_sequence_number = x_fee_ci_sequence_number
675: AND waiver_name = x_waiver_name;
676:

Line 726: END igs_fi_waiver_pgms_pkg;

722:
723: END add_row;
724:
725:
726: END igs_fi_waiver_pgms_pkg;