APPS.PA_PROJECT_REQUEST_PVT dependencies on PA_PROJECT_STATUSES

Line 10: -- p_request_sys_status pa_project_statuses.project_system_status_code%TYPE

6: -- Status of 'PROJ_REQ_CLOSED' OR 'PROJ_REQ_CANCELED'.
7: --
8: -- Input parameters
9: -- Parameters Type
10: -- p_request_sys_status pa_project_statuses.project_system_status_code%TYPE
11: --
12: G_DEBUG_MODE VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
13: PROCEDURE debug(p_msg IN VARCHAR2) IS
14: l_debug_mode varchar2(1); -- Added for Bug 4469333

Line 34: (p_request_sys_status IN pa_project_statuses.project_system_status_code%TYPE,

30: END debug;
31:
32:
33: PROCEDURE create_project_validation
34: (p_request_sys_status IN pa_project_statuses.project_system_status_code%TYPE,
35: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
36: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
37: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
38: IS

Line 143: FROM pa_projects_all p, pa_project_statuses s

139:
140: -- 2564086: Modified to select from pa_projects_all.
141: CURSOR prj IS
142: SELECT p.name, p.segment1, p.project_type, s.project_status_name, p.description
143: FROM pa_projects_all p, pa_project_statuses s
144: WHERE p.project_status_code = s.project_status_code
145: AND p.project_id = p_object_id1;
146:
147: v_prj prj%ROWTYPE;

Line 151: FROM pa_project_requests r, pa_project_statuses s, pa_lookups lup

147: v_prj prj%ROWTYPE;
148:
149: CURSOR prq IS
150: SELECT r.request_name, r.request_number, lup.meaning, s.project_status_name, r.description
151: FROM pa_project_requests r, pa_project_statuses s, pa_lookups lup
152: WHERE r.status_code = s.project_status_code
153: AND r.request_id = p_object_id1
154: AND r.request_type = lup.lookup_code
155: AND lup.lookup_type = 'PROJECT_REQUEST_TYPE';

Line 368: from pa_project_statuses sts, pa_project_requests req

364: -- added for Bug Fix: 4537865
365:
366: cursor cur_status is
367: select sts.project_system_status_code
368: from pa_project_statuses sts, pa_project_requests req
369: where req.request_id = p_request_id
370: and sts.project_status_code = req.status_code;
371: BEGIN
372:

Line 1660: pa_project_statuses s ,

1656: p.record_version_number,
1657: p.org_id -- Added for Bug#3798344
1658: FROM
1659: pa_projects_all p,
1660: pa_project_statuses s ,
1661: pa_probability_members m ,
1662: pa_project_opp_attrs a
1663: WHERE p.project_status_code = s.project_status_code
1664: AND p.probability_member_id = m.probability_member_id(+)

Line 1698: l_project_status_name pa_project_statuses.project_status_name%TYPE;

1694:
1695:
1696: l_project_name pa_projects_all.name%TYPE;
1697: l_project_number pa_projects_all.segment1%TYPE;
1698: l_project_status_name pa_project_statuses.project_status_name%TYPE;
1699:
1700: -- Old pipeline project info.
1701: l_project_value pa_projects_all.project_value%TYPE;
1702: l_probability pa_probability_members.probability_percentage%TYPE;

Line 1773: stmt_class2 := ' FROM as_leads l, as_interests i, pa_project_requests r, pa_object_relationships o,pa_project_statuses s '

1769: || 'r.request_id request_id,'
1770: || 'l.lead_id lead_id,'
1771: || 'null as category ' ;
1772:
1773: stmt_class2 := ' FROM as_leads l, as_interests i, pa_project_requests r, pa_object_relationships o,pa_project_statuses s '
1774: || ' WHERE '
1775: || ' (l.win_probability >= nvl(:1, 0) OR'
1776: || ' (l.win_probability IS NULL AND :1 IS NULL)'
1777: ||' ) '

Line 1831: stmt_categ2 := ' FROM as_leads l,as_lead_lines ll,pa_lead_categories_v h,pa_project_requests r, pa_object_relationships o,pa_project_statuses s '

1827: || ' r.request_id request_id,'
1828: || 'l.lead_id lead_id,'
1829: || 'h.category category ' ;
1830:
1831: stmt_categ2 := ' FROM as_leads l,as_lead_lines ll,pa_lead_categories_v h,pa_project_requests r, pa_object_relationships o,pa_project_statuses s '
1832: || ' WHERE '
1833: || 'll.product_category_id = h.category_id '
1834: || ' AND l.lead_id = ll.lead_id '
1835: || ' AND ('