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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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);
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: -----------------------------------------------------------------------------
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:
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;
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;