1 PACKAGE PA_PROJECT_REQUEST_PUB as
2 /* $Header: PAYRPUBS.pls 120.1 2005/08/19 17:25:01 mwasowic noship $ */
3
4 -- Note: The following IN parameters are not supported in
5 -- Phase 1 Sales Online and Projects Integration.
6 -- Parameters
7 -- p_request_status_name
8 -- p_cust_party_name
9 -- p_cust_party_site_name
10 -- p_cust_account_name
11
12 PROCEDURE create_project_request
13 ( p_request_name IN pa_project_requests.request_name%TYPE,
14 p_request_type IN pa_project_requests.request_type%TYPE,
15 p_request_status_code IN pa_project_requests.status_code%TYPE,
16 p_request_status_name IN pa_project_statuses.project_status_name%TYPE,
17 p_description IN pa_project_requests.description%TYPE,
18 p_expected_proj_approval_date IN pa_project_requests.expected_project_approval_date%TYPE,
19 p_closed_date IN pa_project_requests.closed_date%TYPE,
20 p_source_type IN pa_project_requests.source_type%TYPE :='ORACLE_APPLICATION',
21 p_application_id IN pa_project_requests.application_id%TYPE,
22 p_source_id IN NUMBER,
23 p_source_object IN pa_object_relationships.object_type_from%TYPE,
24 p_source_reference IN pa_project_requests.source_reference%TYPE,
25 p_value IN pa_project_requests.value%TYPE,
26 p_currency_code IN pa_project_requests.currency_code%TYPE,
27 p_cust_party_id IN pa_project_requests.cust_party_id%TYPE,
28 p_cust_party_name IN hz_parties.party_name%TYPE,
29 p_cust_party_site_id IN pa_project_requests.cust_party_site_id%TYPE,
30 p_cust_party_site_name IN hz_party_sites.party_site_name%TYPE,
31 p_cust_account_id IN pa_project_requests.cust_account_id%TYPE,
32 p_cust_account_name IN hz_cust_accounts.account_name%TYPE,
33 p_source_org_id IN pa_project_requests.source_org_id%TYPE,
34 p_attribute_category IN pa_project_requests.attribute_category%TYPE,
35 p_attribute1 IN pa_project_requests.attribute1%TYPE,
36 p_attribute2 IN pa_project_requests.attribute2%TYPE,
37 p_attribute3 IN pa_project_requests.attribute3%TYPE,
38 p_attribute4 IN pa_project_requests.attribute4%TYPE,
39 p_attribute5 IN pa_project_requests.attribute5%TYPE,
40 p_attribute6 IN pa_project_requests.attribute6%TYPE,
41 p_attribute7 IN pa_project_requests.attribute7%TYPE,
42 p_attribute8 IN pa_project_requests.attribute8%TYPE,
43 p_attribute9 IN pa_project_requests.attribute9%TYPE,
44 p_attribute10 IN pa_project_requests.attribute10%TYPE,
45 p_attribute11 IN pa_project_requests.attribute11%TYPE,
46 p_attribute12 IN pa_project_requests.attribute12%TYPE,
47 p_attribute13 IN pa_project_requests.attribute13%TYPE,
48 p_attribute14 IN pa_project_requests.attribute14%TYPE,
49 p_attribute15 IN pa_project_requests.attribute15%TYPE,
50 p_create_rel_flag IN VARCHAR2,
51 p_api_version IN NUMBER := 1.0,
52 p_init_msg_list IN VARCHAR2,
53 p_commit IN VARCHAR2,
54 p_validate_only IN VARCHAR2,
55 p_max_msg_count IN NUMBER,
56 x_request_id OUT NOCOPY pa_project_requests.request_id%TYPE, --File.Sql.39 bug 4440895
57 x_request_number OUT NOCOPY pa_project_requests.request_number%TYPE, --File.Sql.39 bug 4440895
58 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
59 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
60 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
61
62
63 --
64 -- Note: The following IN parameters are not supported in
65 -- Phase 1 Sales Online and Projects Integration.
66 -- Parameters
67 -- p_request_name
68
69 PROCEDURE cancel_project_request
70 (p_request_id IN pa_project_requests.request_id%TYPE,
71 p_request_name IN pa_project_requests.request_name%TYPE,
72 p_request_sys_status IN pa_project_statuses.project_system_status_code%TYPE,
73 p_record_version_number IN NUMBER DEFAULT NULL,
74 p_api_version IN NUMBER :=1.0,
75 p_init_msg_list IN VARCHAR2,
76 p_commit IN VARCHAR2,
77 p_validate_only IN VARCHAR2,
78 p_max_msg_count IN NUMBER,
79 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
80 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
81 x_msg_data OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895
82
83 procedure party_merge(
84 p_entity_name IN varchar2
85 ,p_from_id IN number
86 ,p_to_id in OUT nocopy number
87 ,p_from_fk_id IN number
88 ,p_to_fk_id IN number
89 ,p_parent_entity_name IN varchar2
90 ,p_batch_id IN number
91 ,p_batch_party_id IN number
92 ,p_return_status IN OUT nocopy varchar2
93 );
94
95 END pa_project_request_pub;