DBA Data[Home] [Help]

APPS.PA_SEARCH_PUB dependencies on FND_TERRITORIES_VL

Line 21: , p_territory_code IN fnd_territories_vl.territory_code%TYPE := FND_API.G_MISS_CHAR

17: , p_org_hierarchy_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
18: , p_organization_id IN hr_organization_units.organization_id%TYPE := FND_API.G_MISS_NUM
19: , p_organization_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
20: , p_employees_only IN VARCHAR2 := FND_API.G_MISS_CHAR
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

Line 22: , p_territory_short_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR

18: , p_organization_id IN hr_organization_units.organization_id%TYPE := FND_API.G_MISS_NUM
19: , p_organization_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
20: , p_employees_only IN VARCHAR2 := FND_API.G_MISS_CHAR
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