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 JTF_RS_SALESREPS_PVT AUTHID CURRENT_USER AS

1: PACKAGE JTF_RS_SALESREPS_PVT AUTHID CURRENT_USER AS
2: /* $Header: jtfrsvss.pls 120.1 2005/06/07 23:03:22 baianand ship $ */
3:
4:
5: /* *****************************************************************************

Line 7: API Name: JTF_RS_SALESREPS_PVT

3:
4:
5: /* *****************************************************************************
6: Start of Comments
7: API Name: JTF_RS_SALESREPS_PVT
8: Type : Private
9: Main Procedures
10: : Create Sallesrep
11: : Update Sallesrep

Line 19: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,

15: PROCEDURE Create_salesrep(
16: P_API_VERSION IN NUMBER,
17: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
18: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
19: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
20: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
21: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT NULL,
22: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,
23: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,

Line 20: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,

16: P_API_VERSION IN NUMBER,
17: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
18: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
19: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
20: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
21: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT NULL,
22: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,
23: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
24: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,

Line 21: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT NULL,

17: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
18: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
19: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
20: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
21: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT NULL,
22: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,
23: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
24: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
25: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,

Line 22: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,

18: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
19: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
20: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
21: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT NULL,
22: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,
23: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
24: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
25: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
26: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,

Line 23: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,

19: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
20: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
21: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT NULL,
22: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,
23: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
24: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
25: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
26: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
27: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,

Line 24: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,

20: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
21: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT NULL,
22: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,
23: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
24: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
25: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
26: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
27: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
28: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,

Line 25: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,

21: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT NULL,
22: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,
23: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
24: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
25: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
26: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
27: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
28: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
29: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,

Line 26: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,

22: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,
23: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
24: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
25: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
26: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
27: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
28: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
29: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
30: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,

Line 27: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,

23: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
24: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
25: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
26: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
27: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
28: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
29: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
30: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
31: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,

Line 28: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,

24: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
25: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
26: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
27: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
28: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
29: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
30: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
31: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,
32: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,

Line 29: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,

25: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
26: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
27: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
28: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
29: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
30: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
31: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,
32: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,
33: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,

Line 30: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,

26: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
27: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
28: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
29: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
30: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
31: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,
32: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,
33: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,
34: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,

Line 31: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,

27: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
28: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
29: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
30: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
31: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,
32: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,
33: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,
34: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,
35: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,

Line 32: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,

28: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
29: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
30: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
31: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,
32: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,
33: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,
34: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,
35: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
36: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE DEFAULT NULL,

Line 33: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,

29: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
30: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
31: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,
32: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,
33: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,
34: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,
35: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
36: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE DEFAULT NULL,
37: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE DEFAULT NULL,

Line 34: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,

30: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
31: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,
32: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,
33: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,
34: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,
35: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
36: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE DEFAULT NULL,
37: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE DEFAULT NULL,
38: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE DEFAULT NULL,

Line 35: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,

31: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,
32: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,
33: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,
34: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,
35: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
36: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE DEFAULT NULL,
37: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE DEFAULT NULL,
38: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE DEFAULT NULL,
39: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE DEFAULT NULL,

Line 36: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE DEFAULT NULL,

32: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,
33: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,
34: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,
35: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
36: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE DEFAULT NULL,
37: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE DEFAULT NULL,
38: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE DEFAULT NULL,
39: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE DEFAULT NULL,
40: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE DEFAULT NULL,

Line 37: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE DEFAULT NULL,

33: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,
34: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,
35: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
36: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE DEFAULT NULL,
37: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE DEFAULT NULL,
38: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE DEFAULT NULL,
39: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE DEFAULT NULL,
40: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE DEFAULT NULL,
41: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE DEFAULT NULL,

Line 38: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE DEFAULT NULL,

34: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,
35: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
36: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE DEFAULT NULL,
37: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE DEFAULT NULL,
38: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE DEFAULT NULL,
39: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE DEFAULT NULL,
40: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE DEFAULT NULL,
41: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE DEFAULT NULL,
42: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE DEFAULT NULL,

Line 39: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE DEFAULT NULL,

35: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
36: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE DEFAULT NULL,
37: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE DEFAULT NULL,
38: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE DEFAULT NULL,
39: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE DEFAULT NULL,
40: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE DEFAULT NULL,
41: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE DEFAULT NULL,
42: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE DEFAULT NULL,
43: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE DEFAULT NULL,

Line 40: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE DEFAULT NULL,

36: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE DEFAULT NULL,
37: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE DEFAULT NULL,
38: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE DEFAULT NULL,
39: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE DEFAULT NULL,
40: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE DEFAULT NULL,
41: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE DEFAULT NULL,
42: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE DEFAULT NULL,
43: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE DEFAULT NULL,
44: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE DEFAULT NULL,

Line 41: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE DEFAULT NULL,

37: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE DEFAULT NULL,
38: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE DEFAULT NULL,
39: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE DEFAULT NULL,
40: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE DEFAULT NULL,
41: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE DEFAULT NULL,
42: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE DEFAULT NULL,
43: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE DEFAULT NULL,
44: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE DEFAULT NULL,
45: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE DEFAULT NULL,

Line 42: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE DEFAULT NULL,

38: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE DEFAULT NULL,
39: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE DEFAULT NULL,
40: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE DEFAULT NULL,
41: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE DEFAULT NULL,
42: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE DEFAULT NULL,
43: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE DEFAULT NULL,
44: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE DEFAULT NULL,
45: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE DEFAULT NULL,
46: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE DEFAULT NULL,

Line 43: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE DEFAULT NULL,

39: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE DEFAULT NULL,
40: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE DEFAULT NULL,
41: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE DEFAULT NULL,
42: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE DEFAULT NULL,
43: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE DEFAULT NULL,
44: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE DEFAULT NULL,
45: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE DEFAULT NULL,
46: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE DEFAULT NULL,
47: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE DEFAULT NULL,

Line 44: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE DEFAULT NULL,

40: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE DEFAULT NULL,
41: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE DEFAULT NULL,
42: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE DEFAULT NULL,
43: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE DEFAULT NULL,
44: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE DEFAULT NULL,
45: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE DEFAULT NULL,
46: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE DEFAULT NULL,
47: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE DEFAULT NULL,
48: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE DEFAULT NULL,

Line 45: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE DEFAULT NULL,

41: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE DEFAULT NULL,
42: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE DEFAULT NULL,
43: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE DEFAULT NULL,
44: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE DEFAULT NULL,
45: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE DEFAULT NULL,
46: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE DEFAULT NULL,
47: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE DEFAULT NULL,
48: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE DEFAULT NULL,
49: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE DEFAULT NULL,

Line 46: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE DEFAULT NULL,

42: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE DEFAULT NULL,
43: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE DEFAULT NULL,
44: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE DEFAULT NULL,
45: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE DEFAULT NULL,
46: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE DEFAULT NULL,
47: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE DEFAULT NULL,
48: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE DEFAULT NULL,
49: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE DEFAULT NULL,
50: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE DEFAULT NULL,

Line 47: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE DEFAULT NULL,

43: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE DEFAULT NULL,
44: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE DEFAULT NULL,
45: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE DEFAULT NULL,
46: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE DEFAULT NULL,
47: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE DEFAULT NULL,
48: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE DEFAULT NULL,
49: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE DEFAULT NULL,
50: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE DEFAULT NULL,
51: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 48: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE DEFAULT NULL,

44: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE DEFAULT NULL,
45: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE DEFAULT NULL,
46: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE DEFAULT NULL,
47: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE DEFAULT NULL,
48: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE DEFAULT NULL,
49: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE DEFAULT NULL,
50: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE DEFAULT NULL,
51: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
52: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 49: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE DEFAULT NULL,

45: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE DEFAULT NULL,
46: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE DEFAULT NULL,
47: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE DEFAULT NULL,
48: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE DEFAULT NULL,
49: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE DEFAULT NULL,
50: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE DEFAULT NULL,
51: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
52: X_MSG_COUNT OUT NOCOPY NUMBER,
53: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 50: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE DEFAULT NULL,

46: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE DEFAULT NULL,
47: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE DEFAULT NULL,
48: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE DEFAULT NULL,
49: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE DEFAULT NULL,
50: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE DEFAULT NULL,
51: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
52: X_MSG_COUNT OUT NOCOPY NUMBER,
53: X_MSG_DATA OUT NOCOPY VARCHAR2,
54: X_SALESREP_ID OUT NOCOPY JTF_RS_SALESREPS.SALESREP_ID%TYPE

Line 54: X_SALESREP_ID OUT NOCOPY JTF_RS_SALESREPS.SALESREP_ID%TYPE

50: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE DEFAULT NULL,
51: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
52: X_MSG_COUNT OUT NOCOPY NUMBER,
53: X_MSG_DATA OUT NOCOPY VARCHAR2,
54: X_SALESREP_ID OUT NOCOPY JTF_RS_SALESREPS.SALESREP_ID%TYPE
55: );
56:
57: --Creating a Global Variable to be used for setting the flag,
58: --when the create_salesrep_migrate gets called

Line 69: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,

65: PROCEDURE create_salesrep_migrate(
66: P_API_VERSION IN NUMBER,
67: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
68: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
69: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
70: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
71: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT NULL,
72: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,
73: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,

Line 70: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,

66: P_API_VERSION IN NUMBER,
67: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
68: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
69: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
70: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
71: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT NULL,
72: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,
73: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
74: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,

Line 71: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT NULL,

67: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
68: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
69: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
70: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
71: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT NULL,
72: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,
73: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
74: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
75: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,

Line 72: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,

68: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
69: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
70: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
71: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT NULL,
72: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,
73: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
74: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
75: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
76: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,

Line 73: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,

69: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
70: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
71: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT NULL,
72: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,
73: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
74: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
75: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
76: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
77: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,

Line 74: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,

70: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
71: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT NULL,
72: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,
73: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
74: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
75: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
76: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
77: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
78: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,

Line 75: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,

71: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT NULL,
72: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,
73: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
74: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
75: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
76: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
77: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
78: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
79: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,

Line 76: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,

72: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,
73: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
74: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
75: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
76: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
77: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
78: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
79: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
80: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,

Line 77: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,

73: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
74: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
75: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
76: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
77: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
78: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
79: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
80: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,
81: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,

Line 78: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,

74: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
75: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
76: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
77: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
78: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
79: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
80: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,
81: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,
82: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,

Line 79: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,

75: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
76: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
77: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
78: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
79: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
80: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,
81: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,
82: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,
83: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,

Line 80: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,

76: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
77: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
78: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
79: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
80: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,
81: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,
82: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,
83: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,
84: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,

Line 81: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,

77: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
78: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
79: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
80: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,
81: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,
82: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,
83: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,
84: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
85: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE DEFAULT NULL,

Line 82: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,

78: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
79: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
80: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,
81: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,
82: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,
83: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,
84: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
85: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE DEFAULT NULL,
86: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE DEFAULT NULL,

Line 83: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,

79: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
80: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,
81: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,
82: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,
83: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,
84: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
85: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE DEFAULT NULL,
86: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE DEFAULT NULL,
87: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE DEFAULT NULL,

Line 84: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,

80: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,
81: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,
82: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,
83: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,
84: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
85: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE DEFAULT NULL,
86: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE DEFAULT NULL,
87: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE DEFAULT NULL,
88: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE DEFAULT NULL,

Line 85: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE DEFAULT NULL,

81: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,
82: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,
83: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,
84: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
85: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE DEFAULT NULL,
86: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE DEFAULT NULL,
87: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE DEFAULT NULL,
88: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE DEFAULT NULL,
89: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE DEFAULT NULL,

Line 86: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE DEFAULT NULL,

82: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,
83: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,
84: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
85: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE DEFAULT NULL,
86: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE DEFAULT NULL,
87: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE DEFAULT NULL,
88: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE DEFAULT NULL,
89: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE DEFAULT NULL,
90: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE DEFAULT NULL,

Line 87: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE DEFAULT NULL,

83: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,
84: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
85: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE DEFAULT NULL,
86: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE DEFAULT NULL,
87: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE DEFAULT NULL,
88: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE DEFAULT NULL,
89: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE DEFAULT NULL,
90: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE DEFAULT NULL,
91: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE DEFAULT NULL,

Line 88: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE DEFAULT NULL,

84: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
85: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE DEFAULT NULL,
86: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE DEFAULT NULL,
87: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE DEFAULT NULL,
88: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE DEFAULT NULL,
89: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE DEFAULT NULL,
90: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE DEFAULT NULL,
91: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE DEFAULT NULL,
92: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE DEFAULT NULL,

Line 89: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE DEFAULT NULL,

85: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE DEFAULT NULL,
86: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE DEFAULT NULL,
87: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE DEFAULT NULL,
88: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE DEFAULT NULL,
89: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE DEFAULT NULL,
90: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE DEFAULT NULL,
91: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE DEFAULT NULL,
92: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE DEFAULT NULL,
93: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE DEFAULT NULL,

Line 90: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE DEFAULT NULL,

86: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE DEFAULT NULL,
87: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE DEFAULT NULL,
88: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE DEFAULT NULL,
89: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE DEFAULT NULL,
90: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE DEFAULT NULL,
91: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE DEFAULT NULL,
92: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE DEFAULT NULL,
93: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE DEFAULT NULL,
94: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE DEFAULT NULL,

Line 91: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE DEFAULT NULL,

87: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE DEFAULT NULL,
88: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE DEFAULT NULL,
89: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE DEFAULT NULL,
90: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE DEFAULT NULL,
91: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE DEFAULT NULL,
92: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE DEFAULT NULL,
93: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE DEFAULT NULL,
94: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE DEFAULT NULL,
95: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE DEFAULT NULL,

Line 92: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE DEFAULT NULL,

88: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE DEFAULT NULL,
89: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE DEFAULT NULL,
90: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE DEFAULT NULL,
91: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE DEFAULT NULL,
92: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE DEFAULT NULL,
93: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE DEFAULT NULL,
94: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE DEFAULT NULL,
95: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE DEFAULT NULL,
96: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE DEFAULT NULL,

Line 93: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE DEFAULT NULL,

89: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE DEFAULT NULL,
90: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE DEFAULT NULL,
91: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE DEFAULT NULL,
92: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE DEFAULT NULL,
93: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE DEFAULT NULL,
94: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE DEFAULT NULL,
95: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE DEFAULT NULL,
96: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE DEFAULT NULL,
97: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE DEFAULT NULL,

Line 94: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE DEFAULT NULL,

90: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE DEFAULT NULL,
91: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE DEFAULT NULL,
92: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE DEFAULT NULL,
93: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE DEFAULT NULL,
94: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE DEFAULT NULL,
95: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE DEFAULT NULL,
96: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE DEFAULT NULL,
97: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE DEFAULT NULL,
98: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE DEFAULT NULL,

Line 95: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE DEFAULT NULL,

91: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE DEFAULT NULL,
92: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE DEFAULT NULL,
93: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE DEFAULT NULL,
94: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE DEFAULT NULL,
95: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE DEFAULT NULL,
96: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE DEFAULT NULL,
97: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE DEFAULT NULL,
98: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE DEFAULT NULL,
99: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE DEFAULT NULL,

Line 96: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE DEFAULT NULL,

92: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE DEFAULT NULL,
93: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE DEFAULT NULL,
94: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE DEFAULT NULL,
95: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE DEFAULT NULL,
96: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE DEFAULT NULL,
97: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE DEFAULT NULL,
98: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE DEFAULT NULL,
99: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE DEFAULT NULL,
100: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,

Line 97: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE DEFAULT NULL,

93: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE DEFAULT NULL,
94: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE DEFAULT NULL,
95: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE DEFAULT NULL,
96: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE DEFAULT NULL,
97: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE DEFAULT NULL,
98: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE DEFAULT NULL,
99: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE DEFAULT NULL,
100: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
101: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,

Line 98: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE DEFAULT NULL,

94: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE DEFAULT NULL,
95: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE DEFAULT NULL,
96: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE DEFAULT NULL,
97: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE DEFAULT NULL,
98: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE DEFAULT NULL,
99: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE DEFAULT NULL,
100: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
101: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
102: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 99: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE DEFAULT NULL,

95: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE DEFAULT NULL,
96: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE DEFAULT NULL,
97: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE DEFAULT NULL,
98: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE DEFAULT NULL,
99: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE DEFAULT NULL,
100: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
101: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
102: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
103: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 100: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,

96: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE DEFAULT NULL,
97: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE DEFAULT NULL,
98: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE DEFAULT NULL,
99: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE DEFAULT NULL,
100: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
101: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
102: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
103: X_MSG_COUNT OUT NOCOPY NUMBER,
104: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 101: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,

97: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE DEFAULT NULL,
98: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE DEFAULT NULL,
99: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE DEFAULT NULL,
100: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
101: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
102: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
103: X_MSG_COUNT OUT NOCOPY NUMBER,
104: X_MSG_DATA OUT NOCOPY VARCHAR2,
105: X_SALESREP_ID OUT NOCOPY JTF_RS_SALESREPS.SALESREP_ID%TYPE

Line 105: X_SALESREP_ID OUT NOCOPY JTF_RS_SALESREPS.SALESREP_ID%TYPE

101: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
102: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
103: X_MSG_COUNT OUT NOCOPY NUMBER,
104: X_MSG_DATA OUT NOCOPY VARCHAR2,
105: X_SALESREP_ID OUT NOCOPY JTF_RS_SALESREPS.SALESREP_ID%TYPE
106: );
107:
108:
109: /* Procedure to update salesreps */

Line 114: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,

110: PROCEDURE Update_salesrep(
111: P_API_VERSION IN NUMBER,
112: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
113: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
114: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
115: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
116: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
117: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
118: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,

Line 115: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,

111: P_API_VERSION IN NUMBER,
112: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
113: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
114: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
115: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
116: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
117: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
118: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
119: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,

Line 116: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,

112: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
113: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
114: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
115: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
116: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
117: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
118: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
119: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
120: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT FND_API.G_MISS_NUM,

Line 117: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,

113: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
114: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
115: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
116: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
117: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
118: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
119: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
120: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT FND_API.G_MISS_NUM,
121: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT FND_API.G_MISS_NUM,

Line 118: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,

114: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
115: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
116: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
117: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
118: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
119: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
120: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT FND_API.G_MISS_NUM,
121: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT FND_API.G_MISS_NUM,
122: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT FND_API.G_MISS_NUM,

Line 119: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,

115: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
116: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
117: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
118: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
119: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
120: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT FND_API.G_MISS_NUM,
121: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT FND_API.G_MISS_NUM,
122: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT FND_API.G_MISS_NUM,
123: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT FND_API.G_MISS_NUM,

Line 120: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT FND_API.G_MISS_NUM,

116: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
117: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
118: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
119: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
120: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT FND_API.G_MISS_NUM,
121: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT FND_API.G_MISS_NUM,
122: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT FND_API.G_MISS_NUM,
123: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
124: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 121: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT FND_API.G_MISS_NUM,

117: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
118: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
119: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
120: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT FND_API.G_MISS_NUM,
121: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT FND_API.G_MISS_NUM,
122: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT FND_API.G_MISS_NUM,
123: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
124: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT FND_API.G_MISS_CHAR,
125: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 122: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT FND_API.G_MISS_NUM,

118: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
119: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
120: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT FND_API.G_MISS_NUM,
121: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT FND_API.G_MISS_NUM,
122: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT FND_API.G_MISS_NUM,
123: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
124: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT FND_API.G_MISS_CHAR,
125: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
126: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,

Line 123: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT FND_API.G_MISS_NUM,

119: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
120: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT FND_API.G_MISS_NUM,
121: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT FND_API.G_MISS_NUM,
122: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT FND_API.G_MISS_NUM,
123: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
124: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT FND_API.G_MISS_CHAR,
125: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
126: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
127: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 124: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT FND_API.G_MISS_CHAR,

120: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT FND_API.G_MISS_NUM,
121: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT FND_API.G_MISS_NUM,
122: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT FND_API.G_MISS_NUM,
123: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
124: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT FND_API.G_MISS_CHAR,
125: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
126: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
127: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
128: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 125: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,

121: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT FND_API.G_MISS_NUM,
122: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT FND_API.G_MISS_NUM,
123: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
124: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT FND_API.G_MISS_CHAR,
125: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
126: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
127: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
128: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT FND_API.G_MISS_CHAR,
129: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,

Line 126: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,

122: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT FND_API.G_MISS_NUM,
123: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
124: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT FND_API.G_MISS_CHAR,
125: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
126: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
127: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
128: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT FND_API.G_MISS_CHAR,
129: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
130: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SALESREPS.OBJECT_VERSION_NUMBER%TYPE,

Line 127: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT FND_API.G_MISS_CHAR,

123: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
124: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT FND_API.G_MISS_CHAR,
125: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
126: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
127: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
128: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT FND_API.G_MISS_CHAR,
129: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
130: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SALESREPS.OBJECT_VERSION_NUMBER%TYPE,
131: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 128: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT FND_API.G_MISS_CHAR,

124: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT FND_API.G_MISS_CHAR,
125: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
126: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
127: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
128: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT FND_API.G_MISS_CHAR,
129: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
130: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SALESREPS.OBJECT_VERSION_NUMBER%TYPE,
131: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
132: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 129: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,

125: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
126: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
127: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
128: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT FND_API.G_MISS_CHAR,
129: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
130: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SALESREPS.OBJECT_VERSION_NUMBER%TYPE,
131: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
132: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
133: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 130: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SALESREPS.OBJECT_VERSION_NUMBER%TYPE,

126: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
127: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
128: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT FND_API.G_MISS_CHAR,
129: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
130: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SALESREPS.OBJECT_VERSION_NUMBER%TYPE,
131: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
132: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
133: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
134: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 131: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,

127: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
128: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT FND_API.G_MISS_CHAR,
129: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
130: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SALESREPS.OBJECT_VERSION_NUMBER%TYPE,
131: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
132: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
133: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
134: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
135: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 132: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,

128: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT FND_API.G_MISS_CHAR,
129: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
130: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SALESREPS.OBJECT_VERSION_NUMBER%TYPE,
131: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
132: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
133: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
134: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
135: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
136: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 133: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,

129: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
130: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SALESREPS.OBJECT_VERSION_NUMBER%TYPE,
131: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
132: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
133: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
134: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
135: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
136: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
137: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 134: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,

130: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SALESREPS.OBJECT_VERSION_NUMBER%TYPE,
131: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
132: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
133: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
134: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
135: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
136: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
137: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
138: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 135: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,

131: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
132: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
133: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
134: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
135: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
136: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
137: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
138: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
139: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 136: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,

132: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
133: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
134: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
135: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
136: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
137: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
138: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
139: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
140: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 137: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,

133: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
134: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
135: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
136: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
137: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
138: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
139: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
140: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
141: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 138: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,

134: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
135: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
136: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
137: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
138: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
139: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
140: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
141: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
142: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 139: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,

135: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
136: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
137: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
138: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
139: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
140: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
141: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
142: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
143: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 140: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,

136: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
137: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
138: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
139: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
140: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
141: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
142: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
143: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
144: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 141: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,

137: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
138: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
139: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
140: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
141: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
142: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
143: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
144: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
145: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 142: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,

138: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
139: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
140: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
141: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
142: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
143: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
144: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
145: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
146: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 143: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,

139: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
140: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
141: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
142: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
143: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
144: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
145: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
146: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
147: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 144: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,

140: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
141: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
142: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
143: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
144: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
145: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
146: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
147: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
148: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 145: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,

141: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
142: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
143: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
144: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
145: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
146: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
147: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
148: X_MSG_COUNT OUT NOCOPY NUMBER,
149: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 146: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,

142: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
143: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
144: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
145: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
146: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
147: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
148: X_MSG_COUNT OUT NOCOPY NUMBER,
149: X_MSG_DATA OUT NOCOPY VARCHAR2
150: );

Line 152: End JTF_RS_SALESREPS_PVT;

148: X_MSG_COUNT OUT NOCOPY NUMBER,
149: X_MSG_DATA OUT NOCOPY VARCHAR2
150: );
151:
152: End JTF_RS_SALESREPS_PVT;