[Home] [Help]
38: PROCEDURE tokenize
39: (
40: p_attr_value IN VARCHAR2,
41: p_delimiter IN VARCHAR2,
42: p_attr_value_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_4000
43: );
44:
45: -- %%%%%%%%%%%%%%%%%%%%%% End of Private Routines %%%%%%%%%%%%%%%%%%%%%%%
46:
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,
57: p_att_delmter IN VARCHAR2,
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,
68: x_return_status OUT NOCOPY VARCHAR2,
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
106:
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:
123: -- Initialize message list if p_init_msg_list is set to TRUE.
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,
448: p_att_delmter IN VARCHAR2,
457: p_top_n_rows_by_profile IN VARCHAR2 := 'T')IS
458:
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;
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: -- --------------------------------------------------------------------------
538: -- l_bind_var_tbl is used for keeping track of all bind variables as we go
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,
2043: x_msg_data OUT NOCOPY VARCHAR2) IS
2249: fnd_msg_pub.initialize;
2250: END IF;
2251:
2252: x_flagcount := JTF_VARCHAR2_TABLE_100();
2253: x_partner_details := JTF_VARCHAR2_TABLE_4000();
2254:
2255: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2256:
2257:
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,
2664: x_msg_data OUT NOCOPY VARCHAR2) IS
2775: END IF;
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: /**
3425: PROCEDURE tokenize
3426: (
3427: p_attr_value IN VARCHAR2,
3428: p_delimiter IN VARCHAR2,
3429: p_attr_value_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_4000
3430: )
3431: IS
3432:
3433: l_token VARCHAR2(4000);
3442: END IF;
3443:
3444: l_delm_leng := length(p_delimiter);
3445:
3446: p_attr_value_tbl := JTF_VARCHAR2_TABLE_4000();
3447:
3448: FOR i IN 1..LENGTH(p_attr_value)
3449: LOOP
3450: