[Home] [Help]
82: ,x_msg_count OUT NOCOPY NUMBER
83: ,x_msg_data OUT NOCOPY VARCHAR2
84: ,p_vrrv_tbl IN vrrv_tbl_type
85: ,x_vrrv_tbl OUT NOCOPY vrrv_tbl_type
86: ,x_request_status OUT NOCOPY okl_vp_change_requests.status_code%TYPE
87: );
88:
89: -------------------------------------------------------------------------------
90: -- PROCEDURE update_change_request_lines
107: ,x_msg_count OUT NOCOPY NUMBER
108: ,x_msg_data OUT NOCOPY VARCHAR2
109: ,p_vrrv_tbl IN vrrv_tbl_type
110: ,x_vrrv_tbl OUT NOCOPY vrrv_tbl_type
111: ,x_request_status OUT NOCOPY okl_vp_change_requests.status_code%TYPE
112: );
113:
114: -------------------------------------------------------------------------------
115: -- PROCEDURE delete_change_request_lines
131: ,x_return_status OUT NOCOPY VARCHAR2
132: ,x_msg_count OUT NOCOPY NUMBER
133: ,x_msg_data OUT NOCOPY VARCHAR2
134: ,p_vrrv_tbl IN vrrv_tbl_type
135: ,x_request_status OUT NOCOPY okl_vp_change_requests.status_code%TYPE
136: );
137:
138: -------------------------------------------------------------------------------
139: -- PROCEDURE create_change_request
191: -- Description : procedure updates change requests status for Operating Agreement and Program Agreement
192: -- the status change is required whenever the change request transitions to a state
193: -- For an AGREEMENT type of change request, the change request status is passed on to the
194: -- copied agreement
195: -- Parameters : IN p_vp_crq_id okl_vp_change_requests.id%TYPE
196: -- IN p_status_code okl_vp_change_requests.status_code%TYPE;
197: -- NO OUT parameters, if the x_return_status = OKL_API.G_RET_STS_SUCCESS then
198: -- the effective status of the change request is the passed in status code value
199: -- Version : 1.0
192: -- the status change is required whenever the change request transitions to a state
193: -- For an AGREEMENT type of change request, the change request status is passed on to the
194: -- copied agreement
195: -- Parameters : IN p_vp_crq_id okl_vp_change_requests.id%TYPE
196: -- IN p_status_code okl_vp_change_requests.status_code%TYPE;
197: -- NO OUT parameters, if the x_return_status = OKL_API.G_RET_STS_SUCCESS then
198: -- the effective status of the change request is the passed in status code value
199: -- Version : 1.0
200: -- History : 26-APR-2005 SJALASUT created
204: ,p_init_msg_list IN VARCHAR2
205: ,x_return_status OUT NOCOPY VARCHAR2
206: ,x_msg_count OUT NOCOPY NUMBER
207: ,x_msg_data OUT NOCOPY VARCHAR2
208: ,p_vp_crq_id IN okl_vp_change_requests.id%TYPE
209: ,p_status_code IN okl_vp_change_requests.status_code%TYPE
210: );
211:
212: -------------------------------------------------------------------------------
205: ,x_return_status OUT NOCOPY VARCHAR2
206: ,x_msg_count OUT NOCOPY NUMBER
207: ,x_msg_data OUT NOCOPY VARCHAR2
208: ,p_vp_crq_id IN okl_vp_change_requests.id%TYPE
209: ,p_status_code IN okl_vp_change_requests.status_code%TYPE
210: );
211:
212: -------------------------------------------------------------------------------
213: -- PROCEDURE cascade_request_status_edit
227: ,p_init_msg_list IN VARCHAR2
228: ,x_return_status OUT NOCOPY VARCHAR2
229: ,x_msg_count OUT NOCOPY NUMBER
230: ,x_msg_data OUT NOCOPY VARCHAR2
231: ,p_vp_crq_id IN okl_vp_change_requests.id%TYPE
232: ,x_status_code OUT NOCOPY okl_vp_change_requests.status_code%TYPE
233: );
234:
235: -------------------------------------------------------------------------------
228: ,x_return_status OUT NOCOPY VARCHAR2
229: ,x_msg_count OUT NOCOPY NUMBER
230: ,x_msg_data OUT NOCOPY VARCHAR2
231: ,p_vp_crq_id IN okl_vp_change_requests.id%TYPE
232: ,x_status_code OUT NOCOPY okl_vp_change_requests.status_code%TYPE
233: );
234:
235: -------------------------------------------------------------------------------
236: -- PROCEDURE submit_cr_for_approval
253: ,x_return_status OUT NOCOPY VARCHAR2
254: ,x_msg_count OUT NOCOPY NUMBER
255: ,x_msg_data OUT NOCOPY VARCHAR2
256: ,p_chr_id IN okc_k_headers_b.id%TYPE
257: ,x_status_code OUT NOCOPY okl_vp_change_requests.status_code%TYPE
258: );
259:
260: -------------------------------------------------------------------------------
261: -- FUNCTION get_assoc_agr_number
265: -- Procedure Name : get_assoc_agr_number
266: -- Description : function returns the assocaited agreement number with this change request
267: -- if the change request is of type AGREEMENT, then the agreement number is
268: -- determined by the okl_k_headers record that contains this change request id
269: -- Parameters : IN p_change_request_id id from okl_vp_change_requests table
270: -- returns contract_number of okc_k_headers_b
271: -- Version : 1.0
272: -- History : 18-SEP-2005 SJALASUT created
273: -- End of comments
271: -- Version : 1.0
272: -- History : 18-SEP-2005 SJALASUT created
273: -- End of comments
274:
275: FUNCTION get_assoc_agr_number(p_change_request_id IN okl_vp_change_requests.id%TYPE) RETURN VARCHAR2;
276:
277: -------------------------------------------------------------------------------
278: -- FUNCTION get_assoc_agr_id
279: -------------------------------------------------------------------------------
282: -- Procedure Name : get_assoc_agr_id
283: -- Description : function returns the assocaited agreement id with this change request
284: -- if the change request is of type AGREEMENT, then the agreement id is
285: -- determined by the okl_k_headers record that contains this change request id
286: -- Parameters : IN p_change_request_id id from okl_vp_change_requests table
287: -- returns id of okc_k_headers_b
288: -- Version : 1.0
289: -- History : 18-SEP-2005 SJALASUT created
290: -- End of comments
288: -- Version : 1.0
289: -- History : 18-SEP-2005 SJALASUT created
290: -- End of comments
291:
292: FUNCTION get_assoc_agr_id(p_change_request_id IN okl_vp_change_requests.id%TYPE) RETURN NUMBER;
293:
294: END okl_vp_change_request_pvt;