APPS.IGF_SL_DISB_LOC_HISTORY_PKG dependencies on IGF_SL_DISB_LOC_HISTORY

Line 1: PACKAGE BODY igf_sl_disb_loc_history_pkg AS

1: PACKAGE BODY igf_sl_disb_loc_history_pkg AS
2: /* $Header: IGFLI42B.pls 120.0 2005/06/01 14:33:12 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sl_disb_loc_history%ROWTYPE;

Line 5: old_references igf_sl_disb_loc_history%ROWTYPE;

1: PACKAGE BODY igf_sl_disb_loc_history_pkg AS
2: /* $Header: IGFLI42B.pls 120.0 2005/06/01 14:33:12 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sl_disb_loc_history%ROWTYPE;
6: new_references igf_sl_disb_loc_history%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_sl_disb_loc_history%ROWTYPE;

2: /* $Header: IGFLI42B.pls 120.0 2005/06/01 14:33:12 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sl_disb_loc_history%ROWTYPE;
6: new_references igf_sl_disb_loc_history%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 41: FROM igf_sl_disb_loc_history

37: */
38:
39: CURSOR cur_old_ref_values IS
40: SELECT *
41: FROM igf_sl_disb_loc_history
42: WHERE rowid = x_rowid;
43:
44: BEGIN
45:

Line 232: fnd_message.set_token ('ROUTINE', 'igf_sl_disb_loc_history_PKG.INSERT_ROW');

228: x_program_update_date := SYSDATE;
229: END IF;
230: ELSE
231: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
232: fnd_message.set_token ('ROUTINE', 'igf_sl_disb_loc_history_PKG.INSERT_ROW');
233: igs_ge_msg_stack.add;
234: app_exception.raise_exception;
235: END IF;
236:

Line 261: INSERT INTO igf_sl_disb_loc_history (

257: x_last_updated_by => x_last_updated_by,
258: x_last_update_login => x_last_update_login
259: );
260:
261: INSERT INTO igf_sl_disb_loc_history (
262: lodisbh_id,
263: award_id,
264: disbursement_number,
265: disbursement_gross_amt,

Line 284: igf_sl_disb_loc_history_s.NEXTVAL,

280: program_id,
281: program_application_id,
282: program_update_date
283: ) VALUES (
284: igf_sl_disb_loc_history_s.NEXTVAL,
285: new_references.award_id,
286: new_references.disbursement_number,
287: new_references.disbursement_gross_amt,
288: new_references.origination_fee_amt,

Line 323: FROM igf_sl_disb_loc_history

319: || (reverse chronological order - newest change first)
320: */
321: CURSOR cur_rowid IS
322: SELECT rowid
323: FROM igf_sl_disb_loc_history
324: WHERE lodisbh_id = x_lodisbh_id
325: FOR UPDATE NOWAIT;
326:
327: lv_rowid cur_rowid%RowType;

Line 382: FROM igf_sl_disb_loc_history

378: disbursement_date,
379: disbursement_hold_rel_ind,
380: disbursement_net_amt,
381: source_txt
382: FROM igf_sl_disb_loc_history
383: WHERE rowid = x_rowid
384: FOR UPDATE NOWAIT;
385:
386: tlinfo c1%ROWTYPE;

Line 477: fnd_message.set_token ('ROUTINE', 'igf_sl_disb_loc_history_PKG.UPDATE_ROW');

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

Line 518: UPDATE igf_sl_disb_loc_history

514: x_program_update_date := SYSDATE;
515: END IF;
516: END IF;
517:
518: UPDATE igf_sl_disb_loc_history
519: SET
520: lodisbh_id = new_references.lodisbh_id,
521: award_id = new_references.award_id,
522: disbursement_number = new_references.disbursement_number,

Line 575: FROM igf_sl_disb_loc_history

571: || (reverse chronological order - newest change first)
572: */
573: CURSOR c1 IS
574: SELECT rowid
575: FROM igf_sl_disb_loc_history
576: WHERE lodisbh_id = x_lodisbh_id ;
577:
578: BEGIN
579:

Line 644: DELETE FROM igf_sl_disb_loc_history

640: p_action => 'DELETE',
641: x_rowid => x_rowid
642: );
643:
644: DELETE FROM igf_sl_disb_loc_history
645: WHERE rowid = x_rowid;
646:
647: IF (SQL%NOTFOUND) THEN
648: RAISE NO_DATA_FOUND;

Line 654: END igf_sl_disb_loc_history_pkg;

650:
651: END delete_row;
652:
653:
654: END igf_sl_disb_loc_history_pkg;