APPS.FV_FACTS_GL_PKG_EXT dependencies on FV_SYSTEM_PARAMETERS

Line 64: --* Tables Used : fv_system_parameters SELECT *--

60: --* : fnd_log.level_unexpected *--
61: --* Called from : process_parameters *--
62: --* Calls : fv_utility.debug_mesg *--
63: --* : fv_utility.log_mesg *--
64: --* Tables Used : fv_system_parameters SELECT *--
65: --* Logic : Select Vendor Attribute Column and Customer Attribute Column *--
66: --* : from fv_system_parameters *--
67: --****************************************************************************************--
68: PROCEDURE get_fed_system_parameters

Line 66: --* : from fv_system_parameters *--

62: --* Calls : fv_utility.debug_mesg *--
63: --* : fv_utility.log_mesg *--
64: --* Tables Used : fv_system_parameters SELECT *--
65: --* Logic : Select Vendor Attribute Column and Customer Attribute Column *--
66: --* : from fv_system_parameters *--
67: --****************************************************************************************--
68: PROCEDURE get_fed_system_parameters
69: (
70: p_vendor_attribute OUT NOCOPY VARCHAR2,

Line 93: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'SELECT from fv_system_parameters');

89: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '****************************');
90: END IF;
91:
92: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
93: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'SELECT from fv_system_parameters');
94: END IF;
95: SELECT fsp.factsi_customer_attribute,
96: fsp.factsi_vendor_attribute
97: INTO p_customer_attribute,

Line 99: FROM fv_system_parameters fsp;

95: SELECT fsp.factsi_customer_attribute,
96: fsp.factsi_vendor_attribute
97: INTO p_customer_attribute,
98: p_vendor_attribute
99: FROM fv_system_parameters fsp;
100:
101: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
102: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '*****OUTPUT PARAMETERS******');
103: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_attribute = '||p_vendor_attribute);

Line 179: l_customer_attribute fv_system_parameters.factsi_customer_attribute%TYPE;

175: )
176: IS
177: l_module_name VARCHAR2(200);
178: l_location VARCHAR2(200);
179: l_customer_attribute fv_system_parameters.factsi_customer_attribute%TYPE;
180: l_vendor_attribute fv_system_parameters.factsi_vendor_attribute%TYPE;
181: l_period_year gl_period_statuses.period_year%TYPE;
182: l_select_stmt VARCHAR2(1024);
183: l_cursor_id INTEGER;

Line 180: l_vendor_attribute fv_system_parameters.factsi_vendor_attribute%TYPE;

176: IS
177: l_module_name VARCHAR2(200);
178: l_location VARCHAR2(200);
179: l_customer_attribute fv_system_parameters.factsi_customer_attribute%TYPE;
180: l_vendor_attribute fv_system_parameters.factsi_vendor_attribute%TYPE;
181: l_period_year gl_period_statuses.period_year%TYPE;
182: l_select_stmt VARCHAR2(1024);
183: l_cursor_id INTEGER;
184: l_ignore INTEGER;