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.
6 The Internal Groups can add customization procedures here for Pre and Post Processing.
7 ******************************************************************************************/
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,
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
22
23 BEGIN
24 NULL;
25 END create_rs_srp_territories_pre;
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,
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
41
42 BEGIN
43 NULL;
44 END create_rs_srp_territories_post;
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,
54 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
55 X_MSG_COUNT OUT NOCOPY NUMBER,
56 X_MSG_DATA OUT NOCOPY VARCHAR2
57 ) IS
58
59 BEGIN
60 NULL;
61 END update_rs_srp_territories_pre;
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,
71 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
72 X_MSG_COUNT OUT NOCOPY NUMBER,
73 X_MSG_DATA OUT NOCOPY VARCHAR2
74 ) IS
75
76 BEGIN
77 NULL;
78 END update_rs_srp_territories_post;
79
80 END jtf_rs_srp_territories_iuhk;