[Home] [Help]
19:
20:
21:
22: -- Bug 12993528\
23: -- Created this following pay_paywsqee_pkg.GET_INPUT_VALUE_DETAILS
24: -- We also pick up the OTL Info type DFF sequence for the input values
25: -- and store that.
26:
27: procedure GET_INPUT_VALUE_DETAILS (
1726: -- Get input values details for this element
1727: HXT_UTIL.DEBUG('Getting input values for element '||to_char(p_values_rec.element_type_id)||' date '||fnd_date.date_to_chardate(p_values_rec.date_worked)); --FORMS60 --HXT115
1728:
1729: -- Bug 12993528
1730: -- Replaced the pay_paywsqee_pkg call with our own new procedure.
1731: -- Added new params otl_sequence for each of the 15 input values.
1732:
1733: GET_INPUT_VALUE_DETAILS(p_values_rec.element_type_id,
1734: p_values_rec.date_worked,
2178: if g_debug then
2179: hr_utility.set_location('dtl_to_BEE',200);
2180: end if;
2181: -- Get next sequence number
2182: -- l_batch_sequence := pay_paywsqee_pkg.next_batch_sequence(p_values_rec.batch_id);
2183: if g_debug then
2184: hr_utility.set_location('dtl_to_BEE',210);
2185: end if;
2186: HXT_UTIL.DEBUG('batch_sequence = '||to_char(p_batch_sequence)); --HXT115
2473: ELSE
2474: we_have_lines := FALSE;
2475: END IF;
2476: END IF;
2477: l_batch_sequence := pay_paywsqee_pkg.next_batch_sequence(l_values_rec.batch_id);
2478: WHILE we_have_lines AND p_sum_retcode = 0 LOOP
2479: dtl_to_BEE(l_values_rec, p_sum_retcode,l_batch_sequence);
2480: --
2481: -- If profile value set to 'Y', then we're sending sum of hours only