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:
419: p_party_id IN NUMBER
420: ,p_record_id IN NUMBER
421: ,p_search_ctx_id IN NUMBER
422: ,p_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type
423: ,p_stage_rec IN HZ_PARTY_STAGE.party_stage_rec_type
424: ,p_table_TX39 VARCHAR2
425: ,p_table_TX40 VARCHAR2
426: ,p_table_TX41 VARCHAR2
427: ,p_table_TX44 VARCHAR2
520: p_party_id IN NUMBER
521: ,p_record_id IN NUMBER
522: ,p_search_ctx_id IN NUMBER
523: ,p_search_rec IN HZ_PARTY_SEARCH.party_site_search_rec_type
524: ,p_stage_rec IN HZ_PARTY_STAGE.party_site_stage_rec_type
525: ,p_table_TX3 VARCHAR2
526: ,p_table_TX4 VARCHAR2
527: ,p_table_TX11 VARCHAR2
528: ,p_idx IN NUMBER) IS
595: p_party_id IN NUMBER
596: ,p_record_id IN NUMBER
597: ,p_search_ctx_id IN NUMBER
598: ,p_search_rec IN HZ_PARTY_SEARCH.contact_search_rec_type
599: ,p_stage_rec IN HZ_PARTY_STAGE.contact_stage_rec_type
600: ,p_table_TX5 VARCHAR2
601: ,p_table_TX2 VARCHAR2
602: ,p_idx IN NUMBER) IS
603: l_current_score NUMBER:=0;
644: p_party_id IN NUMBER
645: ,p_record_id IN NUMBER
646: ,p_search_ctx_id IN NUMBER
647: ,p_search_rec IN HZ_PARTY_SEARCH.contact_point_search_rec_type
648: ,p_stage_rec IN HZ_PARTY_STAGE.contact_pt_stage_rec_type
649: ,p_table_TX1 VARCHAR2
650: ,p_idx IN NUMBER) IS
651: l_current_score NUMBER:=0;
652: l_score NUMBER;
1282: p_restrict_sql VARCHAR2,
1283: p_match_str VARCHAR2,
1284: p_search_merged VARCHAR2,
1285: p_party_contains_str VARCHAR2,
1286: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
1287: l_sqlstr VARCHAR2(4000);
1288: l_search_merged VARCHAR2(1);
1289: BEGIN
1290: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1415: p_contains_str VARCHAR2,
1416: p_search_ctx_id NUMBER,
1417: p_match_str VARCHAR2,
1418: p_search_merged VARCHAR2,
1419: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
1420: l_sqlstr VARCHAR2(4000);
1421: l_hint VARCHAR2(100);
1422: l_check NUMBER;
1423: l_search_merged VARCHAR2(1);
1535: p_search_ctx_id NUMBER,
1536: p_search_merged VARCHAR2,
1537: p_search_rel_sites VARCHAR2,
1538: p_person_api VARCHAR2,
1539: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
1540: l_sqlstr VARCHAR2(4000);
1541: l_hint VARCHAR2(100);
1542: l_check NUMBER;
1543: l_check_dt NUMBER;
1778: p_restrict_sql VARCHAR2,
1779: p_contains_str VARCHAR2,
1780: p_search_ctx_id NUMBER,
1781: p_search_merged VARCHAR2,
1782: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
1783: l_sqlstr VARCHAR2(4000);
1784: l_hint VARCHAR2(100);
1785: l_check NUMBER;
1786: l_check_dt NUMBER;
1927: p_search_ctx_id NUMBER,
1928: p_search_merged VARCHAR2,
1929: p_search_rel_cpts VARCHAR2,
1930: p_person_api VARCHAR2,
1931: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp,
1932: p_restrict_entity VARCHAR2 DEFAULT NULL) IS
1933: l_sqlstr VARCHAR2(4000);
1934: l_hint VARCHAR2(100);
1935: l_check NUMBER;
2323: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
2324:
2325: l_score NUMBER;
2326: l_idx NUMBER;
2327: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
2328: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
2329: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
2330: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
2331: l_party_id NUMBER;
2324:
2325: l_score NUMBER;
2326: l_idx NUMBER;
2327: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
2328: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
2329: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
2330: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
2331: l_party_id NUMBER;
2332: l_ps_party_id NUMBER;
2325: l_score NUMBER;
2326: l_idx NUMBER;
2327: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
2328: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
2329: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
2330: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
2331: l_party_id NUMBER;
2332: l_ps_party_id NUMBER;
2333: l_ct_party_id NUMBER;
2326: l_idx NUMBER;
2327: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
2328: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
2329: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
2330: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
2331: l_party_id NUMBER;
2332: l_ps_party_id NUMBER;
2333: l_ct_party_id NUMBER;
2334: l_cpt_party_id NUMBER;
3281: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
3282:
3283: l_score NUMBER;
3284: l_idx NUMBER;
3285: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
3286: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
3287: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
3288: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
3289: l_party_id NUMBER;
3282:
3283: l_score NUMBER;
3284: l_idx NUMBER;
3285: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
3286: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
3287: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
3288: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
3289: l_party_id NUMBER;
3290: l_ps_party_id NUMBER;
3283: l_score NUMBER;
3284: l_idx NUMBER;
3285: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
3286: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
3287: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
3288: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
3289: l_party_id NUMBER;
3290: l_ps_party_id NUMBER;
3291: l_ct_party_id NUMBER;
3284: l_idx NUMBER;
3285: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
3286: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
3287: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
3288: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
3289: l_party_id NUMBER;
3290: l_ps_party_id NUMBER;
3291: l_ct_party_id NUMBER;
3292: l_cpt_party_id NUMBER;
3484: END;
3485: PROCEDURE open_person_contact_cursor(
3486: p_contains_str VARCHAR2,
3487: p_search_ctx_id NUMBER,
3488: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
3489: BEGIN
3490: OPEN x_cursor FOR
3491: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID, TX5, TX2
3492: FROM HZ_STAGED_CONTACTS stage
4859: H_SCORES HZ_PARTY_SEARCH.score_list;
4860:
4861: l_score NUMBER;
4862: l_idx NUMBER;
4863: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
4864: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
4865: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
4866: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
4867: l_party_id NUMBER;
4860:
4861: l_score NUMBER;
4862: l_idx NUMBER;
4863: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
4864: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
4865: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
4866: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
4867: l_party_id NUMBER;
4868: l_ps_party_id NUMBER;
4861: l_score NUMBER;
4862: l_idx NUMBER;
4863: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
4864: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
4865: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
4866: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
4867: l_party_id NUMBER;
4868: l_ps_party_id NUMBER;
4869: l_ct_party_id NUMBER;
4862: l_idx NUMBER;
4863: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
4864: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
4865: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
4866: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
4867: l_party_id NUMBER;
4868: l_ps_party_id NUMBER;
4869: l_ct_party_id NUMBER;
4870: l_cpt_party_id NUMBER;
5094: H_SCORES HZ_PARTY_SEARCH.score_list;
5095:
5096: l_score NUMBER;
5097: l_idx NUMBER;
5098: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
5099: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
5100: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
5101: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
5102: l_party_id NUMBER;
5095:
5096: l_score NUMBER;
5097: l_idx NUMBER;
5098: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
5099: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
5100: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
5101: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
5102: l_party_id NUMBER;
5103: l_ps_party_id NUMBER;
5096: l_score NUMBER;
5097: l_idx NUMBER;
5098: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
5099: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
5100: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
5101: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
5102: l_party_id NUMBER;
5103: l_ps_party_id NUMBER;
5104: l_ct_party_id NUMBER;
5097: l_idx NUMBER;
5098: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
5099: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
5100: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
5101: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
5102: l_party_id NUMBER;
5103: l_ps_party_id NUMBER;
5104: l_ct_party_id NUMBER;
5105: l_cpt_party_id NUMBER;
5313: l_TX1 VARCHAR2(2000);
5314:
5315: l_score NUMBER;
5316: l_idx NUMBER;
5317: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
5318: l_cpt_party_id NUMBER;
5319: l_cpt_ps_id NUMBER;
5320: l_cpt_contact_id NUMBER;
5321: l_contact_pt_id NUMBER;
5481:
5482: l_score NUMBER;
5483: l_match_idx NUMBER;
5484: l_idx NUMBER;
5485: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
5486: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
5487: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
5488: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
5489: l_party_id NUMBER;
5482: l_score NUMBER;
5483: l_match_idx NUMBER;
5484: l_idx NUMBER;
5485: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
5486: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
5487: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
5488: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
5489: l_party_id NUMBER;
5490: l_ps_party_id NUMBER;
5483: l_match_idx NUMBER;
5484: l_idx NUMBER;
5485: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
5486: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
5487: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
5488: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
5489: l_party_id NUMBER;
5490: l_ps_party_id NUMBER;
5491: l_ct_party_id NUMBER;
5484: l_idx NUMBER;
5485: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
5486: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
5487: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
5488: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
5489: l_party_id NUMBER;
5490: l_ps_party_id NUMBER;
5491: l_ct_party_id NUMBER;
5492: l_cpt_party_id NUMBER;
6058: PROCEDURE MAP_PARTY_REC(
6059: p_search_ctx IN BOOLEAN,
6060: p_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
6061: x_entered_max_score OUT NUMBER,
6062: x_stage_rec IN OUT NOCOPY HZ_PARTY_STAGE.party_stage_rec_type
6063: ) IS
6064: tmp VARCHAR2(4000);
6065: l_party_name VARCHAR2(4000);
6066: BEGIN
6200: PROCEDURE MAP_PARTY_SITE_REC(
6201: p_search_ctx IN BOOLEAN,
6202: p_search_list IN HZ_PARTY_SEARCH.party_site_list,
6203: x_entered_max_score OUT NUMBER,
6204: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.party_site_stage_list
6205: ) IS
6206: l_current_max_score NUMBER;
6207: tmp VARCHAR2(4000);
6208: BEGIN
6318: PROCEDURE MAP_CONTACT_REC(
6319: p_search_ctx IN BOOLEAN,
6320: p_search_list IN HZ_PARTY_SEARCH.contact_list,
6321: x_entered_max_score OUT NUMBER,
6322: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.contact_stage_list
6323: ) IS
6324: l_current_max_score NUMBER;
6325: tmp VARCHAR2(4000);
6326: BEGIN
6398: PROCEDURE MAP_CONTACT_POINT_REC(
6399: p_search_ctx IN BOOLEAN,
6400: p_search_list IN HZ_PARTY_SEARCH.contact_point_list,
6401: x_entered_max_score OUT NUMBER,
6402: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.contact_pt_stage_list
6403: ) IS
6404: l_current_max_score NUMBER;
6405: tmp VARCHAR2(4000);
6406: TYPE INDEX_VARCHAR100_TBL IS TABLE OF NUMBER INDEX BY VARCHAR2(100);