DBA Data[Home] [Help]

APPS.CSTPPCAT dependencies on MTL_PARAMETERS

Line 17: p_cost_method MTL_PARAMETERS.PRIMARY_COST_METHOD%TYPE;

13: O_RETURN_CODE OUT NOCOPY NUMBER,
14: O_RETURN_ERR OUT NOCOPY VARCHAR2
15: ) IS
16: row_count NUMBER;
17: p_cost_method MTL_PARAMETERS.PRIMARY_COST_METHOD%TYPE;
18: p_avg_rates_cost_type MTL_PARAMETERS.AVG_RATES_COST_TYPE_ID%TYPE; --Added for 7237799
19: retval NUMBER;
20: retmsg VARCHAR(100);
21: BEGIN

Line 18: p_avg_rates_cost_type MTL_PARAMETERS.AVG_RATES_COST_TYPE_ID%TYPE; --Added for 7237799

14: O_RETURN_ERR OUT NOCOPY VARCHAR2
15: ) IS
16: row_count NUMBER;
17: p_cost_method MTL_PARAMETERS.PRIMARY_COST_METHOD%TYPE;
18: p_avg_rates_cost_type MTL_PARAMETERS.AVG_RATES_COST_TYPE_ID%TYPE; --Added for 7237799
19: retval NUMBER;
20: retmsg VARCHAR(100);
21: BEGIN
22:

Line 32: from mtl_parameters

28: * 2 = Average costing/Average cost type
29: */
30: select primary_cost_method, avg_rates_cost_type_id
31: into p_cost_method, p_avg_rates_cost_type
32: from mtl_parameters
33: where organization_id = I_ORGANIZATION_ID;
34:
35: /*
36: * Added the below ELSE condition or bug 7237799