PACKAGE: APPS.AMS_ACTMETRICS_SEED_PVT

Source

1 Package Ams_Actmetrics_Seed_Pvt AS
2 /* $Header: amsvamss.pls 120.2 2005/08/26 15:29:59 dmvincen noship $ */
3 --------------------------------------------------------------------------------
4 --
5 -- NAME
6 --    AMS_ACTMETRICS_SEED_PVT 12.0
7 --
8 -- HISTORY
9 -- 30-Aug-2001   dmvincen     Created
10 -- 05-Sep-2001   dmvincen     Changed paramters to primatives.
11 -- 11-Aug-2005   dmvincen     Added Inferred Calculations.
12 --
13 -- Global variables and constants.
14 --
15 
16 --
17 -- Start type definition
18 --
19 TYPE num_table_type IS TABLE
20   OF NUMBER INDEX BY BINARY_INTEGER;
21 --
22 -- End type definition
23 --
24 
25 
26 FUNCTION  convert_currency(
27    p_from_currency          VARCHAR2
28   ,p_from_amount            NUMBER) return NUMBER;
29 
30 FUNCTION  convert_to_trans_currency(
31    p_trans_currency          VARCHAR2
32   ,p_from_amount            NUMBER) return NUMBER;
33 
34 -- NAME
35 --     Calculate_Seeded_Metrics
36 --
37 -- PURPOSE
38 --
39 -- NOTES
40 --
41 -- HISTORY
42 -- 30-Aug-2001   dmvincen   Created.
43 --
44 PROCEDURE Calculate_Seeded_Metrics(
45           p_arc_act_metric_used_by VARCHAR2 := NULL,
46           p_act_metric_used_by_id NUMBER := NULL);
47 
48 
49 -- NAME
50 --    CALCULATE_TARGET_GROUP
51 --
52 -- PURPOSE
53 --
54 -- NOTES
55 --
56 -- HISTORY
57 -- 20-Aug-2003   sunkumar   Created.
58 --
59 PROCEDURE Calculate_Target_Group(
60           p_arc_act_metric_used_by VARCHAR2 := NULL,
61           p_act_metric_used_by_id NUMBER := NULL);
62 
63 
64 
65 -- NAME
66 --     CALCULATE_SEEDED_LIST_METRICS
67 --
68 -- PURPOSE
69 --
70 -- NOTES
71 --
72 -- HISTORY
73 -- 20-Aug-2003   sunkumar   Created.
74 --
75 PROCEDURE Calculate_Seeded_List_Metrics(
76           p_arc_act_metric_used_by VARCHAR2 := null,
77           p_act_metric_used_by_id NUMBER := null);
78 
79 -- NAME
80 --     CALCULATE_INFERRED_METRICS
81 --
82 -- PURPOSE
83 --
84 -- NOTES
85 --
86 -- HISTORY
87 -- 11-Aug-2005   dmvincen   Created.
88 --
89 PROCEDURE Calculate_Inferred_Metrics(
90           p_arc_act_metric_used_by VARCHAR2,
91           p_act_metric_used_by_id NUMBER);
92 
93 PROCEDURE Calculate_Inferred_Metrics;
94 
95 -- NAME
96 --     Update_Actmetrics_Bulk
97 --
98 -- PURPOSE
99 --     Bulk update the activity metrics for given ids and actual values.
100 --
101 -- NOTES
102 --     Only immediate parents are updated to be dirty.
103 --     To Do: The Costs and Revenue value must be converted.
104 --
105 -- HISTORY
106 -- 30-Aug-2001   dmvincen   Created.
107 --
108 PROCEDURE Update_Actmetrics_Bulk(
109           p_actmetric_id_table IN num_table_type,
110           p_actual_value_table IN num_table_type);
111 
112 END Ams_Actmetrics_Seed_Pvt;