1 package per_sg_perwsepi AUTHID CURRENT_USER as
2 /* $Header: pesgsepi.pkh 120.2.12020000.1 2012/06/29 02:23:30 appldev ship $ */
3
4 -- Package variable
5 g_application_id number := 800;
6
7 procedure get_segment_attributes
8 (p_flexfield_segment in fnd_descr_flex_column_usages.application_column_name%type,
9 p_form_prompt out nocopy fnd_descr_flex_col_usage_tl.form_left_prompt%type,
10 p_required_flag out nocopy fnd_descr_flex_column_usages.required_flag%type);
11
12 -- Called from POST-QUERY trigger to obtain all the values
13 -- to display to the user in one hit.
14 procedure get_pddf_lookup_meanings
15 (p_country_code in fnd_territories_vl.territory_code%type,
16 p_permit_type_code in hr_lookups.lookup_code%type,
17 p_permit_category_code in hr_lookups.lookup_code%type,
18 p_nric_colour_code in hr_lookups.lookup_code%type,
19 p_religion_code in hr_lookups.lookup_code%type,
20 p_cpf_category_code in hr_lookups.lookup_code%type,
21 p_race_code in hr_lookups.lookup_code%type,
22 p_community_fund_code in hr_lookups.lookup_code%type,
23 p_ee_er_rate_code in hr_lookups.lookup_code%type,
24 p_payee_id_type_code in hr_lookups.lookup_code%type,
25 p_country out nocopy fnd_territories_vl.territory_short_name%type,
26 p_permit_type out nocopy hr_lookups.meaning%type,
27 p_permit_category out nocopy hr_lookups.meaning%type,
28 p_nric_colour out nocopy hr_lookups.meaning%type,
29 p_religion out nocopy hr_lookups.meaning%type,
30 p_cpf_category out nocopy hr_lookups.meaning%type,
31 p_race out nocopy hr_lookups.meaning%type,
32 p_community_fund out nocopy hr_lookups.meaning%type,
33 p_ee_er_rate out nocopy hr_lookups.meaning%type,
34 p_payee_id_type out nocopy hr_lookups.meaning%type);
35 end per_sg_perwsepi;