[Home] [Help]
PACKAGE: APPS.AP_DUPLICATE_VENDORS_PKG
Source
1 PACKAGE AP_DUPLICATE_VENDORS_PKG as
2 /* $Header: apiduves.pls 120.4 2004/10/28 00:01:59 pjena noship $ */
3
4
5 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
6 X_Entry_Id NUMBER DEFAULT NULL,
7 X_Vendor_Id NUMBER DEFAULT NULL,
8 X_Duplicate_Vendor_Id NUMBER DEFAULT NULL,
9 X_Vendor_Site_Id NUMBER DEFAULT NULL,
10 X_Duplicate_Vendor_Site_Id NUMBER DEFAULT NULL,
11 X_Number_Unpaid_Invoices NUMBER DEFAULT NULL,
12 X_Number_Paid_Invoices NUMBER DEFAULT NULL,
13 X_Number_Po_Headers_Changed NUMBER DEFAULT NULL,
14 X_Amount_Unpaid_Invoices NUMBER DEFAULT NULL,
15 X_Amount_Paid_Invoices NUMBER DEFAULT NULL,
16 X_Last_Update_Date DATE DEFAULT NULL,
17 X_Last_Updated_By NUMBER DEFAULT NULL,
18 X_Process_Flag VARCHAR2 DEFAULT NULL,
19 X_Process VARCHAR2 DEFAULT NULL,
20 X_Keep_Site_Flag VARCHAR2 DEFAULT NULL,
21 X_Paid_Invoices_Flag VARCHAR2 DEFAULT NULL,
22 X_Last_Update_Login NUMBER DEFAULT NULL,
23 X_Creation_Date DATE DEFAULT NULL,
24 X_Created_By NUMBER DEFAULT NULL,
25 X_Org_Id NUMBER,
26 X_calling_sequence VARCHAR2
27 );
28
29 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
30 X_Entry_Id NUMBER DEFAULT NULL,
31 X_Vendor_Id NUMBER DEFAULT NULL,
32 X_Duplicate_Vendor_Id NUMBER DEFAULT NULL,
33 X_Vendor_Site_Id NUMBER DEFAULT NULL,
34 X_Duplicate_Vendor_Site_Id NUMBER DEFAULT NULL,
35 X_Number_Unpaid_Invoices NUMBER DEFAULT NULL,
36 X_Number_Paid_Invoices NUMBER DEFAULT NULL,
37 X_Number_Po_Headers_Changed NUMBER DEFAULT NULL,
38 X_Amount_Unpaid_Invoices NUMBER DEFAULT NULL,
39 X_Amount_Paid_Invoices NUMBER DEFAULT NULL,
40 X_Process_Flag VARCHAR2 DEFAULT NULL,
41 X_Process VARCHAR2 DEFAULT NULL,
42 X_Keep_Site_Flag VARCHAR2 DEFAULT NULL,
43 X_Paid_Invoices_Flag VARCHAR2 DEFAULT NULL,
44 X_Org_Id NUMBER,
45 X_calling_sequence VARCHAR2
46 );
47
48
49
50 PROCEDURE Update_Row(X_Rowid VARCHAR2,
51 X_Entry_Id NUMBER DEFAULT NULL,
52 X_Vendor_Id NUMBER DEFAULT NULL,
53 X_Duplicate_Vendor_Id NUMBER DEFAULT NULL,
54 X_Vendor_Site_Id NUMBER DEFAULT NULL,
55 X_Duplicate_Vendor_Site_Id NUMBER DEFAULT NULL,
56 X_Number_Unpaid_Invoices NUMBER DEFAULT NULL,
57 X_Number_Paid_Invoices NUMBER DEFAULT NULL,
58 X_Number_Po_Headers_Changed NUMBER DEFAULT NULL,
59 X_Amount_Unpaid_Invoices NUMBER DEFAULT NULL,
60 X_Amount_Paid_Invoices NUMBER DEFAULT NULL,
61 X_Last_Update_Date DATE DEFAULT NULL,
62 X_Last_Updated_By NUMBER DEFAULT NULL,
63 X_Process_Flag VARCHAR2 DEFAULT NULL,
64 X_Process VARCHAR2 DEFAULT NULL,
65 X_Keep_Site_Flag VARCHAR2 DEFAULT NULL,
66 X_Paid_Invoices_Flag VARCHAR2 DEFAULT NULL,
67 X_Last_Update_Login NUMBER DEFAULT NULL,
68 X_Org_Id NUMBER,
69 X_calling_sequence VARCHAR2
70 );
71 PROCEDURE Delete_Row(X_Rowid VARCHAR2,
72 X_calling_sequence VARCHAR2
73 );
74
75 END AP_DUPLICATE_VENDORS_PKG;