1: PACKAGE jtf_rs_salesreps_pub AUTHID CURRENT_USER 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.
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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:
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
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. */
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: /*#
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
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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: );
250: X_MSG_DATA OUT NOCOPY VARCHAR2
251: );
252:
253:
254: END jtf_rs_salesreps_pub;