DBA Data[Home] [Help]

APPS.OE_ACCEPTANCE_UTIL dependencies on OE_ORDER_LINES_ALL

Line 398: oe_debug_pub.add('Updating records in OE_ORDER_LINES_ALL ' );

394: l_line_id_new := default_contingencies_rec.id;
395:
396: IF l_line_id_new <> l_line_id_old THEN
397: IF l_debug_level > 0 THEN
398: oe_debug_pub.add('Updating records in OE_ORDER_LINES_ALL ' );
399: END IF;
400: UPDATE OE_ORDER_LINES_ALL
401: SET contingency_id = default_contingencies_rec.contingency_id,
402: revrec_event_code = default_contingencies_rec.revrec_event_code,

Line 400: UPDATE OE_ORDER_LINES_ALL

396: IF l_line_id_new <> l_line_id_old THEN
397: IF l_debug_level > 0 THEN
398: oe_debug_pub.add('Updating records in OE_ORDER_LINES_ALL ' );
399: END IF;
400: UPDATE OE_ORDER_LINES_ALL
401: SET contingency_id = default_contingencies_rec.contingency_id,
402: revrec_event_code = default_contingencies_rec.revrec_event_code,
403: revrec_expiration_days = default_contingencies_rec.expiration_days
404: WHERE line_id = default_contingencies_rec.id;

Line 501: FROM oe_order_lines_all

497: , l_revrec_implicit_flag
498: , l_accepted_by
499: , l_item_type_code
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

Line 539: FROM oe_order_lines_all

535: , l_revrec_implicit_flag
536: ,l_accepted_by
537: , l_item_type_code
538: , l_top_model_line_id
539: FROM oe_order_lines_all
540: WHERE line_id= l_top_model_line_id;
541:
542: if nvl(l_accepted_quantity,0) = 0 then --if parent is rejected or not accepted
543: p_line_rec.accepted_quantity := l_accepted_quantity;

Line 613: FROM oe_order_lines_all

609: END IF;
610: IF p_line_rec.top_model_line_id IS NOT NULL THEN
611: SELECT contingency_id, revrec_event_code, revrec_expiration_days
612: INTO x_contingency_id, x_revrec_event_code,x_revrec_expiration_days
613: FROM oe_order_lines_all
614: WHERE line_id = p_line_rec.top_model_line_id;
615: END IF;
616: ELSIF p_line_rec.item_type_code = 'SERVICE' THEN
617: IF l_debug_level > 0 THEN

Line 651: FROM oe_order_lines_all

647:
648: IF l_service_reference_line_id IS NOT NULL THEN
649: SELECT contingency_id,revrec_event_code,revrec_expiration_days,item_type_code,top_model_line_id
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

Line 661: FROM oe_order_lines_all

657: NULL;
658: ELSIF l_top_model_line_id IS NOT NULL THEN -- service attached to a child line
659: SELECT contingency_id, revrec_event_code, revrec_expiration_days
660: INTO x_contingency_id, x_revrec_event_code, x_revrec_expiration_days
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

Line 731: FROM oe_order_lines_all

727: END IF;
728: IF p_line_rec.top_model_line_id IS NOT NULL THEN
729: SELECT contingency_id, revrec_event_code
730: INTO l_contingency_id, l_revrec_event_code
731: FROM oe_order_lines_all
732: WHERE line_id = p_line_rec.top_model_line_id;
733: END IF;
734:
735: IF l_contingency_id IS NOT NULL AND l_revrec_event_code='INVOICING' THEN

Line 775: FROM oe_order_lines_all

771:
772: IF l_service_reference_line_id IS NOT NULL THEN
773: SELECT contingency_id, revrec_event_code,item_type_code, top_model_line_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

Line 788: FROM oe_order_lines_all

784: END IF;
785: ELSIF l_top_model_line_id IS NOT NULL THEN -- service attached to a child line
786: SELECT contingency_id, revrec_event_code
787: INTO l_contingency_id, l_revrec_event_code
788: FROM oe_order_lines_all
789: WHERE line_id=l_top_model_line_id;
790: END IF;
791: IF l_contingency_id IS NOT NULL AND l_revrec_event_code='INVOICING' THEN
792: RETURN TRUE;

Line 884: FROM oe_order_lines_all

880: END IF;
881: IF p_line_rec.top_model_line_id IS NOT NULL THEN
882: SELECT contingency_id, revrec_event_code
883: INTO l_contingency_id, l_revrec_event_code
884: FROM oe_order_lines_all
885: WHERE line_id = p_line_rec.top_model_line_id;
886: END IF;
887:
888: IF l_contingency_id IS NOT NULL AND l_revrec_event_code='CUSTOMER_ACCEPTANCE' THEN

Line 928: FROM oe_order_lines_all

924:
925: IF l_service_reference_line_id IS NOT NULL THEN
926: SELECT contingency_id, revrec_event_code,item_type_code, top_model_line_id
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

Line 941: FROM oe_order_lines_all

937: END IF;
938: ELSIF l_top_model_line_id IS NOT NULL THEN -- service attached to a child line
939: SELECT contingency_id, revrec_event_code
940: INTO l_contingency_id, l_revrec_event_code
941: FROM oe_order_lines_all
942: WHERE line_id=l_top_model_line_id;
943: END IF;
944: IF l_contingency_id IS NOT NULL AND l_revrec_event_code='CUSTOMER_ACCEPTANCE' THEN
945: RETURN TRUE;

Line 1057: FROM oe_order_lines_all

1053: ELSE
1054: --top model line use exists
1055: SELECT count(*)
1056: INTO l_count
1057: FROM oe_order_lines_all
1058: WHERE header_id = p_line_rec.header_id
1059: AND top_model_line_id = p_line_rec.line_id
1060: AND flow_status_code NOT IN ('PRE-BILLING_ACCEPTANCE', 'POST-BILLING_ACCEPTANCE')
1061: AND nvl(open_flag, 'Y') = 'Y';

Line 1146: FROM oe_order_lines_all

1142: --
1143: BEGIN
1144: SELECT accepted_quantity, open_flag
1145: INTO l_accepted_quantity, l_open_flag
1146: FROM oe_order_lines_all
1147: WHERE line_id = p_line_id;
1148:
1149: IF l_accepted_quantity is NULL OR l_accepted_quantity = FND_API.G_MISS_NUM THEN
1150: -- consider closed lines as accepted because parent line might have been closed