[Home] [Help]
23: ', accepted_quantity '||
24: ', sold_to_org_id '||
25: ', revrec_expiration_days';
26:
27: g_query_from_clause VARCHAR2(1000) := ' FROM oe_order_lines_all ';
28: g_query_where_clause VARCHAR2(3000) := ' WHERE flow_status_code = ''PRE-BILLING_ACCEPTANCE''';
29: g_customer_acceptance_enabled BOOLEAN;
30: g_fulfillment_action VARCHAR2(40);
31: g_return_status VARCHAR2(1);
326: END IF;
327:
328: /* myerrams, Bug: 5531056. Modified the l_cust_query to restrict records with Acceptance Expire Event as Ship Confirm Date and REVREC_EVENT_CODE as Invoicing (Pre-Billing Acceptance) */
329: l_query_where_clause := ' WHERE oel.contingency_id = arc.contingency_id AND oel.flow_status_code = :1 AND oel.org_id = :2 and oel.open_flag = :3 AND arc.expiration_event_code = :4 AND oel.REVREC_EVENT_CODE = :5 ';
330: l_query_from_clause := ' FROM oe_order_lines_all oel, ar_deferral_reasons arc ';
331: l_cust_query := l_cust_query || l_query_from_clause || l_query_where_clause;
332: IF l_debug_level > 0 THEN
333: oe_debug_pub.add('Implicit Acceptance: the query that is being executed is:'||l_cust_query);
334: END IF;
371: oe_debug_pub.add('Inside KIT or MODEL Item Logic, Line_id:'||l_line_id);
372: END IF;
373: SELECT count(*)
374: INTO l_count
375: FROM oe_order_lines_all
376: WHERE header_id = l_header_id
377: AND top_model_line_id = l_line_id
378: AND flow_status_code NOT IN ('PRE-BILLING_ACCEPTANCE') --myerrams, Bug: 5290313
379: AND nvl(open_flag, 'Y') = 'Y';
380: /* If all the Child/Included lines are either Pending Pre-Billing_Acceptance or Closed */
381: IF l_count = 0 THEN
382: SELECT max(actual_shipment_date)
383: INTO l_max_actual_shipment_date
384: FROM oe_order_lines_all
385: WHERE header_id = l_header_id
386: AND top_model_line_id = l_line_id;
387:
388: IF l_max_actual_shipment_date IS NULL THEN
560: INTO l_line_id
561: , l_contingency_id
562: , l_revrec_event_code
563: , l_accepted_quantity
564: FROM oe_order_lines_all
565: WHERE line_id = l_product_line_id;
566:
567: IF l_contingency_id IS NOT NULL
568: AND l_accepted_quantity IS NOT NULL