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:
766: p_party_id IN NUMBER
767: ,p_record_id IN NUMBER
768: ,p_search_ctx_id IN NUMBER
769: ,p_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type
770: ,p_stage_rec IN HZ_PARTY_STAGE.party_stage_rec_type
771: ,p_table_TX32 VARCHAR2
772: ,p_table_TX34 VARCHAR2
773: ,p_table_TX35 VARCHAR2
774: ,p_table_TX39 VARCHAR2
1089: p_party_id IN NUMBER
1090: ,p_record_id IN NUMBER
1091: ,p_search_ctx_id IN NUMBER
1092: ,p_search_rec IN HZ_PARTY_SEARCH.party_site_search_rec_type
1093: ,p_stage_rec IN HZ_PARTY_STAGE.party_site_stage_rec_type
1094: ,p_table_TX9 VARCHAR2
1095: ,p_table_TX10 VARCHAR2
1096: ,p_table_TX11 VARCHAR2
1097: ,p_table_TX13 VARCHAR2
1282: p_party_id IN NUMBER
1283: ,p_record_id IN NUMBER
1284: ,p_search_ctx_id IN NUMBER
1285: ,p_search_rec IN HZ_PARTY_SEARCH.contact_search_rec_type
1286: ,p_stage_rec IN HZ_PARTY_STAGE.contact_stage_rec_type
1287: ,p_idx IN NUMBER) IS
1288: l_current_score NUMBER:=0;
1289: l_score NUMBER;
1290: l_attrib_value VARCHAR2(2000);
1298: p_party_id IN NUMBER
1299: ,p_record_id IN NUMBER
1300: ,p_search_ctx_id IN NUMBER
1301: ,p_search_rec IN HZ_PARTY_SEARCH.contact_point_search_rec_type
1302: ,p_stage_rec IN HZ_PARTY_STAGE.contact_pt_stage_rec_type
1303: ,p_table_TX1 VARCHAR2
1304: ,p_table_TX3 VARCHAR2
1305: ,p_table_TX4 VARCHAR2
1306: ,p_idx IN NUMBER) IS
2140: p_restrict_sql VARCHAR2,
2141: p_match_str VARCHAR2,
2142: p_search_merged VARCHAR2,
2143: p_party_contains_str VARCHAR2,
2144: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
2145: l_sqlstr VARCHAR2(4000);
2146: l_search_merged VARCHAR2(1);
2147: BEGIN
2148: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2367: p_contains_str VARCHAR2,
2368: p_search_ctx_id NUMBER,
2369: p_match_str VARCHAR2,
2370: p_search_merged VARCHAR2,
2371: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
2372: l_sqlstr VARCHAR2(4000);
2373: l_hint VARCHAR2(100);
2374: l_check NUMBER;
2375: l_search_merged VARCHAR2(1);
2487: p_search_ctx_id NUMBER,
2488: p_search_merged VARCHAR2,
2489: p_search_rel_sites VARCHAR2,
2490: p_person_api VARCHAR2,
2491: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
2492: l_sqlstr VARCHAR2(4000);
2493: l_hint VARCHAR2(100);
2494: l_check NUMBER;
2495: l_check_dt NUMBER;
2730: p_restrict_sql VARCHAR2,
2731: p_contains_str VARCHAR2,
2732: p_search_ctx_id NUMBER,
2733: p_search_merged VARCHAR2,
2734: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
2735: l_sqlstr VARCHAR2(4000);
2736: l_hint VARCHAR2(100);
2737: l_check NUMBER;
2738: l_check_dt NUMBER;
2879: p_search_ctx_id NUMBER,
2880: p_search_merged VARCHAR2,
2881: p_search_rel_cpts VARCHAR2,
2882: p_person_api VARCHAR2,
2883: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp,
2884: p_restrict_entity VARCHAR2 DEFAULT NULL) IS
2885: l_sqlstr VARCHAR2(4000);
2886: l_hint VARCHAR2(100);
2887: l_check NUMBER;
3291: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
3292:
3293: l_score NUMBER;
3294: l_idx NUMBER;
3295: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
3296: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
3297: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
3298: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
3299: l_party_id NUMBER;
3292:
3293: l_score NUMBER;
3294: l_idx NUMBER;
3295: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
3296: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
3297: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
3298: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
3299: l_party_id NUMBER;
3300: l_ps_party_id NUMBER;
3293: l_score NUMBER;
3294: l_idx NUMBER;
3295: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
3296: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
3297: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
3298: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
3299: l_party_id NUMBER;
3300: l_ps_party_id NUMBER;
3301: l_ct_party_id NUMBER;
3294: l_idx NUMBER;
3295: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
3296: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
3297: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
3298: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
3299: l_party_id NUMBER;
3300: l_ps_party_id NUMBER;
3301: l_ct_party_id NUMBER;
3302: l_cpt_party_id NUMBER;
4265: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
4266:
4267: l_score NUMBER;
4268: l_idx NUMBER;
4269: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
4270: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
4271: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
4272: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
4273: l_party_id NUMBER;
4266:
4267: l_score NUMBER;
4268: l_idx NUMBER;
4269: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
4270: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
4271: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
4272: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
4273: l_party_id NUMBER;
4274: l_ps_party_id NUMBER;
4267: l_score NUMBER;
4268: l_idx NUMBER;
4269: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
4270: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
4271: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
4272: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
4273: l_party_id NUMBER;
4274: l_ps_party_id NUMBER;
4275: l_ct_party_id NUMBER;
4268: l_idx NUMBER;
4269: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
4270: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
4271: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
4272: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
4273: l_party_id NUMBER;
4274: l_ps_party_id NUMBER;
4275: l_ct_party_id NUMBER;
4276: l_cpt_party_id NUMBER;
4468: END;
4469: PROCEDURE open_person_contact_cursor(
4470: p_contains_str VARCHAR2,
4471: p_search_ctx_id NUMBER,
4472: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
4473: BEGIN
4474: OPEN x_cursor FOR
4475: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID
4476: FROM HZ_STAGED_CONTACTS stage
5976: H_SCORES HZ_PARTY_SEARCH.score_list;
5977:
5978: l_score NUMBER;
5979: l_idx NUMBER;
5980: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
5981: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
5982: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
5983: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
5984: l_party_id NUMBER;
5977:
5978: l_score NUMBER;
5979: l_idx NUMBER;
5980: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
5981: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
5982: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
5983: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
5984: l_party_id NUMBER;
5985: l_ps_party_id NUMBER;
5978: l_score NUMBER;
5979: l_idx NUMBER;
5980: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
5981: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
5982: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
5983: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
5984: l_party_id NUMBER;
5985: l_ps_party_id NUMBER;
5986: l_ct_party_id NUMBER;
5979: l_idx NUMBER;
5980: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
5981: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
5982: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
5983: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
5984: l_party_id NUMBER;
5985: l_ps_party_id NUMBER;
5986: l_ct_party_id NUMBER;
5987: l_cpt_party_id NUMBER;
6211: H_SCORES HZ_PARTY_SEARCH.score_list;
6212:
6213: l_score NUMBER;
6214: l_idx NUMBER;
6215: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
6216: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
6217: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
6218: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
6219: l_party_id NUMBER;
6212:
6213: l_score NUMBER;
6214: l_idx NUMBER;
6215: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
6216: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
6217: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
6218: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
6219: l_party_id NUMBER;
6220: l_ps_party_id NUMBER;
6213: l_score NUMBER;
6214: l_idx NUMBER;
6215: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
6216: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
6217: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
6218: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
6219: l_party_id NUMBER;
6220: l_ps_party_id NUMBER;
6221: l_ct_party_id NUMBER;
6214: l_idx NUMBER;
6215: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
6216: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
6217: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
6218: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
6219: l_party_id NUMBER;
6220: l_ps_party_id NUMBER;
6221: l_ct_party_id NUMBER;
6222: l_cpt_party_id NUMBER;
6432: l_TX4 VARCHAR2(2000);
6433:
6434: l_score NUMBER;
6435: l_idx NUMBER;
6436: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
6437: l_cpt_party_id NUMBER;
6438: l_cpt_ps_id NUMBER;
6439: l_cpt_contact_id NUMBER;
6440: l_contact_pt_id NUMBER;
6632:
6633: l_score NUMBER;
6634: l_match_idx NUMBER;
6635: l_idx NUMBER;
6636: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
6637: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
6638: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
6639: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
6640: l_party_id NUMBER;
6633: l_score NUMBER;
6634: l_match_idx NUMBER;
6635: l_idx NUMBER;
6636: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
6637: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
6638: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
6639: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
6640: l_party_id NUMBER;
6641: l_ps_party_id NUMBER;
6634: l_match_idx NUMBER;
6635: l_idx NUMBER;
6636: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
6637: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
6638: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
6639: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
6640: l_party_id NUMBER;
6641: l_ps_party_id NUMBER;
6642: l_ct_party_id NUMBER;
6635: l_idx NUMBER;
6636: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
6637: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
6638: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
6639: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
6640: l_party_id NUMBER;
6641: l_ps_party_id NUMBER;
6642: l_ct_party_id NUMBER;
6643: l_cpt_party_id NUMBER;
7230: PROCEDURE MAP_PARTY_REC(
7231: p_search_ctx IN BOOLEAN,
7232: p_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
7233: x_entered_max_score OUT NUMBER,
7234: x_stage_rec IN OUT NOCOPY HZ_PARTY_STAGE.party_stage_rec_type
7235: ) IS
7236: tmp VARCHAR2(4000);
7237: l_party_name VARCHAR2(4000);
7238: BEGIN
7561: PROCEDURE MAP_PARTY_SITE_REC(
7562: p_search_ctx IN BOOLEAN,
7563: p_search_list IN HZ_PARTY_SEARCH.party_site_list,
7564: x_entered_max_score OUT NUMBER,
7565: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.party_site_stage_list
7566: ) IS
7567: l_current_max_score NUMBER;
7568: tmp VARCHAR2(4000);
7569: BEGIN
7768: PROCEDURE MAP_CONTACT_REC(
7769: p_search_ctx IN BOOLEAN,
7770: p_search_list IN HZ_PARTY_SEARCH.contact_list,
7771: x_entered_max_score OUT NUMBER,
7772: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.contact_stage_list
7773: ) IS
7774: l_current_max_score NUMBER;
7775: tmp VARCHAR2(4000);
7776: BEGIN
7810: PROCEDURE MAP_CONTACT_POINT_REC(
7811: p_search_ctx IN BOOLEAN,
7812: p_search_list IN HZ_PARTY_SEARCH.contact_point_list,
7813: x_entered_max_score OUT NUMBER,
7814: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.contact_pt_stage_list
7815: ) IS
7816: l_current_max_score NUMBER;
7817: tmp VARCHAR2(4000);
7818: TYPE INDEX_VARCHAR100_TBL IS TABLE OF NUMBER INDEX BY VARCHAR2(100);