1 PACKAGE jtf_rs_salesreps_vuhk AS
2 /* $Header: jtfrsiss.pls 120.0 2005/05/11 08:20:20 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
10 create salesrep */
11
12 PROCEDURE create_salesrep_pre
13 (P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
14 P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
15 P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
16 P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
17 P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
18 P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
19 P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
20 P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
21 P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
22 P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
23 P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
24 P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
25 P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
26 P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
27 P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
28 X_RETURN_STATUS OUT NOCOPY VARCHAR2
29 );
30
31
32 /* Vertical Industry Procedure for post processing in case of
33 create salesrep */
34
35 PROCEDURE create_salesrep_post
36 (P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
37 P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
38 P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
39 P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
40 P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
41 P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
42 P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
43 P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
44 P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
45 P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
46 P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
47 P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
48 P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
49 P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
50 P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
51 P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
52 X_RETURN_STATUS OUT NOCOPY VARCHAR2
53 );
54
55
56 /* Vertical Industry Procedure for pre processing in case of
57 update salesrep */
58
59 PROCEDURE update_salesrep_pre
60 (P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
61 P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
62 P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
63 P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
64 P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
65 P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
66 P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
67 P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
68 P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
69 P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
70 P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
71 P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
72 P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
73 P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
74 P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
75 X_RETURN_STATUS OUT NOCOPY VARCHAR2
76 );
77
78
79 /* Vertical Industry Procedure for post processing in case of
80 update salesrep */
81
82 PROCEDURE update_salesrep_post
83 (P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
84 P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
85 P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
86 P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
87 P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
88 P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
89 P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
90 P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
91 P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
92 P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
93 P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
94 P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
95 P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
96 P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
97 P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
98 X_RETURN_STATUS OUT NOCOPY VARCHAR2
99 );
100
101
102 END jtf_rs_salesreps_vuhk;