eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROJECT_REQUEST_PKG dependencies on PA_PROJECT_REQUESTS

Line 5: -- Purpose : Create Row in PA_PROJECT_REQUESTS.

1: PACKAGE PA_PROJECT_REQUEST_PKG AUTHID CURRENT_USER 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,

Line 9: ( p_request_name IN pa_project_requests.request_name%TYPE,

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,

Line 10: p_request_type IN pa_project_requests.request_type%TYPE,

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,

Line 11: p_request_status_code IN pa_project_requests.status_code%TYPE,

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

Line 12: p_description IN pa_project_requests.description%TYPE,

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,

Line 13: p_expected_proj_approval_date IN pa_project_requests.expected_project_approval_date%TYPE,

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,

Line 14: p_closed_date IN pa_project_requests.closed_date%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,

Line 15: p_source_type IN pa_project_requests.source_type%TYPE :='ORACLE_APPLICATION',

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,

Line 16: p_application_id IN pa_project_requests.application_id%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,

Line 17: p_source_reference IN pa_project_requests.source_reference%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,

Line 18: p_value IN pa_project_requests.value%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,

Line 19: p_currency_code IN pa_project_requests.currency_code%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,

Line 20: p_cust_party_id IN pa_project_requests.cust_party_id%TYPE,

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,

Line 21: p_cust_party_site_id IN pa_project_requests.cust_party_site_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,

Line 22: p_cust_account_id IN pa_project_requests.cust_account_id%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,

Line 23: p_source_org_id IN pa_project_requests.source_org_id%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,

Line 24: p_record_version_number IN pa_project_requests.record_version_number%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,

Line 25: p_attribute_category IN pa_project_requests.attribute_category%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,

Line 26: p_attribute1 IN pa_project_requests.attribute1%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,

Line 27: p_attribute2 IN pa_project_requests.attribute2%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,

Line 28: p_attribute3 IN pa_project_requests.attribute3%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,

Line 29: p_attribute4 IN pa_project_requests.attribute4%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,

Line 30: p_attribute5 IN pa_project_requests.attribute5%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,

Line 31: p_attribute6 IN pa_project_requests.attribute6%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,

Line 32: p_attribute7 IN pa_project_requests.attribute7%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,

Line 33: p_attribute8 IN pa_project_requests.attribute8%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,

Line 34: p_attribute9 IN pa_project_requests.attribute9%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,

Line 35: p_attribute10 IN pa_project_requests.attribute10%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,

Line 36: p_attribute11 IN pa_project_requests.attribute11%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,

Line 37: p_attribute12 IN pa_project_requests.attribute12%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

Line 38: p_attribute13 IN pa_project_requests.attribute13%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

Line 39: p_attribute14 IN pa_project_requests.attribute14%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

Line 40: p_attribute15 IN pa_project_requests.attribute15%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

Line 41: x_request_id OUT NOCOPY pa_project_requests.request_id%TYPE, --File.Sql.39 bug 4440895

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

Line 42: x_request_number OUT NOCOPY pa_project_requests.request_number%TYPE, --File.Sql.39 bug 4440895

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:

Line 49: -- Purpose : Update row in PA_PROJECT_REQUESTS.

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 ,

Line 53: ( p_request_id IN pa_project_requests.request_id%TYPE ,

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

Line 54: p_request_status_code IN pa_project_requests.status_code%TYPE,

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

Line 55: p_closed_date IN pa_project_requests.closed_date%TYPE DEFAULT NULL,

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