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_PDOI_LINE_PROCESS_PVT dependencies on PO_LINES_INTERFACE

Line 288: FROM po_lines_interface intf_lines,

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

Line 306: po_lines_interface intf_lines,

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

Line 371: p_table_name => 'PO_LINES_INTERFACE',

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)

Line 440: p_table_name => 'PO_LINES_INTERFACE',

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)

Line 507: FROM po_lines_interface intf_lines,

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

Line 560: p_table_name => 'PO_LINES_INTERFACE',

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)

Line 757: FROM po_lines_interface intf_lines,

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

Line 890: FROM po_lines_interface intf_lines,

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

Line 1024: FROM po_lines_interface intf_lines,

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

Line 1161: FROM po_lines_interface intf_lines,

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

Line 1302: FROM po_lines_interface intf_lines,

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

Line 1730: p_table_name => 'PO_LINES_INTERFACE',

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

Line 1754: p_table_name => 'PO_LINES_INTERFACE',

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',

Line 1777: p_table_name => 'PO_LINES_INTERFACE',

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',

Line 1805: p_table_name => 'PO_LINES_INTERFACE',

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',

Line 1836: p_table_name => 'PO_LINES_INTERFACE',

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',

Line 1865: p_table_name => 'PO_LINES_INTERFACE',

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',

Line 1893: p_table_name => 'PO_LINES_INTERFACE',

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',

Line 1921: p_table_name => 'PO_LINES_INTERFACE',

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',

Line 1947: p_table_name => 'PO_LINES_INTERFACE',

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',

Line 1973: p_table_name => 'PO_LINES_INTERFACE',

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',

Line 2131: p_table_name => 'PO_LINES_INTERFACE',

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',

Line 2160: p_table_name => 'PO_LINES_INTERFACE',

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',

Line 2187: p_table_name => 'PO_LINES_INTERFACE',

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',

Line 2885: UPDATE po_lines_interface

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:

Line 2909: p_table_name => 'PO_LINES_INTERFACE',

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',

Line 3148: UPDATE po_lines_interface

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',

Line 3681: p_table_name => 'PO_LINES_INTERFACE',

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;

Line 3895: p_table_name => 'PO_LINES_INTERFACE',

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)

Line 7898: p_table_name => 'PO_LINES_INTERFACE',

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