[Home] [Help]
113: cursor c_setname is
114: select
115: REQUEST_SET_NAME
116: from
117: fnd_request_sets_vl a,
118: fnd_application b
119: where a.USER_REQUEST_SET_NAME=p_setlongname
120: and a.application_id=b.application_id
121: and b.application_short_name=p_setapp;
195: cursor c_setname is
196: select
197: REQUEST_SET_NAME
198: from
199: fnd_request_sets_vl a,
200: fnd_application b
201: where a.USER_REQUEST_SET_NAME=p_setlongname
202: and a.application_id=b.application_id
203: and b.application_short_name=p_setapp;
529: select
530: c.stage_name,
531: b.sequence
532: from
533: fnd_request_sets a,
534: fnd_request_set_programs b,
535: fnd_request_set_stages c,
536: fnd_concurrent_programs d,
537: fnd_application e,
578: cursor c_max_seq is
579: select
580: max(b.sequence) max_prog_seq
581: from
582: fnd_request_sets a,
583: fnd_request_set_programs b,
584: fnd_request_set_stages c,
585: fnd_application d
586: where a.request_set_id=b.request_set_id
1105: cursor c_max_stage is
1106: select
1107: max(b.display_sequence)
1108: from
1109: fnd_request_sets a,
1110: fnd_request_set_stages b,
1111: fnd_application c
1112: where a.request_set_id=b.request_set_id
1113: and a.application_id=b.set_application_id
1402: select 'Y'
1403: from dual
1404: where exists
1405: (select a.request_set_name
1406: from fnd_request_sets a,
1407: fnd_request_group_units b,
1408: fnd_request_groups c,
1409: fnd_application d1,
1410: fnd_application d2
1447: c.REQUEST_SET_STAGE_ID stage_id,
1448: c.STAGE_NAME stage_name,
1449: c.display_sequence
1450: from
1451: fnd_request_sets a,
1452: fnd_application b,
1453: fnd_request_set_stages c
1454: where
1455: a.application_id=b.application_id
1461:
1462: cursor c_start_stage is
1463: select start_stage
1464: from
1465: fnd_request_sets a,
1466: fnd_application b
1467: where
1468: a.application_id=b.application_id
1469: and a.request_set_name=p_set_name
1525: end if;
1526: close c_start_stage;
1527: if nvl(l_start_stage_id, -1)<>nvl(l_first_stage_id,-1) then
1528: ---update the start stage
1529: update fnd_request_sets
1530: set start_stage=l_first_stage_id
1531: where request_set_id=l_set_id
1532: and application_id=l_set_app_id;
1533: commit;
1576: distinct
1577: b.stage_name,
1578: c.sequence
1579: from
1580: fnd_request_sets a,
1581: fnd_request_set_stages b,
1582: fnd_request_set_programs c,
1583: fnd_request_set_program_args d,
1584: fnd_application e
1821: cursor c_min_stage is
1822: select
1823: min(b.display_sequence)
1824: from
1825: fnd_request_sets a,
1826: fnd_request_set_stages b,
1827: fnd_application c
1828: where a.request_set_id=b.request_set_id
1829: and a.application_id=b.set_application_id
2328: cursor c_pages is
2329: select distinct a.object_name,a.object_type
2330: from
2331: bis_request_set_objects a,
2332: fnd_request_sets b,
2333: fnd_application c
2334: where a.request_set_name=b.request_set_name
2335: and a.set_app_id=b.application_id
2336: and b.request_set_name=upper(p_request_set_code)
2743: c.REQUEST_SET_STAGE_ID stage_id,
2744: c.STAGE_NAME stage_name,
2745: c.display_sequence
2746: from
2747: fnd_request_sets a,
2748: fnd_application b,
2749: fnd_request_set_stages c
2750: where
2751: a.application_id=b.application_id
2758: cursor c_max_stage is
2759: select
2760: max(b.display_sequence)
2761: from
2762: fnd_request_sets a,
2763: fnd_request_set_stages b,
2764: fnd_application c
2765: where a.request_set_id=b.request_set_id
2766: and a.application_id=b.set_application_id
2771: cursor c_min_stage is
2772: select
2773: min(b.display_sequence)
2774: from
2775: fnd_request_sets a,
2776: fnd_request_set_stages b,
2777: fnd_application c
2778: where a.request_set_id=b.request_set_id
2779: and a.application_id=b.set_application_id
3553: cursor c_set_with_unimpl_obj is
3554: select distinct c.user_request_set_name from
3555: bis_request_set_objects a,
3556: bis_obj_properties b,
3557: fnd_request_sets_vl c
3558: where a.object_name=b.object_name
3559: and a.object_type=b.object_type
3560: and b.implementation_flag='N'
3561: and a.request_set_name=c.request_set_name
3931: cursor c_page_objects is
3932: select distinct a.object_name,a.object_type
3933: from
3934: bis_request_set_objects a,
3935: fnd_request_sets b
3936: where a.request_set_name=b.request_set_name
3937: and a.set_app_id=b.application_id
3938: and b.request_set_name=p_request_set_code
3939: and b.application_id=191;
4147: cursor c_pages is
4148: select distinct a.object_name,a.object_type
4149: from
4150: bis_request_set_objects a,
4151: fnd_request_sets b,
4152: fnd_application c
4153: where a.request_set_name=b.request_set_name
4154: and a.set_app_id=b.application_id
4155: and b.request_set_name=upper(p_request_set_code)
4307: report_stage_name varchar2(200);
4308: cursor c_stages
4309: is
4310: select s.STAGE_NAME
4311: from fnd_request_sets r ,fnd_request_set_stages s,
4312: fnd_application app
4313: where r.REQUEST_SET_ID= s.REQUEST_SET_ID
4314: and r.application_id = s.set_Application_id
4315: and r.REQUEST_SET_NAME = p_set_name
4511: FUNCTION is_history_collect_on(p_root_request_id IN NUMBER) RETURN BOOLEAN
4512: IS
4513: CURSOR c_request_set_details IS
4514: SELECT rs.request_set_name
4515: FROM fnd_concurrent_requests cr, fnd_request_sets rs
4516: WHERE cr.request_id = p_root_request_id
4517: AND rs.application_id = cr.argument1
4518: AND rs.request_set_id = cr.argument2;
4519: l_request_set_name VARCHAR2(1000);