[Home] [Help]
PACKAGE: APPS.OZF_QUAL_MARKET_OPTION_PKG
Source
1 PACKAGE OZF_QUAL_MARKET_OPTION_PKG AS
2 /* $Header: ozftqmos.pls 120.0 2005/06/23 10:56:06 rssharma noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- OZF_QUAL_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_qualifier_market_option_id IN OUT NOCOPY NUMBER
36 , p_offer_market_option_id NUMBER
37 , p_qp_qualifier_id NUMBER
38 , px_object_version_number IN OUT NOCOPY NUMBER
39 , p_last_update_date DATE
40 , p_last_updated_by NUMBER
41 , p_creation_date DATE
42 , p_created_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_qualifier_market_option_id NUMBER
60 , p_offer_market_option_id NUMBER
61 , p_qp_qualifier_id NUMBER
62 , p_object_version_number NUMBER
63 , p_last_update_date DATE
64 , p_last_updated_by NUMBER
65 , p_last_update_login NUMBER
66 );
67
68 -- ========================================================
69 --
70 -- NAME
71 -- Delete_Row
72 --
73 -- PURPOSE
74 --
75 -- NOTES
76 --
77 -- HISTORY
78 --
79 -- ========================================================
80 PROCEDURE Delete_Row(
81 p_qualifier_market_option_id NUMBER,
82 p_object_version_number NUMBER);
83
84
85
86
87 -- ========================================================
88 --
89 -- NAME
90 -- Lock_Row
91 --
92 -- PURPOSE
93 --
94 -- NOTES
95 --
96 -- HISTORY
97 --
98 -- ========================================================
99 PROCEDURE Lock_Row(
100 p_qualifier_market_option_id NUMBER,
101 p_object_version_number NUMBER);
102
103
104
105
106 END OZF_QUAL_MARKET_OPTION_PKG;