41: g_team_template_id_tbl team_template_id_tbl;
42:
43: PROCEDURE Execute_Apply_Team_Template
44: (p_team_template_id IN pa_team_templates.team_template_id%TYPE
45: ,p_project_id IN pa_projects_all.project_id%TYPE
46: ,p_project_start_date IN pa_projects_all.start_date%TYPE
47: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
48: ,p_use_project_location IN VARCHAR2 := 'N'
49: ,p_project_location_id IN pa_projects_all.location_id%TYPE := NULL
42:
43: PROCEDURE Execute_Apply_Team_Template
44: (p_team_template_id IN pa_team_templates.team_template_id%TYPE
45: ,p_project_id IN pa_projects_all.project_id%TYPE
46: ,p_project_start_date IN pa_projects_all.start_date%TYPE
47: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
48: ,p_use_project_location IN VARCHAR2 := 'N'
49: ,p_project_location_id IN pa_projects_all.location_id%TYPE := NULL
50: ,p_use_project_calendar IN VARCHAR2 := 'N'
45: ,p_project_id IN pa_projects_all.project_id%TYPE
46: ,p_project_start_date IN pa_projects_all.start_date%TYPE
47: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
48: ,p_use_project_location IN VARCHAR2 := 'N'
49: ,p_project_location_id IN pa_projects_all.location_id%TYPE := NULL
50: ,p_use_project_calendar IN VARCHAR2 := 'N'
51: ,p_project_calendar_id IN pa_projects_all.calendar_id%TYPE := NULL
52: ,p_apply IN VARCHAR2 := 'Y'
53: ,p_api_version IN NUMBER := 1.0
47: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
48: ,p_use_project_location IN VARCHAR2 := 'N'
49: ,p_project_location_id IN pa_projects_all.location_id%TYPE := NULL
50: ,p_use_project_calendar IN VARCHAR2 := 'N'
51: ,p_project_calendar_id IN pa_projects_all.calendar_id%TYPE := NULL
52: ,p_apply IN VARCHAR2 := 'Y'
53: ,p_api_version IN NUMBER := 1.0
54: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
55: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
60: );
61:
62: PROCEDURE Apply_Team_Template
63: (p_team_template_id_tbl IN team_template_id_tbl
64: ,p_project_id IN pa_projects_all.project_id%TYPE
65: ,p_project_start_date IN pa_projects_all.start_date%TYPE
66: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
67: ,p_use_project_location IN VARCHAR2 := 'N'
68: ,p_project_location_id IN pa_projects_all.location_id%TYPE := NULL
61:
62: PROCEDURE Apply_Team_Template
63: (p_team_template_id_tbl IN team_template_id_tbl
64: ,p_project_id IN pa_projects_all.project_id%TYPE
65: ,p_project_start_date IN pa_projects_all.start_date%TYPE
66: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
67: ,p_use_project_location IN VARCHAR2 := 'N'
68: ,p_project_location_id IN pa_projects_all.location_id%TYPE := NULL
69: ,p_use_project_calendar IN VARCHAR2 := 'N'
64: ,p_project_id IN pa_projects_all.project_id%TYPE
65: ,p_project_start_date IN pa_projects_all.start_date%TYPE
66: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
67: ,p_use_project_location IN VARCHAR2 := 'N'
68: ,p_project_location_id IN pa_projects_all.location_id%TYPE := NULL
69: ,p_use_project_calendar IN VARCHAR2 := 'N'
70: ,p_project_calendar_id IN pa_projects_all.calendar_id%TYPE := NULL
71: ,p_api_version IN NUMBER := 1.0
72: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
66: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
67: ,p_use_project_location IN VARCHAR2 := 'N'
68: ,p_project_location_id IN pa_projects_all.location_id%TYPE := NULL
69: ,p_use_project_calendar IN VARCHAR2 := 'N'
70: ,p_project_calendar_id IN pa_projects_all.calendar_id%TYPE := NULL
71: ,p_api_version IN NUMBER := 1.0
72: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
73: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
74: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE