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.POA_BIS_ALERTS dependencies on POA_BIS_ALERTS

Line 1: PACKAGE BODY POA_BIS_ALERTS AS

1: PACKAGE BODY POA_BIS_ALERTS AS
2: /* $Header: poaalrtb.pls 115.9 2003/03/15 00:22:54 jhou ship $ */
3:
4: PROCEDURE get_target_value(
5: p_target_level_short_name IN VARCHAR2,

Line 306: POA_BIS_ALERTS.g_percent_mask),

302: SELECT
303: TO_CHAR(DECODE(SUM(NVL(poa.purchase_amount,0)*NVL(gl.conversion_rate,1)),
304: 0,0,100*SUM(NVL(poa.pot_contract_amount,0) *NVL(gl.conversion_rate,1))/
305: SUM(NVL(poa.purchase_amount,0)*NVL(gl.conversion_rate,1))),
306: POA_BIS_ALERTS.g_percent_mask),
307: TO_CHAR(SUM(NVL(poa.purchase_amount,0)*NVL(gl.conversion_rate,1)),
308: l_format_mask),
309: TO_CHAR(SUM(NVL(poa.potential_saving,0)*NVL(gl.conversion_rate,1)),
310: l_format_mask),

Line 363: POA_BIS_ALERTS.g_percent_mask),

359: SELECT
360: TO_CHAR(DECODE(SUM(NVL(poa.purchase_amount,0)*NVL(gl.conversion_rate,1)),
361: 0,0,100*SUM(NVL(poa.pot_contract_amount,0) *NVL(gl.conversion_rate,1))/
362: SUM(NVL(poa.purchase_amount,0)*NVL(gl.conversion_rate,1))),
363: POA_BIS_ALERTS.g_percent_mask),
364: TO_CHAR(SUM(NVL(poa.purchase_amount,0)*NVL(gl.conversion_rate,1)),
365: l_format_mask),
366: TO_CHAR(SUM(NVL(poa.potential_saving,0)*NVL(gl.conversion_rate,1)),
367: l_format_mask),

Line 421: POA_BIS_ALERTS.g_percent_mask),

417: SELECT
418: TO_CHAR(DECODE(SUM(NVL(poa.purchase_amount,0)*NVL(gl.conversion_rate,1)),
419: 0,0,100*SUM(NVL(poa.pot_contract_amount,0) *NVL(gl.conversion_rate,1))/
420: SUM(NVL(poa.purchase_amount,0)*NVL(gl.conversion_rate,1))),
421: POA_BIS_ALERTS.g_percent_mask),
422: TO_CHAR(SUM(NVL(poa.purchase_amount,0)*NVL(gl.conversion_rate,1)),
423: l_format_mask),
424: TO_CHAR(SUM(NVL(poa.potential_saving,0)*NVL(gl.conversion_rate,1)),
425: l_format_mask),

Line 475: POA_BIS_ALERTS.g_percent_mask) Actual

471: SELECT
472: TO_CHAR(decode(sum(poa.sales_amount), NULL, 0,0,0,
473: nvl(100*sum((poa.purchase_amount)*nvl(gl.conversion_rate,1))/
474: nvl(sum((poa.sales_amount)*nvl(gl.conversion_rate,1)),1),0)),
475: POA_BIS_ALERTS.g_percent_mask) Actual
476: INTO l_actual
477: FROM poa_purchase_sales_v poa,
478: gl_daily_rates gl
479: WHERE gl.from_currency (+) = poa.currency

Line 512: POA_BIS_ALERTS.g_percent_mask) Actual

508: SELECT
509: TO_CHAR(decode(sum(poa.sales_amount), NULL, 0,0,0,
510: nvl(100*sum((poa.purchase_amount)*nvl(gl.conversion_rate,1))/
511: nvl(sum((poa.sales_amount)*nvl(gl.conversion_rate,1)),1),0)),
512: POA_BIS_ALERTS.g_percent_mask) Actual
513: INTO l_actual
514: FROM poa_purchase_sales_v poa,
515: gl_daily_rates gl
516: WHERE gl.from_currency (+) = poa.currency

Line 870: to_char(l_target_rec.target,POA_BIS_ALERTS.g_percent_mask) || ')',

866: insert_row('L_SUBJECT', fnd_message.get_string('POA',
867: 'POA_' || UPPER(l_measure_short_name) || '_SUBJECT'), '(' ||
868: fnd_message.get_string('PO','POA_ACTUAL') || ': ' || l_value ||
869: ' ' || fnd_message.get_string('PO','POA_TARGET') || ': ' ||
870: to_char(l_target_rec.target,POA_BIS_ALERTS.g_percent_mask) || ')',
871: l_value_tbl);
872: insert_row('L_TARGET_LEVEL',
873: fnd_message.get_string('POA','POA_TARGET_LEVEL'),
874: l_target_level_name, l_value_tbl);

Line 885: to_char(l_target_rec.target, POA_BIS_ALERTS.g_percent_mask),

881: fnd_message.get_string('PO','POA_PERIOD'), l_period_name,
882: l_value_tbl);
883: insert_row('L_TARGET',
884: fnd_message.get_string('PO','POA_TARGET'),
885: to_char(l_target_rec.target, POA_BIS_ALERTS.g_percent_mask),
886: l_value_tbl);
887: insert_row('L_TARGET_RANGE',
888: fnd_message.get_string('POA','POA_TARGET_RANGE'),
889: to_char(l_range_low, POA_BIS_ALERTS.g_percent_mask) || ' - ' ||

Line 889: to_char(l_range_low, POA_BIS_ALERTS.g_percent_mask) || ' - ' ||

885: to_char(l_target_rec.target, POA_BIS_ALERTS.g_percent_mask),
886: l_value_tbl);
887: insert_row('L_TARGET_RANGE',
888: fnd_message.get_string('POA','POA_TARGET_RANGE'),
889: to_char(l_range_low, POA_BIS_ALERTS.g_percent_mask) || ' - ' ||
890: to_char(l_range_high,POA_BIS_ALERTS.g_percent_mask),l_value_tbl);
891: insert_row('L_THANKS',
892: fnd_message.get_string('POA','POA_THANKS'), NULL, l_value_tbl);
893: insert_row('L_SENDER', l_app_name, NULL, l_value_tbl);

Line 890: to_char(l_range_high,POA_BIS_ALERTS.g_percent_mask),l_value_tbl);

886: l_value_tbl);
887: insert_row('L_TARGET_RANGE',
888: fnd_message.get_string('POA','POA_TARGET_RANGE'),
889: to_char(l_range_low, POA_BIS_ALERTS.g_percent_mask) || ' - ' ||
890: to_char(l_range_high,POA_BIS_ALERTS.g_percent_mask),l_value_tbl);
891: insert_row('L_THANKS',
892: fnd_message.get_string('POA','POA_THANKS'), NULL, l_value_tbl);
893: insert_row('L_SENDER', l_app_name, NULL, l_value_tbl);
894: get_report_param(p_target_level_short_name,

Line 917: to_char(l_range_low, POA_BIS_ALERTS.g_percent_mask) || ' - ' ||

913: IF (l_actual NOT BETWEEN l_range_low AND l_range_high) THEN
914: POA_LOG.debug_line('Outside Range 2');
915: set_value('L_TARGET_RANGE',
916: fnd_message.get_string('POA','POA_TARGET_RANGE'),
917: to_char(l_range_low, POA_BIS_ALERTS.g_percent_mask) || ' - ' ||
918: to_char(l_range_high,POA_BIS_ALERTS.g_percent_mask),l_value_tbl);
919: get_report_param(p_target_level_short_name,
920: to_number(l_target_orgs(l_index).org_level_value_id),
921: l_start_date, l_end_date, l_period_type, l_param);

Line 918: to_char(l_range_high,POA_BIS_ALERTS.g_percent_mask),l_value_tbl);

914: POA_LOG.debug_line('Outside Range 2');
915: set_value('L_TARGET_RANGE',
916: fnd_message.get_string('POA','POA_TARGET_RANGE'),
917: to_char(l_range_low, POA_BIS_ALERTS.g_percent_mask) || ' - ' ||
918: to_char(l_range_high,POA_BIS_ALERTS.g_percent_mask),l_value_tbl);
919: get_report_param(p_target_level_short_name,
920: to_number(l_target_orgs(l_index).org_level_value_id),
921: l_start_date, l_end_date, l_period_type, l_param);
922: set_value('L_URL', fnd_profile.value('ICX_REPORT_LINK') ||

Line 943: to_char(l_range_low, POA_BIS_ALERTS.g_percent_mask) || ' - ' ||

939: IF (l_actual NOT BETWEEN l_range_low AND l_range_high) THEN
940: POA_LOG.debug_line('Outside Range 3');
941: set_value('L_TARGET_RANGE',
942: fnd_message.get_string('POA','POA_TARGET_RANGE'),
943: to_char(l_range_low, POA_BIS_ALERTS.g_percent_mask) || ' - ' ||
944: to_char(l_range_high,POA_BIS_ALERTS.g_percent_mask),l_value_tbl);
945: get_report_param(p_target_level_short_name,
946: to_number(l_target_orgs(l_index).org_level_value_id),
947: l_start_date, l_end_date, l_period_type, l_param);

Line 944: to_char(l_range_high,POA_BIS_ALERTS.g_percent_mask),l_value_tbl);

940: POA_LOG.debug_line('Outside Range 3');
941: set_value('L_TARGET_RANGE',
942: fnd_message.get_string('POA','POA_TARGET_RANGE'),
943: to_char(l_range_low, POA_BIS_ALERTS.g_percent_mask) || ' - ' ||
944: to_char(l_range_high,POA_BIS_ALERTS.g_percent_mask),l_value_tbl);
945: get_report_param(p_target_level_short_name,
946: to_number(l_target_orgs(l_index).org_level_value_id),
947: l_start_date, l_end_date, l_period_type, l_param);
948: set_value('L_URL', fnd_profile.value('ICX_REPORT_LINK') ||

Line 1097: END POA_BIS_ALERTS;

1093: POA_LOG.put_line(sqlcode);
1094: RAISE;
1095: END start_workflow;
1096:
1097: END POA_BIS_ALERTS;