APPS.CZ_DEVELOPER_UTILS_PVT dependencies on FND_PROFILE

Line 3012: v_label := NVL(fnd_profile.value_wnps(PROFILE_OPTION_LABEL_BOM), OPTION_VALUE_LABEL_NAME);

3008: BEGIN
3009:
3010: IF(p_ps_node_type >= BOM_MODEL_TYPE)THEN
3011:
3012: v_label := NVL(fnd_profile.value_wnps(PROFILE_OPTION_LABEL_BOM), OPTION_VALUE_LABEL_NAME);
3013: ELSE
3014:
3015: v_label := NVL(fnd_profile.value_wnps(PROFILE_OPTION_LABEL_NONBOM), OPTION_VALUE_LABEL_NAME);
3016: END IF;

Line 3015: v_label := NVL(fnd_profile.value_wnps(PROFILE_OPTION_LABEL_NONBOM), OPTION_VALUE_LABEL_NAME);

3011:
3012: v_label := NVL(fnd_profile.value_wnps(PROFILE_OPTION_LABEL_BOM), OPTION_VALUE_LABEL_NAME);
3013: ELSE
3014:
3015: v_label := NVL(fnd_profile.value_wnps(PROFILE_OPTION_LABEL_NONBOM), OPTION_VALUE_LABEL_NAME);
3016: END IF;
3017:
3018: IF(v_label = OPTION_VALUE_LABEL_NAME)THEN RETURN p_name; ELSE RETURN NVL(p_description, p_name); END IF;
3019: END get_node_label;

Line 3047: v_label := NVL(fnd_profile.value_wnps(PROFILE_OPTION_LABEL_BOM), OPTION_VALUE_LABEL_NAME);

3043: END IF;
3044:
3045: IF(v_ps_node_type >= BOM_MODEL_TYPE)THEN
3046:
3047: v_label := NVL(fnd_profile.value_wnps(PROFILE_OPTION_LABEL_BOM), OPTION_VALUE_LABEL_NAME);
3048: ELSE
3049:
3050: v_label := NVL(fnd_profile.value_wnps(PROFILE_OPTION_LABEL_NONBOM), OPTION_VALUE_LABEL_NAME);
3051: END IF;

Line 3050: v_label := NVL(fnd_profile.value_wnps(PROFILE_OPTION_LABEL_NONBOM), OPTION_VALUE_LABEL_NAME);

3046:
3047: v_label := NVL(fnd_profile.value_wnps(PROFILE_OPTION_LABEL_BOM), OPTION_VALUE_LABEL_NAME);
3048: ELSE
3049:
3050: v_label := NVL(fnd_profile.value_wnps(PROFILE_OPTION_LABEL_NONBOM), OPTION_VALUE_LABEL_NAME);
3051: END IF;
3052:
3053: IF(v_label = OPTION_VALUE_LABEL_NAME)THEN RETURN v_name; ELSE RETURN NVL(v_description, v_name); END IF;
3054: END get_node_label;

Line 3069: v_label_bom := NVL(fnd_profile.value_wnps(PROFILE_OPTION_LABEL_BOM), OPTION_VALUE_LABEL_NAME);

3065: BEGIN
3066:
3067: --Read and default the profile option values to 'Name'.
3068:
3069: v_label_bom := NVL(fnd_profile.value_wnps(PROFILE_OPTION_LABEL_BOM), OPTION_VALUE_LABEL_NAME);
3070: v_label_nonbom := NVL(fnd_profile.value_wnps(PROFILE_OPTION_LABEL_NONBOM), OPTION_VALUE_LABEL_NAME);
3071:
3072: BEGIN
3073: SELECT ps_node_id INTO l_ps_node_id

Line 3070: v_label_nonbom := NVL(fnd_profile.value_wnps(PROFILE_OPTION_LABEL_NONBOM), OPTION_VALUE_LABEL_NAME);

3066:
3067: --Read and default the profile option values to 'Name'.
3068:
3069: v_label_bom := NVL(fnd_profile.value_wnps(PROFILE_OPTION_LABEL_BOM), OPTION_VALUE_LABEL_NAME);
3070: v_label_nonbom := NVL(fnd_profile.value_wnps(PROFILE_OPTION_LABEL_NONBOM), OPTION_VALUE_LABEL_NAME);
3071:
3072: BEGIN
3073: SELECT ps_node_id INTO l_ps_node_id
3074: FROM CZ_PS_NODES

Line 11687: v_filter := NVL(fnd_profile.value_wnps(PROFILE_OPTION_EFF_FILTER), OPTION_VALUE_FILTER_ALL);

11683: --The actual reading of the profile option value will be done only once or, if the node on which
11684: --the function is called, is always effective - never.
11685:
11686: IF(v_filter IS NULL)THEN
11687: v_filter := NVL(fnd_profile.value_wnps(PROFILE_OPTION_EFF_FILTER), OPTION_VALUE_FILTER_ALL);
11688: IF(v_filter = OPTION_VALUE_FILTER_ALL)THEN RETURN 1; END IF;
11689: END IF;
11690:
11691: IF(v_eff_until < v_eff_from)THEN RETURN 0; END IF;

Line 11749: v_filter := NVL(fnd_profile.value_wnps(PROFILE_OPTION_EFF_FILTER), OPTION_VALUE_FILTER_ALL);

11745: h_eff_from date_hash_table;
11746: h_eff_until date_hash_table;
11747: BEGIN
11748:
11749: v_filter := NVL(fnd_profile.value_wnps(PROFILE_OPTION_EFF_FILTER), OPTION_VALUE_FILTER_ALL);
11750: IF(v_filter = OPTION_VALUE_FILTER_ALL)THEN
11751: FOR i IN 1..p_self_eff_set_id.COUNT LOOP
11752: v_return.EXTEND();
11753: v_return(i) := 1;