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 890: FROM hz_party_usg_assignments

886: p_owner_table_name VARCHAR2,
887: p_owner_table_id NUMBER
888: ) IS
889: SELECT party_usg_assignment_id
890: FROM hz_party_usg_assignments
891: WHERE owner_table_name = p_owner_table_name
892: AND owner_table_id = p_owner_table_id
893: AND party_id = p_party_id
894: AND party_usage_code = p_party_usage_code

Line 905: FROM hz_party_usg_assignments

901: p_effective_start_date DATE,
902: p_effective_end_date DATE
903: ) IS
904: SELECT party_usg_assignment_id
905: FROM hz_party_usg_assignments
906: WHERE party_id = p_party_id
907: AND party_usage_code = p_party_usage_code
908: AND status_flag = 'A'
909: AND p_effective_start_date BETWEEN

Line 1045: FROM hz_party_usg_assignments

1041: ) IS
1042: SELECT party_usg_assignment_id,
1043: party_usage_code,
1044: effective_start_date
1045: FROM hz_party_usg_assignments
1046: WHERE party_id = p_party_id
1047: AND status_flag = 'A'
1048: AND trunc(sysdate) between
1049: effective_start_date and effective_end_date;

Line 1248: FROM hz_party_usg_assignments

1244: ) IS
1245: SELECT party_usg_assignment_id,
1246: party_usage_code,
1247: effective_start_date
1248: FROM hz_party_usg_assignments
1249: WHERE party_id = p_party_id
1250: AND status_flag = 'A'
1251: AND trunc(sysdate) between
1252: effective_start_date and effective_end_date;

Line 1622: HZ_PARTY_USG_ASSIGNMENTS_PKG.insert_row (

1618: p_prefix => l_debug_prefix,
1619: p_msg_level => fnd_log.level_procedure);
1620: END IF;
1621:
1622: HZ_PARTY_USG_ASSIGNMENTS_PKG.insert_row (
1623: x_party_id => p_party_usg_assignment_rec.party_id,
1624: x_party_usage_code => p_party_usg_assignment_rec.party_usage_code,
1625: x_effective_start_date => p_party_usg_assignment_rec.effective_start_date,
1626: x_effective_end_date => p_party_usg_assignment_rec.effective_end_date,

Line 1705: FROM hz_party_usg_assignments

1701: CURSOR c_assignment (
1702: p_party_usg_assignment_id NUMBER
1703: ) IS
1704: SELECT object_version_number
1705: FROM hz_party_usg_assignments
1706: WHERE party_usg_assignment_id = p_party_usg_assignment_id
1707: FOR UPDATE NOWAIT;
1708:
1709: l_object_version_number NUMBER;

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

1730: END IF;
1731:
1732: IF p_object_version_number <> l_object_version_number THEN
1733: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
1734: fnd_message.set_token('TABLE', 'hz_party_usg_assignments');
1735: fnd_msg_pub.add;
1736: RAISE fnd_api.g_exc_error;
1737: END IF;
1738: END IF;

Line 1742: HZ_PARTY_USG_ASSIGNMENTS_PKG.update_row (

1738: END IF;
1739:
1740: p_object_version_number := l_object_version_number + 1;
1741:
1742: HZ_PARTY_USG_ASSIGNMENTS_PKG.update_row (
1743: x_party_usg_assignment_id => p_party_usg_assignment_id,
1744: x_party_id => null,
1745: x_party_usage_code => null,
1746: x_effective_start_date => p_party_usg_assignment_rec.effective_start_date,

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

2095:
2096: c_api_name CONSTANT VARCHAR2(30) := 'get_usg_assignment';
2097: l_debug_prefix VARCHAR2(30);
2098:
2099: TYPE assignment_cursor_type IS REF CURSOR RETURN hz_party_usg_assignments%ROWTYPE;
2100: c_assignment assignment_cursor_type;
2101: assignment_row hz_party_usg_assignments%ROWTYPE;
2102: l_counter NUMBER;
2103: l_search_by VARCHAR2(30);

Line 2101: assignment_row hz_party_usg_assignments%ROWTYPE;

2097: l_debug_prefix VARCHAR2(30);
2098:
2099: TYPE assignment_cursor_type IS REF CURSOR RETURN hz_party_usg_assignments%ROWTYPE;
2100: c_assignment assignment_cursor_type;
2101: assignment_row hz_party_usg_assignments%ROWTYPE;
2102: l_counter NUMBER;
2103: l_search_by VARCHAR2(30);
2104:
2105: BEGIN

Line 2139: FROM hz_party_usg_assignments

2135: THEN
2136: l_search_by := 'ASSIGNMENT_ID';
2137: OPEN c_assignment FOR
2138: SELECT *
2139: FROM hz_party_usg_assignments
2140: WHERE party_usg_assignment_id = p_party_usg_assignment_id;
2141: --
2142: -- check party_id, party_usage_code
2143: --

Line 2152: FROM hz_party_usg_assignments

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

Line 2168: FROM hz_party_usg_assignments

2164: THEN
2165: l_search_by := 'OWNER_TABLE_NAME';
2166: OPEN c_assignment FOR
2167: SELECT *
2168: FROM hz_party_usg_assignments
2169: WHERE owner_table_name = p_party_usg_assignment_rec.owner_table_name
2170: AND owner_table_id = p_party_usg_assignment_rec.owner_table_id;
2171: -- need required parameters
2172: --

Line 2768: FROM hz_party_usg_assignments

2764: CURSOR c_assignments (
2765: p_party_id NUMBER
2766: ) IS
2767: SELECT UNIQUE party_usage_code
2768: FROM hz_party_usg_assignments
2769: WHERE party_id = p_party_id;
2770:
2771: l_from_party_usage_codes_tbl VARCHAR100_TBL;
2772: l_to_party_usage_codes_tbl VARCHAR100_TBL;

Line 3021: FROM hz_party_usg_assignments pu

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