275: status Varchar2(30);
276: l_param varchar2(2000);
277: BEGIN
278:
279: l_subject := fnd_message.get_string('WIP', 'WIP_BIS_WK_SUBJECT');
280: l_sob := fnd_message.get_string('WIP', 'SET_OF_BOOKS') || ': ' || sob;
281: l_le := fnd_message.get_string('WIP', 'WIP_LEGAL_ENTITY') || ': ' || le;
282: l_ou := fnd_message.get_string('BOM', 'CST_OPERATING_UNIT_LABEL') ||
283: ': ' || ou;
276: l_param varchar2(2000);
277: BEGIN
278:
279: l_subject := fnd_message.get_string('WIP', 'WIP_BIS_WK_SUBJECT');
280: l_sob := fnd_message.get_string('WIP', 'SET_OF_BOOKS') || ': ' || sob;
281: l_le := fnd_message.get_string('WIP', 'WIP_LEGAL_ENTITY') || ': ' || le;
282: l_ou := fnd_message.get_string('BOM', 'CST_OPERATING_UNIT_LABEL') ||
283: ': ' || ou;
284: l_org := fnd_message.get_string('WIP', 'INVENTORY_ORGANIZATION') ||
277: BEGIN
278:
279: l_subject := fnd_message.get_string('WIP', 'WIP_BIS_WK_SUBJECT');
280: l_sob := fnd_message.get_string('WIP', 'SET_OF_BOOKS') || ': ' || sob;
281: l_le := fnd_message.get_string('WIP', 'WIP_LEGAL_ENTITY') || ': ' || le;
282: l_ou := fnd_message.get_string('BOM', 'CST_OPERATING_UNIT_LABEL') ||
283: ': ' || ou;
284: l_org := fnd_message.get_string('WIP', 'INVENTORY_ORGANIZATION') ||
285: ': ' || org;
278:
279: l_subject := fnd_message.get_string('WIP', 'WIP_BIS_WK_SUBJECT');
280: l_sob := fnd_message.get_string('WIP', 'SET_OF_BOOKS') || ': ' || sob;
281: l_le := fnd_message.get_string('WIP', 'WIP_LEGAL_ENTITY') || ': ' || le;
282: l_ou := fnd_message.get_string('BOM', 'CST_OPERATING_UNIT_LABEL') ||
283: ': ' || ou;
284: l_org := fnd_message.get_string('WIP', 'INVENTORY_ORGANIZATION') ||
285: ': ' || org;
286: l_area := fnd_message.get_string('BOM', 'CST_AREA_LABEL') || ': ' || area;
280: l_sob := fnd_message.get_string('WIP', 'SET_OF_BOOKS') || ': ' || sob;
281: l_le := fnd_message.get_string('WIP', 'WIP_LEGAL_ENTITY') || ': ' || le;
282: l_ou := fnd_message.get_string('BOM', 'CST_OPERATING_UNIT_LABEL') ||
283: ': ' || ou;
284: l_org := fnd_message.get_string('WIP', 'INVENTORY_ORGANIZATION') ||
285: ': ' || org;
286: l_area := fnd_message.get_string('BOM', 'CST_AREA_LABEL') || ': ' || area;
287: l_country := fnd_message.get_string('BOM', 'CST_COUNTRY_LABEL') ||
288: ': ' || country;
282: l_ou := fnd_message.get_string('BOM', 'CST_OPERATING_UNIT_LABEL') ||
283: ': ' || ou;
284: l_org := fnd_message.get_string('WIP', 'INVENTORY_ORGANIZATION') ||
285: ': ' || org;
286: l_area := fnd_message.get_string('BOM', 'CST_AREA_LABEL') || ': ' || area;
287: l_country := fnd_message.get_string('BOM', 'CST_COUNTRY_LABEL') ||
288: ': ' || country;
289: l_prod_cat := fnd_message.get_string('WIP', 'WIP_PROD_CATEGORY')
290: || ': ' || prod;
283: ': ' || ou;
284: l_org := fnd_message.get_string('WIP', 'INVENTORY_ORGANIZATION') ||
285: ': ' || org;
286: l_area := fnd_message.get_string('BOM', 'CST_AREA_LABEL') || ': ' || area;
287: l_country := fnd_message.get_string('BOM', 'CST_COUNTRY_LABEL') ||
288: ': ' || country;
289: l_prod_cat := fnd_message.get_string('WIP', 'WIP_PROD_CATEGORY')
290: || ': ' || prod;
291: l_prod := fnd_message.get_string('BOM', 'CST_PRODUCT_LABEL') ||
285: ': ' || org;
286: l_area := fnd_message.get_string('BOM', 'CST_AREA_LABEL') || ': ' || area;
287: l_country := fnd_message.get_string('BOM', 'CST_COUNTRY_LABEL') ||
288: ': ' || country;
289: l_prod_cat := fnd_message.get_string('WIP', 'WIP_PROD_CATEGORY')
290: || ': ' || prod;
291: l_prod := fnd_message.get_string('BOM', 'CST_PRODUCT_LABEL') ||
292: ': ' || item;
293: l_period := fnd_message.get_string('WIP', 'WIP_PERIOD')
287: l_country := fnd_message.get_string('BOM', 'CST_COUNTRY_LABEL') ||
288: ': ' || country;
289: l_prod_cat := fnd_message.get_string('WIP', 'WIP_PROD_CATEGORY')
290: || ': ' || prod;
291: l_prod := fnd_message.get_string('BOM', 'CST_PRODUCT_LABEL') ||
292: ': ' || item;
293: l_period := fnd_message.get_string('WIP', 'WIP_PERIOD')
294: || ': ' || time_level_value;
295: l_actual := fnd_message.get_string('WIP', 'WIP_ACTUAL')
289: l_prod_cat := fnd_message.get_string('WIP', 'WIP_PROD_CATEGORY')
290: || ': ' || prod;
291: l_prod := fnd_message.get_string('BOM', 'CST_PRODUCT_LABEL') ||
292: ': ' || item;
293: l_period := fnd_message.get_string('WIP', 'WIP_PERIOD')
294: || ': ' || time_level_value;
295: l_actual := fnd_message.get_string('WIP', 'WIP_ACTUAL')
296: || ': ' || round(actual, 2);
297: l_target := fnd_message.get_string('WIP', 'WIP_TARGET')
291: l_prod := fnd_message.get_string('BOM', 'CST_PRODUCT_LABEL') ||
292: ': ' || item;
293: l_period := fnd_message.get_string('WIP', 'WIP_PERIOD')
294: || ': ' || time_level_value;
295: l_actual := fnd_message.get_string('WIP', 'WIP_ACTUAL')
296: || ': ' || round(actual, 2);
297: l_target := fnd_message.get_string('WIP', 'WIP_TARGET')
298: || ': ' || round(target, 2);
299:
293: l_period := fnd_message.get_string('WIP', 'WIP_PERIOD')
294: || ': ' || time_level_value;
295: l_actual := fnd_message.get_string('WIP', 'WIP_ACTUAL')
296: || ': ' || round(actual, 2);
297: l_target := fnd_message.get_string('WIP', 'WIP_TARGET')
298: || ': ' || round(target, 2);
299:
300: l_param := 'P_PARAM_FROM_DATE=' ||
301: to_char(start_date, 'DD-MON-YYYY') ||
442: l_resp_name VARCHAR2(100);
443: BEGIN
444:
445: /* initialize the all text */
446: all_text := '''' || FND_MESSAGE.get_string('WIP', 'WIP_ALL') || '''';
447:
448: p_select_sob_name := all_text;
449: p_select_le_name := all_text;
450: p_select_ou_name := all_text;