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_AP_IDA_TRIGGER_DTC_PKG dependencies on JAI_AP_TDS_PREPAYMENTS

Line 37: FROM jai_ap_tds_prepayments

33:
34: --Added by Sanjikum for Bug#5131075(4722011)
35: CURSOR c_check_prepayment_apply IS
36: SELECT '1'
37: FROM jai_ap_tds_prepayments
38: WHERE invoice_distribution_id_prepay = pr_new.invoice_distribution_id;
39:
40: CURSOR c_check_prepayment_unapply IS
41: SELECT '1'

Line 42: FROM jai_ap_tds_prepayments

38: WHERE invoice_distribution_id_prepay = pr_new.invoice_distribution_id;
39:
40: CURSOR c_check_prepayment_unapply IS
41: SELECT '1'
42: FROM jai_ap_tds_prepayments
43: WHERE invoice_distribution_id_prepay = pr_new.parent_reversal_id
44: AND unapply_flag = 'Y';
45:
46: lv_prepay_flag VARCHAR2(1);

Line 191: --jai_ap_tds_prepayments_pkg.process_prepayment

187: lv_codepath := null;
188:
189: --Updated by Zhiwei Hou for DTC #13359892 begin
190: ----------------------------------------------------------------------
191: --jai_ap_tds_prepayments_pkg.process_prepayment
192: jai_ap_dtc_prepayments_pkg.process_prepayment
193: ----------------------------------------------------------------------
194: --Updated by Zhiwei Hou for DTC #13359892 end
195: (

Line 230: --jai_ap_tds_prepayments_pkg.process_old_transaction

226:
227: --Invoke the old regime functionality
228: --Updated by Zhiwei Hou for DTC #13359892 begin
229: ----------------------------------------------------------------------
230: --jai_ap_tds_prepayments_pkg.process_old_transaction
231: jai_ap_dtc_prepayments_pkg.process_old_transaction
232: ----------------------------------------------------------------------
233: --Updated by Zhiwei Hou for DTC #13359892 end
234: (

Line 1411: /*Data is inserted into JAI_AP_TDS_PREPAYMENTS before Validation. This results in incorrect TDS getting calculated

1407: end if; /*inserting or updating */
1408:
1409: /* TDS Tax Defaultation Functionality Bug # 4088186 */
1410: /*Bug 12630283 - Start*/
1411: /*Data is inserted into JAI_AP_TDS_PREPAYMENTS before Validation. This results in incorrect TDS getting calculated
1412: On validation of Invoice the match status flag of PREPAY line is set to 'A' first resulting in JAI_AP_TDS_PREPAYMENTS
1413: getting inserted before the Item Line's match status flag is set to A. Only if all the distraibutions match status flag
1414: is set to A or T process_tds_at_inv_validate shall be called. If process_tds_at_inv_validate is called after insertion
1415: of data in JAI_AP_TDS_PREPAYMENTS it results in incorrect TDS deduction. Hence moved the code to insert JAI_AP_TDS_PREPAYMENTS

Line 1412: On validation of Invoice the match status flag of PREPAY line is set to 'A' first resulting in JAI_AP_TDS_PREPAYMENTS

1408:
1409: /* TDS Tax Defaultation Functionality Bug # 4088186 */
1410: /*Bug 12630283 - Start*/
1411: /*Data is inserted into JAI_AP_TDS_PREPAYMENTS before Validation. This results in incorrect TDS getting calculated
1412: On validation of Invoice the match status flag of PREPAY line is set to 'A' first resulting in JAI_AP_TDS_PREPAYMENTS
1413: getting inserted before the Item Line's match status flag is set to A. Only if all the distraibutions match status flag
1414: is set to A or T process_tds_at_inv_validate shall be called. If process_tds_at_inv_validate is called after insertion
1415: of data in JAI_AP_TDS_PREPAYMENTS it results in incorrect TDS deduction. Hence moved the code to insert JAI_AP_TDS_PREPAYMENTS
1416: after validation of Invoice.*/

Line 1415: of data in JAI_AP_TDS_PREPAYMENTS it results in incorrect TDS deduction. Hence moved the code to insert JAI_AP_TDS_PREPAYMENTS

1411: /*Data is inserted into JAI_AP_TDS_PREPAYMENTS before Validation. This results in incorrect TDS getting calculated
1412: On validation of Invoice the match status flag of PREPAY line is set to 'A' first resulting in JAI_AP_TDS_PREPAYMENTS
1413: getting inserted before the Item Line's match status flag is set to A. Only if all the distraibutions match status flag
1414: is set to A or T process_tds_at_inv_validate shall be called. If process_tds_at_inv_validate is called after insertion
1415: of data in JAI_AP_TDS_PREPAYMENTS it results in incorrect TDS deduction. Hence moved the code to insert JAI_AP_TDS_PREPAYMENTS
1416: after validation of Invoice.*/
1417: --To handle the condition, if there are PP applications/Unapplications, before the SI is validated
1418: if pv_action = jai_constants.updating then
1419: IF pr_new.line_type_lookup_code = 'PREPAY' THEN

Line 1681: jai_ap_tds_prepayments_pkg.process_prepayment

1677: if lv_new_transaction_si = 'Y' and lv_new_transaction_pp = 'Y' then
1678:
1679: lv_codepath := null;
1680:
1681: jai_ap_tds_prepayments_pkg.process_prepayment
1682: (
1683: p_invoice_id => pr_new.invoice_id,
1684: p_invoice_distribution_id => pr_new.invoice_distribution_id,
1685: p_prepay_distribution_id => pr_new.prepay_distribution_id,

Line 1712: jai_ap_tds_prepayments_pkg.process_old_transaction

1708: else
1709: --
1710: --|| Invoke the old regime functionality
1711: --
1712: jai_ap_tds_prepayments_pkg.process_old_transaction
1713: (
1714: p_invoice_id => pr_new.invoice_id,
1715: p_invoice_distribution_id => pr_new.invoice_distribution_id,
1716: p_prepay_distribution_id => pr_new.prepay_distribution_id,