APPS.CZ_DEVELOPER_UTILS_PVT dependencies on FND_PROFILE

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

2980: BEGIN
2981:
2982: IF(p_ps_node_type >= BOM_MODEL_TYPE)THEN
2983:
2984: v_label := NVL(fnd_profile.value_wnps(PROFILE_OPTION_LABEL_BOM), OPTION_VALUE_LABEL_NAME);
2985: ELSE
2986:
2987: v_label := NVL(fnd_profile.value_wnps(PROFILE_OPTION_LABEL_NONBOM), OPTION_VALUE_LABEL_NAME);
2988: END IF;

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

2983:
2984: v_label := NVL(fnd_profile.value_wnps(PROFILE_OPTION_LABEL_BOM), OPTION_VALUE_LABEL_NAME);
2985: ELSE
2986:
2987: v_label := NVL(fnd_profile.value_wnps(PROFILE_OPTION_LABEL_NONBOM), OPTION_VALUE_LABEL_NAME);
2988: END IF;
2989:
2990: IF(v_label = OPTION_VALUE_LABEL_NAME)THEN RETURN p_name; ELSE RETURN NVL(p_description, p_name); END IF;
2991: END get_node_label;

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

3015: END IF;
3016:
3017: IF(v_ps_node_type >= BOM_MODEL_TYPE)THEN
3018:
3019: v_label := NVL(fnd_profile.value_wnps(PROFILE_OPTION_LABEL_BOM), OPTION_VALUE_LABEL_NAME);
3020: ELSE
3021:
3022: v_label := NVL(fnd_profile.value_wnps(PROFILE_OPTION_LABEL_NONBOM), OPTION_VALUE_LABEL_NAME);
3023: END IF;

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

3018:
3019: v_label := NVL(fnd_profile.value_wnps(PROFILE_OPTION_LABEL_BOM), OPTION_VALUE_LABEL_NAME);
3020: ELSE
3021:
3022: v_label := NVL(fnd_profile.value_wnps(PROFILE_OPTION_LABEL_NONBOM), OPTION_VALUE_LABEL_NAME);
3023: END IF;
3024:
3025: IF(v_label = OPTION_VALUE_LABEL_NAME)THEN RETURN v_name; ELSE RETURN NVL(v_description, v_name); END IF;
3026: END get_node_label;

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

3037: BEGIN
3038:
3039: --Read and default the profile option values to 'Name'.
3040:
3041: v_label_bom := NVL(fnd_profile.value_wnps(PROFILE_OPTION_LABEL_BOM), OPTION_VALUE_LABEL_NAME);
3042: v_label_nonbom := NVL(fnd_profile.value_wnps(PROFILE_OPTION_LABEL_NONBOM), OPTION_VALUE_LABEL_NAME);
3043:
3044: BEGIN
3045: SELECT ps_node_id INTO l_ps_node_id

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

3038:
3039: --Read and default the profile option values to 'Name'.
3040:
3041: v_label_bom := NVL(fnd_profile.value_wnps(PROFILE_OPTION_LABEL_BOM), OPTION_VALUE_LABEL_NAME);
3042: v_label_nonbom := NVL(fnd_profile.value_wnps(PROFILE_OPTION_LABEL_NONBOM), OPTION_VALUE_LABEL_NAME);
3043:
3044: BEGIN
3045: SELECT ps_node_id INTO l_ps_node_id
3046: FROM CZ_PS_NODES

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

11609: --The actual reading of the profile option value will be done only once or, if the node on which
11610: --the function is called, is always effective - never.
11611:
11612: IF(v_filter IS NULL)THEN
11613: v_filter := NVL(fnd_profile.value_wnps(PROFILE_OPTION_EFF_FILTER), OPTION_VALUE_FILTER_ALL);
11614: IF(v_filter = OPTION_VALUE_FILTER_ALL)THEN RETURN 1; END IF;
11615: END IF;
11616:
11617: IF(v_eff_until < v_eff_from)THEN RETURN 0; END IF;

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

11671: h_eff_from date_hash_table;
11672: h_eff_until date_hash_table;
11673: BEGIN
11674:
11675: v_filter := NVL(fnd_profile.value_wnps(PROFILE_OPTION_EFF_FILTER), OPTION_VALUE_FILTER_ALL);
11676: IF(v_filter = OPTION_VALUE_FILTER_ALL)THEN
11677: FOR i IN 1..p_self_eff_set_id.COUNT LOOP
11678: v_return.EXTEND();
11679: v_return(i) := 1;