DBA Data[Home] [Help]

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 261: l_comp_sn FND_APP_COMPONENTS_VL.COMPONENT_NAME%TYPE;

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

Line 262: l_comp_fn FND_APP_COMPONENTS_VL.DISPLAY_NAME%TYPE;

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

Line 496: l_comp_sn FND_APP_COMPONENTS_VL.COMPONENT_NAME%TYPE;

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

Line 503: l_comp_fn FND_APP_COMPONENTS_VL.DISPLAY_NAME%TYPE;

499:
500: l_app_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_APPL_ID%TYPE;
501: l_comp_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_ID%TYPE;
502: l_comp_type FND_LOG_TRANSACTION_CONTEXT.COMPONENT_TYPE%TYPE;
503: l_comp_fn FND_APP_COMPONENTS_VL.DISPLAY_NAME%TYPE;
504: BEGIN
505: fdebug('In:FND_OAM_KBF_SUBS.createBusExcepDocSubject');
506:
507: SELECT

Line 585: l_comp_sn FND_APP_COMPONENTS_VL.COMPONENT_NAME%TYPE;

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

Line 593: l_comp_fn FND_APP_COMPONENTS_VL.DISPLAY_NAME%TYPE;

589:
590: l_app_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_APPL_ID%TYPE;
591: l_comp_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_ID%TYPE;
592: l_comp_type FND_LOG_TRANSACTION_CONTEXT.COMPONENT_TYPE%TYPE;
593: l_comp_fn FND_APP_COMPONENTS_VL.DISPLAY_NAME%TYPE;
594:
595: BEGIN
596: fdebug('In:FND_OAM_KBF_SUBS.createBusExcepDocPart1');
597: ---Set up the Subject