[Home] [Help]
203: cursor set_programs( set_app_id number, set_id number) is
204: select CP.concurrent_program_name, CP.enabled_flag, RSS.stage_name,
205: RSP.sequence
206: from fnd_request_sets RS, fnd_request_set_stages RSS,
207: fnd_concurrent_programs CP, fnd_request_set_programs RSP
208: where RS.application_id = set_app_id
209: and RS.request_set_id = set_id
210: and RSS.set_application_id = RS.application_id
211: and RSS.request_set_id = RS.request_set_id
266: incompatibilities_allowed, print_together,
267: rs_owner, rs_printer, rs_print_style,
268: rs_conc_program, user_rs_name
269: from Fnd_Request_Sets_Vl RS, Fnd_Application A,
270: Fnd_Concurrent_Programs CP
271: where
272: RS.Application_id = A.Application_id
273: And RS.Request_Set_Name = upper(request_set)
274: And A.Application_Short_Name = upper(application)
291: i := 0;
292: invalid_program := FALSE;
293:
294: for crec in set_programs( P_SET_APP_ID, P_SET_ID ) loop
295: -- check program exists in fnd_concurrent_programs or not
296: -- check program enabled or not
297: -- Bug 5680619
298: /*if( crec.concurrent_program_name is null
299: or crec.enabled_flag = 'N') then
701: rsp_conc_prog_id, rsp_nls_lang,
702: rsp_nls_territory, rsp_copies, rsp_printer,
703: rsp_style, rsp_save_output_flag
704: from fnd_request_set_programs RSP, fnd_request_set_stages RSS,
705: fnd_concurrent_programs CP
706: where RSP.set_application_id = P_SET_APP_ID
707: and RSP.request_set_id = P_SET_ID
708: and RSP.set_application_id = RSS.set_application_id
709: and RSP.request_set_id = RSS.request_set_id
769: end if;
770:
771: -- Get program's Printer, Print Style,
772: -- Save output flag, priority, and request set flag
773: -- from fnd_concurrent_programs
774: begin
775: Select
776: Printer_Name, NVL(Output_Print_Style, 'PORTRAIT'),
777: Required_Style, Minimum_Width,
781: Into
782: fcp_printer, print_style, reqrd_flag, minwid,
783: minlen, execcode, saveout, prtflg,
784: qctlflg
785: From Fnd_Concurrent_Programs P
786: Where P.Application_ID = rsp_prog_app_id
787: and P.concurrent_program_id = rsp_conc_prog_id;
788:
789:
1851: return varchar2 is
1852: cursor program_cursor is
1853: select fcp.concurrent_program_name, frsp.critical
1854: FROM fnd_request_set_programs frsp,
1855: fnd_concurrent_programs_vl fcp,
1856: fnd_request_sets_vl frs,
1857: fnd_application fa
1858: WHERE fa.application_short_name = template_appl_name
1859: AND fa.application_id = frs.application_id