eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_AW_COA_RATE_DET_PKG dependencies on IGF_AW_COA_RATE_DET

Line 1: PACKAGE BODY igf_aw_coa_rate_det_pkg AS

1: PACKAGE BODY igf_aw_coa_rate_det_pkg AS
2: /* $Header: IGFWI70B.pls 120.0 2005/06/01 14:36:38 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_coa_rate_det%ROWTYPE;

Line 5: old_references igf_aw_coa_rate_det%ROWTYPE;

1: PACKAGE BODY igf_aw_coa_rate_det_pkg AS
2: /* $Header: IGFWI70B.pls 120.0 2005/06/01 14:36:38 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_coa_rate_det%ROWTYPE;
6: new_references igf_aw_coa_rate_det%ROWTYPE;
7:
8: FUNCTION check_data(
9: p_ci_cal_type igf_aw_coa_rate_det.ci_cal_type%TYPE,

Line 6: new_references igf_aw_coa_rate_det%ROWTYPE;

2: /* $Header: IGFWI70B.pls 120.0 2005/06/01 14:36:38 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_coa_rate_det%ROWTYPE;
6: new_references igf_aw_coa_rate_det%ROWTYPE;
7:
8: FUNCTION check_data(
9: p_ci_cal_type igf_aw_coa_rate_det.ci_cal_type%TYPE,
10: p_ci_sequence_number igf_aw_coa_rate_det.ci_sequence_number%TYPE,

Line 9: p_ci_cal_type igf_aw_coa_rate_det.ci_cal_type%TYPE,

5: old_references igf_aw_coa_rate_det%ROWTYPE;
6: new_references igf_aw_coa_rate_det%ROWTYPE;
7:
8: FUNCTION check_data(
9: p_ci_cal_type igf_aw_coa_rate_det.ci_cal_type%TYPE,
10: p_ci_sequence_number igf_aw_coa_rate_det.ci_sequence_number%TYPE,
11: p_item_code igf_aw_coa_rate_det.item_code%TYPE
12: ) RETURN BOOLEAN AS
13: CURSOR chk_data_uk ( cp_ci_cal_type igf_aw_coa_rate_det.ci_cal_type%TYPE,

Line 10: p_ci_sequence_number igf_aw_coa_rate_det.ci_sequence_number%TYPE,

6: new_references igf_aw_coa_rate_det%ROWTYPE;
7:
8: FUNCTION check_data(
9: p_ci_cal_type igf_aw_coa_rate_det.ci_cal_type%TYPE,
10: p_ci_sequence_number igf_aw_coa_rate_det.ci_sequence_number%TYPE,
11: p_item_code igf_aw_coa_rate_det.item_code%TYPE
12: ) RETURN BOOLEAN AS
13: CURSOR chk_data_uk ( cp_ci_cal_type igf_aw_coa_rate_det.ci_cal_type%TYPE,
14: cp_ci_sequence_number igf_aw_coa_rate_det.ci_sequence_number%TYPE,

Line 11: p_item_code igf_aw_coa_rate_det.item_code%TYPE

7:
8: FUNCTION check_data(
9: p_ci_cal_type igf_aw_coa_rate_det.ci_cal_type%TYPE,
10: p_ci_sequence_number igf_aw_coa_rate_det.ci_sequence_number%TYPE,
11: p_item_code igf_aw_coa_rate_det.item_code%TYPE
12: ) RETURN BOOLEAN AS
13: CURSOR chk_data_uk ( cp_ci_cal_type igf_aw_coa_rate_det.ci_cal_type%TYPE,
14: cp_ci_sequence_number igf_aw_coa_rate_det.ci_sequence_number%TYPE,
15: cp_item_code igf_aw_coa_rate_det.item_code%TYPE

Line 13: CURSOR chk_data_uk ( cp_ci_cal_type igf_aw_coa_rate_det.ci_cal_type%TYPE,

9: p_ci_cal_type igf_aw_coa_rate_det.ci_cal_type%TYPE,
10: p_ci_sequence_number igf_aw_coa_rate_det.ci_sequence_number%TYPE,
11: p_item_code igf_aw_coa_rate_det.item_code%TYPE
12: ) RETURN BOOLEAN AS
13: CURSOR chk_data_uk ( cp_ci_cal_type igf_aw_coa_rate_det.ci_cal_type%TYPE,
14: cp_ci_sequence_number igf_aw_coa_rate_det.ci_sequence_number%TYPE,
15: cp_item_code igf_aw_coa_rate_det.item_code%TYPE
16: ) IS
17: SELECT ci_cal_type

Line 14: cp_ci_sequence_number igf_aw_coa_rate_det.ci_sequence_number%TYPE,

10: p_ci_sequence_number igf_aw_coa_rate_det.ci_sequence_number%TYPE,
11: p_item_code igf_aw_coa_rate_det.item_code%TYPE
12: ) RETURN BOOLEAN AS
13: CURSOR chk_data_uk ( cp_ci_cal_type igf_aw_coa_rate_det.ci_cal_type%TYPE,
14: cp_ci_sequence_number igf_aw_coa_rate_det.ci_sequence_number%TYPE,
15: cp_item_code igf_aw_coa_rate_det.item_code%TYPE
16: ) IS
17: SELECT ci_cal_type
18: FROM igf_aw_coa_rate_det

Line 15: cp_item_code igf_aw_coa_rate_det.item_code%TYPE

11: p_item_code igf_aw_coa_rate_det.item_code%TYPE
12: ) RETURN BOOLEAN AS
13: CURSOR chk_data_uk ( cp_ci_cal_type igf_aw_coa_rate_det.ci_cal_type%TYPE,
14: cp_ci_sequence_number igf_aw_coa_rate_det.ci_sequence_number%TYPE,
15: cp_item_code igf_aw_coa_rate_det.item_code%TYPE
16: ) IS
17: SELECT ci_cal_type
18: FROM igf_aw_coa_rate_det
19: WHERE ci_cal_type = cp_ci_cal_type

Line 18: FROM igf_aw_coa_rate_det

14: cp_ci_sequence_number igf_aw_coa_rate_det.ci_sequence_number%TYPE,
15: cp_item_code igf_aw_coa_rate_det.item_code%TYPE
16: ) IS
17: SELECT ci_cal_type
18: FROM igf_aw_coa_rate_det
19: WHERE ci_cal_type = cp_ci_cal_type
20: AND ci_sequence_number = cp_ci_sequence_number
21: AND item_code = cp_item_code
22: GROUP BY ci_cal_type, ci_sequence_number, item_code,

Line 83: FROM igf_aw_coa_rate_det

79: */
80:
81: CURSOR cur_old_ref_values IS
82: SELECT *
83: FROM igf_aw_coa_rate_det
84: WHERE rowid = x_rowid;
85:
86: BEGIN
87:

Line 244: FROM igf_aw_coa_rate_det

240: || (reverse chronological order - newest change first)
241: */
242: CURSOR cur_rowid IS
243: SELECT rowid
244: FROM igf_aw_coa_rate_det
245: WHERE ci_cal_type = x_ci_cal_type
246: AND ci_sequence_number = x_ci_sequence_number
247: AND item_code = x_item_code
248: AND rate_order_num = x_rate_order_num

Line 321: fnd_message.set_token ('ROUTINE', 'IGF_AW_COA_RATE_DET_PKG.INSERT_ROW');

317: x_last_update_login := -1;
318: END IF;
319: ELSE
320: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
321: fnd_message.set_token ('ROUTINE', 'IGF_AW_COA_RATE_DET_PKG.INSERT_ROW');
322: igs_ge_msg_stack.add;
323: app_exception.raise_exception;
324: END IF;
325:

Line 354: INSERT INTO igf_aw_coa_rate_det (

350: x_last_updated_by => x_last_updated_by,
351: x_last_update_login => x_last_update_login
352: );
353:
354: INSERT INTO igf_aw_coa_rate_det (
355: ci_cal_type,
356: ci_sequence_number,
357: item_code,
358: rate_order_num,

Line 466: FROM igf_aw_coa_rate_det

462: ld_cal_type,
463: ld_sequence_number,
464: mult_factor_code,
465: mult_amount_num
466: FROM igf_aw_coa_rate_det
467: WHERE rowid = x_rowid
468: FOR UPDATE NOWAIT;
469:
470: tlinfo c1%ROWTYPE;

Line 569: fnd_message.set_token ('ROUTINE', 'IGF_AW_COA_RATE_DET_PKG.UPDATE_ROW');

565: x_last_update_login := -1;
566: END IF;
567: ELSE
568: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
569: fnd_message.set_token ('ROUTINE', 'IGF_AW_COA_RATE_DET_PKG.UPDATE_ROW');
570: igs_ge_msg_stack.add;
571: app_exception.raise_exception;
572: END IF;
573:

Line 602: UPDATE igf_aw_coa_rate_det

598: x_last_updated_by => x_last_updated_by,
599: x_last_update_login => x_last_update_login
600: );
601:
602: UPDATE igf_aw_coa_rate_det
603: SET
604: ci_cal_type = new_references.ci_cal_type,
605: ci_sequence_number = new_references.ci_sequence_number,
606: item_code = new_references.item_code,

Line 676: FROM igf_aw_coa_rate_det

672: || (reverse chronological order - newest change first)
673: */
674: CURSOR c1 IS
675: SELECT rowid
676: FROM igf_aw_coa_rate_det
677: WHERE ci_cal_type = x_ci_cal_type
678: AND ci_sequence_number = x_ci_sequence_number
679: AND item_code = x_item_code
680: AND rate_order_num = x_rate_order_num;

Line 760: DELETE FROM igf_aw_coa_rate_det

756: p_action => 'DELETE',
757: x_rowid => x_rowid
758: );
759:
760: DELETE FROM igf_aw_coa_rate_det
761: WHERE rowid = x_rowid;
762:
763: IF (SQL%NOTFOUND) THEN
764: RAISE NO_DATA_FOUND;

Line 770: END igf_aw_coa_rate_det_pkg;

766:
767: END delete_row;
768:
769:
770: END igf_aw_coa_rate_det_pkg;