The following lines contain the word 'select', 'insert', 'update' or 'delete':
CSP_MOVEORDER_HEADERS_PKG.Insert_Row(
p_HEADER_ID => p_MOH_rec.HEADER_ID,
p_CREATED_BY => p_MOH_rec.created_by,
p_CREATION_DATE => p_MOH_rec.creation_date,
p_LAST_UPDATED_BY => p_MOH_rec.last_updated_by,
p_LAST_UPDATE_DATE => p_MOH_rec.last_update_date,
p_LAST_UPDATE_LOGIN => p_MOH_rec.last_update_login,
p_CARRIER => p_MOH_rec.CARRIER,
p_SHIPMENT_METHOD => p_MOH_rec.SHIPMENT_METHOD,
p_AUTORECEIPT_FLAG => p_MOH_rec.AUTORECEIPT_FLAG,
p_ATTRIBUTE_CATEGORY => p_MOH_rec.ATTRIBUTE_CATEGORY,
p_ATTRIBUTE1 => p_MOH_rec.ATTRIBUTE1,
p_ATTRIBUTE2 => p_MOH_rec.ATTRIBUTE2,
p_ATTRIBUTE3 => p_MOH_rec.ATTRIBUTE3,
p_ATTRIBUTE4 => p_MOH_rec.ATTRIBUTE4,
p_ATTRIBUTE5 => p_MOH_rec.ATTRIBUTE5,
p_ATTRIBUTE6 => p_MOH_rec.ATTRIBUTE6,
p_ATTRIBUTE7 => p_MOH_rec.ATTRIBUTE7,
p_ATTRIBUTE8 => p_MOH_rec.ATTRIBUTE8,
p_ATTRIBUTE9 => p_MOH_rec.ATTRIBUTE9,
p_ATTRIBUTE10 => p_MOH_rec.ATTRIBUTE10,
p_ATTRIBUTE11 => p_MOH_rec.ATTRIBUTE11,
p_ATTRIBUTE12 => p_MOH_rec.ATTRIBUTE12,
p_ATTRIBUTE13 => p_MOH_rec.ATTRIBUTE13,
p_ATTRIBUTE14 => p_MOH_rec.ATTRIBUTE14,
p_ATTRIBUTE15 => p_MOH_rec.ATTRIBUTE15,
P_LOCATION_ID => P_MOH_REC.LOCATION_ID,
p_PARTY_SITE_ID => P_MOH_REC.PARTY_SITE_ID
);
PROCEDURE Update_orderheaders(
P_Api_Version_Number 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,
P_Identity_Salesforce_Id IN NUMBER := NULL,
P_MOH_Rec IN MOH_Rec_Type,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2
)
IS
/*
Cursor C_Get_orderheaders(HEADER_ID Number) IS
Select rowid,
HEADER_ID,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
LOCATION_ID,
CARRIER,
SHIPMENT_METHOD,
AUTORECEIPT_FLAG,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
ADDRESS1,
ADDRESS2,
ADDRESS3,
ADDRESS4,
CITY,
POSTAL_CODE,
STATE,
PROVINCE,
COUNTRY
From CSP_MOVEORDER_HEADERS
-- Hint: Developer need to provide Where clause
For Update NOWAIT;
l_api_name CONSTANT VARCHAR2(30) := 'Update_orderheaders';
SAVEPOINT UPDATE_ORDERHEADERS_PVT;
AS_CALLOUT_PKG.Update_orderheaders_BU(
p_api_version_number => 2.0,
p_init_msg_list => FND_API.G_FALSE,
p_commit => FND_API.G_FALSE,
p_validation_level => p_validation_level,
p_identity_salesforce_id => p_identity_salesforce_id,
P_MOH_Rec => P_MOH_Rec,
-- Hint: Add detail tables as parameter lists if it's master-detail relationship.
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: - Open Cursor to Select');
l_ref_MOH_rec.LAST_UPDATED_BY,
l_ref_MOH_rec.LAST_UPDATE_DATE,
l_ref_MOH_rec.LAST_UPDATE_LOGIN,
l_ref_MOH_rec.LOCATION_ID,
l_ref_MOH_rec.CARRIER,
l_ref_MOH_rec.SHIPMENT_METHOD,
l_ref_MOH_rec.AUTORECEIPT_FLAG,
l_ref_MOH_rec.ATTRIBUTE_CATEGORY,
l_ref_MOH_rec.ATTRIBUTE1,
l_ref_MOH_rec.ATTRIBUTE2,
l_ref_MOH_rec.ATTRIBUTE3,
l_ref_MOH_rec.ATTRIBUTE4,
l_ref_MOH_rec.ATTRIBUTE5,
l_ref_MOH_rec.ATTRIBUTE6,
l_ref_MOH_rec.ATTRIBUTE7,
l_ref_MOH_rec.ATTRIBUTE8,
l_ref_MOH_rec.ATTRIBUTE9,
l_ref_MOH_rec.ATTRIBUTE10,
l_ref_MOH_rec.ATTRIBUTE11,
l_ref_MOH_rec.ATTRIBUTE12,
l_ref_MOH_rec.ATTRIBUTE13,
l_ref_MOH_rec.ATTRIBUTE14,
l_ref_MOH_rec.ATTRIBUTE15,
l_ref_MOH_rec.ADDRESS1,
l_ref_MOH_rec.ADDRESS2,
l_ref_MOH_rec.ADDRESS3,
l_ref_MOH_rec.ADDRESS4,
l_ref_MOH_rec.CITY,
l_ref_MOH_rec.POSTAL_CODE,
l_ref_MOH_rec.STATE,
l_ref_MOH_rec.PROVINCE,
l_ref_MOH_rec.COUNTRY;
FND_MESSAGE.Set_Name('CSP', 'API_MISSING_UPDATE_TARGET');
If (l_tar_MOH_rec.last_update_date is NULL or
l_tar_MOH_rec.last_update_date = FND_API.G_MISS_Date ) Then
IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
THEN
FND_MESSAGE.Set_Name('CSP', 'API_MISSING_ID');
FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
If (l_tar_MOH_rec.last_update_date <> l_ref_MOH_rec.last_update_date) Then
IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
THEN
FND_MESSAGE.Set_Name('CSP', 'API_RECORD_CHANGED');
p_validation_mode => JTF_PLSQL_API.G_UPDATE,
P_MOH_Rec => P_MOH_Rec,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Calling update table handler');
CSP_MOVEORDER_HEADERS_PKG.Update_Row(
p_HEADER_ID => p_MOH_rec.HEADER_ID,
p_CREATED_BY => p_MOH_rec.created_by,
p_CREATION_DATE => p_MOH_rec.creation_date,
p_LAST_UPDATED_BY => p_MOH_rec.LAST_UPDATED_BY,
p_LAST_UPDATE_DATE => SYSDATE,
p_LAST_UPDATE_LOGIN => p_MOH_rec.LAST_UPDATE_LOGIN,
p_CARRIER => p_MOH_rec.CARRIER,
p_SHIPMENT_METHOD => p_MOH_rec.SHIPMENT_METHOD,
p_AUTORECEIPT_FLAG => p_MOH_rec.AUTORECEIPT_FLAG,
p_ATTRIBUTE_CATEGORY => p_MOH_rec.ATTRIBUTE_CATEGORY,
p_ATTRIBUTE1 => p_MOH_rec.ATTRIBUTE1,
p_ATTRIBUTE2 => p_MOH_rec.ATTRIBUTE2,
p_ATTRIBUTE3 => p_MOH_rec.ATTRIBUTE3,
p_ATTRIBUTE4 => p_MOH_rec.ATTRIBUTE4,
p_ATTRIBUTE5 => p_MOH_rec.ATTRIBUTE5,
p_ATTRIBUTE6 => p_MOH_rec.ATTRIBUTE6,
p_ATTRIBUTE7 => p_MOH_rec.ATTRIBUTE7,
p_ATTRIBUTE8 => p_MOH_rec.ATTRIBUTE8,
p_ATTRIBUTE9 => p_MOH_rec.ATTRIBUTE9,
p_ATTRIBUTE10 => p_MOH_rec.ATTRIBUTE10,
p_ATTRIBUTE11 => p_MOH_rec.ATTRIBUTE11,
p_ATTRIBUTE12 => p_MOH_rec.ATTRIBUTE12,
p_ATTRIBUTE13 => p_MOH_rec.ATTRIBUTE13,
p_ATTRIBUTE14 => p_MOH_rec.ATTRIBUTE14,
p_ATTRIBUTE15 => p_MOH_rec.ATTRIBUTE15,
P_LOCATION_ID => P_MOH_REC.LOCATION_ID,
p_PARTY_SITE_ID => P_MOH_REC.PARTY_SITE_ID
/*
p_ADDRESS1 => p_MOH_rec.ADDRESS1,
p_ADDRESS2 => p_MOH_rec.ADDRESS2,
p_ADDRESS3 => p_MOH_rec.ADDRESS3,
p_ADDRESS4 => p_MOH_rec.ADDRESS4,
p_CITY => p_MOH_rec.CITY,
p_POSTAL_CODE => p_MOH_rec.POSTAL_CODE,
p_STATE => p_MOH_rec.STATE,
p_PROVINCE => p_MOH_rec.PROVINCE,
p_COUNTRY => p_MOH_rec.COUNTRY */
);
AS_CALLOUT_PKG.Update_orderheaders_AU(
p_api_version_number => 2.0,
p_init_msg_list => FND_API.G_FALSE,
p_commit => FND_API.G_FALSE,
p_validation_level => p_validation_level,
p_identity_salesforce_id => p_identity_salesforce_id,
P_MOH_Rec => P_MOH_Rec,
-- Hint: Add detail tables as parameter lists if it's master-detail relationship.
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
End Update_orderheaders;
PROCEDURE Delete_orderheaders(
P_Api_Version_Number 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,
P_identity_salesforce_id IN NUMBER := NULL,
P_MOH_Rec IN MOH_Rec_Type,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'Delete_orderheaders';
SAVEPOINT DELETE_ORDERHEADERS_PVT;
AS_CALLOUT_PKG.Delete_orderheaders_BD(
p_api_version_number => 2.0,
p_init_msg_list => FND_API.G_FALSE,
p_commit => FND_API.G_FALSE,
p_validation_level => p_validation_level,
p_identity_salesforce_id => p_identity_salesforce_id,
P_MOH_Rec => P_MOH_Rec,
-- Hint: Add detail tables as parameter lists if it's master-detail relationship.
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Calling delete table handler');
CSP_MOVEORDER_HEADERS_PKG.Delete_Row(
p_HEADER_ID => p_MOH_rec.HEADER_ID);
AS_CALLOUT_PKG.Delete_orderheaders_AD(
p_api_version_number => 2.0,
p_init_msg_list => FND_API.G_FALSE,
p_commit => FND_API.G_FALSE,
p_validation_level => p_validation_level,
p_identity_salesforce_id => p_identity_salesforce_id,
P_MOH_Rec => P_MOH_Rec,
-- Hint: Add detail tables as parameter lists if it's master-detail relationship.
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
End Delete_orderheaders;
PROCEDURE Gen_Select(
x_select_cl OUT NOCOPY VARCHAR2
)
IS
BEGIN
-- Debug Message
JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Select Begins');
x_select_cl := 'Select ' ||
'CSP_MOVEORDER_HEADERS_V.HEADER_ID,' ||
'CSP_MOVEORDER_HEADERS_V.CREATED_BY,' ||
'CSP_MOVEORDER_HEADERS_V.CREATION_DATE,' ||
'CSP_MOVEORDER_HEADERS_V.LAST_UPDATED_BY,' ||
'CSP_MOVEORDER_HEADERS_V.LAST_UPDATE_DATE,' ||
'CSP_MOVEORDER_HEADERS_V.LAST_UPDATE_LOGIN,' ||
'CSP_MOVEORDER_HEADERS_V.LOCATION_ID,' ||
'CSP_MOVEORDER_HEADERS_V.CARRIER,' ||
'CSP_MOVEORDER_HEADERS_V.SHIPMENT_METHOD,' ||
'CSP_MOVEORDER_HEADERS_V.AUTORECEIPT_FLAG,' ||
'CSP_MOVEORDER_HEADERS_V.ATTRIBUTE_CATEGORY,' ||
/* 'CSP_MOVEORDER_HEADERS_V.ADDRESS1,' ||
'CSP_MOVEORDER_HEADERS_V.ADDRESS2,' ||
'CSP_MOVEORDER_HEADERS_V.ADDRESS3,' ||
'CSP_MOVEORDER_HEADERS_V.ADDRESS4,' ||
'CSP_MOVEORDER_HEADERS_V.CITY,' ||
'CSP_MOVEORDER_HEADERS_V.POSTAL_CODE,' ||
'CSP_MOVEORDER_HEADERS_V.STATE,' ||
'CSP_MOVEORDER_HEADERS_V.PROVINCE,' ||
'CSP_MOVEORDER_HEADERS_V.COUNTRY,' || */
'from CSP_MOVEORDER_HEADERS_V';
JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Select Ends');
END Gen_Select;
SELECT INSTR(p_rec_item, '%', 1, 1)
FROM DUAL;
SELECT INSTR(p_rec_item, '_', 1, 1)
FROM DUAL;
select header_id into l_check_header_id
from mtl_txn_request_headers
where header_id = p_header_id;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_HEADER_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
select header_id into l_check_header_id
from mtl_txn_request_headers
where header_id = p_header_id;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_LOCATION_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_CARRIER <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_SHIPMENT_METHOD <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_AUTORECEIPT_FLAG <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_ADDRESS1 <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_ADDRESS2 <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_ADDRESS3 <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_ADDRESS4 <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_CITY <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_POSTAL_CODE <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_STATE <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_PROVINCE <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_COUNTRY <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;