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_PKG dependencies on HZ_PARTY_SEARCH

Line 25: ( p_party IN hz_party_search.party_search_rec_type)

21: END;
22:
23: FUNCTION IsNull
24: -- Return TRUE if the dqm record type argument has all its attributes to NULL
25: ( p_party IN hz_party_search.party_search_rec_type)
26: RETURN BOOLEAN
27: IS
28: BEGIN
29: IF p_party.line_of_business IS NULL

Line 224: ( p_party_site IN hz_party_search.party_site_search_rec_type)

220: END IF;
221: END;
222:
223: FUNCTION IsNull
224: ( p_party_site IN hz_party_search.party_site_search_rec_type)
225: RETURN BOOLEAN
226: IS
227: BEGIN
228: IF p_party_site.party_site_number IS NULL

Line 300: ( p_contact IN hz_party_search.contact_search_rec_type)

296: END IF;
297: END;
298:
299: FUNCTION IsNull
300: ( p_contact IN hz_party_search.contact_search_rec_type)
301: RETURN BOOLEAN
302: IS
303: BEGIN
304: IF p_contact.directional_flag IS NULL

Line 380: ( p_contact_point IN hz_party_search.contact_point_search_rec_type)

376: END IF;
377: END;
378:
379: FUNCTION IsNull
380: ( p_contact_point IN hz_party_search.contact_point_search_rec_type)
381: RETURN BOOLEAN
382: IS
383: BEGIN
384: IF p_contact_point.phone_line_type IS NULL

Line 454: ( p_contact_point IN hz_party_search.contact_point_search_rec_type,

450: -- Return a list of contact_point_search_rec by defaulting the contact_type
451: -- split 1 contact_point_search_rec into a list of record for different contact_type
452: -- Return an empty list if the in record type argument is null
453: ----------------------------------------------
454: ( p_contact_point IN hz_party_search.contact_point_search_rec_type,
455: p_default_type IN VARCHAR2 DEFAULT 'PHONE')
456: RETURN hz_party_search.contact_point_list
457: IS
458: l_list hz_party_search.contact_point_list;

Line 456: RETURN hz_party_search.contact_point_list

452: -- Return an empty list if the in record type argument is null
453: ----------------------------------------------
454: ( p_contact_point IN hz_party_search.contact_point_search_rec_type,
455: p_default_type IN VARCHAR2 DEFAULT 'PHONE')
456: RETURN hz_party_search.contact_point_list
457: IS
458: l_list hz_party_search.contact_point_list;
459: l_reset_rec hz_party_search.contact_point_search_rec_type;
460: l_rec hz_party_search.contact_point_search_rec_type;

Line 458: l_list hz_party_search.contact_point_list;

454: ( p_contact_point IN hz_party_search.contact_point_search_rec_type,
455: p_default_type IN VARCHAR2 DEFAULT 'PHONE')
456: RETURN hz_party_search.contact_point_list
457: IS
458: l_list hz_party_search.contact_point_list;
459: l_reset_rec hz_party_search.contact_point_search_rec_type;
460: l_rec hz_party_search.contact_point_search_rec_type;
461: l_init_rec hz_party_search.contact_point_search_rec_type;
462: i NUMBER := 0;

Line 459: l_reset_rec hz_party_search.contact_point_search_rec_type;

455: p_default_type IN VARCHAR2 DEFAULT 'PHONE')
456: RETURN hz_party_search.contact_point_list
457: IS
458: l_list hz_party_search.contact_point_list;
459: l_reset_rec hz_party_search.contact_point_search_rec_type;
460: l_rec hz_party_search.contact_point_search_rec_type;
461: l_init_rec hz_party_search.contact_point_search_rec_type;
462: i NUMBER := 0;
463: BEGIN

Line 460: l_rec hz_party_search.contact_point_search_rec_type;

456: RETURN hz_party_search.contact_point_list
457: IS
458: l_list hz_party_search.contact_point_list;
459: l_reset_rec hz_party_search.contact_point_search_rec_type;
460: l_rec hz_party_search.contact_point_search_rec_type;
461: l_init_rec hz_party_search.contact_point_search_rec_type;
462: i NUMBER := 0;
463: BEGIN
464: IF NOT IsNull(p_contact_point) THEN

Line 461: l_init_rec hz_party_search.contact_point_search_rec_type;

457: IS
458: l_list hz_party_search.contact_point_list;
459: l_reset_rec hz_party_search.contact_point_search_rec_type;
460: l_rec hz_party_search.contact_point_search_rec_type;
461: l_init_rec hz_party_search.contact_point_search_rec_type;
462: i NUMBER := 0;
463: BEGIN
464: IF NOT IsNull(p_contact_point) THEN
465: l_init_rec.primary_flag := p_contact_point.primary_flag;

Line 990: l_party hz_party_search.party_search_rec_type;

986: x_msg_data IN OUT NOCOPY varchar2,
987: x_return_status IN OUT NOCOPY VARCHAR2)
988: IS
989: -- DQM record types
990: l_party hz_party_search.party_search_rec_type;
991: l_party_site hz_party_search.party_site_search_rec_type;
992: l_contact hz_party_search.contact_search_rec_type;
993: l_contact_point hz_party_search.contact_point_search_rec_type;
994: -- DQM list type

Line 991: l_party_site hz_party_search.party_site_search_rec_type;

987: x_return_status IN OUT NOCOPY VARCHAR2)
988: IS
989: -- DQM record types
990: l_party hz_party_search.party_search_rec_type;
991: l_party_site hz_party_search.party_site_search_rec_type;
992: l_contact hz_party_search.contact_search_rec_type;
993: l_contact_point hz_party_search.contact_point_search_rec_type;
994: -- DQM list type
995: l_party_site_list hz_party_search.party_site_list;

Line 992: l_contact hz_party_search.contact_search_rec_type;

988: IS
989: -- DQM record types
990: l_party hz_party_search.party_search_rec_type;
991: l_party_site hz_party_search.party_site_search_rec_type;
992: l_contact hz_party_search.contact_search_rec_type;
993: l_contact_point hz_party_search.contact_point_search_rec_type;
994: -- DQM list type
995: l_party_site_list hz_party_search.party_site_list;
996: l_contact_list hz_party_search.contact_list;

Line 993: l_contact_point hz_party_search.contact_point_search_rec_type;

989: -- DQM record types
990: l_party hz_party_search.party_search_rec_type;
991: l_party_site hz_party_search.party_site_search_rec_type;
992: l_contact hz_party_search.contact_search_rec_type;
993: l_contact_point hz_party_search.contact_point_search_rec_type;
994: -- DQM list type
995: l_party_site_list hz_party_search.party_site_list;
996: l_contact_list hz_party_search.contact_list;
997: l_contact_point_list hz_party_search.contact_point_list;

Line 995: l_party_site_list hz_party_search.party_site_list;

991: l_party_site hz_party_search.party_site_search_rec_type;
992: l_contact hz_party_search.contact_search_rec_type;
993: l_contact_point hz_party_search.contact_point_search_rec_type;
994: -- DQM list type
995: l_party_site_list hz_party_search.party_site_list;
996: l_contact_list hz_party_search.contact_list;
997: l_contact_point_list hz_party_search.contact_point_list;
998: -- for error usage
999: tmp_var VARCHAR2(2000);

Line 996: l_contact_list hz_party_search.contact_list;

992: l_contact hz_party_search.contact_search_rec_type;
993: l_contact_point hz_party_search.contact_point_search_rec_type;
994: -- DQM list type
995: l_party_site_list hz_party_search.party_site_list;
996: l_contact_list hz_party_search.contact_list;
997: l_contact_point_list hz_party_search.contact_point_list;
998: -- for error usage
999: tmp_var VARCHAR2(2000);
1000: tmp_var1 VARCHAR2(2000);

Line 997: l_contact_point_list hz_party_search.contact_point_list;

993: l_contact_point hz_party_search.contact_point_search_rec_type;
994: -- DQM list type
995: l_party_site_list hz_party_search.party_site_list;
996: l_contact_list hz_party_search.contact_list;
997: l_contact_point_list hz_party_search.contact_point_list;
998: -- for error usage
999: tmp_var VARCHAR2(2000);
1000: tmp_var1 VARCHAR2(2000);
1001: l_party_id NUMBER;

Line 1433: hz_party_search.find_parties (

1429:
1430: l_contact_point_list := arh_dqm_pkg.Contact_point_list( p_contact_point =>l_contact_point);
1431:
1432: /*
1433: hz_party_search.find_parties (
1434: x_rule_id => x_rule_id,
1435: p_party_search_rec => l_party,
1436: p_party_site_list => l_party_site_list,
1437: p_contact_list => l_contact_list,

Line 1448: hz_party_search.find_party_details (

1444: x_msg_count => x_msg_count,
1445: x_msg_data => x_msg_data);
1446: */
1447:
1448: hz_party_search.find_party_details (
1449: p_rule_id => x_rule_id,
1450: p_party_search_rec => l_party,
1451: p_party_site_list => l_party_site_list,
1452: p_contact_list => l_contact_list,

Line 1482: hz_party_search.get_party_score_details (

1478: LOOP
1479: FETCH matched_parties INTO l_party_id, l_score;
1480: EXIT WHEN matched_parties%NOTFOUND;
1481:
1482: hz_party_search.get_party_score_details (
1483: p_rule_id => x_rule_id,
1484: p_party_id => l_party_id,
1485: p_search_ctx_id => x_search_ctx_id,
1486: p_party_search_rec => l_party,

Line 1569: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,

1565: PROCEDURE Get_Dqm_Exec_Details
1566: (p_party_id IN NUMBER,
1567: p_rule_id IN NUMBER,
1568: p_search_ctx_id IN NUMBER,
1569: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
1570: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
1571: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
1572: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
1573: x_msg_count IN OUT NOCOPY NUMBER,

Line 1570: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,

1566: (p_party_id IN NUMBER,
1567: p_rule_id IN NUMBER,
1568: p_search_ctx_id IN NUMBER,
1569: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
1570: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
1571: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
1572: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
1573: x_msg_count IN OUT NOCOPY NUMBER,
1574: x_msg_data IN OUT NOCOPY varchar2,

Line 1571: p_contact_list IN HZ_PARTY_SEARCH.contact_list,

1567: p_rule_id IN NUMBER,
1568: p_search_ctx_id IN NUMBER,
1569: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
1570: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
1571: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
1572: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
1573: x_msg_count IN OUT NOCOPY NUMBER,
1574: x_msg_data IN OUT NOCOPY varchar2,
1575: x_return_status IN OUT NOCOPY VARCHAR2)

Line 1572: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,

1568: p_search_ctx_id IN NUMBER,
1569: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
1570: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
1571: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
1572: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
1573: x_msg_count IN OUT NOCOPY NUMBER,
1574: x_msg_data IN OUT NOCOPY varchar2,
1575: x_return_status IN OUT NOCOPY VARCHAR2)
1576: IS

Line 1579: x_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;

1575: x_return_status IN OUT NOCOPY VARCHAR2)
1576: IS
1577: tmp_var VARCHAR2(2000);
1578: tmp_var1 VARCHAR2(2000);
1579: x_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
1580: x_party_site_list HZ_PARTY_SEARCH.party_site_list;
1581: x_contact_list HZ_PARTY_SEARCH.contact_list;
1582: x_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
1583: BEGIN

Line 1580: x_party_site_list HZ_PARTY_SEARCH.party_site_list;

1576: IS
1577: tmp_var VARCHAR2(2000);
1578: tmp_var1 VARCHAR2(2000);
1579: x_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
1580: x_party_site_list HZ_PARTY_SEARCH.party_site_list;
1581: x_contact_list HZ_PARTY_SEARCH.contact_list;
1582: x_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
1583: BEGIN
1584: hz_party_search.get_party_score_details (

Line 1581: x_contact_list HZ_PARTY_SEARCH.contact_list;

1577: tmp_var VARCHAR2(2000);
1578: tmp_var1 VARCHAR2(2000);
1579: x_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
1580: x_party_site_list HZ_PARTY_SEARCH.party_site_list;
1581: x_contact_list HZ_PARTY_SEARCH.contact_list;
1582: x_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
1583: BEGIN
1584: hz_party_search.get_party_score_details (
1585: p_rule_id => p_rule_id,

Line 1582: x_contact_point_list HZ_PARTY_SEARCH.contact_point_list;

1578: tmp_var1 VARCHAR2(2000);
1579: x_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
1580: x_party_site_list HZ_PARTY_SEARCH.party_site_list;
1581: x_contact_list HZ_PARTY_SEARCH.contact_list;
1582: x_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
1583: BEGIN
1584: hz_party_search.get_party_score_details (
1585: p_rule_id => p_rule_id,
1586: p_party_id => p_party_id,

Line 1584: hz_party_search.get_party_score_details (

1580: x_party_site_list HZ_PARTY_SEARCH.party_site_list;
1581: x_contact_list HZ_PARTY_SEARCH.contact_list;
1582: x_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
1583: BEGIN
1584: hz_party_search.get_party_score_details (
1585: p_rule_id => p_rule_id,
1586: p_party_id => p_party_id,
1587: p_search_ctx_id => p_search_ctx_id,
1588: p_party_search_rec => p_party_search_rec,

Line 1619: p_party_site_ids HZ_PARTY_SEARCH.IDList;

1615: x_msg_count IN OUT NOCOPY NUMBER,
1616: x_msg_data IN OUT NOCOPY varchar2,
1617: x_return_status IN OUT NOCOPY VARCHAR2)
1618: IS
1619: p_party_site_ids HZ_PARTY_SEARCH.IDList;
1620: p_contact_ids HZ_PARTY_SEARCH.IDList;
1621: p_contact_pt_ids HZ_PARTY_SEARCH.IDList;
1622: x_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
1623: x_party_site_list HZ_PARTY_SEARCH.party_site_list;

Line 1620: p_contact_ids HZ_PARTY_SEARCH.IDList;

1616: x_msg_data IN OUT NOCOPY varchar2,
1617: x_return_status IN OUT NOCOPY VARCHAR2)
1618: IS
1619: p_party_site_ids HZ_PARTY_SEARCH.IDList;
1620: p_contact_ids HZ_PARTY_SEARCH.IDList;
1621: p_contact_pt_ids HZ_PARTY_SEARCH.IDList;
1622: x_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
1623: x_party_site_list HZ_PARTY_SEARCH.party_site_list;
1624: x_contact_list HZ_PARTY_SEARCH.contact_list;

Line 1621: p_contact_pt_ids HZ_PARTY_SEARCH.IDList;

1617: x_return_status IN OUT NOCOPY VARCHAR2)
1618: IS
1619: p_party_site_ids HZ_PARTY_SEARCH.IDList;
1620: p_contact_ids HZ_PARTY_SEARCH.IDList;
1621: p_contact_pt_ids HZ_PARTY_SEARCH.IDList;
1622: x_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
1623: x_party_site_list HZ_PARTY_SEARCH.party_site_list;
1624: x_contact_list HZ_PARTY_SEARCH.contact_list;
1625: x_contact_point_list HZ_PARTY_SEARCH.contact_point_list;

Line 1622: x_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;

1618: IS
1619: p_party_site_ids HZ_PARTY_SEARCH.IDList;
1620: p_contact_ids HZ_PARTY_SEARCH.IDList;
1621: p_contact_pt_ids HZ_PARTY_SEARCH.IDList;
1622: x_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
1623: x_party_site_list HZ_PARTY_SEARCH.party_site_list;
1624: x_contact_list HZ_PARTY_SEARCH.contact_list;
1625: x_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
1626: CURSOR c_ps

Line 1623: x_party_site_list HZ_PARTY_SEARCH.party_site_list;

1619: p_party_site_ids HZ_PARTY_SEARCH.IDList;
1620: p_contact_ids HZ_PARTY_SEARCH.IDList;
1621: p_contact_pt_ids HZ_PARTY_SEARCH.IDList;
1622: x_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
1623: x_party_site_list HZ_PARTY_SEARCH.party_site_list;
1624: x_contact_list HZ_PARTY_SEARCH.contact_list;
1625: x_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
1626: CURSOR c_ps
1627: IS

Line 1624: x_contact_list HZ_PARTY_SEARCH.contact_list;

1620: p_contact_ids HZ_PARTY_SEARCH.IDList;
1621: p_contact_pt_ids HZ_PARTY_SEARCH.IDList;
1622: x_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
1623: x_party_site_list HZ_PARTY_SEARCH.party_site_list;
1624: x_contact_list HZ_PARTY_SEARCH.contact_list;
1625: x_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
1626: CURSOR c_ps
1627: IS
1628: SELECT party_site_id

Line 1625: x_contact_point_list HZ_PARTY_SEARCH.contact_point_list;

1621: p_contact_pt_ids HZ_PARTY_SEARCH.IDList;
1622: x_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
1623: x_party_site_list HZ_PARTY_SEARCH.party_site_list;
1624: x_contact_list HZ_PARTY_SEARCH.contact_list;
1625: x_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
1626: CURSOR c_ps
1627: IS
1628: SELECT party_site_id
1629: FROM hz_party_sites

Line 1740: HZ_PARTY_SEARCH.get_search_criteria

1736: p_contact_pt_ids(i) := l_id;
1737: END LOOP;
1738: CLOSE c_cpt;
1739:
1740: HZ_PARTY_SEARCH.get_search_criteria
1741: (p_init_msg_list => FND_API.G_TRUE,
1742: p_rule_id => p_rule_id,
1743: p_party_id => p_party_id,
1744: p_party_site_ids => p_party_site_ids,

Line 1766: hz_party_search.find_party_details (

1762: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1763: RETURN;
1764: END IF;
1765:
1766: hz_party_search.find_party_details (
1767: p_init_msg_list => FND_API.G_TRUE,
1768: p_rule_id => p_rule_id,
1769: p_party_search_rec => x_party_search_rec,
1770: p_party_site_list => x_party_site_list,

Line 1799: hz_party_search.get_party_score_details (

1795: LOOP
1796: FETCH matched_parties INTO l_party_id, l_score;
1797: EXIT WHEN matched_parties%NOTFOUND;
1798:
1799: hz_party_search.get_party_score_details (
1800: p_rule_id => p_rule_id,
1801: p_party_id => l_party_id,
1802: p_search_ctx_id => x_search_ctx_id,
1803: p_party_search_rec => x_party_search_rec,

Line 1861: hz_party_search.get_party_score_details (

1857: LOOP
1858: FETCH matched_parties INTO l_party_id, l_score;
1859: EXIT WHEN matched_parties%NOTFOUND;
1860:
1861: hz_party_search.get_party_score_details (
1862: p_rule_id => p_rule_id,
1863: p_party_id => l_party_id,
1864: p_search_ctx_id => x_search_ctx_id,
1865: p_party_search_rec => x_party_search_rec,