1 PACKAGE okl_ins_products_pub AUTHID CURRENT_USER AS
2 /* $Header: OKLPIPTS.pls 115.4 2002/02/18 12:43:43 pkm ship $ */
3
4
5 subtype iptv_rec_type is okl_ipt_pvt.iptv_rec_type;
6 subtype iptv_tbl_type is okl_ipt_pvt.iptv_tbl_type;
7 ------------------------------------------------------------------------------
8 -- Global Variables
9 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_INS_PRODUCTS_PUB';
10 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
11 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
12 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
13 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
14 ------------------------------------------------------------------------------
15 --Global Exception
16 ------------------------------------------------------------------------------
17 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
18 ------------------------------------------------------------------------------
19
20
21 PROCEDURE insert_ins_products(
22 p_api_version IN NUMBER
23 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
24 ,x_return_status OUT NOCOPY VARCHAR2
25 ,x_msg_count OUT NOCOPY NUMBER
26 ,x_msg_data OUT NOCOPY VARCHAR2
27 ,p_iptv_tbl IN iptv_tbl_type
28 ,x_iptv_tbl OUT NOCOPY iptv_tbl_type);
29
30 PROCEDURE insert_ins_products(
31 p_api_version IN NUMBER
32 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
33 ,x_return_status OUT NOCOPY VARCHAR2
34 ,x_msg_count OUT NOCOPY NUMBER
35 ,x_msg_data OUT NOCOPY VARCHAR2
36 ,p_iptv_rec IN iptv_rec_type
37 ,x_iptv_rec OUT NOCOPY iptv_rec_type);
38
39 PROCEDURE lock_ins_products(
40 p_api_version IN NUMBER
41 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
42 ,x_return_status OUT NOCOPY VARCHAR2
43 ,x_msg_count OUT NOCOPY NUMBER
44 ,x_msg_data OUT NOCOPY VARCHAR2
45 ,p_iptv_tbl IN iptv_tbl_type);
46
47 PROCEDURE lock_ins_products(
48 p_api_version IN NUMBER
49 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
50 ,x_return_status OUT NOCOPY VARCHAR2
51 ,x_msg_count OUT NOCOPY NUMBER
52 ,x_msg_data OUT NOCOPY VARCHAR2
53 ,p_iptv_rec IN iptv_rec_type);
54
55 PROCEDURE update_ins_products(
56 p_api_version IN NUMBER
57 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
58 ,x_return_status OUT NOCOPY VARCHAR2
59 ,x_msg_count OUT NOCOPY NUMBER
60 ,x_msg_data OUT NOCOPY VARCHAR2
61 ,p_iptv_tbl IN iptv_tbl_type
62 ,x_iptv_tbl OUT NOCOPY iptv_tbl_type);
63
64 PROCEDURE update_ins_products(
65 p_api_version IN NUMBER
66 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
67 ,x_return_status OUT NOCOPY VARCHAR2
68 ,x_msg_count OUT NOCOPY NUMBER
69 ,x_msg_data OUT NOCOPY VARCHAR2
70 ,p_iptv_rec IN iptv_rec_type
71 ,x_iptv_rec OUT NOCOPY iptv_rec_type);
72
73 PROCEDURE delete_ins_products(
74 p_api_version IN NUMBER
75 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_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_iptv_tbl IN iptv_tbl_type);
80
81 PROCEDURE delete_ins_products(
82 p_api_version IN NUMBER
83 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
84 ,x_return_status OUT NOCOPY VARCHAR2
85 ,x_msg_count OUT NOCOPY NUMBER
86 ,x_msg_data OUT NOCOPY VARCHAR2
87 ,p_iptv_rec IN iptv_rec_type);
88
89 PROCEDURE validate_ins_products(
90 p_api_version IN NUMBER
91 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
92 ,x_return_status OUT NOCOPY VARCHAR2
93 ,x_msg_count OUT NOCOPY NUMBER
94 ,x_msg_data OUT NOCOPY VARCHAR2
95 ,p_iptv_tbl IN iptv_tbl_type);
96
97 PROCEDURE validate_ins_products(
98 p_api_version IN NUMBER
99 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
100 ,x_return_status OUT NOCOPY VARCHAR2
101 ,x_msg_count OUT NOCOPY NUMBER
102 ,x_msg_data OUT NOCOPY VARCHAR2
103 ,p_iptv_rec IN iptv_rec_type);
104
105 END okl_ins_products_pub;