DBA Data[Home] [Help]

APPS.PA_SEARCH_PUB dependencies on PA_NUM_TBL_TYPE

Line 25: , p_competence_id IN system.pa_num_tbl_type := NULL

21: , p_territory_code IN fnd_territories_vl.territory_code%TYPE := FND_API.G_MISS_CHAR
22: , p_territory_short_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
23: , p_start_date IN DATE := FND_API.G_MISS_DATE
24: , p_end_date IN DATE := FND_API.G_MISS_DATE
25: , p_competence_id IN system.pa_num_tbl_type := NULL
26: , p_competence_alias IN system.pa_varchar2_30_tbl_type := NULL
27: , p_competence_name IN system.pa_varchar2_240_tbl_type := NULL
28: , p_rating IN system.pa_num_tbl_type := NULL
29: , p_mandatory IN system.pa_varchar2_1_tbl_type := NULL

Line 28: , p_rating IN system.pa_num_tbl_type := NULL

24: , p_end_date IN DATE := FND_API.G_MISS_DATE
25: , p_competence_id IN system.pa_num_tbl_type := NULL
26: , p_competence_alias IN system.pa_varchar2_30_tbl_type := NULL
27: , p_competence_name IN system.pa_varchar2_240_tbl_type := NULL
28: , p_rating IN system.pa_num_tbl_type := NULL
29: , p_mandatory IN system.pa_varchar2_1_tbl_type := NULL
30: , p_provisional_availability IN VARCHAR
31: , p_region IN VARCHAR := FND_API.G_MISS_CHAR
32: , p_city IN VARCHAR := FND_API.G_MISS_CHAR