PACKAGE: APPS.AMS_METRICCUSTOM_PVT

Source

1 PACKAGE ams_metriccustom_pvt AS
2 /* $Header: amsvrcss.pls 120.0 2005/06/01 02:36:52 appldev noship $ */
3 ---------------------------------------------------------------------
4 -- FUNCTION
5 --     get_rollup_value
6 --
7 -- PURPOSE
8 --    Get the rollup values for the events and campaigns
9 --
10 -- PARAMETERS
11 --    p_act_met_id: the new record to be inserted
12 -- RETURNS
13 --   l_tot_value :  sum of the roolup metrics value
14 --
15 -- NOTES
16 --    1. Checks whether metrics is used by campaigns.
17 --    2. Checks for the child campaign if exists and select the functional actual value, functional
18 --       forecasted value  used by it (passing the category id and sub_category_id) and sum it up.
19 --    3. Checks whether the metrics is used by events.
20 --    4. Find out the sub events associated to it and get the functional actual value,functional
21 --       forcasted value and it adds it up.
22 --    5. Calls  update API and passes the functional actual value .
23 --    6. Returns the total sum
24 ---------------------------------------------------------------------
25 
26 FUNCTION get_rollup_value (
27   p_act_met_id IN NUMBER ) RETURN NUMBER;
28 
29 --------------------------------------------------------------------
30 
31 END ams_metriccustom_pvt;