eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.CN_SRP_PERIODS_PKG

Source


1 PACKAGE CN_SRP_PERIODS_PKG AUTHID CURRENT_USER AS
2 /* $Header: cnsrprds.pls 120.0 2005/06/06 17:35:21 appldev noship $ */
3 --
4 -- Package Name
5 -- CN_SRP_PERIODS_PKG
6 -- Purpose
7 --  Table Handler for CN_SRP_PERIODS
8 -- History
9 -- 26-Jun-99	Angela Chung	Created
10 -- 02-Nov-99    Angela Chung    remove proc : mark_event, raise_status
11 --
12 
13 --/*-------------------------------------------------------------------------*
14 -- Procedure Name
15 --	Insert_row
16 -- Purpose
17 --    Main insert procedure
18 -- *-------------------------------------------------------------------------*/
19 
20 PROCEDURE INSERT_ROW
21   (X_SRP_PERIOD_ID IN OUT NOCOPY NUMBER,
22    X_SALESREP_ID IN NUMBER,
23    x_org_id      IN NUMBER,
24    X_PERIOD_ID IN NUMBER,
25    X_START_DATE IN DATE,
26    X_END_DATE   IN DATE,
27    X_SRP_PLAN_ASSIGN_ID IN NUMBER := NULL,
28    X_CREDIT_TYPE_ID IN NUMBER,
29    X_ROLE_ID IN NUMBER,
30    X_QUOTA_ID IN NUMBER,
31    X_PAY_GROUP_ID IN NUMBER,
32    X_BALANCE1_DTD IN NUMBER := 0,
33    X_BALANCE1_CTD IN NUMBER := 0,
34    X_BALANCE1_BBD IN NUMBER := 0,
35    X_BALANCE1_BBC IN NUMBER := 0,
36    X_BALANCE2_DTD IN NUMBER := 0,
37    X_BALANCE2_CTD IN NUMBER := 0,
38    X_BALANCE2_BBD IN NUMBER := 0,
39    X_BALANCE2_BBC IN NUMBER := 0,
40    X_BALANCE3_DTD IN NUMBER := 0,
41    X_BALANCE3_CTD IN NUMBER := 0,
42    X_BALANCE3_BBD IN NUMBER := 0,
43    X_BALANCE3_BBC IN NUMBER := 0,
44    X_BALANCE4_DTD IN NUMBER := 0,
45    X_BALANCE4_CTD IN NUMBER := 0,
46    X_BALANCE4_BBD IN NUMBER := 0,
47    X_BALANCE4_BBC IN NUMBER := 0,
48    X_BALANCE5_DTD IN NUMBER := 0,
49    X_BALANCE5_CTD IN NUMBER := 0,
50    X_BALANCE5_BBD IN NUMBER := 0,
51    X_BALANCE5_BBC IN NUMBER := 0,
52    X_BALANCE6_DTD IN NUMBER := 0,
53   X_BALANCE6_CTD IN NUMBER := 0,
54   X_BALANCE6_BBD IN NUMBER := 0,
55   X_BALANCE6_BBC IN NUMBER := 0,
56   X_BALANCE7_DTD IN NUMBER := 0,
57   X_BALANCE7_CTD IN NUMBER := 0,
58   X_BALANCE7_BBD IN NUMBER := 0,
59   X_BALANCE7_BBC IN NUMBER := 0,
60   X_BALANCE8_DTD IN NUMBER := 0,
61   X_BALANCE8_CTD IN NUMBER := 0,
62   X_BALANCE8_BBD IN NUMBER := 0,
63   X_BALANCE8_BBC IN NUMBER := 0,
64   X_BALANCE9_DTD IN NUMBER := 0,
65   X_BALANCE9_CTD IN NUMBER := 0,
66   X_BALANCE9_BBD IN NUMBER := 0,
67   X_BALANCE9_BBC IN NUMBER := 0,
68   X_BALANCE10_DTD IN NUMBER := 0,
69   X_BALANCE10_CTD IN NUMBER := 0,
70   X_BALANCE10_BBD IN NUMBER := 0,
71   X_BALANCE10_BBC IN NUMBER := 0,
72   X_BALANCE11_DTD IN NUMBER := 0,
73   X_BALANCE11_CTD IN NUMBER := 0,
74   X_BALANCE11_BBD IN NUMBER := 0,
75   X_BALANCE11_BBC IN NUMBER := 0,
76   X_BALANCE12_DTD IN NUMBER := 0,
77   X_BALANCE12_CTD IN NUMBER := 0,
78   X_BALANCE12_BBD IN NUMBER := 0,
79   X_BALANCE12_BBC IN NUMBER := 0,
80   X_BALANCE13_DTD IN NUMBER := 0,
81   X_BALANCE13_CTD IN NUMBER := 0,
82   X_BALANCE13_BBD IN NUMBER := 0,
83   X_BALANCE13_BBC IN NUMBER := 0,
84   X_BALANCE14_DTD IN NUMBER := 0,
85   X_BALANCE14_CTD IN NUMBER := 0,
86   X_BALANCE14_BBD IN NUMBER := 0,
87   X_BALANCE14_BBC IN NUMBER := 0,
88   X_BALANCE15_DTD IN NUMBER := 0,
89   X_BALANCE15_CTD IN NUMBER := 0,
90   X_BALANCE15_BBD IN NUMBER := 0,
91   X_BALANCE15_BBC IN NUMBER := 0,
92   X_BALANCE16_DTD IN NUMBER := 0,
93   X_BALANCE16_CTD IN NUMBER := 0,
94   X_BALANCE16_BBD IN NUMBER := 0,
95   X_BALANCE16_BBC IN NUMBER := 0,
96   X_BALANCE17_DTD IN NUMBER := 0,
97   X_BALANCE17_CTD IN NUMBER := 0,
98   X_BALANCE17_BBD IN NUMBER := 0,
99   X_BALANCE17_BBC IN NUMBER := 0,
100   X_BALANCE18_DTD IN NUMBER := 0,
101   X_BALANCE18_CTD IN NUMBER := 0,
102   X_BALANCE18_BBD IN NUMBER := 0,
103   X_BALANCE18_BBC IN NUMBER := 0,
104   X_BALANCE19_DTD IN NUMBER := 0,
105   X_BALANCE19_CTD IN NUMBER := 0,
106   X_BALANCE19_BBD IN NUMBER := 0,
107   X_BALANCE19_BBC IN NUMBER := 0,
108   X_BALANCE20_DTD IN NUMBER := 0,
109   X_BALANCE20_CTD IN NUMBER := 0,
110   X_BALANCE20_BBD IN NUMBER := 0,
111   X_BALANCE20_BBC IN NUMBER := 0,
112   X_BALANCE21_DTD IN NUMBER := 0,
113   X_BALANCE21_CTD IN NUMBER := 0,
114   X_BALANCE21_BBD IN NUMBER := 0,
115   X_BALANCE21_BBC IN NUMBER := 0,
116   X_BALANCE22_DTD IN NUMBER := 0,
117   X_BALANCE22_CTD IN NUMBER := 0,
118   X_BALANCE22_BBD IN NUMBER := 0,
119   X_BALANCE22_BBC IN NUMBER := 0,
120   X_BALANCE23_DTD IN NUMBER := 0,
121   X_BALANCE23_CTD IN NUMBER := 0,
122   X_BALANCE23_BBD IN NUMBER := 0,
123   X_BALANCE23_BBC IN NUMBER := 0,
124   X_BALANCE24_DTD IN NUMBER := 0,
125   X_BALANCE24_CTD IN NUMBER := 0,
126   X_BALANCE24_BBD IN NUMBER := 0,
127   X_BALANCE24_BBC IN NUMBER := 0,
128   X_BALANCE25_DTD IN NUMBER := 0,
129   X_BALANCE25_CTD IN NUMBER := 0,
130   X_BALANCE25_BBD IN NUMBER := 0,
131   X_BALANCE25_BBC IN NUMBER := 0,
132   X_BALANCE26_DTD IN NUMBER := 0,
133   X_BALANCE26_CTD IN NUMBER := 0,
134   X_BALANCE26_BBD IN NUMBER := 0,
135   X_BALANCE26_BBC IN NUMBER := 0,
136   X_BALANCE27_DTD IN NUMBER := 0,
137   X_BALANCE27_CTD IN NUMBER := 0,
138   X_BALANCE27_BBD IN NUMBER := 0,
139   X_BALANCE27_BBC IN NUMBER := 0,
140   X_BALANCE28_DTD IN NUMBER := 0,
141   X_BALANCE28_CTD IN NUMBER := 0,
142   X_BALANCE28_BBD IN NUMBER := 0,
143   X_BALANCE28_BBC IN NUMBER := 0,
144   X_BALANCE29_DTD IN NUMBER := 0,
145   X_BALANCE29_CTD IN NUMBER := 0,
146   X_BALANCE29_BBD IN NUMBER := 0,
147   X_BALANCE29_BBC IN NUMBER := 0,
148   X_BALANCE30_DTD IN NUMBER := 0,
149   X_BALANCE30_CTD IN NUMBER := 0,
150   X_BALANCE30_BBD IN NUMBER := 0,
151   X_BALANCE30_BBC IN NUMBER := 0,
152   X_BALANCE31_DTD IN NUMBER := 0,
153   X_BALANCE31_CTD IN NUMBER := 0,
154   X_BALANCE31_BBD IN NUMBER := 0,
155   X_BALANCE31_BBC IN NUMBER := 0,
156   X_BALANCE32_DTD IN NUMBER := 0,
157   X_BALANCE32_CTD IN NUMBER := 0,
158   X_BALANCE32_BBD IN NUMBER := 0,
159   X_BALANCE32_BBC IN NUMBER := 0,
160   X_BALANCE33_DTD IN NUMBER := 0,
161   X_BALANCE33_CTD IN NUMBER := 0,
162   X_BALANCE33_BBD IN NUMBER := 0,
163   X_BALANCE33_BBC IN NUMBER := 0,
164   X_CONSISTENCY_FLAG IN VARCHAR2 := 'Y',
165   X_PAID_FLAG IN  VARCHAR2 := 'N',
166   X_CREATION_DATE IN DATE,
167   X_CREATED_BY IN NUMBER,
168   X_LAST_UPDATE_DATE IN DATE,
169   X_LAST_UPDATED_BY IN NUMBER,
170   X_LAST_UPDATE_LOGIN IN NUMBER
171 );
172 
173 --/*-------------------------------------------------------------------------*
174 -- Procedure Name
175 --	Delete_row
176 -- Purpose
177 --    Delete the Srp Payment Plan Assign
178 -- *-------------------------------------------------------------------------*/
179 
180 PROCEDURE DELETE_ROW
181   (X_SRP_PERIOD_ID IN NUMBER);
182 
183 END CN_SRP_PERIODS_PKG;