APPS.PAY_NL_PAYFILE dependencies on FF_FORMULAS_F

Line 8: g_payee_details_formula_id ff_formulas_f.formula_id%TYPE;

4: -- Global Variables
5: hr_formula_error EXCEPTION;
6: g_payee_details_formula_exists BOOLEAN := TRUE;
7: g_payee_details_formula_cached BOOLEAN := FALSE;
8: g_payee_details_formula_id ff_formulas_f.formula_id%TYPE;
9: g_payee_details_formula_name ff_formulas_f.formula_name%TYPE;
10: g_trans_desc_formula_exists BOOLEAN := TRUE;
11: g_trans_desc_formula_cached BOOLEAN := FALSE;
12: g_trans_desc_formula_id ff_formulas_f.formula_id%TYPE;

Line 9: g_payee_details_formula_name ff_formulas_f.formula_name%TYPE;

5: hr_formula_error EXCEPTION;
6: g_payee_details_formula_exists BOOLEAN := TRUE;
7: g_payee_details_formula_cached BOOLEAN := FALSE;
8: g_payee_details_formula_id ff_formulas_f.formula_id%TYPE;
9: g_payee_details_formula_name ff_formulas_f.formula_name%TYPE;
10: g_trans_desc_formula_exists BOOLEAN := TRUE;
11: g_trans_desc_formula_cached BOOLEAN := FALSE;
12: g_trans_desc_formula_id ff_formulas_f.formula_id%TYPE;
13: g_trans_desc_formula_name ff_formulas_f.formula_name%TYPE;

Line 12: g_trans_desc_formula_id ff_formulas_f.formula_id%TYPE;

8: g_payee_details_formula_id ff_formulas_f.formula_id%TYPE;
9: g_payee_details_formula_name ff_formulas_f.formula_name%TYPE;
10: g_trans_desc_formula_exists BOOLEAN := TRUE;
11: g_trans_desc_formula_cached BOOLEAN := FALSE;
12: g_trans_desc_formula_id ff_formulas_f.formula_id%TYPE;
13: g_trans_desc_formula_name ff_formulas_f.formula_name%TYPE;
14: ------------------------------------------------------------------------------
15: -- Global Variables for over riding Oraganization Name
16: ------------------------------------------------------------------------------

Line 13: g_trans_desc_formula_name ff_formulas_f.formula_name%TYPE;

9: g_payee_details_formula_name ff_formulas_f.formula_name%TYPE;
10: g_trans_desc_formula_exists BOOLEAN := TRUE;
11: g_trans_desc_formula_cached BOOLEAN := FALSE;
12: g_trans_desc_formula_id ff_formulas_f.formula_id%TYPE;
13: g_trans_desc_formula_name ff_formulas_f.formula_name%TYPE;
14: ------------------------------------------------------------------------------
15: -- Global Variables for over riding Oraganization Name
16: ------------------------------------------------------------------------------
17: g_org_details_formula_exists BOOLEAN := TRUE;

Line 19: g_org_details_formula_id ff_formulas_f.formula_id%TYPE;

15: -- Global Variables for over riding Oraganization Name
16: ------------------------------------------------------------------------------
17: g_org_details_formula_exists BOOLEAN := TRUE;
18: g_org_details_formula_cached BOOLEAN := FALSE;
19: g_org_details_formula_id ff_formulas_f.formula_id%TYPE;
20: g_org_details_formula_name ff_formulas_f.formula_name%TYPE;
21: -----------------------------------------------------------------------------
22:
23:

Line 20: g_org_details_formula_name ff_formulas_f.formula_name%TYPE;

16: ------------------------------------------------------------------------------
17: g_org_details_formula_exists BOOLEAN := TRUE;
18: g_org_details_formula_cached BOOLEAN := FALSE;
19: g_org_details_formula_id ff_formulas_f.formula_id%TYPE;
20: g_org_details_formula_name ff_formulas_f.formula_name%TYPE;
21: -----------------------------------------------------------------------------
22:
23:
24: FUNCTION get_payee_details(p_assignment_id IN NUMBER

Line 60: p_formula_id ff_formulas_f.formula_id%TYPE;

56: l_inputs ff_exec.inputs_t;
57: l_outputs ff_exec.outputs_t;
58: p_formula_exists BOOLEAN := TRUE;
59: p_formula_cached BOOLEAN := FALSE;
60: p_formula_id ff_formulas_f.formula_id%TYPE;
61: p_formula_name ff_formulas_f.formula_name%TYPE;
62: --
63: BEGIN
64: --

Line 61: p_formula_name ff_formulas_f.formula_name%TYPE;

57: l_outputs ff_exec.outputs_t;
58: p_formula_exists BOOLEAN := TRUE;
59: p_formula_cached BOOLEAN := FALSE;
60: p_formula_id ff_formulas_f.formula_id%TYPE;
61: p_formula_name ff_formulas_f.formula_name%TYPE;
62: --
63: BEGIN
64: --
65: -- To be removed.

Line 295: p_formula_id ff_formulas_f.formula_id%TYPE;

291: l_inputs ff_exec.inputs_t;
292: l_outputs ff_exec.outputs_t;
293: p_formula_exists BOOLEAN := TRUE;
294: p_formula_cached BOOLEAN := FALSE;
295: p_formula_id ff_formulas_f.formula_id%TYPE;
296: p_formula_name ff_formulas_f.formula_name%TYPE;
297: BEGIN
298: g_trans_desc_formula_name := 'NL_TRANSACTION_DESCRIPTION';
299: IF g_trans_desc_formula_exists = TRUE THEN

Line 296: p_formula_name ff_formulas_f.formula_name%TYPE;

292: l_outputs ff_exec.outputs_t;
293: p_formula_exists BOOLEAN := TRUE;
294: p_formula_cached BOOLEAN := FALSE;
295: p_formula_id ff_formulas_f.formula_id%TYPE;
296: p_formula_name ff_formulas_f.formula_name%TYPE;
297: BEGIN
298: g_trans_desc_formula_name := 'NL_TRANSACTION_DESCRIPTION';
299: IF g_trans_desc_formula_exists = TRUE THEN
300: IF g_trans_desc_formula_cached = FALSE THEN

Line 351: FROM ff_formulas_f ff

347: ) IS
348: --
349: CURSOR c_compiled_formula_exist IS
350: SELECT 'Y'
351: FROM ff_formulas_f ff
352: ,ff_compiled_info_f ffci
353: WHERE ff.formula_id = ffci.formula_id
354: AND ff.effective_start_date = ffci.effective_start_date
355: AND ff.effective_end_date = ffci.effective_end_date

Line 361: CURSOR c_get_formula(p_formula_name ff_formulas_f.formula_name%TYPE

357: AND ff.business_group_id = p_business_group_id
358: AND p_effective_date BETWEEN ff.effective_start_date
359: AND ff.effective_end_date;
360: --
361: CURSOR c_get_formula(p_formula_name ff_formulas_f.formula_name%TYPE
362: ,p_effective_date DATE) IS
363: SELECT ff.formula_id
364: FROM ff_formulas_f ff
365: WHERE ff.formula_name = p_formula_name

Line 364: FROM ff_formulas_f ff

360: --
361: CURSOR c_get_formula(p_formula_name ff_formulas_f.formula_name%TYPE
362: ,p_effective_date DATE) IS
363: SELECT ff.formula_id
364: FROM ff_formulas_f ff
365: WHERE ff.formula_name = p_formula_name
366: AND ff.business_group_id = p_business_group_id
367: AND p_effective_date BETWEEN ff.effective_start_date
368: AND ff.effective_end_date;