DBA Data[Home] [Help]

APPS.CTO_AUTO_PROCURE_PK dependencies on OE_SYS_PARAMETERS

Line 1696: p_preparer_id := oe_sys_parameters.value('ONT_EMP_ID_FOR_SS_ORDERS',p_org_id);

1692: -- (FP 5633329)bugfix 5514977: If p_prepared_id is null, then get the value from profile ONT_EMP_ID_FOR_SS_ORDERS
1693: ---Profile is obsolete in R12 and it was moved to OE system parameters
1694: ---we are using the operating unit of order line in order to be consistent with OM dropship code
1695: IF p_preparer_id is null and p_interface_source_code in ('CTO','CTO-LOWER LEVEL') THEN
1696: p_preparer_id := oe_sys_parameters.value('ONT_EMP_ID_FOR_SS_ORDERS',p_org_id);
1697:
1698: IF PG_DEBUG <> 0 THEN
1699: oe_debug_pub.add('populate_req_interface: ' || 'Preparer ID (empIdforSSOrders): '||to_char(p_preparer_id),1);
1700: END IF;