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 2002: from xtr_hedge_criteria hc,

1998: l_pct NUMBER := 0;
1999:
2000: cursor source(hedge_no in NUMBER) is
2001: select st.source_type_id, instrument_item_flag
2002: from xtr_hedge_criteria hc,
2003: xtr_source_types st
2004: where hedge_attribute_id = hedge_no
2005: and hc.from_value = st.source_code
2006: and criteria_type = 'BASIC'

Line 2363: from xtr_hedge_criteria

2359: l_currency XTR_MASTER_CURRENCIES.CURRENCY%TYPE;
2360:
2361: cursor source(hedge_no in NUMBER) is
2362: select from_value
2363: from xtr_hedge_criteria
2364: where hedge_attribute_id = hedge_no
2365: and criteria_type = 'BASIC'
2366: and criteria_code = 'ITEM_SOURCE';
2367:

Line 2368: l_source XTR_HEDGE_CRITERIA.FROM_VALUE%TYPE;

2364: where hedge_attribute_id = hedge_no
2365: and criteria_type = 'BASIC'
2366: and criteria_code = 'ITEM_SOURCE';
2367:
2368: l_source XTR_HEDGE_CRITERIA.FROM_VALUE%TYPE;
2369:
2370: cursor basic_crit(hedge_no in NUMBER) is
2371: --select from_value, to_value
2372: select fnd_date.canonical_to_date(from_value), fnd_date.canonical_to_date(to_value)

Line 2373: from xtr_hedge_criteria

2369:
2370: cursor basic_crit(hedge_no in NUMBER) is
2371: --select from_value, to_value
2372: select fnd_date.canonical_to_date(from_value), fnd_date.canonical_to_date(to_value)
2373: from xtr_hedge_criteria
2374: where hedge_attribute_id = hedge_no
2375: and criteria_type = 'BASIC'
2376: and criteria_code = 'TRX_DATES';
2377:

Line 2378: --l_from_value XTR_HEDGE_CRITERIA.FROM_VALUE%TYPE;

2374: where hedge_attribute_id = hedge_no
2375: and criteria_type = 'BASIC'
2376: and criteria_code = 'TRX_DATES';
2377:
2378: --l_from_value XTR_HEDGE_CRITERIA.FROM_VALUE%TYPE;
2379: --l_to_value XTR_HEDGE_CRITERIA.TO_VALUE%TYPE;
2380:
2381: l_from_value DATE;
2382: l_to_value DATE;

Line 2379: --l_to_value XTR_HEDGE_CRITERIA.TO_VALUE%TYPE;

2375: and criteria_type = 'BASIC'
2376: and criteria_code = 'TRX_DATES';
2377:
2378: --l_from_value XTR_HEDGE_CRITERIA.FROM_VALUE%TYPE;
2379: --l_to_value XTR_HEDGE_CRITERIA.TO_VALUE%TYPE;
2380:
2381: l_from_value DATE;
2382: l_to_value DATE;
2383:

Line 2386: from xtr_hedge_criteria

2382: l_to_value DATE;
2383:
2384: cursor adv_crit(hedge_no in NUMBER) is
2385: select criteria_code,operator,from_value
2386: from xtr_hedge_criteria
2387: where criteria_type = 'ADVANCED'
2388: and hedge_attribute_id = hedge_no;
2389:
2390: Begin

Line 2439: from xtr_hedge_criteria hc,

2435: FUNCTION GET_SOURCE_CODE(P_HEDGE_NO IN NUMBER) RETURN VARCHAR2 IS
2436:
2437: cursor source(hedge_no in NUMBER) is
2438: select st.source_code
2439: from xtr_hedge_criteria hc,
2440: xtr_source_types st
2441: where hedge_attribute_id = hedge_no
2442: and hc.from_value = st.source_code
2443: and criteria_type = 'BASIC'

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

2707: This code was essentially extracted from the FIND_ARAP forms procedure
2708: */
2709: PROCEDURE GET_HOAPR_REPORT_PARAMETERS(p_criteria_set_name VARCHAR2,
2710: p_criteria_set_owner VARCHAR2,
2711: p_source IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2712: p_currency IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2713: p_company_code IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2714: p_sob_currency IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2715: p_discount IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,

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

2708: */
2709: PROCEDURE GET_HOAPR_REPORT_PARAMETERS(p_criteria_set_name VARCHAR2,
2710: p_criteria_set_owner VARCHAR2,
2711: p_source IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2712: p_currency IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2713: p_company_code IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2714: p_sob_currency IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2715: p_discount IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2716: p_factor IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,

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

2709: PROCEDURE GET_HOAPR_REPORT_PARAMETERS(p_criteria_set_name VARCHAR2,
2710: p_criteria_set_owner VARCHAR2,
2711: p_source IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2712: p_currency IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2713: p_company_code IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2714: p_sob_currency IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2715: p_discount IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2716: p_factor IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2717: p_due_date_from IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,

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

2710: p_criteria_set_owner VARCHAR2,
2711: p_source IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2712: p_currency IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2713: p_company_code IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2714: p_sob_currency IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2715: p_discount IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2716: p_factor IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2717: p_due_date_from IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2718: p_due_date_to IN OUT NOCOPY xtr_hedge_criteria.to_value%TYPE,

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

2711: p_source IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2712: p_currency IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2713: p_company_code IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2714: p_sob_currency IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2715: p_discount IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2716: p_factor IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2717: p_due_date_from IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2718: p_due_date_to IN OUT NOCOPY xtr_hedge_criteria.to_value%TYPE,
2719: p_ar_unpld IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,

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

2712: p_currency IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2713: p_company_code IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2714: p_sob_currency IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2715: p_discount IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2716: p_factor IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2717: p_due_date_from IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2718: p_due_date_to IN OUT NOCOPY xtr_hedge_criteria.to_value%TYPE,
2719: p_ar_unpld IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2720: p_ap_unpld IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,

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

2713: p_company_code IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2714: p_sob_currency IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2715: p_discount IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2716: p_factor IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2717: p_due_date_from IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2718: p_due_date_to IN OUT NOCOPY xtr_hedge_criteria.to_value%TYPE,
2719: p_ar_unpld IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2720: p_ap_unpld IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2721: p_ar_from OUT NOCOPY VARCHAR2,

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

2714: p_sob_currency IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2715: p_discount IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2716: p_factor IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2717: p_due_date_from IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2718: p_due_date_to IN OUT NOCOPY xtr_hedge_criteria.to_value%TYPE,
2719: p_ar_unpld IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2720: p_ap_unpld IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2721: p_ar_from OUT NOCOPY VARCHAR2,
2722: p_ap_from OUT NOCOPY VARCHAR2,

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

2715: p_discount IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2716: p_factor IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2717: p_due_date_from IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2718: p_due_date_to IN OUT NOCOPY xtr_hedge_criteria.to_value%TYPE,
2719: p_ar_unpld IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2720: p_ap_unpld IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2721: p_ar_from OUT NOCOPY VARCHAR2,
2722: p_ap_from OUT NOCOPY VARCHAR2,
2723: p_ar_where OUT NOCOPY VARCHAR2,

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

2716: p_factor IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2717: p_due_date_from IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2718: p_due_date_to IN OUT NOCOPY xtr_hedge_criteria.to_value%TYPE,
2719: p_ar_unpld IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2720: p_ap_unpld IN OUT NOCOPY xtr_hedge_criteria.from_value%TYPE,
2721: p_ar_from OUT NOCOPY VARCHAR2,
2722: p_ap_from OUT NOCOPY VARCHAR2,
2723: p_ar_where OUT NOCOPY VARCHAR2,
2724: p_ap_where OUT NOCOPY VARCHAR2) IS

Line 2740: from xtr_hedge_criteria

2736:
2737: if (p_criteria_set_name is not null) then
2738: select count(*)
2739: into n_dummy
2740: from xtr_hedge_criteria
2741: where criteria_set = p_criteria_set_name
2742: and criteria_set_owner = p_criteria_set_owner;
2743:
2744: if (n_dummy > 0) then

Line 2826: 3) For every non null criteria add a row into xtr_hedge_criteria

2822: into the table.
2823: 1) if no set name is specified, raise an exception
2824: 2) if name matches already used name, load, retain, and use creator id and created date
2825: delete all rows that belong to the matching set
2826: 3) For every non null criteria add a row into xtr_hedge_criteria
2827: Note: date is saved relative to system date.
2828: */
2829: PROCEDURE SAVE_CRITERIA_SET(p_crit_set CRITERIA_SET_REC_TYPE) IS
2830:

Line 2839: from xtr_hedge_criteria

2835: v_create_date DATE;
2836:
2837: cursor get_old_set_info(p_criteria_set varchar2,p_criteria_set_owner number) is
2838: select created_by,creation_date
2839: from xtr_hedge_criteria
2840: where criteria_set = p_criteria_set
2841: and (criteria_set_owner = p_criteria_set_owner
2842: or (criteria_set_owner is null
2843: and p_criteria_set_owner is null

Line 2855: insert into xtr_hedge_criteria(hedge_criteria_id,

2851: p_from in VARCHAR2,
2852: p_to in VARCHAR2 default NULL) IS
2853: BEGIN
2854: if (p_from is not null) then
2855: insert into xtr_hedge_criteria(hedge_criteria_id,
2856: criteria_type,
2857: criteria_code,
2858: operator,
2859: from_value,

Line 2868: values(xtr_hedge_criteria_s.nextval,

2864: last_update_date,
2865: last_update_login,
2866: criteria_set,
2867: criteria_set_owner)
2868: values(xtr_hedge_criteria_s.nextval,
2869: p_type,
2870: p_code,
2871: p_operator,
2872: p_from,

Line 2924: information to load all the details from xtr_hedge_criteria

2920: END SAVE_CRITERIA_SET;
2921:
2922: /* LOAD_CRITERIA_SET works in the opposite manner as SAVE_CRITERIA_SET
2923: This time, the procedure is given a set name and owner and uses that
2924: information to load all the details from xtr_hedge_criteria
2925: */
2926: PROCEDURE LOAD_CRITERIA_SET(p_crit_set IN OUT NOCOPY CRITERIA_SET_REC_TYPE) IS
2927:
2928: v_dummy xtr_hedge_criteria.to_value%type;

Line 2928: v_dummy xtr_hedge_criteria.to_value%type;

2924: information to load all the details from xtr_hedge_criteria
2925: */
2926: PROCEDURE LOAD_CRITERIA_SET(p_crit_set IN OUT NOCOPY CRITERIA_SET_REC_TYPE) IS
2927:
2928: v_dummy xtr_hedge_criteria.to_value%type;
2929: i Number;
2930:
2931: cursor get_advanced_criteria is
2932: select criteria_code,operator,from_value

Line 2933: from xtr_hedge_criteria

2929: i Number;
2930:
2931: cursor get_advanced_criteria is
2932: select criteria_code,operator,from_value
2933: from xtr_hedge_criteria
2934: where criteria_type='ADVANCED'
2935: and criteria_set = p_crit_set.criteria_set
2936: and (criteria_set_owner = p_crit_set.criteria_set_owner
2937: or (criteria_set_owner is null

Line 2944: from xtr_hedge_criteria

2940: );
2941:
2942: cursor get_basic_criteria(p_criteria_code VARCHAR2) is
2943: select from_value,to_value
2944: from xtr_hedge_criteria
2945: where criteria_type = 'BASIC'
2946: and criteria_code = p_criteria_code
2947: and criteria_set = p_crit_set.criteria_set
2948: and (criteria_set_owner = p_crit_set.criteria_set_owner

Line 2995: /* DELETE_CRITERIA_SET removes all rows from xtr_hedge_criteria

2991:
2992:
2993:
2994:
2995: /* DELETE_CRITERIA_SET removes all rows from xtr_hedge_criteria
2996: that match the set name and owner
2997: */
2998: PROCEDURE DELETE_CRITERIA_SET(p_crit_set CRITERIA_SET_REC_TYPE) IS
2999: BEGIN

Line 3000: DELETE xtr_hedge_criteria

2996: that match the set name and owner
2997: */
2998: PROCEDURE DELETE_CRITERIA_SET(p_crit_set CRITERIA_SET_REC_TYPE) IS
2999: BEGIN
3000: DELETE xtr_hedge_criteria
3001: WHERE criteria_set = p_crit_set.criteria_set
3002: AND (
3003: criteria_set_owner = p_crit_set.criteria_set_owner
3004: or