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.OZF_MULTI_CURR_MIG_PVT dependencies on OZF_FUNDS_UTILIZED_ALL_B

Line 55: TYPE utilIdTbl IS TABLE OF ozf_funds_utilized_all_b.utilization_id%TYPE;

51: IS
52:
53:
54:
55: TYPE utilIdTbl IS TABLE OF ozf_funds_utilized_all_b.utilization_id%TYPE;
56: TYPE planIdTbl IS TABLE OF ozf_funds_utilized_all_b.plan_id%TYPE;
57: TYPE planCurrCodeTbl IS TABLE OF ozf_funds_utilized_all_b.plan_currency_code%TYPE;
58: TYPE fundReqCurrCodeTbl IS TABLE OF ozf_funds_utilized_all_b.fund_request_currency_code%TYPE;
59: TYPE orgIdTbl IS TABLE OF ozf_funds_utilized_all_b.org_id%TYPE;

Line 56: TYPE planIdTbl IS TABLE OF ozf_funds_utilized_all_b.plan_id%TYPE;

52:
53:
54:
55: TYPE utilIdTbl IS TABLE OF ozf_funds_utilized_all_b.utilization_id%TYPE;
56: TYPE planIdTbl IS TABLE OF ozf_funds_utilized_all_b.plan_id%TYPE;
57: TYPE planCurrCodeTbl IS TABLE OF ozf_funds_utilized_all_b.plan_currency_code%TYPE;
58: TYPE fundReqCurrCodeTbl IS TABLE OF ozf_funds_utilized_all_b.fund_request_currency_code%TYPE;
59: TYPE orgIdTbl IS TABLE OF ozf_funds_utilized_all_b.org_id%TYPE;
60: TYPE currCodeTbl IS TABLE OF ozf_funds_utilized_all_b.currency_code%TYPE;

Line 57: TYPE planCurrCodeTbl IS TABLE OF ozf_funds_utilized_all_b.plan_currency_code%TYPE;

53:
54:
55: TYPE utilIdTbl IS TABLE OF ozf_funds_utilized_all_b.utilization_id%TYPE;
56: TYPE planIdTbl IS TABLE OF ozf_funds_utilized_all_b.plan_id%TYPE;
57: TYPE planCurrCodeTbl IS TABLE OF ozf_funds_utilized_all_b.plan_currency_code%TYPE;
58: TYPE fundReqCurrCodeTbl IS TABLE OF ozf_funds_utilized_all_b.fund_request_currency_code%TYPE;
59: TYPE orgIdTbl IS TABLE OF ozf_funds_utilized_all_b.org_id%TYPE;
60: TYPE currCodeTbl IS TABLE OF ozf_funds_utilized_all_b.currency_code%TYPE;
61: TYPE planCurrAmtTbl IS TABLE OF ozf_funds_utilized_all_b.plan_curr_amount%TYPE;

Line 58: TYPE fundReqCurrCodeTbl IS TABLE OF ozf_funds_utilized_all_b.fund_request_currency_code%TYPE;

54:
55: TYPE utilIdTbl IS TABLE OF ozf_funds_utilized_all_b.utilization_id%TYPE;
56: TYPE planIdTbl IS TABLE OF ozf_funds_utilized_all_b.plan_id%TYPE;
57: TYPE planCurrCodeTbl IS TABLE OF ozf_funds_utilized_all_b.plan_currency_code%TYPE;
58: TYPE fundReqCurrCodeTbl IS TABLE OF ozf_funds_utilized_all_b.fund_request_currency_code%TYPE;
59: TYPE orgIdTbl IS TABLE OF ozf_funds_utilized_all_b.org_id%TYPE;
60: TYPE currCodeTbl IS TABLE OF ozf_funds_utilized_all_b.currency_code%TYPE;
61: TYPE planCurrAmtTbl IS TABLE OF ozf_funds_utilized_all_b.plan_curr_amount%TYPE;
62: TYPE planCurrAmtRemTbl IS TABLE OF ozf_funds_utilized_all_b.plan_curr_amount_remaining%TYPE;

Line 59: TYPE orgIdTbl IS TABLE OF ozf_funds_utilized_all_b.org_id%TYPE;

55: TYPE utilIdTbl IS TABLE OF ozf_funds_utilized_all_b.utilization_id%TYPE;
56: TYPE planIdTbl IS TABLE OF ozf_funds_utilized_all_b.plan_id%TYPE;
57: TYPE planCurrCodeTbl IS TABLE OF ozf_funds_utilized_all_b.plan_currency_code%TYPE;
58: TYPE fundReqCurrCodeTbl IS TABLE OF ozf_funds_utilized_all_b.fund_request_currency_code%TYPE;
59: TYPE orgIdTbl IS TABLE OF ozf_funds_utilized_all_b.org_id%TYPE;
60: TYPE currCodeTbl IS TABLE OF ozf_funds_utilized_all_b.currency_code%TYPE;
61: TYPE planCurrAmtTbl IS TABLE OF ozf_funds_utilized_all_b.plan_curr_amount%TYPE;
62: TYPE planCurrAmtRemTbl IS TABLE OF ozf_funds_utilized_all_b.plan_curr_amount_remaining%TYPE;
63: TYPE excTypeTbl IS TABLE OF ozf_funds_utilized_all_b.exchange_rate_type%TYPE;

Line 60: TYPE currCodeTbl IS TABLE OF ozf_funds_utilized_all_b.currency_code%TYPE;

56: TYPE planIdTbl IS TABLE OF ozf_funds_utilized_all_b.plan_id%TYPE;
57: TYPE planCurrCodeTbl IS TABLE OF ozf_funds_utilized_all_b.plan_currency_code%TYPE;
58: TYPE fundReqCurrCodeTbl IS TABLE OF ozf_funds_utilized_all_b.fund_request_currency_code%TYPE;
59: TYPE orgIdTbl IS TABLE OF ozf_funds_utilized_all_b.org_id%TYPE;
60: TYPE currCodeTbl IS TABLE OF ozf_funds_utilized_all_b.currency_code%TYPE;
61: TYPE planCurrAmtTbl IS TABLE OF ozf_funds_utilized_all_b.plan_curr_amount%TYPE;
62: TYPE planCurrAmtRemTbl IS TABLE OF ozf_funds_utilized_all_b.plan_curr_amount_remaining%TYPE;
63: TYPE excTypeTbl IS TABLE OF ozf_funds_utilized_all_b.exchange_rate_type%TYPE;
64: TYPE excDateTbl IS TABLE OF ozf_funds_utilized_all_b.exchange_rate_date%TYPE;

Line 61: TYPE planCurrAmtTbl IS TABLE OF ozf_funds_utilized_all_b.plan_curr_amount%TYPE;

57: TYPE planCurrCodeTbl IS TABLE OF ozf_funds_utilized_all_b.plan_currency_code%TYPE;
58: TYPE fundReqCurrCodeTbl IS TABLE OF ozf_funds_utilized_all_b.fund_request_currency_code%TYPE;
59: TYPE orgIdTbl IS TABLE OF ozf_funds_utilized_all_b.org_id%TYPE;
60: TYPE currCodeTbl IS TABLE OF ozf_funds_utilized_all_b.currency_code%TYPE;
61: TYPE planCurrAmtTbl IS TABLE OF ozf_funds_utilized_all_b.plan_curr_amount%TYPE;
62: TYPE planCurrAmtRemTbl IS TABLE OF ozf_funds_utilized_all_b.plan_curr_amount_remaining%TYPE;
63: TYPE excTypeTbl IS TABLE OF ozf_funds_utilized_all_b.exchange_rate_type%TYPE;
64: TYPE excDateTbl IS TABLE OF ozf_funds_utilized_all_b.exchange_rate_date%TYPE;
65:

Line 62: TYPE planCurrAmtRemTbl IS TABLE OF ozf_funds_utilized_all_b.plan_curr_amount_remaining%TYPE;

58: TYPE fundReqCurrCodeTbl IS TABLE OF ozf_funds_utilized_all_b.fund_request_currency_code%TYPE;
59: TYPE orgIdTbl IS TABLE OF ozf_funds_utilized_all_b.org_id%TYPE;
60: TYPE currCodeTbl IS TABLE OF ozf_funds_utilized_all_b.currency_code%TYPE;
61: TYPE planCurrAmtTbl IS TABLE OF ozf_funds_utilized_all_b.plan_curr_amount%TYPE;
62: TYPE planCurrAmtRemTbl IS TABLE OF ozf_funds_utilized_all_b.plan_curr_amount_remaining%TYPE;
63: TYPE excTypeTbl IS TABLE OF ozf_funds_utilized_all_b.exchange_rate_type%TYPE;
64: TYPE excDateTbl IS TABLE OF ozf_funds_utilized_all_b.exchange_rate_date%TYPE;
65:
66:

Line 63: TYPE excTypeTbl IS TABLE OF ozf_funds_utilized_all_b.exchange_rate_type%TYPE;

59: TYPE orgIdTbl IS TABLE OF ozf_funds_utilized_all_b.org_id%TYPE;
60: TYPE currCodeTbl IS TABLE OF ozf_funds_utilized_all_b.currency_code%TYPE;
61: TYPE planCurrAmtTbl IS TABLE OF ozf_funds_utilized_all_b.plan_curr_amount%TYPE;
62: TYPE planCurrAmtRemTbl IS TABLE OF ozf_funds_utilized_all_b.plan_curr_amount_remaining%TYPE;
63: TYPE excTypeTbl IS TABLE OF ozf_funds_utilized_all_b.exchange_rate_type%TYPE;
64: TYPE excDateTbl IS TABLE OF ozf_funds_utilized_all_b.exchange_rate_date%TYPE;
65:
66:
67: l_utilIdTbl utilIdTbl;

Line 64: TYPE excDateTbl IS TABLE OF ozf_funds_utilized_all_b.exchange_rate_date%TYPE;

60: TYPE currCodeTbl IS TABLE OF ozf_funds_utilized_all_b.currency_code%TYPE;
61: TYPE planCurrAmtTbl IS TABLE OF ozf_funds_utilized_all_b.plan_curr_amount%TYPE;
62: TYPE planCurrAmtRemTbl IS TABLE OF ozf_funds_utilized_all_b.plan_curr_amount_remaining%TYPE;
63: TYPE excTypeTbl IS TABLE OF ozf_funds_utilized_all_b.exchange_rate_type%TYPE;
64: TYPE excDateTbl IS TABLE OF ozf_funds_utilized_all_b.exchange_rate_date%TYPE;
65:
66:
67: l_utilIdTbl utilIdTbl;
68: l_planIdTbl planIdTbl;

Line 101: ozf_funds_utilized_all_b utiz

97: rpad(utiz.fund_request_currency_code ,20, ' '), utiz.plan_id
98: FROM
99: ozf_offers off,
100: qp_list_headers_all qpl,
101: ozf_funds_utilized_all_b utiz
102: WHERE
103: off.qp_list_header_id = utiz.plan_id
104: AND off.transaction_currency_code IS NULL
105: AND off.fund_request_curr_code <> utiz.plan_currency_code

Line 142: UPDATE /* PARALLEL */ ozf_funds_utilized_all_b

138: 2) fund_request_amount_remaining
139: 3) fund_request_currency_code
140: 4) plan_currency_code*/
141:
142: UPDATE /* PARALLEL */ ozf_funds_utilized_all_b
143: SET fund_request_amount = plan_curr_amount,
144: fund_request_amount_remaining = plan_curr_amount_remaining,
145: fund_request_currency_code = DECODE(plan_type,'OFFR', (SELECT NVL(transaction_currency_code,fund_request_curr_code)
146: FROM ozf_offers

Line 253: FROM ozf_funds_utilized_all_b

249: INSERT INTO OZF_MULTI_CURR_UTIL_BCK (SELECT utilization_id,
250: plan_curr_amount,
251: plan_curr_amount_remaining,
252: exchange_rate
253: FROM ozf_funds_utilized_all_b
254: WHERE NVL(plan_curr_amount,0) <> 0
255: AND plan_currency_code <> (SELECT fund_request_curr_code FROM ozf_offers WHERE qp_list_header_id=plan_id AND transaction_currency_code IS NULL)
256: AND plan_type='OFFR'
257: AND last_updated_by = -2);

Line 263: UPDATE /* PARALLEL */ ozf_funds_utilized_all_b

259: IF p_debug_flag = 'Y' THEN
260: ozf_utility_pvt.write_conc_log (' <===> Backup Completed <===>'||sql%rowcount||' rows inserted');
261: END IF;
262:
263: UPDATE /* PARALLEL */ ozf_funds_utilized_all_b
264: SET plan_curr_amount = gl_currency_api.convert_closest_amount_sql(fund_request_currency_code,plan_currency_code,
265: exchange_rate_date,exchange_rate_type,NULL,fund_request_amount,-1),
266: plan_curr_amount_remaining = gl_currency_api.convert_closest_amount_sql(fund_request_currency_code,plan_currency_code,
267: exchange_rate_date,exchange_rate_type,NULL,fund_request_amount_remaining,-1),