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_CONSTANTS

Line 398: WHERE --regime_code = jai_constants.vat_regime -- commneted by mmurtuza for bug 12641455

394: IS
395: SELECT organization_id,
396: location_id
397: FROM jai_rgm_org_regns_v
398: WHERE --regime_code = jai_constants.vat_regime -- commneted by mmurtuza for bug 12641455
399: regime_id = cp_regime_id -- added by mmurtuza for bug 12641455
400: AND attribute_code ='REGISTRATION_NO'
401: AND attribute_value = cp_regn_no
402: AND registration_id = cp_regn_id

Line 639: AND register_type IN (jai_constants.reg_rg23a ,jai_constants.reg_rg23c)--rchandan for bug#4428980

635: CURSOR c_cess_balance (cp_org_unit_id number) is
636: SELECT SUM(balance)
637: FROM JAI_CMN_RG_OTH_BALANCES
638: WHERE org_unit_id = cp_org_unit_id
639: AND register_type IN (jai_constants.reg_rg23a ,jai_constants.reg_rg23c)--rchandan for bug#4428980
640: AND tax_type IN (jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_exc_edu_cess);--rchandan for bug#4428980
641: ln_cess_balance number :=0;
642: /* Bug 4568078. Added by Lakshmi Gopalsami */
643:

Line 640: AND tax_type IN (jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_exc_edu_cess);--rchandan for bug#4428980

636: SELECT SUM(balance)
637: FROM JAI_CMN_RG_OTH_BALANCES
638: WHERE org_unit_id = cp_org_unit_id
639: AND register_type IN (jai_constants.reg_rg23a ,jai_constants.reg_rg23c)--rchandan for bug#4428980
640: AND tax_type IN (jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_exc_edu_cess);--rchandan for bug#4428980
641: ln_cess_balance number :=0;
642: /* Bug 4568078. Added by Lakshmi Gopalsami */
643:
644: CURSOR c_pla_cess_balance (cp_org_unit_id number) is

Line 648: AND register_type = jai_constants.reg_pla

644: CURSOR c_pla_cess_balance (cp_org_unit_id number) is
645: SELECT SUM(balance)
646: FROM JAI_CMN_RG_OTH_BALANCES
647: WHERE org_unit_id = cp_org_unit_id
648: AND register_type = jai_constants.reg_pla
649: AND tax_type IN (jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_exc_edu_cess) ;
650:
651: --added by csahoo for bug#6109941, start
652: CURSOR c_sh_cess_balance (cp_org_unit_id number) is

Line 649: AND tax_type IN (jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_exc_edu_cess) ;

645: SELECT SUM(balance)
646: FROM JAI_CMN_RG_OTH_BALANCES
647: WHERE org_unit_id = cp_org_unit_id
648: AND register_type = jai_constants.reg_pla
649: AND tax_type IN (jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_exc_edu_cess) ;
650:
651: --added by csahoo for bug#6109941, start
652: CURSOR c_sh_cess_balance (cp_org_unit_id number) is
653: SELECT SUM(balance)

Line 656: AND register_type IN (jai_constants.reg_rg23a ,jai_constants.reg_rg23c)

652: CURSOR c_sh_cess_balance (cp_org_unit_id number) is
653: SELECT SUM(balance)
654: FROM JAI_CMN_RG_OTH_BALANCES
655: WHERE org_unit_id = cp_org_unit_id
656: AND register_type IN (jai_constants.reg_rg23a ,jai_constants.reg_rg23c)
657: AND tax_type IN (jai_constants.tax_type_sh_cvd_edu_cess,jai_constants.tax_type_sh_exc_edu_cess);
658:
659:
660:

Line 657: AND tax_type IN (jai_constants.tax_type_sh_cvd_edu_cess,jai_constants.tax_type_sh_exc_edu_cess);

653: SELECT SUM(balance)
654: FROM JAI_CMN_RG_OTH_BALANCES
655: WHERE org_unit_id = cp_org_unit_id
656: AND register_type IN (jai_constants.reg_rg23a ,jai_constants.reg_rg23c)
657: AND tax_type IN (jai_constants.tax_type_sh_cvd_edu_cess,jai_constants.tax_type_sh_exc_edu_cess);
658:
659:
660:
661: CURSOR c_sh_pla_cess_balance (cp_org_unit_id number) is

Line 665: AND register_type = jai_constants.reg_pla

661: CURSOR c_sh_pla_cess_balance (cp_org_unit_id number) is
662: SELECT SUM(balance)
663: FROM JAI_CMN_RG_OTH_BALANCES
664: WHERE org_unit_id = cp_org_unit_id
665: AND register_type = jai_constants.reg_pla
666: AND tax_type IN (jai_constants.tax_type_sh_cvd_edu_cess,jai_constants.tax_type_sh_exc_edu_cess) ;
667:
668: ln_sh_cess_balance number :=0;
669: ln_sh_pla_cess_balance NUMBER :=0;

Line 666: AND tax_type IN (jai_constants.tax_type_sh_cvd_edu_cess,jai_constants.tax_type_sh_exc_edu_cess) ;

662: SELECT SUM(balance)
663: FROM JAI_CMN_RG_OTH_BALANCES
664: WHERE org_unit_id = cp_org_unit_id
665: AND register_type = jai_constants.reg_pla
666: AND tax_type IN (jai_constants.tax_type_sh_cvd_edu_cess,jai_constants.tax_type_sh_exc_edu_cess) ;
667:
668: ln_sh_cess_balance number :=0;
669: ln_sh_pla_cess_balance NUMBER :=0;
670: ln_sh_debit_amt NUMBER :=0;

Line 865: ELSIF lv_regime = jai_constants.tcs_regime THEN

861: AND regime_code = lv_regime --added for bug#8289991
862: AND trunc(transaction_date) <= p_balance_date /*bug 9445836*/
863: AND settlement_id IS NULL;
864:
865: ELSIF lv_regime = jai_constants.tcs_regime THEN
866: UPDATE JAI_RGM_REFS_ALL
867: SET SETTLEMENT_ID = P_SETTLEMENT_ID
868: WHERE ORG_TAN_NO = P_TAN_NO AND
869: ITEM_CLASSIFICATION = P_ITEM_CLASSIFICATION AND

Line 1213: IF lv_regime_code = jai_constants.service_regime THEN

1209: FETCH c_regime_code INTO lv_regime_code;
1210: CLOSE c_regime_code;
1211:
1212: IF p_called_from = 'SETTLEMENT' THEN
1213: IF lv_regime_code = jai_constants.service_regime THEN
1214: lv_source_trx_type := 'Invoice Payment';--rchandan for bug#4428980
1215:
1216: /**start additions for bug#11821537 by vkaranam,budget 2011 phase2 **/
1217: open get_crptg_utilize_st(p_regime_id);

Line 1362: -- ln_utilization_amount := round(ln_total_debit_balance*nvl(ln_crptg_utilize_st,0)/100, jai_constants.service_rgm_rnd_factor);

1358: /**start additions for bug#11821537 by vkaranam,budget 2011 phase2,calculation logic for jai_rgm_stl_balances.credit_utilized
1359: column based on the ST credit utilization ptg provided on the regime registration setup **/
1360: ln_total_debit_balance := nvl(ln_settled_debit_balance,0) + delta_rec.debit_amt ;
1361: ln_total_credit_balance := nvl(ln_settled_credit_balance,0) + delta_rec.credit_amt ;
1362: -- ln_utilization_amount := round(ln_total_debit_balance*nvl(ln_crptg_utilize_st,0)/100, jai_constants.service_rgm_rnd_factor);
1363: ln_utilization_amount := ln_total_debit_balance*nvl(ln_crptg_utilize_st,0)/100; --removed the round function for 11821537 (qa bug# 11923714)
1364:
1365:
1366: if ln_crptg_utilize_st is not null

Line 1410: ELSIF lv_regime_code = jai_constants.vat_regime THEN /* 4245365*/

1406: p_location_id => p_location_id, /*Bug 5879769 bduvarag*/
1407: p_org_id => p_org_id /*added by ssawant for bug 5662296*/
1408: ,p_reverse_charge_flag => p_reverse_charge_flag --Added by Qiong for reverse charge settlement
1409: );
1410: ELSIF lv_regime_code = jai_constants.vat_regime THEN /* 4245365*/
1411: /*Even though VAT is for IO , balances are calculated similar to an OU. i.e from
1412: jai_rgm_trx_records. hence the implementation is done in this procedure only*/
1413: lv_source_trx_type := 'Invoice Payment';--rchandan for bug#4428980
1414: FOR delta_rec in

Line 1605: AND registration_type = jai_constants.regn_type_tax_types

1601: FROM jai_rgm_org_regns_v
1602: WHERE organization_id = p_org_id
1603: AND location_id = p_location_id
1604: AND organization_type = p_org_type
1605: AND registration_type = jai_constants.regn_type_tax_types
1606: AND regime_code = lv_regime_code
1607: )
1608: LOOP
1609:

Line 1844: IF LV_REGIME_CODE = JAI_CONSTANTS.TCS_REGIME THEN

1840: OPEN C_REGIME_CODE;
1841: FETCH C_REGIME_CODE INTO LV_REGIME_CODE;
1842: CLOSE C_REGIME_CODE;
1843:
1844: IF LV_REGIME_CODE = JAI_CONSTANTS.TCS_REGIME THEN
1845: FOR DELTA_REC IN
1846: (
1847: SELECT SUM(DECODE(SIGN(JRT.TAX_AMT),-1,-1 * JRT.TAX_AMT,1,0)) CREDIT_AMOUNT,
1848: SUM(DECODE(SIGN(JRT.TAX_AMT),1,JRT.TAX_AMT,-1,0)) DEBIT_AMOUNT,

Line 2008: IF LV_REGIME_CODE = JAI_CONSTANTS.TCS_REGIME THEN

2004: -- CURSOR AND CALCULATE RGM BALANCES IS ADDED TO PROVIDE TCS FUNCTIONALITY
2005: OPEN CUR_REGIME_CODE( P_REGIME_ID);
2006: FETCH CUR_REGIME_CODE INTO LV_REGIME_CODE;
2007: CLOSE CUR_REGIME_CODE;
2008: IF LV_REGIME_CODE = JAI_CONSTANTS.TCS_REGIME THEN
2009: calculate_rgm_balances( p_regime_id => p_regime_id ,
2010: p_balance_date => p_balance_date ,
2011: p_request_id => p_request_id ,
2012: p_org_id => p_org_id ,

Line 2241: -- and tax_type in (lv_excise_cess,jai_constants.tax_type_service_edu_cess, jai_constants.tax_type_sh_service_edu_cess); --rchandan for bug#4428980

2237: CURSOR c_cess_amt(cp_transfer_dest_id number) IS
2238: SELECT transfer_amount
2239: FROM JAI_RGM_DIS_DES_TAXES
2240: WHERE transfer_destination_id = cp_transfer_dest_id
2241: -- and tax_type in (lv_excise_cess,jai_constants.tax_type_service_edu_cess, jai_constants.tax_type_sh_service_edu_cess); --rchandan for bug#4428980
2242: --commented the above and added the below by Sanjikum for Bug#6119459
2243: and tax_type in ('EXCISE-CESS','SERVICE_EDUCATION_CESS');
2244:
2245: --Added the below by kunkumar for bug#6127194

Line 2415: AND p_from_tax_type IN (jai_constants.tax_type_service, jai_constants.tax_type_service_edu_cess,

2411: /*Bug 5879769 bduvarag start*/
2412: IF p_from_party_type IN ( 'OU' )
2413: OR
2414: ( p_from_party_type = 'IO'
2415: AND p_from_tax_type IN (jai_constants.tax_type_service, jai_constants.tax_type_service_edu_cess,
2416: jai_constants.tax_type_sh_service_edu_cess)) THEN -- added, Harshita for Bug 5694855
2417: --Modified by kunkumar for Bug#6127194
2418: /*Bug 5879769 bduvarag end*/
2419:

Line 2416: jai_constants.tax_type_sh_service_edu_cess)) THEN -- added, Harshita for Bug 5694855

2412: IF p_from_party_type IN ( 'OU' )
2413: OR
2414: ( p_from_party_type = 'IO'
2415: AND p_from_tax_type IN (jai_constants.tax_type_service, jai_constants.tax_type_service_edu_cess,
2416: jai_constants.tax_type_sh_service_edu_cess)) THEN -- added, Harshita for Bug 5694855
2417: --Modified by kunkumar for Bug#6127194
2418: /*Bug 5879769 bduvarag end*/
2419:
2420: lv_acct_req_flag := jai_constants.YES;

Line 2420: lv_acct_req_flag := jai_constants.YES;

2416: jai_constants.tax_type_sh_service_edu_cess)) THEN -- added, Harshita for Bug 5694855
2417: --Modified by kunkumar for Bug#6127194
2418: /*Bug 5879769 bduvarag end*/
2419:
2420: lv_acct_req_flag := jai_constants.YES;
2421:
2422: IF p_source = 'SETTLEMENT' THEN
2423: lv_source := jai_constants.source_settle_out ;
2424: -- lv_balancing_entry := jai_constants.NO; --added by nprashar for bug # 7525691 commented for bug#6773684

Line 2423: lv_source := jai_constants.source_settle_out ;

2419:
2420: lv_acct_req_flag := jai_constants.YES;
2421:
2422: IF p_source = 'SETTLEMENT' THEN
2423: lv_source := jai_constants.source_settle_out ;
2424: -- lv_balancing_entry := jai_constants.NO; --added by nprashar for bug # 7525691 commented for bug#6773684
2425: ELSIF p_source = 'DISTRIBUTION' THEN
2426: /*bug 7525691*/
2427: if p_from_tax_type IN (jai_constants.tax_type_service, jai_constants.tax_type_service_edu_cess,jai_constants.tax_type_sh_service_edu_cess)

Line 2424: -- lv_balancing_entry := jai_constants.NO; --added by nprashar for bug # 7525691 commented for bug#6773684

2420: lv_acct_req_flag := jai_constants.YES;
2421:
2422: IF p_source = 'SETTLEMENT' THEN
2423: lv_source := jai_constants.source_settle_out ;
2424: -- lv_balancing_entry := jai_constants.NO; --added by nprashar for bug # 7525691 commented for bug#6773684
2425: ELSIF p_source = 'DISTRIBUTION' THEN
2426: /*bug 7525691*/
2427: if p_from_tax_type IN (jai_constants.tax_type_service, jai_constants.tax_type_service_edu_cess,jai_constants.tax_type_sh_service_edu_cess)
2428: and p_to_tax_type IN (jai_constants.tax_type_service, jai_constants.tax_type_service_edu_cess,jai_constants.tax_type_sh_service_edu_cess )

Line 2427: if p_from_tax_type IN (jai_constants.tax_type_service, jai_constants.tax_type_service_edu_cess,jai_constants.tax_type_sh_service_edu_cess)

2423: lv_source := jai_constants.source_settle_out ;
2424: -- lv_balancing_entry := jai_constants.NO; --added by nprashar for bug # 7525691 commented for bug#6773684
2425: ELSIF p_source = 'DISTRIBUTION' THEN
2426: /*bug 7525691*/
2427: if p_from_tax_type IN (jai_constants.tax_type_service, jai_constants.tax_type_service_edu_cess,jai_constants.tax_type_sh_service_edu_cess)
2428: and p_to_tax_type IN (jai_constants.tax_type_service, jai_constants.tax_type_service_edu_cess,jai_constants.tax_type_sh_service_edu_cess )
2429: then
2430: lv_distribution_type:='S-S';
2431: end if;

Line 2428: and p_to_tax_type IN (jai_constants.tax_type_service, jai_constants.tax_type_service_edu_cess,jai_constants.tax_type_sh_service_edu_cess )

2424: -- lv_balancing_entry := jai_constants.NO; --added by nprashar for bug # 7525691 commented for bug#6773684
2425: ELSIF p_source = 'DISTRIBUTION' THEN
2426: /*bug 7525691*/
2427: if p_from_tax_type IN (jai_constants.tax_type_service, jai_constants.tax_type_service_edu_cess,jai_constants.tax_type_sh_service_edu_cess)
2428: and p_to_tax_type IN (jai_constants.tax_type_service, jai_constants.tax_type_service_edu_cess,jai_constants.tax_type_sh_service_edu_cess )
2429: then
2430: lv_distribution_type:='S-S';
2431: end if;
2432: /*end bug 7525691*/

Line 2433: lv_source := jai_constants.service_src_distribute_out;

2429: then
2430: lv_distribution_type:='S-S';
2431: end if;
2432: /*end bug 7525691*/
2433: lv_source := jai_constants.service_src_distribute_out;
2434: END IF;
2435: IF p_to_party_type = 'IO' and upper(p_to_tax_type) IN (upper(jai_constants.tax_type_excise), 'EXCISE-CESS',jai_constants.tax_type_sh_exc_edu_cess)
2436: THEN /*5694855*/
2437: /*

Line 2435: IF p_to_party_type = 'IO' and upper(p_to_tax_type) IN (upper(jai_constants.tax_type_excise), 'EXCISE-CESS',jai_constants.tax_type_sh_exc_edu_cess)

2431: end if;
2432: /*end bug 7525691*/
2433: lv_source := jai_constants.service_src_distribute_out;
2434: END IF;
2435: IF p_to_party_type = 'IO' and upper(p_to_tax_type) IN (upper(jai_constants.tax_type_excise), 'EXCISE-CESS',jai_constants.tax_type_sh_exc_edu_cess)
2436: THEN /*5694855*/
2437: /*
2438: ||Start of bug 5073553
2439: || Added by CSahoo

Line 2448: v_register_type := jai_constants.register_type_pla;

2444: p_from_party_type => p_from_party_type ,
2445: p_to_party_type => p_to_party_type
2446: ) = 'PLA'
2447: THEN
2448: v_register_type := jai_constants.register_type_pla;
2449: ELSE
2450: --v_register_type := jai_constants.REGISTER_TYPE_A; commented for bug#6773684
2451: v_register_type :='RG';--bug#6773684
2452: END IF;

Line 2450: --v_register_type := jai_constants.REGISTER_TYPE_A; commented for bug#6773684

2446: ) = 'PLA'
2447: THEN
2448: v_register_type := jai_constants.register_type_pla;
2449: ELSE
2450: --v_register_type := jai_constants.REGISTER_TYPE_A; commented for bug#6773684
2451: v_register_type :='RG';--bug#6773684
2452: END IF;
2453: /* End of bug 5073553 */
2454: /*Bug 5879769 bduvarag start*/

Line 2455: ELSIF ( p_source = 'SETTLEMENT' or p_from_tax_type IN (jai_constants.tax_type_service, jai_constants.tax_type_service_edu_cess, jai_constants.tax_type_sh_service_edu_cess) ) THEN --Added by kunkumar for Bug#6127194

2451: v_register_type :='RG';--bug#6773684
2452: END IF;
2453: /* End of bug 5073553 */
2454: /*Bug 5879769 bduvarag start*/
2455: ELSIF ( p_source = 'SETTLEMENT' or p_from_tax_type IN (jai_constants.tax_type_service, jai_constants.tax_type_service_edu_cess, jai_constants.tax_type_sh_service_edu_cess) ) THEN --Added by kunkumar for Bug#6127194
2456: lv_acct_req_flag := jai_constants.YES;
2457: v_register_type := NULL;
2458: /*Bug 5879769 bduvarag end*/
2459: ELSE

Line 2456: lv_acct_req_flag := jai_constants.YES;

2452: END IF;
2453: /* End of bug 5073553 */
2454: /*Bug 5879769 bduvarag start*/
2455: ELSIF ( p_source = 'SETTLEMENT' or p_from_tax_type IN (jai_constants.tax_type_service, jai_constants.tax_type_service_edu_cess, jai_constants.tax_type_sh_service_edu_cess) ) THEN --Added by kunkumar for Bug#6127194
2456: lv_acct_req_flag := jai_constants.YES;
2457: v_register_type := NULL;
2458: /*Bug 5879769 bduvarag end*/
2459: ELSE
2460: v_register_type := NULL;

Line 2476: lv_rep_register_type:=jai_constants.register_type_a;

2472:
2473: --start additions for bug#6773684
2474: if v_register_type='RG'
2475: then
2476: lv_rep_register_type:=jai_constants.register_type_a;
2477: end if;
2478: --end additions for bug#6773684
2479: --this entry is for service to excise transfer
2480: jai_cmn_rgm_recording_pkg.insert_repository_entry

Line 2513: P_CURRENCY_CODE => jai_constants.func_curr , -- File.Sql.35 by Brathod

2509: P_BALANCING_ORGN_ID => p_to_party_id ,
2510: P_BALANCING_LOCATION_ID => p_to_locn_id ,
2511: P_BALANCING_TAX_TYPE => p_to_tax_type ,
2512: P_BALANCING_ACCNT_NAME =>nvl(lv_rep_register_type ,v_register_type) ,--added nvl(lv_rep_register_type for bug#6773684
2513: P_CURRENCY_CODE => jai_constants.func_curr , -- File.Sql.35 by Brathod
2514: p_service_type_code => p_from_service_type,
2515: p_distribution_type => lv_distribution_type /*bug 7525691*/
2516: );
2517: IF NVL(p_process_flag,'$') <> jai_constants.successful THEN

Line 2517: IF NVL(p_process_flag,'$') <> jai_constants.successful THEN

2513: P_CURRENCY_CODE => jai_constants.func_curr , -- File.Sql.35 by Brathod
2514: p_service_type_code => p_from_service_type,
2515: p_distribution_type => lv_distribution_type /*bug 7525691*/
2516: );
2517: IF NVL(p_process_flag,'$') <> jai_constants.successful THEN
2518: rollback;
2519: return;
2520: END IF;
2521: p_repository_id := ln_repository_id;

Line 2537: v_register_type := jai_constants.register_type_pla;

2533: p_from_party_type => p_from_party_type ,
2534: p_to_party_type => p_to_party_type
2535: ) = 'PLA'
2536: THEN
2537: v_register_type := jai_constants.register_type_pla;
2538: ELSE
2539: --v_register_type := jai_constants.REGISTER_TYPE_A;commented for bug#6773684
2540: v_register_type :='RG';--added for bug#6773684
2541: END IF;

Line 2539: --v_register_type := jai_constants.REGISTER_TYPE_A;commented for bug#6773684

2535: ) = 'PLA'
2536: THEN
2537: v_register_type := jai_constants.register_type_pla;
2538: ELSE
2539: --v_register_type := jai_constants.REGISTER_TYPE_A;commented for bug#6773684
2540: v_register_type :='RG';--added for bug#6773684
2541: END IF;
2542: --end additions for bug#6773684
2543:

Line 2634: P_REGISTER_TYPE => jai_constants.REGISTER_TYPE_A ,

2630: P_DR_ADDITIONAL_ED => NULL,
2631: P_DR_OTHER_ED => NULL,
2632: P_EXCISE_INVOICE_NO => NULL,
2633: P_EXCISE_INVOICE_DATE => NULL,
2634: P_REGISTER_TYPE => jai_constants.REGISTER_TYPE_A ,
2635: P_REMARKS => 'DISTRIBUTION - OUT',
2636: P_VENDOR_ID => NULL,
2637: P_VENDOR_SITE_ID => NULL ,
2638: P_CUSTOMER_ID => NULL,

Line 2707: IF nvl(p_process_flag,jai_constants.successful) <> jai_constants.successful THEN

2703: );
2704:
2705: /*jai_cmn_utils_pkg.print_log('dis.log','after call to from io process flag = ' || p_process_flag);
2706: jai_cmn_utils_pkg.print_log('dis.log','err messg is '||p_process_message );*/
2707: IF nvl(p_process_flag,jai_constants.successful) <> jai_constants.successful THEN
2708: rollback;
2709: return;
2710: END IF;
2711: END IF;

Line 2719: ( p_to_party_type = 'IO' AND p_to_tax_type IN (jai_constants.tax_type_service, jai_constants.tax_type_service_edu_cess, jai_constants.tax_type_sh_service_edu_cess )) THEN -- added, Harshita for Bug 5694855 --Modified by kunkumar for Bug#6127194

2715: */
2716: /*Bug 5879769 bduvarag*/
2717: IF p_to_party_type IN ('OU')
2718: OR
2719: ( p_to_party_type = 'IO' AND p_to_tax_type IN (jai_constants.tax_type_service, jai_constants.tax_type_service_edu_cess, jai_constants.tax_type_sh_service_edu_cess )) THEN -- added, Harshita for Bug 5694855 --Modified by kunkumar for Bug#6127194
2720: IF p_from_party_type = 'IO' AND upper(p_from_tax_type) IN (upper(jai_constants.tax_type_excise), 'EXCISE-CESS',upper(jai_constants.tax_type_sh_exc_edu_cess)) THEN/*Bug 5879769 bduvarag*/
2721: lv_acct_req_flag := jai_constants.YES;
2722: -- v_register_type := jai_constants.REGISTER_TYPE_A; commented for bug#6773684
2723:

Line 2720: IF p_from_party_type = 'IO' AND upper(p_from_tax_type) IN (upper(jai_constants.tax_type_excise), 'EXCISE-CESS',upper(jai_constants.tax_type_sh_exc_edu_cess)) THEN/Bug 5879769 bduvarag/

2716: /*Bug 5879769 bduvarag*/
2717: IF p_to_party_type IN ('OU')
2718: OR
2719: ( p_to_party_type = 'IO' AND p_to_tax_type IN (jai_constants.tax_type_service, jai_constants.tax_type_service_edu_cess, jai_constants.tax_type_sh_service_edu_cess )) THEN -- added, Harshita for Bug 5694855 --Modified by kunkumar for Bug#6127194
2720: IF p_from_party_type = 'IO' AND upper(p_from_tax_type) IN (upper(jai_constants.tax_type_excise), 'EXCISE-CESS',upper(jai_constants.tax_type_sh_exc_edu_cess)) THEN/*Bug 5879769 bduvarag*/
2721: lv_acct_req_flag := jai_constants.YES;
2722: -- v_register_type := jai_constants.REGISTER_TYPE_A; commented for bug#6773684
2723:
2724: --start additions for bug#6773684

Line 2721: lv_acct_req_flag := jai_constants.YES;

2717: IF p_to_party_type IN ('OU')
2718: OR
2719: ( p_to_party_type = 'IO' AND p_to_tax_type IN (jai_constants.tax_type_service, jai_constants.tax_type_service_edu_cess, jai_constants.tax_type_sh_service_edu_cess )) THEN -- added, Harshita for Bug 5694855 --Modified by kunkumar for Bug#6127194
2720: IF p_from_party_type = 'IO' AND upper(p_from_tax_type) IN (upper(jai_constants.tax_type_excise), 'EXCISE-CESS',upper(jai_constants.tax_type_sh_exc_edu_cess)) THEN/*Bug 5879769 bduvarag*/
2721: lv_acct_req_flag := jai_constants.YES;
2722: -- v_register_type := jai_constants.REGISTER_TYPE_A; commented for bug#6773684
2723:
2724: --start additions for bug#6773684
2725: IF f_get_io_register ( p_party_id => p_from_party_id ,

Line 2722: -- v_register_type := jai_constants.REGISTER_TYPE_A; commented for bug#6773684

2718: OR
2719: ( p_to_party_type = 'IO' AND p_to_tax_type IN (jai_constants.tax_type_service, jai_constants.tax_type_service_edu_cess, jai_constants.tax_type_sh_service_edu_cess )) THEN -- added, Harshita for Bug 5694855 --Modified by kunkumar for Bug#6127194
2720: IF p_from_party_type = 'IO' AND upper(p_from_tax_type) IN (upper(jai_constants.tax_type_excise), 'EXCISE-CESS',upper(jai_constants.tax_type_sh_exc_edu_cess)) THEN/*Bug 5879769 bduvarag*/
2721: lv_acct_req_flag := jai_constants.YES;
2722: -- v_register_type := jai_constants.REGISTER_TYPE_A; commented for bug#6773684
2723:
2724: --start additions for bug#6773684
2725: IF f_get_io_register ( p_party_id => p_from_party_id ,
2726: p_from_party_type => p_from_party_type ,

Line 2730: v_register_type := jai_constants.register_type_pla;

2726: p_from_party_type => p_from_party_type ,
2727: p_to_party_type => p_to_party_type
2728: ) = 'PLA'
2729: THEN
2730: v_register_type := jai_constants.register_type_pla;
2731: ELSE
2732: --v_register_type := jai_constants.REGISTER_TYPE_A;--commneted for bug#6773684
2733: v_register_type :='RG';--added for bug#6773684
2734: END IF;

Line 2732: --v_register_type := jai_constants.REGISTER_TYPE_A;--commneted for bug#6773684

2728: ) = 'PLA'
2729: THEN
2730: v_register_type := jai_constants.register_type_pla;
2731: ELSE
2732: --v_register_type := jai_constants.REGISTER_TYPE_A;--commneted for bug#6773684
2733: v_register_type :='RG';--added for bug#6773684
2734: END IF;
2735: --end additions for bug#6773684
2736: -- start additions for bug#8873924

Line 2772: ELSIF ( p_source = 'SETTLEMENT' or p_to_tax_type IN (jai_constants.tax_type_service, jai_constants.tax_type_service_edu_cess, jai_constants.tax_type_sh_service_edu_cess )) THEN --Added by kunkumar for Bug#6127194

2768:
2769:
2770:
2771: /*Bug 5879769 bduvarag start*/
2772: ELSIF ( p_source = 'SETTLEMENT' or p_to_tax_type IN (jai_constants.tax_type_service, jai_constants.tax_type_service_edu_cess, jai_constants.tax_type_sh_service_edu_cess )) THEN --Added by kunkumar for Bug#6127194
2773: lv_acct_req_flag := jai_constants.YES;
2774: v_register_type := NULL;
2775: /*Bug 5879769 bduvarag end*/
2776: ELSE

Line 2773: lv_acct_req_flag := jai_constants.YES;

2769:
2770:
2771: /*Bug 5879769 bduvarag start*/
2772: ELSIF ( p_source = 'SETTLEMENT' or p_to_tax_type IN (jai_constants.tax_type_service, jai_constants.tax_type_service_edu_cess, jai_constants.tax_type_sh_service_edu_cess )) THEN --Added by kunkumar for Bug#6127194
2773: lv_acct_req_flag := jai_constants.YES;
2774: v_register_type := NULL;
2775: /*Bug 5879769 bduvarag end*/
2776: ELSE
2777: lv_acct_req_flag := jai_constants.NO;

Line 2777: lv_acct_req_flag := jai_constants.NO;

2773: lv_acct_req_flag := jai_constants.YES;
2774: v_register_type := NULL;
2775: /*Bug 5879769 bduvarag end*/
2776: ELSE
2777: lv_acct_req_flag := jai_constants.NO;
2778: v_register_type := NULL;
2779: END IF;
2780: IF p_source = 'SETTLEMENT' THEN
2781: lv_source := jai_constants.source_settle_in ;

Line 2781: lv_source := jai_constants.source_settle_in ;

2777: lv_acct_req_flag := jai_constants.NO;
2778: v_register_type := NULL;
2779: END IF;
2780: IF p_source = 'SETTLEMENT' THEN
2781: lv_source := jai_constants.source_settle_in ;
2782: -- lv_balancing_entry := jai_constants.NO; --added by nprashar for bug # 7525691 commented for bug#6773684
2783: ELSIF p_source = 'DISTRIBUTION' THEN
2784: /*bug 7525691*/
2785: if p_from_tax_type IN (jai_constants.tax_type_service, jai_constants.tax_type_service_edu_cess,jai_constants.tax_type_sh_service_edu_cess)

Line 2782: -- lv_balancing_entry := jai_constants.NO; --added by nprashar for bug # 7525691 commented for bug#6773684

2778: v_register_type := NULL;
2779: END IF;
2780: IF p_source = 'SETTLEMENT' THEN
2781: lv_source := jai_constants.source_settle_in ;
2782: -- lv_balancing_entry := jai_constants.NO; --added by nprashar for bug # 7525691 commented for bug#6773684
2783: ELSIF p_source = 'DISTRIBUTION' THEN
2784: /*bug 7525691*/
2785: if p_from_tax_type IN (jai_constants.tax_type_service, jai_constants.tax_type_service_edu_cess,jai_constants.tax_type_sh_service_edu_cess)
2786: and p_to_tax_type IN (jai_constants.tax_type_service, jai_constants.tax_type_service_edu_cess,jai_constants.tax_type_sh_service_edu_cess )

Line 2785: if p_from_tax_type IN (jai_constants.tax_type_service, jai_constants.tax_type_service_edu_cess,jai_constants.tax_type_sh_service_edu_cess)

2781: lv_source := jai_constants.source_settle_in ;
2782: -- lv_balancing_entry := jai_constants.NO; --added by nprashar for bug # 7525691 commented for bug#6773684
2783: ELSIF p_source = 'DISTRIBUTION' THEN
2784: /*bug 7525691*/
2785: if p_from_tax_type IN (jai_constants.tax_type_service, jai_constants.tax_type_service_edu_cess,jai_constants.tax_type_sh_service_edu_cess)
2786: and p_to_tax_type IN (jai_constants.tax_type_service, jai_constants.tax_type_service_edu_cess,jai_constants.tax_type_sh_service_edu_cess )
2787: then
2788: lv_distribution_type:='S-S';
2789: end if;

Line 2786: and p_to_tax_type IN (jai_constants.tax_type_service, jai_constants.tax_type_service_edu_cess,jai_constants.tax_type_sh_service_edu_cess )

2782: -- lv_balancing_entry := jai_constants.NO; --added by nprashar for bug # 7525691 commented for bug#6773684
2783: ELSIF p_source = 'DISTRIBUTION' THEN
2784: /*bug 7525691*/
2785: if p_from_tax_type IN (jai_constants.tax_type_service, jai_constants.tax_type_service_edu_cess,jai_constants.tax_type_sh_service_edu_cess)
2786: and p_to_tax_type IN (jai_constants.tax_type_service, jai_constants.tax_type_service_edu_cess,jai_constants.tax_type_sh_service_edu_cess )
2787: then
2788: lv_distribution_type:='S-S';
2789: end if;
2790: lv_source := jai_constants.service_src_distribute_in;

Line 2790: lv_source := jai_constants.service_src_distribute_in;

2786: and p_to_tax_type IN (jai_constants.tax_type_service, jai_constants.tax_type_service_edu_cess,jai_constants.tax_type_sh_service_edu_cess )
2787: then
2788: lv_distribution_type:='S-S';
2789: end if;
2790: lv_source := jai_constants.service_src_distribute_in;
2791: END IF;
2792: /* jai_cmn_utils_pkg.print_log('dis.log',' p_to_trx_amount is :' || p_to_trx_amount); */
2793: IF p_called_from = 'DISTRIBUTION' THEN
2794: ln_transfer_id := p_reference_id;

Line 2807: lv_rep_register_type :=jai_constants.register_type_a;

2803:
2804: --start additions for bug#6773684
2805: if v_register_type='RG'
2806: then
2807: lv_rep_register_type :=jai_constants.register_type_a;
2808: else
2809: lv_rep_register_type:= v_register_type;--added for bug#8873924
2810: end if;
2811: --end additions for bug#6773684

Line 2848: P_CURRENCY_CODE => jai_constants.func_curr , -- File.Sql.35 by Brathod

2844: P_BALANCING_LOCATION_ID => p_from_locn_id ,
2845: P_BALANCING_TAX_TYPE => p_from_tax_type ,
2846: P_BALANCING_ACCNT_NAME =>lv_rep_register_type ,
2847: --added the nvl(lv_rep_register_type for bug#6773684
2848: P_CURRENCY_CODE => jai_constants.func_curr , -- File.Sql.35 by Brathod
2849: p_service_type_code => p_to_service_type ,
2850: p_distribution_type => lv_distribution_type /*bug 7525691*/
2851: );
2852: IF nvl(p_process_flag,'$') <> jai_constants.successful THEN

Line 2852: IF nvl(p_process_flag,'$') <> jai_constants.successful THEN

2848: P_CURRENCY_CODE => jai_constants.func_curr , -- File.Sql.35 by Brathod
2849: p_service_type_code => p_to_service_type ,
2850: p_distribution_type => lv_distribution_type /*bug 7525691*/
2851: );
2852: IF nvl(p_process_flag,'$') <> jai_constants.successful THEN
2853: rollback;
2854: return;
2855: END IF;
2856: p_repository_id := ln_repository_id;

Line 2983: IF nvl(p_process_flag,jai_constants.successful) <> jai_constants.successful THEN

2979: p_process_flag => p_process_flag ,
2980: p_process_message => p_process_message
2981: );
2982:
2983: IF nvl(p_process_flag,jai_constants.successful) <> jai_constants.successful THEN
2984: rollback;
2985: return;
2986: END IF;--p_process_flag
2987: END IF;-- p_to_tax_type

Line 3073: p_process_flag := jai_constants.successful;

3069: --Added the body of the procedure by kunkumar for bug#6127194
3070: /*
3071: ||Initialize the variables
3072: */
3073: p_process_flag := jai_constants.successful;
3074: ln_source_type := null ;
3075: lv_source_register := null ;
3076:
3077: IF p_tax_type = 'EXCISE' THEN

Line 3110: p_register_type => lv_register_type ,--jai_constants.register_type_a , bug 8873924

3106: p_dr_additional_ed => p_dr_additional_ed ,
3107: p_dr_other_ed => p_dr_other_ed ,
3108: p_excise_invoice_no => p_excise_invoice_no ,
3109: p_excise_invoice_date => p_excise_invoice_date ,
3110: p_register_type => lv_register_type ,--jai_constants.register_type_a , bug 8873924
3111: p_remarks => p_remarks ,
3112: p_vendor_id => p_vendor_id ,
3113: p_vendor_site_id => p_vendor_site_id ,
3114: p_customer_id => p_customer_id ,

Line 3175: IF nvl(p_process_flag,jai_constants.successful) <> jai_constants.successful THEN

3171: );
3172:
3173: END IF;
3174:
3175: IF nvl(p_process_flag,jai_constants.successful) <> jai_constants.successful THEN
3176: rollback;
3177: return;
3178: ELSE /* Pass cess entries in jai_rg_others table*/
3179: /* Update the cess amount in the ja_in_rg23_part_ii table*/

Line 3194: IF nvl(p_process_flag,jai_constants.successful) <> jai_constants.successful THEN

3190: p_process_flag => p_process_flag ,
3191: p_process_msg => p_process_message
3192: );
3193:
3194: IF nvl(p_process_flag,jai_constants.successful) <> jai_constants.successful THEN
3195:
3196: rollback;
3197: return;
3198: END IF;

Line 3215: IF nvl(p_process_flag,jai_constants.successful) <> jai_constants.successful THEN

3211: p_process_flag => p_process_flag ,
3212: p_process_msg => p_process_message
3213: );
3214:
3215: IF nvl(p_process_flag,jai_constants.successful) <> jai_constants.successful THEN
3216:
3217: rollback;
3218: return;
3219: END IF;