DBA Data[Home] [Help]

PACKAGE: APPS.GCS_RAISE_EVENT_PKG

Source


1 PACKAGE GCS_RAISE_EVENT_PKG as
2 /* $Header: gcs_raise_events.pls 120.5 2007/12/05 14:37:20 rthati noship $ */
3 
4   --
5   -- Procedure
6   --   raise_hierarchy_alt_event()
7   -- Purpose
8   --   Raised by the Hierarchy UI, during the update flow
9   -- Arguments
10   --	p_pre_cons_relationship_id	NUMBER
11   --	p_post_cons_relationship_id	NUMBER
12   -- 	p_trx_type_code			VARCHAR2
13   --    p_trx_date_day			NUMBER
14   --	p_trx_date_month		NUMBER
15   --	p_trx_date_year			NUMBER
16   --	p_hidden_flag			VARCHAR2
17   --	p_intermediate_trtmnt_id	NUMBER
18   --    p_intermediate_pct_owned	NUMBER
19 
20   PROCEDURE	raise_hierarchy_alt_event	(p_pre_cons_relationship_id	IN	NUMBER,
21   						 p_post_cons_relationship_id	IN	NUMBER,
22   						 p_trx_type_code		IN	VARCHAR2,
23   						 p_trx_date_day			IN	NUMBER,
24   						 p_trx_date_month		IN	NUMBER,
25   						 p_trx_date_year		IN	NUMBER,
26   						 p_hidden_flag			IN	VARCHAR2,
27   						 p_intermediate_trtmnt_id	IN	NUMBER,
28   						 p_intermediate_pct_owned	IN	NUMBER);
29 
30   --
31   -- Procedure
32   --   raise_execute_eng_event()
33   -- Purpose
34   --   Raised by the Consolidation Monitor UI to submit a consolidation
35   -- Arguments
36   --	p_consolidation_hierarchy	NUMBER
37   -- 	p_consolidation_entity		NUMBER
38   --	p_run_identifier		NUMBER
39   --	p_cal_period_id			VARCHAR2
40   --	p_balance_type_code		VARCHAR2
41   --	p_process_method                VARCHAR2
42 
43   PROCEDURE	raise_execute_eng_event		(p_consolidation_hierarchy	IN	NUMBER,
44   						 p_consolidation_entity		IN	NUMBER,
45   						 p_run_identifier		IN	VARCHAR2,
46   						 p_cal_period_id		IN	VARCHAR2,
47   						 p_balance_type_code		IN	VARCHAR2,
48   						 p_process_method		IN	VARCHAR2);
49 
50   -- bugfix: 5569522 Added p_analysis_cycle_id
51   -- Procedure
52   --   raise_execute_eng_event()
53   -- Purpose
54   --   Raised by the Consolidation Monitor UI to submit a consolidation
55   -- Arguments
56   --	p_consolidation_hierarchy NUMBER
57   -- 	p_consolidation_entity	  NUMBER
58   --	p_run_identifier		  NUMBER
59   --	p_cal_period_id			  VARCHAR2
60   --	p_balance_type_code		  VARCHAR2
61   --	p_process_method          VARCHAR2
62   --    p_analysis_cycle_id       NUMBER
63 
64   PROCEDURE	raise_execute_eng_event		(p_consolidation_hierarchy	IN	NUMBER,
65   						 p_consolidation_entity	IN	NUMBER,
66   						 p_run_identifier		IN	VARCHAR2,
67   						 p_cal_period_id		IN	VARCHAR2,
68   						 p_balance_type_code	IN	VARCHAR2,
69   						 p_process_method		IN	VARCHAR2,
70   						 p_request_id			OUT	NOCOPY NUMBER,
71                          p_analysis_cycle_id    IN  NUMBER);
72 
73 
74   -- bugfix: 5569522 - Added p_analysis_cycle_id
75   -- Procedure
76   --   execute_consolidation()
77   -- Purpose
78   --   Execute Consolidation
79   -- Arguments
80   --	x_retcode			VARCHAR2
81   --    x_errbuf			VARCHAR2
82   --    p_consolidation_hierarchy       NUMBER
83   --    p_consolidation_entity          NUMBER
84   --    p_run_identifier                NUMBER
85   --    p_cal_period_id                 VARCHAR2
86   --    p_balance_type_code             VARCHAR2
87   --    p_process_method                VARCHAR2
88   --    p_analysis_cycle_id             NUMBER
89 
90   PROCEDURE execute_consolidation (x_retcode  OUT	NOCOPY VARCHAR2,
91               					   x_errbuf	  OUT	NOCOPY VARCHAR2,
92         						   p_run_identifier 	      IN OUT NOCOPY VARCHAR2,
93 						           p_consolidation_hierarchy  IN  NUMBER,
94                                    p_consolidation_entity     IN  NUMBER,
95                                    p_cal_period_id            IN  VARCHAR2,
96                                    p_balance_type_code        IN  VARCHAR2,
97                                    p_process_method           IN  VARCHAR2,
98            						   p_called_via_srs		      IN  VARCHAR2 DEFAULT 'Y',
99                                    p_analysis_cycle_id        IN  NUMBER);
100 
101 END;
102 
103 
104