1: PACKAGE jtf_rs_srp_territories_cuhk AUTHID CURRENT_USER AS
2: /* $Header: jtfrscis.pls 120.0 2005/05/11 08:19:39 appldev ship $ */
3:
4: /*****************************************************************************************
5: This is the Customer User Hook API.
8:
9: /* Customer 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,
9: /* Customer 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,
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,
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,
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
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: );
23:
24: /* Customer Procedure for post processing in case of create srp territories */
25:
26: PROCEDURE create_rs_srp_territories_post (
27: P_SALESREP_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_ID%TYPE,
28: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,
29: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
30: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
31: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
24: /* Customer Procedure for post processing in case of create srp territories */
25:
26: PROCEDURE create_rs_srp_territories_post (
27: P_SALESREP_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_ID%TYPE,
28: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,
29: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
30: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
31: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
32: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
25:
26: PROCEDURE create_rs_srp_territories_post (
27: P_SALESREP_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_ID%TYPE,
28: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,
29: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
30: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
31: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
32: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
33: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
26: PROCEDURE create_rs_srp_territories_post (
27: P_SALESREP_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_ID%TYPE,
28: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,
29: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
30: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
31: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
32: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
33: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
34: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
27: P_SALESREP_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_ID%TYPE,
28: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,
29: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
30: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
31: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
32: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
33: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
34: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
35: X_MSG_COUNT OUT NOCOPY NUMBER,
28: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,
29: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
30: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
31: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
32: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
33: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
34: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
35: X_MSG_COUNT OUT NOCOPY NUMBER,
36: X_MSG_DATA OUT NOCOPY VARCHAR2
29: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
30: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
31: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
32: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
33: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
34: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
35: X_MSG_COUNT OUT NOCOPY NUMBER,
36: X_MSG_DATA OUT NOCOPY VARCHAR2
37: );
38:
39: /* Customer Procedure for pre processing in case of update srp territories */
40:
41: PROCEDURE update_rs_srp_territories_pre (
42: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
43: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
44: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
45: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
46: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
39: /* Customer Procedure for pre processing in case of update srp territories */
40:
41: PROCEDURE update_rs_srp_territories_pre (
42: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
43: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
44: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
45: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
46: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
47: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
40:
41: PROCEDURE update_rs_srp_territories_pre (
42: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
43: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
44: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
45: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
46: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
47: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
48: X_MSG_COUNT OUT NOCOPY NUMBER,
41: PROCEDURE update_rs_srp_territories_pre (
42: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
43: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
44: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
45: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
46: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
47: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
48: X_MSG_COUNT OUT NOCOPY NUMBER,
49: X_MSG_DATA OUT NOCOPY VARCHAR2
42: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
43: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
44: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
45: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
46: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
47: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
48: X_MSG_COUNT OUT NOCOPY NUMBER,
49: X_MSG_DATA OUT NOCOPY VARCHAR2
50: );
51:
52: /* Customer Procedure for post processing in case of update srp territories */
53:
54: PROCEDURE update_rs_srp_territories_post (
55: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
56: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
57: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
58: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
59: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
52: /* Customer Procedure for post processing in case of update srp territories */
53:
54: PROCEDURE update_rs_srp_territories_post (
55: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
56: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
57: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
58: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
59: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
60: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
53:
54: PROCEDURE update_rs_srp_territories_post (
55: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
56: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
57: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
58: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
59: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
60: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
61: X_MSG_COUNT OUT NOCOPY NUMBER,
54: PROCEDURE update_rs_srp_territories_post (
55: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
56: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
57: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
58: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
59: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
60: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
61: X_MSG_COUNT OUT NOCOPY NUMBER,
62: X_MSG_DATA OUT NOCOPY VARCHAR2
55: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
56: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
57: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
58: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
59: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
60: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
61: X_MSG_COUNT OUT NOCOPY NUMBER,
62: X_MSG_DATA OUT NOCOPY VARCHAR2
63: );
64:
65: /* Customer/Vertical Industry Function before Message Generation */
66:
67: FUNCTION ok_to_generate_msg (
68: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
69: X_RETURN_STATUS OUT NOCOPY VARCHAR2
70: )RETURN BOOLEAN;
71:
72: END jtf_rs_srp_territories_cuhk;
68: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
69: X_RETURN_STATUS OUT NOCOPY VARCHAR2
70: )RETURN BOOLEAN;
71:
72: END jtf_rs_srp_territories_cuhk;