1 PACKAGE IEX_COSTS_PKG as
2 /* $Header: iextcoss.pls 120.0 2004/01/24 03:21:32 appldev noship $ */
3 -- Start of Comments
4 -- Package name : IEX_COSTS_PKG
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 PROCEDURE Insert_Row(
11 X_ROWID in out NOCOPY VARCHAR2,
12 p_COST_ID IN NUMBER,
13 p_CASE_ID IN NUMBER,
14 p_DELINQUENCY_ID IN NUMBER,
15 p_COST_TYPE_CODE IN VARCHAR2,
16 p_COST_ITEM_TYPE_CODE IN VARCHAR2,
17 p_COST_ITEM_TYPE_DESC IN VARCHAR2,
18 p_COST_ITEM_AMOUNT IN NUMBER,
19 p_COST_ITEM_CURRENCY_CODE IN VARCHAR2,
20 p_COST_ITEM_QTY IN NUMBER,
21 p_COST_ITEM_DATE IN DATE,
22 p_FUNCTIONAL_AMOUNT IN NUMBER,
23 p_EXCHANGE_TYPE IN VARCHAR2,
24 p_EXCHANGE_RATE IN NUMBER,
25 p_EXCHANGE_DATE IN DATE,
26 p_OBJECT_VERSION_NUMBER IN NUMBER,
27 P_COST_ITEM_APPROVED IN VARCHAR2,
28 p_active_flag IN VARCHAR2,
29 p_REQUEST_ID IN NUMBER,
30 p_PROGRAM_APPLICATION_ID IN NUMBER,
31 p_PROGRAM_ID IN NUMBER,
32 p_PROGRAM_UPDATE_DATE IN DATE,
33 p_ATTRIBUTE_CATEGORY IN VARCHAR2,
34 p_ATTRIBUTE1 IN VARCHAR2,
35 p_ATTRIBUTE2 IN VARCHAR2,
36 p_ATTRIBUTE3 IN VARCHAR2,
37 p_ATTRIBUTE4 IN VARCHAR2,
38 p_ATTRIBUTE5 IN VARCHAR2,
39 p_ATTRIBUTE6 IN VARCHAR2,
40 p_ATTRIBUTE7 IN VARCHAR2,
41 p_ATTRIBUTE8 IN VARCHAR2,
42 p_ATTRIBUTE9 IN VARCHAR2,
43 p_ATTRIBUTE10 IN VARCHAR2,
44 p_ATTRIBUTE11 IN VARCHAR2,
45 p_ATTRIBUTE12 IN VARCHAR2,
46 p_ATTRIBUTE13 IN VARCHAR2,
47 p_ATTRIBUTE14 IN VARCHAR2,
48 p_ATTRIBUTE15 IN VARCHAR2,
49 p_CREATED_BY IN VARCHAR2,
50 p_CREATION_DATE IN DATE,
51 p_LAST_UPDATED_BY IN NUMBER,
52 p_LAST_UPDATE_DATE IN DATE,
53 p_LAST_UPDATE_LOGIN IN NUMBER
54 );
55
56 PROCEDURE Update_Row(
57 p_COST_ID IN NUMBER,
58 p_CASE_ID IN NUMBER,
59 p_DELINQUENCY_ID IN NUMBER,
60 p_COST_TYPE_CODE IN VARCHAR2,
61 p_COST_ITEM_TYPE_CODE IN VARCHAR2,
62 p_COST_ITEM_TYPE_DESC IN VARCHAR2,
63 p_COST_ITEM_AMOUNT IN NUMBER,
64 p_COST_ITEM_CURRENCY_CODE IN VARCHAR2,
65 p_COST_ITEM_QTY IN NUMBER,
66 p_COST_ITEM_DATE IN DATE,
67 p_FUNCTIONAL_AMOUNT IN NUMBER,
68 p_EXCHANGE_TYPE IN VARCHAR2,
69 p_EXCHANGE_RATE IN NUMBER,
70 p_EXCHANGE_DATE IN DATE,
71 p_OBJECT_VERSION_NUMBER IN NUMBER,
72 P_COST_ITEM_APPROVED IN VARCHAR2,
73 p_active_flag IN VARCHAR2,
74 p_REQUEST_ID IN NUMBER,
75 p_PROGRAM_APPLICATION_ID IN NUMBER,
76 p_PROGRAM_ID IN NUMBER,
77 p_PROGRAM_UPDATE_DATE IN DATE,
78 p_ATTRIBUTE_CATEGORY IN VARCHAR2,
79 p_ATTRIBUTE1 IN VARCHAR2,
80 p_ATTRIBUTE2 IN VARCHAR2,
81 p_ATTRIBUTE3 IN VARCHAR2,
82 p_ATTRIBUTE4 IN VARCHAR2,
83 p_ATTRIBUTE5 IN VARCHAR2,
84 p_ATTRIBUTE6 IN VARCHAR2,
85 p_ATTRIBUTE7 IN VARCHAR2,
86 p_ATTRIBUTE8 IN VARCHAR2,
87 p_ATTRIBUTE9 IN VARCHAR2,
88 p_ATTRIBUTE10 IN VARCHAR2,
89 p_ATTRIBUTE11 IN VARCHAR2,
90 p_ATTRIBUTE12 IN VARCHAR2,
91 p_ATTRIBUTE13 IN VARCHAR2,
92 p_ATTRIBUTE14 IN VARCHAR2,
93 p_ATTRIBUTE15 IN VARCHAR2,
94 p_LAST_UPDATED_BY IN NUMBER,
95 p_LAST_UPDATE_DATE IN DATE,
96 p_LAST_UPDATE_LOGIN IN NUMBER
97 );
98
99 procedure LOCK_ROW (
100 p_COST_ID in NUMBER,
101 p_OBJECT_VERSION_NUMBER in NUMBER);
102 /*
103 PROCEDURE Lock_Row(
104 p_CASE_ID IN NUMBER,
105 p_DELINQUENCY_ID IN NUMBER,
106 p_COST_TYPE_CODE IN VARCHAR2,
107 p_COST_ITEM_TYPE_CODE IN VARCHAR2,
108 p_COST_ITEM_TYPE_DESC IN VARCHAR2,
109 p_COST_ITEM_AMOUNT IN NUMBER,
110 p_COST_ITEM_CURRENCY_CODE IN VARCHAR2,
111 p_COST_ITEM_QTY IN NUMBER,
112 p_COST_ITEM_DATE IN DATE,
113 p_FUNCTIONAL_AMOUNT IN NUMBER,
114 p_EXCHANGE_TYPE IN VARCHAR2,
115 p_EXCHANGE_RATE IN NUMBER,
116 p_EXCHANGE_DATE IN DATE,
117 p_OBJECT_VERSION_NUMBER IN NUMBER,
118 P_COST_ITEM_APPROVED IN VARCHAR2
119 p_active_flag IN VARCHAR2,
120 p_REQUEST_ID IN NUMBER,
121 p_PROGRAM_APPLICATION_ID IN NUMBER,
122 p_PROGRAM_ID IN NUMBER,
123 p_PROGRAM_UPDATE_DATE IN DATE,
124 p_ATTRIBUTE_CATEGORY IN VARCHAR2,
125 p_ATTRIBUTE1 IN VARCHAR2,
126 p_ATTRIBUTE2 IN VARCHAR2,
127 p_ATTRIBUTE3 IN VARCHAR2,
128 p_ATTRIBUTE4 IN VARCHAR2,
129 p_ATTRIBUTE5 IN VARCHAR2,
130 p_ATTRIBUTE6 IN VARCHAR2,
131 p_ATTRIBUTE7 IN VARCHAR2,
132 p_ATTRIBUTE8 IN VARCHAR2,
133 p_ATTRIBUTE9 IN VARCHAR2,
134 p_ATTRIBUTE10 IN VARCHAR2,
135 p_ATTRIBUTE11 IN VARCHAR2,
136 p_ATTRIBUTE12 IN VARCHAR2,
137 p_ATTRIBUTE13 IN VARCHAR2,
138 p_ATTRIBUTE14 IN VARCHAR2,
139 p_ATTRIBUTE15 IN VARCHAR2,
140 p_CREATED_BY IN VARCHAR2,
141 p_CREATION_DATE IN DATE,
142 p_LAST_UPDATED_BY IN NUMBER,
143 p_LAST_UPDATE_DATE IN DATE,
144 p_LAST_UPDATE_LOGIN IN NUMBER
145 );
146 */
147
148 PROCEDURE Delete_Row(
149 p_COST_ID IN NUMBER);
150 End IEX_COSTS_PKG;