[Home] [Help]
PACKAGE BODY: APPS.OKC_PH_LINE_BREAKS_PVT
Source
1 PACKAGE BODY OKC_PH_LINE_BREAKS_PVT AS
2 /* $Header: OKCRPHLB.pls 120.0 2005/05/25 23:00:44 appldev noship $ */
3
4 l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5
6 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
7 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_PH_LINE_BREAKS_PVT';
8 G_CHILD_RECORD_FOUND CONSTANT varchar2(200) := 'OKC_CHILD_RECORD_FOUND';
9 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
10 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
11
12
13 -- Start of comments
14 --
15 -- Procedure Name : create_Price_Hold_Line_Breaks
16 -- Description :
17 -- Business Rules :
18 -- Parameters :
19 -- Version : 1.0
20 -- End of comments
21 procedure create_Price_Hold_Line_Breaks(p_api_version IN NUMBER,
22 p_init_msg_list IN VARCHAR2 ,
23 x_return_status OUT NOCOPY VARCHAR2,
24 x_msg_count OUT NOCOPY NUMBER,
25 x_msg_data OUT NOCOPY VARCHAR2,
26 p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type,
27 x_okc_ph_line_breaks_v_rec OUT NOCOPY okc_ph_line_breaks_v_rec_type) is
28 begin
29
30 okc_phl_pvt.insert_row(p_api_version => p_api_version,
31 p_init_msg_list => p_init_msg_list,
32 x_msg_count => x_msg_count,
33 x_msg_data => x_msg_data,
34 x_return_status => x_return_status,
35 p_okc_ph_line_breaks_v_rec => p_okc_ph_line_breaks_v_rec,
36 x_okc_ph_line_breaks_v_rec => x_okc_ph_line_breaks_v_rec);
37
38 --V
39
40 end create_Price_Hold_Line_Breaks;
41
42
43
44 -- Start of comments
45 --
46 -- Procedure Name : create_Price_Hold_Line_Breaks
47 -- Description :
48 -- Business Rules :
49 -- Parameters :
50 -- Version : 1.0
51 -- End of comments
52 procedure create_Price_Hold_Line_Breaks(p_api_version IN NUMBER,
53 p_init_msg_list IN VARCHAR2 ,
54 x_return_status OUT NOCOPY VARCHAR2,
55 x_msg_count OUT NOCOPY NUMBER,
56 x_msg_data OUT NOCOPY VARCHAR2,
57 p_okc_ph_line_breaks_v_tbl IN okc_ph_line_breaks_v_tbl_type,
58 x_okc_ph_line_breaks_v_tbl OUT NOCOPY okc_ph_line_breaks_v_tbl_type) is
59 begin
60
61 okc_phl_pvt.insert_row(p_api_version => p_api_version,
62 p_init_msg_list => p_init_msg_list,
63 x_msg_count => x_msg_count,
64 x_msg_data => x_msg_data,
65 x_return_status => x_return_status,
66 p_okc_ph_line_breaks_v_tbl => p_okc_ph_line_breaks_v_tbl,
67 x_okc_ph_line_breaks_v_tbl => x_okc_ph_line_breaks_v_tbl);
68
69 --V
70 if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
71 return;
72 end if;
73 end create_Price_Hold_Line_Breaks;
74
75
76
77 -- Start of comments
78 --
79 -- Procedure Name : delete_Price_Hold_Line_Breaks
80 -- Description :
81 -- Business Rules :
82 -- Parameters :
83 -- Version : 1.0
84 -- End of comments
85 procedure delete_Price_Hold_Line_Breaks(p_api_version IN NUMBER,
86 p_init_msg_list IN VARCHAR2 ,
87 x_return_status OUT NOCOPY VARCHAR2,
88 x_msg_count OUT NOCOPY NUMBER,
89 x_msg_data OUT NOCOPY VARCHAR2,
90 p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type) is
91
92
93
94 begin
95 --V
96 okc_phl_pvt.delete_row(p_api_version => p_api_version,
97 p_init_msg_list => p_init_msg_list,
98 x_msg_count => x_msg_count,
99 x_msg_data => x_msg_data,
100 x_return_status => x_return_status,
101 p_okc_ph_line_breaks_v_rec => p_okc_ph_line_breaks_v_rec);
102
103
104 if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
105 return;
106 end if;
107
108 end delete_Price_Hold_Line_Breaks;
109
110
111
112 end OKC_PH_LINE_BREAKS_PVT;