[Home] [Help]
PACKAGE: APPS.OKL_INV_TYPE_DELETE_PVT
Source
1 PACKAGE Okl_Inv_Type_Delete_Pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLRITDS.pls 115.1 2002/02/05 12:12:37 pkm ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE ity_del_rec_type IS RECORD (
7 id NUMBER := Okl_Api.G_MISS_NUM,
8 inf_id NUMBER := Okl_Api.G_MISS_NUM,
9 name OKL_INVOICE_TYPES_V.NAME%TYPE := Okl_Api.G_MISS_CHAR,
10 description OKL_INVOICE_TYPES_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
11 GROUP_ASSET_YN OKL_INVOICE_TYPES_V.GROUP_ASSET_YN%TYPE := Okl_Api.G_MISS_CHAR,
12 GROUP_BY_CONTRACT_YN OKL_INVOICE_TYPES_V.GROUP_BY_CONTRACT_YN%TYPE := Okl_Api.G_MISS_CHAR
13 );
14
15 TYPE ity_del_tbl_type IS TABLE OF ity_del_rec_type
16 INDEX BY BINARY_INTEGER;
17
18 ---------------------------------------------------------------------------
19 -- GLOBAL MESSAGE CONSTANTS
20 ---------------------------------------------------------------------------
21 G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
22 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
23 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
24 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
25 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
26 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
27 G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
28 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
29 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
30 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
31
32 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
33 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
34 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
35 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
36 G_NOT_SAME CONSTANT VARCHAR2(200) := 'OKL_CANNOT_BE_SAME';
37 ---------------------------------------------------------------------------
38 -- GLOBAL VARIABLES
39 ---------------------------------------------------------------------------
40 G_PKG_NAME CONSTANT VARCHAR2(200) := 'Okl_inv_type_delete_Pvt';
41 G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
42
43 G_VIEW CONSTANT VARCHAR2(30) := 'OKL_BPD_INV_TYPES_UV';
44 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
45
46
47 ---------------------------------------------------------------------------
48 -- Procedures and Functions
49 ---------------------------------------------------------------------------
50
51 PROCEDURE delete_type(
52 p_api_version IN NUMBER,
53 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
54 x_return_status OUT NOCOPY VARCHAR2,
55 x_msg_count OUT NOCOPY NUMBER,
56 x_msg_data OUT NOCOPY VARCHAR2,
57 p_ity_del_rec IN ity_del_rec_type);
58
59 PROCEDURE delete_type(
60 p_api_version IN NUMBER,
61 p_init_msg_list IN VARCHAR2 DEFAULT Okl_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_ity_del_tbl IN ity_del_tbl_type);
66
67
68 END Okl_Inv_Type_Delete_Pvt;