[Home] [Help]
PACKAGE: APPS.OKL_TXL_ITM_INSTS_PVT
Source
1 package OKL_TXL_ITM_INSTS_PVT AUTHID CURRENT_USER as
2 /* $Header: OKLCITIS.pls 115.3 2004/05/08 00:11:22 dedey noship $ */
3
4 subtype iitv_rec_type is okl_iti_pvt.iti_rec_type;
5 subtype iitv_tbl_type is okl_iti_pvt.iti_tbl_type;
6 subtype iivv_rec_type is okl_iti_pvt.itiv_rec_type;
7 subtype iivv_tbl_type is okl_iti_pvt.itiv_tbl_type;
8 ---------------------------------------------------------------------------
9 -- GLOBAL MESSAGE CONSTANTS , VARIABLES
10 ---------------------------------------------------------------------------
11 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TXL_ITM_INSTS_PVT';
12 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
13 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
14 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
15
16 ----------------------------------------------------------------------------------
17 --Global Exception
18 ----------------------------------------------------------------------------------
19 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
20 ----------------------------------------------------------------------------------
21 --Public Procedures and Functions
22 ----------------------------------------------------------------------------------
23 -- PROCEDURE add_language;
24 PROCEDURE Create_txl_itm_insts(
25 p_api_version IN NUMBER,
26 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
27 x_return_status OUT NOCOPY VARCHAR2,
28 x_msg_count OUT NOCOPY NUMBER,
29 x_msg_data OUT NOCOPY VARCHAR2,
30 p_iivv_rec IN iivv_rec_type,
31 x_iivv_rec OUT NOCOPY iivv_rec_type);
32
33 PROCEDURE Create_txl_itm_insts(
34 p_api_version IN NUMBER,
35 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
36 x_return_status OUT NOCOPY VARCHAR2,
37 x_msg_count OUT NOCOPY NUMBER,
38 x_msg_data OUT NOCOPY VARCHAR2,
39 p_iivv_tbl IN iivv_tbl_type,
40 x_iivv_tbl OUT NOCOPY iivv_tbl_type);
41
42 PROCEDURE lock_txl_itm_insts(
43 p_api_version IN NUMBER,
44 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
45 x_return_status OUT NOCOPY VARCHAR2,
46 x_msg_count OUT NOCOPY NUMBER,
47 x_msg_data OUT NOCOPY VARCHAR2,
48 p_iivv_rec IN iivv_rec_type);
49
50 PROCEDURE lock_txl_itm_insts(
51 p_api_version IN NUMBER,
52 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_iivv_tbl IN iivv_tbl_type);
57
58 PROCEDURE update_txl_itm_insts(
59 p_api_version IN NUMBER,
60 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_iivv_rec IN iivv_rec_type,
65 x_iivv_rec OUT NOCOPY iivv_rec_type);
66
67 PROCEDURE update_txl_itm_insts(
68 p_api_version IN NUMBER,
69 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
70 x_return_status OUT NOCOPY VARCHAR2,
71 x_msg_count OUT NOCOPY NUMBER,
72 x_msg_data OUT NOCOPY VARCHAR2,
73 p_iivv_tbl IN iivv_tbl_type,
74 x_iivv_tbl OUT NOCOPY iivv_tbl_type);
75
76 PROCEDURE delete_txl_itm_insts(
77 p_api_version IN NUMBER,
78 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
79 x_return_status OUT NOCOPY VARCHAR2,
80 x_msg_count OUT NOCOPY NUMBER,
81 x_msg_data OUT NOCOPY VARCHAR2,
82 p_iivv_rec IN iivv_rec_type);
83
84 PROCEDURE delete_txl_itm_insts(
85 p_api_version IN NUMBER,
86 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
87 x_return_status OUT NOCOPY VARCHAR2,
88 x_msg_count OUT NOCOPY NUMBER,
89 x_msg_data OUT NOCOPY VARCHAR2,
90 p_iivv_tbl IN iivv_tbl_type);
91
92 PROCEDURE validate_txl_itm_insts(
93 p_api_version IN NUMBER,
94 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
95 x_return_status OUT NOCOPY VARCHAR2,
96 x_msg_count OUT NOCOPY NUMBER,
97 x_msg_data OUT NOCOPY VARCHAR2,
98 p_iivv_rec IN iivv_rec_type);
99
100 PROCEDURE validate_txl_itm_insts(
101 p_api_version IN NUMBER,
102 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
103 x_return_status OUT NOCOPY VARCHAR2,
104 x_msg_count OUT NOCOPY NUMBER,
105 x_msg_data OUT NOCOPY VARCHAR2,
106 p_iivv_tbl IN iivv_tbl_type);
107
108 PROCEDURE reset_item_srl_number(
109 p_api_version IN NUMBER,
110 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
111 x_return_status OUT NOCOPY VARCHAR2,
112 x_msg_count OUT NOCOPY NUMBER,
113 x_msg_data OUT NOCOPY VARCHAR2,
114 p_chr_id IN NUMBER,
115 p_asset_line_id IN NUMBER
116 );
117
118 END OKL_TXL_ITM_INSTS_PVT;