[Home] [Help]
635: 'SELECT INVOICE_ID, SUM (AMOUNT), ACTUAL_SECTION_CODE, TAX_CATEGORY_ID
636: FROM
637: (
638: SELECT JATIT.INVOICE_ID, (JATIT.AMOUNT-NVL(JATP.APPLICATION_AMOUNT, 0)) AMOUNT, JATIT.ACTUAL_SECTION_CODE, JATIT.TAX_CATEGORY_ID
639: FROM JAI_AP_TDS_INV_TAXES JATIT, JAI_AP_TDS_PREPAYMENTS JATP
640: WHERE JATIT.INVOICE_ID <> $$P_INVOICE_ID$$
641: AND (
642: ( JATIT.TAX_LINE_NO <> 0 and JATIT.TAX_CATEGORY_ID IS NOT NULL and JATIT.invoice_distribution_id <> 1 )
643: or
1070: is
1071: --PRAGMA AUTONOMOUS_TRANSACTION; --commented by Cholei for ZX integration bug#14040855
1072: cursor c_jai_apply_amount(cp_invoice_id number) is
1073: select sum(a.application_amount) application_amount, d.threshold_grp_id, d.invoice_id
1074: from jai_ap_tds_prepayments a,
1075: ap_invoice_distributions_all b,
1076: ap_invoice_distributions_all c,
1077: jai_ap_tds_inv_taxes d
1078: where a.invoice_distribution_id_prepay = b.invoice_distribution_id
1088: incorrect TDS deducted during Threshold Transition. Derive the Prepayments(which suffered TDS)
1089: applied and subtract the same before calculating Effective amount for Threshold Transition*/
1090: cursor c_pp_single_apply_amount(cp_invoice_id number) is
1091: select sum(application_amount) amount
1092: from jai_ap_tds_prepayments a,
1093: ap_invoice_distributions_all b
1094: where a.invoice_id = cp_invoice_id
1095: and a.invoice_id = b.invoice_id
1096: and a.invoice_distribution_id_prepay = b.invoice_distribution_id
2726: -------------------------------------------------------------------------------
2727: /*Added parameter section_type fro bug 11070443*/
2728: cursor c_get_amount_already_applied(p_invoice_distribution_id number, p_section_type varchar2) is
2729: select sum(application_amount)
2730: from jai_ap_tds_prepayments
2731: where invoice_distribution_id = p_invoice_distribution_id
2732: and (
2733: (p_section_type = 'TDS_SECTION' and nvl(tds_applicable_flag, '*') = 'Y') or
2734: (p_section_type = 'WCT_SECTION' and nvl(wct_applicable_flag, '*') = 'Y') or
2860: cv_section_code varchar2
2861: )
2862: IS
2863: select sum(application_amount) applied_amount
2864: from jai_ap_tds_prepayments
2865: where invoice_id = cn_invoice_id
2866: and (
2867: (cv_section_type = 'TDS_SECTION' and nvl(tds_applicable_flag, '*') = 'Y' and tds_section_code_prepay = cv_section_code)
2868: or (cv_section_type = 'WCT_SECTION' and nvl(wct_applicable_flag, '*') = 'Y')
8737:
8738: CURSOR c_check_prepayment_apply(p_invoice_distribution_id NUMBER)
8739: IS
8740: SELECT '1'
8741: FROM jai_ap_tds_prepayments
8742: WHERE invoice_distribution_id_prepay = p_invoice_distribution_id;
8743:
8744: CURSOR c_check_prepayment_unapply(p_invoice_distribution_id_pp NUMBER)
8745: IS
8743:
8744: CURSOR c_check_prepayment_unapply(p_invoice_distribution_id_pp NUMBER)
8745: IS
8746: SELECT '1'
8747: FROM jai_ap_tds_prepayments
8748: WHERE invoice_distribution_id_prepay = p_invoice_distribution_id_pp
8749: AND unapply_flag = 'Y';
8750: --End addition by sanjikum for Bug#5131075(4722011)
8751:
8919: if lv_new_transaction_si = 'Y' and lv_new_transaction_pp = 'Y' then
8920:
8921: lv_codepath := null;
8922:
8923: jai_ap_tds_prepayments_pkg.process_prepayment
8924: (
8925: p_event => 'INSERT', --Added for Bug 8431516
8926: p_invoice_id => i.invoice_id,
8927: p_invoice_distribution_id => i.invoice_distribution_id,
8947: end if;
8948:
8949: else
8950: --Invoke the old regime functionality
8951: jai_ap_tds_prepayments_pkg.process_old_transaction
8952: (
8953: p_invoice_id => i.invoice_id,
8954: p_invoice_distribution_id => i.invoice_distribution_id,
8955: p_prepay_distribution_id => i.prepay_distribution_id,