[Home] [Help]
PACKAGE: APPS.OZF_OFFER_ADJ_LINE_PKG
Source
1 PACKAGE OZF_Offer_Adj_Line_PKG 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;