DBA Data[Home] [Help]

APPS.INL_INTEGRATION_GRP dependencies on FND_PROFILE

Line 559: l_ship_type_id := NVL(FND_PROFILE.VALUE('INL_SHIP_TYPE_ID_OI'),0);

555: p_module_name => g_module_name,
556: p_procedure_name => l_proc_name,
557: p_debug_info => 'Get value from profile INL_SHIP_TYPE_ID_OI' );
558:
559: l_ship_type_id := NVL(FND_PROFILE.VALUE('INL_SHIP_TYPE_ID_OI'),0);
560:
561: INL_LOGGING_PVT.Log_Variable (
562: p_module_name => g_module_name,
563: p_procedure_name => l_proc_name,

Line 2938: AND DECODE(FND_PROFILE.VALUE('RCV_CLOSED_PO_DEFAULT_OPTION'),'N',NVL(pll.closed_code,'OPEN'), 'OPEN') NOT IN ('CLOSED','CLOSED FOR RECEIVING')

2934: NULL,
2935: p_vendor_id,
2936: p_vendor_site_id) = 'Y'
2937: -- Debug 13064637 pick PO details based on the profile option set
2938: AND DECODE(FND_PROFILE.VALUE('RCV_CLOSED_PO_DEFAULT_OPTION'),'N',NVL(pll.closed_code,'OPEN'), 'OPEN') NOT IN ('CLOSED','CLOSED FOR RECEIVING')
2939: ORDER BY pll.ship_to_organization_id,
2940: pll.ship_to_location_id,
2941: pl.line_num,
2942: pll.line_location_id;

Line 2963: l_ship_type_id := NVL(FND_PROFILE.VALUE('INL_SHIP_TYPE_ID_OI'),0);

2959: p_var_name => 'p_po_hdr_rec.po_header_id',
2960: p_var_value => p_po_hdr_rec.po_header_id);
2961:
2962: -- Verifying: the INL: Default Type for Simulated Shipment profile must be setup
2963: l_ship_type_id := NVL(FND_PROFILE.VALUE('INL_SHIP_TYPE_ID_OI'),0);
2964:
2965: INL_LOGGING_PVT.Log_Variable (
2966: p_module_name => g_module_name,
2967: p_procedure_name => l_proc_name,