APPS.JL_AR_DOC_NUMBERING_PKG dependencies on DUAL

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

289: INTO l_doc_letter, l_branch_num, l_cai_num, l_cai_date
290: FROM ra_batch_sources
291: WHERE batch_source_id = p_batch_source_id;
292:
293: SELECT REPLACE(l_cai_date,'/') INTO l_cai_date from dual;
294:
295: SELECT REPLACE(l_comp_cuit,'-') INTO l_comp_cuit from dual;
296:
297: EXCEPTION

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

291: WHERE batch_source_id = p_batch_source_id;
292:
293: SELECT REPLACE(l_cai_date,'/') INTO l_cai_date from dual;
294:
295: SELECT REPLACE(l_comp_cuit,'-') INTO l_comp_cuit from dual;
296:
297: EXCEPTION
298: WHEN OTHERS THEN
299: l_branch_num := NULL;

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

324: END IF;
325:
326: l_num_bar_code := l_comp_cuit||l_dgi_code||l_branch_num||l_cai_num||l_cai_date;
327:
328: Select length(l_num_bar_code) into l_leng from dual;
329:
330: l_count := 1;
331: l_odd_temp := 0;
332:

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

357:
358: l_temp := l_odd_temp + l_even_temp;
359:
360: -- Get the modulus of the sum
361: SELECT MOD(l_temp,10) into l_temp FROM dual;
362: -- Bug 8727000 FW Port of 11i Bug 8279519
363: -- MOD will return 0 if l_temp passed is multiple of 10
364: --In that case l_valid_digit will be 10-0 = 10 which is incorrect
365: IF l_temp = 0 then

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

898: RETURN VARCHAR2 IS
899: l_num_code VARCHAR2(50);
900: BEGIN
901:
902: SELECT substr(p_concat_segs,instr(p_concat_segs,''||p_flex_delimiter||'',1,4)+1) INTO l_num_code FROM dual;
903:
904: RETURN l_num_code;
905:
906: EXCEPTION

Line 1147: 'from dual' ;

1143:
1144:
1145: l_string := 'select '||
1146: l_seq_name||'.nextval seq_number '||
1147: 'from dual' ;
1148:
1149: execute immediate l_string into seq_no;
1150: l_trx_number := seq_no;
1151: