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
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
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
18
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,
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
34
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,
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
49
50 /*==================================================================
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,
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
65 END PA_PT_CO_IMPL_STATUSES_PKG;