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_TASK_PARTY_MERGE_PKG dependencies on HZ_PARTIES

Line 361: || ' , source_object_name = (SELECT jtf_task_utl.check_truncation(:2) FROM hz_parties WHERE party_id = :3)'

357: -- Modified by SBARAT on 23/12/2005 for SQL Literal issue, bug# 4614088
358: l_select_stat :=
359: 'UPDATE jtf_tasks_b'
360: || ' SET source_object_id = :1'
361: || ' , source_object_name = (SELECT jtf_task_utl.check_truncation(:2) FROM hz_parties WHERE party_id = :3)'
362: || ' , last_update_date = hz_utility_pub.last_update_date'
363: || ' , last_updated_by = hz_utility_pub.user_id'
364: || ' , last_update_login = hz_utility_pub.last_update_login'
365: || ' , object_version_number = object_version_number + 1'

Line 483: || ' , new_source_object_name = (SELECT jtf_task_utl.check_truncation(:2) FROM hz_parties WHERE party_id = :3)'

479: -- Modified by TSINGHAL for bug # 3138768 dt 17/sept/2003 start
480: -- Modified by SBARAT on 23/12/2005 for SQL Literal issue, bug# 4614088
481: l_select_stat := 'UPDATE jtf_task_audits_b '
482: || 'SET new_source_object_id = :1'
483: || ' , new_source_object_name = (SELECT jtf_task_utl.check_truncation(:2) FROM hz_parties WHERE party_id = :3)'
484: || ' , last_update_date = hz_utility_pub.last_update_date'
485: || ' , last_updated_by = hz_utility_pub.user_id'
486: || ' , last_update_login = hz_utility_pub.last_update_login'
487: || ' , object_version_number = object_version_number + 1'

Line 606: || ' , old_source_object_name = (SELECT jtf_task_utl.check_truncation(:2) FROM hz_parties WHERE party_id = :3 )'

602: -- Modified by TSINGHAL for bug # 3138768 dt 01/Oct/2003 Start
603: -- Modified by SBARAT on 23/12/2005 for SQL Literal issue, bug# 4614088
604: l_select_stat := 'UPDATE jtf_task_audits_b'
605: || ' SET old_source_object_id = :1'
606: || ' , old_source_object_name = (SELECT jtf_task_utl.check_truncation(:2) FROM hz_parties WHERE party_id = :3 )'
607: || ' , last_update_date = hz_utility_pub.last_update_date'
608: || ' , last_updated_by = hz_utility_pub.user_id'
609: || ' , last_update_login = hz_utility_pub.last_update_login'
610: || ' , object_version_number = object_version_number + 1'

Line 732: || ' , object_name = (SELECT jtf_task_utl.check_truncation(:2) FROM hz_parties WHERE party_id = :3 )'

728: /* Modified by tsinghal 4th Nov '03 bug # 3138768 Start */
729: -- Modified by SBARAT on 23/12/2005 for SQL Literal issue, bug# 4614088
730: l_select_stat := 'UPDATE jtf_task_references_b'
731: || ' SET object_id = :1'
732: || ' , object_name = (SELECT jtf_task_utl.check_truncation(:2) FROM hz_parties WHERE party_id = :3 )'
733: || ' , last_update_date = hz_utility_pub.last_update_date'
734: || ' , last_updated_by = hz_utility_pub.user_id'
735: || ' , last_update_login = hz_utility_pub.last_update_login'
736: || ' , object_version_number = object_version_number + 1'

Line 1360: FROM hz_parties

1356: -- get Customer new Name - using the p_to_fk_id
1357:
1358: cursor get_new_customer_number(p_to_fk_id NUMBER) Is
1359: SELECT party_number
1360: FROM hz_parties
1361: WHERE party_id = p_to_fk_id;
1362:
1363: --l_query_customer_name_id jtf_perz_query_param.query_param_id%TYPE;
1364: l_customer_new_number hz_parties.party_number%TYPE;

Line 1364: l_customer_new_number hz_parties.party_number%TYPE;

1360: FROM hz_parties
1361: WHERE party_id = p_to_fk_id;
1362:
1363: --l_query_customer_name_id jtf_perz_query_param.query_param_id%TYPE;
1364: l_customer_new_number hz_parties.party_number%TYPE;
1365:
1366: BEGIN
1367:
1368: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1520: FROM hz_parties

1516: -- get Customer new Name - using the p_to_fk_id
1517:
1518: cursor get_new_customer_name(p_to_fk_id NUMBER) Is
1519: SELECT party_name
1520: FROM hz_parties
1521: WHERE party_id = p_to_fk_id;
1522:
1523: --l_query_customer_name_id jtf_perz_query_param.query_param_id%TYPE;
1524: l_customer_new_name hz_parties.party_name%TYPE;

Line 1524: l_customer_new_name hz_parties.party_name%TYPE;

1520: FROM hz_parties
1521: WHERE party_id = p_to_fk_id;
1522:
1523: --l_query_customer_name_id jtf_perz_query_param.query_param_id%TYPE;
1524: l_customer_new_name hz_parties.party_name%TYPE;
1525:
1526: BEGIN
1527:
1528: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1682: FROM hz_parties

1678: where batch_id = p_batch_id;
1679:
1680: CURSOR c_party IS
1681: SELECT party_type
1682: FROM hz_parties
1683: WHERE party_id = p_from_fk_id;
1684:
1685: l_party_type hz_parties.party_type%TYPE;
1686:

Line 1685: l_party_type hz_parties.party_type%TYPE;

1681: SELECT party_type
1682: FROM hz_parties
1683: WHERE party_id = p_from_fk_id;
1684:
1685: l_party_type hz_parties.party_type%TYPE;
1686:
1687: BEGIN
1688:
1689: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1732: WHERE LTRIM(RTRIM(UPPER(from_table))) = 'HZ_PARTIES'

1728: object_version_number = object_version_number + 1
1729: WHERE resource_id = p_from_fk_id
1730: AND resource_type_code IN (SELECT object_code
1731: FROM jtf_objects_b
1732: WHERE LTRIM(RTRIM(UPPER(from_table))) = 'HZ_PARTIES'
1733: AND RTRIM(LTRIM(UPPER(select_id))) = 'PARTY_ID');
1734:
1735: end if;
1736: