[Home] [Help]
PACKAGE: APPS.IEX_STRATEGY_WORK_ITEMS_PVT
Source
1 PACKAGE IEX_strategy_work_items_PVT AUTHID CURRENT_USER as
2 /* $Header: iexvswis.pls 120.4 2010/11/10 09:57:39 pnaveenk ship $ */
3
4 -- Default number of records fetch per call
5 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
6 -- *******************************************************
7 -- Start of Comments
8 -- -------------------------------------------------------
9 -- Record name:strategy_work_item_Rec_Type
10 -- -------------------------------------------------------
11 -- Parameters:
12 -- WORK_ITEM_ID
13 -- STRATEGY_ID
14 -- RESOURCE_ID
15 -- STATUS_CODE
16 -- LAST_UPDATED_BY
17 -- LAST_UPDATE_LOGIN
18 -- CREATION_DATE
19 -- CREATED_BY
20 -- PROGRAM_ID
21 -- OBJECT_VERSION_NUMBER
22 -- REQUEST_ID
23 -- LAST_UPDATE_DATE
24 -- WORK_ITEM_TEMPLATE_ID
25 -- PROGRAM_APPLICATION_ID
26 -- PROGRAM_UPDATE_DATE
27 -- EXECUTE_START
28 -- EXECUTE_END
29 -- schedule_start in DATE
30 -- schedule_end in DATE
31 -- strategy_temp_id in NUMBER
32 -- work_item_order in NUMBER
33
34 -- Required:
35 -- Defaults:
36 -- End of Comments
37
38 TYPE strategy_work_item_Rec_Type IS RECORD
39 (
40 WORK_ITEM_ID NUMBER := FND_API.G_MISS_NUM
41 , STRATEGY_ID NUMBER := FND_API.G_MISS_NUM
42 , RESOURCE_ID NUMBER := FND_API.G_MISS_NUM
43 , STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
44 , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
45 , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
46 , CREATION_DATE DATE := FND_API.G_MISS_DATE
47 , CREATED_BY NUMBER := FND_API.G_MISS_NUM
48 , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
49 , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
50 , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
51 , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
52 , WORK_ITEM_TEMPLATE_ID NUMBER := FND_API.G_MISS_NUM
53 , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
54 , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
55 , EXECUTE_START DATE := FND_API.G_MISS_DATE
56 , EXECUTE_END DATE := FND_API.G_MISS_DATE
57 , SCHEDULE_START DATE := FND_API.G_MISS_DATE
58 , SCHEDULE_END DATE := FND_API.G_MISS_DATE
59 , STRATEGY_TEMP_ID NUMBER := FND_API.G_MISS_NUM
60 , WORK_ITEM_ORDER NUMBER := FND_API.G_MISS_NUM
61 , ESCALATED_YN CHAR := FND_API.G_MISS_CHAR
62 , pre_execution_wait NUMBER := FND_API.G_MISS_NUM
63 , pre_execution_time_uom VARCHAR2(100) := FND_API.G_MISS_CHAR
64 , post_execution_wait NUMBER := FND_API.G_MISS_NUM
65 , execution_time_uom VARCHAR2(100) := FND_API.G_MISS_CHAR
66 , xdo_temp_id NUMBER := FND_API.G_MISS_NUM
67 , optional_yn VARCHAR2(5) := FND_API.G_MISS_CHAR
68 , optional_wait_time NUMBER := FND_API.G_MISS_NUM
69 , optional_wait_time_uom VARCHAR2(60) := FND_API.G_MISS_CHAR
70 , notify_yn VARCHAR2(3) := FND_API.G_MISS_CHAR
71 , escalate_yn CHAR := FND_API.G_MISS_CHAR
72 , escalate_wait_time NUMBER := FND_API.G_MISS_NUM
73 , escalate_wait_time_uom VARCHAR2(60) := FND_API.G_MISS_CHAR
74 , custom_workflow_type VARCHAR2(240) := FND_API.G_MISS_CHAR
75 );
76
77 G_MISS_strategy_work_item_REC strategy_work_item_Rec_Type;
78 TYPE strategy_work_item_Tbl_Type IS TABLE OF strategy_work_item_Rec_Type
79 INDEX BY BINARY_INTEGER;
80 G_MISS_strategy_work_item_TBL strategy_work_item_Tbl_Type;
81
82 -- *******************************************************
83 -- Start of Comments
84 -- *******************************************************
85 -- API Name: Create_strategy_work_items
86 -- Type : Private
87 -- Pre-Req :
88 -- Parameters:
89 -- IN
90 -- p_api_version_number IN NUMBER Required
91 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
92 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
93 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
94 -- P_strategy_work_item_Rec IN strategy_work_item_Rec_Type Required
95 --
96 -- OUT:
97 -- x_return_status OUT NOCOPY VARCHAR2
98 -- x_msg_count OUT NOCOPY NUMBER
99 -- x_msg_data OUT NOCOPY VARCHAR2
100 -- Version : Current version 2.0
101 -- End of Comments
102 --
103 PROCEDURE Create_strategy_work_items(
104 P_Api_Version_Number IN NUMBER,
105 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
106 P_Commit IN VARCHAR2 := FND_API.G_TRUE,
107 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
108 P_strategy_work_item_Rec IN strategy_work_item_Rec_Type := G_MISS_strategy_work_item_REC,
109 X_WORK_ITEM_ID OUT NOCOPY NUMBER,
110 X_Return_Status OUT NOCOPY VARCHAR2,
111 X_Msg_Count OUT NOCOPY NUMBER,
112 X_Msg_Data OUT NOCOPY VARCHAR2
113 );
114
115 -- *******************************************************
116 -- Start of Comments
117 -- *******************************************************
118 -- API Name: Update_strategy_work_items
119 -- Type : Private
120 -- Pre-Req :
121 -- Parameters:
122 -- IN
123 -- p_api_version_number IN NUMBER Required
124 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
125 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
126 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
127 -- P_strategy_work_item_Rec IN strategy_work_item_Rec_Type Required
128 -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
129 --
130 -- OUT:
131 -- x_return_status OUT NOCOPY VARCHAR2
132 -- x_msg_count OUT NOCOPY NUMBER
133 -- x_msg_data OUT NOCOPY VARCHAR2
134 -- Version : Current version 2.0
135 -- End of Comments
136 --
137 -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
138 PROCEDURE Update_strategy_work_items(
139 P_Api_Version_Number IN NUMBER,
140 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
141 P_Commit IN VARCHAR2 := FND_API.G_TRUE,
142 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
143 P_strategy_work_item_Rec IN strategy_work_item_Rec_Type,
144 X_Return_Status OUT NOCOPY VARCHAR2,
145 X_Msg_Count OUT NOCOPY NUMBER,
146 X_Msg_Data OUT NOCOPY VARCHAR2,
147 XO_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER
148 );
149
150 -- *******************************************************
151 -- Start of Comments
152 -- *******************************************************
153 -- API Name: Delete_strategy_work_items
154 -- Type : Private
155 -- Pre-Req :
156 -- Parameters:
157 -- IN
158 -- p_api_version_number IN NUMBER Required
159 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
160 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
161 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
162 -- P_strategy_work_item_Rec IN strategy_work_item_Rec_Type Required
163
164 --
165 -- OUT:
166 -- x_return_status OUT NOCOPY VARCHAR2
167 -- x_msg_count OUT NOCOPY NUMBER
168 -- x_msg_data OUT NOCOPY VARCHAR2
169 -- Version : Current version 2.0
170 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
171 -- and basic operation, developer must manually add parameters and business logic as necessary.
172 --
173 -- End of Comments
174 --
175
176 PROCEDURE Delete_strategy_work_items(
177 P_Api_Version_Number IN NUMBER,
178 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
179 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
180 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
181 p_WORK_ITEM_ID IN NUMBER,
182 X_Return_Status OUT NOCOPY VARCHAR2,
183 X_Msg_Count OUT NOCOPY NUMBER,
184 X_Msg_Data OUT NOCOPY VARCHAR2
185 );
186
187 End IEX_strategy_work_items_PVT;