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 373: FROM po_lines_interface intf_lines,

369: p_request_processing_round_num NUMBER) IS
370: SELECT intf_headers.interface_header_id,
371: intf_lines.interface_line_id,
372: intf_lines.line_num
373: FROM po_lines_interface intf_lines,
374: po_headers_interface intf_headers,
375: po_lines txn_lines
376: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
377: AND intf_headers.po_header_id = txn_lines.po_header_id

Line 391: po_lines_interface intf_lines,

387: SELECT intf_headers.interface_header_id,
388: intf_lines.interface_line_id,
389: intf_lines.line_num
390: FROM po_headers_interface intf_headers,
391: po_lines_interface intf_lines,
392: po_lines_draft_all draft_lines
393: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
394: AND intf_headers.draft_id = draft_lines.draft_id
395: AND intf_headers.po_header_id = draft_lines.po_header_id

Line 456: p_table_name => 'PO_LINES_INTERFACE',

452: (
453: p_interface_header_id => l_dup_intf_header_id_tbl(i),
454: p_interface_line_id => l_dup_intf_line_id_tbl(i),
455: p_error_message_name => 'PO_PDOI_STD_PO_LINE_NUM_EXISTS',
456: p_table_name => 'PO_LINES_INTERFACE',
457: p_column_name => 'LINE_NUM',
458: p_column_value => l_dup_intf_line_num_tbl(i),
459: p_token1_name => 'VALUE',
460: p_token1_value => l_dup_intf_line_num_tbl(i)

Line 525: p_table_name => 'PO_LINES_INTERFACE',

521: (
522: p_interface_header_id => l_dup_intf_header_id_tbl(i),
523: p_interface_line_id => l_dup_intf_line_id_tbl(i),
524: p_error_message_name => 'PO_PDOI_STD_PO_LINE_NUM_EXISTS',
525: p_table_name => 'PO_LINES_INTERFACE',
526: p_column_name => 'LINE_NUM',
527: p_column_value => l_dup_intf_line_num_tbl(i),
528: p_token1_name => 'VALUE',
529: p_token1_value => l_dup_intf_line_num_tbl(i)

Line 592: FROM po_lines_interface intf_lines,

588: p_request_processing_round_num NUMBER) IS
589: SELECT intf_lines.interface_line_id,
590: intf_headers.interface_header_id,
591: intf_lines.action
592: FROM po_lines_interface intf_lines,
593: po_headers_interface intf_headers
594: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
595: AND intf_lines.processing_id = p_request_processing_id
596: AND intf_headers.processing_round_num = p_request_processing_round_num

Line 645: p_table_name => 'PO_LINES_INTERFACE',

641: (
642: p_interface_header_id => l_rej_intf_header_id_tbl(i),
643: p_interface_line_id => l_rej_intf_line_id_tbl(i),
644: p_error_message_name => 'PO_PDOI_INVALID_ACTION',
645: p_table_name => 'PO_LINES_INTERFACE',
646: p_column_name => 'ACTION',
647: p_column_value => l_rej_line_action_tbl(i),
648: p_token1_name => 'VALUE',
649: p_token1_value => l_rej_line_action_tbl(i)

Line 890: FROM po_lines_interface intf_lines,

886: intf_lines.clm_base_line_num_disp,
887: intf_lines.from_header_disp,
888: intf_lines.from_line_disp
889:
890: FROM po_lines_interface intf_lines,
891: po_headers_interface intf_headers,
892: po_headers_draft_all draft_headers
893: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
894: AND intf_headers.draft_id = draft_headers.draft_id

Line 1075: FROM po_lines_interface intf_lines,

1071: intf_lines.from_header_disp,
1072: intf_lines.from_line_disp
1073:
1074:
1075: FROM po_lines_interface intf_lines,
1076: po_headers_interface intf_headers,
1077: po_headers txn_headers
1078: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
1079: AND intf_headers.po_header_id = txn_headers.po_header_id

Line 1260: FROM po_lines_interface intf_lines,

1256: intf_lines.clm_base_line_num_disp,
1257: intf_lines.from_header_disp,
1258: intf_lines.from_line_disp
1259:
1260: FROM po_lines_interface intf_lines,
1261: po_headers_interface intf_headers,
1262: po_headers txn_headers
1263: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
1264: AND intf_headers.po_header_id = txn_headers.po_header_id

Line 1450: FROM po_lines_interface intf_lines,

1446: intf_lines.clm_base_line_num_disp,
1447: intf_lines.from_header_disp,
1448: intf_lines.from_line_disp
1449:
1450: FROM po_lines_interface intf_lines,
1451: po_headers_interface intf_headers,
1452: po_headers txn_headers
1453: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
1454: AND intf_headers.po_header_id = txn_headers.po_header_id

Line 1643: FROM po_lines_interface intf_lines,

1639: intf_lines.clm_base_line_num_disp,
1640: intf_lines.from_header_disp,
1641: intf_lines.from_line_disp
1642:
1643: FROM po_lines_interface intf_lines,
1644: po_headers_interface intf_headers,
1645: po_headers txn_headers
1646: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
1647: AND intf_headers.po_header_id = txn_headers.po_header_id

Line 1836: FROM po_lines_interface intf_lines,

1832: intf_lines.clm_base_line_num_disp,
1833: intf_lines.from_header_disp,
1834: intf_lines.from_line_disp
1835:
1836: FROM po_lines_interface intf_lines,
1837: po_headers_interface intf_headers,
1838: po_headers_draft_all draft_headers
1839: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
1840: AND intf_headers.draft_id = draft_headers.draft_id

Line 2362: p_table_name => 'PO_LINES_INTERFACE',

2358: (
2359: p_interface_header_id => x_lines.intf_header_id_tbl(i),
2360: p_interface_line_id => x_lines.intf_line_id_tbl(i),
2361: p_error_message_name => 'PO_PDOI_DERV_PART_NUM_ERROR',
2362: p_table_name => 'PO_LINES_INTERFACE',
2363: p_column_name => NULL,
2364: p_column_value => NULL,
2365: p_validation_id => PO_VAL_CONSTANTS.c_part_num_derv,
2366: p_lines => x_lines

Line 2386: p_table_name => 'PO_LINES_INTERFACE',

2382: (
2383: p_interface_header_id => x_lines.intf_header_id_tbl(i),
2384: p_interface_line_id => x_lines.intf_line_id_tbl(i),
2385: p_error_message_name => 'PO_PDOI_DERV_ERROR',
2386: p_table_name => 'PO_LINES_INTERFACE',
2387: p_column_name => 'JOB_BUSINESS_GROUP_ID',
2388: p_column_value => x_lines.job_business_group_id_tbl(i),
2389: p_token1_name => 'COLUMN_NAME',
2390: p_token1_value => 'JOB_BUSINESS_GROUP_NAME',

Line 2409: p_table_name => 'PO_LINES_INTERFACE',

2405: (
2406: p_interface_header_id => x_lines.intf_header_id_tbl(i),
2407: p_interface_line_id => x_lines.intf_line_id_tbl(i),
2408: p_error_message_name => 'PO_PDOI_DERV_ERROR',
2409: p_table_name => 'PO_LINES_INTERFACE',
2410: p_column_name => 'JOB_ID',
2411: p_column_value => x_lines.job_id_tbl(i),
2412: p_token1_name => 'COLUMN_NAME',
2413: p_token1_value => 'JOB_NAME',

Line 2437: p_table_name => 'PO_LINES_INTERFACE',

2433: (
2434: p_interface_header_id => x_lines.intf_header_id_tbl(i),
2435: p_interface_line_id => x_lines.intf_line_id_tbl(i),
2436: p_error_message_name => 'PO_PDOI_DERV_ERROR',
2437: p_table_name => 'PO_LINES_INTERFACE',
2438: p_column_name => 'CATEGORY_ID',
2439: p_column_value => x_lines.category_id_tbl(i),
2440: p_token1_name => 'COLUMN_NAME',
2441: p_token1_value => 'CATEGORY',

Line 2468: p_table_name => 'PO_LINES_INTERFACE',

2464: (
2465: p_interface_header_id => x_lines.intf_header_id_tbl(i),
2466: p_interface_line_id => x_lines.intf_line_id_tbl(i),
2467: p_error_message_name => 'PO_PDOI_DERV_ERROR',
2468: p_table_name => 'PO_LINES_INTERFACE',
2469: p_column_name => 'IP_CATEGORY_ID',
2470: p_column_value => x_lines.ip_category_id_tbl(i),
2471: p_token1_name => 'COLUMN_NAME',
2472: p_token1_value => 'IP_CATEGORY',

Line 2497: p_table_name => 'PO_LINES_INTERFACE',

2493: (
2494: p_interface_header_id => x_lines.intf_header_id_tbl(i),
2495: p_interface_line_id => x_lines.intf_line_id_tbl(i),
2496: p_error_message_name => 'PO_PDOI_DERV_ERROR',
2497: p_table_name => 'PO_LINES_INTERFACE',
2498: p_column_name => 'UNIT_OF_MEASURE',
2499: p_column_value => x_lines.unit_of_measure_tbl(i),
2500: p_token1_name => 'COLUMN_NAME',
2501: p_token1_value => 'UOM_CODE',

Line 2525: p_table_name => 'PO_LINES_INTERFACE',

2521: (
2522: p_interface_header_id => x_lines.intf_header_id_tbl(i),
2523: p_interface_line_id => x_lines.intf_line_id_tbl(i),
2524: p_error_message_name => 'PO_PDOI_DERV_ERROR',
2525: p_table_name => 'PO_LINES_INTERFACE',
2526: p_column_name => 'LINE_TYPE_ID',
2527: p_column_value => x_lines.line_type_id_tbl(i),
2528: p_token1_name => 'COLUMN_NAME',
2529: p_token1_value => 'LINE_TYPE',

Line 2553: p_table_name => 'PO_LINES_INTERFACE',

2549: (
2550: p_interface_header_id => x_lines.intf_header_id_tbl(i),
2551: p_interface_line_id => x_lines.intf_line_id_tbl(i),
2552: p_error_message_name => 'PO_PDOI_DERV_ERROR',
2553: p_table_name => 'PO_LINES_INTERFACE',
2554: p_column_name => 'UN_NUMBER_ID',
2555: p_column_value => x_lines.un_number_id_tbl(i),
2556: p_token1_name => 'COLUMN_NAME',
2557: p_token1_value => 'UN_NUMBER',

Line 2579: p_table_name => 'PO_LINES_INTERFACE',

2575: (
2576: p_interface_header_id => x_lines.intf_header_id_tbl(i),
2577: p_interface_line_id => x_lines.intf_line_id_tbl(i),
2578: p_error_message_name => 'PO_PDOI_DERV_ERROR',
2579: p_table_name => 'PO_LINES_INTERFACE',
2580: p_column_name => 'HAZARD_CLASS_ID',
2581: p_column_value => x_lines.hazard_class_id_tbl(i),
2582: p_token1_name => 'COLUMN_NAME',
2583: p_token1_value => 'HAZARD_CLASS',

Line 2605: p_table_name => 'PO_LINES_INTERFACE',

2601: (
2602: p_interface_header_id => x_lines.intf_header_id_tbl(i),
2603: p_interface_line_id => x_lines.intf_line_id_tbl(i),
2604: p_error_message_name => 'PO_PDOI_DERV_ERROR',
2605: p_table_name => 'PO_LINES_INTERFACE',
2606: p_column_name => 'TEMPLATE_ID',
2607: p_column_value => x_lines.template_id_tbl(i),
2608: p_token1_name => 'COLUMN_NAME',
2609: p_token1_value => 'TEMPLATE_NAME',

Line 2634: p_table_name => 'PO_LINES_INTERFACE',

2630: (
2631: p_interface_header_id => x_lines.intf_header_id_tbl(i),
2632: p_interface_line_id => x_lines.intf_line_id_tbl(i),
2633: p_error_message_name => 'PO_PDOI_DERV_ERROR',
2634: p_table_name => 'PO_LINES_INTERFACE',
2635: p_column_name => 'CONTRACT_TYPE',
2636: p_column_value => x_lines.contract_type_tbl(i),
2637: p_token1_name => 'COLUMN_NAME',
2638: p_token1_value => 'CONTRACT_TYPE_DISPLAY',

Line 2660: p_table_name => 'PO_LINES_INTERFACE',

2656: (
2657: p_interface_header_id => x_lines.intf_header_id_tbl(i),
2658: p_interface_line_id => x_lines.intf_line_id_tbl(i),
2659: p_error_message_name => 'PO_PDOI_DERV_ERROR',
2660: p_table_name => 'PO_LINES_INTERFACE',
2661: p_column_name => 'COST_CONSTRAINT',
2662: p_column_value => x_lines.cost_constraint_tbl(i),
2663: p_token1_name => 'COLUMN_NAME',
2664: p_token1_value => 'COST_CONSTRAINT_DISPLAY',

Line 2686: p_table_name => 'PO_LINES_INTERFACE',

2682: (
2683: p_interface_header_id => x_lines.intf_header_id_tbl(i),
2684: p_interface_line_id => x_lines.intf_line_id_tbl(i),
2685: p_error_message_name => 'PO_PDOI_DERV_ERROR',
2686: p_table_name => 'PO_LINES_INTERFACE',
2687: p_column_name => 'CLM_IDC_TYPE',
2688: p_column_value => x_lines.clm_idc_type_tbl(i),
2689: p_token1_name => 'COLUMN_NAME',
2690: p_token1_value => 'CLM_IDC_TYPE_DISPLAY',

Line 2712: p_table_name => 'PO_LINES_INTERFACE',

2708: (
2709: p_interface_header_id => x_lines.intf_header_id_tbl(i),
2710: p_interface_line_id => x_lines.intf_line_id_tbl(i),
2711: p_error_message_name => 'PO_PDOI_DERV_ERROR',
2712: p_table_name => 'PO_LINES_INTERFACE',
2713: p_column_name => 'CLM_BASE_LINE_NUM',
2714: p_column_value => x_lines.clm_base_line_num_tbl(i),
2715: p_token1_name => 'COLUMN_NAME',
2716: p_token1_value => 'CLM_BASE_LINE_NUM_DISPLAY',

Line 2738: p_table_name => 'PO_LINES_INTERFACE',

2734: (
2735: p_interface_header_id => x_lines.intf_header_id_tbl(i),
2736: p_interface_line_id => x_lines.intf_line_id_tbl(i),
2737: p_error_message_name => 'PO_PDOI_DERV_ERROR',
2738: p_table_name => 'PO_LINES_INTERFACE',
2739: p_column_name => 'FROM_HEADER_ID',
2740: p_column_value => x_lines.from_header_id_tbl(i),
2741: p_token1_name => 'COLUMN_NAME',
2742: p_token1_value => 'FROM_HEADER_ID_DISPLAY',

Line 2764: p_table_name => 'PO_LINES_INTERFACE',

2760: (
2761: p_interface_header_id => x_lines.intf_header_id_tbl(i),
2762: p_interface_line_id => x_lines.intf_line_id_tbl(i),
2763: p_error_message_name => 'PO_PDOI_DERV_ERROR',
2764: p_table_name => 'PO_LINES_INTERFACE',
2765: p_column_name => 'FROM_LINE_ID',
2766: p_column_value => x_lines.from_line_id_tbl(i),
2767: p_token1_name => 'COLUMN_NAME',
2768: p_token1_value => 'FROM_LINE_ID_DISPLAY',

Line 2951: p_table_name => 'PO_LINES_INTERFACE',

2947: (
2948: p_interface_header_id => x_lines.intf_header_id_tbl(i),
2949: p_interface_line_id => x_lines.intf_line_id_tbl(i),
2950: p_error_message_name => 'PO_PDOI_DERV_ERROR',
2951: p_table_name => 'PO_LINES_INTERFACE',
2952: p_column_name => 'CATEGORY_ID',
2953: p_column_value => x_lines.category_id_tbl(i),
2954: p_token1_name => 'COLUMN_NAME',
2955: p_token1_value => 'CATEGORY',

Line 2980: p_table_name => 'PO_LINES_INTERFACE',

2976: (
2977: p_interface_header_id => x_lines.intf_header_id_tbl(i),
2978: p_interface_line_id => x_lines.intf_line_id_tbl(i),
2979: p_error_message_name => 'PO_PDOI_DERV_ERROR',
2980: p_table_name => 'PO_LINES_INTERFACE',
2981: p_column_name => 'IP_CATEGORY_ID',
2982: p_column_value => x_lines.ip_category_id_tbl(i),
2983: p_token1_name => 'COLUMN_NAME',
2984: p_token1_value => 'IP_CATEGORY',

Line 3007: p_table_name => 'PO_LINES_INTERFACE',

3003: (
3004: p_interface_header_id => x_lines.intf_header_id_tbl(i),
3005: p_interface_line_id => x_lines.intf_line_id_tbl(i),
3006: p_error_message_name => 'PO_PDOI_DERV_ERROR',
3007: p_table_name => 'PO_LINES_INTERFACE',
3008: p_column_name => 'UNIT_OF_MEASURE',
3009: p_column_value => x_lines.unit_of_measure_tbl(i),
3010: p_token1_name => 'COLUMN_NAME',
3011: p_token1_value => 'UOM_CODE',

Line 3781: UPDATE po_lines_interface

3777: x_lines := l_create_lines;
3778:
3779: -- update location only lines with new po_line_id and price_break_flag
3780: FORALL i IN 1..l_update_lines.rec_count
3781: UPDATE po_lines_interface
3782: SET po_line_id = l_update_lines.po_line_id_tbl(i),
3783: price_break_flag = 'Y'
3784: WHERE interface_line_id = l_update_lines.intf_line_id_tbl(i);
3785:

Line 3805: p_table_name => 'PO_LINES_INTERFACE',

3801: (
3802: p_interface_header_id => l_update_lines.intf_header_id_tbl(i),
3803: p_interface_line_id => l_update_lines.intf_line_id_tbl(i),
3804: p_error_message_name => 'PO_PDOI_INVALID_INTER_LINE_REC',
3805: p_table_name => 'PO_LINES_INTERFACE',
3806: p_column_name => 'CREATE_PO_LINES_FLAG',
3807: p_column_value => 'N',
3808: p_token1_name => 'COLUMN_NAME',
3809: p_token1_value => 'CREATE_PO_LINES_FLAG',

Line 4044: UPDATE po_lines_interface

4040:
4041: d_position := 20;
4042:
4043: FORALL i IN 1.. x_lines.rec_count
4044: UPDATE po_lines_interface
4045: SET po_line_id = x_lines.po_line_id_tbl(i),
4046: po_header_id = x_lines.po_header_id_tbl(i), --vegajula line for bug 9531925
4047: price_update_tolerance = x_lines.price_update_tolerance_tbl(i),
4048: action = x_lines.action_tbl(i),

Line 4603: p_table_name => 'PO_LINES_INTERFACE',

4599:
4600: PO_PDOI_ERR_UTL.process_val_type_errors
4601: (
4602: x_results => l_results,
4603: p_table_name => 'PO_LINES_INTERFACE',
4604: p_lines => x_lines
4605: );
4606:
4607: d_position := 50;

Line 4817: p_table_name => 'PO_LINES_INTERFACE',

4813: (
4814: p_interface_header_id => p_intf_header_id_tbl(l_index),
4815: p_interface_line_id => p_intf_line_id_tbl(l_index),
4816: p_error_message_name => 'PO_PDOI_MULT_BUYER_PART',
4817: p_table_name => 'PO_LINES_INTERFACE',
4818: p_column_name => 'VENDOR_PRODUCT_NUM',
4819: p_column_value => p_vendor_product_num_tbl(l_index),
4820: p_token2_name => 'VALUE',
4821: p_token2_value => p_vendor_product_num_tbl(l_index)

Line 8865: p_table_name => 'PO_LINES_INTERFACE',

8861: (
8862: p_interface_header_id => x_lines.intf_header_id_tbl(l_index),
8863: p_interface_line_id => x_lines.intf_line_id_tbl(l_index),
8864: p_error_message_name => 'PO_PDOI_NO_TLP_IN_CREATE_LANG',
8865: p_table_name => 'PO_LINES_INTERFACE',
8866: p_column_name => NULL,
8867: p_column_value => NULL,
8868: p_validation_id => PO_VAL_CONSTANTS.c_language,
8869: p_lines => x_lines

Line 9742: FROM po_headers_draft_all phd, po_lines_interface PLI, po_headers_interface phi

9738: FROM dual;
9739:
9740: UPDATE po_session_gt psg
9741: SET psg.num4 = ( SELECT phd.clm_source_document_id
9742: FROM po_headers_draft_all phd, po_lines_interface PLI, po_headers_interface phi
9743: WHERE PLI.interface_line_id = psg.num3
9744: AND PLI.interface_header_id = phi.interface_header_id
9745: AND phi.po_header_id = phd.po_header_id
9746: )