APPS.JL_BR_AR_CANCEL_BORDERO dependencies on JL_BR_AR_BORDEROS

Line 54: FROM jl_br_ar_borderos

50:
51: CURSOR check1 IS
52: SELECT bordero_status,
53: bordero_type
54: FROM jl_br_ar_borderos
55: WHERE bordero_id = param_bordero_id
56: AND bordero_status in ('SELECTED', 'FORMATTED')
57: FOR UPDATE NOWAIT;
58:

Line 67: FROM jl_br_ar_borderos

63: FOR UPDATE NOWAIT;
64:
65: CURSOR c1 IS
66: SELECT bordero_status
67: FROM jl_br_ar_borderos
68: WHERE selection_control_id = param_select_control
69: AND select_account_id = param_select_account_id;
70: CURSOR c3 IS
71: SELECT document_status,

Line 124: UPDATE jl_br_ar_borderos SET

120: var_status := 'CANCELED';
121: var_cancel_date := sysdate;
122: END IF;
123:
124: UPDATE jl_br_ar_borderos SET
125: bordero_status = var_status,
126: cancellation_date = var_cancel_date
127: WHERE bordero_id = param_bordero_id;
128: --commit;