APPS.OKL_VP_CHANGE_REQUEST_PVT dependencies on OKL_VP_CHANGE_REQ_NUM_SEQ

Line 39: SELECT okl_vp_change_req_num_seq.NEXTVAL

35:
36: FUNCTION generate_change_req_num RETURN okl_vp_change_requests.change_request_number%TYPE IS
37: -- cursor to fetch the next available change request number
38: CURSOR c_get_next_cr_num IS
39: SELECT okl_vp_change_req_num_seq.NEXTVAL
40: FROM dual;
41: lv_new_change_request_number okl_vp_change_requests.change_request_number%TYPE;
42: BEGIN
43: OPEN c_get_next_cr_num; FETCH c_get_next_cr_num INTO lv_new_change_request_number;

Line 886: -- agreement number, and the change_request_number (using sequence okl_vp_change_req_num_seq)

882: lv_vcrv_rec.change_request_number := generate_change_req_num;
883:
884: -- construct the new internal agreement number that would serve as agreement number on the
885: -- new copied agreement record. the format is last 30 char of the concatenated string of
886: -- agreement number, and the change_request_number (using sequence okl_vp_change_req_num_seq)
887: -- lv_calc_agr_number finally returns last 30 characters of the concatenated value
888: -- if there are less than 30 char in the resultant string, then lv_calc_agr_number is as good as the resultant string
889: lv_calc_agr_number := TRIM(RPAD(SUBSTR(LPAD((lv_agreement_number || lv_vcrv_rec.change_request_number),120,' ') ,
890: length(LPAD((lv_agreement_number || lv_vcrv_rec.change_request_number),120,' ')) - 120),120, ' '));