[Home] [Help]
157: profile_priority_number := to_number(profile_priority_char);
158:
159: Select min(nvl(request_priority, profile_priority_number))
160: Into program_priority
161: From Fnd_Concurrent_Programs P,
162: Fnd_Request_Set_Programs S
163: Where S.set_application_id = app_id
164: and S.request_set_id = set_id
165: and P.concurrent_program_id = S.concurrent_program_id
499: argument96, argument97, argument98, argument99, argument100,
500: Sysdate, FND_GLOBAL.conc_login_id, Sysdate,
501: FND_GLOBAL.conc_login_id, FND_GLOBAL.conc_login_id
502: From Fnd_Application FA,
503: Fnd_Concurrent_Programs FCP
504: Where
505: FCP.Enabled_Flag = 'Y'
506: And (FCP.Application_ID = FA.Application_ID And
507: Concurrent_Program_Name = Upper (program))
720: begin
721: select fcpoi.node_name1
722: into P_NODE_NAME1
723: from fnd_conc_prog_onsite_info fcpoi,
724: fnd_concurrent_programs fcp,
725: fnd_application fa
726: where fcp.application_id = fcpoi.program_application_id
727: and fcp.concurrent_program_id = fcpoi.concurrent_program_id
728: and fa.application_id = fcp.application_id
738: begin
739: select fcpoi.connstr1
740: into P_CONNSTR1
741: from fnd_conc_prog_onsite_info fcpoi,
742: fnd_concurrent_programs fcp,
743: fnd_application fa
744: where fcp.application_id = fcpoi.program_application_id
745: and fcp.concurrent_program_id = fcpoi.concurrent_program_id
746: and fa.application_id = fcp.application_id
849: fcp_printer, print_style, reqrd_flag, minwid,
850: minlen, execcode, saveout, prtflg,
851: qctlflg, program_priority, request_set_flag,
852: submit_ops_id, portlet_ref, mult_pending_req
853: From Fnd_Concurrent_Programs P, Fnd_Application A
854: Where Upper(Concurrent_Program_Name) = upper(program)
855: And P.Application_ID = A.Application_ID
856: And Upper(A.Application_Short_Name) = upper(application);
857:
1712: submit.argument23, submit.argument24,
1713: submit.argument25
1714:
1715: From Fnd_Application FA,
1716: Fnd_Concurrent_Programs FCP,
1717: Fnd_Oracle_Userid
1718: Where
1719: Oracle_Username = oraclacct
1720: And FCP.Enabled_Flag = 'Y'
2003: when insert_error then -- Find the problem
2004: begin -- Is the program enabled?
2005: Select null
2006: Into Dummy
2007: From Fnd_Concurrent_Programs
2008: Where Application_ID = prog_appl_id
2009: And upper (Concurrent_Program_Name) = upper (program)
2010: And Enabled_Flag = 'Y';
2011:
3092: begin
3093: begin -- Is the program name correct?
3094: Select concurrent_program_id
3095: Into prog_id
3096: From Fnd_concurrent_programs
3097: Where concurrent_program_name = command
3098: and application_id = 0;
3099:
3100: exception
3204: begin
3205: begin -- Is the program name correct?
3206: Select concurrent_program_id
3207: Into prog_id
3208: From Fnd_concurrent_programs
3209: Where concurrent_program_name = command
3210: and application_id = 0;
3211:
3212: exception
3313: begin
3314: begin -- Is the program name correct?
3315: Select concurrent_program_id
3316: Into prog_id
3317: From Fnd_concurrent_programs
3318: Where concurrent_program_name = command
3319: and application_id = 0;
3320:
3321: exception
3410: begin
3411: begin -- Is the program name correct?
3412: Select concurrent_program_id
3413: Into prog_id
3414: From Fnd_concurrent_programs
3415: Where concurrent_program_name = command
3416: and application_id = 0;
3417:
3418: exception
3488: begin
3489: begin -- Is the program name correct?
3490: Select concurrent_program_id
3491: Into prog_id
3492: From Fnd_concurrent_programs
3493: Where concurrent_program_name = command
3494: and application_id = 0;
3495:
3496: exception