1 PACKAGE OKE_TERMS_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKEPTRMS.pls 115.4 2002/08/14 01:42:39 alaw ship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKE_TERMS_PUB';
5 G_APP_NAME CONSTANT VARCHAR2(200) := OKE_API.G_APP_NAME;
6
7 SUBTYPE term_rec_type IS oke_term_pvt.term_rec_type;
8
9
10 /* Creates a row in oke_k_terms. must provide all key values
11 k_header_id,k_line_id,term_code,term_value_pk1,term_value_pk2
12 except when creating for a line, where k_line_id is ommitted.
13 */
14
15 PROCEDURE create_term(
16
17 p_api_version IN NUMBER,
18 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
19 x_return_status OUT NOCOPY VARCHAR2,
20 x_msg_count OUT NOCOPY NUMBER,
21 x_msg_data OUT NOCOPY VARCHAR2,
22
23 p_term_rec IN oke_term_pvt.term_rec_type,
24 x_term_rec OUT NOCOPY oke_term_pvt.term_rec_type);
25
26 PROCEDURE create_term(
27 p_api_version IN NUMBER,
28 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
29 x_return_status OUT NOCOPY VARCHAR2,
30 x_msg_count OUT NOCOPY NUMBER,
31 x_msg_data OUT NOCOPY VARCHAR2,
32
33 p_term_tbl IN oke_term_pvt.term_tbl_type,
34 x_term_tbl OUT NOCOPY oke_term_pvt.term_tbl_type);
35
36
37 /* delete uses all of the 5 key attributes to delete a particular row
38 use NULL for k_line_id if target belongs to a contract line.
39 */
40
41 PROCEDURE delete_term(
42 p_api_version IN NUMBER,
43 p_init_msg_list IN VARCHAR2 DEFAULT OKE_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_term_rec IN oke_term_pvt.term_rec_type);
48
49
50 PROCEDURE delete_term(
51 p_api_version IN NUMBER,
52 p_init_msg_list IN VARCHAR2 DEFAULT OKE_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_term_tbl IN oke_term_pvt.term_tbl_type);
57
58
59 /* to delete a line's term specify cle and trm.
60 to delete a header's term specify chr and trm.
61 the other is left as NULL
62 */
63
64 PROCEDURE delete_term(
65 p_api_version IN NUMBER,
66 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
67 x_return_status OUT NOCOPY VARCHAR2,
68 x_msg_count OUT NOCOPY NUMBER,
69 x_msg_data OUT NOCOPY VARCHAR2,
70 p_chr_id IN NUMBER,
71 p_cle_id IN NUMBER,
72 p_trm_cd IN OKE_K_TERMS.TERM_CODE%TYPE,
73 p_trm_val_pk1 OKE_K_TERMS.TERM_VALUE_PK1%TYPE,
74 p_trm_val_pk2 OKE_K_TERMS.TERM_VALUE_PK2%TYPE
75 );
76
77 /*
78
79 PROCEDURE validate_term(
80 p_api_version IN NUMBER,
81 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
82 x_return_status OUT NOCOPY VARCHAR2,
83 x_msg_count OUT NOCOPY NUMBER,
84 x_msg_data OUT NOCOPY VARCHAR2,
85 p_term_rec IN oke_term_pvt.term_rec_type);
86
87 PROCEDURE validate_term(
88 p_api_version IN NUMBER,
89 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
90 x_return_status OUT NOCOPY VARCHAR2,
91 x_msg_count OUT NOCOPY NUMBER,
92 x_msg_data OUT NOCOPY VARCHAR2,
93 p_term_tbl IN oke_term_pvt.term_tbl_type);
94
95 */
96
97
98 /* Specify level as being either 'H' for Header or 'L' for Lines
99 To copy from a Header, provide p_from_chr_id
100 To copy from a Line, provide p_from_cle_id
101 To copy to another Line in same header, provide p_to_cle_id
102 To copy to another Line in another header, provide both
103 p_to_cle_id and p_to_chr_id
104 To copy to another Header, provide p_to_chr_id
105 Unmentioned fields must be NULL
106
107 Copies ALL terms belonging to that line or header
108 */
109
110 PROCEDURE copy_term(
111 p_api_version IN NUMBER,
112 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
113 x_return_status OUT NOCOPY VARCHAR2,
114 x_msg_count OUT NOCOPY NUMBER,
115 x_msg_data OUT NOCOPY VARCHAR2,
116 p_from_level IN VARCHAR2,
117 p_to_level IN VARCHAR2,
118 p_from_chr_id IN NUMBER,
119 p_to_chr_id IN NUMBER,
120 p_from_cle_id IN NUMBER,
121 p_to_cle_id IN NUMBER
122 );
123
124
125 /* lock uses all of the 5 key attributes to lock a particular row
126 use NULL for k_line_id if target belongs to a contract line.
127 */
128
129
130 PROCEDURE lock_term(
131 p_api_version IN NUMBER,
132 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
133 x_return_status OUT NOCOPY VARCHAR2,
134 x_msg_count OUT NOCOPY NUMBER,
135 x_msg_data OUT NOCOPY VARCHAR2,
136 p_term_rec IN OKE_TERM_PVT.term_rec_type);
137
138 PROCEDURE lock_term(
139 p_api_version IN NUMBER,
140 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
141 x_return_status OUT NOCOPY VARCHAR2,
142 x_msg_count OUT NOCOPY NUMBER,
143 x_msg_data OUT NOCOPY VARCHAR2,
144 p_term_tbl IN oke_term_pvt.term_tbl_type);
145
146 END OKE_TERMS_PUB;
147