[Home] [Help]
PACKAGE: APPS.IEX_STRATEGY_WORK_ITEMS_PVT
Source
1 PACKAGE IEX_strategy_work_items_PVT as
2 /* $Header: iexvswis.pls 120.0.12010000.2 2008/08/06 09:04:55 schekuri 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 );
63
64 G_MISS_strategy_work_item_REC strategy_work_item_Rec_Type;
65 TYPE strategy_work_item_Tbl_Type IS TABLE OF strategy_work_item_Rec_Type
66 INDEX BY BINARY_INTEGER;
67 G_MISS_strategy_work_item_TBL strategy_work_item_Tbl_Type;
68
69 -- *******************************************************
70 -- Start of Comments
71 -- *******************************************************
72 -- API Name: Create_strategy_work_items
73 -- Type : Private
74 -- Pre-Req :
75 -- Parameters:
76 -- IN
77 -- p_api_version_number IN NUMBER Required
78 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
79 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
80 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
81 -- P_strategy_work_item_Rec IN strategy_work_item_Rec_Type Required
82 --
83 -- OUT:
84 -- x_return_status OUT NOCOPY VARCHAR2
85 -- x_msg_count OUT NOCOPY NUMBER
86 -- x_msg_data OUT NOCOPY VARCHAR2
87 -- Version : Current version 2.0
88 -- End of Comments
89 --
90 PROCEDURE Create_strategy_work_items(
91 P_Api_Version_Number IN NUMBER,
92 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
93 P_Commit IN VARCHAR2 := FND_API.G_TRUE,
94 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
95 P_strategy_work_item_Rec IN strategy_work_item_Rec_Type := G_MISS_strategy_work_item_REC,
96 X_WORK_ITEM_ID OUT NOCOPY NUMBER,
97 X_Return_Status OUT NOCOPY VARCHAR2,
98 X_Msg_Count OUT NOCOPY NUMBER,
99 X_Msg_Data OUT NOCOPY VARCHAR2
100 );
101
102 -- *******************************************************
103 -- Start of Comments
104 -- *******************************************************
105 -- API Name: Update_strategy_work_items
106 -- Type : Private
107 -- Pre-Req :
108 -- Parameters:
109 -- IN
110 -- p_api_version_number IN NUMBER Required
111 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
112 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
113 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
114 -- P_strategy_work_item_Rec IN strategy_work_item_Rec_Type Required
115 -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
116 --
117 -- OUT:
118 -- x_return_status OUT NOCOPY VARCHAR2
119 -- x_msg_count OUT NOCOPY NUMBER
120 -- x_msg_data OUT NOCOPY VARCHAR2
121 -- Version : Current version 2.0
122 -- End of Comments
123 --
124 -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
125 PROCEDURE Update_strategy_work_items(
126 P_Api_Version_Number IN NUMBER,
127 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
128 P_Commit IN VARCHAR2 := FND_API.G_TRUE,
129 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
130 P_strategy_work_item_Rec IN strategy_work_item_Rec_Type,
131 X_Return_Status OUT NOCOPY VARCHAR2,
132 X_Msg_Count OUT NOCOPY NUMBER,
133 X_Msg_Data OUT NOCOPY VARCHAR2,
134 XO_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER
135 );
136
137 -- *******************************************************
138 -- Start of Comments
139 -- *******************************************************
140 -- API Name: Delete_strategy_work_items
141 -- Type : Private
142 -- Pre-Req :
143 -- Parameters:
144 -- IN
145 -- p_api_version_number IN NUMBER Required
146 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
147 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
148 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
149 -- P_strategy_work_item_Rec IN strategy_work_item_Rec_Type Required
150
151 --
152 -- OUT:
153 -- x_return_status OUT NOCOPY VARCHAR2
154 -- x_msg_count OUT NOCOPY NUMBER
155 -- x_msg_data OUT NOCOPY VARCHAR2
156 -- Version : Current version 2.0
157 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
158 -- and basic operation, developer must manually add parameters and business logic as necessary.
159 --
160 -- End of Comments
161 --
162
163 PROCEDURE Delete_strategy_work_items(
164 P_Api_Version_Number IN NUMBER,
165 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
166 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
167 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
168 p_WORK_ITEM_ID IN NUMBER,
169 X_Return_Status OUT NOCOPY VARCHAR2,
170 X_Msg_Count OUT NOCOPY NUMBER,
171 X_Msg_Data OUT NOCOPY VARCHAR2
172 );
173
174 End IEX_strategy_work_items_PVT;