DBA Data[Home] [Help]

APPS.PA_REQUESTS_CREATION_PKG dependencies on PA_REQ_CREATE_TEMP

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

1: PACKAGE PA_REQUESTS_CREATION_PKG AUTHID CURRENT_USER as
2: /* $Header: PAYRPK1S.pls 120.1 2005/08/19 17:24:13 mwasowic noship $ */
3: --
4: -- Procedure : insert_row
5: -- Purpose : Create Row in PA_REQ_CREATE_TEMP.
6: --
7: --
8: PROCEDURE insert_row
9: ( p_request_name IN PA_REQ_CREATE_TEMP.request_name%TYPE,

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

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

Line 10: p_request_number IN PA_REQ_CREATE_TEMP.request_number%TYPE,

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

Line 11: p_request_type IN PA_REQ_CREATE_TEMP.request_type%TYPE,

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

Line 12: p_request_status_name IN PA_REQ_CREATE_TEMP.request_status_name%TYPE,

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

Line 13: p_request_customer IN PA_REQ_CREATE_TEMP.request_customer%TYPE,

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

Line 14: p_country IN PA_REQ_CREATE_TEMP.country%TYPE,

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

Line 15: p_state IN PA_REQ_CREATE_TEMP.state%TYPE,

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

Line 16: p_city IN PA_REQ_CREATE_TEMP.city%TYPE,

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

Line 17: p_value IN PA_REQ_CREATE_TEMP.value%TYPE,

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

Line 18: p_currency_code IN PA_REQ_CREATE_TEMP.currency_code%TYPE,

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

Line 19: p_expected_proj_approval_date IN PA_REQ_CREATE_TEMP.expected_project_approval_date%TYPE,

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

Line 20: p_source_reference IN PA_REQ_CREATE_TEMP.source_reference%TYPE,

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