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_ACCRUAL_ENGINE dependencies on OZF_FUNDS_UTILIZED_ALL_B

Line 67: -- 06/12/2005 Ribha R12 Changes - populate new columns bill_to_site_use_id/ship_to_site_use_id in ozf_funds_utilized_all_b

63: -- 01/31/2005 kdass fixed 11.5.9 bug 4067266
64: -- 06/08/2005 kdass Bug 4415878 SQL Repository Fix - added the column object_id to the cursor c_old_adjustment_amount
65: -- in procedure adjust_changed_order. Now passed object_id to the cursor c_split_line
66: -- and added condition - AND header_id = p_header_id
67: -- 06/12/2005 Ribha R12 Changes - populate new columns bill_to_site_use_id/ship_to_site_use_id in ozf_funds_utilized_all_b
68: -- 06/26/2005 Ribha fixed bug 4173825 - get adjusted_amount from oe_price_adjustments
69: -- 06/26/2005 Ribha fixed bug 4417084 - for partial return order
70: -- 07/27/2005 Feliu add enhancement for R12 to insert order info to ozf_sales_transaction table.
71: -- 08/01/2005 Ribha R12: populate universal currency amount in ozf_funds_utilized_all_b

Line 71: -- 08/01/2005 Ribha R12: populate universal currency amount in ozf_funds_utilized_all_b

67: -- 06/12/2005 Ribha R12 Changes - populate new columns bill_to_site_use_id/ship_to_site_use_id in ozf_funds_utilized_all_b
68: -- 06/26/2005 Ribha fixed bug 4173825 - get adjusted_amount from oe_price_adjustments
69: -- 06/26/2005 Ribha fixed bug 4417084 - for partial return order
70: -- 07/27/2005 Feliu add enhancement for R12 to insert order info to ozf_sales_transaction table.
71: -- 08/01/2005 Ribha R12: populate universal currency amount in ozf_funds_utilized_all_b
72: -- 08/02/2005 Ribha R12: populate new table ozf_object_fund_summary
73: -- 09/21/2005 Ribha Bug Fix 4619156
74: -- 10/28/2005 Ribha fixed bug 4676217 (same as 3697213 in 1159)
75: -- 12/23/2005 kdass Bug 4778995 - removed columns month_id/quarter_id/year_id

Line 87: -- 17/01/2008 nirprasa Ship-Debit R12.1 Autopay Enhancement: 2)bill_to_site_use_id was incorrect in ozf_funds_utilized_all_b

83: -- 05/11/2007 nirprasa fixed bug 6140826 - don't post to GL the utilization amount having orig_utilization_id as -1
84: -- 10/01/2007 nirprasa fixed bug 6373391
85: -- 19/12/2007 psomyaju Ship-Debit R12.1 Enhancement: Added code for custom_setup_id 10445
86: -- 17/01/2008 nirprasa Ship-Debit R12.1 Offer Enhancement: 1)Create utilization even if committed amount is zero.
87: -- 17/01/2008 nirprasa Ship-Debit R12.1 Autopay Enhancement: 2)bill_to_site_use_id was incorrect in ozf_funds_utilized_all_b
88: -- table when offer's autopay party is Customer Name/Customer Bill To
89: -- 21/04/2008 psomyaju bug 6278466 - FP:11510-R12 6051298 - FUNDS EARNED NOT RECOGNISED AS ELIGBLE FOR CLAIM AND AUTO
90: -- 09/06/2008 nirprasa bug 7157394 - put the org_id assignment done for bug 6278466 only if beneficiary is not a customer.
91: -- Also, remove the initialization of org_id

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

101: g_universal_currency CONSTANT VARCHAR2 (15) := fnd_profile.VALUE ('OZF_UNIV_CURR_CODE');
102: g_order_gl_phase CONSTANT VARCHAR2 (15) := NVL(fnd_profile.VALUE ('OZF_ORDER_GLPOST_PHASE'), 'SHIPPED');
103: g_bulk_limit CONSTANT NUMBER := 5000; -- yzhao: Sep 8,2005 bulk fetch limit. It should get from profile.
104:
105: TYPE utilIdTbl IS TABLE OF ozf_funds_utilized_all_b.utilization_id%TYPE;
106: TYPE objVerTbl IS TABLE OF ozf_funds_utilized_all_b.object_version_number%TYPE;
107: TYPE amountTbl IS TABLE OF ozf_funds_utilized_all_b.amount%TYPE;
108: TYPE planTypeTbl IS TABLE OF ozf_funds_utilized_all_b.plan_type%TYPE;
109: TYPE planIdTbl IS TABLE OF ozf_funds_utilized_all_b.plan_id%TYPE;

Line 106: TYPE objVerTbl IS TABLE OF ozf_funds_utilized_all_b.object_version_number%TYPE;

102: g_order_gl_phase CONSTANT VARCHAR2 (15) := NVL(fnd_profile.VALUE ('OZF_ORDER_GLPOST_PHASE'), 'SHIPPED');
103: g_bulk_limit CONSTANT NUMBER := 5000; -- yzhao: Sep 8,2005 bulk fetch limit. It should get from profile.
104:
105: TYPE utilIdTbl IS TABLE OF ozf_funds_utilized_all_b.utilization_id%TYPE;
106: TYPE objVerTbl IS TABLE OF ozf_funds_utilized_all_b.object_version_number%TYPE;
107: TYPE amountTbl IS TABLE OF ozf_funds_utilized_all_b.amount%TYPE;
108: TYPE planTypeTbl IS TABLE OF ozf_funds_utilized_all_b.plan_type%TYPE;
109: TYPE planIdTbl IS TABLE OF ozf_funds_utilized_all_b.plan_id%TYPE;
110: TYPE planAmtTbl IS TABLE OF ozf_funds_utilized_all_b.plan_curr_amount%TYPE;

Line 107: TYPE amountTbl IS TABLE OF ozf_funds_utilized_all_b.amount%TYPE;

103: g_bulk_limit CONSTANT NUMBER := 5000; -- yzhao: Sep 8,2005 bulk fetch limit. It should get from profile.
104:
105: TYPE utilIdTbl IS TABLE OF ozf_funds_utilized_all_b.utilization_id%TYPE;
106: TYPE objVerTbl IS TABLE OF ozf_funds_utilized_all_b.object_version_number%TYPE;
107: TYPE amountTbl IS TABLE OF ozf_funds_utilized_all_b.amount%TYPE;
108: TYPE planTypeTbl IS TABLE OF ozf_funds_utilized_all_b.plan_type%TYPE;
109: TYPE planIdTbl IS TABLE OF ozf_funds_utilized_all_b.plan_id%TYPE;
110: TYPE planAmtTbl IS TABLE OF ozf_funds_utilized_all_b.plan_curr_amount%TYPE;
111: TYPE utilTypeTbl IS TABLE OF ozf_funds_utilized_all_b.utilization_type%TYPE;

Line 108: TYPE planTypeTbl IS TABLE OF ozf_funds_utilized_all_b.plan_type%TYPE;

104:
105: TYPE utilIdTbl IS TABLE OF ozf_funds_utilized_all_b.utilization_id%TYPE;
106: TYPE objVerTbl IS TABLE OF ozf_funds_utilized_all_b.object_version_number%TYPE;
107: TYPE amountTbl IS TABLE OF ozf_funds_utilized_all_b.amount%TYPE;
108: TYPE planTypeTbl IS TABLE OF ozf_funds_utilized_all_b.plan_type%TYPE;
109: TYPE planIdTbl IS TABLE OF ozf_funds_utilized_all_b.plan_id%TYPE;
110: TYPE planAmtTbl IS TABLE OF ozf_funds_utilized_all_b.plan_curr_amount%TYPE;
111: TYPE utilTypeTbl IS TABLE OF ozf_funds_utilized_all_b.utilization_type%TYPE;
112: TYPE fundIdTbl IS TABLE OF ozf_funds_utilized_all_b.fund_id%TYPE;

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

105: TYPE utilIdTbl IS TABLE OF ozf_funds_utilized_all_b.utilization_id%TYPE;
106: TYPE objVerTbl IS TABLE OF ozf_funds_utilized_all_b.object_version_number%TYPE;
107: TYPE amountTbl IS TABLE OF ozf_funds_utilized_all_b.amount%TYPE;
108: TYPE planTypeTbl IS TABLE OF ozf_funds_utilized_all_b.plan_type%TYPE;
109: TYPE planIdTbl IS TABLE OF ozf_funds_utilized_all_b.plan_id%TYPE;
110: TYPE planAmtTbl IS TABLE OF ozf_funds_utilized_all_b.plan_curr_amount%TYPE;
111: TYPE utilTypeTbl IS TABLE OF ozf_funds_utilized_all_b.utilization_type%TYPE;
112: TYPE fundIdTbl IS TABLE OF ozf_funds_utilized_all_b.fund_id%TYPE;
113: TYPE acctAmtTbl IS TABLE OF ozf_funds_utilized_all_b.acctd_amount%TYPE;

Line 110: TYPE planAmtTbl IS TABLE OF ozf_funds_utilized_all_b.plan_curr_amount%TYPE;

106: TYPE objVerTbl IS TABLE OF ozf_funds_utilized_all_b.object_version_number%TYPE;
107: TYPE amountTbl IS TABLE OF ozf_funds_utilized_all_b.amount%TYPE;
108: TYPE planTypeTbl IS TABLE OF ozf_funds_utilized_all_b.plan_type%TYPE;
109: TYPE planIdTbl IS TABLE OF ozf_funds_utilized_all_b.plan_id%TYPE;
110: TYPE planAmtTbl IS TABLE OF ozf_funds_utilized_all_b.plan_curr_amount%TYPE;
111: TYPE utilTypeTbl IS TABLE OF ozf_funds_utilized_all_b.utilization_type%TYPE;
112: TYPE fundIdTbl IS TABLE OF ozf_funds_utilized_all_b.fund_id%TYPE;
113: TYPE acctAmtTbl IS TABLE OF ozf_funds_utilized_all_b.acctd_amount%TYPE;
114: TYPE glDateTbl IS TABLE OF ozf_funds_utilized_all_b.gl_date%TYPE;

Line 111: TYPE utilTypeTbl IS TABLE OF ozf_funds_utilized_all_b.utilization_type%TYPE;

107: TYPE amountTbl IS TABLE OF ozf_funds_utilized_all_b.amount%TYPE;
108: TYPE planTypeTbl IS TABLE OF ozf_funds_utilized_all_b.plan_type%TYPE;
109: TYPE planIdTbl IS TABLE OF ozf_funds_utilized_all_b.plan_id%TYPE;
110: TYPE planAmtTbl IS TABLE OF ozf_funds_utilized_all_b.plan_curr_amount%TYPE;
111: TYPE utilTypeTbl IS TABLE OF ozf_funds_utilized_all_b.utilization_type%TYPE;
112: TYPE fundIdTbl IS TABLE OF ozf_funds_utilized_all_b.fund_id%TYPE;
113: TYPE acctAmtTbl IS TABLE OF ozf_funds_utilized_all_b.acctd_amount%TYPE;
114: TYPE glDateTbl IS TABLE OF ozf_funds_utilized_all_b.gl_date%TYPE;
115: TYPE orgIdTbl IS TABLE OF ozf_funds_utilized_all_b.org_id%TYPE;

Line 112: TYPE fundIdTbl IS TABLE OF ozf_funds_utilized_all_b.fund_id%TYPE;

108: TYPE planTypeTbl IS TABLE OF ozf_funds_utilized_all_b.plan_type%TYPE;
109: TYPE planIdTbl IS TABLE OF ozf_funds_utilized_all_b.plan_id%TYPE;
110: TYPE planAmtTbl IS TABLE OF ozf_funds_utilized_all_b.plan_curr_amount%TYPE;
111: TYPE utilTypeTbl IS TABLE OF ozf_funds_utilized_all_b.utilization_type%TYPE;
112: TYPE fundIdTbl IS TABLE OF ozf_funds_utilized_all_b.fund_id%TYPE;
113: TYPE acctAmtTbl IS TABLE OF ozf_funds_utilized_all_b.acctd_amount%TYPE;
114: TYPE glDateTbl IS TABLE OF ozf_funds_utilized_all_b.gl_date%TYPE;
115: TYPE orgIdTbl IS TABLE OF ozf_funds_utilized_all_b.org_id%TYPE;
116: TYPE priceAdjTbl IS TABLE OF ozf_funds_utilized_all_b.price_adjustment_id%TYPE ;

Line 113: TYPE acctAmtTbl IS TABLE OF ozf_funds_utilized_all_b.acctd_amount%TYPE;

109: TYPE planIdTbl IS TABLE OF ozf_funds_utilized_all_b.plan_id%TYPE;
110: TYPE planAmtTbl IS TABLE OF ozf_funds_utilized_all_b.plan_curr_amount%TYPE;
111: TYPE utilTypeTbl IS TABLE OF ozf_funds_utilized_all_b.utilization_type%TYPE;
112: TYPE fundIdTbl IS TABLE OF ozf_funds_utilized_all_b.fund_id%TYPE;
113: TYPE acctAmtTbl IS TABLE OF ozf_funds_utilized_all_b.acctd_amount%TYPE;
114: TYPE glDateTbl IS TABLE OF ozf_funds_utilized_all_b.gl_date%TYPE;
115: TYPE orgIdTbl IS TABLE OF ozf_funds_utilized_all_b.org_id%TYPE;
116: TYPE priceAdjTbl IS TABLE OF ozf_funds_utilized_all_b.price_adjustment_id%TYPE ;
117: TYPE objectIdTbl IS TABLE OF ozf_funds_utilized_all_b.object_id%TYPE ;

Line 114: TYPE glDateTbl IS TABLE OF ozf_funds_utilized_all_b.gl_date%TYPE;

110: TYPE planAmtTbl IS TABLE OF ozf_funds_utilized_all_b.plan_curr_amount%TYPE;
111: TYPE utilTypeTbl IS TABLE OF ozf_funds_utilized_all_b.utilization_type%TYPE;
112: TYPE fundIdTbl IS TABLE OF ozf_funds_utilized_all_b.fund_id%TYPE;
113: TYPE acctAmtTbl IS TABLE OF ozf_funds_utilized_all_b.acctd_amount%TYPE;
114: TYPE glDateTbl IS TABLE OF ozf_funds_utilized_all_b.gl_date%TYPE;
115: TYPE orgIdTbl IS TABLE OF ozf_funds_utilized_all_b.org_id%TYPE;
116: TYPE priceAdjTbl IS TABLE OF ozf_funds_utilized_all_b.price_adjustment_id%TYPE ;
117: TYPE objectIdTbl IS TABLE OF ozf_funds_utilized_all_b.object_id%TYPE ;
118:

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

111: TYPE utilTypeTbl IS TABLE OF ozf_funds_utilized_all_b.utilization_type%TYPE;
112: TYPE fundIdTbl IS TABLE OF ozf_funds_utilized_all_b.fund_id%TYPE;
113: TYPE acctAmtTbl IS TABLE OF ozf_funds_utilized_all_b.acctd_amount%TYPE;
114: TYPE glDateTbl IS TABLE OF ozf_funds_utilized_all_b.gl_date%TYPE;
115: TYPE orgIdTbl IS TABLE OF ozf_funds_utilized_all_b.org_id%TYPE;
116: TYPE priceAdjTbl IS TABLE OF ozf_funds_utilized_all_b.price_adjustment_id%TYPE ;
117: TYPE objectIdTbl IS TABLE OF ozf_funds_utilized_all_b.object_id%TYPE ;
118:
119: ----------------------------------------------------------------------------------

Line 116: TYPE priceAdjTbl IS TABLE OF ozf_funds_utilized_all_b.price_adjustment_id%TYPE ;

112: TYPE fundIdTbl IS TABLE OF ozf_funds_utilized_all_b.fund_id%TYPE;
113: TYPE acctAmtTbl IS TABLE OF ozf_funds_utilized_all_b.acctd_amount%TYPE;
114: TYPE glDateTbl IS TABLE OF ozf_funds_utilized_all_b.gl_date%TYPE;
115: TYPE orgIdTbl IS TABLE OF ozf_funds_utilized_all_b.org_id%TYPE;
116: TYPE priceAdjTbl IS TABLE OF ozf_funds_utilized_all_b.price_adjustment_id%TYPE ;
117: TYPE objectIdTbl IS TABLE OF ozf_funds_utilized_all_b.object_id%TYPE ;
118:
119: ----------------------------------------------------------------------------------
120: -- Procedure Name

Line 117: TYPE objectIdTbl IS TABLE OF ozf_funds_utilized_all_b.object_id%TYPE ;

113: TYPE acctAmtTbl IS TABLE OF ozf_funds_utilized_all_b.acctd_amount%TYPE;
114: TYPE glDateTbl IS TABLE OF ozf_funds_utilized_all_b.gl_date%TYPE;
115: TYPE orgIdTbl IS TABLE OF ozf_funds_utilized_all_b.org_id%TYPE;
116: TYPE priceAdjTbl IS TABLE OF ozf_funds_utilized_all_b.price_adjustment_id%TYPE ;
117: TYPE objectIdTbl IS TABLE OF ozf_funds_utilized_all_b.object_id%TYPE ;
118:
119: ----------------------------------------------------------------------------------
120: -- Procedure Name
121: -- calculate_accrual_amount

Line 190: FROM ozf_funds_utilized_all_b a2

186: get utilized amount.
187: -- rimehrot, commented for R12: use ozf_object_fund_summary table directly.
188: CURSOR c_get_utilized_amount(p_offer_id IN NUMBER, p_fund_id IN NUMBER) IS
189: SELECT SUM(NVL(a2.amount, 0)) amount
190: FROM ozf_funds_utilized_all_b a2
191: WHERE a2.plan_id = p_offer_id
192: AND a2.plan_type = 'OFFR'
193: AND a2.fund_id = p_fund_id
194: AND a2.utilization_type NOT IN ('REQUEST', 'TRANSFER', 'SALES_ACCRUAL');

Line 855: FROM ozf_funds_utilized_all_b

851:
852: CURSOR c_budget_request_utilrec(p_fund_id IN NUMBER, p_plan_id IN NUMBER, p_actbudget_id IN NUMBER) IS
853: SELECT utilization_id
854: , object_version_number
855: FROM ozf_funds_utilized_all_b
856: WHERE utilization_type = 'REQUEST'
857: AND fund_id = p_fund_id
858: AND plan_type = 'FUND'
859: AND plan_id = p_fund_id

Line 1264: column in ozf_funds_utilized_all_b */

1260: l_utilization_rec.univ_curr_amount_remaining := l_utilization_rec.plan_curr_amount_remaining;
1261: ELSE
1262: /*Added for bug 7030415 - Send the exchange rate
1263: Utilization amount is converted from request curr to universal curr to populate univ_curr_amount
1264: column in ozf_funds_utilized_all_b */
1265:
1266: IF g_debug_flag = 'Y' THEN
1267: ozf_utility_pvt.write_conc_log('**************************START****************************');
1268: ozf_utility_pvt.write_conc_log(l_api_name||' From Amount: '||l_utilization_rec.amount );

Line 1314: INSERT INTO ozf_funds_utilized_all_b

1310: RAISE fnd_api.g_exc_error;
1311: END IF;
1312: END IF; -- g_universal_currency = l_utilization_rec.currency_code
1313:
1314: INSERT INTO ozf_funds_utilized_all_b
1315: (utilization_id,last_update_date
1316: ,last_updated_by,last_update_login
1317: ,creation_date,created_by
1318: ,created_from,request_id

Line 1579: -- populate request amount in ozf_funds_utilized_all_b record

1575: RAISE fnd_api.g_exc_error;
1576: END IF;
1577: CLOSE c_budget_request_utilrec;
1578:
1579: -- populate request amount in ozf_funds_utilized_all_b record
1580: UPDATE ozf_funds_utilized_all_b
1581: SET amount = NVL(amount,0) + NVL(l_utilization_rec.amount,0)
1582: , plan_curr_amount = NVL(plan_curr_amount,0) + NVL(l_utilization_rec.plan_curr_amount,0)
1583: , univ_curr_amount = NVL(univ_curr_amount, 0) + NVL(l_utilization_rec.univ_curr_amount, 0)

Line 1580: UPDATE ozf_funds_utilized_all_b

1576: END IF;
1577: CLOSE c_budget_request_utilrec;
1578:
1579: -- populate request amount in ozf_funds_utilized_all_b record
1580: UPDATE ozf_funds_utilized_all_b
1581: SET amount = NVL(amount,0) + NVL(l_utilization_rec.amount,0)
1582: , plan_curr_amount = NVL(plan_curr_amount,0) + NVL(l_utilization_rec.plan_curr_amount,0)
1583: , univ_curr_amount = NVL(univ_curr_amount, 0) + NVL(l_utilization_rec.univ_curr_amount, 0)
1584: , acctd_amount = NVL(acctd_amount,0) + NVL(l_utilization_rec.acctd_amount,0)

Line 2127: of ozf_funds_utilized_all_b table*/

2123: -- Added for bug 7030415, get the order's org_id to get the exchange rate.
2124:
2125: /*Adjustment amount is converted from offer curr to budgets curr to populate
2126: parent_src_apprvd_amt column in izf_act_budgets table and amount column
2127: of ozf_funds_utilized_all_b table*/
2128:
2129: OPEN c_order_org_id(p_adj_amt_tbl(i).order_line_id);
2130: FETCH c_order_org_id INTO l_order_org_id;
2131: CLOSE c_order_org_id;

Line 2173: ozf_utility_pvt.write_conc_log('Adjustment amount is converted from offer curr to budgets curr to populate parent_src_apprvd_amt column in izf_act_budgets table and amount column of ozf_funds_utilized_all_b table');

2169: );
2170:
2171: IF g_debug_flag = 'Y' THEN
2172: ozf_utility_pvt.write_conc_log('post_accrual_to_budget' ||' Converted Amount l_converted_adj_amount: '|| l_converted_adj_amount);
2173: ozf_utility_pvt.write_conc_log('Adjustment amount is converted from offer curr to budgets curr to populate parent_src_apprvd_amt column in izf_act_budgets table and amount column of ozf_funds_utilized_all_b table');
2174: ozf_utility_pvt.write_conc_log('***************************END******************************');
2175: END IF;
2176:
2177: IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 2368: FROM ozf_funds_utilized_all_b

2364: WHERE list_line_id = p_list_line_id;
2365:
2366: CURSOR c_old_adjustment_amount (p_price_adjustment_id IN NUMBER) IS
2367: SELECT SUM (plan_curr_amount)
2368: FROM ozf_funds_utilized_all_b
2369: WHERE price_adjustment_id = p_price_adjustment_id
2370: AND object_type = 'ORDER';
2371:
2372: CURSOR c_order_count (p_header_id IN NUMBER) IS

Line 2390: FROM ozf_funds_utilized_all_b

2386: fund_id,
2387: currency_code,
2388: NVL (plan_curr_amount, 0) plan_curr_amount,
2389: gl_posted_flag, product_id,component_type,utilization_type
2390: FROM ozf_funds_utilized_all_b
2391: WHERE price_adjustment_id = p_price_adjustment_id
2392: AND object_type = 'ORDER';
2393: --GROUP BY fund_id, currency_code, price_adjustment_id, gl_posted_flag, product_id ;
2394:

Line 2397: FROM ozf_funds_utilized_all_b

2393: --GROUP BY fund_id, currency_code, price_adjustment_id, gl_posted_flag, product_id ;
2394:
2395: CURSOR c_get_util_rec(p_utilization_id IN NUMBER) IS
2396: SELECT object_version_number, plan_type, utilization_type, amount, fund_id, acctd_amount, plan_id, plan_curr_amount
2397: FROM ozf_funds_utilized_all_b
2398: WHERE utilization_id = p_utilization_id;
2399:
2400: CURSOR c_tm_offer (p_list_header_id IN NUMBER) IS
2401: SELECT nvl(transaction_currency_code,fund_request_curr_code) transaction_currency_code

Line 2407: FROM ozf_funds_utilized_all_b

2403: WHERE qp_list_header_id = p_list_header_id;
2404:
2405: CURSOR c_get_util (p_list_header_id IN NUMBER, p_header_id IN NUMBER, p_line_id IN NUMBER) IS
2406: SELECT 1
2407: FROM ozf_funds_utilized_all_b
2408: WHERE plan_type = 'OFFR'
2409: AND plan_id = p_list_header_id
2410: AND object_type = 'ORDER'
2411: AND object_id = p_header_id

Line 3007: FROM ozf_funds_utilized_all_b

3003: gl_posted_flag,plan_id,
3004: utilization_type,price_adjustment_id,
3005: adjustment_type,orig_utilization_id,
3006: exchange_rate_type --nirprasa
3007: FROM ozf_funds_utilized_all_b
3008: WHERE price_adjustment_id = p_price_adjustment_id
3009: AND object_type = 'ORDER'
3010: AND NVL(gl_posted_flag,'N') <> 'Y';
3011:

Line 3015: FROM ozf_funds_utilized_all_b

3011:
3012: -- yzhao: 03/21/2003 get old adjustment amount per price_adjustment_id, copy from adjust_accrual
3013: CURSOR c_old_adjustment_total_amount (p_price_adjustment_id IN NUMBER) IS
3014: SELECT SUM (plan_curr_amount) -- change to plan_curr_amount from acct_amount by feliu
3015: FROM ozf_funds_utilized_all_b
3016: WHERE price_adjustment_id = p_price_adjustment_id
3017: AND object_type = 'ORDER'
3018: AND utilization_type NOT IN ('ADJUSTMENT', 'LEAD_ADJUSTMENT'); -- remove adjustment amount on 08/03/04 by feliu
3019:

Line 3025: FROM ozf_funds_utilized_all_b

3021: -- changed for bug 6140826
3022: CURSOR c_get_accrual_rec(p_line_id IN NUMBER) IS
3023: SELECT utilization_id, object_version_number, plan_type, utilization_type, amount
3024: , fund_id, acctd_amount, plan_curr_amount, plan_id,org_id
3025: FROM ozf_funds_utilized_all_b
3026: WHERE price_adjustment_id IN (SELECT price_adjustment_id
3027: FROM oe_price_adjustments
3028: WHERE line_id = p_line_id)
3029: AND gl_posted_flag = G_GL_FLAG_NO -- 'N'

Line 3036: from ozf_funds_utilized_all_b

3032: AND utilization_type in ('ACCRUAL', 'LEAD_ACCRUAL','SALES_ACCRUAL')
3033: UNION ALL -- added for bug 5485334 kpatro
3034: select utilization_id, object_version_number, plan_type, utilization_type, amount
3035: , fund_id, acctd_amount, plan_curr_amount, plan_id,org_id
3036: from ozf_funds_utilized_all_b
3037: where object_type = 'ORDER'
3038: and order_line_id = p_line_id
3039: AND gl_posted_flag = G_GL_FLAG_NO
3040: AND utilization_type IN ('ADJUSTMENT','LEAD_ADJUSTMENT')

Line 3073: FROM ozf_funds_utilized_all_b

3069: AND list_header_id = p_header_id;
3070: -- add by feliu on 08/03/04, get max utilization id to use in create adjustment.
3071: CURSOR c_max_utilized_id(p_price_adj_id IN NUMBER) IS
3072: SELECT max(utilization_id)
3073: FROM ozf_funds_utilized_all_b
3074: WHERE price_adjustment_id = p_price_adj_id
3075: AND object_type = 'ORDER';
3076:
3077: CURSOR c_orig_order_info (p_line_id IN NUMBER) IS

Line 3088: FROM ozf_funds_utilized_all_b

3084: fund_id,currency_code,
3085: gl_posted_flag,plan_id,
3086: utilization_type,price_adjustment_id,
3087: adjustment_type,orig_utilization_id
3088: FROM ozf_funds_utilized_all_b
3089: WHERE order_line_id = p_order_line_id
3090: AND adjustment_type_id IN(-4,-5);
3091:
3092: --kdass bug 5953774

Line 3103: FROM ozf_funds_utilized_all_b

3099:
3100: --added for bug
3101: CURSOR c_old_adj_total_amount (p_order_line_id IN NUMBER) IS
3102: SELECT SUM (plan_curr_amount) -- change to plan_curr_amount from acct_amount by feliu
3103: FROM ozf_funds_utilized_all_b
3104: WHERE price_adjustment_id = -1
3105: and order_line_id=p_order_line_id
3106: AND object_type = 'ORDER'
3107: AND utilization_type IN ('ADJUSTMENT', 'LEAD_ADJUSTMENT'); --

Line 3115: FROM ozf_funds_utilized_all_b

3111: fund_id,currency_code,
3112: gl_posted_flag,plan_id,
3113: utilization_type,price_adjustment_id,
3114: adjustment_type,orig_utilization_id
3115: FROM ozf_funds_utilized_all_b
3116: WHERE price_adjustment_id = -1
3117: and order_line_id=p_order_line_id
3118: AND object_type = 'ORDER'
3119: AND utilization_id=(

Line 3121: FROM ozf_funds_utilized_all_b

3117: and order_line_id=p_order_line_id
3118: AND object_type = 'ORDER'
3119: AND utilization_id=(
3120: SELECT max(utilization_id)
3121: FROM ozf_funds_utilized_all_b
3122: WHERE price_adjustment_id = -1
3123: and order_line_id=p_order_line_id
3124: AND object_type = 'ORDER');
3125:

Line 3141: FROM ozf_funds_utilized_all_b

3137:
3138:
3139: CURSOR c_all_fund_utilizations (p_line_id IN NUMBER) IS
3140: SELECT price_adjustment_id , plan_id
3141: FROM ozf_funds_utilized_all_b
3142: WHERE order_line_id = p_line_id;
3143:
3144: CURSOR c_offer_type (p_offer_id IN NUMBER) IS
3145: SELECT offer_type

Line 3777: UPDATE ozf_funds_utilized_all_b

3773: , l_fundIdTbl, l_acctAmtTbl, l_planAmtTbl, l_planIdTbl,l_orgIdTbl
3774: LIMIT g_bulk_limit;
3775:
3776: FORALL t_i IN NVL(l_utilIdTbl.FIRST, 1) .. NVL(l_utilIdTbl.LAST, 0)
3777: UPDATE ozf_funds_utilized_all_b
3778: SET gl_date = l_gl_date
3779: WHERE utilization_id = l_utilIdTbl(t_i);
3780:
3781: FOR t_i IN NVL(l_utilIdTbl.FIRST, 1) .. NVL(l_utilIdTbl.LAST, 0)

Line 4741: UPDATE ozf_funds_utilized_all_b

4737:
4738: END IF; --l_gl_posted_flag = G_GL_FLAG_NO
4739:
4740: -- update utilization gl_posted_flag directly to avoid all validations
4741: UPDATE ozf_funds_utilized_all_b
4742: SET last_update_date = SYSDATE
4743: , last_updated_by = NVL (fnd_global.user_id, -1)
4744: , last_update_login = NVL (fnd_global.conc_login_id, -1)
4745: , object_version_number = p_util_object_version_number + 1

Line 4951: FROM ozf_funds_utilized_all_b

4947: CURSOR c_get_failed_gl_posting IS
4948: SELECT utilization_id, object_version_number,
4949: plan_type, utilization_type,
4950: amount, fund_id, acctd_amount, plan_curr_amount, plan_id,org_id
4951: FROM ozf_funds_utilized_all_b
4952: WHERE plan_type IN ( 'OFFR' , 'PRIC') -- yzhao: 10/20/2003 PRICE_LIST is changed to PRIC
4953: -- AND utilization_type = 'ACCRUAL' yzhao: 01/29/2004 11.5.10 off-invoice offer, LEAD_ACCRUAL may post to GL too
4954: AND gl_posted_flag = G_GL_FLAG_FAIL; -- 'F';
4955:

Line 5063: FROM ozf_funds_utilized_all_b

5059: SELECT utilization_id, object_version_number,
5060: plan_type, utilization_type,
5061: amount, fund_id, acctd_amount, plan_curr_amount, plan_id
5062: ,org_id,object_id, price_adjustment_id
5063: FROM ozf_funds_utilized_all_b
5064: WHERE utilization_type = 'UTILIZED'
5065: AND gl_posted_flag = G_GL_FLAG_NO -- 'N'
5066: AND object_type = 'ORDER'
5067: AND price_adjustment_id IS NOT NULL;

Line 5132: UPDATE ozf_funds_utilized_all_b

5128: l_gl_date := sysdate;
5129: END IF;
5130:
5131: FORALL t_i IN NVL(l_utilIdTbl.FIRST, 1) .. NVL(l_utilIdTbl.LAST, 0)
5132: UPDATE ozf_funds_utilized_all_b
5133: SET gl_date = l_gl_date
5134: WHERE utilization_id = l_utilIdTbl(t_i);
5135:
5136: post_accrual_to_gl( p_util_utilization_id => l_utilIdTbl(i)

Line 5232: FROM ozf_funds_utilized_all_b

5228: -- yzhao: 03/04/2004 get related accraul records, post to GL
5229: CURSOR c_get_related_accrual IS
5230: SELECT utilization_id, object_version_number, plan_type, utilization_type, amount
5231: , fund_id, acctd_amount, plan_curr_amount, plan_id,org_id
5232: FROM ozf_funds_utilized_all_b
5233: WHERE (gl_posted_flag = G_GL_FLAG_NO OR gl_posted_flag = G_GL_FLAG_FAIL)
5234: AND orig_utilization_id = p_utilization_id;
5235:
5236: BEGIN

Line 5255: UPDATE ozf_funds_utilized_all_b

5251: LIMIT g_bulk_limit;
5252:
5253: IF p_gl_date IS NOT NULL THEN
5254: FORALL i IN NVL(l_utilIdTbl.FIRST, 1) .. NVL(l_utilIdTbl.LAST, 0)
5255: UPDATE ozf_funds_utilized_all_b
5256: SET gl_date = p_gl_date
5257: WHERE utilization_id = l_utilIdTbl(i);
5258: END IF;
5259: