DBA Data[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;