PACKAGE: APPS.CN_COMP_PLANS_PKG

Source

1 PACKAGE CN_COMP_PLANS_PKG as
2 /* $Header: cnplipls.pls 120.0 2005/07/08 12:43:09 appldev noship $ */
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_attribute_category       VARCHAR2
42    ,x_attribute1               VARCHAR2
43    ,x_attribute2               VARCHAR2
44    ,x_attribute3               VARCHAR2
45    ,x_attribute4               VARCHAR2
46    ,x_attribute5               VARCHAR2
47    ,x_attribute6               VARCHAR2
48    ,x_attribute7               VARCHAR2
49    ,x_attribute8               VARCHAR2
50    ,x_attribute9               VARCHAR2
51    ,x_attribute10              VARCHAR2
52    ,x_attribute11              VARCHAR2
53    ,x_attribute12              VARCHAR2
54    ,x_attribute13              VARCHAR2
55    ,x_attribute14              VARCHAR2
56    ,x_attribute15              VARCHAR2
57    ,x_ORG_ID                   NUMBER
58   ) ;
59 -- Name
60 --
61 -- Purpose
62 --
63 -- Notes
64 --
65 --
66 PROCEDURE End_Record(
67 		     X_Rowid       	 	VARCHAR2  ,
68 		     X_Comp_Plan_Id       	NUMBER    ,
69 		     X_Name                   	VARCHAR2  ,
70 		     X_Description            	VARCHAR2  ,
71 		     x_start_date         	DATE      ,
72 		     X_End_date          	DATE      ,
73 		     X_Program_Type		VARCHAR2  ,
74 		     x_status_code		VARCHAR2  ,
75 		     x_allow_rev_class_overlap	VARCHAR2
76 		     );
77 
78 -- Name
79 --
80 -- Purpose
81 --
82 -- Notes
83 --  Must be public as called on when-validate-item
84 --  debug remove this
85 FUNCTION Check_Unique( X_Comp_Plan_Id   NUMBER
86 			,X_Name  	 VARCHAR2) RETURN BOOLEAN;
87 
88 -- Procedure Name
89 --  Check_unique_rev_class
90 -- Purpose
91 --  Ensure there are no duplicate revenue classes assigned to a comp plan.
92 FUNCTION check_unique_rev_class
93   ( x_comp_plan_id             NUMBER
94     ,x_name                     VARCHAR2
95     ,x_allow_rev_class_overlap  VARCHAR2) RETURN BOOLEAN;
96 
97 
98 -- Name
99 --
100 -- Purpose
101 --
102 -- Notes
103 --
104 --
105 PROCEDURE Set_Status(  x_comp_plan_id        	NUMBER
106 		       ,x_quota_id		NUMBER
107 		       ,x_rate_schedule_id	NUMBER
108 		       ,x_status_code   	VARCHAR2
109 		       ,x_event		        VARCHAR2);
110 -- Name
111 --
112 -- Purpose
113 --
114 -- Notes
115 --
116 --
117 PROCEDURE Get_status( X_Comp_Plan_Id           NUMBER
118 		      ,X_status_code	IN OUT NOCOPY VARCHAR2
119 		      ,x_status	IN OUT NOCOPY         VARCHAR2);
120 -- Name
121 --
122 -- Purpose
123 --
124 -- Notes
125 --  Must be public as called on key-delrec
126 --
127 FUNCTION Check_Assigned( X_Comp_Plan_Id  NUMBER) RETURN BOOLEAN;
128 
129 -- Name
130 --
131 -- Purpose
132 --
133 -- Notes
134 --
135 --
136 FUNCTION Check_period_range(  X_Comp_Plan_Id  	NUMBER
137 			       ,x_start_date    DATE
138 			       ,x_end_date      DATE ) RETURN BOOLEAN;
139 
140 END CN_COMP_PLANS_PKG;