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.AS_SALES_LEAD_ENGINE_PVT dependencies on PV_CHECK_MATCH_PUB

Line 757: b.attribute_id = pv_check_match_pub.g_a_Country_ AND

753: FROM pv_process_rules_b a,
754: pv_enty_select_criteria b,
755: pv_selected_attr_values c
756: WHERE b.selection_type_code = 'INPUT_FILTER' AND
757: b.attribute_id = pv_check_match_pub.g_a_Country_ AND
758: a.process_type = c_process_type AND
759: a.process_rule_id = b.process_rule_id AND
760: b.selection_criteria_id = c.selection_criteria_id(+) AND
761: ((b.operator = 'EQUALS' AND c.attribute_value = c_country) OR

Line 774: b.attribute_id = pv_check_match_pub.g_a_Campaign_ AND

770: FROM pv_process_rules_b a,
771: pv_enty_select_criteria b,
772: pv_selected_attr_values c
773: WHERE b.selection_type_code = 'INPUT_FILTER' AND
774: b.attribute_id = pv_check_match_pub.g_a_Campaign_ AND
775: a.process_type = c_process_type AND
776: a.process_rule_id = b.process_rule_id AND
777: b.selection_criteria_id = c.selection_criteria_id(+) AND
778: ((b.operator = 'EQUALS' AND c.attribute_value = TO_CHAR(c_source_promotion_id)) OR

Line 795: pv_check_match_pub.g_a_Campaign_Setup_Type

791: pv_selected_attr_values c
792: WHERE b.selection_type_code = 'INPUT_FILTER' AND
793: b.attribute_id =
794: --575
795: pv_check_match_pub.g_a_Campaign_Setup_Type
796: AND
797: a.process_type = c_process_type AND
798: a.process_rule_id = b.process_rule_id AND
799: b.selection_criteria_id = c.selection_criteria_id(+) AND

Line 815: b.attribute_id = pv_check_match_pub.g_a_Lead_Status AND

811: FROM pv_process_rules_b a,
812: pv_enty_select_criteria b,
813: pv_selected_attr_values c
814: WHERE b.selection_type_code = 'INPUT_FILTER' AND
815: b.attribute_id = pv_check_match_pub.g_a_Lead_Status AND
816: a.process_type = c_process_type AND
817: a.process_rule_id = b.process_rule_id AND
818: b.selection_criteria_id = c.selection_criteria_id(+) AND
819: ((b.operator = 'EQUALS' AND c.attribute_value = c_status_code) OR

Line 834: b.attribute_id = pv_check_match_pub.g_a_Product_Interest AND

830: pv_selected_attr_values c,
831: as_sales_lead_lines asll
832: WHERE a.process_rule_id = b.process_rule_id AND
833: b.selection_criteria_id = c.selection_criteria_id(+) AND
834: b.attribute_id = pv_check_match_pub.g_a_Product_Interest AND
835: a.process_type = c_process_type AND
836: b.selection_type_code = 'INPUT_FILTER' AND
837: asll.sales_lead_id = c_sales_lead_id AND
838: ((b.operator = 'IS_NOT_NULL' AND asll.CATEGORY_ID IS NOT NULL) OR

Line 862: b.attribute_id = pv_check_match_pub.g_a_Creation_Date AND

858: pv_selected_attr_values c
859: WHERE a.process_rule_id = b.process_rule_id AND
860: b.selection_type_code = 'INPUT_FILTER' AND
861: b.selection_criteria_id = c.selection_criteria_id(+) AND
862: b.attribute_id = pv_check_match_pub.g_a_Creation_Date AND
863: a.process_type = c_process_type AND
864: ((b.operator = 'EQUALS' AND c_creation_date = c.attribute_value) OR
865: (b.operator = 'NOT_EQUALS' AND c_creation_date <> c.attribute_value) OR
866: (b.operator = 'LESS_THAN' AND c_creation_date < c.attribute_value) OR

Line 884: b.attribute_id = pv_check_match_pub.g_a_Area_Code AND

880: FROM pv_process_rules_b a,
881: pv_enty_select_criteria b,
882: pv_selected_attr_values c
883: WHERE b.selection_type_code = 'INPUT_FILTER' AND
884: b.attribute_id = pv_check_match_pub.g_a_Area_Code AND
885: a.process_type = c_process_type AND
886: a.process_rule_id = b.process_rule_id AND
887: b.selection_criteria_id = c.selection_criteria_id(+) AND
888: ((b.operator = 'EQUALS' AND c.attribute_value = c_area_code) OR

Line 907: b.attribute_id = pv_check_match_pub.g_a_State_ AND

903: FROM pv_process_rules_b a,
904: pv_enty_select_criteria b,
905: pv_selected_attr_values c
906: WHERE b.selection_type_code = 'INPUT_FILTER' AND
907: b.attribute_id = pv_check_match_pub.g_a_State_ AND
908: a.process_type = c_process_type AND
909: a.process_rule_id = b.process_rule_id AND
910: b.selection_criteria_id = c.selection_criteria_id(+) AND
911: ((b.operator = 'EQUALS' AND c.attribute_value = c_state) OR

Line 924: b.attribute_id = pv_check_match_pub.g_a_Province AND

920: FROM pv_process_rules_b a,
921: pv_enty_select_criteria b,
922: pv_selected_attr_values c
923: WHERE b.selection_type_code = 'INPUT_FILTER' AND
924: b.attribute_id = pv_check_match_pub.g_a_Province AND
925: a.process_type = c_process_type AND
926: a.process_rule_id = b.process_rule_id AND
927: b.selection_criteria_id = c.selection_criteria_id(+) AND
928: ((b.operator = 'EQUALS' AND c.attribute_value = c_province) OR

Line 947: b.attribute_id = pv_check_match_pub.g_a_County AND

943: FROM pv_process_rules_b a,
944: pv_enty_select_criteria b,
945: pv_selected_attr_values c
946: WHERE b.selection_type_code = 'INPUT_FILTER' AND
947: b.attribute_id = pv_check_match_pub.g_a_County AND
948: a.process_type = c_process_type AND
949: a.process_rule_id = b.process_rule_id AND
950: b.selection_criteria_id = c.selection_criteria_id(+) AND
951: ((b.operator = 'EQUALS' AND c.attribute_value = c_county) OR

Line 970: b.attribute_id = pv_check_match_pub.g_a_City AND

966: FROM pv_process_rules_b a,
967: pv_enty_select_criteria b,
968: pv_selected_attr_values c
969: WHERE b.selection_type_code = 'INPUT_FILTER' AND
970: b.attribute_id = pv_check_match_pub.g_a_City AND
971: a.process_type = c_process_type AND
972: a.process_rule_id = b.process_rule_id AND
973: b.selection_criteria_id = c.selection_criteria_id(+) AND
974: ((b.operator = 'EQUALS' AND c.attribute_value = c_city) OR

Line 993: b.attribute_id = pv_check_match_pub.g_a_Postal_Code AND

989: FROM pv_process_rules_b a,
990: pv_enty_select_criteria b,
991: pv_selected_attr_values c
992: WHERE b.selection_type_code = 'INPUT_FILTER' AND
993: b.attribute_id = pv_check_match_pub.g_a_Postal_Code AND
994: a.process_type = c_process_type AND
995: a.process_rule_id = b.process_rule_id AND
996: b.selection_criteria_id = c.selection_criteria_id(+) AND
997: ((b.operator = 'EQUALS' AND c.attribute_value = c_postal_code) OR

Line 1016: b.attribute_id = pv_check_match_pub.g_a_Customer_Category AND

1012: FROM pv_process_rules_b a,
1013: pv_enty_select_criteria b,
1014: pv_selected_attr_values c
1015: WHERE b.selection_type_code = 'INPUT_FILTER' AND
1016: b.attribute_id = pv_check_match_pub.g_a_Customer_Category AND
1017: a.process_type = c_process_type AND
1018: a.process_rule_id = b.process_rule_id AND
1019: b.selection_criteria_id = c.selection_criteria_id(+) AND
1020: ((b.operator = 'EQUALS' AND c.attribute_value = c_category_code) OR

Line 1033: b.attribute_id = pv_check_match_pub.g_a_all AND

1029: FROM pv_process_rules_b a,
1030: pv_enty_select_criteria b,
1031: pv_selected_attr_values c
1032: WHERE b.selection_type_code = 'INPUT_FILTER' AND
1033: b.attribute_id = pv_check_match_pub.g_a_all AND
1034: a.process_type = c_process_type AND
1035: a.process_rule_id = b.process_rule_id AND
1036: b.selection_criteria_id = c.selection_criteria_id AND
1037: b.operator = 'EQUALS' AND c.attribute_value = 'Y'

Line 1162: l_input_filter_tbl PV_CHECK_MATCH_PUB.t_input_filter;

1158: l_criterion_rule_index NUMBER;
1159: l_matched_rule_index_tbl NUMBER_TABLE;
1160: l_attr_index NUMBER;
1161: l_min_score NUMBER := -1000; -- no socre is less than -1000
1162: l_input_filter_tbl PV_CHECK_MATCH_PUB.t_input_filter;
1163: l_rank NUMBER;
1164: l_prev_attribute_id NUMBER;
1165: l_prev_selection_criteria_id NUMBER;
1166: l_selection_criteria_id NUMBER;

Line 1174: l_entity_attr_value_tbl PV_CHECK_MATCH_PUB.t_entity_attr_value;

1170: l_attr_value VARCHAR2(500);
1171: l_attr_to_value VARCHAR2(500);
1172: l_rule_attr_value VARCHAR2(1500);
1173: l_rule_attr_to_value VARCHAR2(1500);
1174: l_entity_attr_value_tbl PV_CHECK_MATCH_PUB.t_entity_attr_value;
1175: l_entity_rule_applied_id NUMBER;
1176: l_final_index NUMBER;
1177: l_final_cron_rule_id NUMBER;
1178: l_sales_lead_log_id NUMBER;

Line 1441: pv_check_match_pub.Retrieve_Input_Filter (

1437: END IF;
1438: EXIT;
1439: END IF;
1440:
1441: pv_check_match_pub.Retrieve_Input_Filter (
1442: p_api_version_number => 1.0,
1443: p_init_msg_list => p_init_msg_list,
1444: p_commit => p_commit,
1445: p_validation_level => p_validation_level,

Line 1564: pv_check_match_pub.Check_Match (

1560: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1561: 'prev_op=' || l_prev_operator);
1562: END IF;
1563: l_match_attribute_flag :=
1564: pv_check_match_pub.Check_Match (
1565: p_attribute_id =>
1566: l_prev_attribute_id,
1567: p_entity => 'SALES_LEAD',
1568: p_entity_id => p_sales_lead_id,

Line 1633: pv_check_match_pub.Check_Match (

1629: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1630: 'prev_op=' || l_prev_operator);
1631: END IF;
1632: l_match_attribute_flag :=
1633: pv_check_match_pub.Check_Match (
1634: p_attribute_id => l_prev_attribute_id,
1635: p_entity => 'SALES_LEAD',
1636: p_entity_id => p_sales_lead_id,
1637: p_rule_attr_value => l_rule_attr_value,

Line 2002: -- l_entity_attr_value_tbl returned by pv_check_match_pub.check_match(,,)

1998: Debug('a_t_v2::' || l_concat_attribute_to_value);
1999:
2000:
2001: -- As we are looping through the attributes, we will refer to the
2002: -- l_entity_attr_value_tbl returned by pv_check_match_pub.check_match(,,)
2003: -- This contains the cached attribute value
2004:
2005: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2006: 'PV :: ' || l_entity_attr_value_tbl(l_enty_select_criteria_val.attribute_id).attribute_value);

Line 2015: if (l_enty_select_criteria_val.attribute_id = pv_check_match_pub.g_a_Product_Interest) then

2011: -- One problem is that PV API returns the expanded concatenated value
2012: -- for FUE attribs (e.g # 510 i.e Prod Interest) We want the non expanded value
2013: -- so we have to call get_entity_attr_values(..) again.
2014:
2015: if (l_enty_select_criteria_val.attribute_id = pv_check_match_pub.g_a_Product_Interest) then
2016:
2017: l_entity_attr_value_tbl.delete(l_enty_select_criteria_val.attribute_id);
2018:
2019: pv_check_match_pub.Get_Entity_Attr_Values (

Line 2019: pv_check_match_pub.Get_Entity_Attr_Values (

2015: if (l_enty_select_criteria_val.attribute_id = pv_check_match_pub.g_a_Product_Interest) then
2016:
2017: l_entity_attr_value_tbl.delete(l_enty_select_criteria_val.attribute_id);
2018:
2019: pv_check_match_pub.Get_Entity_Attr_Values (
2020: p_api_version_number => 1.0,
2021: p_attribute_id => l_enty_select_criteria_val.attribute_id,
2022: p_entity => 'SALES_LEAD',
2023: p_entity_id => p_sales_lead_id,