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_PT_CO_IMPL_STATUSES_PKG dependencies on PA_PT_CO_IMPL_STATUSES

Line 1: PACKAGE PA_PT_CO_IMPL_STATUSES_PKG AS

1: PACKAGE PA_PT_CO_IMPL_STATUSES_PKG AS
2: /* $Header: PAFPCOIS.pls 120.1 2005/08/19 16:25:37 mwasowic noship $ */
3:
4: /*==================================================================
5: API for inserting into the table

Line 8: p_pt_co_impl_statuses_id IN pa_pt_co_impl_statuses.pt_co_impl_statuses_id%TYPE,

4: /*==================================================================
5: API for inserting into the table
6: ==================================================================*/
7: PROCEDURE INSERT_ROW (
8: p_pt_co_impl_statuses_id IN pa_pt_co_impl_statuses.pt_co_impl_statuses_id%TYPE,
9: p_fin_plan_type_id IN pa_pt_co_impl_statuses.fin_plan_type_id%TYPE,
10: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE,
11: p_version_type IN pa_pt_co_impl_statuses.version_type%TYPE,
12: p_status_code IN pa_pt_co_impl_statuses.status_code%TYPE,

Line 9: p_fin_plan_type_id IN pa_pt_co_impl_statuses.fin_plan_type_id%TYPE,

5: API for inserting into the table
6: ==================================================================*/
7: PROCEDURE INSERT_ROW (
8: p_pt_co_impl_statuses_id IN pa_pt_co_impl_statuses.pt_co_impl_statuses_id%TYPE,
9: p_fin_plan_type_id IN pa_pt_co_impl_statuses.fin_plan_type_id%TYPE,
10: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE,
11: p_version_type IN pa_pt_co_impl_statuses.version_type%TYPE,
12: p_status_code IN pa_pt_co_impl_statuses.status_code%TYPE,
13: p_impl_default_flag IN pa_pt_co_impl_statuses.impl_default_flag%TYPE,

Line 10: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE,

6: ==================================================================*/
7: PROCEDURE INSERT_ROW (
8: p_pt_co_impl_statuses_id IN pa_pt_co_impl_statuses.pt_co_impl_statuses_id%TYPE,
9: p_fin_plan_type_id IN pa_pt_co_impl_statuses.fin_plan_type_id%TYPE,
10: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE,
11: p_version_type IN pa_pt_co_impl_statuses.version_type%TYPE,
12: p_status_code IN pa_pt_co_impl_statuses.status_code%TYPE,
13: p_impl_default_flag IN pa_pt_co_impl_statuses.impl_default_flag%TYPE,
14: x_row_id OUT NOCOPY ROWID, --File.Sql.39 bug 4440895

Line 11: p_version_type IN pa_pt_co_impl_statuses.version_type%TYPE,

7: PROCEDURE INSERT_ROW (
8: p_pt_co_impl_statuses_id IN pa_pt_co_impl_statuses.pt_co_impl_statuses_id%TYPE,
9: p_fin_plan_type_id IN pa_pt_co_impl_statuses.fin_plan_type_id%TYPE,
10: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE,
11: p_version_type IN pa_pt_co_impl_statuses.version_type%TYPE,
12: p_status_code IN pa_pt_co_impl_statuses.status_code%TYPE,
13: p_impl_default_flag IN pa_pt_co_impl_statuses.impl_default_flag%TYPE,
14: x_row_id OUT NOCOPY ROWID, --File.Sql.39 bug 4440895
15: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 12: p_status_code IN pa_pt_co_impl_statuses.status_code%TYPE,

8: p_pt_co_impl_statuses_id IN pa_pt_co_impl_statuses.pt_co_impl_statuses_id%TYPE,
9: p_fin_plan_type_id IN pa_pt_co_impl_statuses.fin_plan_type_id%TYPE,
10: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE,
11: p_version_type IN pa_pt_co_impl_statuses.version_type%TYPE,
12: p_status_code IN pa_pt_co_impl_statuses.status_code%TYPE,
13: p_impl_default_flag IN pa_pt_co_impl_statuses.impl_default_flag%TYPE,
14: x_row_id OUT NOCOPY ROWID, --File.Sql.39 bug 4440895
15: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
16: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 13: p_impl_default_flag IN pa_pt_co_impl_statuses.impl_default_flag%TYPE,

9: p_fin_plan_type_id IN pa_pt_co_impl_statuses.fin_plan_type_id%TYPE,
10: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE,
11: p_version_type IN pa_pt_co_impl_statuses.version_type%TYPE,
12: p_status_code IN pa_pt_co_impl_statuses.status_code%TYPE,
13: p_impl_default_flag IN pa_pt_co_impl_statuses.impl_default_flag%TYPE,
14: x_row_id OUT NOCOPY ROWID, --File.Sql.39 bug 4440895
15: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
16: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
17: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 23: p_pt_co_impl_statuses_id IN pa_pt_co_impl_statuses.pt_co_impl_statuses_id%TYPE,

19: /*==================================================================
20: API for updating records of the table
21: ==================================================================*/
22: PROCEDURE UPDATE_ROW (
23: p_pt_co_impl_statuses_id IN pa_pt_co_impl_statuses.pt_co_impl_statuses_id%TYPE,
24: p_fin_plan_type_id IN pa_pt_co_impl_statuses.fin_plan_type_id%TYPE,
25: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE,
26: p_version_type IN pa_pt_co_impl_statuses.version_type%TYPE,
27: p_status_code IN pa_pt_co_impl_statuses.status_code%TYPE,

Line 24: p_fin_plan_type_id IN pa_pt_co_impl_statuses.fin_plan_type_id%TYPE,

20: API for updating records of the table
21: ==================================================================*/
22: PROCEDURE UPDATE_ROW (
23: p_pt_co_impl_statuses_id IN pa_pt_co_impl_statuses.pt_co_impl_statuses_id%TYPE,
24: p_fin_plan_type_id IN pa_pt_co_impl_statuses.fin_plan_type_id%TYPE,
25: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE,
26: p_version_type IN pa_pt_co_impl_statuses.version_type%TYPE,
27: p_status_code IN pa_pt_co_impl_statuses.status_code%TYPE,
28: p_impl_default_flag IN pa_pt_co_impl_statuses.impl_default_flag%TYPE,

Line 25: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE,

21: ==================================================================*/
22: PROCEDURE UPDATE_ROW (
23: p_pt_co_impl_statuses_id IN pa_pt_co_impl_statuses.pt_co_impl_statuses_id%TYPE,
24: p_fin_plan_type_id IN pa_pt_co_impl_statuses.fin_plan_type_id%TYPE,
25: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE,
26: p_version_type IN pa_pt_co_impl_statuses.version_type%TYPE,
27: p_status_code IN pa_pt_co_impl_statuses.status_code%TYPE,
28: p_impl_default_flag IN pa_pt_co_impl_statuses.impl_default_flag%TYPE,
29: p_record_version_number IN pa_pt_co_impl_statuses.record_version_number%TYPE,

Line 26: p_version_type IN pa_pt_co_impl_statuses.version_type%TYPE,

22: PROCEDURE UPDATE_ROW (
23: p_pt_co_impl_statuses_id IN pa_pt_co_impl_statuses.pt_co_impl_statuses_id%TYPE,
24: p_fin_plan_type_id IN pa_pt_co_impl_statuses.fin_plan_type_id%TYPE,
25: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE,
26: p_version_type IN pa_pt_co_impl_statuses.version_type%TYPE,
27: p_status_code IN pa_pt_co_impl_statuses.status_code%TYPE,
28: p_impl_default_flag IN pa_pt_co_impl_statuses.impl_default_flag%TYPE,
29: p_record_version_number IN pa_pt_co_impl_statuses.record_version_number%TYPE,
30: p_lock_row IN VARCHAR2,

Line 27: p_status_code IN pa_pt_co_impl_statuses.status_code%TYPE,

23: p_pt_co_impl_statuses_id IN pa_pt_co_impl_statuses.pt_co_impl_statuses_id%TYPE,
24: p_fin_plan_type_id IN pa_pt_co_impl_statuses.fin_plan_type_id%TYPE,
25: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE,
26: p_version_type IN pa_pt_co_impl_statuses.version_type%TYPE,
27: p_status_code IN pa_pt_co_impl_statuses.status_code%TYPE,
28: p_impl_default_flag IN pa_pt_co_impl_statuses.impl_default_flag%TYPE,
29: p_record_version_number IN pa_pt_co_impl_statuses.record_version_number%TYPE,
30: p_lock_row IN VARCHAR2,
31: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 28: p_impl_default_flag IN pa_pt_co_impl_statuses.impl_default_flag%TYPE,

24: p_fin_plan_type_id IN pa_pt_co_impl_statuses.fin_plan_type_id%TYPE,
25: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE,
26: p_version_type IN pa_pt_co_impl_statuses.version_type%TYPE,
27: p_status_code IN pa_pt_co_impl_statuses.status_code%TYPE,
28: p_impl_default_flag IN pa_pt_co_impl_statuses.impl_default_flag%TYPE,
29: p_record_version_number IN pa_pt_co_impl_statuses.record_version_number%TYPE,
30: p_lock_row IN VARCHAR2,
31: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
32: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 29: p_record_version_number IN pa_pt_co_impl_statuses.record_version_number%TYPE,

25: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE,
26: p_version_type IN pa_pt_co_impl_statuses.version_type%TYPE,
27: p_status_code IN pa_pt_co_impl_statuses.status_code%TYPE,
28: p_impl_default_flag IN pa_pt_co_impl_statuses.impl_default_flag%TYPE,
29: p_record_version_number IN pa_pt_co_impl_statuses.record_version_number%TYPE,
30: p_lock_row IN VARCHAR2,
31: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
32: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
33: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 39: p_pt_co_impl_statuses_id IN pa_pt_co_impl_statuses.pt_co_impl_statuses_id%TYPE,

35: /*==================================================================
36: API for deleting records of the table
37: ==================================================================*/
38: PROCEDURE DELETE_ROW (
39: p_pt_co_impl_statuses_id IN pa_pt_co_impl_statuses.pt_co_impl_statuses_id%TYPE,
40: p_fin_plan_type_id IN pa_pt_co_impl_statuses.fin_plan_type_id%TYPE,
41: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE,
42: p_version_type IN pa_pt_co_impl_statuses.version_type%TYPE,
43: p_status_code IN pa_pt_co_impl_statuses.status_code%TYPE,

Line 40: p_fin_plan_type_id IN pa_pt_co_impl_statuses.fin_plan_type_id%TYPE,

36: API for deleting records of the table
37: ==================================================================*/
38: PROCEDURE DELETE_ROW (
39: p_pt_co_impl_statuses_id IN pa_pt_co_impl_statuses.pt_co_impl_statuses_id%TYPE,
40: p_fin_plan_type_id IN pa_pt_co_impl_statuses.fin_plan_type_id%TYPE,
41: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE,
42: p_version_type IN pa_pt_co_impl_statuses.version_type%TYPE,
43: p_status_code IN pa_pt_co_impl_statuses.status_code%TYPE,
44: p_record_version_number IN pa_pt_co_impl_statuses.record_version_number%TYPE,

Line 41: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE,

37: ==================================================================*/
38: PROCEDURE DELETE_ROW (
39: p_pt_co_impl_statuses_id IN pa_pt_co_impl_statuses.pt_co_impl_statuses_id%TYPE,
40: p_fin_plan_type_id IN pa_pt_co_impl_statuses.fin_plan_type_id%TYPE,
41: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE,
42: p_version_type IN pa_pt_co_impl_statuses.version_type%TYPE,
43: p_status_code IN pa_pt_co_impl_statuses.status_code%TYPE,
44: p_record_version_number IN pa_pt_co_impl_statuses.record_version_number%TYPE,
45: p_lock_row IN VARCHAR2,

Line 42: p_version_type IN pa_pt_co_impl_statuses.version_type%TYPE,

38: PROCEDURE DELETE_ROW (
39: p_pt_co_impl_statuses_id IN pa_pt_co_impl_statuses.pt_co_impl_statuses_id%TYPE,
40: p_fin_plan_type_id IN pa_pt_co_impl_statuses.fin_plan_type_id%TYPE,
41: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE,
42: p_version_type IN pa_pt_co_impl_statuses.version_type%TYPE,
43: p_status_code IN pa_pt_co_impl_statuses.status_code%TYPE,
44: p_record_version_number IN pa_pt_co_impl_statuses.record_version_number%TYPE,
45: p_lock_row IN VARCHAR2,
46: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 43: p_status_code IN pa_pt_co_impl_statuses.status_code%TYPE,

39: p_pt_co_impl_statuses_id IN pa_pt_co_impl_statuses.pt_co_impl_statuses_id%TYPE,
40: p_fin_plan_type_id IN pa_pt_co_impl_statuses.fin_plan_type_id%TYPE,
41: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE,
42: p_version_type IN pa_pt_co_impl_statuses.version_type%TYPE,
43: p_status_code IN pa_pt_co_impl_statuses.status_code%TYPE,
44: p_record_version_number IN pa_pt_co_impl_statuses.record_version_number%TYPE,
45: p_lock_row IN VARCHAR2,
46: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
47: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 44: p_record_version_number IN pa_pt_co_impl_statuses.record_version_number%TYPE,

40: p_fin_plan_type_id IN pa_pt_co_impl_statuses.fin_plan_type_id%TYPE,
41: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE,
42: p_version_type IN pa_pt_co_impl_statuses.version_type%TYPE,
43: p_status_code IN pa_pt_co_impl_statuses.status_code%TYPE,
44: p_record_version_number IN pa_pt_co_impl_statuses.record_version_number%TYPE,
45: p_lock_row IN VARCHAR2,
46: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
47: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
48: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 55: p_pt_co_impl_statuses_id IN pa_pt_co_impl_statuses.pt_co_impl_statuses_id%TYPE,

51: API for locking records of the table
52: ==================================================================*/
53: PROCEDURE LOCK_ROW (
54: p_row_id IN ROWID,
55: p_pt_co_impl_statuses_id IN pa_pt_co_impl_statuses.pt_co_impl_statuses_id%TYPE,
56: p_record_version_number IN pa_pt_co_impl_statuses.record_version_number%TYPE,
57: p_fin_plan_type_id IN pa_pt_co_impl_statuses.fin_plan_type_id%TYPE,
58: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE,
59: p_version_type IN pa_pt_co_impl_statuses.version_type%TYPE,

Line 56: p_record_version_number IN pa_pt_co_impl_statuses.record_version_number%TYPE,

52: ==================================================================*/
53: PROCEDURE LOCK_ROW (
54: p_row_id IN ROWID,
55: p_pt_co_impl_statuses_id IN pa_pt_co_impl_statuses.pt_co_impl_statuses_id%TYPE,
56: p_record_version_number IN pa_pt_co_impl_statuses.record_version_number%TYPE,
57: p_fin_plan_type_id IN pa_pt_co_impl_statuses.fin_plan_type_id%TYPE,
58: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE,
59: p_version_type IN pa_pt_co_impl_statuses.version_type%TYPE,
60: p_status_code IN pa_pt_co_impl_statuses.status_code%TYPE,

Line 57: p_fin_plan_type_id IN pa_pt_co_impl_statuses.fin_plan_type_id%TYPE,

53: PROCEDURE LOCK_ROW (
54: p_row_id IN ROWID,
55: p_pt_co_impl_statuses_id IN pa_pt_co_impl_statuses.pt_co_impl_statuses_id%TYPE,
56: p_record_version_number IN pa_pt_co_impl_statuses.record_version_number%TYPE,
57: p_fin_plan_type_id IN pa_pt_co_impl_statuses.fin_plan_type_id%TYPE,
58: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE,
59: p_version_type IN pa_pt_co_impl_statuses.version_type%TYPE,
60: p_status_code IN pa_pt_co_impl_statuses.status_code%TYPE,
61: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 58: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE,

54: p_row_id IN ROWID,
55: p_pt_co_impl_statuses_id IN pa_pt_co_impl_statuses.pt_co_impl_statuses_id%TYPE,
56: p_record_version_number IN pa_pt_co_impl_statuses.record_version_number%TYPE,
57: p_fin_plan_type_id IN pa_pt_co_impl_statuses.fin_plan_type_id%TYPE,
58: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE,
59: p_version_type IN pa_pt_co_impl_statuses.version_type%TYPE,
60: p_status_code IN pa_pt_co_impl_statuses.status_code%TYPE,
61: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
62: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 59: p_version_type IN pa_pt_co_impl_statuses.version_type%TYPE,

55: p_pt_co_impl_statuses_id IN pa_pt_co_impl_statuses.pt_co_impl_statuses_id%TYPE,
56: p_record_version_number IN pa_pt_co_impl_statuses.record_version_number%TYPE,
57: p_fin_plan_type_id IN pa_pt_co_impl_statuses.fin_plan_type_id%TYPE,
58: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE,
59: p_version_type IN pa_pt_co_impl_statuses.version_type%TYPE,
60: p_status_code IN pa_pt_co_impl_statuses.status_code%TYPE,
61: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
62: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
63: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 60: p_status_code IN pa_pt_co_impl_statuses.status_code%TYPE,

56: p_record_version_number IN pa_pt_co_impl_statuses.record_version_number%TYPE,
57: p_fin_plan_type_id IN pa_pt_co_impl_statuses.fin_plan_type_id%TYPE,
58: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE,
59: p_version_type IN pa_pt_co_impl_statuses.version_type%TYPE,
60: p_status_code IN pa_pt_co_impl_statuses.status_code%TYPE,
61: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
62: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
63: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
64:

Line 65: END PA_PT_CO_IMPL_STATUSES_PKG;

61: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
62: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
63: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
64:
65: END PA_PT_CO_IMPL_STATUSES_PKG;