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_SRP_TERRITORIES_IUHK dependencies on JTF_RS_SRP_TERRITORIES

Line 1: PACKAGE jtf_rs_srp_territories_iuhk AUTHID CURRENT_USER AS

1: PACKAGE jtf_rs_srp_territories_iuhk AUTHID CURRENT_USER AS
2: /* $Header: jtfrsnis.pls 120.0 2005/05/11 08:20:48 appldev ship $ */
3:
4: /*****************************************************************************************
5: This is the Internal User Hook API.

Line 12: P_SALESREP_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_ID%TYPE,

8:
9: /* Internal Procedure for pre processing in case of create srp territories */
10:
11: PROCEDURE create_rs_srp_territories_pre (
12: P_SALESREP_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_ID%TYPE,
13: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,
14: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
15: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
16: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,

Line 13: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,

9: /* Internal Procedure for pre processing in case of create srp territories */
10:
11: PROCEDURE create_rs_srp_territories_pre (
12: P_SALESREP_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_ID%TYPE,
13: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,
14: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
15: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
16: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
17: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,

Line 14: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,

10:
11: PROCEDURE create_rs_srp_territories_pre (
12: P_SALESREP_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_ID%TYPE,
13: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,
14: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
15: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
16: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
17: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
18: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 15: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,

11: PROCEDURE create_rs_srp_territories_pre (
12: P_SALESREP_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_ID%TYPE,
13: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,
14: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
15: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
16: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
17: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
18: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
19: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 16: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,

12: P_SALESREP_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_ID%TYPE,
13: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,
14: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
15: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
16: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
17: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
18: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
19: X_MSG_COUNT OUT NOCOPY NUMBER,
20: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 17: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,

13: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,
14: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
15: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
16: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
17: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
18: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
19: X_MSG_COUNT OUT NOCOPY NUMBER,
20: X_MSG_DATA OUT NOCOPY VARCHAR2
21: );

Line 26: P_SALESREP_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_ID%TYPE,

22:
23: /* Internal Procedure for post processing in case of create srp territories */
24:
25: PROCEDURE create_rs_srp_territories_post (
26: P_SALESREP_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_ID%TYPE,
27: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,
28: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
29: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
30: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,

Line 27: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,

23: /* Internal Procedure for post processing in case of create srp territories */
24:
25: PROCEDURE create_rs_srp_territories_post (
26: P_SALESREP_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_ID%TYPE,
27: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,
28: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
29: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
30: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
31: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,

Line 28: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,

24:
25: PROCEDURE create_rs_srp_territories_post (
26: P_SALESREP_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_ID%TYPE,
27: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,
28: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
29: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
30: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
31: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
32: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,

Line 29: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,

25: PROCEDURE create_rs_srp_territories_post (
26: P_SALESREP_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_ID%TYPE,
27: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,
28: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
29: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
30: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
31: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
32: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
33: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 30: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,

26: P_SALESREP_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_ID%TYPE,
27: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,
28: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
29: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
30: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
31: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
32: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
33: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
34: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 31: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,

27: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,
28: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
29: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
30: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
31: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
32: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
33: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
34: X_MSG_COUNT OUT NOCOPY NUMBER,
35: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 32: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,

28: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
29: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
30: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
31: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
32: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
33: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
34: X_MSG_COUNT OUT NOCOPY NUMBER,
35: X_MSG_DATA OUT NOCOPY VARCHAR2
36: );

Line 41: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,

37:
38: /* Internal Procedure for pre processing in case of update srp territories */
39:
40: PROCEDURE update_rs_srp_territories_pre (
41: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
42: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
43: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
44: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
45: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,

Line 42: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,

38: /* Internal Procedure for pre processing in case of update srp territories */
39:
40: PROCEDURE update_rs_srp_territories_pre (
41: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
42: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
43: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
44: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
45: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
46: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 43: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,

39:
40: PROCEDURE update_rs_srp_territories_pre (
41: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
42: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
43: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
44: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
45: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
46: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
47: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 44: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,

40: PROCEDURE update_rs_srp_territories_pre (
41: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
42: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
43: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
44: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
45: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
46: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
47: X_MSG_COUNT OUT NOCOPY NUMBER,
48: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 45: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,

41: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
42: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
43: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
44: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
45: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
46: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
47: X_MSG_COUNT OUT NOCOPY NUMBER,
48: X_MSG_DATA OUT NOCOPY VARCHAR2
49: );

Line 54: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,

50:
51: /* Internal Procedure for post processing in case of update srp territories */
52:
53: PROCEDURE update_rs_srp_territories_post (
54: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
55: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
56: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
57: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
58: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,

Line 55: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,

51: /* Internal Procedure for post processing in case of update srp territories */
52:
53: PROCEDURE update_rs_srp_territories_post (
54: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
55: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
56: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
57: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
58: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
59: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 56: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,

52:
53: PROCEDURE update_rs_srp_territories_post (
54: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
55: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
56: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
57: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
58: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
59: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
60: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 57: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,

53: PROCEDURE update_rs_srp_territories_post (
54: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
55: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
56: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
57: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
58: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
59: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
60: X_MSG_COUNT OUT NOCOPY NUMBER,
61: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 58: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,

54: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
55: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
56: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
57: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
58: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
59: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
60: X_MSG_COUNT OUT NOCOPY NUMBER,
61: X_MSG_DATA OUT NOCOPY VARCHAR2
62: );

Line 64: END jtf_rs_srp_territories_iuhk;

60: X_MSG_COUNT OUT NOCOPY NUMBER,
61: X_MSG_DATA OUT NOCOPY VARCHAR2
62: );
63:
64: END jtf_rs_srp_territories_iuhk;