[Home] [Help]
PACKAGE: APPS.IEX_STRATEGY_PVT
Source
1 PACKAGE IEX_STRATEGY_PVT as
2 /* $Header: iexvstrs.pls 120.0.12010000.2 2008/08/11 10:58:35 pnaveenk ship $ */
3
4 -- Default number of records fetch per call
5
6 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
7 -- *******************************************************
8 -- Start of Comments
9 -- -------------------------------------------------------
10 -- Record name:STRATEGY_Rec_Type
11 -- -------------------------------------------------------
12 -- Parameters:
13 -- STRATEGY_ID
14 -- STATUS_CODE
15 -- STRATEGY_TEMPLATE_ID
16 -- DELINQUENCY_ID
17 -- OBJECT_TYPE
18 -- OBJECT_ID
19 -- CUST_ACCOUNT_ID
20 -- PARTY_ID
21 -- SCORE_VALUE
22 -- NEXT_WORK_ITEM_ID
23 -- USER_WORK_ITEM_YN
24 -- LAST_UPDATE_DATE
25 -- LAST_UPDATED_BY
26 -- LAST_UPDATE_LOGIN
27 -- CREATION_DATE
28 -- CREATED_BY
29 -- OBJECT_VERSION_NUMBER
30 -- REQUEST_ID
31 -- PROGRAM_APPLICATION_ID
32 -- PROGRAM_ID
33 -- PROGRAM_UPDATE_DATE
34 -- CHECKLIST_STRATEGY_ID
35 -- CHECKLIST_YN
36 --
37 -- Required:
38 -- Defaults:
39 -- Note: This is automatic generated record definition, it includes all columns
40 -- defined in the table, developer must manually add or delete some of the attributes.
41 --
42 -- End of Comments
43
44 TYPE STRATEGY_Rec_Type IS RECORD
45 (
46 STRATEGY_ID NUMBER
47 , STATUS_CODE VARCHAR2(30)
48 , STRATEGY_TEMPLATE_ID NUMBER
49 , DELINQUENCY_ID NUMBER
50 , OBJECT_TYPE VARCHAR2(30)
51 , OBJECT_ID NUMBER
52 , CUST_ACCOUNT_ID NUMBER
53 , PARTY_ID NUMBER
54 , SCORE_VALUE NUMBER
55 , NEXT_WORK_ITEM_ID NUMBER
56 , USER_WORK_ITEM_YN VARCHAR2(2)
57 , LAST_UPDATE_DATE DATE
58 , LAST_UPDATED_BY NUMBER
59 , LAST_UPDATE_LOGIN NUMBER
60 , CREATION_DATE DATE
61 , CREATED_BY NUMBER
62 , OBJECT_VERSION_NUMBER NUMBER
63 , REQUEST_ID NUMBER
64 , PROGRAM_APPLICATION_ID NUMBER
65 , PROGRAM_ID NUMBER
66 , PROGRAM_UPDATE_DATE DATE
67 , CHECKLIST_STRATEGY_ID NUMBER
68 , CHECKLIST_YN VARCHAR2(10)
69 , STRATEGY_LEVEL NUMBER
70 , JTF_OBJECT_TYPE VARCHAR2(30)
71 , JTF_OBJECT_ID NUMBER
72 , CUSTOMER_SITE_USE_ID NUMBER
73 , ORG_ID NUMBER --Bug# 6870773 Naveen
74 );
75
76 -- G_MISS_STRATEGY_REC STRATEGY_Rec_Type;
77 TYPE STRATEGY_Tbl_Type IS TABLE OF STRATEGY_Rec_Type
78 INDEX BY BINARY_INTEGER;
79 -- G_MISS_STRATEGY_TBL STRATEGY_Tbl_Type;
80
81 -- *******************************************************
82 -- Start of Comments
83 -- *******************************************************
84 -- API Name: Create_strategy
85 -- Type : Private
86 -- Pre-Req :
87 -- Parameters:
88 -- IN
89 -- p_api_version_number IN NUMBER Required
90 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
91 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
92 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
93 -- P_STRATEGY_Rec IN STRATEGY_Rec_Type Required
94 --
95 -- OUT:
96 -- x_return_status OUT NOCOPY VARCHAR2
97 -- x_msg_count OUT NOCOPY NUMBER
98 -- x_msg_data OUT NOCOPY VARCHAR2
99 -- Version : Current version 2.0
100 -- End of Comments
101 --
102 PROCEDURE Create_strategy(
103 P_Api_Version_Number IN NUMBER,
104 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
105 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
106 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
107 P_STRATEGY_Rec IN STRATEGY_Rec_Type,
108 X_STRATEGY_ID OUT NOCOPY NUMBER,
109 X_Return_Status OUT NOCOPY VARCHAR2,
110 X_Msg_Count OUT NOCOPY NUMBER,
111 X_Msg_Data OUT NOCOPY VARCHAR2
112 );
113
114 -- *******************************************************
115 -- Start of Comments
116 -- *******************************************************
117 -- API Name: Update_strategy
118 -- Type : Private
119 -- Pre-Req :
120 -- Parameters:
121 -- IN
122 -- p_api_version_number IN NUMBER Required
123 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
124 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
125 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
126 -- P_STRATEGY_Rec IN STRATEGY_Rec_Type Required
127 --
128 -- OUT:
129 -- x_return_status OUT NOCOPY VARCHAR2
130 -- x_msg_count OUT NOCOPY NUMBER
131 -- x_msg_data OUT NOCOPY VARCHAR2
132 -- XO_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER
133 -- Version : Current version 2.0
134 -- End of Comments
135 --
136 PROCEDURE Update_strategy(
137 P_Api_Version_Number IN NUMBER,
138 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
139 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
140 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
141 P_STRATEGY_Rec IN STRATEGY_Rec_Type,
142 X_Return_Status OUT NOCOPY VARCHAR2,
143 X_Msg_Count OUT NOCOPY NUMBER,
144 X_Msg_Data OUT NOCOPY VARCHAR2,
145 XO_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER
146 );
147
148 -- *******************************************************
149 -- Start of Comments
150 -- *******************************************************
151 -- API Name: Delete_strategy
152 -- Type : Private
153 -- Pre-Req :
154 -- Parameters:
155 -- IN
156 -- p_api_version_number IN NUMBER Required
157 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
158 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
159 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
160 -- P_STRATEGY_Rec IN STRATEGY_Rec_Type Required
161 -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
162 --
163 -- OUT:
164 -- x_return_status OUT NOCOPY VARCHAR2
165 -- x_msg_count OUT NOCOPY NUMBER
166 -- x_msg_data OUT NOCOPY VARCHAR2
167 -- Version : Current version 2.0
168 -- End of Comments
169 --
170
171 PROCEDURE Delete_strategy(
172 P_Api_Version_Number IN NUMBER,
173 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
174 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
175 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
176 P_STRATEGY_ID IN NUMBER,
177 X_Return_Status OUT NOCOPY VARCHAR2,
178 X_Msg_Count OUT NOCOPY NUMBER,
179 X_Msg_Data OUT NOCOPY VARCHAR2
180 );
181
182
183 End IEX_STRATEGY_PVT;