DBA Data[Home] [Help]

APPS.HZ_MATCH_RULE_39 dependencies on HZ_PARTY_STAGE

Line 34: g_party_stage_rec HZ_PARTY_STAGE.party_stage_rec_type;

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;

Line 35: g_party_site_stage_list HZ_PARTY_STAGE.party_site_stage_list;

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;

Line 36: g_contact_stage_list HZ_PARTY_STAGE.contact_stage_list;

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;

Line 37: g_contact_pt_stage_list HZ_PARTY_STAGE.contact_pt_stage_list;

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:

Line 370: ,p_stage_rec IN HZ_PARTY_STAGE.party_stage_rec_type

366: p_party_id IN NUMBER
367: ,p_record_id IN NUMBER
368: ,p_search_ctx_id IN NUMBER
369: ,p_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type
370: ,p_stage_rec IN HZ_PARTY_STAGE.party_stage_rec_type
371: ,p_table_TX39 VARCHAR2
372: ,p_table_TX40 VARCHAR2
373: ,p_table_TX41 VARCHAR2
374: ,p_table_TX44 VARCHAR2

Line 471: ,p_stage_rec IN HZ_PARTY_STAGE.party_site_stage_rec_type

467: p_party_id IN NUMBER
468: ,p_record_id IN NUMBER
469: ,p_search_ctx_id IN NUMBER
470: ,p_search_rec IN HZ_PARTY_SEARCH.party_site_search_rec_type
471: ,p_stage_rec IN HZ_PARTY_STAGE.party_site_stage_rec_type
472: ,p_table_TX4 VARCHAR2
473: ,p_table_TX3 VARCHAR2
474: ,p_idx IN NUMBER) IS
475: l_current_score NUMBER:=0;

Line 520: ,p_stage_rec IN HZ_PARTY_STAGE.contact_stage_rec_type

516: p_party_id IN NUMBER
517: ,p_record_id IN NUMBER
518: ,p_search_ctx_id IN NUMBER
519: ,p_search_rec IN HZ_PARTY_SEARCH.contact_search_rec_type
520: ,p_stage_rec IN HZ_PARTY_STAGE.contact_stage_rec_type
521: ,p_idx IN NUMBER) IS
522: l_current_score NUMBER:=0;
523: l_score NUMBER;
524: l_attrib_value VARCHAR2(2000);

Line 536: ,p_stage_rec IN HZ_PARTY_STAGE.contact_pt_stage_rec_type

532: p_party_id IN NUMBER
533: ,p_record_id IN NUMBER
534: ,p_search_ctx_id IN NUMBER
535: ,p_search_rec IN HZ_PARTY_SEARCH.contact_point_search_rec_type
536: ,p_stage_rec IN HZ_PARTY_STAGE.contact_pt_stage_rec_type
537: ,p_idx IN NUMBER) IS
538: l_current_score NUMBER:=0;
539: l_score NUMBER;
540: l_attrib_value VARCHAR2(2000);

Line 1021: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS

1017: p_restrict_sql VARCHAR2,
1018: p_match_str VARCHAR2,
1019: p_search_merged VARCHAR2,
1020: p_party_contains_str VARCHAR2,
1021: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
1022: l_sqlstr VARCHAR2(4000);
1023: l_search_merged VARCHAR2(1);
1024: BEGIN
1025: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1140: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS

1136: p_contains_str VARCHAR2,
1137: p_search_ctx_id NUMBER,
1138: p_match_str VARCHAR2,
1139: p_search_merged VARCHAR2,
1140: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
1141: l_sqlstr VARCHAR2(4000);
1142: l_hint VARCHAR2(100);
1143: l_check NUMBER;
1144: l_search_merged VARCHAR2(1);

Line 1260: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS

1256: p_search_ctx_id NUMBER,
1257: p_search_merged VARCHAR2,
1258: p_search_rel_sites VARCHAR2,
1259: p_person_api VARCHAR2,
1260: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
1261: l_sqlstr VARCHAR2(4000);
1262: l_hint VARCHAR2(100);
1263: l_check NUMBER;
1264: l_check_dt NUMBER;

Line 1503: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS

1499: p_restrict_sql VARCHAR2,
1500: p_contains_str VARCHAR2,
1501: p_search_ctx_id NUMBER,
1502: p_search_merged VARCHAR2,
1503: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
1504: l_sqlstr VARCHAR2(4000);
1505: l_hint VARCHAR2(100);
1506: l_check NUMBER;
1507: l_check_dt NUMBER;

Line 1652: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp,

1648: p_search_ctx_id NUMBER,
1649: p_search_merged VARCHAR2,
1650: p_search_rel_cpts VARCHAR2,
1651: p_person_api VARCHAR2,
1652: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp,
1653: p_restrict_entity VARCHAR2 DEFAULT NULL) IS
1654: l_sqlstr VARCHAR2(4000);
1655: l_hint VARCHAR2(100);
1656: l_check NUMBER;

Line 2044: l_party_cur HZ_PARTY_STAGE.StageCurTyp;

2040: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
2041:
2042: l_score NUMBER;
2043: l_idx NUMBER;
2044: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
2045: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
2046: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
2047: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
2048: l_party_id NUMBER;

Line 2045: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;

2041:
2042: l_score NUMBER;
2043: l_idx NUMBER;
2044: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
2045: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
2046: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
2047: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
2048: l_party_id NUMBER;
2049: l_ps_party_id NUMBER;

Line 2046: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;

2042: l_score NUMBER;
2043: l_idx NUMBER;
2044: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
2045: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
2046: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
2047: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
2048: l_party_id NUMBER;
2049: l_ps_party_id NUMBER;
2050: l_ct_party_id NUMBER;

Line 2047: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;

2043: l_idx NUMBER;
2044: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
2045: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
2046: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
2047: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
2048: l_party_id NUMBER;
2049: l_ps_party_id NUMBER;
2050: l_ct_party_id NUMBER;
2051: l_cpt_party_id NUMBER;

Line 2998: l_party_cur HZ_PARTY_STAGE.StageCurTyp;

2994: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
2995:
2996: l_score NUMBER;
2997: l_idx NUMBER;
2998: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
2999: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
3000: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
3001: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
3002: l_party_id NUMBER;

Line 2999: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;

2995:
2996: l_score NUMBER;
2997: l_idx NUMBER;
2998: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
2999: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
3000: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
3001: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
3002: l_party_id NUMBER;
3003: l_ps_party_id NUMBER;

Line 3000: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;

2996: l_score NUMBER;
2997: l_idx NUMBER;
2998: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
2999: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
3000: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
3001: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
3002: l_party_id NUMBER;
3003: l_ps_party_id NUMBER;
3004: l_ct_party_id NUMBER;

Line 3001: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;

2997: l_idx NUMBER;
2998: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
2999: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
3000: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
3001: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
3002: l_party_id NUMBER;
3003: l_ps_party_id NUMBER;
3004: l_ct_party_id NUMBER;
3005: l_cpt_party_id NUMBER;

Line 3201: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS

3197: END;
3198: PROCEDURE open_person_contact_cursor(
3199: p_contains_str VARCHAR2,
3200: p_search_ctx_id NUMBER,
3201: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
3202: BEGIN
3203: OPEN x_cursor FOR
3204: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID
3205: FROM HZ_STAGED_CONTACTS stage

Line 4543: l_party_cur HZ_PARTY_STAGE.StageCurTyp;

4539: H_SCORES HZ_PARTY_SEARCH.score_list;
4540:
4541: l_score NUMBER;
4542: l_idx NUMBER;
4543: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
4544: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
4545: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
4546: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
4547: l_party_id NUMBER;

Line 4544: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;

4540:
4541: l_score NUMBER;
4542: l_idx NUMBER;
4543: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
4544: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
4545: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
4546: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
4547: l_party_id NUMBER;
4548: l_ps_party_id NUMBER;

Line 4545: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;

4541: l_score NUMBER;
4542: l_idx NUMBER;
4543: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
4544: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
4545: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
4546: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
4547: l_party_id NUMBER;
4548: l_ps_party_id NUMBER;
4549: l_ct_party_id NUMBER;

Line 4546: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;

4542: l_idx NUMBER;
4543: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
4544: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
4545: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
4546: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
4547: l_party_id NUMBER;
4548: l_ps_party_id NUMBER;
4549: l_ct_party_id NUMBER;
4550: l_cpt_party_id NUMBER;

Line 4775: l_party_cur HZ_PARTY_STAGE.StageCurTyp;

4771: H_SCORES HZ_PARTY_SEARCH.score_list;
4772:
4773: l_score NUMBER;
4774: l_idx NUMBER;
4775: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
4776: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
4777: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
4778: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
4779: l_party_id NUMBER;

Line 4776: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;

4772:
4773: l_score NUMBER;
4774: l_idx NUMBER;
4775: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
4776: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
4777: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
4778: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
4779: l_party_id NUMBER;
4780: l_ps_party_id NUMBER;

Line 4777: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;

4773: l_score NUMBER;
4774: l_idx NUMBER;
4775: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
4776: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
4777: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
4778: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
4779: l_party_id NUMBER;
4780: l_ps_party_id NUMBER;
4781: l_ct_party_id NUMBER;

Line 4778: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;

4774: l_idx NUMBER;
4775: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
4776: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
4777: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
4778: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
4779: l_party_id NUMBER;
4780: l_ps_party_id NUMBER;
4781: l_ct_party_id NUMBER;
4782: l_cpt_party_id NUMBER;

Line 4993: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;

4989:
4990:
4991: l_score NUMBER;
4992: l_idx NUMBER;
4993: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
4994: l_cpt_party_id NUMBER;
4995: l_cpt_ps_id NUMBER;
4996: l_cpt_contact_id NUMBER;
4997: l_contact_pt_id NUMBER;

Line 5153: l_party_cur HZ_PARTY_STAGE.StageCurTyp;

5149:
5150: l_score NUMBER;
5151: l_match_idx NUMBER;
5152: l_idx NUMBER;
5153: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
5154: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
5155: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
5156: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
5157: l_party_id NUMBER;

Line 5154: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;

5150: l_score NUMBER;
5151: l_match_idx NUMBER;
5152: l_idx NUMBER;
5153: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
5154: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
5155: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
5156: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
5157: l_party_id NUMBER;
5158: l_ps_party_id NUMBER;

Line 5155: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;

5151: l_match_idx NUMBER;
5152: l_idx NUMBER;
5153: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
5154: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
5155: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
5156: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
5157: l_party_id NUMBER;
5158: l_ps_party_id NUMBER;
5159: l_ct_party_id NUMBER;

Line 5156: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;

5152: l_idx NUMBER;
5153: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
5154: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
5155: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
5156: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
5157: l_party_id NUMBER;
5158: l_ps_party_id NUMBER;
5159: l_ct_party_id NUMBER;
5160: l_cpt_party_id NUMBER;

Line 5665: x_stage_rec IN OUT NOCOPY HZ_PARTY_STAGE.party_stage_rec_type

5661: PROCEDURE MAP_PARTY_REC(
5662: p_search_ctx IN BOOLEAN,
5663: p_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
5664: x_entered_max_score OUT NUMBER,
5665: x_stage_rec IN OUT NOCOPY HZ_PARTY_STAGE.party_stage_rec_type
5666: ) IS
5667: tmp VARCHAR2(4000);
5668: l_party_name VARCHAR2(4000);
5669: BEGIN

Line 5802: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.party_site_stage_list

5798: PROCEDURE MAP_PARTY_SITE_REC(
5799: p_search_ctx IN BOOLEAN,
5800: p_search_list IN HZ_PARTY_SEARCH.party_site_list,
5801: x_entered_max_score OUT NUMBER,
5802: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.party_site_stage_list
5803: ) IS
5804: l_current_max_score NUMBER;
5805: tmp VARCHAR2(4000);
5806: BEGIN

Line 5917: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.contact_stage_list

5913: PROCEDURE MAP_CONTACT_REC(
5914: p_search_ctx IN BOOLEAN,
5915: p_search_list IN HZ_PARTY_SEARCH.contact_list,
5916: x_entered_max_score OUT NUMBER,
5917: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.contact_stage_list
5918: ) IS
5919: l_current_max_score NUMBER;
5920: tmp VARCHAR2(4000);
5921: BEGIN

Line 5959: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.contact_pt_stage_list

5955: PROCEDURE MAP_CONTACT_POINT_REC(
5956: p_search_ctx IN BOOLEAN,
5957: p_search_list IN HZ_PARTY_SEARCH.contact_point_list,
5958: x_entered_max_score OUT NUMBER,
5959: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.contact_pt_stage_list
5960: ) IS
5961: l_current_max_score NUMBER;
5962: tmp VARCHAR2(4000);
5963: TYPE INDEX_VARCHAR100_TBL IS TABLE OF NUMBER INDEX BY VARCHAR2(100);