eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.FA_CUSTOM_RET_VAL_PKG

Source


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