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.XTR_HEDGE_PROCESS_P dependencies on XTR_HEDGE_CRITERIA

Line 7: TYPE hedge_items IS TABLE OF xtr_hedge_criteria.criteria_code%TYPE INDEX BY BINARY_INTEGER;

3:
4: e_invalid_criteria_set EXCEPTION;
5: e_batch_been_run EXCEPTION;
6:
7: TYPE hedge_items IS TABLE OF xtr_hedge_criteria.criteria_code%TYPE INDEX BY BINARY_INTEGER;
8: TYPE hedge_conditions IS TABLE OF xtr_hedge_criteria.operator%TYPE INDEX BY BINARY_INTEGER;
9: TYPE hedge_values IS TABLE OF xtr_hedge_criteria.from_value%TYPE INDEX BY BINARY_INTEGER;
10:
11: TYPE criteria_set_rec_type IS RECORD (

Line 8: TYPE hedge_conditions IS TABLE OF xtr_hedge_criteria.operator%TYPE INDEX BY BINARY_INTEGER;

4: e_invalid_criteria_set EXCEPTION;
5: e_batch_been_run EXCEPTION;
6:
7: TYPE hedge_items IS TABLE OF xtr_hedge_criteria.criteria_code%TYPE INDEX BY BINARY_INTEGER;
8: TYPE hedge_conditions IS TABLE OF xtr_hedge_criteria.operator%TYPE INDEX BY BINARY_INTEGER;
9: TYPE hedge_values IS TABLE OF xtr_hedge_criteria.from_value%TYPE INDEX BY BINARY_INTEGER;
10:
11: TYPE criteria_set_rec_type IS RECORD (
12: criteria_set xtr_hedge_criteria.criteria_set%TYPE,

Line 9: TYPE hedge_values IS TABLE OF xtr_hedge_criteria.from_value%TYPE INDEX BY BINARY_INTEGER;

5: e_batch_been_run EXCEPTION;
6:
7: TYPE hedge_items IS TABLE OF xtr_hedge_criteria.criteria_code%TYPE INDEX BY BINARY_INTEGER;
8: TYPE hedge_conditions IS TABLE OF xtr_hedge_criteria.operator%TYPE INDEX BY BINARY_INTEGER;
9: TYPE hedge_values IS TABLE OF xtr_hedge_criteria.from_value%TYPE INDEX BY BINARY_INTEGER;
10:
11: TYPE criteria_set_rec_type IS RECORD (
12: criteria_set xtr_hedge_criteria.criteria_set%TYPE,
13: criteria_set_owner xtr_hedge_criteria.criteria_set_owner%TYPE,

Line 12: criteria_set xtr_hedge_criteria.criteria_set%TYPE,

8: TYPE hedge_conditions IS TABLE OF xtr_hedge_criteria.operator%TYPE INDEX BY BINARY_INTEGER;
9: TYPE hedge_values IS TABLE OF xtr_hedge_criteria.from_value%TYPE INDEX BY BINARY_INTEGER;
10:
11: TYPE criteria_set_rec_type IS RECORD (
12: criteria_set xtr_hedge_criteria.criteria_set%TYPE,
13: criteria_set_owner xtr_hedge_criteria.criteria_set_owner%TYPE,
14: source xtr_hedge_criteria.from_value%TYPE,
15: currency xtr_hedge_criteria.from_value%TYPE,
16: company_code xtr_hedge_criteria.from_value%TYPE,

Line 13: criteria_set_owner xtr_hedge_criteria.criteria_set_owner%TYPE,

9: TYPE hedge_values IS TABLE OF xtr_hedge_criteria.from_value%TYPE INDEX BY BINARY_INTEGER;
10:
11: TYPE criteria_set_rec_type IS RECORD (
12: criteria_set xtr_hedge_criteria.criteria_set%TYPE,
13: criteria_set_owner xtr_hedge_criteria.criteria_set_owner%TYPE,
14: source xtr_hedge_criteria.from_value%TYPE,
15: currency xtr_hedge_criteria.from_value%TYPE,
16: company_code xtr_hedge_criteria.from_value%TYPE,
17: sob_currency xtr_hedge_criteria.from_value%TYPE,

Line 14: source xtr_hedge_criteria.from_value%TYPE,

10:
11: TYPE criteria_set_rec_type IS RECORD (
12: criteria_set xtr_hedge_criteria.criteria_set%TYPE,
13: criteria_set_owner xtr_hedge_criteria.criteria_set_owner%TYPE,
14: source xtr_hedge_criteria.from_value%TYPE,
15: currency xtr_hedge_criteria.from_value%TYPE,
16: company_code xtr_hedge_criteria.from_value%TYPE,
17: sob_currency xtr_hedge_criteria.from_value%TYPE,
18: discount xtr_hedge_criteria.from_value%TYPE,

Line 15: currency xtr_hedge_criteria.from_value%TYPE,

11: TYPE criteria_set_rec_type IS RECORD (
12: criteria_set xtr_hedge_criteria.criteria_set%TYPE,
13: criteria_set_owner xtr_hedge_criteria.criteria_set_owner%TYPE,
14: source xtr_hedge_criteria.from_value%TYPE,
15: currency xtr_hedge_criteria.from_value%TYPE,
16: company_code xtr_hedge_criteria.from_value%TYPE,
17: sob_currency xtr_hedge_criteria.from_value%TYPE,
18: discount xtr_hedge_criteria.from_value%TYPE,
19: factor xtr_hedge_criteria.from_value%TYPE,

Line 16: company_code xtr_hedge_criteria.from_value%TYPE,

12: criteria_set xtr_hedge_criteria.criteria_set%TYPE,
13: criteria_set_owner xtr_hedge_criteria.criteria_set_owner%TYPE,
14: source xtr_hedge_criteria.from_value%TYPE,
15: currency xtr_hedge_criteria.from_value%TYPE,
16: company_code xtr_hedge_criteria.from_value%TYPE,
17: sob_currency xtr_hedge_criteria.from_value%TYPE,
18: discount xtr_hedge_criteria.from_value%TYPE,
19: factor xtr_hedge_criteria.from_value%TYPE,
20: due_date_from xtr_hedge_criteria.from_value%TYPE, --MUST MAINTAIN INVARIANT DATE TYPE OF RRRR/MM/DD

Line 17: sob_currency xtr_hedge_criteria.from_value%TYPE,

13: criteria_set_owner xtr_hedge_criteria.criteria_set_owner%TYPE,
14: source xtr_hedge_criteria.from_value%TYPE,
15: currency xtr_hedge_criteria.from_value%TYPE,
16: company_code xtr_hedge_criteria.from_value%TYPE,
17: sob_currency xtr_hedge_criteria.from_value%TYPE,
18: discount xtr_hedge_criteria.from_value%TYPE,
19: factor xtr_hedge_criteria.from_value%TYPE,
20: due_date_from xtr_hedge_criteria.from_value%TYPE, --MUST MAINTAIN INVARIANT DATE TYPE OF RRRR/MM/DD
21: due_date_to xtr_hedge_criteria.to_value%TYPE, --MUST MAINTAIN INVARIANT DATE TYPE OF RRRR/MM/DD

Line 18: discount xtr_hedge_criteria.from_value%TYPE,

14: source xtr_hedge_criteria.from_value%TYPE,
15: currency xtr_hedge_criteria.from_value%TYPE,
16: company_code xtr_hedge_criteria.from_value%TYPE,
17: sob_currency xtr_hedge_criteria.from_value%TYPE,
18: discount xtr_hedge_criteria.from_value%TYPE,
19: factor xtr_hedge_criteria.from_value%TYPE,
20: due_date_from xtr_hedge_criteria.from_value%TYPE, --MUST MAINTAIN INVARIANT DATE TYPE OF RRRR/MM/DD
21: due_date_to xtr_hedge_criteria.to_value%TYPE, --MUST MAINTAIN INVARIANT DATE TYPE OF RRRR/MM/DD
22: ar_unpld xtr_hedge_criteria.from_value%TYPE,

Line 19: factor xtr_hedge_criteria.from_value%TYPE,

15: currency xtr_hedge_criteria.from_value%TYPE,
16: company_code xtr_hedge_criteria.from_value%TYPE,
17: sob_currency xtr_hedge_criteria.from_value%TYPE,
18: discount xtr_hedge_criteria.from_value%TYPE,
19: factor xtr_hedge_criteria.from_value%TYPE,
20: due_date_from xtr_hedge_criteria.from_value%TYPE, --MUST MAINTAIN INVARIANT DATE TYPE OF RRRR/MM/DD
21: due_date_to xtr_hedge_criteria.to_value%TYPE, --MUST MAINTAIN INVARIANT DATE TYPE OF RRRR/MM/DD
22: ar_unpld xtr_hedge_criteria.from_value%TYPE,
23: ap_unpld xtr_hedge_criteria.from_value%TYPE,

Line 20: due_date_from xtr_hedge_criteria.from_value%TYPE, --MUST MAINTAIN INVARIANT DATE TYPE OF RRRR/MM/DD

16: company_code xtr_hedge_criteria.from_value%TYPE,
17: sob_currency xtr_hedge_criteria.from_value%TYPE,
18: discount xtr_hedge_criteria.from_value%TYPE,
19: factor xtr_hedge_criteria.from_value%TYPE,
20: due_date_from xtr_hedge_criteria.from_value%TYPE, --MUST MAINTAIN INVARIANT DATE TYPE OF RRRR/MM/DD
21: due_date_to xtr_hedge_criteria.to_value%TYPE, --MUST MAINTAIN INVARIANT DATE TYPE OF RRRR/MM/DD
22: ar_unpld xtr_hedge_criteria.from_value%TYPE,
23: ap_unpld xtr_hedge_criteria.from_value%TYPE,
24: condition_count NUMBER,

Line 21: due_date_to xtr_hedge_criteria.to_value%TYPE, --MUST MAINTAIN INVARIANT DATE TYPE OF RRRR/MM/DD

17: sob_currency xtr_hedge_criteria.from_value%TYPE,
18: discount xtr_hedge_criteria.from_value%TYPE,
19: factor xtr_hedge_criteria.from_value%TYPE,
20: due_date_from xtr_hedge_criteria.from_value%TYPE, --MUST MAINTAIN INVARIANT DATE TYPE OF RRRR/MM/DD
21: due_date_to xtr_hedge_criteria.to_value%TYPE, --MUST MAINTAIN INVARIANT DATE TYPE OF RRRR/MM/DD
22: ar_unpld xtr_hedge_criteria.from_value%TYPE,
23: ap_unpld xtr_hedge_criteria.from_value%TYPE,
24: condition_count NUMBER,
25: item hedge_items,

Line 22: ar_unpld xtr_hedge_criteria.from_value%TYPE,

18: discount xtr_hedge_criteria.from_value%TYPE,
19: factor xtr_hedge_criteria.from_value%TYPE,
20: due_date_from xtr_hedge_criteria.from_value%TYPE, --MUST MAINTAIN INVARIANT DATE TYPE OF RRRR/MM/DD
21: due_date_to xtr_hedge_criteria.to_value%TYPE, --MUST MAINTAIN INVARIANT DATE TYPE OF RRRR/MM/DD
22: ar_unpld xtr_hedge_criteria.from_value%TYPE,
23: ap_unpld xtr_hedge_criteria.from_value%TYPE,
24: condition_count NUMBER,
25: item hedge_items,
26: condition hedge_conditions,

Line 23: ap_unpld xtr_hedge_criteria.from_value%TYPE,

19: factor xtr_hedge_criteria.from_value%TYPE,
20: due_date_from xtr_hedge_criteria.from_value%TYPE, --MUST MAINTAIN INVARIANT DATE TYPE OF RRRR/MM/DD
21: due_date_to xtr_hedge_criteria.to_value%TYPE, --MUST MAINTAIN INVARIANT DATE TYPE OF RRRR/MM/DD
22: ar_unpld xtr_hedge_criteria.from_value%TYPE,
23: ap_unpld xtr_hedge_criteria.from_value%TYPE,
24: condition_count NUMBER,
25: item hedge_items,
26: condition hedge_conditions,
27: value hedge_values

Line 57: p_source IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,

53: p_where2 OUT NOCOPY VARCHAR2);
54:
55: PROCEDURE GET_HOAPR_REPORT_PARAMETERS(p_criteria_set_name VARCHAR2,
56: p_criteria_set_owner VARCHAR2,
57: p_source IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
58: p_currency IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
59: p_company_code IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
60: p_sob_currency IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
61: p_discount IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,

Line 58: p_currency IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,

54:
55: PROCEDURE GET_HOAPR_REPORT_PARAMETERS(p_criteria_set_name VARCHAR2,
56: p_criteria_set_owner VARCHAR2,
57: p_source IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
58: p_currency IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
59: p_company_code IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
60: p_sob_currency IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
61: p_discount IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
62: p_factor IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,

Line 59: p_company_code IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,

55: PROCEDURE GET_HOAPR_REPORT_PARAMETERS(p_criteria_set_name VARCHAR2,
56: p_criteria_set_owner VARCHAR2,
57: p_source IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
58: p_currency IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
59: p_company_code IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
60: p_sob_currency IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
61: p_discount IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
62: p_factor IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
63: p_due_date_from IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,

Line 60: p_sob_currency IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,

56: p_criteria_set_owner VARCHAR2,
57: p_source IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
58: p_currency IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
59: p_company_code IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
60: p_sob_currency IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
61: p_discount IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
62: p_factor IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
63: p_due_date_from IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
64: p_due_date_to IN OUT NOCOPY xtr_hedge_criteria.to_value%TYPE,

Line 61: p_discount IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,

57: p_source IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
58: p_currency IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
59: p_company_code IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
60: p_sob_currency IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
61: p_discount IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
62: p_factor IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
63: p_due_date_from IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
64: p_due_date_to IN OUT NOCOPY xtr_hedge_criteria.to_value%TYPE,
65: p_ar_unpld IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,

Line 62: p_factor IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,

58: p_currency IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
59: p_company_code IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
60: p_sob_currency IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
61: p_discount IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
62: p_factor IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
63: p_due_date_from IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
64: p_due_date_to IN OUT NOCOPY xtr_hedge_criteria.to_value%TYPE,
65: p_ar_unpld IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
66: p_ap_unpld IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,

Line 63: p_due_date_from IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,

59: p_company_code IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
60: p_sob_currency IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
61: p_discount IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
62: p_factor IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
63: p_due_date_from IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
64: p_due_date_to IN OUT NOCOPY xtr_hedge_criteria.to_value%TYPE,
65: p_ar_unpld IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
66: p_ap_unpld IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
67: p_ar_from OUT NOCOPY VARCHAR2,

Line 64: p_due_date_to IN OUT NOCOPY xtr_hedge_criteria.to_value%TYPE,

60: p_sob_currency IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
61: p_discount IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
62: p_factor IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
63: p_due_date_from IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
64: p_due_date_to IN OUT NOCOPY xtr_hedge_criteria.to_value%TYPE,
65: p_ar_unpld IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
66: p_ap_unpld IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
67: p_ar_from OUT NOCOPY VARCHAR2,
68: p_ap_from OUT NOCOPY VARCHAR2,

Line 65: p_ar_unpld IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,

61: p_discount IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
62: p_factor IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
63: p_due_date_from IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
64: p_due_date_to IN OUT NOCOPY xtr_hedge_criteria.to_value%TYPE,
65: p_ar_unpld IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
66: p_ap_unpld IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
67: p_ar_from OUT NOCOPY VARCHAR2,
68: p_ap_from OUT NOCOPY VARCHAR2,
69: p_ar_where OUT NOCOPY VARCHAR2,

Line 66: p_ap_unpld IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,

62: p_factor IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
63: p_due_date_from IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
64: p_due_date_to IN OUT NOCOPY xtr_hedge_criteria.to_value%TYPE,
65: p_ar_unpld IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
66: p_ap_unpld IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
67: p_ar_from OUT NOCOPY VARCHAR2,
68: p_ap_from OUT NOCOPY VARCHAR2,
69: p_ar_where OUT NOCOPY VARCHAR2,
70: p_ap_where OUT NOCOPY VARCHAR2);