APPS.FND_OAM_KBF_SUBS dependencies on FND_APP_COMPONENTS_VL

Line 174: l_comp_name FND_APP_COMPONENTS_VL.COMPONENT_NAME%TYPE;

170: comp_id in number,
171: comp_name out NOCOPY varchar2,
172: comp_display_name out NOCOPY varchar2)
173: IS
174: l_comp_name FND_APP_COMPONENTS_VL.COMPONENT_NAME%TYPE;
175: l_comp_display_name FND_APP_COMPONENTS_VL.DISPLAY_NAME%TYPE;
176: BEGIN
177: fdebug('In:FND_OAM_KBF_SUBS.retriveComponentInfo');
178: fdebug('app_id=' || app_id || ' comp_type=' || comp_type || ' comp_id=' || comp_id );

Line 175: l_comp_display_name FND_APP_COMPONENTS_VL.DISPLAY_NAME%TYPE;

171: comp_name out NOCOPY varchar2,
172: comp_display_name out NOCOPY varchar2)
173: IS
174: l_comp_name FND_APP_COMPONENTS_VL.COMPONENT_NAME%TYPE;
175: l_comp_display_name FND_APP_COMPONENTS_VL.DISPLAY_NAME%TYPE;
176: BEGIN
177: fdebug('In:FND_OAM_KBF_SUBS.retriveComponentInfo');
178: fdebug('app_id=' || app_id || ' comp_type=' || comp_type || ' comp_id=' || comp_id );
179:

Line 254: l_comp_sn FND_APP_COMPONENTS_VL.COMPONENT_NAME%TYPE;

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);
258: l_app_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_APPL_ID%TYPE;

Line 255: l_comp_fn FND_APP_COMPONENTS_VL.DISPLAY_NAME%TYPE;

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);
258: l_app_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_APPL_ID%TYPE;
259: l_comp_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_ID%TYPE;

Line 489: l_comp_sn FND_APP_COMPONENTS_VL.COMPONENT_NAME%TYPE;

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:
493: l_app_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_APPL_ID%TYPE;

Line 496: l_comp_fn FND_APP_COMPONENTS_VL.DISPLAY_NAME%TYPE;

492:
493: l_app_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_APPL_ID%TYPE;
494: l_comp_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_ID%TYPE;
495: l_comp_type FND_LOG_TRANSACTION_CONTEXT.COMPONENT_TYPE%TYPE;
496: l_comp_fn FND_APP_COMPONENTS_VL.DISPLAY_NAME%TYPE;
497: BEGIN
498: fdebug('In:FND_OAM_KBF_SUBS.createBusExcepDocSubject');
499:
500: SELECT

Line 578: l_comp_sn FND_APP_COMPONENTS_VL.COMPONENT_NAME%TYPE;

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;
581: l_comp_type_d fnd_lookups.MEANING%TYPE;
582:

Line 586: l_comp_fn FND_APP_COMPONENTS_VL.DISPLAY_NAME%TYPE;

582:
583: l_app_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_APPL_ID%TYPE;
584: l_comp_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_ID%TYPE;
585: l_comp_type FND_LOG_TRANSACTION_CONTEXT.COMPONENT_TYPE%TYPE;
586: l_comp_fn FND_APP_COMPONENTS_VL.DISPLAY_NAME%TYPE;
587:
588: BEGIN
589: fdebug('In:FND_OAM_KBF_SUBS.createBusExcepDocPart1');
590: ---Set up the Subject