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.PO_AUTOCREATE_MAINPROC_PVT dependencies on PO_LINES_INTERFACE

Line 79: FROM po_lines_interface pli ,

75: BULK COLLECT
76: INTO po_line_id_tbl ,
77: draft_id_tbl ,
78: delete_flag_tbl
79: FROM po_lines_interface pli ,
80: po_lines_all pla ,
81: po_headers_interface phi
82: WHERE PLI.interface_header_id = po_autocreate_params.g_interface_header_id
83: AND phi.interface_header_id = PLI.interface_header_id

Line 132: po_lines_interface PLI ,

128: draft_id_tbl ,
129: delete_flag_tbl
130: FROM TABLE(po_line_id_tbl) pl ,
131: po_line_locations_all plla ,
132: po_lines_interface PLI ,
133: po_headers_interface phi
134: WHERE PLI.interface_header_id = po_autocreate_params.g_interface_header_id
135: AND phi.interface_header_id = PLI.interface_header_id
136: AND plla.po_header_id = PhI.po_header_id

Line 478: FROM po_lines_interface pli,

474: 'N', 'N', DECODE(psp.expense_accrual_code,
475: 'PERIOD END', 'N', 'Y')),
476: 'INVENTORY', 'Y', 'SHOP FLOOR', 'Y')
477: INTO x_receipt_required_flag
478: FROM po_lines_interface pli,
479: po_headers_interface phi,
480: po_requisition_lines_all prl, --
481: mtl_system_items msi,
482: po_line_types plt,

Line 527: FROM PO_LINES_INTERFACE PLI,

523: SELECT PLI.shipment_num,
524: PLI.requisition_line_id
525: INTO x_po_shipment_num,
526: x_req_line_to_check
527: FROM PO_LINES_INTERFACE PLI,
528: PO_REQUISITION_LINES_ALL PRL, --
529: --bug 1942696 hr_location changes to reflect the new view
530: MTL_SYSTEM_ITEMS MSI,
531: PO_LINE_TYPES PLT,

Line 617: FROM PO_LINES_INTERFACE PLI,

613: ** interface table matches the shipment you are trying to create.
614: */
615: SELECT PLI.shipment_num
616: INTO x_po_shipment_num
617: FROM PO_LINES_INTERFACE PLI,
618: PO_REQUISITION_LINES_ALL PRL, --
619: MTL_SYSTEM_ITEMS MSI,
620: PO_LINE_TYPES PLT,
621: PO_SYSTEM_PARAMETERS_ALL PSP, --

Line 740: UPDATE po_lines_interface

736: ** line matches the requisition line information.
737: */
738: IF x_requisition_line_id IS NOT NULL THEN
739: l_progress := '010';
740: UPDATE po_lines_interface
741: SET shipment_num = x_po_shipment_num
742: WHERE interface_header_id = x_interface_header_id
743: AND requisition_line_id = x_requisition_line_id;
744: ELSE

Line 746: UPDATE po_lines_interface

742: WHERE interface_header_id = x_interface_header_id
743: AND requisition_line_id = x_requisition_line_id;
744: ELSE
745: l_progress := '015';
746: UPDATE po_lines_interface
747: SET shipment_num = x_po_shipment_num
748: WHERE interface_header_id = x_interface_header_id
749: AND ROWID = x_row_id;
750: END IF;

Line 780: FROM po_lines_interface pli

776:
777: l_progress := '040';
778: SELECT NVL (MAX (line_num), 0)
779: INTO x_int_line_num
780: FROM po_lines_interface pli
781: WHERE pli.interface_header_id = x_interface_header_id;
782:
783: IF (x_line_num >= x_int_line_num) THEN
784: x_line_num := x_line_num;

Line 790: UPDATE po_lines_interface

786: x_line_num := x_int_line_num;
787: END IF;
788:
789: l_progress := '050';
790: UPDATE po_lines_interface
791: SET line_num = x_line_num + 1
792: WHERE interface_header_id = x_interface_header_id
793: AND requisition_line_id = x_requisition_line_id;
794:

Line 813: FROM po_lines_interface pli

809: ** assigned in the interface table.
810: */
811: SELECT NVL (MAX (shipment_num), 0)
812: INTO x_int_shipment_num
813: FROM po_lines_interface pli
814: WHERE pli.interface_header_id = x_interface_header_id
815: AND pli.line_num = x_po_line_num;
816: END IF; -- create new line
817:

Line 844: FROM po_lines_interface pli

840: ** assigned in the interface table.
841: */
842: SELECT NVL (MAX (shipment_num), 0)
843: INTO x_int_shipment_num
844: FROM po_lines_interface pli
845: WHERE pli.interface_header_id = x_interface_header_id;
846:
847: END IF;
848:

Line 859: UPDATE po_lines_interface

855:
856: IF x_requisition_line_id IS NOT NULL THEN
857:
858: l_progress := '110';
859: UPDATE po_lines_interface
860: SET shipment_num = x_shipment_num + 1
861: WHERE interface_header_id = x_interface_header_id
862: AND requisition_line_id = x_requisition_line_id;
863:

Line 867: UPDATE po_lines_interface

863:
864: ELSE
865:
866: l_progress := '120';
867: UPDATE po_lines_interface
868: SET shipment_num = x_shipment_num + 1
869: WHERE interface_header_id = x_interface_header_id
870: AND ROWID = x_row_id;
871:

Line 1141: x_vmi_flag po_lines_interface.vmi_flag%TYPE;

1137: x_clm_funded_flag VARCHAR2 (1);
1138: x_clm_base_line_num NUMBER;
1139: l_int_line_num NUMBER;
1140: l_is_priced_slin VARCHAR2 (1);
1141: x_vmi_flag po_lines_interface.vmi_flag%TYPE;
1142: x_drop_ship_flag po_lines_interface.drop_ship_flag%TYPE;
1143: x_source_doc_id NUMBER;
1144: x_source_doc_line_id NUMBER;
1145: x_consigned_flag VARCHAR2 (1) := 'N';

Line 1142: x_drop_ship_flag po_lines_interface.drop_ship_flag%TYPE;

1138: x_clm_base_line_num NUMBER;
1139: l_int_line_num NUMBER;
1140: l_is_priced_slin VARCHAR2 (1);
1141: x_vmi_flag po_lines_interface.vmi_flag%TYPE;
1142: x_drop_ship_flag po_lines_interface.drop_ship_flag%TYPE;
1143: x_source_doc_id NUMBER;
1144: x_source_doc_line_id NUMBER;
1145: x_consigned_flag VARCHAR2 (1) := 'N';
1146: x_create_new_line VARCHAR2 (1) := 'N';

Line 1147: l_supplier_ref_number po_lines_interface.supplier_ref_number%TYPE;

1143: x_source_doc_id NUMBER;
1144: x_source_doc_line_id NUMBER;
1145: x_consigned_flag VARCHAR2 (1) := 'N';
1146: x_create_new_line VARCHAR2 (1) := 'N';
1147: l_supplier_ref_number po_lines_interface.supplier_ref_number%TYPE;
1148: l_contract_id po_lines_all.contract_id%TYPE;
1149: l_needby_prf VARCHAR2 (1);
1150: l_shipto_prf VARCHAR2 (1);
1151: x_contract_type VARCHAR2 (100);

Line 1167: FROM po_lines_interface pli

1163: */
1164: CURSOR interface_lines_temp
1165: IS
1166: SELECT pli.requisition_line_id
1167: FROM po_lines_interface pli
1168: WHERE pli.interface_header_id = x_interface_header_id
1169: ORDER BY pli.requisition_line_id;
1170: CURSOR intf_sourcing_lines
1171: IS

Line 1173: FROM po_lines_interface pli

1169: ORDER BY pli.requisition_line_id;
1170: CURSOR intf_sourcing_lines
1171: IS
1172: SELECT ROWID
1173: FROM po_lines_interface pli
1174: WHERE interface_header_id = po_autocreate_params.g_interface_header_id
1175: ORDER BY bid_line_number;
1176:
1177: l_sourcing_temp_num NUMBER :=1;

Line 1219: FROM po_lines_interface pli,

1215: pli.clm_funded_flag ,
1216: pli.clm_base_line_num ,
1217: PLI.contract_Type ,
1218: pli.receipt_required_flag
1219: FROM po_lines_interface pli,
1220: po_distributions_interface pld
1221: WHERE pli.interface_header_id =x_interface_header_id
1222: AND pli.interface_line_id =pld.interface_line_id
1223: AND pld.interface_distribution_id =

Line 1270: FROM po_lines_interface pli

1266: pli.clm_funded_flag ,
1267: pli.clm_base_line_num ,
1268: PLI.contract_Type ,
1269: pli.receipt_required_flag
1270: FROM po_lines_interface pli
1271: WHERE pli.interface_header_id=x_interface_header_id
1272: AND NOT EXISTS
1273: (SELECT 'x'
1274: FROM po_distributions_interface pdi2

Line 1342: UPDATE po_lines_interface pli

1338: IF (fnd_profile.VALUE ('PO_USE_REQ_NUM_IN_AUTOCREATE') = 'Y' AND po_autocreate_params.g_interface_source_code <> 'SOURCING') THEN
1339:
1340: -- use requisition numbers
1341: l_progress := '035';
1342: UPDATE po_lines_interface pli
1343: SET pli.line_num =
1344: (SELECT prl.line_num
1345: FROM po_requisition_lines_all prl
1346: WHERE prl.requisition_line_id = pli.requisition_line_id

Line 1353: UPDATE po_lines_interface pli

1349: AND pli.line_num IS NULL
1350: AND pli.shipment_num IS NULL;
1351:
1352: l_progress := '036';
1353: UPDATE po_lines_interface pli
1354: SET pli.shipment_num = 1
1355: WHERE pli.interface_header_id = x_interface_header_id
1356: AND pli.shipment_num IS NULL
1357: AND NVL (pli.clm_info_flag, 'N') ='N'

Line 1373: UPDATE po_lines_interface pli

1369: EXIT
1370: WHEN interface_lines_temp%NOTFOUND;
1371:
1372: l_progress := '050';
1373: UPDATE po_lines_interface pli
1374: SET pli.line_num = x_count
1375: WHERE pli.requisition_line_id = x_requisition_line_id
1376: AND pli.interface_header_id = x_interface_header_id
1377: AND pli.line_num IS NULL

Line 1381: UPDATE po_lines_interface pli

1377: AND pli.line_num IS NULL
1378: AND pli.shipment_num IS NULL;
1379:
1380: l_progress := '051';
1381: UPDATE po_lines_interface pli
1382: SET pli.shipment_num = 1
1383: WHERE pli.requisition_line_id = x_requisition_line_id
1384: AND pli.interface_header_id = x_interface_header_id
1385: AND pli.shipment_num IS NULL

Line 1398: UPDATE po_lines_interface

1394: l_progress := '052';
1395: FOR l_rec IN intf_sourcing_lines
1396: LOOP
1397:
1398: UPDATE po_lines_interface
1399: SET line_num = l_sourcing_temp_num
1400: WHERE rowid = l_rec.ROWID;
1401: UPDATE po_lines_interface
1402: SET shipment_num = 1

Line 1401: UPDATE po_lines_interface

1397:
1398: UPDATE po_lines_interface
1399: SET line_num = l_sourcing_temp_num
1400: WHERE rowid = l_rec.ROWID;
1401: UPDATE po_lines_interface
1402: SET shipment_num = 1
1403: WHERE rowid = l_rec.ROWID
1404: AND shipment_num IS NULL
1405: AND NVL (clm_info_flag, 'N') = 'N';

Line 1448: UPDATE po_lines_interface pli

1444: EXIT
1445: WHEN interface_lines_temp%NOTFOUND;
1446:
1447: l_progress := '150';
1448: UPDATE po_lines_interface pli
1449: SET pli.line_num = x_line_num + x_count
1450: WHERE pli.requisition_line_id = x_requisition_line_id
1451: AND pli.interface_header_id = x_interface_header_id
1452: AND pli.line_num IS NULL

Line 1456: UPDATE po_lines_interface pli

1452: AND pli.line_num IS NULL
1453: AND pli.shipment_num IS NULL;
1454:
1455: l_progress := '151';
1456: UPDATE po_lines_interface pli
1457: SET pli.shipment_num = 1
1458: WHERE pli.requisition_line_id = x_requisition_line_id
1459: AND pli.interface_header_id = x_interface_header_id
1460: AND pli.shipment_num IS NULL

Line 1482: FROM po_lines_interface pli

1478: --
1479: -- Get maximum line number in interface table, to be used later
1480: SELECT NVL (MAX (pli.line_num), 0)
1481: INTO l_max_iface_line_num
1482: FROM po_lines_interface pli
1483: WHERE pli.interface_header_id = x_interface_header_id;
1484:
1485: --
1486: OPEN interface_lines;

Line 1550: UPDATE po_lines_interface pli

1546: -- will be set to REQUISITION and so lines will not be grouped.
1547: -- when coming from sourcing, however, the group type is set
1548: -- to DEFAULT.
1549: -- Do not group; simply add 1 to each successive interface line
1550: UPDATE po_lines_interface pli
1551: SET pli.line_num = l_max_iface_line_num + 1
1552: WHERE pli.ROWID = x_row_id
1553: AND pli.line_num IS NULL;
1554:

Line 1560: for all priced lines in the po_lines_interface table

1556: l_max_iface_line_num := l_max_iface_line_num + 1;
1557: END IF;
1558:
1559: /*Bug 13588855: The shipment_num also needs to be stamped as 1
1560: for all priced lines in the po_lines_interface table
1561: */
1562:
1563: UPDATE po_lines_interface pli
1564: SET pli.shipment_num = 1

Line 1563: UPDATE po_lines_interface pli

1559: /*Bug 13588855: The shipment_num also needs to be stamped as 1
1560: for all priced lines in the po_lines_interface table
1561: */
1562:
1563: UPDATE po_lines_interface pli
1564: SET pli.shipment_num = 1
1565: WHERE pli.interface_header_id = x_interface_header_id
1566: AND pli.shipment_num IS NULL
1567: AND NVL (pli.clm_info_flag, 'N') = 'N';

Line 1591: FROM po_lines_interface pli

1587:
1588: l_progress := '251';
1589: SELECT NVL (MAX (line_num), 0)
1590: INTO l_int_line_num
1591: FROM po_lines_interface pli
1592: WHERE pli.interface_header_id = x_interface_header_id;
1593:
1594: l_progress := '252';
1595: UPDATE po_lines_interface

Line 1595: UPDATE po_lines_interface

1591: FROM po_lines_interface pli
1592: WHERE pli.interface_header_id = x_interface_header_id;
1593:
1594: l_progress := '252';
1595: UPDATE po_lines_interface
1596: SET line_num = l_int_line_num + 1
1597: WHERE interface_header_id = x_interface_header_id
1598: AND requisition_line_id = x_requisition_line_id
1599: AND line_num IS NULL; --Updating line nums only when they are null, else honor the line nums from interface table

Line 1891: FROM po_lines_interface pli,

1887: -- SQL Why: Want to group matching lines onto PO documents.
1888: -- SQL Join: business logic for combining two lines
1889: SELECT MIN (pli.line_num)
1890: INTO x_po_line_num
1891: FROM po_lines_interface pli,
1892: po_requisition_lines_all prl,
1893: po_line_types_b plt --
1894: WHERE pli.interface_header_id = x_interface_header_id
1895: AND pli.line_num IS NOT NULL

Line 2022: UPDATE po_lines_interface pli

2018: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress,
2019: p_message => 'Before update line_num: Line Id:'||x_requisition_line_id||' Line Num:'||x_po_line_num );
2020: END IF;
2021:
2022: UPDATE po_lines_interface pli
2023: SET pli.line_num = x_po_line_num
2024: WHERE pli.interface_header_id = x_interface_header_id
2025: AND pli.requisition_line_id = x_requisition_line_id;
2026:

Line 2074: UPDATE po_lines_interface pli2

2070: --group them to a single line. Also no need to select from
2071: --po_lines table as we are not supporting add to functionality.
2072:
2073: l_progress := '400';
2074: UPDATE po_lines_interface pli2
2075: SET
2076: (
2077: pli2.line_num,
2078: pli2.shipment_num

Line 2083: FROM po_lines_interface pli

2079: )
2080: =
2081: (SELECT (NVL (MAX (pli.line_num), 0) + 1),
2082: 1
2083: FROM po_lines_interface pli
2084: WHERE pli.interface_header_id = x_interface_header_id
2085: )
2086: WHERE pli2.ROWID = x_row_id;
2087:

Line 2117: p_message => 'Before select max line_num from po_lines_interface' );

2113: -- Get the max line number already assigne in the interface table
2114: l_progress := '420';
2115: IF g_debug_stmt THEN
2116: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress,
2117: p_message => 'Before select max line_num from po_lines_interface' );
2118: END IF;
2119:
2120: SELECT NVL (MAX (pli.line_num), 0)
2121: INTO l_int_line_num

Line 2122: FROM po_lines_interface pli

2118: END IF;
2119:
2120: SELECT NVL (MAX (pli.line_num), 0)
2121: INTO l_int_line_num
2122: FROM po_lines_interface pli
2123: WHERE pli.interface_header_id = x_interface_header_id;
2124:
2125: IF (x_line_num >= l_int_line_num) THEN
2126: x_line_num := x_line_num;

Line 2140: UPDATE po_lines_interface pli

2136: p_message => 'Sourcing to PO: Update Line Num : x_line_num : '|| x_line_num );
2137: END IF;
2138:
2139: IF (x_requisition_line_id IS NOT NULL) THEN
2140: UPDATE po_lines_interface pli
2141: SET pli.line_num = x_line_num + 1
2142: WHERE pli.interface_header_id = x_interface_header_id
2143: AND pli.requisition_line_id = x_requisition_line_id;
2144: UPDATE po_lines_interface pli

Line 2144: UPDATE po_lines_interface pli

2140: UPDATE po_lines_interface pli
2141: SET pli.line_num = x_line_num + 1
2142: WHERE pli.interface_header_id = x_interface_header_id
2143: AND pli.requisition_line_id = x_requisition_line_id;
2144: UPDATE po_lines_interface pli
2145: SET pli.shipment_num = 1
2146: WHERE pli.interface_header_id = x_interface_header_id
2147: AND pli.requisition_line_id = x_requisition_line_id
2148: AND NVL (pli.clm_info_flag, 'N') = 'N'

Line 2154: UPDATE po_lines_interface pli

2150: AND pli.clm_base_line_num IS NULL;
2151: -- Normal/Base Line
2152: ELSE
2153: -- no backing req line; use rowid
2154: UPDATE po_lines_interface pli
2155: SET pli.line_num = x_line_num + 1,
2156: pli.shipment_num = 1
2157: WHERE pli.ROWID = x_row_id;
2158: END IF; -- if x_requisition_id is not null

Line 2194: DESC: Handle the logic to derive, default, validate records from po_lines_interface

2190: END group_interface_records;
2191:
2192: /* ============================================================================
2193: NAME: process_lines
2194: DESC: Handle the logic to derive, default, validate records from po_lines_interface
2195: table and insert records into po_lines_draft_all table.
2196: PO_AUTO_LINE_PROCESS_PVT.fetch_lines
2197: PO_AUTO_LINE_PROCESS_PVT.derive_and_default_lines
2198: PO_AUTO_LINE_PROCESS_PVT.validate_lines (Is this required??)