APPS.FTE_ACS_PKG dependencies on FTE_ACS_CACHE_PKG

Line 516: l_result_tab fte_acs_cache_pkg.fte_cs_result_attr_tab;

512: FROM FTE_SEL_RULES
513: WHERE rule_id = p_rule_id;
514:
515: l_entity_tab fte_cs_temp_entity_tab;
516: l_result_tab fte_acs_cache_pkg.fte_cs_result_attr_tab;
517: itr NUMBER;
518: l_itr NUMBER;
519: l_cnt NUMBER;
520: l_return_status VARCHAR2(1);

Line 591: FTE_ACS_CACHE_PKG.get_results_for_rule(p_rule_id => l_entity_tab(itr).rule_id,

587: -- Reason for doing this : Only this information can be cached.
588: -- Other information will not be cached.
589: --
590:
591: FTE_ACS_CACHE_PKG.get_results_for_rule(p_rule_id => l_entity_tab(itr).rule_id,
592: x_result_tab => l_result_tab,
593: x_return_status => l_return_status);
594:
595: IF l_debug_on THEN

Line 811: l_output_tab FTE_ACS_CACHE_PKG.fte_cs_entity_attr_tab;

807:
808: l_entity_rec FTE_ACS_PKG.fte_cs_entity_rec_type;
809: l_search_level_tab WSH_UTIL_CORE.column_tab_type;
810:
811: l_output_tab FTE_ACS_CACHE_PKG.fte_cs_entity_attr_tab;
812: l_entity_info FTE_ACS_CACHE_PKG.fte_cs_entity_attr_rec;
813:
814: l_entity_rule_rec fte_cs_entity_rule_rec;
815: l_entity_cnt NUMBER;

Line 812: l_entity_info FTE_ACS_CACHE_PKG.fte_cs_entity_attr_rec;

808: l_entity_rec FTE_ACS_PKG.fte_cs_entity_rec_type;
809: l_search_level_tab WSH_UTIL_CORE.column_tab_type;
810:
811: l_output_tab FTE_ACS_CACHE_PKG.fte_cs_entity_attr_tab;
812: l_entity_info FTE_ACS_CACHE_PKG.fte_cs_entity_attr_rec;
813:
814: l_entity_rule_rec fte_cs_entity_rule_rec;
815: l_entity_cnt NUMBER;
816: l_return_status VARCHAR2(1);

Line 1027: FTE_ACS_CACHE_PKG.GET_MATCHING_RULE( p_info => l_entity_info,

1023: LOOP
1024:
1025: l_entity_info := l_output_tab(itr);
1026:
1027: FTE_ACS_CACHE_PKG.GET_MATCHING_RULE( p_info => l_entity_info,
1028: x_rule_id => l_rule_id,
1029: x_return_status => l_return_status);
1030:
1031: IF l_debug_on THEN

Line 1042: IF (l_rule_id <> FTE_ACS_CACHE_PKG.g_rule_not_found) THEN

1038: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1039: END IF;
1040: END IF;
1041:
1042: IF (l_rule_id <> FTE_ACS_CACHE_PKG.g_rule_not_found) THEN
1043:
1044: l_entities_left := l_entities_left - 1;
1045:
1046: IF NOT(l_single_entity) THEN