DBA Data[Home] [Help]

APPS.FND_REQUEST dependencies on FND_APPLICATION

Line 551: From Fnd_Application FA,

547: argument91, argument92, argument93, argument94, argument95,
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

Line 769: fnd_application fa

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
773: and fcp.concurrent_program_name = upper(program)

Line 787: fnd_application fa

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
791: and fcp.concurrent_program_name = upper(program)

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 1820: From Fnd_Application FA,

1816: submit.argument21, submit.argument22,
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

Line 2086: From Fnd_Application

2082: when appl_prog_error then -- Appl or program invalid
2083: begin -- Is the appl short name correct?
2084: Select Application_ID
2085: Into prog_appl_id
2086: From Fnd_Application
2087: Where Application_Short_Name = upper (application);
2088:
2089: exception
2090: when no_data_found then

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 2923: From Fnd_Conc_Release_Classes C, Fnd_Application A

2919: if (class_name is not null) then
2920: begin
2921: Select A.Application_ID, C.Release_Class_Id
2922: Into P_REL_CLASS_APP_ID, P_REL_CLASS_ID
2923: From Fnd_Conc_Release_Classes C, Fnd_Application A
2924: Where Upper(Release_class_Name) = upper(class_name)
2925: And C.Application_ID = A.Application_ID
2926: And A.Application_Short_Name = upper(application);
2927:

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 3804: From Fnd_Application

3800:
3801: begin -- Is the appl short name correct?
3802: Select Application_ID, sysdate
3803: Into mgr_app_id, now
3804: From Fnd_Application
3805: Where Application_Short_Name = upper (service_app);
3806:
3807: exception
3808: when no_data_found then

Line 3916: From Fnd_Application

3912:
3913: begin -- Is the appl short name correct?
3914: Select Application_ID, sysdate
3915: Into mgr_app_id, now
3916: From Fnd_Application
3917: Where Application_Short_Name = upper (application);
3918:
3919: exception
3920: when no_data_found then

Line 4593: from fnd_conc_release_classes_vl rc, fnd_application_vl a

4589: end if;
4590:
4591: begin
4592: select rc.application_id, rc.release_class_id into P_RELEASE_CLASS_APP_ID, P_RELEASE_CLASS_ID
4593: from fnd_conc_release_classes_vl rc, fnd_application_vl a
4594: where rc.owner_req_id is null
4595: and rc.application_id = a.application_id
4596: and rc.user_release_class_name = P_RELEASE_CLASS_NAME;
4597: exception

Line 4645: from fnd_conc_release_classes_vl rc, fnd_application_vl a

4641: begin
4642:
4643: begin
4644: select rc.application_id, rc.release_class_id into P_RELEASE_CLASS_APP_ID, P_RELEASE_CLASS_ID
4645: from fnd_conc_release_classes_vl rc, fnd_application_vl a
4646: where rc.owner_req_id is null
4647: and rc.application_id = a.application_id
4648: and rc.user_release_class_name = schName;
4649: exception