DBA Data[Home] [Help]

APPS.PAY_JP_CREATE_CMA_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 7: c_cma_ele_name constant pay_element_types_f.element_name%TYPE := 'SAL_CMA_PROC';

3: --
4: -- Constants
5: --
6: c_package constant varchar2(31) := 'pay_jp_create_cma_pkg.';
7: c_cma_ele_name constant pay_element_types_f.element_name%TYPE := 'SAL_CMA_PROC';
8: c_itax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_ITX_INFO';
9: c_non_res_iv_name constant pay_input_values_f.name%TYPE := 'NRES_FLAG';
10: -- need to set irregular def val except hr_api.g_varchar2 (entry_value_tbl exclude setting default value of parameter)
11: c_def_val varchar2(1000) := to_char(hr_api.g_number);

Line 8: c_itax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_ITX_INFO';

4: -- Constants
5: --
6: c_package constant varchar2(31) := 'pay_jp_create_cma_pkg.';
7: c_cma_ele_name constant pay_element_types_f.element_name%TYPE := 'SAL_CMA_PROC';
8: c_itax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_ITX_INFO';
9: c_non_res_iv_name constant pay_input_values_f.name%TYPE := 'NRES_FLAG';
10: -- need to set irregular def val except hr_api.g_varchar2 (entry_value_tbl exclude setting default value of parameter)
11: c_def_val varchar2(1000) := to_char(hr_api.g_number);
12: c_value_if_null_tbl constant pay_jp_bee_utility_pkg.t_varchar2_tbl

Line 15: c_non_res_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_NRES_INFO';

11: c_def_val varchar2(1000) := to_char(hr_api.g_number);
12: c_value_if_null_tbl constant pay_jp_bee_utility_pkg.t_varchar2_tbl
13: := pay_jp_bee_utility_pkg.entry_value_tbl(c_def_val,c_def_val,c_def_val,c_def_val,c_def_val,c_def_val,c_def_val,c_def_val,c_def_val,c_def_val,c_def_val,c_def_val,c_def_val,c_def_val,c_def_val);
14: c_non_taxable_GlbVal_name constant varchar2(80) := 'G_SAL_CMA_PUBLIC_TRANSPORT_NTXBL_ERN_MAX';
15: c_non_res_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_NRES_INFO';
16: c_non_res_date_iv_name constant pay_input_values_f.name%TYPE := 'NRES_START_DATE';
17: c_res_date_iv_name constant pay_input_values_f.name%TYPE := 'PROJECTED_RES_DATE';
18: c_elm pay_element_types_f.element_name%TYPE;
19: c_elm_tl pay_element_types_f_tl.element_name%TYPE;

Line 18: c_elm pay_element_types_f.element_name%TYPE;

14: c_non_taxable_GlbVal_name constant varchar2(80) := 'G_SAL_CMA_PUBLIC_TRANSPORT_NTXBL_ERN_MAX';
15: c_non_res_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_NRES_INFO';
16: c_non_res_date_iv_name constant pay_input_values_f.name%TYPE := 'NRES_START_DATE';
17: c_res_date_iv_name constant pay_input_values_f.name%TYPE := 'PROJECTED_RES_DATE';
18: c_elm pay_element_types_f.element_name%TYPE;
19: c_elm_tl pay_element_types_f_tl.element_name%TYPE;
20: c_elm_tl_max number := 30;
21: --
22: -- Global Variables

Line 19: c_elm_tl pay_element_types_f_tl.element_name%TYPE;

15: c_non_res_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_NRES_INFO';
16: c_non_res_date_iv_name constant pay_input_values_f.name%TYPE := 'NRES_START_DATE';
17: c_res_date_iv_name constant pay_input_values_f.name%TYPE := 'PROJECTED_RES_DATE';
18: c_elm pay_element_types_f.element_name%TYPE;
19: c_elm_tl pay_element_types_f_tl.element_name%TYPE;
20: c_elm_tl_max number := 30;
21: --
22: -- Global Variables
23: --

Line 59: o_elm_tl pay_element_types_f_tl.element_name%type;

55: p_elm_name in varchar2)
56: return varchar2
57: is
58: --
59: o_elm_tl pay_element_types_f_tl.element_name%type;
60: --
61: -- support only session lang based on case forms and srs session lang is same
62: cursor csr_elm_tl
63: is

Line 66: from pay_element_types_f pet,

62: cursor csr_elm_tl
63: is
64: select /*+ ORDERD */
65: pett.element_name
66: from pay_element_types_f pet,
67: pay_element_types_f_tl pett
68: where pet.element_name = p_elm_name
69: and pet.legislation_code = 'JP'
70: and pett.element_type_id = pet.element_type_id

Line 67: pay_element_types_f_tl pett

63: is
64: select /*+ ORDERD */
65: pett.element_name
66: from pay_element_types_f pet,
67: pay_element_types_f_tl pett
68: where pet.element_name = p_elm_name
69: and pet.legislation_code = 'JP'
70: and pett.element_type_id = pet.element_type_id
71: and pett.language = userenv('LANG');