eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_RS_SALESREPS_IUHK dependencies on JTF_RS_SALESREPS

Line 1: PACKAGE jtf_rs_salesreps_iuhk AS

1: PACKAGE jtf_rs_salesreps_iuhk AS
2: /* $Header: jtfrsnss.pls 120.0 2005/05/11 08:20:57 appldev ship $ */
3:
4: /*****************************************************************************************
5: This is the Internal Industry User Hook API.

Line 13: (P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,

9: /* Internal 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,

Line 14: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%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,

Line 15: P_NAME IN JTF_RS_SALESREPS.NAME%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,

Line 16: P_STATUS IN JTF_RS_SALESREPS.STATUS%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,

Line 17: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%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,

Line 18: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%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,

Line 19: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%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,

Line 20: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%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,

Line 21: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%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,

Line 22: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%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,

Line 23: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%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,

Line 24: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%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

Line 25: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%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
29: );

Line 26: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%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: );
30:

Line 27: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%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:
31:

Line 36: (P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,

32: /* Internal 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,

Line 37: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%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,

Line 38: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%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,

Line 39: P_NAME IN JTF_RS_SALESREPS.NAME%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,

Line 40: P_STATUS IN JTF_RS_SALESREPS.STATUS%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,

Line 41: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%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,

Line 42: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%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,

Line 43: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%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,

Line 44: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%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,

Line 45: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%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,

Line 46: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%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,

Line 47: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%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,

Line 48: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%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

Line 49: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%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
53: );

Line 50: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%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: );
54:

Line 51: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%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:
55:

Line 60: (P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,

56: /* Internal 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,

Line 61: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%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,

Line 62: P_NAME IN JTF_RS_SALESREPS.NAME%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,

Line 63: P_STATUS IN JTF_RS_SALESREPS.STATUS%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,

Line 64: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%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,

Line 65: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%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,

Line 66: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%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,

Line 67: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%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,

Line 68: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%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,

Line 69: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%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,

Line 70: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%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,

Line 71: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%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

Line 72: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%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
76: );

Line 73: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%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: );
77:

Line 74: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%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:
78:

Line 83: (P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,

79: /* Internal 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,

Line 84: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%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,

Line 85: P_NAME IN JTF_RS_SALESREPS.NAME%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,

Line 86: P_STATUS IN JTF_RS_SALESREPS.STATUS%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,

Line 87: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%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,

Line 88: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%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,

Line 89: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%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,

Line 90: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%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,

Line 91: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%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,

Line 92: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%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,

Line 93: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%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,

Line 94: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%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

Line 95: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%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
99: );

Line 96: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%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: );
100:

Line 97: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%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:
101:

Line 102: END jtf_rs_salesreps_iuhk;

98: X_RETURN_STATUS OUT NOCOPY VARCHAR2
99: );
100:
101:
102: END jtf_rs_salesreps_iuhk;