[Home] [Help]
PACKAGE: APPS.OKS_BILLSUBLINE_PUB
Source
1 Package OKS_BILLSubLINE_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKSPBSLS.pls 120.0 2005/05/25 17:59:25 appldev noship $ */
3
4 SUBTYPE bslv_rec_type IS OKS_BILLSubLINE_PVT.bslv_rec_type;
5 SUBTYPE bslv_tbl_type IS OKS_BILLSubLINE_PVT.bslv_tbl_type;
6
7 -- GLOBAL VARIABLES
8 ---------------------------------------------------------------------------
9 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_BILLSUBLINE_PUB';
10 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
11 G_bslv_REC bslv_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) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
27 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
28 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
29 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UPPERCASE_REQUIRED';
30 ---------------------------------------------------------------------------
31
32 -- GLOBAL EXCEPTION
33 ---------------------------------------------------------------------------
34 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
35 ---------------------------------------------------------------------------
36
37
38 PROCEDURE insert_bill_SubLine_Pub(
39 p_api_version IN NUMBER,
40 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
41 x_return_status OUT NOCOPY VARCHAR2,
42 x_msg_count OUT NOCOPY NUMBER,
43 x_msg_data OUT NOCOPY VARCHAR2,
44 p_bslv_rec IN bslv_rec_type,
45 x_bslv_rec OUT NOCOPY bslv_rec_type);
46
47 PROCEDURE insert_bill_SubLine_Pub(
48 p_api_version IN NUMBER,
49 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
50 x_return_status OUT NOCOPY VARCHAR2,
51 x_msg_count OUT NOCOPY NUMBER,
52 x_msg_data OUT NOCOPY VARCHAR2,
53 p_bslv_tbl IN bslv_tbl_type,
54 x_bslv_tbl OUT NOCOPY bslv_tbl_type);
55
56 PROCEDURE lock_bill_SubLine_Pub(
57 p_api_version IN NUMBER,
58 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
59 x_return_status OUT NOCOPY VARCHAR2,
60 x_msg_count OUT NOCOPY NUMBER,
61 x_msg_data OUT NOCOPY VARCHAR2,
62 p_bslv_rec IN bslv_rec_type);
63
64 PROCEDURE lock_bill_SubLine_Pub(
65 p_api_version IN NUMBER,
66 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_bslv_tbl IN bslv_tbl_type);
71
72 PROCEDURE update_bill_SubLine_Pub(
73 p_api_version IN NUMBER,
74 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
75 x_return_status OUT NOCOPY VARCHAR2,
76 x_msg_count OUT NOCOPY NUMBER,
77 x_msg_data OUT NOCOPY VARCHAR2,
78 p_bslv_rec IN bslv_rec_type,
79 x_bslv_rec OUT NOCOPY bslv_rec_type);
80
81 PROCEDURE update_bill_SubLine_Pub(
82 p_api_version IN NUMBER,
83 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
84 x_return_status OUT NOCOPY VARCHAR2,
85 x_msg_count OUT NOCOPY NUMBER,
86 x_msg_data OUT NOCOPY VARCHAR2,
87 p_bslv_tbl IN bslv_tbl_type,
88 x_bslv_tbl OUT NOCOPY bslv_tbl_type);
89
90 PROCEDURE delete_bill_SubLine_Pub(
91 p_api_version IN NUMBER,
92 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
93 x_return_status OUT NOCOPY VARCHAR2,
94 x_msg_count OUT NOCOPY NUMBER,
95 x_msg_data OUT NOCOPY VARCHAR2,
96 p_bslv_rec IN bslv_rec_type);
97
98 PROCEDURE delete_bill_SubLine_Pub(
99 p_api_version IN NUMBER,
100 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
101 x_return_status OUT NOCOPY VARCHAR2,
102 x_msg_count OUT NOCOPY NUMBER,
103 x_msg_data OUT NOCOPY VARCHAR2,
104 p_bslv_tbl IN bslv_tbl_type);
105
106 PROCEDURE validate_bill_SubLine_Pub(
107 p_api_version IN NUMBER,
108 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
109 x_return_status OUT NOCOPY VARCHAR2,
110 x_msg_count OUT NOCOPY NUMBER,
111 x_msg_data OUT NOCOPY VARCHAR2,
112 p_bslv_rec IN bslv_rec_type);
113
114 PROCEDURE validate_bill_SubLine_Pub(
115 p_api_version IN NUMBER,
116 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
117 x_return_status OUT NOCOPY VARCHAR2,
118 x_msg_count OUT NOCOPY NUMBER,
119 x_msg_data OUT NOCOPY VARCHAR2,
120 p_bslv_tbl IN bslv_tbl_type);
121
122 END OKS_BILLSubLINE_PUB;