DBA Data[Home] [Help]

APPS.GMA_CORE_PKG dependencies on FND_PROFILE

Line 20: RETURN to_date(fnd_profile.value_wnps('SY$MIN_DATE'),'YYYY/MM/DD HH24:MI:SS');

16:
17: FUNCTION get_date_constant_d(V_constant IN VARCHAR2) RETURN DATE IS
18: begin
19: IF (V_constant in ('SY$MIN_DATE')) THEN
20: RETURN to_date(fnd_profile.value_wnps('SY$MIN_DATE'),'YYYY/MM/DD HH24:MI:SS');
21: ELSIF (V_constant in ('SY$MAX_DATE')) THEN
22: RETURN to_date(fnd_profile.value_wnps('SY$MAX_DATE'),'YYYY/MM/DD HH24:MI:SS');
23: ELSIF (V_constant in ('SY$ZERODATE')) THEN
24: RETURN to_date(fnd_profile.value_wnps('SY$ZERODATE'),'YYYY/MM/DD HH24:MI:SS');

Line 22: RETURN to_date(fnd_profile.value_wnps('SY$MAX_DATE'),'YYYY/MM/DD HH24:MI:SS');

18: begin
19: IF (V_constant in ('SY$MIN_DATE')) THEN
20: RETURN to_date(fnd_profile.value_wnps('SY$MIN_DATE'),'YYYY/MM/DD HH24:MI:SS');
21: ELSIF (V_constant in ('SY$MAX_DATE')) THEN
22: RETURN to_date(fnd_profile.value_wnps('SY$MAX_DATE'),'YYYY/MM/DD HH24:MI:SS');
23: ELSIF (V_constant in ('SY$ZERODATE')) THEN
24: RETURN to_date(fnd_profile.value_wnps('SY$ZERODATE'),'YYYY/MM/DD HH24:MI:SS');
25: END IF;
26: end get_date_constant_d;

Line 24: RETURN to_date(fnd_profile.value_wnps('SY$ZERODATE'),'YYYY/MM/DD HH24:MI:SS');

20: RETURN to_date(fnd_profile.value_wnps('SY$MIN_DATE'),'YYYY/MM/DD HH24:MI:SS');
21: ELSIF (V_constant in ('SY$MAX_DATE')) THEN
22: RETURN to_date(fnd_profile.value_wnps('SY$MAX_DATE'),'YYYY/MM/DD HH24:MI:SS');
23: ELSIF (V_constant in ('SY$ZERODATE')) THEN
24: RETURN to_date(fnd_profile.value_wnps('SY$ZERODATE'),'YYYY/MM/DD HH24:MI:SS');
25: END IF;
26: end get_date_constant_d;
27:
28: PROCEDURE check_product_installed (V_constant IN VARCHAR2,