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_AR_SUP_TRX_PKG dependencies on DUAL

Line 721: FROM DUAL;

717: /*Added the below by Bgowrava for Bug#6139693*/
718: CURSOR c_get_sup_seq_val
719: IS
720: SELECT JAI_AR_SUP_LINES_S.NEXTVAL
721: FROM DUAL;
722:
723: v_cust_trx_line_no_s NUMBER;
724: v_cust_trx_line_no_s1 NUMBER;
725: /*END, Bug#6139693*/

Line 2039: from dual;

2035:
2036:
2037: cursor c_legal_entity_id (cp_org_id NUMBER) IS
2038: SELECT XLE_UTILITIES_GRP.Get_DefaultLegalContext_OU( cp_org_id )
2039: from dual;
2040:
2041: /* Bug 4906958. Added by Lakshmi Gopalsami
2042: Get the value of legal entity from hr_operating_units
2043: if the above cursor is returning null.

Line 2082: --select JAI_AR_SUP_HDRS_ALL_S3.nextval into v_seq from dual;

2078: IF CHSN_FOR_CNSLDT = 'N' OR CHSN_FOR_CNSLDT IS NULL THEN
2079: FOR SUPP_INV IN GET_SUPP_INV
2080: LOOP
2081: if supp_inv.supp_inv_type = 'CR' then
2082: --select JAI_AR_SUP_HDRS_ALL_S3.nextval into v_seq from dual;
2083: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2084: elsif supp_inv.supp_inv_type = 'DB' then
2085: --select JAI_AR_SUP_HDRS_ALL_S2.nextval into v_seq from dual;
2086: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;

Line 2083: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;

2079: FOR SUPP_INV IN GET_SUPP_INV
2080: LOOP
2081: if supp_inv.supp_inv_type = 'CR' then
2082: --select JAI_AR_SUP_HDRS_ALL_S3.nextval into v_seq from dual;
2083: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2084: elsif supp_inv.supp_inv_type = 'DB' then
2085: --select JAI_AR_SUP_HDRS_ALL_S2.nextval into v_seq from dual;
2086: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2087: elsif supp_inv.supp_inv_type = 'SI' then

Line 2085: --select JAI_AR_SUP_HDRS_ALL_S2.nextval into v_seq from dual;

2081: if supp_inv.supp_inv_type = 'CR' then
2082: --select JAI_AR_SUP_HDRS_ALL_S3.nextval into v_seq from dual;
2083: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2084: elsif supp_inv.supp_inv_type = 'DB' then
2085: --select JAI_AR_SUP_HDRS_ALL_S2.nextval into v_seq from dual;
2086: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2087: elsif supp_inv.supp_inv_type = 'SI' then
2088: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2089: end if ;

Line 2086: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;

2082: --select JAI_AR_SUP_HDRS_ALL_S3.nextval into v_seq from dual;
2083: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2084: elsif supp_inv.supp_inv_type = 'DB' then
2085: --select JAI_AR_SUP_HDRS_ALL_S2.nextval into v_seq from dual;
2086: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2087: elsif supp_inv.supp_inv_type = 'SI' then
2088: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2089: end if ;
2090: open get_address(supp_inv.bill_to_site_use_id);

Line 2088: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;

2084: elsif supp_inv.supp_inv_type = 'DB' then
2085: --select JAI_AR_SUP_HDRS_ALL_S2.nextval into v_seq from dual;
2086: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2087: elsif supp_inv.supp_inv_type = 'SI' then
2088: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2089: end if ;
2090: open get_address(supp_inv.bill_to_site_use_id);
2091: fetch get_address into v_address;
2092: close get_address;

Line 2256: --select JAI_AR_SUP_HDRS_ALL_S3.nextval into v_seq from dual;

2252: Elsif CHSN_FOR_CNSLDT = 'Y' THEN
2253: for cnsldt_header in get_cnsldt_header
2254: loop
2255: IF cnsldt_header.supp_inv_type = 'CR' then
2256: --select JAI_AR_SUP_HDRS_ALL_S3.nextval into v_seq from dual;
2257: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2258: elsif cnsldt_header.supp_inv_type = 'DB' then
2259: --select JAI_AR_SUP_HDRS_ALL_S2.nextval into v_seq from dual;
2260: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;

Line 2257: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;

2253: for cnsldt_header in get_cnsldt_header
2254: loop
2255: IF cnsldt_header.supp_inv_type = 'CR' then
2256: --select JAI_AR_SUP_HDRS_ALL_S3.nextval into v_seq from dual;
2257: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2258: elsif cnsldt_header.supp_inv_type = 'DB' then
2259: --select JAI_AR_SUP_HDRS_ALL_S2.nextval into v_seq from dual;
2260: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2261: elsif cnsldt_header.supp_inv_type = 'SI' then

Line 2259: --select JAI_AR_SUP_HDRS_ALL_S2.nextval into v_seq from dual;

2255: IF cnsldt_header.supp_inv_type = 'CR' then
2256: --select JAI_AR_SUP_HDRS_ALL_S3.nextval into v_seq from dual;
2257: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2258: elsif cnsldt_header.supp_inv_type = 'DB' then
2259: --select JAI_AR_SUP_HDRS_ALL_S2.nextval into v_seq from dual;
2260: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2261: elsif cnsldt_header.supp_inv_type = 'SI' then
2262: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2263: end if ;

Line 2260: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;

2256: --select JAI_AR_SUP_HDRS_ALL_S3.nextval into v_seq from dual;
2257: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2258: elsif cnsldt_header.supp_inv_type = 'DB' then
2259: --select JAI_AR_SUP_HDRS_ALL_S2.nextval into v_seq from dual;
2260: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2261: elsif cnsldt_header.supp_inv_type = 'SI' then
2262: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2263: end if ;
2264:

Line 2262: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;

2258: elsif cnsldt_header.supp_inv_type = 'DB' then
2259: --select JAI_AR_SUP_HDRS_ALL_S2.nextval into v_seq from dual;
2260: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2261: elsif cnsldt_header.supp_inv_type = 'SI' then
2262: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2263: end if ;
2264:
2265: for inv_cnsldt in get_inv_cnsldt(cnsldt_header.set_of_books_id,cnsldt_header.customer_id,
2266: cnsldt_header.customer_site,cnsldt_header.supp_inv_type)