DBA Data[Home] [Help]

APPS.PA_TEAM_TEMPLATES_PUB dependencies on PA_PROJECTS_ALL

Line 45: ,p_project_id IN pa_projects_all.project_id%TYPE

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

Line 46: ,p_project_start_date IN pa_projects_all.start_date%TYPE

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'

Line 49: ,p_project_location_id IN pa_projects_all.location_id%TYPE := NULL

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

Line 51: ,p_project_calendar_id IN pa_projects_all.calendar_id%TYPE := NULL

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

Line 64: ,p_project_id IN pa_projects_all.project_id%TYPE

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

Line 65: ,p_project_start_date IN pa_projects_all.start_date%TYPE

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'

Line 68: ,p_project_location_id IN pa_projects_all.location_id%TYPE := NULL

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

Line 70: ,p_project_calendar_id IN pa_projects_all.calendar_id%TYPE := NULL

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