eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.CSD_RULES_ENGINE_PVT dependencies on FND_PROFILE

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

657: * (3) Check if any retrieval needs to be done for default value:
658: * IF l_rule_matching_rec.RULE_RESULTS_TBL(1).VALUE_TYPE = ATTRIBUTE THEN
659: * DEFAULT_VALUE := l_rule_matching_rec.RULE_RESULTS_TBL(1).defaulting_value
660: * ELSIF l_rule_matching_rec.RULE_RESULTS_TBL(1).VALUE_TYPE = PROFILE THEN
661: * DEFAULT_VALUE := get fnd_profile value for profile name stored in
662: * l_rule_matching_rec.RULE_RESULTS_TBL(1).defaulting_value
663: * ELSIF l_rule_matching_rec.RULE_RESULTS_TBL(1).VALUE_TYPE = PLSQL THEN
664: * DEFAULT_VALUE := execute PL/SQL API.
665: * END IF;

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

1057: --** debug starts!!
1058: --dbms_output.put_line('>>>MATCH_CONDITION - USER_INV_ORG');
1059: --** debug ends!!
1060:
1061: l_number_input := FND_PROFILE.VALUE(G_PROFILE_INV_ORG); -- get user inventory org id
1062: l_return_val := CHECK_CONDITION_MATCH(p_input_param => l_number_input,
1063: p_operator => p_operator,
1064: p_criterion => to_number(p_criterion));
1065: ELSIF (p_parameter_type = 'USER_OU') THEN -- to test

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

1790:
1791: -- if defaulting value is null, the try to find profile value if applies
1792: IF (p_defaulting_value IS NULL) THEN -- get profile values and put them in
1793: IF (p_attribute_type = G_ATTR_TYPE_RO) AND (p_attribute_code = G_ATTR_CODE_REPAIR_ORG) THEN
1794: l_return_val := FND_PROFILE.VALUE(G_PROFILE_REPAIR_ORG);
1795: --** debug starts!!
1796: --dbms_output.put_line('~~~ GET_DEFAULT_VALUE , G_ATTR_CODE_REPAIR_ORG, l_return_val from profile = ' || l_return_val);
1797: --** debug ends!!
1798:

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

1803: --dbms_output.put_line('~~~ GET_DEFAULT_VALUE , G_ATTR_CODE_REPAIR_OWNER, l_return_val set to null ');
1804: --** debug ends!!
1805:
1806: ELSIF (p_attribute_type = G_ATTR_TYPE_RO) AND (p_attribute_code = G_ATTR_CODE_INV_ORG) THEN
1807: l_return_val := FND_PROFILE.VALUE(G_PROFILE_INV_ORG);
1808: ELSIF (p_attribute_type = G_ATTR_TYPE_RO) AND (p_attribute_code = G_ATTR_CODE_RMA_RCV_ORG) THEN
1809: --* no profile
1810: l_return_val := NULL;
1811: ELSIF (p_attribute_type = G_ATTR_TYPE_RO) AND (p_attribute_code = G_ATTR_CODE_RMA_RCV_SUBINV) THEN

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

1814: ELSIF (p_attribute_type = G_ATTR_TYPE_RO) AND (p_attribute_code = G_ATTR_CODE_PRIORITY) THEN
1815: --* no profile, place holder for if other defaulting logic is needed.
1816: l_return_val := NULL;
1817: ELSIF (p_attribute_type = G_ATTR_TYPE_RO) AND (p_attribute_code = G_ATTR_CODE_REPAIR_TYPE) THEN
1818: l_return_val := FND_PROFILE.VALUE(G_PROFILE_REPAIR_TYPE);
1819: ELSIF (p_attribute_type = G_ATTR_TYPE_RO) AND (p_attribute_code = G_ATTR_CODE_SHIP_FROM_ORG) THEN
1820: --* no profile
1821: l_return_val := NULL;
1822: ELSIF (p_attribute_type = G_ATTR_TYPE_RO) AND (p_attribute_code = G_ATTR_CODE_SHIP_FROM_SUBINV) THEN

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

1841: IF (p_value_type IS NULL) OR (p_value_type = FND_API.G_MISS_CHAR) --* bulletin rules does not specify this value
1842: OR (p_value_type = G_VALUE_TYPE_ATTRIBUTE) THEN
1843: l_return_val := p_defaulting_value;
1844: ELSIF (p_value_type = G_VALUE_TYPE_PROFILE) THEN
1845: l_return_val := FND_PROFILE.VALUE(p_defaulting_value);
1846: ELSIF (p_value_type = G_VALUE_TYPE_PLSQL) THEN
1847: l_sql_stmt := c_SELECT ||
1848: replace(p_defaulting_value, G_REPAIR_LINE_ID_PARAM, to_char(p_rule_input_rec.repair_line_id)) || --bug#12536477
1849: c_FROM_DUAL;

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

2296: AND sysdate
2297: ; --* end cur_get_chronic_repairs *--
2298: BEGIN
2299: IF (p_repair_line_id IS NOT NULL) THEN
2300: l_period := FND_PROFILE.VALUE(G_PROFILE_QUALITY_CHECK_PERIOD);
2301:
2302:
2303: --** debug starts!!
2304: --dbms_output.put_line('+++>> CHECK_CHRONIC_REPAIR , l_period = ' || l_period);

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

2527: l_join_stmt := 'FND_GLOBAL.USER_ID ' || l_num_condition;
2528: when 'USER_RESPONSIBILITY' then
2529: l_join_stmt := 'FND_GLOBAL.RESP_ID ' || l_num_condition;
2530: when 'USER_INV_ORG' then
2531: l_join_stmt := 'FND_PROFILE.VALUE(''' || G_PROFILE_INV_ORG || ''') '
2532: || l_num_condition;
2533: when 'USER_OU' then
2534: l_join_stmt := 'FND_GLOBAL.ORG_ID ' || l_num_condition;
2535: when 'SR_CUSTOMER_ID' then

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

2629: l_join_stmt := '(SELECT count(dra2.repair_line_id) '
2630: || ' FROM csd_repairs dra2 '
2631: || ' WHERE dra2.customer_product_id = dra.customer_product_id '
2632: || ' AND dra2.date_closed BETWEEN sysdate - '
2633: || ' nvl(FND_PROFILE.VALUE(''CSD_QUALITY_CHECK_PERIOD''), 0) '
2634: || ' AND sysdate) ' || l_num_condition;
2635: -- bug 7323831 - contract line can expire if either end date or termination date
2636: -- has passed. If either date is null, do not consider it as a valid date.
2637: when 'RO_CONTRACT_EXP_THRESHOLD' then