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 BODY jtf_rs_salesreps_iuhk AS

1: PACKAGE BODY jtf_rs_salesreps_iuhk AS
2: /* $Header: jtfrsnsb.pls 120.0 2005/05/11 08:20:56 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: ) IS

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: ) IS
30: begin

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: ) IS
30: begin
31: null;

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

35: /* Internal Industry Procedure for post processing in case of
36: create salesrep */
37:
38: PROCEDURE create_salesrep_post
39: (P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
40: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
41: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
42: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
43: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,

Line 40: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,

36: create salesrep */
37:
38: PROCEDURE create_salesrep_post
39: (P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
40: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
41: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
42: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
43: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
44: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,

Line 41: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,

37:
38: PROCEDURE create_salesrep_post
39: (P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
40: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
41: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
42: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
43: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
44: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
45: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,

Line 42: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,

38: PROCEDURE create_salesrep_post
39: (P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
40: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
41: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
42: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
43: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
44: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
45: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
46: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,

Line 43: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,

39: (P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
40: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
41: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
42: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
43: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
44: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
45: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
46: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
47: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,

Line 44: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,

40: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
41: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
42: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
43: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
44: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
45: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
46: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
47: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
48: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,

Line 45: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,

41: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
42: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
43: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
44: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
45: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
46: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
47: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
48: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
49: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,

Line 46: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,

42: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
43: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
44: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
45: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
46: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
47: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
48: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
49: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
50: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,

Line 47: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,

43: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
44: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
45: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
46: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
47: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
48: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
49: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
50: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
51: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,

Line 48: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,

44: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
45: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
46: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
47: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
48: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
49: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
50: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
51: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
52: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,

Line 49: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,

45: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
46: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
47: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
48: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
49: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
50: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
51: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
52: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
53: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,

Line 50: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,

46: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
47: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
48: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
49: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
50: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
51: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
52: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
53: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
54: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,

Line 51: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,

47: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
48: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
49: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
50: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
51: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
52: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
53: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
54: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
55: X_RETURN_STATUS OUT NOCOPY VARCHAR2

Line 52: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,

48: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
49: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
50: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
51: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
52: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
53: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
54: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
55: X_RETURN_STATUS OUT NOCOPY VARCHAR2
56: ) IS

Line 53: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,

49: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
50: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
51: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
52: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
53: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
54: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
55: X_RETURN_STATUS OUT NOCOPY VARCHAR2
56: ) IS
57: begin

Line 54: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,

50: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
51: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
52: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
53: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
54: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
55: X_RETURN_STATUS OUT NOCOPY VARCHAR2
56: ) IS
57: begin
58: null;

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

62: /* Internal Industry Procedure for pre processing in case of
63: update salesrep */
64:
65: PROCEDURE update_salesrep_pre
66: (P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
67: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
68: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
69: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
70: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,

Line 67: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,

63: update salesrep */
64:
65: PROCEDURE update_salesrep_pre
66: (P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
67: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
68: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
69: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
70: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
71: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,

Line 68: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,

64:
65: PROCEDURE update_salesrep_pre
66: (P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
67: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
68: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
69: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
70: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
71: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
72: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,

Line 69: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,

65: PROCEDURE update_salesrep_pre
66: (P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
67: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
68: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
69: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
70: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
71: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
72: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
73: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,

Line 70: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,

66: (P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
67: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
68: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
69: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
70: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
71: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
72: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
73: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
74: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,

Line 71: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,

67: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
68: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
69: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
70: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
71: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
72: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
73: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
74: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
75: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,

Line 72: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,

68: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
69: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
70: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
71: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
72: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
73: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
74: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
75: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
76: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,

Line 73: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,

69: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
70: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
71: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
72: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
73: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
74: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
75: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
76: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
77: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,

Line 74: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,

70: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
71: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
72: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
73: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
74: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
75: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
76: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
77: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
78: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,

Line 75: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,

71: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
72: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
73: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
74: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
75: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
76: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
77: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
78: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
79: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,

Line 76: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,

72: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
73: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
74: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
75: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
76: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
77: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
78: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
79: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
80: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,

Line 77: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,

73: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
74: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
75: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
76: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
77: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
78: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
79: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
80: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
81: X_RETURN_STATUS OUT NOCOPY VARCHAR2

Line 78: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,

74: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
75: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
76: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
77: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
78: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
79: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
80: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
81: X_RETURN_STATUS OUT NOCOPY VARCHAR2
82: ) IS

Line 79: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,

75: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
76: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
77: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
78: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
79: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
80: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
81: X_RETURN_STATUS OUT NOCOPY VARCHAR2
82: ) IS
83: begin

Line 80: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,

76: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
77: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
78: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
79: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
80: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
81: X_RETURN_STATUS OUT NOCOPY VARCHAR2
82: ) IS
83: begin
84: null;

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

88: /* Internal Industry Procedure for post processing in case of
89: update salesrep */
90:
91: PROCEDURE update_salesrep_post
92: (P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
93: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
94: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
95: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
96: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,

Line 93: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,

89: update salesrep */
90:
91: PROCEDURE update_salesrep_post
92: (P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
93: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
94: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
95: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
96: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
97: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,

Line 94: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,

90:
91: PROCEDURE update_salesrep_post
92: (P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
93: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
94: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
95: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
96: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
97: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
98: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,

Line 95: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,

91: PROCEDURE update_salesrep_post
92: (P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
93: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
94: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
95: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
96: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
97: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
98: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
99: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,

Line 96: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,

92: (P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
93: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
94: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
95: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
96: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
97: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
98: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
99: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
100: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,

Line 97: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,

93: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
94: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
95: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
96: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
97: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
98: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
99: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
100: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
101: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,

Line 98: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,

94: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
95: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
96: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
97: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
98: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
99: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
100: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
101: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
102: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,

Line 99: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,

95: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
96: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
97: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
98: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
99: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
100: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
101: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
102: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
103: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,

Line 100: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,

96: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
97: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
98: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
99: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
100: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
101: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
102: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
103: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
104: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,

Line 101: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,

97: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
98: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
99: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
100: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
101: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
102: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
103: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
104: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
105: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,

Line 102: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,

98: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
99: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
100: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
101: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
102: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
103: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
104: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
105: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
106: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,

Line 103: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,

99: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
100: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
101: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
102: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
103: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
104: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
105: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
106: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
107: X_RETURN_STATUS OUT NOCOPY VARCHAR2

Line 104: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,

100: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
101: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
102: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
103: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
104: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
105: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
106: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
107: X_RETURN_STATUS OUT NOCOPY VARCHAR2
108: ) IS

Line 105: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,

101: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
102: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
103: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
104: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
105: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
106: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
107: X_RETURN_STATUS OUT NOCOPY VARCHAR2
108: ) IS
109: begin

Line 106: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,

102: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
103: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
104: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
105: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
106: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
107: X_RETURN_STATUS OUT NOCOPY VARCHAR2
108: ) IS
109: begin
110: null;

Line 114: END jtf_rs_salesreps_iuhk;

110: null;
111: end update_salesrep_post;
112:
113:
114: END jtf_rs_salesreps_iuhk;