APPS.PA_TEAM_TEMPLATES_PKG dependencies on PA_TEAM_TEMPLATES_S

Line 8: ,p_start_date_active IN pa_team_templates.start_date_active%TYPE

4: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5: PROCEDURE Insert_Row
6: (p_team_template_name IN pa_team_templates.team_template_name%TYPE
7: ,p_description IN pa_team_templates.description%TYPE := FND_API.G_MISS_CHAR
8: ,p_start_date_active IN pa_team_templates.start_date_active%TYPE
9: ,p_end_date_active IN pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE
10: ,p_calendar_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
11: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
12: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM

Line 51: SELECT pa_team_templates_s.NEXTVAL

47:
48: x_return_status := FND_API.G_RET_STS_SUCCESS;
49:
50: --Fetch the next sequence number for team template
51: SELECT pa_team_templates_s.NEXTVAL
52: INTO x_team_template_id
53: FROM dual;
54:
55: INSERT INTO pa_team_templates

Line 140: ,p_start_date_active IN pa_team_templates.start_date_active%TYPE := FND_API.G_MISS_DATE

136: (p_team_template_id IN pa_team_templates.team_template_id%TYPE
137: ,p_record_version_number IN pa_team_templates.record_version_number%TYPE
138: ,p_team_template_name IN pa_team_templates.team_template_name%TYPE := FND_API.G_MISS_CHAR
139: ,p_description IN pa_team_templates.description%TYPE := FND_API.G_MISS_CHAR
140: ,p_start_date_active IN pa_team_templates.start_date_active%TYPE := FND_API.G_MISS_DATE
141: ,p_end_date_active IN pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE
142: ,p_calendar_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
143: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
144: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM