[Home] [Help]
PACKAGE: APPS.OKL_TXL_ITM_INSTS_PUB
Source
1 PACKAGE OKL_TXL_ITM_INSTS_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPITIS.pls 115.3 2004/05/08 00:09:19 dedey noship $ */
3
4 subtype iipv_rec_type is okl_txl_itm_insts_pvt.iivv_rec_type;
5 subtype iipv_tbl_type is okl_txl_itm_insts_pvt.iivv_tbl_type;
6
7
8 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
9 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
10 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
11 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
12 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
13 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
14 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
15 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
16
17 -- Global variables for user hooks
18 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TXL_ITM_INSTS_PUB';
19 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
20 g_iipv_rec iipv_rec_type;
21 g_iipv_tbl iipv_tbl_type;
22
23
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_iipv_rec IN iipv_rec_type,
31 x_iipv_rec OUT NOCOPY iipv_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_iipv_tbl IN iipv_tbl_type,
40 x_iipv_tbl OUT NOCOPY iipv_tbl_type);
41
42
43 PROCEDURE update_txl_itm_insts(
44 p_api_version IN NUMBER,
45 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
46 x_return_status OUT NOCOPY VARCHAR2,
47 x_msg_count OUT NOCOPY NUMBER,
48 x_msg_data OUT NOCOPY VARCHAR2,
49 p_iipv_rec IN iipv_rec_type,
50 x_iipv_rec OUT NOCOPY iipv_rec_type);
51
52 PROCEDURE update_txl_itm_insts(
53 p_api_version IN NUMBER,
54 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
55 x_return_status OUT NOCOPY VARCHAR2,
56 x_msg_count OUT NOCOPY NUMBER,
57 x_msg_data OUT NOCOPY VARCHAR2,
58 p_iipv_tbl IN iipv_tbl_type,
59 x_iipv_tbl OUT NOCOPY iipv_tbl_type);
60
61 PROCEDURE delete_txl_itm_insts(
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_iipv_rec IN iipv_rec_type);
68
69 PROCEDURE delete_txl_itm_insts(
70 p_api_version IN NUMBER,
71 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
72 x_return_status OUT NOCOPY VARCHAR2,
73 x_msg_count OUT NOCOPY NUMBER,
74 x_msg_data OUT NOCOPY VARCHAR2,
75 p_iipv_tbl IN iipv_tbl_type);
76
77 PROCEDURE lock_txl_itm_insts(
78 p_api_version IN NUMBER,
79 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
80 x_return_status OUT NOCOPY VARCHAR2,
81 x_msg_count OUT NOCOPY NUMBER,
82 x_msg_data OUT NOCOPY VARCHAR2,
83 p_iipv_rec IN iipv_rec_type);
84
85 procedure lock_txl_itm_insts(
86 p_api_version IN NUMBER,
87 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
88 x_return_status OUT NOCOPY VARCHAR2,
89 x_msg_count OUT NOCOPY NUMBER,
90 x_msg_data OUT NOCOPY VARCHAR2,
91 p_iipv_tbl IN iipv_tbl_type);
92
93 PROCEDURE validate_txl_itm_insts(
94 p_api_version IN NUMBER,
95 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
96 x_return_status OUT NOCOPY VARCHAR2,
97 x_msg_count OUT NOCOPY NUMBER,
98 x_msg_data OUT NOCOPY VARCHAR2,
99 p_iipv_rec IN iipv_rec_type);
100
101 procedure validate_txl_itm_insts(
102 p_api_version IN NUMBER,
103 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
104 x_return_status OUT NOCOPY VARCHAR2,
105 x_msg_count OUT NOCOPY NUMBER,
106 x_msg_data OUT NOCOPY VARCHAR2,
107 p_iipv_tbl IN iipv_tbl_type);
108
109 PROCEDURE reset_item_srl_number(
110 p_api_version IN NUMBER,
111 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
112 x_return_status OUT NOCOPY VARCHAR2,
113 x_msg_count OUT NOCOPY NUMBER,
114 x_msg_data OUT NOCOPY VARCHAR2,
115 p_chr_id IN NUMBER,
116 p_asset_line_id IN NUMBER
117 );
118
119
120 END OKL_TXL_ITM_INSTS_PUB;