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