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.

APPS.FLM_KANBAN_CONFIG_PARAMS dependencies on FLM_KANBAN_CONSTANTS

Line 99: l_preference_id := FLM_KANBAN_CONSTANTS.KANBAN_TOL_FS;

95: l_level_id number;
96: l_KBToleranceFSProd varchar(10);
97: l_number number;
98: begin
99: l_preference_id := FLM_KANBAN_CONSTANTS.KANBAN_TOL_FS;
100: l_level_id := get_preference_level_id(l_preference_id, p_org_id);
101: l_KBToleranceFSProd := get_ekb_preference_value(l_level_id, l_preference_id, '4');
102: l_number := to_number(l_KBToleranceFSProd);
103: return l_number;

Line 114: l_preference_id := FLM_KANBAN_CONSTANTS.KANBAN_TOL_FS;

110: l_KBToleranceFSInter varchar(10);
111: l_preference_id number;
112: l_number number;
113: begin
114: l_preference_id := FLM_KANBAN_CONSTANTS.KANBAN_TOL_FS;
115: l_level_id := get_preference_level_id(l_preference_id, p_org_id);
116: l_KBToleranceFSInter := get_ekb_preference_value(l_level_id, l_preference_id, '1');
117: l_number := to_number(l_KBToleranceFSInter);
118: return l_number;

Line 129: l_preference_id := FLM_KANBAN_CONSTANTS.KANBAN_TOL_FS;

125: l_KBToleranceFSIntra varchar(10);
126: l_preference_id number;
127: l_number number;
128: begin
129: l_preference_id := FLM_KANBAN_CONSTANTS.KANBAN_TOL_FS;
130: l_level_id := get_preference_level_id(l_preference_id, p_org_id);
131: l_KBToleranceFSIntra := get_ekb_preference_value(l_level_id, l_preference_id, '3');
132: l_number := to_number(l_KBToleranceFSIntra);
133: return l_number;

Line 144: l_preference_id := FLM_KANBAN_CONSTANTS.KANBAN_TOL_FS;

140: l_KBToleranceFSSupplier varchar(10);
141: l_preference_id number;
142: l_number number;
143: begin
144: l_preference_id := FLM_KANBAN_CONSTANTS.KANBAN_TOL_FS;
145: l_level_id := get_preference_level_id(l_preference_id, p_org_id);
146: l_KBToleranceFSSupplier := get_ekb_preference_value(l_level_id, l_preference_id, '2');
147: l_number := to_number(l_KBToleranceFSSupplier);
148: return l_number;

Line 160: l_preference_id := FLM_KANBAN_CONSTANTS.TOLERANCE_KANBAN_TRANSFERS;

156: l_level_id number;
157: l_tol_kanban_transfer varchar(10);
158: l_preference_id number;
159: begin
160: l_preference_id := FLM_KANBAN_CONSTANTS.TOLERANCE_KANBAN_TRANSFERS;
161: l_level_id := get_preference_level_id(l_preference_id, p_org_id);
162: l_tol_kanban_transfer := get_ekb_preference_value(l_level_id, l_preference_id, null);
163: return l_tol_kanban_transfer;
164: end;

Line 173: l_preference_id := FLM_KANBAN_CONSTANTS.DJ_STATUS_REPLENISHMENT;

169: l_level_id number;
170: l_StatusDJReplenishment varchar(10);
171: l_preference_id number;
172: begin
173: l_preference_id := FLM_KANBAN_CONSTANTS.DJ_STATUS_REPLENISHMENT;
174: l_level_id := get_preference_level_id(l_preference_id, p_org_id);
175: l_StatusDJReplenishment := get_ekb_preference_value(l_level_id, l_preference_id, null);
176: return l_StatusDJReplenishment;
177: end;

Line 186: l_preference_id := FLM_KANBAN_CONSTANTS.SOURCE_STAGING_SUBINV;

182: l_level_id number;
183: l_SrcSubInvAsStagSubInv varchar(10);
184: l_preference_id number;
185: begin
186: l_preference_id := FLM_KANBAN_CONSTANTS.SOURCE_STAGING_SUBINV;
187: l_level_id := get_preference_level_id(l_preference_id, p_org_id);
188: l_SrcSubInvAsStagSubInv := get_ekb_preference_value(l_level_id, l_preference_id, null);
189: return l_SrcSubInvAsStagSubInv;
190: end;

Line 201: l_preference_id := FLM_KANBAN_CONSTANTS.KANBAN_TOL_FS;

197: l_RcvTolerance_Prod varchar(10);
198: l_preference_id number;
199: l_number number;
200: begin
201: l_preference_id := FLM_KANBAN_CONSTANTS.KANBAN_TOL_FS;
202: l_level_id := get_preference_level_id(l_preference_id, p_org_id);
203: l_RcvTolerance_Prod := get_ekb_preference_value(l_level_id, l_preference_id, '4');
204: l_number := to_number(l_RcvTolerance_Prod);
205: return l_number;

Line 217: l_preference_id := FLM_KANBAN_CONSTANTS.DEMAND_RANGE_DAYS;

213: l_demand_range_days varchar(10);
214: l_preference_id number;
215: l_number number;
216: begin
217: l_preference_id := FLM_KANBAN_CONSTANTS.DEMAND_RANGE_DAYS;
218: l_level_id := get_preference_level_id(l_preference_id, p_org_id);
219: l_demand_range_days := get_ekb_preference_value(l_level_id, l_preference_id, null);
220: l_number := to_number(l_demand_range_days);
221: return l_number;

Line 232: l_preference_id := FLM_KANBAN_CONSTANTS.DEMAND_TOLERANCE;

228: l_demand_tolerance varchar(10);
229: l_preference_id number;
230: l_number number;
231: begin
232: l_preference_id := FLM_KANBAN_CONSTANTS.DEMAND_TOLERANCE;
233: l_level_id := get_preference_level_id(l_preference_id, p_org_id);
234: l_demand_tolerance := get_ekb_preference_value(l_level_id, l_preference_id, null);
235: l_number := to_number(l_demand_tolerance);
236: return l_number;

Line 248: l_preference_id := FLM_KANBAN_CONSTANTS.LEADTIME_RANGE_DAYS;

244: l_lt_range_days varchar(10);
245: l_preference_id number;
246: l_number number;
247: begin
248: l_preference_id := FLM_KANBAN_CONSTANTS.LEADTIME_RANGE_DAYS;
249: l_level_id := get_preference_level_id(l_preference_id, p_org_id);
250: l_lt_range_days := get_ekb_preference_value(l_level_id, l_preference_id, null);
251: l_number := to_number(l_lt_range_days);
252: return l_number;

Line 263: l_preference_id := FLM_KANBAN_CONSTANTS.LEADTIME_TOLERANCE;

259: l_lt_tolerance varchar(10);
260: l_preference_id number;
261: l_number number;
262: begin
263: l_preference_id := FLM_KANBAN_CONSTANTS.LEADTIME_TOLERANCE;
264: l_level_id := get_preference_level_id(l_preference_id, p_org_id);
265: l_lt_tolerance := get_ekb_preference_value(l_level_id, l_preference_id, null);
266: l_number := to_number(l_lt_tolerance);
267: return l_number;

Line 279: l_preference_id := FLM_KANBAN_CONSTANTS.INV_HEALTH_PER_GOOD;

275: l_good_inv_health_per varchar(10);
276: l_preference_id number;
277: l_number number;
278: begin
279: l_preference_id := FLM_KANBAN_CONSTANTS.INV_HEALTH_PER_GOOD;
280: l_level_id := get_preference_level_id(l_preference_id, p_org_id);
281: l_good_inv_health_per := get_ekb_preference_value(l_level_id, l_preference_id, null);
282: l_number := to_number(l_good_inv_health_per);
283: return l_number;

Line 294: l_preference_id := FLM_KANBAN_CONSTANTS.INV_HEALTH_PER_BAD;

290: l_bad_inv_health_per varchar(10);
291: l_preference_id number;
292: l_number number;
293: begin
294: l_preference_id := FLM_KANBAN_CONSTANTS.INV_HEALTH_PER_BAD;
295: l_level_id := get_preference_level_id(l_preference_id, p_org_id);
296: l_bad_inv_health_per := get_ekb_preference_value(l_level_id, l_preference_id, null);
297: l_number := to_number(l_bad_inv_health_per);
298: return l_number;

Line 309: l_preference_id := FLM_KANBAN_CONSTANTS.DIST_DEPLOYMENT;

305: l_dist_deployment varchar(10);
306: l_preference_id number;
307: l_number number;
308: begin
309: l_preference_id := FLM_KANBAN_CONSTANTS.DIST_DEPLOYMENT;
310: l_dist_deployment := get_ekb_preference_value(1, l_preference_id, null);
311: l_number := to_number(l_dist_deployment);
312: return l_number;
313: end;

Line 327: and preference_id = FLM_KANBAN_CONSTANTS.UNMOVED_CARD_LEADTIME_PER

323: cursor c_unmovedcard_leadtime(p_level_id number) IS
324: select attribute_name, attribute_value_code
325: from FLM_EKB_PREFERENCE_VALUES
326: where level_id = p_level_id
327: and preference_id = FLM_KANBAN_CONSTANTS.UNMOVED_CARD_LEADTIME_PER
328: and attribute_value_code is NOT NULL;
329:
330: unmovecardtable flm_unmovecard_table;
331: /*This is API will return status and leadtime value combination.

Line 343: l_preference_id := FLM_KANBAN_CONSTANTS.UNMOVED_CARD_LEADTIME_PER;

339: leadtime. At UI level it will be made sure that if a particular status
340: is enabled, then it needs to have a leadtime value AND if is not-enabled
341: then NULL leadtime value*/
342: begin
343: l_preference_id := FLM_KANBAN_CONSTANTS.UNMOVED_CARD_LEADTIME_PER;
344: l_level_id_site := 1;
345: l_level_id := get_preference_level_id(l_preference_id, p_org_id);
346: open c_unmovedcard_leadtime(l_level_id);
347: FETCH c_unmovedcard_leadtime BULK COLLECT INTO unmovecardtable;

Line 369: and preference_id = FLM_KANBAN_CONSTANTS.UNMOVED_CARD_LEADTIME_PER

365: cursor c_unmovedcard_enb_status(p_level_id number) IS
366: select attribute_name
367: from FLM_EKB_PREFERENCE_VALUES
368: where level_id = p_level_id
369: and preference_id = FLM_KANBAN_CONSTANTS.UNMOVED_CARD_LEADTIME_PER
370: and nvl(attribute_enable_flag,1) = 1;
371:
372: unmovecardtable flm_unmovecard_enb_status_t;
373: /*Bug 12623839: This API will return statuses that are enabled

Line 377: l_preference_id := FLM_KANBAN_CONSTANTS.UNMOVED_CARD_LEADTIME_PER;

373: /*Bug 12623839: This API will return statuses that are enabled
374: based on the column attribute_enable_flag.*/
375:
376: begin
377: l_preference_id := FLM_KANBAN_CONSTANTS.UNMOVED_CARD_LEADTIME_PER;
378: l_level_id_site := 1;
379: l_level_id := get_preference_level_id(l_preference_id, p_org_id);
380: open c_unmovedcard_enb_status(l_level_id);
381: FETCH c_unmovedcard_enb_status BULK COLLECT INTO unmovecardtable;

Line 473: if(p_preference_id = FLM_KANBAN_CONSTANTS.CUSTOM_PANEL

469: end if;
470: for c_multi_val_cp in multi_value_custom_panel(p_org_id) loop
471: l_multi_val_cnt_cp := c_multi_val_cp.multi_value_count;
472: end loop;
473: if(p_preference_id = FLM_KANBAN_CONSTANTS.CUSTOM_PANEL
474: and l_return_val = 'INHERIT'
475: and l_level_code = 1
476: and l_multi_val_cnt_cp > 0) then
477: l_return_val := 'NOTENTERED';