DBA Data[Home] [Help]

APPS.OE_HEADER_UTIL dependencies on FND_PROFILE

Line 7659: x_order_source := FND_PROFILE.VALUE('ONT_SOURCE_CODE');

7655: INTO l_order_number,l_order_type_id
7656: FROM oe_order_headers_all
7657: WHERE header_id = p_header_id;
7658:
7659: x_order_source := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
7660: x_order_number := l_order_number;
7661: EXCEPTION
7662: WHEN NO_DATA_FOUND THEN
7663: x_order_number := NULL;

Line 8167: NVL(FND_PROFILE.VALUE('OE_APPLY_AUTOMATIC_ATCHMT'),'Y') ; --5893276

8163: i Number;
8164: j Number := 0;
8165: lx_line_rec OE_Order_PUB.Line_Rec_Type;
8166: l_apply_automatic_atchmt VARCHAR2(1) :=
8167: NVL(FND_PROFILE.VALUE('OE_APPLY_AUTOMATIC_ATCHMT'),'Y') ; --5893276
8168:
8169: cursor line_ids(p_header_id IN NUMBER) is
8170: select line_id from oe_order_lines_all
8171: where header_id = p_header_id;

Line 8647: l_source_code := FND_PROFILE.VALUE('ONT_SOURCE_CODE');

8643: -- If the Order Type has changed, we need to sync up the
8644: -- MTL_SALES_ORDERS table.
8645: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
8646:
8647: l_source_code := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
8648: -- 3817802 : New api Get_Base_Order_Type is used to get order type based on base lang
8649: l_new_order_type := Get_Base_Order_Type(p_x_header_rec.order_type_id);
8650: l_order_type := Get_Base_Order_Type(p_old_header_rec.order_type_id);
8651: IF l_debug_level > 0 THEN