[Home] [Help]
PACKAGE: APPS.CSC_CUSTOMERS_PKG
Source
1 package csc_customers_pkg AUTHID CURRENT_USER as
2 /*$Header: csctcccs.pls 115.4 2004/04/27 10:24:51 vshastry ship $*/
3 procedure insert_row(
4 x_rowid IN OUT NOCOPY VARCHAR2,
5 x_party_id NUMBER,
6 x_cust_account_id NUMBER,
7 x_last_update_date DATE,
8 x_last_updated_by NUMBER,
9 x_last_update_login NUMBER,
10 x_creation_date DATE,
11 x_created_by NUMBER,
12 x_sys_det_critical_flag VARCHAR2,
13 x_override_flag VARCHAR2,
14 x_overridden_critical_flag VARCHAR2,
15 x_override_reason_code VARCHAR2,
16 x_attribute1 VARCHAR2 DEFAULT NULL,
17 x_attribute2 VARCHAR2 DEFAULT NULL,
18 x_attribute3 VARCHAR2 DEFAULT NULL,
19 x_attribute4 VARCHAR2 DEFAULT NULL,
20 x_attribute5 VARCHAR2 DEFAULT NULL,
21 x_attribute6 VARCHAR2 DEFAULT NULL,
22 x_attribute7 VARCHAR2 DEFAULT NULL,
23 x_attribute8 VARCHAR2 DEFAULT NULL,
24 x_attribute9 VARCHAR2 DEFAULT NULL,
25 x_attribute10 VARCHAR2 DEFAULT NULL,
26 x_attribute11 VARCHAR2 DEFAULT NULL,
27 x_attribute12 VARCHAR2 DEFAULT NULL,
28 x_attribute13 VARCHAR2 DEFAULT NULL,
29 x_attribute14 VARCHAR2 DEFAULT NULL,
30 x_attribute15 VARCHAR2 DEFAULT NULL,
31 p_party_status VARCHAR2 DEFAULT NULL,
32 p_request_id NUMBER DEFAULT NULL,
33 p_program_application_id NUMBER DEFAULT NULL,
34 p_program_id NUMBER DEFAULT NULL,
35 p_program_update_date DATE DEFAULT NULL );
36
37 procedure lock_row(
38 x_rowid VARCHAR2,
39 x_party_id NUMBER,
40 x_cust_account_id NUMBER,
41 x_last_update_date DATE,
42 x_last_updated_by NUMBER,
43 x_last_update_login NUMBER,
44 x_creation_date DATE,
45 x_created_by NUMBER,
46 x_override_flag VARCHAR2,
47 x_overridden_critical_flag VARCHAR2,
48 x_override_reason_code VARCHAR2);
49
50
51 procedure update_row(
52 x_rowid VARCHAR2,
53 x_party_id NUMBER,
54 x_cust_account_id NUMBER,
55 x_last_update_date DATE,
56 x_last_updated_by NUMBER,
57 x_last_update_login NUMBER,
58 x_creation_date DATE,
59 x_created_by NUMBER,
60 x_sys_det_critical_flag VARCHAR2,
61 x_override_flag VARCHAR2,
62 x_overridden_critical_flag VARCHAR2,
63 x_override_reason_code VARCHAR2,
64 x_attribute1 VARCHAR2 DEFAULT NULL,
65 x_attribute2 VARCHAR2 DEFAULT NULL,
66 x_attribute3 VARCHAR2 DEFAULT NULL,
67 x_attribute4 VARCHAR2 DEFAULT NULL,
68 x_attribute5 VARCHAR2 DEFAULT NULL,
69 x_attribute6 VARCHAR2 DEFAULT NULL,
70 x_attribute7 VARCHAR2 DEFAULT NULL,
71 x_attribute8 VARCHAR2 DEFAULT NULL,
72 x_attribute9 VARCHAR2 DEFAULT NULL,
73 x_attribute10 VARCHAR2 DEFAULT NULL,
74 x_attribute11 VARCHAR2 DEFAULT NULL,
75 x_attribute12 VARCHAR2 DEFAULT NULL,
76 x_attribute13 VARCHAR2 DEFAULT NULL,
77 x_attribute14 VARCHAR2 DEFAULT NULL,
78 x_attribute15 VARCHAR2 DEFAULT NULL,
79 p_party_status VARCHAR2 DEFAULT NULL,
80 p_request_id NUMBER DEFAULT NULL,
81 p_program_application_id NUMBER DEFAULT NULL,
82 p_program_id NUMBER DEFAULT NULL,
83 p_program_update_date DATE DEFAULT NULL);
84
85 end csc_customers_pkg;