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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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:
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,
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,