51: * @rep:displayname Create Salesreps API
52: */
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,
52: */
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,
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,
127: * @rep:displayname Create Salesreps Migration API
128: */
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,
128: */
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,
225: * @rep:displayname Update Salesreps API
226: */
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,
226: */
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,
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,