DBA Data[Home] [Help]

APPS.PA_PROJECT_REQUEST_PUB dependencies on PA_PROJECT_REQUESTS

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

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,

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

Line 15: p_request_status_code IN pa_project_requests.status_code%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,

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

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

Line 19: p_closed_date IN pa_project_requests.closed_date%TYPE,

15: p_request_status_code IN pa_project_requests.status_code%TYPE,
16: p_request_status_name IN pa_project_statuses.project_status_name%TYPE,
17: p_description IN pa_project_requests.description%TYPE,
18: p_expected_proj_approval_date IN pa_project_requests.expected_project_approval_date%TYPE,
19: p_closed_date IN pa_project_requests.closed_date%TYPE,
20: p_source_type IN pa_project_requests.source_type%TYPE :='ORACLE_APPLICATION',
21: p_application_id IN pa_project_requests.application_id%TYPE,
22: p_source_id IN NUMBER,
23: p_source_object IN pa_object_relationships.object_type_from%TYPE,

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

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,

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

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

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

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

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

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

Line 31: p_cust_account_id IN pa_project_requests.cust_account_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,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 47: p_attribute13 IN pa_project_requests.attribute13%TYPE,

43: p_attribute9 IN pa_project_requests.attribute9%TYPE,
44: p_attribute10 IN pa_project_requests.attribute10%TYPE,
45: p_attribute11 IN pa_project_requests.attribute11%TYPE,
46: p_attribute12 IN pa_project_requests.attribute12%TYPE,
47: p_attribute13 IN pa_project_requests.attribute13%TYPE,
48: p_attribute14 IN pa_project_requests.attribute14%TYPE,
49: p_attribute15 IN pa_project_requests.attribute15%TYPE,
50: p_create_rel_flag IN VARCHAR2,
51: p_api_version IN NUMBER := 1.0,

Line 48: p_attribute14 IN pa_project_requests.attribute14%TYPE,

44: p_attribute10 IN pa_project_requests.attribute10%TYPE,
45: p_attribute11 IN pa_project_requests.attribute11%TYPE,
46: p_attribute12 IN pa_project_requests.attribute12%TYPE,
47: p_attribute13 IN pa_project_requests.attribute13%TYPE,
48: p_attribute14 IN pa_project_requests.attribute14%TYPE,
49: p_attribute15 IN pa_project_requests.attribute15%TYPE,
50: p_create_rel_flag IN VARCHAR2,
51: p_api_version IN NUMBER := 1.0,
52: p_init_msg_list IN VARCHAR2,

Line 49: p_attribute15 IN pa_project_requests.attribute15%TYPE,

45: p_attribute11 IN pa_project_requests.attribute11%TYPE,
46: p_attribute12 IN pa_project_requests.attribute12%TYPE,
47: p_attribute13 IN pa_project_requests.attribute13%TYPE,
48: p_attribute14 IN pa_project_requests.attribute14%TYPE,
49: p_attribute15 IN pa_project_requests.attribute15%TYPE,
50: p_create_rel_flag IN VARCHAR2,
51: p_api_version IN NUMBER := 1.0,
52: p_init_msg_list IN VARCHAR2,
53: p_commit IN VARCHAR2,

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

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

Line 57: x_request_number OUT NOCOPY pa_project_requests.request_number%TYPE, --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:

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

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,

Line 71: p_request_name IN pa_project_requests.request_name%TYPE,

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,