DBA Data[Home] [Help]

APPS.FND_REQUEST dependencies on FND_CONCURRENT_PROGRAMS

Line 211: From Fnd_Concurrent_Programs P,

207: profile_priority_number := to_number(profile_priority_char);
208:
209: Select min(nvl(request_priority, profile_priority_number))
210: Into program_priority
211: From Fnd_Concurrent_Programs P,
212: Fnd_Request_Set_Programs S
213: Where S.set_application_id = app_id
214: and S.request_set_id = set_id
215: and P.concurrent_program_id = S.concurrent_program_id

Line 552: Fnd_Concurrent_Programs FCP

548: argument96, argument97, argument98, argument99, argument100,
549: Sysdate, FND_GLOBAL.conc_login_id, Sysdate,
550: FND_GLOBAL.conc_login_id, FND_GLOBAL.conc_login_id
551: From Fnd_Application FA,
552: Fnd_Concurrent_Programs FCP
553: Where
554: FCP.Enabled_Flag = 'Y'
555: And (FCP.Application_ID = FA.Application_ID And
556: Concurrent_Program_Name = Upper (program))

Line 768: fnd_concurrent_programs fcp,

764: begin
765: select fcpoi.node_name1
766: into P_NODE_NAME1
767: from fnd_conc_prog_onsite_info fcpoi,
768: fnd_concurrent_programs fcp,
769: fnd_application fa
770: where fcp.application_id = fcpoi.program_application_id
771: and fcp.concurrent_program_id = fcpoi.concurrent_program_id
772: and fa.application_id = fcp.application_id

Line 786: fnd_concurrent_programs fcp,

782: begin
783: select fcpoi.connstr1
784: into P_CONNSTR1
785: from fnd_conc_prog_onsite_info fcpoi,
786: fnd_concurrent_programs fcp,
787: fnd_application fa
788: where fcp.application_id = fcpoi.program_application_id
789: and fcp.concurrent_program_id = fcpoi.concurrent_program_id
790: and fa.application_id = fcp.application_id

Line 912: From Fnd_Concurrent_Programs P, Fnd_Application A

908: fcp_printer, print_style, reqrd_flag, minwid,
909: minlen, execcode, saveout, prtflg,
910: qctlflg, program_priority, request_set_flag,
911: submit_ops_id, portlet_ref, mult_pending_req
912: From Fnd_Concurrent_Programs P, Fnd_Application A
913: Where Upper(Concurrent_Program_Name) = upper(program)
914: And P.Application_ID = A.Application_ID
915: And Upper(A.Application_Short_Name) = upper(application);
916:

Line 1821: Fnd_Concurrent_Programs FCP,

1817: submit.argument23, submit.argument24,
1818: submit.argument25
1819:
1820: From Fnd_Application FA,
1821: Fnd_Concurrent_Programs FCP,
1822: Fnd_Oracle_Userid
1823: Where
1824: Oracle_Username = oraclacct
1825: And FCP.Enabled_Flag = 'Y'

Line 2112: From Fnd_Concurrent_Programs

2108: when insert_error then -- Find the problem
2109: begin -- Is the program enabled?
2110: Select null
2111: Into Dummy
2112: From Fnd_Concurrent_Programs
2113: Where Application_ID = prog_appl_id
2114: And upper (Concurrent_Program_Name) = upper (program)
2115: And Enabled_Flag = 'Y';
2116:

Line 2310: from fnd_concurrent_programs fcp, fnd_concurrent_programs_tl fcpt, fnd_application fa

2306:
2307: select fcpt.user_concurrent_program_name, fcp.concurrent_program_id,
2308: fa.application_id, printer_name
2309: into user_prog_name, conc_prog_id, conc_app_id, fcp_printer
2310: from fnd_concurrent_programs fcp, fnd_concurrent_programs_tl fcpt, fnd_application fa
2311: where fcp.concurrent_program_id=fcpt.concurrent_program_id
2312: and fcp.application_id=fcpt.application_id
2313: and fa.application_id=fcp.application_id
2314: and fcpt.language = userenv('LANG')

Line 3652: from fnd_concurrent_programs FCP, fnd_application FA

3648: -- Check to see if this is going to be an MLS request
3649: select decode(nvl(MLS_EXECUTABLE_ID, -1), -1, 'N', 'Y'),
3650: srs_flag
3651: into func_exists, srsflag
3652: from fnd_concurrent_programs FCP, fnd_application FA
3653: where FCP.CONCURRENT_PROGRAM_NAME = UPPER(program)
3654: and FA.APPLICATION_SHORT_NAME = UPPER(application)
3655: and FCP.APPLICATION_ID = FA.APPLICATION_ID;
3656:

Line 3783: From Fnd_concurrent_programs

3779: begin
3780: begin -- Is the program name correct?
3781: Select concurrent_program_id
3782: Into prog_id
3783: From Fnd_concurrent_programs
3784: Where concurrent_program_name = command
3785: and application_id = 0;
3786:
3787: exception

Line 3895: From Fnd_concurrent_programs

3891: begin
3892: begin -- Is the program name correct?
3893: Select concurrent_program_id
3894: Into prog_id
3895: From Fnd_concurrent_programs
3896: Where concurrent_program_name = command
3897: and application_id = 0;
3898:
3899: exception

Line 4004: From Fnd_concurrent_programs

4000: begin
4001: begin -- Is the program name correct?
4002: Select concurrent_program_id
4003: Into prog_id
4004: From Fnd_concurrent_programs
4005: Where concurrent_program_name = command
4006: and application_id = 0;
4007:
4008: exception

Line 4101: From Fnd_concurrent_programs

4097: begin
4098: begin -- Is the program name correct?
4099: Select concurrent_program_id
4100: Into prog_id
4101: From Fnd_concurrent_programs
4102: Where concurrent_program_name = command
4103: and application_id = 0;
4104:
4105: exception

Line 4179: From Fnd_concurrent_programs

4175: begin
4176: begin -- Is the program name correct?
4177: Select concurrent_program_id
4178: Into prog_id
4179: From Fnd_concurrent_programs
4180: Where concurrent_program_name = command
4181: and application_id = 0;
4182:
4183: exception