eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_CMN_MTAX_PKG dependencies on STANDARD

Line 483: STANDARD, PLANNED_PA, BLANKET_PA, QUOTATION, RFQ

479: AND (p_org_id IS NULL OR a.org_id = p_org_id);
480:
481: /****************************************
482: PURCHASE ORDERS Fetching Main Cursor for
483: STANDARD, PLANNED_PA, BLANKET_PA, QUOTATION, RFQ
484: ****************************************/
485:
486: /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
487: CURSOR c_main_po( p_org_id IN NUMBER, p_document_type IN VARCHAR2, p_shipment_type IN VARCHAR2,

Line 838: For SEED there is a change in concurrent "JAINMTCH" to use FND_STANDARD_DATE with STANDARD_DATE format

834:
835: Base bug - #4245089
836:
837: 5. 28/04/2005 rallamse for Bug#4336482, Version 116.1
838: For SEED there is a change in concurrent "JAINMTCH" to use FND_STANDARD_DATE with STANDARD_DATE format
839: Procedure ja_in_mass_tax_changes signature modified by converting p_from_date, p_to_date of DATE datatype
840: to pv_to_date, pv_to_date of varchar2 datatype. The varchar2 values are converted to DATE fromat
841: using fnd_date.canonical_to_date function.
842:

Line 856: However as dbms_out.put_line is not standards compliant hence was modified to fnd_file.put_line

852: 2. Cannot insert null into JAI_CMN_MTAX_HDRS_ALL.
853: Reason and Fix:-
854: 1. As the concurrent program JAINMCTH does not have the parameter pv_dbms_output hence the reported error.
855: This parameter was previously added to debug from backend with dbms_output.
856: However as dbms_out.put_line is not standards compliant hence was modified to fnd_file.put_line
857: Now as the parameter pv_debug is already present both in the concurrent program registration and the current procedure
858: hence removed the pv_dbms_output from both spec and body and instead used the pv_debug for capturing the debug info.
859: This can now be also enabled from conc program.
860:

Line 1124: IF p_document_type = 'STANDARD_PO' THEN

1120: RETURN;
1121: END IF;
1122:
1123: -- PreProcessing of the Input Variables
1124: IF p_document_type = 'STANDARD_PO' THEN
1125: v_document_type := 'STANDARD';
1126: v_shipment_type := 'STANDARD';
1127: ELSIF p_document_type = 'PLANNED_PA' THEN
1128: v_document_type := 'PLANNED';

Line 1125: v_document_type := 'STANDARD';

1121: END IF;
1122:
1123: -- PreProcessing of the Input Variables
1124: IF p_document_type = 'STANDARD_PO' THEN
1125: v_document_type := 'STANDARD';
1126: v_shipment_type := 'STANDARD';
1127: ELSIF p_document_type = 'PLANNED_PA' THEN
1128: v_document_type := 'PLANNED';
1129: v_shipment_type := 'PLANNED';

Line 1126: v_shipment_type := 'STANDARD';

1122:
1123: -- PreProcessing of the Input Variables
1124: IF p_document_type = 'STANDARD_PO' THEN
1125: v_document_type := 'STANDARD';
1126: v_shipment_type := 'STANDARD';
1127: ELSIF p_document_type = 'PLANNED_PA' THEN
1128: v_document_type := 'PLANNED';
1129: v_shipment_type := 'PLANNED';
1130: ELSIF p_document_type = 'BLANKET_PA' THEN

Line 1222: -- This is for document_type in ('STANDARD', 'QUOTATION', 'RFQ', 'BLANKET' )

1218: COMMIT;
1219: RETURN;
1220: END IF;
1221:
1222: -- This is for document_type in ('STANDARD', 'QUOTATION', 'RFQ', 'BLANKET' )
1223:
1224: IF p_document_no IS NOT NULL THEN
1225: -- The mass tax change is being run for one(1) PO or SO or RFQ document
1226:

Line 1228: 'STANDARD_PO', 'PLANNED_PA', 'BLANKET_PA' )

1224: IF p_document_no IS NOT NULL THEN
1225: -- The mass tax change is being run for one(1) PO or SO or RFQ document
1226:
1227: IF p_document_type IN ('BLANKET_RELEASES', 'RFQ', 'QUOTATION', 'SCHEDULED_RELEASES',
1228: 'STANDARD_PO', 'PLANNED_PA', 'BLANKET_PA' )
1229: THEN
1230: OPEN c_po_header( v_document_type, p_document_no, v_org_id);
1231: FETCH c_po_header INTO v_po_header_id;
1232: CLOSE c_po_header;

Line 1347: STANDARD, PLANNED, BLANKET_PA, QUOTATION, RFQ

1343: END IF;
1344:
1345: -- PURCHASING DOCUMENTS BLOCK
1346: /************
1347: STANDARD, PLANNED, BLANKET_PA, QUOTATION, RFQ
1348: ************/
1349: IF v_shipment_type IN ('STANDARD', 'PRICE BREAK', 'QUOTATION', 'RFQ', 'PLANNED' ) THEN
1350: FOR shipment_rec IN c_main_po( v_org_id, v_document_type, v_shipment_type,
1351: trunc(p_from_date), trunc(p_to_date),

Line 1349: IF v_shipment_type IN ('STANDARD', 'PRICE BREAK', 'QUOTATION', 'RFQ', 'PLANNED' ) THEN

1345: -- PURCHASING DOCUMENTS BLOCK
1346: /************
1347: STANDARD, PLANNED, BLANKET_PA, QUOTATION, RFQ
1348: ************/
1349: IF v_shipment_type IN ('STANDARD', 'PRICE BREAK', 'QUOTATION', 'RFQ', 'PLANNED' ) THEN
1350: FOR shipment_rec IN c_main_po( v_org_id, v_document_type, v_shipment_type,
1351: trunc(p_from_date), trunc(p_to_date),
1352: p_supplier_id, p_supplier_site_id, p_old_tax_category,
1353: p_document_no, p_document_line_no, p_shipment_no) --***

Line 1734: p_type => 'STANDARDPO',

1730:
1731: --recalculate the taxes based on the tax lines that are replaced along with the assessable value of the item
1732: jai_po_tax_pkg.calc_tax
1733: (
1734: p_type => 'STANDARDPO',
1735: p_header_id => shipment_rec.po_header_id,
1736: P_line_id => shipment_rec.po_line_id,
1737: p_line_location_id => v_line_location_id,
1738: p_line_focus_id => shipment_rec.line_focus_id,