[Home] [Help]
462: , l_top_model_line_id
463: FROM oe_order_lines_all
464: WHERE line_id = l_service_reference_line_id;
465:
466: IF l_item_type_code IN ('MODEL', 'STANDARD') or (l_item_type_code='KIT' AND
467: l_top_model_line_id = l_service_reference_line_id) AND
468: l_accepted_quantity is not null THEN -- parent is a top model and is accepted already
469: if nvl(l_accepted_quantity,0) = 0 then --if parent is rejected or not accepted
470: p_line_rec.accepted_quantity := l_accepted_quantity;
612: INTO x_contingency_id,x_revrec_event_code,x_revrec_expiration_days,l_item_type_code,l_top_model_line_id
613: FROM oe_order_lines_all
614: WHERE line_id= l_service_reference_line_id;
615:
616: IF l_item_type_code IN ('MODEL','STANDARD') OR
617: (l_item_type_code = 'KIT' AND l_top_model_line_id=l_service_reference_line_id) THEN
618: --service attached to a parent already assigned
619: NULL;
620: ELSIF l_top_model_line_id IS NOT NULL THEN -- service attached to a child line
623: FROM oe_order_lines_all
624: WHERE line_id=l_top_model_line_id;
625: END IF;
626: END IF;
627: ELSE -- standard line or top model
628: IF l_debug_level > 0 THEN
629: oe_debug_pub.add( 'Item_type_code:'||p_line_rec.item_type_code||' top_model_line_id:'||p_line_rec.top_model_line_id );
630: END IF;
631: x_contingency_id := p_line_rec.contingency_id;
736: INTO l_contingency_id, l_revrec_event_code,l_item_type_code, l_top_model_line_id
737: FROM oe_order_lines_all
738: WHERE line_id= l_service_reference_line_id;
739:
740: IF l_item_type_code IN ('MODEL', 'STANDARD') OR
741: (l_item_type_code = 'KIT' AND l_top_model_line_id=l_service_reference_line_id) THEN --service attached to a parent
742: IF l_contingency_id IS NOT NULL AND l_revrec_event_code='INVOICING' THEN
743: RETURN TRUE;
744: ELSE
757: END IF;
758: ELSE -- if service_reference_line_id is null
759: RETURN FALSE;
760: END IF;
761: ELSE -- standard line or top model
762: IF l_debug_level > 0 THEN
763: oe_debug_pub.add( 'Item_type_code:'||p_line_rec.item_type_code||' top_model_line_id:'||p_line_rec.top_model_line_id );
764: END IF;
765: IF p_line_rec.contingency_id IS NOT NULL AND p_line_rec.revrec_event_code='INVOICING' THEN
889: INTO l_contingency_id, l_revrec_event_code,l_item_type_code, l_top_model_line_id
890: FROM oe_order_lines_all
891: WHERE line_id= l_service_reference_line_id;
892:
893: IF l_item_type_code IN ('MODEL', 'STANDARD') OR
894: (l_item_type_code = 'KIT' AND l_top_model_line_id=l_service_reference_line_id) THEN --service attached to a parent
895: IF l_contingency_id IS NOT NULL AND l_revrec_event_code='CUSTOMER_ACCEPTANCE' THEN
896: RETURN TRUE;
897: ELSE
910: END IF;
911: ELSE -- service_refernce_line_id null
912: RETURN FALSE;
913: END IF;
914: ELSE -- standard line or top model
915: IF l_debug_level > 0 THEN
916: oe_debug_pub.add( 'Item_type_code:'||p_line_rec.item_type_code||' top_model_line_id:'||p_line_rec.top_model_line_id );
917: END IF;
918: IF p_line_rec.contingency_id IS NOT NULL AND p_line_rec.revrec_event_code='CUSTOMER_ACCEPTANCE' THEN
1004: ELSE
1005: RETURN FALSE;
1006: END IF;
1007: END IF;
1008: ELSE -- Now it could be a model, kit or standard line
1009: IF l_debug_level > 0 THEN
1010: oe_debug_pub.add( 'Item_type_code:'||p_line_rec.item_type_code||' top_model_line_id'|| p_line_rec.top_model_line_id);
1011: END IF;
1012: IF p_line_rec.top_model_line_id IS NOT NULL AND p_line_rec.top_model_line_id = p_line_rec.line_id THEN
1027: ELSE
1028: RETURN FALSE;
1029: END IF;
1030: END IF;
1031: ELSE -- standard line
1032: IF p_line_rec.flow_status_code in ('PRE-BILLING_ACCEPTANCE', 'POST-BILLING_ACCEPTANCE') THEN
1033: RETURN TRUE;
1034: ELSE
1035: RETURN FALSE;