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_PARTY_USG_ASSIGNMENT_PVT dependencies on HZ_PARTY_USG_ASSIGNMENTS

Line 120: hz_populate_bot_pkg.pop_hz_party_usg_assignments(

116:
117: -- populate function for integration service
118: IF hz_utility_v2pub.G_EXECUTE_API_CALLOUTS IN ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')
119: THEN
120: hz_populate_bot_pkg.pop_hz_party_usg_assignments(
121: p_operation => p_create_update_flag,
122: P_party_usg_assignment_id => p_party_usg_assignment_id);
123: END IF;
124:

Line 314: FROM hz_party_usg_assignments

310: CURSOR c_assignments (
311: p_party_id NUMBER
312: ) IS
313: SELECT party_usage_code
314: FROM hz_party_usg_assignments
315: WHERE party_id = p_party_id;
316:
317: db_party_type VARCHAR2(30);
318: db_party_name VARCHAR2(360);

Line 894: FROM hz_party_usg_assignments

890: p_owner_table_name VARCHAR2,
891: p_owner_table_id NUMBER
892: ) IS
893: SELECT party_usg_assignment_id
894: FROM hz_party_usg_assignments
895: WHERE owner_table_name = p_owner_table_name
896: AND owner_table_id = p_owner_table_id
897: AND party_id = p_party_id
898: AND party_usage_code = p_party_usage_code

Line 909: FROM hz_party_usg_assignments

905: p_effective_start_date DATE,
906: p_effective_end_date DATE
907: ) IS
908: SELECT party_usg_assignment_id
909: FROM hz_party_usg_assignments
910: WHERE party_id = p_party_id
911: AND party_usage_code = p_party_usage_code
912: AND status_flag = 'A'
913: AND p_effective_start_date BETWEEN

Line 1049: FROM hz_party_usg_assignments

1045: ) IS
1046: SELECT party_usg_assignment_id,
1047: party_usage_code,
1048: effective_start_date
1049: FROM hz_party_usg_assignments
1050: WHERE party_id = p_party_id
1051: AND status_flag = 'A'
1052: AND trunc(sysdate) between
1053: effective_start_date and effective_end_date;

Line 1252: FROM hz_party_usg_assignments

1248: ) IS
1249: SELECT party_usg_assignment_id,
1250: party_usage_code,
1251: effective_start_date
1252: FROM hz_party_usg_assignments
1253: WHERE party_id = p_party_id
1254: AND status_flag = 'A'
1255: AND trunc(sysdate) between
1256: effective_start_date and effective_end_date;

Line 1626: HZ_PARTY_USG_ASSIGNMENTS_PKG.insert_row (

1622: p_prefix => l_debug_prefix,
1623: p_msg_level => fnd_log.level_procedure);
1624: END IF;
1625:
1626: HZ_PARTY_USG_ASSIGNMENTS_PKG.insert_row (
1627: x_party_id => p_party_usg_assignment_rec.party_id,
1628: x_party_usage_code => p_party_usg_assignment_rec.party_usage_code,
1629: x_effective_start_date => p_party_usg_assignment_rec.effective_start_date,
1630: x_effective_end_date => p_party_usg_assignment_rec.effective_end_date,

Line 1709: FROM hz_party_usg_assignments

1705: CURSOR c_assignment (
1706: p_party_usg_assignment_id NUMBER
1707: ) IS
1708: SELECT object_version_number
1709: FROM hz_party_usg_assignments
1710: WHERE party_usg_assignment_id = p_party_usg_assignment_id
1711: FOR UPDATE NOWAIT;
1712:
1713: l_object_version_number NUMBER;

Line 1738: fnd_message.set_token('TABLE', 'hz_party_usg_assignments');

1734: END IF;
1735:
1736: IF p_object_version_number <> l_object_version_number THEN
1737: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
1738: fnd_message.set_token('TABLE', 'hz_party_usg_assignments');
1739: fnd_msg_pub.add;
1740: RAISE fnd_api.g_exc_error;
1741: END IF;
1742: END IF;

Line 1746: HZ_PARTY_USG_ASSIGNMENTS_PKG.update_row (

1742: END IF;
1743:
1744: p_object_version_number := l_object_version_number + 1;
1745:
1746: HZ_PARTY_USG_ASSIGNMENTS_PKG.update_row (
1747: x_party_usg_assignment_id => p_party_usg_assignment_id,
1748: x_party_id => null,
1749: x_party_usage_code => null,
1750: x_effective_start_date => p_party_usg_assignment_rec.effective_start_date,

Line 2103: TYPE assignment_cursor_type IS REF CURSOR RETURN hz_party_usg_assignments%ROWTYPE;

2099:
2100: c_api_name CONSTANT VARCHAR2(30) := 'get_usg_assignment';
2101: l_debug_prefix VARCHAR2(30);
2102:
2103: TYPE assignment_cursor_type IS REF CURSOR RETURN hz_party_usg_assignments%ROWTYPE;
2104: c_assignment assignment_cursor_type;
2105: assignment_row hz_party_usg_assignments%ROWTYPE;
2106: l_counter NUMBER;
2107: l_search_by VARCHAR2(30);

Line 2105: assignment_row hz_party_usg_assignments%ROWTYPE;

2101: l_debug_prefix VARCHAR2(30);
2102:
2103: TYPE assignment_cursor_type IS REF CURSOR RETURN hz_party_usg_assignments%ROWTYPE;
2104: c_assignment assignment_cursor_type;
2105: assignment_row hz_party_usg_assignments%ROWTYPE;
2106: l_counter NUMBER;
2107: l_search_by VARCHAR2(30);
2108:
2109: BEGIN

Line 2143: FROM hz_party_usg_assignments

2139: THEN
2140: l_search_by := 'ASSIGNMENT_ID';
2141: OPEN c_assignment FOR
2142: SELECT *
2143: FROM hz_party_usg_assignments
2144: WHERE party_usg_assignment_id = p_party_usg_assignment_id;
2145: --
2146: -- check party_id, party_usage_code
2147: --

Line 2156: FROM hz_party_usg_assignments

2152: THEN
2153: l_search_by := 'USAGE_CODE';
2154: OPEN c_assignment FOR
2155: SELECT *
2156: FROM hz_party_usg_assignments
2157: WHERE party_id = p_party_usg_assignment_rec.party_id
2158: AND party_usage_code = p_party_usg_assignment_rec.party_usage_code
2159: AND status_flag = 'A'
2160: AND effective_end_date > trunc(sysdate);

Line 2172: FROM hz_party_usg_assignments

2168: THEN
2169: l_search_by := 'OWNER_TABLE_NAME';
2170: OPEN c_assignment FOR
2171: SELECT *
2172: FROM hz_party_usg_assignments
2173: WHERE owner_table_name = p_party_usg_assignment_rec.owner_table_name
2174: AND owner_table_id = p_party_usg_assignment_rec.owner_table_id;
2175: -- need required parameters
2176: --

Line 2772: FROM hz_party_usg_assignments

2768: CURSOR c_assignments (
2769: p_party_id NUMBER
2770: ) IS
2771: SELECT UNIQUE party_usage_code
2772: FROM hz_party_usg_assignments
2773: WHERE party_id = p_party_id;
2774:
2775: l_from_party_usage_codes_tbl VARCHAR100_TBL;
2776: l_to_party_usage_codes_tbl VARCHAR100_TBL;

Line 3025: FROM hz_party_usg_assignments pu

3021: AND p.party_id <> p_party_id
3022: AND p.status IN ('A', 'I')
3023: AND EXISTS (
3024: SELECT null
3025: FROM hz_party_usg_assignments pu
3026: WHERE pu.party_usage_code = c_supplier_code
3027: AND pu.party_id = p.party_id
3028: AND ROWNUM = 1)
3029: AND ROWNUM = 1;