1 PACKAGE jtf_rs_srp_territories_cuhk 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.
6 The Customers can add customization procedures here for Pre and Post Processing.
7 ******************************************************************************************/
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,
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 /* 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,
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,
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,
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;