[Home] [Help]
PACKAGE: APPS.CN_COMP_PLANS_PKG
Source
1 PACKAGE CN_COMP_PLANS_PKG AUTHID CURRENT_USER as
2 /* $Header: cnplipls.pls 120.0.12010000.2 2008/08/30 08:01:51 ramchint ship $ */
3 --
4 --Date Name Description
5 ----------------------------------------------------------------------------+
6 -- Modified the table handler with the start date and end date for periods
7 -- Modified Date 06/30/99
8 --Name
9 --
10 --Purpose
11 --
12 --Notes
13
14 -- Name
15 --
16 -- Purpose
17 --
18 -- Notes
19 --
20 --
21 PROCEDURE Begin_Record
22 (
23 X_Operation VARCHAR2
24 ,X_Rowid IN OUT NOCOPY VARCHAR2
25 ,X_Comp_Plan_Id IN OUT NOCOPY NUMBER
26 ,X_Name VARCHAR2
27 ,X_Last_Update_Date DATE
28 ,X_Last_Updated_By NUMBER
29 ,X_Creation_Date DATE
30 ,X_Created_By NUMBER
31 ,X_Last_Update_Login NUMBER
32 ,X_Description VARCHAR2
33 ,X_Start_date DATE
34 ,X_Start_date_old DATE
35 ,X_end_date DATE
36 ,X_end_date_old DATE
37 ,X_Program_Type VARCHAR2
38 ,x_status_code VARCHAR2
39 ,x_allow_rev_class_overlap VARCHAR2
40 ,x_allow_rev_class_overlap_old VARCHAR2
41 ,x_sum_trx_flag VARCHAR2
42 ,x_attribute_category VARCHAR2
43 ,x_attribute1 VARCHAR2
44 ,x_attribute2 VARCHAR2
45 ,x_attribute3 VARCHAR2
46 ,x_attribute4 VARCHAR2
47 ,x_attribute5 VARCHAR2
48 ,x_attribute6 VARCHAR2
49 ,x_attribute7 VARCHAR2
50 ,x_attribute8 VARCHAR2
51 ,x_attribute9 VARCHAR2
52 ,x_attribute10 VARCHAR2
53 ,x_attribute11 VARCHAR2
54 ,x_attribute12 VARCHAR2
55 ,x_attribute13 VARCHAR2
56 ,x_attribute14 VARCHAR2
57 ,x_attribute15 VARCHAR2
58 ,x_ORG_ID NUMBER
59 ) ;
60 -- Name
61 --
62 -- Purpose
63 --
64 -- Notes
65 --
66 --
67 PROCEDURE End_Record(
68 X_Rowid VARCHAR2 ,
69 X_Comp_Plan_Id NUMBER ,
70 X_Name VARCHAR2 ,
71 X_Description VARCHAR2 ,
72 x_start_date DATE ,
73 X_End_date DATE ,
74 X_Program_Type VARCHAR2 ,
75 x_status_code VARCHAR2 ,
76 x_allow_rev_class_overlap VARCHAR2,
77 x_sum_trx_flag VARCHAR2
78 );
79
80 -- Name
81 --
82 -- Purpose
83 --
84 -- Notes
85 -- Must be public as called on when-validate-item
86 -- debug remove this
87 FUNCTION Check_Unique( X_Comp_Plan_Id NUMBER
88 ,X_Name VARCHAR2) RETURN BOOLEAN;
89
90 -- Procedure Name
91 -- Check_unique_rev_class
92 -- Purpose
93 -- Ensure there are no duplicate revenue classes assigned to a comp plan.
94 FUNCTION check_unique_rev_class
95 ( x_comp_plan_id NUMBER
96 ,x_name VARCHAR2
97 ,x_allow_rev_class_overlap VARCHAR2
98 ,x_sum_trx_flag VARCHAR2) RETURN BOOLEAN;
99
100
101 -- Name
102 --
103 -- Purpose
104 --
105 -- Notes
106 --
107 --
108 PROCEDURE Set_Status( x_comp_plan_id NUMBER
109 ,x_quota_id NUMBER
110 ,x_rate_schedule_id NUMBER
111 ,x_status_code VARCHAR2
112 ,x_event VARCHAR2);
113 -- Name
114 --
115 -- Purpose
116 --
117 -- Notes
118 --
119 --
120 PROCEDURE Get_status( X_Comp_Plan_Id NUMBER
121 ,X_status_code IN OUT NOCOPY VARCHAR2
122 ,x_status IN OUT NOCOPY VARCHAR2);
123 -- Name
124 --
125 -- Purpose
126 --
127 -- Notes
128 -- Must be public as called on key-delrec
129 --
130 FUNCTION Check_Assigned( X_Comp_Plan_Id NUMBER) RETURN BOOLEAN;
131
132 -- Name
133 --
134 -- Purpose
135 --
136 -- Notes
137 --
138 --
139 FUNCTION Check_period_range( X_Comp_Plan_Id NUMBER
140 ,x_start_date DATE
141 ,x_end_date DATE ) RETURN BOOLEAN;
142
143 END CN_COMP_PLANS_PKG;