PACKAGE: APPS.PA_REQUESTS_CREATION_PKG

Source

1 PACKAGE PA_REQUESTS_CREATION_PKG AUTHID CURRENT_USER as
2 /* $Header: PAYRPK1S.pls 120.1 2005/08/19 17:24:13 mwasowic noship $ */
3 --
4 -- Procedure     : insert_row
5 -- Purpose       : Create Row in PA_REQ_CREATE_TEMP.
6 --
7 --
8 PROCEDURE insert_row
9       ( p_request_name                    IN PA_REQ_CREATE_TEMP.request_name%TYPE,
10 	      p_request_number                  IN PA_REQ_CREATE_TEMP.request_number%TYPE,
11         p_request_type                    IN PA_REQ_CREATE_TEMP.request_type%TYPE,
12         p_request_status_name             IN PA_REQ_CREATE_TEMP.request_status_name%TYPE,
13         p_request_customer                IN PA_REQ_CREATE_TEMP.request_customer%TYPE,
14         p_country			                    IN PA_REQ_CREATE_TEMP.country%TYPE,
15         p_state	                          IN PA_REQ_CREATE_TEMP.state%TYPE,
16         p_city				                    IN PA_REQ_CREATE_TEMP.city%TYPE,
17         p_value                           IN PA_REQ_CREATE_TEMP.value%TYPE,
18         p_currency_code                   IN PA_REQ_CREATE_TEMP.currency_code%TYPE,
19         p_expected_proj_approval_date     IN PA_REQ_CREATE_TEMP.expected_project_approval_date%TYPE,
20         p_source_reference                IN PA_REQ_CREATE_TEMP.source_reference%TYPE,
21         x_return_status                   OUT  NOCOPY VARCHAR2                          , --File.Sql.39 bug 4440895
22         x_msg_count                       OUT  NOCOPY NUMBER                            , --File.Sql.39 bug 4440895
23         x_msg_data                        OUT  NOCOPY VARCHAR2 );  --File.Sql.39 bug 4440895
24 
25 
26 
27 END PA_REQUESTS_CREATION_PKG;