1 PACKAGE GCS_CONS_MONITOR_PKG AUTHID CURRENT_USER AS
2 /* $Header: gcscms.pls 120.3 2007/12/14 04:58:46 cdesouza noship $ */
3
4 --
5 -- Procedure
6 -- lock_results
7 -- Purpose
8 -- lock/unlock consolidation results
9 -- called from consolidation monitor UI
10 -- Arguments
11 -- p_runname Consolidation run identifier
12 -- p_entity_id Consolidation entity identifier
13 -- p_lock_flag Y for lock and N for unlock
14 --
15 PROCEDURE lock_results (
16 p_runname IN VARCHAR2,
17 p_entity_id IN NUMBER,
18 p_lock_flag IN VARCHAR2,
19 x_errbuf OUT NOCOPY VARCHAR2,
20 x_retcode OUT NOCOPY VARCHAR2
21 );
22
23 --
24 -- Procedure
25 -- update_data_status
26 -- Purpose
27 -- Update the gcs_cons_data_status when a new hierarchy is created,
28 -- or an entity is added/deleted, or new data submitted
29 -- Arguments
30 -- p_load_id Data submission identifier
31 -- p_cons_rel_id Consolidation relationship identifier
32 -- p_hierarchy_id Hierarchy for which the logic must be performed
33 -- p_transaction_type NEW, ACQ, or DIS
34 --
35 PROCEDURE update_data_status (
36 p_load_id IN NUMBER DEFAULT NULL,
37 p_cons_rel_id IN NUMBER DEFAULT NULL,
38 p_hierarchy_id IN NUMBER DEFAULT NULL,
39 p_transaction_type IN VARCHAR2 DEFAULT NULL
40 );
41
42 --
43 -- Procedure
44 -- hierarchy_init
45 -- Purpose
46 -- Update the gcs_cons_data_status when a new hierarchy is created
47 -- Arguments
48 -- p_hierarchy_id Hierarchy for which the logic must be performed
49 --
50 PROCEDURE hierarchy_init (
51 x_errbuf OUT NOCOPY VARCHAR2,
52 x_retcode OUT NOCOPY VARCHAR2,
53 p_hierarchy_id NUMBER
54 );
55
56 --
57 -- Procedure
58 -- submit_update_data_status
59 -- Purpose
60 -- Submits update gcs_cons_data_status when a new hierarchy is created,
61 -- or an entity is added/deleted, or new data submitted
62 -- Arguments
63 -- p_load_id Data submission identifier
64 -- p_cons_rel_id Consolidation relationship identifier
65 -- p_hierarchy_id Hierarchy for which the logic must be performed
66 -- p_transaction_type NEW, ACQ, or DIS
67 --
68 PROCEDURE submit_update_data_status(x_errbuf OUT NOCOPY VARCHAR2,
69 x_retcode OUT NOCOPY VARCHAR2,
70 p_load_id IN NUMBER DEFAULT NULL,
71 p_cons_rel_id IN NUMBER DEFAULT NULL,
72 p_hierarchy_id IN NUMBER DEFAULT NULL,
73 p_transaction_type IN VARCHAR2 DEFAULT NULL
74 );
75
76 END GCS_CONS_MONITOR_PKG;
77