[Home] [Help]
500: , l_top_model_line_id
501: FROM oe_order_lines_all
502: WHERE line_id = l_service_reference_line_id;
503:
504: IF l_item_type_code IN ('MODEL', 'STANDARD') or (l_item_type_code='KIT' AND
505: l_top_model_line_id = l_service_reference_line_id) AND
506: l_accepted_quantity is not null THEN -- parent is a top model and is accepted already
507: if nvl(l_accepted_quantity,0) = 0 then --if parent is rejected or not accepted
508: p_line_rec.accepted_quantity := l_accepted_quantity;
650: INTO x_contingency_id,x_revrec_event_code,x_revrec_expiration_days,l_item_type_code,l_top_model_line_id
651: FROM oe_order_lines_all
652: WHERE line_id= l_service_reference_line_id;
653:
654: IF l_item_type_code IN ('MODEL','STANDARD') OR
655: (l_item_type_code = 'KIT' AND l_top_model_line_id=l_service_reference_line_id) THEN
656: --service attached to a parent already assigned
657: NULL;
658: ELSIF l_top_model_line_id IS NOT NULL THEN -- service attached to a child line
661: FROM oe_order_lines_all
662: WHERE line_id=l_top_model_line_id;
663: END IF;
664: END IF;
665: ELSE -- standard line or top model
666: IF l_debug_level > 0 THEN
667: oe_debug_pub.add( 'Item_type_code:'||p_line_rec.item_type_code||' top_model_line_id:'||p_line_rec.top_model_line_id );
668: END IF;
669: x_contingency_id := p_line_rec.contingency_id;
774: INTO l_contingency_id, l_revrec_event_code,l_item_type_code, l_top_model_line_id
775: FROM oe_order_lines_all
776: WHERE line_id= l_service_reference_line_id;
777:
778: IF l_item_type_code IN ('MODEL', 'STANDARD') OR
779: (l_item_type_code = 'KIT' AND l_top_model_line_id=l_service_reference_line_id) THEN --service attached to a parent
780: IF l_contingency_id IS NOT NULL AND l_revrec_event_code='INVOICING' THEN
781: RETURN TRUE;
782: ELSE
795: END IF;
796: ELSE -- if service_reference_line_id is null
797: RETURN FALSE;
798: END IF;
799: ELSE -- standard line or top model
800: IF l_debug_level > 0 THEN
801: oe_debug_pub.add( 'Item_type_code:'||p_line_rec.item_type_code||' top_model_line_id:'||p_line_rec.top_model_line_id );
802: END IF;
803: IF p_line_rec.contingency_id IS NOT NULL AND p_line_rec.revrec_event_code='INVOICING' THEN
927: INTO l_contingency_id, l_revrec_event_code,l_item_type_code, l_top_model_line_id
928: FROM oe_order_lines_all
929: WHERE line_id= l_service_reference_line_id;
930:
931: IF l_item_type_code IN ('MODEL', 'STANDARD') OR
932: (l_item_type_code = 'KIT' AND l_top_model_line_id=l_service_reference_line_id) THEN --service attached to a parent
933: IF l_contingency_id IS NOT NULL AND l_revrec_event_code='CUSTOMER_ACCEPTANCE' THEN
934: RETURN TRUE;
935: ELSE
948: END IF;
949: ELSE -- service_refernce_line_id null
950: RETURN FALSE;
951: END IF;
952: ELSE -- standard line or top model
953: IF l_debug_level > 0 THEN
954: oe_debug_pub.add( 'Item_type_code:'||p_line_rec.item_type_code||' top_model_line_id:'||p_line_rec.top_model_line_id );
955: END IF;
956: IF p_line_rec.contingency_id IS NOT NULL AND p_line_rec.revrec_event_code='CUSTOMER_ACCEPTANCE' THEN
1042: ELSE
1043: RETURN FALSE;
1044: END IF;
1045: END IF;
1046: ELSE -- Now it could be a model, kit or standard line
1047: IF l_debug_level > 0 THEN
1048: oe_debug_pub.add( 'Item_type_code:'||p_line_rec.item_type_code||' top_model_line_id'|| p_line_rec.top_model_line_id);
1049: END IF;
1050: 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
1065: ELSE
1066: RETURN FALSE;
1067: END IF;
1068: END IF;
1069: ELSE -- standard line
1070: IF p_line_rec.flow_status_code in ('PRE-BILLING_ACCEPTANCE', 'POST-BILLING_ACCEPTANCE') THEN
1071: RETURN TRUE;
1072: ELSE
1073: RETURN FALSE;