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

Line 351: --Function: standard po lines cannot be updated. So if the new line in

347:
348: -----------------------------------------------------------------------
349: --Start of Comments
350: --Name: reject_dup_lines_for_spo
351: --Function: standard po lines cannot be updated. So if the new line in
352: -- interface table has the same line num as existing lines in
353: -- same document, these new lines will be regarded as intention
354: -- to update existing standard po records thus rejected.
355: --Parameters:

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 375: po_lines txn_lines

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
378: AND intf_lines.processing_id = p_request_processing_id
379: AND intf_headers.processing_round_num = p_request_processing_round_num

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 392: po_lines_draft_all draft_lines

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
396: AND intf_lines.processing_id = p_request_processing_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 3590: FROM po_lines_draft_all

3586: order_type_lookup_code,
3587: item_id,
3588: job_id,
3589: po_header_id --vegajula bugno:9531925
3590: FROM po_lines_draft_all
3591: WHERE po_line_id = x_lines.po_line_id_tbl(i)
3592: AND draft_id = x_lines.draft_id_tbl(i);
3593:
3594: d_position := 20;

Line 3605: FROM po_lines_all

3601: order_type_lookup_code,
3602: item_id,
3603: job_id,
3604: po_header_id --vegajula bugno:9531925
3605: FROM po_lines_all
3606: WHERE po_line_id = x_lines.po_line_id_tbl(i)
3607: AND NOT EXISTS (SELECT 1
3608: FROM po_lines_draft_all
3609: WHERE po_line_id = x_lines.po_line_id_tbl(i)

Line 3608: FROM po_lines_draft_all

3604: po_header_id --vegajula bugno:9531925
3605: FROM po_lines_all
3606: WHERE po_line_id = x_lines.po_line_id_tbl(i)
3607: AND NOT EXISTS (SELECT 1
3608: FROM po_lines_draft_all
3609: WHERE po_line_id = x_lines.po_line_id_tbl(i)
3610: AND draft_id = x_lines.draft_id_tbl(i));
3611:
3612: d_position := 30;

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 3806: p_column_name => 'CREATE_PO_LINES_FLAG',

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',
3810: p_token2_name => 'VALUE',

Line 3809: p_token1_value => 'CREATE_PO_LINES_FLAG',

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',
3810: p_token2_name => 'VALUE',
3811: p_token2_value => 'N'
3812: );
3813:

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 4266: FROM po_lines txn_lines

4262: FORALL i IN 1..x_lines.rec_count
4263: INSERT INTO po_session_gt(key, num1)
4264: SELECT l_key,
4265: l_index_tbl(i)
4266: FROM po_lines txn_lines
4267: WHERE txn_lines.po_line_id = x_lines.po_line_id_tbl(i)
4268: AND x_lines.unit_of_measure_tbl(i) IS NOT NULL
4269: AND txn_lines.unit_meas_lookup_code IS NOT NULL
4270: AND txn_lines.unit_meas_lookup_code <>

Line 4278: FROM po_lines_all

4274: WHERE po_line_id = txn_lines.po_line_id
4275: AND shipment_type = 'BLANKET')
4276: OR
4277: EXISTS (SELECT 1
4278: FROM po_lines_all
4279: WHERE from_line_id = txn_lines.po_line_id)
4280: );
4281:
4282: DELETE FROM po_session_gt

Line 4443: -- indicate whether the po lines are going to be created or updated;

4439: -- number of error lines.
4440: --Parameters:
4441: --IN:
4442: -- p_action
4443: -- indicate whether the po lines are going to be created or updated;
4444: -- the values can be 'CREATE' or 'UPDATE'
4445: --IN OUT:
4446: -- x_lines
4447: -- record which stores all the line rows within the batch;

Line 4464: l_lines PO_LINES_VAL_TYPE := PO_LINES_VAL_TYPE();

4460: d_api_name CONSTANT VARCHAR2(30) := 'validate_lines';
4461: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
4462: d_position NUMBER;
4463:
4464: l_lines PO_LINES_VAL_TYPE := PO_LINES_VAL_TYPE();
4465: l_result_type VARCHAR2(30);
4466: l_results po_validation_results_type;
4467: l_parameter_name_tbl PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();
4468: l_parameter_value_tbl PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();

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 4771: FROM po_headers txn_headers, po_lines txn_lines

4767: SELECT DISTINCT
4768: p_key,
4769: p_index_tbl(i),
4770: txn_lines.item_id
4771: FROM po_headers txn_headers, po_lines txn_lines
4772: WHERE txn_headers.po_header_id = txn_lines.po_header_id
4773: AND p_item_tbl(i) IS NULL
4774: AND x_item_id_tbl(i) IS NULL
4775: AND p_vendor_product_num_tbl(i) IS NOT NULL

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 6632: -- to group the po lines and po line locations.

6628: --Name: match_lines_on_line_num
6629: --Function:
6630: -- If header action is 'ORIGINAL', 'REPLACE' or
6631: -- 'UPDATE SPO', this procedure will be called
6632: -- to group the po lines and po line locations.
6633: -- The first criteria used is line_num
6634: --Parameters:
6635: --IN:
6636: -- p_index_tbl

Line 6690: FROM po_lines_draft_all

6686: INSERT INTO po_session_gt(key, num1, num2)
6687: SELECT l_key,
6688: p_index_tbl(i),
6689: po_line_id
6690: FROM po_lines_draft_all
6691: WHERE draft_id = x_lines.draft_id_tbl(i)
6692: AND po_header_id = x_lines.po_header_id_tbl(i)
6693: AND line_num = x_lines.line_num_tbl(i)
6694: AND NVL(delete_flag, 'N') <> 'Y';

Line 6784: -- po lines and po line locations.

6780: --Name: match_lines_on_item_info
6781: --Function:
6782: -- If header action is 'ORIGINAL', or 'REPLACE',
6783: -- this procedure will be called to group the
6784: -- po lines and po line locations.
6785: -- this procedure match the lines based on
6786: -- item related info.
6787: --Parameters:
6788: --IN:

Line 6875: FROM po_lines_draft_all

6871: SELECT l_key,
6872: l_processing_line_tbl(i),
6873: po_line_id,
6874: line_num
6875: FROM po_lines_draft_all
6876: WHERE x_lines.item_id_tbl(i) IS NOT NULL
6877: AND draft_id = x_lines.draft_id_tbl(i)
6878: AND po_header_id = x_lines.po_header_id_tbl(i)
6879: AND item_id = x_lines.item_id_tbl(i)

Line 6897: FROM po_lines_draft_all

6893: SELECT l_key,
6894: l_processing_line_tbl(i),
6895: po_line_id,
6896: line_num
6897: FROM po_lines_draft_all
6898: WHERE x_lines.item_id_tbl(i) IS NULL
6899: AND draft_id = x_lines.draft_id_tbl(i)
6900: AND po_header_id = x_lines.po_header_id_tbl(i)
6901: AND item_description = x_lines.item_desc_tbl(i)

Line 7436: FROM po_lines_draft_all draft_lines

7432: p_key,
7433: x_processing_row_tbl(i),
7434: draft_lines.po_line_id,
7435: draft_lines.line_num
7436: FROM po_lines_draft_all draft_lines
7437: WHERE draft_lines.po_header_id = x_lines.hd_po_header_id_tbl(i)
7438: AND draft_lines.draft_id = x_lines.draft_id_tbl(i)
7439: AND NVL(draft_lines.expiration_date, TRUNC(sysdate)) >= TRUNC(sysdate)
7440: AND draft_lines.item_description = x_lines.item_desc_tbl(i)

Line 7463: FROM po_lines txn_lines

7459: p_key,
7460: x_processing_row_tbl(i),
7461: txn_lines.po_line_id,
7462: txn_lines.line_num
7463: FROM po_lines txn_lines
7464: WHERE txn_lines.po_header_id = x_lines.hd_po_header_id_tbl(i)
7465: AND NOT EXISTS ( SELECT 1
7466: FROM po_lines_draft_all draft_lines
7467: WHERE draft_lines.po_line_id = txn_lines.po_line_id

Line 7466: FROM po_lines_draft_all draft_lines

7462: txn_lines.line_num
7463: FROM po_lines txn_lines
7464: WHERE txn_lines.po_header_id = x_lines.hd_po_header_id_tbl(i)
7465: AND NOT EXISTS ( SELECT 1
7466: FROM po_lines_draft_all draft_lines
7467: WHERE draft_lines.po_line_id = txn_lines.po_line_id
7468: AND draft_lines.draft_id = x_lines.draft_id_tbl(i))
7469: AND txn_lines.item_description = x_lines.item_desc_tbl(i)
7470: AND (x_lines.category_tbl(i) IS NULL OR

Line 7710: FROM po_lines_draft_all draft_lines

7706: p_key,
7707: x_processing_row_tbl(i),
7708: draft_lines.po_line_id,
7709: draft_lines.line_num
7710: FROM po_lines_draft_all draft_lines
7711: WHERE x_lines.item_tbl(i) IS NOT NULL
7712: AND draft_lines.po_header_id = x_lines.hd_po_header_id_tbl(i)
7713: AND draft_lines.draft_id = x_lines.draft_id_tbl(i)
7714: AND NVL(draft_lines.expiration_date, TRUNC(sysdate)) >= TRUNC(sysdate)

Line 7745: FROM po_lines txn_lines

7741: p_key,
7742: x_processing_row_tbl(i),
7743: txn_lines.po_line_id,
7744: txn_lines.line_num
7745: FROM po_lines txn_lines
7746: WHERE x_lines.item_tbl(i) IS NOT NULL
7747: AND txn_lines.po_header_id = x_lines.hd_po_header_id_tbl(i)
7748: AND NOT EXISTS ( SELECT 1
7749: FROM po_lines_draft_all draft_lines

Line 7749: FROM po_lines_draft_all draft_lines

7745: FROM po_lines txn_lines
7746: WHERE x_lines.item_tbl(i) IS NOT NULL
7747: AND txn_lines.po_header_id = x_lines.hd_po_header_id_tbl(i)
7748: AND NOT EXISTS ( SELECT 1
7749: FROM po_lines_draft_all draft_lines
7750: WHERE draft_lines.po_line_id = txn_lines.po_line_id
7751: AND draft_lines.draft_id = x_lines.draft_id_tbl(i))
7752: AND EXISTS (SELECT 1
7753: FROM mtl_system_items items

Line 7992: FROM po_lines_draft_all draft_lines

7988: p_key,
7989: x_processing_row_tbl(i),
7990: draft_lines.po_line_id,
7991: draft_lines.line_num
7992: FROM po_lines_draft_all draft_lines
7993: WHERE x_lines.item_tbl(i) IS NULL
7994: AND x_lines.vendor_product_num_tbl(i) IS NOT NULL
7995: AND draft_lines.po_header_id = x_lines.hd_po_header_id_tbl(i)
7996: AND draft_lines.draft_id = x_lines.draft_id_tbl(i)

Line 8019: FROM po_lines txn_lines

8015: p_key,
8016: x_processing_row_tbl(i),
8017: txn_lines.po_line_id,
8018: txn_lines.line_num
8019: FROM po_lines txn_lines
8020: WHERE x_lines.item_tbl(i) IS NULL
8021: AND x_lines.vendor_product_num_tbl(i) IS NOT NULL
8022: AND txn_lines.po_header_id = x_lines.hd_po_header_id_tbl(i)
8023: AND NOT EXISTS ( SELECT 1

Line 8024: FROM po_lines_draft_all draft_lines

8020: WHERE x_lines.item_tbl(i) IS NULL
8021: AND x_lines.vendor_product_num_tbl(i) IS NOT NULL
8022: AND txn_lines.po_header_id = x_lines.hd_po_header_id_tbl(i)
8023: AND NOT EXISTS ( SELECT 1
8024: FROM po_lines_draft_all draft_lines
8025: WHERE draft_lines.po_line_id = txn_lines.po_line_id
8026: AND draft_lines.draft_id = x_lines.draft_id_tbl(i))
8027: AND txn_lines.vendor_product_num = x_lines.vendor_product_num_tbl(i)
8028: AND NVL(x_lines.supplier_part_auxid_tbl(i),

Line 8250: FROM po_lines_draft_all draft_lines

8246: p_key,
8247: x_processing_row_tbl(i),
8248: draft_lines.po_line_id,
8249: draft_lines.line_num
8250: FROM po_lines_draft_all draft_lines
8251: WHERE x_lines.item_tbl(i) IS NULL
8252: AND x_lines.vendor_product_num_tbl(i) IS NULL
8253: AND x_lines.job_name_tbl(i) IS NOT NULL
8254: AND draft_lines.po_header_id = x_lines.hd_po_header_id_tbl(i)

Line 8279: FROM po_lines txn_lines

8275: p_key,
8276: x_processing_row_tbl(i),
8277: txn_lines.po_line_id,
8278: txn_lines.line_num
8279: FROM po_lines txn_lines
8280: WHERE x_lines.item_tbl(i) IS NULL
8281: AND x_lines.vendor_product_num_tbl(i) IS NULL
8282: AND x_lines.job_name_tbl(i) IS NOT NULL
8283: AND txn_lines.po_header_id = x_lines.hd_po_header_id_tbl(i)

Line 8285: FROM po_lines_draft_all draft_lines

8281: AND x_lines.vendor_product_num_tbl(i) IS NULL
8282: AND x_lines.job_name_tbl(i) IS NOT NULL
8283: AND txn_lines.po_header_id = x_lines.hd_po_header_id_tbl(i)
8284: AND NOT EXISTS ( SELECT 1
8285: FROM po_lines_draft_all draft_lines
8286: WHERE draft_lines.po_line_id = txn_lines.po_line_id
8287: AND draft_lines.draft_id = x_lines.draft_id_tbl(i))
8288: AND EXISTS (SELECT 1
8289: FROM per_jobs_vl

Line 8505: FROM po_lines_draft_all draft_lines

8501: p_key,
8502: x_processing_row_tbl(i),
8503: draft_lines.po_line_id,
8504: draft_lines.line_num
8505: FROM po_lines_draft_all draft_lines
8506: WHERE x_lines.item_tbl(i) IS NULL
8507: AND x_lines.vendor_product_num_tbl(i) IS NULL
8508: AND x_lines.job_name_tbl(i) IS NULL
8509: AND x_lines.line_num_tbl(i) IS NOT NULL

Line 8531: FROM po_lines txn_lines

8527: p_key,
8528: x_processing_row_tbl(i),
8529: txn_lines.po_line_id,
8530: txn_lines.line_num
8531: FROM po_lines txn_lines
8532: WHERE x_lines.item_tbl(i) IS NULL
8533: AND x_lines.vendor_product_num_tbl(i) IS NULL
8534: AND x_lines.job_name_tbl(i) IS NULL
8535: AND x_lines.line_num_tbl(i) IS NOT NULL

Line 8538: FROM po_lines_draft_all draft_lines

8534: AND x_lines.job_name_tbl(i) IS NULL
8535: AND x_lines.line_num_tbl(i) IS NOT NULL
8536: AND txn_lines.po_header_id = x_lines.hd_po_header_id_tbl(i)
8537: AND NOT EXISTS ( SELECT 1
8538: FROM po_lines_draft_all draft_lines
8539: WHERE draft_lines.po_line_id = txn_lines.po_line_id
8540: AND draft_lines.draft_id = x_lines.draft_id_tbl(i))
8541: AND txn_lines.line_num = x_lines.line_num_tbl(i)
8542: AND NVL(txn_lines.expiration_date, TRUNC(sysdate)) >= TRUNC(sysdate)

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 9502: FROM po_lines_all pli

9498: FROM dual;
9499:
9500: UPDATE po_session_gt psg
9501: SET psg.num3 = ( SELECT PLI.po_line_id
9502: FROM po_lines_all pli
9503: WHERE PLI.po_header_id = psg.num2
9504: AND PLI.line_num_display = psg.char1
9505: )
9506: WHERE psg.num2 IS NOT null

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: )