DBA Data[Home] [Help]

APPS.CZ_IMP_SINGLE dependencies on FND_PROFILE

Line 239: IF(UPPER(FND_PROFILE.VALUE('CZ_IMP_DECIMAL_QTY_FLAG')) = 'Y')THEN

235: END IF;
236: iPrimaryUomCode(nIndex) := PrimaryUomCode(i);
237:
238: /* Added the profile condition for the fix of bug # 3074328 jjujjava 10/06/03 */
239: IF(UPPER(FND_PROFILE.VALUE('CZ_IMP_DECIMAL_QTY_FLAG')) = 'Y')THEN
240: IF(IndivisibleFlag(i) = 'Y')THEN
241: iDecimalQtyFlag(nIndex) := '0';
242: ELSIF(BomItemType(i) = cnStandard OR (BomItemType(i) = cnOptionClass AND allowDecimalOptionClass = 1)) THEN
243: iDecimalQtyFlag(nIndex) := '1';

Line 311: -- by default set max boundary value to FND_PROFILE.VALUE('CZ_DEFAULT_MAX_QTY_INT')

307: FUNCTION setFCEMaxBoundary RETURN NUMBER IS
308: l_max_boundary_val NUMBER;
309: BEGIN
310: --
311: -- by default set max boundary value to FND_PROFILE.VALUE('CZ_DEFAULT_MAX_QTY_INT')
312: --
313: l_max_boundary_val := p_default_int;
314:
315: --

Line 316: -- if Imports sets decimal quantity <=> FND_PROFILE.VALUE('CZ_IMP_DECIMAL_QTY_FLAG')='Y'

312: --
313: l_max_boundary_val := p_default_int;
314:
315: --
316: -- if Imports sets decimal quantity <=> FND_PROFILE.VALUE('CZ_IMP_DECIMAL_QTY_FLAG')='Y'
317: -- and item is decimal <=> p_decimal_item_flag='1'
318: -- then set set max boundary value to FND_PROFILE.VALUE('CZ_DEFAULT_MAX_QTY_DEC')
319: --
320: IF (UPPER(p_set_decimals)='Y' AND p_decimal_item_flag='1') THEN

Line 318: -- then set set max boundary value to FND_PROFILE.VALUE('CZ_DEFAULT_MAX_QTY_DEC')

314:
315: --
316: -- if Imports sets decimal quantity <=> FND_PROFILE.VALUE('CZ_IMP_DECIMAL_QTY_FLAG')='Y'
317: -- and item is decimal <=> p_decimal_item_flag='1'
318: -- then set set max boundary value to FND_PROFILE.VALUE('CZ_DEFAULT_MAX_QTY_DEC')
319: --
320: IF (UPPER(p_set_decimals)='Y' AND p_decimal_item_flag='1') THEN
321: l_max_boundary_val := p_default_dec;
322: END IF;

Line 639: l_imp_decimal_qty_flag VARCHAR2(1) := UPPER(FND_PROFILE.VALUE('CZ_IMP_DECIMAL_QTY_FLAG'));

635: l_set_decimals VARCHAR2(1);
636: l_default_dec NUMBER;
637: l_default_int NUMBER;
638:
639: l_imp_decimal_qty_flag VARCHAR2(1) := UPPER(FND_PROFILE.VALUE('CZ_IMP_DECIMAL_QTY_FLAG'));
640: l_max_boundary_value NUMBER;
641:
642: StackPlanLevel tPlanLevel;
643: StackComponentCode tComponentCode;

Line 1036: IF(UPPER(FND_PROFILE.VALUE('CZ_IMP_DECIMAL_QTY_FLAG')) = 'Y')THEN

1032: iQuoteableFlag(nIndex) := '0';
1033: END IF;
1034: END IF;
1035:
1036: IF(UPPER(FND_PROFILE.VALUE('CZ_IMP_DECIMAL_QTY_FLAG')) = 'Y')THEN
1037:
1038: IF(IndivisibleFlag(i) = 'Y')THEN
1039: iDecimalQtyFlag(nIndex) := '0';
1040: ELSIF(StackModelType(nStack) = 'A' AND (BomItemType(i) = cnStandard OR (BomItemType(i) = cnOptionClass AND allowDecimalOptionClass = 1)))THEN

Line 1279: IF(UPPER(FND_PROFILE.VALUE('CZ_IMP_DECIMAL_QTY_FLAG')) = 'Y')THEN

1275: iQuoteableFlag(nIndex) := '0';
1276: END IF;
1277: END IF;
1278:
1279: IF(UPPER(FND_PROFILE.VALUE('CZ_IMP_DECIMAL_QTY_FLAG')) = 'Y')THEN
1280:
1281: IF(IndivisibleFlag(i) = 'Y')THEN
1282: iDecimalQtyFlag(nIndex) := '0';
1283: ELSIF(StackModelType(nStack) = 'A' AND (BomItemType(i) = cnStandard OR (BomItemType(i) = cnOptionClass AND allowDecimalOptionClass = 1)))THEN

Line 1335: l_use_defaults := FND_PROFILE.VALUE('CZ_BOM_DEFAULT_QTY_DOMN');

1331: -- changes for Solver --
1332: --
1333: IF g_CONFIG_ENGINE_TYPE='F' THEN
1334:
1335: l_use_defaults := FND_PROFILE.VALUE('CZ_BOM_DEFAULT_QTY_DOMN');
1336: l_set_decimals := FND_PROFILE.VALUE('CZ_IMP_DECIMAL_QTY_FLAG');
1337: l_default_dec := FND_PROFILE.VALUE('CZ_DEFAULT_MAX_QTY_DEC');
1338: l_default_int := FND_PROFILE.VALUE('CZ_DEFAULT_MAX_QTY_INT');
1339:

Line 1336: l_set_decimals := FND_PROFILE.VALUE('CZ_IMP_DECIMAL_QTY_FLAG');

1332: --
1333: IF g_CONFIG_ENGINE_TYPE='F' THEN
1334:
1335: l_use_defaults := FND_PROFILE.VALUE('CZ_BOM_DEFAULT_QTY_DOMN');
1336: l_set_decimals := FND_PROFILE.VALUE('CZ_IMP_DECIMAL_QTY_FLAG');
1337: l_default_dec := FND_PROFILE.VALUE('CZ_DEFAULT_MAX_QTY_DEC');
1338: l_default_int := FND_PROFILE.VALUE('CZ_DEFAULT_MAX_QTY_INT');
1339:
1340: FOR j IN 1..iOrigSysRef.COUNT

Line 1337: l_default_dec := FND_PROFILE.VALUE('CZ_DEFAULT_MAX_QTY_DEC');

1333: IF g_CONFIG_ENGINE_TYPE='F' THEN
1334:
1335: l_use_defaults := FND_PROFILE.VALUE('CZ_BOM_DEFAULT_QTY_DOMN');
1336: l_set_decimals := FND_PROFILE.VALUE('CZ_IMP_DECIMAL_QTY_FLAG');
1337: l_default_dec := FND_PROFILE.VALUE('CZ_DEFAULT_MAX_QTY_DEC');
1338: l_default_int := FND_PROFILE.VALUE('CZ_DEFAULT_MAX_QTY_INT');
1339:
1340: FOR j IN 1..iOrigSysRef.COUNT
1341: LOOP

Line 1338: l_default_int := FND_PROFILE.VALUE('CZ_DEFAULT_MAX_QTY_INT');

1334:
1335: l_use_defaults := FND_PROFILE.VALUE('CZ_BOM_DEFAULT_QTY_DOMN');
1336: l_set_decimals := FND_PROFILE.VALUE('CZ_IMP_DECIMAL_QTY_FLAG');
1337: l_default_dec := FND_PROFILE.VALUE('CZ_DEFAULT_MAX_QTY_DEC');
1338: l_default_int := FND_PROFILE.VALUE('CZ_DEFAULT_MAX_QTY_INT');
1339:
1340: FOR j IN 1..iOrigSysRef.COUNT
1341: LOOP
1342: -- this a special case of root of BOM Model

Line 1952: fnd_profile.get('CZ_SEGS_FOR_ITEMTYPE_NAME', l_name_method);

1948: if (CZ_IMP_ALL.get_time) then
1949: st_time := dbms_utility.get_time();
1950: end if;
1951:
1952: fnd_profile.get('CZ_SEGS_FOR_ITEMTYPE_NAME', l_name_method);
1953:
1954: IF (l_name_method = 'CZ_CAT_DESC') THEN
1955: l_use_segments := FALSE;
1956: ELSIF (l_name_method = 'CZ_CAT_CONCAT_SEGS') THEN

Line 3507: g_CONFIG_ENGINE_TYPE := FND_PROFILE.VALUE('CZ_CONFIG_ENGINE_NEW_MODELS');

3503: AND d.devl_project_id = d.persistent_project_id
3504: AND p.model_ps_node_id = d.devl_project_id;
3505: EXCEPTION
3506: WHEN NO_DATA_FOUND THEN
3507: g_CONFIG_ENGINE_TYPE := FND_PROFILE.VALUE('CZ_CONFIG_ENGINE_NEW_MODELS');
3508: END;
3509: ELSE
3510: SELECT NVL(config_engine_type,'L') INTO g_CONFIG_ENGINE_TYPE FROM CZ_DEVL_PROJECTS
3511: WHERE devl_project_id=REFRESH_MODEL_ID;