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_PROJECT_SUBTEAM_PARTIES_PKG dependencies on PA_PROJECT_SUBTEAM_PARTIES

Line 1: PACKAGE BODY pa_project_subteam_parties_pkg AS

1: PACKAGE BODY pa_project_subteam_parties_pkg AS
2: --$Header: PARTSPHB.pls 120.1 2005/08/19 17:01:37 mwasowic noship $
3:
4: PROCEDURE Insert_Row
5: (

Line 8: p_object_type IN pa_project_subteam_parties.object_type%TYPE := FND_API.g_miss_char,

4: PROCEDURE Insert_Row
5: (
6: p_project_subteam_id IN pa_project_subteams.Project_subteam_id%TYPE := FND_API.g_miss_num,
7:
8: p_object_type IN pa_project_subteam_parties.object_type%TYPE := FND_API.g_miss_char,
9:
10: p_object_id IN pa_project_subteam_parties.object_id%TYPE := fnd_api.g_miss_num,
11:
12: p_primary_subteam_flag IN pa_project_subteam_parties.primary_subteam_flag%TYPE := 'Y',

Line 10: p_object_id IN pa_project_subteam_parties.object_id%TYPE := fnd_api.g_miss_num,

6: p_project_subteam_id IN pa_project_subteams.Project_subteam_id%TYPE := FND_API.g_miss_num,
7:
8: p_object_type IN pa_project_subteam_parties.object_type%TYPE := FND_API.g_miss_char,
9:
10: p_object_id IN pa_project_subteam_parties.object_id%TYPE := fnd_api.g_miss_num,
11:
12: p_primary_subteam_flag IN pa_project_subteam_parties.primary_subteam_flag%TYPE := 'Y',
13:
14: x_project_subteam_party_row_id OUT NOCOPY ROWID, --File.Sql.39 bug 4440895

Line 12: p_primary_subteam_flag IN pa_project_subteam_parties.primary_subteam_flag%TYPE := 'Y',

8: p_object_type IN pa_project_subteam_parties.object_type%TYPE := FND_API.g_miss_char,
9:
10: p_object_id IN pa_project_subteam_parties.object_id%TYPE := fnd_api.g_miss_num,
11:
12: p_primary_subteam_flag IN pa_project_subteam_parties.primary_subteam_flag%TYPE := 'Y',
13:
14: x_project_subteam_party_row_id OUT NOCOPY ROWID, --File.Sql.39 bug 4440895
15:
16: x_project_subteam_party_id OUT NOCOPY pa_project_subteam_parties.project_subteam_party_id%TYPE, --File.Sql.39 bug 4440895

Line 16: x_project_subteam_party_id OUT NOCOPY pa_project_subteam_parties.project_subteam_party_id%TYPE, --File.Sql.39 bug 4440895

12: p_primary_subteam_flag IN pa_project_subteam_parties.primary_subteam_flag%TYPE := 'Y',
13:
14: x_project_subteam_party_row_id OUT NOCOPY ROWID, --File.Sql.39 bug 4440895
15:
16: x_project_subteam_party_id OUT NOCOPY pa_project_subteam_parties.project_subteam_party_id%TYPE, --File.Sql.39 bug 4440895
17:
18: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
19:
20: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 27: l_primary_subteam_flag pa_project_subteam_parties.primary_subteam_flag%TYPE;

23: ) IS
24:
25: l_subteam_party_id NUMBER;
26: l_record_version_number NUMBER := 1;
27: l_primary_subteam_flag pa_project_subteam_parties.primary_subteam_flag%TYPE;
28:
29: CURSOR c1 IS
30: SELECT rowid
31: FROM pa_project_subteam_parties

Line 31: FROM pa_project_subteam_parties

27: l_primary_subteam_flag pa_project_subteam_parties.primary_subteam_flag%TYPE;
28:
29: CURSOR c1 IS
30: SELECT rowid
31: FROM pa_project_subteam_parties
32: WHERE project_subteam_party_id = l_subteam_party_id;
33:
34: BEGIN
35:

Line 49: INSERT INTO pa_project_subteam_parties

45: else
46: l_primary_subteam_flag := p_primary_subteam_flag;
47: end if;
48:
49: INSERT INTO pa_project_subteam_parties
50: (project_subteam_party_id,
51: project_subteam_id,
52: record_version_number,
53: object_type,

Line 101: p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE,

97: PROCEDURE Update_Row
98: (
99: p_project_subteam_party_row_id IN ROWID :=NULL,
100:
101: p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE,
102:
103: p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE,
104:
105: -- p_object_type IN varchar2,

Line 109: p_primary_subteam_flag IN pa_project_subteam_parties.primary_subteam_flag%TYPE := 'Y',

105: -- p_object_type IN varchar2,
106:
107: -- p_object_id IN NUMBER := fnd_api.g_miss_num,
108:
109: p_primary_subteam_flag IN pa_project_subteam_parties.primary_subteam_flag%TYPE := 'Y',
110:
111: p_record_version_number IN NUMBER := NULL,
112:
113: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 120: l_primary_subteam_flag pa_project_subteam_parties.primary_subteam_flag%TYPE;

116:
117: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
118: ) IS
119:
120: l_primary_subteam_flag pa_project_subteam_parties.primary_subteam_flag%TYPE;
121: l_row_id ROWID := p_project_subteam_party_row_id;
122: l_record_version_number NUMBER;
123:
124: CURSOR get_row_id IS

Line 126: FROM pa_project_subteam_parties

122: l_record_version_number NUMBER;
123:
124: CURSOR get_row_id IS
125: SELECT rowid
126: FROM pa_project_subteam_parties
127: WHERE project_subteam_party_id = p_project_subteam_party_id;
128:
129:
130: BEGIN

Line 159: UPDATE pa_project_subteam_parties

155: IF p_record_version_number IS NOT NULL then
156: l_record_version_number := p_record_version_number +1;
157: END IF;
158:
159: UPDATE pa_project_subteam_parties
160: SET
161:
162: project_subteam_id = Decode (p_project_subteam_id,fnd_api.g_miss_num,project_subteam_id, p_project_subteam_id),
163:

Line 179: PA_PROJECT_SUBTEAM_PARTIES_PVT.g_error_exists := FND_API.G_TRUE;

175: AND nvl(p_record_version_number, record_version_number) = record_version_number;
176:
177: IF (SQL%NOTFOUND) THEN
178: PA_UTILS.Add_Message ( p_app_short_name => 'PA',p_msg_name => 'PA_XC_RECORD_CHANGED');
179: PA_PROJECT_SUBTEAM_PARTIES_PVT.g_error_exists := FND_API.G_TRUE;
180: END IF;
181:
182: --
183: EXCEPTION

Line 194: ,p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE

190:
191: PROCEDURE Delete_Row
192: (
193: p_project_subteam_party_row_id IN ROWID
194: ,p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE
195: ,p_record_version_number IN NUMBER := NULL
196: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
197: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
198: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 207: DELETE FROM pa_project_subteam_parties

203: BEGIN
204:
205: x_return_status := FND_API.G_RET_STS_SUCCESS;
206:
207: DELETE FROM pa_project_subteam_parties
208: WHERE project_subteam_party_id = p_project_subteam_party_id
209: OR rowid = p_project_subteam_party_row_id
210: AND nvl(p_record_version_number, record_version_number) = record_version_number;
211:

Line 215: PA_PROJECT_SUBTEAM_PARTIES_PVT.g_error_exists := FND_API.G_TRUE;

211:
212: --
213: IF (SQL%NOTFOUND) THEN
214: PA_UTILS.Add_Message ( p_app_short_name => 'PA', p_msg_name => 'PA_XC_RECORD_CHANGED');
215: PA_PROJECT_SUBTEAM_PARTIES_PVT.g_error_exists := FND_API.G_TRUE;
216: x_return_status := FND_API.G_RET_STS_ERROR;
217: END IF;
218: --
219: --

Line 230: END PA_PROJECT_SUBTEAM_PARTIES_PKG;

226: END Delete_Row;
227:
228: --
229: --
230: END PA_PROJECT_SUBTEAM_PARTIES_PKG;