The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row Overloaded Procedure for CC_REF_NUM addition
===============================================================================*/
PROCEDURE Insert_Row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
X_return_status OUT NOCOPY VARCHAR2,
X_msg_count OUT NOCOPY NUMBER,
X_msg_data OUT NOCOPY VARCHAR2,
p_Rowid IN OUT NOCOPY VARCHAR2,
p_CC_Header_Id IGC_CC_HEADER_HISTORY.CC_Header_Id%TYPE,
p_Org_id IGC_CC_HEADER_HISTORY.Org_id%TYPE,
p_CC_Type IGC_CC_HEADER_HISTORY.CC_Type%TYPE,
p_CC_Num IGC_CC_HEADER_HISTORY.CC_Num%TYPE,
p_CC_Ref_Num IGC_CC_HEADER_HISTORY.CC_Ref_Num%TYPE,
p_CC_Version_num IGC_CC_HEADER_HISTORY.CC_Version_Num%TYPE,
p_CC_Version_Action IGC_CC_HEADER_HISTORY.CC_Version_Action%TYPE,
p_CC_State IGC_CC_HEADER_HISTORY.CC_State%TYPE,
p_Parent_Header_Id IGC_CC_HEADER_HISTORY.Parent_Header_Id%TYPE,
p_CC_ctrl_status IGC_CC_HEADER_HISTORY.CC_ctrl_status%TYPE,
p_CC_Encmbrnc_Status IGC_CC_HEADER_HISTORY.CC_Encmbrnc_Status%TYPE,
p_CC_Apprvl_Status IGC_CC_HEADER_HISTORY.CC_Apprvl_Status%TYPE,
p_Vendor_Id IGC_CC_HEADER_HISTORY.Vendor_Id%TYPE,
p_Vendor_Site_Id IGC_CC_HEADER_HISTORY.Vendor_Site_Id%TYPE,
p_Vendor_Contact_Id IGC_CC_HEADER_HISTORY.Vendor_Contact_Id%TYPE,
p_Term_Id IGC_CC_HEADER_HISTORY.Term_Id%TYPE,
p_Location_Id IGC_CC_HEADER_HISTORY.Location_Id%TYPE,
p_Set_Of_Books_Id IGC_CC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
p_CC_Acct_Date IGC_CC_HEADER_HISTORY.CC_Acct_Date%TYPE,
p_CC_Desc IGC_CC_HEADER_HISTORY.CC_Desc%TYPE,
p_CC_Start_Date IGC_CC_HEADER_HISTORY.CC_Start_Date%TYPE,
p_CC_End_Date IGC_CC_HEADER_HISTORY.CC_End_Date%TYPE,
p_CC_Owner_User_Id IGC_CC_HEADER_HISTORY.CC_Owner_User_Id%TYPE,
p_CC_Preparer_User_Id IGC_CC_HEADER_HISTORY.CC_Preparer_User_Id%TYPE,
p_Currency_Code IGC_CC_HEADER_HISTORY.Currency_Code%TYPE,
p_Conversion_Type IGC_CC_HEADER_HISTORY.Conversion_Type%TYPE,
p_Conversion_Date IGC_CC_HEADER_HISTORY.Conversion_Date%TYPE,
p_Conversion_Rate IGC_CC_HEADER_HISTORY.Conversion_Rate%TYPE,
p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
p_Created_By IGC_CC_HEADER_HISTORY.Created_By%TYPE,
p_Creation_Date IGC_CC_HEADER_HISTORY.Creation_Date%TYPE,
p_Wf_Item_Type IGC_CC_HEADER_HISTORY.Wf_Item_Type%TYPE,
p_Wf_Item_Key IGC_CC_HEADER_HISTORY.Wf_Item_Key%TYPE,
p_CC_Current_User_Id IGC_CC_HEADERS.CC_Current_User_Id%TYPE,
p_Attribute1 IGC_CC_HEADER_HISTORY.Attribute1%TYPE,
p_Attribute2 IGC_CC_HEADER_HISTORY.Attribute2%TYPE,
p_Attribute3 IGC_CC_HEADER_HISTORY.Attribute3%TYPE,
p_Attribute4 IGC_CC_HEADER_HISTORY.Attribute4%TYPE,
p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
p_Attribute14 IGC_CC_HEADER_HISTORY.Attribute14%TYPE,
p_Attribute15 IGC_CC_HEADER_HISTORY.Attribute15%TYPe,
p_Context IGC_CC_HEADER_HISTORY.Context%TYPE,
p_CC_Guarantee_Flag IGC_CC_HEADER_HISTORY.CC_Guarantee_Flag%TYPE,
G_FLAG IN OUT NOCOPY VARCHAR2
) IS
l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';
SELECT Rowid
FROM IGC_CC_HEADER_HISTORY
WHERE CC_Header_id = p_CC_Header_id
AND CC_Version_Num = P_CC_Version_Num ;
SELECT Application_Id
FROM FND_APPLICATION
WHERE Application_Short_Name = 'IGC';
SAVEPOINT Insert_Row_Pvt ;
INSERT
INTO IGC_CC_HEADER_HISTORY
(CC_Header_Id,
Parent_Header_Id,
Org_Id,
CC_Type,
CC_Num,
CC_Ref_Num,
CC_Version_Num,
CC_Version_Action,
CC_State,
CC_Ctrl_Status,
CC_Encmbrnc_Status,
CC_Apprvl_Status,
Vendor_Id,
Vendor_Site_Id,
Vendor_Contact_Id,
Term_Id,
Location_Id,
Set_Of_Books_Id,
CC_Acct_Date,
CC_Desc,
CC_Start_Date,
CC_End_Date,
CC_Owner_User_Id,
CC_Preparer_User_Id,
Currency_Code,
Conversion_Type,
Conversion_Date,
Conversion_Rate,
Last_Update_Date,
Last_Updated_By,
Last_Update_Login,
Created_By,
Creation_Date,
Wf_Item_Type,
Wf_Item_Key,
CC_Current_User_Id,
Attribute1,
Attribute2,
Attribute3,
Attribute4,
Attribute5,
Attribute6,
Attribute7,
Attribute8,
Attribute9,
Attribute10,
Attribute11,
Attribute12,
Attribute13,
Attribute14,
Attribute15,
Context,
CC_Guarantee_Flag
)
VALUES
(p_CC_Header_Id,
p_Parent_Header_Id,
p_Org_id,
p_CC_Type,
p_CC_Num,
p_CC_Ref_Num,
p_CC_Version_num,
p_CC_Version_Action,
p_CC_State,
p_CC_ctrl_status,
p_CC_Encmbrnc_Status,
p_CC_Apprvl_Status,
p_Vendor_Id,
p_Vendor_Site_Id,
p_Vendor_Contact_Id,
p_Term_Id,
p_Location_Id,
p_Set_Of_Books_Id,
p_CC_Acct_Date,
p_CC_Desc,
p_CC_Start_Date,
p_CC_End_Date,
p_CC_Owner_User_Id,
p_CC_Preparer_User_Id,
p_Currency_Code,
p_Conversion_Type,
p_Conversion_Date,
p_Conversion_Rate,
p_Last_Update_Date,
p_Last_Updated_By,
p_Last_Update_Login,
p_Created_By,
p_Creation_Date,
p_Wf_Item_Type,
p_Wf_Item_Key,
p_CC_Current_User_Id,
p_Attribute1,
p_Attribute2,
p_Attribute3,
p_Attribute4,
p_Attribute5,
p_Attribute6,
p_Attribute7,
p_Attribute8,
p_Attribute9,
p_Attribute10,
p_Attribute11,
p_Attribute12,
p_Attribute13,
p_Attribute14,
p_Attribute15,
p_Context,
p_CC_Guarantee_Flag
);
ROLLBACK TO Insert_Row_Pvt ;
ROLLBACK TO Insert_Row_Pvt ;
ROLLBACK TO Insert_Row_Pvt ;
END Insert_Row;
PROCEDURE Insert_Row
===============================================================================*/
PROCEDURE Insert_Row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
X_return_status OUT NOCOPY VARCHAR2,
X_msg_count OUT NOCOPY NUMBER,
X_msg_data OUT NOCOPY VARCHAR2,
p_Rowid IN OUT NOCOPY VARCHAR2,
p_CC_Header_Id IGC_CC_HEADER_HISTORY.CC_Header_Id%TYPE,
p_Org_id IGC_CC_HEADER_HISTORY.Org_id%TYPE,
p_CC_Type IGC_CC_HEADER_HISTORY.CC_Type%TYPE,
p_CC_Num IGC_CC_HEADER_HISTORY.CC_Num%TYPE,
p_CC_Version_num IGC_CC_HEADER_HISTORY.CC_Version_Num%TYPE,
p_CC_Version_Action IGC_CC_HEADER_HISTORY.CC_Version_Action%TYPE,
p_CC_State IGC_CC_HEADER_HISTORY.CC_State%TYPE,
p_Parent_Header_Id IGC_CC_HEADER_HISTORY.Parent_Header_Id%TYPE,
p_CC_ctrl_status IGC_CC_HEADER_HISTORY.CC_ctrl_status%TYPE,
p_CC_Encmbrnc_Status IGC_CC_HEADER_HISTORY.CC_Encmbrnc_Status%TYPE,
p_CC_Apprvl_Status IGC_CC_HEADER_HISTORY.CC_Apprvl_Status%TYPE,
p_Vendor_Id IGC_CC_HEADER_HISTORY.Vendor_Id%TYPE,
p_Vendor_Site_Id IGC_CC_HEADER_HISTORY.Vendor_Site_Id%TYPE,
p_Vendor_Contact_Id IGC_CC_HEADER_HISTORY.Vendor_Contact_Id%TYPE,
p_Term_Id IGC_CC_HEADER_HISTORY.Term_Id%TYPE,
p_Location_Id IGC_CC_HEADER_HISTORY.Location_Id%TYPE,
p_Set_Of_Books_Id IGC_CC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
p_CC_Acct_Date IGC_CC_HEADER_HISTORY.CC_Acct_Date%TYPE,
p_CC_Desc IGC_CC_HEADER_HISTORY.CC_Desc%TYPE,
p_CC_Start_Date IGC_CC_HEADER_HISTORY.CC_Start_Date%TYPE,
p_CC_End_Date IGC_CC_HEADER_HISTORY.CC_End_Date%TYPE,
p_CC_Owner_User_Id IGC_CC_HEADER_HISTORY.CC_Owner_User_Id%TYPE,
p_CC_Preparer_User_Id IGC_CC_HEADER_HISTORY.CC_Preparer_User_Id%TYPE,
p_Currency_Code IGC_CC_HEADER_HISTORY.Currency_Code%TYPE,
p_Conversion_Type IGC_CC_HEADER_HISTORY.Conversion_Type%TYPE,
p_Conversion_Date IGC_CC_HEADER_HISTORY.Conversion_Date%TYPE,
p_Conversion_Rate IGC_CC_HEADER_HISTORY.Conversion_Rate%TYPE,
p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
p_Created_By IGC_CC_HEADER_HISTORY.Created_By%TYPE,
p_Creation_Date IGC_CC_HEADER_HISTORY.Creation_Date%TYPE,
p_Wf_Item_Type IGC_CC_HEADER_HISTORY.Wf_Item_Type%TYPE,
p_Wf_Item_Key IGC_CC_HEADER_HISTORY.Wf_Item_Key%TYPE,
p_CC_Current_User_Id IGC_CC_HEADERS.CC_Current_User_Id%TYPE,
p_Attribute1 IGC_CC_HEADER_HISTORY.Attribute1%TYPE,
p_Attribute2 IGC_CC_HEADER_HISTORY.Attribute2%TYPE,
p_Attribute3 IGC_CC_HEADER_HISTORY.Attribute3%TYPE,
p_Attribute4 IGC_CC_HEADER_HISTORY.Attribute4%TYPE,
p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
p_Attribute14 IGC_CC_HEADER_HISTORY.Attribute14%TYPE,
p_Attribute15 IGC_CC_HEADER_HISTORY.Attribute15%TYPe,
p_Context IGC_CC_HEADER_HISTORY.Context%TYPE,
p_CC_Guarantee_Flag IGC_CC_HEADER_HISTORY.CC_Guarantee_Flag%TYPE,
G_FLAG IN OUT NOCOPY VARCHAR2
) IS
l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';
SELECT Rowid
FROM IGC_CC_HEADER_HISTORY
WHERE CC_Header_id = p_CC_Header_id
AND CC_Version_Num = P_CC_Version_Num ;
SELECT Application_Id
FROM FND_APPLICATION
WHERE Application_Short_Name = 'IGC';
SAVEPOINT Insert_Row_Pvt ;
INSERT
INTO IGC_CC_HEADER_HISTORY
(CC_Header_Id,
Parent_Header_Id,
Org_Id,
CC_Type,
CC_Num,
CC_Version_Num,
CC_Version_Action,
CC_State,
CC_Ctrl_Status,
CC_Encmbrnc_Status,
CC_Apprvl_Status,
Vendor_Id,
Vendor_Site_Id,
Vendor_Contact_Id,
Term_Id,
Location_Id,
Set_Of_Books_Id,
CC_Acct_Date,
CC_Desc,
CC_Start_Date,
CC_End_Date,
CC_Owner_User_Id,
CC_Preparer_User_Id,
Currency_Code,
Conversion_Type,
Conversion_Date,
Conversion_Rate,
Last_Update_Date,
Last_Updated_By,
Last_Update_Login,
Created_By,
Creation_Date,
Wf_Item_Type,
Wf_Item_Key,
CC_Current_User_Id,
Attribute1,
Attribute2,
Attribute3,
Attribute4,
Attribute5,
Attribute6,
Attribute7,
Attribute8,
Attribute9,
Attribute10,
Attribute11,
Attribute12,
Attribute13,
Attribute14,
Attribute15,
Context,
CC_Guarantee_Flag
)
VALUES
(p_CC_Header_Id,
p_Parent_Header_Id,
p_Org_id,
p_CC_Type,
p_CC_Num,
p_CC_Version_num,
p_CC_Version_Action,
p_CC_State,
p_CC_ctrl_status,
p_CC_Encmbrnc_Status,
p_CC_Apprvl_Status,
p_Vendor_Id,
p_Vendor_Site_Id,
p_Vendor_Contact_Id,
p_Term_Id,
p_Location_Id,
p_Set_Of_Books_Id,
p_CC_Acct_Date,
p_CC_Desc,
p_CC_Start_Date,
p_CC_End_Date,
p_CC_Owner_User_Id,
p_CC_Preparer_User_Id,
p_Currency_Code,
p_Conversion_Type,
p_Conversion_Date,
p_Conversion_Rate,
p_Last_Update_Date,
p_Last_Updated_By,
p_Last_Update_Login,
p_Created_By,
p_Creation_Date,
p_Wf_Item_Type,
p_Wf_Item_Key,
p_CC_Current_User_Id,
p_Attribute1,
p_Attribute2,
p_Attribute3,
p_Attribute4,
p_Attribute5,
p_Attribute6,
p_Attribute7,
p_Attribute8,
p_Attribute9,
p_Attribute10,
p_Attribute11,
p_Attribute12,
p_Attribute13,
p_Attribute14,
p_Attribute15,
p_Context,
p_CC_Guarantee_Flag
);
ROLLBACK TO Insert_Row_Pvt ;
ROLLBACK TO Insert_Row_Pvt ;
ROLLBACK TO Insert_Row_Pvt ;
END Insert_Row;
p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
p_Created_By IGC_CC_HEADER_HISTORY.Created_By%TYPE,
p_Creation_Date IGC_CC_HEADER_HISTORY.Creation_Date%TYPE,
p_Wf_Item_Type IGC_CC_HEADER_HISTORY.Wf_Item_Type%TYPE,
p_Wf_Item_Key IGC_CC_HEADER_HISTORY.Wf_Item_Key%TYPE,
p_CC_Current_User_Id IGC_CC_HEADERS.CC_Current_User_Id%TYPE,
p_Attribute1 IGC_CC_HEADER_HISTORY.Attribute1%TYPE,
p_Attribute2 IGC_CC_HEADER_HISTORY.Attribute2%TYPE,
p_Attribute3 IGC_CC_HEADER_HISTORY.Attribute3%TYPE,
p_Attribute4 IGC_CC_HEADER_HISTORY.Attribute4%TYPE,
p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
p_Attribute14 IGC_CC_HEADER_HISTORY.Attribute14%TYPE,
p_Attribute15 IGC_CC_HEADER_HISTORY.Attribute15%TYPE,
p_Context IGC_CC_HEADER_HISTORY.Context%TYPE,
p_CC_Guarantee_Flag IGC_CC_HEADER_HISTORY.CC_Guarantee_Flag%TYPE,
X_row_locked OUT NOCOPY VARCHAR2,
G_FLAG IN OUT NOCOPY VARCHAR2
) IS
l_api_name CONSTANT VARCHAR2(30) := 'Lock_Row';
SELECT *
FROM IGC_CC_HEADER_HISTORY
WHERE rowid = p_Rowid
FOR UPDATE of CC_Header_Id NOWAIT;
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
PROCEDURE Update_Row Overloaded Procedure for CC_REF_NUM addition
===============================================================================*/
PROCEDURE Update_Row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
X_return_status OUT NOCOPY VARCHAR2,
X_msg_count OUT NOCOPY NUMBER,
X_msg_data OUT NOCOPY VARCHAR2,
p_Rowid IN OUT NOCOPY VARCHAR2,
p_CC_Header_Id IGC_CC_HEADER_HISTORY.CC_Header_Id%TYPE,
p_Org_id IGC_CC_HEADER_HISTORY.Org_id%TYPE,
p_CC_Type IGC_CC_HEADER_HISTORY.CC_Type%TYPE,
p_CC_Num IGC_CC_HEADER_HISTORY.CC_Num%TYPE,
p_CC_Ref_Num IGC_CC_HEADER_HISTORY.CC_Ref_Num%TYPE,
p_CC_Version_num IGC_CC_HEADER_HISTORY.CC_Version_Num%TYPE,
p_CC_Version_Action IGC_CC_HEADER_HISTORY.CC_Version_Action%TYPE,
p_CC_State IGC_CC_HEADER_HISTORY.CC_State%TYPE,
p_Parent_Header_Id IGC_CC_HEADER_HISTORY.Parent_Header_Id%TYPE,
p_CC_ctrl_status IGC_CC_HEADER_HISTORY.CC_ctrl_status%TYPE,
p_CC_Encmbrnc_Status IGC_CC_HEADER_HISTORY.CC_Encmbrnc_Status%TYPE,
p_CC_Apprvl_Status IGC_CC_HEADER_HISTORY.CC_Apprvl_Status%TYPE,
p_Vendor_Id IGC_CC_HEADER_HISTORY.Vendor_Id%TYPE,
p_Vendor_Site_Id IGC_CC_HEADER_HISTORY.Vendor_Site_Id%TYPE,
p_Vendor_Contact_Id IGC_CC_HEADER_HISTORY.Vendor_Contact_Id%TYPE,
p_Term_Id IGC_CC_HEADER_HISTORY.Term_Id%TYPE,
p_Location_Id IGC_CC_HEADER_HISTORY.Location_Id%TYPE,
p_Set_Of_Books_Id IGC_CC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
p_CC_Acct_Date IGC_CC_HEADER_HISTORY.CC_Acct_Date%TYPE,
p_CC_Desc IGC_CC_HEADER_HISTORY.CC_Desc%TYPE,
p_CC_Start_Date IGC_CC_HEADER_HISTORY.CC_Start_Date%TYPE,
p_CC_End_Date IGC_CC_HEADER_HISTORY.CC_End_Date%TYPE,
p_CC_Owner_User_Id IGC_CC_HEADER_HISTORY.CC_Owner_User_Id%TYPE,
p_CC_Preparer_User_Id IGC_CC_HEADER_HISTORY.CC_Preparer_User_Id%TYPE,
p_Currency_Code IGC_CC_HEADER_HISTORY.Currency_Code%TYPE,
p_Conversion_Type IGC_CC_HEADER_HISTORY.Conversion_Type%TYPE,
p_Conversion_Date IGC_CC_HEADER_HISTORY.Conversion_Date%TYPE,
p_Conversion_Rate IGC_CC_HEADER_HISTORY.Conversion_Rate%TYPE,
p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
p_Created_By IGC_CC_HEADER_HISTORY.Created_By%TYPE,
p_Creation_Date IGC_CC_HEADER_HISTORY.Creation_Date%TYPE,
p_Wf_Item_Type IGC_CC_HEADER_HISTORY.Wf_Item_Type%TYPE,
p_Wf_Item_Key IGC_CC_HEADER_HISTORY.Wf_Item_Key%TYPE,
p_CC_Current_User_Id IGC_CC_HEADERS.CC_Current_User_Id%TYPE,
p_Attribute1 IGC_CC_HEADER_HISTORY.Attribute1%TYPE,
p_Attribute2 IGC_CC_HEADER_HISTORY.Attribute2%TYPE,
p_Attribute3 IGC_CC_HEADER_HISTORY.Attribute3%TYPE,
p_Attribute4 IGC_CC_HEADER_HISTORY.Attribute4%TYPE,
p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
p_Attribute14 IGC_CC_HEADER_HISTORY.Attribute14%TYPE,
p_Attribute15 IGC_CC_HEADER_HISTORY.Attribute15%TYPE,
p_Context IGC_CC_HEADER_HISTORY.Context%TYPE,
p_CC_Guarantee_Flag IGC_CC_HEADER_HISTORY.CC_Guarantee_Flag%TYPE,
G_FLAG IN OUT NOCOPY VARCHAR2
) IS
l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';
SAVEPOINT Update_Row_Pvt ;
UPDATE IGC_CC_HEADER_HISTORY
SET CC_Header_Id = p_CC_Header_Id,
Parent_Header_Id = p_Parent_Header_Id,
Org_Id = p_Org_id,
CC_Type = p_CC_Type,
CC_Num = p_CC_Num,
CC_Ref_Num = p_CC_Ref_Num,
CC_Version_Num = p_CC_Version_num,
CC_Version_Action = p_CC_Version_Action,
CC_State = p_CC_State,
CC_ctrl_status = p_CC_ctrl_status ,
CC_Encmbrnc_Status = p_CC_Encmbrnc_Status,
CC_Apprvl_Status = p_CC_Apprvl_Status,
Vendor_Id = p_Vendor_Id,
Vendor_Site_Id = p_Vendor_Site_Id,
Vendor_Contact_Id = p_Vendor_Contact_Id,
Term_Id = p_Term_Id,
Location_Id = p_Location_Id,
Set_Of_Books_Id = p_Set_Of_Books_Id,
CC_Acct_Date = p_CC_Acct_Date,
CC_Desc = p_CC_Desc,
CC_Start_Date = p_CC_Start_Date,
CC_End_Date = p_CC_End_Date,
CC_Owner_User_Id = p_CC_Owner_User_Id,
CC_Preparer_User_Id = p_CC_Preparer_User_Id,
Currency_Code = p_Currency_Code,
Conversion_Type = p_Conversion_Type,
Conversion_Date = p_Conversion_Date,
Conversion_Rate = p_Conversion_Rate,
Last_Update_Date = p_Last_Update_Date,
Last_Updated_By = p_Last_Updated_By,
Last_Update_Login = p_Last_Update_Login,
Created_By = p_Created_By,
Creation_Date = p_Creation_Date,
Wf_Item_Type = p_Wf_Item_Type,
Wf_Item_Key = p_Wf_Item_Key,
CC_Current_User_Id = p_CC_Current_User_Id,
Attribute1 = p_Attribute1,
Attribute2 = p_Attribute2,
Attribute3 = p_Attribute3,
Attribute4 = p_Attribute4,
Attribute5 = p_Attribute5,
Attribute6 = p_Attribute6,
Attribute7 = p_Attribute7,
Attribute8 = p_Attribute8,
Attribute9 = p_Attribute9,
Attribute10 = p_Attribute10,
Attribute11 = p_Attribute11,
Attribute12 = p_Attribute12,
Attribute13 = p_Attribute13,
Attribute14 = p_Attribute14,
Attribute15 = p_Attribute15,
Context = p_Context,
CC_Guarantee_Flag = p_CC_Guarantee_Flag
WHERE rowid = p_Rowid;
ROLLBACK TO Update_Row_Pvt ;
ROLLBACK TO Update_Row_Pvt ;
ROLLBACK TO Update_Row_Pvt ;
END Update_Row;
PROCEDURE Update_Row
===============================================================================*/
PROCEDURE Update_Row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
X_return_status OUT NOCOPY VARCHAR2,
X_msg_count OUT NOCOPY NUMBER,
X_msg_data OUT NOCOPY VARCHAR2,
p_Rowid IN OUT NOCOPY VARCHAR2,
p_CC_Header_Id IGC_CC_HEADER_HISTORY.CC_Header_Id%TYPE,
p_Org_id IGC_CC_HEADER_HISTORY.Org_id%TYPE,
p_CC_Type IGC_CC_HEADER_HISTORY.CC_Type%TYPE,
p_CC_Num IGC_CC_HEADER_HISTORY.CC_Num%TYPE,
p_CC_Version_num IGC_CC_HEADER_HISTORY.CC_Version_Num%TYPE,
p_CC_Version_Action IGC_CC_HEADER_HISTORY.CC_Version_Action%TYPE,
p_CC_State IGC_CC_HEADER_HISTORY.CC_State%TYPE,
p_Parent_Header_Id IGC_CC_HEADER_HISTORY.Parent_Header_Id%TYPE,
p_CC_ctrl_status IGC_CC_HEADER_HISTORY.CC_ctrl_status%TYPE,
p_CC_Encmbrnc_Status IGC_CC_HEADER_HISTORY.CC_Encmbrnc_Status%TYPE,
p_CC_Apprvl_Status IGC_CC_HEADER_HISTORY.CC_Apprvl_Status%TYPE,
p_Vendor_Id IGC_CC_HEADER_HISTORY.Vendor_Id%TYPE,
p_Vendor_Site_Id IGC_CC_HEADER_HISTORY.Vendor_Site_Id%TYPE,
p_Vendor_Contact_Id IGC_CC_HEADER_HISTORY.Vendor_Contact_Id%TYPE,
p_Term_Id IGC_CC_HEADER_HISTORY.Term_Id%TYPE,
p_Location_Id IGC_CC_HEADER_HISTORY.Location_Id%TYPE,
p_Set_Of_Books_Id IGC_CC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
p_CC_Acct_Date IGC_CC_HEADER_HISTORY.CC_Acct_Date%TYPE,
p_CC_Desc IGC_CC_HEADER_HISTORY.CC_Desc%TYPE,
p_CC_Start_Date IGC_CC_HEADER_HISTORY.CC_Start_Date%TYPE,
p_CC_End_Date IGC_CC_HEADER_HISTORY.CC_End_Date%TYPE,
p_CC_Owner_User_Id IGC_CC_HEADER_HISTORY.CC_Owner_User_Id%TYPE,
p_CC_Preparer_User_Id IGC_CC_HEADER_HISTORY.CC_Preparer_User_Id%TYPE,
p_Currency_Code IGC_CC_HEADER_HISTORY.Currency_Code%TYPE,
p_Conversion_Type IGC_CC_HEADER_HISTORY.Conversion_Type%TYPE,
p_Conversion_Date IGC_CC_HEADER_HISTORY.Conversion_Date%TYPE,
p_Conversion_Rate IGC_CC_HEADER_HISTORY.Conversion_Rate%TYPE,
p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
p_Created_By IGC_CC_HEADER_HISTORY.Created_By%TYPE,
p_Creation_Date IGC_CC_HEADER_HISTORY.Creation_Date%TYPE,
p_Wf_Item_Type IGC_CC_HEADER_HISTORY.Wf_Item_Type%TYPE,
p_Wf_Item_Key IGC_CC_HEADER_HISTORY.Wf_Item_Key%TYPE,
p_CC_Current_User_Id IGC_CC_HEADERS.CC_Current_User_Id%TYPE,
p_Attribute1 IGC_CC_HEADER_HISTORY.Attribute1%TYPE,
p_Attribute2 IGC_CC_HEADER_HISTORY.Attribute2%TYPE,
p_Attribute3 IGC_CC_HEADER_HISTORY.Attribute3%TYPE,
p_Attribute4 IGC_CC_HEADER_HISTORY.Attribute4%TYPE,
p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
p_Attribute14 IGC_CC_HEADER_HISTORY.Attribute14%TYPE,
p_Attribute15 IGC_CC_HEADER_HISTORY.Attribute15%TYPE,
p_Context IGC_CC_HEADER_HISTORY.Context%TYPE,
p_CC_Guarantee_Flag IGC_CC_HEADER_HISTORY.CC_Guarantee_Flag%TYPE,
G_FLAG IN OUT NOCOPY VARCHAR2
) IS
l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';
SAVEPOINT Update_Row_Pvt ;
UPDATE IGC_CC_HEADER_HISTORY
SET CC_Header_Id = p_CC_Header_Id,
Parent_Header_Id = p_Parent_Header_Id,
Org_Id = p_Org_id,
CC_Type = p_CC_Type,
CC_Num = p_CC_Num,
CC_Version_Num = p_CC_Version_num,
CC_Version_Action = p_CC_Version_Action,
CC_State = p_CC_State,
CC_ctrl_status = p_CC_ctrl_status ,
CC_Encmbrnc_Status = p_CC_Encmbrnc_Status,
CC_Apprvl_Status = p_CC_Apprvl_Status,
Vendor_Id = p_Vendor_Id,
Vendor_Site_Id = p_Vendor_Site_Id,
Vendor_Contact_Id = p_Vendor_Contact_Id,
Term_Id = p_Term_Id,
Location_Id = p_Location_Id,
Set_Of_Books_Id = p_Set_Of_Books_Id,
CC_Acct_Date = p_CC_Acct_Date,
CC_Desc = p_CC_Desc,
CC_Start_Date = p_CC_Start_Date,
CC_End_Date = p_CC_End_Date,
CC_Owner_User_Id = p_CC_Owner_User_Id,
CC_Preparer_User_Id = p_CC_Preparer_User_Id,
Currency_Code = p_Currency_Code,
Conversion_Type = p_Conversion_Type,
Conversion_Date = p_Conversion_Date,
Conversion_Rate = p_Conversion_Rate,
Last_Update_Date = p_Last_Update_Date,
Last_Updated_By = p_Last_Updated_By,
Last_Update_Login = p_Last_Update_Login,
Created_By = p_Created_By,
Creation_Date = p_Creation_Date,
Wf_Item_Type = p_Wf_Item_Type,
Wf_Item_Key = p_Wf_Item_Key,
CC_Current_User_Id = p_CC_Current_User_Id,
Attribute1 = p_Attribute1,
Attribute2 = p_Attribute2,
Attribute3 = p_Attribute3,
Attribute4 = p_Attribute4,
Attribute5 = p_Attribute5,
Attribute6 = p_Attribute6,
Attribute7 = p_Attribute7,
Attribute8 = p_Attribute8,
Attribute9 = p_Attribute9,
Attribute10 = p_Attribute10,
Attribute11 = p_Attribute11,
Attribute12 = p_Attribute12,
Attribute13 = p_Attribute13,
Attribute14 = p_Attribute14,
Attribute15 = p_Attribute15,
Context = p_Context,
CC_Guarantee_Flag = p_CC_Guarantee_Flag
WHERE rowid = p_Rowid;
ROLLBACK TO Update_Row_Pvt ;
ROLLBACK TO Update_Row_Pvt ;
ROLLBACK TO Update_Row_Pvt ;
END Update_Row;
PROCEDURE Delete_Row
===============================================================================*/
PROCEDURE Delete_Row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
X_return_status OUT NOCOPY VARCHAR2,
X_msg_count OUT NOCOPY NUMBER,
X_msg_data OUT NOCOPY VARCHAR2,
p_Rowid VARCHAR2,
G_FLAG IN OUT NOCOPY VARCHAR2
) IS
l_api_name CONSTANT VARCHAR2(30) := 'Delete_Row';
SAVEPOINT Delete_Row_Pvt ;
DELETE
FROM IGC_CC_HEADER_HISTORY
WHERE rowid = p_Rowid;
ROLLBACK TO Delete_Row_Pvt ;
ROLLBACK TO Delete_Row_Pvt ;
ROLLBACK TO Delete_Row_Pvt ;
END Delete_Row;