APPS.PA_SEARCH_GLOB dependencies on PER_COMPETENCES

Line 67: ,competence_name per_competences.name%TYPE DEFAULT FND_API.G_MISS_CHAR

63:
64:
65: TYPE Competence_Criteria_Rec_Type IS
66: RECORD ( competence_id NUMBER DEFAULT FND_API.G_MISS_NUM
67: ,competence_name per_competences.name%TYPE DEFAULT FND_API.G_MISS_CHAR
68: , competence_alias per_competences.competence_alias%TYPE DEFAULT FND_API.G_MISS_CHAR
69: , rating_level NUMBER DEFAULT FND_API.G_MISS_NUM
70: , mandatory_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR
71: );

Line 68: , competence_alias per_competences.competence_alias%TYPE DEFAULT FND_API.G_MISS_CHAR

64:
65: TYPE Competence_Criteria_Rec_Type IS
66: RECORD ( competence_id NUMBER DEFAULT FND_API.G_MISS_NUM
67: ,competence_name per_competences.name%TYPE DEFAULT FND_API.G_MISS_CHAR
68: , competence_alias per_competences.competence_alias%TYPE DEFAULT FND_API.G_MISS_CHAR
69: , rating_level NUMBER DEFAULT FND_API.G_MISS_NUM
70: , mandatory_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR
71: );
72:

Line 84: TYPE Competence_Name_Array IS TABLE OF per_competences.name%TYPE INDEX BY BINARY_INTEGER;

80: g_competence_criteria Competence_Criteria_Tbl_Type;
81:
82: TYPE Competence_Id_Array IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
83:
84: TYPE Competence_Name_Array IS TABLE OF per_competences.name%TYPE INDEX BY BINARY_INTEGER;
85:
86: TYPE Competence_Alias_Array IS TABLE OF per_competences.competence_alias%TYPE INDEX BY BINARY_INTEGER;
87:
88: TYPE Competence_Rating_Array IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 86: TYPE Competence_Alias_Array IS TABLE OF per_competences.competence_alias%TYPE INDEX BY BINARY_INTEGER;

82: TYPE Competence_Id_Array IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
83:
84: TYPE Competence_Name_Array IS TABLE OF per_competences.name%TYPE INDEX BY BINARY_INTEGER;
85:
86: TYPE Competence_Alias_Array IS TABLE OF per_competences.competence_alias%TYPE INDEX BY BINARY_INTEGER;
87:
88: TYPE Competence_Rating_Array IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
89:
90: TYPE Competence_Mandatory_Array IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;