eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_ACCEPTANCE_UTIL dependencies on OE_ORDER_LINES_ALL

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

356: l_line_id_new := default_contingencies_rec.id;
357:
358: IF l_line_id_new <> l_line_id_old THEN
359: IF l_debug_level > 0 THEN
360: oe_debug_pub.add('Updating records in OE_ORDER_LINES_ALL ' );
361: END IF;
362: UPDATE OE_ORDER_LINES_ALL
363: SET contingency_id = default_contingencies_rec.contingency_id,
364: revrec_event_code = default_contingencies_rec.revrec_event_code,

Line 362: UPDATE OE_ORDER_LINES_ALL

358: IF l_line_id_new <> l_line_id_old THEN
359: IF l_debug_level > 0 THEN
360: oe_debug_pub.add('Updating records in OE_ORDER_LINES_ALL ' );
361: END IF;
362: UPDATE OE_ORDER_LINES_ALL
363: SET contingency_id = default_contingencies_rec.contingency_id,
364: revrec_event_code = default_contingencies_rec.revrec_event_code,
365: revrec_expiration_days = default_contingencies_rec.expiration_days
366: WHERE line_id = default_contingencies_rec.id;

Line 463: FROM oe_order_lines_all

459: , l_revrec_implicit_flag
460: , l_accepted_by
461: , l_item_type_code
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

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_top_model_line_id;
503:
504: if nvl(l_accepted_quantity,0) = 0 then --if parent is rejected or not accepted
505: p_line_rec.accepted_quantity := l_accepted_quantity;

Line 575: FROM oe_order_lines_all

571: END IF;
572: IF p_line_rec.top_model_line_id IS NOT NULL THEN
573: SELECT contingency_id, revrec_event_code, revrec_expiration_days
574: INTO x_contingency_id, x_revrec_event_code,x_revrec_expiration_days
575: FROM oe_order_lines_all
576: WHERE line_id = p_line_rec.top_model_line_id;
577: END IF;
578: ELSIF p_line_rec.item_type_code = 'SERVICE' THEN
579: IF l_debug_level > 0 THEN

Line 613: FROM oe_order_lines_all

609:
610: IF l_service_reference_line_id IS NOT NULL THEN
611: SELECT contingency_id,revrec_event_code,revrec_expiration_days,item_type_code,top_model_line_id
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

Line 623: FROM oe_order_lines_all

619: NULL;
620: ELSIF l_top_model_line_id IS NOT NULL THEN -- service attached to a child line
621: SELECT contingency_id, revrec_event_code, revrec_expiration_days
622: INTO x_contingency_id, x_revrec_event_code, x_revrec_expiration_days
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

Line 693: FROM oe_order_lines_all

689: END IF;
690: IF p_line_rec.top_model_line_id IS NOT NULL THEN
691: SELECT contingency_id, revrec_event_code
692: INTO l_contingency_id, l_revrec_event_code
693: FROM oe_order_lines_all
694: WHERE line_id = p_line_rec.top_model_line_id;
695: END IF;
696:
697: IF l_contingency_id IS NOT NULL AND l_revrec_event_code='INVOICING' THEN

Line 737: FROM oe_order_lines_all

733:
734: IF l_service_reference_line_id IS NOT NULL THEN
735: SELECT contingency_id, revrec_event_code,item_type_code, top_model_line_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

Line 750: FROM oe_order_lines_all

746: END IF;
747: ELSIF l_top_model_line_id IS NOT NULL THEN -- service attached to a child line
748: SELECT contingency_id, revrec_event_code
749: INTO l_contingency_id, l_revrec_event_code
750: FROM oe_order_lines_all
751: WHERE line_id=l_top_model_line_id;
752: END IF;
753: IF l_contingency_id IS NOT NULL AND l_revrec_event_code='INVOICING' THEN
754: RETURN TRUE;

Line 846: FROM oe_order_lines_all

842: END IF;
843: IF p_line_rec.top_model_line_id IS NOT NULL THEN
844: SELECT contingency_id, revrec_event_code
845: INTO l_contingency_id, l_revrec_event_code
846: FROM oe_order_lines_all
847: WHERE line_id = p_line_rec.top_model_line_id;
848: END IF;
849:
850: IF l_contingency_id IS NOT NULL AND l_revrec_event_code='CUSTOMER_ACCEPTANCE' THEN

Line 890: FROM oe_order_lines_all

886:
887: IF l_service_reference_line_id IS NOT NULL THEN
888: SELECT contingency_id, revrec_event_code,item_type_code, top_model_line_id
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

Line 903: FROM oe_order_lines_all

899: END IF;
900: ELSIF l_top_model_line_id IS NOT NULL THEN -- service attached to a child line
901: SELECT contingency_id, revrec_event_code
902: INTO l_contingency_id, l_revrec_event_code
903: FROM oe_order_lines_all
904: WHERE line_id=l_top_model_line_id;
905: END IF;
906: IF l_contingency_id IS NOT NULL AND l_revrec_event_code='CUSTOMER_ACCEPTANCE' THEN
907: RETURN TRUE;

Line 1019: FROM oe_order_lines_all

1015: ELSE
1016: --top model line use exists
1017: SELECT count(*)
1018: INTO l_count
1019: FROM oe_order_lines_all
1020: WHERE header_id = p_line_rec.header_id
1021: AND top_model_line_id = p_line_rec.line_id
1022: AND flow_status_code NOT IN ('PRE-BILLING_ACCEPTANCE', 'POST-BILLING_ACCEPTANCE')
1023: AND nvl(open_flag, 'Y') = 'Y';

Line 1108: FROM oe_order_lines_all

1104: --
1105: BEGIN
1106: SELECT accepted_quantity, open_flag
1107: INTO l_accepted_quantity, l_open_flag
1108: FROM oe_order_lines_all
1109: WHERE line_id = p_line_id;
1110:
1111: IF l_accepted_quantity is NULL OR l_accepted_quantity = FND_API.G_MISS_NUM THEN
1112: -- consider closed lines as accepted because parent line might have been closed