1 PACKAGE BODY jtf_rs_salesreps_iuhk AS
2 /* $Header: jtfrsnsb.pls 120.0 2005/05/11 08:20:56 appldev ship $ */
3
4 /*****************************************************************************************
5 This is the Internal Industry User Hook API.
6 The Internal Industry can add customization procedures here for Pre and Post Processing.
7 ******************************************************************************************/
8
9 /* Internal 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 ) IS
30 begin
31 null;
32 end create_salesrep_pre;
33
34
35 /* Internal Industry Procedure for post processing in case of
36 create salesrep */
37
38 PROCEDURE create_salesrep_post
39 (P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
40 P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
41 P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
42 P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
43 P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
44 P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
45 P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
46 P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
47 P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
48 P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
49 P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
50 P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
51 P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
52 P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
53 P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
54 P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
55 X_RETURN_STATUS OUT NOCOPY VARCHAR2
56 ) IS
57 begin
58 null;
59 end create_salesrep_post;
60
61
62 /* Internal Industry Procedure for pre processing in case of
63 update salesrep */
64
65 PROCEDURE update_salesrep_pre
66 (P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
67 P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
68 P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
69 P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
70 P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
71 P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
72 P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
73 P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
74 P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
75 P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
76 P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
77 P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
78 P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
79 P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
80 P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
81 X_RETURN_STATUS OUT NOCOPY VARCHAR2
82 ) IS
83 begin
84 null;
85 end update_salesrep_pre;
86
87
88 /* Internal Industry Procedure for post processing in case of
89 update salesrep */
90
91 PROCEDURE update_salesrep_post
92 (P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
93 P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
94 P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
95 P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
96 P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
97 P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
98 P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
99 P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
100 P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
101 P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
102 P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
103 P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
104 P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
105 P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
106 P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
107 X_RETURN_STATUS OUT NOCOPY VARCHAR2
108 ) IS
109 begin
110 null;
111 end update_salesrep_post;
112
113
114 END jtf_rs_salesreps_iuhk;