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.HZ_MIXNM_WEBUI_UTILITY dependencies on HZ_UTILITY_V2PUB

Line 447: hz_utility_v2pub.created_by,

443: ) VALUES (
444: p_rule_id,
445: p_entity_attr_id_tab(i),
446: p_flag_tab(i),
447: hz_utility_v2pub.created_by,
448: SYSDATE,
449: hz_utility_v2pub.last_update_login,
450: SYSDATE,
451: hz_utility_v2pub.last_updated_by

Line 449: hz_utility_v2pub.last_update_login,

445: p_entity_attr_id_tab(i),
446: p_flag_tab(i),
447: hz_utility_v2pub.created_by,
448: SYSDATE,
449: hz_utility_v2pub.last_update_login,
450: SYSDATE,
451: hz_utility_v2pub.last_updated_by
452: );
453:

Line 451: hz_utility_v2pub.last_updated_by

447: hz_utility_v2pub.created_by,
448: SYSDATE,
449: hz_utility_v2pub.last_update_login,
450: SYSDATE,
451: hz_utility_v2pub.last_updated_by
452: );
453:
454: ELSIF p_rule_type = G_USER_OVERWRITE_RULE_TYPE THEN
455:

Line 484: hz_utility_v2pub.created_by,

480: ) VALUES (
481: p_rule_id,
482: l_entity_attr_id_tab(i),
483: l_flag_tab(i),
484: hz_utility_v2pub.created_by,
485: SYSDATE,
486: hz_utility_v2pub.last_update_login,
487: SYSDATE,
488: hz_utility_v2pub.last_updated_by,

Line 486: hz_utility_v2pub.last_update_login,

482: l_entity_attr_id_tab(i),
483: l_flag_tab(i),
484: hz_utility_v2pub.created_by,
485: SYSDATE,
486: hz_utility_v2pub.last_update_login,
487: SYSDATE,
488: hz_utility_v2pub.last_updated_by,
489: l_os_tab(i)
490: );

Line 488: hz_utility_v2pub.last_updated_by,

484: hz_utility_v2pub.created_by,
485: SYSDATE,
486: hz_utility_v2pub.last_update_login,
487: SYSDATE,
488: hz_utility_v2pub.last_updated_by,
489: l_os_tab(i)
490: );
491:
492: END IF;

Line 552: last_update_login = hz_utility_v2pub.last_update_login,

548:
549: FORALL i IN 1..p_entity_attr_id_tab.COUNT
550: UPDATE hz_user_create_rules
551: SET creation_flag = p_flag_tab(i),
552: last_update_login = hz_utility_v2pub.last_update_login,
553: last_update_date = SYSDATE,
554: last_updated_by = hz_utility_v2pub.last_updated_by
555: WHERE rule_id = p_rule_id
556: AND creation_flag <> p_flag_tab(i)

Line 554: last_updated_by = hz_utility_v2pub.last_updated_by

550: UPDATE hz_user_create_rules
551: SET creation_flag = p_flag_tab(i),
552: last_update_login = hz_utility_v2pub.last_update_login,
553: last_update_date = SYSDATE,
554: last_updated_by = hz_utility_v2pub.last_updated_by
555: WHERE rule_id = p_rule_id
556: AND creation_flag <> p_flag_tab(i)
557: AND entity_attr_id = p_entity_attr_id_tab(i);
558:

Line 601: hz_utility_v2pub.created_by,

597: ) VALUES (
598: p_rule_id,
599: l_entity_attr_id_tab(i),
600: l_flag_tab(i),
601: hz_utility_v2pub.created_by,
602: SYSDATE,
603: hz_utility_v2pub.last_update_login,
604: SYSDATE,
605: hz_utility_v2pub.last_updated_by,

Line 603: hz_utility_v2pub.last_update_login,

599: l_entity_attr_id_tab(i),
600: l_flag_tab(i),
601: hz_utility_v2pub.created_by,
602: SYSDATE,
603: hz_utility_v2pub.last_update_login,
604: SYSDATE,
605: hz_utility_v2pub.last_updated_by,
606: l_os_tab(i)
607: );

Line 605: hz_utility_v2pub.last_updated_by,

601: hz_utility_v2pub.created_by,
602: SYSDATE,
603: hz_utility_v2pub.last_update_login,
604: SYSDATE,
605: hz_utility_v2pub.last_updated_by,
606: l_os_tab(i)
607: );
608: END IF;
609: END LOOP;

Line 614: last_update_login = hz_utility_v2pub.last_update_login,

610: /*
611: FORALL i IN 1..l_entity_attr_id_tab.COUNT
612: UPDATE hz_user_overwrite_rules
613: SET overwrite_flag = l_flag_tab(i),
614: last_update_login = hz_utility_v2pub.last_update_login,
615: last_update_date = SYSDATE,
616: last_updated_by = hz_utility_v2pub.last_updated_by
617: WHERE rule_id = p_rule_id
618: AND entity_attr_id = l_entity_attr_id_tab(i);

Line 616: last_updated_by = hz_utility_v2pub.last_updated_by

612: UPDATE hz_user_overwrite_rules
613: SET overwrite_flag = l_flag_tab(i),
614: last_update_login = hz_utility_v2pub.last_update_login,
615: last_update_date = SYSDATE,
616: last_updated_by = hz_utility_v2pub.last_updated_by
617: WHERE rule_id = p_rule_id
618: AND entity_attr_id = l_entity_attr_id_tab(i);
619: */
620: END IF;

Line 683: hz_utility_v2pub.created_by,

679: SELECT
680: x_new_rule_id,
681: entity_attr_id,
682: creation_flag,
683: hz_utility_v2pub.created_by,
684: SYSDATE,
685: hz_utility_v2pub.last_update_login,
686: SYSDATE,
687: hz_utility_v2pub.last_updated_by

Line 685: hz_utility_v2pub.last_update_login,

681: entity_attr_id,
682: creation_flag,
683: hz_utility_v2pub.created_by,
684: SYSDATE,
685: hz_utility_v2pub.last_update_login,
686: SYSDATE,
687: hz_utility_v2pub.last_updated_by
688: FROM hz_user_create_rules
689: WHERE rule_id = p_rule_id;

Line 687: hz_utility_v2pub.last_updated_by

683: hz_utility_v2pub.created_by,
684: SYSDATE,
685: hz_utility_v2pub.last_update_login,
686: SYSDATE,
687: hz_utility_v2pub.last_updated_by
688: FROM hz_user_create_rules
689: WHERE rule_id = p_rule_id;
690:
691: INSERT INTO hz_user_overwrite_rules (

Line 706: hz_utility_v2pub.created_by,

702: SELECT
703: x_new_rule_id,
704: entity_attr_id,
705: overwrite_flag,
706: hz_utility_v2pub.created_by,
707: SYSDATE,
708: hz_utility_v2pub.last_update_login,
709: SYSDATE,
710: hz_utility_v2pub.last_updated_by,

Line 708: hz_utility_v2pub.last_update_login,

704: entity_attr_id,
705: overwrite_flag,
706: hz_utility_v2pub.created_by,
707: SYSDATE,
708: hz_utility_v2pub.last_update_login,
709: SYSDATE,
710: hz_utility_v2pub.last_updated_by,
711: orig_system
712: FROM hz_user_overwrite_rules

Line 710: hz_utility_v2pub.last_updated_by,

706: hz_utility_v2pub.created_by,
707: SYSDATE,
708: hz_utility_v2pub.last_update_login,
709: SYSDATE,
710: hz_utility_v2pub.last_updated_by,
711: orig_system
712: FROM hz_user_overwrite_rules
713: WHERE rule_id = p_rule_id;
714:

Line 735: hz_utility_v2pub.created_by,

731: SELECT
732: x_new_rule_id,
733: entity_attr_id,
734: overwrite_flag,
735: hz_utility_v2pub.created_by,
736: SYSDATE,
737: hz_utility_v2pub.last_update_login,
738: SYSDATE,
739: hz_utility_v2pub.last_updated_by,

Line 737: hz_utility_v2pub.last_update_login,

733: entity_attr_id,
734: overwrite_flag,
735: hz_utility_v2pub.created_by,
736: SYSDATE,
737: hz_utility_v2pub.last_update_login,
738: SYSDATE,
739: hz_utility_v2pub.last_updated_by,
740: orig_system
741: FROM hz_user_overwrite_rules

Line 739: hz_utility_v2pub.last_updated_by,

735: hz_utility_v2pub.created_by,
736: SYSDATE,
737: hz_utility_v2pub.last_update_login,
738: SYSDATE,
739: hz_utility_v2pub.last_updated_by,
740: orig_system
741: FROM hz_user_overwrite_rules
742: WHERE rule_id = p_rule_id;
743:

Line 875: hz_utility_v2pub.created_by,

871: )
872: VALUES (
873: l_entity_attr_id_tab(i),
874: l_flag_tab(i),
875: hz_utility_v2pub.created_by,
876: SYSDATE,
877: hz_utility_v2pub.last_update_login,
878: SYSDATE,
879: hz_utility_v2pub.last_updated_by,

Line 877: hz_utility_v2pub.last_update_login,

873: l_entity_attr_id_tab(i),
874: l_flag_tab(i),
875: hz_utility_v2pub.created_by,
876: SYSDATE,
877: hz_utility_v2pub.last_update_login,
878: SYSDATE,
879: hz_utility_v2pub.last_updated_by,
880: l_os_tab(i)
881: );

Line 879: hz_utility_v2pub.last_updated_by,

875: hz_utility_v2pub.created_by,
876: SYSDATE,
877: hz_utility_v2pub.last_update_login,
878: SYSDATE,
879: hz_utility_v2pub.last_updated_by,
880: l_os_tab(i)
881: );
882:
883: ELSE

Line 905: hz_utility_v2pub.created_by,

901: )
902: VALUES (
903: l_entity_attr_id_tab(i),
904: l_flag_tab(i),
905: hz_utility_v2pub.created_by,
906: SYSDATE,
907: hz_utility_v2pub.last_update_login,
908: SYSDATE,
909: hz_utility_v2pub.last_updated_by,

Line 907: hz_utility_v2pub.last_update_login,

903: l_entity_attr_id_tab(i),
904: l_flag_tab(i),
905: hz_utility_v2pub.created_by,
906: SYSDATE,
907: hz_utility_v2pub.last_update_login,
908: SYSDATE,
909: hz_utility_v2pub.last_updated_by,
910: l_os_tab(i)
911: );

Line 909: hz_utility_v2pub.last_updated_by,

905: hz_utility_v2pub.created_by,
906: SYSDATE,
907: hz_utility_v2pub.last_update_login,
908: SYSDATE,
909: hz_utility_v2pub.last_updated_by,
910: l_os_tab(i)
911: );
912: END IF;
913: END LOOP;

Line 917: last_update_login = hz_utility_v2pub.last_update_login,

913: END LOOP;
914: /*
915: UPDATE hz_thirdparty_rule
916: SET overwrite_flag = l_flag_tab(i),
917: last_update_login = hz_utility_v2pub.last_update_login,
918: last_update_date = SYSDATE,
919: last_updated_by = hz_utility_v2pub.last_updated_by
920: WHERE entity_attr_id = l_entity_attr_id_tab(i);
921: */

Line 919: last_updated_by = hz_utility_v2pub.last_updated_by

915: UPDATE hz_thirdparty_rule
916: SET overwrite_flag = l_flag_tab(i),
917: last_update_login = hz_utility_v2pub.last_update_login,
918: last_update_date = SYSDATE,
919: last_updated_by = hz_utility_v2pub.last_updated_by
920: WHERE entity_attr_id = l_entity_attr_id_tab(i);
921: */
922: END IF;
923:

Line 984: last_update_login = hz_utility_v2pub.last_update_login,

980:
981: FOR k IN l_start..l_end LOOP
982: UPDATE hz_select_data_sources
983: SET ranking = p_ranking_tab(k),
984: last_update_login = hz_utility_v2pub.last_update_login,
985: last_update_date = SYSDATE,
986: last_updated_by = hz_utility_v2pub.last_updated_by
987: WHERE entity_attr_id = l_entity_attr_id_tab(j)
988: AND content_source_type = p_data_sources_tab(k);

Line 986: last_updated_by = hz_utility_v2pub.last_updated_by

982: UPDATE hz_select_data_sources
983: SET ranking = p_ranking_tab(k),
984: last_update_login = hz_utility_v2pub.last_update_login,
985: last_update_date = SYSDATE,
986: last_updated_by = hz_utility_v2pub.last_updated_by
987: WHERE entity_attr_id = l_entity_attr_id_tab(j)
988: AND content_source_type = p_data_sources_tab(k);
989: END LOOP;
990:

Line 995: last_update_login = hz_utility_v2pub.last_update_login,

991: -- mark the attribute as been updated.
992:
993: UPDATE hz_entity_attributes
994: SET updated_flag = 'Y',
995: last_update_login = hz_utility_v2pub.last_update_login,
996: last_update_date = SYSDATE,
997: last_updated_by = hz_utility_v2pub.last_updated_by
998: WHERE entity_attr_id = l_entity_attr_id_tab(j);
999:

Line 997: last_updated_by = hz_utility_v2pub.last_updated_by

993: UPDATE hz_entity_attributes
994: SET updated_flag = 'Y',
995: last_update_login = hz_utility_v2pub.last_update_login,
996: last_update_date = SYSDATE,
997: last_updated_by = hz_utility_v2pub.last_updated_by
998: WHERE entity_attr_id = l_entity_attr_id_tab(j);
999:
1000: END LOOP;
1001:

Line 1116: ' hz_utility_v2pub.Get_LookupMeaning( '||

1112: str := SUBSTR(str, 1, LENGTH(str)-1);
1113:
1114: c := dbms_sql.open_cursor;
1115: l_sql := 'SELECT UNIQUE content_source_type, '||
1116: ' hz_utility_v2pub.Get_LookupMeaning( '||
1117: ' ''AR_LOOKUPS'', ''CONTENT_SOURCE_TYPE'', '||
1118: ' content_source_type ) meaning '||
1119: 'FROM hz_select_data_sources '||
1120: 'WHERE entity_attr_id IN ('||str||') ';

Line 1217: last_update_login = hz_utility_v2pub.last_update_login,

1213:
1214: FORALL j IN 1..p_data_sources_tab.COUNT
1215: UPDATE hz_select_data_sources
1216: SET ranking = p_ranking_tab(j),
1217: last_update_login = hz_utility_v2pub.last_update_login,
1218: last_update_date = SYSDATE,
1219: last_updated_by = hz_utility_v2pub.last_updated_by
1220: WHERE entity_attr_id = l_entity_attr_id_tab(i)
1221: AND content_source_type = p_data_sources_tab(j);

Line 1219: last_updated_by = hz_utility_v2pub.last_updated_by

1215: UPDATE hz_select_data_sources
1216: SET ranking = p_ranking_tab(j),
1217: last_update_login = hz_utility_v2pub.last_update_login,
1218: last_update_date = SYSDATE,
1219: last_updated_by = hz_utility_v2pub.last_updated_by
1220: WHERE entity_attr_id = l_entity_attr_id_tab(i)
1221: AND content_source_type = p_data_sources_tab(j);
1222:
1223: -- mark the attribute as been updated.

Line 1227: last_update_login = hz_utility_v2pub.last_update_login,

1223: -- mark the attribute as been updated.
1224:
1225: UPDATE hz_entity_attributes
1226: SET updated_flag = 'Y',
1227: last_update_login = hz_utility_v2pub.last_update_login,
1228: last_update_date = SYSDATE,
1229: last_updated_by = hz_utility_v2pub.last_updated_by
1230: WHERE entity_attr_id = l_entity_attr_id_tab(i);
1231:

Line 1229: last_updated_by = hz_utility_v2pub.last_updated_by

1225: UPDATE hz_entity_attributes
1226: SET updated_flag = 'Y',
1227: last_update_login = hz_utility_v2pub.last_update_login,
1228: last_update_date = SYSDATE,
1229: last_updated_by = hz_utility_v2pub.last_updated_by
1230: WHERE entity_attr_id = l_entity_attr_id_tab(i);
1231:
1232: END LOOP;
1233: