DBA Data[Home] [Help]

APPS.INV_RESERVATION_PVT dependencies on INV_RESERVATION_LOCK_PVT

Line 8056: inv_reservation_lock_pvt.lock_supply_demand_record

8052: l_supply_source_type_id := l_rsv_rec.supply_source_type_id;
8053: END IF;
8054:
8055: IF (l_rsv_rec.supply_source_type_id <> inv_reservation_global.g_source_type_inv) THEN
8056: inv_reservation_lock_pvt.lock_supply_demand_record
8057: (p_organization_id => l_rsv_rec.organization_id
8058: ,p_inventory_item_id => l_rsv_rec.inventory_item_id
8059: ,p_source_type_id => l_supply_source_type_id
8060: ,p_source_header_id => l_rsv_rec.supply_source_header_id

Line 8072: inv_reservation_lock_pvt.lock_supply_demand_record

8068: fnd_msg_pub.ADD;
8069: RAISE fnd_api.g_exc_error;
8070: END if;
8071:
8072: inv_reservation_lock_pvt.lock_supply_demand_record
8073: (p_organization_id => l_rsv_rec.organization_id
8074: ,p_inventory_item_id => l_rsv_rec.inventory_item_id
8075: ,p_source_type_id => l_rsv_rec.demand_source_type_id
8076: ,p_source_header_id => l_rsv_rec.demand_source_header_id

Line 9137: inv_reservation_lock_pvt.release_lock

9133:
9134: /**** {{ R12 Enhanced reservations code changes. Should be
9135: -- releasing the locks. }} *****/
9136: IF l_lock_obtained THEN
9137: inv_reservation_lock_pvt.release_lock
9138: (l_supply_lock_handle);
9139: inv_reservation_lock_pvt.release_lock
9140: (l_demand_lock_handle);
9141: END IF;

Line 9139: inv_reservation_lock_pvt.release_lock

9135: -- releasing the locks. }} *****/
9136: IF l_lock_obtained THEN
9137: inv_reservation_lock_pvt.release_lock
9138: (l_supply_lock_handle);
9139: inv_reservation_lock_pvt.release_lock
9140: (l_demand_lock_handle);
9141: END IF;
9142: /*** End R12 ***/
9143:

Line 9173: inv_reservation_lock_pvt.release_lock

9169: x_return_status := fnd_api.g_ret_sts_error;
9170: /**** {{ R12 Enhanced reservations code changes. Should be
9171: -- releasing the locks. }} *****/
9172: IF l_lock_obtained THEN
9173: inv_reservation_lock_pvt.release_lock
9174: (l_supply_lock_handle);
9175: inv_reservation_lock_pvt.release_lock
9176: (l_demand_lock_handle);
9177: END IF;

Line 9175: inv_reservation_lock_pvt.release_lock

9171: -- releasing the locks. }} *****/
9172: IF l_lock_obtained THEN
9173: inv_reservation_lock_pvt.release_lock
9174: (l_supply_lock_handle);
9175: inv_reservation_lock_pvt.release_lock
9176: (l_demand_lock_handle);
9177: END IF;
9178: /*** End R12 ***/
9179: -- Get message count and data

Line 9187: inv_reservation_lock_pvt.release_lock

9183: x_return_status := fnd_api.g_ret_sts_unexp_error;
9184: /**** {{ R12 Enhanced reservations code changes. Should be
9185: -- releasing the locks. }} *****/
9186: IF l_lock_obtained THEN
9187: inv_reservation_lock_pvt.release_lock
9188: (l_supply_lock_handle);
9189: inv_reservation_lock_pvt.release_lock
9190: (l_demand_lock_handle);
9191: END IF;

Line 9189: inv_reservation_lock_pvt.release_lock

9185: -- releasing the locks. }} *****/
9186: IF l_lock_obtained THEN
9187: inv_reservation_lock_pvt.release_lock
9188: (l_supply_lock_handle);
9189: inv_reservation_lock_pvt.release_lock
9190: (l_demand_lock_handle);
9191: END IF;
9192: /*** End R12 ***/
9193: -- Get message count and data

Line 9201: inv_reservation_lock_pvt.release_lock

9197: x_return_status := fnd_api.g_ret_sts_unexp_error;
9198: /**** {{ R12 Enhanced reservations code changes. Should be
9199: -- releasing the locks. }} *****/
9200: IF l_lock_obtained THEN
9201: inv_reservation_lock_pvt.release_lock
9202: (l_supply_lock_handle);
9203: inv_reservation_lock_pvt.release_lock
9204: (l_demand_lock_handle);
9205: END IF;

Line 9203: inv_reservation_lock_pvt.release_lock

9199: -- releasing the locks. }} *****/
9200: IF l_lock_obtained THEN
9201: inv_reservation_lock_pvt.release_lock
9202: (l_supply_lock_handle);
9203: inv_reservation_lock_pvt.release_lock
9204: (l_demand_lock_handle);
9205: END IF;
9206: /*** End R12 ***/
9207: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 9649: inv_reservation_lock_pvt.lock_supply_demand_record

9645: l_supply_source_type_id := l_to_rsv_rec.supply_source_type_id;
9646: END IF;
9647:
9648: IF (l_to_rsv_rec.supply_source_type_id <> inv_reservation_global.g_source_type_inv) THEN
9649: inv_reservation_lock_pvt.lock_supply_demand_record
9650: (p_organization_id => l_to_rsv_rec.organization_id
9651: ,p_inventory_item_id => l_to_rsv_rec.inventory_item_id
9652: ,p_source_type_id => l_supply_source_type_id
9653: ,p_source_header_id => l_to_rsv_rec.supply_source_header_id

Line 9665: inv_reservation_lock_pvt.lock_supply_demand_record

9661: fnd_msg_pub.ADD;
9662: RAISE fnd_api.g_exc_error;
9663: END if;
9664:
9665: inv_reservation_lock_pvt.lock_supply_demand_record
9666: (p_organization_id => l_to_rsv_rec.organization_id
9667: ,p_inventory_item_id => l_to_rsv_rec.inventory_item_id
9668: ,p_source_type_id => l_to_rsv_rec.demand_source_type_id
9669: ,p_source_header_id => l_to_rsv_rec.demand_source_header_id

Line 10953: inv_reservation_lock_pvt.release_lock

10949:
10950: /**** {{ R12 Enhanced reservations code changes. Should be
10951: -- releasing the locks. }} *****/
10952: IF l_lock_obtained THEN
10953: inv_reservation_lock_pvt.release_lock
10954: (l_supply_lock_handle);
10955: inv_reservation_lock_pvt.release_lock
10956: (l_demand_lock_handle);
10957: END IF;

Line 10955: inv_reservation_lock_pvt.release_lock

10951: -- releasing the locks. }} *****/
10952: IF l_lock_obtained THEN
10953: inv_reservation_lock_pvt.release_lock
10954: (l_supply_lock_handle);
10955: inv_reservation_lock_pvt.release_lock
10956: (l_demand_lock_handle);
10957: END IF;
10958: /*** End R12 ***/
10959:

Line 10977: inv_reservation_lock_pvt.release_lock

10973: x_return_status := fnd_api.g_ret_sts_error;
10974: /**** {{ R12 Enhanced reservations code changes. Should be
10975: -- releasing the locks. }} *****/
10976: IF l_lock_obtained THEN
10977: inv_reservation_lock_pvt.release_lock
10978: (l_supply_lock_handle);
10979: inv_reservation_lock_pvt.release_lock
10980: (l_demand_lock_handle);
10981: END IF;

Line 10979: inv_reservation_lock_pvt.release_lock

10975: -- releasing the locks. }} *****/
10976: IF l_lock_obtained THEN
10977: inv_reservation_lock_pvt.release_lock
10978: (l_supply_lock_handle);
10979: inv_reservation_lock_pvt.release_lock
10980: (l_demand_lock_handle);
10981: END IF;
10982: /*** End R12 ***/
10983: -- Get message count and data

Line 10994: inv_reservation_lock_pvt.release_lock

10990: x_return_status := fnd_api.g_ret_sts_unexp_error;
10991: /**** {{ R12 Enhanced reservations code changes. Should be
10992: -- releasing the locks. }} *****/
10993: IF l_lock_obtained THEN
10994: inv_reservation_lock_pvt.release_lock
10995: (l_supply_lock_handle);
10996: inv_reservation_lock_pvt.release_lock
10997: (l_demand_lock_handle);
10998: END IF;

Line 10996: inv_reservation_lock_pvt.release_lock

10992: -- releasing the locks. }} *****/
10993: IF l_lock_obtained THEN
10994: inv_reservation_lock_pvt.release_lock
10995: (l_supply_lock_handle);
10996: inv_reservation_lock_pvt.release_lock
10997: (l_demand_lock_handle);
10998: END IF;
10999: /*** End R12 ***/
11000: -- Get message count and data

Line 11011: inv_reservation_lock_pvt.release_lock

11007: x_return_status := fnd_api.g_ret_sts_unexp_error;
11008: /**** {{ R12 Enhanced reservations code changes. Should be
11009: -- releasing the locks. }} *****/
11010: IF l_lock_obtained THEN
11011: inv_reservation_lock_pvt.release_lock
11012: (l_supply_lock_handle);
11013: inv_reservation_lock_pvt.release_lock
11014: (l_demand_lock_handle);
11015: END IF;

Line 11013: inv_reservation_lock_pvt.release_lock

11009: -- releasing the locks. }} *****/
11010: IF l_lock_obtained THEN
11011: inv_reservation_lock_pvt.release_lock
11012: (l_supply_lock_handle);
11013: inv_reservation_lock_pvt.release_lock
11014: (l_demand_lock_handle);
11015: END IF;
11016: /*** End R12 ***/
11017: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 12697: inv_reservation_lock_pvt.lock_supply_demand_record

12693: l_supply_source_type_id := l_to_rsv_rec.supply_source_type_id;
12694: END IF;
12695:
12696: IF (l_to_rsv_rec.supply_source_type_id <> inv_reservation_global.g_source_type_inv) THEN
12697: inv_reservation_lock_pvt.lock_supply_demand_record
12698: (p_organization_id => l_to_rsv_rec.organization_id
12699: ,p_inventory_item_id => l_to_rsv_rec.inventory_item_id
12700: ,p_source_type_id => l_supply_source_type_id
12701: ,p_source_header_id => l_to_rsv_rec.supply_source_header_id

Line 12713: inv_reservation_lock_pvt.lock_supply_demand_record

12709: fnd_msg_pub.ADD;
12710: RAISE fnd_api.g_exc_error;
12711: END if;
12712:
12713: inv_reservation_lock_pvt.lock_supply_demand_record
12714: (p_organization_id => l_to_rsv_rec.organization_id
12715: ,p_inventory_item_id => l_to_rsv_rec.inventory_item_id
12716: ,p_source_type_id => l_to_rsv_rec.demand_source_type_id
12717: ,p_source_header_id => l_to_rsv_rec.demand_source_header_id

Line 15766: inv_reservation_lock_pvt.release_lock

15762:
15763: /**** {{ R12 Enhanced reservations code changes. Should be
15764: -- releasing the locks. }} *****/
15765: IF l_lock_obtained THEN
15766: inv_reservation_lock_pvt.release_lock
15767: (l_supply_lock_handle);
15768: inv_reservation_lock_pvt.release_lock
15769: (l_demand_lock_handle);
15770: END IF;

Line 15768: inv_reservation_lock_pvt.release_lock

15764: -- releasing the locks. }} *****/
15765: IF l_lock_obtained THEN
15766: inv_reservation_lock_pvt.release_lock
15767: (l_supply_lock_handle);
15768: inv_reservation_lock_pvt.release_lock
15769: (l_demand_lock_handle);
15770: END IF;
15771: /*** End R12 ***/
15772:

Line 15781: inv_reservation_lock_pvt.release_lock

15777: x_return_status := fnd_api.g_ret_sts_error;
15778: /**** {{ R12 Enhanced reservations code changes. Should be
15779: -- releasing the locks. }} *****/
15780: IF l_lock_obtained THEN
15781: inv_reservation_lock_pvt.release_lock
15782: (l_supply_lock_handle);
15783: inv_reservation_lock_pvt.release_lock
15784: (l_demand_lock_handle);
15785: END IF;

Line 15783: inv_reservation_lock_pvt.release_lock

15779: -- releasing the locks. }} *****/
15780: IF l_lock_obtained THEN
15781: inv_reservation_lock_pvt.release_lock
15782: (l_supply_lock_handle);
15783: inv_reservation_lock_pvt.release_lock
15784: (l_demand_lock_handle);
15785: END IF;
15786: /*** End R12 ***/
15787: -- Get message count and data

Line 15795: inv_reservation_lock_pvt.release_lock

15791: x_return_status := fnd_api.g_ret_sts_unexp_error;
15792: /**** {{ R12 Enhanced reservations code changes. Should be
15793: -- releasing the locks. }} *****/
15794: IF l_lock_obtained THEN
15795: inv_reservation_lock_pvt.release_lock
15796: (l_supply_lock_handle);
15797: inv_reservation_lock_pvt.release_lock
15798: (l_demand_lock_handle);
15799: END IF;

Line 15797: inv_reservation_lock_pvt.release_lock

15793: -- releasing the locks. }} *****/
15794: IF l_lock_obtained THEN
15795: inv_reservation_lock_pvt.release_lock
15796: (l_supply_lock_handle);
15797: inv_reservation_lock_pvt.release_lock
15798: (l_demand_lock_handle);
15799: END IF;
15800: /*** End R12 ***/
15801: -- Get message count and data

Line 15809: inv_reservation_lock_pvt.release_lock

15805: x_return_status := fnd_api.g_ret_sts_unexp_error;
15806: /**** {{ R12 Enhanced reservations code changes. Should be
15807: -- releasing the locks. }} *****/
15808: IF l_lock_obtained THEN
15809: inv_reservation_lock_pvt.release_lock
15810: (l_supply_lock_handle);
15811: inv_reservation_lock_pvt.release_lock
15812: (l_demand_lock_handle);
15813: END IF;

Line 15811: inv_reservation_lock_pvt.release_lock

15807: -- releasing the locks. }} *****/
15808: IF l_lock_obtained THEN
15809: inv_reservation_lock_pvt.release_lock
15810: (l_supply_lock_handle);
15811: inv_reservation_lock_pvt.release_lock
15812: (l_demand_lock_handle);
15813: END IF;
15814: /*** End R12 ***/
15815: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN