APPS.AMS_ACTMETRICFACT_PVT dependencies on AMS_ACT_METRIC_FACTS_ALL

Line 267: FROM ams_act_metric_facts_all fact, ams_act_metric_formulas formula

263:
264: CURSOR c_fundfact_getfacts IS
265: SELECT fact.hierarchy_id, fact.node_id, fact.level_depth, fact.fact_value
266: ,formula.formula_id, formula.formula_type
267: FROM ams_act_metric_facts_all fact, ams_act_metric_formulas formula
268: WHERE fact.activity_metric_id = p_act_metric_id
269: AND fact.formula_id = formula.formula_id
270: ORDER BY fact.level_depth, fact.node_id, formula.formula_type asc;
271:

Line 289: FROM ams_act_metric_facts_all fact

285: -- get allocation amount summary of this node's children
286: CURSOR c_fundfact_getchildsum(p_hierarchy_id NUMBER, p_node_id NUMBER,
287: p_level_depth NUMBER, p_formula_id NUMBER) IS
288: SELECT NVL(SUM(fact_value), 0)
289: FROM ams_act_metric_facts_all fact
290: WHERE activity_metric_id = p_act_metric_id
291: AND hierarchy_id = p_hierarchy_id
292: AND EXISTS
293: (SELECT 1 FROM ams_act_metric_formulas formula

Line 448: FROM ams_act_metric_facts_all

444: l_sql_err_msg varchar2(4000);
445:
446: CURSOR c_act_metric_fact_count(l_act_metric_fact_id IN NUMBER) IS
447: SELECT count(1)
448: FROM ams_act_metric_facts_all
449: WHERE activity_metric_fact_id = l_act_metric_fact_id;
450:
451: CURSOR c_act_metric_fact_id IS
452: SELECT ams_act_metric_facts_all_s.NEXTVAL

Line 452: SELECT ams_act_metric_facts_all_s.NEXTVAL

448: FROM ams_act_metric_facts_all
449: WHERE activity_metric_fact_id = l_act_metric_fact_id;
450:
451: CURSOR c_act_metric_fact_id IS
452: SELECT ams_act_metric_facts_all_s.NEXTVAL
453: FROM dual;
454:
455: BEGIN
456: --

Line 576: Insert into ams_act_metric_facts_all (

572: -- Insert into the base table.
573: --
574:
575:
576: Insert into ams_act_metric_facts_all (
577: activity_metric_fact_id,
578: last_update_date,
579: last_updated_by,
580: creation_date,

Line 875: -- Updates an entry in the AMS_ACT_METRIC_FACTS_ALL table for

871: -- NAME
872: -- Update_ActMetricFact
873: --
874: -- PURPOSE
875: -- Updates an entry in the AMS_ACT_METRIC_FACTS_ALL table for
876: -- a given activity_metric record.
877: --
878: -- NOTES
879: --

Line 1033: Update ams_act_metric_facts_all Set

1029: END IF;
1030:
1031:
1032:
1033: Update ams_act_metric_facts_all Set
1034: object_version_number = object_version_number + 1,
1035: last_update_date = SYSDATE,
1036: last_updated_by = NVL(fnd_global.user_id, -1),
1037: last_update_login = NVL(fnd_global.conc_login_id, -1),

Line 1247: FROM ams_act_metric_facts_all

1243: l_activity_metric_fact_id NUMBER;
1244:
1245: CURSOR c_act_metric_fact_info IS
1246: SELECT activity_metric_fact_id
1247: FROM ams_act_metric_facts_all
1248: WHERE activity_metric_fact_id = p_activity_metric_fact_id
1249: AND object_version_number = p_object_version_number
1250: FOR UPDATE OF activity_metric_fact_id NOWAIT;
1251:

Line 1385: FROM ams_act_metric_facts_all

1381: )
1382: IS
1383: CURSOR c_act_metric_fact IS
1384: SELECT *
1385: FROM ams_act_metric_facts_all
1386: WHERE activity_metric_fact_id = p_act_metric_fact_rec.activity_metric_fact_id;
1387:
1388: l_act_metric_fact_rec c_act_metric_fact%ROWTYPE;
1389: BEGIN

Line 1797: -- Deletes an entry in the ams_act_metric_facts_all table.

1793: -- NAME
1794: -- Delete_ActMetricFact
1795: --
1796: -- PURPOSE
1797: -- Deletes an entry in the ams_act_metric_facts_all table.
1798: --
1799: -- NOTES
1800: --
1801: -- HISTORY

Line 1877: DELETE FROM ams_act_metric_facts_all

1873: END IF;
1874:
1875: IF(p_activity_metric_id IS NOT NULL) THEN
1876:
1877: DELETE FROM ams_act_metric_facts_all
1878: WHERE activity_metric_id = p_activity_metric_id;
1879:
1880: ELSIF (p_activity_metric_fact_id IS NOT NULL) THEN
1881:

Line 1882: DELETE FROM ams_act_metric_facts_all

1878: WHERE activity_metric_id = p_activity_metric_id;
1879:
1880: ELSIF (p_activity_metric_fact_id IS NOT NULL) THEN
1881:
1882: DELETE FROM ams_act_metric_facts_all
1883: WHERE activity_metric_fact_id = p_activity_metric_fact_id
1884: AND object_version_number = p_object_version_number;
1885:
1886: END IF;

Line 2427: p_table_name => 'ams_act_metric_facts_all',

2423:
2424: l_where_clause := ' activity_metric_fact_id = '||p_act_metric_fact_rec.activity_metric_fact_id ;
2425:
2426: IF AMS_Utility_PVT.Check_Uniqueness(
2427: p_table_name => 'ams_act_metric_facts_all',
2428: p_where_clause => l_where_clause
2429: ) = FND_API.g_false
2430: THEN
2431: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 2480: SELECT 1 from ams_act_metric_facts_all

2476: l_additional_where_clause VARCHAR2(4000); -- Used by Check_FK_Exists.
2477: l_lookup_type VARCHAR2(30);
2478:
2479: 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
2480: SELECT 1 from ams_act_metric_facts_all
2481: WHERE hierarchy_id = p_hierarchy_id
2482: AND node_id = p_node_id
2483: AND formula_id = p_formula_id
2484: AND activity_metric_fact_id <> p_act_metric_fact_id