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);
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);
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);
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);
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);
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);