PACKAGE: APPS.OZF_OFFER_ADJ_LINE_PKG

Source

1 PACKAGE OZF_Offer_Adj_Line_PKG AUTHID CURRENT_USER AS
2 /* $Header: ozftoals.pls 120.3 2006/03/29 17:27:30 rssharma noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 --          OZF_Offer_Adj_Line_PKG
7 -- Purpose
8 --
9 -- History
10 --        Wed Mar 29 2006:5/5 PM RSSHARMA Added end date column
11 -- NOTE
12 --
13 -- This Api is generated with Latest version of
14 -- Rosetta, where g_miss indicates NULL and
15 -- NULL indicates missing value. Rosetta Version 1.55
16 -- End of Comments
17 -- ===============================================================
18 
19 
20 
21 
22 --  ========================================================
23 --
24 --  NAME
25 --  Insert_Row
26 --
27 --  PURPOSE
28 --
29 --  NOTES
30 --
31 --  HISTORY
32 --
33 --  ========================================================
34 PROCEDURE Insert_Row(
35           px_offer_adjustment_line_id   IN OUT NOCOPY NUMBER,
36           p_offer_adjustment_id    NUMBER,
37           p_list_line_id    NUMBER,
38           p_arithmetic_operator    VARCHAR2,
39           p_original_discount    NUMBER,
40           p_modified_discount    NUMBER,
41           p_last_update_date    DATE,
42           p_last_updated_by    NUMBER,
43           p_creation_date    DATE,
44           p_created_by    NUMBER,
45           p_last_update_login    NUMBER,
46           px_object_version_number   IN OUT NOCOPY NUMBER,
47           p_list_header_id    NUMBER,
48           p_accrual_flag    VARCHAR2,
49           p_list_line_id_td    NUMBER,
50           p_original_discount_td    NUMBER,
51           p_modified_discount_td    NUMBER,
52           p_quantity    NUMBER ,
53           p_created_from_adjustments VARCHAR2,
54           p_discount_end_date DATE);
55 
56 
57 
58 
59 
60 --  ========================================================
61 --
62 --  NAME
63 --  Update_Row
64 --
65 --  PURPOSE
66 --
67 --  NOTES
68 --
69 --  HISTORY
70 --
71 --  ========================================================
72 PROCEDURE Update_Row(
73           p_offer_adjustment_line_id    NUMBER,
74           p_offer_adjustment_id    NUMBER,
75           p_list_line_id    NUMBER,
76           p_arithmetic_operator    VARCHAR2,
77           p_original_discount    NUMBER,
78           p_modified_discount    NUMBER,
79           p_last_update_date    DATE,
80           p_last_updated_by    NUMBER,
81           p_last_update_login    NUMBER,
82           px_object_version_number   IN OUT NOCOPY NUMBER,
83           p_list_header_id    NUMBER,
84           p_accrual_flag    VARCHAR2,
85           p_list_line_id_td    NUMBER,
86           p_original_discount_td    NUMBER,
87           p_modified_discount_td    NUMBER,
88           p_quantity    NUMBER ,
89           p_created_from_adjustments VARCHAR2,
90           p_discount_end_date DATE);
91 
92 
93 
94 
95 
96 --  ========================================================
97 --
98 --  NAME
99 --  Delete_Row
100 --
101 --  PURPOSE
102 --
103 --  NOTES
104 --
105 --  HISTORY
106 --
107 --  ========================================================
108 PROCEDURE Delete_Row(
109     p_offer_adjustment_line_id  NUMBER,
110     p_object_version_number  NUMBER);
111 
112 
113 
114 
115 --  ========================================================
116 --
117 --  NAME
118 --  Lock_Row
119 --
120 --  PURPOSE
121 --
122 --  NOTES
123 --
124 --  HISTORY
125 --
126 --  ========================================================
127 PROCEDURE Lock_Row(
128     p_offer_adjustment_line_id  NUMBER,
129     p_object_version_number  NUMBER);
130 
131 
132 END OZF_Offer_Adj_Line_PKG;