eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_DIAGNOSTIC_MIGRATE dependencies on JTF_PERZ_DATA

Line 88: a.object_version_number from jtf_perz_data a,

84:
85: CURSOR applist IS
86: select distinct c.application_id, c.application_short_name,
87: a.created_by, a.last_updated_by, a.last_update_date,
88: a.object_version_number from jtf_perz_data a,
89: jtf_perz_profile b, fnd_application c where a.profile_id = b.profile_id
90: and b.profile_name = 'JTF_PROPERTY_MANAGER_DEFAULT_1'
91: and a.perz_data_type = 'JTF' and a.perz_data_name
92: like 'TESTHARNESS%GRPCOUNT' and a.application_id = c.application_id;

Line 158: from jtf_perz_data a , jtf_perz_data_attrib b, jtf_perz_profile c

154:
155: CURSOR PREREQLIST IS
156: select b.attribute_value, b.created_by,
157: b.last_updated_by, b.last_update_date, a.object_version_number
158: from jtf_perz_data a , jtf_perz_data_attrib b, jtf_perz_profile c
159: where a.perz_data_id = b.perz_data_id
160: and a.profile_id = c.profile_id
161: and c.profile_name = 'JTF_PROPERTY_MANAGER_DEFAULT_1'
162: and a.application_id= P_APP_ID

Line 228: from jtf_perz_data a , jtf_perz_data_attrib b, jtf_perz_profile c

224:
225: BEGIN
226:
227: select distinct to_number(b.attribute_value) into v_group_count
228: from jtf_perz_data a , jtf_perz_data_attrib b, jtf_perz_profile c
229: where a.perz_data_id = b.perz_data_id
230: and a.profile_id = c.profile_id
231: and c.profile_name = 'JTF_PROPERTY_MANAGER_DEFAULT_1'
232: and a.application_id= P_APP_ID

Line 270: from jtf_perz_data a , jtf_perz_data_attrib b, jtf_perz_profile c

266:
267: cursor grplist is
268: select b.attribute_value, b.created_by,
269: b.last_updated_by, b.last_update_date, a.object_version_number
270: from jtf_perz_data a , jtf_perz_data_attrib b, jtf_perz_profile c
271: where a.perz_data_id = b.perz_data_id
272: and a.profile_id = c.profile_id
273: and c.profile_name = 'JTF_PROPERTY_MANAGER_DEFAULT_1'
274: and a.application_id = P_APP_ID

Line 344: from jtf_perz_data a , jtf_perz_data_attrib b, jtf_perz_profile c

340:
341:
342: v_temp := 0;
343: select count(*) into v_temp
344: from jtf_perz_data a , jtf_perz_data_attrib b, jtf_perz_profile c
345: where a.perz_data_id = b.perz_data_id
346: and a.profile_id = c.profile_id
347: and c.profile_name = 'JTF_PROPERTY_MANAGER_DEFAULT_1'
348: and a.application_id = P_APP_ID

Line 356: from jtf_perz_data a , jtf_perz_data_attrib b, jtf_perz_profile c

352:
353: if v_temp = 1 then
354:
355: select distinct to_number(b.attribute_value) into v_temp
356: from jtf_perz_data a , jtf_perz_data_attrib b, jtf_perz_profile c
357: where a.perz_data_id = b.perz_data_id
358: and a.profile_id = c.profile_id
359: and c.profile_name = 'JTF_PROPERTY_MANAGER_DEFAULT_1'
360: and a.application_id = P_APP_ID

Line 396: from jtf_perz_data a , jtf_perz_data_attrib b, jtf_perz_profile c

392:
393: cursor prereqlist is
394: select b.attribute_value, b.created_by,
395: b.last_updated_by, b.last_update_date, a.object_version_number
396: from jtf_perz_data a , jtf_perz_data_attrib b, jtf_perz_profile c
397: where a.perz_data_id = b.perz_data_id
398: and a.profile_id = c.profile_id
399: and c.profile_name = 'JTF_PROPERTY_MANAGER_DEFAULT_1'
400: and a.application_id = P_APP_ID

Line 465: v_prev_data_name jtf_perz_data.perz_data_name%type := 'blank';

461: v_last_migrate_date date := SYSDATE;
462: v_count NUMBER := 0;
463: v_temp_ordnum number := 0;
464: v_temp_argrows number := 0;
465: v_prev_data_name jtf_perz_data.perz_data_name%type := 'blank';
466: v_prev_attrib_value jtf_perz_data_attrib.attribute_value%type := 'blank';
467:
468: cursor testlist is
469: select distinct a.perz_data_name, b.attribute_value, b.created_by,

Line 466: v_prev_attrib_value jtf_perz_data_attrib.attribute_value%type := 'blank';

462: v_count NUMBER := 0;
463: v_temp_ordnum number := 0;
464: v_temp_argrows number := 0;
465: v_prev_data_name jtf_perz_data.perz_data_name%type := 'blank';
466: v_prev_attrib_value jtf_perz_data_attrib.attribute_value%type := 'blank';
467:
468: cursor testlist is
469: select distinct a.perz_data_name, b.attribute_value, b.created_by,
470: b.last_updated_by, b.last_update_date, a.object_version_number

Line 471: from jtf_perz_data a , jtf_perz_data_attrib b, jtf_perz_profile c

467:
468: cursor testlist is
469: select distinct a.perz_data_name, b.attribute_value, b.created_by,
470: b.last_updated_by, b.last_update_date, a.object_version_number
471: from jtf_perz_data a , jtf_perz_data_attrib b, jtf_perz_profile c
472: where a.perz_data_id = b.perz_data_id
473: and a.profile_id = c.profile_id
474: and c.profile_name = 'JTF_PROPERTY_MANAGER_DEFAULT_1'
475: and a.application_id = P_APP_ID

Line 546: from jtf_perz_data a , jtf_perz_data_attrib b,

542: -- total argument rows (key is okay)
543: -- v_temp_argrows
544:
545: select count(*) into v_temp_argrows
546: from jtf_perz_data a , jtf_perz_data_attrib b,
547: jtf_perz_profile c
548: where a.perz_data_id = b.perz_data_id
549: and a.profile_id = c.profile_id
550: and c.profile_name = 'JTF_PROPERTY_MANAGER_DEFAULT_1'

Line 561: from jtf_perz_data a , jtf_perz_data_attrib b,

557: if v_temp_argrows = 1 then
558:
559: select distinct TO_NUMBER(b.attribute_value)
560: into v_temp_argrows
561: from jtf_perz_data a , jtf_perz_data_attrib b,
562: jtf_perz_profile c
563: where a.perz_data_id = b.perz_data_id
564: and a.profile_id = c.profile_id
565: and c.profile_name = 'JTF_PROPERTY_MANAGER_DEFAULT_1'

Line 636: from jtf_perz_data a , jtf_perz_data_attrib b, jtf_perz_profile c

632: cursor argnamelist is
633:
634: select a.perz_data_name, b.attribute_value, b.created_by,
635: b.last_updated_by, b.last_update_date, a.object_version_number
636: from jtf_perz_data a , jtf_perz_data_attrib b, jtf_perz_profile c
637: where a.perz_data_id = b.perz_data_id and a.profile_id = c.profile_id
638: and c.profile_name = 'JTF_PROPERTY_MANAGER_DEFAULT_1'
639: and a.application_id = p_app_id and a.perz_data_name like
640: 'TESTHARNESS.' || p_asn || '.' || p_grpname ||'.'

Line 651: from jtf_perz_data a , jtf_perz_data_attrib b,

647: -- total argument rows (key is okay)
648: -- v_temp_argrows
649:
650: select count(*) into v_count
651: from jtf_perz_data a , jtf_perz_data_attrib b,
652: jtf_perz_profile c
653: where a.perz_data_id = b.perz_data_id
654: and a.profile_id = c.profile_id
655: and c.profile_name = 'JTF_PROPERTY_MANAGER_DEFAULT_1'

Line 671: from jtf_perz_data a , jtf_perz_data_attrib b,

667: -- and search for arguments
668:
669: select distinct TO_NUMBER(b.attribute_value)
670: into v_count
671: from jtf_perz_data a , jtf_perz_data_attrib b,
672: jtf_perz_profile c
673: where a.perz_data_id = b.perz_data_id
674: and a.profile_id = c.profile_id
675: and c.profile_name = 'JTF_PROPERTY_MANAGER_DEFAULT_1'

Line 738: from jtf_perz_data a , jtf_perz_data_attrib b, jtf_perz_profile c

734: cursor argvallist is
735:
736: select a.perz_data_name, b.attribute_value, b.created_by,
737: b.last_updated_by, b.last_update_date, a.object_version_number
738: from jtf_perz_data a , jtf_perz_data_attrib b, jtf_perz_profile c
739: where a.perz_data_id = b.perz_data_id and a.profile_id = c.profile_id
740: and c.profile_name = 'JTF_PROPERTY_MANAGER_DEFAULT_1'
741: and a.application_id = p_app_id
742: and a.perz_data_name like

Line 753: from jtf_perz_data a , jtf_perz_data_attrib b, jtf_perz_profile c

749: -- query is equal to the number of arguments in the array
750: -- if not dont do anything, potentiall dangerous situation
751:
752: select count(*) into v_count
753: from jtf_perz_data a , jtf_perz_data_attrib b, jtf_perz_profile c
754: where a.perz_data_id = b.perz_data_id and a.profile_id = c.profile_id
755: and c.profile_name = 'JTF_PROPERTY_MANAGER_DEFAULT_1'
756: and a.application_id = p_app_id
757: and a.perz_data_name like