[Home] [Help]
PACKAGE: APPS.OKS_BCL_PRINT_PREVIEW_PUB
Source
1 Package OKS_BCL_PRINT_PREVIEW_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKSBCLVS.pls 120.1 2006/09/19 18:53:04 hvaladip noship $ */
3
4 SUBTYPE bcl_pr_rec_type IS OKS_BCL_PRINT_PREVIEW_PVT.bcl_pr_rec_type;
5 SUBTYPE bcl_pr_tbl_type IS OKS_BCL_PRINT_PREVIEW_PVT.bcl_pr_tbl_type;
6
7 -- GLOBAL VARIABLES
8 ---------------------------------------------------------------------------
9 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_BILLCONTLINE_PRV_PUB';
10 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
11 G_BCL_PR_REC bcl_pr_rec_type;
12 ---------------------------------------------------------------------------
13
14 -- GLOBAL_MESSAGE_CONSTANTS
15 ---------------------------------------------------------------------------
16 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
17 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
18 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
19 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
20 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
21 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
22 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
23 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
24 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
25 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
26 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_CONTRACTS_UNEXPECTED_ERROR';
27 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
28 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
29 ---------------------------------------------------------------------------
30
31 -- GLOBAL EXCEPTION
32 ---------------------------------------------------------------------------
33 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
34 ---------------------------------------------------------------------------
35
36
37 PROCEDURE insert_bcl_pr (
38 p_api_version IN NUMBER,
39 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
40 x_return_status OUT NOCOPY VARCHAR2,
41 x_msg_count OUT NOCOPY NUMBER,
42 x_msg_data OUT NOCOPY VARCHAR2,
43 p_bcl_pr_rec IN bcl_pr_rec_type,
44 x_bcl_pr_rec OUT NOCOPY bcl_pr_rec_type);
45
46 PROCEDURE insert_bcl_pr (
47 p_api_version IN NUMBER,
48 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
49 x_return_status OUT NOCOPY VARCHAR2,
50 x_msg_count OUT NOCOPY NUMBER,
51 x_msg_data OUT NOCOPY VARCHAR2,
52 p_bcl_pr_tbl IN bcl_pr_tbl_type,
53 x_bcl_pr_tbl OUT NOCOPY bcl_pr_tbl_type);
54
55 PROCEDURE lock_bcl_pr(
56 p_api_version IN NUMBER,
57 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
58 x_return_status OUT NOCOPY VARCHAR2,
59 x_msg_count OUT NOCOPY NUMBER,
60 x_msg_data OUT NOCOPY VARCHAR2,
61 p_bcl_pr_rec IN bcl_pr_rec_type);
62
63 PROCEDURE lock_bcl_pr(
64 p_api_version IN NUMBER,
65 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
66 x_return_status OUT NOCOPY VARCHAR2,
67 x_msg_count OUT NOCOPY NUMBER,
68 x_msg_data OUT NOCOPY VARCHAR2,
69 p_bcl_pr_tbl IN bcl_pr_tbl_type);
70
71 PROCEDURE update_bcl_pr(
72 p_api_version IN NUMBER,
73 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
74 x_return_status OUT NOCOPY VARCHAR2,
75 x_msg_count OUT NOCOPY NUMBER,
76 x_msg_data OUT NOCOPY VARCHAR2,
77 p_bcl_pr_rec IN bcl_pr_rec_type,
78 x_bcl_pr_rec OUT NOCOPY bcl_pr_rec_type);
79
80 PROCEDURE update_bcl_pr(
81 p_api_version IN NUMBER,
82 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
83 x_return_status OUT NOCOPY VARCHAR2,
84 x_msg_count OUT NOCOPY NUMBER,
85 x_msg_data OUT NOCOPY VARCHAR2,
86 p_bcl_pr_tbl IN bcl_pr_tbl_type,
87 x_bcl_pr_tbl OUT NOCOPY bcl_pr_tbl_type);
88
89 PROCEDURE delete_bcl_pr(
90 p_api_version IN NUMBER,
91 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
92 x_return_status OUT NOCOPY VARCHAR2,
93 x_msg_count OUT NOCOPY NUMBER,
94 x_msg_data OUT NOCOPY VARCHAR2,
95 p_bcl_pr_rec IN bcl_pr_rec_type);
96
97 PROCEDURE delete_bcl_pr(
98 p_api_version IN NUMBER,
99 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
100 x_return_status OUT NOCOPY VARCHAR2,
101 x_msg_count OUT NOCOPY NUMBER,
102 x_msg_data OUT NOCOPY VARCHAR2,
103 p_bcl_pr_tbl IN bcl_pr_tbl_type);
104
105 PROCEDURE validate_bcl_pr(
106 p_api_version IN NUMBER,
107 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
108 x_return_status OUT NOCOPY VARCHAR2,
109 x_msg_count OUT NOCOPY NUMBER,
110 x_msg_data OUT NOCOPY VARCHAR2,
111 p_bcl_pr_rec IN bcl_pr_rec_type);
112
113 PROCEDURE validate_bcl_pr(
114 p_api_version IN NUMBER,
115 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
116 x_return_status OUT NOCOPY VARCHAR2,
117 x_msg_count OUT NOCOPY NUMBER,
118 x_msg_data OUT NOCOPY VARCHAR2,
119 p_bcl_pr_tbl IN bcl_pr_tbl_type);
120
121 END OKS_BCL_PRINT_PREVIEW_PUB;