eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARI_REG_VERIFY_PKG dependencies on FND_API

Line 164: x_Application_Code VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

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,

Line 165: x_User_Email_Addr VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

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,

Line 166: x_Access_Domain_Type VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

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,

Line 167: x_Access_Domain_Number 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,

Line 168: x_Access_Domain_Cust_Id NUMBER DEFAULT FND_API.G_MISS_NUM,

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,

Line 169: x_Access_Domain_Billto_Id 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,

Line 170: x_Cust_Acct_Type 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,
174: x_Company_Id NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 171: x_Status_Lookup_Code 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,
175: x_Person_Id NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 172: x_Missed_Cust_Question_Count 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,

Line 173: x_Missed_Billto_Question_Count 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,
177: x_Last_Updated_By NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 174: x_Company_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,
178: x_Creation_Date DATE DEFAULT FND_API.G_MISS_DATE,

Line 175: x_Person_Id NUMBER DEFAULT FND_API.G_MISS_NUM,

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,

Line 176: x_Last_Update_Date DATE DEFAULT FND_API.G_MISS_DATE,

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,

Line 177: x_Last_Updated_By 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,

Line 178: x_Creation_Date DATE DEFAULT FND_API.G_MISS_DATE,

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)

Line 179: x_Created_By 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)
183: ------------------------------------------------------------------------------

Line 180: x_Last_Update_Login 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: ------------------------------------------------------------------------------
184: IS

Line 181: x_Registration_Type VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

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';

Line 182: x_Wf_Item_Key VARCHAR2 DEFAULT FND_API.G_MISS_CHAR)

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

Line 190: Application_Code = decode(x_Application_Code, FND_API.G_MISS_CHAR, Application_Code, x_Application_Code),

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

Line 191: User_Email_Addr = decode(x_User_Email_Addr, FND_API.G_MISS_CHAR, User_Email_Addr, x_User_Email_Addr),

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

Line 192: Access_Domain_Type = decode(x_Access_Domain_Type, FND_API.G_MISS_CHAR, Access_Domain_Type, x_Access_Domain_Type),

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

Line 193: Access_Domain_Number = decode(x_Access_Domain_Number, FND_API.G_MISS_CHAR, Access_Domain_Number, x_Access_Domain_Number),

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

Line 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),

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

Line 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),

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

Line 196: Cust_Acct_Type = decode(x_Cust_Acct_Type, FND_API.G_MISS_CHAR, Cust_Acct_Type, x_Cust_Acct_Type),

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

Line 197: Status = decode(x_Status_Lookup_Code, FND_API.G_MISS_CHAR, Status, x_Status_Lookup_Code),

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

Line 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),

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

Line 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),

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

Line 200: Company_Id = decode(x_Company_Id, FND_API.G_MISS_NUM, Company_Id, x_Company_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),
204: Last_Update_Login = decode(x_Last_Update_Login, FND_API.G_MISS_NUM, Last_Update_Login, x_Last_Update_Login),

Line 201: Person_Id = decode(x_Person_Id, FND_API.G_MISS_NUM, Person_Id, x_Person_Id),

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

Line 202: Last_Update_Date = decode(x_Last_Update_Date, FND_API.G_MISS_DATE, Last_Update_Date, x_Last_Update_Date),

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)

Line 203: Last_Updated_By = decode(x_Last_Updated_By, FND_API.G_MISS_NUM, Last_Updated_By, x_Last_Updated_By),

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

Line 204: Last_Update_Login = decode(x_Last_Update_Login, FND_API.G_MISS_NUM, Last_Update_Login, x_Last_Update_Login),

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: /*

Line 205: Registration_Type = decode(x_Registration_Type, FND_API.G_MISS_CHAR, Registration_Type,x_Registration_Type),

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

Line 206: Wf_Item_Key = decode(x_Wf_Item_Key, FND_API.G_MISS_CHAR, Wf_Item_Key,x_Wf_Item_Key)

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)*/

Line 209: Creation_Date = decode(x_Creation_Date, FND_API.G_MISS_DATE, Creation_Date, x_Creation_Date),

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

Line 210: Created_By = decode(x_Created_By, FND_API.G_MISS_NUM, Created_By, x_Created_By)*/

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;