PACKAGE: APPS.OZF_MO_PRESET_TIERS_PKG

Source

1 PACKAGE OZF_MO_PRESET_TIERS_PKG AS
2 /* $Header: ozftmopts.pls 120.0 2005/07/11 18:16:49 rssharma noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 --          OZF_MO_PRESET_TIERS_PKG
7 -- Purpose
8 --
9 -- History
10 -- NOTE
11 --
12 -- This Api is generated with Latest version of
13 -- Rosetta, where g_miss indicates NULL and
14 -- NULL indicates missing value. Rosetta Version 1.55
15 -- End of Comments
16 -- ===============================================================
17 
18 
19 
20 
21 --  ========================================================
22 --
23 --  NAME
24 --  Insert_Row
25 --
26 --  PURPOSE
27 --
28 --  NOTES
29 --
30 --  HISTORY
31 --
32 --  ========================================================
33 PROCEDURE Insert_Row(
34           px_market_preset_tier_id IN OUT NOCOPY NUMBER
35           , p_offer_market_option_id NUMBER
36           , p_pbh_offer_discount_id NUMBER
37           , p_dis_offer_discount_id NUMBER
38           , px_object_version_number IN OUT NOCOPY NUMBER
39           , p_creation_date    DATE
40           , p_created_by    NUMBER
41           , p_last_update_date    DATE
42           , p_last_updated_by    NUMBER
43           , p_last_update_login    NUMBER
44           );
45 
46 --  ========================================================
47 --
48 --  NAME
49 --  Update_Row
50 --
51 --  PURPOSE
52 --
53 --  NOTES
54 --
55 --  HISTORY
56 --
57 --  ========================================================
58 PROCEDURE Update_Row(
59           p_market_preset_tier_id IN OUT NOCOPY NUMBER
60           , p_offer_market_option_id NUMBER
61           , p_pbh_offer_discount_id NUMBER
62           , p_dis_offer_discount_id NUMBER
63           , p_object_version_number IN OUT NOCOPY NUMBER
64           , p_last_update_date    DATE
65           , p_last_updated_by    NUMBER
66           , p_last_update_login    NUMBER
67           );
68 
69 
70 --  ========================================================
71 --
72 --  NAME
73 --  Delete_Row
74 --
75 --  PURPOSE
76 --
77 --  NOTES
78 --
79 --  HISTORY
80 --
81 --  ========================================================
82 PROCEDURE Delete_Row(
83     p_market_preset_tier_id  NUMBER,
84     p_object_version_number  NUMBER);
85 
86 
87 
88 
89 --  ========================================================
90 --
91 --  NAME
92 --  Lock_Row
93 --
94 --  PURPOSE
95 --
96 --  NOTES
97 --
98 --  HISTORY
99 --
100 --  ========================================================
101 PROCEDURE Lock_Row(
102     p_market_preset_tier_id  NUMBER,
103     p_object_version_number  NUMBER);
104 
105 
106 
107 
108 END OZF_MO_PRESET_TIERS_PKG;