APPS.WIP_BIS_UTZ_ALERT dependencies on WIP_BIS_UTZ_ALERT

Line 1: PACKAGE BODY WIP_BIS_UTZ_ALERT AS

1: PACKAGE BODY WIP_BIS_UTZ_ALERT AS
2: /* $Header: wipbiuab.pls 115.22 2004/04/14 13:49:49 achandak ship $ */
3:
4: /*
5: * PostActual

Line 194: WIP_BIS_UTZ_ALERT.PostActual(

190: DBMS_SQL.COLUMN_VALUE( cursor_id, 4, v_geography );
191: DBMS_SQL.COLUMN_VALUE( cursor_id, 5, v_product );
192: DBMS_SQL.COLUMN_VALUE( cursor_id, 6, v_actual );
193:
194: WIP_BIS_UTZ_ALERT.PostActual(
195: target_level_id,
196: v_time,
197: v_org,
198: v_geography,

Line 849: WIP_BIS_UTZ_ALERT.StartFlow(

845:
846: /* do the range checking */
847: if ( v_actual < v_target*(1-(v_range1_low/100)) OR
848: v_actual > v_target*(1+(v_range1_high/100)) ) then
849: WIP_BIS_UTZ_ALERT.StartFlow(
850: v_time, v_start_date, v_end_date,
851: v_org, v_geography, v_product, v_prod_id,
852: v_sob_name, v_le_name, v_ou_name, v_org_name,
853: v_area_name, v_country_name, v_country_id, v_region_name,

Line 863: WIP_BIS_UTZ_ALERT.StartFlow(

859: end if;
860:
861: if ( v_actual < v_target*(1-(v_range2_low/100)) OR
862: v_actual > v_target*(1+(v_range2_high/100)) ) then
863: WIP_BIS_UTZ_ALERT.StartFlow(
864: v_time, v_start_date, v_end_date,
865: v_org, v_geography, v_product, v_prod_id,
866: v_sob_name, v_le_name, v_ou_name, v_org_name,
867: v_area_name, v_country_name, v_country_id, v_region_name,

Line 877: WIP_BIS_UTZ_ALERT.StartFlow(

873: end if;
874:
875: if ( v_actual < v_target*(1-(v_range3_low/100)) OR
876: v_actual > v_target*(1+(v_range3_high/100)) ) then
877: WIP_BIS_UTZ_ALERT.StartFlow(
878: v_time, v_start_date, v_end_date,
879: v_org, v_geography, v_product, v_prod_id,
880: v_sob_name, v_le_name, v_ou_name, v_org_name,
881: v_area_name, v_country_name, v_country_id, v_region_name,

Line 1093: WIP_BIS_UTZ_ALERT.PostLevelActuals(tl_rec.target_level_id,

1089: BEGIN
1090:
1091: FOR tl_rec in get_target_level LOOP
1092:
1093: WIP_BIS_UTZ_ALERT.PostLevelActuals(tl_rec.target_level_id,
1094: tl_rec.time_value,
1095: tl_rec.org_value, tl_rec.geo_value,
1096: tl_rec.prod_value);
1097: WIP_BIS_UTZ_ALERT.CompareLevelTarget(tl_rec.target_level_id,

Line 1097: WIP_BIS_UTZ_ALERT.CompareLevelTarget(tl_rec.target_level_id,

1093: WIP_BIS_UTZ_ALERT.PostLevelActuals(tl_rec.target_level_id,
1094: tl_rec.time_value,
1095: tl_rec.org_value, tl_rec.geo_value,
1096: tl_rec.prod_value);
1097: WIP_BIS_UTZ_ALERT.CompareLevelTarget(tl_rec.target_level_id,
1098: tl_rec.time_value, tl_rec.org_value,
1099: tl_rec.geo_value, tl_rec.prod_value);
1100: END LOOP;
1101:

Line 1104: END WIP_BIS_UTZ_ALERT;

1100: END LOOP;
1101:
1102: END Alert_Check;
1103:
1104: END WIP_BIS_UTZ_ALERT;