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 BODY: APPS.IGS_AD_IMP_018

Source


1 PACKAGE BODY IGS_AD_IMP_018 AS
2 /* $Header: IGSAD96B.pls 120.0 2005/06/01 14:06:06 appldev noship $ */
3 FUNCTION validate_desc_flex
4 (
5  p_attribute_category IN VARCHAR2,
6  p_attribute1  IN VARCHAR2,
7  p_attribute2  IN VARCHAR2,
8  p_attribute3  IN VARCHAR2,
9  p_attribute4  IN VARCHAR2,
10  p_attribute5  IN VARCHAR2,
11  p_attribute6  IN VARCHAR2,
12  p_attribute7  IN VARCHAR2,
13  p_attribute8  IN VARCHAR2,
14  p_attribute9  IN VARCHAR2,
15  p_attribute10  IN VARCHAR2,
16  p_attribute11  IN VARCHAR2,
17  p_attribute12  IN VARCHAR2,
18  p_attribute13  IN VARCHAR2,
19  p_attribute14  IN VARCHAR2,
20  p_attribute15  IN VARCHAR2,
21  p_attribute16  IN VARCHAR2,
22  p_attribute17  IN VARCHAR2,
23  p_attribute18  IN VARCHAR2,
24  p_attribute19  IN VARCHAR2,
25  p_attribute20  IN VARCHAR2,
26  p_desc_flex_name IN VARCHAR2
27 ) RETURN BOOLEAN AS
28 	CURSOR app_cur IS
29 	SELECT
30 		application_short_name
31 	FROM
32 		fnd_application app, fnd_descriptive_flexs des
33 	WHERE
34 		app.application_id = des.application_id AND
35 		des.descriptive_flexfield_name = p_desc_flex_name;
36 	app_rec app_cur%ROWTYPE;
37 BEGIN
38  fnd_flex_descval.clear_column_values;
39  fnd_flex_descval.set_context_value(p_attribute_category);
40  fnd_flex_descval.set_column_value('ATTRIBUTE1',p_attribute1);
41  fnd_flex_descval.set_column_value('ATTRIBUTE2',p_attribute2);
42  fnd_flex_descval.set_column_value('ATTRIBUTE3',p_attribute3);
43  fnd_flex_descval.set_column_value('ATTRIBUTE4',p_attribute4);
44  fnd_flex_descval.set_column_value('ATTRIBUTE5',p_attribute5);
45  fnd_flex_descval.set_column_value('ATTRIBUTE6',p_attribute6);
46  fnd_flex_descval.set_column_value('ATTRIBUTE7',p_attribute7);
47  fnd_flex_descval.set_column_value('ATTRIBUTE8',p_attribute8);
48  fnd_flex_descval.set_column_value('ATTRIBUTE9',p_attribute9);
49  fnd_flex_descval.set_column_value('ATTRIBUTE10',p_attribute10);
50  fnd_flex_descval.set_column_value('ATTRIBUTE11',p_attribute11);
51  fnd_flex_descval.set_column_value('ATTRIBUTE12',p_attribute12);
52  fnd_flex_descval.set_column_value('ATTRIBUTE13',p_attribute13);
53  fnd_flex_descval.set_column_value('ATTRIBUTE14',p_attribute14);
54  fnd_flex_descval.set_column_value('ATTRIBUTE15',p_attribute15);
55  fnd_flex_descval.set_column_value('ATTRIBUTE16',p_attribute16);
56  fnd_flex_descval.set_column_value('ATTRIBUTE17',p_attribute17);
57  fnd_flex_descval.set_column_value('ATTRIBUTE18',p_attribute18);
58  fnd_flex_descval.set_column_value('ATTRIBUTE19',p_attribute19);
59  fnd_flex_descval.set_column_value('ATTRIBUTE20',p_attribute20);
60  OPEN app_cur;
61  FETCH app_cur INTO app_rec;
62  CLOSE app_cur;
63  IF (FND_FLEX_DESCVAL.validate_desccols( app_rec.application_short_name, p_desc_flex_name, 'I',SYSDATE)) THEN
64   RETURN TRUE;
65  ELSE
66   RETURN FALSE;
67  END IF;
68 EXCEPTION
69  WHEN OTHERS THEN
70   IF app_cur%ISOPEN THEN
71   	CLOSE app_cur;
72   END IF;
73   RETURN FALSE;
74 END validate_desc_flex;
75 
76 FUNCTION validate_desc_flex_40_cols(
77  p_attribute_category	IN VARCHAR2,
78  p_attribute1		IN VARCHAR2,
79  p_attribute2		IN VARCHAR2,
80  p_attribute3		IN VARCHAR2,
81  p_attribute4		IN VARCHAR2,
82  p_attribute5		IN VARCHAR2,
83  p_attribute6		IN VARCHAR2,
84  p_attribute7		IN VARCHAR2,
85  p_attribute8		IN VARCHAR2,
86  p_attribute9		IN VARCHAR2,
87  p_attribute10		IN VARCHAR2,
88  p_attribute11		IN VARCHAR2,
89  p_attribute12		IN VARCHAR2,
90  p_attribute13		IN VARCHAR2,
91  p_attribute14		IN VARCHAR2,
92  p_attribute15		IN VARCHAR2,
93  p_attribute16		IN VARCHAR2,
94  p_attribute17		IN VARCHAR2,
95  p_attribute18		IN VARCHAR2,
96  p_attribute19		IN VARCHAR2,
97  p_attribute20		IN VARCHAR2,
98  p_attribute21		IN VARCHAR2,
99  p_attribute22		IN VARCHAR2,
100  p_attribute23		IN VARCHAR2,
101  p_attribute24		IN VARCHAR2,
102  p_attribute25		IN VARCHAR2,
103  p_attribute26		IN VARCHAR2,
104  p_attribute27		IN VARCHAR2,
105  p_attribute28		IN VARCHAR2,
106  p_attribute29		IN VARCHAR2,
107  p_attribute30		IN VARCHAR2,
108  p_attribute31		IN VARCHAR2,
109  p_attribute32		IN VARCHAR2,
110  p_attribute33		IN VARCHAR2,
111  p_attribute34		IN VARCHAR2,
112  p_attribute35		IN VARCHAR2,
113  p_attribute36		IN VARCHAR2,
114  p_attribute37		IN VARCHAR2,
115  p_attribute38		IN VARCHAR2,
116  p_attribute39		IN VARCHAR2,
117  p_attribute40		IN VARCHAR2,
118  p_desc_flex_name	IN VARCHAR2)
119  RETURN BOOLEAN AS
120 
121  CURSOR app_cur IS
122   SELECT application_short_name
123   FROM fnd_application app, fnd_descriptive_flexs des
124   WHERE app.application_id = des.application_id AND
125 	des.descriptive_flexfield_name = p_desc_flex_name;
126 	app_rec app_cur%ROWTYPE;
127 BEGIN
128  fnd_flex_descval.clear_column_values;
129  fnd_flex_descval.set_context_value(p_attribute_category);
130  fnd_flex_descval.set_column_value('ATTRIBUTE1',p_attribute1);
131  fnd_flex_descval.set_column_value('ATTRIBUTE2',p_attribute2);
132  fnd_flex_descval.set_column_value('ATTRIBUTE3',p_attribute3);
133  fnd_flex_descval.set_column_value('ATTRIBUTE4',p_attribute4);
134  fnd_flex_descval.set_column_value('ATTRIBUTE5',p_attribute5);
135  fnd_flex_descval.set_column_value('ATTRIBUTE6',p_attribute6);
136  fnd_flex_descval.set_column_value('ATTRIBUTE7',p_attribute7);
137  fnd_flex_descval.set_column_value('ATTRIBUTE8',p_attribute8);
138  fnd_flex_descval.set_column_value('ATTRIBUTE9',p_attribute9);
139  fnd_flex_descval.set_column_value('ATTRIBUTE10',p_attribute10);
140  fnd_flex_descval.set_column_value('ATTRIBUTE11',p_attribute11);
141  fnd_flex_descval.set_column_value('ATTRIBUTE12',p_attribute12);
142  fnd_flex_descval.set_column_value('ATTRIBUTE13',p_attribute13);
143  fnd_flex_descval.set_column_value('ATTRIBUTE14',p_attribute14);
144  fnd_flex_descval.set_column_value('ATTRIBUTE15',p_attribute15);
145  fnd_flex_descval.set_column_value('ATTRIBUTE16',p_attribute16);
146  fnd_flex_descval.set_column_value('ATTRIBUTE17',p_attribute17);
147  fnd_flex_descval.set_column_value('ATTRIBUTE18',p_attribute18);
148  fnd_flex_descval.set_column_value('ATTRIBUTE19',p_attribute19);
149  fnd_flex_descval.set_column_value('ATTRIBUTE20',p_attribute20);
150  fnd_flex_descval.set_column_value('ATTRIBUTE21',p_attribute21);
151  fnd_flex_descval.set_column_value('ATTRIBUTE22',p_attribute22);
152  fnd_flex_descval.set_column_value('ATTRIBUTE23',p_attribute23);
153  fnd_flex_descval.set_column_value('ATTRIBUTE24',p_attribute24);
154  fnd_flex_descval.set_column_value('ATTRIBUTE25',p_attribute25);
155  fnd_flex_descval.set_column_value('ATTRIBUTE26',p_attribute26);
156  fnd_flex_descval.set_column_value('ATTRIBUTE27',p_attribute27);
157  fnd_flex_descval.set_column_value('ATTRIBUTE28',p_attribute28);
158  fnd_flex_descval.set_column_value('ATTRIBUTE29',p_attribute29);
159  fnd_flex_descval.set_column_value('ATTRIBUTE30',p_attribute30);
160  fnd_flex_descval.set_column_value('ATTRIBUTE31',p_attribute31);
161  fnd_flex_descval.set_column_value('ATTRIBUTE32',p_attribute32);
162  fnd_flex_descval.set_column_value('ATTRIBUTE33',p_attribute33);
163  fnd_flex_descval.set_column_value('ATTRIBUTE34',p_attribute34);
164  fnd_flex_descval.set_column_value('ATTRIBUTE35',p_attribute35);
165  fnd_flex_descval.set_column_value('ATTRIBUTE36',p_attribute36);
166  fnd_flex_descval.set_column_value('ATTRIBUTE37',p_attribute37);
167  fnd_flex_descval.set_column_value('ATTRIBUTE38',p_attribute38);
168  fnd_flex_descval.set_column_value('ATTRIBUTE39',p_attribute39);
169  fnd_flex_descval.set_column_value('ATTRIBUTE40',p_attribute40);
170  OPEN app_cur;
171  FETCH app_cur INTO app_rec;
172  CLOSE app_cur;
173  IF (FND_FLEX_DESCVAL.validate_desccols( app_rec.application_short_name, p_desc_flex_name, 'I',SYSDATE)) THEN
174   RETURN TRUE;
175  ELSE
176   RETURN FALSE;
177  END IF;
178 EXCEPTION
179  WHEN OTHERS THEN
180   IF app_cur%ISOPEN THEN
181   	CLOSE app_cur;
182   END IF;
183   RETURN FALSE;
184 END validate_desc_flex_40_cols;
185 
186 END IGS_AD_IMP_018;