eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_NL_PAYFILE_SEPA 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: FUNCTION RAISE_WARNING(p_flag IN VARCHAR2, p_message IN VARCHAR2) return number is

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: FUNCTION RAISE_WARNING(p_flag IN VARCHAR2, p_message IN VARCHAR2) return number is
24: l_status BOOLEAN;

Line 136: p_formula_id ff_formulas_f.formula_id%TYPE;

132: l_inputs ff_exec.inputs_t;
133: l_outputs ff_exec.outputs_t;
134: p_formula_exists BOOLEAN := TRUE;
135: p_formula_cached BOOLEAN := FALSE;
136: p_formula_id ff_formulas_f.formula_id%TYPE;
137: p_formula_name ff_formulas_f.formula_name%TYPE;
138: l_address_return VARCHAR2(100);
139: --
140:

Line 137: p_formula_name ff_formulas_f.formula_name%TYPE;

133: l_outputs ff_exec.outputs_t;
134: p_formula_exists BOOLEAN := TRUE;
135: p_formula_cached BOOLEAN := FALSE;
136: p_formula_id ff_formulas_f.formula_id%TYPE;
137: p_formula_name ff_formulas_f.formula_name%TYPE;
138: l_address_return VARCHAR2(100);
139: --
140:
141: FUNCTION get_payee_address(p_payee_id IN NUMBER

Line 443: FROM ff_formulas_f ff

439: ) IS
440: --
441: CURSOR c_compiled_formula_exist IS
442: SELECT 'Y'
443: FROM ff_formulas_f ff
444: ,ff_compiled_info_f ffci
445: WHERE ff.formula_id = ffci.formula_id
446: AND ff.effective_start_date = ffci.effective_start_date
447: AND ff.effective_end_date = ffci.effective_end_date

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

449: AND ff.business_group_id = p_business_group_id
450: AND p_effective_date BETWEEN ff.effective_start_date
451: AND ff.effective_end_date;
452: --
453: CURSOR c_get_formula(p_formula_name ff_formulas_f.formula_name%TYPE
454: ,p_effective_date DATE) IS
455: SELECT ff.formula_id
456: FROM ff_formulas_f ff
457: WHERE ff.formula_name = p_formula_name

Line 456: FROM ff_formulas_f ff

452: --
453: CURSOR c_get_formula(p_formula_name ff_formulas_f.formula_name%TYPE
454: ,p_effective_date DATE) IS
455: SELECT ff.formula_id
456: FROM ff_formulas_f ff
457: WHERE ff.formula_name = p_formula_name
458: AND ff.business_group_id = p_business_group_id
459: AND p_effective_date BETWEEN ff.effective_start_date
460: AND ff.effective_end_date;