1 package pa_cc_org_relationships_pkg AUTHID CURRENT_USER as
2 /* $Header: PAXCCOUS.pls 120.2 2005/08/08 12:46:02 sbharath noship $ */
3
4 procedure insert_row ( x_rowid IN OUT NOCOPY Varchar2,
5 x_prvdr_org_id IN Number,
6 x_recvr_org_id IN Number,
7 x_Prvdr_allow_cc_flag IN Varchar2,
8 x_Cross_charge_code IN Varchar2,
9 x_prvdr_project_id IN Number ,
10 x_invoice_grouping_code IN Varchar2,
11 x_last_update_date IN Date,
12 x_last_updated_by IN Number,
13 x_creation_date IN Date,
14 x_created_by IN Number,
15 x_last_update_login IN Number ,
16 x_vendor_site_id IN Number ,
17 x_ap_inv_exp_type IN Varchar2 ,
18 x_ap_inv_exp_organization_id IN Number ,
19 x_attribute_category IN Varchar2 ,
20 x_attribute1 IN Varchar2 ,
21 x_attribute2 IN Varchar2 ,
22 x_attribute3 IN Varchar2 ,
23 x_attribute4 IN Varchar2 ,
24 x_attribute5 IN Varchar2 ,
25 x_attribute6 IN Varchar2 ,
26 x_attribute7 IN Varchar2 ,
27 x_attribute8 IN Varchar2 ,
28 x_attribute9 IN Varchar2 ,
29 x_attribute10 IN Varchar2 ,
30 x_attribute11 IN Varchar2 ,
31 x_attribute12 IN Varchar2 ,
32 x_attribute13 IN Varchar2 ,
33 x_attribute14 IN Varchar2 ,
34 x_attribute15 IN Varchar2 ) ;
35
36 procedure update_row ( x_rowid IN Varchar2,
37 x_prvdr_org_id IN Number,
38 x_recvr_org_id IN Number,
39 x_Prvdr_allow_cc_flag IN Varchar2,
40 x_Cross_charge_code IN Varchar2,
41 x_prvdr_project_id IN Number ,
42 x_invoice_grouping_code IN Varchar2,
43 x_last_update_date IN Date,
44 x_last_updated_by IN Number,
45 x_creation_date IN Date,
46 x_created_by IN Number,
47 x_last_update_login IN Number ,
48 x_vendor_site_id IN Number ,
49 x_ap_inv_exp_type IN Varchar2 ,
50 x_ap_inv_exp_organization_id IN Number ,
51 x_attribute_category IN Varchar2 ,
52 x_attribute1 IN Varchar2 ,
53 x_attribute2 IN Varchar2 ,
54 x_attribute3 IN Varchar2 ,
55 x_attribute4 IN Varchar2 ,
56 x_attribute5 IN Varchar2 ,
57 x_attribute6 IN Varchar2 ,
58 x_attribute7 IN Varchar2 ,
59 x_attribute8 IN Varchar2 ,
60 x_attribute9 IN Varchar2 ,
61 x_attribute10 IN Varchar2 ,
62 x_attribute11 IN Varchar2 ,
63 x_attribute12 IN Varchar2 ,
64 x_attribute13 IN Varchar2 ,
65 x_attribute14 IN Varchar2 ,
66 x_attribute15 IN Varchar2 ) ;
67 END pa_cc_org_relationships_pkg;