[Home] [Help]
262:
263: -----------------------------------------------------------------------
264: --Start of Comments
265: --Name: reject_dup_lines_for_spo
266: --Function: standard po lines cannot be updated. So if the new line in
267: -- interface table has the same line num as existing lines in
268: -- same document, these new lines will be regarded as intention
269: -- to update existing standard po records thus rejected.
270: --Parameters:
284: p_request_processing_round_num NUMBER) IS
285: SELECT intf_headers.interface_header_id,
286: intf_lines.interface_line_id,
287: intf_lines.line_num
288: FROM po_lines_interface intf_lines,
289: po_headers_interface intf_headers,
290: po_lines txn_lines
291: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
292: AND intf_headers.po_header_id = txn_lines.po_header_id
286: intf_lines.interface_line_id,
287: intf_lines.line_num
288: FROM po_lines_interface intf_lines,
289: po_headers_interface intf_headers,
290: po_lines txn_lines
291: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
292: AND intf_headers.po_header_id = txn_lines.po_header_id
293: AND intf_lines.processing_id = p_request_processing_id
294: AND intf_headers.processing_round_num = p_request_processing_round_num
302: SELECT intf_headers.interface_header_id,
303: intf_lines.interface_line_id,
304: intf_lines.line_num
305: FROM po_headers_interface intf_headers,
306: po_lines_interface intf_lines,
307: po_lines_draft_all draft_lines
308: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
309: AND intf_headers.draft_id = draft_lines.draft_id
310: AND intf_headers.po_header_id = draft_lines.po_header_id
303: intf_lines.interface_line_id,
304: intf_lines.line_num
305: FROM po_headers_interface intf_headers,
306: po_lines_interface intf_lines,
307: po_lines_draft_all draft_lines
308: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
309: AND intf_headers.draft_id = draft_lines.draft_id
310: AND intf_headers.po_header_id = draft_lines.po_header_id
311: AND intf_lines.processing_id = p_request_processing_id
367: (
368: p_interface_header_id => l_dup_intf_header_id_tbl(i),
369: p_interface_line_id => l_dup_intf_line_id_tbl(i),
370: p_error_message_name => 'PO_PDOI_STD_PO_LINE_NUM_EXISTS',
371: p_table_name => 'PO_LINES_INTERFACE',
372: p_column_name => 'LINE_NUM',
373: p_column_value => l_dup_intf_line_num_tbl(i),
374: p_token1_name => 'VALUE',
375: p_token1_value => l_dup_intf_line_num_tbl(i)
436: (
437: p_interface_header_id => l_dup_intf_header_id_tbl(i),
438: p_interface_line_id => l_dup_intf_line_id_tbl(i),
439: p_error_message_name => 'PO_PDOI_STD_PO_LINE_NUM_EXISTS',
440: p_table_name => 'PO_LINES_INTERFACE',
441: p_column_name => 'LINE_NUM',
442: p_column_value => l_dup_intf_line_num_tbl(i),
443: p_token1_name => 'VALUE',
444: p_token1_value => l_dup_intf_line_num_tbl(i)
503: p_request_processing_round_num NUMBER) IS
504: SELECT intf_lines.interface_line_id,
505: intf_headers.interface_header_id,
506: intf_lines.action
507: FROM po_lines_interface intf_lines,
508: po_headers_interface intf_headers
509: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
510: AND intf_lines.processing_id = p_request_processing_id
511: AND intf_headers.processing_round_num = p_request_processing_round_num
556: (
557: p_interface_header_id => l_rej_intf_header_id_tbl(i),
558: p_interface_line_id => l_rej_intf_line_id_tbl(i),
559: p_error_message_name => 'PO_PDOI_INVALID_ACTION',
560: p_table_name => 'PO_LINES_INTERFACE',
561: p_column_name => 'ACTION',
562: p_column_value => l_rej_line_action_tbl(i),
563: p_token1_name => 'VALUE',
564: p_token1_value => l_rej_line_action_tbl(i)
753: -1, -- group_num
754: NULL, -- origin_line_num
755: FND_API.g_FALSE, -- match_line_found
756: NULL -- allow_desc_update_flag_tbl
757: FROM po_lines_interface intf_lines,
758: po_headers_interface intf_headers,
759: po_headers_draft_all draft_headers
760: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
761: AND intf_headers.draft_id = draft_headers.draft_id
886: -1, -- group_num
887: NULL, -- origin_line_num
888: FND_API.g_FALSE, -- match_line_found
889: NULL -- allow_desc_update_flag_tbl
890: FROM po_lines_interface intf_lines,
891: po_headers_interface intf_headers,
892: po_headers txn_headers
893: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
894: AND intf_headers.po_header_id = txn_headers.po_header_id
1020: -1, -- group_num
1021: NULL, -- origin_line_num
1022: FND_API.g_FALSE, -- match_line_found
1023: NULL -- allow_desc_update_flag_tbl
1024: FROM po_lines_interface intf_lines,
1025: po_headers_interface intf_headers,
1026: po_headers txn_headers
1027: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
1028: AND intf_headers.po_header_id = txn_headers.po_header_id
1157: -1, -- group_num
1158: NULL, -- origin_line_num
1159: FND_API.g_FALSE, -- match_line_found
1160: NULL -- allow_desc_update_flag_tbl
1161: FROM po_lines_interface intf_lines,
1162: po_headers_interface intf_headers,
1163: po_headers txn_headers
1164: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
1165: AND intf_headers.po_header_id = txn_headers.po_header_id
1298: -1, -- group_num
1299: NULL, -- origin_line_num
1300: FND_API.g_FALSE, -- match_line_found
1301: NULL -- allow_desc_update_flag_tbl
1302: FROM po_lines_interface intf_lines,
1303: po_headers_interface intf_headers,
1304: po_headers txn_headers
1305: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
1306: AND intf_headers.po_header_id = txn_headers.po_header_id
1726: (
1727: p_interface_header_id => x_lines.intf_header_id_tbl(i),
1728: p_interface_line_id => x_lines.intf_line_id_tbl(i),
1729: p_error_message_name => 'PO_PDOI_DERV_PART_NUM_ERROR',
1730: p_table_name => 'PO_LINES_INTERFACE',
1731: p_column_name => NULL,
1732: p_column_value => NULL,
1733: p_validation_id => PO_VAL_CONSTANTS.c_part_num_derv,
1734: p_lines => x_lines
1750: (
1751: p_interface_header_id => x_lines.intf_header_id_tbl(i),
1752: p_interface_line_id => x_lines.intf_line_id_tbl(i),
1753: p_error_message_name => 'PO_PDOI_DERV_ERROR',
1754: p_table_name => 'PO_LINES_INTERFACE',
1755: p_column_name => 'JOB_BUSINESS_GROUP_ID',
1756: p_column_value => x_lines.job_business_group_id_tbl(i),
1757: p_token1_name => 'COLUMN_NAME',
1758: p_token1_value => 'JOB_BUSINESS_GROUP_NAME',
1773: (
1774: p_interface_header_id => x_lines.intf_header_id_tbl(i),
1775: p_interface_line_id => x_lines.intf_line_id_tbl(i),
1776: p_error_message_name => 'PO_PDOI_DERV_ERROR',
1777: p_table_name => 'PO_LINES_INTERFACE',
1778: p_column_name => 'JOB_ID',
1779: p_column_value => x_lines.job_id_tbl(i),
1780: p_token1_name => 'COLUMN_NAME',
1781: p_token1_value => 'JOB_NAME',
1801: (
1802: p_interface_header_id => x_lines.intf_header_id_tbl(i),
1803: p_interface_line_id => x_lines.intf_line_id_tbl(i),
1804: p_error_message_name => 'PO_PDOI_DERV_ERROR',
1805: p_table_name => 'PO_LINES_INTERFACE',
1806: p_column_name => 'CATEGORY_ID',
1807: p_column_value => x_lines.category_id_tbl(i),
1808: p_token1_name => 'COLUMN_NAME',
1809: p_token1_value => 'CATEGORY',
1832: (
1833: p_interface_header_id => x_lines.intf_header_id_tbl(i),
1834: p_interface_line_id => x_lines.intf_line_id_tbl(i),
1835: p_error_message_name => 'PO_PDOI_DERV_ERROR',
1836: p_table_name => 'PO_LINES_INTERFACE',
1837: p_column_name => 'IP_CATEGORY_ID',
1838: p_column_value => x_lines.ip_category_id_tbl(i),
1839: p_token1_name => 'COLUMN_NAME',
1840: p_token1_value => 'IP_CATEGORY',
1861: (
1862: p_interface_header_id => x_lines.intf_header_id_tbl(i),
1863: p_interface_line_id => x_lines.intf_line_id_tbl(i),
1864: p_error_message_name => 'PO_PDOI_DERV_ERROR',
1865: p_table_name => 'PO_LINES_INTERFACE',
1866: p_column_name => 'UNIT_OF_MEASURE',
1867: p_column_value => x_lines.unit_of_measure_tbl(i),
1868: p_token1_name => 'COLUMN_NAME',
1869: p_token1_value => 'UOM_CODE',
1889: (
1890: p_interface_header_id => x_lines.intf_header_id_tbl(i),
1891: p_interface_line_id => x_lines.intf_line_id_tbl(i),
1892: p_error_message_name => 'PO_PDOI_DERV_ERROR',
1893: p_table_name => 'PO_LINES_INTERFACE',
1894: p_column_name => 'LINE_TYPE_ID',
1895: p_column_value => x_lines.line_type_id_tbl(i),
1896: p_token1_name => 'COLUMN_NAME',
1897: p_token1_value => 'LINE_TYPE',
1917: (
1918: p_interface_header_id => x_lines.intf_header_id_tbl(i),
1919: p_interface_line_id => x_lines.intf_line_id_tbl(i),
1920: p_error_message_name => 'PO_PDOI_DERV_ERROR',
1921: p_table_name => 'PO_LINES_INTERFACE',
1922: p_column_name => 'UN_NUMBER_ID',
1923: p_column_value => x_lines.un_number_id_tbl(i),
1924: p_token1_name => 'COLUMN_NAME',
1925: p_token1_value => 'UN_NUMBER',
1943: (
1944: p_interface_header_id => x_lines.intf_header_id_tbl(i),
1945: p_interface_line_id => x_lines.intf_line_id_tbl(i),
1946: p_error_message_name => 'PO_PDOI_DERV_ERROR',
1947: p_table_name => 'PO_LINES_INTERFACE',
1948: p_column_name => 'HAZARD_CLASS_ID',
1949: p_column_value => x_lines.hazard_class_id_tbl(i),
1950: p_token1_name => 'COLUMN_NAME',
1951: p_token1_value => 'HAZARD_CLASS',
1969: (
1970: p_interface_header_id => x_lines.intf_header_id_tbl(i),
1971: p_interface_line_id => x_lines.intf_line_id_tbl(i),
1972: p_error_message_name => 'PO_PDOI_DERV_ERROR',
1973: p_table_name => 'PO_LINES_INTERFACE',
1974: p_column_name => 'TEMPLATE_ID',
1975: p_column_value => x_lines.template_id_tbl(i),
1976: p_token1_name => 'COLUMN_NAME',
1977: p_token1_value => 'TEMPLATE_NAME',
2127: (
2128: p_interface_header_id => x_lines.intf_header_id_tbl(i),
2129: p_interface_line_id => x_lines.intf_line_id_tbl(i),
2130: p_error_message_name => 'PO_PDOI_DERV_ERROR',
2131: p_table_name => 'PO_LINES_INTERFACE',
2132: p_column_name => 'CATEGORY_ID',
2133: p_column_value => x_lines.category_id_tbl(i),
2134: p_token1_name => 'COLUMN_NAME',
2135: p_token1_value => 'CATEGORY',
2156: (
2157: p_interface_header_id => x_lines.intf_header_id_tbl(i),
2158: p_interface_line_id => x_lines.intf_line_id_tbl(i),
2159: p_error_message_name => 'PO_PDOI_DERV_ERROR',
2160: p_table_name => 'PO_LINES_INTERFACE',
2161: p_column_name => 'IP_CATEGORY_ID',
2162: p_column_value => x_lines.ip_category_id_tbl(i),
2163: p_token1_name => 'COLUMN_NAME',
2164: p_token1_value => 'IP_CATEGORY',
2183: (
2184: p_interface_header_id => x_lines.intf_header_id_tbl(i),
2185: p_interface_line_id => x_lines.intf_line_id_tbl(i),
2186: p_error_message_name => 'PO_PDOI_DERV_ERROR',
2187: p_table_name => 'PO_LINES_INTERFACE',
2188: p_column_name => 'UNIT_OF_MEASURE',
2189: p_column_value => x_lines.unit_of_measure_tbl(i),
2190: p_token1_name => 'COLUMN_NAME',
2191: p_token1_value => 'UOM_CODE',
2691: l_num_list(i),
2692: order_type_lookup_code,
2693: item_id,
2694: job_id
2695: FROM po_lines_draft_all
2696: WHERE po_line_id = x_lines.po_line_id_tbl(i)
2697: AND draft_id = x_lines.draft_id_tbl(i);
2698:
2699: d_position := 20;
2705: l_num_list(i),
2706: order_type_lookup_code,
2707: item_id,
2708: job_id
2709: FROM po_lines_all
2710: WHERE po_line_id = x_lines.po_line_id_tbl(i)
2711: AND NOT EXISTS (SELECT 1
2712: FROM po_lines_draft_all
2713: WHERE po_line_id = x_lines.po_line_id_tbl(i)
2708: job_id
2709: FROM po_lines_all
2710: WHERE po_line_id = x_lines.po_line_id_tbl(i)
2711: AND NOT EXISTS (SELECT 1
2712: FROM po_lines_draft_all
2713: WHERE po_line_id = x_lines.po_line_id_tbl(i)
2714: AND draft_id = x_lines.draft_id_tbl(i));
2715:
2716: d_position := 30;
2881: x_lines := l_create_lines;
2882:
2883: -- update location only lines with new po_line_id and price_break_flag
2884: FORALL i IN 1..l_update_lines.rec_count
2885: UPDATE po_lines_interface
2886: SET po_line_id = l_update_lines.po_line_id_tbl(i),
2887: price_break_flag = 'Y'
2888: WHERE interface_line_id = l_update_lines.intf_line_id_tbl(i);
2889:
2905: (
2906: p_interface_header_id => l_update_lines.intf_header_id_tbl(i),
2907: p_interface_line_id => l_update_lines.intf_line_id_tbl(i),
2908: p_error_message_name => 'PO_PDOI_INVALID_INTER_LINE_REC',
2909: p_table_name => 'PO_LINES_INTERFACE',
2910: p_column_name => 'CREATE_PO_LINES_FLAG',
2911: p_column_value => 'N',
2912: p_token1_name => 'COLUMN_NAME',
2913: p_token1_value => 'CREATE_PO_LINES_FLAG',
2906: p_interface_header_id => l_update_lines.intf_header_id_tbl(i),
2907: p_interface_line_id => l_update_lines.intf_line_id_tbl(i),
2908: p_error_message_name => 'PO_PDOI_INVALID_INTER_LINE_REC',
2909: p_table_name => 'PO_LINES_INTERFACE',
2910: p_column_name => 'CREATE_PO_LINES_FLAG',
2911: p_column_value => 'N',
2912: p_token1_name => 'COLUMN_NAME',
2913: p_token1_value => 'CREATE_PO_LINES_FLAG',
2914: p_token2_name => 'VALUE',
2909: p_table_name => 'PO_LINES_INTERFACE',
2910: p_column_name => 'CREATE_PO_LINES_FLAG',
2911: p_column_value => 'N',
2912: p_token1_name => 'COLUMN_NAME',
2913: p_token1_value => 'CREATE_PO_LINES_FLAG',
2914: p_token2_name => 'VALUE',
2915: p_token2_value => 'N'
2916: );
2917:
3144:
3145: d_position := 20;
3146:
3147: FORALL i IN 1.. x_lines.rec_count
3148: UPDATE po_lines_interface
3149: SET po_line_id = x_lines.po_line_id_tbl(i),
3150: price_update_tolerance = x_lines.price_update_tolerance_tbl(i),
3151: action = x_lines.action_tbl(i),
3152: price_break_flag = DECODE(x_lines.action_tbl(i), 'UPDATE',
3363: FORALL i IN 1..x_lines.rec_count
3364: INSERT INTO po_session_gt(key, num1)
3365: SELECT l_key,
3366: l_index_tbl(i)
3367: FROM po_lines txn_lines
3368: WHERE txn_lines.po_line_id = x_lines.po_line_id_tbl(i)
3369: AND x_lines.unit_of_measure_tbl(i) IS NOT NULL
3370: AND txn_lines.unit_meas_lookup_code IS NOT NULL
3371: AND txn_lines.unit_meas_lookup_code <>
3375: WHERE po_line_id = txn_lines.po_line_id
3376: AND shipment_type = 'BLANKET')
3377: OR
3378: EXISTS (SELECT 1
3379: FROM po_lines_all
3380: WHERE from_line_id = txn_lines.po_line_id)
3381: );
3382:
3383: DELETE FROM po_session_gt
3540: -- number of error lines.
3541: --Parameters:
3542: --IN:
3543: -- p_action
3544: -- indicate whether the po lines are going to be created or updated;
3545: -- the values can be 'CREATE' or 'UPDATE'
3546: --IN OUT:
3547: -- x_lines
3548: -- record which stores all the line rows within the batch;
3561: d_api_name CONSTANT VARCHAR2(30) := 'validate_lines';
3562: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
3563: d_position NUMBER;
3564:
3565: l_lines PO_LINES_VAL_TYPE := PO_LINES_VAL_TYPE();
3566: l_result_type VARCHAR2(30);
3567: l_results po_validation_results_type;
3568: l_parameter_name_tbl PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();
3569: l_parameter_value_tbl PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();
3677:
3678: PO_PDOI_ERR_UTL.process_val_type_errors
3679: (
3680: x_results => l_results,
3681: p_table_name => 'PO_LINES_INTERFACE',
3682: p_lines => x_lines
3683: );
3684:
3685: d_position := 50;
3845: SELECT DISTINCT
3846: p_key,
3847: p_index_tbl(i),
3848: txn_lines.item_id
3849: FROM po_headers txn_headers, po_lines txn_lines
3850: WHERE txn_headers.po_header_id = txn_lines.po_header_id
3851: AND p_item_tbl(i) IS NULL
3852: AND x_item_id_tbl(i) IS NULL
3853: AND p_vendor_product_num_tbl(i) IS NOT NULL
3891: (
3892: p_interface_header_id => p_intf_header_id_tbl(l_index),
3893: p_interface_line_id => p_intf_line_id_tbl(l_index),
3894: p_error_message_name => 'PO_PDOI_MULT_BUYER_PART',
3895: p_table_name => 'PO_LINES_INTERFACE',
3896: p_column_name => 'VENDOR_PRODUCT_NUM',
3897: p_column_value => p_vendor_product_num_tbl(l_index),
3898: p_token2_name => 'VALUE',
3899: p_token2_value => p_vendor_product_num_tbl(l_index)
5706: --Name: match_lines_on_line_num
5707: --Function:
5708: -- If header action is 'ORIGINAL', 'REPLACE' or
5709: -- 'UPDATE SPO', this procedure will be called
5710: -- to group the po lines and po line locations.
5711: -- The first criteria used is line_num
5712: --Parameters:
5713: --IN:
5714: -- p_index_tbl
5761: INSERT INTO po_session_gt(key, num1, num2)
5762: SELECT l_key,
5763: p_index_tbl(i),
5764: po_line_id
5765: FROM po_lines_draft_all
5766: WHERE draft_id = x_lines.draft_id_tbl(i)
5767: AND po_header_id = x_lines.po_header_id_tbl(i)
5768: AND line_num = x_lines.line_num_tbl(i)
5769: AND NVL(delete_flag, 'N') <> 'Y';
5855: --Name: match_lines_on_item_info
5856: --Function:
5857: -- If header action is 'ORIGINAL', or 'REPLACE',
5858: -- this procedure will be called to group the
5859: -- po lines and po line locations.
5860: -- this procedure match the lines based on
5861: -- item related info.
5862: --Parameters:
5863: --IN:
5946: SELECT l_key,
5947: l_processing_line_tbl(i),
5948: po_line_id,
5949: line_num
5950: FROM po_lines_draft_all
5951: WHERE x_lines.item_id_tbl(i) IS NOT NULL
5952: AND draft_id = x_lines.draft_id_tbl(i)
5953: AND po_header_id = x_lines.po_header_id_tbl(i)
5954: AND item_id = x_lines.item_id_tbl(i)
5968: SELECT l_key,
5969: l_processing_line_tbl(i),
5970: po_line_id,
5971: line_num
5972: FROM po_lines_draft_all
5973: WHERE x_lines.item_id_tbl(i) IS NULL
5974: AND draft_id = x_lines.draft_id_tbl(i)
5975: AND po_header_id = x_lines.po_header_id_tbl(i)
5976: AND item_description = x_lines.item_desc_tbl(i)
6465: p_key,
6466: x_processing_row_tbl(i),
6467: draft_lines.po_line_id,
6468: draft_lines.line_num
6469: FROM po_lines_draft_all draft_lines
6470: WHERE draft_lines.po_header_id = x_lines.hd_po_header_id_tbl(i)
6471: AND draft_lines.draft_id = x_lines.draft_id_tbl(i)
6472: AND NVL(draft_lines.expiration_date, TRUNC(sysdate)) >= TRUNC(sysdate)
6473: AND draft_lines.item_description = x_lines.item_desc_tbl(i)
6492: p_key,
6493: x_processing_row_tbl(i),
6494: txn_lines.po_line_id,
6495: txn_lines.line_num
6496: FROM po_lines txn_lines
6497: WHERE txn_lines.po_header_id = x_lines.hd_po_header_id_tbl(i)
6498: AND NOT EXISTS ( SELECT 1
6499: FROM po_lines_draft_all draft_lines
6500: WHERE draft_lines.po_line_id = txn_lines.po_line_id
6495: txn_lines.line_num
6496: FROM po_lines txn_lines
6497: WHERE txn_lines.po_header_id = x_lines.hd_po_header_id_tbl(i)
6498: AND NOT EXISTS ( SELECT 1
6499: FROM po_lines_draft_all draft_lines
6500: WHERE draft_lines.po_line_id = txn_lines.po_line_id
6501: AND draft_lines.draft_id = x_lines.draft_id_tbl(i))
6502: AND txn_lines.item_description = x_lines.item_desc_tbl(i)
6503: AND (x_lines.category_tbl(i) IS NULL OR
6739: p_key,
6740: x_processing_row_tbl(i),
6741: draft_lines.po_line_id,
6742: draft_lines.line_num
6743: FROM po_lines_draft_all draft_lines
6744: WHERE x_lines.item_tbl(i) IS NOT NULL
6745: AND draft_lines.po_header_id = x_lines.hd_po_header_id_tbl(i)
6746: AND draft_lines.draft_id = x_lines.draft_id_tbl(i)
6747: AND NVL(draft_lines.expiration_date, TRUNC(sysdate)) >= TRUNC(sysdate)
6774: p_key,
6775: x_processing_row_tbl(i),
6776: txn_lines.po_line_id,
6777: txn_lines.line_num
6778: FROM po_lines txn_lines
6779: WHERE x_lines.item_tbl(i) IS NOT NULL
6780: AND txn_lines.po_header_id = x_lines.hd_po_header_id_tbl(i)
6781: AND NOT EXISTS ( SELECT 1
6782: FROM po_lines_draft_all draft_lines
6778: FROM po_lines txn_lines
6779: WHERE x_lines.item_tbl(i) IS NOT NULL
6780: AND txn_lines.po_header_id = x_lines.hd_po_header_id_tbl(i)
6781: AND NOT EXISTS ( SELECT 1
6782: FROM po_lines_draft_all draft_lines
6783: WHERE draft_lines.po_line_id = txn_lines.po_line_id
6784: AND draft_lines.draft_id = x_lines.draft_id_tbl(i))
6785: AND EXISTS (SELECT 1
6786: FROM mtl_system_items items
7021: p_key,
7022: x_processing_row_tbl(i),
7023: draft_lines.po_line_id,
7024: draft_lines.line_num
7025: FROM po_lines_draft_all draft_lines
7026: WHERE x_lines.item_tbl(i) IS NULL
7027: AND x_lines.vendor_product_num_tbl(i) IS NOT NULL
7028: AND draft_lines.po_header_id = x_lines.hd_po_header_id_tbl(i)
7029: AND draft_lines.draft_id = x_lines.draft_id_tbl(i)
7048: p_key,
7049: x_processing_row_tbl(i),
7050: txn_lines.po_line_id,
7051: txn_lines.line_num
7052: FROM po_lines txn_lines
7053: WHERE x_lines.item_tbl(i) IS NULL
7054: AND x_lines.vendor_product_num_tbl(i) IS NOT NULL
7055: AND txn_lines.po_header_id = x_lines.hd_po_header_id_tbl(i)
7056: AND NOT EXISTS ( SELECT 1
7053: WHERE x_lines.item_tbl(i) IS NULL
7054: AND x_lines.vendor_product_num_tbl(i) IS NOT NULL
7055: AND txn_lines.po_header_id = x_lines.hd_po_header_id_tbl(i)
7056: AND NOT EXISTS ( SELECT 1
7057: FROM po_lines_draft_all draft_lines
7058: WHERE draft_lines.po_line_id = txn_lines.po_line_id
7059: AND draft_lines.draft_id = x_lines.draft_id_tbl(i))
7060: AND txn_lines.vendor_product_num = x_lines.vendor_product_num_tbl(i)
7061: AND NVL(x_lines.supplier_part_auxid_tbl(i),
7279: p_key,
7280: x_processing_row_tbl(i),
7281: draft_lines.po_line_id,
7282: draft_lines.line_num
7283: FROM po_lines_draft_all draft_lines
7284: WHERE x_lines.item_tbl(i) IS NULL
7285: AND x_lines.vendor_product_num_tbl(i) IS NULL
7286: AND x_lines.job_name_tbl(i) IS NOT NULL
7287: AND draft_lines.po_header_id = x_lines.hd_po_header_id_tbl(i)
7308: p_key,
7309: x_processing_row_tbl(i),
7310: txn_lines.po_line_id,
7311: txn_lines.line_num
7312: FROM po_lines txn_lines
7313: WHERE x_lines.item_tbl(i) IS NULL
7314: AND x_lines.vendor_product_num_tbl(i) IS NULL
7315: AND x_lines.job_name_tbl(i) IS NOT NULL
7316: AND txn_lines.po_header_id = x_lines.hd_po_header_id_tbl(i)
7314: AND x_lines.vendor_product_num_tbl(i) IS NULL
7315: AND x_lines.job_name_tbl(i) IS NOT NULL
7316: AND txn_lines.po_header_id = x_lines.hd_po_header_id_tbl(i)
7317: AND NOT EXISTS ( SELECT 1
7318: FROM po_lines_draft_all draft_lines
7319: WHERE draft_lines.po_line_id = txn_lines.po_line_id
7320: AND draft_lines.draft_id = x_lines.draft_id_tbl(i))
7321: AND EXISTS (SELECT 1
7322: FROM per_jobs_vl
7534: p_key,
7535: x_processing_row_tbl(i),
7536: draft_lines.po_line_id,
7537: draft_lines.line_num
7538: FROM po_lines_draft_all draft_lines
7539: WHERE x_lines.item_tbl(i) IS NULL
7540: AND x_lines.vendor_product_num_tbl(i) IS NULL
7541: AND x_lines.job_name_tbl(i) IS NULL
7542: AND x_lines.line_num_tbl(i) IS NOT NULL
7560: p_key,
7561: x_processing_row_tbl(i),
7562: txn_lines.po_line_id,
7563: txn_lines.line_num
7564: FROM po_lines txn_lines
7565: WHERE x_lines.item_tbl(i) IS NULL
7566: AND x_lines.vendor_product_num_tbl(i) IS NULL
7567: AND x_lines.job_name_tbl(i) IS NULL
7568: AND x_lines.line_num_tbl(i) IS NOT NULL
7567: AND x_lines.job_name_tbl(i) IS NULL
7568: AND x_lines.line_num_tbl(i) IS NOT NULL
7569: AND txn_lines.po_header_id = x_lines.hd_po_header_id_tbl(i)
7570: AND NOT EXISTS ( SELECT 1
7571: FROM po_lines_draft_all draft_lines
7572: WHERE draft_lines.po_line_id = txn_lines.po_line_id
7573: AND draft_lines.draft_id = x_lines.draft_id_tbl(i))
7574: AND txn_lines.line_num = x_lines.line_num_tbl(i)
7575: AND NVL(txn_lines.expiration_date, TRUNC(sysdate)) >= TRUNC(sysdate)
7894: (
7895: p_interface_header_id => x_lines.intf_header_id_tbl(l_index),
7896: p_interface_line_id => x_lines.intf_line_id_tbl(l_index),
7897: p_error_message_name => 'PO_PDOI_NO_TLP_IN_CREATE_LANG',
7898: p_table_name => 'PO_LINES_INTERFACE',
7899: p_column_name => NULL,
7900: p_column_value => NULL,
7901: p_validation_id => PO_VAL_CONSTANTS.c_language,
7902: p_lines => x_lines