1 PACKAGE IEX_STRATEGIES_PKG as
2 /* $Header: iextstrs.pls 120.0.12010000.3 2008/08/13 10:53:14 pnaveenk ship $ */
3 PROCEDURE Insert_Row(
4 X_ROWID IN OUT NOCOPY VARCHAR2
5 ,X_STRATEGY_ID IN NUMBER
6 ,X_STATUS_CODE IN VARCHAR2
7 ,X_STRATEGY_TEMPLATE_ID IN NUMBER
8 ,X_DELINQUENCY_ID IN NUMBER
9 ,X_OBJECT_TYPE IN VARCHAR2
10 ,X_OBJECT_ID IN NUMBER
11 ,X_CUST_ACCOUNT_ID IN NUMBER
12 ,X_PARTY_ID IN NUMBER
13 ,X_SCORE_VALUE IN NUMBER
14 ,X_NEXT_WORK_ITEM_ID IN NUMBER
15 ,X_USER_WORK_ITEM_YN IN VARCHAR2,
16 X_OBJECT_VERSION_NUMBER in NUMBER,
17 X_CREATION_DATE in DATE,
18 X_CREATED_BY in NUMBER,
19 X_LAST_UPDATE_DATE in DATE,
20 X_LAST_UPDATED_BY in NUMBER,
21 X_LAST_UPDATE_LOGIN in NUMBER,
22 X_REQUEST_ID in NUMBER,
23 X_PROGRAM_APPLICATION_ID in NUMBER,
24 X_PROGRAM_ID in NUMBER,
25 X_PROGRAM_UPDATE_DATE in DATE,
26 X_CHECKLIST_STRATEGY_ID IN NUMBER,
27 X_CHECKLIST_YN IN VARCHAR2,
28 X_STRATEGY_LEVEL IN NUMBER,
29 X_JTF_OBJECT_TYPE IN VARCHAR2,
30 X_JTF_OBJECT_ID IN NUMBER,
31 X_CUSTOMER_SITE_USE_ID IN NUMBER,
32 X_ORG_ID IN NUMBER --Bug# 6870773 Naveen
33 );
34
35 PROCEDURE Update_Row(
36 X_STRATEGY_ID IN NUMBER
37 ,X_STATUS_CODE IN VARCHAR2
38 ,X_STRATEGY_TEMPLATE_ID IN NUMBER
39 ,X_DELINQUENCY_ID IN NUMBER
40 ,X_OBJECT_TYPE IN VARCHAR2
41 ,X_OBJECT_ID IN NUMBER
42 ,X_CUST_ACCOUNT_ID IN NUMBER
43 ,X_PARTY_ID IN NUMBER
44 ,X_SCORE_VALUE IN NUMBER
45 ,X_NEXT_WORK_ITEM_ID IN NUMBER
46 ,X_USER_WORK_ITEM_YN IN VARCHAR2,
47 X_OBJECT_VERSION_NUMBER in NUMBER,
48 X_LAST_UPDATE_DATE in DATE,
49 X_LAST_UPDATED_BY in NUMBER,
50 X_LAST_UPDATE_LOGIN in NUMBER,
51 X_REQUEST_ID in NUMBER,
52 X_PROGRAM_APPLICATION_ID in NUMBER,
53 X_PROGRAM_ID in NUMBER,
54 X_PROGRAM_UPDATE_DATE in DATE,
55 X_CHECKLIST_STRATEGY_ID IN NUMBER,
56 X_CHECKLIST_YN IN VARCHAR2,
57 X_STRATEGY_LEVEL IN NUMBER,
58 X_JTF_OBJECT_TYPE IN VARCHAR2,
59 X_JTF_OBJECT_ID IN NUMBER,
60 X_CUSTOMER_SITE_USE_ID IN NUMBER,
61 X_ORG_ID IN NUMBER --Bug# 6870773 Naveen
62 );
63
64 /*PROCEDURE Lock_Row(
65 X_STRATEGY_ID IN NUMBER
66 ,X_STATUS_CODE IN VARCHAR2
67 ,X_STRATEGY_TEMPLATE_ID IN NUMBER
68 ,X_DELINQUENCY_ID IN NUMBER
69 ,X_OBJECT_TYPE IN VARCHAR2
70 ,X_OBJECT_ID IN NUMBER
71 ,X_CUST_ACCOUNT_ID IN NUMBER
72 ,X_PARTY_ID IN NUMBER
73 ,X_SCORE_VALUE IN NUMBER
74 ,X_NEXT_WORK_ITEM_ID IN NUMBER
75 ,X_USER_WORK_ITEM_YN IN VARCHAR2,
76 X_OBJECT_VERSION_NUMBER in NUMBER,
77 X_CREATION_DATE in DATE,
78 X_CREATED_BY in NUMBER,
79 X_LAST_UPDATE_DATE in DATE,
80 X_LAST_UPDATED_BY in NUMBER,
81 X_LAST_UPDATE_LOGIN in NUMBER,
82 X_REQUEST_ID in NUMBER,
83 X_PROGRAM_APPLICATION_ID in NUMBER,
84 X_PROGRAM_ID in NUMBER,
85 X_PROGRAM_UPDATE_DATE in DATE);
86 */
87
88 procedure LOCK_ROW (
89 X_STRATEGY_ID in NUMBER,
90 X_OBJECT_VERSION_NUMBER in NUMBER);
91
92 PROCEDURE Delete_Row(
93 X_STRATEGY_ID NUMBER);
94 End IEX_STRATEGIES_PKG;