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_V2_PUB dependencies on JTF_NUMBER_TABLE

Line 52: p_attr_id_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,

48: p_api_version_number IN NUMBER,
49: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
50: p_commit IN VARCHAR2 := FND_API.G_FALSE,
51: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
52: p_attr_id_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,
53: p_attr_value_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
54: p_attr_operator_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,
55: p_attr_data_type_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,
56: p_attr_selection_mode IN VARCHAR2,

Line 63: x_matched_id OUT NOCOPY JTF_NUMBER_TABLE,

59: p_resource_id IN NUMBER,
60: p_lead_id IN NUMBER,
61: p_auto_match_flag IN VARCHAR2,
62: p_get_distance_flag IN VARCHAR2 := 'F',
63: x_matched_id OUT NOCOPY JTF_NUMBER_TABLE,
64: x_partner_details OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
65: x_distance_tbl OUT NOCOPY JTF_NUMBER_TABLE,
66: x_distance_uom_returned OUT NOCOPY VARCHAR2,
67: x_flagcount OUT NOCOPY JTF_VARCHAR2_TABLE_100,

Line 65: x_distance_tbl OUT NOCOPY JTF_NUMBER_TABLE,

61: p_auto_match_flag IN VARCHAR2,
62: p_get_distance_flag IN VARCHAR2 := 'F',
63: x_matched_id OUT NOCOPY JTF_NUMBER_TABLE,
64: x_partner_details OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
65: x_distance_tbl OUT NOCOPY JTF_NUMBER_TABLE,
66: x_distance_uom_returned OUT NOCOPY VARCHAR2,
67: x_flagcount OUT NOCOPY JTF_VARCHAR2_TABLE_100,
68: x_return_status OUT NOCOPY VARCHAR2,
69: x_msg_count OUT NOCOPY NUMBER,

Line 84: l_matched_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

80: from as_leads_all asla
81: where asla.lead_id = pc_lead_id;
82:
83:
84: l_matched_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
85: l_new_matched_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
86:
87: l_incumbent_pt_party_id NUMBER;
88: l_matched_tbl_last_idx NUMBER := 0;

Line 85: l_new_matched_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

81: where asla.lead_id = pc_lead_id;
82:
83:
84: l_matched_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
85: l_new_matched_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
86:
87: l_incumbent_pt_party_id NUMBER;
88: l_matched_tbl_last_idx NUMBER := 0;
89: l_incumbent_idx NUMBER := 0;

Line 98: l_prefered_pt_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

94: l_customer_address pv_locator.party_address_rec_type;
95: --x_distance_uom_returned VARCHAR2(30);
96:
97: l_no_of_prefered_pts NUMBER := 0;
98: l_prefered_pt_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
99: l_prefered_dist_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
100: l_prefered_dist_uom VARCHAR2(200);
101: l_partner_dist_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
102: l_tokenize_attr_tbl JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();

Line 99: l_prefered_dist_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

95: --x_distance_uom_returned VARCHAR2(30);
96:
97: l_no_of_prefered_pts NUMBER := 0;
98: l_prefered_pt_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
99: l_prefered_dist_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
100: l_prefered_dist_uom VARCHAR2(200);
101: l_partner_dist_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
102: l_tokenize_attr_tbl JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();
103:

Line 101: l_partner_dist_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

97: l_no_of_prefered_pts NUMBER := 0;
98: l_prefered_pt_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
99: l_prefered_dist_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
100: l_prefered_dist_uom VARCHAR2(200);
101: l_partner_dist_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
102: l_tokenize_attr_tbl JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();
103:
104: l_locator_flag VARCHAR2(1) := 'Y';
105: BEGIN

Line 118: x_matched_id := JTF_NUMBER_TABLE();

114: G_PKG_NAME) THEN
115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
116:
117: END IF;
118: x_matched_id := JTF_NUMBER_TABLE();
119: x_partner_details := JTF_VARCHAR2_TABLE_4000();
120: x_distance_tbl := JTF_NUMBER_TABLE();
121: x_flagcount := JTF_VARCHAR2_TABLE_100();
122:

Line 120: x_distance_tbl := JTF_NUMBER_TABLE();

116:
117: END IF;
118: x_matched_id := JTF_NUMBER_TABLE();
119: x_partner_details := JTF_VARCHAR2_TABLE_4000();
120: x_distance_tbl := JTF_NUMBER_TABLE();
121: x_flagcount := JTF_VARCHAR2_TABLE_100();
122:
123: -- Initialize message list if p_init_msg_list is set to TRUE.
124: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 175: FROM TABLE (CAST(x_matched_id AS JTF_NUMBER_TABLE)))) a

171: FOR x IN (
172: SELECT idx
173: FROM (SELECT rownum idx, column_value party_id
174: FROM (SELECT column_value
175: FROM TABLE (CAST(x_matched_id AS JTF_NUMBER_TABLE)))) a
176: WHERE a.party_id = l_incumbent_pt_party_id)
177: LOOP
178: l_incumbent_idx := x.idx;
179:

Line 306: FROM TABLE (CAST(x_matched_id AS JTF_NUMBER_TABLE)))) a

302: FOR x IN (
303: SELECT idx
304: FROM (SELECT rownum idx, column_value party_id
305: FROM (SELECT column_value
306: FROM TABLE (CAST(x_matched_id AS JTF_NUMBER_TABLE)))) a
307: WHERE a.party_id = l_incumbent_pt_party_id)
308: LOOP
309: l_incumbent_idx := x.idx;
310: END LOOP;

Line 443: p_attr_id_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,

439: p_api_version_number IN NUMBER,
440: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
441: p_commit IN VARCHAR2 := FND_API.G_FALSE,
442: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
443: p_attr_id_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,
444: p_attr_value_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
445: p_attr_operator_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,
446: p_attr_data_type_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,
447: p_attr_selection_mode IN VARCHAR2,

Line 453: x_matched_id OUT NOCOPY JTF_NUMBER_TABLE,

449: p_selection_criteria IN VARCHAR2,
450: p_resource_id IN NUMBER,
451: p_lead_id IN NUMBER,
452: p_auto_match_flag IN VARCHAR2,
453: x_matched_id OUT NOCOPY JTF_NUMBER_TABLE,
454: x_return_status OUT NOCOPY VARCHAR2,
455: x_msg_count OUT NOCOPY NUMBER,
456: x_msg_data OUT NOCOPY VARCHAR2,
457: p_top_n_rows_by_profile IN VARCHAR2 := 'T')IS

Line 463: l_attr_val_cnt_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

459: Type l_tmp is Table of Varchar2(4000) index by binary_integer;
460:
461: l_tmp_tbl JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();
462: l_tmp_tbl1 l_tmp;
463: l_attr_val_cnt_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
464: l_where Varchar2(32000);
465: l_value_count Number := 0;
466: l_tmp_where Varchar2(32000);
467: attr_seq NUMBER := 1;

Line 528: l_matched_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

524: l_distance_uom VARCHAR2(30);
525: l_customer_address pv_locator.party_address_rec_type;
526: --x_distance_uom_returned VARCHAR2(30);
527:
528: l_matched_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
529: l_no_of_prefered_pts NUMBER := 0;
530: l_prefered_pt_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
531: l_prefered_dist_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
532: l_prefered_dist_uom VARCHAR2(200);

Line 530: l_prefered_pt_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

526: --x_distance_uom_returned VARCHAR2(30);
527:
528: l_matched_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
529: l_no_of_prefered_pts NUMBER := 0;
530: l_prefered_pt_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
531: l_prefered_dist_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
532: l_prefered_dist_uom VARCHAR2(200);
533: l_partner_dist_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
534: l_tokenize_attr_tbl JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();

Line 531: l_prefered_dist_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

527:
528: l_matched_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
529: l_no_of_prefered_pts NUMBER := 0;
530: l_prefered_pt_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
531: l_prefered_dist_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
532: l_prefered_dist_uom VARCHAR2(200);
533: l_partner_dist_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
534: l_tokenize_attr_tbl JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();
535: l_opr_meaning VARCHAR2(30);

Line 533: l_partner_dist_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

529: l_no_of_prefered_pts NUMBER := 0;
530: l_prefered_pt_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
531: l_prefered_dist_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
532: l_prefered_dist_uom VARCHAR2(200);
533: l_partner_dist_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
534: l_tokenize_attr_tbl JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();
535: l_opr_meaning VARCHAR2(30);
536:
537: -- --------------------------------------------------------------------------

Line 569: x_matched_id := JTF_NUMBER_TABLE();

565: fnd_msg_pub.initialize;
566: END IF;
567:
568: x_return_status := FND_API.G_RET_STS_SUCCESS ;
569: x_matched_id := JTF_NUMBER_TABLE();
570:
571: if p_attr_id_tbl.count() = 0
572: or p_attr_value_tbl.count() = 0
573: or p_attr_operator_tbl.count() = 0

Line 1504: x_matched_prt OUT NOCOPY JTF_NUMBER_TABLE,

1500: p_selection_criteria IN VARCHAR2,
1501: p_num_of_attrs IN NUMBER,
1502: p_bind_var_tbl IN bind_var_tbl,
1503: p_top_n_rows_by_profile IN VARCHAR2 := 'T',
1504: x_matched_prt OUT NOCOPY JTF_NUMBER_TABLE,
1505: x_prt_matched OUT NOCOPY BOOLEAN,
1506: x_matched_attr_cnt OUT NOCOPY NUMBER,
1507: x_return_status OUT NOCOPY VARCHAR2,
1508: x_msg_count OUT NOCOPY NUMBER,

Line 1562: x_matched_prt := JTF_NUMBER_TABLE();

1558: fnd_msg_pub.initialize;
1559: END IF;
1560:
1561: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1562: x_matched_prt := JTF_NUMBER_TABLE();
1563:
1564: -- ------------------------------------------------------------------------
1565: -- Determines how many partners should be retrieved. This is determined
1566: -- by the profile PV_TOP_N_MATCH_PARTNERS. p_top_n_rows_by_profile

Line 2038: p_matched_id IN OUT NOCOPY JTF_NUMBER_TABLE,

2034: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2035: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2036: p_lead_id IN NUMBER,
2037: p_extra_partner_details IN JTF_VARCHAR2_TABLE_1000,
2038: p_matched_id IN OUT NOCOPY JTF_NUMBER_TABLE,
2039: x_partner_details OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
2040: x_flagcount OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2041: x_return_status OUT NOCOPY VARCHAR2,
2042: x_msg_count OUT NOCOPY NUMBER,

Line 2073: l_partner_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

2069: l_internal_org_name VARCHAR2(3600);
2070: l_internal_flag VARCHAR2(1);
2071: l_party_flag VARCHAR2(1);
2072: l_partner_names VARCHAR2(3600);
2073: l_partner_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
2074: l_count NUMBER;
2075: l_wf_status VARCHAR2(1000);
2076: l_active_flag VARCHAR2(1);
2077: l_partner_detail_sql VARCHAR2(4000);

Line 2139: SELECT * FROM TABLE (CAST(p_matched_id AS JTF_NUMBER_TABLE))

2135: and hzr.subject_id = HZOP_pt.party_id and nvl(hzop_pt.effective_end_date,sysdate) >= sysdate
2136: and hzr.object_id = HZOP_vend.party_id and nvl(hzop_vend.effective_end_date,sysdate) >= sysdate
2137: and (HZOP_vend.internal_flag = 'N' or hzop_pt.internal_flag = 'Y')
2138: and pvpp.partner_id in (
2139: SELECT * FROM TABLE (CAST(p_matched_id AS JTF_NUMBER_TABLE))
2140: )
2141: and hzr.object_id = vend.party_id
2142: and hzr.relationship_code in ('PARTNER_OF','VAD_OF');
2143:

Line 2174: FROM (SELECT column_value FROM TABLE (CAST(p_matched_id AS JTF_NUMBER_TABLE)))) x_partner

2170: from hz_parties hzp , pv_partner_profiles pvpp ,
2171: pv_attribute_codes_vl pvac, hz_relationships hzr ,
2172: hz_organization_profiles HZOP,
2173: (SELECT rownum idx, column_value
2174: FROM (SELECT column_value FROM TABLE (CAST(p_matched_id AS JTF_NUMBER_TABLE)))) x_partner
2175: where pvpp_partner_id in (SELECT * FROM THE(select CAST(p_matched_id AS JTF_NUMBER_TABLE) from dual))
2176: and pvpp.partner_id = x_partner.column_value
2177: and hzr.party_id = pvpp.partner_id
2178: and hzr.subject_id = hzp.party_id

Line 2175: where pvpp_partner_id in (SELECT * FROM THE(select CAST(p_matched_id AS JTF_NUMBER_TABLE) from dual))

2171: pv_attribute_codes_vl pvac, hz_relationships hzr ,
2172: hz_organization_profiles HZOP,
2173: (SELECT rownum idx, column_value
2174: FROM (SELECT column_value FROM TABLE (CAST(p_matched_id AS JTF_NUMBER_TABLE)))) x_partner
2175: where pvpp_partner_id in (SELECT * FROM THE(select CAST(p_matched_id AS JTF_NUMBER_TABLE) from dual))
2176: and pvpp.partner_id = x_partner.column_value
2177: and hzr.party_id = pvpp.partner_id
2178: and hzr.subject_id = hzp.party_id
2179: and hzr.object_id = HZOP.party_id

Line 2200: FROM (SELECT column_value FROM TABLE (CAST(p_matched_id AS JTF_NUMBER_TABLE)))) x_partner

2196: from hz_parties hzp,
2197: pv_partner_profiles pvpp,
2198: pv_attribute_codes_vl pvac,
2199: (SELECT rownum idx, column_value
2200: FROM (SELECT column_value FROM TABLE (CAST(p_matched_id AS JTF_NUMBER_TABLE)))) x_partner
2201: where pvpp.partner_id = x_partner.column_value
2202: and pvpp.partner_party_id = hzp.party_id
2203: and pvpp.PARTNER_LEVEL = pvac.attr_code_id(+)
2204: order by x_partner.idx;

Line 2287: '(SELECT column_value FROM TABLE (CAST(:1 AS JTF_NUMBER_TABLE)))) x_partner '||

2283: 'to_char(pvpp.oppty_last_offered_date, ''YYYY-MM-DD HH:MI:SS''), '||
2284: 'pvpp.status active_flag ' ||
2285: 'from hz_parties hzp , pv_partner_profiles pvpp, pv_attribute_codes_tl pvac, '||
2286: '(SELECT rownum idx, column_value FROM '||
2287: '(SELECT column_value FROM TABLE (CAST(:1 AS JTF_NUMBER_TABLE)))) x_partner '||
2288: 'where pvpp.partner_id = x_partner.column_value ' ||
2289: 'and pvpp.partner_party_id = hzp.party_id ' ||
2290: 'and pvpp.PARTNER_LEVEL = pvac.attr_code_id(+) '||
2291: 'and pvac.language(+) = USERENV(''LANG'') ' ||

Line 2659: x_assigned_partner_id OUT NOCOPY JTF_NUMBER_TABLE,

2655: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2656: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2657: p_lead_id IN NUMBER,
2658: p_resource_id IN NUMBER,
2659: x_assigned_partner_id OUT NOCOPY JTF_NUMBER_TABLE,
2660: x_partner_details OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
2661: x_flagcount OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2662: x_return_status OUT NOCOPY VARCHAR2,
2663: x_msg_count OUT NOCOPY NUMBER,

Line 2780: x_assigned_partner_id := JTF_NUMBER_TABLE();

2776:
2777: l_tmp_tbl := JTF_VARCHAR2_TABLE_1000();
2778: x_flagcount := JTF_VARCHAR2_TABLE_100();
2779: x_partner_details := JTF_VARCHAR2_TABLE_4000();
2780: x_assigned_partner_id := JTF_NUMBER_TABLE();
2781: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2782:
2783: /**
2784: p_wf_started value passed into the API has to be either Y or N.

Line 3149: l_partner_id_tbl JTF_NUMBER_TABLE;

3145: l_partner_count number := 1;
3146: l_partner_id number;
3147: l_rank number;
3148: l_source_type VARCHAR2(30);
3149: l_partner_id_tbl JTF_NUMBER_TABLE;
3150: l_rank_tbl JTF_NUMBER_TABLE;
3151: l_source_type_tbl JTF_VARCHAR2_TABLE_100;
3152: l_party_id number;
3153: l_party_count number := 0;

Line 3150: l_rank_tbl JTF_NUMBER_TABLE;

3146: l_partner_id number;
3147: l_rank number;
3148: l_source_type VARCHAR2(30);
3149: l_partner_id_tbl JTF_NUMBER_TABLE;
3150: l_rank_tbl JTF_NUMBER_TABLE;
3151: l_source_type_tbl JTF_VARCHAR2_TABLE_100;
3152: l_party_id number;
3153: l_party_count number := 0;
3154:

Line 3184: l_PARTNER_ID_TBL := JTF_NUMBER_TABLE();

3180: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3181: fnd_msg_pub.initialize;
3182: END IF;
3183:
3184: l_PARTNER_ID_TBL := JTF_NUMBER_TABLE();
3185: l_RANK_TBL := JTF_NUMBER_TABLE();
3186: l_source_type_tbl := jtf_varchar2_table_100();
3187: x_return_status := FND_API.G_RET_STS_SUCCESS ;
3188:

Line 3185: l_RANK_TBL := JTF_NUMBER_TABLE();

3181: fnd_msg_pub.initialize;
3182: END IF;
3183:
3184: l_PARTNER_ID_TBL := JTF_NUMBER_TABLE();
3185: l_RANK_TBL := JTF_NUMBER_TABLE();
3186: l_source_type_tbl := jtf_varchar2_table_100();
3187: x_return_status := FND_API.G_RET_STS_SUCCESS ;
3188:
3189: open lc_get_saved_pts(p_lead_id);

Line 3198: FROM TABLE (CAST(l_partner_id_tbl AS JTF_NUMBER_TABLE))

3194: IF l_partner_id_tbl.count > 0 THEN
3195: FOR x IN ( SELECT count(party_id) cnt
3196: FROM (SELECT rownum idx, column_value party_id
3197: FROM (SELECT column_value
3198: FROM TABLE (CAST(l_partner_id_tbl AS JTF_NUMBER_TABLE))
3199: )
3200: ) a
3201: WHERE a.party_id = l_partner_id
3202: GROUP BY A.PARTY_ID )