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_REQUEST_PVT dependencies on PA_PROJECT_REQUESTS

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 198: ELSIF p_object_type = 'PA_PROJECT_REQUESTS' THEN

194: x_status_name := v_prj.project_status_name;
195: x_description := v_prj.description;
196: END IF;
197:
198: ELSIF p_object_type = 'PA_PROJECT_REQUESTS' THEN
199: OPEN prq;
200: FETCH prq INTO v_prq;
201: IF prq%NOTFOUND THEN
202: RETURN;

Line 354: (p_request_id IN pa_project_requests.request_id%TYPE,

350: END populate_associations_temp;
351:
352:
353: PROCEDURE close_project_request
354: (p_request_id IN pa_project_requests.request_id%TYPE,
355: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
356: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
357: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
358: IS

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 525: AND object_type_from = 'PA_PROJECT_REQUESTS'

521: SELECT object_id_to1
522: FROM pa_object_relationships
523: WHERE relationship_type = 'A'
524: AND relationship_subtype = 'PROJECT_REQUEST'
525: AND object_type_from = 'PA_PROJECT_REQUESTS'
526: AND object_id_from1 = p_request_id
527: AND object_type_to = 'AS_LEADS';
528:
529: -- Cursor to get the probability value for a opportunity

Line 565: pa_project_requests r,

561: lc.city city,
562: p.party_name customer_orgnization,
563: r.request_type
564: FROM
565: pa_project_requests r,
566: hz_parties p,
567: hz_party_sites s,
568: --hz_cust_accounts a,--bug#9132476
569: hz_locations lc,

Line 1097: pa_project_requests r,

1093: l.country,
1094: l.state,
1095: l.city
1096: FROM
1097: pa_project_requests r,
1098: hz_parties p,
1099: hz_party_sites s,
1100: hz_locations l
1101: WHERE

Line 1190: --Modified stmt_Class5 for bug 5728842. Added o.object_type_to = 'PA_PROJECT_REQUESTS' condition.

1186: ||' (i.secondary_interest_code_id IS NULL AND :12 IS NULL)'
1187: ||' )'
1188: ||'AND l.lead_id = i.lead_id (+)';
1189:
1190: --Modified stmt_Class5 for bug 5728842. Added o.object_type_to = 'PA_PROJECT_REQUESTS' condition.
1191: stmt_class5 :='AND l.lead_id NOT IN'
1192: ||' (SELECT l.lead_id'
1193: ||' FROM as_leads l,'
1194: ||' pa_object_relationships o,'

Line 1195: ||' pa_project_requests r'

1191: stmt_class5 :='AND l.lead_id NOT IN'
1192: ||' (SELECT l.lead_id'
1193: ||' FROM as_leads l,'
1194: ||' pa_object_relationships o,'
1195: ||' pa_project_requests r'
1196: ||' WHERE l.lead_id = o.object_id_from1'
1197: ||' AND o.object_id_to1 = r.request_id'
1198: ||' AND o.object_type_to = ''PA_PROJECT_REQUESTS'''
1199: ||' AND r.request_type = :13 '

Line 1198: ||' AND o.object_type_to = ''PA_PROJECT_REQUESTS'''

1194: ||' pa_object_relationships o,'
1195: ||' pa_project_requests r'
1196: ||' WHERE l.lead_id = o.object_id_from1'
1197: ||' AND o.object_id_to1 = r.request_id'
1198: ||' AND o.object_type_to = ''PA_PROJECT_REQUESTS'''
1199: ||' AND r.request_type = :13 '
1200: ||' AND o.relationship_type=''A'''
1201: ||' AND o.relationship_subtype =''PROJECT_REQUEST'''
1202: ||' AND object_type_from = ''AS_LEADS'')';

Line 1264: ||' pa_project_requests r'

1260: stmt_categ5 :=' AND l.lead_id NOT IN'
1261: ||' (SELECT l.lead_id'
1262: ||' FROM as_leads l,'
1263: ||' pa_object_relationships o,'
1264: ||' pa_project_requests r'
1265: ||' WHERE l.lead_id = o.object_id_from1'
1266: ||' AND o.object_id_to1 = r.request_id'
1267: ||' AND r.request_type =:11 '
1268: ||' AND o.relationship_type=''A'' '

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 1821: ||' AND o.object_type_to = ''PA_PROJECT_REQUESTS'' ';

1817: ||' AND r.request_type =:12'
1818: ||' AND o.relationship_type=''A'' '
1819: ||' AND o.relationship_subtype =''PROJECT_REQUEST'' '
1820: ||' AND o.object_type_from = ''AS_LEADS'' '
1821: ||' AND o.object_type_to = ''PA_PROJECT_REQUESTS'' ';
1822:
1823: stmt_categ1 := 'SELECT l.total_amount value, '
1824: || 'l.currency_code currency_code,'
1825: || 'l.decision_date expected_approval_date,'

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 ('

Line 1872: ||' AND o.object_type_to = ''PA_PROJECT_REQUESTS'' ';

1868: ||' AND r.request_type =:10'
1869: ||' AND o.relationship_type=''A'' '
1870: ||' AND o.relationship_subtype =''PROJECT_REQUEST'' '
1871: ||' AND o.object_type_from = ''AS_LEADS'' '
1872: ||' AND o.object_type_to = ''PA_PROJECT_REQUESTS'' ';
1873:
1874:
1875: --Generate group_id for each run of update projects.
1876: --Used by workflow notification.

Line 2056: AND object_type_from ='PA_PROJECT_REQUESTS'

2052: INTO l_project_id
2053: FROM pa_object_relationships
2054: WHERE relationship_type='A'
2055: AND relationship_subtype ='PROJECT_REQUEST'
2056: AND object_type_from ='PA_PROJECT_REQUESTS'
2057: AND object_type_to = 'PA_PROJECTS'
2058: AND object_id_from1 = cur_sel_opportunities_rec.request_id;
2059:
2060: debug('Updating this project, project_id = ' || l_project_id );

Line 2534: PROCEDURE post_create_project(p_request_id IN pa_project_requests.request_id%TYPE,

2530: -- between the project request and the project created.
2531: -- And close the project request after the project is created.
2532:
2533:
2534: PROCEDURE post_create_project(p_request_id IN pa_project_requests.request_id%TYPE,
2535: p_project_id IN pa_projects_all.project_id%TYPE,
2536: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2537: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2538: x_msg_data OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895

Line 2550: ,p_object_type_from => 'PA_PROJECT_REQUESTS'

2546: -- Form the relationship: from the project request to the created project.
2547:
2548: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
2549: p_user_id => FND_GLOBAL.USER_ID
2550: ,p_object_type_from => 'PA_PROJECT_REQUESTS'
2551: ,p_object_id_from1 => p_request_id
2552: ,p_object_id_from2 => NULL
2553: ,p_object_id_from3 => NULL
2554: ,p_object_id_from4 => NULL

Line 2583: ,p_object_type_to => 'PA_PROJECT_REQUESTS'

2579: ,p_object_id_from2 => NULL
2580: ,p_object_id_from3 => NULL
2581: ,p_object_id_from4 => NULL
2582: ,p_object_id_from5 => NULL
2583: ,p_object_type_to => 'PA_PROJECT_REQUESTS'
2584: ,p_object_id_to1 => p_request_id
2585: ,p_object_id_to2 => NULL
2586: ,p_object_id_to3 => NULL
2587: ,p_object_id_to4 => NULL

Line 2628: FROM pa_project_requests

2624: x_msg_data OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
2625:
2626: CURSOR C1 IS
2627: SELECT 'N'
2628: FROM pa_project_requests
2629: WHERE UPPER(REQUEST_NAME) = UPPER(P_REQUEST_NAME);
2630: l_duplicate VARCHAR2(1);
2631: l_msg_index_out NUMBER;
2632: dup_req_name_not_allowed EXCEPTION;