eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_AP_TDS_ETDS_PKG dependencies on DUAL

Line 286: FROM dual) LOOP

282: (SELECT TRANSLATE(UPPER(substr(p_str, 1, 5)),'ABCDEFGHIJKLMNOPQRSTUVWXYZ','AAAAAAAAAAAAAAAAAAAAAAAAAA') src_str1,
283: TRANSLATE(substr(p_str, 6, 4),'0123456789','0000000000') src_str2,
284: TRANSLATE(UPPER(substr(p_str, 10, 1)),'ABCDEFGHIJKLMNOPQRSTUVWXYZ','AAAAAAAAAAAAAAAAAAAAAAAAAA') src_str3,
285: 'AAAAA0000A' dest_str
286: FROM dual) LOOP
287:
288: IF (i.src_str1 || i.src_str2 || i.src_str3) = i.dest_str or p_str in ('PANNOTAVBL', 'PANAPPLIED') then/*ETDS FVU3.1 Bug 11896260*/
289: lv_resp := 'VALID';
290: ELSE

Line 5266: substr(p_phone_no,0,(select instr(p_phone_no,'-')from dual)-1),

5262: /*Bug 10315928 - Start*/
5263: cursor c_split_phone_no(p_phone_no IN VARCHAR2)
5264: IS
5265: select
5266: substr(p_phone_no,0,(select instr(p_phone_no,'-')from dual)-1),
5267: substr(p_phone_no,(select instr(p_phone_no,'-')from dual)+1)
5268: from dual;
5269:
5270: --Here merge cursor to support software Vendor.

Line 5267: substr(p_phone_no,(select instr(p_phone_no,'-')from dual)+1)

5263: cursor c_split_phone_no(p_phone_no IN VARCHAR2)
5264: IS
5265: select
5266: substr(p_phone_no,0,(select instr(p_phone_no,'-')from dual)-1),
5267: substr(p_phone_no,(select instr(p_phone_no,'-')from dual)+1)
5268: from dual;
5269:
5270: --Here merge cursor to support software Vendor.
5271: --Changed by Zhiwei for Bug#15840480 FVU3.6 begin

Line 5268: from dual;

5264: IS
5265: select
5266: substr(p_phone_no,0,(select instr(p_phone_no,'-')from dual)-1),
5267: substr(p_phone_no,(select instr(p_phone_no,'-')from dual)+1)
5268: from dual;
5269:
5270: --Here merge cursor to support software Vendor.
5271: --Changed by Zhiwei for Bug#15840480 FVU3.6 begin
5272: ------------------------------------------------------------------------------------------------------

Line 6348: SELECT JAI_AP_ETDS_T_S.nextval INTO v_batch_id FROM DUAL;

6344:
6345: -- v_quart_form_number := '26Q';
6346: v_quart_form_number := p_form_number; --Date 11-05-2007 by Sacsethi for bug 5647248
6347:
6348: SELECT JAI_AP_ETDS_T_S.nextval INTO v_batch_id FROM DUAL;
6349:
6350: IF NVL(p_action,'X') <> 'V' THEN
6351: IF NVL(p_generate_headers,'X') = 'Y' or NVL(p_action,'X') = 'H' THEN
6352: jai_ap_tds_etds_pkg.v_debug_pad_char := ' ';