APPS.IEU_DIAGNOSTICS_PVT dependencies on JTF_OBJECTS_VL

Line 453: l_object_code jtf_objects_vl.object_code%TYPE;

449: p_responsibility IN VARCHAR2,
450: x_resp_id OUT NOCOPY NUMBER
451: )
452: AS
453: l_object_code jtf_objects_vl.object_code%TYPE;
454:
455:
456: l_responsibility_id FND_RESPONSIBILITY.RESPONSIBILITY_ID%TYPE;
457:

Line 3692: -- 1. get object_function from jtf_objects_vl and call FND_FUNCTION.TEST

3688: l_application_name VARCHAR2(2000);
3689:
3690: begin
3691: x_return_status := fnd_api.g_ret_sts_success;
3692: -- 1. get object_function from jtf_objects_vl and call FND_FUNCTION.TEST
3693: -- 2. if FND_FUNCTION.TEST run successfully, show successful message with function name, application name
3694: -- 3. if FND_FUNCITON.TEST run failed,
3695: -- 3.1 if object_code is 'TASK', test 'Launch TASK Manager',
3696: -- i.e. get object_function from jtf_objects_vl

Line 3696: -- i.e. get object_function from jtf_objects_vl

3692: -- 1. get object_function from jtf_objects_vl and call FND_FUNCTION.TEST
3693: -- 2. if FND_FUNCTION.TEST run successfully, show successful message with function name, application name
3694: -- 3. if FND_FUNCITON.TEST run failed,
3695: -- 3.1 if object_code is 'TASK', test 'Launch TASK Manager',
3696: -- i.e. get object_function from jtf_objects_vl
3697: -- show log message IEU_UWQ_DEFTASKMAN_LAUNCH
3698: -- 3.1.1 successfully, show success message
3699: -- 3.1.2 failed, show error message IEU_UWQ_FUNCTION_NOT_ALLOWED
3700: -- 3.2 not 'TASK' object_code, show error message IEU_UWQ_ALL_NO_SOURCE_DOC

Line 3704: FROM jtf_objects_vl

3700: -- 3.2 not 'TASK' object_code, show error message IEU_UWQ_ALL_NO_SOURCE_DOC
3701: v_cursor := DBMS_SQL.OPEN_CURSOR;
3702: DBMS_SQL.parse(v_cursor,
3703: 'SELECT unique object_function, name , APPLICATION_NAME
3704: FROM jtf_objects_vl
3705: WHERE lower(object_code) = lower(:action_code)',
3706: DBMS_SQL.V7);
3707:
3708: DBMS_SQL.BIND_VARIABLE(v_cursor, 'action_code', p_object_code);

Line 3747: ' from jtf_objects_vl '||

3743: else
3744: -- failed.
3745: IF (p_task_source = 'Y' or p_task_source = 'y') THEN
3746: EXECUTE immediate ' select object_function '||
3747: ' from jtf_objects_vl '||
3748: ' where lower(OBJECT_CODE) = lower(:1) '
3749: INTO l_object_function
3750: USING 'TASK';
3751: IF (FND_FUNCTION.TEST(l_object_function)) then

Line 3961: ' from jtf_objects_vl '||

3957: DBMS_SQL.COLUMN_VALUE(v_cursor3, 1, l_count);
3958: DBMS_SQL.CLOSE_CURSOR(v_cursor3);
3959: -- DBMS_OUTPUT.Put_Line('count(action_object_code) in ieu_uwq_nonmedia_actions is ' || l_count);
3960: EXECUTE immediate ' select NAME , application_name'||
3961: ' from jtf_objects_vl '||
3962: ' where lower(OBJECT_CODE) = lower(:1) '
3963: INTO l_name,l_application_name
3964: USING p_object_code;
3965: if ( l_count = 0 ) then

Line 3971: -- i.e. get object_function from jtf_objects_vl

3967: -- a.1. get object_function from base view and call FND_FUNCTION.TEST
3968: -- a.2. if FND_FUNCTION.TEST run successfully, show successful message with function name, application name
3969: -- a.3. if FND_FUNCITON.TEST run failed,
3970: -- a.3.1 if object_code is 'TASK', test 'Launch TASK Manager',
3971: -- i.e. get object_function from jtf_objects_vl
3972: -- show log message IEU_UWQ_DEFTASKMAN_LAUNCH
3973: -- a.3.1.1 successfully, show success message
3974: -- a.3.1.2 failed, show error message IEU_UWQ_FUNCTION_NOT_ALLOWED
3975: -- a.3.2 not 'TASK' object_code, show error message IEU_UWQ_ALL_NO_SOURCE_DOC