1 PACKAGE OKE_K_PRINT_FORMS_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKEPKPFS.pls 115.3 2002/08/14 01:44:51 alaw ship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKE_K_PRINT_FORMS_PUB';
5 G_APP_NAME CONSTANT VARCHAR2(200) := OKE_API.G_APP_NAME;
6
7
8 PROCEDURE create_print_form(
9
10 p_api_version IN NUMBER,
11 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
12 x_return_status OUT NOCOPY VARCHAR2,
13 x_msg_count OUT NOCOPY NUMBER,
14 x_msg_data OUT NOCOPY VARCHAR2,
15
16 p_form_rec IN oke_form_pvt.form_rec_type,
17 x_form_rec OUT NOCOPY oke_form_pvt.form_rec_type);
18
19 PROCEDURE create_print_form(
20 p_api_version IN NUMBER,
21 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
22 x_return_status OUT NOCOPY VARCHAR2,
23 x_msg_count OUT NOCOPY NUMBER,
24 x_msg_data OUT NOCOPY VARCHAR2,
25
26 p_form_tbl IN oke_form_pvt.form_tbl_type,
27 x_form_tbl OUT NOCOPY oke_form_pvt.form_tbl_type);
28
29
30 PROCEDURE update_print_form(
31 p_api_version IN NUMBER,
32 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
33 x_return_status OUT NOCOPY VARCHAR2,
34 x_msg_count OUT NOCOPY NUMBER,
35 x_msg_data OUT NOCOPY VARCHAR2,
36 p_form_rec IN oke_form_pvt.form_rec_type,
37 x_form_rec OUT NOCOPY oke_form_pvt.form_rec_type);
38
39
40 PROCEDURE update_print_form(
41 p_api_version IN NUMBER,
42 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
43 x_return_status OUT NOCOPY VARCHAR2,
44 x_msg_count OUT NOCOPY NUMBER,
45 x_msg_data OUT NOCOPY VARCHAR2,
46 p_form_tbl IN oke_form_pvt.form_tbl_type,
47 x_form_tbl OUT NOCOPY oke_form_pvt.form_tbl_type);
48
49
50 PROCEDURE delete_print_form(
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_form_rec IN oke_form_pvt.form_rec_type);
57
58
59 PROCEDURE delete_print_form(
60 p_api_version IN NUMBER,
61 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
62 x_return_status OUT NOCOPY VARCHAR2,
63 x_msg_count OUT NOCOPY NUMBER,
64 x_msg_data OUT NOCOPY VARCHAR2,
65 p_form_tbl IN oke_form_pvt.form_tbl_type);
66
67
68 /* to delete a line's print form specify cle and pfm.
69 to delete a header's print form specify chr and pfm.
70 the other is left as NULL
71 */
72
73 PROCEDURE delete_print_form(
74 p_api_version IN NUMBER,
75 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
76 x_return_status OUT NOCOPY VARCHAR2,
77 x_msg_count OUT NOCOPY NUMBER,
78 x_msg_data OUT NOCOPY VARCHAR2,
79 p_chr_id IN NUMBER,
80 p_cle_id IN NUMBER,
81 p_pfm_cd IN OKE_K_PRINT_FORMS.PRINT_FORM_CODE%TYPE);
82
83
84 PROCEDURE validate_print_form(
85 p_api_version IN NUMBER,
86 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
87 x_return_status OUT NOCOPY VARCHAR2,
88 x_msg_count OUT NOCOPY NUMBER,
89 x_msg_data OUT NOCOPY VARCHAR2,
90 p_form_rec IN oke_form_pvt.form_rec_type);
91
92 PROCEDURE validate_print_form(
93 p_api_version IN NUMBER,
94 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
95 x_return_status OUT NOCOPY VARCHAR2,
96 x_msg_count OUT NOCOPY NUMBER,
97 x_msg_data OUT NOCOPY VARCHAR2,
98 p_form_tbl IN oke_form_pvt.form_tbl_type);
99
100
101 /* Specify level as being either 'H' for Header or 'L' for Lines
102 To copy from a Header, provide p_from_chr_id
103 To copy from a Line, provide p_from_cle_id
104 To copy to another Line in same header, provide p_to_cle_id
105 To copy to another Line in another header, provide both
106 p_to_cle_id and p_to_chr_id
107 To copy to another Header, provide p_to_chr_id
108 Unmentioned fields must be NULL
109
110 Copies ALL print forms with different PRINT_FORM_CODE.
111 */
112 PROCEDURE copy_print_form(
113 p_api_version IN NUMBER,
114 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
115 x_return_status OUT NOCOPY VARCHAR2,
116 x_msg_count OUT NOCOPY NUMBER,
117 x_msg_data OUT NOCOPY VARCHAR2,
118 p_from_level IN VARCHAR2,
119 p_to_level IN VARCHAR2,
120 p_from_chr_id IN NUMBER,
121 p_to_chr_id IN NUMBER,
122 p_from_cle_id IN NUMBER,
123 p_to_cle_id IN NUMBER
124 );
125
126
127 PROCEDURE lock_print_form(
128 p_api_version IN NUMBER,
129 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
130 x_return_status OUT NOCOPY VARCHAR2,
131 x_msg_count OUT NOCOPY NUMBER,
132 x_msg_data OUT NOCOPY VARCHAR2,
133 p_form_rec IN OKE_FORM_PVT.form_rec_type);
134
135 PROCEDURE lock_print_form(
136 p_api_version IN NUMBER,
137 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
138 x_return_status OUT NOCOPY VARCHAR2,
139 x_msg_count OUT NOCOPY NUMBER,
140 x_msg_data OUT NOCOPY VARCHAR2,
141 p_form_tbl IN oke_form_pvt.form_tbl_type);
142
143 END OKE_K_PRINT_FORMS_PUB;
144