DBA Data[Home] [Help]

APPS.OE_LINE_FULLFILL dependencies on OE_GLOBALS

Line 7: G_BINARY_LIMIT CONSTANT NUMBER :=OE_GLOBALS.G_BINARY_LIMIT; --7827727

3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Line_Fullfill';
5: G_FULFILL_WITH_ACTIVITY CONSTANT VARCHAR2(30) := 'With Activity';
6: G_FULFILL_NO_ACTIVITY CONSTANT VARCHAR2(30) := 'No Activity';
7: G_BINARY_LIMIT CONSTANT NUMBER :=OE_GLOBALS.G_BINARY_LIMIT; --7827727
8: g_set_tbl processed_set;
9:
10: -------------------------------------------------------------------
11: -- Added 09-DEC-2002

Line 337: p_item_type => OE_GLOBALS.G_WFI_LIN

333: END IF;
334:
335: Get_Activity_Result
336: (
337: p_item_type => OE_GLOBALS.G_WFI_LIN
338: , p_item_key => l_item_key
339: , p_activity_name => l_fulfill_activity
340: , x_return_status => l_return_status
341: , x_activity_result => l_activity_result

Line 508: l_fulfill_tbl(l_fulfill_index).operation := OE_GLOBALS.G_OPR_UPDATE;

504: l_fulfill_tbl(l_fulfill_index).header_id := l_service_tbl(l_service_index).header_id;
505: l_fulfill_tbl(l_fulfill_index).inventory_item_id := l_service_tbl(l_service_index).inventory_item_id;
506: l_fulfill_tbl(l_fulfill_index).order_firmed_date := l_service_tbl(l_service_index).order_firmed_date;
507: l_fulfill_tbl(l_fulfill_index).actual_shipment_date := l_service_tbl(l_service_index).actual_shipment_date;
508: l_fulfill_tbl(l_fulfill_index).operation := OE_GLOBALS.G_OPR_UPDATE;
509: IF l_debug_level > 0 THEN
510: oe_debug_pub.add( 'FULFILL INDEX : '||TO_CHAR ( L_FULFILL_INDEX ) , 3 ) ;
511: oe_debug_pub.add( 'FULFILLED FLAG : '||L_FULFILL_TBL ( L_FULFILL_INDEX ) .FULFILLED_FLAG , 3 ) ;
512: oe_debug_pub.add( 'FULFILLED QUANTITY : '||TO_CHAR ( L_FULFILL_TBL ( L_FULFILL_INDEX ) .FULFILLED_QUANTITY ) , 3 ) ;

Line 780: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN

776:
777: l_line_rec.service_start_date := NULL; -- initialization for 2292133
778: l_line_rec.service_end_date := NULL;
779:
780: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN
781: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);
782: END IF;
783:
784: /* Commented for performance changes.

Line 781: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);

777: l_line_rec.service_start_date := NULL; -- initialization for 2292133
778: l_line_rec.service_end_date := NULL;
779:
780: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN
781: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);
782: END IF;
783:
784: /* Commented for performance changes.
785: l_control_rec := OE_GLOBALS.G_MISS_CONTROL_REC;

Line 785: l_control_rec := OE_GLOBALS.G_MISS_CONTROL_REC;

781: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);
782: END IF;
783:
784: /* Commented for performance changes.
785: l_control_rec := OE_GLOBALS.G_MISS_CONTROL_REC;
786: l_control_rec.validate_entity := FALSE;
787: l_control_rec.check_security := FALSE;
788: */
789: IF p_mode = 'RECORD' THEN

Line 804: l_update_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;

800:
801: /* Commented for performance changes
802: l_update_line_tbl(1) := OE_Order_PUB.G_MISS_LINE_REC;
803: l_update_line_tbl(1).line_id := p_line_rec.line_id;
804: l_update_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
805: */
806: /* Start Audit Trail */
807: -- l_update_line_tbl(1).change_reason := 'SYSTEM';
808: -- l_update_line_tbl(1).change_comments := 'Process fulfillment set';

Line 850: IF p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE /* 2048753 */

846:
847: END IF;
848: --webroot bug 6826344 end
849:
850: IF p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE /* 2048753 */
851: OR p_line_rec.subscription_enable_flag = 'Y' --sol_ord_er #16014165
852: OR (l_accounting_rule_type = 'PP_DR_PP' OR l_accounting_rule_type = 'PP_DR_ALL') THEN -- added for webroot bug 6826344
853: l_line_rec := p_line_rec;
854: l_line_rec.fulfillment_date := SYSDATE;

Line 874: IF ( (OE_GLOBALS.G_ASO_INSTALLED = 'Y') OR

870: END IF;
871: IF l_debug_level > 0 THEN
872: oe_debug_pub.add('After calling update_service_lines() ',5) ;
873: END IF;
874: IF ( (OE_GLOBALS.G_ASO_INSTALLED = 'Y') OR
875: (NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'),'N') = 'Y') ) THEN
876: IF l_debug_level > 0 THEN
877: oe_debug_pub.add('mode is record',3) ;
878: END IF;

Line 1014: IF p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE

1010: l_recalc_First_periodamt := 'N';
1011: End If;
1012: -- sol_ord_er #16014165 end
1013:
1014: IF p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE
1015: OR p_line_rec.subscription_enable_flag = 'Y' THEN -- sol_ord_er #16014165 (for Model)
1016: /* Start Improved OM,IB,OKS changes */
1017: select order_number
1018: into l_order_number

Line 1062: IF p_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_SERVICE

1058: END IF;
1059:
1060: oe_debug_pub.add(' FND_PROFILE.VALUE(ONT_AUTO_INTERFACE_LINES_TO_IB) = ' || FND_PROFILE.VALUE('ONT_AUTO_INTERFACE_LINES_TO_IB'), 5);
1061:
1062: IF p_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_SERVICE
1063: AND NVL(p_line_rec.subscription_enable_flag,'N') <> 'Y' -- sol_ord_er #16014165 (for Model)
1064: AND ( NVL(FND_PROFILE.VALUE('ONT_AUTO_INTERFACE_LINES_TO_IB'),'Y') = 'Y') -- bug 9245134
1065: THEN
1066: oe_debug_pub.add('Before Call to csi_ont_txn_pub.posttransaction',1);

Line 1118: IF ( (OE_GLOBALS.G_ASO_INSTALLED = 'Y') OR

1114: -- Changes for AFD
1115: l_actual_fulfillment_date := nvl(p_line_tbl(l_index).actual_shipment_date,nvl(p_line_tbl(l_index).order_firmed_date,l_ordered_date));
1116: -- END CHANGES for AFD
1117:
1118: IF ( (OE_GLOBALS.G_ASO_INSTALLED = 'Y') OR
1119: (NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'),'N') = 'Y') )THEN
1120:
1121: OE_Line_Util.Lock_Rows
1122: (p_line_id => p_line_tbl(l_index).line_id

Line 1161: IF l_line_tbl(l_index).item_type_code = OE_GLOBALS.G_ITEM_SERVICE /* 2048753 */

1157: -- Changes for AFD
1158: l_line_tbl(l_index).actual_fulfillment_date := l_actual_fulfillment_date;
1159: -- END CHANGES for AFD
1160:
1161: IF l_line_tbl(l_index).item_type_code = OE_GLOBALS.G_ITEM_SERVICE /* 2048753 */
1162: OR l_line_tbl(l_index).subscription_enable_flag = 'Y' --sol_ord_er #16014165
1163: THEN
1164: l_line_rec := l_line_tbl(l_index);
1165: --sol_ord_er #16014165

Line 1234: ELSIF p_line_tbl(l_index).item_type_code = OE_GLOBALS.G_ITEM_SERVICE /* 2292133 */

1230: END IF;
1231: END IF;
1232: END IF; --code_release_level
1233: -- notification framework end
1234: ELSIF p_line_tbl(l_index).item_type_code = OE_GLOBALS.G_ITEM_SERVICE /* 2292133 */
1235: OR p_line_tbl(l_index).item_type_code IS NULL -- 2417601
1236: OR p_line_tbl(l_index).subscription_enable_flag = 'Y' --sol_ord_er #16014165
1237: OR p_line_tbl(l_index).item_type_code = FND_API.G_MISS_CHAR THEN -- 2417601
1238: l_line_rec := p_line_tbl(l_index);

Line 1248: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE

1244: l_line_rec.service_duration,
1245: l_line_rec.service_coterminate_flag,
1246: l_line_rec.item_type_code;
1247: close srv_lines;
1248: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE
1249: OR l_line_rec.subscription_enable_flag = 'Y' --sol_ord_er #16014165
1250: THEN -- 2417601
1251: Update_Service_Dates(l_line_rec);
1252: IF l_debug_level > 0 THEN

Line 1256: END IF; /* IF OE_GLOBALS.G_ASO_INSTALLED */

1252: IF l_debug_level > 0 THEN
1253: oe_debug_pub.add('After calling update_service_dates - aso not installed',5) ;
1254: END IF;
1255: END IF;
1256: END IF; /* IF OE_GLOBALS.G_ASO_INSTALLED */
1257:
1258: IF l_debug_level > 0 THEN
1259: oe_debug_pub.add('Updating line : '||p_line_tbl(l_index).line_id,3) ;
1260: END IF;

Line 1262: -- IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE THEN --3471423

1258: IF l_debug_level > 0 THEN
1259: oe_debug_pub.add('Updating line : '||p_line_tbl(l_index).line_id,3) ;
1260: END IF;
1261:
1262: -- IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE THEN --3471423
1263: IF p_line_tbl(l_index).item_type_code = OE_GLOBALS.G_ITEM_SERVICE --3471423
1264: OR p_line_tbl(l_index).subscription_enable_flag = 'Y' THEN -- sol_ord_er #16014165 (for Model)
1265: /* 2417601 uses a different update statements for service line */
1266:

Line 1263: IF p_line_tbl(l_index).item_type_code = OE_GLOBALS.G_ITEM_SERVICE --3471423

1259: oe_debug_pub.add('Updating line : '||p_line_tbl(l_index).line_id,3) ;
1260: END IF;
1261:
1262: -- IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE THEN --3471423
1263: IF p_line_tbl(l_index).item_type_code = OE_GLOBALS.G_ITEM_SERVICE --3471423
1264: OR p_line_tbl(l_index).subscription_enable_flag = 'Y' THEN -- sol_ord_er #16014165 (for Model)
1265: /* 2417601 uses a different update statements for service line */
1266:
1267:

Line 1366: IF p_line_tbl(l_index).item_type_code <> OE_GLOBALS.G_ITEM_SERVICE

1362: END IF;
1363:
1364: oe_debug_pub.add(' FND_PROFILE.VALUE(ONT_AUTO_INTERFACE_LINES_TO_IB) =>> ' || FND_PROFILE.VALUE('ONT_AUTO_INTERFACE_LINES_TO_IB'), 5);
1365:
1366: IF p_line_tbl(l_index).item_type_code <> OE_GLOBALS.G_ITEM_SERVICE
1367: AND NVL(p_line_tbl(l_index).subscription_enable_flag,'N') <> 'Y' -- sol_ord_er #16014165 (for Model)
1368: AND ( NVL(FND_PROFILE.VALUE('ONT_AUTO_INTERFACE_LINES_TO_IB'),'Y') = 'Y') -- bug 9245134
1369: THEN
1370: oe_debug_pub.add('Before Call to csi_ont_txn_pub.posttransaction',1);

Line 1399: OE_GLOBALS.G_RECURSION_MODE := 'Y';

1395:
1396: /* Commented for performance changes.
1397: oe_debug_pub.ADD('Calling OE_Order_PVT.Process_Order to update the fulfilled quantity and fulfilled flag',2);
1398:
1399: OE_GLOBALS.G_RECURSION_MODE := 'Y';
1400: OE_Shipping_Integration_PVT.Call_Process_Order
1401: (
1402: p_line_tbl => l_update_line_tbl,
1403: p_control_rec => l_control_rec,

Line 1407: OE_GLOBALS.G_RECURSION_MODE := 'N';

1403: p_control_rec => l_control_rec,
1404: x_return_status => l_return_status
1405: );
1406:
1407: OE_GLOBALS.G_RECURSION_MODE := 'N';
1408:
1409: oe_debug_pub.add('Return Status from Process Order : '||l_return_status,2);
1410:
1411: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1418: IF (OE_GLOBALS.G_ASO_INSTALLED = 'Y') THEN

1414: RAISE FND_API.G_EXC_ERROR;
1415: END IF;
1416: */
1417: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL < '110508' THEN
1418: IF (OE_GLOBALS.G_ASO_INSTALLED = 'Y') THEN
1419:
1420: -- #2769599
1421: IF (nvl(oe_order_cache.g_header_rec.header_id,-999)<>p_line_rec.header_id) THEN
1422: IF l_debug_level > 0 THEN

Line 1452: IF ( (OE_GLOBALS.G_ASO_INSTALLED = 'Y') OR

1448:
1449:
1450: ELSE
1451: /* Pack H or higher */
1452: IF ( (OE_GLOBALS.G_ASO_INSTALLED = 'Y') OR
1453: ( NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'),'N') = 'Y') ) THEN
1454:
1455:
1456: OE_ORDER_PVT.Process_Requests_and_Notify

Line 1884: l_item_type VARCHAR2(8) := OE_GLOBALS.G_WFI_LIN;

1880: IS
1881: l_fulfill_attr_name VARCHAR2(30) := 'FULFILLMENT_ACTIVITY';
1882: l_in_fulfill_attr_name VARCHAR2(30) := 'INBOUND_FULFILLMENT_ACTIVITY';
1883: l_fulfill_activity_name VARCHAR2(30);
1884: l_item_type VARCHAR2(8) := OE_GLOBALS.G_WFI_LIN;
1885: l_result_attr_name VARCHAR2(30) := 'COMPLETION_RESULT';
1886: l_in_result_attr_name VARCHAR2(30) := 'INBOUND_COMPLETION_RESULT';
1887: l_completion_result VARCHAR2(30);
1888: l_activity_result VARCHAR2(30) := 'NO_RESULT';

Line 1998: l_activity_status := OE_GLOBALS.G_WFR_COMPLETE;

1994: WHERE line_id = to_number(p_item_key);
1995: IF l_upgraded_flag = 'N' THEN
1996: RAISE FND_API.G_EXC_ERROR;
1997: ELSE
1998: l_activity_status := OE_GLOBALS.G_WFR_COMPLETE;
1999: END IF; -- bug 3589692 ends
2000: END IF;
2001:
2002: IF l_activity_status <> OE_GLOBALS.G_WFR_COMPLETE THEN

Line 2002: IF l_activity_status <> OE_GLOBALS.G_WFR_COMPLETE THEN

1998: l_activity_status := OE_GLOBALS.G_WFR_COMPLETE;
1999: END IF; -- bug 3589692 ends
2000: END IF;
2001:
2002: IF l_activity_status <> OE_GLOBALS.G_WFR_COMPLETE THEN
2003: RAISE FND_API.G_EXC_ERROR;
2004: END IF;
2005:
2006: END IF;

Line 2104: p_item_type => OE_GLOBALS.G_WFI_LIN

2100: END IF;
2101:
2102: Get_Activity_Result
2103: (
2104: p_item_type => OE_GLOBALS.G_WFI_LIN
2105: , p_item_key => l_item_key
2106: , p_activity_name => l_fulfill_activity
2107: , x_return_status => l_return_status
2108: , x_activity_result => l_activity_result

Line 2254: IF l_old_line_tbl(1).item_type_code <> OE_GLOBALS.G_ITEM_SERVICE

2250: lock_control = lock_control+1
2251: where line_id = l_line_tbl(1).line_id;
2252:
2253: -- Bug 14192627
2254: IF l_old_line_tbl(1).item_type_code <> OE_GLOBALS.G_ITEM_SERVICE
2255: AND NVL(l_old_line_tbl(1).subscription_enable_flag,'N') <> 'Y' -- sol_ord_er #16014165
2256: AND ( NVL(FND_PROFILE.VALUE('ONT_AUTO_INTERFACE_LINES_TO_IB'),'Y') = 'Y')
2257: THEN
2258: oe_debug_pub.add('Before Call to csi_ont_txn_pub.posttransaction',1);

Line 2606: p_item_type => OE_GLOBALS.G_WFI_LIN

2602: END IF;
2603:
2604: Get_Activity_Result
2605: (
2606: p_item_type => OE_GLOBALS.G_WFI_LIN
2607: , p_item_key => l_item_key
2608: , p_activity_name => l_fulfill_activity
2609: , x_return_status => l_return_status
2610: , x_activity_result => l_activity_result

Line 2752: l_fulfill_tbl(l_fulfill_index).operation := OE_GLOBALS.G_OPR_UPDATE;

2748: l_fulfill_tbl(l_fulfill_index).subscription_enable_flag := 'Y';
2749: End If;
2750: -- sol_ord_er #16014165 end
2751:
2752: l_fulfill_tbl(l_fulfill_index).operation := OE_GLOBALS.G_OPR_UPDATE;
2753: IF l_debug_level > 0 THEN
2754: oe_debug_pub.add('index - '||l_fulfill_index,5);
2755: oe_debug_pub.add('fulfilled flag - '||l_fulfill_tbl(l_fulfill_index).fulfilled_flag,5);
2756: oe_debug_pub.add('quantity - '||l_fulfill_tbl(l_fulfill_index).fulfilled_quantity,5);

Line 2808: l_fulfill_tbl(l_fulfill_index).operation := OE_GLOBALS.G_OPR_UPDATE;

2804: THEN
2805: l_fulfill_tbl(l_fulfill_index).subscription_enable_flag := 'Y';
2806: End If;
2807: -- sol_ord_er #16014165 end
2808: l_fulfill_tbl(l_fulfill_index).operation := OE_GLOBALS.G_OPR_UPDATE;
2809: IF l_debug_level > 0 THEN
2810: oe_debug_pub.add('index - '||l_fulfill_index,5);
2811: oe_debug_pub.add('fulfilled flag - '||l_fulfill_tbl(l_fulfill_index).fulfilled_flag,5);
2812: oe_debug_pub.add('fulfilled quantity - '||l_fulfill_tbl(l_fulfill_index).fulfilled_quantity,5);

Line 3233: p_item_type => OE_GLOBALS.G_WFI_LIN

3229: END IF;
3230:
3231: Get_Activity_Result
3232: (
3233: p_item_type => OE_GLOBALS.G_WFI_LIN
3234: , p_item_key => l_item_key
3235: , p_activity_name => l_fulfill_activity
3236: , x_return_status => l_return_status
3237: , x_activity_result => l_activity_result

Line 3336: l_fulfill_tbl(l_fulfill_index).operation := OE_GLOBALS.G_OPR_UPDATE;

3332: l_fulfill_tbl(l_fulfill_index).actual_shipment_date := l_service_tbl(l_service_index).actual_shipment_date;
3333: l_fulfill_tbl(l_fulfill_index).order_firmed_date := l_service_tbl(l_service_index).order_firmed_date;
3334: -- end changes for AFD
3335:
3336: l_fulfill_tbl(l_fulfill_index).operation := OE_GLOBALS.G_OPR_UPDATE;
3337: IF l_debug_level > 0 THEN
3338: oe_debug_pub.add( 'FULFILL INDEX : '||TO_CHAR ( L_FULFILL_INDEX ) , 3 ) ;
3339: oe_debug_pub.add( 'FULFILLED FLAG : '||L_FULFILL_TBL ( L_FULFILL_INDEX ) .FULFILLED_FLAG , 3 ) ;
3340: oe_debug_pub.add( 'FULFILLED QUANTITY : '||TO_CHAR ( L_FULFILL_TBL ( L_FULFILL_INDEX ) .FULFILLED_QUANTITY ) , 3 ) ;

Line 3406: l_fulfill_tbl(l_fulfill_index).operation := OE_GLOBALS.G_OPR_UPDATE;

3402: -- end Changes for AFD
3403:
3404: CLOSE c_line;
3405: -- End bug 3061559
3406: l_fulfill_tbl(l_fulfill_index).operation := OE_GLOBALS.G_OPR_UPDATE;
3407: IF l_debug_level > 0 THEN
3408: oe_debug_pub.add( 'FULFILL INDEX : '||TO_CHAR ( L_FULFILL_INDEX ) , 3 ) ;
3409: oe_debug_pub.add( 'FULFILLED FLAG : '||L_FULFILL_TBL ( L_FULFILL_INDEX ) .FULFILLED_FLAG , 3 ) ;
3410: oe_debug_pub.add( 'FULFILLED QUANTITY : '||TO_CHAR ( L_FULFILL_TBL ( L_FULFILL_INDEX ) .FULFILLED_QUANTITY ) , 3 ) ;

Line 4040: p_item_type => OE_GLOBALS.G_WFI_LIN

4036: l_item_key := to_char(l_line_tbl(l_line_index).line_id);
4037:
4038: Get_Activity_Result
4039: (
4040: p_item_type => OE_GLOBALS.G_WFI_LIN
4041: , p_item_key => l_item_key
4042: , p_activity_name => 'FULFILL_LINE'
4043: , x_return_status => l_return_status
4044: , x_activity_result => l_activity_result

Line 4178: l_line_tbl(l_line_index).item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN

4174: x_line_tbl => l_line_tbl);
4175: FOR l_line_index IN l_line_tbl.FIRST .. l_line_tbl.LAST
4176: LOOP
4177: IF l_line_tbl(l_line_index).ato_line_id = l_line_rec.ato_line_id AND
4178: l_line_tbl(l_line_index).item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN
4179: l_config_index := l_line_index;
4180: GOTO CONFIG_FOUND;
4181: END IF;
4182:

Line 4199: p_item_type => OE_GLOBALS.G_WFI_LIN

4195: END IF;
4196:
4197: Get_Activity_Result
4198: (
4199: p_item_type => OE_GLOBALS.G_WFI_LIN
4200: , p_item_key => l_item_key
4201: , p_activity_name => 'FULFILL_LINE'
4202: , x_return_status => l_return_status
4203: , x_activity_result => l_activity_result

Line 4299: p_item_type => OE_GLOBALS.G_WFI_LIN

4295: END IF;
4296:
4297: Get_Activity_Result
4298: (
4299: p_item_type => OE_GLOBALS.G_WFI_LIN
4300: , p_item_key => l_item_key
4301: , p_activity_name => 'FULFILL_LINE'
4302: , x_return_status => l_return_status
4303: , x_activity_result => l_activity_result

Line 5126: p_item_type => OE_GLOBALS.G_WFI_LIN

5122: ELSE
5123:
5124: Get_Activity_Result
5125: (
5126: p_item_type => OE_GLOBALS.G_WFI_LIN
5127: , p_item_key => to_char(l_ful_set_tbl(l_ful_set_index).line_id)
5128: , p_activity_name => 'FULFILL_LINE'
5129: , x_return_status => l_return_status
5130: , x_activity_result => l_activity_result

Line 5324: ( p_item_type => OE_GLOBALS.G_WFI_LIN

5320: --bug3292817 start
5321: l_activity_status := 'NOTIFIED';
5322: IF OE_OE_FORM_CANCEL_LINE.g_num_of_records > 1 THEN
5323: Get_Activity_Result
5324: ( p_item_type => OE_GLOBALS.G_WFI_LIN
5325: ,p_item_key =>
5326: to_char(l_ful_set_tbl(l_ful_set_index).line_id)
5327: ,p_activity_name => 'FULFILL_LINE'
5328: ,x_return_status => l_return_status

Line 5499: p_item_type => OE_GLOBALS.G_WFI_LIN

5495: ELSE
5496:
5497: Get_Activity_Result
5498: (
5499: p_item_type => OE_GLOBALS.G_WFI_LIN
5500: , p_item_key => to_char(p_line_id)
5501: , p_activity_name => 'FULFILL_LINE'
5502: , x_return_status => l_return_status
5503: , x_activity_result => l_activity_result