[Home] [Help]
PACKAGE: APPS.PA_PROJECT_REQUEST_PKG
Source
1 PACKAGE PA_PROJECT_REQUEST_PKG as
2 /* $Header: PAYRPKGS.pls 120.1 2005/08/19 17:24:52 mwasowic noship $ */
3 --
4 -- Procedure : insert_row
5 -- Purpose : Create Row in PA_PROJECT_REQUESTS.
6 --
7 --
8 PROCEDURE insert_row
9 ( p_request_name IN pa_project_requests.request_name%TYPE,
10 p_request_type IN pa_project_requests.request_type%TYPE,
11 p_request_status_code IN pa_project_requests.status_code%TYPE,
12 p_description IN pa_project_requests.description%TYPE,
13 p_expected_proj_approval_date IN pa_project_requests.expected_project_approval_date%TYPE,
14 p_closed_date IN pa_project_requests.closed_date%TYPE,
15 p_source_type IN pa_project_requests.source_type%TYPE :='ORACLE_APPLICATION',
16 p_application_id IN pa_project_requests.application_id%TYPE,
17 p_source_reference IN pa_project_requests.source_reference%TYPE,
18 p_value IN pa_project_requests.value%TYPE,
19 p_currency_code IN pa_project_requests.currency_code%TYPE,
20 p_cust_party_id IN pa_project_requests.cust_party_id%TYPE,
21 p_cust_party_site_id IN pa_project_requests.cust_party_site_id%TYPE,
22 p_cust_account_id IN pa_project_requests.cust_account_id%TYPE,
23 p_source_org_id IN pa_project_requests.source_org_id%TYPE,
24 p_record_version_number IN pa_project_requests.record_version_number%TYPE,
25 p_attribute_category IN pa_project_requests.attribute_category%TYPE,
26 p_attribute1 IN pa_project_requests.attribute1%TYPE,
27 p_attribute2 IN pa_project_requests.attribute2%TYPE,
28 p_attribute3 IN pa_project_requests.attribute3%TYPE,
29 p_attribute4 IN pa_project_requests.attribute4%TYPE,
30 p_attribute5 IN pa_project_requests.attribute5%TYPE,
31 p_attribute6 IN pa_project_requests.attribute6%TYPE,
32 p_attribute7 IN pa_project_requests.attribute7%TYPE,
33 p_attribute8 IN pa_project_requests.attribute8%TYPE,
34 p_attribute9 IN pa_project_requests.attribute9%TYPE,
35 p_attribute10 IN pa_project_requests.attribute10%TYPE,
36 p_attribute11 IN pa_project_requests.attribute11%TYPE,
37 p_attribute12 IN pa_project_requests.attribute12%TYPE,
38 p_attribute13 IN pa_project_requests.attribute13%TYPE,
39 p_attribute14 IN pa_project_requests.attribute14%TYPE,
40 p_attribute15 IN pa_project_requests.attribute15%TYPE,
41 x_request_id OUT NOCOPY pa_project_requests.request_id%TYPE, --File.Sql.39 bug 4440895
42 x_request_number OUT NOCOPY pa_project_requests.request_number%TYPE, --File.Sql.39 bug 4440895
43 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
44 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
45 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
46
47 --
48 -- Procedure : update_row
49 -- Purpose : Update row in PA_PROJECT_REQUESTS.
50 --
51 --
52 PROCEDURE update_row
53 ( p_request_id IN pa_project_requests.request_id%TYPE ,
54 p_request_status_code IN pa_project_requests.status_code%TYPE,
55 p_closed_date IN pa_project_requests.closed_date%TYPE DEFAULT NULL,
56 p_record_version_number IN NUMBER DEFAULT NULL,
57 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
58 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
59 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
60
61
62 END PA_PROJECT_REQUEST_PKG;