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.ARH_DQM_SRCH_PKG dependencies on HZ_PARTY_SEARCH

Line 7: ( p_party IN hz_party_search.party_search_rec_type)

3:
4:
5: FUNCTION IsNull
6: -- Return TRUE if the dqm record type argument has all its attributes to NULL
7: ( p_party IN hz_party_search.party_search_rec_type)
8: RETURN BOOLEAN
9: IS
10: BEGIN
11: IF p_party.line_of_business IS NULL

Line 206: ( p_party_site IN hz_party_search.party_site_search_rec_type)

202: END IF;
203: END;
204:
205: FUNCTION IsNull
206: ( p_party_site IN hz_party_search.party_site_search_rec_type)
207: RETURN BOOLEAN
208: IS
209: BEGIN
210: IF p_party_site.party_site_number IS NULL

Line 282: ( p_contact IN hz_party_search.contact_search_rec_type)

278: END IF;
279: END;
280:
281: FUNCTION IsNull
282: ( p_contact IN hz_party_search.contact_search_rec_type)
283: RETURN BOOLEAN
284: IS
285: BEGIN
286: IF p_contact.directional_flag IS NULL

Line 362: ( p_contact_point IN hz_party_search.contact_point_search_rec_type)

358: END IF;
359: END;
360:
361: FUNCTION IsNull
362: ( p_contact_point IN hz_party_search.contact_point_search_rec_type)
363: RETURN BOOLEAN
364: IS
365: BEGIN
366: IF p_contact_point.phone_line_type IS NULL

Line 436: ( p_contact_point IN hz_party_search.contact_point_search_rec_type,

432: -- Return a list of contact_point_search_rec by defaulting the contact_type
433: -- split 1 contact_point_search_rec into a list of record for different contact_type
434: -- Return an empty list if the in record type argument is null
435: ----------------------------------------------
436: ( p_contact_point IN hz_party_search.contact_point_search_rec_type,
437: p_default_type IN VARCHAR2)
438: RETURN hz_party_search.contact_point_list
439: IS
440: l_list hz_party_search.contact_point_list;

Line 438: RETURN hz_party_search.contact_point_list

434: -- Return an empty list if the in record type argument is null
435: ----------------------------------------------
436: ( p_contact_point IN hz_party_search.contact_point_search_rec_type,
437: p_default_type IN VARCHAR2)
438: RETURN hz_party_search.contact_point_list
439: IS
440: l_list hz_party_search.contact_point_list;
441: l_reset_rec hz_party_search.contact_point_search_rec_type;
442: l_rec hz_party_search.contact_point_search_rec_type;

Line 440: l_list hz_party_search.contact_point_list;

436: ( p_contact_point IN hz_party_search.contact_point_search_rec_type,
437: p_default_type IN VARCHAR2)
438: RETURN hz_party_search.contact_point_list
439: IS
440: l_list hz_party_search.contact_point_list;
441: l_reset_rec hz_party_search.contact_point_search_rec_type;
442: l_rec hz_party_search.contact_point_search_rec_type;
443: l_init_rec hz_party_search.contact_point_search_rec_type;
444: i NUMBER := 0;

Line 441: l_reset_rec hz_party_search.contact_point_search_rec_type;

437: p_default_type IN VARCHAR2)
438: RETURN hz_party_search.contact_point_list
439: IS
440: l_list hz_party_search.contact_point_list;
441: l_reset_rec hz_party_search.contact_point_search_rec_type;
442: l_rec hz_party_search.contact_point_search_rec_type;
443: l_init_rec hz_party_search.contact_point_search_rec_type;
444: i NUMBER := 0;
445: BEGIN

Line 442: l_rec hz_party_search.contact_point_search_rec_type;

438: RETURN hz_party_search.contact_point_list
439: IS
440: l_list hz_party_search.contact_point_list;
441: l_reset_rec hz_party_search.contact_point_search_rec_type;
442: l_rec hz_party_search.contact_point_search_rec_type;
443: l_init_rec hz_party_search.contact_point_search_rec_type;
444: i NUMBER := 0;
445: BEGIN
446: IF NOT IsNull(p_contact_point) THEN

Line 443: l_init_rec hz_party_search.contact_point_search_rec_type;

439: IS
440: l_list hz_party_search.contact_point_list;
441: l_reset_rec hz_party_search.contact_point_search_rec_type;
442: l_rec hz_party_search.contact_point_search_rec_type;
443: l_init_rec hz_party_search.contact_point_search_rec_type;
444: i NUMBER := 0;
445: BEGIN
446: IF NOT IsNull(p_contact_point) THEN
447: l_init_rec.primary_flag := p_contact_point.primary_flag;

Line 973: l_party hz_party_search.party_search_rec_type;

969: x_msg_data IN OUT NOCOPY varchar2,
970: x_return_status IN OUT NOCOPY VARCHAR2)
971: IS
972: -- DQM record types
973: l_party hz_party_search.party_search_rec_type;
974: l_party_site hz_party_search.party_site_search_rec_type;
975: l_contact hz_party_search.contact_search_rec_type;
976: l_contact_point hz_party_search.contact_point_search_rec_type;
977: -- DQM list type

Line 974: l_party_site hz_party_search.party_site_search_rec_type;

970: x_return_status IN OUT NOCOPY VARCHAR2)
971: IS
972: -- DQM record types
973: l_party hz_party_search.party_search_rec_type;
974: l_party_site hz_party_search.party_site_search_rec_type;
975: l_contact hz_party_search.contact_search_rec_type;
976: l_contact_point hz_party_search.contact_point_search_rec_type;
977: -- DQM list type
978: l_party_site_list hz_party_search.party_site_list;

Line 975: l_contact hz_party_search.contact_search_rec_type;

971: IS
972: -- DQM record types
973: l_party hz_party_search.party_search_rec_type;
974: l_party_site hz_party_search.party_site_search_rec_type;
975: l_contact hz_party_search.contact_search_rec_type;
976: l_contact_point hz_party_search.contact_point_search_rec_type;
977: -- DQM list type
978: l_party_site_list hz_party_search.party_site_list;
979: l_contact_list hz_party_search.contact_list;

Line 976: l_contact_point hz_party_search.contact_point_search_rec_type;

972: -- DQM record types
973: l_party hz_party_search.party_search_rec_type;
974: l_party_site hz_party_search.party_site_search_rec_type;
975: l_contact hz_party_search.contact_search_rec_type;
976: l_contact_point hz_party_search.contact_point_search_rec_type;
977: -- DQM list type
978: l_party_site_list hz_party_search.party_site_list;
979: l_contact_list hz_party_search.contact_list;
980: l_contact_point_list hz_party_search.contact_point_list;

Line 978: l_party_site_list hz_party_search.party_site_list;

974: l_party_site hz_party_search.party_site_search_rec_type;
975: l_contact hz_party_search.contact_search_rec_type;
976: l_contact_point hz_party_search.contact_point_search_rec_type;
977: -- DQM list type
978: l_party_site_list hz_party_search.party_site_list;
979: l_contact_list hz_party_search.contact_list;
980: l_contact_point_list hz_party_search.contact_point_list;
981: -- for error usage
982: tmp_var VARCHAR2(2000);

Line 979: l_contact_list hz_party_search.contact_list;

975: l_contact hz_party_search.contact_search_rec_type;
976: l_contact_point hz_party_search.contact_point_search_rec_type;
977: -- DQM list type
978: l_party_site_list hz_party_search.party_site_list;
979: l_contact_list hz_party_search.contact_list;
980: l_contact_point_list hz_party_search.contact_point_list;
981: -- for error usage
982: tmp_var VARCHAR2(2000);
983: tmp_var1 VARCHAR2(2000);

Line 980: l_contact_point_list hz_party_search.contact_point_list;

976: l_contact_point hz_party_search.contact_point_search_rec_type;
977: -- DQM list type
978: l_party_site_list hz_party_search.party_site_list;
979: l_contact_list hz_party_search.contact_list;
980: l_contact_point_list hz_party_search.contact_point_list;
981: -- for error usage
982: tmp_var VARCHAR2(2000);
983: tmp_var1 VARCHAR2(2000);
984:

Line 1382: hz_party_search.find_party_details (

1378: END IF;
1379:
1380: l_contact_point_list := arh_dqm_srch_pkg.Contact_point_list( p_contact_point =>l_contact_point);
1381:
1382: hz_party_search.find_party_details (
1383: p_rule_id => x_rule_id,
1384: p_party_search_rec => l_party,
1385: p_party_site_list => l_party_site_list,
1386: p_contact_list => l_contact_list,

Line 1614: l_party_site hz_party_search.party_site_search_rec_type;

1610: x_msg_data IN OUT NOCOPY varchar2,
1611: x_return_status IN OUT NOCOPY VARCHAR2)
1612: IS
1613: -- DQM record types
1614: l_party_site hz_party_search.party_site_search_rec_type;
1615: l_contact hz_party_search.contact_search_rec_type;
1616: l_contact_point hz_party_search.contact_point_search_rec_type;
1617: -- DQM list type
1618: l_party_site_list hz_party_search.party_site_list;

Line 1615: l_contact hz_party_search.contact_search_rec_type;

1611: x_return_status IN OUT NOCOPY VARCHAR2)
1612: IS
1613: -- DQM record types
1614: l_party_site hz_party_search.party_site_search_rec_type;
1615: l_contact hz_party_search.contact_search_rec_type;
1616: l_contact_point hz_party_search.contact_point_search_rec_type;
1617: -- DQM list type
1618: l_party_site_list hz_party_search.party_site_list;
1619: l_contact_list hz_party_search.contact_list;

Line 1616: l_contact_point hz_party_search.contact_point_search_rec_type;

1612: IS
1613: -- DQM record types
1614: l_party_site hz_party_search.party_site_search_rec_type;
1615: l_contact hz_party_search.contact_search_rec_type;
1616: l_contact_point hz_party_search.contact_point_search_rec_type;
1617: -- DQM list type
1618: l_party_site_list hz_party_search.party_site_list;
1619: l_contact_list hz_party_search.contact_list;
1620: l_contact_point_list hz_party_search.contact_point_list;

Line 1618: l_party_site_list hz_party_search.party_site_list;

1614: l_party_site hz_party_search.party_site_search_rec_type;
1615: l_contact hz_party_search.contact_search_rec_type;
1616: l_contact_point hz_party_search.contact_point_search_rec_type;
1617: -- DQM list type
1618: l_party_site_list hz_party_search.party_site_list;
1619: l_contact_list hz_party_search.contact_list;
1620: l_contact_point_list hz_party_search.contact_point_list;
1621: -- for error usage
1622: tmp_var VARCHAR2(2000);

Line 1619: l_contact_list hz_party_search.contact_list;

1615: l_contact hz_party_search.contact_search_rec_type;
1616: l_contact_point hz_party_search.contact_point_search_rec_type;
1617: -- DQM list type
1618: l_party_site_list hz_party_search.party_site_list;
1619: l_contact_list hz_party_search.contact_list;
1620: l_contact_point_list hz_party_search.contact_point_list;
1621: -- for error usage
1622: tmp_var VARCHAR2(2000);
1623: tmp_var1 VARCHAR2(2000);

Line 1620: l_contact_point_list hz_party_search.contact_point_list;

1616: l_contact_point hz_party_search.contact_point_search_rec_type;
1617: -- DQM list type
1618: l_party_site_list hz_party_search.party_site_list;
1619: l_contact_list hz_party_search.contact_list;
1620: l_contact_point_list hz_party_search.contact_point_list;
1621: -- for error usage
1622: tmp_var VARCHAR2(2000);
1623: tmp_var1 VARCHAR2(2000);
1624:

Line 1869: hz_party_search.get_matching_party_sites (

1865:
1866: l_contact_point_list := arh_dqm_srch_pkg.Contact_point_list( p_contact_point =>l_contact_point);
1867:
1868:
1869: hz_party_search.get_matching_party_sites (
1870: p_init_msg_list => FND_API.G_TRUE,
1871: p_rule_id => x_rule_id,
1872: p_party_id => p_party_id,
1873: p_party_site_list => l_party_site_list,