DBA Data[Home] [Help]

PACKAGE: APPS.OKL_SIT_PVT

Source


1 Package OKL_SIT_PVT AS
2 /* $Header: OKLSSITS.pls 120.2 2005/10/30 04:44:15 appldev noship $ */
3   ---------------------------------------------------------------------------
4   -- GLOBAL DATASTRUCTURES
5   ---------------------------------------------------------------------------
6   TYPE sit_rec_type IS RECORD (
7     id                             NUMBER := OKC_API.G_MISS_NUM,
8     object_version_number          NUMBER := OKC_API.G_MISS_NUM,
9     sif_id                         NUMBER := OKC_API.G_MISS_NUM,
10     sty_id                         NUMBER := OKC_API.G_MISS_NUM,
11     sil_id                         NUMBER := OKC_API.G_MISS_NUM,
12     sfe_id                         NUMBER := OKC_API.G_MISS_NUM,
13     created_by                     NUMBER := OKC_API.G_MISS_NUM,
14     creation_date                  OKL_SIF_STREAM_TYPES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15     last_updated_by                NUMBER := OKC_API.G_MISS_NUM,
16     last_update_date               OKL_SIF_STREAM_TYPES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17     last_update_login              NUMBER := OKC_API.G_MISS_NUM,
18 	pricing_name				   OKL_SIF_STREAM_TYPES.PRICING_NAME%type := OKC_API.G_MISS_CHAR);
19   g_miss_sit_rec                          sit_rec_type;
20   TYPE sit_tbl_type IS TABLE OF sit_rec_type
21         INDEX BY BINARY_INTEGER;
22   TYPE sitv_rec_type IS RECORD (
23     id                             NUMBER := OKC_API.G_MISS_NUM,
24     object_version_number          NUMBER := OKC_API.G_MISS_NUM,
25     sif_id                         NUMBER := OKC_API.G_MISS_NUM,
26     sty_id                         NUMBER := OKC_API.G_MISS_NUM,
27     sil_id                         NUMBER := OKC_API.G_MISS_NUM,
28     sfe_id                         NUMBER := OKC_API.G_MISS_NUM,
29     created_by                     NUMBER := OKC_API.G_MISS_NUM,
30     creation_date                  OKL_SIF_STREAM_TYPES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
31     last_updated_by                NUMBER := OKC_API.G_MISS_NUM,
32     last_update_date               OKL_SIF_STREAM_TYPES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
33     last_update_login              NUMBER := OKC_API.G_MISS_NUM,
34 	pricing_name				   OKL_SIF_STREAM_TYPES.PRICING_NAME%type := OKC_API.G_MISS_CHAR);
35   g_miss_sitv_rec                         sitv_rec_type;
36   TYPE sitv_tbl_type IS TABLE OF sitv_rec_type
37         INDEX BY BINARY_INTEGER;
38   ---------------------------------------------------------------------------
39   -- GLOBAL MESSAGE CONSTANTS
40   ---------------------------------------------------------------------------
41   G_FND_APP			CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
42   G_OKC_APP			CONSTANT VARCHAR2(3)   :=  OKC_API.G_APP_NAME;
43   G_FORM_UNABLE_TO_RESERVE_REC	CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
44   G_FORM_RECORD_DELETED		CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
45   G_FORM_RECORD_CHANGED		CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
46   G_RECORD_LOGICALLY_DELETED	CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
47   G_REQUIRED_VALUE		CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
48   G_INVALID_VALUE			CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
49   G_COL_NAME_TOKEN		CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
50   G_PARENT_TABLE_TOKEN		CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
51   G_CHILD_TABLE_TOKEN		CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
52   G_OKL_UNEXPECTED_ERROR            CONSTANT VARCHAR2(200) :='OKL_CONTRACTS_UNEXPECTED_ERROR';
53   G_OKL_SQLERRM_TOKEN               CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
54   G_OKL_SQLCODE_TOKEN               CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
55   ---------------------------------------------------------------------------
56   -- GLOBAL VARIABLES
57   ---------------------------------------------------------------------------
58   G_PKG_NAME			CONSTANT VARCHAR2(200) := 'OKL_SIT_PVT';
59   G_APP_NAME			CONSTANT VARCHAR2(3)   :=  OKL_API.G_APP_NAME;
60 
61   ---------------------------------------------------------------------------
62   -- GLOBAL EXCEPTIONS
63   ---------------------------------------------------------------------------
64   G_EXCEPTION_HALT_VALIDATION EXCEPTION;
65 
66   ---------------------------------------------------------------------------
67   -- Procedures and Functions
68   ---------------------------------------------------------------------------
69 
70   PROCEDURE qc;
71   PROCEDURE change_version;
72   PROCEDURE api_copy;
73   PROCEDURE insert_row(
74     p_api_version                  IN NUMBER,
75     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
76     x_return_status                OUT NOCOPY VARCHAR2,
77     x_msg_count                    OUT NOCOPY NUMBER,
78     x_msg_data                     OUT NOCOPY VARCHAR2,
79     p_sitv_rec                     IN sitv_rec_type,
80     x_sitv_rec                     OUT NOCOPY sitv_rec_type);
81 
82   PROCEDURE insert_row(
83     p_api_version                  IN NUMBER,
84     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
85     x_return_status                OUT NOCOPY VARCHAR2,
86     x_msg_count                    OUT NOCOPY NUMBER,
87     x_msg_data                     OUT NOCOPY VARCHAR2,
88     p_sitv_tbl                     IN sitv_tbl_type,
89     x_sitv_tbl                     OUT NOCOPY sitv_tbl_type);
90 
91   PROCEDURE lock_row(
92     p_api_version                  IN NUMBER,
93     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
94     x_return_status                OUT NOCOPY VARCHAR2,
95     x_msg_count                    OUT NOCOPY NUMBER,
96     x_msg_data                     OUT NOCOPY VARCHAR2,
97     p_sitv_rec                     IN sitv_rec_type);
98 
99   PROCEDURE lock_row(
100     p_api_version                  IN NUMBER,
101     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
102     x_return_status                OUT NOCOPY VARCHAR2,
103     x_msg_count                    OUT NOCOPY NUMBER,
104     x_msg_data                     OUT NOCOPY VARCHAR2,
105     p_sitv_tbl                     IN sitv_tbl_type);
106 
107   PROCEDURE update_row(
108     p_api_version                  IN NUMBER,
109     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
110     x_return_status                OUT NOCOPY VARCHAR2,
111     x_msg_count                    OUT NOCOPY NUMBER,
112     x_msg_data                     OUT NOCOPY VARCHAR2,
113     p_sitv_rec                     IN sitv_rec_type,
114     x_sitv_rec                     OUT NOCOPY sitv_rec_type);
115 
116   PROCEDURE update_row(
117     p_api_version                  IN NUMBER,
118     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
119     x_return_status                OUT NOCOPY VARCHAR2,
120     x_msg_count                    OUT NOCOPY NUMBER,
121     x_msg_data                     OUT NOCOPY VARCHAR2,
122     p_sitv_tbl                     IN sitv_tbl_type,
123     x_sitv_tbl                     OUT NOCOPY sitv_tbl_type);
124 
125   PROCEDURE delete_row(
126     p_api_version                  IN NUMBER,
127     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
128     x_return_status                OUT NOCOPY VARCHAR2,
129     x_msg_count                    OUT NOCOPY NUMBER,
130     x_msg_data                     OUT NOCOPY VARCHAR2,
131     p_sitv_rec                     IN sitv_rec_type);
132 
133   PROCEDURE delete_row(
134     p_api_version                  IN NUMBER,
135     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
136     x_return_status                OUT NOCOPY VARCHAR2,
137     x_msg_count                    OUT NOCOPY NUMBER,
138     x_msg_data                     OUT NOCOPY VARCHAR2,
139     p_sitv_tbl                     IN sitv_tbl_type);
140 
141   PROCEDURE validate_row(
142     p_api_version                  IN NUMBER,
143     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
144     x_return_status                OUT NOCOPY VARCHAR2,
145     x_msg_count                    OUT NOCOPY NUMBER,
146     x_msg_data                     OUT NOCOPY VARCHAR2,
147     p_sitv_rec                     IN sitv_rec_type);
148 
149   PROCEDURE validate_row(
150     p_api_version                  IN NUMBER,
151     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
152     x_return_status                OUT NOCOPY VARCHAR2,
153     x_msg_count                    OUT NOCOPY NUMBER,
154     x_msg_data                     OUT NOCOPY VARCHAR2,
155     p_sitv_tbl                     IN sitv_tbl_type);
156 
157 END OKL_SIT_PVT;