DBA Data[Home] [Help]

APPS.PV_PARTNER_ATTR_LOAD_PUB dependencies on FND_PROFILE

Line 95: select fnd_profile.value('ICX_DATE_FORMAT_MASK') into l_date_format from dual;

91: where attribute_id = l_attribute_id;
92:
93: if (l_display_style = 'DATE') then
94: begin
95: select fnd_profile.value('ICX_DATE_FORMAT_MASK') into l_date_format from dual;
96: l_target_date := to_date(l_attr_value_table(1).attr_value,l_date_format);
97: exception
98: when others then
99: l_target_date := null;

Line 1759: SELECT nvl(fnd_profile.value(cv_profile_name),0) from dual;

1755:
1756:
1757: -- Get the value of Profile PV_IMPORT_COMMIT_SIZE.
1758: CURSOR l_get_commit_size_csr(cv_profile_name IN VARCHAR2) IS
1759: SELECT nvl(fnd_profile.value(cv_profile_name),0) from dual;
1760:
1761: CURSOR l_get_party_id(cv_orig_system IN VARCHAR2, cv_orig_system_ref IN VARCHAR2) IS
1762: SELECT
1763: HZ_PARTIES.PARTY_ID

Line 1831: l_prof := fnd_profile.value('HZ_EXECUTE_API_CALLOUTS');

1827:
1828: BEGIN
1829:
1830: BEGIN
1831: l_prof := fnd_profile.value('HZ_EXECUTE_API_CALLOUTS');
1832: if l_prof <> 'N' then
1833: fnd_profile.put('HZ_EXECUTE_API_CALLOUTS','N');
1834: end if;
1835:

Line 1833: fnd_profile.put('HZ_EXECUTE_API_CALLOUTS','N');

1829:
1830: BEGIN
1831: l_prof := fnd_profile.value('HZ_EXECUTE_API_CALLOUTS');
1832: if l_prof <> 'N' then
1833: fnd_profile.put('HZ_EXECUTE_API_CALLOUTS','N');
1834: end if;
1835:
1836: IF p_mode is null then
1837: l_running_mode := 'EVALUATION';

Line 2070: fnd_profile.put('HZ_EXECUTE_API_CALLOUTS',l_prof);

2066: --dbms_output.put_line('No partner data has been passed');
2067: end if;
2068:
2069: if l_prof <> 'N' then
2070: fnd_profile.put('HZ_EXECUTE_API_CALLOUTS',l_prof);
2071: end if;
2072:
2073: x_file_name := l_out_dir || '/' || l_file_name;
2074: --dbms_output.put_line('output file name ' || x_file_name);