[Home] [Help]
PACKAGE: APPS.OZF_PRODUCT_ALLOCATIONS_PKG
Source
1 PACKAGE OZF_PRODUCT_ALLOCATIONS_PKG AUTHID CURRENT_USER AS
2 /* $Header: ozftpals.pls 115.1 2003/11/18 23:54:37 mkothari noship $ */
3
4 ---g_version CONSTANT CHAR(80) := '$Header: ozftpals.pls 115.1 2003/11/18 23:54:37 mkothari noship $';
5 G_PKG_NAME CONSTANT VARCHAR2(30):='OZF_PRODUCT_ALLOCATIONS_PKG';
6 G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozftpals.pls';
7
8 OZF_DEBUG_HIGH_ON CONSTANT BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
9 OZF_DEBUG_MEDIUM_ON CONSTANT BOOLEAN := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
10 OZF_DEBUG_LOW_ON CONSTANT BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);
11
12
13
14
15
16 -- ========================================================
17 --
18 -- NAME
19 -- Insert_Row
20 --
21 -- PURPOSE
22 --
23 -- NOTES
24 --
25 -- HISTORY
26 --
27 -- ========================================================
28 PROCEDURE Insert_Row(
29 px_product_allocation_id IN OUT NOCOPY NUMBER,
30 p_allocation_for VARCHAR2,
31 p_allocation_for_id NUMBER,
32 p_fund_id NUMBER,
33 p_item_type VARCHAR2,
34 p_item_id NUMBER,
35 p_selected_flag VARCHAR2,
36 p_target NUMBER,
37 p_lysp_sales NUMBER,
38 p_parent_product_allocation_id NUMBER,
39 px_object_version_number IN OUT NOCOPY NUMBER,
40 p_creation_date DATE,
41 p_created_by NUMBER,
42 p_last_update_date DATE,
43 p_last_updated_by NUMBER,
44 p_last_update_login NUMBER,
45 p_attribute_category VARCHAR2,
46 p_attribute1 VARCHAR2,
47 p_attribute2 VARCHAR2,
48 p_attribute3 VARCHAR2,
49 p_attribute4 VARCHAR2,
50 p_attribute5 VARCHAR2,
51 p_attribute6 VARCHAR2,
52 p_attribute7 VARCHAR2,
53 p_attribute8 VARCHAR2,
54 p_attribute9 VARCHAR2,
55 p_attribute10 VARCHAR2,
56 p_attribute11 VARCHAR2,
57 p_attribute12 VARCHAR2,
58 p_attribute13 VARCHAR2,
59 p_attribute14 VARCHAR2,
60 p_attribute15 VARCHAR2,
61 px_org_id IN OUT NOCOPY NUMBER);
62
63
64
65 -- ========================================================
66 --
67 -- NAME
68 -- Update_Row
69 --
70 -- PURPOSE
71 --
72 -- NOTES
73 --
74 -- HISTORY
75 --
76 -- ========================================================
77 PROCEDURE Update_Row(
78 p_product_allocation_id NUMBER,
79 p_allocation_for VARCHAR2,
80 p_allocation_for_id NUMBER,
81 p_fund_id NUMBER,
82 p_item_type VARCHAR2,
83 p_item_id NUMBER,
84 p_selected_flag VARCHAR2,
85 p_target NUMBER,
86 p_lysp_sales NUMBER,
87 p_parent_product_allocation_id NUMBER,
88 p_object_version_number IN NUMBER,
89 p_last_update_date DATE,
90 p_last_updated_by NUMBER,
91 p_last_update_login NUMBER,
92 p_attribute_category VARCHAR2,
93 p_attribute1 VARCHAR2,
94 p_attribute2 VARCHAR2,
95 p_attribute3 VARCHAR2,
96 p_attribute4 VARCHAR2,
97 p_attribute5 VARCHAR2,
98 p_attribute6 VARCHAR2,
99 p_attribute7 VARCHAR2,
100 p_attribute8 VARCHAR2,
101 p_attribute9 VARCHAR2,
102 p_attribute10 VARCHAR2,
103 p_attribute11 VARCHAR2,
104 p_attribute12 VARCHAR2,
105 p_attribute13 VARCHAR2,
106 p_attribute14 VARCHAR2,
107 p_attribute15 VARCHAR2);
108
109
110
111 -- ========================================================
112 --
113 -- NAME
114 -- Delete_Row
115 --
116 -- PURPOSE
117 --
118 -- NOTES
119 --
120 -- HISTORY
121 --
122 -- ========================================================
123 PROCEDURE Delete_Row(
124 p_product_allocation_id NUMBER,
125 p_object_version_number NUMBER);
126
127
128
129
130 -- ========================================================
131 --
132 -- NAME
133 -- Lock_Row
134 --
135 -- PURPOSE
136 --
137 -- NOTES
138 --
139 -- HISTORY
140 --
141 -- ========================================================
142 PROCEDURE Lock_Row(
143 p_product_allocation_id NUMBER,
144 p_object_version_number NUMBER);
145
146
147 END OZF_PRODUCT_ALLOCATIONS_PKG;