[Home] [Help]
50: SELECT BOM_RESOURCES_S.nextval
51: FROM sys.dual;
52:
53: CURSOR Cur_instance_id IS
54: SELECT GMP_RESOURCE_INSTANCES_S.nextval
55: FROM sys.DUAL;
56:
57: /* B4724360 Rajesh Patangya INVCONV */
58: CURSOR Cur_uom IS
906: ,p_last_update_login IN NUMBER ) IS
907:
908: BEGIN
909:
910: INSERT INTO gmp_resource_instances
911: (
912: RESOURCE_ID
913: ,INSTANCE_ID
914: ,INSTANCE_NUMBER
1308: PROCEDURE update_instances
1309: ( p_api_version IN NUMBER := 1
1310: , p_init_msg_list IN BOOLEAN := TRUE
1311: , p_commit IN BOOLEAN := FALSE
1312: , p_instances IN gmp_resource_instances%ROWTYPE
1313: , x_message_count OUT NOCOPY NUMBER
1314: , x_message_list OUT NOCOPY VARCHAR2
1315: , x_return_status OUT NOCOPY VARCHAR2
1316: ) IS
1472: /* */
1473: /* DESCRIPTION: */
1474: /* */
1475: /* The following Procedure Updates the information in */
1476: /* gmp_resource_instances table and Returns S code if updated */
1477: /* Successfully */
1478: /* */
1479: /* History : */
1480: /* Sgidugu 09/10/2002 Initial implementation */
1509: ) IS
1510:
1511: BEGIN
1512:
1513: UPDATE gmp_resource_instances set
1514: vendor_id = p_vendor_id
1515: ,model_number = p_model_number
1516: ,serial_number = p_serial_number
1517: ,tracking_number = p_tracking_number
1641: delete from gmp_rsrc_unavail_man
1642: WHERE resource_id = v_resource_id ;
1643:
1644: -- Resource instances
1645: delete from gmp_resource_instances
1646: where resource_id = v_resource_id;
1647:
1648: -- Resource available
1649: delete from gmp_resource_avail
1721: ) IS
1722:
1723: CURSOR Cur_check_dup IS
1724: SELECT COUNT(1)
1725: FROM gmp_resource_instances
1726: where instance_id = p_instance_id
1727: and resource_id = p_resource_id ;
1728:
1729: CURSOR Cur_vendor_id IS