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_MERGE_ENTITY_ATTRI_PVT dependencies on FND_GLOBAL

Line 889: last_update_login = FND_GLOBAL.LOGIN_ID,

885: where party_id = l_attribute_party_id
886: and sysdate between effective_start_date and nvl(effective_end_date,sysdate)
887: and rownum=1),
888: last_update_date = SYSDATE,
889: last_update_login = FND_GLOBAL.LOGIN_ID,
890: last_updated_by = FND_GLOBAL.USER_ID,
891: object_version_number = nvl(object_version_number,1)+1
892: where party_id = p_merge_to_party_id
893: and sysdate between effective_start_date and nvl(effective_end_date,sysdate);

Line 890: last_updated_by = FND_GLOBAL.USER_ID,

886: and sysdate between effective_start_date and nvl(effective_end_date,sysdate)
887: and rownum=1),
888: last_update_date = SYSDATE,
889: last_update_login = FND_GLOBAL.LOGIN_ID,
890: last_updated_by = FND_GLOBAL.USER_ID,
891: object_version_number = nvl(object_version_number,1)+1
892: where party_id = p_merge_to_party_id
893: and sysdate between effective_start_date and nvl(effective_end_date,sysdate);
894: end if; -- if l_automerge_flag = 'N'

Line 924: last_update_login = FND_GLOBAL.LOGIN_ID,

920: then
921: update hz_person_profiles
922: set created_by_module = 'CTB_PERSON_REGISTRY_SERVICES',
923: last_update_date = SYSDATE,
924: last_update_login = FND_GLOBAL.LOGIN_ID,
925: last_updated_by = FND_GLOBAL.USER_ID,
926: object_version_number = nvl(object_version_number,1)+1
927: where party_id = p_merge_to_party_id
928: and sysdate between effective_start_date and nvl(effective_end_date,sysdate);

Line 925: last_updated_by = FND_GLOBAL.USER_ID,

921: update hz_person_profiles
922: set created_by_module = 'CTB_PERSON_REGISTRY_SERVICES',
923: last_update_date = SYSDATE,
924: last_update_login = FND_GLOBAL.LOGIN_ID,
925: last_updated_by = FND_GLOBAL.USER_ID,
926: object_version_number = nvl(object_version_number,1)+1
927: where party_id = p_merge_to_party_id
928: and sysdate between effective_start_date and nvl(effective_end_date,sysdate);
929:

Line 939: last_update_login = FND_GLOBAL.LOGIN_ID,

935: update HZ_MERGE_ENTITY_ATTRIBUTES
936: set attribute_value = 'Y',
937: attribute_party_id = l_party_id,
938: last_update_date = SYSDATE,
939: last_update_login = FND_GLOBAL.LOGIN_ID,
940: last_updated_by = FND_GLOBAL.USER_ID,
941: object_version_number = nvl(object_version_number,1)+1
942: where attribute_name = 'INTERNAL_FLAG'
943: and merge_batch_id = p_merge_batch_id

Line 940: last_updated_by = FND_GLOBAL.USER_ID,

936: set attribute_value = 'Y',
937: attribute_party_id = l_party_id,
938: last_update_date = SYSDATE,
939: last_update_login = FND_GLOBAL.LOGIN_ID,
940: last_updated_by = FND_GLOBAL.USER_ID,
941: object_version_number = nvl(object_version_number,1)+1
942: where attribute_name = 'INTERNAL_FLAG'
943: and merge_batch_id = p_merge_batch_id
944: and merge_to_party_id = p_merge_to_party_id;

Line 1033: last_update_login = FND_GLOBAL.LOGIN_ID,

1029: --attribute_value = decode(attribute_type,'D',to_char(to_date(l_value),'YYYY/MM/DD'),l_value), -- Bug No:3729832
1030: attribute_party_id = p_candidate_party_id,
1031: derived_last_update_date = p_derived_last_update_date,
1032: last_update_date = SYSDATE,
1033: last_update_login = FND_GLOBAL.LOGIN_ID,
1034: last_updated_by = FND_GLOBAL.USER_ID,
1035: object_version_number = nvl(object_version_number,1)+1
1036: where attribute_name = l_group_attribute_name
1037: and merge_batch_id = p_merge_batch_id

Line 1034: last_updated_by = FND_GLOBAL.USER_ID,

1030: attribute_party_id = p_candidate_party_id,
1031: derived_last_update_date = p_derived_last_update_date,
1032: last_update_date = SYSDATE,
1033: last_update_login = FND_GLOBAL.LOGIN_ID,
1034: last_updated_by = FND_GLOBAL.USER_ID,
1035: object_version_number = nvl(object_version_number,1)+1
1036: where attribute_name = l_group_attribute_name
1037: and merge_batch_id = p_merge_batch_id
1038: and entity_name = p_entity_name

Line 1048: last_update_login = FND_GLOBAL.LOGIN_ID,

1044: --attribute_value = decode(attribute_type,'D',to_char(to_date(l_value),'YYYY/MM/DD'),l_value), -- Bug No:3729832
1045: attribute_party_id = p_candidate_party_id,
1046: derived_last_update_date = p_derived_last_update_date,
1047: last_update_date = SYSDATE,
1048: last_update_login = FND_GLOBAL.LOGIN_ID,
1049: last_updated_by = FND_GLOBAL.USER_ID,
1050: object_version_number = nvl(object_version_number,1)+1
1051: where attribute_name = l_group_attribute_name
1052: and merge_batch_id = p_merge_batch_id

Line 1049: last_updated_by = FND_GLOBAL.USER_ID,

1045: attribute_party_id = p_candidate_party_id,
1046: derived_last_update_date = p_derived_last_update_date,
1047: last_update_date = SYSDATE,
1048: last_update_login = FND_GLOBAL.LOGIN_ID,
1049: last_updated_by = FND_GLOBAL.USER_ID,
1050: object_version_number = nvl(object_version_number,1)+1
1051: where attribute_name = l_group_attribute_name
1052: and merge_batch_id = p_merge_batch_id
1053: and entity_name = p_entity_name

Line 1387: last_update_login = FND_GLOBAL.LOGIN_ID,

1383:
1384: update hz_merge_entity_attributes
1385: set attribute_party_id = l_from_party_id,
1386: last_update_date = SYSDATE,
1387: last_update_login = FND_GLOBAL.LOGIN_ID,
1388: last_updated_by = FND_GLOBAL.USER_ID,
1389: object_version_number = nvl(object_version_number,1)+1,
1390: derived_last_update_date = l_last_update_date
1391: where attribute_name = 'BUSINESS_REPORT'

Line 1388: last_updated_by = FND_GLOBAL.USER_ID,

1384: update hz_merge_entity_attributes
1385: set attribute_party_id = l_from_party_id,
1386: last_update_date = SYSDATE,
1387: last_update_login = FND_GLOBAL.LOGIN_ID,
1388: last_updated_by = FND_GLOBAL.USER_ID,
1389: object_version_number = nvl(object_version_number,1)+1,
1390: derived_last_update_date = l_last_update_date
1391: where attribute_name = 'BUSINESS_REPORT'
1392: and merge_batch_id = p_merge_batch_id

Line 1529: nvl(fnd_global.user_id,-1),

1525: l_attri_party_id,
1526: p_entity_name,
1527: l_derived_date,
1528: 1,
1529: nvl(fnd_global.user_id,-1),
1530: sysdate,
1531: nvl(fnd_global.user_id,-1),
1532: nvl(fnd_global.login_id,-1),
1533: sysdate);

Line 1531: nvl(fnd_global.user_id,-1),

1527: l_derived_date,
1528: 1,
1529: nvl(fnd_global.user_id,-1),
1530: sysdate,
1531: nvl(fnd_global.user_id,-1),
1532: nvl(fnd_global.login_id,-1),
1533: sysdate);
1534: end if;
1535:

Line 1532: nvl(fnd_global.login_id,-1),

1528: 1,
1529: nvl(fnd_global.user_id,-1),
1530: sysdate,
1531: nvl(fnd_global.user_id,-1),
1532: nvl(fnd_global.login_id,-1),
1533: sysdate);
1534: end if;
1535:
1536: end loop;

Line 1696: nvl(fnd_global.user_id,-1),

1692: p_merge_to_party_id,
1693: p_entity_name,
1694: last_update_date,
1695: 1,
1696: nvl(fnd_global.user_id,-1),
1697: sysdate,
1698: nvl(fnd_global.user_id,-1),
1699: nvl(fnd_global.login_id,-1),
1700: sysdate

Line 1698: nvl(fnd_global.user_id,-1),

1694: last_update_date,
1695: 1,
1696: nvl(fnd_global.user_id,-1),
1697: sysdate,
1698: nvl(fnd_global.user_id,-1),
1699: nvl(fnd_global.login_id,-1),
1700: sysdate
1701: from HZ_ORGANIZATION_PROFILES
1702: where party_id = l_selected_party_id

Line 1699: nvl(fnd_global.login_id,-1),

1695: 1,
1696: nvl(fnd_global.user_id,-1),
1697: sysdate,
1698: nvl(fnd_global.user_id,-1),
1699: nvl(fnd_global.login_id,-1),
1700: sysdate
1701: from HZ_ORGANIZATION_PROFILES
1702: where party_id = l_selected_party_id
1703: and sysdate between effective_start_date and nvl(effective_end_date,sysdate);

Line 1738: 'nvl(fnd_global.user_id,-1)'||','||

1734: l_selected_party_id ||','||
1735: ''''||p_entity_name||''''||','||
1736: 'last_update_date'||','||
1737: '1,'||
1738: 'nvl(fnd_global.user_id,-1)'||','||
1739: 'sysdate'||','||
1740: 'nvl(fnd_global.user_id,-1)'||','||
1741: 'nvl(fnd_global.login_id,-1)'||','||
1742: 'sysdate'||

Line 1740: 'nvl(fnd_global.user_id,-1)'||','||

1736: 'last_update_date'||','||
1737: '1,'||
1738: 'nvl(fnd_global.user_id,-1)'||','||
1739: 'sysdate'||','||
1740: 'nvl(fnd_global.user_id,-1)'||','||
1741: 'nvl(fnd_global.login_id,-1)'||','||
1742: 'sysdate'||
1743: ' from '|| p_entity_name ||
1744: ' where party_id = '||':selected_party_id'||

Line 1741: 'nvl(fnd_global.login_id,-1)'||','||

1737: '1,'||
1738: 'nvl(fnd_global.user_id,-1)'||','||
1739: 'sysdate'||','||
1740: 'nvl(fnd_global.user_id,-1)'||','||
1741: 'nvl(fnd_global.login_id,-1)'||','||
1742: 'sysdate'||
1743: ' from '|| p_entity_name ||
1744: ' where party_id = '||':selected_party_id'||
1745: ' and sysdate between effective_start_date and nvl(effective_end_date,sysdate)';

Line 1766: last_update_login = FND_GLOBAL.LOGIN_ID,

1762: update HZ_MERGE_ENTITY_ATTRIBUTES
1763: set attribute_value = 'CTB_PERSON_REGISTRY_SERVICES',
1764: attribute_party_id = l_party_id,
1765: last_update_date = SYSDATE,
1766: last_update_login = FND_GLOBAL.LOGIN_ID,
1767: last_updated_by = FND_GLOBAL.USER_ID,
1768: object_version_number = nvl(object_version_number,1)+1
1769: where attribute_name = 'CREATED_BY_MODULE'
1770: and merge_batch_id = p_merge_batch_id

Line 1767: last_updated_by = FND_GLOBAL.USER_ID,

1763: set attribute_value = 'CTB_PERSON_REGISTRY_SERVICES',
1764: attribute_party_id = l_party_id,
1765: last_update_date = SYSDATE,
1766: last_update_login = FND_GLOBAL.LOGIN_ID,
1767: last_updated_by = FND_GLOBAL.USER_ID,
1768: object_version_number = nvl(object_version_number,1)+1
1769: where attribute_name = 'CREATED_BY_MODULE'
1770: and merge_batch_id = p_merge_batch_id
1771: and merge_to_party_id = p_merge_to_party_id;

Line 1782: last_update_login = FND_GLOBAL.LOGIN_ID,

1778: update HZ_MERGE_ENTITY_ATTRIBUTES
1779: set attribute_value = 'Y',
1780: attribute_party_id = l_party_id,
1781: last_update_date = SYSDATE,
1782: last_update_login = FND_GLOBAL.LOGIN_ID,
1783: last_updated_by = FND_GLOBAL.USER_ID,
1784: object_version_number = nvl(object_version_number,1)+1
1785: where attribute_name = 'INTERNAL_FLAG'
1786: and merge_batch_id = p_merge_batch_id

Line 1783: last_updated_by = FND_GLOBAL.USER_ID,

1779: set attribute_value = 'Y',
1780: attribute_party_id = l_party_id,
1781: last_update_date = SYSDATE,
1782: last_update_login = FND_GLOBAL.LOGIN_ID,
1783: last_updated_by = FND_GLOBAL.USER_ID,
1784: object_version_number = nvl(object_version_number,1)+1
1785: where attribute_name = 'INTERNAL_FLAG'
1786: and merge_batch_id = p_merge_batch_id
1787: and merge_to_party_id = p_merge_to_party_id;

Line 1940: last_update_login = FND_GLOBAL.LOGIN_ID,

1936: set attribute_value = p_attribute_value,
1937: attribute_party_id = p_attribute_party_id,
1938: derived_last_update_date = decode(p_attribute_party_id,null,SYSDATE,l_last_update_date),
1939: last_update_date = SYSDATE,
1940: last_update_login = FND_GLOBAL.LOGIN_ID,
1941: last_updated_by = FND_GLOBAL.USER_ID,
1942: object_version_number = px_object_version_number
1943: where attribute_name = p_attribute_name
1944: and merge_batch_id = p_merge_batch_id

Line 1941: last_updated_by = FND_GLOBAL.USER_ID,

1937: attribute_party_id = p_attribute_party_id,
1938: derived_last_update_date = decode(p_attribute_party_id,null,SYSDATE,l_last_update_date),
1939: last_update_date = SYSDATE,
1940: last_update_login = FND_GLOBAL.LOGIN_ID,
1941: last_updated_by = FND_GLOBAL.USER_ID,
1942: object_version_number = px_object_version_number
1943: where attribute_name = p_attribute_name
1944: and merge_batch_id = p_merge_batch_id
1945: and merge_to_party_id = p_merge_to_party_id

Line 2259: last_update_login = FND_GLOBAL.LOGIN_ID,

2255: update hz_merge_entity_attributes
2256: set attribute_value = l_value, -- value formatted already
2257: derived_last_update_date = l_party_last_upd_date,
2258: last_update_date = SYSDATE,
2259: last_update_login = FND_GLOBAL.LOGIN_ID,
2260: last_updated_by = FND_GLOBAL.USER_ID,
2261: object_version_number = nvl(object_version_number,1)+1
2262: where attribute_name = l_attribute_name
2263: and merge_batch_id = p_merge_batch_id

Line 2260: last_updated_by = FND_GLOBAL.USER_ID,

2256: set attribute_value = l_value, -- value formatted already
2257: derived_last_update_date = l_party_last_upd_date,
2258: last_update_date = SYSDATE,
2259: last_update_login = FND_GLOBAL.LOGIN_ID,
2260: last_updated_by = FND_GLOBAL.USER_ID,
2261: object_version_number = nvl(object_version_number,1)+1
2262: where attribute_name = l_attribute_name
2263: and merge_batch_id = p_merge_batch_id
2264: and entity_name = p_entity_name