1 Package Okl_Opt_Rul_Tmp_Pub AUTHID CURRENT_USER AS
2 /* $Header: OKLPRTMS.pls 115.1 2002/02/25 17:08:06 pkm ship $ */
3
4 SUBTYPE rgrv_rec_type IS Okl_Opt_Rul_Tmp_Pvt.rgrv_rec_type;
5 SUBTYPE rgrv_tbl_type IS Okl_Opt_Rul_Tmp_Pvt.rgrv_tbl_type;
6
7 ------------------------------------------------------------------------------
8 -- Global Variables
9 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_Options_Rule_Template_PUB';
10 G_APP_NAME CONSTANT VARCHAR2(3) := Okc_Api.G_APP_NAME;
11 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
12 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
13 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
14 ------------------------------------------------------------------------------
15 --Global Exception
16 ------------------------------------------------------------------------------
17 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
18 ------------------------------------------------------------------------------
19
20
21 PROCEDURE insert_Opt_Rul_Tmp(
22 p_api_version IN NUMBER
23 ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE
24 ,x_return_status OUT NOCOPY VARCHAR2
25 ,x_msg_count OUT NOCOPY NUMBER
26 ,x_msg_data OUT NOCOPY VARCHAR2
27 ,p_ovd_id IN NUMBER
28 ,p_rgrv_tbl IN rgrv_tbl_type
29 ,x_rgrv_tbl OUT NOCOPY rgrv_tbl_type);
30
31 PROCEDURE insert_Opt_Rul_Tmp(
32 p_api_version IN NUMBER
33 ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE
34 ,x_return_status OUT NOCOPY VARCHAR2
35 ,x_msg_count OUT NOCOPY NUMBER
36 ,x_msg_data OUT NOCOPY VARCHAR2
37 ,p_ovd_id IN NUMBER
38 ,p_rgrv_rec IN rgrv_rec_type
39 ,x_rgrv_rec OUT NOCOPY rgrv_rec_type);
40
41 PROCEDURE lock_Opt_Rul_Tmp(
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_rgrv_tbl IN rgrv_tbl_type);
48
49 PROCEDURE lock_Opt_Rul_Tmp(
50 p_api_version IN NUMBER
51 ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE
52 ,x_return_status OUT NOCOPY VARCHAR2
53 ,x_msg_count OUT NOCOPY NUMBER
54 ,x_msg_data OUT NOCOPY VARCHAR2
55 ,p_rgrv_rec IN rgrv_rec_type);
56
57 PROCEDURE update_Opt_Rul_Tmp(
58 p_api_version IN NUMBER
59 ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE
60 ,x_return_status OUT NOCOPY VARCHAR2
61 ,x_msg_count OUT NOCOPY NUMBER
62 ,x_msg_data OUT NOCOPY VARCHAR2
63 ,p_rgrv_tbl IN rgrv_tbl_type
64 ,x_rgrv_tbl OUT NOCOPY rgrv_tbl_type);
65
66 PROCEDURE update_Opt_Rul_Tmp(
67 p_api_version IN NUMBER
68 ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE
69 ,x_return_status OUT NOCOPY VARCHAR2
70 ,x_msg_count OUT NOCOPY NUMBER
71 ,x_msg_data OUT NOCOPY VARCHAR2
72 ,p_rgrv_rec IN rgrv_rec_type
73 ,x_rgrv_rec OUT NOCOPY rgrv_rec_type);
74
75 PROCEDURE delete_Opt_Rul_Tmp(
76 p_api_version IN NUMBER
77 ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE
78 ,x_return_status OUT NOCOPY VARCHAR2
79 ,x_msg_count OUT NOCOPY NUMBER
80 ,x_msg_data OUT NOCOPY VARCHAR2
81 ,p_rgrv_tbl IN rgrv_tbl_type);
82
83 PROCEDURE delete_Opt_Rul_Tmp(
84 p_api_version IN NUMBER
85 ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE
86 ,x_return_status OUT NOCOPY VARCHAR2
87 ,x_msg_count OUT NOCOPY NUMBER
88 ,x_msg_data OUT NOCOPY VARCHAR2
89 ,p_rgrv_rec IN rgrv_rec_type);
90
91 PROCEDURE validate_Opt_Rul_Tmp(
92 p_api_version IN NUMBER
93 ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE
94 ,x_return_status OUT NOCOPY VARCHAR2
95 ,x_msg_count OUT NOCOPY NUMBER
96 ,x_msg_data OUT NOCOPY VARCHAR2
97 ,p_rgrv_tbl IN rgrv_tbl_type);
98
99 PROCEDURE validate_Opt_Rul_Tmp(
100 p_api_version IN NUMBER
101 ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE
102 ,x_return_status OUT NOCOPY VARCHAR2
103 ,x_msg_count OUT NOCOPY NUMBER
104 ,x_msg_data OUT NOCOPY VARCHAR2
105 ,p_rgrv_rec IN rgrv_rec_type);
106
107 END Okl_Opt_Rul_Tmp_Pub;
108