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 1269: v_tax_type JAI_CMN_RG_OTHERS.tax_type%TYPE;

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

Line 1270: v_dr_amt JAI_CMN_RG_OTHERS.debit%TYPE;

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

Line 1271: v_cr_amt JAI_CMN_RG_OTHERS.credit%TYPE;

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

Line 1305: INSERT INTO JAI_CMN_RG_OTHERS

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

Line 1321: (JAI_CMN_RG_OTHERS_S.nextval,

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

Line 2211: -- 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

2207: nvl(sum( decode(c.tax_type, 'CVD_EDUCATION_CESS', c.debit, 0)), 0) dr_cvd_edu_cess,
2208: 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
2209: nvl(sum( decode(c.tax_type, jai_constants.tax_type_sh_cvd_edu_cess, c.debit, 0)), 0) dr_sh_cvd_edu_cess,
2210: null transaction_date
2211: -- 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
2212: from JAI_CMN_RG_23AC_II_TRXS a, JAI_RCV_TRANSACTIONS b, JAI_CMN_RG_OTHERS c
2213: where a.RECEIPT_REF = b.transaction_id
2214: AND a.organization_id = p_organization_id
2215: AND c.source_type(+) = 1 -- this means register is JAI_CMN_RG_23AC_II_TRXS

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

2208: 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
2209: nvl(sum( decode(c.tax_type, jai_constants.tax_type_sh_cvd_edu_cess, c.debit, 0)), 0) dr_sh_cvd_edu_cess,
2210: null transaction_date
2211: -- 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
2212: from JAI_CMN_RG_23AC_II_TRXS a, JAI_RCV_TRANSACTIONS b, JAI_CMN_RG_OTHERS c
2213: where a.RECEIPT_REF = b.transaction_id
2214: AND a.organization_id = p_organization_id
2215: AND c.source_type(+) = 1 -- this means register is JAI_CMN_RG_23AC_II_TRXS
2216: AND a.register_id = c.source_register_id(+)

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

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

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

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

Line 2951: v_tax_type JAI_CMN_RG_OTHERS.tax_type%TYPE;

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

Line 2952: v_dr_amt JAI_CMN_RG_OTHERS.debit%TYPE;

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

Line 2953: v_cr_amt JAI_CMN_RG_OTHERS.credit%TYPE;

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

Line 2983: INSERT INTO JAI_CMN_RG_OTHERS (

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

Line 2999: JAI_CMN_RG_OTHERS_S.nextval,

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