[Home] [Help]
PACKAGE: APPS.ARI_REG_VERIFY_PKG
Source
1 PACKAGE ARI_REG_VERIFY_PKG AUTHID CURRENT_USER AS
2 /* $Header: ARIREGPS.pls 120.2.12020000.2 2012/07/22 13:25:40 rsinthre ship $ */
3
4 -----------------------------------------------------------------------
5 PROCEDURE Insert_Row(
6 x_Rowid IN OUT NOCOPY VARCHAR2,
7 x_Registration_Id IN OUT NOCOPY NUMBER,
8 x_Application_Code VARCHAR2,
9 x_User_Email_Addr VARCHAR2,
10 x_Access_Domain_Search_Type VARCHAR2,
11 x_Access_Domain_Search_Number VARCHAR2,
12 x_Access_Domain_Type VARCHAR2,
13 x_Access_Domain_Cust_Id NUMBER,
14 x_Access_Domain_Billto_Id NUMBER,
15 x_Access_Domain_Number VARCHAR2,
16 x_Cust_Acct_Type VARCHAR2,
17 x_Status_Lookup_Code VARCHAR2,
18 x_Missed_Cust_Question_Count NUMBER DEFAULT 0,
19 x_Missed_Billto_Question_Count NUMBER DEFAULT 0,
20 x_Company_Id NUMBER,
21 x_Person_Id NUMBER,
22 x_Last_Update_Date DATE,
23 x_Last_Updated_By NUMBER,
24 x_Creation_Date DATE,
25 x_Created_By NUMBER,
26 x_Last_Update_Login NUMBER,
27 x_Registration_Type VARCHAR2);
28 ------------------------------------------------------------------------
29
30 ----------------------------------------------------
31 PROCEDURE Delete_Row(x_registration_id NUMBER);
32 ----------------------------------------------------
33
34 ----------------------------------------------------------------------------
35 PROCEDURE Update_Row(x_Registration_id NUMBER,
36 x_Application_Code VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
37 x_User_Email_Addr VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
38 x_Access_Domain_Type VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
39 x_Access_Domain_Number VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
40 x_Access_Domain_Cust_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
41 x_Access_Domain_Billto_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
42 x_Cust_Acct_Type VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
43 x_Status_Lookup_Code VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
44 x_Missed_Cust_Question_Count NUMBER DEFAULT FND_API.G_MISS_NUM,
45 x_Missed_Billto_Question_Count NUMBER DEFAULT FND_API.G_MISS_NUM,
46 x_Company_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
47 x_Person_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
48 x_Last_Update_Date DATE DEFAULT FND_API.G_MISS_DATE,
49 x_Last_Updated_By NUMBER DEFAULT FND_API.G_MISS_NUM,
50 x_Creation_Date DATE DEFAULT FND_API.G_MISS_DATE,
51 x_Created_By NUMBER DEFAULT FND_API.G_MISS_NUM,
52 x_Last_Update_Login NUMBER DEFAULT FND_API.G_MISS_NUM,
53 x_Registration_Type VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
54 x_Wf_Item_Key VARCHAR2 DEFAULT FND_API.G_MISS_CHAR);
55 -----------------------------------------------------------------------------
56
57 END ARI_REG_VERIFY_PKG;