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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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);
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;
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;
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;
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;