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 6: -- Purpose : Create Row in PA_PROJECT_REQUESTS.

2: /* $Header: PAYRPKGB.pls 120.2 2005/08/19 17:24:46 mwasowic noship $ */
3:
4: --
5: -- Procedure : Insert_row
6: -- Purpose : Create Row in PA_PROJECT_REQUESTS.
7: --
8: --
9: PROCEDURE insert_row
10: ( p_request_name IN pa_project_requests.request_name%TYPE,

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

6: -- Purpose : Create Row in PA_PROJECT_REQUESTS.
7: --
8: --
9: PROCEDURE insert_row
10: ( p_request_name IN pa_project_requests.request_name%TYPE,
11: p_request_type IN pa_project_requests.request_type%TYPE,
12: p_request_status_code IN pa_project_requests.status_code%TYPE,
13: p_description IN pa_project_requests.description%TYPE,
14: p_expected_proj_approval_date IN pa_project_requests.expected_project_approval_date%TYPE,

Line 11: p_request_type IN pa_project_requests.request_type%TYPE,

7: --
8: --
9: PROCEDURE insert_row
10: ( p_request_name IN pa_project_requests.request_name%TYPE,
11: p_request_type IN pa_project_requests.request_type%TYPE,
12: p_request_status_code IN pa_project_requests.status_code%TYPE,
13: p_description IN pa_project_requests.description%TYPE,
14: p_expected_proj_approval_date IN pa_project_requests.expected_project_approval_date%TYPE,
15: p_closed_date IN pa_project_requests.closed_date%TYPE,

Line 12: p_request_status_code IN pa_project_requests.status_code%TYPE,

8: --
9: PROCEDURE insert_row
10: ( p_request_name IN pa_project_requests.request_name%TYPE,
11: p_request_type IN pa_project_requests.request_type%TYPE,
12: p_request_status_code IN pa_project_requests.status_code%TYPE,
13: p_description IN pa_project_requests.description%TYPE,
14: p_expected_proj_approval_date IN pa_project_requests.expected_project_approval_date%TYPE,
15: p_closed_date IN pa_project_requests.closed_date%TYPE,
16: p_source_type IN pa_project_requests.source_type%TYPE :='ORACLE_APPLICATION',

Line 13: p_description IN pa_project_requests.description%TYPE,

9: PROCEDURE insert_row
10: ( p_request_name IN pa_project_requests.request_name%TYPE,
11: p_request_type IN pa_project_requests.request_type%TYPE,
12: p_request_status_code IN pa_project_requests.status_code%TYPE,
13: p_description IN pa_project_requests.description%TYPE,
14: p_expected_proj_approval_date IN pa_project_requests.expected_project_approval_date%TYPE,
15: p_closed_date IN pa_project_requests.closed_date%TYPE,
16: p_source_type IN pa_project_requests.source_type%TYPE :='ORACLE_APPLICATION',
17: p_application_id IN pa_project_requests.application_id%TYPE,

Line 14: p_expected_proj_approval_date IN pa_project_requests.expected_project_approval_date%TYPE,

10: ( p_request_name IN pa_project_requests.request_name%TYPE,
11: p_request_type IN pa_project_requests.request_type%TYPE,
12: p_request_status_code IN pa_project_requests.status_code%TYPE,
13: p_description IN pa_project_requests.description%TYPE,
14: p_expected_proj_approval_date IN pa_project_requests.expected_project_approval_date%TYPE,
15: p_closed_date IN pa_project_requests.closed_date%TYPE,
16: p_source_type IN pa_project_requests.source_type%TYPE :='ORACLE_APPLICATION',
17: p_application_id IN pa_project_requests.application_id%TYPE,
18: p_source_reference IN pa_project_requests.source_reference%TYPE,

Line 15: p_closed_date IN pa_project_requests.closed_date%TYPE,

11: p_request_type IN pa_project_requests.request_type%TYPE,
12: p_request_status_code IN pa_project_requests.status_code%TYPE,
13: p_description IN pa_project_requests.description%TYPE,
14: p_expected_proj_approval_date IN pa_project_requests.expected_project_approval_date%TYPE,
15: p_closed_date IN pa_project_requests.closed_date%TYPE,
16: p_source_type IN pa_project_requests.source_type%TYPE :='ORACLE_APPLICATION',
17: p_application_id IN pa_project_requests.application_id%TYPE,
18: p_source_reference IN pa_project_requests.source_reference%TYPE,
19: p_value IN pa_project_requests.value%TYPE,

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

12: p_request_status_code IN pa_project_requests.status_code%TYPE,
13: p_description IN pa_project_requests.description%TYPE,
14: p_expected_proj_approval_date IN pa_project_requests.expected_project_approval_date%TYPE,
15: p_closed_date IN pa_project_requests.closed_date%TYPE,
16: p_source_type IN pa_project_requests.source_type%TYPE :='ORACLE_APPLICATION',
17: p_application_id IN pa_project_requests.application_id%TYPE,
18: p_source_reference IN pa_project_requests.source_reference%TYPE,
19: p_value IN pa_project_requests.value%TYPE,
20: p_currency_code IN pa_project_requests.currency_code%TYPE,

Line 17: p_application_id IN pa_project_requests.application_id%TYPE,

13: p_description IN pa_project_requests.description%TYPE,
14: p_expected_proj_approval_date IN pa_project_requests.expected_project_approval_date%TYPE,
15: p_closed_date IN pa_project_requests.closed_date%TYPE,
16: p_source_type IN pa_project_requests.source_type%TYPE :='ORACLE_APPLICATION',
17: p_application_id IN pa_project_requests.application_id%TYPE,
18: p_source_reference IN pa_project_requests.source_reference%TYPE,
19: p_value IN pa_project_requests.value%TYPE,
20: p_currency_code IN pa_project_requests.currency_code%TYPE,
21: p_cust_party_id IN pa_project_requests.cust_party_id%TYPE,

Line 18: p_source_reference IN pa_project_requests.source_reference%TYPE,

14: p_expected_proj_approval_date IN pa_project_requests.expected_project_approval_date%TYPE,
15: p_closed_date IN pa_project_requests.closed_date%TYPE,
16: p_source_type IN pa_project_requests.source_type%TYPE :='ORACLE_APPLICATION',
17: p_application_id IN pa_project_requests.application_id%TYPE,
18: p_source_reference IN pa_project_requests.source_reference%TYPE,
19: p_value IN pa_project_requests.value%TYPE,
20: p_currency_code IN pa_project_requests.currency_code%TYPE,
21: p_cust_party_id IN pa_project_requests.cust_party_id%TYPE,
22: p_cust_party_site_id IN pa_project_requests.cust_party_site_id%TYPE,

Line 19: p_value IN pa_project_requests.value%TYPE,

15: p_closed_date IN pa_project_requests.closed_date%TYPE,
16: p_source_type IN pa_project_requests.source_type%TYPE :='ORACLE_APPLICATION',
17: p_application_id IN pa_project_requests.application_id%TYPE,
18: p_source_reference IN pa_project_requests.source_reference%TYPE,
19: p_value IN pa_project_requests.value%TYPE,
20: p_currency_code IN pa_project_requests.currency_code%TYPE,
21: p_cust_party_id IN pa_project_requests.cust_party_id%TYPE,
22: p_cust_party_site_id IN pa_project_requests.cust_party_site_id%TYPE,
23: p_cust_account_id IN pa_project_requests.cust_account_id%TYPE,

Line 20: p_currency_code IN pa_project_requests.currency_code%TYPE,

16: p_source_type IN pa_project_requests.source_type%TYPE :='ORACLE_APPLICATION',
17: p_application_id IN pa_project_requests.application_id%TYPE,
18: p_source_reference IN pa_project_requests.source_reference%TYPE,
19: p_value IN pa_project_requests.value%TYPE,
20: p_currency_code IN pa_project_requests.currency_code%TYPE,
21: p_cust_party_id IN pa_project_requests.cust_party_id%TYPE,
22: p_cust_party_site_id IN pa_project_requests.cust_party_site_id%TYPE,
23: p_cust_account_id IN pa_project_requests.cust_account_id%TYPE,
24: p_source_org_id IN pa_project_requests.source_org_id%TYPE,

Line 21: p_cust_party_id IN pa_project_requests.cust_party_id%TYPE,

17: p_application_id IN pa_project_requests.application_id%TYPE,
18: p_source_reference IN pa_project_requests.source_reference%TYPE,
19: p_value IN pa_project_requests.value%TYPE,
20: p_currency_code IN pa_project_requests.currency_code%TYPE,
21: p_cust_party_id IN pa_project_requests.cust_party_id%TYPE,
22: p_cust_party_site_id IN pa_project_requests.cust_party_site_id%TYPE,
23: p_cust_account_id IN pa_project_requests.cust_account_id%TYPE,
24: p_source_org_id IN pa_project_requests.source_org_id%TYPE,
25: p_record_version_number IN pa_project_requests.record_version_number%TYPE,

Line 22: p_cust_party_site_id IN pa_project_requests.cust_party_site_id%TYPE,

18: p_source_reference IN pa_project_requests.source_reference%TYPE,
19: p_value IN pa_project_requests.value%TYPE,
20: p_currency_code IN pa_project_requests.currency_code%TYPE,
21: p_cust_party_id IN pa_project_requests.cust_party_id%TYPE,
22: p_cust_party_site_id IN pa_project_requests.cust_party_site_id%TYPE,
23: p_cust_account_id IN pa_project_requests.cust_account_id%TYPE,
24: p_source_org_id IN pa_project_requests.source_org_id%TYPE,
25: p_record_version_number IN pa_project_requests.record_version_number%TYPE,
26: p_attribute_category IN pa_project_requests.attribute_category%TYPE,

Line 23: p_cust_account_id IN pa_project_requests.cust_account_id%TYPE,

19: p_value IN pa_project_requests.value%TYPE,
20: p_currency_code IN pa_project_requests.currency_code%TYPE,
21: p_cust_party_id IN pa_project_requests.cust_party_id%TYPE,
22: p_cust_party_site_id IN pa_project_requests.cust_party_site_id%TYPE,
23: p_cust_account_id IN pa_project_requests.cust_account_id%TYPE,
24: p_source_org_id IN pa_project_requests.source_org_id%TYPE,
25: p_record_version_number IN pa_project_requests.record_version_number%TYPE,
26: p_attribute_category IN pa_project_requests.attribute_category%TYPE,
27: p_attribute1 IN pa_project_requests.attribute1%TYPE,

Line 24: p_source_org_id IN pa_project_requests.source_org_id%TYPE,

20: p_currency_code IN pa_project_requests.currency_code%TYPE,
21: p_cust_party_id IN pa_project_requests.cust_party_id%TYPE,
22: p_cust_party_site_id IN pa_project_requests.cust_party_site_id%TYPE,
23: p_cust_account_id IN pa_project_requests.cust_account_id%TYPE,
24: p_source_org_id IN pa_project_requests.source_org_id%TYPE,
25: p_record_version_number IN pa_project_requests.record_version_number%TYPE,
26: p_attribute_category IN pa_project_requests.attribute_category%TYPE,
27: p_attribute1 IN pa_project_requests.attribute1%TYPE,
28: p_attribute2 IN pa_project_requests.attribute2%TYPE,

Line 25: p_record_version_number IN pa_project_requests.record_version_number%TYPE,

21: p_cust_party_id IN pa_project_requests.cust_party_id%TYPE,
22: p_cust_party_site_id IN pa_project_requests.cust_party_site_id%TYPE,
23: p_cust_account_id IN pa_project_requests.cust_account_id%TYPE,
24: p_source_org_id IN pa_project_requests.source_org_id%TYPE,
25: p_record_version_number IN pa_project_requests.record_version_number%TYPE,
26: p_attribute_category IN pa_project_requests.attribute_category%TYPE,
27: p_attribute1 IN pa_project_requests.attribute1%TYPE,
28: p_attribute2 IN pa_project_requests.attribute2%TYPE,
29: p_attribute3 IN pa_project_requests.attribute3%TYPE,

Line 26: p_attribute_category IN pa_project_requests.attribute_category%TYPE,

22: p_cust_party_site_id IN pa_project_requests.cust_party_site_id%TYPE,
23: p_cust_account_id IN pa_project_requests.cust_account_id%TYPE,
24: p_source_org_id IN pa_project_requests.source_org_id%TYPE,
25: p_record_version_number IN pa_project_requests.record_version_number%TYPE,
26: p_attribute_category IN pa_project_requests.attribute_category%TYPE,
27: p_attribute1 IN pa_project_requests.attribute1%TYPE,
28: p_attribute2 IN pa_project_requests.attribute2%TYPE,
29: p_attribute3 IN pa_project_requests.attribute3%TYPE,
30: p_attribute4 IN pa_project_requests.attribute4%TYPE,

Line 27: p_attribute1 IN pa_project_requests.attribute1%TYPE,

23: p_cust_account_id IN pa_project_requests.cust_account_id%TYPE,
24: p_source_org_id IN pa_project_requests.source_org_id%TYPE,
25: p_record_version_number IN pa_project_requests.record_version_number%TYPE,
26: p_attribute_category IN pa_project_requests.attribute_category%TYPE,
27: p_attribute1 IN pa_project_requests.attribute1%TYPE,
28: p_attribute2 IN pa_project_requests.attribute2%TYPE,
29: p_attribute3 IN pa_project_requests.attribute3%TYPE,
30: p_attribute4 IN pa_project_requests.attribute4%TYPE,
31: p_attribute5 IN pa_project_requests.attribute5%TYPE,

Line 28: p_attribute2 IN pa_project_requests.attribute2%TYPE,

24: p_source_org_id IN pa_project_requests.source_org_id%TYPE,
25: p_record_version_number IN pa_project_requests.record_version_number%TYPE,
26: p_attribute_category IN pa_project_requests.attribute_category%TYPE,
27: p_attribute1 IN pa_project_requests.attribute1%TYPE,
28: p_attribute2 IN pa_project_requests.attribute2%TYPE,
29: p_attribute3 IN pa_project_requests.attribute3%TYPE,
30: p_attribute4 IN pa_project_requests.attribute4%TYPE,
31: p_attribute5 IN pa_project_requests.attribute5%TYPE,
32: p_attribute6 IN pa_project_requests.attribute6%TYPE,

Line 29: p_attribute3 IN pa_project_requests.attribute3%TYPE,

25: p_record_version_number IN pa_project_requests.record_version_number%TYPE,
26: p_attribute_category IN pa_project_requests.attribute_category%TYPE,
27: p_attribute1 IN pa_project_requests.attribute1%TYPE,
28: p_attribute2 IN pa_project_requests.attribute2%TYPE,
29: p_attribute3 IN pa_project_requests.attribute3%TYPE,
30: p_attribute4 IN pa_project_requests.attribute4%TYPE,
31: p_attribute5 IN pa_project_requests.attribute5%TYPE,
32: p_attribute6 IN pa_project_requests.attribute6%TYPE,
33: p_attribute7 IN pa_project_requests.attribute7%TYPE,

Line 30: p_attribute4 IN pa_project_requests.attribute4%TYPE,

26: p_attribute_category IN pa_project_requests.attribute_category%TYPE,
27: p_attribute1 IN pa_project_requests.attribute1%TYPE,
28: p_attribute2 IN pa_project_requests.attribute2%TYPE,
29: p_attribute3 IN pa_project_requests.attribute3%TYPE,
30: p_attribute4 IN pa_project_requests.attribute4%TYPE,
31: p_attribute5 IN pa_project_requests.attribute5%TYPE,
32: p_attribute6 IN pa_project_requests.attribute6%TYPE,
33: p_attribute7 IN pa_project_requests.attribute7%TYPE,
34: p_attribute8 IN pa_project_requests.attribute8%TYPE,

Line 31: p_attribute5 IN pa_project_requests.attribute5%TYPE,

27: p_attribute1 IN pa_project_requests.attribute1%TYPE,
28: p_attribute2 IN pa_project_requests.attribute2%TYPE,
29: p_attribute3 IN pa_project_requests.attribute3%TYPE,
30: p_attribute4 IN pa_project_requests.attribute4%TYPE,
31: p_attribute5 IN pa_project_requests.attribute5%TYPE,
32: p_attribute6 IN pa_project_requests.attribute6%TYPE,
33: p_attribute7 IN pa_project_requests.attribute7%TYPE,
34: p_attribute8 IN pa_project_requests.attribute8%TYPE,
35: p_attribute9 IN pa_project_requests.attribute9%TYPE,

Line 32: p_attribute6 IN pa_project_requests.attribute6%TYPE,

28: p_attribute2 IN pa_project_requests.attribute2%TYPE,
29: p_attribute3 IN pa_project_requests.attribute3%TYPE,
30: p_attribute4 IN pa_project_requests.attribute4%TYPE,
31: p_attribute5 IN pa_project_requests.attribute5%TYPE,
32: p_attribute6 IN pa_project_requests.attribute6%TYPE,
33: p_attribute7 IN pa_project_requests.attribute7%TYPE,
34: p_attribute8 IN pa_project_requests.attribute8%TYPE,
35: p_attribute9 IN pa_project_requests.attribute9%TYPE,
36: p_attribute10 IN pa_project_requests.attribute10%TYPE,

Line 33: p_attribute7 IN pa_project_requests.attribute7%TYPE,

29: p_attribute3 IN pa_project_requests.attribute3%TYPE,
30: p_attribute4 IN pa_project_requests.attribute4%TYPE,
31: p_attribute5 IN pa_project_requests.attribute5%TYPE,
32: p_attribute6 IN pa_project_requests.attribute6%TYPE,
33: p_attribute7 IN pa_project_requests.attribute7%TYPE,
34: p_attribute8 IN pa_project_requests.attribute8%TYPE,
35: p_attribute9 IN pa_project_requests.attribute9%TYPE,
36: p_attribute10 IN pa_project_requests.attribute10%TYPE,
37: p_attribute11 IN pa_project_requests.attribute11%TYPE,

Line 34: p_attribute8 IN pa_project_requests.attribute8%TYPE,

30: p_attribute4 IN pa_project_requests.attribute4%TYPE,
31: p_attribute5 IN pa_project_requests.attribute5%TYPE,
32: p_attribute6 IN pa_project_requests.attribute6%TYPE,
33: p_attribute7 IN pa_project_requests.attribute7%TYPE,
34: p_attribute8 IN pa_project_requests.attribute8%TYPE,
35: p_attribute9 IN pa_project_requests.attribute9%TYPE,
36: p_attribute10 IN pa_project_requests.attribute10%TYPE,
37: p_attribute11 IN pa_project_requests.attribute11%TYPE,
38: p_attribute12 IN pa_project_requests.attribute12%TYPE,

Line 35: p_attribute9 IN pa_project_requests.attribute9%TYPE,

31: p_attribute5 IN pa_project_requests.attribute5%TYPE,
32: p_attribute6 IN pa_project_requests.attribute6%TYPE,
33: p_attribute7 IN pa_project_requests.attribute7%TYPE,
34: p_attribute8 IN pa_project_requests.attribute8%TYPE,
35: p_attribute9 IN pa_project_requests.attribute9%TYPE,
36: p_attribute10 IN pa_project_requests.attribute10%TYPE,
37: p_attribute11 IN pa_project_requests.attribute11%TYPE,
38: p_attribute12 IN pa_project_requests.attribute12%TYPE,
39: p_attribute13 IN pa_project_requests.attribute13%TYPE,

Line 36: p_attribute10 IN pa_project_requests.attribute10%TYPE,

32: p_attribute6 IN pa_project_requests.attribute6%TYPE,
33: p_attribute7 IN pa_project_requests.attribute7%TYPE,
34: p_attribute8 IN pa_project_requests.attribute8%TYPE,
35: p_attribute9 IN pa_project_requests.attribute9%TYPE,
36: p_attribute10 IN pa_project_requests.attribute10%TYPE,
37: p_attribute11 IN pa_project_requests.attribute11%TYPE,
38: p_attribute12 IN pa_project_requests.attribute12%TYPE,
39: p_attribute13 IN pa_project_requests.attribute13%TYPE,
40: p_attribute14 IN pa_project_requests.attribute14%TYPE,

Line 37: p_attribute11 IN pa_project_requests.attribute11%TYPE,

33: p_attribute7 IN pa_project_requests.attribute7%TYPE,
34: p_attribute8 IN pa_project_requests.attribute8%TYPE,
35: p_attribute9 IN pa_project_requests.attribute9%TYPE,
36: p_attribute10 IN pa_project_requests.attribute10%TYPE,
37: p_attribute11 IN pa_project_requests.attribute11%TYPE,
38: p_attribute12 IN pa_project_requests.attribute12%TYPE,
39: p_attribute13 IN pa_project_requests.attribute13%TYPE,
40: p_attribute14 IN pa_project_requests.attribute14%TYPE,
41: p_attribute15 IN pa_project_requests.attribute15%TYPE,

Line 38: p_attribute12 IN pa_project_requests.attribute12%TYPE,

34: p_attribute8 IN pa_project_requests.attribute8%TYPE,
35: p_attribute9 IN pa_project_requests.attribute9%TYPE,
36: p_attribute10 IN pa_project_requests.attribute10%TYPE,
37: p_attribute11 IN pa_project_requests.attribute11%TYPE,
38: p_attribute12 IN pa_project_requests.attribute12%TYPE,
39: p_attribute13 IN pa_project_requests.attribute13%TYPE,
40: p_attribute14 IN pa_project_requests.attribute14%TYPE,
41: p_attribute15 IN pa_project_requests.attribute15%TYPE,
42: x_request_id OUT NOCOPY pa_project_requests.request_id%TYPE, --File.Sql.39 bug 4440895

Line 39: p_attribute13 IN pa_project_requests.attribute13%TYPE,

35: p_attribute9 IN pa_project_requests.attribute9%TYPE,
36: p_attribute10 IN pa_project_requests.attribute10%TYPE,
37: p_attribute11 IN pa_project_requests.attribute11%TYPE,
38: p_attribute12 IN pa_project_requests.attribute12%TYPE,
39: p_attribute13 IN pa_project_requests.attribute13%TYPE,
40: p_attribute14 IN pa_project_requests.attribute14%TYPE,
41: p_attribute15 IN pa_project_requests.attribute15%TYPE,
42: x_request_id OUT NOCOPY pa_project_requests.request_id%TYPE, --File.Sql.39 bug 4440895
43: x_request_number OUT NOCOPY pa_project_requests.request_number%TYPE, --File.Sql.39 bug 4440895

Line 40: p_attribute14 IN pa_project_requests.attribute14%TYPE,

36: p_attribute10 IN pa_project_requests.attribute10%TYPE,
37: p_attribute11 IN pa_project_requests.attribute11%TYPE,
38: p_attribute12 IN pa_project_requests.attribute12%TYPE,
39: p_attribute13 IN pa_project_requests.attribute13%TYPE,
40: p_attribute14 IN pa_project_requests.attribute14%TYPE,
41: p_attribute15 IN pa_project_requests.attribute15%TYPE,
42: x_request_id OUT NOCOPY pa_project_requests.request_id%TYPE, --File.Sql.39 bug 4440895
43: x_request_number OUT NOCOPY pa_project_requests.request_number%TYPE, --File.Sql.39 bug 4440895
44: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

Line 41: p_attribute15 IN pa_project_requests.attribute15%TYPE,

37: p_attribute11 IN pa_project_requests.attribute11%TYPE,
38: p_attribute12 IN pa_project_requests.attribute12%TYPE,
39: p_attribute13 IN pa_project_requests.attribute13%TYPE,
40: p_attribute14 IN pa_project_requests.attribute14%TYPE,
41: p_attribute15 IN pa_project_requests.attribute15%TYPE,
42: x_request_id OUT NOCOPY pa_project_requests.request_id%TYPE, --File.Sql.39 bug 4440895
43: x_request_number OUT NOCOPY pa_project_requests.request_number%TYPE, --File.Sql.39 bug 4440895
44: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
45: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895

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

38: p_attribute12 IN pa_project_requests.attribute12%TYPE,
39: p_attribute13 IN pa_project_requests.attribute13%TYPE,
40: p_attribute14 IN pa_project_requests.attribute14%TYPE,
41: p_attribute15 IN pa_project_requests.attribute15%TYPE,
42: x_request_id OUT NOCOPY pa_project_requests.request_id%TYPE, --File.Sql.39 bug 4440895
43: x_request_number OUT NOCOPY pa_project_requests.request_number%TYPE, --File.Sql.39 bug 4440895
44: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
45: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
46: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895

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

39: p_attribute13 IN pa_project_requests.attribute13%TYPE,
40: p_attribute14 IN pa_project_requests.attribute14%TYPE,
41: p_attribute15 IN pa_project_requests.attribute15%TYPE,
42: x_request_id OUT NOCOPY pa_project_requests.request_id%TYPE, --File.Sql.39 bug 4440895
43: x_request_number OUT NOCOPY pa_project_requests.request_number%TYPE, --File.Sql.39 bug 4440895
44: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
45: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
46: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
47: IS

Line 49: l_request_id pa_project_requests.request_id%TYPE;

45: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
46: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
47: IS
48:
49: l_request_id pa_project_requests.request_id%TYPE;
50: l_request_number pa_project_requests.request_number%TYPE;
51: l_msg_index_out NUMBER;
52: -- added for bug: 4537865
53: l_new_msg_data VARCHAR2(2000);

Line 50: l_request_number pa_project_requests.request_number%TYPE;

46: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
47: IS
48:
49: l_request_id pa_project_requests.request_id%TYPE;
50: l_request_number pa_project_requests.request_number%TYPE;
51: l_msg_index_out NUMBER;
52: -- added for bug: 4537865
53: l_new_msg_data VARCHAR2(2000);
54: -- added for bug: 4537865

Line 60: SELECT pa_project_requests_s.nextval

56: BEGIN
57:
58: x_return_status := FND_API.G_RET_STS_SUCCESS;
59:
60: SELECT pa_project_requests_s.nextval
61: INTO l_request_id
62: FROM DUAL;
63:
64: SELECT pa_project_requests_num_s.nextval

Line 64: SELECT pa_project_requests_num_s.nextval

60: SELECT pa_project_requests_s.nextval
61: INTO l_request_id
62: FROM DUAL;
63:
64: SELECT pa_project_requests_num_s.nextval
65: INTO l_request_number
66: FROM DUAL;
67:
68:

Line 69: INSERT INTO pa_project_requests

65: INTO l_request_number
66: FROM DUAL;
67:
68:
69: INSERT INTO pa_project_requests
70: (request_id ,
71: request_name ,
72: request_number ,
73: request_type ,

Line 167: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PROJECT_REQUESTS_PKG',

163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
164: x_msg_count := FND_MSG_PUB.Count_Msg;
165: x_msg_data := substr(SQLERRM,1,240);
166:
167: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PROJECT_REQUESTS_PKG',
168: p_procedure_name => 'insert_row');
169:
170: IF x_msg_count = 1 THEN
171: pa_interface_utils_pub.get_messages

Line 189: -- Purpose : Update a row in pa_project_requests.

185: END insert_row;
186:
187: --
188: -- Procedure : update_row
189: -- Purpose : Update a row in pa_project_requests.
190: --
191: --
192: PROCEDURE update_row
193: ( p_request_id IN pa_project_requests.request_id%TYPE ,

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

189: -- Purpose : Update a row in pa_project_requests.
190: --
191: --
192: PROCEDURE update_row
193: ( p_request_id IN pa_project_requests.request_id%TYPE ,
194: p_request_status_code IN pa_project_requests.status_code%TYPE,
195: p_closed_date IN pa_project_requests.closed_date%TYPE DEFAULT NULL,
196: p_record_version_number IN NUMBER DEFAULT NULL,
197: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

Line 194: p_request_status_code IN pa_project_requests.status_code%TYPE,

190: --
191: --
192: PROCEDURE update_row
193: ( p_request_id IN pa_project_requests.request_id%TYPE ,
194: p_request_status_code IN pa_project_requests.status_code%TYPE,
195: p_closed_date IN pa_project_requests.closed_date%TYPE DEFAULT NULL,
196: p_record_version_number IN NUMBER DEFAULT NULL,
197: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
198: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895

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

191: --
192: PROCEDURE update_row
193: ( p_request_id IN pa_project_requests.request_id%TYPE ,
194: p_request_status_code IN pa_project_requests.status_code%TYPE,
195: p_closed_date IN pa_project_requests.closed_date%TYPE DEFAULT NULL,
196: p_record_version_number IN NUMBER DEFAULT NULL,
197: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
198: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
199: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895

Line 213: UPDATE pa_project_requests

209: -- Increment the record version number by 1
210: l_record_version_number := p_record_version_number +1;
211:
212:
213: UPDATE pa_project_requests
214: SET status_code = p_request_status_code,
215: closed_date = p_closed_date,
216: record_version_number = DECODE(p_record_version_number, NULL, record_version_number, l_record_version_number),
217: last_update_date = sysdate,

Line 229: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PROJECT_REQUESTS_PKG',

225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
226: x_msg_count := FND_MSG_PUB.Count_Msg;
227: x_msg_data := substr(SQLERRM,1,240);
228:
229: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PROJECT_REQUESTS_PKG',
230: p_procedure_name => 'update_row');
231:
232: IF x_msg_count = 1 THEN
233: pa_interface_utils_pub.get_messages