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,
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,
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,
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',
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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
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
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
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
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
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);
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
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
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:
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 ,
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
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 ,
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
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
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
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,
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