1 PACKAGE CS_CHARGE_DETAILS_CUHK AS
2 /* $Header: cschrs.pls 120.0.12010000.3 2008/08/07 06:23:31 vpremach ship $ */
3
4
5 /*======================================================================+
6 ==
7 == Package name : CS_CHARGE_DETAILS_CUHK
8 == Description : This is the Customer User Hook API.
9 == The Customers can add customization procedures here for Pre and Post Processing.
10 ==
11 ==
12 ==
13 == Modification History:
14 ==
15 == Date Name Desc
16 == ---------- --------- ---------------------------------------------
17 == 11/18/2004 mviswana Bug fixed 3868233 .
18 == in Create_Charge_Details_Post, Update_Charge_Details_Pre and Update_Charge_Details_Post.
19 == 11/18/2004 mviswana Bug Fixed 3951392 .
20 == in Create_Charge_Details_Post, Update_Charge_Details_Pre and Update_Charge_Details_Post.
21 == 07/07/2005 mviswana Bug Fixed 3951397
22 == primary key unknown in user hook CS_CHARGE_DETAILS_CUHK
23 ==
24 ========================================================================*/
25 /* Customer Procedure for pre processing in case of create charge details */
26
27 Procedure Create_Charge_Details_Pre(
28 p_api_version IN NUMBER,
29 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
30 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
31 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
32 x_return_status OUT NOCOPY VARCHAR2,
33 x_msg_count OUT NOCOPY NUMBER,
34 x_object_version_number OUT NOCOPY NUMBER,
35 x_estimate_detail_id OUT NOCOPY NUMBER,
36 x_line_number OUT NOCOPY NUMBER,
37 x_msg_data OUT NOCOPY VARCHAR2,
38 p_resp_appl_id IN NUMBER DEFAULT NULL,
39 p_resp_id IN NUMBER DEFAULT NULL,
40 p_user_id IN NUMBER DEFAULT NULL,
41 p_login_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
42 p_transaction_control IN VARCHAR2 DEFAULT FND_API.G_TRUE,
43 p_est_detail_rec IN CS_Charge_Details_PUB.Charges_Rec_Type);
44
45
46 /* Customer Procedure for post processing in case of
47 create charge details */
48
49
50 Procedure Create_Charge_Details_Post(
51 p_api_version IN NUMBER,
52 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
53 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
54 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
55 x_return_status OUT NOCOPY VARCHAR2,
56 x_msg_count OUT NOCOPY NUMBER,
57 x_object_version_number OUT NOCOPY NUMBER,
58 x_estimate_detail_id IN OUT NOCOPY NUMBER, --3951392
59 x_line_number OUT NOCOPY NUMBER,
60 x_msg_data OUT NOCOPY VARCHAR2,
61 p_resp_appl_id IN NUMBER DEFAULT NULL,
62 p_resp_id IN NUMBER DEFAULT NULL,
63 p_user_id IN NUMBER DEFAULT NULL,
64 p_login_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
65 p_transaction_control IN VARCHAR2 DEFAULT FND_API.G_TRUE,
66 p_est_detail_rec IN CS_Charge_Details_PUB.Charges_Rec_Type);
67
68
69
70 /* Customer Procedure for pre processing in case of update charge details */
71
72 Procedure Update_Charge_Details_Pre(
73 p_api_version IN NUMBER,
74 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
75 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
76 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
77 x_return_status OUT NOCOPY VARCHAR2,
78 x_msg_count OUT NOCOPY NUMBER,
79 x_object_version_number OUT NOCOPY NUMBER,
80 x_estimate_detail_id IN OUT NOCOPY NUMBER, --3951392
81 x_msg_data OUT NOCOPY VARCHAR2,
82 p_resp_appl_id IN NUMBER DEFAULT NULL,
83 p_resp_id IN NUMBER DEFAULT NULL,
84 p_user_id IN NUMBER DEFAULT NULL,
85 p_login_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
86 p_transaction_control IN VARCHAR2 DEFAULT FND_API.G_TRUE,
87 p_est_detail_rec IN CS_Charge_Details_PUB.Charges_Rec_Type);
88
89
90 /* Customer Procedure for post processing in case of
91 update charge details */
92
93
94 Procedure Update_Charge_Details_Post(
95 p_api_version IN NUMBER,
96 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
97 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
98 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
99 x_return_status OUT NOCOPY VARCHAR2,
100 x_msg_count OUT NOCOPY NUMBER,
101 x_object_version_number OUT NOCOPY NUMBER,
102 x_estimate_detail_id IN OUT NOCOPY NUMBER, --3951392
103 x_msg_data OUT NOCOPY VARCHAR2,
104 p_resp_appl_id IN NUMBER DEFAULT NULL,
105 p_resp_id IN NUMBER DEFAULT NULL,
106 p_user_id IN NUMBER DEFAULT NULL,
107 p_login_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
108 p_transaction_control IN VARCHAR2 DEFAULT FND_API.G_TRUE,
109 p_est_detail_rec IN CS_Charge_Details_PUB.Charges_Rec_Type);
110
111
112
113 /* Customer Procedure for pre processing in case of call pricing item */
114 Procedure Call_Pricing_Item_Pre (
115 p_inventory_item_id IN NUMBER,
116 p_price_list_id IN NUMBER,
117 p_uom_code IN VARCHAR2,
118 p_currency_code IN VARCHAR2,
119 p_quantity IN NUMBER,
120 p_org_id IN NUMBER,
121 x_list_price OUT NOCOPY NUMBER,
122 p_in_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
123 x_return_status OUT NOCOPY VARCHAR2,
124 x_msg_count OUT NOCOPY NUMBER,
125 x_msg_data OUT NOCOPY VARCHAR2 );
126
127 END CS_CHARGE_DETAILS_CUHK ;