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_CMN_RGM_TAX_DIST_PKG dependencies on JAI_RGM_DIS_SRC_HDRS

Line 252: Fix: Added cursor c_get_src_rec to fetch distribution number from jai_rgm_dis_src_hdrs

248: Fix : changes are done in populate_all_orgs_vat procedure.
249:
250: 27 01-Feb-2012 amandali for bug 13534704
251: Issue: Distribution number not matching with invoice number in RG 23 Part II view transactions form
252: Fix: Added cursor c_get_src_rec to fetch distribution number from jai_rgm_dis_src_hdrs
253: the parameter p_excise_invoice_no in procedure call create_io_register_entry has been modified to distribution number rather
254: than the transfer id prefixed with Distribution
255:
256: 28 21-mar-2012 vkaranam for bug#13865856

Line 2252: cursor c_get_src_rec ( cp_transfer_id jai_rgm_dis_src_hdrs.transfer_id%type

2248: FROM jai_rgm_dis_des_taxes
2249: WHERE transfer_destination_id = cp_transfer_dest_id
2250: and tax_type in ('SERVICE_SH_EDU_CESS','EXCISE_SH_EDU_CESS');
2251: /* bug 13534704 */
2252: cursor c_get_src_rec ( cp_transfer_id jai_rgm_dis_src_hdrs.transfer_id%type
2253: , cp_party_type jai_rgm_dis_src_hdrs.party_type%type
2254: , cp_party_id jai_rgm_dis_src_hdrs.party_id%type
2255: )
2256: is

Line 2253: , cp_party_type jai_rgm_dis_src_hdrs.party_type%type

2249: WHERE transfer_destination_id = cp_transfer_dest_id
2250: and tax_type in ('SERVICE_SH_EDU_CESS','EXCISE_SH_EDU_CESS');
2251: /* bug 13534704 */
2252: cursor c_get_src_rec ( cp_transfer_id jai_rgm_dis_src_hdrs.transfer_id%type
2253: , cp_party_type jai_rgm_dis_src_hdrs.party_type%type
2254: , cp_party_id jai_rgm_dis_src_hdrs.party_id%type
2255: )
2256: is
2257: select transfer_number

Line 2254: , cp_party_id jai_rgm_dis_src_hdrs.party_id%type

2250: and tax_type in ('SERVICE_SH_EDU_CESS','EXCISE_SH_EDU_CESS');
2251: /* bug 13534704 */
2252: cursor c_get_src_rec ( cp_transfer_id jai_rgm_dis_src_hdrs.transfer_id%type
2253: , cp_party_type jai_rgm_dis_src_hdrs.party_type%type
2254: , cp_party_id jai_rgm_dis_src_hdrs.party_id%type
2255: )
2256: is
2257: select transfer_number
2258: from jai_rgm_dis_src_hdrs

Line 2258: from jai_rgm_dis_src_hdrs

2254: , cp_party_id jai_rgm_dis_src_hdrs.party_id%type
2255: )
2256: is
2257: select transfer_number
2258: from jai_rgm_dis_src_hdrs
2259: where party_type = cp_party_type
2260: and party_id = cp_party_id
2261: and transfer_id = cp_transfer_id;
2262: ln_transfer_number number;

Line 2269: SELECT jai_rgm_dis_src_hdrs_s.nextval ,

2265: BEGIN
2266:
2267: IF p_called_from = 'SETTLEMENT' THEN
2268:
2269: SELECT jai_rgm_dis_src_hdrs_s.nextval ,
2270: JAI_RGM_DIS_SRC_TAXES_S.nextval ,
2271: jai_rgm_dis_des_hdrs_s.nextval ,
2272: JAI_RGM_DIS_DES_TAXES_S.nextval ,
2273: JAI_RGM_DIS_TRF_NUMS_S.nextval

Line 2280: INSERT INTO jai_rgm_dis_src_hdrs

2276: ln_transfer_dest_id ,
2277: ln_transfer_dest_line_id ,
2278: lv_transfer_num
2279: FROM dual;
2280: INSERT INTO jai_rgm_dis_src_hdrs
2281: (
2282: TRANSFER_ID ,
2283: PARTY_ID ,
2284: PARTY_TYPE ,