[Home] [Help]
PACKAGE: APPS.OKC_TAG_PVT
Source
1 Package OKC_TAG_PVT AS
2 /* $Header: OKCSTAGS.pls 120.0 2005/05/26 09:41:04 appldev noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE tagv_rec_type IS RECORD (
7 ID NUMBER,
8 XSL_ID NUMBER,
9 CODE OKC_REPORT_TAG_V.CODE%TYPE,
10 MEANING OKC_REPORT_TAG_V.MEANING%TYPE,
11 ENABLED_FLAG OKC_REPORT_TAG_V.ENABLED_FLAG%TYPE,
12 OBJECT_VERSION_NUMBER NUMBER,
13 CREATED_BY NUMBER,
14 CREATION_DATE DATE,
15 LAST_UPDATED_BY NUMBER,
16 LAST_UPDATE_DATE DATE,
17 LAST_UPDATE_LOGIN NUMBER);
18
19 g_miss_tagv_rec tagv_rec_type;
20
21 ---------------------------------------------------------------------------
22 -- GLOBAL MESSAGE CONSTANTS
23 ---------------------------------------------------------------------------
24 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
25 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
26 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
27 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
28 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
29 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
30 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
31 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
32 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
33 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
34 ---------------------------------------------------------------------------
35 -- GLOBAL VARIABLES
36 ---------------------------------------------------------------------------
37 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_TAG_PVT';
38 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
39 ---------------------------------------------------------------------------
40 -- Procedures and Functions
41 ---------------------------------------------------------------------------
42
43 PROCEDURE add_language;
44
45 PROCEDURE insert_row(
46 p_api_version IN NUMBER,
47 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
48 x_return_status OUT NOCOPY VARCHAR2,
49 x_msg_count OUT NOCOPY NUMBER,
50 x_msg_data OUT NOCOPY VARCHAR2,
51 p_tagv_rec IN tagv_rec_type,
52 x_tagv_rec OUT NOCOPY tagv_rec_type);
53
54 PROCEDURE lock_row(
55 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
56 x_return_status OUT NOCOPY VARCHAR2,
57 x_msg_count OUT NOCOPY NUMBER,
58 x_msg_data OUT NOCOPY VARCHAR2,
59 p_tagv_rec IN tagv_rec_type);
60
61 PROCEDURE update_row(
62 p_api_version IN NUMBER,
63 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
64 x_return_status OUT NOCOPY VARCHAR2,
65 x_msg_count OUT NOCOPY NUMBER,
66 x_msg_data OUT NOCOPY VARCHAR2,
67 p_tagv_rec IN tagv_rec_type,
68 x_tagv_rec OUT NOCOPY tagv_rec_type);
69
70 PROCEDURE delete_row(
71 p_api_version IN NUMBER,
72 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
73 x_return_status OUT NOCOPY VARCHAR2,
74 x_msg_count OUT NOCOPY NUMBER,
75 x_msg_data OUT NOCOPY VARCHAR2,
76 p_tagv_rec IN tagv_rec_type);
77
78 END OKC_TAG_PVT;