PACKAGE BODY: APPS.OZF_SD_CUSTOMER_PKG

Source

1 PACKAGE BODY OZF_SD_CUSTOMER_PKG AS
2 /* $Header: ozftcdtb.pls 120.1 2008/01/03 06:21:48 bkunjan noship $ */
3 
4 G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_SD_CUSTOMER_PKG';
5 G_FILE_NAME CONSTANT VARCHAR2(15) := 'ozftcdtb.pls';
6 
7 PROCEDURE Insert_Row(
8     p_request_customer_id        NUMBER,
9     p_request_header_id      	 NUMBER,
10     p_cust_account_id        	 NUMBER,
11     p_party_id               	 NUMBER,
12     p_site_use_id            	 NUMBER,
13     p_cust_usage_code	         VARCHAR2,
14     p_security_group_id      	 NUMBER,
15     p_creation_date          	 DATE,
16     p_created_by             	 NUMBER,
17     p_last_update_date       	 DATE,
18     p_last_updated_by        	 NUMBER,
19     p_last_update_login      	 NUMBER,
20     p_object_version_number  	 NUMBER,
21     p_attribute_category     	 VARCHAR2,
22     p_attribute1             	 VARCHAR2,
23     p_attribute2             	 VARCHAR2,
24     p_attribute3             	 VARCHAR2,
25     p_attribute4             	 VARCHAR2,
26     p_attribute5             	 VARCHAR2,
27     p_attribute6             	 VARCHAR2,
28     p_attribute7             	 VARCHAR2,
29     p_attribute8             	 VARCHAR2,
30     p_attribute9             	 VARCHAR2,
31     p_attribute10            	 VARCHAR2,
32     p_attribute11            	 VARCHAR2,
33     p_attribute12            	 VARCHAR2,
34     p_attribute13            	 VARCHAR2,
35     p_attribute14            	 VARCHAR2,
36     p_attribute15		 VARCHAR2,
37     p_end_customer_flag          VARCHAR2)
38 IS
39 BEGIN
40 INSERT INTO OZF_SD_CUSTOMER_DETAILS(
41         request_customer_id,
42         request_header_id,
43         cust_account_id,
44         party_id,
45         site_use_id,
46         cust_usage_code,
47         security_group_id,
48         creation_date,
49         created_by,
50         last_update_date,
51         last_updated_by,
52         last_update_login,
53         object_version_number,
54         attribute_category,
55         attribute1,
56         attribute2,
57         attribute3,
58         attribute4,
59         attribute5,
60         attribute6,
61         attribute7,
62         attribute8,
63         attribute9,
64         attribute10,
65         attribute11,
66         attribute12,
67         attribute13,
68         attribute14,
69         attribute15,
70         end_customer_flag)
71 VALUES(
72         p_request_customer_id,
73         p_request_header_id,
74         p_cust_account_id,
75         p_party_id,
76         p_site_use_id,
77         p_cust_usage_code,
78         p_security_group_id,
79         p_creation_date,
80         p_created_by,
81         p_last_update_date,
82         p_last_updated_by,
83         p_last_update_login,
84         p_object_version_number,
85         p_attribute_category,
86         p_attribute1,
87         p_attribute2,
88         p_attribute3,
89         p_attribute4,
90         p_attribute5,
91         p_attribute6,
92         p_attribute7,
93         p_attribute8,
94         p_attribute9,
95         p_attribute10,
96         p_attribute11,
97         p_attribute12,
98         p_attribute13,
99         p_attribute14,
100         p_attribute15,
101         p_end_customer_flag);
102 END Insert_Row;
103 
104 PROCEDURE Update_Row(
105     p_request_customer_id     	 NUMBER,
106     p_request_header_id      	 NUMBER,
107     p_cust_account_id        	 NUMBER,
108     p_party_id               	 NUMBER,
109     p_site_use_id            	 NUMBER,
110     p_cust_usage_code	         VARCHAR2,
111     p_security_group_id      	 NUMBER,
112     p_last_update_date       	 DATE,
113     p_last_updated_by        	 NUMBER,
114     p_last_update_login      	 NUMBER,
115     p_object_version_number  	 NUMBER,
116     p_attribute_category     	 VARCHAR2,
117     p_attribute1             	 VARCHAR2,
118     p_attribute2             	 VARCHAR2,
119     p_attribute3             	 VARCHAR2,
120     p_attribute4             	 VARCHAR2,
121     p_attribute5             	 VARCHAR2,
122     p_attribute6             	 VARCHAR2,
123     p_attribute7             	 VARCHAR2,
124     p_attribute8             	 VARCHAR2,
125     p_attribute9             	 VARCHAR2,
126     p_attribute10            	 VARCHAR2,
127     p_attribute11            	 VARCHAR2,
128     p_attribute12            	 VARCHAR2,
129     p_attribute13            	 VARCHAR2,
130     p_attribute14            	 VARCHAR2,
131     p_attribute15		 VARCHAR2,
132     p_end_customer_flag          VARCHAR2)
133 IS
134 BEGIN
135 
136 UPDATE OZF_SD_CUSTOMER_DETAILS
137 SET request_header_id      	=	p_request_header_id,
138     cust_account_id        	=	p_cust_account_id,
139     party_id               	=	p_party_id,
140     site_use_id            	=	p_site_use_id,
141     cust_usage_code	        =	p_cust_usage_code,
142     security_group_id      	=	p_security_group_id,
143     last_update_date       	=	p_last_update_date,
144     last_updated_by        	=	p_last_updated_by,
145     last_update_login      	=	p_last_update_login,
146     object_version_number  	=	p_object_version_number,
147     attribute_category     	=	p_attribute_category,
148     attribute1             	=	p_attribute1,
149     attribute2             	=	p_attribute2,
150     attribute3             	=	p_attribute3,
151     attribute4             	=	p_attribute4,
152     attribute5             	=	p_attribute5,
153     attribute6             	=	p_attribute6,
154     attribute7             	=	p_attribute7,
155     attribute8             	=	p_attribute8,
156     attribute9             	=	p_attribute9,
157     attribute10            	=	p_attribute10,
158     attribute11            	=	p_attribute11,
159     attribute12            	=	p_attribute12,
160     attribute13            	=	p_attribute13,
161     attribute14            	=	p_attribute14,
162     attribute15			=	p_attribute15,
163     end_customer_flag		=   p_end_customer_flag
164 WHERE request_customer_id=p_request_customer_id;
165 
166 END Update_Row;
167 END OZF_SD_CUSTOMER_PKG;