DBA Data[Home] [Help]

APPS.INV_INVARCLI_XMLP_PKG dependencies on CST_COST_GROUPS

Line 198: M_COST_GROUP CST_COST_GROUPS.COST_GROUP%TYPE := NULL;

194: -- For bug 14037978, modified the parameters by adding "p_" as prefix and modified the same in the definition
195: -- and replace return clause CHAR with VARCHAR2
196: FUNCTION CF_COST_GROUPFORMULA(P_COST_GROUP_ID IN NUMBER) RETURN VARCHAR2 IS
197: --M_COST_GROUP VARCHAR2(10) := NULL;
198: M_COST_GROUP CST_COST_GROUPS.COST_GROUP%TYPE := NULL;
199: BEGIN
200: IF ((P_WMS_INSTALLED = 'TRUE') AND (P_COST_GROUP_ID IS NOT NULL)) THEN
201: BEGIN
202: SELECT

Line 206: CST_COST_GROUPS

202: SELECT
203: COST_GROUP
204: INTO M_COST_GROUP
205: FROM
206: CST_COST_GROUPS
207: WHERE COST_GROUP_ID = P_COST_GROUP_ID;
208: EXCEPTION
209: WHEN NO_DATA_FOUND THEN
210: M_COST_GROUP := NULL;