[Home] [Help]
1078: WHERE b.site_use_id = p_account_site_id
1079: AND b.cust_acct_site_id = a.cust_acct_site_id;
1080:
1081: CURSOR sales_transation_csr(p_line_id IN NUMBER) IS
1082: SELECT 1 FROM DUAL WHERE EXISTS
1083: ( SELECT 1
1084: FROM ozf_sales_transactions_all trx
1085: WHERE trx.line_id = p_line_id
1086: AND source_code = 'OM');
1411: write_conc_log ('l_order_line_tbl(j).group_nos: ' || l_order_line_tbl(j).group_nos);
1412:
1413: IF l_order_line_tbl(j).group_nos IS NOT NULL THEN
1414:
1415: --loop to get individual group number from the comma seperated list
1416: l_string := l_order_line_tbl(j).group_nos;
1417: LOOP
1418: l_last_pos := INSTR(l_string,',',1,l_cntr+1);
1419: l_num_chars := l_last_pos - l_first_pos;
4114: AND cust_lines.interface_line_attribute6 = to_char(p_line_id);
4115:
4116: CURSOR sales_transation_csr(p_line_id IN NUMBER) IS
4117: SELECT 1
4118: FROM dual
4119: WHERE EXISTS
4120: (SELECT 1
4121: FROM ozf_sales_transactions_all trx
4122: WHERE trx.line_id = p_line_id
4323: write_conc_log ('l_order_line_tbl(j).group_nos: ' || l_order_line_tbl(j).group_nos);
4324:
4325: IF l_order_line_tbl(j).group_nos IS NOT NULL THEN
4326:
4327: --loop to get individual group number from the comma seperated list
4328: l_string := l_order_line_tbl(j).group_nos;
4329: LOOP
4330: l_last_pos := INSTR(l_string,',',1,l_cntr+1);
4331: l_num_chars := l_last_pos - l_first_pos;
4391: x_cw_quantity => l_cw_quantity,
4392: x_cw_quantity_uom => l_cw_quantity_uom ); */
4393:
4394: -- getting fulfillment_base from OE API. In case of performance issue can think of using fulfillment_base from existing cursor
4395: l_fulfillment_base := OE_DUAL_UOM_UTIL.get_fulfillment_base(p_line_rec.line_id) ;
4396:
4397: --IF p_line_rec.fulfillment_base = 'S' THEN
4398: IF l_fulfillment_base = 'S' THEN
4399: l_cw_quantity := p_line_rec.shipping_quantity;
5114: x_cw_quantity => l_cw_quantity,
5115: x_cw_quantity_uom => l_cw_quantity_uom ); */
5116:
5117: -- getting fulfillment_base from OE API. In case of performance issue can think of using fulfillment_base from existing cursor
5118: l_fulfillment_base := OE_DUAL_UOM_UTIL.get_fulfillment_base(p_line_rec.line_id) ;
5119:
5120: --IF p_line_rec.fulfillment_base = 'S' THEN
5121: IF l_fulfillment_base = 'S' THEN
5122: l_cw_quantity := p_line_rec.shipping_quantity;
6861: -- with all items but insert -1 instead
6862: ----DBMS_output.put_line ( 'product_rec.product_attribute ' || product_rec.product_attribute);
6863: ----DBMS_output.put_line ( 'product_rec.product_attr_value ' || product_rec.product_attr_value);
6864: IF product_rec.product_attribute = 'PRICING_ATTRIBUTE3' AND product_rec.product_attr_value = 'ALL' THEN
6865: --l_temp_sql := 'SELECT -1 product_id FROM DUAL';
6866: FND_DSQL.add_text('SELECT -1 product_id FROM DUAL');
6867: ----DBMS_output.put_line (' IN ALL products ');
6868: ELSE
6869: l_temp_sql := ozf_offr_elig_prod_denorm_pvt.get_sql (
6862: ----DBMS_output.put_line ( 'product_rec.product_attribute ' || product_rec.product_attribute);
6863: ----DBMS_output.put_line ( 'product_rec.product_attr_value ' || product_rec.product_attr_value);
6864: IF product_rec.product_attribute = 'PRICING_ATTRIBUTE3' AND product_rec.product_attr_value = 'ALL' THEN
6865: --l_temp_sql := 'SELECT -1 product_id FROM DUAL';
6866: FND_DSQL.add_text('SELECT -1 product_id FROM DUAL');
6867: ----DBMS_output.put_line (' IN ALL products ');
6868: ELSE
6869: l_temp_sql := ozf_offr_elig_prod_denorm_pvt.get_sql (
6870: p_context=> 'ITEM',
7877: AND p_volume <= volume_to
7878: AND parent_discount_line_id = p_parent_discount_id;
7879:
7880: /* CURSOR c_max_volume(p_order_line_id IN NUMBER, p_qp_list_header_id IN NUMBER,p_source_code IN VARCHAR2) IS
7881: SELECT summ.individual_volume
7882: FROM ozf_volume_detail det,ozf_volume_summary summ
7883: WHERE det.order_line_id = p_order_line_id
7884: AND det.qp_list_header_id = p_qp_list_header_id
7885: AND det.volume_track_type = summ.individual_type
7881: SELECT summ.individual_volume
7882: FROM ozf_volume_detail det,ozf_volume_summary summ
7883: WHERE det.order_line_id = p_order_line_id
7884: AND det.qp_list_header_id = p_qp_list_header_id
7885: AND det.volume_track_type = summ.individual_type
7886: AND det.qp_list_header_id = summ.qp_list_header_id
7887: AND det.source_code = p_source_code;
7888: */
7889: CURSOR c_preset_tier(p_pbh_line_id IN NUMBER, p_qp_list_header_id IN NUMBER,p_group_id IN NUMBER) IS
8423: x_cw_quantity => l_cw_quantity,
8424: x_cw_quantity_uom => l_cw_quantity_uom );*/
8425:
8426: -- getting fulfillment_base from OE API. In case of performance issue can think of using fulfillment_base from existing cursor
8427: l_order_line_info.fulfillment_base := OE_DUAL_UOM_UTIL.get_fulfillment_base(l_order_line_id) ;
8428:
8429: IF l_order_line_info.fulfillment_base = 'S' THEN
8430: l_cw_quantity := l_order_line_info.shipping_quantity;
8431: l_cw_quantity_uom := l_order_line_info.shipping_quantity_uom;
9104:
9105: );
9106:
9107: CURSOR c_is_util_correct(p_list_header_id IN NUMBER) IS
9108: SELECT 1 FROM DUAL WHERE EXISTS
9109: ( SELECT 1
9110: FROM
9111: ( SELECT sum(plan_curr_amount) old_Adj_amt
9112: , order_line_id