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