APPS.HZ_PARTY_ACQUIRE dependencies on HZ_PARTY_SEARCH

Line 43: ) RETURN HZ_PARTY_SEARCH.party_search_rec_type IS

39:
40: FUNCTION get_party_rec (
41: p_party_id IN NUMBER,
42: p_party_type IN VARCHAR2
43: ) RETURN HZ_PARTY_SEARCH.party_search_rec_type IS
44: CURSOR org IS
45: SELECT o.ANALYSIS_FY
46: ,o.AVG_HIGH_CREDIT
47: ,o.BEST_TIME_CONTACT_BEGIN

Line 253: l_party_search_rec HZ_PARTY_SEARCH.PARTY_SEARCH_REC_TYPE;

249: l_val VARCHAR2(2000);
250:
251: l_return_status VARCHAR2(1);
252:
253: l_party_search_rec HZ_PARTY_SEARCH.PARTY_SEARCH_REC_TYPE;
254: NUM NUMBER;
255: c NUMBER;
256:
257: l_sql VARCHAR2(255);

Line 601: ) RETURN HZ_PARTY_SEARCH.party_site_search_rec_type IS

597:
598:
599: FUNCTION get_party_site_rec (
600: p_party_site_id IN NUMBER
601: ) RETURN HZ_PARTY_SEARCH.party_site_search_rec_type IS
602:
603: CURSOR c_party_site IS
604: SELECT l.ADDRESS1
605: ,l.ADDRESS2

Line 654: l_party_site_search_rec HZ_PARTY_SEARCH.PARTY_SITE_SEARCH_REC_TYPE;

650: l_proc_name VARCHAR2(255);
651: plsql_block VARCHAR2(32000);
652: l_val VARCHAR2(2000);
653:
654: l_party_site_search_rec HZ_PARTY_SEARCH.PARTY_SITE_SEARCH_REC_TYPE;
655: l_return_status VARCHAR2(1);
656:
657: NUM NUMBER;
658: c NUMBER;

Line 845: ) RETURN HZ_PARTY_SEARCH.contact_search_rec_type IS

841:
842:
843: FUNCTION get_contact_rec (
844: p_org_contact_id IN NUMBER
845: ) RETURN HZ_PARTY_SEARCH.contact_search_rec_type IS
846:
847: CURSOR c_org_contact IS
848: SELECT o.CONTACT_NUMBER
849: ,o.DECISION_MAKER_FLAG

Line 906: l_contact_search_rec HZ_PARTY_SEARCH.contact_search_rec_type;

902: l_proc_name VARCHAR2(255);
903: plsql_block VARCHAR2(32000);
904: l_val VARCHAR2(2000);
905:
906: l_contact_search_rec HZ_PARTY_SEARCH.contact_search_rec_type;
907: l_subject_id NUMBER;
908: l_return_status VARCHAR2(1);
909:
910: NUM NUMBER;

Line 1098: ) RETURN HZ_PARTY_SEARCH.contact_point_search_rec_type IS

1094:
1095:
1096: FUNCTION get_contact_point_rec (
1097: p_contact_point_id IN NUMBER
1098: ) RETURN HZ_PARTY_SEARCH.contact_point_search_rec_type IS
1099:
1100: CURSOR cpt IS
1101: SELECT CONTACT_POINT_TYPE
1102: ,CONTENT_SOURCE_TYPE

Line 1142: l_contact_pt_search_rec HZ_PARTY_SEARCH.contact_point_search_rec_type;

1138: l_proc_name VARCHAR2(255);
1139: plsql_block VARCHAR2(32000);
1140: l_val VARCHAR2(2000);
1141:
1142: l_contact_pt_search_rec HZ_PARTY_SEARCH.contact_point_search_rec_type;
1143: l_return_status VARCHAR2(1);
1144:
1145: NUM NUMBER;
1146: c NUMBER;