49:
50: CURSOR check1 IS
51: SELECT bordero_status,
52: bordero_type
53: FROM jl_br_ar_borderos
54: WHERE bordero_id = param_bordero_id
55: AND bordero_status in ('SELECTED', 'FORMATTED')
56: FOR UPDATE NOWAIT;
57:
62: FOR UPDATE NOWAIT;
63:
64: CURSOR c1 IS
65: SELECT bordero_status
66: FROM jl_br_ar_borderos
67: WHERE selection_control_id = param_select_control
68: AND select_account_id = param_select_account_id;
69: CURSOR c3 IS
70: SELECT document_status,
118: var_status := 'CANCELED';
119: var_cancel_date := sysdate;
120: END IF;
121:
122: UPDATE jl_br_ar_borderos SET
123: bordero_status = var_status,
124: cancellation_date = var_cancel_date
125: WHERE bordero_id = param_bordero_id;
126: commit;