APPS.IGS_FI_TP_RET_SCHD_PKG dependencies on IGS_FI_TP_RET_SCHD

Line 1: PACKAGE BODY igs_fi_tp_ret_schd_pkg AS

1: PACKAGE BODY igs_fi_tp_ret_schd_pkg AS
2: /* $Header: IGSSIE7B.pls 120.0 2005/06/02 04:20:06 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_tp_ret_schd%ROWTYPE;

Line 5: old_references igs_fi_tp_ret_schd%ROWTYPE;

1: PACKAGE BODY igs_fi_tp_ret_schd_pkg AS
2: /* $Header: IGSSIE7B.pls 120.0 2005/06/02 04:20:06 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_tp_ret_schd%ROWTYPE;
6: new_references igs_fi_tp_ret_schd%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_fi_tp_ret_schd%ROWTYPE;

2: /* $Header: IGSSIE7B.pls 120.0 2005/06/02 04:20:06 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_tp_ret_schd%ROWTYPE;
6: new_references igs_fi_tp_ret_schd%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 39: FROM igs_fi_tp_ret_schd

35: */
36:
37: CURSOR cur_old_ref_values IS
38: SELECT *
39: FROM igs_fi_tp_ret_schd
40: WHERE rowid = x_rowid;
41:
42: BEGIN
43:

Line 183: FROM igs_fi_tp_ret_schd

179: || (reverse chronological order - newest change first)
180: */
181: CURSOR cur_rowid IS
182: SELECT rowid
183: FROM igs_fi_tp_ret_schd
184: WHERE ftci_teach_retention_id = x_ftci_teach_retention_id
185: FOR UPDATE NOWAIT;
186:
187: lv_rowid cur_rowid%RowType;

Line 224: FROM igs_fi_tp_ret_schd

220: || (reverse chronological order - newest change first)
221: */
222: CURSOR cur_rowid IS
223: SELECT rowid
224: FROM igs_fi_tp_ret_schd
225: WHERE teach_cal_type = x_teach_cal_type
226: AND teach_ci_sequence_number = x_teach_ci_sequence_number
227: AND ((fee_cal_type = x_fee_cal_type) OR (fee_cal_type IS NULL AND x_fee_cal_type IS NULL))
228: AND ((fee_ci_sequence_number = x_fee_ci_sequence_number) OR (fee_ci_sequence_number IS NULL AND x_fee_ci_sequence_number IS NULL))

Line 429: fnd_message.set_token ('ROUTINE', 'IGS_FI_TP_RET_SCHD_PKG.INSERT_ROW');

425: x_program_update_date := SYSDATE;
426: END IF;
427: ELSE
428: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
429: fnd_message.set_token ('ROUTINE', 'IGS_FI_TP_RET_SCHD_PKG.INSERT_ROW');
430: igs_ge_msg_stack.add;
431: app_exception.raise_exception;
432: END IF;
433:

Line 456: INSERT INTO igs_fi_tp_ret_schd (

452: x_last_updated_by => x_last_updated_by,
453: x_last_update_login => x_last_update_login
454: );
455:
456: INSERT INTO igs_fi_tp_ret_schd (
457: ftci_teach_retention_id,
458: teach_cal_type,
459: teach_ci_sequence_number,
460: fee_cal_type,

Line 477: igs_fi_tp_ret_schd_s.NEXTVAL,

473: program_id,
474: program_application_id,
475: program_update_date
476: ) VALUES (
477: igs_fi_tp_ret_schd_s.NEXTVAL,
478: new_references.teach_cal_type,
479: new_references.teach_ci_sequence_number,
480: new_references.fee_cal_type,
481: new_references.fee_ci_sequence_number,

Line 534: FROM igs_fi_tp_ret_schd

530: dt_alias,
531: dai_sequence_number,
532: ret_percentage,
533: ret_amount
534: FROM igs_fi_tp_ret_schd
535: WHERE rowid = x_rowid
536: FOR UPDATE NOWAIT;
537:
538: tlinfo c1%ROWTYPE;

Line 623: fnd_message.set_token ('ROUTINE', 'IGS_FI_TP_RET_SCHD_PKG.UPDATE_ROW');

619: x_last_update_login := -1;
620: END IF;
621: ELSE
622: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
623: fnd_message.set_token ('ROUTINE', 'IGS_FI_TP_RET_SCHD_PKG.UPDATE_ROW');
624: igs_ge_msg_stack.add;
625: app_exception.raise_exception;
626: END IF;
627:

Line 662: UPDATE igs_fi_tp_ret_schd

658: x_program_update_date := SYSDATE;
659: END IF;
660: END IF;
661:
662: UPDATE igs_fi_tp_ret_schd
663: SET
664: teach_cal_type = new_references.teach_cal_type,
665: teach_ci_sequence_number = new_references.teach_ci_sequence_number,
666: fee_cal_type = new_references.fee_cal_type,

Line 714: FROM igs_fi_tp_ret_schd

710: || (reverse chronological order - newest change first)
711: */
712: CURSOR c1 IS
713: SELECT rowid
714: FROM igs_fi_tp_ret_schd
715: WHERE ftci_teach_retention_id = x_ftci_teach_retention_id;
716:
717: BEGIN
718:

Line 776: FROM igs_fi_tp_ret_schd

772: || (reverse chronological order - newest change first)
773: */
774: CURSOR cur_rowid IS
775: SELECT rowid
776: FROM igs_fi_tp_ret_schd
777: WHERE ((dt_alias = x_dt_alias ) AND
778: (dai_sequence_number = x_dai_sequence_number) AND
779: (teach_cal_type = x_teach_cal_type) AND
780: (teach_ci_sequence_number = x_teach_ci_sequence_number));

Line 817: DELETE FROM igs_fi_tp_ret_schd

813: p_action => 'DELETE',
814: x_rowid => x_rowid
815: );
816:
817: DELETE FROM igs_fi_tp_ret_schd
818: WHERE rowid = x_rowid;
819:
820: IF (SQL%NOTFOUND) THEN
821: RAISE NO_DATA_FOUND;

Line 867: END igs_fi_tp_ret_schd_pkg;

863: END IF;
864: END IF;
865:
866: END Check_Constraints;
867: END igs_fi_tp_ret_schd_pkg;