APPS.GMF_GET_XFER_PRICE_HOOK_PUB dependencies on MTL_PARAMETERS

Line 49: l_process_enabled_flag mtl_parameters.process_enabled_flag%TYPE;

45:
46: l_api_name CONSTANT VARCHAR2(30) := 'Get_xfer_price_user_hook';
47: l_api_version CONSTANT NUMBER := 1.0;
48:
49: l_process_enabled_flag mtl_parameters.process_enabled_flag%TYPE;
50: l_primary_cost_method mtl_parameters.primary_cost_method%TYPE;
51: l_return_status VARCHAR2(10);
52:
53: BEGIN

Line 50: l_primary_cost_method mtl_parameters.primary_cost_method%TYPE;

46: l_api_name CONSTANT VARCHAR2(30) := 'Get_xfer_price_user_hook';
47: l_api_version CONSTANT NUMBER := 1.0;
48:
49: l_process_enabled_flag mtl_parameters.process_enabled_flag%TYPE;
50: l_primary_cost_method mtl_parameters.primary_cost_method%TYPE;
51: l_return_status VARCHAR2(10);
52:
53: BEGIN
54:

Line 60: FROM mtl_parameters mp

56: -- initialize api return status to -1 to indicate no user hook
57: -------------------------------------------------------------------------
58: SELECT NVL(process_enabled_flag, 'N'), primary_cost_method
59: INTO l_process_enabled_flag, l_primary_cost_method
60: FROM mtl_parameters mp
61: WHERE organization_id = p_from_organization_id
62: ;
63:
64: IF l_process_enabled_flag = 'Y'