[Home] [Help]
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;
122:
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;
204:
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,
538: fnd_application f
539: where a.request_set_id=b.request_set_id
540: and b.request_set_stage_id=c.request_set_stage_id
541: and a.request_set_id=c.request_set_id
534: fnd_request_set_programs b,
535: fnd_request_set_stages c,
536: fnd_concurrent_programs d,
537: fnd_application e,
538: fnd_application f
539: where a.request_set_id=b.request_set_id
540: and b.request_set_stage_id=c.request_set_stage_id
541: and a.request_set_id=c.request_set_id
542: and b.concurrent_program_id=d.concurrent_program_id
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
587: and b.request_set_stage_id=c.request_set_stage_id
588: and a.request_set_id=c.request_set_id
589: and a.application_id=d.application_id
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
1114: and a.application_id=c.application_id
1115: and c.application_short_name=p_set_application
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
1411: where a.application_id=b.unit_application_id
1412: and a.request_set_id=b.request_unit_id
1413: and b.request_unit_type='S'
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
1411: where a.application_id=b.unit_application_id
1412: and a.request_set_id=b.request_unit_id
1413: and b.request_unit_type='S'
1414: and a.application_id=d1.application_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
1456: and b.application_short_name=p_setapp
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
1470: and b.application_short_name=p_setapp;
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
1585: where a.request_set_id=b.request_set_id
1586: and a.application_id=b.set_application_id
1587: and a.application_id=e.application_id
1588: and e.application_short_name=p_set_app
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
1830: and a.application_id=c.application_id
1831: and c.application_short_name=p_setapp
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)
2337: and b.application_id=c.application_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
2752: and b.application_short_name=p_setapp
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
2767: and a.application_id=c.application_id
2768: and c.application_short_name=p_setapp
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
2780: and a.application_id=c.application_id
2781: and c.application_short_name=p_setapp
3126: -- perform
3127: g_current_user_id := FND_GLOBAL.User_id;
3128: g_current_login_id := FND_GLOBAL.Login_id;
3129:
3130: select APPLICATION_ID into l_set_app_id from fnd_application where
3131: application_short_name=p_set_app;
3132: l_stmt := 'insert into bis_request_set_options(request_set_name, set_app_id,
3133: option_name,option_value, CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,
3134: LAST_UPDATE_LOGIN,LAST_UPDATE_DATE) values
3217: END IF;
3218: END IF;
3219:
3220: --------dbms_output.put_Line('within create rs objects');
3221: select APPLICATION_ID into l_set_app_id from fnd_application where
3222: application_short_name=p_set_app;
3223: if (p_object_owner is null) then
3224: open c_owner;
3225: fetch c_owner into l_object_owner;
3247: l_stmt VARCHAR2 (2000);
3248: l_set_app_id number;
3249: begin
3250: ---- ----dbms_output.put_Line('within delete rs objects');
3251: select APPLICATION_ID into l_set_app_id from fnd_application where
3252: application_short_name=p_set_app;
3253: l_stmt := 'delete bis_request_set_objects where request_set_name=:a and
3254: set_app_id=:b';
3255: EXECUTE IMMEDIATE l_stmt USING p_set_name, l_set_app_id;
3261: l_stmt VARCHAR2 (2000);
3262: l_set_app_id number;
3263: begin
3264: -- ----dbms_output.put_Line('within delete rs options');
3265: select APPLICATION_ID into l_set_app_id from fnd_application where
3266: application_short_name=p_set_app;
3267: l_stmt := 'delete bis_request_set_options where request_set_name=:a and
3268: set_app_id=:b';
3269: EXECUTE IMMEDIATE l_stmt USING p_set_name, l_set_app_id;
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)
4156: and b.application_id=c.application_id
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
4316: and r.application_id = app.application_id
4417: END add_link_history_stage;
4418:
4419: function get_bsc_schema_name return varchar is
4420: cursor get_appl_short_name is
4421: select application_short_name from fnd_application
4422: where application_id =271;
4423:
4424: begin
4425: for get_appl_rec in get_appl_short_name loop
4439: CURSOR c_get_all_prog_status IS
4440: SELECT request_id, user_concurrent_program_name NAME, 'PROG' TYPE
4441: FROM BIS_RS_PROG_RUN_HISTORY bis, FND_CONCURRENT_PROGRAMS_VL fnd
4442: WHERE bis.set_request_id = l_root_request_id AND bis.status_code ='E'
4443: AND bis.prog_app_id = fnd.application_id AND bis.program_id = fnd.concurrent_program_id
4444: UNION
4445: SELECT request_id, user_stage_name NAME, 'STAGE' TYPE
4446: FROM BIS_RS_STAGE_RUN_HISTORY bis, FND_REQUEST_SET_STAGES_VL fnd
4447: WHERE set_request_id = l_root_request_id AND status_code ='E'