DBA Data[Home] [Help]

APPS.OE_HEADER_UTIL dependencies on FND_PROFILE

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

7503: INTO l_order_number,l_order_type_id
7504: FROM oe_order_headers_all
7505: WHERE header_id = p_header_id;
7506:
7507: x_order_source := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
7508: x_order_number := l_order_number;
7509: EXCEPTION
7510: WHEN NO_DATA_FOUND THEN
7511: x_order_number := NULL;

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

7980: i Number;
7981: j Number := 0;
7982: lx_line_rec OE_Order_PUB.Line_Rec_Type;
7983: l_apply_automatic_atchmt VARCHAR2(1) :=
7984: NVL(FND_PROFILE.VALUE('OE_APPLY_AUTOMATIC_ATCHMT'),'Y') ; --5893276
7985:
7986: cursor line_ids(p_header_id IN NUMBER) is
7987: select line_id from oe_order_lines_all
7988: where header_id = p_header_id;

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

8450: -- If the Order Type has changed, we need to sync up the
8451: -- MTL_SALES_ORDERS table.
8452: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
8453:
8454: l_source_code := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
8455: -- 3817802 : New api Get_Base_Order_Type is used to get order type based on base lang
8456: l_new_order_type := Get_Base_Order_Type(p_x_header_rec.order_type_id);
8457: l_order_type := Get_Base_Order_Type(p_old_header_rec.order_type_id);
8458: IF l_debug_level > 0 THEN