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:
574: p_party_id IN NUMBER
575: ,p_record_id IN NUMBER
576: ,p_search_ctx_id IN NUMBER
577: ,p_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type
578: ,p_stage_rec IN HZ_PARTY_STAGE.party_stage_rec_type
579: ,p_table_TX34 VARCHAR2
580: ,p_table_TX35 VARCHAR2
581: ,p_table_TX40 VARCHAR2
582: ,p_table_TX39 VARCHAR2
701: p_party_id IN NUMBER
702: ,p_record_id IN NUMBER
703: ,p_search_ctx_id IN NUMBER
704: ,p_search_rec IN HZ_PARTY_SEARCH.party_site_search_rec_type
705: ,p_stage_rec IN HZ_PARTY_STAGE.party_site_stage_rec_type
706: ,p_table_TX3 VARCHAR2
707: ,p_table_TX4 VARCHAR2
708: ,p_table_TX9 VARCHAR2
709: ,p_table_TX10 VARCHAR2
901: p_party_id IN NUMBER
902: ,p_record_id IN NUMBER
903: ,p_search_ctx_id IN NUMBER
904: ,p_search_rec IN HZ_PARTY_SEARCH.contact_search_rec_type
905: ,p_stage_rec IN HZ_PARTY_STAGE.contact_stage_rec_type
906: ,p_table_TX22 VARCHAR2
907: ,p_idx IN NUMBER) IS
908: l_current_score NUMBER:=0;
909: l_score NUMBER;
943: p_party_id IN NUMBER
944: ,p_record_id IN NUMBER
945: ,p_search_ctx_id IN NUMBER
946: ,p_search_rec IN HZ_PARTY_SEARCH.contact_point_search_rec_type
947: ,p_stage_rec IN HZ_PARTY_STAGE.contact_pt_stage_rec_type
948: ,p_table_TX1 VARCHAR2
949: ,p_table_TX6 VARCHAR2
950: ,p_table_TX5 VARCHAR2
951: ,p_idx IN NUMBER) IS
1684: p_restrict_sql VARCHAR2,
1685: p_match_str VARCHAR2,
1686: p_search_merged VARCHAR2,
1687: p_party_contains_str VARCHAR2,
1688: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
1689: l_sqlstr VARCHAR2(4000);
1690: l_search_merged VARCHAR2(1);
1691: BEGIN
1692: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1848: p_contains_str VARCHAR2,
1849: p_search_ctx_id NUMBER,
1850: p_match_str VARCHAR2,
1851: p_search_merged VARCHAR2,
1852: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
1853: l_sqlstr VARCHAR2(4000);
1854: l_hint VARCHAR2(100);
1855: l_check NUMBER;
1856: l_search_merged VARCHAR2(1);
1968: p_search_ctx_id NUMBER,
1969: p_search_merged VARCHAR2,
1970: p_search_rel_sites VARCHAR2,
1971: p_person_api VARCHAR2,
1972: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
1973: l_sqlstr VARCHAR2(4000);
1974: l_hint VARCHAR2(100);
1975: l_check NUMBER;
1976: l_check_dt NUMBER;
2211: p_restrict_sql VARCHAR2,
2212: p_contains_str VARCHAR2,
2213: p_search_ctx_id NUMBER,
2214: p_search_merged VARCHAR2,
2215: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
2216: l_sqlstr VARCHAR2(4000);
2217: l_hint VARCHAR2(100);
2218: l_check NUMBER;
2219: l_check_dt NUMBER;
2360: p_search_ctx_id NUMBER,
2361: p_search_merged VARCHAR2,
2362: p_search_rel_cpts VARCHAR2,
2363: p_person_api VARCHAR2,
2364: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp,
2365: p_restrict_entity VARCHAR2 DEFAULT NULL) IS
2366: l_sqlstr VARCHAR2(4000);
2367: l_hint VARCHAR2(100);
2368: l_check NUMBER;
2764: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
2765:
2766: l_score NUMBER;
2767: l_idx NUMBER;
2768: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
2769: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
2770: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
2771: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
2772: l_party_id NUMBER;
2765:
2766: l_score NUMBER;
2767: l_idx NUMBER;
2768: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
2769: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
2770: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
2771: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
2772: l_party_id NUMBER;
2773: l_ps_party_id NUMBER;
2766: l_score NUMBER;
2767: l_idx NUMBER;
2768: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
2769: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
2770: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
2771: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
2772: l_party_id NUMBER;
2773: l_ps_party_id NUMBER;
2774: l_ct_party_id NUMBER;
2767: l_idx NUMBER;
2768: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
2769: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
2770: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
2771: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
2772: l_party_id NUMBER;
2773: l_ps_party_id NUMBER;
2774: l_ct_party_id NUMBER;
2775: l_cpt_party_id NUMBER;
3730: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
3731:
3732: l_score NUMBER;
3733: l_idx NUMBER;
3734: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
3735: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
3736: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
3737: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
3738: l_party_id NUMBER;
3731:
3732: l_score NUMBER;
3733: l_idx NUMBER;
3734: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
3735: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
3736: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
3737: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
3738: l_party_id NUMBER;
3739: l_ps_party_id NUMBER;
3732: l_score NUMBER;
3733: l_idx NUMBER;
3734: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
3735: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
3736: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
3737: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
3738: l_party_id NUMBER;
3739: l_ps_party_id NUMBER;
3740: l_ct_party_id NUMBER;
3733: l_idx NUMBER;
3734: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
3735: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
3736: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
3737: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
3738: l_party_id NUMBER;
3739: l_ps_party_id NUMBER;
3740: l_ct_party_id NUMBER;
3741: l_cpt_party_id NUMBER;
3933: END;
3934: PROCEDURE open_person_contact_cursor(
3935: p_contains_str VARCHAR2,
3936: p_search_ctx_id NUMBER,
3937: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
3938: BEGIN
3939: OPEN x_cursor FOR
3940: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID, TX22
3941: FROM HZ_STAGED_CONTACTS stage
5369: H_SCORES HZ_PARTY_SEARCH.score_list;
5370:
5371: l_score NUMBER;
5372: l_idx NUMBER;
5373: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
5374: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
5375: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
5376: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
5377: l_party_id NUMBER;
5370:
5371: l_score NUMBER;
5372: l_idx NUMBER;
5373: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
5374: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
5375: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
5376: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
5377: l_party_id NUMBER;
5378: l_ps_party_id NUMBER;
5371: l_score NUMBER;
5372: l_idx NUMBER;
5373: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
5374: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
5375: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
5376: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
5377: l_party_id NUMBER;
5378: l_ps_party_id NUMBER;
5379: l_ct_party_id NUMBER;
5372: l_idx NUMBER;
5373: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
5374: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
5375: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
5376: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
5377: l_party_id NUMBER;
5378: l_ps_party_id NUMBER;
5379: l_ct_party_id NUMBER;
5380: l_cpt_party_id NUMBER;
5605: H_SCORES HZ_PARTY_SEARCH.score_list;
5606:
5607: l_score NUMBER;
5608: l_idx NUMBER;
5609: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
5610: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
5611: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
5612: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
5613: l_party_id NUMBER;
5606:
5607: l_score NUMBER;
5608: l_idx NUMBER;
5609: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
5610: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
5611: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
5612: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
5613: l_party_id NUMBER;
5614: l_ps_party_id NUMBER;
5607: l_score NUMBER;
5608: l_idx NUMBER;
5609: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
5610: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
5611: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
5612: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
5613: l_party_id NUMBER;
5614: l_ps_party_id NUMBER;
5615: l_ct_party_id NUMBER;
5608: l_idx NUMBER;
5609: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
5610: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
5611: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
5612: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
5613: l_party_id NUMBER;
5614: l_ps_party_id NUMBER;
5615: l_ct_party_id NUMBER;
5616: l_cpt_party_id NUMBER;
5826: l_TX6 VARCHAR2(2000);
5827:
5828: l_score NUMBER;
5829: l_idx NUMBER;
5830: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
5831: l_cpt_party_id NUMBER;
5832: l_cpt_ps_id NUMBER;
5833: l_cpt_contact_id NUMBER;
5834: l_contact_pt_id NUMBER;
6010:
6011: l_score NUMBER;
6012: l_match_idx NUMBER;
6013: l_idx NUMBER;
6014: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
6015: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
6016: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
6017: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
6018: l_party_id NUMBER;
6011: l_score NUMBER;
6012: l_match_idx NUMBER;
6013: l_idx NUMBER;
6014: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
6015: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
6016: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
6017: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
6018: l_party_id NUMBER;
6019: l_ps_party_id NUMBER;
6012: l_match_idx NUMBER;
6013: l_idx NUMBER;
6014: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
6015: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
6016: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
6017: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
6018: l_party_id NUMBER;
6019: l_ps_party_id NUMBER;
6020: l_ct_party_id NUMBER;
6013: l_idx NUMBER;
6014: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
6015: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
6016: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
6017: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
6018: l_party_id NUMBER;
6019: l_ps_party_id NUMBER;
6020: l_ct_party_id NUMBER;
6021: l_cpt_party_id NUMBER;
6605: PROCEDURE MAP_PARTY_REC(
6606: p_search_ctx IN BOOLEAN,
6607: p_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
6608: x_entered_max_score OUT NUMBER,
6609: x_stage_rec IN OUT NOCOPY HZ_PARTY_STAGE.party_stage_rec_type
6610: ) IS
6611: tmp VARCHAR2(4000);
6612: l_party_name VARCHAR2(4000);
6613: BEGIN
6780: PROCEDURE MAP_PARTY_SITE_REC(
6781: p_search_ctx IN BOOLEAN,
6782: p_search_list IN HZ_PARTY_SEARCH.party_site_list,
6783: x_entered_max_score OUT NUMBER,
6784: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.party_site_stage_list
6785: ) IS
6786: l_current_max_score NUMBER;
6787: tmp VARCHAR2(4000);
6788: BEGIN
7021: PROCEDURE MAP_CONTACT_REC(
7022: p_search_ctx IN BOOLEAN,
7023: p_search_list IN HZ_PARTY_SEARCH.contact_list,
7024: x_entered_max_score OUT NUMBER,
7025: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.contact_stage_list
7026: ) IS
7027: l_current_max_score NUMBER;
7028: tmp VARCHAR2(4000);
7029: BEGIN
7078: PROCEDURE MAP_CONTACT_POINT_REC(
7079: p_search_ctx IN BOOLEAN,
7080: p_search_list IN HZ_PARTY_SEARCH.contact_point_list,
7081: x_entered_max_score OUT NUMBER,
7082: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.contact_pt_stage_list
7083: ) IS
7084: l_current_max_score NUMBER;
7085: tmp VARCHAR2(4000);
7086: TYPE INDEX_VARCHAR100_TBL IS TABLE OF NUMBER INDEX BY VARCHAR2(100);