APPS.IGF_AW_COA_HIST_PKG dependencies on IGF_AW_COA_HIST

Line 1: PACKAGE BODY igf_aw_coa_hist_pkg AS

1: PACKAGE BODY igf_aw_coa_hist_pkg AS
2: /* $Header: IGFWI68B.pls 120.0 2005/06/01 13:54:12 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_coa_hist%ROWTYPE;

Line 5: old_references igf_aw_coa_hist%ROWTYPE;

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

Line 6: new_references igf_aw_coa_hist%ROWTYPE;

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

Line 38: FROM igf_aw_coa_hist

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

Line 98: FROM igf_aw_coa_hist

94: || (reverse chronological order - newest change first)
95: */
96: CURSOR cur_rowid IS
97: SELECT rowid
98: FROM igf_aw_coa_hist
99: WHERE coah_id = x_coah_id
100: FOR UPDATE NOWAIT;
101:
102: lv_rowid cur_rowid%RowType;

Line 253: fnd_message.set_token ('ROUTINE', 'IGF_AW_COA_HIST_PKG.INSERT_ROW');

249: x_program_update_date := SYSDATE;
250: END IF;
251: ELSE
252: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
253: fnd_message.set_token ('ROUTINE', 'IGF_AW_COA_HIST_PKG.INSERT_ROW');
254: igs_ge_msg_stack.add;
255: app_exception.raise_exception;
256: END IF;
257:

Line 279: INSERT INTO igf_aw_coa_hist (

275: x_last_updated_by => x_last_updated_by,
276: x_last_update_login => x_last_update_login
277: );
278:
279: INSERT INTO igf_aw_coa_hist (
280: coah_id,
281: base_id,
282: tran_date,
283: item_code,

Line 299: igf_aw_coa_hist_s.NEXTVAL,

295: program_id,
296: program_application_id,
297: program_update_date
298: ) VALUES (
299: igf_aw_coa_hist_s.NEXTVAL,
300: new_references.base_id,
301: new_references.tran_date,
302: new_references.item_code,
303: new_references.ld_cal_type,

Line 353: FROM igf_aw_coa_hist

349: ld_sequence_number,
350: operation_txt,
351: old_value,
352: new_value
353: FROM igf_aw_coa_hist
354: WHERE rowid = x_rowid
355: FOR UPDATE NOWAIT;
356:
357: tlinfo c1%ROWTYPE;

Line 441: fnd_message.set_token ('ROUTINE', 'IGF_AW_COA_HIST_PKG.UPDATE_ROW');

437: x_last_update_login := -1;
438: END IF;
439: ELSE
440: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
441: fnd_message.set_token ('ROUTINE', 'IGF_AW_COA_HIST_PKG.UPDATE_ROW');
442: igs_ge_msg_stack.add;
443: app_exception.raise_exception;
444: END IF;
445:

Line 479: UPDATE igf_aw_coa_hist

475: x_program_update_date := SYSDATE;
476: END IF;
477: END IF;
478:
479: UPDATE igf_aw_coa_hist
480: SET
481: base_id = new_references.base_id,
482: tran_date = new_references.tran_date,
483: item_code = new_references.item_code,

Line 529: FROM igf_aw_coa_hist

525: || (reverse chronological order - newest change first)
526: */
527: CURSOR c1 IS
528: SELECT rowid
529: FROM igf_aw_coa_hist
530: WHERE coah_id = x_coah_id;
531:
532: BEGIN
533:

Line 592: DELETE FROM igf_aw_coa_hist

588: p_action => 'DELETE',
589: x_rowid => x_rowid
590: );
591:
592: DELETE FROM igf_aw_coa_hist
593: WHERE rowid = x_rowid;
594:
595: IF (SQL%NOTFOUND) THEN
596: RAISE NO_DATA_FOUND;

Line 602: END igf_aw_coa_hist_pkg;

598:
599: END delete_row;
600:
601:
602: END igf_aw_coa_hist_pkg;