APPS.JAI_RCV_THIRD_PARTY_PKG dependencies on JAI_CONSTANTS

Line 459: and jrlt.tax_type not in (jai_constants.tax_type_tds,jai_constants.tax_type_modvat_recovery) --'TDS', 'Modvat Recovery')

455: )
456: )
457: and jrt.third_party_flag = 'N'
458: )
459: and jrlt.tax_type not in (jai_constants.tax_type_tds,jai_constants.tax_type_modvat_recovery) --'TDS', 'Modvat Recovery')
460: and jrlt.vendor_id > 0
461: and jrlt.tax_amount <> 0
462: and jrlt.tax_amount <> 0
463: and jrlt.vendor_id <> p_po_vendor_id;

Line 492: and jrlt.tax_type not in (jai_constants.tax_type_tds,jai_constants.tax_type_modvat_recovery) --'TDS', 'Modvat Recovery')

488: )
489: )
490: and jrt.third_party_flag = 'N'
491: )
492: and jrlt.tax_type not in (jai_constants.tax_type_tds,jai_constants.tax_type_modvat_recovery) --'TDS', 'Modvat Recovery')
493: and jrlt.vendor_id > 0
494: and jrlt.tax_amount <> 0
495: and jrlt.vendor_id <> p_po_vendor_id
496: and jrlt.vendor_site_id is null;

Line 526: and jrlt.tax_type not in (jai_constants.tax_type_tds,jai_constants.tax_type_modvat_recovery) --'TDS', 'Modvat Recovery')

522: )
523: )
524: and jrt.third_party_flag = 'N'
525: )
526: and jrlt.tax_type not in (jai_constants.tax_type_tds,jai_constants.tax_type_modvat_recovery) --'TDS', 'Modvat Recovery')
527: and jrlt.vendor_id > 0
528: and jrlt.tax_amount <> 0
529: and jrlt.vendor_id <> p_po_vendor_id
530: and jrlt.vendor_site_id is not null

Line 684: and jrtv.tax_type not in (jai_constants.tax_type_tds,jai_constants.tax_type_modvat_recovery) --'TDS', 'Modvat Recovery')

680: )
681: and third_party_flag = 'N'
682:
683: )
684: and jrtv.tax_type not in (jai_constants.tax_type_tds,jai_constants.tax_type_modvat_recovery) --'TDS', 'Modvat Recovery')
685: and jrtv.vendor_id > 0
686: and nvl(jrtv.tax_amount, 0) is not null
687: and jrtv.shipment_header_id = pn_shipment_header_id
688: and jrtv.tax_id = jcta.tax_id

Line 895: and jrtv.tax_type not in (jai_constants.tax_type_tds,jai_constants.tax_type_modvat_recovery) --'TDS', 'Modvat Recovery')

891: )
892: and third_party_flag = 'N'
893:
894: )
895: and jrtv.tax_type not in (jai_constants.tax_type_tds,jai_constants.tax_type_modvat_recovery) --'TDS', 'Modvat Recovery')
896: and jrtv.vendor_id > 0
897: and nvl(jrtv.tax_amount, 0) is not null
898: and jrtv.vendor_id <> r_rcv_transactions.vendor_id /* bug#3957167 */
899: and jrtv.shipment_header_id = p_shipment_header_id

Line 1292: AND jrlt.tax_type NOT IN (jai_constants.tax_type_tds,jai_constants.tax_type_modvat_recovery) --'TDS', 'Modvat Recovery')

1288: )
1289: )
1290: AND jrt.third_party_flag = 'N'
1291: )
1292: AND jrlt.tax_type NOT IN (jai_constants.tax_type_tds,jai_constants.tax_type_modvat_recovery) --'TDS', 'Modvat Recovery')
1293: AND jrlt.vendor_id > 0
1294: AND nvl(jrlt.tax_amount, 0) IS NOT NULL
1295: AND jrlt.vendor_id <> r_rcv_transactions.vendor_id
1296: AND jrlt.vendor_id = c_thirdparty_tax_rec.vendor_id

Line 1488: p_process_flag := jai_constants.successful;

1484: WHERE invoice_num = p_invoice_num
1485: AND vendor_id = p_vendor_id
1486: AND vendor_site_id = p_vendor_site_id;
1487:
1488: p_process_flag := jai_constants.successful;
1489:
1490: EXCEPTION
1491: WHEN OTHERS THEN
1492: p_process_flag := jai_constants.unexpected_error;

Line 1492: p_process_flag := jai_constants.unexpected_error;

1488: p_process_flag := jai_constants.successful;
1489:
1490: EXCEPTION
1491: WHEN OTHERS THEN
1492: p_process_flag := jai_constants.unexpected_error;
1493: p_process_message := substr(sqlerrm,1,1000);
1494:
1495: END;
1496: