30: TYPE vlisttype IS TABLE of VARCHAR2(255) INDEX BY BINARY_INTEGER ;
31: call_order vlisttype;
32: call_max_score HZ_PARTY_SEARCH.IDList;
33: call_type vlisttype;
34: g_party_stage_rec HZ_PARTY_STAGE.party_stage_rec_type;
35: g_party_site_stage_list HZ_PARTY_STAGE.party_site_stage_list;
36: g_contact_stage_list HZ_PARTY_STAGE.contact_stage_list;
37: g_contact_pt_stage_list HZ_PARTY_STAGE.contact_pt_stage_list;
38: g_mappings HZ_PARTY_SEARCH.IDList;
31: call_order vlisttype;
32: call_max_score HZ_PARTY_SEARCH.IDList;
33: call_type vlisttype;
34: g_party_stage_rec HZ_PARTY_STAGE.party_stage_rec_type;
35: g_party_site_stage_list HZ_PARTY_STAGE.party_site_stage_list;
36: g_contact_stage_list HZ_PARTY_STAGE.contact_stage_list;
37: g_contact_pt_stage_list HZ_PARTY_STAGE.contact_pt_stage_list;
38: g_mappings HZ_PARTY_SEARCH.IDList;
39: g_max_id NUMBER:=2000000000;
32: call_max_score HZ_PARTY_SEARCH.IDList;
33: call_type vlisttype;
34: g_party_stage_rec HZ_PARTY_STAGE.party_stage_rec_type;
35: g_party_site_stage_list HZ_PARTY_STAGE.party_site_stage_list;
36: g_contact_stage_list HZ_PARTY_STAGE.contact_stage_list;
37: g_contact_pt_stage_list HZ_PARTY_STAGE.contact_pt_stage_list;
38: g_mappings HZ_PARTY_SEARCH.IDList;
39: g_max_id NUMBER:=2000000000;
40: g_other_party_level_attribs BOOLEAN;
33: call_type vlisttype;
34: g_party_stage_rec HZ_PARTY_STAGE.party_stage_rec_type;
35: g_party_site_stage_list HZ_PARTY_STAGE.party_site_stage_list;
36: g_contact_stage_list HZ_PARTY_STAGE.contact_stage_list;
37: g_contact_pt_stage_list HZ_PARTY_STAGE.contact_pt_stage_list;
38: g_mappings HZ_PARTY_SEARCH.IDList;
39: g_max_id NUMBER:=2000000000;
40: g_other_party_level_attribs BOOLEAN;
41:
402: p_party_id IN NUMBER
403: ,p_record_id IN NUMBER
404: ,p_search_ctx_id IN NUMBER
405: ,p_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type
406: ,p_stage_rec IN HZ_PARTY_STAGE.party_stage_rec_type
407: ,p_table_TX4 VARCHAR2
408: ,p_table_TX45 VARCHAR2
409: ,p_table_TX46 VARCHAR2
410: ,p_idx IN NUMBER) IS
496: p_party_id IN NUMBER
497: ,p_record_id IN NUMBER
498: ,p_search_ctx_id IN NUMBER
499: ,p_search_rec IN HZ_PARTY_SEARCH.party_site_search_rec_type
500: ,p_stage_rec IN HZ_PARTY_STAGE.party_site_stage_rec_type
501: ,p_table_TX4 VARCHAR2
502: ,p_table_TX11 VARCHAR2
503: ,p_idx IN NUMBER) IS
504: l_current_score NUMBER:=0;
564: p_party_id IN NUMBER
565: ,p_record_id IN NUMBER
566: ,p_search_ctx_id IN NUMBER
567: ,p_search_rec IN HZ_PARTY_SEARCH.contact_search_rec_type
568: ,p_stage_rec IN HZ_PARTY_STAGE.contact_stage_rec_type
569: ,p_idx IN NUMBER) IS
570: l_current_score NUMBER:=0;
571: l_score NUMBER;
572: l_attrib_value VARCHAR2(2000);
580: p_party_id IN NUMBER
581: ,p_record_id IN NUMBER
582: ,p_search_ctx_id IN NUMBER
583: ,p_search_rec IN HZ_PARTY_SEARCH.contact_point_search_rec_type
584: ,p_stage_rec IN HZ_PARTY_STAGE.contact_pt_stage_rec_type
585: ,p_table_TX2 VARCHAR2
586: ,p_idx IN NUMBER) IS
587: l_current_score NUMBER:=0;
588: l_score NUMBER;
1184: p_restrict_sql VARCHAR2,
1185: p_match_str VARCHAR2,
1186: p_search_merged VARCHAR2,
1187: p_party_contains_str VARCHAR2,
1188: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
1189: l_sqlstr VARCHAR2(4000);
1190: l_search_merged VARCHAR2(1);
1191: BEGIN
1192: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1303: p_contains_str VARCHAR2,
1304: p_search_ctx_id NUMBER,
1305: p_match_str VARCHAR2,
1306: p_search_merged VARCHAR2,
1307: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
1308: l_sqlstr VARCHAR2(4000);
1309: l_hint VARCHAR2(100);
1310: l_check NUMBER;
1311: l_search_merged VARCHAR2(1);
1425: p_search_ctx_id NUMBER,
1426: p_search_merged VARCHAR2,
1427: p_search_rel_sites VARCHAR2,
1428: p_person_api VARCHAR2,
1429: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
1430: l_sqlstr VARCHAR2(4000);
1431: l_hint VARCHAR2(100);
1432: l_check NUMBER;
1433: l_check_dt NUMBER;
1668: p_restrict_sql VARCHAR2,
1669: p_contains_str VARCHAR2,
1670: p_search_ctx_id NUMBER,
1671: p_search_merged VARCHAR2,
1672: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
1673: l_sqlstr VARCHAR2(4000);
1674: l_hint VARCHAR2(100);
1675: l_check NUMBER;
1676: l_check_dt NUMBER;
1817: p_search_ctx_id NUMBER,
1818: p_search_merged VARCHAR2,
1819: p_search_rel_cpts VARCHAR2,
1820: p_person_api VARCHAR2,
1821: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp,
1822: p_restrict_entity VARCHAR2 DEFAULT NULL) IS
1823: l_sqlstr VARCHAR2(4000);
1824: l_hint VARCHAR2(100);
1825: l_check NUMBER;
2208: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
2209:
2210: l_score NUMBER;
2211: l_idx NUMBER;
2212: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
2213: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
2214: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
2215: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
2216: l_party_id NUMBER;
2209:
2210: l_score NUMBER;
2211: l_idx NUMBER;
2212: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
2213: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
2214: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
2215: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
2216: l_party_id NUMBER;
2217: l_ps_party_id NUMBER;
2210: l_score NUMBER;
2211: l_idx NUMBER;
2212: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
2213: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
2214: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
2215: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
2216: l_party_id NUMBER;
2217: l_ps_party_id NUMBER;
2218: l_ct_party_id NUMBER;
2211: l_idx NUMBER;
2212: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
2213: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
2214: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
2215: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
2216: l_party_id NUMBER;
2217: l_ps_party_id NUMBER;
2218: l_ct_party_id NUMBER;
2219: l_cpt_party_id NUMBER;
3162: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
3163:
3164: l_score NUMBER;
3165: l_idx NUMBER;
3166: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
3167: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
3168: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
3169: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
3170: l_party_id NUMBER;
3163:
3164: l_score NUMBER;
3165: l_idx NUMBER;
3166: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
3167: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
3168: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
3169: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
3170: l_party_id NUMBER;
3171: l_ps_party_id NUMBER;
3164: l_score NUMBER;
3165: l_idx NUMBER;
3166: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
3167: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
3168: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
3169: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
3170: l_party_id NUMBER;
3171: l_ps_party_id NUMBER;
3172: l_ct_party_id NUMBER;
3165: l_idx NUMBER;
3166: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
3167: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
3168: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
3169: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
3170: l_party_id NUMBER;
3171: l_ps_party_id NUMBER;
3172: l_ct_party_id NUMBER;
3173: l_cpt_party_id NUMBER;
3366: END;
3367: PROCEDURE open_person_contact_cursor(
3368: p_contains_str VARCHAR2,
3369: p_search_ctx_id NUMBER,
3370: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
3371: BEGIN
3372: OPEN x_cursor FOR
3373: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID
3374: FROM HZ_STAGED_CONTACTS stage
4726: H_SCORES HZ_PARTY_SEARCH.score_list;
4727:
4728: l_score NUMBER;
4729: l_idx NUMBER;
4730: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
4731: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
4732: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
4733: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
4734: l_party_id NUMBER;
4727:
4728: l_score NUMBER;
4729: l_idx NUMBER;
4730: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
4731: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
4732: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
4733: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
4734: l_party_id NUMBER;
4735: l_ps_party_id NUMBER;
4728: l_score NUMBER;
4729: l_idx NUMBER;
4730: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
4731: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
4732: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
4733: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
4734: l_party_id NUMBER;
4735: l_ps_party_id NUMBER;
4736: l_ct_party_id NUMBER;
4729: l_idx NUMBER;
4730: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
4731: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
4732: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
4733: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
4734: l_party_id NUMBER;
4735: l_ps_party_id NUMBER;
4736: l_ct_party_id NUMBER;
4737: l_cpt_party_id NUMBER;
4959: H_SCORES HZ_PARTY_SEARCH.score_list;
4960:
4961: l_score NUMBER;
4962: l_idx NUMBER;
4963: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
4964: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
4965: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
4966: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
4967: l_party_id NUMBER;
4960:
4961: l_score NUMBER;
4962: l_idx NUMBER;
4963: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
4964: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
4965: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
4966: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
4967: l_party_id NUMBER;
4968: l_ps_party_id NUMBER;
4961: l_score NUMBER;
4962: l_idx NUMBER;
4963: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
4964: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
4965: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
4966: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
4967: l_party_id NUMBER;
4968: l_ps_party_id NUMBER;
4969: l_ct_party_id NUMBER;
4962: l_idx NUMBER;
4963: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
4964: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
4965: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
4966: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
4967: l_party_id NUMBER;
4968: l_ps_party_id NUMBER;
4969: l_ct_party_id NUMBER;
4970: l_cpt_party_id NUMBER;
5178: l_TX2 VARCHAR2(2000);
5179:
5180: l_score NUMBER;
5181: l_idx NUMBER;
5182: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
5183: l_cpt_party_id NUMBER;
5184: l_cpt_ps_id NUMBER;
5185: l_cpt_contact_id NUMBER;
5186: l_contact_pt_id NUMBER;
5336:
5337: l_score NUMBER;
5338: l_match_idx NUMBER;
5339: l_idx NUMBER;
5340: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
5341: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
5342: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
5343: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
5344: l_party_id NUMBER;
5337: l_score NUMBER;
5338: l_match_idx NUMBER;
5339: l_idx NUMBER;
5340: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
5341: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
5342: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
5343: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
5344: l_party_id NUMBER;
5345: l_ps_party_id NUMBER;
5338: l_match_idx NUMBER;
5339: l_idx NUMBER;
5340: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
5341: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
5342: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
5343: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
5344: l_party_id NUMBER;
5345: l_ps_party_id NUMBER;
5346: l_ct_party_id NUMBER;
5339: l_idx NUMBER;
5340: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
5341: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
5342: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
5343: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
5344: l_party_id NUMBER;
5345: l_ps_party_id NUMBER;
5346: l_ct_party_id NUMBER;
5347: l_cpt_party_id NUMBER;
5888: PROCEDURE MAP_PARTY_REC(
5889: p_search_ctx IN BOOLEAN,
5890: p_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
5891: x_entered_max_score OUT NUMBER,
5892: x_stage_rec IN OUT NOCOPY HZ_PARTY_STAGE.party_stage_rec_type
5893: ) IS
5894: tmp VARCHAR2(4000);
5895: l_party_name VARCHAR2(4000);
5896: BEGIN
6007: PROCEDURE MAP_PARTY_SITE_REC(
6008: p_search_ctx IN BOOLEAN,
6009: p_search_list IN HZ_PARTY_SEARCH.party_site_list,
6010: x_entered_max_score OUT NUMBER,
6011: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.party_site_stage_list
6012: ) IS
6013: l_current_max_score NUMBER;
6014: tmp VARCHAR2(4000);
6015: BEGIN
6102: PROCEDURE MAP_CONTACT_REC(
6103: p_search_ctx IN BOOLEAN,
6104: p_search_list IN HZ_PARTY_SEARCH.contact_list,
6105: x_entered_max_score OUT NUMBER,
6106: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.contact_stage_list
6107: ) IS
6108: l_current_max_score NUMBER;
6109: tmp VARCHAR2(4000);
6110: BEGIN
6144: PROCEDURE MAP_CONTACT_POINT_REC(
6145: p_search_ctx IN BOOLEAN,
6146: p_search_list IN HZ_PARTY_SEARCH.contact_point_list,
6147: x_entered_max_score OUT NUMBER,
6148: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.contact_pt_stage_list
6149: ) IS
6150: l_current_max_score NUMBER;
6151: tmp VARCHAR2(4000);
6152: TYPE INDEX_VARCHAR100_TBL IS TABLE OF NUMBER INDEX BY VARCHAR2(100);