eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_MATCH_RULE_52 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:

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:
41: g_debug_count NUMBER := 0;

Line 540: ,p_stage_rec IN HZ_PARTY_STAGE.party_stage_rec_type

536: p_party_id IN NUMBER
537: ,p_record_id IN NUMBER
538: ,p_search_ctx_id IN NUMBER
539: ,p_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type
540: ,p_stage_rec IN HZ_PARTY_STAGE.party_stage_rec_type
541: ,p_table_TX2 VARCHAR2
542: ,p_table_TX59 VARCHAR2
543: ,p_table_TX41 VARCHAR2
544: ,p_table_TX45 VARCHAR2

Line 641: ,p_stage_rec IN HZ_PARTY_STAGE.party_site_stage_rec_type

637: p_party_id IN NUMBER
638: ,p_record_id IN NUMBER
639: ,p_search_ctx_id IN NUMBER
640: ,p_search_rec IN HZ_PARTY_SEARCH.party_site_search_rec_type
641: ,p_stage_rec IN HZ_PARTY_STAGE.party_site_stage_rec_type
642: ,p_table_TX26 VARCHAR2
643: ,p_table_TX9 VARCHAR2
644: ,p_table_TX14 VARCHAR2
645: ,p_table_TX22 VARCHAR2

Line 761: ,p_stage_rec IN HZ_PARTY_STAGE.contact_stage_rec_type

757: p_party_id IN NUMBER
758: ,p_record_id IN NUMBER
759: ,p_search_ctx_id IN NUMBER
760: ,p_search_rec IN HZ_PARTY_SEARCH.contact_search_rec_type
761: ,p_stage_rec IN HZ_PARTY_STAGE.contact_stage_rec_type
762: ,p_table_TX2 VARCHAR2
763: ,p_table_TX23 VARCHAR2
764: ,p_table_TX22 VARCHAR2
765: ,p_idx IN NUMBER) IS

Line 836: ,p_stage_rec IN HZ_PARTY_STAGE.contact_pt_stage_rec_type

832: p_party_id IN NUMBER
833: ,p_record_id IN NUMBER
834: ,p_search_ctx_id IN NUMBER
835: ,p_search_rec IN HZ_PARTY_SEARCH.contact_point_search_rec_type
836: ,p_stage_rec IN HZ_PARTY_STAGE.contact_pt_stage_rec_type
837: ,p_table_TX5 VARCHAR2
838: ,p_table_TX7 VARCHAR2
839: ,p_table_TX10 VARCHAR2
840: ,p_table_TX158 VARCHAR2

Line 1160: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS

1156: p_contains_str VARCHAR2,
1157: p_search_ctx_id NUMBER,
1158: p_match_str VARCHAR2,
1159: p_search_merged VARCHAR2,
1160: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
1161: l_sqlstr VARCHAR2(4000);
1162: BEGIN
1163: IF p_contains_str IS NULL THEN
1164: OPEN x_cursor FOR

Line 1279: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS

1275: p_party_id NUMBER,
1276: p_restrict_sql VARCHAR2,
1277: p_contains_str VARCHAR2,
1278: p_search_ctx_id NUMBER,
1279: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
1280: l_sqlstr VARCHAR2(4000);
1281: BEGIN
1282: IF p_party_id IS NOT NULL THEN
1283: OPEN x_cursor FOR

Line 1376: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS

1372: p_party_id NUMBER,
1373: p_restrict_sql VARCHAR2,
1374: p_contains_str VARCHAR2,
1375: p_search_ctx_id NUMBER,
1376: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
1377: l_sqlstr VARCHAR2(4000);
1378: BEGIN
1379: IF p_party_id IS NOT NULL THEN
1380: OPEN x_cursor FOR

Line 1477: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS

1473: p_party_id NUMBER,
1474: p_restrict_sql VARCHAR2,
1475: p_contains_str VARCHAR2,
1476: p_search_ctx_id NUMBER,
1477: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
1478: l_sqlstr VARCHAR2(4000);
1479: BEGIN
1480: IF p_party_id IS NOT NULL THEN
1481: OPEN x_cursor FOR

Line 1708: l_party_cur HZ_PARTY_STAGE.StageCurTyp;

1704: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
1705:
1706: l_score NUMBER;
1707: l_idx NUMBER;
1708: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
1709: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
1710: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
1711: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
1712: l_party_id NUMBER;

Line 1709: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;

1705:
1706: l_score NUMBER;
1707: l_idx NUMBER;
1708: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
1709: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
1710: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
1711: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
1712: l_party_id NUMBER;
1713: l_ps_party_id NUMBER;

Line 1710: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;

1706: l_score NUMBER;
1707: l_idx NUMBER;
1708: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
1709: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
1710: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
1711: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
1712: l_party_id NUMBER;
1713: l_ps_party_id NUMBER;
1714: l_ct_party_id NUMBER;

Line 1711: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;

1707: l_idx NUMBER;
1708: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
1709: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
1710: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
1711: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
1712: l_party_id NUMBER;
1713: l_ps_party_id NUMBER;
1714: l_ct_party_id NUMBER;
1715: l_cpt_party_id NUMBER;

Line 2335: l_party_cur HZ_PARTY_STAGE.StageCurTyp;

2331: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
2332:
2333: l_score NUMBER;
2334: l_idx NUMBER;
2335: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
2336: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
2337: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
2338: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
2339: l_party_id NUMBER;

Line 2336: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;

2332:
2333: l_score NUMBER;
2334: l_idx NUMBER;
2335: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
2336: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
2337: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
2338: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
2339: l_party_id NUMBER;
2340: l_ps_party_id NUMBER;

Line 2337: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;

2333: l_score NUMBER;
2334: l_idx NUMBER;
2335: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
2336: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
2337: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
2338: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
2339: l_party_id NUMBER;
2340: l_ps_party_id NUMBER;
2341: l_ct_party_id NUMBER;

Line 2338: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;

2334: l_idx NUMBER;
2335: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
2336: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
2337: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
2338: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
2339: l_party_id NUMBER;
2340: l_ps_party_id NUMBER;
2341: l_ct_party_id NUMBER;
2342: l_cpt_party_id NUMBER;

Line 2503: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS

2499: END;
2500: PROCEDURE open_person_contact_cursor(
2501: p_contains_str VARCHAR2,
2502: p_search_ctx_id NUMBER,
2503: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
2504: BEGIN
2505: OPEN x_cursor FOR
2506: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID, TX2, TX23, TX22
2507: FROM HZ_STAGED_CONTACTS stage

Line 3784: l_party_cur HZ_PARTY_STAGE.StageCurTyp;

3780: H_SCORES HZ_PARTY_SEARCH.score_list;
3781:
3782: l_score NUMBER;
3783: l_idx NUMBER;
3784: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
3785: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
3786: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
3787: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
3788: l_party_id NUMBER;

Line 3785: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;

3781:
3782: l_score NUMBER;
3783: l_idx NUMBER;
3784: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
3785: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
3786: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
3787: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
3788: l_party_id NUMBER;
3789: l_ps_party_id NUMBER;

Line 3786: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;

3782: l_score NUMBER;
3783: l_idx NUMBER;
3784: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
3785: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
3786: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
3787: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
3788: l_party_id NUMBER;
3789: l_ps_party_id NUMBER;
3790: l_ct_party_id NUMBER;

Line 3787: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;

3783: l_idx NUMBER;
3784: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
3785: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
3786: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
3787: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
3788: l_party_id NUMBER;
3789: l_ps_party_id NUMBER;
3790: l_ct_party_id NUMBER;
3791: l_cpt_party_id NUMBER;

Line 4011: l_party_cur HZ_PARTY_STAGE.StageCurTyp;

4007: H_SCORES HZ_PARTY_SEARCH.score_list;
4008:
4009: l_score NUMBER;
4010: l_idx NUMBER;
4011: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
4012: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
4013: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
4014: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
4015: l_party_id NUMBER;

Line 4012: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;

4008:
4009: l_score NUMBER;
4010: l_idx NUMBER;
4011: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
4012: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
4013: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
4014: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
4015: l_party_id NUMBER;
4016: l_ps_party_id NUMBER;

Line 4013: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;

4009: l_score NUMBER;
4010: l_idx NUMBER;
4011: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
4012: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
4013: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
4014: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
4015: l_party_id NUMBER;
4016: l_ps_party_id NUMBER;
4017: l_ct_party_id NUMBER;

Line 4014: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;

4010: l_idx NUMBER;
4011: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
4012: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
4013: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
4014: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
4015: l_party_id NUMBER;
4016: l_ps_party_id NUMBER;
4017: l_ct_party_id NUMBER;
4018: l_cpt_party_id NUMBER;

Line 4224: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;

4220: l_TX7 VARCHAR2(2000);
4221:
4222: l_score NUMBER;
4223: l_idx NUMBER;
4224: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
4225: l_cpt_party_id NUMBER;
4226: l_cpt_ps_id NUMBER;
4227: l_cpt_contact_id NUMBER;
4228: l_contact_pt_id NUMBER;

Line 4400: l_party_cur HZ_PARTY_STAGE.StageCurTyp;

4396:
4397: l_score NUMBER;
4398: l_match_idx NUMBER;
4399: l_idx NUMBER;
4400: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
4401: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
4402: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
4403: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
4404: l_party_id NUMBER;

Line 4401: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;

4397: l_score NUMBER;
4398: l_match_idx NUMBER;
4399: l_idx NUMBER;
4400: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
4401: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
4402: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
4403: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
4404: l_party_id NUMBER;
4405: l_ps_party_id NUMBER;

Line 4402: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;

4398: l_match_idx NUMBER;
4399: l_idx NUMBER;
4400: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
4401: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
4402: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
4403: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
4404: l_party_id NUMBER;
4405: l_ps_party_id NUMBER;
4406: l_ct_party_id NUMBER;

Line 4403: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;

4399: l_idx NUMBER;
4400: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
4401: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
4402: l_contact_cur HZ_PARTY_STAGE.StageCurTyp;
4403: l_contact_pt_cur HZ_PARTY_STAGE.StageCurTyp;
4404: l_party_id NUMBER;
4405: l_ps_party_id NUMBER;
4406: l_ct_party_id NUMBER;
4407: l_cpt_party_id NUMBER;

Line 5000: x_stage_rec IN OUT NOCOPY HZ_PARTY_STAGE.party_stage_rec_type

4996: PROCEDURE MAP_PARTY_REC(
4997: p_search_ctx IN BOOLEAN,
4998: p_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
4999: x_entered_max_score OUT NUMBER,
5000: x_stage_rec IN OUT NOCOPY HZ_PARTY_STAGE.party_stage_rec_type
5001: ) IS
5002: tmp VARCHAR2(4000);
5003: BEGIN
5004: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 5129: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.party_site_stage_list

5125: PROCEDURE MAP_PARTY_SITE_REC(
5126: p_search_ctx IN BOOLEAN,
5127: p_search_list IN HZ_PARTY_SEARCH.party_site_list,
5128: x_entered_max_score OUT NUMBER,
5129: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.party_site_stage_list
5130: ) IS
5131: l_current_max_score NUMBER;
5132: tmp VARCHAR2(4000);
5133: BEGIN

Line 5282: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.contact_stage_list

5278: PROCEDURE MAP_CONTACT_REC(
5279: p_search_ctx IN BOOLEAN,
5280: p_search_list IN HZ_PARTY_SEARCH.contact_list,
5281: x_entered_max_score OUT NUMBER,
5282: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.contact_stage_list
5283: ) IS
5284: l_current_max_score NUMBER;
5285: tmp VARCHAR2(4000);
5286: BEGIN

Line 5383: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.contact_pt_stage_list

5379: PROCEDURE MAP_CONTACT_POINT_REC(
5380: p_search_ctx IN BOOLEAN,
5381: p_search_list IN HZ_PARTY_SEARCH.contact_point_list,
5382: x_entered_max_score OUT NUMBER,
5383: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.contact_pt_stage_list
5384: ) IS
5385: l_current_max_score NUMBER;
5386: tmp VARCHAR2(4000);
5387: BEGIN