The following lines contain the word 'select', 'insert', 'update' or 'delete':
P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE,
P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE,
P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE,
P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE,
P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE,
P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE,
P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE,
P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE,
P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE,
P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE,
P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE,
P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE,
P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE,
P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE,
P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE,
P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE,
X_RETURN_STATUS OUT NOCOPY VARCHAR2,
X_MSG_COUNT OUT NOCOPY NUMBER,
X_MSG_DATA OUT NOCOPY VARCHAR2,
X_SALESREP_ID OUT NOCOPY JTF_RS_SALESREPS.SALESREP_ID%TYPE
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'CREATE_SALESREP';
l_wh_update_date jtf_rs_salesreps.wh_update_date%type := p_wh_update_date;
SELECT category,source_id
FROM jtf_rs_resource_extns
WHERE resource_id = l_resource_id;
SELECT 'Y'
FROM jtf_rs_salesreps
WHERE rowid = l_rowid;
SELECT 'X'
FROM jtf_rs_salesreps
WHERE salesrep_id = l_salesrep_id
AND nvl(org_id,-99) = nvl(l_org_id,-99);
SELECT 'Y'
FROM jtf_rs_salesreps
WHERE resource_id = l_resource_id
AND nvl(org_id,-99) = nvl(l_org_id,-99);
p_wh_update_date => l_wh_update_date,
p_sales_tax_geocode => l_sales_tax_geocode,
p_sales_tax_inside_city_limits => l_sales_tax_inside_city_limits,
x_return_status => x_return_status);
p_wh_update_date => l_wh_update_date,
p_sales_tax_geocode => l_sales_tax_geocode,
p_sales_tax_inside_city_limits => l_sales_tax_inside_city_limits,
x_return_status => x_return_status);
p_wh_update_date => l_wh_update_date,
p_sales_tax_geocode => l_sales_tax_geocode,
p_sales_tax_inside_city_limits => l_sales_tax_inside_city_limits,
x_return_status => x_return_status);
SELECT jtf_rs_salesreps_s.nextval
INTO l_salesrep_id
FROM dual;
/* Calling table handler to insert salesrep */
jtf_rs_salesreps_pkg.insert_row(
X_ROWID => l_rowid,
X_SALESREP_ID => l_salesrep_id,
X_RESOURCE_ID => l_resource_id,
X_SALES_CREDIT_TYPE_ID => l_sales_credit_type_id,
X_NAME => l_name,
X_STATUS => l_status,
X_START_DATE_ACTIVE => l_start_date_active,
X_END_DATE_ACTIVE => l_end_date_active,
X_ORG_ID => l_org_id,
X_GL_ID_REV => l_gl_id_rev,
X_GL_ID_FREIGHT => l_gl_id_freight,
X_GL_ID_REC => l_gl_id_rec,
X_SET_OF_BOOKS_ID => l_set_of_books_id,
X_SALESREP_NUMBER => l_salesrep_number,
X_EMAIL_ADDRESS => l_email_address,
X_WH_UPDATE_DATE => l_wh_update_date,
X_PERSON_ID => l_person_id,
X_SALES_TAX_GEOCODE => l_sales_tax_geocode,
X_SALES_TAX_INSIDE_CITY_LIMITS => l_sales_tax_inside_city_limits,
X_ATTRIBUTE_CATEGORY => p_attribute_category,
X_ATTRIBUTE2 => p_attribute2,
X_ATTRIBUTE3 => p_attribute3,
X_ATTRIBUTE4 => p_attribute4,
X_ATTRIBUTE5 => p_attribute5,
X_ATTRIBUTE6 => p_attribute6,
X_ATTRIBUTE7 => p_attribute7,
X_ATTRIBUTE8 => p_attribute8,
X_ATTRIBUTE9 => p_attribute9,
X_ATTRIBUTE10 => p_attribute10,
X_ATTRIBUTE11 => p_attribute11,
X_ATTRIBUTE12 => p_attribute12,
X_ATTRIBUTE13 => p_attribute13,
X_ATTRIBUTE14 => p_attribute14,
X_ATTRIBUTE15 => p_attribute15,
X_ATTRIBUTE1 => p_attribute1,
X_CREATION_DATE => SYSDATE,
X_CREATED_BY => jtf_resource_utl.created_by,
X_LAST_UPDATE_DATE => SYSDATE,
X_LAST_UPDATED_BY => jtf_resource_utl.updated_by,
X_LAST_UPDATE_LOGIN => jtf_resource_utl.login_id
);
p_wh_update_date => l_wh_update_date,
p_sales_tax_geocode => l_sales_tax_geocode,
p_sales_tax_inside_city_limits => l_sales_tax_inside_city_limits,
x_return_status => x_return_status);
p_wh_update_date => l_wh_update_date,
p_sales_tax_geocode => l_sales_tax_geocode,
p_sales_tax_inside_city_limits => l_sales_tax_inside_city_limits,
x_return_status => x_return_status);
p_wh_update_date => l_wh_update_date,
p_sales_tax_geocode => l_sales_tax_geocode,
p_sales_tax_inside_city_limits => l_sales_tax_inside_city_limits,
x_return_status => x_return_status);
P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE,
P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE,
P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE,
P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE,
P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE,
P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE,
P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE,
P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE,
P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE,
P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE,
P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE,
P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE,
P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE,
P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE,
P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE,
P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE,
P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
X_RETURN_STATUS OUT NOCOPY VARCHAR2,
X_MSG_COUNT OUT NOCOPY NUMBER,
X_MSG_DATA OUT NOCOPY VARCHAR2,
X_SALESREP_ID OUT NOCOPY JTF_RS_SALESREPS.SALESREP_ID%TYPE
) IS
BEGIN
G_SRP_ID_PVT_FLAG := 'N';
P_WH_UPDATE_DATE => P_WH_UPDATE_DATE,
P_SALES_TAX_GEOCODE => P_SALES_TAX_GEOCODE,
P_SALES_TAX_INSIDE_CITY_LIMITS => P_SALES_TAX_INSIDE_CITY_LIMITS ,
P_ATTRIBUTE_CATEGORY => P_ATTRIBUTE_CATEGORY ,
P_ATTRIBUTE1 => P_ATTRIBUTE1,
P_ATTRIBUTE2 => P_ATTRIBUTE2,
P_ATTRIBUTE3 => P_ATTRIBUTE3,
P_ATTRIBUTE4 => P_ATTRIBUTE4,
P_ATTRIBUTE5 => P_ATTRIBUTE5,
P_ATTRIBUTE6 => P_ATTRIBUTE6,
P_ATTRIBUTE7 => P_ATTRIBUTE7,
P_ATTRIBUTE8 => P_ATTRIBUTE8,
P_ATTRIBUTE9 => P_ATTRIBUTE9,
P_ATTRIBUTE10 => P_ATTRIBUTE10,
P_ATTRIBUTE11 => P_ATTRIBUTE11,
P_ATTRIBUTE12 => P_ATTRIBUTE12,
P_ATTRIBUTE13 => P_ATTRIBUTE13,
P_ATTRIBUTE14 => P_ATTRIBUTE14,
P_ATTRIBUTE15 => P_ATTRIBUTE15,
X_RETURN_STATUS => X_RETURN_STATUS,
X_MSG_COUNT => X_MSG_COUNT,
X_MSG_DATA => X_MSG_DATA,
X_SALESREP_ID => X_SALESREP_ID
);
PROCEDURE Update_salesrep(
P_API_VERSION IN NUMBER,
P_INIT_MSG_LIST IN VARCHAR2,
P_COMMIT IN VARCHAR2,
P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SALESREPS.OBJECT_VERSION_NUMBER%TYPE,
P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE,
P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE,
P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE,
P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE,
P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE,
P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE,
P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE,
P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE,
P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE,
P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE,
P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE,
P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE,
P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE,
P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE,
P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE,
P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%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) := 'UPDATE_SALESREP';
l_wh_update_date jtf_rs_salesreps.wh_update_date%type := p_wh_update_date;
CURSOR c_salesrep_update(l_salesrep_id jtf_rs_salesreps.salesrep_id%type, l_org_id jtf_rs_salesreps.org_id%type) is
SELECT salesrep_id,
resource_id,
DECODE(p_sales_credit_type_id,fnd_api.g_miss_num,sales_credit_type_id,p_sales_credit_type_id) sales_credit_type_id,
DECODE(p_name,fnd_api.g_miss_char,name,p_name) name,
DECODE(p_status,fnd_api.g_miss_char,status,p_status) status,
DECODE(p_start_date_active,fnd_api.g_miss_date,start_date_active,p_start_date_active) start_date_active,
DECODE(p_end_date_active,fnd_api.g_miss_date,end_date_active,p_end_date_active) end_date_active,
DECODE(p_gl_id_rev,fnd_api.g_miss_num,gl_id_rev,p_gl_id_rev) gl_id_rev,
DECODE(p_gl_id_freight,fnd_api.g_miss_num,gl_id_freight,p_gl_id_freight) gl_id_freight,
DECODE(p_gl_id_rec,fnd_api.g_miss_num,gl_id_rec,p_gl_id_rec) gl_id_rec,
DECODE(p_set_of_books_id,fnd_api.g_miss_num,set_of_books_id,p_set_of_books_id) set_of_books_id,
DECODE(p_salesrep_number,fnd_api.g_miss_char,salesrep_number,p_salesrep_number) salesrep_number,
DECODE(p_email_address,fnd_api.g_miss_char,email_address,p_email_address) email_address,
DECODE(p_wh_update_date,fnd_api.g_miss_date,wh_update_date,p_wh_update_date) wh_update_date,
person_id,
DECODE(p_sales_tax_geocode,fnd_api.g_miss_char,sales_tax_geocode,p_sales_tax_geocode) sales_tax_geocode,
DECODE(p_sales_tax_inside_city_limits,fnd_api.g_miss_char,sales_tax_inside_city_limits,p_sales_tax_inside_city_limits) sales_tax_inside_city_limits,
org_id,
DECODE(p_object_version_number,fnd_api.g_miss_char,object_version_number,p_object_version_number) object_version_number,
DECODE(p_attribute_category,fnd_api.g_miss_char,attribute_category,p_attribute_category) attribute_category,
DECODE(p_attribute1,fnd_api.g_miss_char,attribute1,p_attribute1) attribute1,
DECODE(p_attribute2,fnd_api.g_miss_char,attribute2,p_attribute2) attribute2,
DECODE(p_attribute3,fnd_api.g_miss_char,attribute3,p_attribute3) attribute3,
DECODE(p_attribute4,fnd_api.g_miss_char,attribute4,p_attribute4) attribute4,
DECODE(p_attribute5,fnd_api.g_miss_char,attribute5,p_attribute5) attribute5,
DECODE(p_attribute6,fnd_api.g_miss_char,attribute6,p_attribute6) attribute6,
DECODE(p_attribute7,fnd_api.g_miss_char,attribute7,p_attribute7) attribute7,
DECODE(p_attribute8,fnd_api.g_miss_char,attribute8,p_attribute8) attribute8,
DECODE(p_attribute9,fnd_api.g_miss_char,attribute9,p_attribute9) attribute9,
DECODE(p_attribute10,fnd_api.g_miss_char,attribute10,p_attribute10) attribute10,
DECODE(p_attribute11,fnd_api.g_miss_char,attribute11,p_attribute11) attribute11,
DECODE(p_attribute12,fnd_api.g_miss_char,attribute12,p_attribute12) attribute12,
DECODE(p_attribute13,fnd_api.g_miss_char,attribute13,p_attribute13) attribute13,
DECODE(p_attribute14,fnd_api.g_miss_char,attribute14,p_attribute14) attribute14,
DECODE(p_attribute15,fnd_api.g_miss_char,attribute15,p_attribute15) attribute15
FROM jtf_rs_salesreps
WHERE salesrep_id = l_salesrep_id
AND nvl(org_id,-99) = nvl(l_org_id,-99);
salesrep_rec c_salesrep_update%ROWTYPE;
SELECT 'X'
FROM jtf_rs_salesreps
WHERE salesrep_number = l_salesrep_number
AND nvl(org_id,-99) = nvl(l_org_id,-99)
AND salesrep_id <> p_salesrep_id;
SAVEPOINT update_salesrep_pvt;
'UPDATE_SALESREP',
'B',
'C')
THEN
jtf_rs_salesreps_cuhk.update_salesrep_pre(
p_salesrep_id => l_salesrep_id,
p_sales_credit_type_id => l_sales_credit_type_id,
p_name => l_name,
p_status => l_status,
p_start_date_active => l_start_date_active,
p_end_date_active => l_end_date_active,
p_gl_id_rev => l_gl_id_rev,
p_gl_id_freight => l_gl_id_freight,
p_gl_id_rec => l_gl_id_rec,
p_set_of_books_id => l_set_of_books_id,
p_salesrep_number => l_salesrep_number,
p_email_address => l_email_address,
p_wh_update_date => l_wh_update_date,
p_sales_tax_geocode => l_sales_tax_geocode,
p_sales_tax_inside_city_limits => l_sales_tax_inside_city_limits,
x_return_status => x_return_status);
'UPDATE_SALESREP',
'B',
'V')
THEN
jtf_rs_salesreps_vuhk.update_salesrep_pre(
p_salesrep_id => l_salesrep_id,
p_sales_credit_type_id => l_sales_credit_type_id,
p_name => l_name,
p_status => l_status,
p_start_date_active => l_start_date_active,
p_end_date_active => l_end_date_active,
p_gl_id_rev => l_gl_id_rev,
p_gl_id_freight => l_gl_id_freight,
p_gl_id_rec => l_gl_id_rec,
p_set_of_books_id => l_set_of_books_id,
p_salesrep_number => l_salesrep_number,
p_email_address => l_email_address,
p_wh_update_date => l_wh_update_date,
p_sales_tax_geocode => l_sales_tax_geocode,
p_sales_tax_inside_city_limits => l_sales_tax_inside_city_limits,
x_return_status => x_return_status);
'UPDATE_SALESREP',
'B',
'I')
THEN
jtf_rs_salesreps_iuhk.update_salesrep_pre(
p_salesrep_id => l_salesrep_id,
p_sales_credit_type_id => l_sales_credit_type_id,
p_name => l_name,
p_status => l_status,
p_start_date_active => l_start_date_active,
p_end_date_active => l_end_date_active,
p_gl_id_rev => l_gl_id_rev,
p_gl_id_freight => l_gl_id_freight,
p_gl_id_rec => l_gl_id_rec,
p_set_of_books_id => l_set_of_books_id,
p_salesrep_number => l_salesrep_number,
p_email_address => l_email_address,
p_wh_update_date => l_wh_update_date,
p_sales_tax_geocode => l_sales_tax_geocode,
p_sales_tax_inside_city_limits => l_sales_tax_inside_city_limits,
x_return_status => x_return_status);
OPEN c_salesrep_update(l_salesrep_id,l_org_id);
FETCH c_salesrep_update INTO salesrep_rec;
IF c_salesrep_update%NOTFOUND THEN
CLOSE c_salesrep_update;
/* Record is being updated, check that salesrep number does not already exist, for any other salesrep Id */
IF (l_salesrep_number IS NOT NULL) THEN
OPEN c_salesrep_number;
/* Invoke table handler to insert into JTF_RS__SALESREPS */
jtf_rs_salesreps_pkg.update_row(
X_SALESREP_ID => l_salesrep_id,
X_RESOURCE_ID => salesrep_rec.resource_id,
X_SALES_CREDIT_TYPE_ID => salesrep_rec.sales_credit_type_id,
X_NAME => salesrep_rec.name,
X_STATUS => salesrep_rec.status,
X_START_DATE_ACTIVE => salesrep_rec.start_date_active,
X_END_DATE_ACTIVE => salesrep_rec.end_date_active,
X_GL_ID_REV => salesrep_rec.gl_id_rev,
X_GL_ID_FREIGHT => salesrep_rec.gl_id_freight,
X_GL_ID_REC => salesrep_rec.gl_id_rec,
X_SET_OF_BOOKS_ID => salesrep_rec.set_of_books_id,
X_SALESREP_NUMBER => salesrep_rec.salesrep_number,
X_EMAIL_ADDRESS => salesrep_rec.email_address,
X_WH_UPDATE_DATE => salesrep_rec.wh_update_date,
X_PERSON_ID => salesrep_rec.person_id,
X_SALES_TAX_GEOCODE => salesrep_rec.sales_tax_geocode,
X_SALES_TAX_INSIDE_CITY_LIMITS => salesrep_rec.sales_tax_inside_city_limits,
X_ORG_ID => l_org_id,
X_OBJECT_VERSION_NUMBER => l_object_version_number,
X_ATTRIBUTE_CATEGORY => salesrep_rec.attribute_category,
X_ATTRIBUTE2 => salesrep_rec.attribute2,
X_ATTRIBUTE3 => salesrep_rec.attribute3,
X_ATTRIBUTE4 => salesrep_rec.attribute4,
X_ATTRIBUTE5 => salesrep_rec.attribute5,
X_ATTRIBUTE6 => salesrep_rec.attribute6,
X_ATTRIBUTE7 => salesrep_rec.attribute7,
X_ATTRIBUTE8 => salesrep_rec.attribute8,
X_ATTRIBUTE9 => salesrep_rec.attribute9,
X_ATTRIBUTE10 => salesrep_rec.attribute10,
X_ATTRIBUTE11 => salesrep_rec.attribute11,
X_ATTRIBUTE12 => salesrep_rec.attribute12,
X_ATTRIBUTE13 => salesrep_rec.attribute13,
X_ATTRIBUTE14 => salesrep_rec.attribute14,
X_ATTRIBUTE15 => salesrep_rec.attribute15,
X_ATTRIBUTE1 => salesrep_rec.attribute1,
X_LAST_UPDATE_DATE => SYSDATE,
X_LAST_UPDATED_BY => jtf_resource_utl.updated_by,
X_LAST_UPDATE_LOGIN => jtf_resource_utl.login_id
);
CLOSE c_salesrep_update;
CLOSE c_salesrep_update;
'UPDATE_SALESREP',
'A',
'C')
THEN
jtf_rs_salesreps_cuhk.update_salesrep_post(
p_salesrep_id => l_salesrep_id,
p_sales_credit_type_id => l_sales_credit_type_id,
p_name => l_name,
p_status => l_status,
p_start_date_active => l_start_date_active,
p_end_date_active => l_end_date_active,
p_gl_id_rev => l_gl_id_rev,
p_gl_id_freight => l_gl_id_freight,
p_gl_id_rec => l_gl_id_rec,
p_set_of_books_id => l_set_of_books_id,
p_salesrep_number => l_salesrep_number,
p_email_address => l_email_address,
p_wh_update_date => l_wh_update_date,
p_sales_tax_geocode => l_sales_tax_geocode,
p_sales_tax_inside_city_limits => l_sales_tax_inside_city_limits,
x_return_status => x_return_status);
'UPDATE_SALESREP',
'A',
'V')
THEN
jtf_rs_salesreps_vuhk.update_salesrep_post(
p_salesrep_id => l_salesrep_id,
p_sales_credit_type_id => l_sales_credit_type_id,
p_name => l_name,
p_status => l_status,
p_start_date_active => l_start_date_active,
p_end_date_active => l_end_date_active,
p_gl_id_rev => l_gl_id_rev,
p_gl_id_freight => l_gl_id_freight,
p_gl_id_rec => l_gl_id_rec,
p_set_of_books_id => l_set_of_books_id,
p_salesrep_number => l_salesrep_number,
p_email_address => l_email_address,
p_wh_update_date => l_wh_update_date,
p_sales_tax_geocode => l_sales_tax_geocode,
p_sales_tax_inside_city_limits => l_sales_tax_inside_city_limits,
x_return_status => x_return_status);
'UPDATE_SALESREP',
'A',
'I')
THEN
jtf_rs_salesreps_iuhk.update_salesrep_post(
p_salesrep_id => l_salesrep_id,
p_sales_credit_type_id => l_sales_credit_type_id,
p_name => l_name,
p_status => l_status,
p_start_date_active => l_start_date_active,
p_end_date_active => l_end_date_active,
p_gl_id_rev => l_gl_id_rev,
p_gl_id_freight => l_gl_id_freight,
p_gl_id_rec => l_gl_id_rec,
p_set_of_books_id => l_set_of_books_id,
p_salesrep_number => l_salesrep_number,
p_email_address => l_email_address,
p_wh_update_date => l_wh_update_date,
p_sales_tax_geocode => l_sales_tax_geocode,
p_sales_tax_inside_city_limits => l_sales_tax_inside_city_limits,
x_return_status => x_return_status);
'UPDATE_SALESREP',
'M',
'M')
THEN
IF (jtf_rs_salesreps_cuhk.ok_to_generate_msg(
p_salesrep_id => l_salesrep_id,
x_return_status => x_return_status) )
THEN
/* Get the bind data id for the Business Object Instance */
l_bind_data_id := jtf_usr_hks.get_bind_data_id;
ROLLBACK TO update_salesrep_pvt;
ROLLBACK TO update_salesrep_pvt;
ROLLBACK TO update_salesrep_pvt;
End update_salesrep;