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 );
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:
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;
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;
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;
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
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:
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