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_S

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