DBA Data[Home] [Help]

APPS.CSD_RULES_ENGINE_PVT dependencies on FND_PROFILE

Line 367: * DEFAULT_VALUE := get fnd_profile value for profile name stored in

363: * (3) Check if any retrieval needs to be done for default value:
364: * IF l_rule_matching_rec.RULE_RESULTS_TBL(1).VALUE_TYPE = ATTRIBUTE THEN
365: * DEFAULT_VALUE := l_rule_matching_rec.RULE_RESULTS_TBL(1).defaulting_value
366: * ELSIF l_rule_matching_rec.RULE_RESULTS_TBL(1).VALUE_TYPE = PROFILE THEN
367: * DEFAULT_VALUE := get fnd_profile value for profile name stored in
368: * l_rule_matching_rec.RULE_RESULTS_TBL(1).defaulting_value
369: * ELSIF l_rule_matching_rec.RULE_RESULTS_TBL(1).VALUE_TYPE = PLSQL THEN
370: * DEFAULT_VALUE := execute PL/SQL API.
371: * END IF;

Line 767: l_number_input := FND_PROFILE.VALUE(G_PROFILE_INV_ORG); -- get user inventory org id

763: --** debug starts!!
764: --dbms_output.put_line('>>>MATCH_CONDITION - USER_INV_ORG');
765: --** debug ends!!
766:
767: l_number_input := FND_PROFILE.VALUE(G_PROFILE_INV_ORG); -- get user inventory org id
768: l_return_val := CHECK_CONDITION_MATCH(p_input_param => l_number_input,
769: p_operator => p_operator,
770: p_criterion => to_number(p_criterion));
771: ELSIF (p_parameter_type = 'USER_OU') THEN -- to test

Line 1232: l_return_val := FND_PROFILE.VALUE(G_PROFILE_REPAIR_ORG);

1228:
1229: -- if defaulting value is null, the try to find profile value if applies
1230: IF (p_defaulting_value IS NULL) THEN -- get profile values and put them in
1231: IF (p_attribute_type = G_ATTR_TYPE_RO) AND (p_attribute_code = G_ATTR_CODE_REPAIR_ORG) THEN
1232: l_return_val := FND_PROFILE.VALUE(G_PROFILE_REPAIR_ORG);
1233: --** debug starts!!
1234: --dbms_output.put_line('~~~ GET_DEFAULT_VALUE , G_ATTR_CODE_REPAIR_ORG, l_return_val from profile = ' || l_return_val);
1235: --** debug ends!!
1236:

Line 1245: l_return_val := FND_PROFILE.VALUE(G_PROFILE_INV_ORG);

1241: --dbms_output.put_line('~~~ GET_DEFAULT_VALUE , G_ATTR_CODE_REPAIR_OWNER, l_return_val set to null ');
1242: --** debug ends!!
1243:
1244: ELSIF (p_attribute_type = G_ATTR_TYPE_RO) AND (p_attribute_code = G_ATTR_CODE_INV_ORG) THEN
1245: l_return_val := FND_PROFILE.VALUE(G_PROFILE_INV_ORG);
1246: ELSIF (p_attribute_type = G_ATTR_TYPE_RO) AND (p_attribute_code = G_ATTR_CODE_RMA_RCV_ORG) THEN
1247: --* no profile
1248: l_return_val := NULL;
1249: ELSIF (p_attribute_type = G_ATTR_TYPE_RO) AND (p_attribute_code = G_ATTR_CODE_RMA_RCV_SUBINV) THEN

Line 1256: l_return_val := FND_PROFILE.VALUE(G_PROFILE_REPAIR_TYPE);

1252: ELSIF (p_attribute_type = G_ATTR_TYPE_RO) AND (p_attribute_code = G_ATTR_CODE_PRIORITY) THEN
1253: --* no profile, place holder for if other defaulting logic is needed.
1254: l_return_val := NULL;
1255: ELSIF (p_attribute_type = G_ATTR_TYPE_RO) AND (p_attribute_code = G_ATTR_CODE_REPAIR_TYPE) THEN
1256: l_return_val := FND_PROFILE.VALUE(G_PROFILE_REPAIR_TYPE);
1257: ELSIF (p_attribute_type = G_ATTR_TYPE_RO) AND (p_attribute_code = G_ATTR_CODE_SHIP_FROM_ORG) THEN
1258: --* no profile
1259: l_return_val := NULL;
1260: ELSIF (p_attribute_type = G_ATTR_TYPE_RO) AND (p_attribute_code = G_ATTR_CODE_SHIP_FROM_SUBINV) THEN

Line 1275: l_return_val := FND_PROFILE.VALUE(p_defaulting_value);

1271: IF (p_value_type IS NULL) OR (p_value_type = FND_API.G_MISS_CHAR) --* bulletin rules does not specify this value
1272: OR (p_value_type = G_VALUE_TYPE_ATTRIBUTE) THEN
1273: l_return_val := p_defaulting_value;
1274: ELSIF (p_value_type = G_VALUE_TYPE_PROFILE) THEN
1275: l_return_val := FND_PROFILE.VALUE(p_defaulting_value);
1276: ELSIF (p_value_type = G_VALUE_TYPE_PLSQL) THEN
1277: l_sql_stmt := c_SELECT || p_defaulting_value || c_FROM_DUAL;
1278:
1279: --** debug starts!!

Line 1728: l_period := FND_PROFILE.VALUE(G_PROFILE_QUALITY_CHECK_PERIOD);

1724: AND sysdate
1725: ; --* end cur_get_chronic_repairs *--
1726: BEGIN
1727: IF (p_repair_line_id IS NOT NULL) THEN
1728: l_period := FND_PROFILE.VALUE(G_PROFILE_QUALITY_CHECK_PERIOD);
1729:
1730:
1731: --** debug starts!!
1732: --dbms_output.put_line('+++>> CHECK_CHRONIC_REPAIR , l_period = ' || l_period);

Line 1959: l_join_stmt := 'FND_PROFILE.VALUE(''' || G_PROFILE_INV_ORG || ''') '

1955: l_join_stmt := 'FND_GLOBAL.USER_ID ' || l_num_condition;
1956: when 'USER_RESPONSIBILITY' then
1957: l_join_stmt := 'FND_GLOBAL.RESP_ID ' || l_num_condition;
1958: when 'USER_INV_ORG' then
1959: l_join_stmt := 'FND_PROFILE.VALUE(''' || G_PROFILE_INV_ORG || ''') '
1960: || l_num_condition;
1961: when 'USER_OU' then
1962: l_join_stmt := 'FND_GLOBAL.ORG_ID ' || l_num_condition;
1963: when 'SR_CUSTOMER_ID' then

Line 2061: || ' nvl(FND_PROFILE.VALUE(''CSD_QUALITY_CHECK_PERIOD''), 0) '

2057: l_join_stmt := '(SELECT count(dra2.repair_line_id) '
2058: || ' FROM csd_repairs dra2 '
2059: || ' WHERE dra2.customer_product_id = dra.customer_product_id '
2060: || ' AND dra2.date_closed BETWEEN sysdate - '
2061: || ' nvl(FND_PROFILE.VALUE(''CSD_QUALITY_CHECK_PERIOD''), 0) '
2062: || ' AND sysdate) ' || l_num_condition;
2063: -- bug 7323831 - contract line can expire if either end date or termination date
2064: -- has passed. If either date is null, do not consider it as a valid date.
2065: when 'RO_CONTRACT_EXP_THRESHOLD' then