APPS.POS_PROFILE_CHANGE_REQUEST_PKG dependencies on POS_PRODUCT_SERVICE_REQUESTS

Line 1236: FROM pos_product_service_requests

1232: )
1233: IS
1234: CURSOR l_cur IS
1235: SELECT *
1236: FROM pos_product_service_requests
1237: WHERE ps_request_id = p_request_id FOR UPDATE NOWAIT;
1238: -- ECO 5209555 Add the nowait clause
1239:
1240: l_rec l_cur%ROWTYPE;

Line 1366: UPDATE pos_product_service_requests

1362: , Sysdate
1363: , fnd_global.login_id
1364: );
1365:
1366: UPDATE pos_product_service_requests
1367: SET request_status = 'APPROVED',
1368: last_update_date = Sysdate,
1369: last_updated_by = fnd_global.user_id,
1370: last_update_login = fnd_global.login_id

Line 1564: select ps_request_id into l_lock_id from pos_product_service_requests

1560: savepoint reject_ps_req;
1561: -- Lock the rows: This is done as part of ECO 5209555
1562: BEGIN
1563:
1564: select ps_request_id into l_lock_id from pos_product_service_requests
1565: WHERE ps_request_id = p_request_id for update nowait;
1566:
1567: EXCEPTION
1568:

Line 1578: UPDATE pos_product_service_requests

1574: END IF;
1575: raise_application_error(-20080, x_msg_data, true);
1576: END;
1577:
1578: UPDATE pos_product_service_requests
1579: SET request_status = 'REJECTED',
1580: last_update_date = Sysdate,
1581: last_updated_by = fnd_global.user_id,
1582: last_update_login = fnd_global.login_id

Line 1793: select ps_request_id into l_lock_id from pos_product_service_requests

1789: BEGIN
1790:
1791: for i in 1..p_req_id_tbl.COUNT LOOP
1792:
1793: select ps_request_id into l_lock_id from pos_product_service_requests
1794: WHERE ps_request_id = p_req_id_tbl(i) for update nowait;
1795:
1796: END LOOP;
1797:

Line 2134: select ps_request_id into l_lock_id from pos_product_service_requests

2130: BEGIN
2131:
2132: for i in 1..p_req_id_tbl.COUNT LOOP
2133:
2134: select ps_request_id into l_lock_id from pos_product_service_requests
2135: WHERE ps_request_id = p_req_id_tbl(i) for update nowait;
2136:
2137: END LOOP;
2138: