1 PACKAGE CN_ACC_PERIODS_PVT AUTHID CURRENT_USER AS
2 /*$Header: cnvsyprs.pls 120.2 2005/08/02 10:33:40 mblum noship $*/
3
4 TYPE acc_period_rec_type IS RECORD
5 (period_name gl_period_statuses.period_name%TYPE,
6 period_year gl_period_statuses.period_year%TYPE,
7 start_date gl_period_statuses.start_date%TYPE,
8 end_date gl_period_statuses.end_date%TYPE,
9 closing_status_meaning gl_lookups.meaning%TYPE,
10 prosessing_status cn_lookups.meaning%TYPE,
11 freeze_flag cn_period_statuses.freeze_flag%TYPE,
12 object_version_number cn_period_statuses.object_version_number%TYPE);
13
14 TYPE acc_period_tbl_type IS TABLE OF acc_period_rec_type INDEX BY BINARY_INTEGER;
15
16 -- Procedure to start OPEN_PERIODS concurrent request
17 PROCEDURE open_period
18 (errbuf OUT NOCOPY VARCHAR2,
19 retcode OUT NOCOPY NUMBER,
20 p_period_name IN VARCHAR2,
21 p_freeze_flag IN VARCHAR2);
22
23 -- Procedure to start concurrent request for opening a period
24 PROCEDURE start_request(p_org_id IN NUMBER, x_request_id OUT NOCOPY NUMBER);
25
26
27 -- Start of comments
28 -- API name : Update_Acc_Periods
29 -- Type : Private.
30 -- Function :
31 -- Pre-reqs : None.
32 -- Parameters :
33 -- IN : p_api_version IN NUMBER Required
34 -- p_init_msg_list IN VARCHAR2 Optional
35 -- Default = FND_API.G_FALSE
36 -- p_commit IN VARCHAR2 Optional
37 -- Default = FND_API.G_FALSE
38 -- p_validation_level IN NUMBER Optional
39 -- Default = FND_API.G_VALID_LEVEL_FULL
40 -- p_acc_period_tbl IN acc_period_tbl_type Required
41 -- Default = null
42 -- IN p_org_id IN NUMBER Required
43 -- OUT : x_return_status OUT VARCHAR2(1)
44 -- x_msg_count OUT NUMBER
45 -- x_msg_data OUT VARCHAR2(2000)
46 -- Version : Current version 1.0
47 -- Initial version 1.0
48 --
49 -- Notes : 1) update period_status, insert period record into cn_period_statuses if the
50 -- the corresponding record does not exist in cn_period_statuses
51 --
52 -- End of comments
53
54 PROCEDURE Update_Acc_Periods
55 (p_api_version IN NUMBER ,
56 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
57 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
58 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
59 p_acc_period_tbl IN acc_period_tbl_type ,
60 p_org_id IN NUMBER,
61 x_return_status OUT NOCOPY VARCHAR2 ,
62 x_msg_count OUT NOCOPY NUMBER ,
63 x_msg_data OUT NOCOPY VARCHAR2 );
64
65 -- populate the accumulation periods screen
66 PROCEDURE get_acc_periods
67 (p_year IN NUMBER,
68 x_system_status OUT NOCOPY cn_lookups.meaning%TYPE,
69 x_calendar OUT NOCOPY cn_period_sets.period_set_name%TYPE,
70 x_period_type OUT NOCOPY cn_period_types.period_type%TYPE,
71 x_acc_period_tbl OUT NOCOPY acc_period_tbl_type);
72
73 END CN_ACC_PERIODS_PVT;