APPS.HRI_BPL_REC_PIPLN dependencies on HRI_BPL_FAST_FORMULA_UTIL

Line 41: l_formula_input_tab hri_bpl_fast_formula_util.formula_param_type;

37: p_stage_code OUT NOCOPY VARCHAR2,
38: p_event_code OUT NOCOPY VARCHAR2,
39: p_event_seq OUT NOCOPY NUMBER) IS
40:
41: l_formula_input_tab hri_bpl_fast_formula_util.formula_param_type;
42: l_formula_output_tab hri_bpl_fast_formula_util.formula_param_type;
43: l_skip_event VARCHAR2(30);
44:
45: BEGIN

Line 42: l_formula_output_tab hri_bpl_fast_formula_util.formula_param_type;

38: p_event_code OUT NOCOPY VARCHAR2,
39: p_event_seq OUT NOCOPY NUMBER) IS
40:
41: l_formula_input_tab hri_bpl_fast_formula_util.formula_param_type;
42: l_formula_output_tab hri_bpl_fast_formula_util.formula_param_type;
43: l_skip_event VARCHAR2(30);
44:
45: BEGIN
46:

Line 55: hri_bpl_fast_formula_util.run_formula

51: -- Extract outputs
52: BEGIN
53:
54: -- Run formula
55: hri_bpl_fast_formula_util.run_formula
56: (p_formula_id => g_status_formula_id,
57: p_input_tab => l_formula_input_tab,
58: p_output_tab => l_formula_output_tab);
59:

Line 276: l_formula_input_tab hri_bpl_fast_formula_util.formula_param_type;

272: -- termination reason
273: -- -----------------------------------------------------------------------------
274: FUNCTION get_appl_term_type(p_appl_term_rsn IN VARCHAR2) RETURN VARCHAR2 IS
275:
276: l_formula_input_tab hri_bpl_fast_formula_util.formula_param_type;
277: l_formula_output_tab hri_bpl_fast_formula_util.formula_param_type;
278:
279: l_term_type varchar2(10);
280:

Line 277: l_formula_output_tab hri_bpl_fast_formula_util.formula_param_type;

273: -- -----------------------------------------------------------------------------
274: FUNCTION get_appl_term_type(p_appl_term_rsn IN VARCHAR2) RETURN VARCHAR2 IS
275:
276: l_formula_input_tab hri_bpl_fast_formula_util.formula_param_type;
277: l_formula_output_tab hri_bpl_fast_formula_util.formula_param_type;
278:
279: l_term_type varchar2(10);
280:
281: BEGIN

Line 293: hri_bpl_fast_formula_util.run_formula

289: -- Trap exceptions if formula fails or doesn't exist
290: BEGIN
291:
292: -- Run formula
293: hri_bpl_fast_formula_util.run_formula
294: (p_formula_id => g_term_formula_id,
295: p_input_tab => l_formula_input_tab,
296: p_output_tab => l_formula_output_tab);
297:

Line 361: g_status_formula_id := hri_bpl_fast_formula_util.fetch_setup_formula_id

357: g_event_cache('EMPL_APR1').event_seq := 1300;
358: g_event_cache('EMPL_LOW1_END').event_seq := 1400;
359: g_event_cache('EMPL_TERM').event_seq := 1500;
360: g_event_cache('NA_EDW').event_seq := -1;
361: g_status_formula_id := hri_bpl_fast_formula_util.fetch_setup_formula_id
362: (p_formula_name => 'HRI_MAP_REC_APPL_STATUS');
363: g_term_formula_id := hri_bpl_fast_formula_util.fetch_setup_formula_id
364: (p_formula_name => 'HRI_MAP_REC_APPL_TERM_TYPE');
365: g_cache_loaded := FALSE;

Line 363: g_term_formula_id := hri_bpl_fast_formula_util.fetch_setup_formula_id

359: g_event_cache('EMPL_TERM').event_seq := 1500;
360: g_event_cache('NA_EDW').event_seq := -1;
361: g_status_formula_id := hri_bpl_fast_formula_util.fetch_setup_formula_id
362: (p_formula_name => 'HRI_MAP_REC_APPL_STATUS');
363: g_term_formula_id := hri_bpl_fast_formula_util.fetch_setup_formula_id
364: (p_formula_name => 'HRI_MAP_REC_APPL_TERM_TYPE');
365: g_cache_loaded := FALSE;
366:
367: END hri_bpl_rec_pipln;