1: PACKAGE jtf_rs_salesreps_vuhk AS
2: /* $Header: jtfrsiss.pls 120.0 2005/05/11 08:20:20 appldev ship $ */
3:
4: /*****************************************************************************************
5: This is the Vertical Industry User Hook API.
9: /* Vertical Industry Procedure for pre processing in case of
10: create salesrep */
11:
12: PROCEDURE create_salesrep_pre
13: (P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
14: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
15: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
16: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
17: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
10: create salesrep */
11:
12: PROCEDURE create_salesrep_pre
13: (P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
14: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
15: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
16: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
17: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
18: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
11:
12: PROCEDURE create_salesrep_pre
13: (P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
14: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
15: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
16: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
17: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
18: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
19: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
12: PROCEDURE create_salesrep_pre
13: (P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
14: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
15: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
16: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
17: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
18: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
19: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
20: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
13: (P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
14: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
15: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
16: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
17: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
18: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
19: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
20: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
21: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
14: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
15: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
16: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
17: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
18: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
19: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
20: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
21: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
22: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
15: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
16: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
17: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
18: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
19: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
20: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
21: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
22: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
23: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
16: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
17: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
18: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
19: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
20: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
21: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
22: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
23: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
24: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
17: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
18: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
19: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
20: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
21: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
22: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
23: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
24: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
25: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
18: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
19: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
20: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
21: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
22: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
23: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
24: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
25: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
26: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
19: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
20: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
21: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
22: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
23: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
24: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
25: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
26: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
27: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
20: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
21: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
22: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
23: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
24: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
25: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
26: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
27: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
28: X_RETURN_STATUS OUT NOCOPY VARCHAR2
21: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
22: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
23: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
24: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
25: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
26: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
27: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
28: X_RETURN_STATUS OUT NOCOPY VARCHAR2
29: );
22: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
23: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
24: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
25: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
26: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
27: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
28: X_RETURN_STATUS OUT NOCOPY VARCHAR2
29: );
30:
23: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
24: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
25: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
26: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
27: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
28: X_RETURN_STATUS OUT NOCOPY VARCHAR2
29: );
30:
31:
32: /* Vertical Industry Procedure for post processing in case of
33: create salesrep */
34:
35: PROCEDURE create_salesrep_post
36: (P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
37: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
38: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
39: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
40: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
33: create salesrep */
34:
35: PROCEDURE create_salesrep_post
36: (P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
37: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
38: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
39: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
40: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
41: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
34:
35: PROCEDURE create_salesrep_post
36: (P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
37: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
38: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
39: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
40: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
41: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
42: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
35: PROCEDURE create_salesrep_post
36: (P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
37: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
38: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
39: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
40: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
41: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
42: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
43: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
36: (P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
37: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
38: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
39: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
40: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
41: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
42: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
43: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
44: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
37: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
38: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
39: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
40: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
41: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
42: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
43: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
44: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
45: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
38: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
39: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
40: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
41: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
42: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
43: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
44: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
45: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
46: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
39: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
40: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
41: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
42: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
43: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
44: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
45: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
46: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
47: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
40: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
41: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
42: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
43: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
44: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
45: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
46: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
47: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
48: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
41: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
42: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
43: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
44: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
45: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
46: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
47: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
48: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
49: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
42: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
43: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
44: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
45: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
46: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
47: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
48: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
49: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
50: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
43: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
44: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
45: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
46: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
47: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
48: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
49: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
50: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
51: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
44: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
45: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
46: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
47: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
48: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
49: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
50: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
51: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
52: X_RETURN_STATUS OUT NOCOPY VARCHAR2
45: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
46: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
47: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
48: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
49: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
50: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
51: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
52: X_RETURN_STATUS OUT NOCOPY VARCHAR2
53: );
46: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
47: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
48: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
49: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
50: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
51: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
52: X_RETURN_STATUS OUT NOCOPY VARCHAR2
53: );
54:
47: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
48: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
49: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
50: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
51: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
52: X_RETURN_STATUS OUT NOCOPY VARCHAR2
53: );
54:
55:
56: /* Vertical Industry Procedure for pre processing in case of
57: update salesrep */
58:
59: PROCEDURE update_salesrep_pre
60: (P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
61: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
62: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
63: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
64: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
57: update salesrep */
58:
59: PROCEDURE update_salesrep_pre
60: (P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
61: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
62: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
63: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
64: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
65: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
58:
59: PROCEDURE update_salesrep_pre
60: (P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
61: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
62: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
63: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
64: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
65: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
66: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
59: PROCEDURE update_salesrep_pre
60: (P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
61: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
62: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
63: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
64: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
65: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
66: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
67: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
60: (P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
61: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
62: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
63: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
64: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
65: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
66: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
67: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
68: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
61: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
62: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
63: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
64: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
65: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
66: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
67: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
68: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
69: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
62: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
63: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
64: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
65: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
66: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
67: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
68: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
69: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
70: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
63: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
64: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
65: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
66: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
67: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
68: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
69: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
70: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
71: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
64: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
65: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
66: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
67: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
68: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
69: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
70: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
71: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
72: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
65: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
66: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
67: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
68: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
69: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
70: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
71: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
72: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
73: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
66: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
67: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
68: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
69: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
70: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
71: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
72: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
73: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
74: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
67: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
68: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
69: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
70: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
71: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
72: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
73: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
74: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
75: X_RETURN_STATUS OUT NOCOPY VARCHAR2
68: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
69: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
70: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
71: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
72: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
73: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
74: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
75: X_RETURN_STATUS OUT NOCOPY VARCHAR2
76: );
69: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
70: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
71: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
72: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
73: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
74: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
75: X_RETURN_STATUS OUT NOCOPY VARCHAR2
76: );
77:
70: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
71: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
72: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
73: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
74: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
75: X_RETURN_STATUS OUT NOCOPY VARCHAR2
76: );
77:
78:
79: /* Vertical Industry Procedure for post processing in case of
80: update salesrep */
81:
82: PROCEDURE update_salesrep_post
83: (P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
84: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
85: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
86: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
87: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
80: update salesrep */
81:
82: PROCEDURE update_salesrep_post
83: (P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
84: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
85: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
86: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
87: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
88: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
81:
82: PROCEDURE update_salesrep_post
83: (P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
84: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
85: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
86: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
87: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
88: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
89: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
82: PROCEDURE update_salesrep_post
83: (P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
84: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
85: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
86: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
87: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
88: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
89: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
90: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
83: (P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
84: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
85: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
86: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
87: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
88: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
89: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
90: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
91: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
84: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
85: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
86: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
87: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
88: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
89: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
90: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
91: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
92: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
85: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
86: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
87: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
88: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
89: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
90: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
91: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
92: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
93: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
86: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
87: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
88: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
89: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
90: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
91: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
92: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
93: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
94: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
87: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
88: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
89: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
90: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
91: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
92: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
93: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
94: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
95: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
88: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
89: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
90: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
91: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
92: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
93: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
94: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
95: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
96: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
89: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
90: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
91: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
92: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
93: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
94: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
95: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
96: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
97: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
90: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
91: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
92: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
93: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
94: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
95: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
96: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
97: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
98: X_RETURN_STATUS OUT NOCOPY VARCHAR2
91: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
92: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
93: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
94: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
95: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
96: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
97: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
98: X_RETURN_STATUS OUT NOCOPY VARCHAR2
99: );
92: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
93: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
94: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
95: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
96: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
97: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
98: X_RETURN_STATUS OUT NOCOPY VARCHAR2
99: );
100:
93: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
94: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
95: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
96: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
97: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
98: X_RETURN_STATUS OUT NOCOPY VARCHAR2
99: );
100:
101:
98: X_RETURN_STATUS OUT NOCOPY VARCHAR2
99: );
100:
101:
102: END jtf_rs_salesreps_vuhk;