160:
161:
162: -----------------------------------------------------------------------------
163: PROCEDURE Update_Row(x_Registration_id NUMBER,
164: x_Application_Code VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
165: x_User_Email_Addr VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
166: x_Access_Domain_Type VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
167: x_Access_Domain_Number VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
168: x_Access_Domain_Cust_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
161:
162: -----------------------------------------------------------------------------
163: PROCEDURE Update_Row(x_Registration_id NUMBER,
164: x_Application_Code VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
165: x_User_Email_Addr VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
166: x_Access_Domain_Type VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
167: x_Access_Domain_Number VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
168: x_Access_Domain_Cust_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
169: x_Access_Domain_Billto_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
162: -----------------------------------------------------------------------------
163: PROCEDURE Update_Row(x_Registration_id NUMBER,
164: x_Application_Code VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
165: x_User_Email_Addr VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
166: x_Access_Domain_Type VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
167: x_Access_Domain_Number VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
168: x_Access_Domain_Cust_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
169: x_Access_Domain_Billto_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
170: x_Cust_Acct_Type VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
163: PROCEDURE Update_Row(x_Registration_id NUMBER,
164: x_Application_Code VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
165: x_User_Email_Addr VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
166: x_Access_Domain_Type VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
167: x_Access_Domain_Number VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
168: x_Access_Domain_Cust_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
169: x_Access_Domain_Billto_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
170: x_Cust_Acct_Type VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
171: x_Status_Lookup_Code VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
164: x_Application_Code VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
165: x_User_Email_Addr VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
166: x_Access_Domain_Type VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
167: x_Access_Domain_Number VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
168: x_Access_Domain_Cust_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
169: x_Access_Domain_Billto_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
170: x_Cust_Acct_Type VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
171: x_Status_Lookup_Code VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
172: x_Missed_Cust_Question_Count NUMBER DEFAULT FND_API.G_MISS_NUM,
165: x_User_Email_Addr VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
166: x_Access_Domain_Type VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
167: x_Access_Domain_Number VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
168: x_Access_Domain_Cust_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
169: x_Access_Domain_Billto_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
170: x_Cust_Acct_Type VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
171: x_Status_Lookup_Code VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
172: x_Missed_Cust_Question_Count NUMBER DEFAULT FND_API.G_MISS_NUM,
173: x_Missed_Billto_Question_Count NUMBER DEFAULT FND_API.G_MISS_NUM,
166: x_Access_Domain_Type VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
167: x_Access_Domain_Number VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
168: x_Access_Domain_Cust_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
169: x_Access_Domain_Billto_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
170: x_Cust_Acct_Type VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
171: x_Status_Lookup_Code VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
172: x_Missed_Cust_Question_Count NUMBER DEFAULT FND_API.G_MISS_NUM,
173: x_Missed_Billto_Question_Count NUMBER DEFAULT FND_API.G_MISS_NUM,
174: x_Company_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
167: x_Access_Domain_Number VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
168: x_Access_Domain_Cust_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
169: x_Access_Domain_Billto_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
170: x_Cust_Acct_Type VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
171: x_Status_Lookup_Code VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
172: x_Missed_Cust_Question_Count NUMBER DEFAULT FND_API.G_MISS_NUM,
173: x_Missed_Billto_Question_Count NUMBER DEFAULT FND_API.G_MISS_NUM,
174: x_Company_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
175: x_Person_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
168: x_Access_Domain_Cust_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
169: x_Access_Domain_Billto_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
170: x_Cust_Acct_Type VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
171: x_Status_Lookup_Code VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
172: x_Missed_Cust_Question_Count NUMBER DEFAULT FND_API.G_MISS_NUM,
173: x_Missed_Billto_Question_Count NUMBER DEFAULT FND_API.G_MISS_NUM,
174: x_Company_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
175: x_Person_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
176: x_Last_Update_Date DATE DEFAULT FND_API.G_MISS_DATE,
169: x_Access_Domain_Billto_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
170: x_Cust_Acct_Type VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
171: x_Status_Lookup_Code VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
172: x_Missed_Cust_Question_Count NUMBER DEFAULT FND_API.G_MISS_NUM,
173: x_Missed_Billto_Question_Count NUMBER DEFAULT FND_API.G_MISS_NUM,
174: x_Company_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
175: x_Person_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
176: x_Last_Update_Date DATE DEFAULT FND_API.G_MISS_DATE,
177: x_Last_Updated_By NUMBER DEFAULT FND_API.G_MISS_NUM,
170: x_Cust_Acct_Type VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
171: x_Status_Lookup_Code VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
172: x_Missed_Cust_Question_Count NUMBER DEFAULT FND_API.G_MISS_NUM,
173: x_Missed_Billto_Question_Count NUMBER DEFAULT FND_API.G_MISS_NUM,
174: x_Company_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
175: x_Person_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
176: x_Last_Update_Date DATE DEFAULT FND_API.G_MISS_DATE,
177: x_Last_Updated_By NUMBER DEFAULT FND_API.G_MISS_NUM,
178: x_Creation_Date DATE DEFAULT FND_API.G_MISS_DATE,
171: x_Status_Lookup_Code VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
172: x_Missed_Cust_Question_Count NUMBER DEFAULT FND_API.G_MISS_NUM,
173: x_Missed_Billto_Question_Count NUMBER DEFAULT FND_API.G_MISS_NUM,
174: x_Company_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
175: x_Person_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
176: x_Last_Update_Date DATE DEFAULT FND_API.G_MISS_DATE,
177: x_Last_Updated_By NUMBER DEFAULT FND_API.G_MISS_NUM,
178: x_Creation_Date DATE DEFAULT FND_API.G_MISS_DATE,
179: x_Created_By NUMBER DEFAULT FND_API.G_MISS_NUM,
172: x_Missed_Cust_Question_Count NUMBER DEFAULT FND_API.G_MISS_NUM,
173: x_Missed_Billto_Question_Count NUMBER DEFAULT FND_API.G_MISS_NUM,
174: x_Company_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
175: x_Person_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
176: x_Last_Update_Date DATE DEFAULT FND_API.G_MISS_DATE,
177: x_Last_Updated_By NUMBER DEFAULT FND_API.G_MISS_NUM,
178: x_Creation_Date DATE DEFAULT FND_API.G_MISS_DATE,
179: x_Created_By NUMBER DEFAULT FND_API.G_MISS_NUM,
180: x_Last_Update_Login NUMBER DEFAULT FND_API.G_MISS_NUM,
173: x_Missed_Billto_Question_Count NUMBER DEFAULT FND_API.G_MISS_NUM,
174: x_Company_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
175: x_Person_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
176: x_Last_Update_Date DATE DEFAULT FND_API.G_MISS_DATE,
177: x_Last_Updated_By NUMBER DEFAULT FND_API.G_MISS_NUM,
178: x_Creation_Date DATE DEFAULT FND_API.G_MISS_DATE,
179: x_Created_By NUMBER DEFAULT FND_API.G_MISS_NUM,
180: x_Last_Update_Login NUMBER DEFAULT FND_API.G_MISS_NUM,
181: x_Registration_Type VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
174: x_Company_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
175: x_Person_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
176: x_Last_Update_Date DATE DEFAULT FND_API.G_MISS_DATE,
177: x_Last_Updated_By NUMBER DEFAULT FND_API.G_MISS_NUM,
178: x_Creation_Date DATE DEFAULT FND_API.G_MISS_DATE,
179: x_Created_By NUMBER DEFAULT FND_API.G_MISS_NUM,
180: x_Last_Update_Login NUMBER DEFAULT FND_API.G_MISS_NUM,
181: x_Registration_Type VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
182: x_Wf_Item_Key VARCHAR2 DEFAULT FND_API.G_MISS_CHAR)
175: x_Person_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
176: x_Last_Update_Date DATE DEFAULT FND_API.G_MISS_DATE,
177: x_Last_Updated_By NUMBER DEFAULT FND_API.G_MISS_NUM,
178: x_Creation_Date DATE DEFAULT FND_API.G_MISS_DATE,
179: x_Created_By NUMBER DEFAULT FND_API.G_MISS_NUM,
180: x_Last_Update_Login NUMBER DEFAULT FND_API.G_MISS_NUM,
181: x_Registration_Type VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
182: x_Wf_Item_Key VARCHAR2 DEFAULT FND_API.G_MISS_CHAR)
183: ------------------------------------------------------------------------------
176: x_Last_Update_Date DATE DEFAULT FND_API.G_MISS_DATE,
177: x_Last_Updated_By NUMBER DEFAULT FND_API.G_MISS_NUM,
178: x_Creation_Date DATE DEFAULT FND_API.G_MISS_DATE,
179: x_Created_By NUMBER DEFAULT FND_API.G_MISS_NUM,
180: x_Last_Update_Login NUMBER DEFAULT FND_API.G_MISS_NUM,
181: x_Registration_Type VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
182: x_Wf_Item_Key VARCHAR2 DEFAULT FND_API.G_MISS_CHAR)
183: ------------------------------------------------------------------------------
184: IS
177: x_Last_Updated_By NUMBER DEFAULT FND_API.G_MISS_NUM,
178: x_Creation_Date DATE DEFAULT FND_API.G_MISS_DATE,
179: x_Created_By NUMBER DEFAULT FND_API.G_MISS_NUM,
180: x_Last_Update_Login NUMBER DEFAULT FND_API.G_MISS_NUM,
181: x_Registration_Type VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
182: x_Wf_Item_Key VARCHAR2 DEFAULT FND_API.G_MISS_CHAR)
183: ------------------------------------------------------------------------------
184: IS
185: l_procedure_name VARCHAR2(31) := '.Update_Row';
178: x_Creation_Date DATE DEFAULT FND_API.G_MISS_DATE,
179: x_Created_By NUMBER DEFAULT FND_API.G_MISS_NUM,
180: x_Last_Update_Login NUMBER DEFAULT FND_API.G_MISS_NUM,
181: x_Registration_Type VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
182: x_Wf_Item_Key VARCHAR2 DEFAULT FND_API.G_MISS_CHAR)
183: ------------------------------------------------------------------------------
184: IS
185: l_procedure_name VARCHAR2(31) := '.Update_Row';
186: BEGIN
186: BEGIN
187:
188: UPDATE ARI_REG_VERIFICATIONS
189: SET
190: Application_Code = decode(x_Application_Code, FND_API.G_MISS_CHAR, Application_Code, x_Application_Code),
191: User_Email_Addr = decode(x_User_Email_Addr, FND_API.G_MISS_CHAR, User_Email_Addr, x_User_Email_Addr),
192: Access_Domain_Type = decode(x_Access_Domain_Type, FND_API.G_MISS_CHAR, Access_Domain_Type, x_Access_Domain_Type),
193: Access_Domain_Number = decode(x_Access_Domain_Number, FND_API.G_MISS_CHAR, Access_Domain_Number, x_Access_Domain_Number),
194: Access_Domain_Cust_Id = decode(x_Access_Domain_Cust_Id, FND_API.G_MISS_NUM, Access_Domain_Cust_Id, x_Access_Domain_Cust_Id),
187:
188: UPDATE ARI_REG_VERIFICATIONS
189: SET
190: Application_Code = decode(x_Application_Code, FND_API.G_MISS_CHAR, Application_Code, x_Application_Code),
191: User_Email_Addr = decode(x_User_Email_Addr, FND_API.G_MISS_CHAR, User_Email_Addr, x_User_Email_Addr),
192: Access_Domain_Type = decode(x_Access_Domain_Type, FND_API.G_MISS_CHAR, Access_Domain_Type, x_Access_Domain_Type),
193: Access_Domain_Number = decode(x_Access_Domain_Number, FND_API.G_MISS_CHAR, Access_Domain_Number, x_Access_Domain_Number),
194: Access_Domain_Cust_Id = decode(x_Access_Domain_Cust_Id, FND_API.G_MISS_NUM, Access_Domain_Cust_Id, x_Access_Domain_Cust_Id),
195: Access_Domain_Billto_Id = decode(x_Access_Domain_Billto_Id, FND_API.G_MISS_NUM, Access_Domain_Billto_Id, x_Access_Domain_Billto_Id),
188: UPDATE ARI_REG_VERIFICATIONS
189: SET
190: Application_Code = decode(x_Application_Code, FND_API.G_MISS_CHAR, Application_Code, x_Application_Code),
191: User_Email_Addr = decode(x_User_Email_Addr, FND_API.G_MISS_CHAR, User_Email_Addr, x_User_Email_Addr),
192: Access_Domain_Type = decode(x_Access_Domain_Type, FND_API.G_MISS_CHAR, Access_Domain_Type, x_Access_Domain_Type),
193: Access_Domain_Number = decode(x_Access_Domain_Number, FND_API.G_MISS_CHAR, Access_Domain_Number, x_Access_Domain_Number),
194: Access_Domain_Cust_Id = decode(x_Access_Domain_Cust_Id, FND_API.G_MISS_NUM, Access_Domain_Cust_Id, x_Access_Domain_Cust_Id),
195: Access_Domain_Billto_Id = decode(x_Access_Domain_Billto_Id, FND_API.G_MISS_NUM, Access_Domain_Billto_Id, x_Access_Domain_Billto_Id),
196: Cust_Acct_Type = decode(x_Cust_Acct_Type, FND_API.G_MISS_CHAR, Cust_Acct_Type, x_Cust_Acct_Type),
189: SET
190: Application_Code = decode(x_Application_Code, FND_API.G_MISS_CHAR, Application_Code, x_Application_Code),
191: User_Email_Addr = decode(x_User_Email_Addr, FND_API.G_MISS_CHAR, User_Email_Addr, x_User_Email_Addr),
192: Access_Domain_Type = decode(x_Access_Domain_Type, FND_API.G_MISS_CHAR, Access_Domain_Type, x_Access_Domain_Type),
193: Access_Domain_Number = decode(x_Access_Domain_Number, FND_API.G_MISS_CHAR, Access_Domain_Number, x_Access_Domain_Number),
194: Access_Domain_Cust_Id = decode(x_Access_Domain_Cust_Id, FND_API.G_MISS_NUM, Access_Domain_Cust_Id, x_Access_Domain_Cust_Id),
195: Access_Domain_Billto_Id = decode(x_Access_Domain_Billto_Id, FND_API.G_MISS_NUM, Access_Domain_Billto_Id, x_Access_Domain_Billto_Id),
196: Cust_Acct_Type = decode(x_Cust_Acct_Type, FND_API.G_MISS_CHAR, Cust_Acct_Type, x_Cust_Acct_Type),
197: Status = decode(x_Status_Lookup_Code, FND_API.G_MISS_CHAR, Status, x_Status_Lookup_Code),
190: Application_Code = decode(x_Application_Code, FND_API.G_MISS_CHAR, Application_Code, x_Application_Code),
191: User_Email_Addr = decode(x_User_Email_Addr, FND_API.G_MISS_CHAR, User_Email_Addr, x_User_Email_Addr),
192: Access_Domain_Type = decode(x_Access_Domain_Type, FND_API.G_MISS_CHAR, Access_Domain_Type, x_Access_Domain_Type),
193: Access_Domain_Number = decode(x_Access_Domain_Number, FND_API.G_MISS_CHAR, Access_Domain_Number, x_Access_Domain_Number),
194: Access_Domain_Cust_Id = decode(x_Access_Domain_Cust_Id, FND_API.G_MISS_NUM, Access_Domain_Cust_Id, x_Access_Domain_Cust_Id),
195: Access_Domain_Billto_Id = decode(x_Access_Domain_Billto_Id, FND_API.G_MISS_NUM, Access_Domain_Billto_Id, x_Access_Domain_Billto_Id),
196: Cust_Acct_Type = decode(x_Cust_Acct_Type, FND_API.G_MISS_CHAR, Cust_Acct_Type, x_Cust_Acct_Type),
197: Status = decode(x_Status_Lookup_Code, FND_API.G_MISS_CHAR, Status, x_Status_Lookup_Code),
198: Missed_Cust_Question_Count = decode(x_Missed_Cust_Question_Count, FND_API.G_MISS_NUM, Missed_Cust_Question_Count, x_Missed_Cust_Question_Count),
191: User_Email_Addr = decode(x_User_Email_Addr, FND_API.G_MISS_CHAR, User_Email_Addr, x_User_Email_Addr),
192: Access_Domain_Type = decode(x_Access_Domain_Type, FND_API.G_MISS_CHAR, Access_Domain_Type, x_Access_Domain_Type),
193: Access_Domain_Number = decode(x_Access_Domain_Number, FND_API.G_MISS_CHAR, Access_Domain_Number, x_Access_Domain_Number),
194: Access_Domain_Cust_Id = decode(x_Access_Domain_Cust_Id, FND_API.G_MISS_NUM, Access_Domain_Cust_Id, x_Access_Domain_Cust_Id),
195: Access_Domain_Billto_Id = decode(x_Access_Domain_Billto_Id, FND_API.G_MISS_NUM, Access_Domain_Billto_Id, x_Access_Domain_Billto_Id),
196: Cust_Acct_Type = decode(x_Cust_Acct_Type, FND_API.G_MISS_CHAR, Cust_Acct_Type, x_Cust_Acct_Type),
197: Status = decode(x_Status_Lookup_Code, FND_API.G_MISS_CHAR, Status, x_Status_Lookup_Code),
198: Missed_Cust_Question_Count = decode(x_Missed_Cust_Question_Count, FND_API.G_MISS_NUM, Missed_Cust_Question_Count, x_Missed_Cust_Question_Count),
199: Missed_Billto_Question_Count = decode(x_Missed_Billto_Question_Count, FND_API.G_MISS_NUM, Missed_Billto_Question_Count, x_Missed_Billto_Question_Count),
192: Access_Domain_Type = decode(x_Access_Domain_Type, FND_API.G_MISS_CHAR, Access_Domain_Type, x_Access_Domain_Type),
193: Access_Domain_Number = decode(x_Access_Domain_Number, FND_API.G_MISS_CHAR, Access_Domain_Number, x_Access_Domain_Number),
194: Access_Domain_Cust_Id = decode(x_Access_Domain_Cust_Id, FND_API.G_MISS_NUM, Access_Domain_Cust_Id, x_Access_Domain_Cust_Id),
195: Access_Domain_Billto_Id = decode(x_Access_Domain_Billto_Id, FND_API.G_MISS_NUM, Access_Domain_Billto_Id, x_Access_Domain_Billto_Id),
196: Cust_Acct_Type = decode(x_Cust_Acct_Type, FND_API.G_MISS_CHAR, Cust_Acct_Type, x_Cust_Acct_Type),
197: Status = decode(x_Status_Lookup_Code, FND_API.G_MISS_CHAR, Status, x_Status_Lookup_Code),
198: Missed_Cust_Question_Count = decode(x_Missed_Cust_Question_Count, FND_API.G_MISS_NUM, Missed_Cust_Question_Count, x_Missed_Cust_Question_Count),
199: Missed_Billto_Question_Count = decode(x_Missed_Billto_Question_Count, FND_API.G_MISS_NUM, Missed_Billto_Question_Count, x_Missed_Billto_Question_Count),
200: Company_Id = decode(x_Company_Id, FND_API.G_MISS_NUM, Company_Id, x_Company_Id),
193: Access_Domain_Number = decode(x_Access_Domain_Number, FND_API.G_MISS_CHAR, Access_Domain_Number, x_Access_Domain_Number),
194: Access_Domain_Cust_Id = decode(x_Access_Domain_Cust_Id, FND_API.G_MISS_NUM, Access_Domain_Cust_Id, x_Access_Domain_Cust_Id),
195: Access_Domain_Billto_Id = decode(x_Access_Domain_Billto_Id, FND_API.G_MISS_NUM, Access_Domain_Billto_Id, x_Access_Domain_Billto_Id),
196: Cust_Acct_Type = decode(x_Cust_Acct_Type, FND_API.G_MISS_CHAR, Cust_Acct_Type, x_Cust_Acct_Type),
197: Status = decode(x_Status_Lookup_Code, FND_API.G_MISS_CHAR, Status, x_Status_Lookup_Code),
198: Missed_Cust_Question_Count = decode(x_Missed_Cust_Question_Count, FND_API.G_MISS_NUM, Missed_Cust_Question_Count, x_Missed_Cust_Question_Count),
199: Missed_Billto_Question_Count = decode(x_Missed_Billto_Question_Count, FND_API.G_MISS_NUM, Missed_Billto_Question_Count, x_Missed_Billto_Question_Count),
200: Company_Id = decode(x_Company_Id, FND_API.G_MISS_NUM, Company_Id, x_Company_Id),
201: Person_Id = decode(x_Person_Id, FND_API.G_MISS_NUM, Person_Id, x_Person_Id),
194: Access_Domain_Cust_Id = decode(x_Access_Domain_Cust_Id, FND_API.G_MISS_NUM, Access_Domain_Cust_Id, x_Access_Domain_Cust_Id),
195: Access_Domain_Billto_Id = decode(x_Access_Domain_Billto_Id, FND_API.G_MISS_NUM, Access_Domain_Billto_Id, x_Access_Domain_Billto_Id),
196: Cust_Acct_Type = decode(x_Cust_Acct_Type, FND_API.G_MISS_CHAR, Cust_Acct_Type, x_Cust_Acct_Type),
197: Status = decode(x_Status_Lookup_Code, FND_API.G_MISS_CHAR, Status, x_Status_Lookup_Code),
198: Missed_Cust_Question_Count = decode(x_Missed_Cust_Question_Count, FND_API.G_MISS_NUM, Missed_Cust_Question_Count, x_Missed_Cust_Question_Count),
199: Missed_Billto_Question_Count = decode(x_Missed_Billto_Question_Count, FND_API.G_MISS_NUM, Missed_Billto_Question_Count, x_Missed_Billto_Question_Count),
200: Company_Id = decode(x_Company_Id, FND_API.G_MISS_NUM, Company_Id, x_Company_Id),
201: Person_Id = decode(x_Person_Id, FND_API.G_MISS_NUM, Person_Id, x_Person_Id),
202: Last_Update_Date = decode(x_Last_Update_Date, FND_API.G_MISS_DATE, Last_Update_Date, x_Last_Update_Date),
195: Access_Domain_Billto_Id = decode(x_Access_Domain_Billto_Id, FND_API.G_MISS_NUM, Access_Domain_Billto_Id, x_Access_Domain_Billto_Id),
196: Cust_Acct_Type = decode(x_Cust_Acct_Type, FND_API.G_MISS_CHAR, Cust_Acct_Type, x_Cust_Acct_Type),
197: Status = decode(x_Status_Lookup_Code, FND_API.G_MISS_CHAR, Status, x_Status_Lookup_Code),
198: Missed_Cust_Question_Count = decode(x_Missed_Cust_Question_Count, FND_API.G_MISS_NUM, Missed_Cust_Question_Count, x_Missed_Cust_Question_Count),
199: Missed_Billto_Question_Count = decode(x_Missed_Billto_Question_Count, FND_API.G_MISS_NUM, Missed_Billto_Question_Count, x_Missed_Billto_Question_Count),
200: Company_Id = decode(x_Company_Id, FND_API.G_MISS_NUM, Company_Id, x_Company_Id),
201: Person_Id = decode(x_Person_Id, FND_API.G_MISS_NUM, Person_Id, x_Person_Id),
202: Last_Update_Date = decode(x_Last_Update_Date, FND_API.G_MISS_DATE, Last_Update_Date, x_Last_Update_Date),
203: Last_Updated_By = decode(x_Last_Updated_By, FND_API.G_MISS_NUM, Last_Updated_By, x_Last_Updated_By),
196: Cust_Acct_Type = decode(x_Cust_Acct_Type, FND_API.G_MISS_CHAR, Cust_Acct_Type, x_Cust_Acct_Type),
197: Status = decode(x_Status_Lookup_Code, FND_API.G_MISS_CHAR, Status, x_Status_Lookup_Code),
198: Missed_Cust_Question_Count = decode(x_Missed_Cust_Question_Count, FND_API.G_MISS_NUM, Missed_Cust_Question_Count, x_Missed_Cust_Question_Count),
199: Missed_Billto_Question_Count = decode(x_Missed_Billto_Question_Count, FND_API.G_MISS_NUM, Missed_Billto_Question_Count, x_Missed_Billto_Question_Count),
200: Company_Id = decode(x_Company_Id, FND_API.G_MISS_NUM, Company_Id, x_Company_Id),
201: Person_Id = decode(x_Person_Id, FND_API.G_MISS_NUM, Person_Id, x_Person_Id),
202: Last_Update_Date = decode(x_Last_Update_Date, FND_API.G_MISS_DATE, Last_Update_Date, x_Last_Update_Date),
203: Last_Updated_By = decode(x_Last_Updated_By, FND_API.G_MISS_NUM, Last_Updated_By, x_Last_Updated_By),
204: Last_Update_Login = decode(x_Last_Update_Login, FND_API.G_MISS_NUM, Last_Update_Login, x_Last_Update_Login),
197: Status = decode(x_Status_Lookup_Code, FND_API.G_MISS_CHAR, Status, x_Status_Lookup_Code),
198: Missed_Cust_Question_Count = decode(x_Missed_Cust_Question_Count, FND_API.G_MISS_NUM, Missed_Cust_Question_Count, x_Missed_Cust_Question_Count),
199: Missed_Billto_Question_Count = decode(x_Missed_Billto_Question_Count, FND_API.G_MISS_NUM, Missed_Billto_Question_Count, x_Missed_Billto_Question_Count),
200: Company_Id = decode(x_Company_Id, FND_API.G_MISS_NUM, Company_Id, x_Company_Id),
201: Person_Id = decode(x_Person_Id, FND_API.G_MISS_NUM, Person_Id, x_Person_Id),
202: Last_Update_Date = decode(x_Last_Update_Date, FND_API.G_MISS_DATE, Last_Update_Date, x_Last_Update_Date),
203: Last_Updated_By = decode(x_Last_Updated_By, FND_API.G_MISS_NUM, Last_Updated_By, x_Last_Updated_By),
204: Last_Update_Login = decode(x_Last_Update_Login, FND_API.G_MISS_NUM, Last_Update_Login, x_Last_Update_Login),
205: Registration_Type = decode(x_Registration_Type, FND_API.G_MISS_CHAR, Registration_Type,x_Registration_Type),
198: Missed_Cust_Question_Count = decode(x_Missed_Cust_Question_Count, FND_API.G_MISS_NUM, Missed_Cust_Question_Count, x_Missed_Cust_Question_Count),
199: Missed_Billto_Question_Count = decode(x_Missed_Billto_Question_Count, FND_API.G_MISS_NUM, Missed_Billto_Question_Count, x_Missed_Billto_Question_Count),
200: Company_Id = decode(x_Company_Id, FND_API.G_MISS_NUM, Company_Id, x_Company_Id),
201: Person_Id = decode(x_Person_Id, FND_API.G_MISS_NUM, Person_Id, x_Person_Id),
202: Last_Update_Date = decode(x_Last_Update_Date, FND_API.G_MISS_DATE, Last_Update_Date, x_Last_Update_Date),
203: Last_Updated_By = decode(x_Last_Updated_By, FND_API.G_MISS_NUM, Last_Updated_By, x_Last_Updated_By),
204: Last_Update_Login = decode(x_Last_Update_Login, FND_API.G_MISS_NUM, Last_Update_Login, x_Last_Update_Login),
205: Registration_Type = decode(x_Registration_Type, FND_API.G_MISS_CHAR, Registration_Type,x_Registration_Type),
206: Wf_Item_Key = decode(x_Wf_Item_Key, FND_API.G_MISS_CHAR, Wf_Item_Key,x_Wf_Item_Key)
199: Missed_Billto_Question_Count = decode(x_Missed_Billto_Question_Count, FND_API.G_MISS_NUM, Missed_Billto_Question_Count, x_Missed_Billto_Question_Count),
200: Company_Id = decode(x_Company_Id, FND_API.G_MISS_NUM, Company_Id, x_Company_Id),
201: Person_Id = decode(x_Person_Id, FND_API.G_MISS_NUM, Person_Id, x_Person_Id),
202: Last_Update_Date = decode(x_Last_Update_Date, FND_API.G_MISS_DATE, Last_Update_Date, x_Last_Update_Date),
203: Last_Updated_By = decode(x_Last_Updated_By, FND_API.G_MISS_NUM, Last_Updated_By, x_Last_Updated_By),
204: Last_Update_Login = decode(x_Last_Update_Login, FND_API.G_MISS_NUM, Last_Update_Login, x_Last_Update_Login),
205: Registration_Type = decode(x_Registration_Type, FND_API.G_MISS_CHAR, Registration_Type,x_Registration_Type),
206: Wf_Item_Key = decode(x_Wf_Item_Key, FND_API.G_MISS_CHAR, Wf_Item_Key,x_Wf_Item_Key)
207: -- Bug 3032780
200: Company_Id = decode(x_Company_Id, FND_API.G_MISS_NUM, Company_Id, x_Company_Id),
201: Person_Id = decode(x_Person_Id, FND_API.G_MISS_NUM, Person_Id, x_Person_Id),
202: Last_Update_Date = decode(x_Last_Update_Date, FND_API.G_MISS_DATE, Last_Update_Date, x_Last_Update_Date),
203: Last_Updated_By = decode(x_Last_Updated_By, FND_API.G_MISS_NUM, Last_Updated_By, x_Last_Updated_By),
204: Last_Update_Login = decode(x_Last_Update_Login, FND_API.G_MISS_NUM, Last_Update_Login, x_Last_Update_Login),
205: Registration_Type = decode(x_Registration_Type, FND_API.G_MISS_CHAR, Registration_Type,x_Registration_Type),
206: Wf_Item_Key = decode(x_Wf_Item_Key, FND_API.G_MISS_CHAR, Wf_Item_Key,x_Wf_Item_Key)
207: -- Bug 3032780
208: /*
201: Person_Id = decode(x_Person_Id, FND_API.G_MISS_NUM, Person_Id, x_Person_Id),
202: Last_Update_Date = decode(x_Last_Update_Date, FND_API.G_MISS_DATE, Last_Update_Date, x_Last_Update_Date),
203: Last_Updated_By = decode(x_Last_Updated_By, FND_API.G_MISS_NUM, Last_Updated_By, x_Last_Updated_By),
204: Last_Update_Login = decode(x_Last_Update_Login, FND_API.G_MISS_NUM, Last_Update_Login, x_Last_Update_Login),
205: Registration_Type = decode(x_Registration_Type, FND_API.G_MISS_CHAR, Registration_Type,x_Registration_Type),
206: Wf_Item_Key = decode(x_Wf_Item_Key, FND_API.G_MISS_CHAR, Wf_Item_Key,x_Wf_Item_Key)
207: -- Bug 3032780
208: /*
209: Creation_Date = decode(x_Creation_Date, FND_API.G_MISS_DATE, Creation_Date, x_Creation_Date),
202: Last_Update_Date = decode(x_Last_Update_Date, FND_API.G_MISS_DATE, Last_Update_Date, x_Last_Update_Date),
203: Last_Updated_By = decode(x_Last_Updated_By, FND_API.G_MISS_NUM, Last_Updated_By, x_Last_Updated_By),
204: Last_Update_Login = decode(x_Last_Update_Login, FND_API.G_MISS_NUM, Last_Update_Login, x_Last_Update_Login),
205: Registration_Type = decode(x_Registration_Type, FND_API.G_MISS_CHAR, Registration_Type,x_Registration_Type),
206: Wf_Item_Key = decode(x_Wf_Item_Key, FND_API.G_MISS_CHAR, Wf_Item_Key,x_Wf_Item_Key)
207: -- Bug 3032780
208: /*
209: Creation_Date = decode(x_Creation_Date, FND_API.G_MISS_DATE, Creation_Date, x_Creation_Date),
210: Created_By = decode(x_Created_By, FND_API.G_MISS_NUM, Created_By, x_Created_By)*/
205: Registration_Type = decode(x_Registration_Type, FND_API.G_MISS_CHAR, Registration_Type,x_Registration_Type),
206: Wf_Item_Key = decode(x_Wf_Item_Key, FND_API.G_MISS_CHAR, Wf_Item_Key,x_Wf_Item_Key)
207: -- Bug 3032780
208: /*
209: Creation_Date = decode(x_Creation_Date, FND_API.G_MISS_DATE, Creation_Date, x_Creation_Date),
210: Created_By = decode(x_Created_By, FND_API.G_MISS_NUM, Created_By, x_Created_By)*/
211: WHERE registration_id = x_registration_id;
212:
213: If (SQL%NOTFOUND) then
206: Wf_Item_Key = decode(x_Wf_Item_Key, FND_API.G_MISS_CHAR, Wf_Item_Key,x_Wf_Item_Key)
207: -- Bug 3032780
208: /*
209: Creation_Date = decode(x_Creation_Date, FND_API.G_MISS_DATE, Creation_Date, x_Creation_Date),
210: Created_By = decode(x_Created_By, FND_API.G_MISS_NUM, Created_By, x_Created_By)*/
211: WHERE registration_id = x_registration_id;
212:
213: If (SQL%NOTFOUND) then
214: RAISE NO_DATA_FOUND;