APPS.HXC_TER_UPLOAD_PKG dependencies on HXC_TIME_ENTRY_RULES

Line 49: l_time_entry_rule_id hxc_time_entry_rules.time_entry_rule_id%TYPE;

45: , p_end_date IN VARCHAR2
46: , p_owner IN VARCHAR2
47: , p_custom_mode IN VARCHAR2 ) IS
48:
49: l_time_entry_rule_id hxc_time_entry_rules.time_entry_rule_id%TYPE;
50: l_mapping_id hxc_mappings.mapping_id%TYPE;
51: l_formula_id ff_formulas_f.formula_id%TYPE;
52: l_ovn hxc_deposit_processes.object_version_number%TYPE := NULL;
53: l_owner VARCHAR2(6);

Line 56: l_attribute_category hxc_time_entry_rules.attribute_category%TYPE;

52: l_ovn hxc_deposit_processes.object_version_number%TYPE := NULL;
53: l_owner VARCHAR2(6);
54: l_formula_name Varchar2(150);
55:
56: l_attribute_category hxc_time_entry_rules.attribute_category%TYPE;
57: l_attribute1 hxc_time_entry_rules.attribute1%TYPE;
58: l_attribute2 hxc_time_entry_rules.attribute1%TYPE;
59:
60: FUNCTION get_ff_id ( p_formula_name VARCHAR2 ) RETURN NUMBER IS

Line 57: l_attribute1 hxc_time_entry_rules.attribute1%TYPE;

53: l_owner VARCHAR2(6);
54: l_formula_name Varchar2(150);
55:
56: l_attribute_category hxc_time_entry_rules.attribute_category%TYPE;
57: l_attribute1 hxc_time_entry_rules.attribute1%TYPE;
58: l_attribute2 hxc_time_entry_rules.attribute1%TYPE;
59:
60: FUNCTION get_ff_id ( p_formula_name VARCHAR2 ) RETURN NUMBER IS
61:

Line 58: l_attribute2 hxc_time_entry_rules.attribute1%TYPE;

54: l_formula_name Varchar2(150);
55:
56: l_attribute_category hxc_time_entry_rules.attribute_category%TYPE;
57: l_attribute1 hxc_time_entry_rules.attribute1%TYPE;
58: l_attribute2 hxc_time_entry_rules.attribute1%TYPE;
59:
60: FUNCTION get_ff_id ( p_formula_name VARCHAR2 ) RETURN NUMBER IS
61:
62: CURSOR csr_get_ff_id IS

Line 159: FROM hxc_time_entry_rules

155: , DECODE( NVL(last_updated_by,-1), 1, 'SEED', 'CUSTOM')
156: INTO l_time_entry_rule_id
157: , l_ovn
158: , l_owner
159: FROM hxc_time_entry_rules
160: WHERE name = P_NAME;
161:
162: if g_debug then
163: hr_utility.set_location('gaz', 2);

Line 290: FROM hxc_time_entry_rules

286: FUNCTION get_time_entry_rule_id ( p_time_entry_rule_name VARCHAR2 ) RETURN NUMBER IS
287:
288: CURSOR csr_get_ter_id IS
289: SELECT time_entry_rule_id
290: FROM hxc_time_entry_rules
291: WHERE name = p_time_entry_rule_name;
292:
293: l_time_entry_rule_id hxc_time_entry_rules.time_entry_rule_id%TYPE;
294:

Line 293: l_time_entry_rule_id hxc_time_entry_rules.time_entry_rule_id%TYPE;

289: SELECT time_entry_rule_id
290: FROM hxc_time_entry_rules
291: WHERE name = p_time_entry_rule_name;
292:
293: l_time_entry_rule_id hxc_time_entry_rules.time_entry_rule_id%TYPE;
294:
295: BEGIN
296:
297: OPEN csr_get_ter_id;