[Home] [Help]
PACKAGE: APPS.CS_CHARGE_DETAILS_PVT
Source
1 PACKAGE CS_Charge_Details_PVT AUTHID CURRENT_USER AS
2 /* $Header: csxvests.pls 120.3 2005/08/18 16:49:35 mviswana noship $ */
3
4 -----------------------------------------------------------------------------
5 -- PACKAGE SPECIFIC CONSTANTS
6 -----------------------------------------------------------------------------
7 G_PKG_NAME CONSTANT VARCHAR2(30) := 'CS_CHARGE_DETAILS_PVT';
8
9 -----------------------------------------------------------------------------
10 -- APPLICATION GLOBAL CONSTANTS
11 -----------------------------------------------------------------------------
12 G_APP_NAME CONSTANT VARCHAR2(2) := 'CS';
13 G_API_VERSION CONSTANT NUMBER := 1.0;
14 G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
15 G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
16 G_DB_ERROR CONSTANT VARCHAR2(11) := 'CS_DB_ERROR';
17 G_PROG_NAME_TOKEN CONSTANT VARCHAR2(9) := 'PROG_NAME';
18 G_SQLCODE_TOKEN CONSTANT VARCHAR2(7) := 'SQLCODE';
19 G_SQLERRM_TOKEN CONSTANT VARCHAR2(7) := 'SQLERRM';
20 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
21 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
22 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
23
24
25 -----------------------------------------------------------------------------
26 -- PROGRAM UNITS
27 -----------------------------------------------------------------------------
28 PROCEDURE Create_Charge_Details(
29 p_api_version IN NUMBER,
30 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
31 p_commit IN VARCHAR2 := FND_API.G_FALSE,
32 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
33 x_return_status OUT NOCOPY VARCHAR2,
34 x_msg_count OUT NOCOPY NUMBER,
35 x_object_version_number OUT NOCOPY NUMBER,
36 x_estimate_detail_id OUT NOCOPY NUMBER,
37 x_line_number OUT NOCOPY NUMBER,
38 x_msg_data OUT NOCOPY VARCHAR2,
39 --p_resp_appl_id IN NUMBER := NULL,
40 --p_resp_id IN NUMBER := NULL,
41 --p_user_id IN NUMBER := NULL,
42 p_resp_appl_id IN NUMBER := FND_GLOBAL.RESP_APPL_ID,
43 p_resp_id IN NUMBER := FND_GLOBAL.RESP_ID,
44 p_user_id IN NUMBER := FND_GLOBAL.USER_ID,
45 p_login_id IN NUMBER := NULL,
46 p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,
47 p_est_detail_rec IN CS_Charge_Details_PUB.Charges_Rec_Type);
48
49
50
51 -- Procedure Update Charge Detail
52 -- Updates CS_ESTIMATE_DETAILS
53
54 PROCEDURE Update_Charge_Details(
55 p_api_version IN NUMBER,
56 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
57 p_commit IN VARCHAR2 := FND_API.G_FALSE,
58 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
59 x_return_status OUT NOCOPY VARCHAR2,
60 x_msg_count OUT NOCOPY NUMBER,
61 x_object_version_number OUT NOCOPY NUMBER,
62 x_msg_data OUT NOCOPY VARCHAR2,
63 --p_resp_appl_id IN NUMBER := NULL,
64 --p_resp_id IN NUMBER := NULL,
65 -- p_user_id IN NUMBER := NULL,
66 p_resp_appl_id IN NUMBER := FND_GLOBAL.RESP_APPL_ID,
67 p_resp_id IN NUMBER := FND_GLOBAL.RESP_ID,
68 p_user_id IN NUMBER := FND_GLOBAL.USER_ID,
69 p_login_id IN NUMBER := NULL,
70 p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,
71 p_est_detail_rec IN CS_Charge_Details_PUB.Charges_Rec_Type);
72
73
74 -- Procedure Delete Charge Detail
75 -- Deletes CS_ESTIMATE_DETAILS
76
77 PROCEDURE Delete_Charge_Details(
78 p_api_version IN NUMBER,
79 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
80 p_commit IN VARCHAR2 := FND_API.G_FALSE,
81 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
82 x_return_status OUT NOCOPY VARCHAR2,
83 x_msg_count OUT NOCOPY NUMBER,
84 x_msg_data OUT NOCOPY VARCHAR2,
85 p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,
86 p_estimate_detail_id IN NUMBER := NULL) ;
87
88 -- Procedure Copy Estimate
89 -- Copies Estimate from CS_ESTIMATE_DETAILS
90
91 Procedure Copy_Estimate(
92 p_api_version IN NUMBER,
93 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
94 p_commit IN VARCHAR2 := FND_API.G_FALSE,
95 p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,
96 p_estimate_detail_id IN NUMBER := NULL,
97 x_estimate_detail_id OUT NOCOPY NUMBER,
98 x_return_status OUT NOCOPY VARCHAR2,
99 x_msg_count OUT NOCOPY NUMBER,
100 x_msg_data OUT NOCOPY VARCHAR2);
101
102 -- Procedure Get Contracts
103 -- Get Contract
104 -- Chaged for R12 contract re-arch changes
105
106 procedure get_contract(
107 p_api_name IN VARCHAR2,
108 p_contract_SR_ID IN NUMBER,
109 p_incident_date IN DATE,
110 p_creation_date IN DATE,
111 p_customer_id IN NUMBER,
112 p_cust_account_id IN NUMBER,
113 p_cust_product_id IN NUMBER,
114 p_system_id IN NUMBER DEFAULT NULL,
115 p_inventory_item_id IN NUMBER DEFAULT NULL,
116 p_business_process_id IN NUMBER,
117 x_contract_id OUT NOCOPY NUMBER,
118 x_po_number OUT NOCOPY VARCHAR2,
119 x_return_status OUT NOCOPY VARCHAR2,
120 x_msg_count OUT NOCOPY NUMBER,
121 x_msg_data OUT NOCOPY VARCHAR2);
122
123 -- Procedure to validate charge lines related to an SR
124 -- and indicating if the SR can be purged or not.
125
126 PROCEDURE Purge_Chg_Validations
127 (
128 p_api_version_number IN NUMBER := 1.0
129 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
130 , p_commit IN VARCHAR2 := FND_API.G_FALSE
131 , p_object_type IN VARCHAR2
132 , p_processing_set_id IN NUMBER
133 , x_return_status OUT NOCOPY VARCHAR2
134 , x_msg_count OUT NOCOPY NUMBER
135 , x_msg_data OUT NOCOPY VARCHAR2
136 );
137
138 -- Procedure to purge charge lines attached to an SR.
139
140 PROCEDURE Purge_Charges
141 (
142 p_api_version_number IN NUMBER := 1.0
143 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
144 , p_commit IN VARCHAR2 := FND_API.G_FALSE
145 , p_object_type IN VARCHAR2
146 , p_processing_set_id IN NUMBER
147 , x_return_status OUT NOCOPY VARCHAR2
148 , x_msg_count OUT NOCOPY NUMBER
149 , x_msg_data OUT NOCOPY VARCHAR2
150 );
151
152
153 END CS_Charge_Details_PVT;