DBA Data[Home] [Help]

APPS.FND_OAM_KBF_SUBS dependencies on FND_APPLICATION_VL

Line 253: l_app_sn FND_APPLICATION_VL.APPLICATION_SHORT_NAME%TYPE;

249: --------------------------------------------------------------------------------
250: procedure setWFAttributes(itemtype in varchar2,
251: itemkey in varchar2)
252: IS
253: l_app_sn FND_APPLICATION_VL.APPLICATION_SHORT_NAME%TYPE;
254: l_comp_sn FND_APP_COMPONENTS_VL.COMPONENT_NAME%TYPE;
255: l_comp_fn FND_APP_COMPONENTS_VL.DISPLAY_NAME%TYPE;
256: l_severity FND_LOG_EXCEPTIONS.SEVERITY%TYPE;
257: l_system VARCHAR2(200);

Line 488: l_app_sn FND_APPLICATION_VL.APPLICATION_SHORT_NAME%TYPE;

484: display_type in varchar2,
485: document in out NOCOPY varchar2,
486: document_type in out NOCOPY varchar2)
487: IS
488: l_app_sn FND_APPLICATION_VL.APPLICATION_SHORT_NAME%TYPE;
489: l_comp_sn FND_APP_COMPONENTS_VL.COMPONENT_NAME%TYPE;
490: l_severity fnd_lookups.MEANING%TYPE; --FND_LOG_EXCEPTIONS.SEVERITY%TYPE;
491: l_system VARCHAR2(200);
492:

Line 509: fnd_application_vl fa,

505: FROM fnd_log_transaction_context fltc,
506: fnd_log_messages flm,
507: fnd_log_exceptions fle,
508: FND_LOG_UNIQUE_EXCEPTIONS flue,
509: fnd_application_vl fa,
510: fnd_lookups fl
511: WHERE
512: flm.log_sequence = document_id
513: and flm.log_sequence = fle.log_sequence

Line 575: l_app_sn FND_APPLICATION_VL.APPLICATION_SHORT_NAME%TYPE;

571: IS
572: l_msg_id FND_LOG_EXCEPTIONS.LOG_SEQUENCE%TYPE;
573: l_subject VARCHAR2(200);
574:
575: l_app_sn FND_APPLICATION_VL.APPLICATION_SHORT_NAME%TYPE;
576: l_app_fn FND_APPLICATION_VL.APPLICATION_NAME%TYPE;
577:
578: l_comp_sn FND_APP_COMPONENTS_VL.COMPONENT_NAME%TYPE;
579:

Line 576: l_app_fn FND_APPLICATION_VL.APPLICATION_NAME%TYPE;

572: l_msg_id FND_LOG_EXCEPTIONS.LOG_SEQUENCE%TYPE;
573: l_subject VARCHAR2(200);
574:
575: l_app_sn FND_APPLICATION_VL.APPLICATION_SHORT_NAME%TYPE;
576: l_app_fn FND_APPLICATION_VL.APPLICATION_NAME%TYPE;
577:
578: l_comp_sn FND_APP_COMPONENTS_VL.COMPONENT_NAME%TYPE;
579:
580: -- l_biz_flow_id FND_LOG_EXCEPTION_CONTEXT.LOG_SEQUENCE%TYPE;

Line 599: fnd_application_vl fa,

595: INTO
596: l_app_sn, l_app_fn, l_comp_type_d, l_app_id, l_comp_type, l_comp_id
597: FROM fnd_log_transaction_context fltc,
598: fnd_log_messages flm,
599: fnd_application_vl fa,
600: fnd_lookups flu
601: WHERE
602: flm.log_sequence = document_id
603: and fltc.transaction_context_id = flm.transaction_context_id