eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_RS_SALESREPS_PVT dependencies on JTF_RS_SALESREPS

Line 1: PACKAGE BODY JTF_RS_SALESREPS_PVT AS

1: PACKAGE BODY JTF_RS_SALESREPS_PVT AS
2: /* $Header: jtfrsvsb.pls 120.4 2011/02/07 08:59:36 rgokavar ship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30):= 'JTF_RS_SALESREPS_PVT';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30):= 'JTF_RS_SALESREPS_PVT';

1: PACKAGE BODY JTF_RS_SALESREPS_PVT AS
2: /* $Header: jtfrsvsb.pls 120.4 2011/02/07 08:59:36 rgokavar 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(

Line 13: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,

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,

Line 14: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%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,

Line 15: P_NAME IN JTF_RS_SALESREPS.NAME%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,

Line 16: P_STATUS IN JTF_RS_SALESREPS.STATUS%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,

Line 17: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%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,

Line 18: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%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,

Line 19: P_ORG_ID IN JTF_RS_SALESREPS.ORG_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,
23: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,

Line 20: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%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,

Line 21: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%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,

Line 22: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%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,

Line 23: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%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,

Line 24: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%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,

Line 25: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%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,

Line 26: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%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,

Line 27: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%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,

Line 28: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%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,

Line 29: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%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,

Line 30: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%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,

Line 31: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%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,

Line 32: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%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,

Line 33: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%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,

Line 34: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%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,

Line 35: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%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,

Line 36: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%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,

Line 37: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%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,

Line 38: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%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,

Line 39: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%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,

Line 40: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%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,

Line 41: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%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,

Line 42: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%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,
46: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 43: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%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,
47: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 44: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%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,
48: X_SALESREP_ID OUT NOCOPY JTF_RS_SALESREPS.SALESREP_ID%TYPE

Line 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;

Line 54: l_resource_id jtf_rs_salesreps.resource_id%type := p_resource_id;

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;

Line 55: l_sales_credit_type_id jtf_rs_salesreps.sales_credit_type_id%type := p_sales_credit_type_id;

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;

Line 56: l_name jtf_rs_salesreps.name%type := p_name;

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;

Line 57: l_status jtf_rs_salesreps.status%type := p_status;

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;

Line 58: l_start_date_active jtf_rs_salesreps.start_date_active%type := p_start_date_active;

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;

Line 59: l_end_date_active jtf_rs_salesreps.end_date_active%type := p_end_date_active;

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;

Line 60: l_gl_id_rev jtf_rs_salesreps.gl_id_rev%type := p_gl_id_rev;

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;

Line 61: l_gl_id_freight jtf_rs_salesreps.gl_id_freight%type := p_gl_id_freight;

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;

Line 62: l_gl_id_rec jtf_rs_salesreps.gl_id_rec%type := p_gl_id_rec;

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;

Line 63: l_set_of_books_id jtf_rs_salesreps.set_of_books_id%type := p_set_of_books_id;

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;

Line 64: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;

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;

Line 65: l_email_address jtf_rs_salesreps.email_address%type := p_email_address;

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;

Line 66: l_wh_update_date jtf_rs_salesreps.wh_update_date%type := p_wh_update_date;

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;

Line 67: l_sales_tax_geocode jtf_rs_salesreps.sales_tax_geocode%type := p_sales_tax_geocode;

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;

Line 68: l_sales_tax_inside_city_limits jtf_rs_salesreps.sales_tax_inside_city_limits%type := p_sales_tax_inside_city_limits;

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;

Line 70: l_person_id jtf_rs_salesreps.person_id%type;

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;

Line 71: l_salesrep_id jtf_rs_salesreps.salesrep_id%type;

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);

Line 72: l_org_id jtf_rs_salesreps.org_id%type := p_org_id;

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);

Line 84: CURSOR c_jtf_rs_salesreps(l_rowid IN ROWID) IS

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:

Line 86: FROM jtf_rs_salesreps

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 )

Line 89: CURSOR c_dup_salesrep_id (l_salesrep_id IN jtf_rs_salesreps.salesrep_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

Line 90: l_org_id IN jtf_rs_salesreps.org_id%type )

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

Line 93: FROM jtf_rs_salesreps

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,

Line 98: l_org_id jtf_rs_salesreps.org_id%type) IS

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);

Line 100: FROM jtf_rs_salesreps

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);

Line 132: 'JTF_RS_SALESREPS_PVT',

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

Line 137: jtf_rs_salesreps_cuhk.create_salesrep_pre(

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,

Line 173: 'JTF_RS_SALESREPS_PVT',

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

Line 179: jtf_rs_salesreps_vuhk.create_salesrep_pre(

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,

Line 216: 'JTF_RS_SALESREPS_PVT',

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

Line 222: jtf_rs_salesreps_iuhk.create_salesrep_pre(

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,

Line 339: SELECT jtf_rs_salesreps_s.nextval

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:

Line 352: l_salesrep_id := JTF_RS_SALESREPS_PUB.G_SALESREP_ID;

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:

Line 353: l_org_id := JTF_RS_SALESREPS_PUB.G_ORG_ID;

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 */

Line 358: jtf_rs_salesreps_pkg.insert_row(

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,

Line 401: OPEN c_jtf_rs_salesreps(l_rowid);

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;

Line 402: FETCH c_jtf_rs_salesreps INTO l_check_char;

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:

Line 403: IF c_jtf_rs_salesreps%NOTFOUND THEN

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');

Line 405: CLOSE c_jtf_rs_salesreps;

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:

Line 414: CLOSE c_jtf_rs_salesreps;

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:

Line 422: 'JTF_RS_SALESREPS_PVT',

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

Line 427: jtf_rs_salesreps_cuhk.create_salesrep_post(

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,

Line 463: 'JTF_RS_SALESREPS_PVT',

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

Line 468: jtf_rs_salesreps_vuhk.create_salesrep_post(

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,

Line 504: 'JTF_RS_SALESREPS_PVT',

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

Line 509: jtf_rs_salesreps_iuhk.create_salesrep_post(

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,

Line 546: 'JTF_RS_SALESREPS_PVT',

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

Line 552: IF (jtf_rs_salesreps_cuhk.ok_to_generate_msg(

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:

Line 635: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,

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,

Line 636: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%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,

Line 637: P_NAME IN JTF_RS_SALESREPS.NAME%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,

Line 638: P_STATUS IN JTF_RS_SALESREPS.STATUS%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,

Line 639: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%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,

Line 640: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%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,

Line 641: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%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,

Line 642: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%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,

Line 643: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%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,

Line 644: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%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,

Line 645: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%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,

Line 646: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%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,

Line 647: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%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,

Line 648: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%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,

Line 649: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%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,

Line 650: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%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,

Line 651: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%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,

Line 652: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%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,

Line 653: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%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,

Line 654: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%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,

Line 655: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%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,

Line 656: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%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,

Line 657: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%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,

Line 658: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%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,

Line 659: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%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,

Line 660: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%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,

Line 661: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%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,

Line 662: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%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,

Line 663: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%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,

Line 664: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%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,

Line 665: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%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,
669: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 666: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%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,
670: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 667: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%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,
671: X_SALESREP_ID OUT NOCOPY JTF_RS_SALESREPS.SALESREP_ID%TYPE

Line 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:

Line 678: jtf_rs_salesreps_pvt.create_salesrep (

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,

Line 726: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,

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,

Line 727: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%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,

Line 728: P_NAME IN JTF_RS_SALESREPS.NAME%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,

Line 729: P_STATUS IN JTF_RS_SALESREPS.STATUS%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,

Line 730: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%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,

Line 731: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%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,

Line 732: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%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,

Line 733: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%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,

Line 734: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%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,

Line 735: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%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,

Line 736: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%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,

Line 737: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%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,

Line 738: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%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,

Line 739: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%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,

Line 740: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%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,

Line 741: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%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,

Line 742: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SALESREPS.OBJECT_VERSION_NUMBER%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,

Line 743: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%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,

Line 744: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%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,

Line 745: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%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,

Line 746: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%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,

Line 747: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%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,

Line 748: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%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,

Line 749: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%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,

Line 750: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%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,

Line 751: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%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,

Line 752: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%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,

Line 753: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%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,

Line 754: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%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,

Line 755: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%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,

Line 756: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%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,
760: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 757: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%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,
761: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 758: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%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
762: )

Line 768: l_salesrep_id jtf_rs_salesreps.salesrep_id%type := p_salesrep_id;

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;

Line 769: l_resource_id jtf_rs_salesreps.resource_id%type;

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;

Line 770: l_sales_credit_type_id jtf_rs_salesreps.sales_credit_type_id%type := p_sales_credit_type_id

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;

Line 772: l_name jtf_rs_salesreps.name%type := p_name;

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;

Line 773: l_status jtf_rs_salesreps.status%type := p_status;

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;

Line 774: l_start_date_active jtf_rs_salesreps.start_date_active%type := p_start_date_active;

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;

Line 775: l_end_date_active jtf_rs_salesreps.end_date_active%type := p_end_date_active;

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;

Line 776: l_gl_id_rev jtf_rs_salesreps.gl_id_rev%type := p_gl_id_rev;

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;

Line 777: l_gl_id_freight jtf_rs_salesreps.gl_id_freight%type := p_gl_id_freight;

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;

Line 778: l_gl_id_rec jtf_rs_salesreps.gl_id_rec%type := p_gl_id_rec;

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;

Line 779: l_set_of_books_id jtf_rs_salesreps.set_of_books_id%type := p_set_of_books_id;

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;

Line 780: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;

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;

Line 781: l_email_address jtf_rs_salesreps.email_address%type := p_email_address;

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;

Line 782: l_wh_update_date jtf_rs_salesreps.wh_update_date%type := p_wh_update_date;

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;

Line 783: l_sales_tax_geocode jtf_rs_salesreps.sales_tax_geocode%type := p_sales_tax_geocode;

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);

Line 784: l_sales_tax_inside_city_limits jtf_rs_salesreps.sales_tax_inside_city_limits%type := p_sales_tax_inside_city_limits;

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);

Line 785: l_org_id jtf_rs_salesreps.org_id%type := p_org_id;

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);

Line 786: l_object_version_number jtf_rs_salesreps.object_version_number%type := p_object_version_number;

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;

Line 793: CURSOR c_salesrep_update(l_salesrep_id jtf_rs_salesreps.salesrep_id%type, l_org_id jtf_rs_salesreps.org_id%type) is

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,

Line 829: FROM jtf_rs_salesreps

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:

Line 836: FROM jtf_rs_salesreps

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:

Line 877: 'JTF_RS_SALESREPS_PVT',

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

Line 882: jtf_rs_salesreps_cuhk.update_salesrep_pre(

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,

Line 916: 'JTF_RS_SALESREPS_PVT',

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

Line 922: jtf_rs_salesreps_vuhk.update_salesrep_pre(

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,

Line 958: 'JTF_RS_SALESREPS_PVT',

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

Line 964: jtf_rs_salesreps_iuhk.update_salesrep_pre(

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,

Line 1054: jtf_rs_salesreps_pkg.lock_row(

1050: END IF;
1051:
1052: /* Locking the row before updating */
1053: BEGIN
1054: jtf_rs_salesreps_pkg.lock_row(
1055: x_salesrep_id => l_salesrep_id,
1056: x_org_id => l_org_id,
1057: x_object_version_number => l_object_version_number
1058: );

Line 1075: jtf_rs_salesreps_pkg.update_row(

1071: l_object_version_number := l_object_version_number + 1;
1072:
1073: /* Invoke table handler to insert into JTF_RS__SALESREPS */
1074:
1075: jtf_rs_salesreps_pkg.update_row(
1076: X_SALESREP_ID => l_salesrep_id,
1077: X_RESOURCE_ID => salesrep_rec.resource_id,
1078: X_SALES_CREDIT_TYPE_ID => salesrep_rec.sales_credit_type_id,
1079: X_NAME => salesrep_rec.name,

Line 1137: 'JTF_RS_SALESREPS_PVT',

1133:
1134: /* Post Call to the Customer Type User Hook */
1135:
1136: IF jtf_usr_hks.ok_to_execute(
1137: 'JTF_RS_SALESREPS_PVT',
1138: 'UPDATE_SALESREP',
1139: 'A',
1140: 'C')
1141: THEN

Line 1142: jtf_rs_salesreps_cuhk.update_salesrep_post(

1138: 'UPDATE_SALESREP',
1139: 'A',
1140: 'C')
1141: THEN
1142: jtf_rs_salesreps_cuhk.update_salesrep_post(
1143: p_salesrep_id => l_salesrep_id,
1144: p_sales_credit_type_id => l_sales_credit_type_id,
1145: p_name => l_name,
1146: p_status => l_status,

Line 1177: 'JTF_RS_SALESREPS_PVT',

1173:
1174: /* Post Call to the Vertical Type User Hook */
1175:
1176: IF jtf_usr_hks.ok_to_execute(
1177: 'JTF_RS_SALESREPS_PVT',
1178: 'UPDATE_SALESREP',
1179: 'A',
1180: 'V')
1181: THEN

Line 1182: jtf_rs_salesreps_vuhk.update_salesrep_post(

1178: 'UPDATE_SALESREP',
1179: 'A',
1180: 'V')
1181: THEN
1182: jtf_rs_salesreps_vuhk.update_salesrep_post(
1183: p_salesrep_id => l_salesrep_id,
1184: p_sales_credit_type_id => l_sales_credit_type_id,
1185: p_name => l_name,
1186: p_status => l_status,

Line 1217: 'JTF_RS_SALESREPS_PVT',

1213:
1214: /* Post Call to the Internal Type User Hook */
1215:
1216: IF jtf_usr_hks.ok_to_execute(
1217: 'JTF_RS_SALESREPS_PVT',
1218: 'UPDATE_SALESREP',
1219: 'A',
1220: 'I')
1221: THEN

Line 1222: jtf_rs_salesreps_iuhk.update_salesrep_post(

1218: 'UPDATE_SALESREP',
1219: 'A',
1220: 'I')
1221: THEN
1222: jtf_rs_salesreps_iuhk.update_salesrep_post(
1223: p_salesrep_id => l_salesrep_id,
1224: p_sales_credit_type_id => l_sales_credit_type_id,
1225: p_name => l_name,
1226: p_status => l_status,

Line 1257: 'JTF_RS_SALESREPS_PVT',

1253:
1254: /* Standard call for Message Generation */
1255:
1256: IF jtf_usr_hks.ok_to_execute(
1257: 'JTF_RS_SALESREPS_PVT',
1258: 'UPDATE_SALESREP',
1259: 'M',
1260: 'M')
1261: THEN

Line 1263: IF (jtf_rs_salesreps_cuhk.ok_to_generate_msg(

1259: 'M',
1260: 'M')
1261: THEN
1262:
1263: IF (jtf_rs_salesreps_cuhk.ok_to_generate_msg(
1264: p_salesrep_id => l_salesrep_id,
1265: x_return_status => x_return_status) )
1266: THEN
1267:

Line 1341: End JTF_RS_SALESREPS_PVT;

1337: p_data => x_msg_data);
1338:
1339: End update_salesrep;
1340:
1341: End JTF_RS_SALESREPS_PVT;