eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_TEAM_TEMPLATES_PUB dependencies on PA_PROJECTS_ALL

Line 7: ,p_project_id IN pa_projects_all.project_id%TYPE

3: --
4: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5: PROCEDURE Execute_Apply_Team_Template
6: (p_team_template_id IN pa_team_templates.team_template_id%TYPE
7: ,p_project_id IN pa_projects_all.project_id%TYPE
8: ,p_project_start_date IN pa_projects_all.start_date%TYPE
9: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
10: ,p_use_project_location IN VARCHAR2 := 'N'
11: ,p_project_location_id IN pa_projects_all.location_id%TYPE := NULL

Line 8: ,p_project_start_date IN pa_projects_all.start_date%TYPE

4: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5: PROCEDURE Execute_Apply_Team_Template
6: (p_team_template_id IN pa_team_templates.team_template_id%TYPE
7: ,p_project_id IN pa_projects_all.project_id%TYPE
8: ,p_project_start_date IN pa_projects_all.start_date%TYPE
9: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
10: ,p_use_project_location IN VARCHAR2 := 'N'
11: ,p_project_location_id IN pa_projects_all.location_id%TYPE := NULL
12: ,p_use_project_calendar IN VARCHAR2 := 'N'

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

7: ,p_project_id IN pa_projects_all.project_id%TYPE
8: ,p_project_start_date IN pa_projects_all.start_date%TYPE
9: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
10: ,p_use_project_location IN VARCHAR2 := 'N'
11: ,p_project_location_id IN pa_projects_all.location_id%TYPE := NULL
12: ,p_use_project_calendar IN VARCHAR2 := 'N'
13: ,p_project_calendar_id IN pa_projects_all.calendar_id%TYPE := NULL
14: ,p_apply IN VARCHAR2 := 'Y'
15: ,p_api_version IN NUMBER := 1.0

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

9: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
10: ,p_use_project_location IN VARCHAR2 := 'N'
11: ,p_project_location_id IN pa_projects_all.location_id%TYPE := NULL
12: ,p_use_project_calendar IN VARCHAR2 := 'N'
13: ,p_project_calendar_id IN pa_projects_all.calendar_id%TYPE := NULL
14: ,p_apply IN VARCHAR2 := 'Y'
15: ,p_api_version IN NUMBER := 1.0
16: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
17: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 111: ,p_project_id IN pa_projects_all.project_id%TYPE

107: END Execute_Apply_Team_Template;
108:
109: PROCEDURE Apply_Team_Template
110: (p_team_template_id_tbl IN team_template_id_tbl
111: ,p_project_id IN pa_projects_all.project_id%TYPE
112: ,p_project_start_date IN pa_projects_all.start_date%TYPE
113: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
114: ,p_use_project_location IN VARCHAR2 := 'N'
115: ,p_project_location_id IN pa_projects_all.location_id%TYPE := NULL

Line 112: ,p_project_start_date IN pa_projects_all.start_date%TYPE

108:
109: PROCEDURE Apply_Team_Template
110: (p_team_template_id_tbl IN team_template_id_tbl
111: ,p_project_id IN pa_projects_all.project_id%TYPE
112: ,p_project_start_date IN pa_projects_all.start_date%TYPE
113: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
114: ,p_use_project_location IN VARCHAR2 := 'N'
115: ,p_project_location_id IN pa_projects_all.location_id%TYPE := NULL
116: ,p_use_project_calendar IN VARCHAR2 := 'N'

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

111: ,p_project_id IN pa_projects_all.project_id%TYPE
112: ,p_project_start_date IN pa_projects_all.start_date%TYPE
113: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
114: ,p_use_project_location IN VARCHAR2 := 'N'
115: ,p_project_location_id IN pa_projects_all.location_id%TYPE := NULL
116: ,p_use_project_calendar IN VARCHAR2 := 'N'
117: ,p_project_calendar_id IN pa_projects_all.calendar_id%TYPE := NULL
118: ,p_api_version IN NUMBER := 1.0
119: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

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

113: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
114: ,p_use_project_location IN VARCHAR2 := 'N'
115: ,p_project_location_id IN pa_projects_all.location_id%TYPE := NULL
116: ,p_use_project_calendar IN VARCHAR2 := 'N'
117: ,p_project_calendar_id IN pa_projects_all.calendar_id%TYPE := NULL
118: ,p_api_version IN NUMBER := 1.0
119: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
120: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
121: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE

Line 130: l_project_calendar_id pa_projects_all.calendar_id%TYPE;

126: IS
127:
128: l_msg_index_out NUMBER;
129:
130: l_project_calendar_id pa_projects_all.calendar_id%TYPE;
131: l_project_location_id pa_projects_all.location_id%TYPE;
132: l_unassigned_time_proj VARCHAR2(1);
133: l_admin_proj VARCHAR2(1);
134:

Line 131: l_project_location_id pa_projects_all.location_id%TYPE;

127:
128: l_msg_index_out NUMBER;
129:
130: l_project_calendar_id pa_projects_all.calendar_id%TYPE;
131: l_project_location_id pa_projects_all.location_id%TYPE;
132: l_unassigned_time_proj VARCHAR2(1);
133: l_admin_proj VARCHAR2(1);
134:
135: -- cursor to get location and calendar for validation

Line 138: FROM pa_projects_all

134:
135: -- cursor to get location and calendar for validation
136: CURSOR get_project_location_and_cal IS
137: SELECT calendar_id, location_id
138: FROM pa_projects_all
139: WHERE project_id = p_project_id;
140:
141: BEGIN
142: