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_X_RECEIVE_CAPACITY_PKG dependencies on MSC_SUPPLIER_CAPACITIES

Line 539: DELETE msc_supplier_capacities

535: IF ((p_overwrite = 1) OR (p_horizon_start_date is null and p_horizon_end_date is null))
536: THEN
537: begin
538:
539: DELETE msc_supplier_capacities
540: WHERE plan_id = -1
541: AND inventory_item_id = nvl(p_item_id , inventory_item_id)
542: AND supplier_id = nvl(p_supplier_id , supplier_id)
543: AND supplier_site_id = nvl(p_supplier_site_id , supplier_site_id)

Line 549: LOG_MESSAGE('No record to be deleted in msc_supplier_capacities.');

545:
546: LOG_MESSAGE( 'Delete all record ' ||sql%rowcount);
547: exception
548: WHEN no_data_found then
549: LOG_MESSAGE('No record to be deleted in msc_supplier_capacities.');
550: WHEN OTHERS THEN
551: log_message('Error while deleting records for overwrite_all option.');
552: end;
553:

Line 560: DELETE msc_supplier_capacities

556: /*--------------------------------------------------------------------------
557: deleting capacity between the horizon dates and leave the 2 ends
558: ---------------------------------------------------------------------------*/
559: begin
560: DELETE msc_supplier_capacities
561: WHERE plan_id = -1
562: AND inventory_item_id = nvl(p_item_id , inventory_item_id)
563: AND supplier_id = nvl(p_supplier_id , supplier_id)
564: AND supplier_site_id = nvl(p_supplier_site_id , supplier_site_id)

Line 575: LOG_MESSAGE('No record to be deleted in msc_supplier_capacities for overwrite_all option.');

571: LOG_MESSAGE('Delete based on horizon_date ' ||sql%rowcount);
572:
573: exception
574: WHEN no_data_found then
575: LOG_MESSAGE('No record to be deleted in msc_supplier_capacities for overwrite_all option.');
576: WHEN OTHERS THEN
577: log_message('Error while deleting records for overwrite_all option.'||sqlcode);
578: log_message(sqlerrm);
579: end;

Line 953: update msc_supplier_capacities

949: /*---------------------------------------------------------------------------
950: | Now update back the current data that are receiving from exchange
951: -------------------------------------------------------------------------*/
952: begin
953: update msc_supplier_capacities
954: set last_update_login = null
955: where plan_id = -1
956: and last_update_login = -999;
957:

Line 1305: FROM msc_supplier_capacities

1301: p_date In Date,
1302: p_horizon_start_date In Date,
1303: p_horizon_end_date in Date) IS
1304: SELECT transaction_id,from_date, to_date, capacity
1305: FROM msc_supplier_capacities
1306: WHERE plan_id = -1
1307: AND sr_instance_id = p_sr_instance_id
1308: AND organization_id = p_organization_id
1309: AND inventory_item_id = p_item_id

Line 1322: FROM msc_supplier_capacities

1318: this statement will take care where p_horizon_start_date is null
1319: and to_date is null
1320: -----------------------------------------------------------------------*/
1321: SELECT transaction_id,from_date, to_date, capacity
1322: FROM msc_supplier_capacities
1323: WHERE plan_id = -1
1324: AND sr_instance_id = p_sr_instance_id
1325: AND organization_id = p_organization_id
1326: AND inventory_item_id = p_item_id

Line 1380: UPDATE msc_supplier_capacities

1376: then insert later when l_to_date > p_horizon_end_date
1377: Also works for p_horizon_end_date is null -- just update the to_date
1378: -------------------------------------------------------------------------*/
1379:
1380: UPDATE msc_supplier_capacities
1381: set to_date = p_horizon_start_date -1
1382: WHERE plan_id = -1
1383: and transaction_id = l_trx_id;
1384:

Line 1402: UPDATE msc_supplier_capacities

1398:
1399: ELSIF (l_from_date >= p_horizon_start_date and
1400: l_to_date > p_horizon_end_date and
1401: p_horizon_end_date is not null) THEN
1402: UPDATE msc_supplier_capacities
1403: set from_date = p_horizon_end_date + 1
1404: WHERE plan_id = -1
1405: and transaction_id = l_trx_id;
1406: END IF;

Line 1410: UPDATE msc_supplier_capacities

1406: END IF;
1407: END IF;
1408: IF (p_horizon_start_date is null and
1409: l_to_date > p_horizon_end_date ) THEN
1410: UPDATE msc_supplier_capacities
1411: set from_date = p_horizon_end_date + 1
1412: WHERE plan_id = -1
1413: and transaction_id = l_trx_id;
1414: END IF;

Line 1432: UPDATE msc_supplier_capacities

1428: IF l_from_date = p_horizon_end_date -- just update the from_date
1429: Also works for p_horizon_start_date is null -- just update the from_date
1430: -------------------------------------------------------------------------*/
1431: --dbms_output.put_line('HZ ' || p_horizon_start_date || p_horizon_end_date);
1432: UPDATE msc_supplier_capacities
1433: set from_date = p_horizon_end_date + 1,
1434: to_date = null
1435: WHERE plan_id = -1
1436: and transaction_id = l_trx_id;

Line 1458: delete msc_supplier_capacities

1454: IF p_horizon_end_date is null and l_to_date is null and
1455: l_from_date is within the p_horizon_start_date, the trx
1456: should be overwrite
1457: --------------------------------------------------------*/
1458: delete msc_supplier_capacities
1459: where transaction_id = l_trx_id;
1460: ELSIF (l_from_date < p_horizon_start_date ) THEN
1461: UPDATE msc_supplier_capacities
1462: set to_date = p_horizon_start_date -1

Line 1461: UPDATE msc_supplier_capacities

1457: --------------------------------------------------------*/
1458: delete msc_supplier_capacities
1459: where transaction_id = l_trx_id;
1460: ELSIF (l_from_date < p_horizon_start_date ) THEN
1461: UPDATE msc_supplier_capacities
1462: set to_date = p_horizon_start_date -1
1463: where plan_id = -1
1464: and transaction_id = l_trx_id;
1465: END IF;

Line 1518: FROM msc_supplier_capacities

1514: --===========================================================================
1515: begin
1516: select count(*)
1517: into l_exist
1518: FROM msc_supplier_capacities
1519: WHERE plan_id = -1
1520: AND sr_instance_id = p_sr_instance_id
1521: AND organization_id = p_organization_id
1522: AND inventory_item_id = p_item_id

Line 1538: UPDATE msc_supplier_capacities

1534: end;
1535:
1536: IF (l_exist > 0) THEN
1537: --LOG_MESSAGE( 'update qty ' || p_capacity);
1538: UPDATE msc_supplier_capacities
1539: set capacity = capacity + p_capacity
1540: WHERE plan_id = -1
1541: AND sr_instance_id = p_sr_instance_id
1542: AND organization_id = p_organization_id

Line 1555: select msc_supplier_capacities_s.nextval

1551: ELSIF (l_exist = 0) THEN
1552:
1553:
1554: LOG_MESSAGE('insert capacity');
1555: select msc_supplier_capacities_s.nextval
1556: into l_nextid
1557: from dual;
1558: BEGIN
1559: insert into msc_supplier_capacities (

Line 1559: insert into msc_supplier_capacities (

1555: select msc_supplier_capacities_s.nextval
1556: into l_nextid
1557: from dual;
1558: BEGIN
1559: insert into msc_supplier_capacities (
1560: transaction_id,
1561: plan_id,
1562: organization_id,
1563: sr_instance_id,

Line 1631: from msc_supplier_capacities

1627: BEGIN
1628: begin
1629: SELECT 1 into l_exist from dual
1630: WHERE exists (SELECT 1
1631: from msc_supplier_capacities
1632: where plan_id = -1
1633: and sr_instance_id = p_sr_instance_id
1634: and transaction_id = p_transaction_id
1635: and inventory_item_id = p_item_id

Line 1650: update msc_supplier_capacities

1646:
1647: IF (l_exist = 1 ) THEN
1648:
1649: LOG_MESSAGE('update sc and override the collected/manually data');
1650: update msc_supplier_capacities
1651: set capacity = p_capacity,
1652: from_date = p_from_date,
1653: to_date = p_to_date,
1654: collected_flag = 3, -- bug 5208105

Line 1669: update msc_supplier_capacities

1665: and nvl(last_update_login,-1) <> -999;
1666: ELSE
1667:
1668: LOG_MESSAGE('do not override the current data receiving from exchange');
1669: update msc_supplier_capacities
1670: set capacity = capacity + p_capacity,
1671: from_date = p_from_date,
1672: to_date = p_to_date,
1673: collected_flag = 3, -- bug 5208105