[Home] [Help]
529: l_rate NUMBER;
530:
531: CURSOR c_act_budget_id IS
532: SELECT ozf_act_budgets_s.NEXTVAL
533: FROM DUAL;
534:
535: CURSOR c_act_util_rec (p_used_by_id IN NUMBER, p_used_by_type IN VARCHAR2) IS
536: SELECT activity_budget_id, object_version_number, approved_amount,approved_amount_fc
537: FROM ozf_act_budgets
919:
920: -- Cursor to get the sequence for utilization_id
921: CURSOR c_utilization_seq IS
922: SELECT ozf_funds_utilized_s.NEXTVAL
923: FROM DUAL;
924:
925: -- Cursor to get fund earned amount and object_version_number
926: CURSOR c_fund_b (p_fund_id IN NUMBER) IS
927: SELECT object_version_number
3167: x_cw_quantity => l_cw_quantity,
3168: x_cw_quantity_uom => l_cw_quantity_uom );*/
3169:
3170: -- getting fulfillment_base from OE API. In case of performance issue can think of using fulfillment_base from existing cursor
3171: l_fulfillment_base := OE_DUAL_UOM_UTIL.get_fulfillment_base(p_line_adj_tbl (i).line_id) ;
3172:
3173: IF l_fulfillment_base = 'S' THEN
3174: l_cw_quantity := l_shipping_quantity;
3175: l_cw_quantity_uom := l_shipping_quantity_uom;
3365: x_cw_quantity => l_cw_quantity,
3366: x_cw_quantity_uom => l_cw_quantity_uom );*/
3367:
3368: -- getting fulfillment_base from OE API. In case of performance issue can think of using fulfillment_base from existing cursor
3369: l_fulfillment_base := OE_DUAL_UOM_UTIL.get_fulfillment_base(p_line_adj_tbl (i).line_id) ;
3370:
3371: IF l_fulfillment_base = 'S' THEN
3372: l_cw_quantity := l_shipping_quantity;
3373: l_cw_quantity_uom := l_shipping_quantity_uom;
3837: WHERE b.site_use_id = p_account_site_id
3838: AND b.cust_acct_site_id = a.cust_acct_site_id;
3839:
3840: CURSOR sales_transation_csr(p_line_id NUMBER) IS
3841: SELECT 1 FROM DUAL WHERE EXISTS
3842: ( SELECT 1
3843: FROM ozf_sales_transactions_all trx
3844: WHERE trx.line_id = p_line_id
3845: AND source_code = 'OM');
4669: x_cw_quantity => l_cw_quantity,
4670: x_cw_quantity_uom => l_cw_quantity_uom );*/
4671:
4672: -- getting fulfillment_base from OE API. In case of performance issue can think of using fulfillment_base from existing cursor
4673: l_fulfillment_base := OE_DUAL_UOM_UTIL.get_fulfillment_base(p_line_tbl(i).line_id) ;
4674:
4675: IF l_fulfillment_base = 'S' THEN
4676: l_cw_quantity := l_shipping_quantity;
4677: l_cw_quantity_uom := l_shipping_quantity_uom;