PACKAGE: APPS.OZF_OFFR_MARKET_OPTION_PKG

Source

1 PACKAGE OZF_OFFR_MARKET_OPTION_PKG AUTHID CURRENT_USER AS
2 /* $Header: ozftomos.pls 120.0 2005/06/23 10:51:06 rssharma noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 --          OZF_OFFR_MARKET_OPTION_PKG
7 -- Purpose
8 --
9 -- History
10 --           Wed May 18 2005:11/57 AM RSSHARMA Added Insert_row and Update_row for Volume Offers
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_market_option_id IN OUT NOCOPY NUMBER
36           , p_offer_id NUMBER
37           , p_qp_list_header_id NUMBER
38           , p_group_number NUMBER
39           , p_retroactive_flag VARCHAR2
40           , p_beneficiary_party_id NUMBER
41           , p_combine_schedule_flag VARCHAR2
42           , p_volume_tracking_level_code VARCHAR2
43           , p_accrue_to_code VARCHAR2
44           , p_precedence NUMBER
45           , px_object_version_number IN OUT NOCOPY NUMBER
46           , p_creation_date    DATE
47           , p_created_by    NUMBER
48           , p_last_update_date    DATE
49           , p_last_updated_by    NUMBER
50           , p_last_update_login    NUMBER
51           );
52 
53 --  ========================================================
54 --
55 --  NAME
56 --  Update_Row
57 --
58 --  PURPOSE
59 --
60 --  NOTES
61 --
62 --  HISTORY
63 --
64 --  ========================================================
65 PROCEDURE Update_Row(
66           p_offer_market_option_id NUMBER
67           , p_offer_id NUMBER
68           , p_qp_list_header_id NUMBER
69           , p_group_number NUMBER
70           , p_retroactive_flag VARCHAR2
71           , p_beneficiary_party_id NUMBER
72           , p_combine_schedule_flag VARCHAR2
73           , p_volume_tracking_level_code VARCHAR2
74           , p_accrue_to_code VARCHAR2
75           , p_precedence NUMBER
76           , p_object_version_number NUMBER
77           , p_creation_date    DATE
78           , p_created_by    NUMBER
79           , p_last_update_date    DATE
80           , p_last_updated_by    NUMBER
81           , p_last_update_login    NUMBER
82           );
83 
84 
85 --  ========================================================
86 --
87 --  NAME
88 --  Delete_Row
89 --
90 --  PURPOSE
91 --
92 --  NOTES
93 --
94 --  HISTORY
95 --
96 --  ========================================================
97 PROCEDURE Delete_Row(
98     p_offer_market_option_id  NUMBER,
99     p_object_version_number  NUMBER);
100 
101 
102 
103 
104 --  ========================================================
105 --
106 --  NAME
107 --  Lock_Row
108 --
109 --  PURPOSE
110 --
111 --  NOTES
112 --
113 --  HISTORY
114 --
115 --  ========================================================
116 PROCEDURE Lock_Row(
117     p_offer_market_option_id  NUMBER,
118     p_object_version_number  NUMBER);
119 
120 
121 
122 
123 END OZF_OFFR_MARKET_OPTION_PKG;