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_PROJECTS_MAINT_UTILS dependencies on PA_PROBABILITY_MEMBERS

Line 222: -- p_probability_member_id IN pa_probability_members.probability_member_id%TYPE Required

218: -- API name : check_probability_code_or_id
219: -- Type : Public
220: -- Pre-reqs : None.
221: -- Parameters :
222: -- p_probability_member_id IN pa_probability_members.probability_member_id%TYPE Required
223: -- p_probability_percentage IN pa_probability_members.probability_percentage%TYPE Required
224: -- p_project_type IN pa_projects_all.project_type%TYPE
225: -- p_probability_list_id IN pa_probability_lists.probability_list_id%TYPE
226: -- p_check_id_flag IN VARCHAR2 Required

Line 223: -- p_probability_percentage IN pa_probability_members.probability_percentage%TYPE Required

219: -- Type : Public
220: -- Pre-reqs : None.
221: -- Parameters :
222: -- p_probability_member_id IN pa_probability_members.probability_member_id%TYPE Required
223: -- p_probability_percentage IN pa_probability_members.probability_percentage%TYPE Required
224: -- p_project_type IN pa_projects_all.project_type%TYPE
225: -- p_probability_list_id IN pa_probability_lists.probability_list_id%TYPE
226: -- p_check_id_flag IN VARCHAR2 Required
227: -- x_probability_member_id OUT pa_probability_members.probability_member_id%TYPE Required

Line 227: -- x_probability_member_id OUT pa_probability_members.probability_member_id%TYPE Required

223: -- p_probability_percentage IN pa_probability_members.probability_percentage%TYPE Required
224: -- p_project_type IN pa_projects_all.project_type%TYPE
225: -- p_probability_list_id IN pa_probability_lists.probability_list_id%TYPE
226: -- p_check_id_flag IN VARCHAR2 Required
227: -- x_probability_member_id OUT pa_probability_members.probability_member_id%TYPE Required
228: -- x_return_status OUT VARCHAR2 Required
229: -- x_error_msg_code OUT VARCHAR2 Required
230: --
231: -- History

Line 237: (p_probability_member_id IN pa_probability_members.probability_member_id%TYPE

233: -- 18-AUG-2000 -- Sakthi/William - Created.
234: -- 18-MAR-2002 -- xxlu Added IN parameter p_probability_list_id.
235: --
236: PROCEDURE CHECK_PROBABILITY_CODE_OR_ID
237: (p_probability_member_id IN pa_probability_members.probability_member_id%TYPE
238: ,p_probability_percentage IN pa_probability_members.probability_percentage%TYPE
239: , p_project_type IN pa_projects_all.project_type%TYPE
240: ,p_probability_list_id IN pa_probability_lists.probability_list_id%TYPE:=NULL
241: ,p_check_id_flag IN VARCHAR2

Line 238: ,p_probability_percentage IN pa_probability_members.probability_percentage%TYPE

234: -- 18-MAR-2002 -- xxlu Added IN parameter p_probability_list_id.
235: --
236: PROCEDURE CHECK_PROBABILITY_CODE_OR_ID
237: (p_probability_member_id IN pa_probability_members.probability_member_id%TYPE
238: ,p_probability_percentage IN pa_probability_members.probability_percentage%TYPE
239: , p_project_type IN pa_projects_all.project_type%TYPE
240: ,p_probability_list_id IN pa_probability_lists.probability_list_id%TYPE:=NULL
241: ,p_check_id_flag IN VARCHAR2
242: ,x_probability_member_id OUT NOCOPY pa_probability_members.probability_member_id%TYPE --File.Sql.39 bug 4440895

Line 242: ,x_probability_member_id OUT NOCOPY pa_probability_members.probability_member_id%TYPE --File.Sql.39 bug 4440895

238: ,p_probability_percentage IN pa_probability_members.probability_percentage%TYPE
239: , p_project_type IN pa_projects_all.project_type%TYPE
240: ,p_probability_list_id IN pa_probability_lists.probability_list_id%TYPE:=NULL
241: ,p_check_id_flag IN VARCHAR2
242: ,x_probability_member_id OUT NOCOPY pa_probability_members.probability_member_id%TYPE --File.Sql.39 bug 4440895
243: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
244: ,x_error_msg_code OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
245: IS
246: l_current_id NUMBER := NULL;

Line 253: from pa_probability_members

249:
250:
251: CURSOR c_ids IS
252: select probability_member_id
253: from pa_probability_members
254: where probability_list_id =
255: (select probability_list_id from pa_project_types where
256: project_type = p_project_type)
257: and probability_percentage = p_probability_percentage;

Line 262: from pa_probability_members

258:
259: --MOAC Changes: Bug 4363092: removed nvl usage with org_id
260: CURSOR c_ids1 IS -- Added the cursor for Bug#3807805
261: select probability_member_id
262: from pa_probability_members
263: where probability_list_id =
264: (select probability_list_id from pa_project_types_all
265: where project_type = p_project_type
266: and org_id = PA_PROJECT_REQUEST_PVT.G_ORG_ID )

Line 274: FROM pa_probability_members

270: IF (p_probability_member_id IS NOT NULL) THEN
271: IF (p_check_id_flag = 'Y') THEN
272: SELECT probability_member_id
273: INTO x_probability_member_id
274: FROM pa_probability_members
275: WHERE probability_member_id = p_probability_member_id;
276:
277: ELSIF (p_check_id_flag='N') THEN
278: x_probability_member_id := p_probability_member_id;

Line 336: from pa_probability_members

332: IF (p_probability_list_id IS NULL) THEN
333: If PA_PROJECT_REQUEST_PVT.G_ORG_ID is null then -- Added the if condition for Bug#3807805
334: select probability_member_id
335: into x_probability_member_id
336: from pa_probability_members
337: where probability_list_id =
338: (select probability_list_id from pa_project_types where
339: project_type = p_project_type)
340: and probability_percentage = p_probability_percentage;

Line 344: from pa_probability_members

340: and probability_percentage = p_probability_percentage;
341: else -- Added the else block for Bug#3807805
342: select probability_member_id
343: into x_probability_member_id
344: from pa_probability_members
345: where probability_list_id =
346: (select probability_list_id from pa_project_types_all where
347: project_type = p_project_type
348: and org_id = PA_PROJECT_REQUEST_PVT.G_ORG_ID ) --MOAC Changes: Bug 4363092: removed nvl usage with org_id

Line 354: FROM pa_probability_members

350: end if;
351: ELSE
352: SELECT probability_member_id
353: INTO x_probability_member_id
354: FROM pa_probability_members
355: WHERE probability_list_id = p_probability_list_id
356: AND probability_percentage = p_probability_percentage;
357: END IF;
358: