DBA Data[Home] [Help]

APPS.JAI_CMN_MTAX_PKG dependencies on STANDARD

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

616: AND (p_org_id IS NULL OR a.org_id = p_org_id);
617:
618: /****************************************
619: PURCHASE ORDERS Fetching Main Cursor for
620: STANDARD, PLANNED_PA, BLANKET_PA, QUOTATION, RFQ
621: ****************************************/
622:
623: /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
624: CURSOR c_main_po( p_org_id IN NUMBER, p_document_type IN VARCHAR2, p_shipment_type IN VARCHAR2,

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

1164:
1165: Base bug - #4245089
1166:
1167: 5. 28/04/2005 rallamse for Bug#4336482, Version 116.1
1168: For SEED there is a change in concurrent "JAINMTCH" to use FND_STANDARD_DATE with STANDARD_DATE format
1169: Procedure ja_in_mass_tax_changes signature modified by converting p_from_date, p_to_date of DATE datatype
1170: to pv_to_date, pv_to_date of varchar2 datatype. The varchar2 values are converted to DATE fromat
1171: using fnd_date.canonical_to_date function.
1172:

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

1182: 2. Cannot insert null into JAI_CMN_MTAX_HDRS_ALL.
1183: Reason and Fix:-
1184: 1. As the concurrent program JAINMCTH does not have the parameter pv_dbms_output hence the reported error.
1185: This parameter was previously added to debug from backend with dbms_output.
1186: However as dbms_out.put_line is not standards compliant hence was modified to fnd_file.put_line
1187: Now as the parameter pv_debug is already present both in the concurrent program registration and the current procedure
1188: hence removed the pv_dbms_output from both spec and body and instead used the pv_debug for capturing the debug info.
1189: This can now be also enabled from conc program.
1190:

Line 1478: IF p_document_type = 'STANDARD_PO' THEN

1474: RETURN;
1475: END IF;
1476:
1477: -- PreProcessing of the Input Variables
1478: IF p_document_type = 'STANDARD_PO' THEN
1479: v_document_type := 'STANDARD';
1480: v_shipment_type := 'STANDARD';
1481: ELSIF p_document_type = 'PLANNED_PA' THEN
1482: v_document_type := 'PLANNED';

Line 1479: v_document_type := 'STANDARD';

1475: END IF;
1476:
1477: -- PreProcessing of the Input Variables
1478: IF p_document_type = 'STANDARD_PO' THEN
1479: v_document_type := 'STANDARD';
1480: v_shipment_type := 'STANDARD';
1481: ELSIF p_document_type = 'PLANNED_PA' THEN
1482: v_document_type := 'PLANNED';
1483: v_shipment_type := 'PLANNED';

Line 1480: v_shipment_type := 'STANDARD';

1476:
1477: -- PreProcessing of the Input Variables
1478: IF p_document_type = 'STANDARD_PO' THEN
1479: v_document_type := 'STANDARD';
1480: v_shipment_type := 'STANDARD';
1481: ELSIF p_document_type = 'PLANNED_PA' THEN
1482: v_document_type := 'PLANNED';
1483: v_shipment_type := 'PLANNED';
1484: ELSIF p_document_type = 'BLANKET_PA' THEN

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

1579: COMMIT;
1580: RETURN;
1581: END IF;
1582:
1583: -- This is for document_type in ('STANDARD', 'QUOTATION', 'RFQ', 'BLANKET' )
1584:
1585: IF p_document_no IS NOT NULL THEN
1586: -- The mass tax change is being run for one(1) PO or SO or RFQ document
1587:

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

1585: IF p_document_no IS NOT NULL THEN
1586: -- The mass tax change is being run for one(1) PO or SO or RFQ document
1587:
1588: IF p_document_type IN ('BLANKET_RELEASES', 'RFQ', 'QUOTATION', 'SCHEDULED_RELEASES',
1589: 'STANDARD_PO', 'PLANNED_PA', 'BLANKET_PA' )
1590: THEN
1591: OPEN c_po_header( v_document_type, p_document_no, v_org_id);
1592: FETCH c_po_header INTO v_po_header_id;
1593: CLOSE c_po_header;

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

1742: END IF;
1743:
1744: -- PURCHASING DOCUMENTS BLOCK
1745: /************
1746: STANDARD, PLANNED, BLANKET_PA, QUOTATION, RFQ
1747: ************/
1748: IF v_shipment_type IN ('STANDARD', 'PRICE BREAK', 'QUOTATION', 'RFQ', 'PLANNED' ) THEN
1749: FOR shipment_rec IN c_main_po( v_org_id, v_document_type, v_shipment_type,
1750: trunc(p_from_date), trunc(p_to_date),

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

1744: -- PURCHASING DOCUMENTS BLOCK
1745: /************
1746: STANDARD, PLANNED, BLANKET_PA, QUOTATION, RFQ
1747: ************/
1748: IF v_shipment_type IN ('STANDARD', 'PRICE BREAK', 'QUOTATION', 'RFQ', 'PLANNED' ) THEN
1749: FOR shipment_rec IN c_main_po( v_org_id, v_document_type, v_shipment_type,
1750: trunc(p_from_date), trunc(p_to_date),
1751: p_supplier_id, p_supplier_site_id, p_old_tax_category,
1752: p_document_no, p_document_line_no, p_shipment_no) --***

Line 2152: p_type => 'STANDARDPO',

2148: */
2149: --recalculate the taxes based on the tax lines that are replaced along with the assessable value of the item
2150: jai_po_tax_pkg.calc_tax
2151: (
2152: p_type => 'STANDARDPO',
2153: p_header_id => shipment_rec.po_header_id,
2154: P_line_id => shipment_rec.po_line_id,
2155: p_line_location_id => v_line_location_id,
2156: p_line_focus_id => shipment_rec.line_focus_id,