PACKAGE: APPS.OZF_SD_CUSTOMER_PKG

Source

1 PACKAGE OZF_SD_CUSTOMER_PKG AUTHID CURRENT_USER AS
2 /* $Header: ozftcdts.pls 120.4 2011/08/08 09:33:33 ninarasi ship $ */
3 
4 PROCEDURE Insert_Row(
5     p_request_customer_id        NUMBER,
6     p_request_header_id      	 NUMBER,
7     p_cust_account_id        	 NUMBER,
8     p_party_id               	 NUMBER,
9     p_site_use_id            	 NUMBER,
10     p_cust_usage_code	         VARCHAR2,
11     p_security_group_id      	 NUMBER,
12     p_creation_date          	 DATE,
13     p_created_by             	 NUMBER,
14     p_last_update_date       	 DATE,
15     p_last_updated_by        	 NUMBER,
16     p_last_update_login      	 NUMBER,
17     p_object_version_number  	 NUMBER,
18     p_attribute_category     	 VARCHAR2,
19     p_attribute1             	 VARCHAR2,
20     p_attribute2             	 VARCHAR2,
21     p_attribute3             	 VARCHAR2,
22     p_attribute4             	 VARCHAR2,
23     p_attribute5             	 VARCHAR2,
24     p_attribute6             	 VARCHAR2,
25     p_attribute7             	 VARCHAR2,
26     p_attribute8             	 VARCHAR2,
27     p_attribute9             	 VARCHAR2,
28     p_attribute10            	 VARCHAR2,
29     p_attribute11            	 VARCHAR2,
30     p_attribute12            	 VARCHAR2,
31     p_attribute13            	 VARCHAR2,
32     p_attribute14            	 VARCHAR2,
33     p_attribute15		         VARCHAR2,
34     p_end_customer_flag          VARCHAR2,
35 	p_cust_usage_value			 VARCHAR2);
36 
37 PROCEDURE Update_Row(
38     p_request_customer_id        NUMBER,
39     p_request_header_id      	 NUMBER,
40     p_cust_account_id        	 NUMBER,
41     p_party_id               	 NUMBER,
42     p_site_use_id            	 NUMBER,
43     p_cust_usage_code	         VARCHAR2,
44     p_security_group_id      	 NUMBER,
45     p_last_update_date       	 DATE,
46     p_last_updated_by        	 NUMBER,
47     p_last_update_login      	 NUMBER,
48     p_object_version_number  	 NUMBER,
49     p_attribute_category     	 VARCHAR2,
50     p_attribute1             	 VARCHAR2,
51     p_attribute2             	 VARCHAR2,
52     p_attribute3             	 VARCHAR2,
53     p_attribute4             	 VARCHAR2,
54     p_attribute5             	 VARCHAR2,
55     p_attribute6             	 VARCHAR2,
56     p_attribute7             	 VARCHAR2,
57     p_attribute8             	 VARCHAR2,
58     p_attribute9             	 VARCHAR2,
59     p_attribute10            	 VARCHAR2,
60     p_attribute11            	 VARCHAR2,
61     p_attribute12            	 VARCHAR2,
62     p_attribute13            	 VARCHAR2,
63     p_attribute14            	 VARCHAR2,
64     p_attribute15		  		 VARCHAR2,
65     p_end_customer_flag          VARCHAR2,
66 	p_cust_usage_value			 VARCHAR2);
67 
68 --ninarasi fix for bug 12656359
69 PROCEDURE Delete_Row(
70     p_request_customer_id     	 NUMBER,
71     p_request_header_id      	 NUMBER
72    );
73 
74 END OZF_SD_CUSTOMER_PKG;