APPS.BIS_CREATE_REQUESTSET dependencies on FND_SET

Line 133: fnd_set.remove_set_from_group(

129: --- g_set_application:='BIS';
130: ----Based on the demo meeting on August 28, 2002
131: ----Need to add the set to DBI requests group attached to Business Intelligence Administrator resp
132: if set_in_group(p_setname,p_setapp,l_group_name,l_group_app)='Y' then
133: fnd_set.remove_set_from_group(
134: request_set=>upper(p_setname),
135: set_application=>p_setapp,
136: request_group=>l_group_name,
137: group_application=>l_group_app

Line 150: fnd_set.delete_set(upper(l_setname),p_setapp);

146: fetch c_setname into l_setname;
147: close c_setname;
148:
149: if l_setname is not null then
150: fnd_set.delete_set(upper(l_setname),p_setapp);
151: /* changes for 'view request set history': delete from
152: bis_request_set_options and bis_request_set_objects if the request
153: set already exists in these tables. */
154: delete_rs_objects(upper(l_setname), p_setapp);

Line 157: fnd_set.delete_set(upper(p_setname),p_setapp);

153: set already exists in these tables. */
154: delete_rs_objects(upper(l_setname), p_setapp);
155: delete_rs_option(upper(l_setname), p_setapp);
156: else
157: fnd_set.delete_set(upper(p_setname),p_setapp);
158: /* changes for 'view request set history': delete from
159: bis_request_set_options and bis_request_set_objects if the request
160: set already exists in these tables. */
161: delete_rs_objects(upper(p_setname), p_setapp);

Line 226: fnd_set.remove_set_from_group(

222: --- g_set_application:='BIS';
223: ----Based on the demo meeting on August 28, 2002
224: ----Need to add the set to DBI requests group attached to Business Intelligence Administrator resp
225: if set_in_group(p_setname,p_setapp,l_group_name,l_group_app)='Y' then
226: fnd_set.remove_set_from_group(
227: request_set=>upper(p_setname),
228: set_application=>p_setapp,
229: request_group=>l_group_name,
230: group_application=>l_group_app

Line 245: fnd_set.delete_set(upper(l_setname),p_setapp);

241: fetch c_setname into l_setname;
242: close c_setname;
243:
244: if l_setname is not null then
245: fnd_set.delete_set(upper(l_setname),p_setapp);
246: /* changes for 'view request set history': delete from
247: bis_request_set_options and bis_request_set_objects if the request
248: set already exists in these tables. */
249: delete_rs_objects(upper(l_setname), p_setapp);

Line 253: fnd_set.delete_set(upper(p_setname),p_setapp);

249: delete_rs_objects(upper(l_setname), p_setapp);
250: delete_rs_option(upper(l_setname), p_setapp);
251:
252: else
253: fnd_set.delete_set(upper(p_setname),p_setapp);
254: /* changes for 'view request set history': delete from
255: bis_request_set_options and bis_request_set_objects if the request
256: set already exists in these tables. */
257: delete_rs_objects(upper(p_setname), p_setapp);

Line 265: fnd_set.create_set

261: commit;
262:
263:
264:
265: fnd_set.create_set
266: (name=>p_setlongname,
267: short_name=>upper(p_setname),
268: application=>p_setapp,
269: description=>p_setlongname||'(created by request set generator)',

Line 278: fnd_set.add_set_to_group(

274: incompatibilities_allowed=>'N',
275: LANGUAGE_CODE=>'US');
276: commit;
277:
278: fnd_set.add_set_to_group(
279: request_set=>upper(p_setname),
280: set_application=>p_setapp,
281: request_group=>'DBI Requests and Reports',
282: group_application=> 'BIS'

Line 663: fnd_set.add_program(

659: l_max_program_seq:=0;
660: end if;
661: begin
662:
663: fnd_set.add_program(
664: program =>l_process_name ,
665: program_application=>l_process_app ,
666: request_set=>upper(p_setname) ,
667: set_application=>p_set_application ,

Line 676: fnd_set.PROGRAM_PARAMETER(

672: save_output =>'Y',
673: style=>null,
674: printer=>null);
675:
676: fnd_set.PROGRAM_PARAMETER(
677: PROGRAM=>l_process_name,
678: PROGRAM_APPLICATION=>l_process_app,
679: REQUEST_SET=>upper(p_setname),
680: SET_APPLICATION=>p_set_application,

Line 691: fnd_set.PROGRAM_PARAMETER(

687: DEFAULT_TYPE=>'Constant',
688: DEFAULT_VALUE=>p_refresh_mode
689: );
690:
691: fnd_set.PROGRAM_PARAMETER(
692: PROGRAM=>l_process_name,
693: PROGRAM_APPLICATION=>l_process_app,
694: REQUEST_SET=>upper(p_setname),
695: SET_APPLICATION=>p_set_application,

Line 719: fnd_set.remove_program

715: ----then we need to remove this process and re-add it to the set on an earlier stage
716: -- if l_exist_stage_number>p_level*100+p_start_stage then
717: if l_exist_stage_number>(p_max_level-p_level+1)*100+p_start_stage then
718: begin
719: fnd_set.remove_program
720: (program=>l_process_name,
721: program_application=>l_process_app,
722: request_set=>upper(p_setname),
723: set_application=>p_set_application,

Line 740: fnd_set.add_program(

736: end if;
737:
738: begin
739:
740: fnd_set.add_program(
741: program =>l_process_name ,
742: program_application=>l_process_app ,
743: request_set=>upper(p_setname) ,
744: set_application=>p_set_application ,

Line 753: fnd_set.PROGRAM_PARAMETER(

749: save_output =>'Y',
750: style=>null,
751: printer=>null);
752:
753: fnd_set.PROGRAM_PARAMETER(
754: PROGRAM=>l_process_name,
755: PROGRAM_APPLICATION=>l_process_app,
756: REQUEST_SET=>upper(p_setname),
757: SET_APPLICATION=>p_set_application,

Line 768: fnd_set.PROGRAM_PARAMETER(

764: DEFAULT_TYPE=>'Constant',
765: DEFAULT_VALUE=>p_refresh_mode
766: );
767:
768: fnd_set.PROGRAM_PARAMETER(
769: PROGRAM=>l_process_name,
770: PROGRAM_APPLICATION=>l_process_app,
771: REQUEST_SET=>upper(p_setname),
772: SET_APPLICATION=>p_set_application,

Line 889: fnd_set.add_program(

885: l_max_program_seq:=0;
886: end if;
887: begin
888: --dbms_output.put_Line('point1');
889: fnd_set.add_program(
890: program =>l_process_name ,
891: program_application=>l_process_app ,
892: request_set=>upper(p_setname) ,
893: set_application=>p_set_application ,

Line 902: fnd_set.PROGRAM_PARAMETER(

898: save_output =>'Y',
899: style=>null,
900: printer=>null);
901: --dbms_output.put_Line('point2');
902: fnd_set.PROGRAM_PARAMETER(
903: PROGRAM=>l_process_name,
904: PROGRAM_APPLICATION=>l_process_app,
905: REQUEST_SET=>upper(p_setname),
906: SET_APPLICATION=>p_set_application,

Line 931: fnd_set.remove_program

927: ----then we need to remove this process and re-add it to the set on an earlier stage
928: -- if l_exist_stage_number>p_level*100+p_start_stage then
929: if l_exist_stage_number>(p_max_level-p_level+1)*100 then
930: begin
931: fnd_set.remove_program
932: (program=>l_process_name,
933: program_application=>l_process_app,
934: request_set=>upper(p_setname),
935: set_application=>p_set_application,

Line 952: fnd_set.add_program(

948: end if;
949:
950: begin
951:
952: fnd_set.add_program(
953: program =>l_process_name ,
954: program_application=>l_process_app ,
955: request_set=>upper(p_setname) ,
956: set_application=>p_set_application ,

Line 966: fnd_set.PROGRAM_PARAMETER(

962: style=>null,
963: printer=>null);
964:
965: --dbms_output.put_Line('point4');
966: fnd_set.PROGRAM_PARAMETER(
967: PROGRAM=>l_process_name,
968: PROGRAM_APPLICATION=>l_process_app,
969: REQUEST_SET=>upper(p_setname),
970: SET_APPLICATION=>p_set_application,

Line 1193: fnd_set.add_stage

1189: ----adding stages if this page has more levels of dependencies
1190: for i in trunc(l_max_stage/100+1)..l_max_level loop
1191: --- --dbms_output.put_Line('stages added: '||'Stage_'||to_char(i*100));
1192: if i=1 then
1193: fnd_set.add_stage
1194: (name=>g_stage_prompt||' '||to_char(i*100),
1195: request_set=>upper(l_setname),
1196: set_application=>l_set_application,
1197: short_name=>'Stage_'||to_char(i*100),

Line 1207: fnd_set.add_stage

1203: incompatibilities_allowed=>'N',
1204: start_stage=>'Y',
1205: language_code=>'US');
1206: else
1207: fnd_set.add_stage
1208: (name=>g_stage_prompt||' '||to_char(i*100),
1209: request_set=>upper(l_setname),
1210: set_application=>l_set_application,
1211: short_name=>'Stage_'||to_char(i*100),

Line 1302: fnd_set.add_program

1298: if l_max_program_seq is null then
1299: l_max_program_seq:=0;
1300: end if;
1301: begin
1302: fnd_set.add_program
1303: (program =>l_process_name ,
1304: program_application=>l_process_app ,
1305: request_set=>upper(l_setname) ,
1306: set_application=>l_set_application ,

Line 1326: fnd_set.remove_program

1322: -----if a same process alreay defined in a set and the stage is later than current process needed
1323: ----then we need to remove this process and re-add it to the set on an earlier stage
1324: if l_exist_stage_number>(l_max_level-l_level+1)*100 then
1325: begin
1326: fnd_set.remove_program
1327: (program=>l_process_name,
1328: program_application=>l_process_app,
1329: request_set=>upper(l_setname),
1330: set_application=>l_set_application,

Line 1346: fnd_set.add_program

1342: if l_max_program_seq is null then
1343: l_max_program_seq:=0;
1344: end if;
1345: begin
1346: fnd_set.add_program
1347: (program =>l_process_name ,
1348: program_application=>l_process_app ,
1349: request_set=>upper(l_setname) ,
1350: set_application=>l_set_application ,

Line 1486: fnd_set.remove_stage(

1482: for l_stage_rec in c_stages loop
1483: if is_stage_empty(l_stage_rec.set_app_id,
1484: l_stage_rec.set_id,
1485: l_stage_rec.stage_id)='Y' then
1486: fnd_set.remove_stage(
1487: request_set=>upper(p_set_name),
1488: set_application=>p_setapp,
1489: stage=>l_stage_rec.stage_name);
1490: commit;

Line 1508: fnd_set.link_stages

1504: end loop;
1505:
1506: if l_counter>1 then
1507: for i in 1..l_counter-1 loop
1508: fnd_set.link_stages
1509: (request_set=>upper(p_set_name),
1510: set_application=>p_setapp,
1511: from_stage=>l_stage_array(i),
1512: to_stage=>l_stage_array(i+1),

Line 1867: fnd_set.add_stage

1863: ----adding stages if this dimension has more levels of dependencies
1864: if (l_max_dim_depend_level>0 and p_start_stage-l_max_dim_depend_level*100 1865: for i in trunc(l_min_stage/100-1)..p_start_stage/100-l_max_dim_depend_level loop
1866: -- ----dbms_output.put_Line('i : '||i);
1867: fnd_set.add_stage
1868: (name=>g_stage_prompt||' '||to_char(i*100),
1869: request_set=>upper(p_setname),
1870: set_application=>p_setapp,
1871: short_name=>'Stage_'||to_char(i*100),

Line 1914: fnd_set.add_program

1910: end if;
1911:
1912: if l_exist_stage is null then
1913: begin
1914: fnd_set.add_program
1915: (program =>l_process_name ,
1916: program_application=>l_process_app ,
1917: request_set=>upper(p_setname) ,
1918: set_application=>p_setapp ,

Line 1937: fnd_set.remove_program

1933: -----if a same process alreay exist in a set and the stage is later than the current process needed
1934: ----then we need to remove the existing process and re-add it to the set on an ealier stage
1935: if l_exist_stage_number>p_start_stage-l_level*100 then
1936: begin
1937: fnd_set.remove_program
1938: (program=>l_process_name,
1939: program_application=>l_process_app,
1940: request_set=>upper(p_setname),
1941: set_application=>p_setapp,

Line 1951: fnd_set.add_program

1947: raise;
1948: end;
1949:
1950: begin
1951: fnd_set.add_program
1952: (program =>l_process_name ,
1953: program_application=>l_process_app ,
1954: request_set=>upper(p_setname) ,
1955: set_application=>p_setapp,

Line 2001: fnd_set.add_program(

1997:
1998:
1999: if l_exist_stage is null then
2000: begin
2001: fnd_set.add_program(
2002: program =>l_process_name ,
2003: program_application=>l_process_app ,
2004: request_set=>upper(p_setname) ,
2005: set_application=>p_setapp,

Line 2014: fnd_set.PROGRAM_PARAMETER(

2010: save_output =>'Y',
2011: style=>null,
2012: printer=>null);
2013:
2014: fnd_set.PROGRAM_PARAMETER(
2015: PROGRAM=>l_process_name,
2016: PROGRAM_APPLICATION=>l_process_app,
2017: REQUEST_SET=>upper(p_setname),
2018: SET_APPLICATION=>p_setapp,

Line 2029: fnd_set.PROGRAM_PARAMETER(

2025: DEFAULT_TYPE=>'Constant',
2026: DEFAULT_VALUE=>p_refresh_mode
2027: );
2028:
2029: fnd_set.PROGRAM_PARAMETER(
2030: PROGRAM=>l_process_name,
2031: PROGRAM_APPLICATION=>l_process_app,
2032: REQUEST_SET=>upper(p_setname),
2033: SET_APPLICATION=>p_setapp,

Line 2054: fnd_set.remove_program

2050: ----For dimensions, if a same process alreay exist in a set and the stage is later than the current process needed
2051: ----then we need to remove the existing process and re-add it to the set on an ealier stage
2052: if l_exist_stage_number>p_start_stage-l_level*100 then
2053: begin
2054: fnd_set.remove_program
2055: (program=>l_process_name,
2056: program_application=>l_process_app,
2057: request_set=>upper(p_setname),
2058: set_application=>p_setapp,

Line 2068: fnd_set.add_program(

2064: raise;
2065: end;
2066:
2067: begin
2068: fnd_set.add_program(
2069: program =>l_process_name ,
2070: program_application=>l_process_app ,
2071: request_set=>upper(p_setname) ,
2072: set_application=>p_setapp,

Line 2081: fnd_set.PROGRAM_PARAMETER(

2077: save_output =>'Y',
2078: style=>null,
2079: printer=>null);
2080:
2081: fnd_set.PROGRAM_PARAMETER(
2082: PROGRAM=>l_process_name,
2083: PROGRAM_APPLICATION=>l_process_app,
2084: REQUEST_SET=>upper(p_setname),
2085: SET_APPLICATION=>p_setapp,

Line 2096: fnd_set.PROGRAM_PARAMETER(

2092: DEFAULT_TYPE=>'Constant',
2093: DEFAULT_VALUE=>p_refresh_mode
2094: );
2095:
2096: fnd_set.PROGRAM_PARAMETER(
2097: PROGRAM=>l_process_name,
2098: PROGRAM_APPLICATION=>l_process_app,
2099: REQUEST_SET=>upper(p_setname),
2100: SET_APPLICATION=>p_setapp,

Line 2216: fnd_set.add_program

2212: if l_max_program_seq is null then
2213: l_max_program_seq:=0;
2214: end if;
2215: begin
2216: fnd_set.add_program
2217: (program =>p_program_name ,
2218: program_application=>p_program_app,
2219: request_set=>upper(p_setname),
2220: set_application=>p_setapp ,

Line 2231: fnd_set.PROGRAM_PARAMETER(

2227: printer=>null);
2228: commit;
2229:
2230: ------register parameters
2231: fnd_set.PROGRAM_PARAMETER(
2232: PROGRAM=>p_program_name,
2233: PROGRAM_APPLICATION=>p_program_app,
2234: REQUEST_SET=>upper(p_setname),
2235: SET_APPLICATION=>p_setapp,

Line 2246: fnd_set.PROGRAM_PARAMETER(

2242: DEFAULT_TYPE=>'Constant',
2243: DEFAULT_VALUE=>p_custom_api
2244: );
2245:
2246: fnd_set.PROGRAM_PARAMETER(
2247: PROGRAM=>p_program_name,
2248: PROGRAM_APPLICATION=>p_program_app,
2249: REQUEST_SET=>upper(p_setname),
2250: SET_APPLICATION=>p_setapp,

Line 2261: fnd_set.PROGRAM_PARAMETER(

2257: DEFAULT_TYPE=>'Constant',
2258: DEFAULT_VALUE=>p_obj_name
2259: );
2260:
2261: fnd_set.PROGRAM_PARAMETER(
2262: PROGRAM=>p_program_name,
2263: PROGRAM_APPLICATION=>p_program_app,
2264: REQUEST_SET=>upper(p_setname),
2265: SET_APPLICATION=>p_setapp,

Line 2276: fnd_set.PROGRAM_PARAMETER(

2272: DEFAULT_TYPE=>'Constant',
2273: DEFAULT_VALUE=>p_obj_type
2274: );
2275:
2276: fnd_set.PROGRAM_PARAMETER(
2277: PROGRAM=>p_program_name,
2278: PROGRAM_APPLICATION=>p_program_app,
2279: REQUEST_SET=>upper(p_setname),
2280: SET_APPLICATION=>p_setapp,

Line 2412: fnd_set.add_stage

2408: end loop; --end loop of objects in a page
2409: end loop; ---end loop of pages
2410:
2411:
2412: fnd_set.add_stage
2413: (name=>g_stage_prompt||' '||to_char(100),
2414: request_set=>upper(p_request_set_code),
2415: set_application=> p_set_app,
2416: short_name=>'Stage_'||to_char(100),

Line 2440: fnd_set.add_program

2436: --- --dbms_output.put_Line('prog sequence '||l_max_program_seq);
2437:
2438: -------add analyze program for the object
2439: begin
2440: fnd_set.add_program
2441: (program =>g_fnd_stats ,
2442: program_application=>g_fnd_stats_app,
2443: request_set=>upper(p_request_set_code) ,
2444: set_application=>p_set_app ,

Line 2454: fnd_set.PROGRAM_PARAMETER(

2450: style=>null,
2451: printer=>null);
2452: commit;
2453:
2454: fnd_set.PROGRAM_PARAMETER(
2455: PROGRAM=>g_fnd_stats,
2456: PROGRAM_APPLICATION=>g_fnd_stats_app,
2457: REQUEST_SET=>upper(p_request_set_code),
2458: SET_APPLICATION=>p_set_app,

Line 2469: fnd_set.PROGRAM_PARAMETER(

2465: DEFAULT_TYPE=>'Constant',
2466: DEFAULT_VALUE=>l_all_objects(j).object_type
2467: );
2468:
2469: fnd_set.PROGRAM_PARAMETER(
2470: PROGRAM=>g_fnd_stats,
2471: PROGRAM_APPLICATION=>g_fnd_stats_app,
2472: REQUEST_SET=>upper(p_request_set_code),
2473: SET_APPLICATION=>p_set_app,

Line 2551: fnd_set.add_stage

2547: --dbms_output.put_line('l_dim_stage_number '||l_dim_stage_number);
2548: if p_refresh_mode='INIT' then
2549: l_del_stage_number:=l_current_stage_number-100-35;
2550: -- dbms_output.put_line('l_del_stage_number '||l_del_stage_number);
2551: fnd_set.add_stage
2552: (name=>g_stage_prompt||' '||to_char(l_del_stage_number),
2553: request_set=>upper(p_setname),
2554: set_application=>p_setapp,
2555: short_name=>'Stage_'||to_char(l_del_stage_number),

Line 2568: fnd_set.add_stage

2564: commit;
2565: end if ;----p_refresh_mode
2566: else ---l_current_stage_number>=100
2567: l_dim_stage_number:=l_current_stage_number-30;
2568: fnd_set.add_stage
2569: (name=>g_stage_prompt||' '||to_char(l_dim_stage_number),
2570: request_set=>upper(p_setname),
2571: set_application=>p_setapp,
2572: short_name=>'Stage_'||to_char(l_dim_stage_number),

Line 2584: fnd_set.add_stage

2580: language_code=>'US');
2581: commit;
2582: if p_refresh_mode='INIT' then
2583: l_del_stage_number:=l_current_stage_number-35;
2584: fnd_set.add_stage
2585: (name=>g_stage_prompt||' '||to_char(l_del_stage_number),
2586: request_set=>upper(p_setname),
2587: set_application=>p_setapp,
2588: short_name=>'Stage_'||to_char(l_del_stage_number),

Line 2613: fnd_set.add_program

2609: if l_max_program_seq is null then
2610: l_max_program_seq:=0;
2611: end if;
2612:
2613: fnd_set.add_program
2614: (program =>g_bsc_loader_del_program ,
2615: program_application=>'BSC',
2616: request_set=>upper(p_setname) ,
2617: set_application=>p_setapp ,

Line 2628: fnd_set.PROGRAM_PARAMETER(

2624: printer=>null);
2625:
2626:
2627:
2628: fnd_set.PROGRAM_PARAMETER(
2629: PROGRAM=>g_bsc_loader_del_program,
2630: PROGRAM_APPLICATION=>'BSC',
2631: REQUEST_SET=>upper(p_setname),
2632: SET_APPLICATION=>p_setapp,

Line 2643: fnd_set.PROGRAM_PARAMETER(

2639: DEFAULT_TYPE=>'Constant',
2640: DEFAULT_VALUE=>l_object_rec.object_name
2641: );
2642:
2643: fnd_set.PROGRAM_PARAMETER(
2644: PROGRAM=>g_bsc_loader_del_program,
2645: PROGRAM_APPLICATION=>'BSC',
2646: REQUEST_SET=>upper(p_setname),
2647: SET_APPLICATION=>p_setapp,

Line 2668: fnd_set.add_program

2664: if l_max_program_seq is null then
2665: l_max_program_seq:=0;
2666: end if;
2667:
2668: fnd_set.add_program
2669: (program =>g_bsc_loader_dim_program ,
2670: program_application=>'BSC',
2671: request_set=>upper(p_setname) ,
2672: set_application=>p_setapp ,

Line 2682: fnd_set.PROGRAM_PARAMETER(

2678: style=>null,
2679: printer=>null);
2680:
2681:
2682: fnd_set.PROGRAM_PARAMETER(
2683: PROGRAM=>g_bsc_loader_dim_program,
2684: PROGRAM_APPLICATION=>'BSC',
2685: REQUEST_SET=>upper(p_setname),
2686: SET_APPLICATION=>p_setapp,

Line 2920: fnd_set.add_stage

2916: l_counter:=l_counter+1;
2917: if l_counter=1 then
2918: ----adding one stage for analyzing objects after current stage
2919: if p_analyze_table='Y' then
2920: fnd_set.add_stage
2921: (name=>g_stage_prompt||' '||to_char(l_mv_stage_number),
2922: request_set=>upper(p_setname),
2923: set_application=>p_setapp,
2924: short_name=>'Stage_'||to_char(l_mv_stage_number),

Line 2937: fnd_set.add_stage

2933: commit;
2934: end if;---end if analyze table='Y'
2935: -------adding stages for dropping/creating snapshot logs for tables
2936: if p_refresh_mode='INIT' then
2937: fnd_set.add_stage
2938: (name=>g_stage_prompt||' '||to_char(l_snp_drop_stage_number),
2939: request_set=>upper(p_setname),
2940: set_application=>p_setapp,
2941: short_name=>'Stage_'||to_char(l_snp_drop_stage_number),

Line 2952: fnd_set.add_stage

2948: start_stage=>'N',
2949: language_code=>'US');
2950: commit;
2951:
2952: fnd_set.add_stage
2953: (name=>g_stage_prompt||' '||to_char(l_snp_create_stage_number),
2954: request_set=>upper(p_setname),
2955: set_application=>p_setapp,
2956: short_name=>'Stage_'||to_char(l_snp_create_stage_number),

Line 2982: fnd_set.add_program

2978: if l_max_program_seq is null then
2979: l_max_program_seq:=0;
2980: end if;
2981: begin
2982: fnd_set.add_program
2983: (program =>g_fnd_stats ,
2984: program_application=>g_fnd_stats_app,
2985: request_set=>upper(p_setname) ,
2986: set_application=>p_setapp ,

Line 2997: fnd_set.PROGRAM_PARAMETER(

2993: printer=>null);
2994: commit;
2995: -- ----dbms_output.put_Line('debug point 2');
2996: -------register parameters for STATS program for the current object
2997: fnd_set.PROGRAM_PARAMETER(
2998: PROGRAM=>g_fnd_stats,
2999: PROGRAM_APPLICATION=>g_fnd_stats_app,
3000: REQUEST_SET=>upper(p_setname),
3001: SET_APPLICATION=>p_setapp,

Line 3012: fnd_set.PROGRAM_PARAMETER(

3008: DEFAULT_TYPE=>'Constant',
3009: DEFAULT_VALUE=>l_stage_object_rec.object_type
3010: );
3011: -------dbms_output.put_Line('debug point 3');
3012: fnd_set.PROGRAM_PARAMETER(
3013: PROGRAM=>g_fnd_stats,
3014: PROGRAM_APPLICATION=>g_fnd_stats_app,
3015: REQUEST_SET=>upper(p_setname),
3016: SET_APPLICATION=>p_setapp,

Line 3321: fnd_set.add_stage

3317: --- ----dbms_output.put_Line('min stage :'||p_min_stage);
3318: --------dbms_output.put_Line('max stage :'||p_max_stage);
3319: if p_min_stage>0 then
3320: --Add Update object implementation flag program at the begining of the request set
3321: fnd_set.add_stage
3322: (name=>g_stage_prompt||' '||to_char(p_min_stage-50),
3323: request_set=>upper(p_set_name),
3324: set_application=>p_set_app,
3325: short_name=>'Stage_'||to_char(p_min_stage-50),

Line 3338: fnd_set.add_program

3334:
3335: commit;
3336: -------dbms_output.put_Line('added stage: '||'Stage_'||to_char(p_min_stage-50));
3337:
3338: fnd_set.add_program
3339: (program =>'BIS_RSG_PREP' ,
3340: program_application=>'BIS',
3341: request_set=>upper(p_set_name) ,
3342: set_application=>p_set_app ,

Line 3352: fnd_set.PROGRAM_PARAMETER(

3348: style=>null,
3349: printer=>null);
3350: commit;
3351:
3352: fnd_set.PROGRAM_PARAMETER(
3353: PROGRAM=>'BIS_RSG_PREP',
3354: PROGRAM_APPLICATION=>'BIS',
3355: REQUEST_SET=>upper(p_set_name),
3356: SET_APPLICATION=>p_set_app,

Line 3371: fnd_set.add_stage

3367: end if;
3368:
3369: if p_max_stage >0 then
3370: ---Add MV dummy refresh program at the end of the request set
3371: fnd_set.add_stage
3372: (name=>g_stage_prompt||' '||to_char(p_max_stage+50),
3373: request_set=>upper(p_set_name),
3374: set_application=>p_set_app,
3375: short_name=>'Stage_'||to_char(p_max_stage+50),

Line 3388: fnd_set.add_program

3384:
3385: commit;
3386: -------dbms_output.put_Line('added stage: '||'Stage_'||to_char(p_max_stage+50));
3387:
3388: fnd_set.add_program
3389: (program =>'BIS_RSG_FINAL' ,
3390: program_application=>'BIS',
3391: request_set=>upper(p_set_name) ,
3392: set_application=>p_set_app ,

Line 3401: fnd_set.PROGRAM_PARAMETER(

3397: save_output =>'Y',
3398: style=>null,
3399: printer=>null);
3400:
3401: fnd_set.PROGRAM_PARAMETER(
3402: PROGRAM=>'BIS_RSG_FINAL',
3403: PROGRAM_APPLICATION=>'BIS',
3404: REQUEST_SET=>upper(p_set_name),
3405: SET_APPLICATION=>p_set_app,

Line 4328: fnd_set.add_stage

4324: ---Add RSG History Report program at the end of the request set
4325:
4326: l_root_request_id := FND_GLOBAL.CONC_PRIORITY_REQUEST;
4327: if (p_rsg_history_flag = 'Y') then
4328: fnd_set.add_stage
4329: (name=>g_stage_prompt||' '||to_char(p_max_stage+50),
4330: request_set=>upper(p_set_name),
4331: set_application=>p_set_app,
4332: short_name=>'Stage_'||to_char(p_max_stage+50),

Line 4342: fnd_set.add_program

4338: incompatibilities_allowed=>'N',
4339: start_stage=>'N',
4340: language_code=>'US');
4341:
4342: fnd_set.add_program
4343: (program =>'BIS_BIA_RSG_HISTORY_PROG' ,
4344: program_application=>'BIS',
4345: request_set=>upper(p_set_name) ,
4346: set_application=>p_set_app ,

Line 4355: fnd_set.PROGRAM_PARAMETER(

4351: save_output =>'Y',
4352: style=>null,
4353: printer=>null);
4354:
4355: fnd_set.PROGRAM_PARAMETER(
4356: PROGRAM=>'BIS_BIA_RSG_HISTORY_PROG',
4357: PROGRAM_APPLICATION=>'BIS',
4358: REQUEST_SET=>upper(p_set_name),
4359: SET_APPLICATION=>p_set_app,

Line 4375: fnd_set.link_stages (request_set =>upper(p_set_name),

4371:
4372: --Now loop through all the stages and link this last stage with all the stages in case of error
4373: for c_stages_rec in c_stages loop
4374: if (c_stages_rec.STAGE_NAME <> report_stage_name) then
4375: fnd_set.link_stages (request_set =>upper(p_set_name),
4376: set_application =>'BIS',
4377: from_stage =>c_stages_rec.STAGE_NAME,
4378: to_stage=>report_stage_name,
4379: success => 'N',

Line 4388: fnd_set.add_stage(name=>g_stage_prompt||' '||to_char(p_max_stage+150),

4384: commit;
4385: end if;
4386: -- Bug#4881518 :: Adding a new stage and a new program to fix the issue with
4387: -- incorrect Request Set Status due to RSG History Collection program
4388: fnd_set.add_stage(name=>g_stage_prompt||' '||to_char(p_max_stage+150),
4389: request_set=>upper(p_set_name),
4390: set_application=>p_set_app,
4391: short_name=>'Stage_'||to_char(p_max_stage+150),
4392: description=>null,

Line 4401: fnd_set.add_program(program =>'BIS_BIA_RS_STATUS_CHK' ,

4397: incompatibilities_allowed=>'N',
4398: start_stage=>'N',
4399: language_code=>'US');
4400:
4401: fnd_set.add_program(program =>'BIS_BIA_RS_STATUS_CHK' ,
4402: program_application=>'BIS',
4403: request_set=>upper(p_set_name) ,
4404: set_application=>p_set_app ,
4405: stage=>'Stage_'||to_char(p_max_stage+150),

Line 4448: AND bis.set_app_id = fnd.set_application_id AND bis.request_set_id = fnd.request_set_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'
4448: AND bis.set_app_id = fnd.set_application_id AND bis.request_set_id = fnd.request_set_id
4449: AND bis.stage_id = fnd.request_set_stage_id ;
4450:
4451: l_request_id VARCHAR2(100);
4452: l_name VARCHAR2(240);