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_TDS_POP_RPST_PKG dependencies on JAI_AP_TDS_REPOSITORY

Line 242: SELECT JAI_AP_TDS_REPOSITORY_S.NEXTVAL

238: AND aida.invoice_distribution_id = pn_distribution_id
239: ;
240:
241: CURSOR c_get_tds_repository_id IS
242: SELECT JAI_AP_TDS_REPOSITORY_S.NEXTVAL
243: FROM DUAL;
244:
245: CURSOR c_get_apply_prepayments_info( pn_threshold_trx_id NUMBER
246: ) IS

Line 279: r_jai_ap_tds_repository jai_ap_tds_repository%rowtype;

275:
276: r_c_get_trx_tds_info c_get_trx_tds_info%rowtype;
277: r_c_get_inv_info c_get_inv_info%rowtype;
278: r_c_get_tds_essi_rate c_get_tds_essi_rate%rowtype;
279: r_jai_ap_tds_repository jai_ap_tds_repository%rowtype;
280: r_c_get_tax_regime_info c_get_tax_regime_info%rowtype;
281: r_c_get_tds_org_tan c_get_tds_org_tan%rowtype;
282: r_c_get_apply_fromto_inv c_get_apply_fromto_inv%rowtype;
283: r_get_apply_prepayments_info c_get_apply_prepayments_info%rowtype;

Line 311: r_jai_ap_tds_repository.EVENT := pv_event;

307: IF pv_event IN (G_SURCHARGE_CALCULATE, G_SURCHARGE_ROLLBACK) THEN
308: RETURN;
309: END IF;
310:
311: r_jai_ap_tds_repository.EVENT := pv_event;
312: r_jai_ap_tds_repository.SECTION_TYPE := pv_section_type;
313: r_jai_ap_tds_repository.SECTION_CODE := pv_section_code;
314: r_jai_ap_tds_repository.threshold_grp_id := pn_threshold_grp_id;
315: r_jai_ap_tds_repository.threshold_hdr_id := pn_threshold_hdr_id;

Line 312: r_jai_ap_tds_repository.SECTION_TYPE := pv_section_type;

308: RETURN;
309: END IF;
310:
311: r_jai_ap_tds_repository.EVENT := pv_event;
312: r_jai_ap_tds_repository.SECTION_TYPE := pv_section_type;
313: r_jai_ap_tds_repository.SECTION_CODE := pv_section_code;
314: r_jai_ap_tds_repository.threshold_grp_id := pn_threshold_grp_id;
315: r_jai_ap_tds_repository.threshold_hdr_id := pn_threshold_hdr_id;
316: r_jai_ap_tds_repository.THRESHOLD_TYPE_ID := pn_threshold_type_id;

Line 313: r_jai_ap_tds_repository.SECTION_CODE := pv_section_code;

309: END IF;
310:
311: r_jai_ap_tds_repository.EVENT := pv_event;
312: r_jai_ap_tds_repository.SECTION_TYPE := pv_section_type;
313: r_jai_ap_tds_repository.SECTION_CODE := pv_section_code;
314: r_jai_ap_tds_repository.threshold_grp_id := pn_threshold_grp_id;
315: r_jai_ap_tds_repository.threshold_hdr_id := pn_threshold_hdr_id;
316: r_jai_ap_tds_repository.THRESHOLD_TYPE_ID := pn_threshold_type_id;
317: r_jai_ap_tds_repository.THRESHOLD_SLAB_ID := pn_threshold_slab_id;

Line 314: r_jai_ap_tds_repository.threshold_grp_id := pn_threshold_grp_id;

310:
311: r_jai_ap_tds_repository.EVENT := pv_event;
312: r_jai_ap_tds_repository.SECTION_TYPE := pv_section_type;
313: r_jai_ap_tds_repository.SECTION_CODE := pv_section_code;
314: r_jai_ap_tds_repository.threshold_grp_id := pn_threshold_grp_id;
315: r_jai_ap_tds_repository.threshold_hdr_id := pn_threshold_hdr_id;
316: r_jai_ap_tds_repository.THRESHOLD_TYPE_ID := pn_threshold_type_id;
317: r_jai_ap_tds_repository.THRESHOLD_SLAB_ID := pn_threshold_slab_id;
318:

Line 315: r_jai_ap_tds_repository.threshold_hdr_id := pn_threshold_hdr_id;

311: r_jai_ap_tds_repository.EVENT := pv_event;
312: r_jai_ap_tds_repository.SECTION_TYPE := pv_section_type;
313: r_jai_ap_tds_repository.SECTION_CODE := pv_section_code;
314: r_jai_ap_tds_repository.threshold_grp_id := pn_threshold_grp_id;
315: r_jai_ap_tds_repository.threshold_hdr_id := pn_threshold_hdr_id;
316: r_jai_ap_tds_repository.THRESHOLD_TYPE_ID := pn_threshold_type_id;
317: r_jai_ap_tds_repository.THRESHOLD_SLAB_ID := pn_threshold_slab_id;
318:
319: /*Set TDS invoice information*/

Line 316: r_jai_ap_tds_repository.THRESHOLD_TYPE_ID := pn_threshold_type_id;

312: r_jai_ap_tds_repository.SECTION_TYPE := pv_section_type;
313: r_jai_ap_tds_repository.SECTION_CODE := pv_section_code;
314: r_jai_ap_tds_repository.threshold_grp_id := pn_threshold_grp_id;
315: r_jai_ap_tds_repository.threshold_hdr_id := pn_threshold_hdr_id;
316: r_jai_ap_tds_repository.THRESHOLD_TYPE_ID := pn_threshold_type_id;
317: r_jai_ap_tds_repository.THRESHOLD_SLAB_ID := pn_threshold_slab_id;
318:
319: /*Set TDS invoice information*/
320: r_jai_ap_tds_repository.invoice_id := pn_invoice_id;

Line 317: r_jai_ap_tds_repository.THRESHOLD_SLAB_ID := pn_threshold_slab_id;

313: r_jai_ap_tds_repository.SECTION_CODE := pv_section_code;
314: r_jai_ap_tds_repository.threshold_grp_id := pn_threshold_grp_id;
315: r_jai_ap_tds_repository.threshold_hdr_id := pn_threshold_hdr_id;
316: r_jai_ap_tds_repository.THRESHOLD_TYPE_ID := pn_threshold_type_id;
317: r_jai_ap_tds_repository.THRESHOLD_SLAB_ID := pn_threshold_slab_id;
318:
319: /*Set TDS invoice information*/
320: r_jai_ap_tds_repository.invoice_id := pn_invoice_id;
321: r_jai_ap_tds_repository.REQUIRED_FOR_ETDS := G_N; --Added for bug#16889298

Line 320: r_jai_ap_tds_repository.invoice_id := pn_invoice_id;

316: r_jai_ap_tds_repository.THRESHOLD_TYPE_ID := pn_threshold_type_id;
317: r_jai_ap_tds_repository.THRESHOLD_SLAB_ID := pn_threshold_slab_id;
318:
319: /*Set TDS invoice information*/
320: r_jai_ap_tds_repository.invoice_id := pn_invoice_id;
321: r_jai_ap_tds_repository.REQUIRED_FOR_ETDS := G_N; --Added for bug#16889298
322:
323: IF pn_invoice_id IS NOT NULL AND pn_invoice_id NOT IN (-9999, -9997) THEN
324: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'Set info TDS invoice: ' || pn_invoice_id);

Line 321: r_jai_ap_tds_repository.REQUIRED_FOR_ETDS := G_N; --Added for bug#16889298

317: r_jai_ap_tds_repository.THRESHOLD_SLAB_ID := pn_threshold_slab_id;
318:
319: /*Set TDS invoice information*/
320: r_jai_ap_tds_repository.invoice_id := pn_invoice_id;
321: r_jai_ap_tds_repository.REQUIRED_FOR_ETDS := G_N; --Added for bug#16889298
322:
323: IF pn_invoice_id IS NOT NULL AND pn_invoice_id NOT IN (-9999, -9997) THEN
324: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'Set info TDS invoice: ' || pn_invoice_id);
325:

Line 330: r_jai_ap_tds_repository.Invoice_number := r_c_get_trx_tds_info.invoice_to_tds_authority_num;

326: OPEN c_get_trx_tds_info(pn_invoice_id);
327: FETCH c_get_trx_tds_info into r_c_get_trx_tds_info;
328: CLOSE c_get_trx_tds_info;
329:
330: r_jai_ap_tds_repository.Invoice_number := r_c_get_trx_tds_info.invoice_to_tds_authority_num;
331: r_jai_ap_tds_repository.TDS_ACCOUNTING_DATE := r_c_get_trx_tds_info.gl_date;
332: --should in NORMAL, RTN, REV-RTN, TRANSITION , ROLLBACK, SURCHARGE, SURCHARGE ROLLBACK.
333: r_jai_ap_tds_repository.TDS_INVOICE_TYPE := get_tds_invoice_type(pv_event);
334: r_jai_ap_tds_repository.threshold_hdr_id := r_c_get_trx_tds_info.threshold_hdr_id;

Line 331: r_jai_ap_tds_repository.TDS_ACCOUNTING_DATE := r_c_get_trx_tds_info.gl_date;

327: FETCH c_get_trx_tds_info into r_c_get_trx_tds_info;
328: CLOSE c_get_trx_tds_info;
329:
330: r_jai_ap_tds_repository.Invoice_number := r_c_get_trx_tds_info.invoice_to_tds_authority_num;
331: r_jai_ap_tds_repository.TDS_ACCOUNTING_DATE := r_c_get_trx_tds_info.gl_date;
332: --should in NORMAL, RTN, REV-RTN, TRANSITION , ROLLBACK, SURCHARGE, SURCHARGE ROLLBACK.
333: r_jai_ap_tds_repository.TDS_INVOICE_TYPE := get_tds_invoice_type(pv_event);
334: r_jai_ap_tds_repository.threshold_hdr_id := r_c_get_trx_tds_info.threshold_hdr_id;
335: r_jai_ap_tds_repository.TDS_INV_TAX_AMOUNT := r_c_get_trx_tds_info.invoice_to_tds_authority_amt;

Line 333: r_jai_ap_tds_repository.TDS_INVOICE_TYPE := get_tds_invoice_type(pv_event);

329:
330: r_jai_ap_tds_repository.Invoice_number := r_c_get_trx_tds_info.invoice_to_tds_authority_num;
331: r_jai_ap_tds_repository.TDS_ACCOUNTING_DATE := r_c_get_trx_tds_info.gl_date;
332: --should in NORMAL, RTN, REV-RTN, TRANSITION , ROLLBACK, SURCHARGE, SURCHARGE ROLLBACK.
333: r_jai_ap_tds_repository.TDS_INVOICE_TYPE := get_tds_invoice_type(pv_event);
334: r_jai_ap_tds_repository.threshold_hdr_id := r_c_get_trx_tds_info.threshold_hdr_id;
335: r_jai_ap_tds_repository.TDS_INV_TAX_AMOUNT := r_c_get_trx_tds_info.invoice_to_tds_authority_amt;
336: r_jai_ap_tds_repository.SUPPLIER_CM_AMOUNT := r_c_get_trx_tds_info.invoice_to_vendor_amt;
337: r_jai_ap_tds_repository.BASE_TAX_AMOUNT := r_c_get_trx_tds_info.taxable_amount;

Line 334: r_jai_ap_tds_repository.threshold_hdr_id := r_c_get_trx_tds_info.threshold_hdr_id;

330: r_jai_ap_tds_repository.Invoice_number := r_c_get_trx_tds_info.invoice_to_tds_authority_num;
331: r_jai_ap_tds_repository.TDS_ACCOUNTING_DATE := r_c_get_trx_tds_info.gl_date;
332: --should in NORMAL, RTN, REV-RTN, TRANSITION , ROLLBACK, SURCHARGE, SURCHARGE ROLLBACK.
333: r_jai_ap_tds_repository.TDS_INVOICE_TYPE := get_tds_invoice_type(pv_event);
334: r_jai_ap_tds_repository.threshold_hdr_id := r_c_get_trx_tds_info.threshold_hdr_id;
335: r_jai_ap_tds_repository.TDS_INV_TAX_AMOUNT := r_c_get_trx_tds_info.invoice_to_tds_authority_amt;
336: r_jai_ap_tds_repository.SUPPLIER_CM_AMOUNT := r_c_get_trx_tds_info.invoice_to_vendor_amt;
337: r_jai_ap_tds_repository.BASE_TAX_AMOUNT := r_c_get_trx_tds_info.taxable_amount;
338: r_jai_ap_tds_repository.tax_category_id := r_c_get_trx_tds_info.tax_category_id;

Line 335: r_jai_ap_tds_repository.TDS_INV_TAX_AMOUNT := r_c_get_trx_tds_info.invoice_to_tds_authority_amt;

331: r_jai_ap_tds_repository.TDS_ACCOUNTING_DATE := r_c_get_trx_tds_info.gl_date;
332: --should in NORMAL, RTN, REV-RTN, TRANSITION , ROLLBACK, SURCHARGE, SURCHARGE ROLLBACK.
333: r_jai_ap_tds_repository.TDS_INVOICE_TYPE := get_tds_invoice_type(pv_event);
334: r_jai_ap_tds_repository.threshold_hdr_id := r_c_get_trx_tds_info.threshold_hdr_id;
335: r_jai_ap_tds_repository.TDS_INV_TAX_AMOUNT := r_c_get_trx_tds_info.invoice_to_tds_authority_amt;
336: r_jai_ap_tds_repository.SUPPLIER_CM_AMOUNT := r_c_get_trx_tds_info.invoice_to_vendor_amt;
337: r_jai_ap_tds_repository.BASE_TAX_AMOUNT := r_c_get_trx_tds_info.taxable_amount;
338: r_jai_ap_tds_repository.tax_category_id := r_c_get_trx_tds_info.tax_category_id;
339: r_jai_ap_tds_repository.TDS_AUTHORITY_ID := r_c_get_trx_tds_info.tds_authority_vendor_id;

Line 336: r_jai_ap_tds_repository.SUPPLIER_CM_AMOUNT := r_c_get_trx_tds_info.invoice_to_vendor_amt;

332: --should in NORMAL, RTN, REV-RTN, TRANSITION , ROLLBACK, SURCHARGE, SURCHARGE ROLLBACK.
333: r_jai_ap_tds_repository.TDS_INVOICE_TYPE := get_tds_invoice_type(pv_event);
334: r_jai_ap_tds_repository.threshold_hdr_id := r_c_get_trx_tds_info.threshold_hdr_id;
335: r_jai_ap_tds_repository.TDS_INV_TAX_AMOUNT := r_c_get_trx_tds_info.invoice_to_tds_authority_amt;
336: r_jai_ap_tds_repository.SUPPLIER_CM_AMOUNT := r_c_get_trx_tds_info.invoice_to_vendor_amt;
337: r_jai_ap_tds_repository.BASE_TAX_AMOUNT := r_c_get_trx_tds_info.taxable_amount;
338: r_jai_ap_tds_repository.tax_category_id := r_c_get_trx_tds_info.tax_category_id;
339: r_jai_ap_tds_repository.TDS_AUTHORITY_ID := r_c_get_trx_tds_info.tds_authority_vendor_id;
340: r_jai_ap_tds_repository.TDS_AUTHORITY_SITE_ID := r_c_get_trx_tds_info.tds_authority_vendor_site_id;

Line 337: r_jai_ap_tds_repository.BASE_TAX_AMOUNT := r_c_get_trx_tds_info.taxable_amount;

333: r_jai_ap_tds_repository.TDS_INVOICE_TYPE := get_tds_invoice_type(pv_event);
334: r_jai_ap_tds_repository.threshold_hdr_id := r_c_get_trx_tds_info.threshold_hdr_id;
335: r_jai_ap_tds_repository.TDS_INV_TAX_AMOUNT := r_c_get_trx_tds_info.invoice_to_tds_authority_amt;
336: r_jai_ap_tds_repository.SUPPLIER_CM_AMOUNT := r_c_get_trx_tds_info.invoice_to_vendor_amt;
337: r_jai_ap_tds_repository.BASE_TAX_AMOUNT := r_c_get_trx_tds_info.taxable_amount;
338: r_jai_ap_tds_repository.tax_category_id := r_c_get_trx_tds_info.tax_category_id;
339: r_jai_ap_tds_repository.TDS_AUTHORITY_ID := r_c_get_trx_tds_info.tds_authority_vendor_id;
340: r_jai_ap_tds_repository.TDS_AUTHORITY_SITE_ID := r_c_get_trx_tds_info.tds_authority_vendor_site_id;
341:

Line 338: r_jai_ap_tds_repository.tax_category_id := r_c_get_trx_tds_info.tax_category_id;

334: r_jai_ap_tds_repository.threshold_hdr_id := r_c_get_trx_tds_info.threshold_hdr_id;
335: r_jai_ap_tds_repository.TDS_INV_TAX_AMOUNT := r_c_get_trx_tds_info.invoice_to_tds_authority_amt;
336: r_jai_ap_tds_repository.SUPPLIER_CM_AMOUNT := r_c_get_trx_tds_info.invoice_to_vendor_amt;
337: r_jai_ap_tds_repository.BASE_TAX_AMOUNT := r_c_get_trx_tds_info.taxable_amount;
338: r_jai_ap_tds_repository.tax_category_id := r_c_get_trx_tds_info.tax_category_id;
339: r_jai_ap_tds_repository.TDS_AUTHORITY_ID := r_c_get_trx_tds_info.tds_authority_vendor_id;
340: r_jai_ap_tds_repository.TDS_AUTHORITY_SITE_ID := r_c_get_trx_tds_info.tds_authority_vendor_site_id;
341:
342: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: Invoice_number[' || r_jai_ap_tds_repository.Invoice_number || '],');

Line 339: r_jai_ap_tds_repository.TDS_AUTHORITY_ID := r_c_get_trx_tds_info.tds_authority_vendor_id;

335: r_jai_ap_tds_repository.TDS_INV_TAX_AMOUNT := r_c_get_trx_tds_info.invoice_to_tds_authority_amt;
336: r_jai_ap_tds_repository.SUPPLIER_CM_AMOUNT := r_c_get_trx_tds_info.invoice_to_vendor_amt;
337: r_jai_ap_tds_repository.BASE_TAX_AMOUNT := r_c_get_trx_tds_info.taxable_amount;
338: r_jai_ap_tds_repository.tax_category_id := r_c_get_trx_tds_info.tax_category_id;
339: r_jai_ap_tds_repository.TDS_AUTHORITY_ID := r_c_get_trx_tds_info.tds_authority_vendor_id;
340: r_jai_ap_tds_repository.TDS_AUTHORITY_SITE_ID := r_c_get_trx_tds_info.tds_authority_vendor_site_id;
341:
342: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: Invoice_number[' || r_jai_ap_tds_repository.Invoice_number || '],');
343: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_ACCOUNTING_DATE[' || r_jai_ap_tds_repository.TDS_ACCOUNTING_DATE || '],');

Line 340: r_jai_ap_tds_repository.TDS_AUTHORITY_SITE_ID := r_c_get_trx_tds_info.tds_authority_vendor_site_id;

336: r_jai_ap_tds_repository.SUPPLIER_CM_AMOUNT := r_c_get_trx_tds_info.invoice_to_vendor_amt;
337: r_jai_ap_tds_repository.BASE_TAX_AMOUNT := r_c_get_trx_tds_info.taxable_amount;
338: r_jai_ap_tds_repository.tax_category_id := r_c_get_trx_tds_info.tax_category_id;
339: r_jai_ap_tds_repository.TDS_AUTHORITY_ID := r_c_get_trx_tds_info.tds_authority_vendor_id;
340: r_jai_ap_tds_repository.TDS_AUTHORITY_SITE_ID := r_c_get_trx_tds_info.tds_authority_vendor_site_id;
341:
342: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: Invoice_number[' || r_jai_ap_tds_repository.Invoice_number || '],');
343: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_ACCOUNTING_DATE[' || r_jai_ap_tds_repository.TDS_ACCOUNTING_DATE || '],');
344: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_INVOICE_TYPE[' || r_jai_ap_tds_repository.TDS_INVOICE_TYPE || '],');

Line 342: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: Invoice_number[' || r_jai_ap_tds_repository.Invoice_number || '],');

338: r_jai_ap_tds_repository.tax_category_id := r_c_get_trx_tds_info.tax_category_id;
339: r_jai_ap_tds_repository.TDS_AUTHORITY_ID := r_c_get_trx_tds_info.tds_authority_vendor_id;
340: r_jai_ap_tds_repository.TDS_AUTHORITY_SITE_ID := r_c_get_trx_tds_info.tds_authority_vendor_site_id;
341:
342: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: Invoice_number[' || r_jai_ap_tds_repository.Invoice_number || '],');
343: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_ACCOUNTING_DATE[' || r_jai_ap_tds_repository.TDS_ACCOUNTING_DATE || '],');
344: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_INVOICE_TYPE[' || r_jai_ap_tds_repository.TDS_INVOICE_TYPE || '],');
345: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: threshold_hdr_id[' || r_jai_ap_tds_repository.threshold_hdr_id || '],');
346: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: THRESHOLD_TYPE_ID[' || r_jai_ap_tds_repository.THRESHOLD_TYPE_ID || '],');

Line 343: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_ACCOUNTING_DATE[' || r_jai_ap_tds_repository.TDS_ACCOUNTING_DATE || '],');

339: r_jai_ap_tds_repository.TDS_AUTHORITY_ID := r_c_get_trx_tds_info.tds_authority_vendor_id;
340: r_jai_ap_tds_repository.TDS_AUTHORITY_SITE_ID := r_c_get_trx_tds_info.tds_authority_vendor_site_id;
341:
342: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: Invoice_number[' || r_jai_ap_tds_repository.Invoice_number || '],');
343: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_ACCOUNTING_DATE[' || r_jai_ap_tds_repository.TDS_ACCOUNTING_DATE || '],');
344: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_INVOICE_TYPE[' || r_jai_ap_tds_repository.TDS_INVOICE_TYPE || '],');
345: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: threshold_hdr_id[' || r_jai_ap_tds_repository.threshold_hdr_id || '],');
346: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: THRESHOLD_TYPE_ID[' || r_jai_ap_tds_repository.THRESHOLD_TYPE_ID || '],');
347: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: THRESHOLD_SLAB_ID[' || r_jai_ap_tds_repository.THRESHOLD_SLAB_ID || '],');

Line 344: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_INVOICE_TYPE[' || r_jai_ap_tds_repository.TDS_INVOICE_TYPE || '],');

340: r_jai_ap_tds_repository.TDS_AUTHORITY_SITE_ID := r_c_get_trx_tds_info.tds_authority_vendor_site_id;
341:
342: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: Invoice_number[' || r_jai_ap_tds_repository.Invoice_number || '],');
343: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_ACCOUNTING_DATE[' || r_jai_ap_tds_repository.TDS_ACCOUNTING_DATE || '],');
344: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_INVOICE_TYPE[' || r_jai_ap_tds_repository.TDS_INVOICE_TYPE || '],');
345: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: threshold_hdr_id[' || r_jai_ap_tds_repository.threshold_hdr_id || '],');
346: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: THRESHOLD_TYPE_ID[' || r_jai_ap_tds_repository.THRESHOLD_TYPE_ID || '],');
347: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: THRESHOLD_SLAB_ID[' || r_jai_ap_tds_repository.THRESHOLD_SLAB_ID || '],');
348: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_INV_TAX_AMOUNT[' || r_jai_ap_tds_repository.TDS_INV_TAX_AMOUNT || '],');

Line 345: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: threshold_hdr_id[' || r_jai_ap_tds_repository.threshold_hdr_id || '],');

341:
342: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: Invoice_number[' || r_jai_ap_tds_repository.Invoice_number || '],');
343: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_ACCOUNTING_DATE[' || r_jai_ap_tds_repository.TDS_ACCOUNTING_DATE || '],');
344: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_INVOICE_TYPE[' || r_jai_ap_tds_repository.TDS_INVOICE_TYPE || '],');
345: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: threshold_hdr_id[' || r_jai_ap_tds_repository.threshold_hdr_id || '],');
346: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: THRESHOLD_TYPE_ID[' || r_jai_ap_tds_repository.THRESHOLD_TYPE_ID || '],');
347: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: THRESHOLD_SLAB_ID[' || r_jai_ap_tds_repository.THRESHOLD_SLAB_ID || '],');
348: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_INV_TAX_AMOUNT[' || r_jai_ap_tds_repository.TDS_INV_TAX_AMOUNT || '],');
349: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: SUPPLIER_CM_AMOUNT[' || r_jai_ap_tds_repository.SUPPLIER_CM_AMOUNT || '],');

Line 346: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: THRESHOLD_TYPE_ID[' || r_jai_ap_tds_repository.THRESHOLD_TYPE_ID || '],');

342: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: Invoice_number[' || r_jai_ap_tds_repository.Invoice_number || '],');
343: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_ACCOUNTING_DATE[' || r_jai_ap_tds_repository.TDS_ACCOUNTING_DATE || '],');
344: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_INVOICE_TYPE[' || r_jai_ap_tds_repository.TDS_INVOICE_TYPE || '],');
345: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: threshold_hdr_id[' || r_jai_ap_tds_repository.threshold_hdr_id || '],');
346: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: THRESHOLD_TYPE_ID[' || r_jai_ap_tds_repository.THRESHOLD_TYPE_ID || '],');
347: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: THRESHOLD_SLAB_ID[' || r_jai_ap_tds_repository.THRESHOLD_SLAB_ID || '],');
348: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_INV_TAX_AMOUNT[' || r_jai_ap_tds_repository.TDS_INV_TAX_AMOUNT || '],');
349: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: SUPPLIER_CM_AMOUNT[' || r_jai_ap_tds_repository.SUPPLIER_CM_AMOUNT || '],');
350: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: BASE_TAX_AMOUNT[' || r_jai_ap_tds_repository.BASE_TAX_AMOUNT || '],');

Line 347: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: THRESHOLD_SLAB_ID[' || r_jai_ap_tds_repository.THRESHOLD_SLAB_ID || '],');

343: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_ACCOUNTING_DATE[' || r_jai_ap_tds_repository.TDS_ACCOUNTING_DATE || '],');
344: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_INVOICE_TYPE[' || r_jai_ap_tds_repository.TDS_INVOICE_TYPE || '],');
345: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: threshold_hdr_id[' || r_jai_ap_tds_repository.threshold_hdr_id || '],');
346: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: THRESHOLD_TYPE_ID[' || r_jai_ap_tds_repository.THRESHOLD_TYPE_ID || '],');
347: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: THRESHOLD_SLAB_ID[' || r_jai_ap_tds_repository.THRESHOLD_SLAB_ID || '],');
348: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_INV_TAX_AMOUNT[' || r_jai_ap_tds_repository.TDS_INV_TAX_AMOUNT || '],');
349: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: SUPPLIER_CM_AMOUNT[' || r_jai_ap_tds_repository.SUPPLIER_CM_AMOUNT || '],');
350: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: BASE_TAX_AMOUNT[' || r_jai_ap_tds_repository.BASE_TAX_AMOUNT || '],');
351: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: tax_category_id[' || r_jai_ap_tds_repository.tax_category_id || '],');

Line 348: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_INV_TAX_AMOUNT[' || r_jai_ap_tds_repository.TDS_INV_TAX_AMOUNT || '],');

344: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_INVOICE_TYPE[' || r_jai_ap_tds_repository.TDS_INVOICE_TYPE || '],');
345: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: threshold_hdr_id[' || r_jai_ap_tds_repository.threshold_hdr_id || '],');
346: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: THRESHOLD_TYPE_ID[' || r_jai_ap_tds_repository.THRESHOLD_TYPE_ID || '],');
347: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: THRESHOLD_SLAB_ID[' || r_jai_ap_tds_repository.THRESHOLD_SLAB_ID || '],');
348: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_INV_TAX_AMOUNT[' || r_jai_ap_tds_repository.TDS_INV_TAX_AMOUNT || '],');
349: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: SUPPLIER_CM_AMOUNT[' || r_jai_ap_tds_repository.SUPPLIER_CM_AMOUNT || '],');
350: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: BASE_TAX_AMOUNT[' || r_jai_ap_tds_repository.BASE_TAX_AMOUNT || '],');
351: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: tax_category_id[' || r_jai_ap_tds_repository.tax_category_id || '],');
352: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_AUTHORITY_ID[' || r_jai_ap_tds_repository.TDS_AUTHORITY_ID || '],');

Line 349: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: SUPPLIER_CM_AMOUNT[' || r_jai_ap_tds_repository.SUPPLIER_CM_AMOUNT || '],');

345: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: threshold_hdr_id[' || r_jai_ap_tds_repository.threshold_hdr_id || '],');
346: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: THRESHOLD_TYPE_ID[' || r_jai_ap_tds_repository.THRESHOLD_TYPE_ID || '],');
347: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: THRESHOLD_SLAB_ID[' || r_jai_ap_tds_repository.THRESHOLD_SLAB_ID || '],');
348: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_INV_TAX_AMOUNT[' || r_jai_ap_tds_repository.TDS_INV_TAX_AMOUNT || '],');
349: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: SUPPLIER_CM_AMOUNT[' || r_jai_ap_tds_repository.SUPPLIER_CM_AMOUNT || '],');
350: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: BASE_TAX_AMOUNT[' || r_jai_ap_tds_repository.BASE_TAX_AMOUNT || '],');
351: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: tax_category_id[' || r_jai_ap_tds_repository.tax_category_id || '],');
352: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_AUTHORITY_ID[' || r_jai_ap_tds_repository.TDS_AUTHORITY_ID || '],');
353: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_AUTHORITY_SITE_ID[' || r_jai_ap_tds_repository.TDS_AUTHORITY_SITE_ID || '],');

Line 350: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: BASE_TAX_AMOUNT[' || r_jai_ap_tds_repository.BASE_TAX_AMOUNT || '],');

346: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: THRESHOLD_TYPE_ID[' || r_jai_ap_tds_repository.THRESHOLD_TYPE_ID || '],');
347: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: THRESHOLD_SLAB_ID[' || r_jai_ap_tds_repository.THRESHOLD_SLAB_ID || '],');
348: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_INV_TAX_AMOUNT[' || r_jai_ap_tds_repository.TDS_INV_TAX_AMOUNT || '],');
349: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: SUPPLIER_CM_AMOUNT[' || r_jai_ap_tds_repository.SUPPLIER_CM_AMOUNT || '],');
350: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: BASE_TAX_AMOUNT[' || r_jai_ap_tds_repository.BASE_TAX_AMOUNT || '],');
351: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: tax_category_id[' || r_jai_ap_tds_repository.tax_category_id || '],');
352: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_AUTHORITY_ID[' || r_jai_ap_tds_repository.TDS_AUTHORITY_ID || '],');
353: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_AUTHORITY_SITE_ID[' || r_jai_ap_tds_repository.TDS_AUTHORITY_SITE_ID || '],');
354:

Line 351: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: tax_category_id[' || r_jai_ap_tds_repository.tax_category_id || '],');

347: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: THRESHOLD_SLAB_ID[' || r_jai_ap_tds_repository.THRESHOLD_SLAB_ID || '],');
348: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_INV_TAX_AMOUNT[' || r_jai_ap_tds_repository.TDS_INV_TAX_AMOUNT || '],');
349: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: SUPPLIER_CM_AMOUNT[' || r_jai_ap_tds_repository.SUPPLIER_CM_AMOUNT || '],');
350: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: BASE_TAX_AMOUNT[' || r_jai_ap_tds_repository.BASE_TAX_AMOUNT || '],');
351: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: tax_category_id[' || r_jai_ap_tds_repository.tax_category_id || '],');
352: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_AUTHORITY_ID[' || r_jai_ap_tds_repository.TDS_AUTHORITY_ID || '],');
353: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_AUTHORITY_SITE_ID[' || r_jai_ap_tds_repository.TDS_AUTHORITY_SITE_ID || '],');
354:
355: IF pv_section_type <> G_TDS_SECTION THEN

Line 352: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_AUTHORITY_ID[' || r_jai_ap_tds_repository.TDS_AUTHORITY_ID || '],');

348: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_INV_TAX_AMOUNT[' || r_jai_ap_tds_repository.TDS_INV_TAX_AMOUNT || '],');
349: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: SUPPLIER_CM_AMOUNT[' || r_jai_ap_tds_repository.SUPPLIER_CM_AMOUNT || '],');
350: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: BASE_TAX_AMOUNT[' || r_jai_ap_tds_repository.BASE_TAX_AMOUNT || '],');
351: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: tax_category_id[' || r_jai_ap_tds_repository.tax_category_id || '],');
352: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_AUTHORITY_ID[' || r_jai_ap_tds_repository.TDS_AUTHORITY_ID || '],');
353: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_AUTHORITY_SITE_ID[' || r_jai_ap_tds_repository.TDS_AUTHORITY_SITE_ID || '],');
354:
355: IF pv_section_type <> G_TDS_SECTION THEN
356: --when section type in WCT or ESSI, get effective rate by WCT/ESSI from tax code

Line 353: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_AUTHORITY_SITE_ID[' || r_jai_ap_tds_repository.TDS_AUTHORITY_SITE_ID || '],');

349: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: SUPPLIER_CM_AMOUNT[' || r_jai_ap_tds_repository.SUPPLIER_CM_AMOUNT || '],');
350: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: BASE_TAX_AMOUNT[' || r_jai_ap_tds_repository.BASE_TAX_AMOUNT || '],');
351: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: tax_category_id[' || r_jai_ap_tds_repository.tax_category_id || '],');
352: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_AUTHORITY_ID[' || r_jai_ap_tds_repository.TDS_AUTHORITY_ID || '],');
353: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_AUTHORITY_SITE_ID[' || r_jai_ap_tds_repository.TDS_AUTHORITY_SITE_ID || '],');
354:
355: IF pv_section_type <> G_TDS_SECTION THEN
356: --when section type in WCT or ESSI, get effective rate by WCT/ESSI from tax code
357: --Assume that in given TDS tax category, only one tax in WCT/ESSI type and its precedence always be 0.

Line 364: r_jai_ap_tds_repository.TAX_RATE := r_c_get_tds_essi_rate.tax_rate;

360: );
361: FETCH c_get_tds_essi_rate into r_c_get_tds_essi_rate;
362: CLOSE c_get_tds_essi_rate;
363:
364: r_jai_ap_tds_repository.TAX_RATE := r_c_get_tds_essi_rate.tax_rate;
365: r_jai_ap_tds_repository.TAX_ID := r_c_get_tds_essi_rate.tax_id;
366: ELSE
367: --When TDS transaction, just give the tds_effective_rate in trx table.
368: r_jai_ap_tds_repository.TAX_RATE := NVL(r_c_get_trx_tds_info.effective_tds_rate,0);

Line 365: r_jai_ap_tds_repository.TAX_ID := r_c_get_tds_essi_rate.tax_id;

361: FETCH c_get_tds_essi_rate into r_c_get_tds_essi_rate;
362: CLOSE c_get_tds_essi_rate;
363:
364: r_jai_ap_tds_repository.TAX_RATE := r_c_get_tds_essi_rate.tax_rate;
365: r_jai_ap_tds_repository.TAX_ID := r_c_get_tds_essi_rate.tax_id;
366: ELSE
367: --When TDS transaction, just give the tds_effective_rate in trx table.
368: r_jai_ap_tds_repository.TAX_RATE := NVL(r_c_get_trx_tds_info.effective_tds_rate,0);
369: END iF;

Line 368: r_jai_ap_tds_repository.TAX_RATE := NVL(r_c_get_trx_tds_info.effective_tds_rate,0);

364: r_jai_ap_tds_repository.TAX_RATE := r_c_get_tds_essi_rate.tax_rate;
365: r_jai_ap_tds_repository.TAX_ID := r_c_get_tds_essi_rate.tax_id;
366: ELSE
367: --When TDS transaction, just give the tds_effective_rate in trx table.
368: r_jai_ap_tds_repository.TAX_RATE := NVL(r_c_get_trx_tds_info.effective_tds_rate,0);
369: END iF;
370:
371: --TDS invoice created
372: r_jai_ap_tds_repository.PRIOR_THRESHOLD := G_N;

Line 372: r_jai_ap_tds_repository.PRIOR_THRESHOLD := G_N;

368: r_jai_ap_tds_repository.TAX_RATE := NVL(r_c_get_trx_tds_info.effective_tds_rate,0);
369: END iF;
370:
371: --TDS invoice created
372: r_jai_ap_tds_repository.PRIOR_THRESHOLD := G_N;
373: ELSIF pn_invoice_id IS NULL THEN
374: --No TDS invoice created, means prior threshold transiton
375: r_jai_ap_tds_repository.PRIOR_THRESHOLD := G_Y;
376: ELSIF pn_invoice_id IN (-9999, -9997) THEN

Line 375: r_jai_ap_tds_repository.PRIOR_THRESHOLD := G_Y;

371: --TDS invoice created
372: r_jai_ap_tds_repository.PRIOR_THRESHOLD := G_N;
373: ELSIF pn_invoice_id IS NULL THEN
374: --No TDS invoice created, means prior threshold transiton
375: r_jai_ap_tds_repository.PRIOR_THRESHOLD := G_Y;
376: ELSIF pn_invoice_id IN (-9999, -9997) THEN
377: -- for zero rate TDS, no TDS created
378: r_jai_ap_tds_repository.PRIOR_THRESHOLD := G_N;
379: r_jai_ap_tds_repository.REQUIRED_FOR_ETDS := G_Y; --Added for bug#16889298

Line 378: r_jai_ap_tds_repository.PRIOR_THRESHOLD := G_N;

374: --No TDS invoice created, means prior threshold transiton
375: r_jai_ap_tds_repository.PRIOR_THRESHOLD := G_Y;
376: ELSIF pn_invoice_id IN (-9999, -9997) THEN
377: -- for zero rate TDS, no TDS created
378: r_jai_ap_tds_repository.PRIOR_THRESHOLD := G_N;
379: r_jai_ap_tds_repository.REQUIRED_FOR_ETDS := G_Y; --Added for bug#16889298
380: END IF;
381: --r_jai_ap_tds_repository.REQUIRED_FOR_ETDS := G_N; --Commented out for bug#16889298
382:

Line 379: r_jai_ap_tds_repository.REQUIRED_FOR_ETDS := G_Y; --Added for bug#16889298

375: r_jai_ap_tds_repository.PRIOR_THRESHOLD := G_Y;
376: ELSIF pn_invoice_id IN (-9999, -9997) THEN
377: -- for zero rate TDS, no TDS created
378: r_jai_ap_tds_repository.PRIOR_THRESHOLD := G_N;
379: r_jai_ap_tds_repository.REQUIRED_FOR_ETDS := G_Y; --Added for bug#16889298
380: END IF;
381: --r_jai_ap_tds_repository.REQUIRED_FOR_ETDS := G_N; --Commented out for bug#16889298
382:
383: /*Threshold transition or threshold rollback can'tderive source invoice id*/

Line 381: --r_jai_ap_tds_repository.REQUIRED_FOR_ETDS := G_N; --Commented out for bug#16889298

377: -- for zero rate TDS, no TDS created
378: r_jai_ap_tds_repository.PRIOR_THRESHOLD := G_N;
379: r_jai_ap_tds_repository.REQUIRED_FOR_ETDS := G_Y; --Added for bug#16889298
380: END IF;
381: --r_jai_ap_tds_repository.REQUIRED_FOR_ETDS := G_N; --Commented out for bug#16889298
382:
383: /*Threshold transition or threshold rollback can'tderive source invoice id*/
384: --ISSUE: for threshold rollback and threshold transition do we need split TDS invoice into each source invoice?
385: --Confirmed. Just use the trigger invoice id for threshold transition and rollback

Line 393: r_jai_ap_tds_repository.SOURCE_INVOICE_ID := r_c_get_inv_info.invoice_id;

389: OPEN c_get_inv_info(pn_source_invoice_id);
390: FETCH c_get_inv_info into r_c_get_inv_info;
391: CLOSE c_get_inv_info;
392:
393: r_jai_ap_tds_repository.SOURCE_INVOICE_ID := r_c_get_inv_info.invoice_id;
394: r_jai_ap_tds_repository.SOURCE_INVOICE_TYPE := r_c_get_inv_info.invoice_type_lookup_code;
395: r_jai_ap_tds_repository.SOURCE_INVOICE_AMT := r_c_get_inv_info.invoice_amount;
396: r_jai_ap_tds_repository.SOURCE_ID := r_c_get_inv_info.vendor_id;
397: r_jai_ap_tds_repository.SOURCE_SITE_ID := r_c_get_inv_info.vendor_site_id;

Line 394: r_jai_ap_tds_repository.SOURCE_INVOICE_TYPE := r_c_get_inv_info.invoice_type_lookup_code;

390: FETCH c_get_inv_info into r_c_get_inv_info;
391: CLOSE c_get_inv_info;
392:
393: r_jai_ap_tds_repository.SOURCE_INVOICE_ID := r_c_get_inv_info.invoice_id;
394: r_jai_ap_tds_repository.SOURCE_INVOICE_TYPE := r_c_get_inv_info.invoice_type_lookup_code;
395: r_jai_ap_tds_repository.SOURCE_INVOICE_AMT := r_c_get_inv_info.invoice_amount;
396: r_jai_ap_tds_repository.SOURCE_ID := r_c_get_inv_info.vendor_id;
397: r_jai_ap_tds_repository.SOURCE_SITE_ID := r_c_get_inv_info.vendor_site_id;
398: --r_jai_ap_tds_repository.INVOICE_CHECK_ID := NULL;

Line 395: r_jai_ap_tds_repository.SOURCE_INVOICE_AMT := r_c_get_inv_info.invoice_amount;

391: CLOSE c_get_inv_info;
392:
393: r_jai_ap_tds_repository.SOURCE_INVOICE_ID := r_c_get_inv_info.invoice_id;
394: r_jai_ap_tds_repository.SOURCE_INVOICE_TYPE := r_c_get_inv_info.invoice_type_lookup_code;
395: r_jai_ap_tds_repository.SOURCE_INVOICE_AMT := r_c_get_inv_info.invoice_amount;
396: r_jai_ap_tds_repository.SOURCE_ID := r_c_get_inv_info.vendor_id;
397: r_jai_ap_tds_repository.SOURCE_SITE_ID := r_c_get_inv_info.vendor_site_id;
398: --r_jai_ap_tds_repository.INVOICE_CHECK_ID := NULL;
399: r_jai_ap_tds_repository.SOURCE_INVOICE_DATE := r_c_get_inv_info.invoice_date;

Line 396: r_jai_ap_tds_repository.SOURCE_ID := r_c_get_inv_info.vendor_id;

392:
393: r_jai_ap_tds_repository.SOURCE_INVOICE_ID := r_c_get_inv_info.invoice_id;
394: r_jai_ap_tds_repository.SOURCE_INVOICE_TYPE := r_c_get_inv_info.invoice_type_lookup_code;
395: r_jai_ap_tds_repository.SOURCE_INVOICE_AMT := r_c_get_inv_info.invoice_amount;
396: r_jai_ap_tds_repository.SOURCE_ID := r_c_get_inv_info.vendor_id;
397: r_jai_ap_tds_repository.SOURCE_SITE_ID := r_c_get_inv_info.vendor_site_id;
398: --r_jai_ap_tds_repository.INVOICE_CHECK_ID := NULL;
399: r_jai_ap_tds_repository.SOURCE_INVOICE_DATE := r_c_get_inv_info.invoice_date;
400: r_jai_ap_tds_repository.ACCOUNTING_DATE := r_c_get_inv_info.gl_date;

Line 397: r_jai_ap_tds_repository.SOURCE_SITE_ID := r_c_get_inv_info.vendor_site_id;

393: r_jai_ap_tds_repository.SOURCE_INVOICE_ID := r_c_get_inv_info.invoice_id;
394: r_jai_ap_tds_repository.SOURCE_INVOICE_TYPE := r_c_get_inv_info.invoice_type_lookup_code;
395: r_jai_ap_tds_repository.SOURCE_INVOICE_AMT := r_c_get_inv_info.invoice_amount;
396: r_jai_ap_tds_repository.SOURCE_ID := r_c_get_inv_info.vendor_id;
397: r_jai_ap_tds_repository.SOURCE_SITE_ID := r_c_get_inv_info.vendor_site_id;
398: --r_jai_ap_tds_repository.INVOICE_CHECK_ID := NULL;
399: r_jai_ap_tds_repository.SOURCE_INVOICE_DATE := r_c_get_inv_info.invoice_date;
400: r_jai_ap_tds_repository.ACCOUNTING_DATE := r_c_get_inv_info.gl_date;
401: r_jai_ap_tds_repository.ORG_ID := r_c_get_inv_info.org_id;

Line 398: --r_jai_ap_tds_repository.INVOICE_CHECK_ID := NULL;

394: r_jai_ap_tds_repository.SOURCE_INVOICE_TYPE := r_c_get_inv_info.invoice_type_lookup_code;
395: r_jai_ap_tds_repository.SOURCE_INVOICE_AMT := r_c_get_inv_info.invoice_amount;
396: r_jai_ap_tds_repository.SOURCE_ID := r_c_get_inv_info.vendor_id;
397: r_jai_ap_tds_repository.SOURCE_SITE_ID := r_c_get_inv_info.vendor_site_id;
398: --r_jai_ap_tds_repository.INVOICE_CHECK_ID := NULL;
399: r_jai_ap_tds_repository.SOURCE_INVOICE_DATE := r_c_get_inv_info.invoice_date;
400: r_jai_ap_tds_repository.ACCOUNTING_DATE := r_c_get_inv_info.gl_date;
401: r_jai_ap_tds_repository.ORG_ID := r_c_get_inv_info.org_id;
402: r_jai_ap_tds_repository.LEGAL_ENTITY_ID := r_c_get_inv_info.legal_entity_id;

Line 399: r_jai_ap_tds_repository.SOURCE_INVOICE_DATE := r_c_get_inv_info.invoice_date;

395: r_jai_ap_tds_repository.SOURCE_INVOICE_AMT := r_c_get_inv_info.invoice_amount;
396: r_jai_ap_tds_repository.SOURCE_ID := r_c_get_inv_info.vendor_id;
397: r_jai_ap_tds_repository.SOURCE_SITE_ID := r_c_get_inv_info.vendor_site_id;
398: --r_jai_ap_tds_repository.INVOICE_CHECK_ID := NULL;
399: r_jai_ap_tds_repository.SOURCE_INVOICE_DATE := r_c_get_inv_info.invoice_date;
400: r_jai_ap_tds_repository.ACCOUNTING_DATE := r_c_get_inv_info.gl_date;
401: r_jai_ap_tds_repository.ORG_ID := r_c_get_inv_info.org_id;
402: r_jai_ap_tds_repository.LEGAL_ENTITY_ID := r_c_get_inv_info.legal_entity_id;
403:

Line 400: r_jai_ap_tds_repository.ACCOUNTING_DATE := r_c_get_inv_info.gl_date;

396: r_jai_ap_tds_repository.SOURCE_ID := r_c_get_inv_info.vendor_id;
397: r_jai_ap_tds_repository.SOURCE_SITE_ID := r_c_get_inv_info.vendor_site_id;
398: --r_jai_ap_tds_repository.INVOICE_CHECK_ID := NULL;
399: r_jai_ap_tds_repository.SOURCE_INVOICE_DATE := r_c_get_inv_info.invoice_date;
400: r_jai_ap_tds_repository.ACCOUNTING_DATE := r_c_get_inv_info.gl_date;
401: r_jai_ap_tds_repository.ORG_ID := r_c_get_inv_info.org_id;
402: r_jai_ap_tds_repository.LEGAL_ENTITY_ID := r_c_get_inv_info.legal_entity_id;
403:
404: /* @TODO

Line 401: r_jai_ap_tds_repository.ORG_ID := r_c_get_inv_info.org_id;

397: r_jai_ap_tds_repository.SOURCE_SITE_ID := r_c_get_inv_info.vendor_site_id;
398: --r_jai_ap_tds_repository.INVOICE_CHECK_ID := NULL;
399: r_jai_ap_tds_repository.SOURCE_INVOICE_DATE := r_c_get_inv_info.invoice_date;
400: r_jai_ap_tds_repository.ACCOUNTING_DATE := r_c_get_inv_info.gl_date;
401: r_jai_ap_tds_repository.ORG_ID := r_c_get_inv_info.org_id;
402: r_jai_ap_tds_repository.LEGAL_ENTITY_ID := r_c_get_inv_info.legal_entity_id;
403:
404: /* @TODO
405: If BASE_TAX_AMOUNT is null then

Line 402: r_jai_ap_tds_repository.LEGAL_ENTITY_ID := r_c_get_inv_info.legal_entity_id;

398: --r_jai_ap_tds_repository.INVOICE_CHECK_ID := NULL;
399: r_jai_ap_tds_repository.SOURCE_INVOICE_DATE := r_c_get_inv_info.invoice_date;
400: r_jai_ap_tds_repository.ACCOUNTING_DATE := r_c_get_inv_info.gl_date;
401: r_jai_ap_tds_repository.ORG_ID := r_c_get_inv_info.org_id;
402: r_jai_ap_tds_repository.LEGAL_ENTITY_ID := r_c_get_inv_info.legal_entity_id;
403:
404: /* @TODO
405: If BASE_TAX_AMOUNT is null then
406: --no TDS invoice created, derive base tax amount from current source invoice

Line 413: r_jai_ap_tds_repository.BASE_TAX_AMOUNT := r_c_get_inv_info.invoice_amount;

409: BASE_TAX_AMOUNT <--- source invoice amount.
410: End if;*/
411: IF pn_invoice_id IN (-9999, -9997) THEN
412: -- for zero rate TDS, no TDS created
413: r_jai_ap_tds_repository.BASE_TAX_AMOUNT := r_c_get_inv_info.invoice_amount;
414: END IF;
415: END IF; --pn_source_invoice_id IS NOT NULL
416:
417: --Derive tds regime ID and code from regime setup

Line 421: r_jai_ap_tds_repository.REGIME_ID := r_c_get_tax_regime_info.regime_id;

417: --Derive tds regime ID and code from regime setup
418: OPEN c_get_tax_regime_info(G_TDS);
419: FETCH c_get_tax_regime_info INTO r_c_get_tax_regime_info;
420: CLOSE c_get_tax_regime_info;
421: r_jai_ap_tds_repository.REGIME_ID := r_c_get_tax_regime_info.regime_id;
422: r_jai_ap_tds_repository.REGIME_CODE := r_c_get_tax_regime_info.lookup_code;
423:
424: --Derive org_tan number from regime registration by below cursor
425: OPEN c_get_tds_org_tan(r_jai_ap_tds_repository.ORG_ID);

Line 422: r_jai_ap_tds_repository.REGIME_CODE := r_c_get_tax_regime_info.lookup_code;

418: OPEN c_get_tax_regime_info(G_TDS);
419: FETCH c_get_tax_regime_info INTO r_c_get_tax_regime_info;
420: CLOSE c_get_tax_regime_info;
421: r_jai_ap_tds_repository.REGIME_ID := r_c_get_tax_regime_info.regime_id;
422: r_jai_ap_tds_repository.REGIME_CODE := r_c_get_tax_regime_info.lookup_code;
423:
424: --Derive org_tan number from regime registration by below cursor
425: OPEN c_get_tds_org_tan(r_jai_ap_tds_repository.ORG_ID);
426: FETCH c_get_tds_org_tan INTO r_c_get_tds_org_tan;

Line 425: OPEN c_get_tds_org_tan(r_jai_ap_tds_repository.ORG_ID);

421: r_jai_ap_tds_repository.REGIME_ID := r_c_get_tax_regime_info.regime_id;
422: r_jai_ap_tds_repository.REGIME_CODE := r_c_get_tax_regime_info.lookup_code;
423:
424: --Derive org_tan number from regime registration by below cursor
425: OPEN c_get_tds_org_tan(r_jai_ap_tds_repository.ORG_ID);
426: FETCH c_get_tds_org_tan INTO r_c_get_tds_org_tan;
427: CLOSE c_get_tds_org_tan;
428: r_jai_ap_tds_repository.org_tan_number := r_c_get_tds_org_tan.org_tan_num;
429:

Line 428: r_jai_ap_tds_repository.org_tan_number := r_c_get_tds_org_tan.org_tan_num;

424: --Derive org_tan number from regime registration by below cursor
425: OPEN c_get_tds_org_tan(r_jai_ap_tds_repository.ORG_ID);
426: FETCH c_get_tds_org_tan INTO r_c_get_tds_org_tan;
427: CLOSE c_get_tds_org_tan;
428: r_jai_ap_tds_repository.org_tan_number := r_c_get_tds_org_tan.org_tan_num;
429:
430:
431: --Process application/unapplication concerning info
432: IF pv_event IN (G_PREPAYMENT_APPLICATION, G_PREPAYMENT_UNAPPLICATION) THEN

Line 477: r_jai_ap_tds_repository.APPLIED_FROM_INVOICE_ID := r_c_get_apply_fromto_inv.invoice_id;

473: --derive apply from prepayment invoice info
474: OPEN c_get_apply_fromto_inv(ln_inv_prepy_distribution_id);
475: FETCH c_get_apply_fromto_inv INTO r_c_get_apply_fromto_inv;
476: CLOSE c_get_apply_fromto_inv;
477: r_jai_ap_tds_repository.APPLIED_FROM_INVOICE_ID := r_c_get_apply_fromto_inv.invoice_id;
478: r_jai_ap_tds_repository.APPLIED_FROM_INVOICE_TYPE := r_c_get_apply_fromto_inv.invoice_type;
479: r_jai_ap_tds_repository.APPLIED_FROM_INVOICE_AMT := r_c_get_apply_fromto_inv.invoice_amount;
480: r_jai_ap_tds_repository.APPLIED_FROM_SUPPLIER_ID := r_c_get_apply_fromto_inv.vendor_id;
481: r_jai_ap_tds_repository.APPLIED_FROM_SUPPLIER_SITE_ID := r_c_get_apply_fromto_inv.vendor_site_id;

Line 478: r_jai_ap_tds_repository.APPLIED_FROM_INVOICE_TYPE := r_c_get_apply_fromto_inv.invoice_type;

474: OPEN c_get_apply_fromto_inv(ln_inv_prepy_distribution_id);
475: FETCH c_get_apply_fromto_inv INTO r_c_get_apply_fromto_inv;
476: CLOSE c_get_apply_fromto_inv;
477: r_jai_ap_tds_repository.APPLIED_FROM_INVOICE_ID := r_c_get_apply_fromto_inv.invoice_id;
478: r_jai_ap_tds_repository.APPLIED_FROM_INVOICE_TYPE := r_c_get_apply_fromto_inv.invoice_type;
479: r_jai_ap_tds_repository.APPLIED_FROM_INVOICE_AMT := r_c_get_apply_fromto_inv.invoice_amount;
480: r_jai_ap_tds_repository.APPLIED_FROM_SUPPLIER_ID := r_c_get_apply_fromto_inv.vendor_id;
481: r_jai_ap_tds_repository.APPLIED_FROM_SUPPLIER_SITE_ID := r_c_get_apply_fromto_inv.vendor_site_id;
482: r_jai_ap_tds_repository.APPLIED_FROM_INVOICE_DATE := r_c_get_apply_fromto_inv.invoice_date;

Line 479: r_jai_ap_tds_repository.APPLIED_FROM_INVOICE_AMT := r_c_get_apply_fromto_inv.invoice_amount;

475: FETCH c_get_apply_fromto_inv INTO r_c_get_apply_fromto_inv;
476: CLOSE c_get_apply_fromto_inv;
477: r_jai_ap_tds_repository.APPLIED_FROM_INVOICE_ID := r_c_get_apply_fromto_inv.invoice_id;
478: r_jai_ap_tds_repository.APPLIED_FROM_INVOICE_TYPE := r_c_get_apply_fromto_inv.invoice_type;
479: r_jai_ap_tds_repository.APPLIED_FROM_INVOICE_AMT := r_c_get_apply_fromto_inv.invoice_amount;
480: r_jai_ap_tds_repository.APPLIED_FROM_SUPPLIER_ID := r_c_get_apply_fromto_inv.vendor_id;
481: r_jai_ap_tds_repository.APPLIED_FROM_SUPPLIER_SITE_ID := r_c_get_apply_fromto_inv.vendor_site_id;
482: r_jai_ap_tds_repository.APPLIED_FROM_INVOICE_DATE := r_c_get_apply_fromto_inv.invoice_date;
483: r_jai_ap_tds_repository.APPLIED_FROM_ACCTG_DATE := r_c_get_apply_fromto_inv.gl_date;

Line 480: r_jai_ap_tds_repository.APPLIED_FROM_SUPPLIER_ID := r_c_get_apply_fromto_inv.vendor_id;

476: CLOSE c_get_apply_fromto_inv;
477: r_jai_ap_tds_repository.APPLIED_FROM_INVOICE_ID := r_c_get_apply_fromto_inv.invoice_id;
478: r_jai_ap_tds_repository.APPLIED_FROM_INVOICE_TYPE := r_c_get_apply_fromto_inv.invoice_type;
479: r_jai_ap_tds_repository.APPLIED_FROM_INVOICE_AMT := r_c_get_apply_fromto_inv.invoice_amount;
480: r_jai_ap_tds_repository.APPLIED_FROM_SUPPLIER_ID := r_c_get_apply_fromto_inv.vendor_id;
481: r_jai_ap_tds_repository.APPLIED_FROM_SUPPLIER_SITE_ID := r_c_get_apply_fromto_inv.vendor_site_id;
482: r_jai_ap_tds_repository.APPLIED_FROM_INVOICE_DATE := r_c_get_apply_fromto_inv.invoice_date;
483: r_jai_ap_tds_repository.APPLIED_FROM_ACCTG_DATE := r_c_get_apply_fromto_inv.gl_date;
484: --@TODO currently, no need ot populate this field.

Line 481: r_jai_ap_tds_repository.APPLIED_FROM_SUPPLIER_SITE_ID := r_c_get_apply_fromto_inv.vendor_site_id;

477: r_jai_ap_tds_repository.APPLIED_FROM_INVOICE_ID := r_c_get_apply_fromto_inv.invoice_id;
478: r_jai_ap_tds_repository.APPLIED_FROM_INVOICE_TYPE := r_c_get_apply_fromto_inv.invoice_type;
479: r_jai_ap_tds_repository.APPLIED_FROM_INVOICE_AMT := r_c_get_apply_fromto_inv.invoice_amount;
480: r_jai_ap_tds_repository.APPLIED_FROM_SUPPLIER_ID := r_c_get_apply_fromto_inv.vendor_id;
481: r_jai_ap_tds_repository.APPLIED_FROM_SUPPLIER_SITE_ID := r_c_get_apply_fromto_inv.vendor_site_id;
482: r_jai_ap_tds_repository.APPLIED_FROM_INVOICE_DATE := r_c_get_apply_fromto_inv.invoice_date;
483: r_jai_ap_tds_repository.APPLIED_FROM_ACCTG_DATE := r_c_get_apply_fromto_inv.gl_date;
484: --@TODO currently, no need ot populate this field.
485: --r_jai_ap_tds_repository.FROM_SLAB_ID :=

Line 482: r_jai_ap_tds_repository.APPLIED_FROM_INVOICE_DATE := r_c_get_apply_fromto_inv.invoice_date;

478: r_jai_ap_tds_repository.APPLIED_FROM_INVOICE_TYPE := r_c_get_apply_fromto_inv.invoice_type;
479: r_jai_ap_tds_repository.APPLIED_FROM_INVOICE_AMT := r_c_get_apply_fromto_inv.invoice_amount;
480: r_jai_ap_tds_repository.APPLIED_FROM_SUPPLIER_ID := r_c_get_apply_fromto_inv.vendor_id;
481: r_jai_ap_tds_repository.APPLIED_FROM_SUPPLIER_SITE_ID := r_c_get_apply_fromto_inv.vendor_site_id;
482: r_jai_ap_tds_repository.APPLIED_FROM_INVOICE_DATE := r_c_get_apply_fromto_inv.invoice_date;
483: r_jai_ap_tds_repository.APPLIED_FROM_ACCTG_DATE := r_c_get_apply_fromto_inv.gl_date;
484: --@TODO currently, no need ot populate this field.
485: --r_jai_ap_tds_repository.FROM_SLAB_ID :=
486:

Line 483: r_jai_ap_tds_repository.APPLIED_FROM_ACCTG_DATE := r_c_get_apply_fromto_inv.gl_date;

479: r_jai_ap_tds_repository.APPLIED_FROM_INVOICE_AMT := r_c_get_apply_fromto_inv.invoice_amount;
480: r_jai_ap_tds_repository.APPLIED_FROM_SUPPLIER_ID := r_c_get_apply_fromto_inv.vendor_id;
481: r_jai_ap_tds_repository.APPLIED_FROM_SUPPLIER_SITE_ID := r_c_get_apply_fromto_inv.vendor_site_id;
482: r_jai_ap_tds_repository.APPLIED_FROM_INVOICE_DATE := r_c_get_apply_fromto_inv.invoice_date;
483: r_jai_ap_tds_repository.APPLIED_FROM_ACCTG_DATE := r_c_get_apply_fromto_inv.gl_date;
484: --@TODO currently, no need ot populate this field.
485: --r_jai_ap_tds_repository.FROM_SLAB_ID :=
486:
487: --derive apply to prepayment invoice info

Line 485: --r_jai_ap_tds_repository.FROM_SLAB_ID :=

481: r_jai_ap_tds_repository.APPLIED_FROM_SUPPLIER_SITE_ID := r_c_get_apply_fromto_inv.vendor_site_id;
482: r_jai_ap_tds_repository.APPLIED_FROM_INVOICE_DATE := r_c_get_apply_fromto_inv.invoice_date;
483: r_jai_ap_tds_repository.APPLIED_FROM_ACCTG_DATE := r_c_get_apply_fromto_inv.gl_date;
484: --@TODO currently, no need ot populate this field.
485: --r_jai_ap_tds_repository.FROM_SLAB_ID :=
486:
487: --derive apply to prepayment invoice info
488: OPEN c_get_apply_fromto_inv(ln_inv_distribution_id);
489: FETCH c_get_apply_fromto_inv INTO r_c_get_apply_fromto_inv;

Line 491: r_jai_ap_tds_repository.APPLIED_TO_INVOICE_ID := r_c_get_apply_fromto_inv.invoice_id;

487: --derive apply to prepayment invoice info
488: OPEN c_get_apply_fromto_inv(ln_inv_distribution_id);
489: FETCH c_get_apply_fromto_inv INTO r_c_get_apply_fromto_inv;
490: CLOSE c_get_apply_fromto_inv;
491: r_jai_ap_tds_repository.APPLIED_TO_INVOICE_ID := r_c_get_apply_fromto_inv.invoice_id;
492: r_jai_ap_tds_repository.APPLIED_TO_INVOICE_TYPE := r_c_get_apply_fromto_inv.invoice_type;
493: r_jai_ap_tds_repository.APPLIED_TO_INVOICE_AMT := r_c_get_apply_fromto_inv.invoice_amount;
494: r_jai_ap_tds_repository.APPLIED_TO_SUPPLIER_ID := r_c_get_apply_fromto_inv.vendor_id;
495: r_jai_ap_tds_repository.APPLIED_TO_SUPPLIER_SITE_ID := r_c_get_apply_fromto_inv.vendor_site_id;

Line 492: r_jai_ap_tds_repository.APPLIED_TO_INVOICE_TYPE := r_c_get_apply_fromto_inv.invoice_type;

488: OPEN c_get_apply_fromto_inv(ln_inv_distribution_id);
489: FETCH c_get_apply_fromto_inv INTO r_c_get_apply_fromto_inv;
490: CLOSE c_get_apply_fromto_inv;
491: r_jai_ap_tds_repository.APPLIED_TO_INVOICE_ID := r_c_get_apply_fromto_inv.invoice_id;
492: r_jai_ap_tds_repository.APPLIED_TO_INVOICE_TYPE := r_c_get_apply_fromto_inv.invoice_type;
493: r_jai_ap_tds_repository.APPLIED_TO_INVOICE_AMT := r_c_get_apply_fromto_inv.invoice_amount;
494: r_jai_ap_tds_repository.APPLIED_TO_SUPPLIER_ID := r_c_get_apply_fromto_inv.vendor_id;
495: r_jai_ap_tds_repository.APPLIED_TO_SUPPLIER_SITE_ID := r_c_get_apply_fromto_inv.vendor_site_id;
496: r_jai_ap_tds_repository.APPLIED_TO_INVOICE_DATE := r_c_get_apply_fromto_inv.invoice_date;

Line 493: r_jai_ap_tds_repository.APPLIED_TO_INVOICE_AMT := r_c_get_apply_fromto_inv.invoice_amount;

489: FETCH c_get_apply_fromto_inv INTO r_c_get_apply_fromto_inv;
490: CLOSE c_get_apply_fromto_inv;
491: r_jai_ap_tds_repository.APPLIED_TO_INVOICE_ID := r_c_get_apply_fromto_inv.invoice_id;
492: r_jai_ap_tds_repository.APPLIED_TO_INVOICE_TYPE := r_c_get_apply_fromto_inv.invoice_type;
493: r_jai_ap_tds_repository.APPLIED_TO_INVOICE_AMT := r_c_get_apply_fromto_inv.invoice_amount;
494: r_jai_ap_tds_repository.APPLIED_TO_SUPPLIER_ID := r_c_get_apply_fromto_inv.vendor_id;
495: r_jai_ap_tds_repository.APPLIED_TO_SUPPLIER_SITE_ID := r_c_get_apply_fromto_inv.vendor_site_id;
496: r_jai_ap_tds_repository.APPLIED_TO_INVOICE_DATE := r_c_get_apply_fromto_inv.invoice_date;
497: r_jai_ap_tds_repository.APPLIED_TO_ACCTG_DATE := r_c_get_apply_fromto_inv.gl_date;

Line 494: r_jai_ap_tds_repository.APPLIED_TO_SUPPLIER_ID := r_c_get_apply_fromto_inv.vendor_id;

490: CLOSE c_get_apply_fromto_inv;
491: r_jai_ap_tds_repository.APPLIED_TO_INVOICE_ID := r_c_get_apply_fromto_inv.invoice_id;
492: r_jai_ap_tds_repository.APPLIED_TO_INVOICE_TYPE := r_c_get_apply_fromto_inv.invoice_type;
493: r_jai_ap_tds_repository.APPLIED_TO_INVOICE_AMT := r_c_get_apply_fromto_inv.invoice_amount;
494: r_jai_ap_tds_repository.APPLIED_TO_SUPPLIER_ID := r_c_get_apply_fromto_inv.vendor_id;
495: r_jai_ap_tds_repository.APPLIED_TO_SUPPLIER_SITE_ID := r_c_get_apply_fromto_inv.vendor_site_id;
496: r_jai_ap_tds_repository.APPLIED_TO_INVOICE_DATE := r_c_get_apply_fromto_inv.invoice_date;
497: r_jai_ap_tds_repository.APPLIED_TO_ACCTG_DATE := r_c_get_apply_fromto_inv.gl_date;
498: --@TODO currently, no need ot populate this field.

Line 495: r_jai_ap_tds_repository.APPLIED_TO_SUPPLIER_SITE_ID := r_c_get_apply_fromto_inv.vendor_site_id;

491: r_jai_ap_tds_repository.APPLIED_TO_INVOICE_ID := r_c_get_apply_fromto_inv.invoice_id;
492: r_jai_ap_tds_repository.APPLIED_TO_INVOICE_TYPE := r_c_get_apply_fromto_inv.invoice_type;
493: r_jai_ap_tds_repository.APPLIED_TO_INVOICE_AMT := r_c_get_apply_fromto_inv.invoice_amount;
494: r_jai_ap_tds_repository.APPLIED_TO_SUPPLIER_ID := r_c_get_apply_fromto_inv.vendor_id;
495: r_jai_ap_tds_repository.APPLIED_TO_SUPPLIER_SITE_ID := r_c_get_apply_fromto_inv.vendor_site_id;
496: r_jai_ap_tds_repository.APPLIED_TO_INVOICE_DATE := r_c_get_apply_fromto_inv.invoice_date;
497: r_jai_ap_tds_repository.APPLIED_TO_ACCTG_DATE := r_c_get_apply_fromto_inv.gl_date;
498: --@TODO currently, no need ot populate this field.
499: --r_jai_ap_tds_repository.TO_SLAB_ID :=

Line 496: r_jai_ap_tds_repository.APPLIED_TO_INVOICE_DATE := r_c_get_apply_fromto_inv.invoice_date;

492: r_jai_ap_tds_repository.APPLIED_TO_INVOICE_TYPE := r_c_get_apply_fromto_inv.invoice_type;
493: r_jai_ap_tds_repository.APPLIED_TO_INVOICE_AMT := r_c_get_apply_fromto_inv.invoice_amount;
494: r_jai_ap_tds_repository.APPLIED_TO_SUPPLIER_ID := r_c_get_apply_fromto_inv.vendor_id;
495: r_jai_ap_tds_repository.APPLIED_TO_SUPPLIER_SITE_ID := r_c_get_apply_fromto_inv.vendor_site_id;
496: r_jai_ap_tds_repository.APPLIED_TO_INVOICE_DATE := r_c_get_apply_fromto_inv.invoice_date;
497: r_jai_ap_tds_repository.APPLIED_TO_ACCTG_DATE := r_c_get_apply_fromto_inv.gl_date;
498: --@TODO currently, no need ot populate this field.
499: --r_jai_ap_tds_repository.TO_SLAB_ID :=
500: IF pv_event = G_PREPAYMENT_APPLICATION THEN

Line 497: r_jai_ap_tds_repository.APPLIED_TO_ACCTG_DATE := r_c_get_apply_fromto_inv.gl_date;

493: r_jai_ap_tds_repository.APPLIED_TO_INVOICE_AMT := r_c_get_apply_fromto_inv.invoice_amount;
494: r_jai_ap_tds_repository.APPLIED_TO_SUPPLIER_ID := r_c_get_apply_fromto_inv.vendor_id;
495: r_jai_ap_tds_repository.APPLIED_TO_SUPPLIER_SITE_ID := r_c_get_apply_fromto_inv.vendor_site_id;
496: r_jai_ap_tds_repository.APPLIED_TO_INVOICE_DATE := r_c_get_apply_fromto_inv.invoice_date;
497: r_jai_ap_tds_repository.APPLIED_TO_ACCTG_DATE := r_c_get_apply_fromto_inv.gl_date;
498: --@TODO currently, no need ot populate this field.
499: --r_jai_ap_tds_repository.TO_SLAB_ID :=
500: IF pv_event = G_PREPAYMENT_APPLICATION THEN
501: r_jai_ap_tds_repository.APPLIED_AMOUNT := r_c_get_apply_fromto_inv.apply_amount;

Line 499: --r_jai_ap_tds_repository.TO_SLAB_ID :=

495: r_jai_ap_tds_repository.APPLIED_TO_SUPPLIER_SITE_ID := r_c_get_apply_fromto_inv.vendor_site_id;
496: r_jai_ap_tds_repository.APPLIED_TO_INVOICE_DATE := r_c_get_apply_fromto_inv.invoice_date;
497: r_jai_ap_tds_repository.APPLIED_TO_ACCTG_DATE := r_c_get_apply_fromto_inv.gl_date;
498: --@TODO currently, no need ot populate this field.
499: --r_jai_ap_tds_repository.TO_SLAB_ID :=
500: IF pv_event = G_PREPAYMENT_APPLICATION THEN
501: r_jai_ap_tds_repository.APPLIED_AMOUNT := r_c_get_apply_fromto_inv.apply_amount;
502: ELSIF pv_event = G_PREPAYMENT_UNAPPLICATION THEN
503: r_jai_ap_tds_repository.UNAPPLIED_AMOUNT := r_c_get_apply_fromto_inv.apply_amount;

Line 501: r_jai_ap_tds_repository.APPLIED_AMOUNT := r_c_get_apply_fromto_inv.apply_amount;

497: r_jai_ap_tds_repository.APPLIED_TO_ACCTG_DATE := r_c_get_apply_fromto_inv.gl_date;
498: --@TODO currently, no need ot populate this field.
499: --r_jai_ap_tds_repository.TO_SLAB_ID :=
500: IF pv_event = G_PREPAYMENT_APPLICATION THEN
501: r_jai_ap_tds_repository.APPLIED_AMOUNT := r_c_get_apply_fromto_inv.apply_amount;
502: ELSIF pv_event = G_PREPAYMENT_UNAPPLICATION THEN
503: r_jai_ap_tds_repository.UNAPPLIED_AMOUNT := r_c_get_apply_fromto_inv.apply_amount;
504: END IF;
505: END IF;

Line 503: r_jai_ap_tds_repository.UNAPPLIED_AMOUNT := r_c_get_apply_fromto_inv.apply_amount;

499: --r_jai_ap_tds_repository.TO_SLAB_ID :=
500: IF pv_event = G_PREPAYMENT_APPLICATION THEN
501: r_jai_ap_tds_repository.APPLIED_AMOUNT := r_c_get_apply_fromto_inv.apply_amount;
502: ELSIF pv_event = G_PREPAYMENT_UNAPPLICATION THEN
503: r_jai_ap_tds_repository.UNAPPLIED_AMOUNT := r_c_get_apply_fromto_inv.apply_amount;
504: END IF;
505: END IF;
506:
507: r_jai_ap_tds_repository.MIGRATED := G_N;

Line 507: r_jai_ap_tds_repository.MIGRATED := G_N;

503: r_jai_ap_tds_repository.UNAPPLIED_AMOUNT := r_c_get_apply_fromto_inv.apply_amount;
504: END IF;
505: END IF;
506:
507: r_jai_ap_tds_repository.MIGRATED := G_N;
508: r_jai_ap_tds_repository.CREATION_DATE := sysdate;
509: r_jai_ap_tds_repository.CREATED_BY := fnd_global.user_id;
510: r_jai_ap_tds_repository.LAST_UPDATE_DATE := sysdate;
511: r_jai_ap_tds_repository.LAST_UPDATE_LOGIN := fnd_global.login_id;

Line 508: r_jai_ap_tds_repository.CREATION_DATE := sysdate;

504: END IF;
505: END IF;
506:
507: r_jai_ap_tds_repository.MIGRATED := G_N;
508: r_jai_ap_tds_repository.CREATION_DATE := sysdate;
509: r_jai_ap_tds_repository.CREATED_BY := fnd_global.user_id;
510: r_jai_ap_tds_repository.LAST_UPDATE_DATE := sysdate;
511: r_jai_ap_tds_repository.LAST_UPDATE_LOGIN := fnd_global.login_id;
512: r_jai_ap_tds_repository.LAST_UPDATED_BY := fnd_global.user_id;

Line 509: r_jai_ap_tds_repository.CREATED_BY := fnd_global.user_id;

505: END IF;
506:
507: r_jai_ap_tds_repository.MIGRATED := G_N;
508: r_jai_ap_tds_repository.CREATION_DATE := sysdate;
509: r_jai_ap_tds_repository.CREATED_BY := fnd_global.user_id;
510: r_jai_ap_tds_repository.LAST_UPDATE_DATE := sysdate;
511: r_jai_ap_tds_repository.LAST_UPDATE_LOGIN := fnd_global.login_id;
512: r_jai_ap_tds_repository.LAST_UPDATED_BY := fnd_global.user_id;
513:

Line 510: r_jai_ap_tds_repository.LAST_UPDATE_DATE := sysdate;

506:
507: r_jai_ap_tds_repository.MIGRATED := G_N;
508: r_jai_ap_tds_repository.CREATION_DATE := sysdate;
509: r_jai_ap_tds_repository.CREATED_BY := fnd_global.user_id;
510: r_jai_ap_tds_repository.LAST_UPDATE_DATE := sysdate;
511: r_jai_ap_tds_repository.LAST_UPDATE_LOGIN := fnd_global.login_id;
512: r_jai_ap_tds_repository.LAST_UPDATED_BY := fnd_global.user_id;
513:
514: --get repsitory id from sequence

Line 511: r_jai_ap_tds_repository.LAST_UPDATE_LOGIN := fnd_global.login_id;

507: r_jai_ap_tds_repository.MIGRATED := G_N;
508: r_jai_ap_tds_repository.CREATION_DATE := sysdate;
509: r_jai_ap_tds_repository.CREATED_BY := fnd_global.user_id;
510: r_jai_ap_tds_repository.LAST_UPDATE_DATE := sysdate;
511: r_jai_ap_tds_repository.LAST_UPDATE_LOGIN := fnd_global.login_id;
512: r_jai_ap_tds_repository.LAST_UPDATED_BY := fnd_global.user_id;
513:
514: --get repsitory id from sequence
515: OPEN c_get_tds_repository_id;

Line 512: r_jai_ap_tds_repository.LAST_UPDATED_BY := fnd_global.user_id;

508: r_jai_ap_tds_repository.CREATION_DATE := sysdate;
509: r_jai_ap_tds_repository.CREATED_BY := fnd_global.user_id;
510: r_jai_ap_tds_repository.LAST_UPDATE_DATE := sysdate;
511: r_jai_ap_tds_repository.LAST_UPDATE_LOGIN := fnd_global.login_id;
512: r_jai_ap_tds_repository.LAST_UPDATED_BY := fnd_global.user_id;
513:
514: --get repsitory id from sequence
515: OPEN c_get_tds_repository_id;
516: FETCH c_get_tds_repository_id INTO r_jai_ap_tds_repository.TDS_REPOSITORY_ID;

Line 516: FETCH c_get_tds_repository_id INTO r_jai_ap_tds_repository.TDS_REPOSITORY_ID;

512: r_jai_ap_tds_repository.LAST_UPDATED_BY := fnd_global.user_id;
513:
514: --get repsitory id from sequence
515: OPEN c_get_tds_repository_id;
516: FETCH c_get_tds_repository_id INTO r_jai_ap_tds_repository.TDS_REPOSITORY_ID;
517: CLOSE c_get_tds_repository_id;
518:
519: --Call procedure to insert one line into repository table.
520: insert_jai_tds_repository(r_jai_ap_tds_repository);

Line 520: insert_jai_tds_repository(r_jai_ap_tds_repository);

516: FETCH c_get_tds_repository_id INTO r_jai_ap_tds_repository.TDS_REPOSITORY_ID;
517: CLOSE c_get_tds_repository_id;
518:
519: --Call procedure to insert one line into repository table.
520: insert_jai_tds_repository(r_jai_ap_tds_repository);
521:
522: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.END', G_PKG_NAME || ': '||l_api_name||'()-');
523: EXCEPTION
524: WHEN OTHERS THEN

Line 533: --Procedure to insert one line into jai_ap_tds_repository table.

529: END populate_repository;
530:
531:
532: /*---------------------------------------------------------------------
533: --Procedure to insert one line into jai_ap_tds_repository table.
534: -----------------------------------------------------------------------*/
535: PROCEDURE process_cancellation(pn_source_invoice_id IN NUMBER)
536: IS
537: l_api_name CONSTANT VARCHAR2(50) := 'process_cancellation()';

Line 542: Update jai_ap_tds_repository jatr

538: BEGIN
539: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_api_name ||'.BEGIN', G_PKG_NAME || ': '|| l_api_name || '()+');
540:
541: If pn_source_invoice_id is not null then
542: Update jai_ap_tds_repository jatr
543: Set jatr.source_invoice_deleted = G_Y
544: ,jatr.invoice_deleted = G_Y
545: Where source_invoice_id = pn_source_invoice_id;
546: End if;

Line 594: From jai_ap_tds_repository jatr

590: ,jatr.threshold_grp_id
591: ,jatr.tax_category_id
592: ,jatr.tds_inv_tax_amount
593: ,jatr.base_tax_amount
594: From jai_ap_tds_repository jatr
595: Where jatr.threshold_grp_id = p_threshold_grp_id
596: And NVL(jatr.migrated,G_N) = G_N
597: And NVL(jatr.invoice_deleted, G_N) = G_N
598: And NVL(jatr.source_invoice_deleted, G_N) = G_N

Line 633: FROM jai_ap_tds_repository jatr

629: WHERE jatrl.tax_type= G_TDS_SURCHARGE
630: AND NVL(jatrl.surcharge_rollback, G_N) =G_N
631: AND EXISTS(
632: SELECT 1
633: FROM jai_ap_tds_repository jatr
634: WHERE jatr.invoice_id = jatrl.invoice_id --TDS invoice ID
635: AND jatr.threshold_grp_id = pn_threshold_grp_id
636: )
637: ;

Line 702: UPDATE jai_ap_tds_repository jatr

698: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_api_name ||'.Parameters', pn_challan_no || ': '|| pn_challan_no);
699:
700: IF pn_invoice_id IS NOT NULL THEN
701: --update challan information, and TDS_PAID,REQUIRED_FOR_ETDS as 'Y'
702: UPDATE jai_ap_tds_repository jatr
703: SET jatr.tds_paid = G_Y
704: ,jatr.required_for_etds = G_Y
705: ,jatr.challan_number = pn_challan_no
706: ,jatr.check_date = pd_check_date

Line 745: FROM jai_ap_tds_repository jatr

741:
742: -- group_id in existing system (by jai_ap_tds_thhold_grps table)
743: CURSOR c_transition_count(pn_threshold_grp_id NUMBER) IS
744: SELECT COUNT(jatr.invoice_id) cnt_exists
745: FROM jai_ap_tds_repository jatr
746: WHERE jatr.threshold_grp_id = pn_threshold_grp_id
747: AND jatr.event like 'THRESHOLD TRANSITION%'
748: ;
749:

Line 848: FROM jai_ap_tds_repository

844: --, tds_check_id
845: , tax_id
846: , TDS_INV_TAX_AMOUNT
847: , base_tax_amount
848: FROM jai_ap_tds_repository
849: WHERE invoice_id = (SELECT MAX(invoice_to_tds_authority_id)
850: FROM jai_ap_tds_thhold_trxs
851: WHERE threshold_grp_id = p_threshold_grp_id
852: AND tds_event LIKE 'THRESHOLD TRANSITION%'

Line 922: INSERT INTO jai_ap_tds_repository (

918: )
919: LOOP
920:
921: --Step 1. Pick all TDS invoices base on jai_ap_tds_thhold_trxs table.
922: INSERT INTO jai_ap_tds_repository (
923: TDS_REPOSITORY_ID
924: ,INVOICE_ID
925: ,INVOICE_NUMBER
926: ,TDS_INVOICE_TYPE

Line 986: JAI_AP_TDS_REPOSITORY_S.NEXTVAL

982: ,LAST_UPDATE_DATE
983: ,LAST_UPDATE_LOGIN
984: ,LAST_UPDATED_BY
985: ) SELECT
986: JAI_AP_TDS_REPOSITORY_S.NEXTVAL
987: ,jattt.invoice_to_tds_authority_id
988: ,tds_invoices.invoice_num
989: --,jattt.tds_event --get_tds_invoice_type(jattt.tds_event)
990: ,decode(jattt.tds_event, G_INVOICE_VALIDATE, 'NORMAL'

Line 1073: from jai_ap_tds_repository jatr

1069: and jror.regime_code = G_TDS
1070: and jror.registration_type = 'OTHERS'
1071: and jror.attribute_code = 'TAN NO'
1072: and not exists (select '1'
1073: from jai_ap_tds_repository jatr
1074: where jatr.invoice_id = jattt.invoice_to_tds_authority_id
1075: )
1076: ;
1077:

Line 1112: UPDATE jai_ap_tds_repository

1108: OPEN c_get_apply_fromto_inv(r_tds_pp_rec.invoice_distribution_id);
1109: FETCH c_get_apply_fromto_inv INTO r_get_apply_to_inv;
1110: CLOSE c_get_apply_fromto_inv;
1111:
1112: UPDATE jai_ap_tds_repository
1113: SET APPLIED_FROM_INVOICE_ID = r_get_apply_from_inv.invoice_id
1114: ,APPLIED_FROM_INVOICE_TYPE = r_get_apply_from_inv.invoice_type
1115: ,APPLIED_FROM_INVOICE_AMT = r_get_apply_from_inv.invoice_amount
1116: ,APPLIED_FROM_SUPPLIER_ID = r_get_apply_from_inv.vendor_id

Line 1150: UPDATE jai_ap_tds_repository

1146: OPEN c_get_apply_fromto_inv(r_tds_pp_rec.invoice_distribution_id);
1147: FETCH c_get_apply_fromto_inv INTO r_get_apply_to_inv;
1148: CLOSE c_get_apply_fromto_inv;
1149:
1150: UPDATE jai_ap_tds_repository
1151: SET APPLIED_FROM_INVOICE_ID = r_get_apply_from_inv.invoice_id
1152: ,APPLIED_FROM_INVOICE_TYPE = r_get_apply_from_inv.invoice_type
1153: ,APPLIED_FROM_INVOICE_AMT = r_get_apply_from_inv.invoice_amount
1154: ,APPLIED_FROM_SUPPLIER_ID = r_get_apply_from_inv.vendor_id

Line 1188: UPDATE jai_ap_tds_repository

1184: OPEN c_get_apply_fromto_inv(r_tds_pp_rec.invoice_distribution_id);
1185: FETCH c_get_apply_fromto_inv INTO r_get_apply_to_inv;
1186: CLOSE c_get_apply_fromto_inv;
1187:
1188: UPDATE jai_ap_tds_repository
1189: SET APPLIED_FROM_INVOICE_ID = r_get_apply_from_inv.invoice_id
1190: ,APPLIED_FROM_INVOICE_TYPE = r_get_apply_from_inv.invoice_type
1191: ,APPLIED_FROM_INVOICE_AMT = r_get_apply_from_inv.invoice_amount
1192: ,APPLIED_FROM_SUPPLIER_ID = r_get_apply_from_inv.vendor_id

Line 1227: UPDATE jai_ap_tds_repository

1223: OPEN c_get_apply_fromto_inv(r_tds_pp_rec.invoice_distribution_id);
1224: FETCH c_get_apply_fromto_inv INTO r_get_apply_to_inv;
1225: CLOSE c_get_apply_fromto_inv;
1226:
1227: UPDATE jai_ap_tds_repository
1228: SET APPLIED_FROM_INVOICE_ID = r_get_apply_from_inv.invoice_id
1229: ,APPLIED_FROM_INVOICE_TYPE = r_get_apply_from_inv.invoice_type
1230: ,APPLIED_FROM_INVOICE_AMT = r_get_apply_from_inv.invoice_amount
1231: ,APPLIED_FROM_SUPPLIER_ID = r_get_apply_from_inv.vendor_id

Line 1265: UPDATE jai_ap_tds_repository

1261: OPEN c_get_apply_fromto_inv(r_tds_pp_rec.invoice_distribution_id);
1262: FETCH c_get_apply_fromto_inv INTO r_get_apply_to_inv;
1263: CLOSE c_get_apply_fromto_inv;
1264:
1265: UPDATE jai_ap_tds_repository
1266: SET APPLIED_FROM_INVOICE_ID = r_get_apply_from_inv.invoice_id
1267: ,APPLIED_FROM_INVOICE_TYPE = r_get_apply_from_inv.invoice_type
1268: ,APPLIED_FROM_INVOICE_AMT = r_get_apply_from_inv.invoice_amount
1269: ,APPLIED_FROM_SUPPLIER_ID = r_get_apply_from_inv.vendor_id

Line 1303: UPDATE jai_ap_tds_repository

1299: OPEN c_get_apply_fromto_inv(r_tds_pp_rec.invoice_distribution_id);
1300: FETCH c_get_apply_fromto_inv INTO r_get_apply_to_inv;
1301: CLOSE c_get_apply_fromto_inv;
1302:
1303: UPDATE jai_ap_tds_repository
1304: SET APPLIED_FROM_INVOICE_ID = r_get_apply_from_inv.invoice_id
1305: ,APPLIED_FROM_INVOICE_TYPE = r_get_apply_from_inv.invoice_type
1306: ,APPLIED_FROM_INVOICE_AMT = r_get_apply_from_inv.invoice_amount
1307: ,APPLIED_FROM_SUPPLIER_ID = r_get_apply_from_inv.vendor_id

Line 1337: INSERT INTO jai_ap_tds_repository (

1333: CLOSE c_chk_threshold_rollback;
1334:
1335: IF r_chk_threshold_rollback.invoice_to_tds_authority_id IS NULL THEN
1336:
1337: INSERT INTO jai_ap_tds_repository (
1338: TDS_REPOSITORY_ID
1339: ,INVOICE_ID
1340: ,INVOICE_NUMBER
1341: ,TDS_AUTHORITY_ID

Line 1388: JAI_AP_TDS_REPOSITORY_S.NEXTVAL,

1384: ,LAST_UPDATE_LOGIN
1385: ,LAST_UPDATED_BY
1386: )
1387: SELECT
1388: JAI_AP_TDS_REPOSITORY_S.NEXTVAL,
1389: -9999,
1390: NULL,
1391: NULL,
1392: NULL,

Line 1461: FROM jai_ap_tds_repository

1457: AND jror.regime_code = G_TDS
1458: AND jror.registration_type = 'OTHERS'
1459: AND jror.attribute_code = 'TAN NO'
1460: AND NOT EXISTS (SELECT 1
1461: FROM jai_ap_tds_repository
1462: WHERE source_invoice_id = jatit.invoice_id
1463: AND event = G_THRESHOLD_TRANSITION
1464: )
1465: ;

Line 1469: INSERT INTO jai_ap_tds_repository (

1465: ;
1466:
1467:
1468: /*Need to pick Invoices created before Threshold was breached and Prepayment applied*/
1469: INSERT INTO jai_ap_tds_repository (
1470: TDS_REPOSITORY_ID
1471: ,INVOICE_ID
1472: ,INVOICE_NUMBER
1473: ,TDS_AUTHORITY_ID

Line 1520: JAI_AP_TDS_REPOSITORY_S.NEXTVAL,

1516: ,LAST_UPDATE_LOGIN
1517: ,LAST_UPDATED_BY
1518: )
1519: select
1520: JAI_AP_TDS_REPOSITORY_S.NEXTVAL,
1521: -9998,
1522: NULL,
1523: NULL,
1524: NULL,

Line 1593: FROM jai_ap_tds_repository

1589: AND jror.regime_code = G_TDS
1590: AND jror.registration_type = 'OTHERS'
1591: AND jror.attribute_code = 'TAN NO'
1592: AND NOT EXISTS (SELECT 1
1593: FROM jai_ap_tds_repository
1594: WHERE source_invoice_id = jatit.invoice_id
1595: AND event = G_THRESHOLD_TRANSITION
1596: )
1597: ;

Line 1632: UPDATE jai_ap_tds_repository

1628: ln_cess_amount := round((r_threshold_tran_inv.tds_inv_tax_amount * r_tax_rates.cess_rate/r_tax_rates.tax_rate),2) + ln_sh_cess_amount;
1629: ln_tds_amount := r_threshold_tran_inv.tds_inv_tax_amount - NVL(ln_surcharge_amount,0) - NVL(ln_cess_amount,0) ;
1630: */
1631: /*Prorate TDS Amount of Threshold Transition invoice among the Invoices prior to Threshold*/
1632: UPDATE jai_ap_tds_repository
1633: SET --tds_check_id = r_threshold_tran_inv.tds_check_id,
1634: challan_number = r_tds_payment_check_id.challan_num,
1635: CHECK_DEPOSIT_DATE = r_tds_payment_check_id.challan_date,
1636: BSR_CODE = r_tds_payment_check_id.branch_code,

Line 1648: DELETE jai_ap_tds_repository

1644: WHERE invoice_id IN (-9998, -9999)
1645: AND threshold_grp_id = r_thhold_grp_rec.threshold_grp_id
1646: ;
1647: --Remove consolidated threshold transition records
1648: DELETE jai_ap_tds_repository
1649: WHERE migrated = 'Y'
1650: AND event LIKE 'THRESHOLD TRANSITION%'
1651: AND threshold_grp_id = r_thhold_grp_rec.threshold_grp_id
1652: ;

Line 1661: UPDATE jai_ap_tds_repository jatr

1657: END LOOP; --r_thhold_grp_rec
1658:
1659: ----Update payment and challan information
1660: -- if TDS invoice was paid, derive payment info from JAI_AP_TDS_INV_PAYMENTS table.
1661: UPDATE jai_ap_tds_repository jatr
1662: SET(jatr.tds_paid
1663: ,jatr.required_for_etds
1664: ,jatr.challan_number
1665: ,jatr.check_date

Line 1698: INSERT INTO jai_ap_tds_repository(

1694: FROM JAI_AP_TDS_VENDOR_HDRS jatvh
1695: )
1696: LOOP
1697: -- Step a. Insert 0% transactions under JAI_TDS_SECTION_ZERO_RATE_197,JAI_TDS_SECTION_ZERO_RATE_197A
1698: INSERT INTO jai_ap_tds_repository(
1699: TDS_REPOSITORY_ID
1700: ,INVOICE_ID
1701: ,INVOICE_NUMBER
1702: ,TDS_INVOICE_TYPE

Line 1733: SELECT JAI_AP_TDS_REPOSITORY_S.NEXTVAL

1729: ,LAST_UPDATE_DATE
1730: ,LAST_UPDATE_LOGIN
1731: ,LAST_UPDATED_BY
1732: )
1733: SELECT JAI_AP_TDS_REPOSITORY_S.NEXTVAL
1734: ,tbl.INVOICE_ID
1735: ,tbl.INVOICE_NUMBER
1736: ,tbl.TDS_INVOICE_TYPE
1737: ,tbl.THRESHOLD_GRP_ID

Line 1819: FROM jai_ap_tds_repository

1815: and upper(jitc.section_code) in (select lookup_code
1816: from fnd_lookup_values_vl
1817: where lookup_type in ('JAI_TDS_SECTION_ZERO_RATE_197', 'JAI_TDS_SECTION_ZERO_RATE_197A'))
1818: AND NOT EXISTS (SELECT 1
1819: FROM jai_ap_tds_repository
1820: WHERE source_invoice_id = jatit.invoice_id
1821: AND invoice_id = -9999
1822: )
1823: group by jatit.invoice_id

Line 1832: INSERT INTO jai_ap_tds_repository (

1828:
1829: --Step b. Insert 0% transactions Vendor Classification being Transporter or Software
1830: --Insert souce invoice information into repository, leave TDS invoice info as NULL
1831: --Populate tax_id and tax_rate, tax info will be update later
1832: INSERT INTO jai_ap_tds_repository (
1833: TDS_REPOSITORY_ID
1834: ,INVOICE_ID
1835: ,INVOICE_NUMBER
1836: ,TDS_INVOICE_TYPE

Line 1867: select JAI_AP_TDS_REPOSITORY_S.NEXTVAL

1863: ,LAST_UPDATE_DATE
1864: ,LAST_UPDATE_LOGIN
1865: ,LAST_UPDATED_BY
1866: )
1867: select JAI_AP_TDS_REPOSITORY_S.NEXTVAL
1868: ,INVOICE_ID
1869: ,INVOICE_NUMBER
1870: ,TDS_INVOICE_TYPE
1871: ,THRESHOLD_GRP_ID

Line 1949: from jai_ap_tds_repository jatr

1945: and aida.match_status_flag in ('A','T') /*10408793 - Unvalidated Invoices must not be picked*/
1946: and base_invoices.invoice_type_lookup_code IN ('STANDARD','PREPAYMENT')
1947: and not exists (select '1' from jai_ap_tds_thhold_trxs jattt where jattt.invoice_id = base_invoices.invoice_id) /*Bug 10408793 - TDS should not be deducted*/
1948: and not exists (select '1'
1949: from jai_ap_tds_repository jatr
1950: where jatr.source_invoice_id = base_invoices.invoice_id
1951: and jatr.migrated= G_Y)
1952: and jte.vendor_id = r_tds_vendor_rec.vendor_id
1953: AND base_invoices.org_id = jror.organization_id

Line 2008: from jai_ap_tds_repository jatr

2004: AND jror.attribute_code = 'TAN NO'
2005: and base_invoices.invoice_type_lookup_code IN ('STANDARD','PREPAYMENT')
2006: and not exists (select '1' from jai_ap_tds_thhold_trxs jattt where jattt.invoice_id = base_invoices.invoice_id)
2007: and not exists (select '1'
2008: from jai_ap_tds_repository jatr
2009: where jatr.source_invoice_id = base_invoices.invoice_id
2010: and jatr.migrated= G_Y)
2011: and jte.vendor_id = r_tds_vendor_rec.vendor_id
2012: ) tbl

Line 2024: FROM jai_ap_tds_repository jatr

2020: ,jatr.invoice_id
2021: ,jatr.tax_id
2022: ,jatr.tax_rate
2023: ,jatr.tds_inv_tax_amount
2024: FROM jai_ap_tds_repository jatr
2025: WHERE jatr.tax_id IS NOT NULL
2026: AND NVL(jatr.tax_rate,0) <> 0
2027: AND jatr.migrated = G_Y
2028: )

Line 2033: Update jai_ap_tds_repository jatr

2029: LOOP
2030:
2031: ln_tax_category_id := map_tds_tax_to_ctg(p_tax_id => r_tds_rpsty_rec.tax_id);
2032:
2033: Update jai_ap_tds_repository jatr
2034: SET jatr.tax_category_id = ln_tax_category_id
2035: WHERE jatr.tds_repository_id = r_tds_rpsty_rec.tds_repository_id;
2036:
2037:

Line 2085: --Procedure to insert one line into jai_ap_tds_repository table.

2081:
2082:
2083:
2084: /*---------------------------------------------------------------------
2085: --Procedure to insert one line into jai_ap_tds_repository table.
2086: ---------------------------------------------------------------------*/
2087: PROCEDURE insert_jai_tds_repository(pr_jai_ap_tds_repository IN jai_ap_tds_repository%rowtype)
2088: IS
2089:

Line 2087: PROCEDURE insert_jai_tds_repository(pr_jai_ap_tds_repository IN jai_ap_tds_repository%rowtype)

2083:
2084: /*---------------------------------------------------------------------
2085: --Procedure to insert one line into jai_ap_tds_repository table.
2086: ---------------------------------------------------------------------*/
2087: PROCEDURE insert_jai_tds_repository(pr_jai_ap_tds_repository IN jai_ap_tds_repository%rowtype)
2088: IS
2089:
2090:
2091: CURSOR c_get_invoice_line_info(p_invoice_id NUMBER) IS

Line 2120: INSERT INTO jai_ap_tds_repository

2116: BEGIN
2117: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
2118:
2119:
2120: INSERT INTO jai_ap_tds_repository
2121: (TDS_REPOSITORY_ID
2122: ,INVOICE_ID
2123: ,INVOICE_NUMBER
2124: ,TDS_AUTHORITY_ID

Line 2189: (pr_jai_ap_tds_repository.TDS_REPOSITORY_ID

2185: ,LAST_UPDATE_LOGIN
2186: ,LAST_UPDATED_BY
2187: )
2188: VALUES
2189: (pr_jai_ap_tds_repository.TDS_REPOSITORY_ID
2190: ,pr_jai_ap_tds_repository.INVOICE_ID
2191: ,pr_jai_ap_tds_repository.INVOICE_NUMBER
2192: ,pr_jai_ap_tds_repository.TDS_AUTHORITY_ID
2193: ,pr_jai_ap_tds_repository.TDS_AUTHORITY_SITE_ID

Line 2190: ,pr_jai_ap_tds_repository.INVOICE_ID

2186: ,LAST_UPDATED_BY
2187: )
2188: VALUES
2189: (pr_jai_ap_tds_repository.TDS_REPOSITORY_ID
2190: ,pr_jai_ap_tds_repository.INVOICE_ID
2191: ,pr_jai_ap_tds_repository.INVOICE_NUMBER
2192: ,pr_jai_ap_tds_repository.TDS_AUTHORITY_ID
2193: ,pr_jai_ap_tds_repository.TDS_AUTHORITY_SITE_ID
2194: ,pr_jai_ap_tds_repository.TDS_INVOICE_TYPE

Line 2191: ,pr_jai_ap_tds_repository.INVOICE_NUMBER

2187: )
2188: VALUES
2189: (pr_jai_ap_tds_repository.TDS_REPOSITORY_ID
2190: ,pr_jai_ap_tds_repository.INVOICE_ID
2191: ,pr_jai_ap_tds_repository.INVOICE_NUMBER
2192: ,pr_jai_ap_tds_repository.TDS_AUTHORITY_ID
2193: ,pr_jai_ap_tds_repository.TDS_AUTHORITY_SITE_ID
2194: ,pr_jai_ap_tds_repository.TDS_INVOICE_TYPE
2195: ,pr_jai_ap_tds_repository.THRESHOLD_GRP_ID

Line 2192: ,pr_jai_ap_tds_repository.TDS_AUTHORITY_ID

2188: VALUES
2189: (pr_jai_ap_tds_repository.TDS_REPOSITORY_ID
2190: ,pr_jai_ap_tds_repository.INVOICE_ID
2191: ,pr_jai_ap_tds_repository.INVOICE_NUMBER
2192: ,pr_jai_ap_tds_repository.TDS_AUTHORITY_ID
2193: ,pr_jai_ap_tds_repository.TDS_AUTHORITY_SITE_ID
2194: ,pr_jai_ap_tds_repository.TDS_INVOICE_TYPE
2195: ,pr_jai_ap_tds_repository.THRESHOLD_GRP_ID
2196: ,pr_jai_ap_tds_repository.THRESHOLD_HDR_ID

Line 2193: ,pr_jai_ap_tds_repository.TDS_AUTHORITY_SITE_ID

2189: (pr_jai_ap_tds_repository.TDS_REPOSITORY_ID
2190: ,pr_jai_ap_tds_repository.INVOICE_ID
2191: ,pr_jai_ap_tds_repository.INVOICE_NUMBER
2192: ,pr_jai_ap_tds_repository.TDS_AUTHORITY_ID
2193: ,pr_jai_ap_tds_repository.TDS_AUTHORITY_SITE_ID
2194: ,pr_jai_ap_tds_repository.TDS_INVOICE_TYPE
2195: ,pr_jai_ap_tds_repository.THRESHOLD_GRP_ID
2196: ,pr_jai_ap_tds_repository.THRESHOLD_HDR_ID
2197: ,pr_jai_ap_tds_repository.THRESHOLD_TYPE_ID

Line 2194: ,pr_jai_ap_tds_repository.TDS_INVOICE_TYPE

2190: ,pr_jai_ap_tds_repository.INVOICE_ID
2191: ,pr_jai_ap_tds_repository.INVOICE_NUMBER
2192: ,pr_jai_ap_tds_repository.TDS_AUTHORITY_ID
2193: ,pr_jai_ap_tds_repository.TDS_AUTHORITY_SITE_ID
2194: ,pr_jai_ap_tds_repository.TDS_INVOICE_TYPE
2195: ,pr_jai_ap_tds_repository.THRESHOLD_GRP_ID
2196: ,pr_jai_ap_tds_repository.THRESHOLD_HDR_ID
2197: ,pr_jai_ap_tds_repository.THRESHOLD_TYPE_ID
2198: ,pr_jai_ap_tds_repository.THRESHOLD_SLAB_ID

Line 2195: ,pr_jai_ap_tds_repository.THRESHOLD_GRP_ID

2191: ,pr_jai_ap_tds_repository.INVOICE_NUMBER
2192: ,pr_jai_ap_tds_repository.TDS_AUTHORITY_ID
2193: ,pr_jai_ap_tds_repository.TDS_AUTHORITY_SITE_ID
2194: ,pr_jai_ap_tds_repository.TDS_INVOICE_TYPE
2195: ,pr_jai_ap_tds_repository.THRESHOLD_GRP_ID
2196: ,pr_jai_ap_tds_repository.THRESHOLD_HDR_ID
2197: ,pr_jai_ap_tds_repository.THRESHOLD_TYPE_ID
2198: ,pr_jai_ap_tds_repository.THRESHOLD_SLAB_ID
2199: ,pr_jai_ap_tds_repository.EVENT

Line 2196: ,pr_jai_ap_tds_repository.THRESHOLD_HDR_ID

2192: ,pr_jai_ap_tds_repository.TDS_AUTHORITY_ID
2193: ,pr_jai_ap_tds_repository.TDS_AUTHORITY_SITE_ID
2194: ,pr_jai_ap_tds_repository.TDS_INVOICE_TYPE
2195: ,pr_jai_ap_tds_repository.THRESHOLD_GRP_ID
2196: ,pr_jai_ap_tds_repository.THRESHOLD_HDR_ID
2197: ,pr_jai_ap_tds_repository.THRESHOLD_TYPE_ID
2198: ,pr_jai_ap_tds_repository.THRESHOLD_SLAB_ID
2199: ,pr_jai_ap_tds_repository.EVENT
2200: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_ID

Line 2197: ,pr_jai_ap_tds_repository.THRESHOLD_TYPE_ID

2193: ,pr_jai_ap_tds_repository.TDS_AUTHORITY_SITE_ID
2194: ,pr_jai_ap_tds_repository.TDS_INVOICE_TYPE
2195: ,pr_jai_ap_tds_repository.THRESHOLD_GRP_ID
2196: ,pr_jai_ap_tds_repository.THRESHOLD_HDR_ID
2197: ,pr_jai_ap_tds_repository.THRESHOLD_TYPE_ID
2198: ,pr_jai_ap_tds_repository.THRESHOLD_SLAB_ID
2199: ,pr_jai_ap_tds_repository.EVENT
2200: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_ID
2201: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_TYPE

Line 2198: ,pr_jai_ap_tds_repository.THRESHOLD_SLAB_ID

2194: ,pr_jai_ap_tds_repository.TDS_INVOICE_TYPE
2195: ,pr_jai_ap_tds_repository.THRESHOLD_GRP_ID
2196: ,pr_jai_ap_tds_repository.THRESHOLD_HDR_ID
2197: ,pr_jai_ap_tds_repository.THRESHOLD_TYPE_ID
2198: ,pr_jai_ap_tds_repository.THRESHOLD_SLAB_ID
2199: ,pr_jai_ap_tds_repository.EVENT
2200: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_ID
2201: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_TYPE
2202: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_AMT

Line 2199: ,pr_jai_ap_tds_repository.EVENT

2195: ,pr_jai_ap_tds_repository.THRESHOLD_GRP_ID
2196: ,pr_jai_ap_tds_repository.THRESHOLD_HDR_ID
2197: ,pr_jai_ap_tds_repository.THRESHOLD_TYPE_ID
2198: ,pr_jai_ap_tds_repository.THRESHOLD_SLAB_ID
2199: ,pr_jai_ap_tds_repository.EVENT
2200: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_ID
2201: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_TYPE
2202: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_AMT
2203: ,pr_jai_ap_tds_repository.SOURCE_ID

Line 2200: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_ID

2196: ,pr_jai_ap_tds_repository.THRESHOLD_HDR_ID
2197: ,pr_jai_ap_tds_repository.THRESHOLD_TYPE_ID
2198: ,pr_jai_ap_tds_repository.THRESHOLD_SLAB_ID
2199: ,pr_jai_ap_tds_repository.EVENT
2200: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_ID
2201: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_TYPE
2202: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_AMT
2203: ,pr_jai_ap_tds_repository.SOURCE_ID
2204: ,pr_jai_ap_tds_repository.SOURCE_SITE_ID

Line 2201: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_TYPE

2197: ,pr_jai_ap_tds_repository.THRESHOLD_TYPE_ID
2198: ,pr_jai_ap_tds_repository.THRESHOLD_SLAB_ID
2199: ,pr_jai_ap_tds_repository.EVENT
2200: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_ID
2201: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_TYPE
2202: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_AMT
2203: ,pr_jai_ap_tds_repository.SOURCE_ID
2204: ,pr_jai_ap_tds_repository.SOURCE_SITE_ID
2205: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_DATE

Line 2202: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_AMT

2198: ,pr_jai_ap_tds_repository.THRESHOLD_SLAB_ID
2199: ,pr_jai_ap_tds_repository.EVENT
2200: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_ID
2201: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_TYPE
2202: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_AMT
2203: ,pr_jai_ap_tds_repository.SOURCE_ID
2204: ,pr_jai_ap_tds_repository.SOURCE_SITE_ID
2205: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_DATE
2206: ,pr_jai_ap_tds_repository.ACCOUNTING_DATE

Line 2203: ,pr_jai_ap_tds_repository.SOURCE_ID

2199: ,pr_jai_ap_tds_repository.EVENT
2200: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_ID
2201: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_TYPE
2202: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_AMT
2203: ,pr_jai_ap_tds_repository.SOURCE_ID
2204: ,pr_jai_ap_tds_repository.SOURCE_SITE_ID
2205: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_DATE
2206: ,pr_jai_ap_tds_repository.ACCOUNTING_DATE
2207: ,pr_jai_ap_tds_repository.APPLIED_FROM_INVOICE_ID

Line 2204: ,pr_jai_ap_tds_repository.SOURCE_SITE_ID

2200: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_ID
2201: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_TYPE
2202: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_AMT
2203: ,pr_jai_ap_tds_repository.SOURCE_ID
2204: ,pr_jai_ap_tds_repository.SOURCE_SITE_ID
2205: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_DATE
2206: ,pr_jai_ap_tds_repository.ACCOUNTING_DATE
2207: ,pr_jai_ap_tds_repository.APPLIED_FROM_INVOICE_ID
2208: ,pr_jai_ap_tds_repository.APPLIED_FROM_INVOICE_TYPE

Line 2205: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_DATE

2201: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_TYPE
2202: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_AMT
2203: ,pr_jai_ap_tds_repository.SOURCE_ID
2204: ,pr_jai_ap_tds_repository.SOURCE_SITE_ID
2205: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_DATE
2206: ,pr_jai_ap_tds_repository.ACCOUNTING_DATE
2207: ,pr_jai_ap_tds_repository.APPLIED_FROM_INVOICE_ID
2208: ,pr_jai_ap_tds_repository.APPLIED_FROM_INVOICE_TYPE
2209: ,pr_jai_ap_tds_repository.APPLIED_FROM_INVOICE_AMT

Line 2206: ,pr_jai_ap_tds_repository.ACCOUNTING_DATE

2202: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_AMT
2203: ,pr_jai_ap_tds_repository.SOURCE_ID
2204: ,pr_jai_ap_tds_repository.SOURCE_SITE_ID
2205: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_DATE
2206: ,pr_jai_ap_tds_repository.ACCOUNTING_DATE
2207: ,pr_jai_ap_tds_repository.APPLIED_FROM_INVOICE_ID
2208: ,pr_jai_ap_tds_repository.APPLIED_FROM_INVOICE_TYPE
2209: ,pr_jai_ap_tds_repository.APPLIED_FROM_INVOICE_AMT
2210: ,pr_jai_ap_tds_repository.APPLIED_FROM_SUPPLIER_ID

Line 2207: ,pr_jai_ap_tds_repository.APPLIED_FROM_INVOICE_ID

2203: ,pr_jai_ap_tds_repository.SOURCE_ID
2204: ,pr_jai_ap_tds_repository.SOURCE_SITE_ID
2205: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_DATE
2206: ,pr_jai_ap_tds_repository.ACCOUNTING_DATE
2207: ,pr_jai_ap_tds_repository.APPLIED_FROM_INVOICE_ID
2208: ,pr_jai_ap_tds_repository.APPLIED_FROM_INVOICE_TYPE
2209: ,pr_jai_ap_tds_repository.APPLIED_FROM_INVOICE_AMT
2210: ,pr_jai_ap_tds_repository.APPLIED_FROM_SUPPLIER_ID
2211: ,pr_jai_ap_tds_repository.APPLIED_FROM_SUPPLIER_SITE_ID

Line 2208: ,pr_jai_ap_tds_repository.APPLIED_FROM_INVOICE_TYPE

2204: ,pr_jai_ap_tds_repository.SOURCE_SITE_ID
2205: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_DATE
2206: ,pr_jai_ap_tds_repository.ACCOUNTING_DATE
2207: ,pr_jai_ap_tds_repository.APPLIED_FROM_INVOICE_ID
2208: ,pr_jai_ap_tds_repository.APPLIED_FROM_INVOICE_TYPE
2209: ,pr_jai_ap_tds_repository.APPLIED_FROM_INVOICE_AMT
2210: ,pr_jai_ap_tds_repository.APPLIED_FROM_SUPPLIER_ID
2211: ,pr_jai_ap_tds_repository.APPLIED_FROM_SUPPLIER_SITE_ID
2212: ,pr_jai_ap_tds_repository.APPLIED_FROM_INVOICE_DATE

Line 2209: ,pr_jai_ap_tds_repository.APPLIED_FROM_INVOICE_AMT

2205: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_DATE
2206: ,pr_jai_ap_tds_repository.ACCOUNTING_DATE
2207: ,pr_jai_ap_tds_repository.APPLIED_FROM_INVOICE_ID
2208: ,pr_jai_ap_tds_repository.APPLIED_FROM_INVOICE_TYPE
2209: ,pr_jai_ap_tds_repository.APPLIED_FROM_INVOICE_AMT
2210: ,pr_jai_ap_tds_repository.APPLIED_FROM_SUPPLIER_ID
2211: ,pr_jai_ap_tds_repository.APPLIED_FROM_SUPPLIER_SITE_ID
2212: ,pr_jai_ap_tds_repository.APPLIED_FROM_INVOICE_DATE
2213: ,pr_jai_ap_tds_repository.APPLIED_FROM_ACCTG_DATE

Line 2210: ,pr_jai_ap_tds_repository.APPLIED_FROM_SUPPLIER_ID

2206: ,pr_jai_ap_tds_repository.ACCOUNTING_DATE
2207: ,pr_jai_ap_tds_repository.APPLIED_FROM_INVOICE_ID
2208: ,pr_jai_ap_tds_repository.APPLIED_FROM_INVOICE_TYPE
2209: ,pr_jai_ap_tds_repository.APPLIED_FROM_INVOICE_AMT
2210: ,pr_jai_ap_tds_repository.APPLIED_FROM_SUPPLIER_ID
2211: ,pr_jai_ap_tds_repository.APPLIED_FROM_SUPPLIER_SITE_ID
2212: ,pr_jai_ap_tds_repository.APPLIED_FROM_INVOICE_DATE
2213: ,pr_jai_ap_tds_repository.APPLIED_FROM_ACCTG_DATE
2214: ,pr_jai_ap_tds_repository.FROM_SLAB_ID

Line 2211: ,pr_jai_ap_tds_repository.APPLIED_FROM_SUPPLIER_SITE_ID

2207: ,pr_jai_ap_tds_repository.APPLIED_FROM_INVOICE_ID
2208: ,pr_jai_ap_tds_repository.APPLIED_FROM_INVOICE_TYPE
2209: ,pr_jai_ap_tds_repository.APPLIED_FROM_INVOICE_AMT
2210: ,pr_jai_ap_tds_repository.APPLIED_FROM_SUPPLIER_ID
2211: ,pr_jai_ap_tds_repository.APPLIED_FROM_SUPPLIER_SITE_ID
2212: ,pr_jai_ap_tds_repository.APPLIED_FROM_INVOICE_DATE
2213: ,pr_jai_ap_tds_repository.APPLIED_FROM_ACCTG_DATE
2214: ,pr_jai_ap_tds_repository.FROM_SLAB_ID
2215: ,pr_jai_ap_tds_repository.APPLIED_TO_INVOICE_ID

Line 2212: ,pr_jai_ap_tds_repository.APPLIED_FROM_INVOICE_DATE

2208: ,pr_jai_ap_tds_repository.APPLIED_FROM_INVOICE_TYPE
2209: ,pr_jai_ap_tds_repository.APPLIED_FROM_INVOICE_AMT
2210: ,pr_jai_ap_tds_repository.APPLIED_FROM_SUPPLIER_ID
2211: ,pr_jai_ap_tds_repository.APPLIED_FROM_SUPPLIER_SITE_ID
2212: ,pr_jai_ap_tds_repository.APPLIED_FROM_INVOICE_DATE
2213: ,pr_jai_ap_tds_repository.APPLIED_FROM_ACCTG_DATE
2214: ,pr_jai_ap_tds_repository.FROM_SLAB_ID
2215: ,pr_jai_ap_tds_repository.APPLIED_TO_INVOICE_ID
2216: ,pr_jai_ap_tds_repository.APPLIED_TO_INVOICE_TYPE

Line 2213: ,pr_jai_ap_tds_repository.APPLIED_FROM_ACCTG_DATE

2209: ,pr_jai_ap_tds_repository.APPLIED_FROM_INVOICE_AMT
2210: ,pr_jai_ap_tds_repository.APPLIED_FROM_SUPPLIER_ID
2211: ,pr_jai_ap_tds_repository.APPLIED_FROM_SUPPLIER_SITE_ID
2212: ,pr_jai_ap_tds_repository.APPLIED_FROM_INVOICE_DATE
2213: ,pr_jai_ap_tds_repository.APPLIED_FROM_ACCTG_DATE
2214: ,pr_jai_ap_tds_repository.FROM_SLAB_ID
2215: ,pr_jai_ap_tds_repository.APPLIED_TO_INVOICE_ID
2216: ,pr_jai_ap_tds_repository.APPLIED_TO_INVOICE_TYPE
2217: ,pr_jai_ap_tds_repository.APPLIED_TO_INVOICE_AMT

Line 2214: ,pr_jai_ap_tds_repository.FROM_SLAB_ID

2210: ,pr_jai_ap_tds_repository.APPLIED_FROM_SUPPLIER_ID
2211: ,pr_jai_ap_tds_repository.APPLIED_FROM_SUPPLIER_SITE_ID
2212: ,pr_jai_ap_tds_repository.APPLIED_FROM_INVOICE_DATE
2213: ,pr_jai_ap_tds_repository.APPLIED_FROM_ACCTG_DATE
2214: ,pr_jai_ap_tds_repository.FROM_SLAB_ID
2215: ,pr_jai_ap_tds_repository.APPLIED_TO_INVOICE_ID
2216: ,pr_jai_ap_tds_repository.APPLIED_TO_INVOICE_TYPE
2217: ,pr_jai_ap_tds_repository.APPLIED_TO_INVOICE_AMT
2218: ,pr_jai_ap_tds_repository.APPLIED_TO_SUPPLIER_ID

Line 2215: ,pr_jai_ap_tds_repository.APPLIED_TO_INVOICE_ID

2211: ,pr_jai_ap_tds_repository.APPLIED_FROM_SUPPLIER_SITE_ID
2212: ,pr_jai_ap_tds_repository.APPLIED_FROM_INVOICE_DATE
2213: ,pr_jai_ap_tds_repository.APPLIED_FROM_ACCTG_DATE
2214: ,pr_jai_ap_tds_repository.FROM_SLAB_ID
2215: ,pr_jai_ap_tds_repository.APPLIED_TO_INVOICE_ID
2216: ,pr_jai_ap_tds_repository.APPLIED_TO_INVOICE_TYPE
2217: ,pr_jai_ap_tds_repository.APPLIED_TO_INVOICE_AMT
2218: ,pr_jai_ap_tds_repository.APPLIED_TO_SUPPLIER_ID
2219: ,pr_jai_ap_tds_repository.APPLIED_TO_SUPPLIER_SITE_ID

Line 2216: ,pr_jai_ap_tds_repository.APPLIED_TO_INVOICE_TYPE

2212: ,pr_jai_ap_tds_repository.APPLIED_FROM_INVOICE_DATE
2213: ,pr_jai_ap_tds_repository.APPLIED_FROM_ACCTG_DATE
2214: ,pr_jai_ap_tds_repository.FROM_SLAB_ID
2215: ,pr_jai_ap_tds_repository.APPLIED_TO_INVOICE_ID
2216: ,pr_jai_ap_tds_repository.APPLIED_TO_INVOICE_TYPE
2217: ,pr_jai_ap_tds_repository.APPLIED_TO_INVOICE_AMT
2218: ,pr_jai_ap_tds_repository.APPLIED_TO_SUPPLIER_ID
2219: ,pr_jai_ap_tds_repository.APPLIED_TO_SUPPLIER_SITE_ID
2220: ,pr_jai_ap_tds_repository.APPLIED_TO_INVOICE_DATE

Line 2217: ,pr_jai_ap_tds_repository.APPLIED_TO_INVOICE_AMT

2213: ,pr_jai_ap_tds_repository.APPLIED_FROM_ACCTG_DATE
2214: ,pr_jai_ap_tds_repository.FROM_SLAB_ID
2215: ,pr_jai_ap_tds_repository.APPLIED_TO_INVOICE_ID
2216: ,pr_jai_ap_tds_repository.APPLIED_TO_INVOICE_TYPE
2217: ,pr_jai_ap_tds_repository.APPLIED_TO_INVOICE_AMT
2218: ,pr_jai_ap_tds_repository.APPLIED_TO_SUPPLIER_ID
2219: ,pr_jai_ap_tds_repository.APPLIED_TO_SUPPLIER_SITE_ID
2220: ,pr_jai_ap_tds_repository.APPLIED_TO_INVOICE_DATE
2221: ,pr_jai_ap_tds_repository.APPLIED_TO_ACCTG_DATE

Line 2218: ,pr_jai_ap_tds_repository.APPLIED_TO_SUPPLIER_ID

2214: ,pr_jai_ap_tds_repository.FROM_SLAB_ID
2215: ,pr_jai_ap_tds_repository.APPLIED_TO_INVOICE_ID
2216: ,pr_jai_ap_tds_repository.APPLIED_TO_INVOICE_TYPE
2217: ,pr_jai_ap_tds_repository.APPLIED_TO_INVOICE_AMT
2218: ,pr_jai_ap_tds_repository.APPLIED_TO_SUPPLIER_ID
2219: ,pr_jai_ap_tds_repository.APPLIED_TO_SUPPLIER_SITE_ID
2220: ,pr_jai_ap_tds_repository.APPLIED_TO_INVOICE_DATE
2221: ,pr_jai_ap_tds_repository.APPLIED_TO_ACCTG_DATE
2222: ,pr_jai_ap_tds_repository.APPLIED_AMOUNT

Line 2219: ,pr_jai_ap_tds_repository.APPLIED_TO_SUPPLIER_SITE_ID

2215: ,pr_jai_ap_tds_repository.APPLIED_TO_INVOICE_ID
2216: ,pr_jai_ap_tds_repository.APPLIED_TO_INVOICE_TYPE
2217: ,pr_jai_ap_tds_repository.APPLIED_TO_INVOICE_AMT
2218: ,pr_jai_ap_tds_repository.APPLIED_TO_SUPPLIER_ID
2219: ,pr_jai_ap_tds_repository.APPLIED_TO_SUPPLIER_SITE_ID
2220: ,pr_jai_ap_tds_repository.APPLIED_TO_INVOICE_DATE
2221: ,pr_jai_ap_tds_repository.APPLIED_TO_ACCTG_DATE
2222: ,pr_jai_ap_tds_repository.APPLIED_AMOUNT
2223: ,pr_jai_ap_tds_repository.TO_SLAB_ID

Line 2220: ,pr_jai_ap_tds_repository.APPLIED_TO_INVOICE_DATE

2216: ,pr_jai_ap_tds_repository.APPLIED_TO_INVOICE_TYPE
2217: ,pr_jai_ap_tds_repository.APPLIED_TO_INVOICE_AMT
2218: ,pr_jai_ap_tds_repository.APPLIED_TO_SUPPLIER_ID
2219: ,pr_jai_ap_tds_repository.APPLIED_TO_SUPPLIER_SITE_ID
2220: ,pr_jai_ap_tds_repository.APPLIED_TO_INVOICE_DATE
2221: ,pr_jai_ap_tds_repository.APPLIED_TO_ACCTG_DATE
2222: ,pr_jai_ap_tds_repository.APPLIED_AMOUNT
2223: ,pr_jai_ap_tds_repository.TO_SLAB_ID
2224: ,pr_jai_ap_tds_repository.UNAPPLIED_AMOUNT

Line 2221: ,pr_jai_ap_tds_repository.APPLIED_TO_ACCTG_DATE

2217: ,pr_jai_ap_tds_repository.APPLIED_TO_INVOICE_AMT
2218: ,pr_jai_ap_tds_repository.APPLIED_TO_SUPPLIER_ID
2219: ,pr_jai_ap_tds_repository.APPLIED_TO_SUPPLIER_SITE_ID
2220: ,pr_jai_ap_tds_repository.APPLIED_TO_INVOICE_DATE
2221: ,pr_jai_ap_tds_repository.APPLIED_TO_ACCTG_DATE
2222: ,pr_jai_ap_tds_repository.APPLIED_AMOUNT
2223: ,pr_jai_ap_tds_repository.TO_SLAB_ID
2224: ,pr_jai_ap_tds_repository.UNAPPLIED_AMOUNT
2225: ,pr_jai_ap_tds_repository.TDS_ACCOUNTING_DATE

Line 2222: ,pr_jai_ap_tds_repository.APPLIED_AMOUNT

2218: ,pr_jai_ap_tds_repository.APPLIED_TO_SUPPLIER_ID
2219: ,pr_jai_ap_tds_repository.APPLIED_TO_SUPPLIER_SITE_ID
2220: ,pr_jai_ap_tds_repository.APPLIED_TO_INVOICE_DATE
2221: ,pr_jai_ap_tds_repository.APPLIED_TO_ACCTG_DATE
2222: ,pr_jai_ap_tds_repository.APPLIED_AMOUNT
2223: ,pr_jai_ap_tds_repository.TO_SLAB_ID
2224: ,pr_jai_ap_tds_repository.UNAPPLIED_AMOUNT
2225: ,pr_jai_ap_tds_repository.TDS_ACCOUNTING_DATE
2226: ,pr_jai_ap_tds_repository.REGIME_ID

Line 2223: ,pr_jai_ap_tds_repository.TO_SLAB_ID

2219: ,pr_jai_ap_tds_repository.APPLIED_TO_SUPPLIER_SITE_ID
2220: ,pr_jai_ap_tds_repository.APPLIED_TO_INVOICE_DATE
2221: ,pr_jai_ap_tds_repository.APPLIED_TO_ACCTG_DATE
2222: ,pr_jai_ap_tds_repository.APPLIED_AMOUNT
2223: ,pr_jai_ap_tds_repository.TO_SLAB_ID
2224: ,pr_jai_ap_tds_repository.UNAPPLIED_AMOUNT
2225: ,pr_jai_ap_tds_repository.TDS_ACCOUNTING_DATE
2226: ,pr_jai_ap_tds_repository.REGIME_ID
2227: ,pr_jai_ap_tds_repository.REGIME_CODE

Line 2224: ,pr_jai_ap_tds_repository.UNAPPLIED_AMOUNT

2220: ,pr_jai_ap_tds_repository.APPLIED_TO_INVOICE_DATE
2221: ,pr_jai_ap_tds_repository.APPLIED_TO_ACCTG_DATE
2222: ,pr_jai_ap_tds_repository.APPLIED_AMOUNT
2223: ,pr_jai_ap_tds_repository.TO_SLAB_ID
2224: ,pr_jai_ap_tds_repository.UNAPPLIED_AMOUNT
2225: ,pr_jai_ap_tds_repository.TDS_ACCOUNTING_DATE
2226: ,pr_jai_ap_tds_repository.REGIME_ID
2227: ,pr_jai_ap_tds_repository.REGIME_CODE
2228: ,pr_jai_ap_tds_repository.ORG_ID

Line 2225: ,pr_jai_ap_tds_repository.TDS_ACCOUNTING_DATE

2221: ,pr_jai_ap_tds_repository.APPLIED_TO_ACCTG_DATE
2222: ,pr_jai_ap_tds_repository.APPLIED_AMOUNT
2223: ,pr_jai_ap_tds_repository.TO_SLAB_ID
2224: ,pr_jai_ap_tds_repository.UNAPPLIED_AMOUNT
2225: ,pr_jai_ap_tds_repository.TDS_ACCOUNTING_DATE
2226: ,pr_jai_ap_tds_repository.REGIME_ID
2227: ,pr_jai_ap_tds_repository.REGIME_CODE
2228: ,pr_jai_ap_tds_repository.ORG_ID
2229: ,pr_jai_ap_tds_repository.LEGAL_ENTITY_ID

Line 2226: ,pr_jai_ap_tds_repository.REGIME_ID

2222: ,pr_jai_ap_tds_repository.APPLIED_AMOUNT
2223: ,pr_jai_ap_tds_repository.TO_SLAB_ID
2224: ,pr_jai_ap_tds_repository.UNAPPLIED_AMOUNT
2225: ,pr_jai_ap_tds_repository.TDS_ACCOUNTING_DATE
2226: ,pr_jai_ap_tds_repository.REGIME_ID
2227: ,pr_jai_ap_tds_repository.REGIME_CODE
2228: ,pr_jai_ap_tds_repository.ORG_ID
2229: ,pr_jai_ap_tds_repository.LEGAL_ENTITY_ID
2230: ,pr_jai_ap_tds_repository.ORG_TAN_NUMBER

Line 2227: ,pr_jai_ap_tds_repository.REGIME_CODE

2223: ,pr_jai_ap_tds_repository.TO_SLAB_ID
2224: ,pr_jai_ap_tds_repository.UNAPPLIED_AMOUNT
2225: ,pr_jai_ap_tds_repository.TDS_ACCOUNTING_DATE
2226: ,pr_jai_ap_tds_repository.REGIME_ID
2227: ,pr_jai_ap_tds_repository.REGIME_CODE
2228: ,pr_jai_ap_tds_repository.ORG_ID
2229: ,pr_jai_ap_tds_repository.LEGAL_ENTITY_ID
2230: ,pr_jai_ap_tds_repository.ORG_TAN_NUMBER
2231: ,pr_jai_ap_tds_repository.SECTION_TYPE

Line 2228: ,pr_jai_ap_tds_repository.ORG_ID

2224: ,pr_jai_ap_tds_repository.UNAPPLIED_AMOUNT
2225: ,pr_jai_ap_tds_repository.TDS_ACCOUNTING_DATE
2226: ,pr_jai_ap_tds_repository.REGIME_ID
2227: ,pr_jai_ap_tds_repository.REGIME_CODE
2228: ,pr_jai_ap_tds_repository.ORG_ID
2229: ,pr_jai_ap_tds_repository.LEGAL_ENTITY_ID
2230: ,pr_jai_ap_tds_repository.ORG_TAN_NUMBER
2231: ,pr_jai_ap_tds_repository.SECTION_TYPE
2232: ,pr_jai_ap_tds_repository.SECTION_CODE

Line 2229: ,pr_jai_ap_tds_repository.LEGAL_ENTITY_ID

2225: ,pr_jai_ap_tds_repository.TDS_ACCOUNTING_DATE
2226: ,pr_jai_ap_tds_repository.REGIME_ID
2227: ,pr_jai_ap_tds_repository.REGIME_CODE
2228: ,pr_jai_ap_tds_repository.ORG_ID
2229: ,pr_jai_ap_tds_repository.LEGAL_ENTITY_ID
2230: ,pr_jai_ap_tds_repository.ORG_TAN_NUMBER
2231: ,pr_jai_ap_tds_repository.SECTION_TYPE
2232: ,pr_jai_ap_tds_repository.SECTION_CODE
2233: ,pr_jai_ap_tds_repository.TAX_RATE

Line 2230: ,pr_jai_ap_tds_repository.ORG_TAN_NUMBER

2226: ,pr_jai_ap_tds_repository.REGIME_ID
2227: ,pr_jai_ap_tds_repository.REGIME_CODE
2228: ,pr_jai_ap_tds_repository.ORG_ID
2229: ,pr_jai_ap_tds_repository.LEGAL_ENTITY_ID
2230: ,pr_jai_ap_tds_repository.ORG_TAN_NUMBER
2231: ,pr_jai_ap_tds_repository.SECTION_TYPE
2232: ,pr_jai_ap_tds_repository.SECTION_CODE
2233: ,pr_jai_ap_tds_repository.TAX_RATE
2234: ,pr_jai_ap_tds_repository.TAX_ID

Line 2231: ,pr_jai_ap_tds_repository.SECTION_TYPE

2227: ,pr_jai_ap_tds_repository.REGIME_CODE
2228: ,pr_jai_ap_tds_repository.ORG_ID
2229: ,pr_jai_ap_tds_repository.LEGAL_ENTITY_ID
2230: ,pr_jai_ap_tds_repository.ORG_TAN_NUMBER
2231: ,pr_jai_ap_tds_repository.SECTION_TYPE
2232: ,pr_jai_ap_tds_repository.SECTION_CODE
2233: ,pr_jai_ap_tds_repository.TAX_RATE
2234: ,pr_jai_ap_tds_repository.TAX_ID
2235: ,pr_jai_ap_tds_repository.TAX_CATEGORY_ID

Line 2232: ,pr_jai_ap_tds_repository.SECTION_CODE

2228: ,pr_jai_ap_tds_repository.ORG_ID
2229: ,pr_jai_ap_tds_repository.LEGAL_ENTITY_ID
2230: ,pr_jai_ap_tds_repository.ORG_TAN_NUMBER
2231: ,pr_jai_ap_tds_repository.SECTION_TYPE
2232: ,pr_jai_ap_tds_repository.SECTION_CODE
2233: ,pr_jai_ap_tds_repository.TAX_RATE
2234: ,pr_jai_ap_tds_repository.TAX_ID
2235: ,pr_jai_ap_tds_repository.TAX_CATEGORY_ID
2236: ,pr_jai_ap_tds_repository.TDS_PAID

Line 2233: ,pr_jai_ap_tds_repository.TAX_RATE

2229: ,pr_jai_ap_tds_repository.LEGAL_ENTITY_ID
2230: ,pr_jai_ap_tds_repository.ORG_TAN_NUMBER
2231: ,pr_jai_ap_tds_repository.SECTION_TYPE
2232: ,pr_jai_ap_tds_repository.SECTION_CODE
2233: ,pr_jai_ap_tds_repository.TAX_RATE
2234: ,pr_jai_ap_tds_repository.TAX_ID
2235: ,pr_jai_ap_tds_repository.TAX_CATEGORY_ID
2236: ,pr_jai_ap_tds_repository.TDS_PAID
2237: ,pr_jai_ap_tds_repository.INVOICE_DELETED

Line 2234: ,pr_jai_ap_tds_repository.TAX_ID

2230: ,pr_jai_ap_tds_repository.ORG_TAN_NUMBER
2231: ,pr_jai_ap_tds_repository.SECTION_TYPE
2232: ,pr_jai_ap_tds_repository.SECTION_CODE
2233: ,pr_jai_ap_tds_repository.TAX_RATE
2234: ,pr_jai_ap_tds_repository.TAX_ID
2235: ,pr_jai_ap_tds_repository.TAX_CATEGORY_ID
2236: ,pr_jai_ap_tds_repository.TDS_PAID
2237: ,pr_jai_ap_tds_repository.INVOICE_DELETED
2238: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_DELETED

Line 2235: ,pr_jai_ap_tds_repository.TAX_CATEGORY_ID

2231: ,pr_jai_ap_tds_repository.SECTION_TYPE
2232: ,pr_jai_ap_tds_repository.SECTION_CODE
2233: ,pr_jai_ap_tds_repository.TAX_RATE
2234: ,pr_jai_ap_tds_repository.TAX_ID
2235: ,pr_jai_ap_tds_repository.TAX_CATEGORY_ID
2236: ,pr_jai_ap_tds_repository.TDS_PAID
2237: ,pr_jai_ap_tds_repository.INVOICE_DELETED
2238: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_DELETED
2239: ,pr_jai_ap_tds_repository.PRIOR_THRESHOLD

Line 2236: ,pr_jai_ap_tds_repository.TDS_PAID

2232: ,pr_jai_ap_tds_repository.SECTION_CODE
2233: ,pr_jai_ap_tds_repository.TAX_RATE
2234: ,pr_jai_ap_tds_repository.TAX_ID
2235: ,pr_jai_ap_tds_repository.TAX_CATEGORY_ID
2236: ,pr_jai_ap_tds_repository.TDS_PAID
2237: ,pr_jai_ap_tds_repository.INVOICE_DELETED
2238: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_DELETED
2239: ,pr_jai_ap_tds_repository.PRIOR_THRESHOLD
2240: ,pr_jai_ap_tds_repository.CHALLAN_NUMBER

Line 2237: ,pr_jai_ap_tds_repository.INVOICE_DELETED

2233: ,pr_jai_ap_tds_repository.TAX_RATE
2234: ,pr_jai_ap_tds_repository.TAX_ID
2235: ,pr_jai_ap_tds_repository.TAX_CATEGORY_ID
2236: ,pr_jai_ap_tds_repository.TDS_PAID
2237: ,pr_jai_ap_tds_repository.INVOICE_DELETED
2238: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_DELETED
2239: ,pr_jai_ap_tds_repository.PRIOR_THRESHOLD
2240: ,pr_jai_ap_tds_repository.CHALLAN_NUMBER
2241: ,pr_jai_ap_tds_repository.CHECK_DATE

Line 2238: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_DELETED

2234: ,pr_jai_ap_tds_repository.TAX_ID
2235: ,pr_jai_ap_tds_repository.TAX_CATEGORY_ID
2236: ,pr_jai_ap_tds_repository.TDS_PAID
2237: ,pr_jai_ap_tds_repository.INVOICE_DELETED
2238: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_DELETED
2239: ,pr_jai_ap_tds_repository.PRIOR_THRESHOLD
2240: ,pr_jai_ap_tds_repository.CHALLAN_NUMBER
2241: ,pr_jai_ap_tds_repository.CHECK_DATE
2242: ,pr_jai_ap_tds_repository.CHECK_DEPOSIT_DATE

Line 2239: ,pr_jai_ap_tds_repository.PRIOR_THRESHOLD

2235: ,pr_jai_ap_tds_repository.TAX_CATEGORY_ID
2236: ,pr_jai_ap_tds_repository.TDS_PAID
2237: ,pr_jai_ap_tds_repository.INVOICE_DELETED
2238: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_DELETED
2239: ,pr_jai_ap_tds_repository.PRIOR_THRESHOLD
2240: ,pr_jai_ap_tds_repository.CHALLAN_NUMBER
2241: ,pr_jai_ap_tds_repository.CHECK_DATE
2242: ,pr_jai_ap_tds_repository.CHECK_DEPOSIT_DATE
2243: ,pr_jai_ap_tds_repository.BSR_CODE

Line 2240: ,pr_jai_ap_tds_repository.CHALLAN_NUMBER

2236: ,pr_jai_ap_tds_repository.TDS_PAID
2237: ,pr_jai_ap_tds_repository.INVOICE_DELETED
2238: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_DELETED
2239: ,pr_jai_ap_tds_repository.PRIOR_THRESHOLD
2240: ,pr_jai_ap_tds_repository.CHALLAN_NUMBER
2241: ,pr_jai_ap_tds_repository.CHECK_DATE
2242: ,pr_jai_ap_tds_repository.CHECK_DEPOSIT_DATE
2243: ,pr_jai_ap_tds_repository.BSR_CODE
2244: ,pr_jai_ap_tds_repository.PAYMENT_REFERENCE_ID

Line 2241: ,pr_jai_ap_tds_repository.CHECK_DATE

2237: ,pr_jai_ap_tds_repository.INVOICE_DELETED
2238: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_DELETED
2239: ,pr_jai_ap_tds_repository.PRIOR_THRESHOLD
2240: ,pr_jai_ap_tds_repository.CHALLAN_NUMBER
2241: ,pr_jai_ap_tds_repository.CHECK_DATE
2242: ,pr_jai_ap_tds_repository.CHECK_DEPOSIT_DATE
2243: ,pr_jai_ap_tds_repository.BSR_CODE
2244: ,pr_jai_ap_tds_repository.PAYMENT_REFERENCE_ID
2245: ,pr_jai_ap_tds_repository.TDS_INV_TAX_AMOUNT

Line 2242: ,pr_jai_ap_tds_repository.CHECK_DEPOSIT_DATE

2238: ,pr_jai_ap_tds_repository.SOURCE_INVOICE_DELETED
2239: ,pr_jai_ap_tds_repository.PRIOR_THRESHOLD
2240: ,pr_jai_ap_tds_repository.CHALLAN_NUMBER
2241: ,pr_jai_ap_tds_repository.CHECK_DATE
2242: ,pr_jai_ap_tds_repository.CHECK_DEPOSIT_DATE
2243: ,pr_jai_ap_tds_repository.BSR_CODE
2244: ,pr_jai_ap_tds_repository.PAYMENT_REFERENCE_ID
2245: ,pr_jai_ap_tds_repository.TDS_INV_TAX_AMOUNT
2246: ,pr_jai_ap_tds_repository.SUPPLIER_CM_AMOUNT

Line 2243: ,pr_jai_ap_tds_repository.BSR_CODE

2239: ,pr_jai_ap_tds_repository.PRIOR_THRESHOLD
2240: ,pr_jai_ap_tds_repository.CHALLAN_NUMBER
2241: ,pr_jai_ap_tds_repository.CHECK_DATE
2242: ,pr_jai_ap_tds_repository.CHECK_DEPOSIT_DATE
2243: ,pr_jai_ap_tds_repository.BSR_CODE
2244: ,pr_jai_ap_tds_repository.PAYMENT_REFERENCE_ID
2245: ,pr_jai_ap_tds_repository.TDS_INV_TAX_AMOUNT
2246: ,pr_jai_ap_tds_repository.SUPPLIER_CM_AMOUNT
2247: ,pr_jai_ap_tds_repository.BASE_TAX_AMOUNT

Line 2244: ,pr_jai_ap_tds_repository.PAYMENT_REFERENCE_ID

2240: ,pr_jai_ap_tds_repository.CHALLAN_NUMBER
2241: ,pr_jai_ap_tds_repository.CHECK_DATE
2242: ,pr_jai_ap_tds_repository.CHECK_DEPOSIT_DATE
2243: ,pr_jai_ap_tds_repository.BSR_CODE
2244: ,pr_jai_ap_tds_repository.PAYMENT_REFERENCE_ID
2245: ,pr_jai_ap_tds_repository.TDS_INV_TAX_AMOUNT
2246: ,pr_jai_ap_tds_repository.SUPPLIER_CM_AMOUNT
2247: ,pr_jai_ap_tds_repository.BASE_TAX_AMOUNT
2248: ,pr_jai_ap_tds_repository.REQUIRED_FOR_ETDS

Line 2245: ,pr_jai_ap_tds_repository.TDS_INV_TAX_AMOUNT

2241: ,pr_jai_ap_tds_repository.CHECK_DATE
2242: ,pr_jai_ap_tds_repository.CHECK_DEPOSIT_DATE
2243: ,pr_jai_ap_tds_repository.BSR_CODE
2244: ,pr_jai_ap_tds_repository.PAYMENT_REFERENCE_ID
2245: ,pr_jai_ap_tds_repository.TDS_INV_TAX_AMOUNT
2246: ,pr_jai_ap_tds_repository.SUPPLIER_CM_AMOUNT
2247: ,pr_jai_ap_tds_repository.BASE_TAX_AMOUNT
2248: ,pr_jai_ap_tds_repository.REQUIRED_FOR_ETDS
2249: ,pr_jai_ap_tds_repository.MIGRATED

Line 2246: ,pr_jai_ap_tds_repository.SUPPLIER_CM_AMOUNT

2242: ,pr_jai_ap_tds_repository.CHECK_DEPOSIT_DATE
2243: ,pr_jai_ap_tds_repository.BSR_CODE
2244: ,pr_jai_ap_tds_repository.PAYMENT_REFERENCE_ID
2245: ,pr_jai_ap_tds_repository.TDS_INV_TAX_AMOUNT
2246: ,pr_jai_ap_tds_repository.SUPPLIER_CM_AMOUNT
2247: ,pr_jai_ap_tds_repository.BASE_TAX_AMOUNT
2248: ,pr_jai_ap_tds_repository.REQUIRED_FOR_ETDS
2249: ,pr_jai_ap_tds_repository.MIGRATED
2250: ,pr_jai_ap_tds_repository.CREATION_DATE

Line 2247: ,pr_jai_ap_tds_repository.BASE_TAX_AMOUNT

2243: ,pr_jai_ap_tds_repository.BSR_CODE
2244: ,pr_jai_ap_tds_repository.PAYMENT_REFERENCE_ID
2245: ,pr_jai_ap_tds_repository.TDS_INV_TAX_AMOUNT
2246: ,pr_jai_ap_tds_repository.SUPPLIER_CM_AMOUNT
2247: ,pr_jai_ap_tds_repository.BASE_TAX_AMOUNT
2248: ,pr_jai_ap_tds_repository.REQUIRED_FOR_ETDS
2249: ,pr_jai_ap_tds_repository.MIGRATED
2250: ,pr_jai_ap_tds_repository.CREATION_DATE
2251: ,pr_jai_ap_tds_repository.CREATED_BY

Line 2248: ,pr_jai_ap_tds_repository.REQUIRED_FOR_ETDS

2244: ,pr_jai_ap_tds_repository.PAYMENT_REFERENCE_ID
2245: ,pr_jai_ap_tds_repository.TDS_INV_TAX_AMOUNT
2246: ,pr_jai_ap_tds_repository.SUPPLIER_CM_AMOUNT
2247: ,pr_jai_ap_tds_repository.BASE_TAX_AMOUNT
2248: ,pr_jai_ap_tds_repository.REQUIRED_FOR_ETDS
2249: ,pr_jai_ap_tds_repository.MIGRATED
2250: ,pr_jai_ap_tds_repository.CREATION_DATE
2251: ,pr_jai_ap_tds_repository.CREATED_BY
2252: ,pr_jai_ap_tds_repository.LAST_UPDATE_DATE

Line 2249: ,pr_jai_ap_tds_repository.MIGRATED

2245: ,pr_jai_ap_tds_repository.TDS_INV_TAX_AMOUNT
2246: ,pr_jai_ap_tds_repository.SUPPLIER_CM_AMOUNT
2247: ,pr_jai_ap_tds_repository.BASE_TAX_AMOUNT
2248: ,pr_jai_ap_tds_repository.REQUIRED_FOR_ETDS
2249: ,pr_jai_ap_tds_repository.MIGRATED
2250: ,pr_jai_ap_tds_repository.CREATION_DATE
2251: ,pr_jai_ap_tds_repository.CREATED_BY
2252: ,pr_jai_ap_tds_repository.LAST_UPDATE_DATE
2253: ,pr_jai_ap_tds_repository.LAST_UPDATE_LOGIN

Line 2250: ,pr_jai_ap_tds_repository.CREATION_DATE

2246: ,pr_jai_ap_tds_repository.SUPPLIER_CM_AMOUNT
2247: ,pr_jai_ap_tds_repository.BASE_TAX_AMOUNT
2248: ,pr_jai_ap_tds_repository.REQUIRED_FOR_ETDS
2249: ,pr_jai_ap_tds_repository.MIGRATED
2250: ,pr_jai_ap_tds_repository.CREATION_DATE
2251: ,pr_jai_ap_tds_repository.CREATED_BY
2252: ,pr_jai_ap_tds_repository.LAST_UPDATE_DATE
2253: ,pr_jai_ap_tds_repository.LAST_UPDATE_LOGIN
2254: ,pr_jai_ap_tds_repository.LAST_UPDATED_BY

Line 2251: ,pr_jai_ap_tds_repository.CREATED_BY

2247: ,pr_jai_ap_tds_repository.BASE_TAX_AMOUNT
2248: ,pr_jai_ap_tds_repository.REQUIRED_FOR_ETDS
2249: ,pr_jai_ap_tds_repository.MIGRATED
2250: ,pr_jai_ap_tds_repository.CREATION_DATE
2251: ,pr_jai_ap_tds_repository.CREATED_BY
2252: ,pr_jai_ap_tds_repository.LAST_UPDATE_DATE
2253: ,pr_jai_ap_tds_repository.LAST_UPDATE_LOGIN
2254: ,pr_jai_ap_tds_repository.LAST_UPDATED_BY
2255: );

Line 2252: ,pr_jai_ap_tds_repository.LAST_UPDATE_DATE

2248: ,pr_jai_ap_tds_repository.REQUIRED_FOR_ETDS
2249: ,pr_jai_ap_tds_repository.MIGRATED
2250: ,pr_jai_ap_tds_repository.CREATION_DATE
2251: ,pr_jai_ap_tds_repository.CREATED_BY
2252: ,pr_jai_ap_tds_repository.LAST_UPDATE_DATE
2253: ,pr_jai_ap_tds_repository.LAST_UPDATE_LOGIN
2254: ,pr_jai_ap_tds_repository.LAST_UPDATED_BY
2255: );
2256:

Line 2253: ,pr_jai_ap_tds_repository.LAST_UPDATE_LOGIN

2249: ,pr_jai_ap_tds_repository.MIGRATED
2250: ,pr_jai_ap_tds_repository.CREATION_DATE
2251: ,pr_jai_ap_tds_repository.CREATED_BY
2252: ,pr_jai_ap_tds_repository.LAST_UPDATE_DATE
2253: ,pr_jai_ap_tds_repository.LAST_UPDATE_LOGIN
2254: ,pr_jai_ap_tds_repository.LAST_UPDATED_BY
2255: );
2256:
2257: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'Process eTDS repository line population');

Line 2254: ,pr_jai_ap_tds_repository.LAST_UPDATED_BY

2250: ,pr_jai_ap_tds_repository.CREATION_DATE
2251: ,pr_jai_ap_tds_repository.CREATED_BY
2252: ,pr_jai_ap_tds_repository.LAST_UPDATE_DATE
2253: ,pr_jai_ap_tds_repository.LAST_UPDATE_LOGIN
2254: ,pr_jai_ap_tds_repository.LAST_UPDATED_BY
2255: );
2256:
2257: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'Process eTDS repository line population');
2258:

Line 2259: IF pr_jai_ap_tds_repository.INVOICE_ID IS NOT NULL THEN

2255: );
2256:
2257: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'Process eTDS repository line population');
2258:
2259: IF pr_jai_ap_tds_repository.INVOICE_ID IS NOT NULL THEN
2260: --If TDS invoice created, populate repository lines for each tax id
2261: --(assume each tax type only exists one tax code)
2262: FOR rec_tax IN c_get_invoice_line_info(pr_jai_ap_tds_repository.INVOICE_ID)
2263: LOOP

Line 2262: FOR rec_tax IN c_get_invoice_line_info(pr_jai_ap_tds_repository.INVOICE_ID)

2258:
2259: IF pr_jai_ap_tds_repository.INVOICE_ID IS NOT NULL THEN
2260: --If TDS invoice created, populate repository lines for each tax id
2261: --(assume each tax type only exists one tax code)
2262: FOR rec_tax IN c_get_invoice_line_info(pr_jai_ap_tds_repository.INVOICE_ID)
2263: LOOP
2264: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'tax_type ' ||rec_tax.tax_type || ' tax_id: ' || rec_tax.tax_id);
2265:
2266: OPEN c_get_taxes_info(p_tax_type => rec_tax.tax_type

Line 2274: r_jai_ap_tds_repo_lines.invoice_id := pr_jai_ap_tds_repository.INVOICE_ID;

2270: CLOSE c_get_taxes_info;
2271:
2272: r_jai_ap_tds_repo_lines := NULL;
2273: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, '@1');
2274: r_jai_ap_tds_repo_lines.invoice_id := pr_jai_ap_tds_repository.INVOICE_ID;
2275: r_jai_ap_tds_repo_lines.tax_id := r_c_get_taxes_info.tax_id;
2276: r_jai_ap_tds_repo_lines.tax_name := r_c_get_taxes_info.tax_name;
2277: r_jai_ap_tds_repo_lines.tax_type := r_c_get_taxes_info.tax_type;
2278: r_jai_ap_tds_repo_lines.tax_amount := rec_tax.amount;

Line 2279: r_jai_ap_tds_repo_lines.CREATION_DATE := pr_jai_ap_tds_repository.CREATION_DATE;

2275: r_jai_ap_tds_repo_lines.tax_id := r_c_get_taxes_info.tax_id;
2276: r_jai_ap_tds_repo_lines.tax_name := r_c_get_taxes_info.tax_name;
2277: r_jai_ap_tds_repo_lines.tax_type := r_c_get_taxes_info.tax_type;
2278: r_jai_ap_tds_repo_lines.tax_amount := rec_tax.amount;
2279: r_jai_ap_tds_repo_lines.CREATION_DATE := pr_jai_ap_tds_repository.CREATION_DATE;
2280: r_jai_ap_tds_repo_lines.CREATED_BY := pr_jai_ap_tds_repository.CREATED_BY;
2281: r_jai_ap_tds_repo_lines.LAST_UPDATE_DATE := pr_jai_ap_tds_repository.LAST_UPDATE_DATE;
2282: r_jai_ap_tds_repo_lines.LAST_UPDATE_LOGIN := pr_jai_ap_tds_repository.LAST_UPDATE_LOGIN;
2283: r_jai_ap_tds_repo_lines.LAST_UPDATED_BY := pr_jai_ap_tds_repository.LAST_UPDATED_BY;

Line 2280: r_jai_ap_tds_repo_lines.CREATED_BY := pr_jai_ap_tds_repository.CREATED_BY;

2276: r_jai_ap_tds_repo_lines.tax_name := r_c_get_taxes_info.tax_name;
2277: r_jai_ap_tds_repo_lines.tax_type := r_c_get_taxes_info.tax_type;
2278: r_jai_ap_tds_repo_lines.tax_amount := rec_tax.amount;
2279: r_jai_ap_tds_repo_lines.CREATION_DATE := pr_jai_ap_tds_repository.CREATION_DATE;
2280: r_jai_ap_tds_repo_lines.CREATED_BY := pr_jai_ap_tds_repository.CREATED_BY;
2281: r_jai_ap_tds_repo_lines.LAST_UPDATE_DATE := pr_jai_ap_tds_repository.LAST_UPDATE_DATE;
2282: r_jai_ap_tds_repo_lines.LAST_UPDATE_LOGIN := pr_jai_ap_tds_repository.LAST_UPDATE_LOGIN;
2283: r_jai_ap_tds_repo_lines.LAST_UPDATED_BY := pr_jai_ap_tds_repository.LAST_UPDATED_BY;
2284:

Line 2281: r_jai_ap_tds_repo_lines.LAST_UPDATE_DATE := pr_jai_ap_tds_repository.LAST_UPDATE_DATE;

2277: r_jai_ap_tds_repo_lines.tax_type := r_c_get_taxes_info.tax_type;
2278: r_jai_ap_tds_repo_lines.tax_amount := rec_tax.amount;
2279: r_jai_ap_tds_repo_lines.CREATION_DATE := pr_jai_ap_tds_repository.CREATION_DATE;
2280: r_jai_ap_tds_repo_lines.CREATED_BY := pr_jai_ap_tds_repository.CREATED_BY;
2281: r_jai_ap_tds_repo_lines.LAST_UPDATE_DATE := pr_jai_ap_tds_repository.LAST_UPDATE_DATE;
2282: r_jai_ap_tds_repo_lines.LAST_UPDATE_LOGIN := pr_jai_ap_tds_repository.LAST_UPDATE_LOGIN;
2283: r_jai_ap_tds_repo_lines.LAST_UPDATED_BY := pr_jai_ap_tds_repository.LAST_UPDATED_BY;
2284:
2285: insert_jai_ap_tds_repo_lines(r_jai_ap_tds_repo_lines);

Line 2282: r_jai_ap_tds_repo_lines.LAST_UPDATE_LOGIN := pr_jai_ap_tds_repository.LAST_UPDATE_LOGIN;

2278: r_jai_ap_tds_repo_lines.tax_amount := rec_tax.amount;
2279: r_jai_ap_tds_repo_lines.CREATION_DATE := pr_jai_ap_tds_repository.CREATION_DATE;
2280: r_jai_ap_tds_repo_lines.CREATED_BY := pr_jai_ap_tds_repository.CREATED_BY;
2281: r_jai_ap_tds_repo_lines.LAST_UPDATE_DATE := pr_jai_ap_tds_repository.LAST_UPDATE_DATE;
2282: r_jai_ap_tds_repo_lines.LAST_UPDATE_LOGIN := pr_jai_ap_tds_repository.LAST_UPDATE_LOGIN;
2283: r_jai_ap_tds_repo_lines.LAST_UPDATED_BY := pr_jai_ap_tds_repository.LAST_UPDATED_BY;
2284:
2285: insert_jai_ap_tds_repo_lines(r_jai_ap_tds_repo_lines);
2286: END LOOP;

Line 2283: r_jai_ap_tds_repo_lines.LAST_UPDATED_BY := pr_jai_ap_tds_repository.LAST_UPDATED_BY;

2279: r_jai_ap_tds_repo_lines.CREATION_DATE := pr_jai_ap_tds_repository.CREATION_DATE;
2280: r_jai_ap_tds_repo_lines.CREATED_BY := pr_jai_ap_tds_repository.CREATED_BY;
2281: r_jai_ap_tds_repo_lines.LAST_UPDATE_DATE := pr_jai_ap_tds_repository.LAST_UPDATE_DATE;
2282: r_jai_ap_tds_repo_lines.LAST_UPDATE_LOGIN := pr_jai_ap_tds_repository.LAST_UPDATE_LOGIN;
2283: r_jai_ap_tds_repo_lines.LAST_UPDATED_BY := pr_jai_ap_tds_repository.LAST_UPDATED_BY;
2284:
2285: insert_jai_ap_tds_repo_lines(r_jai_ap_tds_repo_lines);
2286: END LOOP;
2287: