[Home] [Help]
229: cursor set_programs( set_app_id number, set_id number) is
230: select CP.concurrent_program_name, CP.enabled_flag, RSS.stage_name,
231: RSP.sequence
232: from fnd_request_sets RS, fnd_request_set_stages RSS,
233: fnd_concurrent_programs CP, fnd_request_set_programs RSP
234: where RS.application_id = set_app_id
235: and RS.request_set_id = set_id
236: and RSS.set_application_id = RS.application_id
237: and RSS.request_set_id = RS.request_set_id
292: incompatibilities_allowed, print_together,
293: rs_owner, rs_printer, rs_print_style,
294: rs_conc_program, user_rs_name
295: from Fnd_Request_Sets_Vl RS, Fnd_Application A,
296: Fnd_Concurrent_Programs CP
297: where
298: RS.Application_id = A.Application_id
299: And RS.Request_Set_Name = upper(request_set)
300: And A.Application_Short_Name = upper(application)
317: i := 0;
318: invalid_program := FALSE;
319:
320: for crec in set_programs( P_SET_APP_ID, P_SET_ID ) loop
321: -- check program exists in fnd_concurrent_programs or not
322: -- check program enabled or not
323: -- Bug 5680619
324: /*if( crec.concurrent_program_name is null
325: or crec.enabled_flag = 'N') then
727: rsp_conc_prog_id, rsp_nls_lang,
728: rsp_nls_territory, rsp_copies, rsp_printer,
729: rsp_style, rsp_save_output_flag
730: from fnd_request_set_programs RSP, fnd_request_set_stages RSS,
731: fnd_concurrent_programs CP
732: where RSP.set_application_id = P_SET_APP_ID
733: and RSP.request_set_id = P_SET_ID
734: and RSP.set_application_id = RSS.set_application_id
735: and RSP.request_set_id = RSS.request_set_id
795: end if;
796:
797: -- Get program's Printer, Print Style,
798: -- Save output flag, priority, and request set flag
799: -- from fnd_concurrent_programs
800: begin
801: Select
802: Printer_Name, NVL(Output_Print_Style, 'PORTRAIT'),
803: Required_Style, Minimum_Width,
807: Into
808: fcp_printer, print_style, reqrd_flag, minwid,
809: minlen, execcode, saveout, prtflg,
810: qctlflg
811: From Fnd_Concurrent_Programs P
812: Where P.Application_ID = rsp_prog_app_id
813: and P.concurrent_program_id = rsp_conc_prog_id;
814:
815:
2298: return varchar2 is
2299: cursor program_cursor is
2300: select fcp.concurrent_program_name, frsp.critical
2301: FROM fnd_request_set_programs frsp,
2302: fnd_concurrent_programs_vl fcp,
2303: fnd_request_sets_vl frs,
2304: fnd_application fa
2305: WHERE fa.application_short_name = template_appl_name
2306: AND fa.application_id = frs.application_id