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_REQUESTS_CREATION_PKG dependencies on PA_REQ_CREATE_TEMP

Line 6: -- Purpose : Create Row in PA_REQ_CREATE_TEMP.

2: /* $Header: PAYRPK1B.pls 120.2 2005/08/22 05:54:02 sunkalya noship $ */
3:
4: --
5: -- Procedure : Insert_row
6: -- Purpose : Create Row in PA_REQ_CREATE_TEMP.
7: --
8: --
9: PROCEDURE insert_row
10: ( p_request_name IN PA_REQ_CREATE_TEMP.request_name%TYPE,

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

6: -- Purpose : Create Row in PA_REQ_CREATE_TEMP.
7: --
8: --
9: PROCEDURE insert_row
10: ( p_request_name IN PA_REQ_CREATE_TEMP.request_name%TYPE,
11: p_request_number IN PA_REQ_CREATE_TEMP.request_number%TYPE,
12: p_request_type IN PA_REQ_CREATE_TEMP.request_type%TYPE,
13: p_request_status_name IN PA_REQ_CREATE_TEMP.request_status_name%TYPE,
14: p_request_customer IN PA_REQ_CREATE_TEMP.request_customer%TYPE,

Line 11: p_request_number IN PA_REQ_CREATE_TEMP.request_number%TYPE,

7: --
8: --
9: PROCEDURE insert_row
10: ( p_request_name IN PA_REQ_CREATE_TEMP.request_name%TYPE,
11: p_request_number IN PA_REQ_CREATE_TEMP.request_number%TYPE,
12: p_request_type IN PA_REQ_CREATE_TEMP.request_type%TYPE,
13: p_request_status_name IN PA_REQ_CREATE_TEMP.request_status_name%TYPE,
14: p_request_customer IN PA_REQ_CREATE_TEMP.request_customer%TYPE,
15: p_country IN PA_REQ_CREATE_TEMP.country%TYPE,

Line 12: p_request_type IN PA_REQ_CREATE_TEMP.request_type%TYPE,

8: --
9: PROCEDURE insert_row
10: ( p_request_name IN PA_REQ_CREATE_TEMP.request_name%TYPE,
11: p_request_number IN PA_REQ_CREATE_TEMP.request_number%TYPE,
12: p_request_type IN PA_REQ_CREATE_TEMP.request_type%TYPE,
13: p_request_status_name IN PA_REQ_CREATE_TEMP.request_status_name%TYPE,
14: p_request_customer IN PA_REQ_CREATE_TEMP.request_customer%TYPE,
15: p_country IN PA_REQ_CREATE_TEMP.country%TYPE,
16: p_state IN PA_REQ_CREATE_TEMP.state%TYPE,

Line 13: p_request_status_name IN PA_REQ_CREATE_TEMP.request_status_name%TYPE,

9: PROCEDURE insert_row
10: ( p_request_name IN PA_REQ_CREATE_TEMP.request_name%TYPE,
11: p_request_number IN PA_REQ_CREATE_TEMP.request_number%TYPE,
12: p_request_type IN PA_REQ_CREATE_TEMP.request_type%TYPE,
13: p_request_status_name IN PA_REQ_CREATE_TEMP.request_status_name%TYPE,
14: p_request_customer IN PA_REQ_CREATE_TEMP.request_customer%TYPE,
15: p_country IN PA_REQ_CREATE_TEMP.country%TYPE,
16: p_state IN PA_REQ_CREATE_TEMP.state%TYPE,
17: p_city IN PA_REQ_CREATE_TEMP.city%TYPE,

Line 14: p_request_customer IN PA_REQ_CREATE_TEMP.request_customer%TYPE,

10: ( p_request_name IN PA_REQ_CREATE_TEMP.request_name%TYPE,
11: p_request_number IN PA_REQ_CREATE_TEMP.request_number%TYPE,
12: p_request_type IN PA_REQ_CREATE_TEMP.request_type%TYPE,
13: p_request_status_name IN PA_REQ_CREATE_TEMP.request_status_name%TYPE,
14: p_request_customer IN PA_REQ_CREATE_TEMP.request_customer%TYPE,
15: p_country IN PA_REQ_CREATE_TEMP.country%TYPE,
16: p_state IN PA_REQ_CREATE_TEMP.state%TYPE,
17: p_city IN PA_REQ_CREATE_TEMP.city%TYPE,
18: p_value IN PA_REQ_CREATE_TEMP.value%TYPE,

Line 15: p_country IN PA_REQ_CREATE_TEMP.country%TYPE,

11: p_request_number IN PA_REQ_CREATE_TEMP.request_number%TYPE,
12: p_request_type IN PA_REQ_CREATE_TEMP.request_type%TYPE,
13: p_request_status_name IN PA_REQ_CREATE_TEMP.request_status_name%TYPE,
14: p_request_customer IN PA_REQ_CREATE_TEMP.request_customer%TYPE,
15: p_country IN PA_REQ_CREATE_TEMP.country%TYPE,
16: p_state IN PA_REQ_CREATE_TEMP.state%TYPE,
17: p_city IN PA_REQ_CREATE_TEMP.city%TYPE,
18: p_value IN PA_REQ_CREATE_TEMP.value%TYPE,
19: p_currency_code IN PA_REQ_CREATE_TEMP.currency_code%TYPE,

Line 16: p_state IN PA_REQ_CREATE_TEMP.state%TYPE,

12: p_request_type IN PA_REQ_CREATE_TEMP.request_type%TYPE,
13: p_request_status_name IN PA_REQ_CREATE_TEMP.request_status_name%TYPE,
14: p_request_customer IN PA_REQ_CREATE_TEMP.request_customer%TYPE,
15: p_country IN PA_REQ_CREATE_TEMP.country%TYPE,
16: p_state IN PA_REQ_CREATE_TEMP.state%TYPE,
17: p_city IN PA_REQ_CREATE_TEMP.city%TYPE,
18: p_value IN PA_REQ_CREATE_TEMP.value%TYPE,
19: p_currency_code IN PA_REQ_CREATE_TEMP.currency_code%TYPE,
20: p_expected_proj_approval_date IN PA_REQ_CREATE_TEMP.expected_project_approval_date%TYPE,

Line 17: p_city IN PA_REQ_CREATE_TEMP.city%TYPE,

13: p_request_status_name IN PA_REQ_CREATE_TEMP.request_status_name%TYPE,
14: p_request_customer IN PA_REQ_CREATE_TEMP.request_customer%TYPE,
15: p_country IN PA_REQ_CREATE_TEMP.country%TYPE,
16: p_state IN PA_REQ_CREATE_TEMP.state%TYPE,
17: p_city IN PA_REQ_CREATE_TEMP.city%TYPE,
18: p_value IN PA_REQ_CREATE_TEMP.value%TYPE,
19: p_currency_code IN PA_REQ_CREATE_TEMP.currency_code%TYPE,
20: p_expected_proj_approval_date IN PA_REQ_CREATE_TEMP.expected_project_approval_date%TYPE,
21: p_source_reference IN PA_REQ_CREATE_TEMP.source_reference%TYPE,

Line 18: p_value IN PA_REQ_CREATE_TEMP.value%TYPE,

14: p_request_customer IN PA_REQ_CREATE_TEMP.request_customer%TYPE,
15: p_country IN PA_REQ_CREATE_TEMP.country%TYPE,
16: p_state IN PA_REQ_CREATE_TEMP.state%TYPE,
17: p_city IN PA_REQ_CREATE_TEMP.city%TYPE,
18: p_value IN PA_REQ_CREATE_TEMP.value%TYPE,
19: p_currency_code IN PA_REQ_CREATE_TEMP.currency_code%TYPE,
20: p_expected_proj_approval_date IN PA_REQ_CREATE_TEMP.expected_project_approval_date%TYPE,
21: p_source_reference IN PA_REQ_CREATE_TEMP.source_reference%TYPE,
22: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

Line 19: p_currency_code IN PA_REQ_CREATE_TEMP.currency_code%TYPE,

15: p_country IN PA_REQ_CREATE_TEMP.country%TYPE,
16: p_state IN PA_REQ_CREATE_TEMP.state%TYPE,
17: p_city IN PA_REQ_CREATE_TEMP.city%TYPE,
18: p_value IN PA_REQ_CREATE_TEMP.value%TYPE,
19: p_currency_code IN PA_REQ_CREATE_TEMP.currency_code%TYPE,
20: p_expected_proj_approval_date IN PA_REQ_CREATE_TEMP.expected_project_approval_date%TYPE,
21: p_source_reference IN PA_REQ_CREATE_TEMP.source_reference%TYPE,
22: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
23: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895

Line 20: p_expected_proj_approval_date IN PA_REQ_CREATE_TEMP.expected_project_approval_date%TYPE,

16: p_state IN PA_REQ_CREATE_TEMP.state%TYPE,
17: p_city IN PA_REQ_CREATE_TEMP.city%TYPE,
18: p_value IN PA_REQ_CREATE_TEMP.value%TYPE,
19: p_currency_code IN PA_REQ_CREATE_TEMP.currency_code%TYPE,
20: p_expected_proj_approval_date IN PA_REQ_CREATE_TEMP.expected_project_approval_date%TYPE,
21: p_source_reference IN PA_REQ_CREATE_TEMP.source_reference%TYPE,
22: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
23: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
24: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895

Line 21: p_source_reference IN PA_REQ_CREATE_TEMP.source_reference%TYPE,

17: p_city IN PA_REQ_CREATE_TEMP.city%TYPE,
18: p_value IN PA_REQ_CREATE_TEMP.value%TYPE,
19: p_currency_code IN PA_REQ_CREATE_TEMP.currency_code%TYPE,
20: p_expected_proj_approval_date IN PA_REQ_CREATE_TEMP.expected_project_approval_date%TYPE,
21: p_source_reference IN PA_REQ_CREATE_TEMP.source_reference%TYPE,
22: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
23: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
24: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
25: IS

Line 36: INSERT INTO PA_REQ_CREATE_TEMP

32: BEGIN
33:
34: x_return_status := FND_API.G_RET_STS_SUCCESS;
35:
36: INSERT INTO PA_REQ_CREATE_TEMP
37: (request_name ,
38: request_number ,
39: request_type ,
40: request_status_name ,