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_PUB dependencies on JTF_RS_SALESREPS

Line 1: PACKAGE jtf_rs_salesreps_pub AS

1: PACKAGE jtf_rs_salesreps_pub AS
2: /* $Header: jtfrspss.pls 120.3 2005/07/19 18:56:53 repuri ship $ */
3: /*#
4: * Salesperson create and update API
5: * This API contains the procedures to insert and update Salesrep record.

Line 57: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,

53: PROCEDURE create_salesrep
54: (P_API_VERSION IN NUMBER,
55: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
56: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
57: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
58: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
59: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT NULL,
60: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,
61: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,

Line 58: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,

54: (P_API_VERSION IN NUMBER,
55: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
56: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
57: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
58: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
59: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT NULL,
60: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,
61: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
62: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,

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

55: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
56: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
57: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
58: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
59: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT NULL,
60: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,
61: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
62: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
63: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,

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

56: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
57: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
58: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
59: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT NULL,
60: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,
61: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
62: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
63: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
64: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,

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

57: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
58: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
59: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT NULL,
60: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,
61: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
62: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
63: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
64: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
65: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,

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

58: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
59: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT NULL,
60: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,
61: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
62: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
63: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
64: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
65: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
66: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,

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

59: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT NULL,
60: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,
61: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
62: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
63: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
64: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
65: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
66: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
67: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,

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

60: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,
61: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
62: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
63: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
64: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
65: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
66: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
67: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
68: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,

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

61: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
62: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
63: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
64: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
65: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
66: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
67: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
68: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
69: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,

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

62: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
63: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
64: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
65: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
66: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
67: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
68: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
69: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,
70: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,

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

63: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
64: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
65: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
66: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
67: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
68: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
69: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,
70: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,
71: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,

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

64: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
65: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
66: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
67: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
68: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
69: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,
70: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,
71: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,
72: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,

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

65: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
66: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
67: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
68: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
69: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,
70: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,
71: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,
72: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,
73: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

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

66: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
67: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
68: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
69: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,
70: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,
71: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,
72: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,
73: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
74: X_MSG_COUNT OUT NOCOPY NUMBER,

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

67: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
68: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
69: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,
70: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,
71: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,
72: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,
73: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
74: X_MSG_COUNT OUT NOCOPY NUMBER,
75: X_MSG_DATA OUT NOCOPY VARCHAR2,

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

68: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
69: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,
70: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,
71: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,
72: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,
73: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
74: X_MSG_COUNT OUT NOCOPY NUMBER,
75: X_MSG_DATA OUT NOCOPY VARCHAR2,
76: X_SALESREP_ID OUT NOCOPY JTF_RS_SALESREPS.SALESREP_ID%TYPE

Line 76: X_SALESREP_ID OUT NOCOPY JTF_RS_SALESREPS.SALESREP_ID%TYPE

72: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,
73: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
74: X_MSG_COUNT OUT NOCOPY NUMBER,
75: X_MSG_DATA OUT NOCOPY VARCHAR2,
76: X_SALESREP_ID OUT NOCOPY JTF_RS_SALESREPS.SALESREP_ID%TYPE
77: );
78:
79: --Create Salesrep Migration API, used for one-time migration of salesrep data
80: --The API includes SALESREP_ID, ORG_ID as its Input Parameters

Line 133: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,

129: PROCEDURE create_salesrep_migrate
130: (P_API_VERSION IN NUMBER,
131: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
132: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
133: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
134: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
135: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT NULL,
136: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,
137: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,

Line 134: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,

130: (P_API_VERSION IN NUMBER,
131: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
132: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
133: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
134: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
135: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT NULL,
136: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,
137: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
138: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,

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

131: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
132: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
133: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
134: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
135: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT NULL,
136: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,
137: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
138: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
139: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,

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

132: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
133: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
134: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
135: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT NULL,
136: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,
137: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
138: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
139: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
140: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,

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

133: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
134: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
135: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT NULL,
136: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,
137: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
138: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
139: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
140: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
141: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,

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

134: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
135: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT NULL,
136: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,
137: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
138: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
139: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
140: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
141: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
142: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,

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

135: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT NULL,
136: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,
137: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
138: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
139: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
140: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
141: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
142: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
143: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,

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

136: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,
137: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
138: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
139: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
140: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
141: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
142: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
143: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
144: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,

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

137: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
138: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
139: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
140: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
141: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
142: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
143: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
144: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,
145: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,

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

138: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
139: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
140: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
141: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
142: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
143: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
144: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,
145: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,
146: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,

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

139: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
140: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
141: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
142: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
143: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
144: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,
145: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,
146: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,
147: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,

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

140: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
141: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
142: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
143: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
144: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,
145: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,
146: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,
147: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,
148: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,

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

141: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
142: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
143: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
144: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,
145: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,
146: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,
147: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,
148: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
149: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,

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

142: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
143: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
144: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,
145: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,
146: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,
147: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,
148: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
149: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
150: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,

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

143: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
144: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,
145: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,
146: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,
147: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,
148: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
149: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
150: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
151: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE DEFAULT NULL,

Line 148: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,

144: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,
145: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,
146: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,
147: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,
148: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
149: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
150: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
151: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE DEFAULT NULL,
152: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE DEFAULT NULL,

Line 149: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,

145: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,
146: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,
147: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,
148: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
149: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
150: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
151: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE DEFAULT NULL,
152: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE DEFAULT NULL,
153: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE DEFAULT NULL,

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

146: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,
147: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,
148: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
149: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
150: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
151: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE DEFAULT NULL,
152: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE DEFAULT NULL,
153: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE DEFAULT NULL,
154: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE DEFAULT NULL,

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

147: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,
148: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
149: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
150: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
151: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE DEFAULT NULL,
152: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE DEFAULT NULL,
153: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE DEFAULT NULL,
154: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE DEFAULT NULL,
155: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE DEFAULT NULL,

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

148: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
149: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
150: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
151: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE DEFAULT NULL,
152: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE DEFAULT NULL,
153: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE DEFAULT NULL,
154: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE DEFAULT NULL,
155: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE DEFAULT NULL,
156: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE DEFAULT NULL,

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

149: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
150: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
151: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE DEFAULT NULL,
152: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE DEFAULT NULL,
153: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE DEFAULT NULL,
154: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE DEFAULT NULL,
155: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE DEFAULT NULL,
156: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE DEFAULT NULL,
157: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE DEFAULT NULL,

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

150: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
151: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE DEFAULT NULL,
152: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE DEFAULT NULL,
153: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE DEFAULT NULL,
154: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE DEFAULT NULL,
155: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE DEFAULT NULL,
156: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE DEFAULT NULL,
157: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE DEFAULT NULL,
158: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE DEFAULT NULL,

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

151: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE DEFAULT NULL,
152: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE DEFAULT NULL,
153: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE DEFAULT NULL,
154: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE DEFAULT NULL,
155: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE DEFAULT NULL,
156: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE DEFAULT NULL,
157: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE DEFAULT NULL,
158: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE DEFAULT NULL,
159: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE DEFAULT NULL,

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

152: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE DEFAULT NULL,
153: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE DEFAULT NULL,
154: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE DEFAULT NULL,
155: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE DEFAULT NULL,
156: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE DEFAULT NULL,
157: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE DEFAULT NULL,
158: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE DEFAULT NULL,
159: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE DEFAULT NULL,
160: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE DEFAULT NULL,

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

153: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE DEFAULT NULL,
154: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE DEFAULT NULL,
155: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE DEFAULT NULL,
156: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE DEFAULT NULL,
157: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE DEFAULT NULL,
158: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE DEFAULT NULL,
159: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE DEFAULT NULL,
160: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE DEFAULT NULL,
161: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE DEFAULT NULL,

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

154: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE DEFAULT NULL,
155: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE DEFAULT NULL,
156: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE DEFAULT NULL,
157: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE DEFAULT NULL,
158: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE DEFAULT NULL,
159: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE DEFAULT NULL,
160: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE DEFAULT NULL,
161: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE DEFAULT NULL,
162: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE DEFAULT NULL,

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

155: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE DEFAULT NULL,
156: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE DEFAULT NULL,
157: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE DEFAULT NULL,
158: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE DEFAULT NULL,
159: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE DEFAULT NULL,
160: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE DEFAULT NULL,
161: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE DEFAULT NULL,
162: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE DEFAULT NULL,
163: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE DEFAULT NULL,

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

156: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE DEFAULT NULL,
157: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE DEFAULT NULL,
158: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE DEFAULT NULL,
159: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE DEFAULT NULL,
160: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE DEFAULT NULL,
161: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE DEFAULT NULL,
162: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE DEFAULT NULL,
163: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE DEFAULT NULL,
164: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE DEFAULT NULL,

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

157: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE DEFAULT NULL,
158: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE DEFAULT NULL,
159: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE DEFAULT NULL,
160: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE DEFAULT NULL,
161: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE DEFAULT NULL,
162: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE DEFAULT NULL,
163: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE DEFAULT NULL,
164: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE DEFAULT NULL,
165: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE DEFAULT NULL,

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

158: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE DEFAULT NULL,
159: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE DEFAULT NULL,
160: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE DEFAULT NULL,
161: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE DEFAULT NULL,
162: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE DEFAULT NULL,
163: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE DEFAULT NULL,
164: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE DEFAULT NULL,
165: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE DEFAULT NULL,
166: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

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

159: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE DEFAULT NULL,
160: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE DEFAULT NULL,
161: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE DEFAULT NULL,
162: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE DEFAULT NULL,
163: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE DEFAULT NULL,
164: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE DEFAULT NULL,
165: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE DEFAULT NULL,
166: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
167: X_MSG_COUNT OUT NOCOPY NUMBER,

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

160: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE DEFAULT NULL,
161: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE DEFAULT NULL,
162: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE DEFAULT NULL,
163: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE DEFAULT NULL,
164: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE DEFAULT NULL,
165: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE DEFAULT NULL,
166: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
167: X_MSG_COUNT OUT NOCOPY NUMBER,
168: X_MSG_DATA OUT NOCOPY VARCHAR2,

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

161: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE DEFAULT NULL,
162: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE DEFAULT NULL,
163: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE DEFAULT NULL,
164: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE DEFAULT NULL,
165: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE DEFAULT NULL,
166: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
167: X_MSG_COUNT OUT NOCOPY NUMBER,
168: X_MSG_DATA OUT NOCOPY VARCHAR2,
169: X_SALESREP_ID OUT NOCOPY JTF_RS_SALESREPS.SALESREP_ID%TYPE

Line 169: X_SALESREP_ID OUT NOCOPY JTF_RS_SALESREPS.SALESREP_ID%TYPE

165: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE DEFAULT NULL,
166: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
167: X_MSG_COUNT OUT NOCOPY NUMBER,
168: X_MSG_DATA OUT NOCOPY VARCHAR2,
169: X_SALESREP_ID OUT NOCOPY JTF_RS_SALESREPS.SALESREP_ID%TYPE
170: );
171:
172: --Creating a Global Variable to be used for setting the flag,
173: --when the create_salesrep_migrate gets called

Line 176: G_SALESREP_ID JTF_RS_SALESREPS.SALESREP_ID%TYPE := NULL;

172: --Creating a Global Variable to be used for setting the flag,
173: --when the create_salesrep_migrate gets called
174:
175: G_SRP_ID_PUB_FLAG VARCHAR2(1) := 'Y';
176: G_SALESREP_ID JTF_RS_SALESREPS.SALESREP_ID%TYPE := NULL;
177: G_ORG_ID JTF_RS_SALESREPS.ORG_ID%TYPE := NULL;
178: G_ATTRIBUTE1 JTF_RS_SALESREPS.ATTRIBUTE1%TYPE := NULL;
179: G_ATTRIBUTE2 JTF_RS_SALESREPS.ATTRIBUTE2%TYPE := NULL;
180: G_ATTRIBUTE3 JTF_RS_SALESREPS.ATTRIBUTE3%TYPE := NULL;

Line 177: G_ORG_ID JTF_RS_SALESREPS.ORG_ID%TYPE := NULL;

173: --when the create_salesrep_migrate gets called
174:
175: G_SRP_ID_PUB_FLAG VARCHAR2(1) := 'Y';
176: G_SALESREP_ID JTF_RS_SALESREPS.SALESREP_ID%TYPE := NULL;
177: G_ORG_ID JTF_RS_SALESREPS.ORG_ID%TYPE := NULL;
178: G_ATTRIBUTE1 JTF_RS_SALESREPS.ATTRIBUTE1%TYPE := NULL;
179: G_ATTRIBUTE2 JTF_RS_SALESREPS.ATTRIBUTE2%TYPE := NULL;
180: G_ATTRIBUTE3 JTF_RS_SALESREPS.ATTRIBUTE3%TYPE := NULL;
181: G_ATTRIBUTE4 JTF_RS_SALESREPS.ATTRIBUTE4%TYPE := NULL;

Line 178: G_ATTRIBUTE1 JTF_RS_SALESREPS.ATTRIBUTE1%TYPE := NULL;

174:
175: G_SRP_ID_PUB_FLAG VARCHAR2(1) := 'Y';
176: G_SALESREP_ID JTF_RS_SALESREPS.SALESREP_ID%TYPE := NULL;
177: G_ORG_ID JTF_RS_SALESREPS.ORG_ID%TYPE := NULL;
178: G_ATTRIBUTE1 JTF_RS_SALESREPS.ATTRIBUTE1%TYPE := NULL;
179: G_ATTRIBUTE2 JTF_RS_SALESREPS.ATTRIBUTE2%TYPE := NULL;
180: G_ATTRIBUTE3 JTF_RS_SALESREPS.ATTRIBUTE3%TYPE := NULL;
181: G_ATTRIBUTE4 JTF_RS_SALESREPS.ATTRIBUTE4%TYPE := NULL;
182: G_ATTRIBUTE5 JTF_RS_SALESREPS.ATTRIBUTE5%TYPE := NULL;

Line 179: G_ATTRIBUTE2 JTF_RS_SALESREPS.ATTRIBUTE2%TYPE := NULL;

175: G_SRP_ID_PUB_FLAG VARCHAR2(1) := 'Y';
176: G_SALESREP_ID JTF_RS_SALESREPS.SALESREP_ID%TYPE := NULL;
177: G_ORG_ID JTF_RS_SALESREPS.ORG_ID%TYPE := NULL;
178: G_ATTRIBUTE1 JTF_RS_SALESREPS.ATTRIBUTE1%TYPE := NULL;
179: G_ATTRIBUTE2 JTF_RS_SALESREPS.ATTRIBUTE2%TYPE := NULL;
180: G_ATTRIBUTE3 JTF_RS_SALESREPS.ATTRIBUTE3%TYPE := NULL;
181: G_ATTRIBUTE4 JTF_RS_SALESREPS.ATTRIBUTE4%TYPE := NULL;
182: G_ATTRIBUTE5 JTF_RS_SALESREPS.ATTRIBUTE5%TYPE := NULL;
183: G_ATTRIBUTE6 JTF_RS_SALESREPS.ATTRIBUTE6%TYPE := NULL;

Line 180: G_ATTRIBUTE3 JTF_RS_SALESREPS.ATTRIBUTE3%TYPE := NULL;

176: G_SALESREP_ID JTF_RS_SALESREPS.SALESREP_ID%TYPE := NULL;
177: G_ORG_ID JTF_RS_SALESREPS.ORG_ID%TYPE := NULL;
178: G_ATTRIBUTE1 JTF_RS_SALESREPS.ATTRIBUTE1%TYPE := NULL;
179: G_ATTRIBUTE2 JTF_RS_SALESREPS.ATTRIBUTE2%TYPE := NULL;
180: G_ATTRIBUTE3 JTF_RS_SALESREPS.ATTRIBUTE3%TYPE := NULL;
181: G_ATTRIBUTE4 JTF_RS_SALESREPS.ATTRIBUTE4%TYPE := NULL;
182: G_ATTRIBUTE5 JTF_RS_SALESREPS.ATTRIBUTE5%TYPE := NULL;
183: G_ATTRIBUTE6 JTF_RS_SALESREPS.ATTRIBUTE6%TYPE := NULL;
184: G_ATTRIBUTE7 JTF_RS_SALESREPS.ATTRIBUTE7%TYPE := NULL;

Line 181: G_ATTRIBUTE4 JTF_RS_SALESREPS.ATTRIBUTE4%TYPE := NULL;

177: G_ORG_ID JTF_RS_SALESREPS.ORG_ID%TYPE := NULL;
178: G_ATTRIBUTE1 JTF_RS_SALESREPS.ATTRIBUTE1%TYPE := NULL;
179: G_ATTRIBUTE2 JTF_RS_SALESREPS.ATTRIBUTE2%TYPE := NULL;
180: G_ATTRIBUTE3 JTF_RS_SALESREPS.ATTRIBUTE3%TYPE := NULL;
181: G_ATTRIBUTE4 JTF_RS_SALESREPS.ATTRIBUTE4%TYPE := NULL;
182: G_ATTRIBUTE5 JTF_RS_SALESREPS.ATTRIBUTE5%TYPE := NULL;
183: G_ATTRIBUTE6 JTF_RS_SALESREPS.ATTRIBUTE6%TYPE := NULL;
184: G_ATTRIBUTE7 JTF_RS_SALESREPS.ATTRIBUTE7%TYPE := NULL;
185: G_ATTRIBUTE8 JTF_RS_SALESREPS.ATTRIBUTE8%TYPE := NULL;

Line 182: G_ATTRIBUTE5 JTF_RS_SALESREPS.ATTRIBUTE5%TYPE := NULL;

178: G_ATTRIBUTE1 JTF_RS_SALESREPS.ATTRIBUTE1%TYPE := NULL;
179: G_ATTRIBUTE2 JTF_RS_SALESREPS.ATTRIBUTE2%TYPE := NULL;
180: G_ATTRIBUTE3 JTF_RS_SALESREPS.ATTRIBUTE3%TYPE := NULL;
181: G_ATTRIBUTE4 JTF_RS_SALESREPS.ATTRIBUTE4%TYPE := NULL;
182: G_ATTRIBUTE5 JTF_RS_SALESREPS.ATTRIBUTE5%TYPE := NULL;
183: G_ATTRIBUTE6 JTF_RS_SALESREPS.ATTRIBUTE6%TYPE := NULL;
184: G_ATTRIBUTE7 JTF_RS_SALESREPS.ATTRIBUTE7%TYPE := NULL;
185: G_ATTRIBUTE8 JTF_RS_SALESREPS.ATTRIBUTE8%TYPE := NULL;
186: G_ATTRIBUTE9 JTF_RS_SALESREPS.ATTRIBUTE9%TYPE := NULL;

Line 183: G_ATTRIBUTE6 JTF_RS_SALESREPS.ATTRIBUTE6%TYPE := NULL;

179: G_ATTRIBUTE2 JTF_RS_SALESREPS.ATTRIBUTE2%TYPE := NULL;
180: G_ATTRIBUTE3 JTF_RS_SALESREPS.ATTRIBUTE3%TYPE := NULL;
181: G_ATTRIBUTE4 JTF_RS_SALESREPS.ATTRIBUTE4%TYPE := NULL;
182: G_ATTRIBUTE5 JTF_RS_SALESREPS.ATTRIBUTE5%TYPE := NULL;
183: G_ATTRIBUTE6 JTF_RS_SALESREPS.ATTRIBUTE6%TYPE := NULL;
184: G_ATTRIBUTE7 JTF_RS_SALESREPS.ATTRIBUTE7%TYPE := NULL;
185: G_ATTRIBUTE8 JTF_RS_SALESREPS.ATTRIBUTE8%TYPE := NULL;
186: G_ATTRIBUTE9 JTF_RS_SALESREPS.ATTRIBUTE9%TYPE := NULL;
187: G_ATTRIBUTE10 JTF_RS_SALESREPS.ATTRIBUTE10%TYPE := NULL;

Line 184: G_ATTRIBUTE7 JTF_RS_SALESREPS.ATTRIBUTE7%TYPE := NULL;

180: G_ATTRIBUTE3 JTF_RS_SALESREPS.ATTRIBUTE3%TYPE := NULL;
181: G_ATTRIBUTE4 JTF_RS_SALESREPS.ATTRIBUTE4%TYPE := NULL;
182: G_ATTRIBUTE5 JTF_RS_SALESREPS.ATTRIBUTE5%TYPE := NULL;
183: G_ATTRIBUTE6 JTF_RS_SALESREPS.ATTRIBUTE6%TYPE := NULL;
184: G_ATTRIBUTE7 JTF_RS_SALESREPS.ATTRIBUTE7%TYPE := NULL;
185: G_ATTRIBUTE8 JTF_RS_SALESREPS.ATTRIBUTE8%TYPE := NULL;
186: G_ATTRIBUTE9 JTF_RS_SALESREPS.ATTRIBUTE9%TYPE := NULL;
187: G_ATTRIBUTE10 JTF_RS_SALESREPS.ATTRIBUTE10%TYPE := NULL;
188: G_ATTRIBUTE11 JTF_RS_SALESREPS.ATTRIBUTE11%TYPE := NULL;

Line 185: G_ATTRIBUTE8 JTF_RS_SALESREPS.ATTRIBUTE8%TYPE := NULL;

181: G_ATTRIBUTE4 JTF_RS_SALESREPS.ATTRIBUTE4%TYPE := NULL;
182: G_ATTRIBUTE5 JTF_RS_SALESREPS.ATTRIBUTE5%TYPE := NULL;
183: G_ATTRIBUTE6 JTF_RS_SALESREPS.ATTRIBUTE6%TYPE := NULL;
184: G_ATTRIBUTE7 JTF_RS_SALESREPS.ATTRIBUTE7%TYPE := NULL;
185: G_ATTRIBUTE8 JTF_RS_SALESREPS.ATTRIBUTE8%TYPE := NULL;
186: G_ATTRIBUTE9 JTF_RS_SALESREPS.ATTRIBUTE9%TYPE := NULL;
187: G_ATTRIBUTE10 JTF_RS_SALESREPS.ATTRIBUTE10%TYPE := NULL;
188: G_ATTRIBUTE11 JTF_RS_SALESREPS.ATTRIBUTE11%TYPE := NULL;
189: G_ATTRIBUTE12 JTF_RS_SALESREPS.ATTRIBUTE12%TYPE := NULL;

Line 186: G_ATTRIBUTE9 JTF_RS_SALESREPS.ATTRIBUTE9%TYPE := NULL;

182: G_ATTRIBUTE5 JTF_RS_SALESREPS.ATTRIBUTE5%TYPE := NULL;
183: G_ATTRIBUTE6 JTF_RS_SALESREPS.ATTRIBUTE6%TYPE := NULL;
184: G_ATTRIBUTE7 JTF_RS_SALESREPS.ATTRIBUTE7%TYPE := NULL;
185: G_ATTRIBUTE8 JTF_RS_SALESREPS.ATTRIBUTE8%TYPE := NULL;
186: G_ATTRIBUTE9 JTF_RS_SALESREPS.ATTRIBUTE9%TYPE := NULL;
187: G_ATTRIBUTE10 JTF_RS_SALESREPS.ATTRIBUTE10%TYPE := NULL;
188: G_ATTRIBUTE11 JTF_RS_SALESREPS.ATTRIBUTE11%TYPE := NULL;
189: G_ATTRIBUTE12 JTF_RS_SALESREPS.ATTRIBUTE12%TYPE := NULL;
190: G_ATTRIBUTE13 JTF_RS_SALESREPS.ATTRIBUTE13%TYPE := NULL;

Line 187: G_ATTRIBUTE10 JTF_RS_SALESREPS.ATTRIBUTE10%TYPE := NULL;

183: G_ATTRIBUTE6 JTF_RS_SALESREPS.ATTRIBUTE6%TYPE := NULL;
184: G_ATTRIBUTE7 JTF_RS_SALESREPS.ATTRIBUTE7%TYPE := NULL;
185: G_ATTRIBUTE8 JTF_RS_SALESREPS.ATTRIBUTE8%TYPE := NULL;
186: G_ATTRIBUTE9 JTF_RS_SALESREPS.ATTRIBUTE9%TYPE := NULL;
187: G_ATTRIBUTE10 JTF_RS_SALESREPS.ATTRIBUTE10%TYPE := NULL;
188: G_ATTRIBUTE11 JTF_RS_SALESREPS.ATTRIBUTE11%TYPE := NULL;
189: G_ATTRIBUTE12 JTF_RS_SALESREPS.ATTRIBUTE12%TYPE := NULL;
190: G_ATTRIBUTE13 JTF_RS_SALESREPS.ATTRIBUTE13%TYPE := NULL;
191: G_ATTRIBUTE14 JTF_RS_SALESREPS.ATTRIBUTE14%TYPE := NULL;

Line 188: G_ATTRIBUTE11 JTF_RS_SALESREPS.ATTRIBUTE11%TYPE := NULL;

184: G_ATTRIBUTE7 JTF_RS_SALESREPS.ATTRIBUTE7%TYPE := NULL;
185: G_ATTRIBUTE8 JTF_RS_SALESREPS.ATTRIBUTE8%TYPE := NULL;
186: G_ATTRIBUTE9 JTF_RS_SALESREPS.ATTRIBUTE9%TYPE := NULL;
187: G_ATTRIBUTE10 JTF_RS_SALESREPS.ATTRIBUTE10%TYPE := NULL;
188: G_ATTRIBUTE11 JTF_RS_SALESREPS.ATTRIBUTE11%TYPE := NULL;
189: G_ATTRIBUTE12 JTF_RS_SALESREPS.ATTRIBUTE12%TYPE := NULL;
190: G_ATTRIBUTE13 JTF_RS_SALESREPS.ATTRIBUTE13%TYPE := NULL;
191: G_ATTRIBUTE14 JTF_RS_SALESREPS.ATTRIBUTE14%TYPE := NULL;
192: G_ATTRIBUTE15 JTF_RS_SALESREPS.ATTRIBUTE15%TYPE := NULL;

Line 189: G_ATTRIBUTE12 JTF_RS_SALESREPS.ATTRIBUTE12%TYPE := NULL;

185: G_ATTRIBUTE8 JTF_RS_SALESREPS.ATTRIBUTE8%TYPE := NULL;
186: G_ATTRIBUTE9 JTF_RS_SALESREPS.ATTRIBUTE9%TYPE := NULL;
187: G_ATTRIBUTE10 JTF_RS_SALESREPS.ATTRIBUTE10%TYPE := NULL;
188: G_ATTRIBUTE11 JTF_RS_SALESREPS.ATTRIBUTE11%TYPE := NULL;
189: G_ATTRIBUTE12 JTF_RS_SALESREPS.ATTRIBUTE12%TYPE := NULL;
190: G_ATTRIBUTE13 JTF_RS_SALESREPS.ATTRIBUTE13%TYPE := NULL;
191: G_ATTRIBUTE14 JTF_RS_SALESREPS.ATTRIBUTE14%TYPE := NULL;
192: G_ATTRIBUTE15 JTF_RS_SALESREPS.ATTRIBUTE15%TYPE := NULL;
193: G_ATTRIBUTE_CATEGORY JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE := NULL;

Line 190: G_ATTRIBUTE13 JTF_RS_SALESREPS.ATTRIBUTE13%TYPE := NULL;

186: G_ATTRIBUTE9 JTF_RS_SALESREPS.ATTRIBUTE9%TYPE := NULL;
187: G_ATTRIBUTE10 JTF_RS_SALESREPS.ATTRIBUTE10%TYPE := NULL;
188: G_ATTRIBUTE11 JTF_RS_SALESREPS.ATTRIBUTE11%TYPE := NULL;
189: G_ATTRIBUTE12 JTF_RS_SALESREPS.ATTRIBUTE12%TYPE := NULL;
190: G_ATTRIBUTE13 JTF_RS_SALESREPS.ATTRIBUTE13%TYPE := NULL;
191: G_ATTRIBUTE14 JTF_RS_SALESREPS.ATTRIBUTE14%TYPE := NULL;
192: G_ATTRIBUTE15 JTF_RS_SALESREPS.ATTRIBUTE15%TYPE := NULL;
193: G_ATTRIBUTE_CATEGORY JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE := NULL;
194:

Line 191: G_ATTRIBUTE14 JTF_RS_SALESREPS.ATTRIBUTE14%TYPE := NULL;

187: G_ATTRIBUTE10 JTF_RS_SALESREPS.ATTRIBUTE10%TYPE := NULL;
188: G_ATTRIBUTE11 JTF_RS_SALESREPS.ATTRIBUTE11%TYPE := NULL;
189: G_ATTRIBUTE12 JTF_RS_SALESREPS.ATTRIBUTE12%TYPE := NULL;
190: G_ATTRIBUTE13 JTF_RS_SALESREPS.ATTRIBUTE13%TYPE := NULL;
191: G_ATTRIBUTE14 JTF_RS_SALESREPS.ATTRIBUTE14%TYPE := NULL;
192: G_ATTRIBUTE15 JTF_RS_SALESREPS.ATTRIBUTE15%TYPE := NULL;
193: G_ATTRIBUTE_CATEGORY JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE := NULL;
194:
195: /* Procedure to update the Salesreps

Line 192: G_ATTRIBUTE15 JTF_RS_SALESREPS.ATTRIBUTE15%TYPE := NULL;

188: G_ATTRIBUTE11 JTF_RS_SALESREPS.ATTRIBUTE11%TYPE := NULL;
189: G_ATTRIBUTE12 JTF_RS_SALESREPS.ATTRIBUTE12%TYPE := NULL;
190: G_ATTRIBUTE13 JTF_RS_SALESREPS.ATTRIBUTE13%TYPE := NULL;
191: G_ATTRIBUTE14 JTF_RS_SALESREPS.ATTRIBUTE14%TYPE := NULL;
192: G_ATTRIBUTE15 JTF_RS_SALESREPS.ATTRIBUTE15%TYPE := NULL;
193: G_ATTRIBUTE_CATEGORY JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE := NULL;
194:
195: /* Procedure to update the Salesreps
196: based on input values passed by calling routines. */

Line 193: G_ATTRIBUTE_CATEGORY JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE := NULL;

189: G_ATTRIBUTE12 JTF_RS_SALESREPS.ATTRIBUTE12%TYPE := NULL;
190: G_ATTRIBUTE13 JTF_RS_SALESREPS.ATTRIBUTE13%TYPE := NULL;
191: G_ATTRIBUTE14 JTF_RS_SALESREPS.ATTRIBUTE14%TYPE := NULL;
192: G_ATTRIBUTE15 JTF_RS_SALESREPS.ATTRIBUTE15%TYPE := NULL;
193: G_ATTRIBUTE_CATEGORY JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE := NULL;
194:
195: /* Procedure to update the Salesreps
196: based on input values passed by calling routines. */
197: /*#

Line 219: * @param p_object_version_number The object version number of the salesrep derives from the jtf_rs_salesreps table.

215: * @param p_wh_update_date This date is sent to the data warehouse
216: * @param p_sales_tax_geocode Sales tax code, it associates the salesperson with a unique tax jurisdiction
217: * @param p_sales_tax_inside_city_limits Indicates that the tax jurisdiction for this address is within city limits
218: * @param p_org_id Organization Identifier
219: * @param p_object_version_number The object version number of the salesrep derives from the jtf_rs_salesreps table.
220: * @param x_return_status Output parameter for return status
221: * @param x_msg_count Output parameter for number of user messages from this procedure
222: * @param x_msg_data Output parameter containing last user message from this procedure
223: * @rep:scope public

Line 231: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,

227: PROCEDURE update_salesrep
228: (P_API_VERSION IN NUMBER,
229: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
230: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
231: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
232: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
233: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
234: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
235: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,

Line 232: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,

228: (P_API_VERSION IN NUMBER,
229: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
230: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
231: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
232: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
233: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
234: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
235: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
236: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,

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

229: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
230: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
231: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
232: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
233: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
234: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
235: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
236: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
237: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT FND_API.G_MISS_NUM,

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

230: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
231: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
232: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
233: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
234: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
235: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
236: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
237: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT FND_API.G_MISS_NUM,
238: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT FND_API.G_MISS_NUM,

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

231: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
232: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
233: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
234: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
235: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
236: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
237: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT FND_API.G_MISS_NUM,
238: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT FND_API.G_MISS_NUM,
239: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT FND_API.G_MISS_NUM,

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

232: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
233: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
234: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
235: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
236: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
237: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT FND_API.G_MISS_NUM,
238: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT FND_API.G_MISS_NUM,
239: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT FND_API.G_MISS_NUM,
240: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT FND_API.G_MISS_NUM,

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

233: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
234: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
235: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
236: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
237: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT FND_API.G_MISS_NUM,
238: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT FND_API.G_MISS_NUM,
239: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT FND_API.G_MISS_NUM,
240: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
241: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT FND_API.G_MISS_CHAR,

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

234: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
235: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
236: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
237: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT FND_API.G_MISS_NUM,
238: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT FND_API.G_MISS_NUM,
239: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT FND_API.G_MISS_NUM,
240: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
241: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT FND_API.G_MISS_CHAR,
242: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,

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

235: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
236: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
237: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT FND_API.G_MISS_NUM,
238: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT FND_API.G_MISS_NUM,
239: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT FND_API.G_MISS_NUM,
240: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
241: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT FND_API.G_MISS_CHAR,
242: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
243: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,

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

236: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
237: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT FND_API.G_MISS_NUM,
238: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT FND_API.G_MISS_NUM,
239: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT FND_API.G_MISS_NUM,
240: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
241: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT FND_API.G_MISS_CHAR,
242: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
243: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
244: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT FND_API.G_MISS_CHAR,

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

237: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT FND_API.G_MISS_NUM,
238: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT FND_API.G_MISS_NUM,
239: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT FND_API.G_MISS_NUM,
240: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
241: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT FND_API.G_MISS_CHAR,
242: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
243: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
244: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
245: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT FND_API.G_MISS_CHAR,

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

238: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT FND_API.G_MISS_NUM,
239: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT FND_API.G_MISS_NUM,
240: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
241: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT FND_API.G_MISS_CHAR,
242: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
243: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
244: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
245: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT FND_API.G_MISS_CHAR,
246: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,

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

239: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT FND_API.G_MISS_NUM,
240: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
241: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT FND_API.G_MISS_CHAR,
242: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
243: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
244: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
245: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT FND_API.G_MISS_CHAR,
246: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
247: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SALESREPS.OBJECT_VERSION_NUMBER%TYPE,

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

240: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
241: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT FND_API.G_MISS_CHAR,
242: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
243: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
244: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
245: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT FND_API.G_MISS_CHAR,
246: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
247: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SALESREPS.OBJECT_VERSION_NUMBER%TYPE,
248: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

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

241: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT FND_API.G_MISS_CHAR,
242: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
243: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
244: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
245: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT FND_API.G_MISS_CHAR,
246: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
247: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SALESREPS.OBJECT_VERSION_NUMBER%TYPE,
248: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
249: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 246: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,

242: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
243: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
244: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
245: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT FND_API.G_MISS_CHAR,
246: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
247: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SALESREPS.OBJECT_VERSION_NUMBER%TYPE,
248: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
249: X_MSG_COUNT OUT NOCOPY NUMBER,
250: X_MSG_DATA OUT NOCOPY VARCHAR2

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

243: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
244: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
245: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT FND_API.G_MISS_CHAR,
246: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
247: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SALESREPS.OBJECT_VERSION_NUMBER%TYPE,
248: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
249: X_MSG_COUNT OUT NOCOPY NUMBER,
250: X_MSG_DATA OUT NOCOPY VARCHAR2
251: );

Line 254: END jtf_rs_salesreps_pub;

250: X_MSG_DATA OUT NOCOPY VARCHAR2
251: );
252:
253:
254: END jtf_rs_salesreps_pub;