[Home] [Help]
PACKAGE: APPS.OKL_CF_OBJECT_PERIODS_PUB
Source
1 PACKAGE OKL_CF_OBJECT_PERIODS_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPCFPS.pls 115.0 2003/10/16 01:53:35 sechawla noship $ */
3
4
5
6 SUBTYPE cfpv_rec_type IS okl_cfp_pvt.cfpv_rec_type;
7 SUBTYPE cfpv_tbl_type IS okl_cfp_pvt.cfpv_tbl_type;
8 ------------------------------------------------------------------------------
9 -- Global Variables
10 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CF_OBJECT_PERIODS_PUB';
11 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
12 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
13 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
14 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
15 ------------------------------------------------------------------------------
16 --Global Exception
17 ------------------------------------------------------------------------------
18 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
19 ------------------------------------------------------------------------------
20
21
22 PROCEDURE insert_cf_object_period(
23 p_api_version IN NUMBER,
24 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
25 x_return_status OUT NOCOPY VARCHAR2,
26 x_msg_count OUT NOCOPY NUMBER,
27 x_msg_data OUT NOCOPY VARCHAR2,
28 p_cfpv_rec IN cfpv_rec_type,
29 x_cfpv_rec OUT NOCOPY cfpv_rec_type);
30
31
32 PROCEDURE insert_cf_object_period(
33 p_api_version IN NUMBER,
34 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
35 x_return_status OUT NOCOPY VARCHAR2,
36 x_msg_count OUT NOCOPY NUMBER,
37 x_msg_data OUT NOCOPY VARCHAR2,
38 p_cfpv_tbl IN cfpv_tbl_type,
39 x_cfpv_tbl OUT NOCOPY cfpv_tbl_type);
40
41 PROCEDURE lock_cf_object_period(
42 p_api_version IN NUMBER,
43 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
44 x_return_status OUT NOCOPY VARCHAR2,
45 x_msg_count OUT NOCOPY NUMBER,
46 x_msg_data OUT NOCOPY VARCHAR2,
47 p_cfpv_rec IN cfpv_rec_type);
48
49
50 PROCEDURE lock_cf_object_period(
51 p_api_version IN NUMBER,
52 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
53 x_return_status OUT NOCOPY VARCHAR2,
54 x_msg_count OUT NOCOPY NUMBER,
55 x_msg_data OUT NOCOPY VARCHAR2,
56 p_cfpv_tbl IN cfpv_tbl_type);
57
58 PROCEDURE update_cf_object_period(
59 p_api_version IN NUMBER,
60 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
61 x_return_status OUT NOCOPY VARCHAR2,
62 x_msg_count OUT NOCOPY NUMBER,
63 x_msg_data OUT NOCOPY VARCHAR2,
64 p_cfpv_rec IN cfpv_rec_type,
65 x_cfpv_rec OUT NOCOPY cfpv_rec_type);
66
67
68 PROCEDURE update_cf_object_period(
69 p_api_version IN NUMBER,
70 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
71 x_return_status OUT NOCOPY VARCHAR2,
72 x_msg_count OUT NOCOPY NUMBER,
73 x_msg_data OUT NOCOPY VARCHAR2,
74 p_cfpv_tbl IN cfpv_tbl_type,
75 x_cfpv_tbl OUT NOCOPY cfpv_tbl_type);
76
77 PROCEDURE delete_cf_object_period(
78 p_api_version IN NUMBER,
79 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
80 x_return_status OUT NOCOPY VARCHAR2,
81 x_msg_count OUT NOCOPY NUMBER,
82 x_msg_data OUT NOCOPY VARCHAR2,
83 p_cfpv_rec IN cfpv_rec_type);
84
85
86 PROCEDURE delete_cf_object_period(
87 p_api_version IN NUMBER,
88 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
89 x_return_status OUT NOCOPY VARCHAR2,
90 x_msg_count OUT NOCOPY NUMBER,
91 x_msg_data OUT NOCOPY VARCHAR2,
92 p_cfpv_tbl IN cfpv_tbl_type);
93
94 PROCEDURE validate_cf_object_period(
95 p_api_version IN NUMBER,
96 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
97 x_return_status OUT NOCOPY VARCHAR2,
98 x_msg_count OUT NOCOPY NUMBER,
99 x_msg_data OUT NOCOPY VARCHAR2,
100 p_cfpv_rec IN cfpv_rec_type);
101
102
103 PROCEDURE validate_cf_object_period(
104 p_api_version IN NUMBER,
105 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
106 x_return_status OUT NOCOPY VARCHAR2,
107 x_msg_count OUT NOCOPY NUMBER,
108 x_msg_data OUT NOCOPY VARCHAR2,
109 p_cfpv_tbl IN cfpv_tbl_type);
110
111 END okl_cf_object_periods_pub;