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.

APPS.CN_PAY_ELEMENT_INPUTS_PKG dependencies on CN_PAY_ELEMENT_INPUTS

Line 1: PACKAGE BODY CN_PAY_ELEMENT_INPUTS_PKG AS

1: PACKAGE BODY CN_PAY_ELEMENT_INPUTS_PKG AS
2: /* $Header: cntpeib.pls 115.3 2002/02/05 00:26:02 pkm ship $ */
3: --
4: -- Package Name
5: -- CN_PAY_ELEMENT_INPUTS

Line 5: -- CN_PAY_ELEMENT_INPUTS

1: PACKAGE BODY CN_PAY_ELEMENT_INPUTS_PKG AS
2: /* $Header: cntpeib.pls 115.3 2002/02/05 00:26:02 pkm ship $ */
3: --
4: -- Package Name
5: -- CN_PAY_ELEMENT_INPUTS
6: -- Purpose
7: -- Table Handler for CN_PAY_ELEMENT_INPUTS
8: --
9: -- History

Line 7: -- Table Handler for CN_PAY_ELEMENT_INPUTS

3: --
4: -- Package Name
5: -- CN_PAY_ELEMENT_INPUTS
6: -- Purpose
7: -- Table Handler for CN_PAY_ELEMENT_INPUTS
8: --
9: -- History
10: -- 02-feb-01 Kumar Sivasankaran
11: -- 22-Mar-01 Kumar Sivasankaran Added Couple of Parameters.

Line 38: SELECT cn_pay_element_inputs_s.nextval

34: PROCEDURE Get_UID( X_pay_element_input_id IN OUT NUMBER) IS
35:
36: BEGIN
37:
38: SELECT cn_pay_element_inputs_s.nextval
39: INTO X_pay_element_input_id
40: FROM dual;
41:
42: END Get_UID;

Line 88: INSERT INTO cn_pay_element_inputs

84: BEGIN
85:
86: Get_UID( x_pay_element_input_id );
87:
88: INSERT INTO cn_pay_element_inputs
89: (pay_element_input_id
90: ,quota_pay_element_id
91: ,element_input_id
92: ,element_type_id

Line 152: select 1 INTO l_dummy from CN_PAY_ELEMENT_INPUTS

148: ,p_Last_Update_Date
149: ,p_Last_Update_Login
150: );
151:
152: select 1 INTO l_dummy from CN_PAY_ELEMENT_INPUTS
153: where PAY_ELEMENT_INPUT_ID = x_pay_element_input_id;
154:
155: END Insert_row;
156:

Line 194: FROM cn_pay_element_inputs

190: ) IS
191:
192: CURSOR C IS
193: SELECT *
194: FROM cn_pay_element_inputs
195: WHERE pay_element_input_id = p_pay_element_input_id
196: FOR UPDATE of pay_element_input_id NOWAIT;
197:
198: tlinfo C%ROWTYPE;

Line 301: l_pay_element_input_id cn_pay_element_inputs.pay_element_input_id%TYPE;

297: ,p_Last_Updated_By NUMBER
298: ,p_Last_Update_Date DATE
299: ,p_Last_Update_Login NUMBER ) IS
300:
301: l_pay_element_input_id cn_pay_element_inputs.pay_element_input_id%TYPE;
302: l_element_input_id cn_pay_element_inputs.element_input_id%TYPE;
303: l_quota_pay_element_id cn_pay_element_inputs.quota_pay_element_id%TYPE;
304: l_element_type_id cn_pay_element_inputs.element_type_id%TYPE;
305: l_tab_object_id cn_pay_element_inputs.tab_object_id%TYPE;

Line 302: l_element_input_id cn_pay_element_inputs.element_input_id%TYPE;

298: ,p_Last_Update_Date DATE
299: ,p_Last_Update_Login NUMBER ) IS
300:
301: l_pay_element_input_id cn_pay_element_inputs.pay_element_input_id%TYPE;
302: l_element_input_id cn_pay_element_inputs.element_input_id%TYPE;
303: l_quota_pay_element_id cn_pay_element_inputs.quota_pay_element_id%TYPE;
304: l_element_type_id cn_pay_element_inputs.element_type_id%TYPE;
305: l_tab_object_id cn_pay_element_inputs.tab_object_id%TYPE;
306: l_col_object_id cn_pay_element_inputs.col_object_id%TYPE;

Line 303: l_quota_pay_element_id cn_pay_element_inputs.quota_pay_element_id%TYPE;

299: ,p_Last_Update_Login NUMBER ) IS
300:
301: l_pay_element_input_id cn_pay_element_inputs.pay_element_input_id%TYPE;
302: l_element_input_id cn_pay_element_inputs.element_input_id%TYPE;
303: l_quota_pay_element_id cn_pay_element_inputs.quota_pay_element_id%TYPE;
304: l_element_type_id cn_pay_element_inputs.element_type_id%TYPE;
305: l_tab_object_id cn_pay_element_inputs.tab_object_id%TYPE;
306: l_col_object_id cn_pay_element_inputs.col_object_id%TYPE;
307: l_line_number cn_pay_element_inputs.line_number%TYPE;

Line 304: l_element_type_id cn_pay_element_inputs.element_type_id%TYPE;

300:
301: l_pay_element_input_id cn_pay_element_inputs.pay_element_input_id%TYPE;
302: l_element_input_id cn_pay_element_inputs.element_input_id%TYPE;
303: l_quota_pay_element_id cn_pay_element_inputs.quota_pay_element_id%TYPE;
304: l_element_type_id cn_pay_element_inputs.element_type_id%TYPE;
305: l_tab_object_id cn_pay_element_inputs.tab_object_id%TYPE;
306: l_col_object_id cn_pay_element_inputs.col_object_id%TYPE;
307: l_line_number cn_pay_element_inputs.line_number%TYPE;
308: l_start_date cn_pay_element_inputs.start_date%TYPE;

Line 305: l_tab_object_id cn_pay_element_inputs.tab_object_id%TYPE;

301: l_pay_element_input_id cn_pay_element_inputs.pay_element_input_id%TYPE;
302: l_element_input_id cn_pay_element_inputs.element_input_id%TYPE;
303: l_quota_pay_element_id cn_pay_element_inputs.quota_pay_element_id%TYPE;
304: l_element_type_id cn_pay_element_inputs.element_type_id%TYPE;
305: l_tab_object_id cn_pay_element_inputs.tab_object_id%TYPE;
306: l_col_object_id cn_pay_element_inputs.col_object_id%TYPE;
307: l_line_number cn_pay_element_inputs.line_number%TYPE;
308: l_start_date cn_pay_element_inputs.start_date%TYPE;
309: l_end_date cn_pay_element_inputs.end_date%TYPE;

Line 306: l_col_object_id cn_pay_element_inputs.col_object_id%TYPE;

302: l_element_input_id cn_pay_element_inputs.element_input_id%TYPE;
303: l_quota_pay_element_id cn_pay_element_inputs.quota_pay_element_id%TYPE;
304: l_element_type_id cn_pay_element_inputs.element_type_id%TYPE;
305: l_tab_object_id cn_pay_element_inputs.tab_object_id%TYPE;
306: l_col_object_id cn_pay_element_inputs.col_object_id%TYPE;
307: l_line_number cn_pay_element_inputs.line_number%TYPE;
308: l_start_date cn_pay_element_inputs.start_date%TYPE;
309: l_end_date cn_pay_element_inputs.end_date%TYPE;
310:

Line 307: l_line_number cn_pay_element_inputs.line_number%TYPE;

303: l_quota_pay_element_id cn_pay_element_inputs.quota_pay_element_id%TYPE;
304: l_element_type_id cn_pay_element_inputs.element_type_id%TYPE;
305: l_tab_object_id cn_pay_element_inputs.tab_object_id%TYPE;
306: l_col_object_id cn_pay_element_inputs.col_object_id%TYPE;
307: l_line_number cn_pay_element_inputs.line_number%TYPE;
308: l_start_date cn_pay_element_inputs.start_date%TYPE;
309: l_end_date cn_pay_element_inputs.end_date%TYPE;
310:
311: l_attribute_category cn_pay_element_inputs.attribute_category%TYPE;

Line 308: l_start_date cn_pay_element_inputs.start_date%TYPE;

304: l_element_type_id cn_pay_element_inputs.element_type_id%TYPE;
305: l_tab_object_id cn_pay_element_inputs.tab_object_id%TYPE;
306: l_col_object_id cn_pay_element_inputs.col_object_id%TYPE;
307: l_line_number cn_pay_element_inputs.line_number%TYPE;
308: l_start_date cn_pay_element_inputs.start_date%TYPE;
309: l_end_date cn_pay_element_inputs.end_date%TYPE;
310:
311: l_attribute_category cn_pay_element_inputs.attribute_category%TYPE;
312: l_attribute1 cn_pay_element_inputs.attribute1%TYPE;

Line 309: l_end_date cn_pay_element_inputs.end_date%TYPE;

305: l_tab_object_id cn_pay_element_inputs.tab_object_id%TYPE;
306: l_col_object_id cn_pay_element_inputs.col_object_id%TYPE;
307: l_line_number cn_pay_element_inputs.line_number%TYPE;
308: l_start_date cn_pay_element_inputs.start_date%TYPE;
309: l_end_date cn_pay_element_inputs.end_date%TYPE;
310:
311: l_attribute_category cn_pay_element_inputs.attribute_category%TYPE;
312: l_attribute1 cn_pay_element_inputs.attribute1%TYPE;
313: l_attribute2 cn_pay_element_inputs.attribute2%TYPE;

Line 311: l_attribute_category cn_pay_element_inputs.attribute_category%TYPE;

307: l_line_number cn_pay_element_inputs.line_number%TYPE;
308: l_start_date cn_pay_element_inputs.start_date%TYPE;
309: l_end_date cn_pay_element_inputs.end_date%TYPE;
310:
311: l_attribute_category cn_pay_element_inputs.attribute_category%TYPE;
312: l_attribute1 cn_pay_element_inputs.attribute1%TYPE;
313: l_attribute2 cn_pay_element_inputs.attribute2%TYPE;
314: l_attribute3 cn_pay_element_inputs.attribute3%TYPE;
315: l_attribute4 cn_pay_element_inputs.attribute4%TYPE;

Line 312: l_attribute1 cn_pay_element_inputs.attribute1%TYPE;

308: l_start_date cn_pay_element_inputs.start_date%TYPE;
309: l_end_date cn_pay_element_inputs.end_date%TYPE;
310:
311: l_attribute_category cn_pay_element_inputs.attribute_category%TYPE;
312: l_attribute1 cn_pay_element_inputs.attribute1%TYPE;
313: l_attribute2 cn_pay_element_inputs.attribute2%TYPE;
314: l_attribute3 cn_pay_element_inputs.attribute3%TYPE;
315: l_attribute4 cn_pay_element_inputs.attribute4%TYPE;
316: l_attribute5 cn_pay_element_inputs.attribute5%TYPE;

Line 313: l_attribute2 cn_pay_element_inputs.attribute2%TYPE;

309: l_end_date cn_pay_element_inputs.end_date%TYPE;
310:
311: l_attribute_category cn_pay_element_inputs.attribute_category%TYPE;
312: l_attribute1 cn_pay_element_inputs.attribute1%TYPE;
313: l_attribute2 cn_pay_element_inputs.attribute2%TYPE;
314: l_attribute3 cn_pay_element_inputs.attribute3%TYPE;
315: l_attribute4 cn_pay_element_inputs.attribute4%TYPE;
316: l_attribute5 cn_pay_element_inputs.attribute5%TYPE;
317: l_attribute6 cn_pay_element_inputs.attribute6%TYPE;

Line 314: l_attribute3 cn_pay_element_inputs.attribute3%TYPE;

310:
311: l_attribute_category cn_pay_element_inputs.attribute_category%TYPE;
312: l_attribute1 cn_pay_element_inputs.attribute1%TYPE;
313: l_attribute2 cn_pay_element_inputs.attribute2%TYPE;
314: l_attribute3 cn_pay_element_inputs.attribute3%TYPE;
315: l_attribute4 cn_pay_element_inputs.attribute4%TYPE;
316: l_attribute5 cn_pay_element_inputs.attribute5%TYPE;
317: l_attribute6 cn_pay_element_inputs.attribute6%TYPE;
318: l_attribute7 cn_pay_element_inputs.attribute7%TYPE;

Line 315: l_attribute4 cn_pay_element_inputs.attribute4%TYPE;

311: l_attribute_category cn_pay_element_inputs.attribute_category%TYPE;
312: l_attribute1 cn_pay_element_inputs.attribute1%TYPE;
313: l_attribute2 cn_pay_element_inputs.attribute2%TYPE;
314: l_attribute3 cn_pay_element_inputs.attribute3%TYPE;
315: l_attribute4 cn_pay_element_inputs.attribute4%TYPE;
316: l_attribute5 cn_pay_element_inputs.attribute5%TYPE;
317: l_attribute6 cn_pay_element_inputs.attribute6%TYPE;
318: l_attribute7 cn_pay_element_inputs.attribute7%TYPE;
319: l_attribute8 cn_pay_element_inputs.attribute8%TYPE;

Line 316: l_attribute5 cn_pay_element_inputs.attribute5%TYPE;

312: l_attribute1 cn_pay_element_inputs.attribute1%TYPE;
313: l_attribute2 cn_pay_element_inputs.attribute2%TYPE;
314: l_attribute3 cn_pay_element_inputs.attribute3%TYPE;
315: l_attribute4 cn_pay_element_inputs.attribute4%TYPE;
316: l_attribute5 cn_pay_element_inputs.attribute5%TYPE;
317: l_attribute6 cn_pay_element_inputs.attribute6%TYPE;
318: l_attribute7 cn_pay_element_inputs.attribute7%TYPE;
319: l_attribute8 cn_pay_element_inputs.attribute8%TYPE;
320: l_attribute9 cn_pay_element_inputs.attribute9%TYPE;

Line 317: l_attribute6 cn_pay_element_inputs.attribute6%TYPE;

313: l_attribute2 cn_pay_element_inputs.attribute2%TYPE;
314: l_attribute3 cn_pay_element_inputs.attribute3%TYPE;
315: l_attribute4 cn_pay_element_inputs.attribute4%TYPE;
316: l_attribute5 cn_pay_element_inputs.attribute5%TYPE;
317: l_attribute6 cn_pay_element_inputs.attribute6%TYPE;
318: l_attribute7 cn_pay_element_inputs.attribute7%TYPE;
319: l_attribute8 cn_pay_element_inputs.attribute8%TYPE;
320: l_attribute9 cn_pay_element_inputs.attribute9%TYPE;
321: l_attribute10 cn_pay_element_inputs.attribute10%TYPE;

Line 318: l_attribute7 cn_pay_element_inputs.attribute7%TYPE;

314: l_attribute3 cn_pay_element_inputs.attribute3%TYPE;
315: l_attribute4 cn_pay_element_inputs.attribute4%TYPE;
316: l_attribute5 cn_pay_element_inputs.attribute5%TYPE;
317: l_attribute6 cn_pay_element_inputs.attribute6%TYPE;
318: l_attribute7 cn_pay_element_inputs.attribute7%TYPE;
319: l_attribute8 cn_pay_element_inputs.attribute8%TYPE;
320: l_attribute9 cn_pay_element_inputs.attribute9%TYPE;
321: l_attribute10 cn_pay_element_inputs.attribute10%TYPE;
322: l_attribute11 cn_pay_element_inputs.attribute11%TYPE;

Line 319: l_attribute8 cn_pay_element_inputs.attribute8%TYPE;

315: l_attribute4 cn_pay_element_inputs.attribute4%TYPE;
316: l_attribute5 cn_pay_element_inputs.attribute5%TYPE;
317: l_attribute6 cn_pay_element_inputs.attribute6%TYPE;
318: l_attribute7 cn_pay_element_inputs.attribute7%TYPE;
319: l_attribute8 cn_pay_element_inputs.attribute8%TYPE;
320: l_attribute9 cn_pay_element_inputs.attribute9%TYPE;
321: l_attribute10 cn_pay_element_inputs.attribute10%TYPE;
322: l_attribute11 cn_pay_element_inputs.attribute11%TYPE;
323: l_attribute12 cn_pay_element_inputs.attribute12%TYPE;

Line 320: l_attribute9 cn_pay_element_inputs.attribute9%TYPE;

316: l_attribute5 cn_pay_element_inputs.attribute5%TYPE;
317: l_attribute6 cn_pay_element_inputs.attribute6%TYPE;
318: l_attribute7 cn_pay_element_inputs.attribute7%TYPE;
319: l_attribute8 cn_pay_element_inputs.attribute8%TYPE;
320: l_attribute9 cn_pay_element_inputs.attribute9%TYPE;
321: l_attribute10 cn_pay_element_inputs.attribute10%TYPE;
322: l_attribute11 cn_pay_element_inputs.attribute11%TYPE;
323: l_attribute12 cn_pay_element_inputs.attribute12%TYPE;
324: l_attribute13 cn_pay_element_inputs.attribute13%TYPE;

Line 321: l_attribute10 cn_pay_element_inputs.attribute10%TYPE;

317: l_attribute6 cn_pay_element_inputs.attribute6%TYPE;
318: l_attribute7 cn_pay_element_inputs.attribute7%TYPE;
319: l_attribute8 cn_pay_element_inputs.attribute8%TYPE;
320: l_attribute9 cn_pay_element_inputs.attribute9%TYPE;
321: l_attribute10 cn_pay_element_inputs.attribute10%TYPE;
322: l_attribute11 cn_pay_element_inputs.attribute11%TYPE;
323: l_attribute12 cn_pay_element_inputs.attribute12%TYPE;
324: l_attribute13 cn_pay_element_inputs.attribute13%TYPE;
325: l_attribute14 cn_pay_element_inputs.attribute14%TYPE;

Line 322: l_attribute11 cn_pay_element_inputs.attribute11%TYPE;

318: l_attribute7 cn_pay_element_inputs.attribute7%TYPE;
319: l_attribute8 cn_pay_element_inputs.attribute8%TYPE;
320: l_attribute9 cn_pay_element_inputs.attribute9%TYPE;
321: l_attribute10 cn_pay_element_inputs.attribute10%TYPE;
322: l_attribute11 cn_pay_element_inputs.attribute11%TYPE;
323: l_attribute12 cn_pay_element_inputs.attribute12%TYPE;
324: l_attribute13 cn_pay_element_inputs.attribute13%TYPE;
325: l_attribute14 cn_pay_element_inputs.attribute14%TYPE;
326: l_attribute15 cn_pay_element_inputs.attribute15%TYPE;

Line 323: l_attribute12 cn_pay_element_inputs.attribute12%TYPE;

319: l_attribute8 cn_pay_element_inputs.attribute8%TYPE;
320: l_attribute9 cn_pay_element_inputs.attribute9%TYPE;
321: l_attribute10 cn_pay_element_inputs.attribute10%TYPE;
322: l_attribute11 cn_pay_element_inputs.attribute11%TYPE;
323: l_attribute12 cn_pay_element_inputs.attribute12%TYPE;
324: l_attribute13 cn_pay_element_inputs.attribute13%TYPE;
325: l_attribute14 cn_pay_element_inputs.attribute14%TYPE;
326: l_attribute15 cn_pay_element_inputs.attribute15%TYPE;
327:

Line 324: l_attribute13 cn_pay_element_inputs.attribute13%TYPE;

320: l_attribute9 cn_pay_element_inputs.attribute9%TYPE;
321: l_attribute10 cn_pay_element_inputs.attribute10%TYPE;
322: l_attribute11 cn_pay_element_inputs.attribute11%TYPE;
323: l_attribute12 cn_pay_element_inputs.attribute12%TYPE;
324: l_attribute13 cn_pay_element_inputs.attribute13%TYPE;
325: l_attribute14 cn_pay_element_inputs.attribute14%TYPE;
326: l_attribute15 cn_pay_element_inputs.attribute15%TYPE;
327:
328: CURSOR C IS

Line 325: l_attribute14 cn_pay_element_inputs.attribute14%TYPE;

321: l_attribute10 cn_pay_element_inputs.attribute10%TYPE;
322: l_attribute11 cn_pay_element_inputs.attribute11%TYPE;
323: l_attribute12 cn_pay_element_inputs.attribute12%TYPE;
324: l_attribute13 cn_pay_element_inputs.attribute13%TYPE;
325: l_attribute14 cn_pay_element_inputs.attribute14%TYPE;
326: l_attribute15 cn_pay_element_inputs.attribute15%TYPE;
327:
328: CURSOR C IS
329: SELECT *

Line 326: l_attribute15 cn_pay_element_inputs.attribute15%TYPE;

322: l_attribute11 cn_pay_element_inputs.attribute11%TYPE;
323: l_attribute12 cn_pay_element_inputs.attribute12%TYPE;
324: l_attribute13 cn_pay_element_inputs.attribute13%TYPE;
325: l_attribute14 cn_pay_element_inputs.attribute14%TYPE;
326: l_attribute15 cn_pay_element_inputs.attribute15%TYPE;
327:
328: CURSOR C IS
329: SELECT *
330: FROM cn_pay_element_inputs

Line 330: FROM cn_pay_element_inputs

326: l_attribute15 cn_pay_element_inputs.attribute15%TYPE;
327:
328: CURSOR C IS
329: SELECT *
330: FROM cn_pay_element_inputs
331: WHERE pay_element_input_id = p_pay_element_input_id
332: FOR UPDATE of pay_element_input_id NOWAIT;
333: oldrow C%ROWTYPE;
334:

Line 440: UPDATE cn_pay_element_inputs

436: l_attribute14,
437: l_attribute15
438: FROM dual;
439:
440: UPDATE cn_pay_element_inputs
441: SET
442: element_input_id = l_element_input_id,
443: quota_pay_element_id = l_quota_pay_element_id,
444: element_type_id = l_element_type_id,

Line 487: DELETE FROM cn_pay_element_inputs

483:
484: PROCEDURE Delete_row( p_pay_element_input_id NUMBER ) IS
485: BEGIN
486:
487: DELETE FROM cn_pay_element_inputs
488: WHERE pay_element_input_id = p_pay_element_input_id ;
489: IF (SQL%NOTFOUND) THEN
490: RAISE NO_DATA_FOUND;
491: END IF;

Line 495: END CN_PAY_ELEMENT_INPUTS_PKG;

491: END IF;
492:
493: END Delete_row;
494:
495: END CN_PAY_ELEMENT_INPUTS_PKG;