[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row(
x_Rowid IN OUT NOCOPY VARCHAR2,
x_Registration_Id IN OUT NOCOPY NUMBER,
x_Application_Code VARCHAR2,
x_User_Email_Addr VARCHAR2,
x_Access_Domain_Search_Type VARCHAR2,
x_Access_Domain_Search_Number VARCHAR2,
x_Access_Domain_Type VARCHAR2,
x_Access_Domain_Cust_Id NUMBER,
x_Access_Domain_Billto_Id NUMBER,
x_Access_Domain_Number VARCHAR2,
x_Cust_Acct_Type VARCHAR2,
x_Status_Lookup_Code VARCHAR2,
x_Missed_Cust_Question_Count NUMBER DEFAULT 0,
x_Missed_Billto_Question_Count NUMBER DEFAULT 0,
x_Company_Id NUMBER,
x_Person_Id NUMBER,
x_Last_Update_Date DATE,
x_Last_Updated_By NUMBER,
x_Creation_Date DATE,
x_Created_By NUMBER,
x_Last_Update_Login NUMBER,
x_Registration_Type VARCHAR2)
-----------------------------------------------------------------------------
IS
CURSOR C IS SELECT rowid FROM ARI_REG_VERIFICATIONS
WHERE REGISTRATION_ID = x_REGISTRATION_ID;
CURSOR C2 IS SELECT ARI_REGISTRATIONS_S.nextval FROM sys.dual;
l_procedure_name VARCHAR2(31) := '.Insert_Row';
l_debug_info := 'Insert into ARI_REG_VERIFICATIONS';
INSERT INTO ARI_REG_VERIFICATIONS(
Registration_Id,
Application_Code,
User_Email_Addr,
Access_Domain_Search_Type,
Access_Domain_Search_Number,
Access_Domain_Type,
Access_Domain_Cust_Id,
Access_Domain_Billto_Id,
Access_Domain_Number,
Cust_Acct_Type,
Status,
Missed_Cust_Question_Count,
Missed_Billto_Question_Count,
Company_Id,
Person_Id,
Last_Update_Date,
Last_Updated_By,
Creation_Date,
Created_By,
Last_Update_Login,
Registration_Type
) VALUES (
x_Registration_id,
x_Application_Code,
x_User_Email_Addr,
x_Access_Domain_Search_Type,
x_Access_Domain_Search_Number,
x_Access_Domain_Type,
x_Access_Domain_Cust_Id,
x_Access_Domain_Billto_Id,
x_Access_Domain_Number,
x_Cust_Acct_Type,
x_Status_Lookup_Code,
x_Missed_Cust_Question_Count,
x_Missed_Billto_Question_Count,
x_Company_Id,
x_Person_Id,
x_Last_Update_Date,
x_Last_Updated_By,
x_Creation_Date,
x_Created_By,
x_Last_Update_Login,
x_Registration_Type
);
END Insert_Row;
PROCEDURE Delete_Row(x_registration_id NUMBER)
----------------------------------------------------
IS
l_procedure_name VARCHAR2(31) := '.Delete_Row';
DELETE FROM ARI_REG_VERIFICATIONS
WHERE registration_id = x_registration_id;
END Delete_Row;
PROCEDURE Update_Row(x_Registration_id NUMBER,
x_Application_Code VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
x_User_Email_Addr VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
x_Access_Domain_Type VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
x_Access_Domain_Number VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
x_Access_Domain_Cust_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
x_Access_Domain_Billto_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
x_Cust_Acct_Type VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
x_Status_Lookup_Code VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
x_Missed_Cust_Question_Count NUMBER DEFAULT FND_API.G_MISS_NUM,
x_Missed_Billto_Question_Count NUMBER DEFAULT FND_API.G_MISS_NUM,
x_Company_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
x_Person_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
x_Last_Update_Date DATE DEFAULT FND_API.G_MISS_DATE,
x_Last_Updated_By NUMBER DEFAULT FND_API.G_MISS_NUM,
x_Creation_Date DATE DEFAULT FND_API.G_MISS_DATE,
x_Created_By NUMBER DEFAULT FND_API.G_MISS_NUM,
x_Last_Update_Login NUMBER DEFAULT FND_API.G_MISS_NUM,
x_Registration_Type VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
x_Wf_Item_Key VARCHAR2 DEFAULT FND_API.G_MISS_CHAR)
------------------------------------------------------------------------------
IS
l_procedure_name VARCHAR2(31) := '.Update_Row';
UPDATE ARI_REG_VERIFICATIONS
SET
Application_Code = decode(x_Application_Code, FND_API.G_MISS_CHAR, Application_Code, x_Application_Code),
User_Email_Addr = decode(x_User_Email_Addr, FND_API.G_MISS_CHAR, User_Email_Addr, x_User_Email_Addr),
Access_Domain_Type = decode(x_Access_Domain_Type, FND_API.G_MISS_CHAR, Access_Domain_Type, x_Access_Domain_Type),
Access_Domain_Number = decode(x_Access_Domain_Number, FND_API.G_MISS_CHAR, Access_Domain_Number, x_Access_Domain_Number),
Access_Domain_Cust_Id = decode(x_Access_Domain_Cust_Id, FND_API.G_MISS_NUM, Access_Domain_Cust_Id, x_Access_Domain_Cust_Id),
Access_Domain_Billto_Id = decode(x_Access_Domain_Billto_Id, FND_API.G_MISS_NUM, Access_Domain_Billto_Id, x_Access_Domain_Billto_Id),
Cust_Acct_Type = decode(x_Cust_Acct_Type, FND_API.G_MISS_CHAR, Cust_Acct_Type, x_Cust_Acct_Type),
Status = decode(x_Status_Lookup_Code, FND_API.G_MISS_CHAR, Status, x_Status_Lookup_Code),
Missed_Cust_Question_Count = decode(x_Missed_Cust_Question_Count, FND_API.G_MISS_NUM, Missed_Cust_Question_Count, x_Missed_Cust_Question_Count),
Missed_Billto_Question_Count = decode(x_Missed_Billto_Question_Count, FND_API.G_MISS_NUM, Missed_Billto_Question_Count, x_Missed_Billto_Question_Count),
Company_Id = decode(x_Company_Id, FND_API.G_MISS_NUM, Company_Id, x_Company_Id),
Person_Id = decode(x_Person_Id, FND_API.G_MISS_NUM, Person_Id, x_Person_Id),
Last_Update_Date = decode(x_Last_Update_Date, FND_API.G_MISS_DATE, Last_Update_Date, x_Last_Update_Date),
Last_Updated_By = decode(x_Last_Updated_By, FND_API.G_MISS_NUM, Last_Updated_By, x_Last_Updated_By),
Last_Update_Login = decode(x_Last_Update_Login, FND_API.G_MISS_NUM, Last_Update_Login, x_Last_Update_Login),
Registration_Type = decode(x_Registration_Type, FND_API.G_MISS_CHAR, Registration_Type,x_Registration_Type),
Wf_Item_Key = decode(x_Wf_Item_Key, FND_API.G_MISS_CHAR, Wf_Item_Key,x_Wf_Item_Key)
-- Bug 3032780
/*
Creation_Date = decode(x_Creation_Date, FND_API.G_MISS_DATE, Creation_Date, x_Creation_Date),
Created_By = decode(x_Created_By, FND_API.G_MISS_NUM, Created_By, x_Created_By)*/
WHERE registration_id = x_registration_id;
END Update_Row;