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

1: PACKAGE BODY jtf_rs_srp_territories_iuhk AS
2: /* $Header: jtfrsnib.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: ) IS

Line 30: P_SALESREP_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_ID%TYPE,

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

Line 31: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,

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

Line 32: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,

28:
29: PROCEDURE create_rs_srp_territories_post (
30: P_SALESREP_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_ID%TYPE,
31: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,
32: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
33: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
34: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
35: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
36: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,

Line 33: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,

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

Line 34: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,

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

Line 35: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,

31: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,
32: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
33: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
34: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
35: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
36: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
37: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
38: X_MSG_COUNT OUT NOCOPY NUMBER,
39: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 36: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,

32: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
33: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
34: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
35: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
36: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
37: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
38: X_MSG_COUNT OUT NOCOPY NUMBER,
39: X_MSG_DATA OUT NOCOPY VARCHAR2
40: ) IS

Line 49: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,

45:
46: /* Internal Procedure for pre processing in case of update srp territories */
47:
48: PROCEDURE update_rs_srp_territories_pre (
49: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
50: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
51: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
52: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
53: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,

Line 50: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,

46: /* Internal Procedure for pre processing in case of update srp territories */
47:
48: PROCEDURE update_rs_srp_territories_pre (
49: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
50: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
51: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
52: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
53: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
54: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 51: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,

47:
48: PROCEDURE update_rs_srp_territories_pre (
49: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
50: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
51: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
52: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
53: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
54: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
55: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 52: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,

48: PROCEDURE update_rs_srp_territories_pre (
49: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
50: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
51: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
52: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
53: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
54: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
55: X_MSG_COUNT OUT NOCOPY NUMBER,
56: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 53: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,

49: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
50: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
51: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
52: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
53: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
54: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
55: X_MSG_COUNT OUT NOCOPY NUMBER,
56: X_MSG_DATA OUT NOCOPY VARCHAR2
57: ) IS

Line 66: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,

62:
63: /* Internal Procedure for post processing in case of update srp territories */
64:
65: PROCEDURE update_rs_srp_territories_post (
66: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
67: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
68: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
69: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
70: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,

Line 67: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,

63: /* Internal Procedure for post processing in case of update srp territories */
64:
65: PROCEDURE update_rs_srp_territories_post (
66: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
67: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
68: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
69: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
70: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
71: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 68: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,

64:
65: PROCEDURE update_rs_srp_territories_post (
66: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
67: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
68: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
69: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
70: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
71: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
72: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 69: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,

65: PROCEDURE update_rs_srp_territories_post (
66: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
67: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
68: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
69: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
70: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
71: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
72: X_MSG_COUNT OUT NOCOPY NUMBER,
73: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 70: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,

66: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
67: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
68: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
69: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
70: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
71: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
72: X_MSG_COUNT OUT NOCOPY NUMBER,
73: X_MSG_DATA OUT NOCOPY VARCHAR2
74: ) IS

Line 80: END jtf_rs_srp_territories_iuhk;

76: BEGIN
77: NULL;
78: END update_rs_srp_territories_post;
79:
80: END jtf_rs_srp_territories_iuhk;