APPS.JL_AR_DOC_NUMBERING_PKG dependencies on DUAL

Line 286: SELECT REPLACE(l_cai_date,'/') INTO l_cai_date from dual;

282: INTO l_doc_letter, l_branch_num, l_cai_num, l_cai_date
283: FROM ra_batch_sources
284: WHERE batch_source_id = p_batch_source_id;
285:
286: SELECT REPLACE(l_cai_date,'/') INTO l_cai_date from dual;
287:
288: SELECT REPLACE(l_comp_cuit,'-') INTO l_comp_cuit from dual;
289:
290: EXCEPTION

Line 288: SELECT REPLACE(l_comp_cuit,'-') INTO l_comp_cuit from dual;

284: WHERE batch_source_id = p_batch_source_id;
285:
286: SELECT REPLACE(l_cai_date,'/') INTO l_cai_date from dual;
287:
288: SELECT REPLACE(l_comp_cuit,'-') INTO l_comp_cuit from dual;
289:
290: EXCEPTION
291: WHEN OTHERS THEN
292: l_branch_num := NULL;

Line 321: Select length(l_num_bar_code) into l_leng from dual;

317: END IF;
318:
319: l_num_bar_code := l_comp_cuit||l_dgi_code||l_branch_num||l_cai_num||l_cai_date;
320:
321: Select length(l_num_bar_code) into l_leng from dual;
322:
323: l_count := 1;
324: l_odd_temp := 0;
325:

Line 354: SELECT MOD(l_temp,10) into l_temp FROM dual;

350:
351: l_temp := l_odd_temp + l_even_temp;
352:
353: -- Get the modulus of the sum
354: SELECT MOD(l_temp,10) into l_temp FROM dual;
355:
356: -- Validation Digit is equivalent to 10 - modulus
357: l_valid_digit := to_char(10 - l_temp);
358:

Line 888: SELECT substr(p_concat_segs,instr(p_concat_segs,''||p_flex_delimiter||'',1,4)+1) INTO l_num_code FROM dual;

884: RETURN VARCHAR2 IS
885: l_num_code VARCHAR2(50);
886: BEGIN
887:
888: SELECT substr(p_concat_segs,instr(p_concat_segs,''||p_flex_delimiter||'',1,4)+1) INTO l_num_code FROM dual;
889:
890: RETURN l_num_code;
891:
892: EXCEPTION

Line 1133: 'from dual' ;

1129:
1130:
1131: l_string := 'select '||
1132: l_seq_name||'.nextval seq_number '||
1133: 'from dual' ;
1134:
1135: execute immediate l_string into seq_no;
1136: l_trx_number := seq_no;
1137: