1 PACKAGE jtf_rs_srp_territories_vuhk AS
2 /* $Header: jtfrsiis.pls 120.0 2005/05/11 08:20:16 appldev ship $ */
3
4 /*****************************************************************************************
5 This is the Vertical Industry User Hook API.
6 The Vertical Industry can add customization procedures here for Pre and Post Processing.
7 ******************************************************************************************/
8
9 /* Vertical Industry 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
24 /* Vertical Industry 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,
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 /* Vertical Industry 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,
48 X_MSG_COUNT OUT NOCOPY NUMBER,
49 X_MSG_DATA OUT NOCOPY VARCHAR2
50 );
51
52 /* Vertical Industry 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,
61 X_MSG_COUNT OUT NOCOPY NUMBER,
62 X_MSG_DATA OUT NOCOPY VARCHAR2
63 );
64
65
66 END jtf_rs_srp_territories_vuhk;