1 PACKAGE cn_prd_quota_pvt AUTHID CURRENT_USER AS
2 /*$Header: cnvpedqs.pls 120.2 2005/07/20 19:08:48 fmburu ship $*/
3
4 -- period quota
5 TYPE prd_quota_rec_type IS RECORD (
6 period_quota_id NUMBER := NULL,
7 period_id NUMBER := NULL,
8 period_name cn_period_statuses.period_name%TYPE := NULL,
9 quota_id NUMBER := NULL,
10 period_target NUMBER := NULL,
11 itd_target NUMBER := NULL,
12 period_payment NUMBER := NULL,
13 itd_payment NUMBER := NULL,
14 quarter_num NUMBER := NULL,
15 period_year NUMBER := NULL,
16 org_id NUMBER := NULL,
17 performance_goal NUMBER := NULL,
18 performance_goal_itd NUMBER := NULL,
19 period_target_tot NUMBER := NULL,
20 period_payment_tot NUMBER := NULL,
21 performance_goal_tot NUMBER := NULL,
22 period_target_pct NUMBER := NULL,
23 period_payment_pct NUMBER := NULL,
24 performance_goal_pct NUMBER := NULL,
25 created_by cn_period_quotas.created_by%TYPE := NULL,
26 creation_date cn_period_quotas.creation_date%TYPE := NULL,
27 last_update_login cn_period_quotas.last_update_login%TYPE := NULL,
28 last_update_date cn_period_quotas.last_update_date%TYPE := NULL,
29 last_updated_by cn_period_quotas.last_updated_by%TYPE := NULL,
30 object_version_number cn_period_quotas.object_version_number%TYPE := NULL
31 );
32
33 TYPE prd_quota_tbl_type IS TABLE OF prd_quota_rec_type
34 INDEX BY BINARY_INTEGER;
35
36 TYPE prd_quota_q_rec_type IS RECORD (
37 quota_id NUMBER := NULL,
38 period_target NUMBER := NULL,
39 period_payment NUMBER := NULL,
40 quarter_num NUMBER := NULL,
41 period_year NUMBER := NULL,
42 performance_goal NUMBER := NULL,
43 period_target_tot NUMBER := NULL,
44 period_payment_tot NUMBER := NULL,
45 performance_goal_tot NUMBER := NULL,
46 period_target_pct NUMBER := NULL,
47 period_payment_pct NUMBER := NULL,
48 performance_goal_pct NUMBER := NULL
49 );
50
51 TYPE prd_quota_q_tbl_type IS TABLE OF prd_quota_q_rec_type
52 INDEX BY BINARY_INTEGER;
53
54 TYPE prd_quota_year_rec_type IS RECORD (
55 quota_id NUMBER := NULL,
56 period_target NUMBER := NULL,
57 period_payment NUMBER := NULL,
58 performance_goal NUMBER := NULL,
59 period_year NUMBER := NULL,
60 period_target_tot NUMBER := NULL,
61 period_payment_tot NUMBER := NULL,
62 performance_goal_tot NUMBER := NULL,
63 period_target_pct NUMBER := NULL,
64 period_payment_pct NUMBER := NULL,
65 performance_goal_pct NUMBER := NULL
66 );
67
68 TYPE prd_quota_year_tbl_type IS TABLE OF prd_quota_year_rec_type
69 INDEX BY BINARY_INTEGER;
70
71 -- Global variable that represent missing values.
72 g_miss_prd_quota_rec prd_quota_rec_type;
73 g_miss_prd_quota_rec_tb prd_quota_tbl_type;
74 g_miss_prd_quota_q_rec prd_quota_q_rec_type;
75 g_miss_prd_quota_q_rec_tb prd_quota_q_tbl_type;
76 g_miss_prd_quota_year_rec prd_quota_year_rec_type;
77 g_miss_prd_quota_year_rec_tb prd_quota_year_tbl_type;
78
79 -- Start of comments
80 -- API name : Update_PRD_QUOTA
81 -- Type : Private.
82 -- Function :
83 -- Pre-reqs : None.
84 -- Parameters :
85 -- IN : p_api_version IN NUMBER Required
86 -- p_init_msg_list IN VARCHAR2 Optional
87 -- Default = FND_API.G_FALSE
88 -- p_commit IN VARCHAR2 Optional
89 -- Default = FND_API.G_FALSE
90 -- p_validation_level IN NUMBER Optional
91 -- Default = FND_API.G_VALID_LEVEL_FULL
92 -- p_prd_quota IN prd_quota_rec_type
93 -- OUT : x_return_status OUT VARCHAR2(1)
94 -- x_msg_count OUT NUMBER
95 -- x_msg_data OUT VARCHAR2(2000)
96 -- Version : Current version 1.0
97 -- Notes : Note text
98 --
99 -- End of comments
100 PROCEDURE update_period_quota (
101 p_api_version IN NUMBER,
102 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
103 p_commit IN VARCHAR2 := fnd_api.g_false,
104 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
105 p_prd_quota IN OUT NOCOPY prd_quota_rec_type,
106 x_return_status OUT NOCOPY VARCHAR2,
107 x_msg_count OUT NOCOPY NUMBER,
108 x_msg_data OUT NOCOPY VARCHAR2
109 );
110
111 END cn_prd_quota_pvt;