DBA Data[Home] [Help]

APPS.OE_ACCEPTANCE_UTIL dependencies on FND_API

Line 8: G_batch_source_id NUMBER := FND_API.G_MISS_NUM;

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:
11: PROCEDURE Register_Changed_Lines (
12: p_line_id IN NUMBER

Line 9: G_batch_source_name VARCHAR2(50) := FND_API.G_MISS_CHAR;

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:
11: PROCEDURE Register_Changed_Lines (
12: p_line_id IN NUMBER
13: , p_header_id IN NUMBER

Line 111: IF g_batch_source_name = FND_API.G_MISS_CHAR OR

107: oe_debug_pub.add('IN Batch source name is ' || p_batch_source_name );
108: END IF;
109:
110: IF p_batch_source_name IS NOT NULL THEN
111: IF g_batch_source_name = FND_API.G_MISS_CHAR OR
112: G_batch_source_name <> p_batch_source_name THEN
113:
114: SELECT batch_source_id,
115: name

Line 425: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

421: , p_reference_line_id => p_line_rec.service_reference_line_id
422: , p_customer_id => p_line_rec.sold_to_org_id
423: , x_cust_product_line_id => l_order_line_id
424: );
425: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
426: IF l_debug_level > 0 THEN
427: oe_debug_pub.add( 'SERVICE LINE ID IS ' || L_ORDER_LINE_ID ) ;
428: END IF;
429: l_service_reference_line_id := l_order_line_id;

Line 593: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

589: , p_reference_line_id => p_line_rec.service_reference_line_id
590: , p_customer_id => p_line_rec.sold_to_org_id
591: , x_cust_product_line_id => l_order_line_id
592: );
593: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
594: IF l_debug_level > 0 THEN
595: oe_debug_pub.add( 'SERVICE LINE ID IS ' || L_ORDER_LINE_ID ) ;
596: END IF;
597: l_service_reference_line_id := l_order_line_id;

Line 717: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

713: , p_reference_line_id => p_line_rec.service_reference_line_id
714: , p_customer_id => p_line_rec.sold_to_org_id
715: , x_cust_product_line_id => l_order_line_id
716: );
717: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
718: IF l_debug_level > 0 THEN
719: oe_debug_pub.add( 'SERVICE LINE ID IS ' || L_ORDER_LINE_ID ) ;
720: END IF;
721: l_service_reference_line_id := l_order_line_id;

Line 870: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

866: , p_reference_line_id => p_line_rec.service_reference_line_id
867: , p_customer_id => p_line_rec.sold_to_org_id
868: , x_cust_product_line_id => l_order_line_id
869: );
870: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
871: IF l_debug_level > 0 THEN
872: oe_debug_pub.add( 'SERVICE LINE ID IS ' || L_ORDER_LINE_ID ) ;
873: END IF;
874: l_service_reference_line_id := l_order_line_id;

Line 1078: IF p_line_rec.accepted_quantity IS NULL OR p_line_rec.accepted_quantity = FND_API.G_MISS_NUM THEN

1074: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1075: --
1076: BEGIN
1077:
1078: IF p_line_rec.accepted_quantity IS NULL OR p_line_rec.accepted_quantity = FND_API.G_MISS_NUM THEN
1079: -- consider closed lines as accepted because parent line might have been closed
1080: -- without acceptance (ex: from progress order when system param turned off)
1081: IF nvl(p_line_rec.open_flag, 'Y') = 'N' THEN
1082: IF l_debug_level > 0 THEN

Line 1111: IF l_accepted_quantity is NULL OR l_accepted_quantity = FND_API.G_MISS_NUM THEN

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
1113: -- without acceptance (ex: from progress order when system param turned off)
1114: IF nvl(l_open_flag, 'Y') = 'N' THEN
1115: IF l_debug_level > 0 THEN