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 119: -- 29/Mar/2012 nirprasa Bug 13824967 FAILED TRANSACTIONS IN OZF_FUNDS_UTILIZED_ALL_B

115: -- correct values of l_orig_amt and l_rollup_orig_amt for Sales Accrual Budget.
116: -- 12/Jan/2012 nirprasa Bug 13463758 MULTIPLE BATCH LINES FOR A SALES ORDER WITH MULTIPLE SALES ORDER LINES IN DIFFER
117: -- 23-Jan-2012 ninarasi Bug 13530939 Added year id changes which got missed out (Was originally added in version 120.56.12010000.22)
118: -- 26/Feb/2012 nirprasa Bug 13742169 AIT: FAE PERFORMANCE ISSUE - meeged 120.56.12010000.36 + bugfix 13742169
119: -- 29/Mar/2012 nirprasa Bug 13824967 FAILED TRANSACTIONS IN OZF_FUNDS_UTILIZED_ALL_B
120: -- 31/Oct/2012 ninarasi Bug 14750730 SUB LEDGER ACCOUNTING ERRORS DUE TO A TERMINATED OFFER
121: -- 30/Nov/2012 ninarasi Bug 15877269 OFFER IN TRADE PLANNING CREATING IMPROPER ADJUSTMENTS
122: -- 01/16/2013 ninarasi Bug 16029659 - OFFER IN TRADE PLANNING CREATING IMPROPER ADJUSTMENTS
123: -- 1/29/2013 nepanda Bug 16235187 - ER - MULTI UOM FULFILLMENT WITH CATCH WEIGHT

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

134: --//13333298
135: G_TPM_PROCESS_ENABLED VARCHAR2 (1) := NVL(fnd_profile.VALUE ('OZF_TPM_PROCESS_ENABLED'),'N');
136:
137:
138: TYPE utilIdTbl IS TABLE OF ozf_funds_utilized_all_b.utilization_id%TYPE;
139: TYPE objVerTbl IS TABLE OF ozf_funds_utilized_all_b.object_version_number%TYPE;
140: TYPE amountTbl IS TABLE OF ozf_funds_utilized_all_b.amount%TYPE;
141: TYPE planTypeTbl IS TABLE OF ozf_funds_utilized_all_b.plan_type%TYPE;
142: TYPE planIdTbl IS TABLE OF ozf_funds_utilized_all_b.plan_id%TYPE;

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

135: G_TPM_PROCESS_ENABLED VARCHAR2 (1) := NVL(fnd_profile.VALUE ('OZF_TPM_PROCESS_ENABLED'),'N');
136:
137:
138: TYPE utilIdTbl IS TABLE OF ozf_funds_utilized_all_b.utilization_id%TYPE;
139: TYPE objVerTbl IS TABLE OF ozf_funds_utilized_all_b.object_version_number%TYPE;
140: TYPE amountTbl IS TABLE OF ozf_funds_utilized_all_b.amount%TYPE;
141: TYPE planTypeTbl IS TABLE OF ozf_funds_utilized_all_b.plan_type%TYPE;
142: TYPE planIdTbl IS TABLE OF ozf_funds_utilized_all_b.plan_id%TYPE;
143: TYPE planAmtTbl IS TABLE OF ozf_funds_utilized_all_b.plan_curr_amount%TYPE;

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

136:
137:
138: TYPE utilIdTbl IS TABLE OF ozf_funds_utilized_all_b.utilization_id%TYPE;
139: TYPE objVerTbl IS TABLE OF ozf_funds_utilized_all_b.object_version_number%TYPE;
140: TYPE amountTbl IS TABLE OF ozf_funds_utilized_all_b.amount%TYPE;
141: TYPE planTypeTbl IS TABLE OF ozf_funds_utilized_all_b.plan_type%TYPE;
142: TYPE planIdTbl IS TABLE OF ozf_funds_utilized_all_b.plan_id%TYPE;
143: TYPE planAmtTbl IS TABLE OF ozf_funds_utilized_all_b.plan_curr_amount%TYPE;
144: TYPE utilTypeTbl IS TABLE OF ozf_funds_utilized_all_b.utilization_type%TYPE;

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

137:
138: TYPE utilIdTbl IS TABLE OF ozf_funds_utilized_all_b.utilization_id%TYPE;
139: TYPE objVerTbl IS TABLE OF ozf_funds_utilized_all_b.object_version_number%TYPE;
140: TYPE amountTbl IS TABLE OF ozf_funds_utilized_all_b.amount%TYPE;
141: TYPE planTypeTbl IS TABLE OF ozf_funds_utilized_all_b.plan_type%TYPE;
142: TYPE planIdTbl IS TABLE OF ozf_funds_utilized_all_b.plan_id%TYPE;
143: TYPE planAmtTbl IS TABLE OF ozf_funds_utilized_all_b.plan_curr_amount%TYPE;
144: TYPE utilTypeTbl IS TABLE OF ozf_funds_utilized_all_b.utilization_type%TYPE;
145: TYPE fundIdTbl IS TABLE OF ozf_funds_utilized_all_b.fund_id%TYPE;

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

138: TYPE utilIdTbl IS TABLE OF ozf_funds_utilized_all_b.utilization_id%TYPE;
139: TYPE objVerTbl IS TABLE OF ozf_funds_utilized_all_b.object_version_number%TYPE;
140: TYPE amountTbl IS TABLE OF ozf_funds_utilized_all_b.amount%TYPE;
141: TYPE planTypeTbl IS TABLE OF ozf_funds_utilized_all_b.plan_type%TYPE;
142: TYPE planIdTbl IS TABLE OF ozf_funds_utilized_all_b.plan_id%TYPE;
143: TYPE planAmtTbl IS TABLE OF ozf_funds_utilized_all_b.plan_curr_amount%TYPE;
144: TYPE utilTypeTbl IS TABLE OF ozf_funds_utilized_all_b.utilization_type%TYPE;
145: TYPE fundIdTbl IS TABLE OF ozf_funds_utilized_all_b.fund_id%TYPE;
146: TYPE acctAmtTbl IS TABLE OF ozf_funds_utilized_all_b.acctd_amount%TYPE;

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

139: TYPE objVerTbl IS TABLE OF ozf_funds_utilized_all_b.object_version_number%TYPE;
140: TYPE amountTbl IS TABLE OF ozf_funds_utilized_all_b.amount%TYPE;
141: TYPE planTypeTbl IS TABLE OF ozf_funds_utilized_all_b.plan_type%TYPE;
142: TYPE planIdTbl IS TABLE OF ozf_funds_utilized_all_b.plan_id%TYPE;
143: TYPE planAmtTbl IS TABLE OF ozf_funds_utilized_all_b.plan_curr_amount%TYPE;
144: TYPE utilTypeTbl IS TABLE OF ozf_funds_utilized_all_b.utilization_type%TYPE;
145: TYPE fundIdTbl IS TABLE OF ozf_funds_utilized_all_b.fund_id%TYPE;
146: TYPE acctAmtTbl IS TABLE OF ozf_funds_utilized_all_b.acctd_amount%TYPE;
147: TYPE glDateTbl IS TABLE OF ozf_funds_utilized_all_b.gl_date%TYPE;

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

140: TYPE amountTbl IS TABLE OF ozf_funds_utilized_all_b.amount%TYPE;
141: TYPE planTypeTbl IS TABLE OF ozf_funds_utilized_all_b.plan_type%TYPE;
142: TYPE planIdTbl IS TABLE OF ozf_funds_utilized_all_b.plan_id%TYPE;
143: TYPE planAmtTbl IS TABLE OF ozf_funds_utilized_all_b.plan_curr_amount%TYPE;
144: TYPE utilTypeTbl IS TABLE OF ozf_funds_utilized_all_b.utilization_type%TYPE;
145: TYPE fundIdTbl IS TABLE OF ozf_funds_utilized_all_b.fund_id%TYPE;
146: TYPE acctAmtTbl IS TABLE OF ozf_funds_utilized_all_b.acctd_amount%TYPE;
147: TYPE glDateTbl IS TABLE OF ozf_funds_utilized_all_b.gl_date%TYPE;
148: TYPE orgIdTbl IS TABLE OF ozf_funds_utilized_all_b.org_id%TYPE;

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

141: TYPE planTypeTbl IS TABLE OF ozf_funds_utilized_all_b.plan_type%TYPE;
142: TYPE planIdTbl IS TABLE OF ozf_funds_utilized_all_b.plan_id%TYPE;
143: TYPE planAmtTbl IS TABLE OF ozf_funds_utilized_all_b.plan_curr_amount%TYPE;
144: TYPE utilTypeTbl IS TABLE OF ozf_funds_utilized_all_b.utilization_type%TYPE;
145: TYPE fundIdTbl IS TABLE OF ozf_funds_utilized_all_b.fund_id%TYPE;
146: TYPE acctAmtTbl IS TABLE OF ozf_funds_utilized_all_b.acctd_amount%TYPE;
147: TYPE glDateTbl IS TABLE OF ozf_funds_utilized_all_b.gl_date%TYPE;
148: TYPE orgIdTbl IS TABLE OF ozf_funds_utilized_all_b.org_id%TYPE;
149: TYPE priceAdjTbl IS TABLE OF ozf_funds_utilized_all_b.price_adjustment_id%TYPE ;

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

142: TYPE planIdTbl IS TABLE OF ozf_funds_utilized_all_b.plan_id%TYPE;
143: TYPE planAmtTbl IS TABLE OF ozf_funds_utilized_all_b.plan_curr_amount%TYPE;
144: TYPE utilTypeTbl IS TABLE OF ozf_funds_utilized_all_b.utilization_type%TYPE;
145: TYPE fundIdTbl IS TABLE OF ozf_funds_utilized_all_b.fund_id%TYPE;
146: TYPE acctAmtTbl IS TABLE OF ozf_funds_utilized_all_b.acctd_amount%TYPE;
147: TYPE glDateTbl IS TABLE OF ozf_funds_utilized_all_b.gl_date%TYPE;
148: TYPE orgIdTbl IS TABLE OF ozf_funds_utilized_all_b.org_id%TYPE;
149: TYPE priceAdjTbl IS TABLE OF ozf_funds_utilized_all_b.price_adjustment_id%TYPE ;
150: TYPE objectIdTbl IS TABLE OF ozf_funds_utilized_all_b.object_id%TYPE ;

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

143: TYPE planAmtTbl IS TABLE OF ozf_funds_utilized_all_b.plan_curr_amount%TYPE;
144: TYPE utilTypeTbl IS TABLE OF ozf_funds_utilized_all_b.utilization_type%TYPE;
145: TYPE fundIdTbl IS TABLE OF ozf_funds_utilized_all_b.fund_id%TYPE;
146: TYPE acctAmtTbl IS TABLE OF ozf_funds_utilized_all_b.acctd_amount%TYPE;
147: TYPE glDateTbl IS TABLE OF ozf_funds_utilized_all_b.gl_date%TYPE;
148: TYPE orgIdTbl IS TABLE OF ozf_funds_utilized_all_b.org_id%TYPE;
149: TYPE priceAdjTbl IS TABLE OF ozf_funds_utilized_all_b.price_adjustment_id%TYPE ;
150: TYPE objectIdTbl IS TABLE OF ozf_funds_utilized_all_b.object_id%TYPE ;
151:

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

144: TYPE utilTypeTbl IS TABLE OF ozf_funds_utilized_all_b.utilization_type%TYPE;
145: TYPE fundIdTbl IS TABLE OF ozf_funds_utilized_all_b.fund_id%TYPE;
146: TYPE acctAmtTbl IS TABLE OF ozf_funds_utilized_all_b.acctd_amount%TYPE;
147: TYPE glDateTbl IS TABLE OF ozf_funds_utilized_all_b.gl_date%TYPE;
148: TYPE orgIdTbl IS TABLE OF ozf_funds_utilized_all_b.org_id%TYPE;
149: TYPE priceAdjTbl IS TABLE OF ozf_funds_utilized_all_b.price_adjustment_id%TYPE ;
150: TYPE objectIdTbl IS TABLE OF ozf_funds_utilized_all_b.object_id%TYPE ;
151:
152: TYPE orderLineIdTbl IS TABLE OF ozf_funds_utilized_all_b.order_line_id%TYPE;

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

145: TYPE fundIdTbl IS TABLE OF ozf_funds_utilized_all_b.fund_id%TYPE;
146: TYPE acctAmtTbl IS TABLE OF ozf_funds_utilized_all_b.acctd_amount%TYPE;
147: TYPE glDateTbl IS TABLE OF ozf_funds_utilized_all_b.gl_date%TYPE;
148: TYPE orgIdTbl IS TABLE OF ozf_funds_utilized_all_b.org_id%TYPE;
149: TYPE priceAdjTbl IS TABLE OF ozf_funds_utilized_all_b.price_adjustment_id%TYPE ;
150: TYPE objectIdTbl IS TABLE OF ozf_funds_utilized_all_b.object_id%TYPE ;
151:
152: TYPE orderLineIdTbl IS TABLE OF ozf_funds_utilized_all_b.order_line_id%TYPE;
153:

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

146: TYPE acctAmtTbl IS TABLE OF ozf_funds_utilized_all_b.acctd_amount%TYPE;
147: TYPE glDateTbl IS TABLE OF ozf_funds_utilized_all_b.gl_date%TYPE;
148: TYPE orgIdTbl IS TABLE OF ozf_funds_utilized_all_b.org_id%TYPE;
149: TYPE priceAdjTbl IS TABLE OF ozf_funds_utilized_all_b.price_adjustment_id%TYPE ;
150: TYPE objectIdTbl IS TABLE OF ozf_funds_utilized_all_b.object_id%TYPE ;
151:
152: TYPE orderLineIdTbl IS TABLE OF ozf_funds_utilized_all_b.order_line_id%TYPE;
153:
154: --nirprasa, ER 8399134

Line 152: TYPE orderLineIdTbl IS TABLE OF ozf_funds_utilized_all_b.order_line_id%TYPE;

148: TYPE orgIdTbl IS TABLE OF ozf_funds_utilized_all_b.org_id%TYPE;
149: TYPE priceAdjTbl IS TABLE OF ozf_funds_utilized_all_b.price_adjustment_id%TYPE ;
150: TYPE objectIdTbl IS TABLE OF ozf_funds_utilized_all_b.object_id%TYPE ;
151:
152: TYPE orderLineIdTbl IS TABLE OF ozf_funds_utilized_all_b.order_line_id%TYPE;
153:
154: --nirprasa, ER 8399134
155: TYPE excDateTbl IS TABLE OF ozf_funds_utilized_all_b.exchange_rate_date%TYPE;
156: TYPE excTypeTbl IS TABLE OF ozf_funds_utilized_all_b.exchange_rate_type%TYPE;

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

151:
152: TYPE orderLineIdTbl IS TABLE OF ozf_funds_utilized_all_b.order_line_id%TYPE;
153:
154: --nirprasa, ER 8399134
155: TYPE excDateTbl IS TABLE OF ozf_funds_utilized_all_b.exchange_rate_date%TYPE;
156: TYPE excTypeTbl IS TABLE OF ozf_funds_utilized_all_b.exchange_rate_type%TYPE;
157: TYPE currCodeTbl IS TABLE OF ozf_funds_utilized_all_b.currency_code%TYPE;
158: TYPE planCurrCodeTbl IS TABLE OF ozf_funds_utilized_all_b.plan_currency_code%TYPE;
159: TYPE fundReqCurrCodeTbl IS TABLE OF ozf_funds_utilized_all_b.fund_request_currency_code%TYPE;

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

152: TYPE orderLineIdTbl IS TABLE OF ozf_funds_utilized_all_b.order_line_id%TYPE;
153:
154: --nirprasa, ER 8399134
155: TYPE excDateTbl IS TABLE OF ozf_funds_utilized_all_b.exchange_rate_date%TYPE;
156: TYPE excTypeTbl IS TABLE OF ozf_funds_utilized_all_b.exchange_rate_type%TYPE;
157: TYPE currCodeTbl IS TABLE OF ozf_funds_utilized_all_b.currency_code%TYPE;
158: TYPE planCurrCodeTbl IS TABLE OF ozf_funds_utilized_all_b.plan_currency_code%TYPE;
159: TYPE fundReqCurrCodeTbl IS TABLE OF ozf_funds_utilized_all_b.fund_request_currency_code%TYPE;
160: TYPE planCurrAmtTbl IS TABLE OF ozf_funds_utilized_all_b.plan_curr_amount%TYPE;

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

153:
154: --nirprasa, ER 8399134
155: TYPE excDateTbl IS TABLE OF ozf_funds_utilized_all_b.exchange_rate_date%TYPE;
156: TYPE excTypeTbl IS TABLE OF ozf_funds_utilized_all_b.exchange_rate_type%TYPE;
157: TYPE currCodeTbl IS TABLE OF ozf_funds_utilized_all_b.currency_code%TYPE;
158: TYPE planCurrCodeTbl IS TABLE OF ozf_funds_utilized_all_b.plan_currency_code%TYPE;
159: TYPE fundReqCurrCodeTbl IS TABLE OF ozf_funds_utilized_all_b.fund_request_currency_code%TYPE;
160: TYPE planCurrAmtTbl IS TABLE OF ozf_funds_utilized_all_b.plan_curr_amount%TYPE;
161: TYPE planCurrAmtRemTbl IS TABLE OF ozf_funds_utilized_all_b.plan_curr_amount_remaining%TYPE;

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

154: --nirprasa, ER 8399134
155: TYPE excDateTbl IS TABLE OF ozf_funds_utilized_all_b.exchange_rate_date%TYPE;
156: TYPE excTypeTbl IS TABLE OF ozf_funds_utilized_all_b.exchange_rate_type%TYPE;
157: TYPE currCodeTbl IS TABLE OF ozf_funds_utilized_all_b.currency_code%TYPE;
158: TYPE planCurrCodeTbl IS TABLE OF ozf_funds_utilized_all_b.plan_currency_code%TYPE;
159: TYPE fundReqCurrCodeTbl IS TABLE OF ozf_funds_utilized_all_b.fund_request_currency_code%TYPE;
160: TYPE planCurrAmtTbl IS TABLE OF ozf_funds_utilized_all_b.plan_curr_amount%TYPE;
161: TYPE planCurrAmtRemTbl IS TABLE OF ozf_funds_utilized_all_b.plan_curr_amount_remaining%TYPE;
162: TYPE univCurrAmtTbl IS TABLE OF ozf_funds_utilized_all_b.univ_curr_amount%TYPE;

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

155: TYPE excDateTbl IS TABLE OF ozf_funds_utilized_all_b.exchange_rate_date%TYPE;
156: TYPE excTypeTbl IS TABLE OF ozf_funds_utilized_all_b.exchange_rate_type%TYPE;
157: TYPE currCodeTbl IS TABLE OF ozf_funds_utilized_all_b.currency_code%TYPE;
158: TYPE planCurrCodeTbl IS TABLE OF ozf_funds_utilized_all_b.plan_currency_code%TYPE;
159: TYPE fundReqCurrCodeTbl IS TABLE OF ozf_funds_utilized_all_b.fund_request_currency_code%TYPE;
160: TYPE planCurrAmtTbl IS TABLE OF ozf_funds_utilized_all_b.plan_curr_amount%TYPE;
161: TYPE planCurrAmtRemTbl IS TABLE OF ozf_funds_utilized_all_b.plan_curr_amount_remaining%TYPE;
162: TYPE univCurrAmtTbl IS TABLE OF ozf_funds_utilized_all_b.univ_curr_amount%TYPE;
163:

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

156: TYPE excTypeTbl IS TABLE OF ozf_funds_utilized_all_b.exchange_rate_type%TYPE;
157: TYPE currCodeTbl IS TABLE OF ozf_funds_utilized_all_b.currency_code%TYPE;
158: TYPE planCurrCodeTbl IS TABLE OF ozf_funds_utilized_all_b.plan_currency_code%TYPE;
159: TYPE fundReqCurrCodeTbl IS TABLE OF ozf_funds_utilized_all_b.fund_request_currency_code%TYPE;
160: TYPE planCurrAmtTbl IS TABLE OF ozf_funds_utilized_all_b.plan_curr_amount%TYPE;
161: TYPE planCurrAmtRemTbl IS TABLE OF ozf_funds_utilized_all_b.plan_curr_amount_remaining%TYPE;
162: TYPE univCurrAmtTbl IS TABLE OF ozf_funds_utilized_all_b.univ_curr_amount%TYPE;
163:
164: TYPE purchase_price_cursor_type is ref cursor; --ER9447673

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

157: TYPE currCodeTbl IS TABLE OF ozf_funds_utilized_all_b.currency_code%TYPE;
158: TYPE planCurrCodeTbl IS TABLE OF ozf_funds_utilized_all_b.plan_currency_code%TYPE;
159: TYPE fundReqCurrCodeTbl IS TABLE OF ozf_funds_utilized_all_b.fund_request_currency_code%TYPE;
160: TYPE planCurrAmtTbl IS TABLE OF ozf_funds_utilized_all_b.plan_curr_amount%TYPE;
161: TYPE planCurrAmtRemTbl IS TABLE OF ozf_funds_utilized_all_b.plan_curr_amount_remaining%TYPE;
162: TYPE univCurrAmtTbl IS TABLE OF ozf_funds_utilized_all_b.univ_curr_amount%TYPE;
163:
164: TYPE purchase_price_cursor_type is ref cursor; --ER9447673
165: ----------------------------------------------------------------------------------

Line 162: TYPE univCurrAmtTbl IS TABLE OF ozf_funds_utilized_all_b.univ_curr_amount%TYPE;

158: TYPE planCurrCodeTbl IS TABLE OF ozf_funds_utilized_all_b.plan_currency_code%TYPE;
159: TYPE fundReqCurrCodeTbl IS TABLE OF ozf_funds_utilized_all_b.fund_request_currency_code%TYPE;
160: TYPE planCurrAmtTbl IS TABLE OF ozf_funds_utilized_all_b.plan_curr_amount%TYPE;
161: TYPE planCurrAmtRemTbl IS TABLE OF ozf_funds_utilized_all_b.plan_curr_amount_remaining%TYPE;
162: TYPE univCurrAmtTbl IS TABLE OF ozf_funds_utilized_all_b.univ_curr_amount%TYPE;
163:
164: TYPE purchase_price_cursor_type is ref cursor; --ER9447673
165: ----------------------------------------------------------------------------------
166: -- Procedure Name

Line 238: FROM ozf_funds_utilized_all_b a2

234: get utilized amount.
235: -- rimehrot, commented for R12: use ozf_object_fund_summary table directly.
236: CURSOR c_get_utilized_amount(p_offer_id IN NUMBER, p_fund_id IN NUMBER) IS
237: SELECT SUM(NVL(a2.amount, 0)) amount
238: FROM ozf_funds_utilized_all_b a2
239: WHERE a2.plan_id = p_offer_id
240: AND a2.plan_type = 'OFFR'
241: AND a2.fund_id = p_fund_id
242: AND a2.utilization_type NOT IN ('REQUEST', 'TRANSFER', 'SALES_ACCRUAL');

Line 1009: FROM ozf_funds_utilized_all_b

1005:
1006: CURSOR c_budget_request_utilrec(p_fund_id IN NUMBER, p_plan_id IN NUMBER, p_actbudget_id IN NUMBER) IS
1007: SELECT utilization_id
1008: , object_version_number
1009: FROM ozf_funds_utilized_all_b
1010: WHERE utilization_type = 'REQUEST'
1011: AND fund_id = p_fund_id
1012: AND plan_type = 'FUND'
1013: AND plan_id = p_fund_id

Line 1126: FROM ozf_funds_utilized_all_b

1122: p_object_type IN VARCHAR2, p_plan_id IN NUMBER,
1123: p_inventory_item_id IN NUMBER,
1124: p_price_adjustment_id IN NUMBER) IS
1125: SELECT utilization_id, object_version_number
1126: FROM ozf_funds_utilized_all_b
1127: WHERE order_line_id = p_line_id
1128: AND object_id = p_object_id
1129: AND object_type = p_object_type
1130: AND plan_id = p_plan_id

Line 1600: column in ozf_funds_utilized_all_b */

1596: l_utilization_rec.univ_curr_amount_remaining := l_utilization_rec.plan_curr_amount_remaining;
1597: ELSE
1598: /*Added for bug 7030415 - Send the exchange rate
1599: Utilization amount is converted from request curr to universal curr to populate univ_curr_amount
1600: column in ozf_funds_utilized_all_b */
1601:
1602: IF g_debug_flag = 'Y' THEN
1603: ozf_utility_pvt.write_conc_log('**************************START****************************');
1604: ozf_utility_pvt.write_conc_log(l_api_name||' From Amount: '||l_utilization_rec.amount );

Line 1662: INSERT INTO ozf_funds_utilized_all_b

1658: ozf_utility_pvt.write_conc_log ('l_obj_ver_num ' || l_obj_ver_num);
1659: END IF;
1660:
1661: IF l_utilization_id IS NULL THEN
1662: INSERT INTO ozf_funds_utilized_all_b
1663: (utilization_id,last_update_date
1664: ,last_updated_by,last_update_login
1665: ,creation_date,created_by
1666: ,created_from,request_id

Line 1825: UPDATE ozf_funds_utilized_all_b

1821: ELSE
1822: --UPDATE UTILIZATION TABLE
1823: --Bug 13463758 Decide if it is partial shipment/backorder/split
1824: --scenario and skip to update instead of insert.
1825: UPDATE ozf_funds_utilized_all_b
1826: SET amount = amount+l_utilization_rec.amount, amount_remaining = amount_remaining+l_utilization_rec.amount_remaining,
1827: plan_curr_amount = plan_curr_amount+l_utilization_rec.plan_curr_amount,
1828: plan_curr_amount_remaining = plan_curr_amount_remaining+l_utilization_rec.plan_curr_amount_remaining,
1829: acctd_amount = acctd_amount+l_utilization_rec.acctd_amount,

Line 1987: -- populate request amount in ozf_funds_utilized_all_b record

1983: RAISE fnd_api.g_exc_error;
1984: END IF;
1985: CLOSE c_budget_request_utilrec;
1986:
1987: -- populate request amount in ozf_funds_utilized_all_b record
1988: UPDATE ozf_funds_utilized_all_b
1989: SET amount = NVL(amount,0) + NVL(l_utilization_rec.amount,0)
1990: , plan_curr_amount = NVL(plan_curr_amount,0) + NVL(l_utilization_rec.plan_curr_amount,0)
1991: , univ_curr_amount = NVL(univ_curr_amount, 0) + NVL(l_utilization_rec.univ_curr_amount, 0)

Line 1988: UPDATE ozf_funds_utilized_all_b

1984: END IF;
1985: CLOSE c_budget_request_utilrec;
1986:
1987: -- populate request amount in ozf_funds_utilized_all_b record
1988: UPDATE ozf_funds_utilized_all_b
1989: SET amount = NVL(amount,0) + NVL(l_utilization_rec.amount,0)
1990: , plan_curr_amount = NVL(plan_curr_amount,0) + NVL(l_utilization_rec.plan_curr_amount,0)
1991: , univ_curr_amount = NVL(univ_curr_amount, 0) + NVL(l_utilization_rec.univ_curr_amount, 0)
1992: , acctd_amount = NVL(acctd_amount,0) + NVL(l_utilization_rec.acctd_amount,0)

Line 2561: of ozf_funds_utilized_all_b table*/

2557: -- Added for bug 7030415, get the order's org_id to get the exchange rate.
2558:
2559: /*Adjustment amount is converted from plan curr to budgets curr to populate
2560: parent_src_apprvd_amt column in ozf_act_budgets table and amount column
2561: of ozf_funds_utilized_all_b table*/
2562:
2563: OPEN c_order_org_id(p_adj_amt_tbl(i).order_line_id);
2564: FETCH c_order_org_id INTO l_order_org_id;
2565: CLOSE c_order_org_id;

Line 2623: 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');

2619: END IF;
2620:
2621: IF g_debug_flag = 'Y' THEN
2622: ozf_utility_pvt.write_conc_log('post_accrual_to_budget' ||' Converted Amount l_converted_adj_amount: '|| l_converted_adj_amount);
2623: 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');
2624: ozf_utility_pvt.write_conc_log('***************************END******************************');
2625: END IF;
2626:
2627: IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 2871: FROM ozf_funds_utilized_all_b

2867: WHERE list_line_id = p_list_line_id;
2868:
2869: CURSOR c_old_adjustment_amount (p_price_adjustment_id IN NUMBER) IS
2870: SELECT SUM (plan_curr_amount)
2871: FROM ozf_funds_utilized_all_b
2872: WHERE price_adjustment_id = p_price_adjustment_id
2873: AND object_type = 'ORDER';
2874:
2875: CURSOR c_order_count (p_header_id IN NUMBER) IS

Line 2897: FROM ozf_funds_utilized_all_b

2893: currency_code,
2894: NVL (plan_curr_amount, 0) plan_curr_amount,
2895: gl_posted_flag, product_id,component_type,utilization_type,
2896: NVL (fund_request_amount, 0) fund_request_amount,plan_currency_code,fund_request_currency_code --nirprasa, ER 8399134, multi-currency enhancement
2897: FROM ozf_funds_utilized_all_b
2898: WHERE price_adjustment_id = p_price_adjustment_id
2899: AND object_type = 'ORDER';
2900: --GROUP BY fund_id, currency_code, price_adjustment_id, gl_posted_flag, product_id ;
2901:

Line 2911: FROM ozf_funds_utilized_all_b

2907: fund_id,
2908: acctd_amount,
2909: plan_id,
2910: fund_request_amount
2911: FROM ozf_funds_utilized_all_b
2912: WHERE utilization_id = p_utilization_id;
2913:
2914: CURSOR c_tm_offer (p_list_header_id IN NUMBER) IS
2915: --SELECT nvl(transaction_currency_code,fund_request_curr_code) transaction_currency_code

Line 2923: FROM ozf_funds_utilized_all_b

2919: WHERE qp_list_header_id = p_list_header_id;
2920:
2921: CURSOR c_get_util (p_list_header_id IN NUMBER, p_header_id IN NUMBER, p_line_id IN NUMBER) IS
2922: SELECT 1
2923: FROM ozf_funds_utilized_all_b
2924: WHERE plan_type = 'OFFR'
2925: AND plan_id = p_list_header_id
2926: AND object_type = 'ORDER'
2927: AND object_id = p_header_id

Line 3877: FROM ozf_funds_utilized_all_b

3873: price_adjustment_id,orig_utilization_id,
3874: exchange_rate_type, --nirprasa, added for LGE enhancement
3875: plan_currency_code, ----nirprasa, ER 8399134
3876: fund_request_currency_code ----nirprasa, ER 8399134
3877: FROM ozf_funds_utilized_all_b
3878: WHERE price_adjustment_id = p_price_adjustment_id
3879: AND object_type = 'ORDER'
3880: AND NVL(gl_posted_flag,'N') <> 'Y'
3881: GROUP BY fund_id,

Line 3895: FROM ozf_funds_utilized_all_b

3891:
3892: -- yzhao: 03/21/2003 get old adjustment amount per price_adjustment_id, copy from adjust_accrual
3893: CURSOR c_old_adjustment_total_amount (p_price_adjustment_id IN NUMBER) IS
3894: SELECT SUM (plan_curr_amount) -- change to plan_curr_amount from acct_amount by feliu
3895: FROM ozf_funds_utilized_all_b
3896: WHERE price_adjustment_id = p_price_adjustment_id
3897: AND object_type = 'ORDER'
3898: AND utilization_type NOT IN ('ADJUSTMENT', 'LEAD_ADJUSTMENT'); -- remove adjustment amount on 08/03/04 by feliu
3899:

Line 3910: FROM ozf_funds_utilized_all_b

3906: , exchange_rate_type, exchange_rate_date
3907: , currency_code, plan_currency_code, fund_request_currency_code
3908: , plan_curr_amount, plan_curr_amount_remaining
3909: , univ_curr_amount
3910: FROM ozf_funds_utilized_all_b
3911: WHERE price_adjustment_id IN (SELECT price_adjustment_id
3912: FROM oe_price_adjustments
3913: WHERE line_id = p_line_id)
3914: AND gl_posted_flag = G_GL_FLAG_NO -- 'N'

Line 3925: from ozf_funds_utilized_all_b

3921: , exchange_rate_type, exchange_rate_date
3922: , currency_code, plan_currency_code, fund_request_currency_code
3923: , plan_curr_amount, plan_curr_amount_remaining
3924: , univ_curr_amount
3925: from ozf_funds_utilized_all_b
3926: where object_type = 'ORDER'
3927: and order_line_id = p_line_id
3928: AND gl_posted_flag = G_GL_FLAG_NO
3929: AND utilization_type IN ('ADJUSTMENT','LEAD_ADJUSTMENT')

Line 3965: FROM ozf_funds_utilized_all_b

3961: AND list_header_id = p_header_id;
3962: -- add by feliu on 08/03/04, get max utilization id to use in create adjustment.
3963: CURSOR c_max_utilized_id(p_price_adj_id IN NUMBER) IS
3964: SELECT max(utilization_id)
3965: FROM ozf_funds_utilized_all_b
3966: WHERE price_adjustment_id = p_price_adj_id
3967: AND object_type = 'ORDER';
3968:
3969: CURSOR c_orig_order_info (p_line_id IN NUMBER) IS

Line 3981: FROM ozf_funds_utilized_all_b

3977: gl_posted_flag,plan_id,
3978: utilization_type,price_adjustment_id,
3979: adjustment_type,orig_utilization_id,
3980: plan_currency_code,fund_request_currency_code --nirprasa, ER 8399134
3981: FROM ozf_funds_utilized_all_b
3982: WHERE order_line_id = p_order_line_id
3983: AND adjustment_type_id IN(-4,-5);
3984:
3985: --kdass bug 5953774

Line 3997: FROM ozf_funds_utilized_all_b

3993:
3994: --added for bug
3995: CURSOR c_old_adj_total_amount (p_order_line_id IN NUMBER) IS
3996: SELECT SUM (plan_curr_amount) -- change to plan_curr_amount from acct_amount by feliu
3997: FROM ozf_funds_utilized_all_b
3998: WHERE price_adjustment_id = -1
3999: and order_line_id=p_order_line_id
4000: AND object_type = 'ORDER'
4001: AND utilization_type IN ('ADJUSTMENT', 'LEAD_ADJUSTMENT'); --

Line 4009: FROM ozf_funds_utilized_all_b

4005: fund_id,currency_code,
4006: gl_posted_flag,plan_id,
4007: utilization_type,price_adjustment_id,
4008: adjustment_type,orig_utilization_id
4009: FROM ozf_funds_utilized_all_b
4010: WHERE price_adjustment_id = -1
4011: and order_line_id=p_order_line_id
4012: AND object_type = 'ORDER'
4013: AND utilization_id=(

Line 4015: FROM ozf_funds_utilized_all_b

4011: and order_line_id=p_order_line_id
4012: AND object_type = 'ORDER'
4013: AND utilization_id=(
4014: SELECT max(utilization_id)
4015: FROM ozf_funds_utilized_all_b
4016: WHERE price_adjustment_id = -1
4017: and order_line_id=p_order_line_id
4018: AND object_type = 'ORDER');
4019:

Line 4035: FROM ozf_funds_utilized_all_b

4031:
4032:
4033: CURSOR c_all_fund_utilizations (p_line_id IN NUMBER) IS
4034: SELECT price_adjustment_id , plan_id
4035: FROM ozf_funds_utilized_all_b
4036: WHERE order_line_id = p_line_id;
4037:
4038: CURSOR c_offer_details (p_qp_list_header_id IN NUMBER) IS
4039: SELECT custom_setup_id

Line 4090: FROM ozf_funds_utilized_all_b

4086: AND list_line_type_code IN ('DIS', 'SUR', 'PBH');
4087: --
4088: CURSOR c_get_exchange_rate_info(p_utilization_id IN NUMBER) IS
4089: SELECT exchange_rate_date,exchange_rate_type
4090: FROM ozf_funds_utilized_all_b
4091: WHERE utilization_id = p_utilization_id;
4092:
4093: l_shipped_qty NUMBER;
4094: l_offer_curr VARCHAR2(150);

Line 4715: UPDATE ozf_funds_utilized_all_b futb

4711: --l_gl_date := sysdate;
4712: IF g_debug_flag = 'Y' THEN
4713: OZF_UTILITY_PVT.write_conc_log(': update gl posted flag to F since invoice is not created yet');
4714: END IF;
4715: UPDATE ozf_funds_utilized_all_b futb
4716: SET gl_posted_flag = 'F'
4717: ,gl_date = NULL
4718: WHERE futb.order_line_id = p_line_tbl(i).line_id
4719: AND futb.gl_posted_flag <> 'Y' --bug 13517522 - added this condition so that duplicate ASO message should not re-post accrual to GL

Line 4816: UPDATE ozf_funds_utilized_all_b

4812: LIMIT g_bulk_limit;
4813:
4814: -- Fix for Bug 12657908
4815: FORALL t_i IN NVL(l_utilIdTbl.FIRST, 1) .. NVL(l_utilIdTbl.LAST, 0)
4816: UPDATE ozf_funds_utilized_all_b
4817: SET gl_date = l_gl_date,
4818: year_id = (select ent_year_id FROM OZF_TIME_ENT_YEAR
4819: WHERE l_gl_date between start_date and end_date)
4820: WHERE utilization_id = l_utilIdTbl(t_i);

Line 4909: UPDATE ozf_funds_utilized_all_b

4905: , x_msg_data => x_msg_data
4906: );
4907: END IF;
4908: ELSE--if amount is zero then only update gl_posted_flag to Y in ozf_funds_utilized_all and do not insert record to ozf_ae_lines_all
4909: UPDATE ozf_funds_utilized_all_b
4910: SET last_update_date = SYSDATE
4911: , last_updated_by = NVL (fnd_global.user_id, -1)
4912: , last_update_login = NVL (fnd_global.conc_login_id, -1)
4913: , object_version_number = l_objVerTbl(t_i) + 1

Line 5712: FROM oe_order_lines_all line, ozf_funds_utilized_all_b util,

5708: util.order_line_id OrderLineId,
5709: NVL(line.invoiced_quantity, NVL(line.shipped_quantity, 0)) ShippedQuantity,
5710: (NVL(line.invoiced_quantity, NVL(line.shipped_quantity, 0))*line.unit_selling_price) Revenue,
5711: NVL(util.plan_curr_amount,0) AccrualAmount
5712: FROM oe_order_lines_all line, ozf_funds_utilized_all_b util,
5713: ozf_offers off, oe_price_adjustments oe,
5714: ozf_xref_map map
5715: WHERE line.line_id = util.order_line_id
5716: AND line.header_id = util.object_id

Line 5740: FROM oe_order_lines_all line, ozf_funds_utilized_all_b util,

5736: util.cust_account_id CustomerId,
5737: NVL(line.invoiced_quantity, NVL(line.shipped_quantity, 0)) ShippedQuantity,
5738: (NVL(line.invoiced_quantity, NVL(line.shipped_quantity, 0))*line.unit_selling_price) Revenue,
5739: NVL(util.plan_curr_amount,0) AccrualAmount
5740: FROM oe_order_lines_all line, ozf_funds_utilized_all_b util,
5741: ozf_offers off, oe_price_adjustments oe,
5742: ozf_xref_map map
5743: WHERE line.line_id = util.order_line_id
5744: AND line.header_id = util.object_id

Line 5834: FROM ozf_offers a, ozf_funds_utilized_all_b b

5830: l_offer_type varchar2(30);
5831:
5832: CURSOR c_get_offer_type(p_util_id IN NUMBER) IS
5833: SELECT offer_type
5834: FROM ozf_offers a, ozf_funds_utilized_all_b b
5835: WHERE a.qp_list_header_id = b.plan_id
5836: AND b.utilization_id = p_util_id ;
5837:
5838: --nirprasa, added for bug 7030415.

Line 5990: UPDATE ozf_funds_utilized_all_b

5986: END IF; --l_gl_posted_flag = G_GL_FLAG_NO
5987:
5988: -- update utilization gl_posted_flag directly to avoid all validations
5989: --ninarasi fix for bug 16029659. Set exchange_rate_date to gl_date since exchange_rate_date has to be same as the shipment date.
5990: UPDATE ozf_funds_utilized_all_b
5991: SET last_update_date = SYSDATE
5992: , last_updated_by = NVL (fnd_global.user_id, -1)
5993: , last_update_login = NVL (fnd_global.conc_login_id, -1)
5994: , object_version_number = p_util_object_version_number + 1

Line 6212: FROM ozf_funds_utilized_all_b

6208: CURSOR c_get_failed_gl_posting IS
6209: SELECT utilization_id, object_version_number,
6210: plan_type, utilization_type,
6211: amount, fund_id, acctd_amount, fund_request_amount, plan_id,org_id, gl_date, object_id, order_line_id
6212: FROM ozf_funds_utilized_all_b
6213: WHERE plan_type IN ( 'OFFR' , 'PRIC') -- yzhao: 10/20/2003 PRICE_LIST is changed to PRIC
6214: -- AND utilization_type = 'ACCRUAL' yzhao: 01/29/2004 11.5.10 off-invoice offer, LEAD_ACCRUAL may post to GL too
6215: AND gl_posted_flag = G_GL_FLAG_FAIL; -- 'F';
6216:

Line 6266: UPDATE ozf_funds_utilized_all_b

6262: END IF;
6263: --l_inv_date := NULL;
6264:
6265: IF l_inv_date IS NOT NULL THEN
6266: UPDATE ozf_funds_utilized_all_b
6267: SET gl_date = l_inv_date
6268: WHERE utilization_id = l_utilIdTbl(i);
6269: ELSE
6270: GOTO l_endofutilloop;

Line 6392: FROM ozf_funds_utilized_all_b

6388: ,org_id, exchange_rate_type, exchange_rate_date
6389: , currency_code, plan_currency_code, fund_request_currency_code
6390: , plan_curr_amount, plan_curr_amount_remaining
6391: , univ_curr_amount,object_id, price_adjustment_id
6392: FROM ozf_funds_utilized_all_b
6393: WHERE utilization_type = 'UTILIZED'
6394: AND gl_posted_flag = 'N'
6395: AND object_type = 'ORDER'
6396: AND price_adjustment_id IS NOT NULL;

Line 6465: UPDATE ozf_funds_utilized_all_b

6461: END IF;
6462:
6463: --Fix for Bug 12657908
6464: FORALL t_i IN NVL(l_utilIdTbl.FIRST, 1) .. NVL(l_utilIdTbl.LAST, 0)
6465: UPDATE ozf_funds_utilized_all_b
6466: SET gl_date = l_gl_date,
6467: year_id = (select ent_year_id FROM OZF_TIME_ENT_YEAR
6468: WHERE l_gl_date between start_date and end_date)
6469: WHERE utilization_id = l_utilIdTbl(t_i);

Line 6617: FROM ozf_funds_utilized_all_b

6613: -- yzhao: 03/04/2004 get related accraul records, post to GL
6614: CURSOR c_get_related_accrual IS
6615: SELECT utilization_id, object_version_number, plan_type, utilization_type, amount
6616: , fund_id, acctd_amount, fund_request_amount, plan_id,org_id
6617: FROM ozf_funds_utilized_all_b
6618: WHERE gl_posted_flag = G_GL_FLAG_NO --// OR gl_posted_flag = G_GL_FLAG_FAIL) Commented for Bugfix 13004854
6619: AND orig_utilization_id = p_utilization_id;
6620:
6621: BEGIN

Line 6641: UPDATE ozf_funds_utilized_all_b

6637:
6638: -- Fix for Bug 12657908
6639: IF p_gl_date IS NOT NULL THEN
6640: FORALL i IN NVL(l_utilIdTbl.FIRST, 1) .. NVL(l_utilIdTbl.LAST, 0)
6641: UPDATE ozf_funds_utilized_all_b
6642: SET gl_date = p_gl_date,
6643: year_id = (select ent_year_id FROM OZF_TIME_ENT_YEAR
6644: WHERE p_gl_date between start_date and end_date)
6645: WHERE utilization_id = l_utilIdTbl(i);

Line 6902: UPDATE ozf_funds_utilized_all_b

6898: l_conv_fund_req_amount_remg := l_conv_fund_req_amount;
6899: END IF;
6900:
6901: --update util table
6902: UPDATE ozf_funds_utilized_all_b
6903: SET amount = l_conv_amount, amount_remaining = l_conv_amount_remg,
6904: acctd_amount = l_conv_acctd_amount, acctd_amount_remaining = l_conv_acctd_amount_remg,
6905: fund_request_amount = l_conv_fund_req_amount, fund_request_amount_remaining = l_conv_fund_req_amount_remg,
6906: univ_curr_amount = l_conv_univ_amount, univ_curr_amount_remaining = l_conv_univ_amount_remg,