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