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_RCV_RND_PKG dependencies on JAI_CMN_RG_OTHERS

Line 154: from JAI_CMN_RG_OTHERS a

150: p_location_id IN NUMBER,
151: p_register_type IN VARCHAR2,
152: p_tax_type IN VARCHAR2) is
153: Select nvl(a.closing_balance,0) closing_balance
154: from JAI_CMN_RG_OTHERS a
155: Where a.source_type = 1 --1 is for JAI_CMN_RG_23AC_II_TRXS
156: AND a.source_register = DECODE(p_register_type,'A',jai_constants.reg_rg23a_2, 'C', jai_constants.reg_rg23c_2) --'RG23A_P2','C','RG23C_P2')
157: and a.tax_type = p_tax_type
158: AND abs(a.source_register_id) IN (Select max(abs(c.source_register_id))

Line 160: JAI_CMN_RG_OTHERS c

156: AND a.source_register = DECODE(p_register_type,'A',jai_constants.reg_rg23a_2, 'C', jai_constants.reg_rg23c_2) --'RG23A_P2','C','RG23C_P2')
157: and a.tax_type = p_tax_type
158: AND abs(a.source_register_id) IN (Select max(abs(c.source_register_id))
159: from JAI_CMN_RG_23AC_II_TRXS b,
160: JAI_CMN_RG_OTHERS c
161: Where c.source_type = 1 --1 is for JAI_CMN_RG_23AC_II_TRXS
162: AND c.source_register = DECODE(p_register_type,'A',jai_constants.reg_rg23a_2, 'C', jai_constants.reg_rg23c_2) --'RG23A_P2','C','RG23C_P2')
163: AND b.register_id = c.source_register_id
164: AND b.organization_id = p_organization_id

Line 1270: v_tax_type JAI_CMN_RG_OTHERS.tax_type%TYPE;

1266:
1267: ) RETURNING register_id INTO v_register_id_part_ii;
1268:
1269: DECLARE
1270: v_tax_type JAI_CMN_RG_OTHERS.tax_type%TYPE;
1271: v_dr_amt JAI_CMN_RG_OTHERS.debit%TYPE;
1272: v_cr_amt JAI_CMN_RG_OTHERS.credit%TYPE;
1273: BEGIN
1274:

Line 1271: v_dr_amt JAI_CMN_RG_OTHERS.debit%TYPE;

1267: ) RETURNING register_id INTO v_register_id_part_ii;
1268:
1269: DECLARE
1270: v_tax_type JAI_CMN_RG_OTHERS.tax_type%TYPE;
1271: v_dr_amt JAI_CMN_RG_OTHERS.debit%TYPE;
1272: v_cr_amt JAI_CMN_RG_OTHERS.credit%TYPE;
1273: BEGIN
1274:
1275: FOR I in 1..4 LOOP -- Date 16/04/2007 by sacsethi for Bug#5989740

Line 1272: v_cr_amt JAI_CMN_RG_OTHERS.credit%TYPE;

1268:
1269: DECLARE
1270: v_tax_type JAI_CMN_RG_OTHERS.tax_type%TYPE;
1271: v_dr_amt JAI_CMN_RG_OTHERS.debit%TYPE;
1272: v_cr_amt JAI_CMN_RG_OTHERS.credit%TYPE;
1273: BEGIN
1274:
1275: FOR I in 1..4 LOOP -- Date 16/04/2007 by sacsethi for Bug#5989740
1276:

Line 1306: INSERT INTO JAI_CMN_RG_OTHERS

1302: -- end 5989740
1303: end if;
1304:
1305: IF NVL(v_dr_amt,0) <> 0 OR NVL(v_cr_amt,0) <> 0 THEN
1306: INSERT INTO JAI_CMN_RG_OTHERS
1307: (RG_OTHER_ID,
1308: SOURCE_TYPE,
1309: SOURCE_REGISTER,
1310: SOURCE_REGISTER_ID,

Line 1322: (JAI_CMN_RG_OTHERS_S.nextval,

1318: LAST_UPDATED_BY,
1319: LAST_UPDATE_DATE,
1320: LAST_UPDATE_LOGIN)
1321: VALUES
1322: (JAI_CMN_RG_OTHERS_S.nextval,
1323: 1,
1324: DECODE(v_register_type,'A','RG23A_P2','C','RG23C_P2'),/*for bug 5054176*/
1325: v_register_id_part_ii,
1326: v_tax_type,

Line 2212: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. from JAI_CMN_RG_23AC_II_TRXS a, rcv_transactions b, JAI_CMN_RG_OTHERS c

2208: nvl(sum( decode(c.tax_type, 'CVD_EDUCATION_CESS', c.debit, 0)), 0) dr_cvd_edu_cess,
2209: nvl(sum( decode(c.tax_type, jai_constants.tax_type_sh_exc_edu_cess, c.debit, 0)), 0) dr_sh_exc_edu_cess, -- Date 16/04/2007 by sacsethi for Bug#5989740
2210: nvl(sum( decode(c.tax_type, jai_constants.tax_type_sh_cvd_edu_cess, c.debit, 0)), 0) dr_sh_cvd_edu_cess,
2211: null transaction_date
2212: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. from JAI_CMN_RG_23AC_II_TRXS a, rcv_transactions b, JAI_CMN_RG_OTHERS c
2213: from JAI_CMN_RG_23AC_II_TRXS a, JAI_RCV_TRANSACTIONS b, JAI_CMN_RG_OTHERS c
2214: where a.RECEIPT_REF = b.transaction_id
2215: AND a.organization_id = p_organization_id
2216: AND c.source_type(+) = 1 -- this means register is JAI_CMN_RG_23AC_II_TRXS

Line 2213: from JAI_CMN_RG_23AC_II_TRXS a, JAI_RCV_TRANSACTIONS b, JAI_CMN_RG_OTHERS c

2209: nvl(sum( decode(c.tax_type, jai_constants.tax_type_sh_exc_edu_cess, c.debit, 0)), 0) dr_sh_exc_edu_cess, -- Date 16/04/2007 by sacsethi for Bug#5989740
2210: nvl(sum( decode(c.tax_type, jai_constants.tax_type_sh_cvd_edu_cess, c.debit, 0)), 0) dr_sh_cvd_edu_cess,
2211: null transaction_date
2212: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. from JAI_CMN_RG_23AC_II_TRXS a, rcv_transactions b, JAI_CMN_RG_OTHERS c
2213: from JAI_CMN_RG_23AC_II_TRXS a, JAI_RCV_TRANSACTIONS b, JAI_CMN_RG_OTHERS c
2214: where a.RECEIPT_REF = b.transaction_id
2215: AND a.organization_id = p_organization_id
2216: AND c.source_type(+) = 1 -- this means register is JAI_CMN_RG_23AC_II_TRXS
2217: AND a.register_id = c.source_register_id(+)

Line 2274: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. from JAI_CMN_RG_PLA_TRXS a, rcv_transactions b, JAI_CMN_RG_OTHERS c

2270: nvl(sum( decode(c.tax_type, 'EXCISE_SH_EDU_CESS', c.debit, 0)), 0) dr_sh_exc_edu_cess,
2271: nvl(sum( decode(c.tax_type, 'CVD_SH_EDU_CESS', c.debit, 0)), 0) dr_sh_cvd_edu_cess,
2272: -- end
2273: max(a.transaction_date) transaction_date
2274: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. from JAI_CMN_RG_PLA_TRXS a, rcv_transactions b, JAI_CMN_RG_OTHERS c
2275: from JAI_CMN_RG_PLA_TRXS a, JAI_RCV_TRANSACTIONS b, JAI_CMN_RG_OTHERS c
2276: where a.ref_document_id = b.transaction_id
2277: AND a.organization_id = p_organization_id
2278: AND c.source_type(+) = 2 -- this means register is JAI_CMN_RG_PLA_TRXS

Line 2275: from JAI_CMN_RG_PLA_TRXS a, JAI_RCV_TRANSACTIONS b, JAI_CMN_RG_OTHERS c

2271: nvl(sum( decode(c.tax_type, 'CVD_SH_EDU_CESS', c.debit, 0)), 0) dr_sh_cvd_edu_cess,
2272: -- end
2273: max(a.transaction_date) transaction_date
2274: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. from JAI_CMN_RG_PLA_TRXS a, rcv_transactions b, JAI_CMN_RG_OTHERS c
2275: from JAI_CMN_RG_PLA_TRXS a, JAI_RCV_TRANSACTIONS b, JAI_CMN_RG_OTHERS c
2276: where a.ref_document_id = b.transaction_id
2277: AND a.organization_id = p_organization_id
2278: AND c.source_type(+) = 2 -- this means register is JAI_CMN_RG_PLA_TRXS
2279: AND a.register_id = c.source_register_id(+)

Line 2954: v_tax_type JAI_CMN_RG_OTHERS.tax_type%TYPE;

2950: ) RETURNING register_id INTO v_register_id_part_ii;
2951: end if;
2952:
2953: DECLARE
2954: v_tax_type JAI_CMN_RG_OTHERS.tax_type%TYPE;
2955: v_dr_amt JAI_CMN_RG_OTHERS.debit%TYPE;
2956: v_cr_amt JAI_CMN_RG_OTHERS.credit%TYPE;
2957: BEGIN
2958: FOR I in 1..4 LOOP -- Date 16/04/2007 by sacsethi for Bug#5989740 changed the loop counter from 2 to 4

Line 2955: v_dr_amt JAI_CMN_RG_OTHERS.debit%TYPE;

2951: end if;
2952:
2953: DECLARE
2954: v_tax_type JAI_CMN_RG_OTHERS.tax_type%TYPE;
2955: v_dr_amt JAI_CMN_RG_OTHERS.debit%TYPE;
2956: v_cr_amt JAI_CMN_RG_OTHERS.credit%TYPE;
2957: BEGIN
2958: FOR I in 1..4 LOOP -- Date 16/04/2007 by sacsethi for Bug#5989740 changed the loop counter from 2 to 4
2959:

Line 2956: v_cr_amt JAI_CMN_RG_OTHERS.credit%TYPE;

2952:
2953: DECLARE
2954: v_tax_type JAI_CMN_RG_OTHERS.tax_type%TYPE;
2955: v_dr_amt JAI_CMN_RG_OTHERS.debit%TYPE;
2956: v_cr_amt JAI_CMN_RG_OTHERS.credit%TYPE;
2957: BEGIN
2958: FOR I in 1..4 LOOP -- Date 16/04/2007 by sacsethi for Bug#5989740 changed the loop counter from 2 to 4
2959:
2960: if i = 1 then

Line 2986: INSERT INTO JAI_CMN_RG_OTHERS (

2982: fnd_file.put_line(fnd_file.log, '5-Before Insert of RG Others.Amts:dr-'||v_dr_amt||',cr-'||v_cr_amt );
2983: end if;
2984:
2985: IF NVL(v_dr_amt,0) <> 0 OR NVL(v_cr_amt,0) <> 0 THEN
2986: INSERT INTO JAI_CMN_RG_OTHERS (
2987: RG_OTHER_ID,
2988: SOURCE_TYPE,
2989: SOURCE_REGISTER,
2990: SOURCE_REGISTER_ID,

Line 3002: JAI_CMN_RG_OTHERS_S.nextval,

2998: LAST_UPDATED_BY,
2999: LAST_UPDATE_DATE,
3000: LAST_UPDATE_LOGIN
3001: ) VALUES (
3002: JAI_CMN_RG_OTHERS_S.nextval,
3003: DECODE(r.register, LV_PLA_REGISTER, 2, 1),
3004: DECODE(r.register, LV_PLA_REGISTER, 'PLA', decode(v_register_type,'A','RG23A_P2','C','RG23C_P2')),/*for bug 5054176*/
3005: v_register_id_part_ii,
3006: v_tax_type,