[Home] [Help]
PACKAGE: APPS.CN_QUOTA_PAY_ELEMENTS_PKG
Source
1 PACKAGE CN_QUOTA_PAY_ELEMENTS_PKG AUTHID CURRENT_USER AS
2 /* $Header: cntqpes.pls 115.2 2002/02/05 00:26:06 pkm ship $ */
3 --
4 -- Package Name
5 -- CN_QUOTA_PAY_ELEMENTS_PKG
6 -- Purpose
7 -- Table Handler for CN_QUOTA_PAY_ELEMENTS
8 --
9 -- History
10 -- 02-feb-01 Kumar Sivasankaran Created
11
12 --==========================================================================
13 -- Procedure Name
14 -- Insert_row
15 -- Purpose
16 -- Main insert procedure
17 --==========================================================================
18
19 PROCEDURE insert_row
20 (x_quota_pay_element_id IN OUT NUMBER
21 ,p_quota_id IN NUMBER
22 ,p_pay_element_type_id IN NUMBER
23 ,p_status VARCHAR2 := NULL
24 ,p_start_date DATE
25 ,p_end_date DATE
26 ,p_attribute_category VARCHAR2 := NULL
27 ,p_attribute1 VARCHAR2 := NULL
28 ,p_attribute2 VARCHAR2 := NULL
29 ,p_attribute3 VARCHAR2 := NULL
30 ,p_attribute4 VARCHAR2 := NULL
31 ,p_attribute5 VARCHAR2 := NULL
32 ,p_attribute6 VARCHAR2 := NULL
33 ,p_attribute7 VARCHAR2 := NULL
34 ,p_attribute8 VARCHAR2 := NULL
35 ,p_attribute9 VARCHAR2 := NULL
36 ,p_attribute10 VARCHAR2 := NULL
37 ,p_attribute11 VARCHAR2 := NULL
38 ,p_attribute12 VARCHAR2 := NULL
39 ,p_attribute13 VARCHAR2 := NULL
40 ,p_attribute14 VARCHAR2 := NULL
41 ,p_attribute15 VARCHAR2 := NULL
42 ,p_Created_By NUMBER
43 ,p_Creation_Date DATE
44 ,p_Last_Updated_By NUMBER
45 ,p_Last_Update_Date DATE
46 ,p_Last_Update_Login NUMBER
47 );
48
49 -- /*-------------------------------------------------------------------------*
50 -- Procedure Name
51 -- Lock_row
52 -- Purpose
53 -- Lock db row after form record is changed
54 -- Notes
55 -- *-------------------------------------------------------------------------*/
56
57 PROCEDURE lock_row
58 (p_quota_pay_element_id IN NUMBER
59 ,p_quota_id IN NUMBER
60 ,p_pay_element_type_id IN NUMBER
61 ,p_status VARCHAR2 := NULL
62 ,p_start_date DATE
63 ,p_end_date DATE
64 ,p_attribute_category VARCHAR2 := NULL
65 ,p_attribute1 VARCHAR2 := NULL
66 ,p_attribute2 VARCHAR2 := NULL
67 ,p_attribute3 VARCHAR2 := NULL
68 ,p_attribute4 VARCHAR2 := NULL
69 ,p_attribute5 VARCHAR2 := NULL
70 ,p_attribute6 VARCHAR2 := NULL
71 ,p_attribute7 VARCHAR2 := NULL
72 ,p_attribute8 VARCHAR2 := NULL
73 ,p_attribute9 VARCHAR2 := NULL
74 ,p_attribute10 VARCHAR2 := NULL
75 ,p_attribute11 VARCHAR2 := NULL
76 ,p_attribute12 VARCHAR2 := NULL
77 ,p_attribute13 VARCHAR2 := NULL
78 ,p_attribute14 VARCHAR2 := NULL
79 ,p_attribute15 VARCHAR2 := NULL
80 );
81
82 -- /*-------------------------------------------------------------------------*
83 -- Procedure Name
84 -- Update Record
85 -- Purpose
86 -- To Update the Quota Pay Element Map
87 --
88 -- *-------------------------------------------------------------------------*/
89 PROCEDURE update_row (
90 p_quota_pay_element_id NUMBER
91 ,p_quota_id NUMBER := fnd_api.g_miss_num
92 ,p_pay_element_type_id NUMBER := fnd_api.g_miss_num
93 ,p_status VARCHAR2 := fnd_api.g_miss_char
94 ,p_start_date DATE := fnd_api.g_miss_date
95 ,p_end_date DATE := fnd_api.g_miss_date
96 ,p_attribute_category VARCHAR2 := fnd_api.g_miss_char
97 ,p_attribute1 VARCHAR2 := fnd_api.g_miss_char
98 ,p_attribute2 VARCHAR2 := fnd_api.g_miss_char
99 ,p_attribute3 VARCHAR2 := fnd_api.g_miss_char
100 ,p_attribute4 VARCHAR2 := fnd_api.g_miss_char
101 ,p_attribute5 VARCHAR2 := fnd_api.g_miss_char
102 ,p_attribute6 VARCHAR2 := fnd_api.g_miss_char
103 ,p_attribute7 VARCHAR2 := fnd_api.g_miss_char
104 ,p_attribute8 VARCHAR2 := fnd_api.g_miss_char
105 ,p_attribute9 VARCHAR2 := fnd_api.g_miss_char
106 ,p_attribute10 VARCHAR2 := fnd_api.g_miss_char
107 ,p_attribute11 VARCHAR2 := fnd_api.g_miss_char
108 ,p_attribute12 VARCHAR2 := fnd_api.g_miss_char
109 ,p_attribute13 VARCHAR2 := fnd_api.g_miss_char
110 ,p_attribute14 VARCHAR2 := fnd_api.g_miss_char
111 ,p_attribute15 VARCHAR2 := fnd_api.g_miss_char
112 ,p_Last_Updated_By NUMBER
113 ,p_Last_Update_Date DATE
114 ,p_Last_Update_Login NUMBER );
115
116 --/*-------------------------------------------------------------------------*
117 -- Procedure Name
118 -- Delete_row
119 -- Purpose
120 -- Delete the Quota Pay Element
121 --*-------------------------------------------------------------------------*/
122 PROCEDURE Delete_row( p_quota_pay_element_id NUMBER );
123
124 END CN_QUOTA_PAY_ELEMENTS_PKG;