[Home] [Help]
PACKAGE: APPS.OZF_ACCOUNT_ALLOCATIONS_PKG
Source
1 PACKAGE OZF_ACCOUNT_ALLOCATIONS_PKG AUTHID CURRENT_USER AS
2 /* $Header: ozftaals.pls 115.2 2003/11/18 23:54:27 mkothari noship $ */
3
4 ---g_version CONSTANT CHAR(80) := '$Header: ozftaals.pls 115.2 2003/11/18 23:54:27 mkothari noship $';
5 G_PKG_NAME CONSTANT VARCHAR2(30):='OZF_ACCOUNT_ALLOCATIONS_PKG';
6 G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozftaals.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_account_allocation_id IN OUT NOCOPY NUMBER,
30 p_allocation_for VARCHAR2,
31 p_allocation_for_id NUMBER,
32 p_cust_account_id NUMBER,
33 p_site_use_id NUMBER,
34 p_site_use_code VARCHAR2,
35 p_location_id NUMBER,
36 p_bill_to_site_use_id NUMBER,
37 p_bill_to_location_id NUMBER,
38 p_parent_party_id NUMBER,
39 p_rollup_party_id NUMBER,
40 p_selected_flag VARCHAR2,
41 p_target NUMBER,
42 p_lysp_sales NUMBER,
43 p_parent_account_allocation_id NUMBER,
44 px_object_version_number IN OUT NOCOPY NUMBER,
45 p_creation_date DATE,
46 p_created_by NUMBER,
47 p_last_update_date DATE,
48 p_last_updated_by NUMBER,
49 p_last_update_login NUMBER,
50 p_attribute_category VARCHAR2,
51 p_attribute1 VARCHAR2,
52 p_attribute2 VARCHAR2,
53 p_attribute3 VARCHAR2,
54 p_attribute4 VARCHAR2,
55 p_attribute5 VARCHAR2,
56 p_attribute6 VARCHAR2,
57 p_attribute7 VARCHAR2,
58 p_attribute8 VARCHAR2,
59 p_attribute9 VARCHAR2,
60 p_attribute10 VARCHAR2,
61 p_attribute11 VARCHAR2,
62 p_attribute12 VARCHAR2,
63 p_attribute13 VARCHAR2,
64 p_attribute14 VARCHAR2,
65 p_attribute15 VARCHAR2,
66 px_org_id IN OUT NOCOPY NUMBER);
67
68
69
70 -- ========================================================
71 --
72 -- NAME
73 -- Update_Row
74 --
75 -- PURPOSE
76 --
77 -- NOTES
78 --
79 -- HISTORY
80 --
81 -- ========================================================
82 PROCEDURE Update_Row(
83 p_account_allocation_id NUMBER,
84 p_allocation_for VARCHAR2,
85 p_allocation_for_id NUMBER,
86 p_cust_account_id NUMBER,
87 p_site_use_id NUMBER,
88 p_site_use_code VARCHAR2,
89 p_location_id NUMBER,
90 p_bill_to_site_use_id NUMBER,
91 p_bill_to_location_id NUMBER,
92 p_parent_party_id NUMBER,
93 p_rollup_party_id NUMBER,
94 p_selected_flag VARCHAR2,
95 p_target NUMBER,
96 p_lysp_sales NUMBER,
97 p_parent_account_allocation_id NUMBER,
98 p_object_version_number IN NUMBER,
99 p_last_update_date DATE,
100 p_last_updated_by NUMBER,
101 p_last_update_login NUMBER,
102 p_attribute_category VARCHAR2,
103 p_attribute1 VARCHAR2,
104 p_attribute2 VARCHAR2,
105 p_attribute3 VARCHAR2,
106 p_attribute4 VARCHAR2,
107 p_attribute5 VARCHAR2,
108 p_attribute6 VARCHAR2,
109 p_attribute7 VARCHAR2,
110 p_attribute8 VARCHAR2,
111 p_attribute9 VARCHAR2,
112 p_attribute10 VARCHAR2,
113 p_attribute11 VARCHAR2,
114 p_attribute12 VARCHAR2,
115 p_attribute13 VARCHAR2,
116 p_attribute14 VARCHAR2,
117 p_attribute15 VARCHAR2);
118
119
120
121 -- ========================================================
122 --
123 -- NAME
124 -- Delete_Row
125 --
126 -- PURPOSE
127 --
128 -- NOTES
129 --
130 -- HISTORY
131 --
132 -- ========================================================
133 PROCEDURE Delete_Row(
134 p_account_allocation_id NUMBER,
135 p_object_version_number NUMBER);
136
137
138
139
140 -- ========================================================
141 --
142 -- NAME
143 -- Lock_Row
144 --
145 -- PURPOSE
146 --
147 -- NOTES
148 --
149 -- HISTORY
150 --
151 -- ========================================================
152 PROCEDURE Lock_Row(
153 p_account_allocation_id NUMBER,
154 p_object_version_number NUMBER);
155
156
157 END OZF_ACCOUNT_ALLOCATIONS_PKG;