PACKAGE: APPS.CN_PERIODS_API

Source

1 PACKAGE cn_periods_api AS
2 -- $Header: cnsyprs.pls 120.3 2005/12/19 13:34:00 mblum noship $
3 
4 
5 /* ----------------------------------------------------------------------- */
6   --+
7   -- Procedure Name
8   --   Update_GL_Status
9   -- Purpose
10   -- Update status in GL_PERIOD_STATUSES
11   --+
12 
13   PROCEDURE update_gl_status (x_org_id             NUMBER, -- MOAC Change
14                               x_period_name	   VARCHAR2,
15 			      x_closing_status	   VARCHAR2,
16 			      x_forecast_flag      VARCHAR2,
17 			      x_application_id	   NUMBER,
18 			      x_set_of_books_id    NUMBER,
19 			      x_freeze_flag        VARCHAR2,
20 			      x_last_update_date   DATE,
21 			      x_last_update_login  NUMBER,
22 			      x_last_updated_by    NUMBER) ;
23 
24 
25 /* ----------------------------------------------------------------------- */
26   --+
27   -- Procedure Name
28   -- Check_CN_Period_Record
29   -- Purpose
30   -- Create a CN status record in CN_PERIOD_STATUSES if it doesn't exist.
31   --+
32 
33   PROCEDURE Check_CN_Period_Record (x_org_id             NUMBER, -- MOAC Change
34                                     x_period_name	 VARCHAR2,
35 				    x_closing_status	 VARCHAR2,
36 				    x_period_type	 VARCHAR2,
37 				    x_period_year	 NUMBER,
38 				    x_quarter_num        NUMBER,
39 				    x_period_num	 NUMBER,
40 				    x_period_set_name    VARCHAR2,
41 				    x_start_date         DATE,
42 				    x_end_date           DATE,
43 				    x_freeze_flag        VARCHAR2,
44 				    x_repository_id	 NUMBER) ;
45 
46 
47   --+
48   -- Procedure Name
49   --   Set_Dates
50   -- Purpose
51   --   Return a data range.  Used by Collection/Notify code.
52   --+
53 
54   PROCEDURE Set_Dates ( x_start_period_id  cn_period_statuses.period_id%TYPE,
55 			x_end_period_id    cn_period_statuses.period_id%TYPE,
56 			x_org_id           cn_period_statuses.org_id%TYPE,
57 			x_start_date	   OUT NOCOPY    DATE,
58 			x_end_date	   OUT NOCOPY    DATE) ;
59 
60   PROCEDURE populate_srp_tables(errbuf OUT NOCOPY VARCHAR2,
61                                 retcode OUT NOCOPY NUMBER);
62 
63   PROCEDURE populate_srp_tables_runner(errbuf OUT nocopy VARCHAR2,
64 				       retcode OUT nocopy NUMBER,
65 				       p_physical_batch_id NUMBER,
66 				       p_parent_proc_audit_id NUMBER);
67 
68 END cn_periods_api;