DBA Data[Home] [Help]

APPS.PV_MATCH_V3_PUB dependencies on PV_CHECK_MATCH_PUB

Line 235: l_entity_attr_value pv_check_match_pub.t_entity_attr_value;

231: IS
232: l_api_version NUMBER := 1.0;
233: l_api_name VARCHAR2(30) := 'Opportunity_Selection';
234:
235: l_entity_attr_value pv_check_match_pub.t_entity_attr_value;
236: l_input_filter pv_check_match_pub.t_input_filter;
237: i NUMBER := 1;
238: j NUMBER;
239: l_next_index NUMBER;

Line 236: l_input_filter pv_check_match_pub.t_input_filter;

232: l_api_version NUMBER := 1.0;
233: l_api_name VARCHAR2(30) := 'Opportunity_Selection';
234:
235: l_entity_attr_value pv_check_match_pub.t_entity_attr_value;
236: l_input_filter pv_check_match_pub.t_input_filter;
237: i NUMBER := 1;
238: j NUMBER;
239: l_next_index NUMBER;
240: l_next_rule_id NUMBER;

Line 380: pv_check_match_pub.Get_Entity_Attr_Values(

376: Debug('Attribute ID: ' || l_attribute_id);
377: Debug('Opportunity ID: ' || p_entity_id);
378: END IF;
379:
380: pv_check_match_pub.Get_Entity_Attr_Values(
381: p_api_version_number => 1.0,
382: p_attribute_id => l_attribute_id,
383: p_entity => p_entity,
384: p_entity_id => p_entity_id,

Line 455: l_matched := pv_check_match_pub.Check_Match(

451: Debug('p_delimiter: ' || l_delimiter);
452: Debug('p_return_type: ' || l_entity_attr_value(l_attribute_id).return_type);
453: END IF;
454:
455: l_matched := pv_check_match_pub.Check_Match(
456: p_attribute_id => l_attribute_id,
457: p_entity_attr_value => l_entity_attr_value(l_attribute_id).attribute_value,
458: p_rule_attr_value => g_opp_selection_tab(i).attribute_value,
459: p_rule_to_attr_value => g_opp_selection_tab(i).attribute_to_value,

Line 517: l_matched := pv_check_match_pub.Check_Match(

513: Debug('p_delimiter: ' || l_delimiter);
514: Debug('p_return_type: ' || l_entity_attr_value(l_attribute_id).return_type);
515: END IF;
516:
517: l_matched := pv_check_match_pub.Check_Match(
518: p_attribute_id => l_attribute_id,
519: p_entity_attr_value => l_entity_attr_value(l_attribute_id).attribute_value,
520: p_rule_attr_value => l_concat_attr_val,
521: p_rule_to_attr_value => l_concat_to_attr_val,

Line 829: l_entity_attr_value pv_check_match_pub.t_entity_attr_value;

825: l_entity_routing lc_entity_routings%ROWTYPE;
826:
827: l_api_version NUMBER := 1.0;
828: l_api_name VARCHAR2(30) := 'Partner_Selection';
829: l_entity_attr_value pv_check_match_pub.t_entity_attr_value;
830: l_temp VARCHAR2(4000);
831: l_num_of_tokens NUMBER;
832: l_attribute_id NUMBER;
833: l_attribute_value VARCHAR2(4000);

Line 1029: pv_check_match_pub.Get_Entity_Attr_Values(

1025: Debug('Attribute ID before calling Get_Entity_Attr_Values: ' || l_attribute_id);
1026: --Debug('Entity Type: ' || p_entity);
1027: END IF;
1028:
1029: pv_check_match_pub.Get_Entity_Attr_Values(
1030: p_api_version_number => 1.0,
1031: p_attribute_id => l_attribute_id,
1032: p_entity => p_entity,
1033: p_entity_id => p_entity_id,

Line 1069: l_num_of_tokens := pv_check_match_pub.Get_Num_Of_Tokens(l_delimiter, l_temp);

1065: -- ---------------------------------------------------------------------
1066: -- Populate PL/SQL table only when the attribute value string IS NOT NULL.
1067: -- ---------------------------------------------------------------------
1068: IF (l_temp IS NOT NULL AND l_temp <> '++++++') THEN
1069: l_num_of_tokens := pv_check_match_pub.Get_Num_Of_Tokens(l_delimiter, l_temp);
1070:
1071: l_attr_id_tbl.EXTEND(l_num_of_tokens);
1072: l_attr_value_tbl.EXTEND(l_num_of_tokens);
1073: l_attr_operator_tbl.EXTEND(l_num_of_tokens);

Line 1081: l_attribute_value := pv_check_match_pub.Retrieve_Token(

1077: -- Everything under the mapping section should be treated as AND
1078: -- condition, which requires one table element per item.
1079: -- ------------------------------------------------------------------
1080: FOR j IN 1..l_num_of_tokens LOOP
1081: l_attribute_value := pv_check_match_pub.Retrieve_Token(
1082: p_delimiter => l_delimiter,
1083: p_attr_value_string => l_temp,
1084: p_input_type => 'STD TOKEN',
1085: p_index => j

Line 3230: l_metric_value := pv_check_match_pub.currency_conversion(l_attr_text);

3226: END IF;
3227:
3228:
3229: ELSIF l_return_type = 'CURRENCY' THEN
3230: l_metric_value := pv_check_match_pub.currency_conversion(l_attr_text);
3231:
3232: ELSE
3233: l_metric_value := 0;
3234: END IF;

Line 3289: l_metric_value := pv_check_match_pub.Currency_Conversion(

3285: begin
3286: --select name into l_curr_value from fnd_currencies_vl
3287: --where currency_code=l_user_currency_code;
3288:
3289: l_metric_value := pv_check_match_pub.Currency_Conversion(
3290: l_attr_text,
3291: l_user_currency_code
3292: ) || ' ' || l_user_currency_code;
3293: