DBA Data[Home] [Help]

APPS.FND_OAM_KBF_SUBS dependencies on FND_APPLICATION_VL

Line 260: l_app_sn FND_APPLICATION_VL.APPLICATION_SHORT_NAME%TYPE;

256: --------------------------------------------------------------------------------
257: procedure setWFAttributes(itemtype in varchar2,
258: itemkey in varchar2)
259: IS
260: l_app_sn FND_APPLICATION_VL.APPLICATION_SHORT_NAME%TYPE;
261: l_comp_sn FND_APP_COMPONENTS_VL.COMPONENT_NAME%TYPE;
262: l_comp_fn FND_APP_COMPONENTS_VL.DISPLAY_NAME%TYPE;
263: l_severity FND_LOG_EXCEPTIONS.SEVERITY%TYPE;
264: l_system VARCHAR2(200);

Line 495: l_app_sn FND_APPLICATION_VL.APPLICATION_SHORT_NAME%TYPE;

491: display_type in varchar2,
492: document in out NOCOPY varchar2,
493: document_type in out NOCOPY varchar2)
494: IS
495: l_app_sn FND_APPLICATION_VL.APPLICATION_SHORT_NAME%TYPE;
496: l_comp_sn FND_APP_COMPONENTS_VL.COMPONENT_NAME%TYPE;
497: l_severity fnd_lookups.MEANING%TYPE; --FND_LOG_EXCEPTIONS.SEVERITY%TYPE;
498: l_system VARCHAR2(200);
499:

Line 516: fnd_application_vl fa,

512: FROM fnd_log_transaction_context fltc,
513: fnd_log_messages flm,
514: fnd_log_exceptions fle,
515: FND_LOG_UNIQUE_EXCEPTIONS flue,
516: fnd_application_vl fa,
517: fnd_lookups fl
518: WHERE
519: flm.log_sequence = document_id
520: and flm.log_sequence = fle.log_sequence

Line 582: l_app_sn FND_APPLICATION_VL.APPLICATION_SHORT_NAME%TYPE;

578: IS
579: l_msg_id FND_LOG_EXCEPTIONS.LOG_SEQUENCE%TYPE;
580: l_subject VARCHAR2(200);
581:
582: l_app_sn FND_APPLICATION_VL.APPLICATION_SHORT_NAME%TYPE;
583: l_app_fn FND_APPLICATION_VL.APPLICATION_NAME%TYPE;
584:
585: l_comp_sn FND_APP_COMPONENTS_VL.COMPONENT_NAME%TYPE;
586:

Line 583: l_app_fn FND_APPLICATION_VL.APPLICATION_NAME%TYPE;

579: l_msg_id FND_LOG_EXCEPTIONS.LOG_SEQUENCE%TYPE;
580: l_subject VARCHAR2(200);
581:
582: l_app_sn FND_APPLICATION_VL.APPLICATION_SHORT_NAME%TYPE;
583: l_app_fn FND_APPLICATION_VL.APPLICATION_NAME%TYPE;
584:
585: l_comp_sn FND_APP_COMPONENTS_VL.COMPONENT_NAME%TYPE;
586:
587: -- l_biz_flow_id FND_LOG_EXCEPTION_CONTEXT.LOG_SEQUENCE%TYPE;

Line 609: fnd_application_vl fa,

605: INTO
606: l_app_sn, l_app_fn, l_comp_type_d, l_app_id, l_comp_type, l_comp_id
607: FROM fnd_log_transaction_context fltc,
608: fnd_log_messages flm,
609: fnd_application_vl fa,
610: fnd_lookups flu
611: WHERE
612: flm.log_sequence = document_id
613: and fltc.transaction_context_id = flm.transaction_context_id