APPS.PON_RESPONSE_IMPORT_PKG dependencies on FND_PROFILE

Line 41: g_fnd_debug CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');

37:
38: g_attr_need_by_date_seq CONSTANT NUMBER := -10;
39:
40: -- These will be used for debugging the code
41: g_fnd_debug CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
42: g_pkg_name CONSTANT VARCHAR2(30) := 'PON_RESPONSE_IMPORT_PKG';
43: g_module_prefix CONSTANT VARCHAR2(50) := 'pon.plsql.' || g_pkg_name || '.';
44:
45:

Line 450: l_date_format := fnd_profile.value('ICX_DATE_FORMAT_MASK');

446: UPDATE pon_bid_attr_values_interface bai
447: SET bai.line_number = g_error_int
448: WHERE bai.batch_id = p_batch_id;
449:
450: l_date_format := fnd_profile.value('ICX_DATE_FORMAT_MASK');
451: l_numeric_characters := fnd_profile.value('ICX_NUMERIC_CHARACTERS');
452: l_decimal_separator_character := SUBSTR(l_numeric_characters, 1, 1);
453: l_grouping_separator_character := SUBSTR(l_numeric_characters, 2, 1);
454:

Line 451: l_numeric_characters := fnd_profile.value('ICX_NUMERIC_CHARACTERS');

447: SET bai.line_number = g_error_int
448: WHERE bai.batch_id = p_batch_id;
449:
450: l_date_format := fnd_profile.value('ICX_DATE_FORMAT_MASK');
451: l_numeric_characters := fnd_profile.value('ICX_NUMERIC_CHARACTERS');
452: l_decimal_separator_character := SUBSTR(l_numeric_characters, 1, 1);
453: l_grouping_separator_character := SUBSTR(l_numeric_characters, 2, 1);
454:
455: -- Attempt the datatype conversions