1: PACKAGE BODY JTF_RS_SALESREPS_PVT AS
2: /* $Header: jtfrsvsb.pls 120.1 2005/06/07 23:03:26 baianand ship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30):= 'JTF_RS_SALESREPS_PVT';
1: PACKAGE BODY JTF_RS_SALESREPS_PVT AS
2: /* $Header: jtfrsvsb.pls 120.1 2005/06/07 23:03:26 baianand ship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30):= 'JTF_RS_SALESREPS_PVT';
6:
7: /* Procedure to create salesreps */
8:
9: PROCEDURE Create_salesrep(
9: PROCEDURE Create_salesrep(
10: P_API_VERSION IN NUMBER,
11: P_INIT_MSG_LIST IN VARCHAR2,
12: P_COMMIT IN VARCHAR2,
13: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
14: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
15: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
16: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
17: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
10: P_API_VERSION IN NUMBER,
11: P_INIT_MSG_LIST IN VARCHAR2,
12: P_COMMIT IN VARCHAR2,
13: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
14: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
15: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
16: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
17: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
18: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
11: P_INIT_MSG_LIST IN VARCHAR2,
12: P_COMMIT IN VARCHAR2,
13: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
14: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
15: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
16: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
17: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
18: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
19: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
12: P_COMMIT IN VARCHAR2,
13: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
14: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
15: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
16: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
17: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
18: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
19: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
20: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
13: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
14: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
15: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
16: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
17: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
18: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
19: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
20: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
21: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
14: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
15: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
16: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
17: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
18: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
19: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
20: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
21: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
22: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
15: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
16: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
17: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
18: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
19: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
20: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
21: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
22: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
23: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
16: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
17: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
18: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
19: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
20: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
21: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
22: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
23: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
24: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
17: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
18: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
19: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
20: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
21: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
22: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
23: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
24: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
25: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
18: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
19: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
20: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
21: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
22: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
23: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
24: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
25: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
26: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
19: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
20: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
21: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
22: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
23: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
24: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
25: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
26: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
27: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
20: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
21: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
22: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
23: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
24: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
25: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
26: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
27: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
28: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
21: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
22: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
23: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
24: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
25: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
26: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
27: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
28: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
29: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE,
22: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
23: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
24: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
25: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
26: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
27: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
28: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
29: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE,
30: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE,
23: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
24: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
25: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
26: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
27: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
28: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
29: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE,
30: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE,
31: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE,
24: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
25: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
26: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
27: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
28: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
29: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE,
30: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE,
31: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE,
32: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE,
25: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
26: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
27: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
28: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
29: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE,
30: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE,
31: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE,
32: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE,
33: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE,
26: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
27: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
28: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
29: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE,
30: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE,
31: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE,
32: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE,
33: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE,
34: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE,
27: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
28: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
29: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE,
30: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE,
31: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE,
32: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE,
33: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE,
34: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE,
35: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE,
28: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
29: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE,
30: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE,
31: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE,
32: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE,
33: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE,
34: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE,
35: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE,
36: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE,
29: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE,
30: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE,
31: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE,
32: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE,
33: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE,
34: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE,
35: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE,
36: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE,
37: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE,
30: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE,
31: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE,
32: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE,
33: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE,
34: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE,
35: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE,
36: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE,
37: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE,
38: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE,
31: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE,
32: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE,
33: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE,
34: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE,
35: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE,
36: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE,
37: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE,
38: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE,
39: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE,
32: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE,
33: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE,
34: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE,
35: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE,
36: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE,
37: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE,
38: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE,
39: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE,
40: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE,
33: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE,
34: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE,
35: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE,
36: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE,
37: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE,
38: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE,
39: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE,
40: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE,
41: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE,
34: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE,
35: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE,
36: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE,
37: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE,
38: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE,
39: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE,
40: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE,
41: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE,
42: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE,
35: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE,
36: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE,
37: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE,
38: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE,
39: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE,
40: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE,
41: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE,
42: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE,
43: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE,
36: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE,
37: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE,
38: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE,
39: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE,
40: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE,
41: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE,
42: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE,
43: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE,
44: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE,
37: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE,
38: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE,
39: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE,
40: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE,
41: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE,
42: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE,
43: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE,
44: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE,
45: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
38: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE,
39: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE,
40: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE,
41: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE,
42: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE,
43: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE,
44: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE,
45: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
46: X_MSG_COUNT OUT NOCOPY NUMBER,
39: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE,
40: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE,
41: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE,
42: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE,
43: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE,
44: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE,
45: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
46: X_MSG_COUNT OUT NOCOPY NUMBER,
47: X_MSG_DATA OUT NOCOPY VARCHAR2,
40: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE,
41: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE,
42: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE,
43: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE,
44: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE,
45: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
46: X_MSG_COUNT OUT NOCOPY NUMBER,
47: X_MSG_DATA OUT NOCOPY VARCHAR2,
48: X_SALESREP_ID OUT NOCOPY JTF_RS_SALESREPS.SALESREP_ID%TYPE
44: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE,
45: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
46: X_MSG_COUNT OUT NOCOPY NUMBER,
47: X_MSG_DATA OUT NOCOPY VARCHAR2,
48: X_SALESREP_ID OUT NOCOPY JTF_RS_SALESREPS.SALESREP_ID%TYPE
49: )
50: IS
51: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_SALESREP';
52: l_api_version CONSTANT NUMBER := 1.0;
50: IS
51: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_SALESREP';
52: l_api_version CONSTANT NUMBER := 1.0;
53: l_rowid ROWID;
54: l_resource_id jtf_rs_salesreps.resource_id%type := p_resource_id;
55: l_sales_credit_type_id jtf_rs_salesreps.sales_credit_type_id%type := p_sales_credit_type_id;
56: l_name jtf_rs_salesreps.name%type := p_name;
57: l_status jtf_rs_salesreps.status%type := p_status;
58: l_start_date_active jtf_rs_salesreps.start_date_active%type := p_start_date_active;
51: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_SALESREP';
52: l_api_version CONSTANT NUMBER := 1.0;
53: l_rowid ROWID;
54: l_resource_id jtf_rs_salesreps.resource_id%type := p_resource_id;
55: l_sales_credit_type_id jtf_rs_salesreps.sales_credit_type_id%type := p_sales_credit_type_id;
56: l_name jtf_rs_salesreps.name%type := p_name;
57: l_status jtf_rs_salesreps.status%type := p_status;
58: l_start_date_active jtf_rs_salesreps.start_date_active%type := p_start_date_active;
59: l_end_date_active jtf_rs_salesreps.end_date_active%type := p_end_date_active;
52: l_api_version CONSTANT NUMBER := 1.0;
53: l_rowid ROWID;
54: l_resource_id jtf_rs_salesreps.resource_id%type := p_resource_id;
55: l_sales_credit_type_id jtf_rs_salesreps.sales_credit_type_id%type := p_sales_credit_type_id;
56: l_name jtf_rs_salesreps.name%type := p_name;
57: l_status jtf_rs_salesreps.status%type := p_status;
58: l_start_date_active jtf_rs_salesreps.start_date_active%type := p_start_date_active;
59: l_end_date_active jtf_rs_salesreps.end_date_active%type := p_end_date_active;
60: l_gl_id_rev jtf_rs_salesreps.gl_id_rev%type := p_gl_id_rev;
53: l_rowid ROWID;
54: l_resource_id jtf_rs_salesreps.resource_id%type := p_resource_id;
55: l_sales_credit_type_id jtf_rs_salesreps.sales_credit_type_id%type := p_sales_credit_type_id;
56: l_name jtf_rs_salesreps.name%type := p_name;
57: l_status jtf_rs_salesreps.status%type := p_status;
58: l_start_date_active jtf_rs_salesreps.start_date_active%type := p_start_date_active;
59: l_end_date_active jtf_rs_salesreps.end_date_active%type := p_end_date_active;
60: l_gl_id_rev jtf_rs_salesreps.gl_id_rev%type := p_gl_id_rev;
61: l_gl_id_freight jtf_rs_salesreps.gl_id_freight%type := p_gl_id_freight;
54: l_resource_id jtf_rs_salesreps.resource_id%type := p_resource_id;
55: l_sales_credit_type_id jtf_rs_salesreps.sales_credit_type_id%type := p_sales_credit_type_id;
56: l_name jtf_rs_salesreps.name%type := p_name;
57: l_status jtf_rs_salesreps.status%type := p_status;
58: l_start_date_active jtf_rs_salesreps.start_date_active%type := p_start_date_active;
59: l_end_date_active jtf_rs_salesreps.end_date_active%type := p_end_date_active;
60: l_gl_id_rev jtf_rs_salesreps.gl_id_rev%type := p_gl_id_rev;
61: l_gl_id_freight jtf_rs_salesreps.gl_id_freight%type := p_gl_id_freight;
62: l_gl_id_rec jtf_rs_salesreps.gl_id_rec%type := p_gl_id_rec;
55: l_sales_credit_type_id jtf_rs_salesreps.sales_credit_type_id%type := p_sales_credit_type_id;
56: l_name jtf_rs_salesreps.name%type := p_name;
57: l_status jtf_rs_salesreps.status%type := p_status;
58: l_start_date_active jtf_rs_salesreps.start_date_active%type := p_start_date_active;
59: l_end_date_active jtf_rs_salesreps.end_date_active%type := p_end_date_active;
60: l_gl_id_rev jtf_rs_salesreps.gl_id_rev%type := p_gl_id_rev;
61: l_gl_id_freight jtf_rs_salesreps.gl_id_freight%type := p_gl_id_freight;
62: l_gl_id_rec jtf_rs_salesreps.gl_id_rec%type := p_gl_id_rec;
63: l_set_of_books_id jtf_rs_salesreps.set_of_books_id%type := p_set_of_books_id;
56: l_name jtf_rs_salesreps.name%type := p_name;
57: l_status jtf_rs_salesreps.status%type := p_status;
58: l_start_date_active jtf_rs_salesreps.start_date_active%type := p_start_date_active;
59: l_end_date_active jtf_rs_salesreps.end_date_active%type := p_end_date_active;
60: l_gl_id_rev jtf_rs_salesreps.gl_id_rev%type := p_gl_id_rev;
61: l_gl_id_freight jtf_rs_salesreps.gl_id_freight%type := p_gl_id_freight;
62: l_gl_id_rec jtf_rs_salesreps.gl_id_rec%type := p_gl_id_rec;
63: l_set_of_books_id jtf_rs_salesreps.set_of_books_id%type := p_set_of_books_id;
64: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;
57: l_status jtf_rs_salesreps.status%type := p_status;
58: l_start_date_active jtf_rs_salesreps.start_date_active%type := p_start_date_active;
59: l_end_date_active jtf_rs_salesreps.end_date_active%type := p_end_date_active;
60: l_gl_id_rev jtf_rs_salesreps.gl_id_rev%type := p_gl_id_rev;
61: l_gl_id_freight jtf_rs_salesreps.gl_id_freight%type := p_gl_id_freight;
62: l_gl_id_rec jtf_rs_salesreps.gl_id_rec%type := p_gl_id_rec;
63: l_set_of_books_id jtf_rs_salesreps.set_of_books_id%type := p_set_of_books_id;
64: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;
65: l_email_address jtf_rs_salesreps.email_address%type := p_email_address;
58: l_start_date_active jtf_rs_salesreps.start_date_active%type := p_start_date_active;
59: l_end_date_active jtf_rs_salesreps.end_date_active%type := p_end_date_active;
60: l_gl_id_rev jtf_rs_salesreps.gl_id_rev%type := p_gl_id_rev;
61: l_gl_id_freight jtf_rs_salesreps.gl_id_freight%type := p_gl_id_freight;
62: l_gl_id_rec jtf_rs_salesreps.gl_id_rec%type := p_gl_id_rec;
63: l_set_of_books_id jtf_rs_salesreps.set_of_books_id%type := p_set_of_books_id;
64: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;
65: l_email_address jtf_rs_salesreps.email_address%type := p_email_address;
66: l_wh_update_date jtf_rs_salesreps.wh_update_date%type := p_wh_update_date;
59: l_end_date_active jtf_rs_salesreps.end_date_active%type := p_end_date_active;
60: l_gl_id_rev jtf_rs_salesreps.gl_id_rev%type := p_gl_id_rev;
61: l_gl_id_freight jtf_rs_salesreps.gl_id_freight%type := p_gl_id_freight;
62: l_gl_id_rec jtf_rs_salesreps.gl_id_rec%type := p_gl_id_rec;
63: l_set_of_books_id jtf_rs_salesreps.set_of_books_id%type := p_set_of_books_id;
64: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;
65: l_email_address jtf_rs_salesreps.email_address%type := p_email_address;
66: l_wh_update_date jtf_rs_salesreps.wh_update_date%type := p_wh_update_date;
67: l_sales_tax_geocode jtf_rs_salesreps.sales_tax_geocode%type := p_sales_tax_geocode;
60: l_gl_id_rev jtf_rs_salesreps.gl_id_rev%type := p_gl_id_rev;
61: l_gl_id_freight jtf_rs_salesreps.gl_id_freight%type := p_gl_id_freight;
62: l_gl_id_rec jtf_rs_salesreps.gl_id_rec%type := p_gl_id_rec;
63: l_set_of_books_id jtf_rs_salesreps.set_of_books_id%type := p_set_of_books_id;
64: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;
65: l_email_address jtf_rs_salesreps.email_address%type := p_email_address;
66: l_wh_update_date jtf_rs_salesreps.wh_update_date%type := p_wh_update_date;
67: l_sales_tax_geocode jtf_rs_salesreps.sales_tax_geocode%type := p_sales_tax_geocode;
68: l_sales_tax_inside_city_limits jtf_rs_salesreps.sales_tax_inside_city_limits%type := p_sales_tax_inside_city_limits;
61: l_gl_id_freight jtf_rs_salesreps.gl_id_freight%type := p_gl_id_freight;
62: l_gl_id_rec jtf_rs_salesreps.gl_id_rec%type := p_gl_id_rec;
63: l_set_of_books_id jtf_rs_salesreps.set_of_books_id%type := p_set_of_books_id;
64: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;
65: l_email_address jtf_rs_salesreps.email_address%type := p_email_address;
66: l_wh_update_date jtf_rs_salesreps.wh_update_date%type := p_wh_update_date;
67: l_sales_tax_geocode jtf_rs_salesreps.sales_tax_geocode%type := p_sales_tax_geocode;
68: l_sales_tax_inside_city_limits jtf_rs_salesreps.sales_tax_inside_city_limits%type := p_sales_tax_inside_city_limits;
69: l_category jtf_rs_resource_extns.category%type;
62: l_gl_id_rec jtf_rs_salesreps.gl_id_rec%type := p_gl_id_rec;
63: l_set_of_books_id jtf_rs_salesreps.set_of_books_id%type := p_set_of_books_id;
64: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;
65: l_email_address jtf_rs_salesreps.email_address%type := p_email_address;
66: l_wh_update_date jtf_rs_salesreps.wh_update_date%type := p_wh_update_date;
67: l_sales_tax_geocode jtf_rs_salesreps.sales_tax_geocode%type := p_sales_tax_geocode;
68: l_sales_tax_inside_city_limits jtf_rs_salesreps.sales_tax_inside_city_limits%type := p_sales_tax_inside_city_limits;
69: l_category jtf_rs_resource_extns.category%type;
70: l_person_id jtf_rs_salesreps.person_id%type;
63: l_set_of_books_id jtf_rs_salesreps.set_of_books_id%type := p_set_of_books_id;
64: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;
65: l_email_address jtf_rs_salesreps.email_address%type := p_email_address;
66: l_wh_update_date jtf_rs_salesreps.wh_update_date%type := p_wh_update_date;
67: l_sales_tax_geocode jtf_rs_salesreps.sales_tax_geocode%type := p_sales_tax_geocode;
68: l_sales_tax_inside_city_limits jtf_rs_salesreps.sales_tax_inside_city_limits%type := p_sales_tax_inside_city_limits;
69: l_category jtf_rs_resource_extns.category%type;
70: l_person_id jtf_rs_salesreps.person_id%type;
71: l_salesrep_id jtf_rs_salesreps.salesrep_id%type;
64: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;
65: l_email_address jtf_rs_salesreps.email_address%type := p_email_address;
66: l_wh_update_date jtf_rs_salesreps.wh_update_date%type := p_wh_update_date;
67: l_sales_tax_geocode jtf_rs_salesreps.sales_tax_geocode%type := p_sales_tax_geocode;
68: l_sales_tax_inside_city_limits jtf_rs_salesreps.sales_tax_inside_city_limits%type := p_sales_tax_inside_city_limits;
69: l_category jtf_rs_resource_extns.category%type;
70: l_person_id jtf_rs_salesreps.person_id%type;
71: l_salesrep_id jtf_rs_salesreps.salesrep_id%type;
72: l_org_id jtf_rs_salesreps.org_id%type := p_org_id;
66: l_wh_update_date jtf_rs_salesreps.wh_update_date%type := p_wh_update_date;
67: l_sales_tax_geocode jtf_rs_salesreps.sales_tax_geocode%type := p_sales_tax_geocode;
68: l_sales_tax_inside_city_limits jtf_rs_salesreps.sales_tax_inside_city_limits%type := p_sales_tax_inside_city_limits;
69: l_category jtf_rs_resource_extns.category%type;
70: l_person_id jtf_rs_salesreps.person_id%type;
71: l_salesrep_id jtf_rs_salesreps.salesrep_id%type;
72: l_org_id jtf_rs_salesreps.org_id%type := p_org_id;
73: l_msg_data VARCHAR2(2000);
74: l_msg_count NUMBER;
67: l_sales_tax_geocode jtf_rs_salesreps.sales_tax_geocode%type := p_sales_tax_geocode;
68: l_sales_tax_inside_city_limits jtf_rs_salesreps.sales_tax_inside_city_limits%type := p_sales_tax_inside_city_limits;
69: l_category jtf_rs_resource_extns.category%type;
70: l_person_id jtf_rs_salesreps.person_id%type;
71: l_salesrep_id jtf_rs_salesreps.salesrep_id%type;
72: l_org_id jtf_rs_salesreps.org_id%type := p_org_id;
73: l_msg_data VARCHAR2(2000);
74: l_msg_count NUMBER;
75: l_check_char VARCHAR2(1);
68: l_sales_tax_inside_city_limits jtf_rs_salesreps.sales_tax_inside_city_limits%type := p_sales_tax_inside_city_limits;
69: l_category jtf_rs_resource_extns.category%type;
70: l_person_id jtf_rs_salesreps.person_id%type;
71: l_salesrep_id jtf_rs_salesreps.salesrep_id%type;
72: l_org_id jtf_rs_salesreps.org_id%type := p_org_id;
73: l_msg_data VARCHAR2(2000);
74: l_msg_count NUMBER;
75: l_check_char VARCHAR2(1);
76: l_check_dup_id VARCHAR2(1);
80: SELECT category,source_id
81: FROM jtf_rs_resource_extns
82: WHERE resource_id = l_resource_id;
83:
84: CURSOR c_jtf_rs_salesreps(l_rowid IN ROWID) IS
85: SELECT 'Y'
86: FROM jtf_rs_salesreps
87: WHERE rowid = l_rowid;
88:
82: WHERE resource_id = l_resource_id;
83:
84: CURSOR c_jtf_rs_salesreps(l_rowid IN ROWID) IS
85: SELECT 'Y'
86: FROM jtf_rs_salesreps
87: WHERE rowid = l_rowid;
88:
89: CURSOR c_dup_salesrep_id (l_salesrep_id IN jtf_rs_salesreps.salesrep_id%type,
90: l_org_id IN jtf_rs_salesreps.org_id%type )
85: SELECT 'Y'
86: FROM jtf_rs_salesreps
87: WHERE rowid = l_rowid;
88:
89: CURSOR c_dup_salesrep_id (l_salesrep_id IN jtf_rs_salesreps.salesrep_id%type,
90: l_org_id IN jtf_rs_salesreps.org_id%type )
91: IS
92: SELECT 'X'
93: FROM jtf_rs_salesreps
86: FROM jtf_rs_salesreps
87: WHERE rowid = l_rowid;
88:
89: CURSOR c_dup_salesrep_id (l_salesrep_id IN jtf_rs_salesreps.salesrep_id%type,
90: l_org_id IN jtf_rs_salesreps.org_id%type )
91: IS
92: SELECT 'X'
93: FROM jtf_rs_salesreps
94: WHERE salesrep_id = l_salesrep_id
89: CURSOR c_dup_salesrep_id (l_salesrep_id IN jtf_rs_salesreps.salesrep_id%type,
90: l_org_id IN jtf_rs_salesreps.org_id%type )
91: IS
92: SELECT 'X'
93: FROM jtf_rs_salesreps
94: WHERE salesrep_id = l_salesrep_id
95: AND nvl(org_id,-99) = nvl(l_org_id,-99);
96:
97: CURSOR c_dup_resource(l_resource_id jtf_rs_resource_extns.resource_id%type,
94: WHERE salesrep_id = l_salesrep_id
95: AND nvl(org_id,-99) = nvl(l_org_id,-99);
96:
97: CURSOR c_dup_resource(l_resource_id jtf_rs_resource_extns.resource_id%type,
98: l_org_id jtf_rs_salesreps.org_id%type) IS
99: SELECT 'Y'
100: FROM jtf_rs_salesreps
101: WHERE resource_id = l_resource_id
102: AND nvl(org_id,-99) = nvl(l_org_id,-99);
96:
97: CURSOR c_dup_resource(l_resource_id jtf_rs_resource_extns.resource_id%type,
98: l_org_id jtf_rs_salesreps.org_id%type) IS
99: SELECT 'Y'
100: FROM jtf_rs_salesreps
101: WHERE resource_id = l_resource_id
102: AND nvl(org_id,-99) = nvl(l_org_id,-99);
103:
104: resource_exists varchar2(1);
128:
129: /* Pre Call to the Customer Type User Hook */
130:
131: IF jtf_usr_hks.ok_to_execute(
132: 'JTF_RS_SALESREPS_PVT',
133: 'CREATE_SALESREP',
134: 'B',
135: 'C')
136: THEN
133: 'CREATE_SALESREP',
134: 'B',
135: 'C')
136: THEN
137: jtf_rs_salesreps_cuhk.create_salesrep_pre(
138: p_resource_id => l_resource_id,
139: p_sales_credit_type_id => l_sales_credit_type_id,
140: p_name => l_name,
141: p_status => l_status,
169:
170: /* Pre Call to the Vertical Type User Hook */
171:
172: IF jtf_usr_hks.ok_to_execute(
173: 'JTF_RS_SALESREPS_PVT',
174: 'CREATE_SALESREP',
175: 'B',
176: 'V')
177: THEN
175: 'B',
176: 'V')
177: THEN
178:
179: jtf_rs_salesreps_vuhk.create_salesrep_pre(
180: p_resource_id => l_resource_id,
181: p_sales_credit_type_id => l_sales_credit_type_id,
182: p_name => l_name,
183: p_status => l_status,
212:
213: /* Pre Call to the Internal Type User Hook */
214:
215: IF jtf_usr_hks.ok_to_execute(
216: 'JTF_RS_SALESREPS_PVT',
217: 'CREATE_SALESREP',
218: 'B',
219: 'I')
220: THEN
218: 'B',
219: 'I')
220: THEN
221:
222: jtf_rs_salesreps_iuhk.create_salesrep_pre(
223: p_resource_id => l_resource_id,
224: p_sales_credit_type_id => l_sales_credit_type_id,
225: p_name => l_name,
226: p_status => l_status,
335:
336: /* Get the next value of the Salesrep_id from the sequence. */
337:
338: LOOP
339: SELECT jtf_rs_salesreps_s.nextval
340: INTO l_salesrep_id
341: FROM dual;
342: --dbms_output.put_line ('After Select - Salesrep ID ' || l_salesrep_id);
343:
348: END LOOP;
349: CLOSE c_dup_salesrep_id;
350:
351: ELSE
352: l_salesrep_id := JTF_RS_SALESREPS_PUB.G_SALESREP_ID;
353: l_org_id := JTF_RS_SALESREPS_PUB.G_ORG_ID;
354:
355: END IF;
356:
349: CLOSE c_dup_salesrep_id;
350:
351: ELSE
352: l_salesrep_id := JTF_RS_SALESREPS_PUB.G_SALESREP_ID;
353: l_org_id := JTF_RS_SALESREPS_PUB.G_ORG_ID;
354:
355: END IF;
356:
357: /* Calling table handler to insert salesrep */
354:
355: END IF;
356:
357: /* Calling table handler to insert salesrep */
358: jtf_rs_salesreps_pkg.insert_row(
359: X_ROWID => l_rowid,
360: X_SALESREP_ID => l_salesrep_id,
361: X_RESOURCE_ID => l_resource_id,
362: X_SALES_CREDIT_TYPE_ID => l_sales_credit_type_id,
397: X_LAST_UPDATED_BY => jtf_resource_utl.updated_by,
398: X_LAST_UPDATE_LOGIN => jtf_resource_utl.login_id
399: );
400:
401: OPEN c_jtf_rs_salesreps(l_rowid);
402: FETCH c_jtf_rs_salesreps INTO l_check_char;
403: IF c_jtf_rs_salesreps%NOTFOUND THEN
404:
405: CLOSE c_jtf_rs_salesreps;
398: X_LAST_UPDATE_LOGIN => jtf_resource_utl.login_id
399: );
400:
401: OPEN c_jtf_rs_salesreps(l_rowid);
402: FETCH c_jtf_rs_salesreps INTO l_check_char;
403: IF c_jtf_rs_salesreps%NOTFOUND THEN
404:
405: CLOSE c_jtf_rs_salesreps;
406:
399: );
400:
401: OPEN c_jtf_rs_salesreps(l_rowid);
402: FETCH c_jtf_rs_salesreps INTO l_check_char;
403: IF c_jtf_rs_salesreps%NOTFOUND THEN
404:
405: CLOSE c_jtf_rs_salesreps;
406:
407: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
401: OPEN c_jtf_rs_salesreps(l_rowid);
402: FETCH c_jtf_rs_salesreps INTO l_check_char;
403: IF c_jtf_rs_salesreps%NOTFOUND THEN
404:
405: CLOSE c_jtf_rs_salesreps;
406:
407: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
408: fnd_msg_pub.add;
409:
410: RAISE fnd_api.g_exc_error;
411:
412: ELSE
413: x_salesrep_id := l_salesrep_id;
414: CLOSE c_jtf_rs_salesreps;
415: END IF;
416:
417: /* Make the post processing call to the user hooks */
418:
418:
419: /* Post Call to the Customer Type User Hook */
420:
421: IF jtf_usr_hks.ok_to_execute(
422: 'JTF_RS_SALESREPS_PVT',
423: 'CREATE_SALESREP',
424: 'A',
425: 'C')
426: THEN
423: 'CREATE_SALESREP',
424: 'A',
425: 'C')
426: THEN
427: jtf_rs_salesreps_cuhk.create_salesrep_post(
428: p_salesrep_id => l_salesrep_id,
429: p_resource_id => l_resource_id,
430: p_sales_credit_type_id => l_sales_credit_type_id,
431: p_name => l_name,
459:
460: /* Post Call to the Vertical Type User Hook */
461:
462: IF jtf_usr_hks.ok_to_execute(
463: 'JTF_RS_SALESREPS_PVT',
464: 'CREATE_SALESREP',
465: 'A',
466: 'V')
467: THEN
464: 'CREATE_SALESREP',
465: 'A',
466: 'V')
467: THEN
468: jtf_rs_salesreps_vuhk.create_salesrep_post(
469: p_salesrep_id => l_salesrep_id,
470: p_resource_id => l_resource_id,
471: p_sales_credit_type_id => l_sales_credit_type_id,
472: p_name => l_name,
500:
501: /* Post Call to the Internal Type User Hook */
502:
503: IF jtf_usr_hks.ok_to_execute(
504: 'JTF_RS_SALESREPS_PVT',
505: 'CREATE_SALESREP',
506: 'A',
507: 'I')
508: THEN
505: 'CREATE_SALESREP',
506: 'A',
507: 'I')
508: THEN
509: jtf_rs_salesreps_iuhk.create_salesrep_post(
510: p_salesrep_id => l_salesrep_id,
511: p_resource_id => l_resource_id,
512: p_sales_credit_type_id => l_sales_credit_type_id,
513: p_name => l_name,
542:
543: /* Standard call for Message Generation */
544:
545: IF jtf_usr_hks.ok_to_execute(
546: 'JTF_RS_SALESREPS_PVT',
547: 'CREATE_SALESREP',
548: 'M',
549: 'M')
550: THEN
548: 'M',
549: 'M')
550: THEN
551:
552: IF (jtf_rs_salesreps_cuhk.ok_to_generate_msg(
553: p_salesrep_id => l_salesrep_id,
554: x_return_status => x_return_status) )
555: THEN
556:
631: PROCEDURE create_salesrep_migrate(
632: P_API_VERSION IN NUMBER,
633: P_INIT_MSG_LIST IN VARCHAR2,
634: P_COMMIT IN VARCHAR2,
635: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
636: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
637: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
638: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
639: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
632: P_API_VERSION IN NUMBER,
633: P_INIT_MSG_LIST IN VARCHAR2,
634: P_COMMIT IN VARCHAR2,
635: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
636: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
637: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
638: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
639: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
640: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
633: P_INIT_MSG_LIST IN VARCHAR2,
634: P_COMMIT IN VARCHAR2,
635: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
636: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
637: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
638: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
639: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
640: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
641: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
634: P_COMMIT IN VARCHAR2,
635: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
636: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
637: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
638: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
639: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
640: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
641: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
642: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
635: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
636: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
637: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
638: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
639: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
640: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
641: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
642: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
643: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
636: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
637: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
638: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
639: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
640: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
641: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
642: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
643: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
644: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
637: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
638: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
639: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
640: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
641: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
642: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
643: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
644: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
645: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
638: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
639: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
640: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
641: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
642: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
643: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
644: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
645: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
646: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
639: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
640: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
641: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
642: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
643: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
644: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
645: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
646: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
647: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
640: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
641: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
642: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
643: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
644: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
645: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
646: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
647: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
648: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
641: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
642: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
643: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
644: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
645: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
646: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
647: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
648: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
649: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
642: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
643: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
644: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
645: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
646: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
647: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
648: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
649: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
650: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE,
643: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
644: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
645: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
646: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
647: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
648: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
649: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
650: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE,
651: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE,
644: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
645: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
646: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
647: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
648: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
649: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
650: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE,
651: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE,
652: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE,
645: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
646: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
647: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
648: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
649: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
650: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE,
651: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE,
652: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE,
653: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE,
646: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
647: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
648: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
649: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
650: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE,
651: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE,
652: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE,
653: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE,
654: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE,
647: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
648: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
649: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
650: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE,
651: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE,
652: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE,
653: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE,
654: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE,
655: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE,
648: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
649: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
650: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE,
651: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE,
652: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE,
653: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE,
654: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE,
655: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE,
656: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE,
649: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
650: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE,
651: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE,
652: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE,
653: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE,
654: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE,
655: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE,
656: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE,
657: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE,
650: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE,
651: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE,
652: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE,
653: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE,
654: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE,
655: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE,
656: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE,
657: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE,
658: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE,
651: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE,
652: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE,
653: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE,
654: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE,
655: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE,
656: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE,
657: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE,
658: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE,
659: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE,
652: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE,
653: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE,
654: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE,
655: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE,
656: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE,
657: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE,
658: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE,
659: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE,
660: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE,
653: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE,
654: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE,
655: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE,
656: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE,
657: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE,
658: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE,
659: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE,
660: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE,
661: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE,
654: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE,
655: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE,
656: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE,
657: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE,
658: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE,
659: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE,
660: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE,
661: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE,
662: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE,
655: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE,
656: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE,
657: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE,
658: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE,
659: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE,
660: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE,
661: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE,
662: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE,
663: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE,
656: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE,
657: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE,
658: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE,
659: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE,
660: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE,
661: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE,
662: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE,
663: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE,
664: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE,
657: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE,
658: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE,
659: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE,
660: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE,
661: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE,
662: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE,
663: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE,
664: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE,
665: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE,
658: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE,
659: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE,
660: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE,
661: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE,
662: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE,
663: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE,
664: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE,
665: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE,
666: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
659: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE,
660: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE,
661: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE,
662: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE,
663: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE,
664: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE,
665: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE,
666: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
667: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
660: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE,
661: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE,
662: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE,
663: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE,
664: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE,
665: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE,
666: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
667: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
668: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
661: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE,
662: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE,
663: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE,
664: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE,
665: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE,
666: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
667: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
668: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
669: X_MSG_COUNT OUT NOCOPY NUMBER,
662: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE,
663: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE,
664: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE,
665: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE,
666: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
667: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
668: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
669: X_MSG_COUNT OUT NOCOPY NUMBER,
670: X_MSG_DATA OUT NOCOPY VARCHAR2,
663: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE,
664: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE,
665: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE,
666: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
667: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
668: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
669: X_MSG_COUNT OUT NOCOPY NUMBER,
670: X_MSG_DATA OUT NOCOPY VARCHAR2,
671: X_SALESREP_ID OUT NOCOPY JTF_RS_SALESREPS.SALESREP_ID%TYPE
667: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
668: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
669: X_MSG_COUNT OUT NOCOPY NUMBER,
670: X_MSG_DATA OUT NOCOPY VARCHAR2,
671: X_SALESREP_ID OUT NOCOPY JTF_RS_SALESREPS.SALESREP_ID%TYPE
672: ) IS
673:
674: BEGIN
675:
674: BEGIN
675:
676: G_SRP_ID_PVT_FLAG := 'N';
677:
678: jtf_rs_salesreps_pvt.create_salesrep (
679: P_API_VERSION => P_API_VERSION,
680: P_INIT_MSG_LIST => P_INIT_MSG_LIST,
681: P_COMMIT => P_COMMIT,
682: P_RESOURCE_ID => P_RESOURCE_ID,
722: PROCEDURE Update_salesrep(
723: P_API_VERSION IN NUMBER,
724: P_INIT_MSG_LIST IN VARCHAR2,
725: P_COMMIT IN VARCHAR2,
726: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
727: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
728: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
729: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
730: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
723: P_API_VERSION IN NUMBER,
724: P_INIT_MSG_LIST IN VARCHAR2,
725: P_COMMIT IN VARCHAR2,
726: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
727: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
728: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
729: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
730: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
731: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
724: P_INIT_MSG_LIST IN VARCHAR2,
725: P_COMMIT IN VARCHAR2,
726: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
727: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
728: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
729: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
730: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
731: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
732: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
725: P_COMMIT IN VARCHAR2,
726: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
727: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
728: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
729: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
730: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
731: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
732: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
733: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
726: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
727: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
728: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
729: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
730: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
731: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
732: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
733: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
734: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
727: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
728: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
729: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
730: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
731: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
732: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
733: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
734: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
735: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
728: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
729: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
730: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
731: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
732: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
733: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
734: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
735: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
736: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
729: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
730: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
731: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
732: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
733: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
734: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
735: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
736: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
737: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
730: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
731: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
732: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
733: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
734: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
735: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
736: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
737: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
738: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
731: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
732: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
733: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
734: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
735: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
736: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
737: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
738: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
739: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
732: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
733: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
734: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
735: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
736: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
737: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
738: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
739: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
740: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
733: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
734: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
735: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
736: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
737: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
738: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
739: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
740: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
741: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
734: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
735: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
736: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
737: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
738: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
739: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
740: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
741: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
742: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SALESREPS.OBJECT_VERSION_NUMBER%TYPE,
735: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
736: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
737: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
738: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
739: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
740: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
741: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
742: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SALESREPS.OBJECT_VERSION_NUMBER%TYPE,
743: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE,
736: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
737: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
738: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
739: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
740: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
741: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
742: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SALESREPS.OBJECT_VERSION_NUMBER%TYPE,
743: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE,
744: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE,
737: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
738: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
739: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
740: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
741: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
742: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SALESREPS.OBJECT_VERSION_NUMBER%TYPE,
743: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE,
744: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE,
745: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE,
738: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
739: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
740: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
741: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
742: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SALESREPS.OBJECT_VERSION_NUMBER%TYPE,
743: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE,
744: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE,
745: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE,
746: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE,
739: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
740: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
741: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
742: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SALESREPS.OBJECT_VERSION_NUMBER%TYPE,
743: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE,
744: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE,
745: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE,
746: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE,
747: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE,
740: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
741: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
742: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SALESREPS.OBJECT_VERSION_NUMBER%TYPE,
743: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE,
744: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE,
745: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE,
746: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE,
747: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE,
748: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE,
741: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
742: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SALESREPS.OBJECT_VERSION_NUMBER%TYPE,
743: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE,
744: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE,
745: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE,
746: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE,
747: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE,
748: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE,
749: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE,
742: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SALESREPS.OBJECT_VERSION_NUMBER%TYPE,
743: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE,
744: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE,
745: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE,
746: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE,
747: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE,
748: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE,
749: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE,
750: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE,
743: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE,
744: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE,
745: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE,
746: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE,
747: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE,
748: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE,
749: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE,
750: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE,
751: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE,
744: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE,
745: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE,
746: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE,
747: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE,
748: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE,
749: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE,
750: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE,
751: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE,
752: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE,
745: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE,
746: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE,
747: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE,
748: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE,
749: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE,
750: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE,
751: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE,
752: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE,
753: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE,
746: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE,
747: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE,
748: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE,
749: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE,
750: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE,
751: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE,
752: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE,
753: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE,
754: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE,
747: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE,
748: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE,
749: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE,
750: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE,
751: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE,
752: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE,
753: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE,
754: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE,
755: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE,
748: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE,
749: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE,
750: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE,
751: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE,
752: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE,
753: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE,
754: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE,
755: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE,
756: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE,
749: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE,
750: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE,
751: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE,
752: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE,
753: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE,
754: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE,
755: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE,
756: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE,
757: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE,
750: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE,
751: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE,
752: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE,
753: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE,
754: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE,
755: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE,
756: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE,
757: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE,
758: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE,
751: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE,
752: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE,
753: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE,
754: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE,
755: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE,
756: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE,
757: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE,
758: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE,
759: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
752: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE,
753: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE,
754: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE,
755: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE,
756: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE,
757: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE,
758: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE,
759: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
760: X_MSG_COUNT OUT NOCOPY NUMBER,
753: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE,
754: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE,
755: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE,
756: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE,
757: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE,
758: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE,
759: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
760: X_MSG_COUNT OUT NOCOPY NUMBER,
761: X_MSG_DATA OUT NOCOPY VARCHAR2
754: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE,
755: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE,
756: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE,
757: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE,
758: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE,
759: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
760: X_MSG_COUNT OUT NOCOPY NUMBER,
761: X_MSG_DATA OUT NOCOPY VARCHAR2
762: )
764:
765: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_SALESREP';
766: l_api_version CONSTANT NUMBER := 1.0;
767: l_rowid ROWID;
768: l_salesrep_id jtf_rs_salesreps.salesrep_id%type := p_salesrep_id;
769: l_resource_id jtf_rs_salesreps.resource_id%type;
770: l_sales_credit_type_id jtf_rs_salesreps.sales_credit_type_id%type := p_sales_credit_type_id
771: ;
772: l_name jtf_rs_salesreps.name%type := p_name;
765: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_SALESREP';
766: l_api_version CONSTANT NUMBER := 1.0;
767: l_rowid ROWID;
768: l_salesrep_id jtf_rs_salesreps.salesrep_id%type := p_salesrep_id;
769: l_resource_id jtf_rs_salesreps.resource_id%type;
770: l_sales_credit_type_id jtf_rs_salesreps.sales_credit_type_id%type := p_sales_credit_type_id
771: ;
772: l_name jtf_rs_salesreps.name%type := p_name;
773: l_status jtf_rs_salesreps.status%type := p_status;
766: l_api_version CONSTANT NUMBER := 1.0;
767: l_rowid ROWID;
768: l_salesrep_id jtf_rs_salesreps.salesrep_id%type := p_salesrep_id;
769: l_resource_id jtf_rs_salesreps.resource_id%type;
770: l_sales_credit_type_id jtf_rs_salesreps.sales_credit_type_id%type := p_sales_credit_type_id
771: ;
772: l_name jtf_rs_salesreps.name%type := p_name;
773: l_status jtf_rs_salesreps.status%type := p_status;
774: l_start_date_active jtf_rs_salesreps.start_date_active%type := p_start_date_active;
768: l_salesrep_id jtf_rs_salesreps.salesrep_id%type := p_salesrep_id;
769: l_resource_id jtf_rs_salesreps.resource_id%type;
770: l_sales_credit_type_id jtf_rs_salesreps.sales_credit_type_id%type := p_sales_credit_type_id
771: ;
772: l_name jtf_rs_salesreps.name%type := p_name;
773: l_status jtf_rs_salesreps.status%type := p_status;
774: l_start_date_active jtf_rs_salesreps.start_date_active%type := p_start_date_active;
775: l_end_date_active jtf_rs_salesreps.end_date_active%type := p_end_date_active;
776: l_gl_id_rev jtf_rs_salesreps.gl_id_rev%type := p_gl_id_rev;
769: l_resource_id jtf_rs_salesreps.resource_id%type;
770: l_sales_credit_type_id jtf_rs_salesreps.sales_credit_type_id%type := p_sales_credit_type_id
771: ;
772: l_name jtf_rs_salesreps.name%type := p_name;
773: l_status jtf_rs_salesreps.status%type := p_status;
774: l_start_date_active jtf_rs_salesreps.start_date_active%type := p_start_date_active;
775: l_end_date_active jtf_rs_salesreps.end_date_active%type := p_end_date_active;
776: l_gl_id_rev jtf_rs_salesreps.gl_id_rev%type := p_gl_id_rev;
777: l_gl_id_freight jtf_rs_salesreps.gl_id_freight%type := p_gl_id_freight;
770: l_sales_credit_type_id jtf_rs_salesreps.sales_credit_type_id%type := p_sales_credit_type_id
771: ;
772: l_name jtf_rs_salesreps.name%type := p_name;
773: l_status jtf_rs_salesreps.status%type := p_status;
774: l_start_date_active jtf_rs_salesreps.start_date_active%type := p_start_date_active;
775: l_end_date_active jtf_rs_salesreps.end_date_active%type := p_end_date_active;
776: l_gl_id_rev jtf_rs_salesreps.gl_id_rev%type := p_gl_id_rev;
777: l_gl_id_freight jtf_rs_salesreps.gl_id_freight%type := p_gl_id_freight;
778: l_gl_id_rec jtf_rs_salesreps.gl_id_rec%type := p_gl_id_rec;
771: ;
772: l_name jtf_rs_salesreps.name%type := p_name;
773: l_status jtf_rs_salesreps.status%type := p_status;
774: l_start_date_active jtf_rs_salesreps.start_date_active%type := p_start_date_active;
775: l_end_date_active jtf_rs_salesreps.end_date_active%type := p_end_date_active;
776: l_gl_id_rev jtf_rs_salesreps.gl_id_rev%type := p_gl_id_rev;
777: l_gl_id_freight jtf_rs_salesreps.gl_id_freight%type := p_gl_id_freight;
778: l_gl_id_rec jtf_rs_salesreps.gl_id_rec%type := p_gl_id_rec;
779: l_set_of_books_id jtf_rs_salesreps.set_of_books_id%type := p_set_of_books_id;
772: l_name jtf_rs_salesreps.name%type := p_name;
773: l_status jtf_rs_salesreps.status%type := p_status;
774: l_start_date_active jtf_rs_salesreps.start_date_active%type := p_start_date_active;
775: l_end_date_active jtf_rs_salesreps.end_date_active%type := p_end_date_active;
776: l_gl_id_rev jtf_rs_salesreps.gl_id_rev%type := p_gl_id_rev;
777: l_gl_id_freight jtf_rs_salesreps.gl_id_freight%type := p_gl_id_freight;
778: l_gl_id_rec jtf_rs_salesreps.gl_id_rec%type := p_gl_id_rec;
779: l_set_of_books_id jtf_rs_salesreps.set_of_books_id%type := p_set_of_books_id;
780: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;
773: l_status jtf_rs_salesreps.status%type := p_status;
774: l_start_date_active jtf_rs_salesreps.start_date_active%type := p_start_date_active;
775: l_end_date_active jtf_rs_salesreps.end_date_active%type := p_end_date_active;
776: l_gl_id_rev jtf_rs_salesreps.gl_id_rev%type := p_gl_id_rev;
777: l_gl_id_freight jtf_rs_salesreps.gl_id_freight%type := p_gl_id_freight;
778: l_gl_id_rec jtf_rs_salesreps.gl_id_rec%type := p_gl_id_rec;
779: l_set_of_books_id jtf_rs_salesreps.set_of_books_id%type := p_set_of_books_id;
780: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;
781: l_email_address jtf_rs_salesreps.email_address%type := p_email_address;
774: l_start_date_active jtf_rs_salesreps.start_date_active%type := p_start_date_active;
775: l_end_date_active jtf_rs_salesreps.end_date_active%type := p_end_date_active;
776: l_gl_id_rev jtf_rs_salesreps.gl_id_rev%type := p_gl_id_rev;
777: l_gl_id_freight jtf_rs_salesreps.gl_id_freight%type := p_gl_id_freight;
778: l_gl_id_rec jtf_rs_salesreps.gl_id_rec%type := p_gl_id_rec;
779: l_set_of_books_id jtf_rs_salesreps.set_of_books_id%type := p_set_of_books_id;
780: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;
781: l_email_address jtf_rs_salesreps.email_address%type := p_email_address;
782: l_wh_update_date jtf_rs_salesreps.wh_update_date%type := p_wh_update_date;
775: l_end_date_active jtf_rs_salesreps.end_date_active%type := p_end_date_active;
776: l_gl_id_rev jtf_rs_salesreps.gl_id_rev%type := p_gl_id_rev;
777: l_gl_id_freight jtf_rs_salesreps.gl_id_freight%type := p_gl_id_freight;
778: l_gl_id_rec jtf_rs_salesreps.gl_id_rec%type := p_gl_id_rec;
779: l_set_of_books_id jtf_rs_salesreps.set_of_books_id%type := p_set_of_books_id;
780: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;
781: l_email_address jtf_rs_salesreps.email_address%type := p_email_address;
782: l_wh_update_date jtf_rs_salesreps.wh_update_date%type := p_wh_update_date;
783: l_sales_tax_geocode jtf_rs_salesreps.sales_tax_geocode%type := p_sales_tax_geocode;
776: l_gl_id_rev jtf_rs_salesreps.gl_id_rev%type := p_gl_id_rev;
777: l_gl_id_freight jtf_rs_salesreps.gl_id_freight%type := p_gl_id_freight;
778: l_gl_id_rec jtf_rs_salesreps.gl_id_rec%type := p_gl_id_rec;
779: l_set_of_books_id jtf_rs_salesreps.set_of_books_id%type := p_set_of_books_id;
780: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;
781: l_email_address jtf_rs_salesreps.email_address%type := p_email_address;
782: l_wh_update_date jtf_rs_salesreps.wh_update_date%type := p_wh_update_date;
783: l_sales_tax_geocode jtf_rs_salesreps.sales_tax_geocode%type := p_sales_tax_geocode;
784: l_sales_tax_inside_city_limits jtf_rs_salesreps.sales_tax_inside_city_limits%type := p_sales_tax_inside_city_limits;
777: l_gl_id_freight jtf_rs_salesreps.gl_id_freight%type := p_gl_id_freight;
778: l_gl_id_rec jtf_rs_salesreps.gl_id_rec%type := p_gl_id_rec;
779: l_set_of_books_id jtf_rs_salesreps.set_of_books_id%type := p_set_of_books_id;
780: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;
781: l_email_address jtf_rs_salesreps.email_address%type := p_email_address;
782: l_wh_update_date jtf_rs_salesreps.wh_update_date%type := p_wh_update_date;
783: l_sales_tax_geocode jtf_rs_salesreps.sales_tax_geocode%type := p_sales_tax_geocode;
784: l_sales_tax_inside_city_limits jtf_rs_salesreps.sales_tax_inside_city_limits%type := p_sales_tax_inside_city_limits;
785: l_org_id jtf_rs_salesreps.org_id%type := p_org_id;
778: l_gl_id_rec jtf_rs_salesreps.gl_id_rec%type := p_gl_id_rec;
779: l_set_of_books_id jtf_rs_salesreps.set_of_books_id%type := p_set_of_books_id;
780: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;
781: l_email_address jtf_rs_salesreps.email_address%type := p_email_address;
782: l_wh_update_date jtf_rs_salesreps.wh_update_date%type := p_wh_update_date;
783: l_sales_tax_geocode jtf_rs_salesreps.sales_tax_geocode%type := p_sales_tax_geocode;
784: l_sales_tax_inside_city_limits jtf_rs_salesreps.sales_tax_inside_city_limits%type := p_sales_tax_inside_city_limits;
785: l_org_id jtf_rs_salesreps.org_id%type := p_org_id;
786: l_object_version_number jtf_rs_salesreps.object_version_number%type := p_object_version_number;
779: l_set_of_books_id jtf_rs_salesreps.set_of_books_id%type := p_set_of_books_id;
780: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;
781: l_email_address jtf_rs_salesreps.email_address%type := p_email_address;
782: l_wh_update_date jtf_rs_salesreps.wh_update_date%type := p_wh_update_date;
783: l_sales_tax_geocode jtf_rs_salesreps.sales_tax_geocode%type := p_sales_tax_geocode;
784: l_sales_tax_inside_city_limits jtf_rs_salesreps.sales_tax_inside_city_limits%type := p_sales_tax_inside_city_limits;
785: l_org_id jtf_rs_salesreps.org_id%type := p_org_id;
786: l_object_version_number jtf_rs_salesreps.object_version_number%type := p_object_version_number;
787: c_val varchar2(1);
780: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;
781: l_email_address jtf_rs_salesreps.email_address%type := p_email_address;
782: l_wh_update_date jtf_rs_salesreps.wh_update_date%type := p_wh_update_date;
783: l_sales_tax_geocode jtf_rs_salesreps.sales_tax_geocode%type := p_sales_tax_geocode;
784: l_sales_tax_inside_city_limits jtf_rs_salesreps.sales_tax_inside_city_limits%type := p_sales_tax_inside_city_limits;
785: l_org_id jtf_rs_salesreps.org_id%type := p_org_id;
786: l_object_version_number jtf_rs_salesreps.object_version_number%type := p_object_version_number;
787: c_val varchar2(1);
788: l_msg_data VARCHAR2(2000);
781: l_email_address jtf_rs_salesreps.email_address%type := p_email_address;
782: l_wh_update_date jtf_rs_salesreps.wh_update_date%type := p_wh_update_date;
783: l_sales_tax_geocode jtf_rs_salesreps.sales_tax_geocode%type := p_sales_tax_geocode;
784: l_sales_tax_inside_city_limits jtf_rs_salesreps.sales_tax_inside_city_limits%type := p_sales_tax_inside_city_limits;
785: l_org_id jtf_rs_salesreps.org_id%type := p_org_id;
786: l_object_version_number jtf_rs_salesreps.object_version_number%type := p_object_version_number;
787: c_val varchar2(1);
788: l_msg_data VARCHAR2(2000);
789: x_var varchar2(1);
782: l_wh_update_date jtf_rs_salesreps.wh_update_date%type := p_wh_update_date;
783: l_sales_tax_geocode jtf_rs_salesreps.sales_tax_geocode%type := p_sales_tax_geocode;
784: l_sales_tax_inside_city_limits jtf_rs_salesreps.sales_tax_inside_city_limits%type := p_sales_tax_inside_city_limits;
785: l_org_id jtf_rs_salesreps.org_id%type := p_org_id;
786: l_object_version_number jtf_rs_salesreps.object_version_number%type := p_object_version_number;
787: c_val varchar2(1);
788: l_msg_data VARCHAR2(2000);
789: x_var varchar2(1);
790: l_msg_count NUMBER;
789: x_var varchar2(1);
790: l_msg_count NUMBER;
791: l_bind_data_id NUMBER;
792:
793: CURSOR c_salesrep_update(l_salesrep_id jtf_rs_salesreps.salesrep_id%type, l_org_id jtf_rs_salesreps.org_id%type) is
794: SELECT salesrep_id,
795: resource_id,
796: DECODE(p_sales_credit_type_id,fnd_api.g_miss_num,sales_credit_type_id,p_sales_credit_type_id) sales_credit_type_id,
797: DECODE(p_name,fnd_api.g_miss_char,name,p_name) name,
825: DECODE(p_attribute12,fnd_api.g_miss_char,attribute12,p_attribute12) attribute12,
826: DECODE(p_attribute13,fnd_api.g_miss_char,attribute13,p_attribute13) attribute13,
827: DECODE(p_attribute14,fnd_api.g_miss_char,attribute14,p_attribute14) attribute14,
828: DECODE(p_attribute15,fnd_api.g_miss_char,attribute15,p_attribute15) attribute15
829: FROM jtf_rs_salesreps
830: WHERE salesrep_id = l_salesrep_id
831: AND nvl(org_id,-99) = nvl(l_org_id,-99);
832: salesrep_rec c_salesrep_update%ROWTYPE;
833:
832: salesrep_rec c_salesrep_update%ROWTYPE;
833:
834: CURSOR c_salesrep_number IS
835: SELECT 'X'
836: FROM jtf_rs_salesreps
837: WHERE salesrep_number = l_salesrep_number
838: AND nvl(org_id,-99) = nvl(l_org_id,-99)
839: AND salesrep_id <> p_salesrep_id;
840:
873:
874: /* Pre Call to the Customer Type User Hook */
875:
876: IF jtf_usr_hks.ok_to_execute(
877: 'JTF_RS_SALESREPS_PVT',
878: 'UPDATE_SALESREP',
879: 'B',
880: 'C')
881: THEN
878: 'UPDATE_SALESREP',
879: 'B',
880: 'C')
881: THEN
882: jtf_rs_salesreps_cuhk.update_salesrep_pre(
883: p_salesrep_id => l_salesrep_id,
884: p_sales_credit_type_id => l_sales_credit_type_id,
885: p_name => l_name,
886: p_status => l_status,
912:
913: /* Pre Call to the Vertical Type User Hook */
914:
915: IF jtf_usr_hks.ok_to_execute(
916: 'JTF_RS_SALESREPS_PVT',
917: 'UPDATE_SALESREP',
918: 'B',
919: 'V')
920: THEN
918: 'B',
919: 'V')
920: THEN
921:
922: jtf_rs_salesreps_vuhk.update_salesrep_pre(
923: p_salesrep_id => l_salesrep_id,
924: p_sales_credit_type_id => l_sales_credit_type_id,
925: p_name => l_name,
926: p_status => l_status,
954:
955: /* Pre Call to the Internal Type User Hook */
956:
957: IF jtf_usr_hks.ok_to_execute(
958: 'JTF_RS_SALESREPS_PVT',
959: 'UPDATE_SALESREP',
960: 'B',
961: 'I')
962: THEN
960: 'B',
961: 'I')
962: THEN
963:
964: jtf_rs_salesreps_iuhk.update_salesrep_pre(
965: p_salesrep_id => l_salesrep_id,
966: p_sales_credit_type_id => l_sales_credit_type_id,
967: p_name => l_name,
968: p_status => l_status,
1047: END IF;
1048:
1049: /* Locking the row before updating */
1050: BEGIN
1051: jtf_rs_salesreps_pkg.lock_row(
1052: x_salesrep_id => l_salesrep_id,
1053: x_org_id => l_org_id,
1054: x_object_version_number => l_object_version_number
1055: );
1068: l_object_version_number := l_object_version_number + 1;
1069:
1070: /* Invoke table handler to insert into JTF_RS__SALESREPS */
1071:
1072: jtf_rs_salesreps_pkg.update_row(
1073: X_SALESREP_ID => l_salesrep_id,
1074: X_RESOURCE_ID => salesrep_rec.resource_id,
1075: X_SALES_CREDIT_TYPE_ID => salesrep_rec.sales_credit_type_id,
1076: X_NAME => salesrep_rec.name,
1130:
1131: /* Post Call to the Customer Type User Hook */
1132:
1133: IF jtf_usr_hks.ok_to_execute(
1134: 'JTF_RS_SALESREPS_PVT',
1135: 'UPDATE_SALESREP',
1136: 'A',
1137: 'C')
1138: THEN
1135: 'UPDATE_SALESREP',
1136: 'A',
1137: 'C')
1138: THEN
1139: jtf_rs_salesreps_cuhk.update_salesrep_post(
1140: p_salesrep_id => l_salesrep_id,
1141: p_sales_credit_type_id => l_sales_credit_type_id,
1142: p_name => l_name,
1143: p_status => l_status,
1170:
1171: /* Post Call to the Vertical Type User Hook */
1172:
1173: IF jtf_usr_hks.ok_to_execute(
1174: 'JTF_RS_SALESREPS_PVT',
1175: 'UPDATE_SALESREP',
1176: 'A',
1177: 'V')
1178: THEN
1175: 'UPDATE_SALESREP',
1176: 'A',
1177: 'V')
1178: THEN
1179: jtf_rs_salesreps_vuhk.update_salesrep_post(
1180: p_salesrep_id => l_salesrep_id,
1181: p_sales_credit_type_id => l_sales_credit_type_id,
1182: p_name => l_name,
1183: p_status => l_status,
1210:
1211: /* Post Call to the Internal Type User Hook */
1212:
1213: IF jtf_usr_hks.ok_to_execute(
1214: 'JTF_RS_SALESREPS_PVT',
1215: 'UPDATE_SALESREP',
1216: 'A',
1217: 'I')
1218: THEN
1215: 'UPDATE_SALESREP',
1216: 'A',
1217: 'I')
1218: THEN
1219: jtf_rs_salesreps_iuhk.update_salesrep_post(
1220: p_salesrep_id => l_salesrep_id,
1221: p_sales_credit_type_id => l_sales_credit_type_id,
1222: p_name => l_name,
1223: p_status => l_status,
1250:
1251: /* Standard call for Message Generation */
1252:
1253: IF jtf_usr_hks.ok_to_execute(
1254: 'JTF_RS_SALESREPS_PVT',
1255: 'UPDATE_SALESREP',
1256: 'M',
1257: 'M')
1258: THEN
1256: 'M',
1257: 'M')
1258: THEN
1259:
1260: IF (jtf_rs_salesreps_cuhk.ok_to_generate_msg(
1261: p_salesrep_id => l_salesrep_id,
1262: x_return_status => x_return_status) )
1263: THEN
1264:
1334: p_data => x_msg_data);
1335:
1336: End update_salesrep;
1337:
1338: End JTF_RS_SALESREPS_PVT;