1 PACKAGE CN_PERIOD_QUOTAS_GRP as
2 /* $Header: cnxgprds.pls 120.2 2005/10/19 06:06:14 chanthon ship $ */
3
4 -- API name : Create_Period_Quotas
5 -- Type : Group.
6 -- Pre-reqs : None.
7 -- Usage : Used to create entry into cn_period_quotas
8 --
9 -- Desc : Create period Quotas, can be called independently from any oracle
10 -- applications. currently this program is called from public API
11 -- and from Forms directly.
12 --
13 -- Parameters :
14 -- IN : p_api_version IN NUMBER Required
15 -- p_init_msg_list IN VARCHAR2 Optional
16 -- Default = FND_API.G_FALSE
17 -- p_commit IN VARCHAR2 Optional
18 -- Default = FND_API.G_FALSE
19 -- p_validation_level IN NUMBER Optional
20 -- Default = FND_API.G_VALID_LEVEL_FULL
21 -- OUT : x_return_status OUT VARCHAR2(1)
22 -- x_msg_count OUT NUMBER
23 -- x_msg_data OUT VARCHAR2(2000)
24 -- : x_loading_status OUT VARCHAR2(50)
25 -- Detailed error code returned from procedure.
26 -- IN : p_quota_name IN VARCHAR2 Required
27 -- p_period_quotas_rec_tbl
28 -- CN_PLAN_ELEMENT_PUB.period_quotas_rec_tbl_type;
29 -- Version : Current version 1.0
30 -- Initial version 1.0
31 --
32 -- Notes : Note text
33 --
34 -- End of comments
35
36 PROCEDURE Create_Period_Quotas
37 (
38 p_api_version IN NUMBER,
39 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
40 p_commit IN VARCHAR2 := FND_API.G_FALSE,
41 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
42 x_return_status OUT NOCOPY VARCHAR2,
43 x_msg_count OUT NOCOPY NUMBER,
44 x_msg_data OUT NOCOPY VARCHAR2,
45 p_quota_name IN VARCHAR2,
46 p_period_quotas_rec_tbl IN CN_PLAN_ELEMENT_PUB.PERIOD_QUOTAS_REC_TBL_TYPE
47 := CN_PLAN_ELEMENT_PUB.G_MISS_PERIOD_QUOTAS_REC_TBL,
48 x_loading_status OUT NOCOPY VARCHAR2,
49 p_is_duplicate IN VARCHAR2 DEFAULT 'N'
50 ) ;
51
52 PROCEDURE Update_Period_Quotas
53 (
54 p_api_version IN NUMBER,
55 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
56 p_commit IN VARCHAR2 := FND_API.G_FALSE,
57 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
58 x_return_status OUT NOCOPY VARCHAR2,
59 x_msg_count OUT NOCOPY NUMBER,
60 x_msg_data OUT NOCOPY VARCHAR2,
61 p_quota_name IN VARCHAR2,
62 p_period_quotas_rec_tbl IN CN_PLAN_ELEMENT_PUB.PERIOD_QUOTAS_REC_TBL_TYPE
63 := CN_PLAN_ELEMENT_PUB.G_MISS_PERIOD_QUOTAS_REC_TBL,
64 x_loading_status OUT NOCOPY VARCHAR2
65 ) ;
66
67 END CN_PERIOD_QUOTAS_GRP;