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_SCE_PUBLISH_PKG dependencies on MSC_X_UTIL

Line 1727: msc_x_util.get_uom_conversion_rates( t_uom_code(j),

1723: t_base_item_desc(j) := null;
1724: END;
1725:
1726:
1727: msc_x_util.get_uom_conversion_rates( t_uom_code(j),
1728: t_tp_uom(j),
1729: t_item_id(j),
1730: l_conversion_found,
1731: l_conversion_rate);

Line 1855: l_order_type_desc:=MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',ORDER_FORECAST);

1851: trunc(t_ship_date(j)) = trunc(t_ship_date(j-1)) and
1852: t_order_type(j) = t_order_type(j-1)) THEN
1853:
1854: IF (t_order_type(j) = PLANNED_EXTERNAL_REPAIR_ORDER) THEN
1855: l_order_type_desc:=MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',ORDER_FORECAST);
1856: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));
1857: begin
1858: IF (t_base_item_id(j) is not null) THEN
1859: update msc_sup_dem_entries

Line 1856: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));

1852: t_order_type(j) = t_order_type(j-1)) THEN
1853:
1854: IF (t_order_type(j) = PLANNED_EXTERNAL_REPAIR_ORDER) THEN
1855: l_order_type_desc:=MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',ORDER_FORECAST);
1856: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));
1857: begin
1858: IF (t_base_item_id(j) is not null) THEN
1859: update msc_sup_dem_entries
1860: set quantity = quantity + t_qty(j),

Line 2009: l_order_type_desc:=MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',ORDER_FORECAST);

2005: when others then
2006: null;
2007: end;
2008: ELSIF (t_order_type(j) = EXTERNAL_REPAIR_ORDER) THEN
2009: l_order_type_desc:=MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',ORDER_FORECAST);
2010: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));
2011: begin
2012: IF (t_base_item_id(j) is not null) THEN
2013: update msc_sup_dem_entries

Line 2010: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));

2006: null;
2007: end;
2008: ELSIF (t_order_type(j) = EXTERNAL_REPAIR_ORDER) THEN
2009: l_order_type_desc:=MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',ORDER_FORECAST);
2010: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));
2011: begin
2012: IF (t_base_item_id(j) is not null) THEN
2013: update msc_sup_dem_entries
2014: set quantity = quantity + t_qty(j),

Line 2163: l_order_type_desc:=MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',ORDER_FORECAST);

2159: when others then
2160: null;
2161: end;
2162: ELSIF (t_order_type(j) = PLANNED_NEW_BUY_ORDER) THEN
2163: l_order_type_desc:=MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',ORDER_FORECAST);
2164: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));
2165: begin
2166: IF (t_base_item_id(j) is not null) THEN
2167: update msc_sup_dem_entries

Line 2164: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));

2160: null;
2161: end;
2162: ELSIF (t_order_type(j) = PLANNED_NEW_BUY_ORDER) THEN
2163: l_order_type_desc:=MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',ORDER_FORECAST);
2164: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));
2165: begin
2166: IF (t_base_item_id(j) is not null) THEN
2167: update msc_sup_dem_entries
2168: set quantity = quantity + t_qty(j),

Line 3037: l_order_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',CP_PLANNED_ORDER);

3033: ------------------------------------------------------
3034: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'PLO' || t_planned_order_qty(j) || ' tp '
3035: -- || t_tp_planned_order_qty(j) || 'date ' || t_key_date(j));
3036: log_message('PLO' || t_planned_order_qty(j) || ' tp ' || t_tp_planned_order_qty(j) || 'date ' || t_key_date(j));
3037: l_order_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',CP_PLANNED_ORDER);
3038: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));
3039:
3040: IF ( t_planned_order_qty(j) <> 0 ) THEN
3041: l_planned_order_qty := t_planned_order_qty(j);

Line 3038: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));

3034: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'PLO' || t_planned_order_qty(j) || ' tp '
3035: -- || t_tp_planned_order_qty(j) || 'date ' || t_key_date(j));
3036: log_message('PLO' || t_planned_order_qty(j) || ' tp ' || t_tp_planned_order_qty(j) || 'date ' || t_key_date(j));
3037: l_order_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',CP_PLANNED_ORDER);
3038: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));
3039:
3040: IF ( t_planned_order_qty(j) <> 0 ) THEN
3041: l_planned_order_qty := t_planned_order_qty(j);
3042: l_tp_planned_order_qty := t_planned_order_qty(j);

Line 3174: l_order_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',CP_RELEASED_PLANNED_ORDER);

3170: ----------------------------------------------------------
3171: -- RELEASED_PLANNED_ORDER
3172: ----------------------------------------------------------
3173:
3174: l_order_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',CP_RELEASED_PLANNED_ORDER);
3175: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));
3176: IF (t_released_qty(j) <> 0 ) THEN
3177: l_released_qty := t_released_qty(j);
3178: l_tp_released_qty := t_tp_released_qty(j);

Line 3175: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));

3171: -- RELEASED_PLANNED_ORDER
3172: ----------------------------------------------------------
3173:
3174: l_order_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',CP_RELEASED_PLANNED_ORDER);
3175: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));
3176: IF (t_released_qty(j) <> 0 ) THEN
3177: l_released_qty := t_released_qty(j);
3178: l_tp_released_qty := t_tp_released_qty(j);
3179: IF (t_released_qty(j) < 0 ) THEN

Line 3315: l_order_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',CP_PURCHASE_ORDER_FROM_PLAN);

3311:
3312: ------------------------------------------------------
3313: -- PURCHASE_ORDER_FROM_PLAN
3314: ------------------------------------------------------
3315: l_order_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',CP_PURCHASE_ORDER_FROM_PLAN);
3316: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));
3317:
3318: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'Po ' || t_qty(j) || ' tp ' || t_tp_qty(j)
3319: --|| 'date ' || t_key_date(j));

Line 3316: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));

3312: ------------------------------------------------------
3313: -- PURCHASE_ORDER_FROM_PLAN
3314: ------------------------------------------------------
3315: l_order_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',CP_PURCHASE_ORDER_FROM_PLAN);
3316: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));
3317:
3318: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'Po ' || t_qty(j) || ' tp ' || t_tp_qty(j)
3319: --|| 'date ' || t_key_date(j));
3320: log_message( 'Po ' || t_qty(j) || ' tp ' || t_tp_qty(j) || 'date ' || t_key_date(j));

Line 3451: l_order_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',CP_PLANNED_INBOUND_SHIPMENT);

3447: ---------------------------------------------------------
3448: -- EXPECTED_INBOUND_SHIPMENT (PLANNED_INBOUND_SHIPMENT)
3449: ---------------------------------------------------------
3450:
3451: l_order_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',CP_PLANNED_INBOUND_SHIPMENT);
3452: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));
3453:
3454: IF ( t_planned_order_qty(j) <> 0 ) THEN
3455: l_planned_order_qty := t_planned_order_qty(j);

Line 3452: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));

3448: -- EXPECTED_INBOUND_SHIPMENT (PLANNED_INBOUND_SHIPMENT)
3449: ---------------------------------------------------------
3450:
3451: l_order_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',CP_PLANNED_INBOUND_SHIPMENT);
3452: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));
3453:
3454: IF ( t_planned_order_qty(j) <> 0 ) THEN
3455: l_planned_order_qty := t_planned_order_qty(j);
3456: l_tp_planned_order_qty := t_planned_order_qty(j);

Line 3590: l_order_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',CP_RELEASED_INBOUND_SHIPMENT);

3586: ----------------------------------------------------------
3587: -- CP_RELEASED_INBOUND_SHIPMENT (qty released from PIS)
3588: ----------------------------------------------------------
3589:
3590: l_order_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',CP_RELEASED_INBOUND_SHIPMENT);
3591: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));
3592: IF (t_released_qty(j) <> 0 ) THEN
3593: l_released_qty := t_released_qty(j);
3594: l_tp_released_qty := t_tp_released_qty(j);

Line 3591: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));

3587: -- CP_RELEASED_INBOUND_SHIPMENT (qty released from PIS)
3588: ----------------------------------------------------------
3589:
3590: l_order_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',CP_RELEASED_INBOUND_SHIPMENT);
3591: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));
3592: IF (t_released_qty(j) <> 0 ) THEN
3593: l_released_qty := t_released_qty(j);
3594: l_tp_released_qty := t_tp_released_qty(j);
3595: IF (t_released_qty(j) < 0 ) THEN

Line 3733: l_order_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',ORDER_FORECAST);

3729: ---------------------------------------------------*/
3730: ELSE
3731:
3732: FND_FILE.PUT_LINE(FND_FILE.LOG, 'qty ' || t_qty(j) || ' tp ' || t_tp_qty(j)|| 'date ' || t_key_date(j) || ' Item ' || t_item_id(j) || ' base ' || t_base_item_id(j));
3733: l_order_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',ORDER_FORECAST);
3734: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));
3735:
3736: IF (t_base_item_id(j) is null) THEN
3737: l_item_id := t_item_id(j);

Line 3734: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));

3730: ELSE
3731:
3732: FND_FILE.PUT_LINE(FND_FILE.LOG, 'qty ' || t_qty(j) || ' tp ' || t_tp_qty(j)|| 'date ' || t_key_date(j) || ' Item ' || t_item_id(j) || ' base ' || t_base_item_id(j));
3733: l_order_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',ORDER_FORECAST);
3734: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));
3735:
3736: IF (t_base_item_id(j) is null) THEN
3737: l_item_id := t_item_id(j);
3738: l_base_item_name := null;

Line 3910: l_order_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',CP_PLANNED_ORDER);

3906: ------------------------------------------------------
3907: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'PLO' || t_planned_order_qty(j) || ' tp '
3908: -- || t_tp_planned_order_qty(j) || 'date ' || t_key_date(j));
3909: log_message('PLO' || t_planned_order_qty(j) || ' tp ' || t_tp_planned_order_qty(j) || 'date ' || t_key_date(j));
3910: l_order_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',CP_PLANNED_ORDER);
3911: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));
3912: IF ( t_planned_order_qty(j) <> 0 ) THEN
3913: l_planned_order_qty := t_planned_order_qty(j);
3914: l_tp_planned_order_qty := t_tp_planned_order_qty(j);

Line 3911: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));

3907: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'PLO' || t_planned_order_qty(j) || ' tp '
3908: -- || t_tp_planned_order_qty(j) || 'date ' || t_key_date(j));
3909: log_message('PLO' || t_planned_order_qty(j) || ' tp ' || t_tp_planned_order_qty(j) || 'date ' || t_key_date(j));
3910: l_order_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',CP_PLANNED_ORDER);
3911: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));
3912: IF ( t_planned_order_qty(j) <> 0 ) THEN
3913: l_planned_order_qty := t_planned_order_qty(j);
3914: l_tp_planned_order_qty := t_tp_planned_order_qty(j);
3915:

Line 4047: l_order_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',CP_RELEASED_PLANNED_ORDER);

4043: ----------------------------------------------------------
4044: -- RELEASED_PLANNED_ORDER
4045: ----------------------------------------------------------
4046:
4047: l_order_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',CP_RELEASED_PLANNED_ORDER);
4048: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));
4049: IF (t_released_qty(j) <> 0 ) THEN
4050: l_released_qty := t_released_qty(j);
4051: l_tp_released_qty := t_tp_released_qty(j);

Line 4048: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));

4044: -- RELEASED_PLANNED_ORDER
4045: ----------------------------------------------------------
4046:
4047: l_order_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',CP_RELEASED_PLANNED_ORDER);
4048: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));
4049: IF (t_released_qty(j) <> 0 ) THEN
4050: l_released_qty := t_released_qty(j);
4051: l_tp_released_qty := t_tp_released_qty(j);
4052: IF (t_released_qty(j) < 0 ) THEN

Line 4188: l_order_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',CP_PURCHASE_ORDER_FROM_PLAN);

4184:
4185: ------------------------------------------------------
4186: -- PURCHASE_ORDER_FROM_PLAN
4187: ------------------------------------------------------
4188: l_order_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',CP_PURCHASE_ORDER_FROM_PLAN);
4189: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));
4190: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'Po ' || t_qty(j) || ' tp ' || t_tp_qty(j)
4191: --|| 'date ' || t_key_date(j));
4192: log_message( 'Po ' || t_qty(j) || ' tp ' || t_tp_qty(j) || 'date ' || t_key_date(j));

Line 4189: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));

4185: ------------------------------------------------------
4186: -- PURCHASE_ORDER_FROM_PLAN
4187: ------------------------------------------------------
4188: l_order_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',CP_PURCHASE_ORDER_FROM_PLAN);
4189: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));
4190: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'Po ' || t_qty(j) || ' tp ' || t_tp_qty(j)
4191: --|| 'date ' || t_key_date(j));
4192: log_message( 'Po ' || t_qty(j) || ' tp ' || t_tp_qty(j) || 'date ' || t_key_date(j));
4193: insert into msc_sup_dem_entries (

Line 4324: l_order_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',CP_PLANNED_INBOUND_SHIPMENT);

4320: ---------------------------------------------------------
4321: -- EXPECTED_INBOUND_SHIPMENT (PLANNED_INBOUND_SHIPMENT)
4322: ---------------------------------------------------------
4323:
4324: l_order_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',CP_PLANNED_INBOUND_SHIPMENT);
4325: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));
4326: IF ( t_planned_order_qty(j) <> 0 ) THEN
4327: l_planned_order_qty := t_planned_order_qty(j);
4328: l_tp_planned_order_qty := t_tp_planned_order_qty(j);

Line 4325: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));

4321: -- EXPECTED_INBOUND_SHIPMENT (PLANNED_INBOUND_SHIPMENT)
4322: ---------------------------------------------------------
4323:
4324: l_order_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',CP_PLANNED_INBOUND_SHIPMENT);
4325: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));
4326: IF ( t_planned_order_qty(j) <> 0 ) THEN
4327: l_planned_order_qty := t_planned_order_qty(j);
4328: l_tp_planned_order_qty := t_tp_planned_order_qty(j);
4329:

Line 4463: l_order_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',CP_RELEASED_INBOUND_SHIPMENT);

4459: ----------------------------------------------------------
4460: -- CP_RELEASED_INBOUND_SHIPMENT (qty released from PIS)
4461: ----------------------------------------------------------
4462:
4463: l_order_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',CP_RELEASED_INBOUND_SHIPMENT);
4464: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));
4465: IF (t_released_qty(j) <> 0 ) THEN
4466: l_released_qty := t_released_qty(j);
4467: l_tp_released_qty := t_tp_released_qty(j);

Line 4464: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));

4460: -- CP_RELEASED_INBOUND_SHIPMENT (qty released from PIS)
4461: ----------------------------------------------------------
4462:
4463: l_order_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',CP_RELEASED_INBOUND_SHIPMENT);
4464: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));
4465: IF (t_released_qty(j) <> 0 ) THEN
4466: l_released_qty := t_released_qty(j);
4467: l_tp_released_qty := t_tp_released_qty(j);
4468: IF (t_released_qty(j) < 0 ) THEN

Line 4761: l_order_type_desc:=MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',RETURNS_FORECAST);

4757: and trunc(key_date) = DECODE(t_order_type(j),ISO_DEF,trunc(t_receipt_date(j)),trunc(t_key_date(j)))
4758: and publisher_order_type = RETURNS_FORECAST ;
4759:
4760: IF SQL%NOTFOUND THEN
4761: l_order_type_desc:=MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',RETURNS_FORECAST);
4762: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));
4763: INSERT INTO msc_sup_dem_entries
4764: (transaction_id,
4765: plan_id,

Line 4762: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));

4758: and publisher_order_type = RETURNS_FORECAST ;
4759:
4760: IF SQL%NOTFOUND THEN
4761: l_order_type_desc:=MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',RETURNS_FORECAST);
4762: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));
4763: INSERT INTO msc_sup_dem_entries
4764: (transaction_id,
4765: plan_id,
4766: sr_instance_id,

Line 4906: l_order_type_desc:=MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',DEFECTIVE_OUTBOUND_SHIPMENT);

4902: and NVL(line_number,G_NULL_STRING) = NVL(t_line_num(j),G_NULL_STRING) -- bug#7310179
4903: and publisher_order_type = DEFECTIVE_OUTBOUND_SHIPMENT;
4904:
4905: IF SQL%NOTFOUND THEN
4906: l_order_type_desc:=MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',DEFECTIVE_OUTBOUND_SHIPMENT);
4907: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));
4908: INSERT INTO msc_sup_dem_entries
4909: (transaction_id,
4910: plan_id,

Line 4907: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));

4903: and publisher_order_type = DEFECTIVE_OUTBOUND_SHIPMENT;
4904:
4905: IF SQL%NOTFOUND THEN
4906: l_order_type_desc:=MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',DEFECTIVE_OUTBOUND_SHIPMENT);
4907: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));
4908: INSERT INTO msc_sup_dem_entries
4909: (transaction_id,
4910: plan_id,
4911: sr_instance_id,