1 PACKAGE jtf_rs_srp_territories_iuhk 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.
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 );
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,
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 );
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,
46 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
47 X_MSG_COUNT OUT NOCOPY NUMBER,
48 X_MSG_DATA OUT NOCOPY VARCHAR2
49 );
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,
59 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
60 X_MSG_COUNT OUT NOCOPY NUMBER,
61 X_MSG_DATA OUT NOCOPY VARCHAR2
62 );
63
64 END jtf_rs_srp_territories_iuhk;