APPS.GMP_RESOURCE_DTL_PUB dependencies on GMP_RESOURCE_INSTANCES

Line 54: SELECT GMP_RESOURCE_INSTANCES_S.nextval

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

Line 854: /* the row into gmp_resource_instances table and Returns S code */

850: /* */
851: /* DESCRIPTION: */
852: /* */
853: /* The following Procedure checks the Record and then Inserts */
854: /* the row into gmp_resource_instances table and Returns S code */
855: /* if inserted Successfully */
856: /* */
857: /* History : */
858: /* Sgidugu 09/10/2002 Initial implementation */

Line 888: INSERT INTO gmp_resource_instances

884: ,p_last_update_login IN NUMBER ) IS
885:
886: BEGIN
887:
888: INSERT INTO gmp_resource_instances
889: (
890: RESOURCE_ID
891: ,INSTANCE_ID
892: ,INSTANCE_NUMBER

Line 1285: , p_instances IN gmp_resource_instances%ROWTYPE

1281: PROCEDURE update_instances
1282: ( p_api_version IN NUMBER := 1
1283: , p_init_msg_list IN BOOLEAN := TRUE
1284: , p_commit IN BOOLEAN := FALSE
1285: , p_instances IN gmp_resource_instances%ROWTYPE
1286: , x_message_count OUT NOCOPY NUMBER
1287: , x_message_list OUT NOCOPY VARCHAR2
1288: , x_return_status OUT NOCOPY VARCHAR2
1289: ) IS

Line 1449: /* gmp_resource_instances table and Returns S code if updated */

1445: /* */
1446: /* DESCRIPTION: */
1447: /* */
1448: /* The following Procedure Updates the information in */
1449: /* gmp_resource_instances table and Returns S code if updated */
1450: /* Successfully */
1451: /* */
1452: /* History : */
1453: /* Sgidugu 09/10/2002 Initial implementation */

Line 1486: UPDATE gmp_resource_instances set

1482: ) IS
1483:
1484: BEGIN
1485:
1486: UPDATE gmp_resource_instances set
1487: vendor_id = p_vendor_id
1488: ,model_number = p_model_number
1489: ,serial_number = p_serial_number
1490: ,tracking_number = p_tracking_number

Line 1618: delete from gmp_resource_instances

1614: delete from gmp_rsrc_unavail_man
1615: WHERE resource_id = v_resource_id ;
1616:
1617: -- Resource instances
1618: delete from gmp_resource_instances
1619: where resource_id = v_resource_id;
1620:
1621: -- Resource available
1622: delete from gmp_resource_avail

Line 1698: FROM gmp_resource_instances

1694: ) IS
1695:
1696: CURSOR Cur_check_dup IS
1697: SELECT COUNT(1)
1698: FROM gmp_resource_instances
1699: where instance_id = p_instance_id
1700: and resource_id = p_resource_id ;
1701:
1702: CURSOR Cur_vendor_id IS