APPS.IGF_SL_LOR_LOC_HISTORY_PKG dependencies on IGF_SL_LOR_LOC_HISTORY

Line 1: PACKAGE BODY igf_sl_lor_loc_history_pkg AS

1: PACKAGE BODY igf_sl_lor_loc_history_pkg AS
2: /* $Header: IGFLI36B.pls 120.1 2006/04/19 08:30:23 bvisvana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sl_lor_loc_history%ROWTYPE;

Line 5: old_references igf_sl_lor_loc_history%ROWTYPE;

1: PACKAGE BODY igf_sl_lor_loc_history_pkg AS
2: /* $Header: IGFLI36B.pls 120.1 2006/04/19 08:30:23 bvisvana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sl_lor_loc_history%ROWTYPE;
6: new_references igf_sl_lor_loc_history%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_sl_lor_loc_history%ROWTYPE;

2: /* $Header: IGFLI36B.pls 120.1 2006/04/19 08:30:23 bvisvana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sl_lor_loc_history%ROWTYPE;
6: new_references igf_sl_lor_loc_history%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 217: FROM igf_sl_lor_loc_history

213: */
214:
215: CURSOR cur_old_ref_values IS
216: SELECT *
217: FROM igf_sl_lor_loc_history
218: WHERE rowid = x_rowid;
219:
220: BEGIN
221:

Line 887: FROM igf_sl_lor_loc_history

883: || (reverse chronological order - newest change first)
884: */
885: CURSOR cur_rowid IS
886: SELECT rowid
887: FROM igf_sl_lor_loc_history
888: WHERE loansh_id = x_loansh_id
889: FOR UPDATE NOWAIT;
890:
891: lv_rowid cur_rowid%RowType;

Line 1147: fnd_message.set_token ('ROUTINE', 'igf_sl_lor_loc_history_PKG.INSERT_ROW');

1143: x_program_update_date := SYSDATE;
1144: END IF;
1145: ELSE
1146: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
1147: fnd_message.set_token ('ROUTINE', 'igf_sl_lor_loc_history_PKG.INSERT_ROW');
1148: igs_ge_msg_stack.add;
1149: app_exception.raise_exception;
1150: END IF;
1151:

Line 1153: SELECT igf_sl_lor_loc_history_s.NEXTVAL INTO x_loansh_id FROM dual;

1149: app_exception.raise_exception;
1150: END IF;
1151:
1152:
1153: SELECT igf_sl_lor_loc_history_s.NEXTVAL INTO x_loansh_id FROM dual;
1154:
1155: before_dml(
1156: p_action => 'INSERT',
1157: x_rowid => x_rowid,

Line 1353: INSERT INTO igf_sl_lor_loc_history (

1349: x_last_updated_by => x_last_updated_by,
1350: x_last_update_login => x_last_update_login
1351: );
1352:
1353: INSERT INTO igf_sl_lor_loc_history (
1354: loan_id,
1355: origination_id,
1356: loan_number,
1357: loan_type,

Line 1738: igf_sl_lor_loc_history_s.NEXTVAL,

1734: new_references.rep_entity_id_txt,
1735: new_references.source_entity_id_txt,
1736: new_references.interest_rebate_percent_num,
1737: new_references.esign_src_typ_cd,
1738: igf_sl_lor_loc_history_s.NEXTVAL,
1739: new_references.source_txt,
1740: x_last_update_date,
1741: x_last_updated_by,
1742: x_last_update_date,

Line 2144: FROM igf_sl_lor_loc_history

2140: interest_rebate_percent_num,
2141: esign_src_typ_cd,
2142: loansh_id,
2143: source_txt
2144: FROM igf_sl_lor_loc_history
2145: WHERE rowid = x_rowid
2146: FOR UPDATE NOWAIT;
2147:
2148: tlinfo c1%ROWTYPE;

Line 2591: fnd_message.set_token ('ROUTINE', 'igf_sl_lor_loc_history_PKG.UPDATE_ROW');

2587: x_last_update_login := -1;
2588: END IF;
2589: ELSE
2590: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
2591: fnd_message.set_token ('ROUTINE', 'igf_sl_lor_loc_history_PKG.UPDATE_ROW');
2592: igs_ge_msg_stack.add;
2593: app_exception.raise_exception;
2594: END IF;
2595:

Line 2808: UPDATE igf_sl_lor_loc_history

2804: x_program_update_date := SYSDATE;
2805: END IF;
2806: END IF;
2807:
2808: UPDATE igf_sl_lor_loc_history
2809: SET
2810: loan_id = new_references.loan_id,
2811: origination_id = new_references.origination_id,
2812: loan_number = new_references.loan_number,

Line 3217: FROM igf_sl_lor_loc_history

3213: || (reverse chronological order - newest change first)
3214: */
3215: CURSOR c1 IS
3216: SELECT rowid
3217: FROM igf_sl_lor_loc_history
3218: WHERE loansh_id = x_loansh_id;
3219:
3220: BEGIN
3221:

Line 3638: DELETE FROM igf_sl_lor_loc_history

3634: p_action => 'DELETE',
3635: x_rowid => x_rowid
3636: );
3637:
3638: DELETE FROM igf_sl_lor_loc_history
3639: WHERE rowid = x_rowid;
3640:
3641: IF (SQL%NOTFOUND) THEN
3642: RAISE NO_DATA_FOUND;

Line 3648: END igf_sl_lor_loc_history_pkg;

3644:
3645: END delete_row;
3646:
3647:
3648: END igf_sl_lor_loc_history_pkg;