[Home] [Help]
PACKAGE: APPS.FA_CUSTOM_RET_VAL_PKG
Source
1 PACKAGE FA_CUSTOM_RET_VAL_PKG AUTHID CURRENT_USER as
2 /* $Header: facrvcs.pls 120.3 2009/03/27 08:55:56 bridgway ship $ */
3
4
5 FUNCTION VALIDATE_CRITERIA
6 (px_mass_ret_rec in FA_CUSTOM_RET_VAL_PKG.mass_ret_rec_type,
7 p_error_message out NOCOPY varchar2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
8 return BOOLEAN;
9
10 TYPE mass_ret_rec_type IS RECORD (
11 MASS_RETIREMENT_ID FA_MASS_RETIREMENTS.MASS_RETIREMENT_ID%TYPE,
12 BOOK_TYPE_CODE FA_MASS_RETIREMENTS.BOOK_TYPE_CODE%TYPE,
13 RETIRE_SUBCOMPONENTS_FLAG FA_MASS_RETIREMENTS.RETIRE_SUBCOMPONENTS_FLAG%TYPE,
14 STATUS FA_MASS_RETIREMENTS.STATUS%TYPE,
15 RETIRE_REQUEST_ID FA_MASS_RETIREMENTS.RETIRE_REQUEST_ID%TYPE,
16 REINSTATE_REQUEST_ID FA_MASS_RETIREMENTS.REINSTATE_REQUEST_ID%TYPE,
17 RETIREMENT_DATE FA_MASS_RETIREMENTS.RETIREMENT_DATE%TYPE,
18 PROCEEDS_OF_SALE FA_MASS_RETIREMENTS.PROCEEDS_OF_SALE%TYPE,
19 COST_OF_REMOVAL FA_MASS_RETIREMENTS.COST_OF_REMOVAL%TYPE,
20 FROM_COST FA_MASS_RETIREMENTS.FROM_COST%TYPE,
21 INCLUDE_FULLY_RSVD_FLAG FA_MASS_RETIREMENTS.INCLUDE_FULLY_RSVD_FLAG%TYPE,
22 TO_COST FA_MASS_RETIREMENTS.TO_COST%TYPE,
23 DESCRIPTION FA_MASS_RETIREMENTS.DESCRIPTION%TYPE,
24 RETIREMENT_TYPE_CODE FA_MASS_RETIREMENTS.RETIREMENT_TYPE_CODE%TYPE,
25 ASSET_TYPE FA_MASS_RETIREMENTS.ASSET_TYPE%TYPE,
26 LOCATION_ID FA_MASS_RETIREMENTS.LOCATION_ID%TYPE,
27 EMPLOYEE_ID FA_MASS_RETIREMENTS.EMPLOYEE_ID%TYPE,
28 CATEGORY_ID FA_MASS_RETIREMENTS.CATEGORY_ID%TYPE,
29 ASSET_KEY_ID FA_MASS_RETIREMENTS.ASSET_KEY_ID%TYPE,
30 FROM_ASSET_NUMBER FA_MASS_RETIREMENTS.FROM_ASSET_NUMBER%TYPE,
31 TO_ASSET_NUMBER FA_MASS_RETIREMENTS.TO_ASSET_NUMBER%TYPE,
32 FROM_DATE_PLACED_IN_SERVICE FA_MASS_RETIREMENTS.FROM_DATE_PLACED_IN_SERVICE%TYPE,
33 TO_DATE_PLACED_IN_SERVICE FA_MASS_RETIREMENTS.TO_DATE_PLACED_IN_SERVICE%TYPE,
34 GROUP_ASSET_ID FA_MASS_RETIREMENTS.GROUP_ASSET_ID%TYPE,
35 FROM_THRESHOLD_AMOUNT FA_MASS_RETIREMENTS.FROM_THRESHOLD_AMOUNT%TYPE,
36 TO_THRESHOLD_AMOUNT FA_MASS_RETIREMENTS.TO_THRESHOLD_AMOUNT%TYPE,
37 CREATE_REQUEST_ID FA_MASS_RETIREMENTS.CREATE_REQUEST_ID%TYPE,
38 SERIAL_NUMBER FA_MASS_RETIREMENTS.SERIAL_NUMBER%TYPE,
39 MANUFACTURER_NAME FA_MASS_RETIREMENTS.MANUFACTURER_NAME%TYPE,
40 MODEL_NUMBER FA_MASS_RETIREMENTS.MODEL_NUMBER%TYPE,
41 TAG_NUMBER FA_MASS_RETIREMENTS.TAG_NUMBER%TYPE,
42 UNITS_TO_RETIRE FA_MASS_RETIREMENTS.UNITS_TO_RETIRE%TYPE,
43 PROJECT_ID FA_MASS_RETIREMENTS.PROJECT_ID%TYPE,
44 TASK_ID FA_MASS_RETIREMENTS.TASK_ID%TYPE,
45 ATTRIBUTE1 FA_MASS_RETIREMENTS.ATTRIBUTE1%TYPE,
46 ATTRIBUTE2 FA_MASS_RETIREMENTS.ATTRIBUTE2%TYPE,
47 ATTRIBUTE3 FA_MASS_RETIREMENTS.ATTRIBUTE3%TYPE,
48 ATTRIBUTE4 FA_MASS_RETIREMENTS.ATTRIBUTE4%TYPE,
49 ATTRIBUTE5 FA_MASS_RETIREMENTS.ATTRIBUTE5%TYPE,
50 ATTRIBUTE6 FA_MASS_RETIREMENTS.ATTRIBUTE6%TYPE,
51 ATTRIBUTE7 FA_MASS_RETIREMENTS.ATTRIBUTE7%TYPE,
52 ATTRIBUTE8 FA_MASS_RETIREMENTS.ATTRIBUTE8%TYPE,
53 ATTRIBUTE9 FA_MASS_RETIREMENTS.ATTRIBUTE9%TYPE,
54 ATTRIBUTE10 FA_MASS_RETIREMENTS.ATTRIBUTE10%TYPE,
55 ATTRIBUTE11 FA_MASS_RETIREMENTS.ATTRIBUTE11%TYPE,
56 ATTRIBUTE12 FA_MASS_RETIREMENTS.ATTRIBUTE12%TYPE,
57 ATTRIBUTE13 FA_MASS_RETIREMENTS.ATTRIBUTE13%TYPE,
58 ATTRIBUTE14 FA_MASS_RETIREMENTS.ATTRIBUTE14%TYPE,
59 ATTRIBUTE15 FA_MASS_RETIREMENTS.ATTRIBUTE15%TYPE,
60 ATTRIBUTE_CATEGORY_CODE FA_MASS_RETIREMENTS.ATTRIBUTE_CATEGORY_CODE%TYPE,
61 SEGMENT1_LOW FA_MASS_RETIREMENTS.SEGMENT1_LOW%TYPE,
62 SEGMENT2_LOW FA_MASS_RETIREMENTS.SEGMENT2_LOW%TYPE,
63 SEGMENT3_LOW FA_MASS_RETIREMENTS.SEGMENT3_LOW%TYPE,
64 SEGMENT4_LOW FA_MASS_RETIREMENTS.SEGMENT4_LOW%TYPE,
65 SEGMENT5_LOW FA_MASS_RETIREMENTS.SEGMENT5_LOW%TYPE,
66 SEGMENT6_LOW FA_MASS_RETIREMENTS.SEGMENT6_LOW%TYPE,
67 SEGMENT7_LOW FA_MASS_RETIREMENTS.SEGMENT7_LOW%TYPE,
68 SEGMENT8_LOW FA_MASS_RETIREMENTS.SEGMENT8_LOW%TYPE,
69 SEGMENT9_LOW FA_MASS_RETIREMENTS.SEGMENT9_LOW%TYPE,
70 SEGMENT10_LOW FA_MASS_RETIREMENTS.SEGMENT10_LOW%TYPE,
71 SEGMENT11_LOW FA_MASS_RETIREMENTS.SEGMENT11_LOW%TYPE,
72 SEGMENT12_LOW FA_MASS_RETIREMENTS.SEGMENT12_LOW%TYPE,
73 SEGMENT13_LOW FA_MASS_RETIREMENTS.SEGMENT13_LOW%TYPE,
74 SEGMENT14_LOW FA_MASS_RETIREMENTS.SEGMENT14_LOW%TYPE,
75 SEGMENT15_LOW FA_MASS_RETIREMENTS.SEGMENT15_LOW%TYPE,
76 SEGMENT16_LOW FA_MASS_RETIREMENTS.SEGMENT16_LOW%TYPE,
77 SEGMENT17_LOW FA_MASS_RETIREMENTS.SEGMENT17_LOW%TYPE,
78 SEGMENT18_LOW FA_MASS_RETIREMENTS.SEGMENT18_LOW%TYPE,
79 SEGMENT19_LOW FA_MASS_RETIREMENTS.SEGMENT19_LOW%TYPE,
80 SEGMENT20_LOW FA_MASS_RETIREMENTS.SEGMENT20_LOW%TYPE,
81 SEGMENT21_LOW FA_MASS_RETIREMENTS.SEGMENT21_LOW%TYPE,
82 SEGMENT22_LOW FA_MASS_RETIREMENTS.SEGMENT22_LOW%TYPE,
83 SEGMENT23_LOW FA_MASS_RETIREMENTS.SEGMENT23_LOW%TYPE,
84 SEGMENT24_LOW FA_MASS_RETIREMENTS.SEGMENT24_LOW%TYPE,
85 SEGMENT25_LOW FA_MASS_RETIREMENTS.SEGMENT25_LOW%TYPE,
86 SEGMENT26_LOW FA_MASS_RETIREMENTS.SEGMENT26_LOW%TYPE,
87 SEGMENT27_LOW FA_MASS_RETIREMENTS.SEGMENT27_LOW%TYPE,
88 SEGMENT28_LOW FA_MASS_RETIREMENTS.SEGMENT28_LOW%TYPE,
89 SEGMENT29_LOW FA_MASS_RETIREMENTS.SEGMENT29_LOW%TYPE,
90 SEGMENT30_LOW FA_MASS_RETIREMENTS.SEGMENT30_LOW%TYPE,
91 SEGMENT1_HIGH FA_MASS_RETIREMENTS.SEGMENT1_HIGH%TYPE,
92 SEGMENT2_HIGH FA_MASS_RETIREMENTS.SEGMENT2_HIGH%TYPE,
93 SEGMENT3_HIGH FA_MASS_RETIREMENTS.SEGMENT3_HIGH%TYPE,
94 SEGMENT4_HIGH FA_MASS_RETIREMENTS.SEGMENT4_HIGH%TYPE,
95 SEGMENT5_HIGH FA_MASS_RETIREMENTS.SEGMENT5_HIGH%TYPE,
96 SEGMENT6_HIGH FA_MASS_RETIREMENTS.SEGMENT6_HIGH%TYPE,
97 SEGMENT7_HIGH FA_MASS_RETIREMENTS.SEGMENT7_HIGH%TYPE,
98 SEGMENT8_HIGH FA_MASS_RETIREMENTS.SEGMENT8_HIGH%TYPE,
99 SEGMENT9_HIGH FA_MASS_RETIREMENTS.SEGMENT9_HIGH%TYPE,
100 SEGMENT10_HIGH FA_MASS_RETIREMENTS.SEGMENT10_HIGH%TYPE,
101 SEGMENT11_HIGH FA_MASS_RETIREMENTS.SEGMENT11_HIGH%TYPE,
102 SEGMENT12_HIGH FA_MASS_RETIREMENTS.SEGMENT12_HIGH%TYPE,
103 SEGMENT13_HIGH FA_MASS_RETIREMENTS.SEGMENT13_HIGH%TYPE,
104 SEGMENT14_HIGH FA_MASS_RETIREMENTS.SEGMENT14_HIGH%TYPE,
105 SEGMENT15_HIGH FA_MASS_RETIREMENTS.SEGMENT15_HIGH%TYPE,
106 SEGMENT16_HIGH FA_MASS_RETIREMENTS.SEGMENT16_HIGH%TYPE,
107 SEGMENT17_HIGH FA_MASS_RETIREMENTS.SEGMENT17_HIGH%TYPE,
108 SEGMENT18_HIGH FA_MASS_RETIREMENTS.SEGMENT18_HIGH%TYPE,
109 SEGMENT19_HIGH FA_MASS_RETIREMENTS.SEGMENT19_HIGH%TYPE,
110 SEGMENT20_HIGH FA_MASS_RETIREMENTS.SEGMENT20_HIGH%TYPE,
111 SEGMENT21_HIGH FA_MASS_RETIREMENTS.SEGMENT21_HIGH%TYPE,
112 SEGMENT22_HIGH FA_MASS_RETIREMENTS.SEGMENT22_HIGH%TYPE,
113 SEGMENT23_HIGH FA_MASS_RETIREMENTS.SEGMENT23_HIGH%TYPE,
114 SEGMENT24_HIGH FA_MASS_RETIREMENTS.SEGMENT24_HIGH%TYPE,
115 SEGMENT25_HIGH FA_MASS_RETIREMENTS.SEGMENT25_HIGH%TYPE,
116 SEGMENT26_HIGH FA_MASS_RETIREMENTS.SEGMENT26_HIGH%TYPE,
117 SEGMENT27_HIGH FA_MASS_RETIREMENTS.SEGMENT27_HIGH%TYPE,
118 SEGMENT28_HIGH FA_MASS_RETIREMENTS.SEGMENT28_HIGH%TYPE,
119 SEGMENT29_HIGH FA_MASS_RETIREMENTS.SEGMENT29_HIGH%TYPE,
120 SEGMENT30_HIGH FA_MASS_RETIREMENTS.SEGMENT30_HIGH%TYPE,
121 LAST_UPDATE_DATE FA_MASS_RETIREMENTS.LAST_UPDATE_DATE%TYPE,
122 LAST_UPDATED_BY FA_MASS_RETIREMENTS.LAST_UPDATED_BY%TYPE,
123 CREATION_DATE FA_MASS_RETIREMENTS.CREATION_DATE%TYPE,
124 CREATED_BY FA_MASS_RETIREMENTS.CREATED_BY%TYPE,
125 LAST_UPDATE_LOGIN FA_MASS_RETIREMENTS.LAST_UPDATE_LOGIN%TYPE
126 );
127
128 TYPE mass_ret_rec_tbl_type IS TABLE OF mass_ret_rec_type index by binary_integer;
129
130
131 END FA_CUSTOM_RET_VAL_PKG;