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.MSC_PUBLISH_SAFETY_STOCK_PKG dependencies on MSC_X_UTIL

Line 2004: l_bucket_type_desc := msc_x_util.get_lookup_meaning('MSC_X_BUCKET_TYPE',t_bucket_type(j));

2000: t_item_id(j) <> t_item_id(j-1) OR
2001: t_bucket_index(j) - nvl(t_bucket_index(j-1), t_bucket_index(j) -1) = 1 )))THEN
2002:
2003: l_order_type_desc := get_order_type (SAFETY_STOCK);
2004: l_bucket_type_desc := msc_x_util.get_lookup_meaning('MSC_X_BUCKET_TYPE',t_bucket_type(j));
2005: --dbms_output.Put_line('HERE insert ' || t_qty(j) || ' DATE ' || t_key_date(j));
2006: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'safety stock: ' || t_qty(j) || ' date ' || t_key_date(j));
2007: --dbms_output.put_line('Org ' || t_org_id(j) || 'SR ' || t_sr_instance_id(j) || 'Bucket ' ||t_bucket_type(j) || 'Key date ' || t_key_date(j));
2008:

Line 2142: l_order_type_desc := msc_x_util.get_lookup_meaning ('MSC_X_ORDER_TYPE', SAFETY_STOCK);

2138: l_qty := t_qty(j-1);
2139:
2140: END IF;
2141:
2142: l_order_type_desc := msc_x_util.get_lookup_meaning ('MSC_X_ORDER_TYPE', SAFETY_STOCK);
2143: l_bucket_type_desc := msc_x_util.get_lookup_meaning('MSC_X_BUCKET_TYPE',b_bkt_type(k));
2144: --dbms_output.Put_line('insert for the gap ' || t_qty(j));
2145:
2146:

Line 2143: l_bucket_type_desc := msc_x_util.get_lookup_meaning('MSC_X_BUCKET_TYPE',b_bkt_type(k));

2139:
2140: END IF;
2141:
2142: l_order_type_desc := msc_x_util.get_lookup_meaning ('MSC_X_ORDER_TYPE', SAFETY_STOCK);
2143: l_bucket_type_desc := msc_x_util.get_lookup_meaning('MSC_X_BUCKET_TYPE',b_bkt_type(k));
2144: --dbms_output.Put_line('insert for the gap ' || t_qty(j));
2145:
2146:
2147: /**l_prev_work_date := msc_calendar.prev_work_day(t_org_id(j),

Line 2277: l_order_type_desc := msc_x_util.get_lookup_meaning ('MSC_X_ORDER_TYPE', SAFETY_STOCK);

2273:
2274: IF (k > 1) THEN
2275: l_qty := t_qty(j-1);
2276:
2277: l_order_type_desc := msc_x_util.get_lookup_meaning ('MSC_X_ORDER_TYPE', SAFETY_STOCK);
2278: l_bucket_type_desc := msc_x_util.get_lookup_meaning('MSC_X_BUCKET_TYPE',b_bkt_type(k));
2279:
2280: IF (b_bkt_end_date(k) >= p_horizon_start and b_bkt_end_date(k) <= p_horizon_end ) THEN
2281: insert into msc_sup_dem_entries (

Line 2278: l_bucket_type_desc := msc_x_util.get_lookup_meaning('MSC_X_BUCKET_TYPE',b_bkt_type(k));

2274: IF (k > 1) THEN
2275: l_qty := t_qty(j-1);
2276:
2277: l_order_type_desc := msc_x_util.get_lookup_meaning ('MSC_X_ORDER_TYPE', SAFETY_STOCK);
2278: l_bucket_type_desc := msc_x_util.get_lookup_meaning('MSC_X_BUCKET_TYPE',b_bkt_type(k));
2279:
2280: IF (b_bkt_end_date(k) >= p_horizon_start and b_bkt_end_date(k) <= p_horizon_end ) THEN
2281: insert into msc_sup_dem_entries (
2282: transaction_id,

Line 2396: l_order_type_desc := msc_x_util.get_lookup_meaning ('MSC_X_ORDER_TYPE', SAFETY_STOCK);

2392:
2393: IF (k > 1) THEN
2394: l_qty := t_qty(j);
2395:
2396: l_order_type_desc := msc_x_util.get_lookup_meaning ('MSC_X_ORDER_TYPE', SAFETY_STOCK);
2397: l_bucket_type_desc := msc_x_util.get_lookup_meaning('MSC_X_BUCKET_TYPE',b_bkt_type(k));
2398:
2399: IF (b_bkt_end_date(k) >= p_horizon_start and b_bkt_end_date(k) <= p_horizon_end ) THEN
2400: insert into msc_sup_dem_entries (

Line 2397: l_bucket_type_desc := msc_x_util.get_lookup_meaning('MSC_X_BUCKET_TYPE',b_bkt_type(k));

2393: IF (k > 1) THEN
2394: l_qty := t_qty(j);
2395:
2396: l_order_type_desc := msc_x_util.get_lookup_meaning ('MSC_X_ORDER_TYPE', SAFETY_STOCK);
2397: l_bucket_type_desc := msc_x_util.get_lookup_meaning('MSC_X_BUCKET_TYPE',b_bkt_type(k));
2398:
2399: IF (b_bkt_end_date(k) >= p_horizon_start and b_bkt_end_date(k) <= p_horizon_end ) THEN
2400: insert into msc_sup_dem_entries (
2401: transaction_id,

Line 2528: l_bucket_type_desc := msc_x_util.get_lookup_meaning('MSC_X_BUCKET_TYPE',1);

2524: l_exp_qty:= 0;
2525: END IF;
2526: l_total:= t_total_qty(j) - l_exp_qty;
2527: FND_FILE.PUT_LINE(FND_FILE.LOG, 'total ' || l_total || ' item ' || t_item_id(j) || ' Key date ' || t_key_date(j));
2528: l_bucket_type_desc := msc_x_util.get_lookup_meaning('MSC_X_BUCKET_TYPE',1);
2529:
2530: IF (trunc(t_key_date(j)) >= trunc(p_horizon_start)) THEN
2531: update msc_sup_dem_entries
2532: set quantity = l_total,

Line 2543: l_bucket_type_desc := msc_x_util.get_lookup_meaning('MSC_X_BUCKET_TYPE',t_bucket_type(j));

2539:
2540:
2541: l_rowcount := sql%ROWCOUNT;
2542:
2543: l_bucket_type_desc := msc_x_util.get_lookup_meaning('MSC_X_BUCKET_TYPE',t_bucket_type(j));
2544: IF l_rowcount = 0 THEN
2545: FND_FILE.PUT_LINE(FND_FILE.LOG, 'row count = 0' || 'Pub ' || t_pub(j) || 'Pub id ' || t_pub_id(j));
2546: --dbms_output.put_line('row count = 0'|| 'Pub ' || t_pub(j) || 'Pub id ' || t_pub_id(j));
2547: insert into msc_sup_dem_entries (

Line 2693: l_order_type_desc := msc_x_util.get_lookup_meaning ('MSC_X_ORDER_TYPE', PROJECTED_AVAILABLE_BALANCE);

2689: END IF;
2690: l_total:= t_total_qty(j-1) - l_exp_qty;
2691: END IF;
2692:
2693: l_order_type_desc := msc_x_util.get_lookup_meaning ('MSC_X_ORDER_TYPE', PROJECTED_AVAILABLE_BALANCE);
2694: l_bucket_type_desc := msc_x_util.get_lookup_meaning('MSC_X_BUCKET_TYPE',b_bkt_type(k));
2695: --dbms_output.Put_line('fill gap ' || t_qty(j));
2696: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'pab: ' || t_qty(j) || 'date ' || t_key_date(j));
2697:

Line 2694: l_bucket_type_desc := msc_x_util.get_lookup_meaning('MSC_X_BUCKET_TYPE',b_bkt_type(k));

2690: l_total:= t_total_qty(j-1) - l_exp_qty;
2691: END IF;
2692:
2693: l_order_type_desc := msc_x_util.get_lookup_meaning ('MSC_X_ORDER_TYPE', PROJECTED_AVAILABLE_BALANCE);
2694: l_bucket_type_desc := msc_x_util.get_lookup_meaning('MSC_X_BUCKET_TYPE',b_bkt_type(k));
2695: --dbms_output.Put_line('fill gap ' || t_qty(j));
2696: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'pab: ' || t_qty(j) || 'date ' || t_key_date(j));
2697:
2698: /*

Line 2815: l_bucket_type_desc := msc_x_util.get_lookup_meaning('MSC_X_BUCKET_TYPE',t_bucket_type(j));

2811: END IF;
2812:
2813: l_total := t_total_qty(j);
2814:
2815: l_bucket_type_desc := msc_x_util.get_lookup_meaning('MSC_X_BUCKET_TYPE',t_bucket_type(j));
2816:
2817: IF ( t_key_date(j) >= p_horizon_start) THEN
2818: insert into msc_sup_dem_entries (
2819: transaction_id,

Line 2933: l_bucket_type_desc := msc_x_util.get_lookup_meaning('MSC_X_BUCKET_TYPE',t_bucket_type(j));

2929:
2930:
2931: l_rowcount := sql%ROWCOUNT;
2932:
2933: l_bucket_type_desc := msc_x_util.get_lookup_meaning('MSC_X_BUCKET_TYPE',t_bucket_type(j));
2934: IF l_rowcount = 0 THEN
2935: FND_FILE.PUT_LINE(FND_FILE.LOG, 'row count = 0' || 'Pub ' || t_pub(j) || 'Pub id ' || t_pub_id(j));
2936: --dbms_output.put_line('row count = 0'|| 'Pub ' || t_pub(j) || 'Pub id ' || t_pub_id(j));
2937: insert into msc_sup_dem_entries (

Line 3058: l_order_type_desc := msc_x_util.get_lookup_meaning ('MSC_X_ORDER_TYPE', PROJECTED_AVAILABLE_BALANCE);

3054: l_exp_qty:= 0;
3055: END IF;
3056: l_total := t_total_qty(j-1) - l_exp_qty;
3057:
3058: l_order_type_desc := msc_x_util.get_lookup_meaning ('MSC_X_ORDER_TYPE', PROJECTED_AVAILABLE_BALANCE);
3059: l_bucket_type_desc := msc_x_util.get_lookup_meaning('MSC_X_BUCKET_TYPE',b_bkt_type(k));
3060:
3061: IF (b_bkt_end_date(k) >= p_horizon_start and b_bkt_end_date(k) <= p_horizon_end ) THEN
3062:

Line 3059: l_bucket_type_desc := msc_x_util.get_lookup_meaning('MSC_X_BUCKET_TYPE',b_bkt_type(k));

3055: END IF;
3056: l_total := t_total_qty(j-1) - l_exp_qty;
3057:
3058: l_order_type_desc := msc_x_util.get_lookup_meaning ('MSC_X_ORDER_TYPE', PROJECTED_AVAILABLE_BALANCE);
3059: l_bucket_type_desc := msc_x_util.get_lookup_meaning('MSC_X_BUCKET_TYPE',b_bkt_type(k));
3060:
3061: IF (b_bkt_end_date(k) >= p_horizon_start and b_bkt_end_date(k) <= p_horizon_end ) THEN
3062:
3063: insert into msc_sup_dem_entries (

Line 3186: l_order_type_desc := msc_x_util.get_lookup_meaning ('MSC_X_ORDER_TYPE', PROJECTED_AVAILABLE_BALANCE);

3182: l_exp_qty:= 0;
3183: END IF;
3184: l_total:= t_total_qty(j) - l_exp_qty;
3185:
3186: l_order_type_desc := msc_x_util.get_lookup_meaning ('MSC_X_ORDER_TYPE', PROJECTED_AVAILABLE_BALANCE);
3187: l_bucket_type_desc := msc_x_util.get_lookup_meaning('MSC_X_BUCKET_TYPE',b_bkt_type(k));
3188:
3189: IF (b_bkt_end_date(k) >= p_horizon_start and b_bkt_end_date(k) <= p_horizon_end ) THEN
3190:

Line 3187: l_bucket_type_desc := msc_x_util.get_lookup_meaning('MSC_X_BUCKET_TYPE',b_bkt_type(k));

3183: END IF;
3184: l_total:= t_total_qty(j) - l_exp_qty;
3185:
3186: l_order_type_desc := msc_x_util.get_lookup_meaning ('MSC_X_ORDER_TYPE', PROJECTED_AVAILABLE_BALANCE);
3187: l_bucket_type_desc := msc_x_util.get_lookup_meaning('MSC_X_BUCKET_TYPE',b_bkt_type(k));
3188:
3189: IF (b_bkt_end_date(k) >= p_horizon_start and b_bkt_end_date(k) <= p_horizon_end ) THEN
3190:
3191: insert into msc_sup_dem_entries (