APPS.IGF_AW_AWD_HIST_PKG dependencies on IGF_AW_AWD_HIST

Line 1: PACKAGE BODY igf_aw_awd_hist_pkg AS

1: PACKAGE BODY igf_aw_awd_hist_pkg AS
2: /* $Header: IGFWI69B.pls 120.0 2005/06/02 15:52:47 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_awd_hist%ROWTYPE;

Line 5: old_references igf_aw_awd_hist%ROWTYPE;

1: PACKAGE BODY igf_aw_awd_hist_pkg AS
2: /* $Header: IGFWI69B.pls 120.0 2005/06/02 15:52:47 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_awd_hist%ROWTYPE;
6: new_references igf_aw_awd_hist%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_aw_awd_hist%ROWTYPE;

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

Line 39: FROM igf_aw_awd_hist

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

Line 100: FROM igf_aw_awd_hist

96: || (reverse chronological order - newest change first)
97: */
98: CURSOR cur_rowid IS
99: SELECT rowid
100: FROM igf_aw_awd_hist
101: WHERE awdh_id = x_awdh_id
102: FOR UPDATE NOWAIT;
103:
104: lv_rowid cur_rowid%RowType;

Line 258: fnd_message.set_token ('ROUTINE', 'IGF_AW_AWD_HIST_PKG.INSERT_ROW');

254: x_program_update_date := SYSDATE;
255: END IF;
256: ELSE
257: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
258: fnd_message.set_token ('ROUTINE', 'IGF_AW_AWD_HIST_PKG.INSERT_ROW');
259: igs_ge_msg_stack.add;
260: app_exception.raise_exception;
261: END IF;
262:

Line 285: INSERT INTO igf_aw_awd_hist (

281: x_last_updated_by => x_last_updated_by,
282: x_last_update_login => x_last_update_login
283: );
284:
285: INSERT INTO igf_aw_awd_hist (
286: awdh_id,
287: award_id,
288: tran_date,
289: operation_txt,

Line 306: igf_aw_awd_hist_s.NEXTVAL,

302: program_id,
303: program_application_id,
304: program_update_date
305: ) VALUES (
306: igf_aw_awd_hist_s.NEXTVAL,
307: new_references.award_id,
308: new_references.tran_date,
309: new_references.operation_txt,
310: new_references.offered_amt_num,

Line 363: FROM igf_aw_awd_hist

359: accepted_amt_num,
360: acc_adj_num,
361: paid_amt_num,
362: paid_adj_num
363: FROM igf_aw_awd_hist
364: WHERE rowid = x_rowid
365: FOR UPDATE NOWAIT;
366:
367: tlinfo c1%ROWTYPE;

Line 453: fnd_message.set_token ('ROUTINE', 'IGF_AW_AWD_HIST_PKG.UPDATE_ROW');

449: x_last_update_login := -1;
450: END IF;
451: ELSE
452: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
453: fnd_message.set_token ('ROUTINE', 'IGF_AW_AWD_HIST_PKG.UPDATE_ROW');
454: igs_ge_msg_stack.add;
455: app_exception.raise_exception;
456: END IF;
457:

Line 492: UPDATE igf_aw_awd_hist

488: x_program_update_date := SYSDATE;
489: END IF;
490: END IF;
491:
492: UPDATE igf_aw_awd_hist
493: SET
494: award_id = new_references.award_id,
495: tran_date = new_references.tran_date,
496: operation_txt = new_references.operation_txt,

Line 544: FROM igf_aw_awd_hist

540: || (reverse chronological order - newest change first)
541: */
542: CURSOR c1 IS
543: SELECT rowid
544: FROM igf_aw_awd_hist
545: WHERE awdh_id = x_awdh_id;
546:
547: BEGIN
548:

Line 609: DELETE FROM igf_aw_awd_hist

605: p_action => 'DELETE',
606: x_rowid => x_rowid
607: );
608:
609: DELETE FROM igf_aw_awd_hist
610: WHERE rowid = x_rowid;
611:
612: IF (SQL%NOTFOUND) THEN
613: RAISE NO_DATA_FOUND;

Line 619: END igf_aw_awd_hist_pkg;

615:
616: END delete_row;
617:
618:
619: END igf_aw_awd_hist_pkg;