[Home] [Help]
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_ACCEPTANCE_UTIL';
7:
8: G_batch_source_id NUMBER := FND_API.G_MISS_NUM;
9: G_batch_source_name VARCHAR2(50) := FND_API.G_MISS_CHAR;
10: G_BINARY_LIMIT CONSTANT NUMBER := OE_GLOBALS.G_BINARY_LIMIT; -- Bug 8656395
11:
12: PROCEDURE Register_Changed_Lines (
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_ACCEPTANCE_UTIL';
7:
8: G_batch_source_id NUMBER := FND_API.G_MISS_NUM;
9: G_batch_source_name VARCHAR2(50) := FND_API.G_MISS_CHAR;
10: G_BINARY_LIMIT CONSTANT NUMBER := OE_GLOBALS.G_BINARY_LIMIT; -- Bug 8656395
11:
12: PROCEDURE Register_Changed_Lines (
13: p_line_id IN NUMBER
117: oe_debug_pub.add('IN Batch source name is ' || p_batch_source_name );
118: END IF;
119:
120: IF p_batch_source_name IS NOT NULL THEN
121: IF g_batch_source_name = FND_API.G_MISS_CHAR OR
122: G_batch_source_name <> p_batch_source_name THEN
123:
124: SELECT batch_source_id,
125: name
459: , p_reference_line_id => p_line_rec.service_reference_line_id
460: , p_customer_id => p_line_rec.sold_to_org_id
461: , x_cust_product_line_id => l_order_line_id
462: );
463: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
464: IF l_debug_level > 0 THEN
465: oe_debug_pub.add( 'SERVICE LINE ID IS ' || L_ORDER_LINE_ID ) ;
466: END IF;
467: l_service_reference_line_id := l_order_line_id;
627: , p_reference_line_id => p_line_rec.service_reference_line_id
628: , p_customer_id => p_line_rec.sold_to_org_id
629: , x_cust_product_line_id => l_order_line_id
630: );
631: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
632: IF l_debug_level > 0 THEN
633: oe_debug_pub.add( 'SERVICE LINE ID IS ' || L_ORDER_LINE_ID ) ;
634: END IF;
635: l_service_reference_line_id := l_order_line_id;
751: , p_reference_line_id => p_line_rec.service_reference_line_id
752: , p_customer_id => p_line_rec.sold_to_org_id
753: , x_cust_product_line_id => l_order_line_id
754: );
755: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
756: IF l_debug_level > 0 THEN
757: oe_debug_pub.add( 'SERVICE LINE ID IS ' || L_ORDER_LINE_ID ) ;
758: END IF;
759: l_service_reference_line_id := l_order_line_id;
904: , p_reference_line_id => p_line_rec.service_reference_line_id
905: , p_customer_id => p_line_rec.sold_to_org_id
906: , x_cust_product_line_id => l_order_line_id
907: );
908: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
909: IF l_debug_level > 0 THEN
910: oe_debug_pub.add( 'SERVICE LINE ID IS ' || L_ORDER_LINE_ID ) ;
911: END IF;
912: l_service_reference_line_id := l_order_line_id;
1112: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1113: --
1114: BEGIN
1115:
1116: IF p_line_rec.accepted_quantity IS NULL OR p_line_rec.accepted_quantity = FND_API.G_MISS_NUM THEN
1117: -- consider closed lines as accepted because parent line might have been closed
1118: -- without acceptance (ex: from progress order when system param turned off)
1119: IF nvl(p_line_rec.open_flag, 'Y') = 'N' THEN
1120: IF l_debug_level > 0 THEN
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
1151: -- without acceptance (ex: from progress order when system param turned off)
1152: IF nvl(l_open_flag, 'Y') = 'N' THEN
1153: IF l_debug_level > 0 THEN