APPS.POS_PROFILE_CHANGE_REQUEST_PKG dependencies on POS_PRODUCT_SERVICE_REQUESTS

Line 1182: FROM pos_product_service_requests

1178: )
1179: IS
1180: CURSOR l_cur IS
1181: SELECT *
1182: FROM pos_product_service_requests
1183: WHERE ps_request_id = p_request_id FOR UPDATE NOWAIT;
1184: -- ECO 5209555 Add the nowait clause
1185:
1186: l_rec l_cur%ROWTYPE;

Line 1312: UPDATE pos_product_service_requests

1308: , Sysdate
1309: , fnd_global.login_id
1310: );
1311:
1312: UPDATE pos_product_service_requests
1313: SET request_status = 'APPROVED',
1314: last_update_date = Sysdate,
1315: last_updated_by = fnd_global.user_id,
1316: last_update_login = fnd_global.login_id

Line 1510: select ps_request_id into l_lock_id from pos_product_service_requests

1506: savepoint reject_ps_req;
1507: -- Lock the rows: This is done as part of ECO 5209555
1508: BEGIN
1509:
1510: select ps_request_id into l_lock_id from pos_product_service_requests
1511: WHERE ps_request_id = p_request_id for update nowait;
1512:
1513: EXCEPTION
1514:

Line 1524: UPDATE pos_product_service_requests

1520: END IF;
1521: raise_application_error(-20080, x_msg_data, true);
1522: END;
1523:
1524: UPDATE pos_product_service_requests
1525: SET request_status = 'REJECTED',
1526: last_update_date = Sysdate,
1527: last_updated_by = fnd_global.user_id,
1528: last_update_login = fnd_global.login_id

Line 1739: select ps_request_id into l_lock_id from pos_product_service_requests

1735: BEGIN
1736:
1737: for i in 1..p_req_id_tbl.COUNT LOOP
1738:
1739: select ps_request_id into l_lock_id from pos_product_service_requests
1740: WHERE ps_request_id = p_req_id_tbl(i) for update nowait;
1741:
1742: END LOOP;
1743:

Line 2080: select ps_request_id into l_lock_id from pos_product_service_requests

2076: BEGIN
2077:
2078: for i in 1..p_req_id_tbl.COUNT LOOP
2079:
2080: select ps_request_id into l_lock_id from pos_product_service_requests
2081: WHERE ps_request_id = p_req_id_tbl(i) for update nowait;
2082:
2083: END LOOP;
2084: