PACKAGE: APPS.GL_BIS_ALERTS_PKG

Source

1 PACKAGE GL_BIS_ALERTS_PKG as
2 /* $Header: glubisas.pls 120.2 2005/05/05 01:36:24 kvora ship $ */
3 
4 --
5 -- Package
6 --   GL_BIS_ALERTS_PKG
7 -- Purpose
8 --   To create GL_BIS_ALERTS_PKG package.
9 -- History
10 --   28-MAY-99         K Vora           Created
11 --
12 
13   TYPE Target_Info_Rec_Type IS RECORD
14     (target_id               BISBV_TARGETS.target_id%TYPE,
15      plan_id                 BISBV_BUSINESS_PLANS.plan_id%TYPE,
16      plan_name               BISBV_BUSINESS_PLANS.name%TYPE,
17      org_level_value_id      BISBV_TARGETS.org_level_value_id%TYPE,
18      sob_name                GL_SETS_OF_BOOKS.name%TYPE,
19      chart_of_accounts_id    GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE,
20      time_level_value_id     BISBV_TARGETS.time_level_value_id%TYPE,
21      dim1_level_value_id     BISBV_TARGETS.dim1_level_value_id%TYPE,
22      dim2_level_value_id     BISBV_TARGETS.dim2_level_value_id%TYPE,
23      range1_low              BISBV_TARGETS.range1_low%TYPE,
24      range1_high             BISBV_TARGETS.range1_high%TYPE,
25      range2_low              BISBV_TARGETS.range2_low%TYPE,
26      range2_high             BISBV_TARGETS.range2_high%TYPE,
27      range3_low              BISBV_TARGETS.range3_low%TYPE,
28      range3_high             BISBV_TARGETS.range3_high%TYPE,
29      notify_resp1_id         BISBV_TARGETS.notify_resp1_id%TYPE,
30      notify_resp1_short_name BISBV_TARGETS.notify_resp1_short_name%TYPE,
31      notify_resp2_id         BISBV_TARGETS.notify_resp2_id%TYPE,
32      notify_resp2_short_name BISBV_TARGETS.notify_resp2_short_name%TYPE,
33      notify_resp3_id         BISBV_TARGETS.notify_resp3_id%TYPE,
34      notify_resp3_short_name BISBV_TARGETS.notify_resp3_short_name%TYPE,
35      dim1_segnum             FND_ID_FLEX_SEGMENTS.segment_num%TYPE,
36      dim2_segnum             FND_ID_FLEX_SEGMENTS.segment_num%TYPE);
37 
38   --
39   -- Procedure
40   --   check_revenue
41   -- Purpose
42   --   Compares actual revenue versus planned revenue amounts
43   --   and sends notifications.
44   -- History
45   --   28-MAY-1999  K Vora       Created
46   -- Arguments
47   --   p_period_id		Period set name + Period name
48   -- Example
49   --   gl_bis_alerts_pkg.check_revenue( 'Accounting+JAN-99');
50   --
51 
52   PROCEDURE check_revenue(p_period_id    IN VARCHAR2);
53 
54   --
55   -- Function
56   --   set_performance_measures
57   -- Purpose
58   --   Set values for performance measures monitored on personal home page
59   -- History
60   --   01-JUL-1999  K Vora       Created
61   -- Arguments
62   --   p_sob_id                 Set of books id
63   --   p_mapped_segnum1         Segment number of segment mapped to GL COMPANY
64   --   p_mapped_segnum2         Segment number of segment mapped to GL SECONDARY MEASURE
65   -- Returns
66   --   TRUE  - Performance Measure value was updated correctly
67   --   FALSE - Performance Measure value was not set
68   -- Example
69   --   ret_value := gl_bis_alerts_pkg.check_revenue( 1491, 1, 2);
70   --
71 
72   FUNCTION set_performance_measures(p_sob_id           IN NUMBER,
73                                     p_mapped_segnum1   IN NUMBER,
74                                     p_mapped_segnum2   IN NUMBER)
75            RETURN BOOLEAN;
76 
77   --
78   -- Function
79   --   get_ctarget
80   -- Purpose
81   --   Dummy function. Always returns -1.
82   -- History
83   --   28-MAY-1999  K Vora       Created
84   -- Arguments
85   --   p_target_rec             Target information
86   -- Example
87   --   gl_bis_alerts_pkg.get_ctarget(p_target_rec => l_target_rec);
88   --
89 
90   FUNCTION get_ctarget(
91            p_target_rec   IN BIS_TARGET_PUB.Target_Rec_Type)
92            RETURN NUMBER;
93 
94 
95 END GL_BIS_ALERTS_PKG;