DBA Data[Home] [Help]

APPS.OE_ORDER_GRP dependencies on OE_GLOBALS

Line 11: , p_control_rec IN OE_GLOBALS.Control_Rec_Type

7:
8: -- Local procedure: Control_Rec_For_Service_Level
9: PROCEDURE Control_Rec_For_Service_Level
10: ( p_api_service_level IN VARCHAR2
11: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
12: , p_validation_level IN VARCHAR2
13: , x_control_rec OUT NOCOPY /* file.sql.39 change */ OE_GLOBALS.Control_Rec_Type
14: , x_validation_level OUT NOCOPY /* file.sql.39 change */ VARCHAR2
15: )

Line 13: , x_control_rec OUT NOCOPY /* file.sql.39 change */ OE_GLOBALS.Control_Rec_Type

9: PROCEDURE Control_Rec_For_Service_Level
10: ( p_api_service_level IN VARCHAR2
11: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
12: , p_validation_level IN VARCHAR2
13: , x_control_rec OUT NOCOPY /* file.sql.39 change */ OE_GLOBALS.Control_Rec_Type
14: , x_validation_level OUT NOCOPY /* file.sql.39 change */ VARCHAR2
15: )
16: IS
17: BEGIN

Line 23: IF p_api_service_level = OE_GLOBALS.G_CHECK_SECURITY_ONLY THEN

19: IF p_control_rec.controlled_operation THEN
20: x_control_rec.process_partial := p_control_rec.process_partial;
21: END IF;
22:
23: IF p_api_service_level = OE_GLOBALS.G_CHECK_SECURITY_ONLY THEN
24:
25: x_control_rec.controlled_operation := TRUE;
26: x_control_rec.check_security := TRUE;
27: -- Bug 2988993 => clear_dependents should also be FALSE

Line 38: ELSIF p_api_service_level = OE_GLOBALS.G_VALIDATION_ONLY THEN

34: x_control_rec.process := FALSE;
35:
36: x_validation_level := FND_API.G_VALID_LEVEL_NONE;
37:
38: ELSIF p_api_service_level = OE_GLOBALS.G_VALIDATION_ONLY THEN
39:
40: x_control_rec.controlled_operation := TRUE;
41: x_control_rec.check_security := TRUE;
42: x_control_rec.default_attributes := TRUE;

Line 154: , p_control_rec IN OE_GLOBALS.Control_Rec_Type :=

150: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
151: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
152: , p_commit IN VARCHAR2 := FND_API.G_FALSE
153: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
154: , p_control_rec IN OE_GLOBALS.Control_Rec_Type :=
155: OE_GLOBALS.G_MISS_CONTROL_REC
156: , p_api_service_level IN VARCHAR2 := OE_GLOBALS.G_ALL_SERVICE
157: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
158: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 155: OE_GLOBALS.G_MISS_CONTROL_REC

151: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
152: , p_commit IN VARCHAR2 := FND_API.G_FALSE
153: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
154: , p_control_rec IN OE_GLOBALS.Control_Rec_Type :=
155: OE_GLOBALS.G_MISS_CONTROL_REC
156: , p_api_service_level IN VARCHAR2 := OE_GLOBALS.G_ALL_SERVICE
157: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
158: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
159: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 156: , p_api_service_level IN VARCHAR2 := OE_GLOBALS.G_ALL_SERVICE

152: , p_commit IN VARCHAR2 := FND_API.G_FALSE
153: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
154: , p_control_rec IN OE_GLOBALS.Control_Rec_Type :=
155: OE_GLOBALS.G_MISS_CONTROL_REC
156: , p_api_service_level IN VARCHAR2 := OE_GLOBALS.G_ALL_SERVICE
157: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
158: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
159: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
160: , p_header_rec IN OE_Order_Pub.Header_Rec_Type :=

Line 291: l_control_rec OE_GLOBALS.Control_Rec_Type;

287: IS
288: l_org_id NUMBER; -- MOAC
289: l_api_version_number CONSTANT NUMBER := 1.0;
290: l_api_name CONSTANT VARCHAR2(30):= 'Process_Order';
291: l_control_rec OE_GLOBALS.Control_Rec_Type;
292: l_validation_level VARCHAR2(30);
293: l_return_status VARCHAR2(1);
294: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
295: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

Line 334: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';

330: RAISE FND_API.G_EXC_ERROR;
331: END IF;
332:
333: -- Bug 4129234/ orig bug 3823649 ReSet the Audit Trail Global variables
334: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
335: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'N';
336:
337:
338: -- Bug 3013210 => set a savepoint so that rollbacks can be done for

Line 335: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'N';

331: END IF;
332:
333: -- Bug 4129234/ orig bug 3823649 ReSet the Audit Trail Global variables
334: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
335: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'N';
336:
337:
338: -- Bug 3013210 => set a savepoint so that rollbacks can be done for
339: -- validation only service level call

Line 376: OE_GLOBALS.G_DEFAULT_REASON := TRUE;

372: IF p_control_rec.require_reason THEN
373: -- We are calling from Order Import, don't do anything.
374: NULL;
375: ELSE
376: OE_GLOBALS.G_DEFAULT_REASON := TRUE;
377: END IF;
378:
379:
380: -- Initialize the control record based on the api_service_level

Line 516: AND NOT OE_GLOBALS.Equal(x_Header_Payment_tbl(I).trxn_extension_id,FND_API.G_MISS_NUM) THEN --bug 5020737

512:
513: WHILE I IS NOT NULL LOOP
514: IF x_Header_Payment_tbl(I).payment_type_code = 'CREDIT_CARD'
515: AND x_Header_Payment_tbl(I).trxn_extension_id IS NOT NULL
516: AND NOT OE_GLOBALS.Equal(x_Header_Payment_tbl(I).trxn_extension_id,FND_API.G_MISS_NUM) THEN --bug 5020737
517: x_header_rec.credit_card_number := null;
518: x_header_rec.credit_card_code := null;
519: x_header_rec.credit_card_holder_name := null;
520: x_header_rec.credit_card_expiration_date := null;

Line 528: OE_GLOBALS.g_validate_desc_flex := p_validate_desc_flex ;--bug4343612

524:
525: I := x_Header_Payment_tbl.NEXT(I);
526: END LOOP;
527:
528: OE_GLOBALS.g_validate_desc_flex := p_validate_desc_flex ;--bug4343612
529: -- Call OE_Order_PVT.Process_Order
530: OE_Order_PVT.Process_Order
531: ( p_api_version_number => 1.0
532: , p_init_msg_list => p_init_msg_list

Line 621: IF p_api_service_level = OE_GLOBALS.G_VALIDATION_ONLY THEN

617:
618: -- Bug 3013210 => if service level is validation only, rollback any
619: -- DB writes and also clear delayed requests
620:
621: IF p_api_service_level = OE_GLOBALS.G_VALIDATION_ONLY THEN
622:
623: ROLLBACK TO SAVEPOINT Group_Process_Order;
624:
625: OE_Delayed_Requests_PVT.Clear_Request(l_return_status);

Line 2048: , p_control_rec IN OE_GLOBALS.Control_Rec_Type :=

2044: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2045: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
2046: , p_commit IN VARCHAR2 := FND_API.G_FALSE
2047: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2048: , p_control_rec IN OE_GLOBALS.Control_Rec_Type :=
2049: OE_GLOBALS.G_MISS_CONTROL_REC
2050: , p_api_service_level IN VARCHAR2 := OE_GLOBALS.G_ALL_SERVICE
2051: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2052: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 2049: OE_GLOBALS.G_MISS_CONTROL_REC

2045: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
2046: , p_commit IN VARCHAR2 := FND_API.G_FALSE
2047: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2048: , p_control_rec IN OE_GLOBALS.Control_Rec_Type :=
2049: OE_GLOBALS.G_MISS_CONTROL_REC
2050: , p_api_service_level IN VARCHAR2 := OE_GLOBALS.G_ALL_SERVICE
2051: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2052: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2053: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 2050: , p_api_service_level IN VARCHAR2 := OE_GLOBALS.G_ALL_SERVICE

2046: , p_commit IN VARCHAR2 := FND_API.G_FALSE
2047: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2048: , p_control_rec IN OE_GLOBALS.Control_Rec_Type :=
2049: OE_GLOBALS.G_MISS_CONTROL_REC
2050: , p_api_service_level IN VARCHAR2 := OE_GLOBALS.G_ALL_SERVICE
2051: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2052: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2053: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2054: , p_header_rec IN OE_Order_Pub.Header_Rec_Type :=

Line 2164: l_control_rec OE_GLOBALS.Control_Rec_Type;

2160: )
2161: IS
2162: l_api_version_number CONSTANT NUMBER := 1.0;
2163: l_api_name CONSTANT VARCHAR2(30):= 'Process_Order';
2164: l_control_rec OE_GLOBALS.Control_Rec_Type;
2165: l_validation_level VARCHAR2(30);
2166: l_return_status VARCHAR2(1);
2167: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
2168: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

Line 2694: IF p_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND

2690: -- Retrieve the sold_to_org_id if not passed on the header record. This
2691: -- will be needed by the value_to_id functions for related fields.
2692: -- For e.g. oe_value_to_id.ship_to_org_id requires sold_to_org_id
2693:
2694: IF p_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
2695: p_header_rec.sold_to_org_id = FND_API.G_MISS_NUM THEN
2696:
2697: IF l_debug_level > 0 THEN
2698: oe_debug_pub.add('AAC: Selecting Customer Based on old sold_to_org_id');