DBA Data[Home] [Help]

APPS.CZ_IMP_SINGLE dependencies on FND_PROFILE

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

259: iDeletedFlag(nIndex) := '0';
260: iPrimaryUomCode(nIndex) := PrimaryUomCode(i);
261:
262: /* Added the profile condition for the fix of bug # 3074328 jjujjava 10/06/03 */
263: IF(UPPER(FND_PROFILE.VALUE('CZ_IMP_DECIMAL_QTY_FLAG')) = 'Y')THEN
264: IF(IndivisibleFlag(i) = 'Y')THEN
265: iDecimalQtyFlag(nIndex) := '0';
266: ELSIF(BomItemType(i) = cnStandard OR (BomItemType(i) = cnOptionClass AND allowDecimalOptionClass = 1)) THEN
267: iDecimalQtyFlag(nIndex) := '1';

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

331: FUNCTION setFCEMaxBoundary RETURN NUMBER IS
332: l_max_boundary_val NUMBER;
333: BEGIN
334: --
335: -- by default set max boundary value to FND_PROFILE.VALUE('CZ_DEFAULT_MAX_QTY_INT')
336: --
337: l_max_boundary_val := p_default_int;
338:
339: --

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

336: --
337: l_max_boundary_val := p_default_int;
338:
339: --
340: -- if Imports sets decimal quantity <=> FND_PROFILE.VALUE('CZ_IMP_DECIMAL_QTY_FLAG')='Y'
341: -- and item is decimal <=> p_decimal_item_flag='1'
342: -- then set set max boundary value to FND_PROFILE.VALUE('CZ_DEFAULT_MAX_QTY_DEC')
343: --
344: IF (UPPER(p_set_decimals)='Y' AND p_decimal_item_flag='1') THEN

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

338:
339: --
340: -- if Imports sets decimal quantity <=> FND_PROFILE.VALUE('CZ_IMP_DECIMAL_QTY_FLAG')='Y'
341: -- and item is decimal <=> p_decimal_item_flag='1'
342: -- then set set max boundary value to FND_PROFILE.VALUE('CZ_DEFAULT_MAX_QTY_DEC')
343: --
344: IF (UPPER(p_set_decimals)='Y' AND p_decimal_item_flag='1') THEN
345: l_max_boundary_val := p_default_dec;
346: END IF;

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

659: l_set_decimals VARCHAR2(1);
660: l_default_dec NUMBER;
661: l_default_int NUMBER;
662:
663: l_imp_decimal_qty_flag VARCHAR2(1) := UPPER(FND_PROFILE.VALUE('CZ_IMP_DECIMAL_QTY_FLAG'));
664: l_max_boundary_value NUMBER;
665:
666: StackPlanLevel tPlanLevel;
667: StackComponentCode tComponentCode;

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

1059: iQuoteableFlag(nIndex) := '0';
1060: END IF;
1061: END IF;
1062:
1063: IF(UPPER(FND_PROFILE.VALUE('CZ_IMP_DECIMAL_QTY_FLAG')) = 'Y')THEN
1064:
1065: IF(IndivisibleFlag(i) = 'Y')THEN
1066: iDecimalQtyFlag(nIndex) := '0';
1067: ELSIF(StackModelType(nStack) = 'A' AND (BomItemType(i) = cnStandard OR (BomItemType(i) = cnOptionClass AND allowDecimalOptionClass = 1)))THEN

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

1302: iQuoteableFlag(nIndex) := '0';
1303: END IF;
1304: END IF;
1305:
1306: IF(UPPER(FND_PROFILE.VALUE('CZ_IMP_DECIMAL_QTY_FLAG')) = 'Y')THEN
1307:
1308: IF(IndivisibleFlag(i) = 'Y')THEN
1309: iDecimalQtyFlag(nIndex) := '0';
1310: ELSIF(StackModelType(nStack) = 'A' AND (BomItemType(i) = cnStandard OR (BomItemType(i) = cnOptionClass AND allowDecimalOptionClass = 1)))THEN

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

1358: -- changes for Solver --
1359: --
1360: IF g_CONFIG_ENGINE_TYPE='F' THEN
1361:
1362: l_use_defaults := FND_PROFILE.VALUE('CZ_BOM_DEFAULT_QTY_DOMN');
1363: l_set_decimals := FND_PROFILE.VALUE('CZ_IMP_DECIMAL_QTY_FLAG');
1364: l_default_dec := FND_PROFILE.VALUE('CZ_DEFAULT_MAX_QTY_DEC');
1365: l_default_int := FND_PROFILE.VALUE('CZ_DEFAULT_MAX_QTY_INT');
1366:

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

1359: --
1360: IF g_CONFIG_ENGINE_TYPE='F' THEN
1361:
1362: l_use_defaults := FND_PROFILE.VALUE('CZ_BOM_DEFAULT_QTY_DOMN');
1363: l_set_decimals := FND_PROFILE.VALUE('CZ_IMP_DECIMAL_QTY_FLAG');
1364: l_default_dec := FND_PROFILE.VALUE('CZ_DEFAULT_MAX_QTY_DEC');
1365: l_default_int := FND_PROFILE.VALUE('CZ_DEFAULT_MAX_QTY_INT');
1366:
1367: FOR j IN 1..iOrigSysRef.COUNT

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

1360: IF g_CONFIG_ENGINE_TYPE='F' THEN
1361:
1362: l_use_defaults := FND_PROFILE.VALUE('CZ_BOM_DEFAULT_QTY_DOMN');
1363: l_set_decimals := FND_PROFILE.VALUE('CZ_IMP_DECIMAL_QTY_FLAG');
1364: l_default_dec := FND_PROFILE.VALUE('CZ_DEFAULT_MAX_QTY_DEC');
1365: l_default_int := FND_PROFILE.VALUE('CZ_DEFAULT_MAX_QTY_INT');
1366:
1367: FOR j IN 1..iOrigSysRef.COUNT
1368: LOOP

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

1361:
1362: l_use_defaults := FND_PROFILE.VALUE('CZ_BOM_DEFAULT_QTY_DOMN');
1363: l_set_decimals := FND_PROFILE.VALUE('CZ_IMP_DECIMAL_QTY_FLAG');
1364: l_default_dec := FND_PROFILE.VALUE('CZ_DEFAULT_MAX_QTY_DEC');
1365: l_default_int := FND_PROFILE.VALUE('CZ_DEFAULT_MAX_QTY_INT');
1366:
1367: FOR j IN 1..iOrigSysRef.COUNT
1368: LOOP
1369: -- this a special case of root of BOM Model

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

2010: if (CZ_IMP_ALL.get_time) then
2011: st_time := dbms_utility.get_time();
2012: end if;
2013:
2014: fnd_profile.get('CZ_SEGS_FOR_ITEMTYPE_NAME', l_name_method);
2015:
2016: IF (l_name_method = 'CZ_CAT_DESC') THEN
2017: l_use_segments := FALSE;
2018: ELSIF (l_name_method = 'CZ_CAT_CONCAT_SEGS') THEN

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

3816: AND d.devl_project_id = d.persistent_project_id
3817: AND p.model_ps_node_id = d.devl_project_id;
3818: EXCEPTION
3819: WHEN NO_DATA_FOUND THEN
3820: g_CONFIG_ENGINE_TYPE := FND_PROFILE.VALUE('CZ_CONFIG_ENGINE_NEW_MODELS');
3821: END;
3822: ELSE
3823: SELECT NVL(config_engine_type,'L') INTO g_CONFIG_ENGINE_TYPE FROM CZ_DEVL_PROJECTS
3824: WHERE devl_project_id=REFRESH_MODEL_ID;