[Home] [Help]
2345: l_prc_param_ids := STRINGARRAY(57, 58, 59, 60);
2346: l_prc_param_values := STRINGARRAY(l_rate_basis, l_rate_basis_uom, l_list_header_id, l_currency);
2347:
2348: --+
2349: -- Insert Facility Data into FTE_PRC_PARAMETERS
2350: --+
2351: BEGIN
2352: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
2353: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Inserting into FTE_PRC_PARAMETERS');
2349: -- Insert Facility Data into FTE_PRC_PARAMETERS
2350: --+
2351: BEGIN
2352: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
2353: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Inserting into FTE_PRC_PARAMETERS');
2354: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_chart_name ', l_chart_name);
2355: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_rate_basis ', l_rate_basis);
2356: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_rate_basis_uom', l_rate_basis_uom);
2357: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_currency ', l_currency);
2359: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_list_header_id', l_list_header_id);
2360: END IF;
2361:
2362: FORALL m IN 1..l_prc_param_ids.COUNT
2363: INSERT INTO FTE_PRC_PARAMETERS( PARAMETER_INSTANCE_ID,
2364: PARAMETER_ID,
2365: VALUE_FROM,
2366: UOM_CODE,
2367: CURRENCY_CODE,
2369: CREATED_BY,
2370: LAST_UPDATE_DATE,
2371: LAST_UPDATED_BY,
2372: LIST_HEADER_ID)
2373: VALUES( fte_prc_parameters_s.NEXTVAL,
2374: l_prc_param_ids(m),
2375: l_prc_param_values(m),
2376: l_rate_basis_uom,
2377: l_currency,
4227:
4228: --+
4229: -- For Facility Modifiers, store the rate basis and its uom. Each facility rate chart
4230: -- has a unique rate basis and basis uom. These will be used to populate
4231: -- fte_prc_parameters.
4232: --+
4233:
4234: IF (p_chart_type = 'FAC_MODIFIER') THEN
4235: