DBA Data[Home] [Help]

APPS.OE_ORDER_BOOK_UTIL dependencies on OE_GLOBALS

Line 266: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN

262: AND trunc(sysdate) between trunc(nvl(start_date_active, sysdate)) and
263: trunc(nvl(end_date_active, sysdate));
264:
265: -- Check if the ASO and EC are installed products
266: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN
267: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);
268: END IF;
269:
270: IF OE_GLOBALS.G_EC_INSTALLED IS NULL THEN

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

263: trunc(nvl(end_date_active, sysdate));
264:
265: -- Check if the ASO and EC are installed products
266: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN
267: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);
268: END IF;
269:
270: IF OE_GLOBALS.G_EC_INSTALLED IS NULL THEN
271: OE_GLOBALS.G_EC_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(175);

Line 270: IF OE_GLOBALS.G_EC_INSTALLED IS NULL THEN

266: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN
267: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);
268: END IF;
269:
270: IF OE_GLOBALS.G_EC_INSTALLED IS NULL THEN
271: OE_GLOBALS.G_EC_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(175);
272: END IF;
273:
274: -- We need to call the Query_Rows only if Pricing is called and ASO/EC are

Line 271: OE_GLOBALS.G_EC_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(175);

267: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);
268: END IF;
269:
270: IF OE_GLOBALS.G_EC_INSTALLED IS NULL THEN
271: OE_GLOBALS.G_EC_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(175);
272: END IF;
273:
274: -- We need to call the Query_Rows only if Pricing is called and ASO/EC are
275: -- Installed products.

Line 278: (OE_GLOBALS.G_ASO_INSTALLED = 'Y') OR

274: -- We need to call the Query_Rows only if Pricing is called and ASO/EC are
275: -- Installed products.
276:
277: IF ( (NVL(l_active_phase_count,0) > 0) OR
278: (OE_GLOBALS.G_ASO_INSTALLED = 'Y') OR
279: (OE_GLOBALS.G_EC_INSTALLED = 'Y' ) OR
280: (NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'),'N') = 'Y') )
281: THEN
282: -- Set up the lines table of records

Line 279: (OE_GLOBALS.G_EC_INSTALLED = 'Y' ) OR

275: -- Installed products.
276:
277: IF ( (NVL(l_active_phase_count,0) > 0) OR
278: (OE_GLOBALS.G_ASO_INSTALLED = 'Y') OR
279: (OE_GLOBALS.G_EC_INSTALLED = 'Y' ) OR
280: (NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'),'N') = 'Y') )
281: THEN
282: -- Set up the lines table of records
283:

Line 365: l_line_tbl(l_index).operation := OE_GLOBALS.G_OPR_UPDATE;

361: x_freeze_inc_items := TRUE;
362: END IF;
363:
364: l_return_status := FND_API.G_RET_STS_SUCCESS;
365: l_line_tbl(l_index).operation := OE_GLOBALS.G_OPR_UPDATE;
366: l_line_tbl(l_index).booked_flag := 'Y';
367: l_line_tbl(l_index).flow_status_code := 'BOOKED';
368: l_line_tbl(l_index).last_updated_by := FND_GLOBAL.USER_ID;
369: l_line_tbl(l_index).last_update_login := FND_GLOBAL.LOGIN_ID;

Line 411: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

407:
408: IF l_line_tbl(l_index).item_type_code not in ('INCLUDED', 'CONFIG') THEN
409:
410: OE_delayed_requests_Pvt.log_request(
411: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
412: p_entity_id => l_line_tbl(l_index).line_id,
413: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
414: p_requesting_entity_id => l_line_tbl(l_index).line_id,
415: p_request_type => OE_GLOBALS.g_tax_line,

Line 413: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

409:
410: OE_delayed_requests_Pvt.log_request(
411: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
412: p_entity_id => l_line_tbl(l_index).line_id,
413: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
414: p_requesting_entity_id => l_line_tbl(l_index).line_id,
415: p_request_type => OE_GLOBALS.g_tax_line,
416: x_return_status => l_return_status);
417:

Line 415: p_request_type => OE_GLOBALS.g_tax_line,

411: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
412: p_entity_id => l_line_tbl(l_index).line_id,
413: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
414: p_requesting_entity_id => l_line_tbl(l_index).line_id,
415: p_request_type => OE_GLOBALS.g_tax_line,
416: x_return_status => l_return_status);
417:
418: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
419: x_return_status := FND_API.G_RET_STS_ERROR;

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

505: -- renga - change for tax calculation event enhancement
506:
507: l_notify := FALSE;
508:
509: IF ( (OE_GLOBALS.G_ASO_INSTALLED = 'Y') OR
510: (OE_GLOBALS.G_EC_INSTALLED = 'Y' ) OR
511: (NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'),'N') = 'Y') )
512: THEN
513: l_notify := TRUE;

Line 510: (OE_GLOBALS.G_EC_INSTALLED = 'Y' ) OR

506:
507: l_notify := FALSE;
508:
509: IF ( (OE_GLOBALS.G_ASO_INSTALLED = 'Y') OR
510: (OE_GLOBALS.G_EC_INSTALLED = 'Y' ) OR
511: (NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'),'N') = 'Y') )
512: THEN
513: l_notify := TRUE;
514:

Line 538: OE_ORDER_UTIL.g_header_adj_tbl(l_in_loop_index).operation := OE_GLOBALS.G_OPR_CREATE;

534: -- loop to populate the operation in the global table
535: l_in_loop_index := OE_ORDER_UTIL.g_header_adj_tbl.FIRST;
536:
537: while l_in_loop_index is not null loop
538: OE_ORDER_UTIL.g_header_adj_tbl(l_in_loop_index).operation := OE_GLOBALS.G_OPR_CREATE;
539: l_in_loop_index := OE_ORDER_UTIL.g_header_adj_tbl.NEXT(l_in_loop_index);
540: END LOOP;
541:
542: oe_debug_pub.add('in OEXUBOKB header adj tbl count is '|| OE_ORDER_UTIL.g_header_adj_tbl.count);

Line 697: OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index).operation := OE_GLOBALS.G_OPR_CREATE;

693: , x_index => l_notify_index
694: , x_return_status => l_return_status);
695:
696: OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index) := l_line_adj_tbl(l_in_loop_index);
697: OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index).operation := OE_GLOBALS.G_OPR_CREATE;
698: oe_debug_pub.add('in OEXUBOKB after insert into global table, line_id is ' || OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index).line_id);
699: oe_debug_pub.add('in OEXUBOKB after insert into global table, operation is ' || OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index).operation);
700:
701: l_in_loop_index := l_line_adj_tbl.NEXT(l_in_loop_index);

Line 1183: OE_GLOBALS.G_IIFM_BOOKING )

1179:
1180: -- Freeze included items, if any, for this order
1181: IF (l_freeze_inc_items
1182: AND FND_PROFILE.VALUE('ONT_INCLUDED_ITEM_FREEZE_METHOD') =
1183: OE_GLOBALS.G_IIFM_BOOKING )
1184: THEN
1185:
1186: l_return_status := OE_Config_Util.Freeze_Inc_Items_For_Order
1187: (p_header_id => p_header_id);

Line 1290: IF NOT OE_GLOBALS.G_ORDER_IMPORT_CALL THEN -- Bug 7367433

1286:
1287: -- From Order Import we will make a call to Verfify Payment, only after committing the data.
1288: -- The call to Verify Payment from Booking code is suppressed for Order Import flow.
1289: -- This change is only for Verify Payment call that is triggered as part of Booking.
1290: IF NOT OE_GLOBALS.G_ORDER_IMPORT_CALL THEN -- Bug 7367433
1291:
1292: -- Payment Verification is done at the end of booking
1293: -- because it is an expensive operation.
1294:

Line 1296: IF nvl(OE_GLOBALS.G_PAYMENT_PROCESSED, 'N') <> 'Y' THEN

1292: -- Payment Verification is done at the end of booking
1293: -- because it is an expensive operation.
1294:
1295: --R12 CVV2
1296: IF nvl(OE_GLOBALS.G_PAYMENT_PROCESSED, 'N') <> 'Y' THEN
1297: Verify_Payment_AT_Booking
1298: (p_header_id => p_header_id
1299: , x_return_status => l_return_status
1300: );

Line 1308: IF nvl(OE_GLOBALS.G_PAYMENT_PROCESSED, 'N') <> 'Y' THEN

1304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1305: END IF;
1306: END IF;
1307: ELSE
1308: IF nvl(OE_GLOBALS.G_PAYMENT_PROCESSED, 'N') <> 'Y' THEN
1309: OE_GLOBALS.G_PAYMENT_PROCESSED := 'O';
1310: END IF;
1311: END IF; -- Bug 7367433
1312:

Line 1309: OE_GLOBALS.G_PAYMENT_PROCESSED := 'O';

1305: END IF;
1306: END IF;
1307: ELSE
1308: IF nvl(OE_GLOBALS.G_PAYMENT_PROCESSED, 'N') <> 'Y' THEN
1309: OE_GLOBALS.G_PAYMENT_PROCESSED := 'O';
1310: END IF;
1311: END IF; -- Bug 7367433
1312:
1313: OE_MSG_PUB.Count_And_Get

Line 1684: ,p_header_id_list IN OE_GLOBALS.Selected_Record_Tbl

1680: ---------------------------------------------------------------------
1681: PROCEDURE Book_Multiple_Orders
1682: (p_api_version_number IN NUMBER
1683: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1684: ,p_header_id_list IN OE_GLOBALS.Selected_Record_Tbl
1685: ,p_header_count IN NUMBER
1686: ,x_error_count OUT NOCOPY NUMBER
1687:
1688: ,x_return_status OUT NOCOPY VARCHAR2