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_PUB dependencies on PA_PROJECT_REQUESTS

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

2: /* $Header: PAYRPUBB.pls 120.2 2005/08/19 17:24:56 mwasowic noship $ */
3:
4:
5: PROCEDURE create_project_request
6: ( p_request_name IN pa_project_requests.request_name%TYPE,
7: p_request_type IN pa_project_requests.request_type%TYPE,
8: p_request_status_code IN pa_project_requests.status_code%TYPE,
9: p_request_status_name IN pa_project_statuses.project_status_name%TYPE,
10: p_description IN pa_project_requests.description%TYPE,

Line 7: p_request_type IN pa_project_requests.request_type%TYPE,

3:
4:
5: PROCEDURE create_project_request
6: ( p_request_name IN pa_project_requests.request_name%TYPE,
7: p_request_type IN pa_project_requests.request_type%TYPE,
8: p_request_status_code IN pa_project_requests.status_code%TYPE,
9: p_request_status_name IN pa_project_statuses.project_status_name%TYPE,
10: p_description IN pa_project_requests.description%TYPE,
11: p_expected_proj_approval_date IN pa_project_requests.expected_project_approval_date%TYPE,

Line 8: p_request_status_code IN pa_project_requests.status_code%TYPE,

4:
5: PROCEDURE create_project_request
6: ( p_request_name IN pa_project_requests.request_name%TYPE,
7: p_request_type IN pa_project_requests.request_type%TYPE,
8: p_request_status_code IN pa_project_requests.status_code%TYPE,
9: p_request_status_name IN pa_project_statuses.project_status_name%TYPE,
10: p_description IN pa_project_requests.description%TYPE,
11: p_expected_proj_approval_date IN pa_project_requests.expected_project_approval_date%TYPE,
12: p_closed_date IN pa_project_requests.closed_date%TYPE,

Line 10: p_description IN pa_project_requests.description%TYPE,

6: ( p_request_name IN pa_project_requests.request_name%TYPE,
7: p_request_type IN pa_project_requests.request_type%TYPE,
8: p_request_status_code IN pa_project_requests.status_code%TYPE,
9: p_request_status_name IN pa_project_statuses.project_status_name%TYPE,
10: p_description IN pa_project_requests.description%TYPE,
11: p_expected_proj_approval_date IN pa_project_requests.expected_project_approval_date%TYPE,
12: p_closed_date IN pa_project_requests.closed_date%TYPE,
13: p_source_type IN pa_project_requests.source_type%TYPE :='ORACLE_APPLICATION',
14: p_application_id IN pa_project_requests.application_id%TYPE,

Line 11: p_expected_proj_approval_date IN pa_project_requests.expected_project_approval_date%TYPE,

7: p_request_type IN pa_project_requests.request_type%TYPE,
8: p_request_status_code IN pa_project_requests.status_code%TYPE,
9: p_request_status_name IN pa_project_statuses.project_status_name%TYPE,
10: p_description IN pa_project_requests.description%TYPE,
11: p_expected_proj_approval_date IN pa_project_requests.expected_project_approval_date%TYPE,
12: p_closed_date IN pa_project_requests.closed_date%TYPE,
13: p_source_type IN pa_project_requests.source_type%TYPE :='ORACLE_APPLICATION',
14: p_application_id IN pa_project_requests.application_id%TYPE,
15: p_source_id IN NUMBER,

Line 12: p_closed_date IN pa_project_requests.closed_date%TYPE,

8: p_request_status_code IN pa_project_requests.status_code%TYPE,
9: p_request_status_name IN pa_project_statuses.project_status_name%TYPE,
10: p_description IN pa_project_requests.description%TYPE,
11: p_expected_proj_approval_date IN pa_project_requests.expected_project_approval_date%TYPE,
12: p_closed_date IN pa_project_requests.closed_date%TYPE,
13: p_source_type IN pa_project_requests.source_type%TYPE :='ORACLE_APPLICATION',
14: p_application_id IN pa_project_requests.application_id%TYPE,
15: p_source_id IN NUMBER,
16: p_source_object IN pa_object_relationships.object_type_from%TYPE,

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

9: p_request_status_name IN pa_project_statuses.project_status_name%TYPE,
10: p_description IN pa_project_requests.description%TYPE,
11: p_expected_proj_approval_date IN pa_project_requests.expected_project_approval_date%TYPE,
12: p_closed_date IN pa_project_requests.closed_date%TYPE,
13: p_source_type IN pa_project_requests.source_type%TYPE :='ORACLE_APPLICATION',
14: p_application_id IN pa_project_requests.application_id%TYPE,
15: p_source_id IN NUMBER,
16: p_source_object IN pa_object_relationships.object_type_from%TYPE,
17: p_source_reference IN pa_project_requests.source_reference%TYPE,

Line 14: p_application_id IN pa_project_requests.application_id%TYPE,

10: p_description IN pa_project_requests.description%TYPE,
11: p_expected_proj_approval_date IN pa_project_requests.expected_project_approval_date%TYPE,
12: p_closed_date IN pa_project_requests.closed_date%TYPE,
13: p_source_type IN pa_project_requests.source_type%TYPE :='ORACLE_APPLICATION',
14: p_application_id IN pa_project_requests.application_id%TYPE,
15: p_source_id IN NUMBER,
16: p_source_object IN pa_object_relationships.object_type_from%TYPE,
17: p_source_reference IN pa_project_requests.source_reference%TYPE,
18: p_value IN pa_project_requests.value%TYPE,

Line 17: p_source_reference IN pa_project_requests.source_reference%TYPE,

13: p_source_type IN pa_project_requests.source_type%TYPE :='ORACLE_APPLICATION',
14: p_application_id IN pa_project_requests.application_id%TYPE,
15: p_source_id IN NUMBER,
16: p_source_object IN pa_object_relationships.object_type_from%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_name IN hz_parties.party_name%TYPE,

Line 18: p_value IN pa_project_requests.value%TYPE,

14: p_application_id IN pa_project_requests.application_id%TYPE,
15: p_source_id IN NUMBER,
16: p_source_object IN pa_object_relationships.object_type_from%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_name IN hz_parties.party_name%TYPE,
22: p_cust_party_site_id IN pa_project_requests.cust_party_site_id%TYPE,

Line 19: p_currency_code IN pa_project_requests.currency_code%TYPE,

15: p_source_id IN NUMBER,
16: p_source_object IN pa_object_relationships.object_type_from%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_name IN hz_parties.party_name%TYPE,
22: p_cust_party_site_id IN pa_project_requests.cust_party_site_id%TYPE,
23: p_cust_party_site_name IN hz_party_sites.party_site_name%TYPE,

Line 20: p_cust_party_id IN pa_project_requests.cust_party_id%TYPE,

16: p_source_object IN pa_object_relationships.object_type_from%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_name IN hz_parties.party_name%TYPE,
22: p_cust_party_site_id IN pa_project_requests.cust_party_site_id%TYPE,
23: p_cust_party_site_name IN hz_party_sites.party_site_name%TYPE,
24: p_cust_account_id IN pa_project_requests.cust_account_id%TYPE,

Line 22: p_cust_party_site_id IN pa_project_requests.cust_party_site_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_name IN hz_parties.party_name%TYPE,
22: p_cust_party_site_id IN pa_project_requests.cust_party_site_id%TYPE,
23: p_cust_party_site_name IN hz_party_sites.party_site_name%TYPE,
24: p_cust_account_id IN pa_project_requests.cust_account_id%TYPE,
25: p_cust_account_name IN hz_cust_accounts.account_name%TYPE,
26: p_source_org_id IN pa_project_requests.source_org_id%TYPE,

Line 24: p_cust_account_id IN pa_project_requests.cust_account_id%TYPE,

20: p_cust_party_id IN pa_project_requests.cust_party_id%TYPE,
21: p_cust_party_name IN hz_parties.party_name%TYPE,
22: p_cust_party_site_id IN pa_project_requests.cust_party_site_id%TYPE,
23: p_cust_party_site_name IN hz_party_sites.party_site_name%TYPE,
24: p_cust_account_id IN pa_project_requests.cust_account_id%TYPE,
25: p_cust_account_name IN hz_cust_accounts.account_name%TYPE,
26: p_source_org_id IN pa_project_requests.source_org_id%TYPE,
27: p_attribute_category IN pa_project_requests.attribute_category%TYPE,
28: p_attribute1 IN pa_project_requests.attribute1%TYPE,

Line 26: p_source_org_id IN pa_project_requests.source_org_id%TYPE,

22: p_cust_party_site_id IN pa_project_requests.cust_party_site_id%TYPE,
23: p_cust_party_site_name IN hz_party_sites.party_site_name%TYPE,
24: p_cust_account_id IN pa_project_requests.cust_account_id%TYPE,
25: p_cust_account_name IN hz_cust_accounts.account_name%TYPE,
26: p_source_org_id IN pa_project_requests.source_org_id%TYPE,
27: p_attribute_category IN pa_project_requests.attribute_category%TYPE,
28: p_attribute1 IN pa_project_requests.attribute1%TYPE,
29: p_attribute2 IN pa_project_requests.attribute2%TYPE,
30: p_attribute3 IN pa_project_requests.attribute3%TYPE,

Line 27: p_attribute_category IN pa_project_requests.attribute_category%TYPE,

23: p_cust_party_site_name IN hz_party_sites.party_site_name%TYPE,
24: p_cust_account_id IN pa_project_requests.cust_account_id%TYPE,
25: p_cust_account_name IN hz_cust_accounts.account_name%TYPE,
26: p_source_org_id IN pa_project_requests.source_org_id%TYPE,
27: p_attribute_category IN pa_project_requests.attribute_category%TYPE,
28: p_attribute1 IN pa_project_requests.attribute1%TYPE,
29: p_attribute2 IN pa_project_requests.attribute2%TYPE,
30: p_attribute3 IN pa_project_requests.attribute3%TYPE,
31: p_attribute4 IN pa_project_requests.attribute4%TYPE,

Line 28: p_attribute1 IN pa_project_requests.attribute1%TYPE,

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

Line 29: p_attribute2 IN pa_project_requests.attribute2%TYPE,

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

Line 30: p_attribute3 IN pa_project_requests.attribute3%TYPE,

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

Line 31: p_attribute4 IN pa_project_requests.attribute4%TYPE,

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

Line 32: p_attribute5 IN pa_project_requests.attribute5%TYPE,

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

Line 33: p_attribute6 IN pa_project_requests.attribute6%TYPE,

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

Line 34: p_attribute7 IN pa_project_requests.attribute7%TYPE,

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

Line 35: p_attribute8 IN pa_project_requests.attribute8%TYPE,

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

Line 36: p_attribute9 IN pa_project_requests.attribute9%TYPE,

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

Line 37: p_attribute10 IN pa_project_requests.attribute10%TYPE,

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

Line 38: p_attribute11 IN pa_project_requests.attribute11%TYPE,

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

Line 39: p_attribute12 IN pa_project_requests.attribute12%TYPE,

35: p_attribute8 IN pa_project_requests.attribute8%TYPE,
36: p_attribute9 IN pa_project_requests.attribute9%TYPE,
37: p_attribute10 IN pa_project_requests.attribute10%TYPE,
38: p_attribute11 IN pa_project_requests.attribute11%TYPE,
39: p_attribute12 IN pa_project_requests.attribute12%TYPE,
40: p_attribute13 IN pa_project_requests.attribute13%TYPE,
41: p_attribute14 IN pa_project_requests.attribute14%TYPE,
42: p_attribute15 IN pa_project_requests.attribute15%TYPE,
43: p_create_rel_flag IN VARCHAR2,

Line 40: p_attribute13 IN pa_project_requests.attribute13%TYPE,

36: p_attribute9 IN pa_project_requests.attribute9%TYPE,
37: p_attribute10 IN pa_project_requests.attribute10%TYPE,
38: p_attribute11 IN pa_project_requests.attribute11%TYPE,
39: p_attribute12 IN pa_project_requests.attribute12%TYPE,
40: p_attribute13 IN pa_project_requests.attribute13%TYPE,
41: p_attribute14 IN pa_project_requests.attribute14%TYPE,
42: p_attribute15 IN pa_project_requests.attribute15%TYPE,
43: p_create_rel_flag IN VARCHAR2,
44: p_api_version IN NUMBER := 1.0,

Line 41: p_attribute14 IN pa_project_requests.attribute14%TYPE,

37: p_attribute10 IN pa_project_requests.attribute10%TYPE,
38: p_attribute11 IN pa_project_requests.attribute11%TYPE,
39: p_attribute12 IN pa_project_requests.attribute12%TYPE,
40: p_attribute13 IN pa_project_requests.attribute13%TYPE,
41: p_attribute14 IN pa_project_requests.attribute14%TYPE,
42: p_attribute15 IN pa_project_requests.attribute15%TYPE,
43: p_create_rel_flag IN VARCHAR2,
44: p_api_version IN NUMBER := 1.0,
45: p_init_msg_list IN VARCHAR2,

Line 42: p_attribute15 IN pa_project_requests.attribute15%TYPE,

38: p_attribute11 IN pa_project_requests.attribute11%TYPE,
39: p_attribute12 IN pa_project_requests.attribute12%TYPE,
40: p_attribute13 IN pa_project_requests.attribute13%TYPE,
41: p_attribute14 IN pa_project_requests.attribute14%TYPE,
42: p_attribute15 IN pa_project_requests.attribute15%TYPE,
43: p_create_rel_flag IN VARCHAR2,
44: p_api_version IN NUMBER := 1.0,
45: p_init_msg_list IN VARCHAR2,
46: p_commit IN VARCHAR2,

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

45: p_init_msg_list IN VARCHAR2,
46: p_commit IN VARCHAR2,
47: p_validate_only IN VARCHAR2,
48: p_max_msg_count IN NUMBER,
49: x_request_id OUT NOCOPY pa_project_requests.request_id%TYPE, --File.Sql.39 bug 4440895
50: x_request_number OUT NOCOPY pa_project_requests.request_number%TYPE, --File.Sql.39 bug 4440895
51: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
52: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
53: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895

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

46: p_commit IN VARCHAR2,
47: p_validate_only IN VARCHAR2,
48: p_max_msg_count IN NUMBER,
49: x_request_id OUT NOCOPY pa_project_requests.request_id%TYPE, --File.Sql.39 bug 4440895
50: x_request_number OUT NOCOPY pa_project_requests.request_number%TYPE, --File.Sql.39 bug 4440895
51: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
52: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
53: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
54:

Line 58: l_request_status_code pa_project_requests.status_code%TYPE;

54:
55: IS
56: --Declare local variables
57: l_check_status_err EXCEPTION;
58: l_request_status_code pa_project_requests.status_code%TYPE;
59: l_msg_index_out NUMBER;
60: l_lead_id as_leads_all.lead_id%TYPE;
61: l_new_obj_rel_id PA_OBJECT_RELATIONSHIPS.OBJECT_RELATIONSHIP_ID%TYPE;
62: l_new_obj_rel_id2 PA_OBJECT_RELATIONSHIPS.OBJECT_RELATIONSHIP_ID%TYPE;

Line 72: PA_PROJECT_REQUEST_PVT.debug('PA_PROJECT_REQUESTS_PUB.create_project_request.begin');

68:
69:
70: BEGIN
71:
72: PA_PROJECT_REQUEST_PVT.debug('PA_PROJECT_REQUESTS_PUB.create_project_request.begin');
73:
74: -- Initialize the Error Stack
75: PA_DEBUG.init_err_stack('PA_PROJECT_REQUEST_PUB.create_project_request');
76:

Line 107: PA_PROJECT_REQUEST_PVT.debug('PA_PROJECT_REQUESTS_PUB.create_project_request: Calling PA_PROJECT_REQUEST_PVT.Req_Name_Duplicate');

103: END IF;
104:
105:
106: --Check duplicate request name.
107: PA_PROJECT_REQUEST_PVT.debug('PA_PROJECT_REQUESTS_PUB.create_project_request: Calling PA_PROJECT_REQUEST_PVT.Req_Name_Duplicate');
108:
109: PA_PROJECT_REQUEST_PVT.Req_Name_Duplicate
110: (p_request_name => p_request_name,
111: x_return_status => x_return_status,

Line 119: PA_PROJECT_REQUEST_PVT.debug('PA_PROJECT_REQUESTS_PUB.create_project_request: Calling PA_PROJECT_REQUEST_PKG.insert_row');

115:
116: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
117:
118:
119: PA_PROJECT_REQUEST_PVT.debug('PA_PROJECT_REQUESTS_PUB.create_project_request: Calling PA_PROJECT_REQUEST_PKG.insert_row');
120:
121: PA_PROJECT_REQUEST_PKG.insert_row
122: ( p_request_name => p_request_name ,
123: p_request_type => p_request_type,

Line 168: PA_PROJECT_REQUEST_PVT.debug('PA_PROJECT_REQUESTS_PUB.create_project_request: Calling PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW to form the relationship.' );

164: p_source_object IS NOT NULL THEN
165:
166: -- Form the relationship: from the source opportunity to the created project request.
167:
168: PA_PROJECT_REQUEST_PVT.debug('PA_PROJECT_REQUESTS_PUB.create_project_request: Calling PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW to form the relationship.' );
169:
170: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
171: p_user_id => FND_GLOBAL.USER_ID
172: ,p_object_type_from => p_source_object

Line 178: ,p_object_type_to => 'PA_PROJECT_REQUESTS'

174: ,p_object_id_from2 => NULL
175: ,p_object_id_from3 => NULL
176: ,p_object_id_from4 => NULL
177: ,p_object_id_from5 => NULL
178: ,p_object_type_to => 'PA_PROJECT_REQUESTS'
179: ,p_object_id_to1 => x_request_id
180: ,p_object_id_to2 => NULL
181: ,p_object_id_to3 => NULL
182: ,p_object_id_to4 => NULL

Line 199: ,p_object_type_from => 'PA_PROJECT_REQUESTS'

195: -- Form the relationship: from the created project request to the source opportunity.
196:
197: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
198: p_user_id => FND_GLOBAL.USER_ID
199: ,p_object_type_from => 'PA_PROJECT_REQUESTS'
200: ,p_object_id_from1 => x_request_id
201: ,p_object_id_from2 => NULL
202: ,p_object_id_from3 => NULL
203: ,p_object_id_from4 => NULL

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

283: --
284: --
285:
286: PROCEDURE cancel_project_request
287: (p_request_id IN pa_project_requests.request_id%TYPE,
288: p_request_name IN pa_project_requests.request_name%TYPE,
289: p_request_sys_status IN pa_project_statuses.project_system_status_code%TYPE,
290: p_record_version_number IN NUMBER DEFAULT NULL,
291: p_api_version IN NUMBER :=1.0,

Line 288: p_request_name IN pa_project_requests.request_name%TYPE,

284: --
285:
286: PROCEDURE cancel_project_request
287: (p_request_id IN pa_project_requests.request_id%TYPE,
288: p_request_name IN pa_project_requests.request_name%TYPE,
289: p_request_sys_status IN pa_project_statuses.project_system_status_code%TYPE,
290: p_record_version_number IN NUMBER DEFAULT NULL,
291: p_api_version IN NUMBER :=1.0,
292: p_init_msg_list IN VARCHAR2,

Line 325: PA_PROJECT_REQUEST_PVT.debug('PA_PROJECT_REQUESTS_PUB.cancel_project_request.begin');

321: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
322: FND_MSG_PUB.initialize;
323: END IF;
324:
325: PA_PROJECT_REQUEST_PVT.debug('PA_PROJECT_REQUESTS_PUB.cancel_project_request.begin');
326:
327:
328: -- Check if the user is allowed to cancel the project request.
329: -- For any project request with a status of 'CANCELED' or 'CLOSED',

Line 340: PA_PROJECT_REQUEST_PVT.debug('PA_PROJECT_REQUESTS_PUB.cancel_project_request: Calling PA_PROJECT_REQUEST_PKG.update_row');

336: END IF;
337:
338: --Log Message
339:
340: PA_PROJECT_REQUEST_PVT.debug('PA_PROJECT_REQUESTS_PUB.cancel_project_request: Calling PA_PROJECT_REQUEST_PKG.update_row');
341:
342:
343: -- Call the table handler
344:

Line 415: -- The goal is to fix CUST_PARTY_ID in pa_project_requests table to point to the

411:
412: -- Update_PC_PARTY_MAERGE (PUBLIC)
413: -- This is the procedure being called during the Party Merge.
414: -- The input/output arguments format matches the document PartyMergeDD.doc.
415: -- The goal is to fix CUST_PARTY_ID in pa_project_requests table to point to the
416: -- same party when two parties are begin merged.
417: --
418: -- Usage example in pl/sql
419: -- This procedure should only be called from the PartyMerge utility.

Line 438: update PA_PROJECT_REQUESTS

434: p_return_status := FND_API.G_RET_STS_SUCCESS;
435:
436: if (p_from_fk_id <> p_to_fk_id) then
437:
438: update PA_PROJECT_REQUESTS
439: set CUST_PARTY_ID = p_to_fk_id,
440: last_update_date = hz_utility_pub.last_update_date,
441: last_updated_by = hz_utility_pub.user_id,
442: last_update_login = hz_utility_pub.last_update_login,