APPS.OZF_ACTMETRICFACT_PVT dependencies on OZF_ACT_METRIC_FACTS_ALL

Line 172: FROM ozf_act_metric_facts_all

168: l_sql_err_msg varchar2(4000);
169:
170: CURSOR c_act_metric_fact_count(l_act_metric_fact_id IN NUMBER) IS
171: SELECT count(1)
172: FROM ozf_act_metric_facts_all
173: WHERE activity_metric_fact_id = l_act_metric_fact_id;
174:
175: CURSOR c_act_metric_fact_id IS
176: SELECT ozf_act_metric_facts_all_s.NEXTVAL

Line 176: SELECT ozf_act_metric_facts_all_s.NEXTVAL

172: FROM ozf_act_metric_facts_all
173: WHERE activity_metric_fact_id = l_act_metric_fact_id;
174:
175: CURSOR c_act_metric_fact_id IS
176: SELECT ozf_act_metric_facts_all_s.NEXTVAL
177: FROM dual;
178:
179: BEGIN
180: --

Line 300: Insert into ozf_act_metric_facts_all (

296: -- Insert into the base table.
297: --
298:
299:
300: Insert into ozf_act_metric_facts_all (
301: activity_metric_fact_id,
302: last_update_date,
303: last_updated_by,
304: creation_date,

Line 611: -- Updates an entry in the ozf_act_metric_facts_all table for

607: -- NAME
608: -- Update_ActMetricFact
609: --
610: -- PURPOSE
611: -- Updates an entry in the ozf_act_metric_facts_all table for
612: -- a given activity_metric record.
613: --
614: -- NOTES
615: --

Line 769: Update ozf_act_metric_facts_all Set

765: END IF;
766:
767:
768:
769: Update ozf_act_metric_facts_all Set
770: object_version_number = object_version_number + 1,
771: last_update_date = SYSDATE,
772: last_updated_by = NVL(fnd_global.user_id, -1),
773: last_update_login = NVL(fnd_global.conc_login_id, -1),

Line 974: FROM ozf_act_metric_facts_all

970: )
971: IS
972: CURSOR c_act_metric_fact IS
973: SELECT *
974: FROM ozf_act_metric_facts_all
975: WHERE activity_metric_fact_id = p_act_metric_fact_rec.activity_metric_fact_id;
976:
977: l_act_metric_fact_rec c_act_metric_fact%ROWTYPE;
978: BEGIN

Line 2169: p_table_name => 'ozf_act_metric_facts_all',

2165:
2166: l_where_clause := ' activity_metric_fact_id = '||p_act_metric_fact_rec.activity_metric_fact_id ;
2167:
2168: IF OZF_Utility_PVT.Check_Uniqueness(
2169: p_table_name => 'ozf_act_metric_facts_all',
2170: p_where_clause => l_where_clause
2171: ) = FND_API.g_false
2172: THEN
2173: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 2222: SELECT 1 from ozf_act_metric_facts_all

2218: l_additional_where_clause VARCHAR2(4000); -- Used by Check_FK_Exists.
2219: l_lookup_type VARCHAR2(30);
2220:
2221: CURSOR c_hierarchy_node_check(p_hierarchy_id number,p_node_id number,p_act_metric_fact_id number,p_act_metric_id number,p_formula_id number) IS
2222: SELECT 1 from ozf_act_metric_facts_all
2223: WHERE hierarchy_id = p_hierarchy_id
2224: AND node_id = p_node_id
2225: AND formula_id = p_formula_id
2226: AND activity_metric_fact_id <> p_act_metric_fact_id