DBA Data[Home] [Help]

APPS.INV_RESERVATION_PVT dependencies on INV_RESERVATION_LOCK_PVT

Line 8476: inv_reservation_lock_pvt.lock_supply_demand_record

8472: l_supply_source_type_id := l_rsv_rec.supply_source_type_id;
8473: END IF;
8474:
8475: IF (l_rsv_rec.supply_source_type_id <> inv_reservation_global.g_source_type_inv) THEN
8476: inv_reservation_lock_pvt.lock_supply_demand_record
8477: (p_organization_id => l_rsv_rec.organization_id
8478: ,p_inventory_item_id => l_rsv_rec.inventory_item_id
8479: ,p_source_type_id => l_supply_source_type_id
8480: ,p_source_header_id => l_rsv_rec.supply_source_header_id

Line 8492: inv_reservation_lock_pvt.lock_supply_demand_record

8488: fnd_msg_pub.ADD;
8489: RAISE fnd_api.g_exc_error;
8490: END if;
8491:
8492: inv_reservation_lock_pvt.lock_supply_demand_record
8493: (p_organization_id => l_rsv_rec.organization_id
8494: ,p_inventory_item_id => l_rsv_rec.inventory_item_id
8495: ,p_source_type_id => l_rsv_rec.demand_source_type_id
8496: ,p_source_header_id => l_rsv_rec.demand_source_header_id

Line 9695: inv_reservation_lock_pvt.release_lock

9691:
9692: /**** {{ R12 Enhanced reservations code changes. Should be
9693: -- releasing the locks. }} *****/
9694: IF l_lock_obtained THEN
9695: inv_reservation_lock_pvt.release_lock
9696: (l_supply_lock_handle);
9697: inv_reservation_lock_pvt.release_lock
9698: (l_demand_lock_handle);
9699: END IF;

Line 9697: inv_reservation_lock_pvt.release_lock

9693: -- releasing the locks. }} *****/
9694: IF l_lock_obtained THEN
9695: inv_reservation_lock_pvt.release_lock
9696: (l_supply_lock_handle);
9697: inv_reservation_lock_pvt.release_lock
9698: (l_demand_lock_handle);
9699: END IF;
9700: /*** End R12 ***/
9701:

Line 9731: inv_reservation_lock_pvt.release_lock

9727: x_return_status := fnd_api.g_ret_sts_error;
9728: /**** {{ R12 Enhanced reservations code changes. Should be
9729: -- releasing the locks. }} *****/
9730: IF l_lock_obtained THEN
9731: inv_reservation_lock_pvt.release_lock
9732: (l_supply_lock_handle);
9733: inv_reservation_lock_pvt.release_lock
9734: (l_demand_lock_handle);
9735: END IF;

Line 9733: inv_reservation_lock_pvt.release_lock

9729: -- releasing the locks. }} *****/
9730: IF l_lock_obtained THEN
9731: inv_reservation_lock_pvt.release_lock
9732: (l_supply_lock_handle);
9733: inv_reservation_lock_pvt.release_lock
9734: (l_demand_lock_handle);
9735: END IF;
9736: /*** End R12 ***/
9737: -- Get message count and data

Line 9745: inv_reservation_lock_pvt.release_lock

9741: x_return_status := fnd_api.g_ret_sts_unexp_error;
9742: /**** {{ R12 Enhanced reservations code changes. Should be
9743: -- releasing the locks. }} *****/
9744: IF l_lock_obtained THEN
9745: inv_reservation_lock_pvt.release_lock
9746: (l_supply_lock_handle);
9747: inv_reservation_lock_pvt.release_lock
9748: (l_demand_lock_handle);
9749: END IF;

Line 9747: inv_reservation_lock_pvt.release_lock

9743: -- releasing the locks. }} *****/
9744: IF l_lock_obtained THEN
9745: inv_reservation_lock_pvt.release_lock
9746: (l_supply_lock_handle);
9747: inv_reservation_lock_pvt.release_lock
9748: (l_demand_lock_handle);
9749: END IF;
9750: /*** End R12 ***/
9751: -- Get message count and data

Line 9759: inv_reservation_lock_pvt.release_lock

9755: x_return_status := fnd_api.g_ret_sts_unexp_error;
9756: /**** {{ R12 Enhanced reservations code changes. Should be
9757: -- releasing the locks. }} *****/
9758: IF l_lock_obtained THEN
9759: inv_reservation_lock_pvt.release_lock
9760: (l_supply_lock_handle);
9761: inv_reservation_lock_pvt.release_lock
9762: (l_demand_lock_handle);
9763: END IF;

Line 9761: inv_reservation_lock_pvt.release_lock

9757: -- releasing the locks. }} *****/
9758: IF l_lock_obtained THEN
9759: inv_reservation_lock_pvt.release_lock
9760: (l_supply_lock_handle);
9761: inv_reservation_lock_pvt.release_lock
9762: (l_demand_lock_handle);
9763: END IF;
9764: /*** End R12 ***/
9765: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 10231: inv_reservation_lock_pvt.lock_supply_demand_record

10227: l_supply_source_type_id := l_to_rsv_rec.supply_source_type_id;
10228: END IF;
10229:
10230: IF (l_to_rsv_rec.supply_source_type_id <> inv_reservation_global.g_source_type_inv) THEN
10231: inv_reservation_lock_pvt.lock_supply_demand_record
10232: (p_organization_id => l_to_rsv_rec.organization_id
10233: ,p_inventory_item_id => l_to_rsv_rec.inventory_item_id
10234: ,p_source_type_id => l_supply_source_type_id
10235: ,p_source_header_id => l_to_rsv_rec.supply_source_header_id

Line 10247: inv_reservation_lock_pvt.lock_supply_demand_record

10243: fnd_msg_pub.ADD;
10244: RAISE fnd_api.g_exc_error;
10245: END if;
10246:
10247: inv_reservation_lock_pvt.lock_supply_demand_record
10248: (p_organization_id => l_to_rsv_rec.organization_id
10249: ,p_inventory_item_id => l_to_rsv_rec.inventory_item_id
10250: ,p_source_type_id => l_to_rsv_rec.demand_source_type_id
10251: ,p_source_header_id => l_to_rsv_rec.demand_source_header_id

Line 11717: inv_reservation_lock_pvt.release_lock

11713:
11714: /**** {{ R12 Enhanced reservations code changes. Should be
11715: -- releasing the locks. }} *****/
11716: IF l_lock_obtained THEN
11717: inv_reservation_lock_pvt.release_lock
11718: (l_supply_lock_handle);
11719: inv_reservation_lock_pvt.release_lock
11720: (l_demand_lock_handle);
11721: END IF;

Line 11719: inv_reservation_lock_pvt.release_lock

11715: -- releasing the locks. }} *****/
11716: IF l_lock_obtained THEN
11717: inv_reservation_lock_pvt.release_lock
11718: (l_supply_lock_handle);
11719: inv_reservation_lock_pvt.release_lock
11720: (l_demand_lock_handle);
11721: END IF;
11722: /*** End R12 ***/
11723:

Line 11741: inv_reservation_lock_pvt.release_lock

11737: x_return_status := fnd_api.g_ret_sts_error;
11738: /**** {{ R12 Enhanced reservations code changes. Should be
11739: -- releasing the locks. }} *****/
11740: IF l_lock_obtained THEN
11741: inv_reservation_lock_pvt.release_lock
11742: (l_supply_lock_handle);
11743: inv_reservation_lock_pvt.release_lock
11744: (l_demand_lock_handle);
11745: END IF;

Line 11743: inv_reservation_lock_pvt.release_lock

11739: -- releasing the locks. }} *****/
11740: IF l_lock_obtained THEN
11741: inv_reservation_lock_pvt.release_lock
11742: (l_supply_lock_handle);
11743: inv_reservation_lock_pvt.release_lock
11744: (l_demand_lock_handle);
11745: END IF;
11746: /*** End R12 ***/
11747: -- Get message count and data

Line 11758: inv_reservation_lock_pvt.release_lock

11754: x_return_status := fnd_api.g_ret_sts_unexp_error;
11755: /**** {{ R12 Enhanced reservations code changes. Should be
11756: -- releasing the locks. }} *****/
11757: IF l_lock_obtained THEN
11758: inv_reservation_lock_pvt.release_lock
11759: (l_supply_lock_handle);
11760: inv_reservation_lock_pvt.release_lock
11761: (l_demand_lock_handle);
11762: END IF;

Line 11760: inv_reservation_lock_pvt.release_lock

11756: -- releasing the locks. }} *****/
11757: IF l_lock_obtained THEN
11758: inv_reservation_lock_pvt.release_lock
11759: (l_supply_lock_handle);
11760: inv_reservation_lock_pvt.release_lock
11761: (l_demand_lock_handle);
11762: END IF;
11763: /*** End R12 ***/
11764: -- Get message count and data

Line 11775: inv_reservation_lock_pvt.release_lock

11771: x_return_status := fnd_api.g_ret_sts_unexp_error;
11772: /**** {{ R12 Enhanced reservations code changes. Should be
11773: -- releasing the locks. }} *****/
11774: IF l_lock_obtained THEN
11775: inv_reservation_lock_pvt.release_lock
11776: (l_supply_lock_handle);
11777: inv_reservation_lock_pvt.release_lock
11778: (l_demand_lock_handle);
11779: END IF;

Line 11777: inv_reservation_lock_pvt.release_lock

11773: -- releasing the locks. }} *****/
11774: IF l_lock_obtained THEN
11775: inv_reservation_lock_pvt.release_lock
11776: (l_supply_lock_handle);
11777: inv_reservation_lock_pvt.release_lock
11778: (l_demand_lock_handle);
11779: END IF;
11780: /*** End R12 ***/
11781: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 13493: inv_reservation_lock_pvt.lock_supply_demand_record

13489: l_supply_source_type_id := l_to_rsv_rec.supply_source_type_id;
13490: END IF;
13491:
13492: IF (l_to_rsv_rec.supply_source_type_id <> inv_reservation_global.g_source_type_inv) THEN
13493: inv_reservation_lock_pvt.lock_supply_demand_record
13494: (p_organization_id => l_to_rsv_rec.organization_id
13495: ,p_inventory_item_id => l_to_rsv_rec.inventory_item_id
13496: ,p_source_type_id => l_supply_source_type_id
13497: ,p_source_header_id => l_to_rsv_rec.supply_source_header_id

Line 13509: inv_reservation_lock_pvt.lock_supply_demand_record

13505: fnd_msg_pub.ADD;
13506: RAISE fnd_api.g_exc_error;
13507: END if;
13508:
13509: inv_reservation_lock_pvt.lock_supply_demand_record
13510: (p_organization_id => l_to_rsv_rec.organization_id
13511: ,p_inventory_item_id => l_to_rsv_rec.inventory_item_id
13512: ,p_source_type_id => l_to_rsv_rec.demand_source_type_id
13513: ,p_source_header_id => l_to_rsv_rec.demand_source_header_id

Line 16895: inv_reservation_lock_pvt.release_lock

16891:
16892: /**** {{ R12 Enhanced reservations code changes. Should be
16893: -- releasing the locks. }} *****/
16894: IF l_lock_obtained THEN
16895: inv_reservation_lock_pvt.release_lock
16896: (l_supply_lock_handle);
16897: inv_reservation_lock_pvt.release_lock
16898: (l_demand_lock_handle);
16899: END IF;

Line 16897: inv_reservation_lock_pvt.release_lock

16893: -- releasing the locks. }} *****/
16894: IF l_lock_obtained THEN
16895: inv_reservation_lock_pvt.release_lock
16896: (l_supply_lock_handle);
16897: inv_reservation_lock_pvt.release_lock
16898: (l_demand_lock_handle);
16899: END IF;
16900: /*** End R12 ***/
16901:

Line 16910: inv_reservation_lock_pvt.release_lock

16906: x_return_status := fnd_api.g_ret_sts_error;
16907: /**** {{ R12 Enhanced reservations code changes. Should be
16908: -- releasing the locks. }} *****/
16909: IF l_lock_obtained THEN
16910: inv_reservation_lock_pvt.release_lock
16911: (l_supply_lock_handle);
16912: inv_reservation_lock_pvt.release_lock
16913: (l_demand_lock_handle);
16914: END IF;

Line 16912: inv_reservation_lock_pvt.release_lock

16908: -- releasing the locks. }} *****/
16909: IF l_lock_obtained THEN
16910: inv_reservation_lock_pvt.release_lock
16911: (l_supply_lock_handle);
16912: inv_reservation_lock_pvt.release_lock
16913: (l_demand_lock_handle);
16914: END IF;
16915: /*** End R12 ***/
16916: -- Get message count and data

Line 16924: inv_reservation_lock_pvt.release_lock

16920: x_return_status := fnd_api.g_ret_sts_unexp_error;
16921: /**** {{ R12 Enhanced reservations code changes. Should be
16922: -- releasing the locks. }} *****/
16923: IF l_lock_obtained THEN
16924: inv_reservation_lock_pvt.release_lock
16925: (l_supply_lock_handle);
16926: inv_reservation_lock_pvt.release_lock
16927: (l_demand_lock_handle);
16928: END IF;

Line 16926: inv_reservation_lock_pvt.release_lock

16922: -- releasing the locks. }} *****/
16923: IF l_lock_obtained THEN
16924: inv_reservation_lock_pvt.release_lock
16925: (l_supply_lock_handle);
16926: inv_reservation_lock_pvt.release_lock
16927: (l_demand_lock_handle);
16928: END IF;
16929: /*** End R12 ***/
16930: -- Get message count and data

Line 16938: inv_reservation_lock_pvt.release_lock

16934: x_return_status := fnd_api.g_ret_sts_unexp_error;
16935: /**** {{ R12 Enhanced reservations code changes. Should be
16936: -- releasing the locks. }} *****/
16937: IF l_lock_obtained THEN
16938: inv_reservation_lock_pvt.release_lock
16939: (l_supply_lock_handle);
16940: inv_reservation_lock_pvt.release_lock
16941: (l_demand_lock_handle);
16942: END IF;

Line 16940: inv_reservation_lock_pvt.release_lock

16936: -- releasing the locks. }} *****/
16937: IF l_lock_obtained THEN
16938: inv_reservation_lock_pvt.release_lock
16939: (l_supply_lock_handle);
16940: inv_reservation_lock_pvt.release_lock
16941: (l_demand_lock_handle);
16942: END IF;
16943: /*** End R12 ***/
16944: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN