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.PV_MATCH_PARTNER dependencies on JTF_VARCHAR2_TABLE_100

Line 42: x_matched_prt OUT JTF_VARCHAR2_TABLE_100,

38: p_commit IN VARCHAR2 := FND_API.G_FALSE,
39: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
40: p_sql IN VArchar2,
41: p_num_of_attrs IN NUMBER,
42: x_matched_prt OUT JTF_VARCHAR2_TABLE_100,
43: x_prt_matched OUT boolean,
44: x_matched_attr_cnt OUT NUMBER,
45: x_return_status OUT VARCHAR2,
46: x_msg_count OUT NUMBER,

Line 52: l_possible_match_party_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

48:
49: Type Match_Partner_Rec is REF CURSOR;
50:
51: match_partner_cur Match_Partner_Rec;
52: l_possible_match_party_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
53: l_possible_match_rank_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
54: l_possible_match_count number := 0;
55: l_possible_rank_high number := 0;
56: l_match_count number := 0;

Line 53: l_possible_match_rank_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

49: Type Match_Partner_Rec is REF CURSOR;
50:
51: match_partner_cur Match_Partner_Rec;
52: l_possible_match_party_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
53: l_possible_match_rank_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
54: l_possible_match_count number := 0;
55: l_possible_rank_high number := 0;
56: l_match_count number := 0;
57: l_top_n_rows number;

Line 91: x_matched_prt := JTF_VARCHAR2_TABLE_100();

87: fnd_msg_pub.initialize;
88: END IF;
89:
90: x_return_status := FND_API.G_RET_STS_SUCCESS ;
91: x_matched_prt := JTF_VARCHAR2_TABLE_100();
92:
93:
94: l_top_n_rows :=nvl(fnd_profile.value('PV_TOP_N_MATCH_PARTNERS'), 10);
95: l_matching_rank := 1;

Line 318: p_attr_tbl IN OUT JTF_VARCHAR2_TABLE_100,

314: p_api_version_number IN NUMBER,
315: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
316: p_commit IN VARCHAR2 := FND_API.G_FALSE,
317: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
318: p_attr_tbl IN OUT JTF_VARCHAR2_TABLE_100,
319: p_attr_val_count IN JTF_VARCHAR2_TABLE_100,
320: p_val_attr_tbl IN OUT JTF_VARCHAR2_TABLE_100,
321: p_cm_id IN number,
322: p_lead_id IN number,

Line 319: p_attr_val_count IN JTF_VARCHAR2_TABLE_100,

315: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
316: p_commit IN VARCHAR2 := FND_API.G_FALSE,
317: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
318: p_attr_tbl IN OUT JTF_VARCHAR2_TABLE_100,
319: p_attr_val_count IN JTF_VARCHAR2_TABLE_100,
320: p_val_attr_tbl IN OUT JTF_VARCHAR2_TABLE_100,
321: p_cm_id IN number,
322: p_lead_id IN number,
323: p_auto_match_flag IN varchar2,

Line 320: p_val_attr_tbl IN OUT JTF_VARCHAR2_TABLE_100,

316: p_commit IN VARCHAR2 := FND_API.G_FALSE,
317: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
318: p_attr_tbl IN OUT JTF_VARCHAR2_TABLE_100,
319: p_attr_val_count IN JTF_VARCHAR2_TABLE_100,
320: p_val_attr_tbl IN OUT JTF_VARCHAR2_TABLE_100,
321: p_cm_id IN number,
322: p_lead_id IN number,
323: p_auto_match_flag IN varchar2,
324: x_iterations OUT varchar2,

Line 325: x_matched_id_tbl OUT JTF_VARCHAR2_TABLE_100,

321: p_cm_id IN number,
322: p_lead_id IN number,
323: p_auto_match_flag IN varchar2,
324: x_iterations OUT varchar2,
325: x_matched_id_tbl OUT JTF_VARCHAR2_TABLE_100,
326: x_return_status OUT VARCHAR2,
327: x_msg_count OUT NUMBER,
328: x_msg_data OUT VARCHAR2) IS
329:

Line 380: x_matched_id_tbl := JTF_VARCHAR2_TABLE_100();

376: fnd_msg_pub.initialize;
377: END IF;
378:
379: x_return_status := FND_API.G_RET_STS_SUCCESS ;
380: x_matched_id_tbl := JTF_VARCHAR2_TABLE_100();
381:
382:
383: IF FND_API.To_Boolean ( p_commit ) THEN
384: COMMIT WORK;

Line 450: x_matched_attr OUT JTF_VARCHAR2_TABLE_100,

446: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
447: p_commit IN VARCHAR2 := FND_API.G_FALSE,
448: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
449: p_lead_id IN Number,
450: x_matched_attr OUT JTF_VARCHAR2_TABLE_100,
451: x_matched_attr_val OUT JTF_VARCHAR2_TABLE_100,
452: x_original_attr OUT JTF_VARCHAR2_TABLE_100,
453: x_original_attr_val OUT JTF_VARCHAR2_TABLE_100,
454: x_iterations OUT varchar2,

Line 451: x_matched_attr_val OUT JTF_VARCHAR2_TABLE_100,

447: p_commit IN VARCHAR2 := FND_API.G_FALSE,
448: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
449: p_lead_id IN Number,
450: x_matched_attr OUT JTF_VARCHAR2_TABLE_100,
451: x_matched_attr_val OUT JTF_VARCHAR2_TABLE_100,
452: x_original_attr OUT JTF_VARCHAR2_TABLE_100,
453: x_original_attr_val OUT JTF_VARCHAR2_TABLE_100,
454: x_iterations OUT varchar2,
455: x_matched_id OUT JTF_VARCHAR2_TABLE_100,

Line 452: x_original_attr OUT JTF_VARCHAR2_TABLE_100,

448: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
449: p_lead_id IN Number,
450: x_matched_attr OUT JTF_VARCHAR2_TABLE_100,
451: x_matched_attr_val OUT JTF_VARCHAR2_TABLE_100,
452: x_original_attr OUT JTF_VARCHAR2_TABLE_100,
453: x_original_attr_val OUT JTF_VARCHAR2_TABLE_100,
454: x_iterations OUT varchar2,
455: x_matched_id OUT JTF_VARCHAR2_TABLE_100,
456: x_return_status OUT VARCHAR2,

Line 453: x_original_attr_val OUT JTF_VARCHAR2_TABLE_100,

449: p_lead_id IN Number,
450: x_matched_attr OUT JTF_VARCHAR2_TABLE_100,
451: x_matched_attr_val OUT JTF_VARCHAR2_TABLE_100,
452: x_original_attr OUT JTF_VARCHAR2_TABLE_100,
453: x_original_attr_val OUT JTF_VARCHAR2_TABLE_100,
454: x_iterations OUT varchar2,
455: x_matched_id OUT JTF_VARCHAR2_TABLE_100,
456: x_return_status OUT VARCHAR2,
457: x_msg_count OUT NUMBER,

Line 455: x_matched_id OUT JTF_VARCHAR2_TABLE_100,

451: x_matched_attr_val OUT JTF_VARCHAR2_TABLE_100,
452: x_original_attr OUT JTF_VARCHAR2_TABLE_100,
453: x_original_attr_val OUT JTF_VARCHAR2_TABLE_100,
454: x_iterations OUT varchar2,
455: x_matched_id OUT JTF_VARCHAR2_TABLE_100,
456: x_return_status OUT VARCHAR2,
457: x_msg_count OUT NUMBER,
458: x_msg_data OUT VARCHAR2) IS
459:

Line 460: l_attr_val_cnt JTF_VARCHAR2_TABLE_100;

456: x_return_status OUT VARCHAR2,
457: x_msg_count OUT NUMBER,
458: x_msg_data OUT VARCHAR2) IS
459:
460: l_attr_val_cnt JTF_VARCHAR2_TABLE_100;
461:
462: cursor attr_cur is
463: select a.attribute_id , a.sql_text , upper(a.src_pkcol_name) src_pkcol_name, v.short_name
464: from pv_entity_attrs a, pv_attributes_vl v

Line 502: x_matched_attr_val := JTF_VARCHAR2_TABLE_100();

498: THEN
499: fnd_msg_pub.initialize;
500: END IF;
501:
502: x_matched_attr_val := JTF_VARCHAR2_TABLE_100();
503: x_matched_attr := JTF_VARCHAR2_TABLE_100();
504: x_original_attr := JTF_VARCHAR2_TABLE_100();
505: x_original_attr_val := JTF_VARCHAR2_TABLE_100();
506: l_attr_val_cnt := JTF_VARCHAR2_TABLE_100();

Line 503: x_matched_attr := JTF_VARCHAR2_TABLE_100();

499: fnd_msg_pub.initialize;
500: END IF;
501:
502: x_matched_attr_val := JTF_VARCHAR2_TABLE_100();
503: x_matched_attr := JTF_VARCHAR2_TABLE_100();
504: x_original_attr := JTF_VARCHAR2_TABLE_100();
505: x_original_attr_val := JTF_VARCHAR2_TABLE_100();
506: l_attr_val_cnt := JTF_VARCHAR2_TABLE_100();
507: x_matched_id := JTF_VARCHAR2_TABLE_100();

Line 504: x_original_attr := JTF_VARCHAR2_TABLE_100();

500: END IF;
501:
502: x_matched_attr_val := JTF_VARCHAR2_TABLE_100();
503: x_matched_attr := JTF_VARCHAR2_TABLE_100();
504: x_original_attr := JTF_VARCHAR2_TABLE_100();
505: x_original_attr_val := JTF_VARCHAR2_TABLE_100();
506: l_attr_val_cnt := JTF_VARCHAR2_TABLE_100();
507: x_matched_id := JTF_VARCHAR2_TABLE_100();
508:

Line 505: x_original_attr_val := JTF_VARCHAR2_TABLE_100();

501:
502: x_matched_attr_val := JTF_VARCHAR2_TABLE_100();
503: x_matched_attr := JTF_VARCHAR2_TABLE_100();
504: x_original_attr := JTF_VARCHAR2_TABLE_100();
505: x_original_attr_val := JTF_VARCHAR2_TABLE_100();
506: l_attr_val_cnt := JTF_VARCHAR2_TABLE_100();
507: x_matched_id := JTF_VARCHAR2_TABLE_100();
508:
509: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 506: l_attr_val_cnt := JTF_VARCHAR2_TABLE_100();

502: x_matched_attr_val := JTF_VARCHAR2_TABLE_100();
503: x_matched_attr := JTF_VARCHAR2_TABLE_100();
504: x_original_attr := JTF_VARCHAR2_TABLE_100();
505: x_original_attr_val := JTF_VARCHAR2_TABLE_100();
506: l_attr_val_cnt := JTF_VARCHAR2_TABLE_100();
507: x_matched_id := JTF_VARCHAR2_TABLE_100();
508:
509: x_return_status := FND_API.G_RET_STS_SUCCESS ;
510:

Line 507: x_matched_id := JTF_VARCHAR2_TABLE_100();

503: x_matched_attr := JTF_VARCHAR2_TABLE_100();
504: x_original_attr := JTF_VARCHAR2_TABLE_100();
505: x_original_attr_val := JTF_VARCHAR2_TABLE_100();
506: l_attr_val_cnt := JTF_VARCHAR2_TABLE_100();
507: x_matched_id := JTF_VARCHAR2_TABLE_100();
508:
509: x_return_status := FND_API.G_RET_STS_SUCCESS ;
510:
511: for attr_rec IN attr_cur loop