1 PACKAGE CN_SRP_PERIOD_QUOTAS_PKG AUTHID CURRENT_USER as
2 /* $Header: cnsrpqos.pls 120.0 2005/06/06 17:59:19 appldev noship $ */
3
4 /*
5 Date Name Description
6 ----------------------------------------------------------------------------+
7 10-JUN-99 S. Kumar Modifiying the Package from Period ID to Date Effty
8
9 Name
10
11 Purpose
12
13 Notes
14
15 10-JUN-99 Modifying this package
16
17 10-AUG-99 Added the Performance Goal Column and the begin record parameter
18
19 */
20 ----------------------------------------------------------------------------+
21 -- PROCEDURE BEGIN_RECORD
22 ----------------------------------------------------------------------------+
23 PROCEDURE Begin_Record(
24 x_operation VARCHAR2
25 ,x_period_target_unit_code VARCHAR2
26 ,x_srp_period_quota_id NUMBER
27 ,x_srp_quota_assign_id NUMBER
28 ,x_srp_plan_assign_id NUMBER
29 ,x_quota_id NUMBER
30 ,x_period_id NUMBER
31 ,x_target_amount NUMBER
32 ,x_period_payment NUMBER
33 ,x_performance_goal NUMBER
34 ,x_quarter_num NUMBER
35 ,x_period_year NUMBER
36 ,x_quota_type_code VARCHAR2
37 ,x_salesrep_id NUMBER := NULL -- only for bonus pay
38 ,x_end_date DATE := NULL -- only for bonus pay
39 ,x_commission_payed_ptd NUMBER := NULL -- only for bonus pay
40 ,x_creation_date DATE
41 ,x_created_by NUMBER
42 ,x_last_update_date DATE
43 ,x_last_updated_by NUMBER
44 ,x_last_update_login NUMBER);
45
46 -- Name
47 --
48 -- Purpose
49 --
50 -- Notes
51 -- Not called by srmt form
52 --
53 ----------------------------------------------------------------------------+
54 -- PROCEDURE INSERT_RECORD
55 -- DESC: called from cn_srp_quota_assigns with srp_plan_assign_id,x_quota_id
56 -- x_start_period_id is Null, x_end_period_id null
57 -- for more info set the body
58 ----------------------------------------------------------------------------+
59 PROCEDURE Insert_Record(
60 x_srp_plan_assign_id NUMBER
61 ,x_quota_id NUMBER
62 ,x_start_period_id NUMBER := NULL
63 ,x_end_period_id NUMBER := NULL
64 ,x_start_date DATE := NULL
65 ,x_end_date DATE := NULL);
66 -- Name
67 --
68 -- Purpose
69 --
70 -- Notes
71 -- Not called by srmt form
72 --
73 ----------------------------------------------------------------------------+
74 -- PROCEDURE DELETE_RECORD
75 ----------------------------------------------------------------------------+
76 PROCEDURE Delete_Record( x_srp_plan_assign_id NUMBER
77 ,x_quota_id NUMBER
78 ,x_start_period_id NUMBER
79 ,x_end_period_id NUMBER
80 ,x_start_date DATE := NULL
81 ,x_end_date DATE := NULL);
82
83 ----------------------------------------------------------------------------+
84 -- PROCEDURE to populate cn_srp_period_quotas_ext table
85 ----------------------------------------------------------------------------+
86
87 PROCEDURE populate_srp_period_quotas_ext
88 (x_operation VARCHAR2,
89 x_srp_period_quota_id NUMBER,
90 x_org_id NUMBER,
91 x_number_dim NUMBER := fnd_api.g_miss_num);
92
93
94 ----------------------------------------------------------------------------+
95 -- PROCEDURE DISTRIBUTE_TARGET
96 ----------------------------------------------------------------------------+
97 PROCEDURE Distribute_Target(
98 x_srp_quota_assign_id NUMBER
99 ,x_target NUMBER
100 ,x_period_target_unit_code VARCHAR2);
101 ----------------------------------------------------------------------------+
102 -- PROCEDURE SELECT_SUMMARY
103 ----------------------------------------------------------------------------+
104 PROCEDURE Select_Summary( x_srp_quota_assign_id NUMBER
105 ,x_total IN OUT NOCOPY NUMBER
106 ,x_total_rtot_db IN OUT NOCOPY NUMBER);
107 ----------------------------------------------------------------------------+
108 -- PROCEDURE SYNCH_TARGET
109 ----------------------------------------------------------------------------+
110 PROCEDURE Synch_Target ( x_srp_plan_assign_id NUMBER
111 ,x_quota_id NUMBER);
112
113 PROCEDURE sync_ITD_values (X_Quota_Id NUMBER);
114
115 PROCEDURE populate_itd_values (x_start_srp_period_quota_id NUMBER);
116 --| ---------------------------------------------------------------------+
117 --| Function Name : next_period
118 --| ---------------------------------------------------------------------+
119 FUNCTION cn_end_date_period(p_end_date DATE, p_org_id NUMBER)
120 RETURN cn_acc_period_statuses_v.end_date%TYPE ;
121
122 END CN_SRP_PERIOD_QUOTAS_PKG;