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.WIP_OSP dependencies on PO_TBL_NUMBER

Line 1752: req_line_id => PO_TBL_NUMBER(p_req_line_id),

1748: line_changes => NULL,
1749: distribution_changes => NULL);
1750:
1751: l_req_changes.line_changes := PO_REQ_LINES_REC_TYPE(
1752: req_line_id => PO_TBL_NUMBER(p_req_line_id),
1753: unit_price => PO_TBL_NUMBER(NULL),
1754: currency_unit_price => PO_TBL_NUMBER(NULL),
1755: quantity => PO_TBL_NUMBER(NULL),
1756: secondary_quantity => PO_TBL_NUMBER(NULL),

Line 1753: unit_price => PO_TBL_NUMBER(NULL),

1749: distribution_changes => NULL);
1750:
1751: l_req_changes.line_changes := PO_REQ_LINES_REC_TYPE(
1752: req_line_id => PO_TBL_NUMBER(p_req_line_id),
1753: unit_price => PO_TBL_NUMBER(NULL),
1754: currency_unit_price => PO_TBL_NUMBER(NULL),
1755: quantity => PO_TBL_NUMBER(NULL),
1756: secondary_quantity => PO_TBL_NUMBER(NULL),
1757: need_by_date => PO_TBL_DATE(p_new_NBD),

Line 1754: currency_unit_price => PO_TBL_NUMBER(NULL),

1750:
1751: l_req_changes.line_changes := PO_REQ_LINES_REC_TYPE(
1752: req_line_id => PO_TBL_NUMBER(p_req_line_id),
1753: unit_price => PO_TBL_NUMBER(NULL),
1754: currency_unit_price => PO_TBL_NUMBER(NULL),
1755: quantity => PO_TBL_NUMBER(NULL),
1756: secondary_quantity => PO_TBL_NUMBER(NULL),
1757: need_by_date => PO_TBL_DATE(p_new_NBD),
1758: deliver_to_location_id => PO_TBL_NUMBER(NULL),

Line 1755: quantity => PO_TBL_NUMBER(NULL),

1751: l_req_changes.line_changes := PO_REQ_LINES_REC_TYPE(
1752: req_line_id => PO_TBL_NUMBER(p_req_line_id),
1753: unit_price => PO_TBL_NUMBER(NULL),
1754: currency_unit_price => PO_TBL_NUMBER(NULL),
1755: quantity => PO_TBL_NUMBER(NULL),
1756: secondary_quantity => PO_TBL_NUMBER(NULL),
1757: need_by_date => PO_TBL_DATE(p_new_NBD),
1758: deliver_to_location_id => PO_TBL_NUMBER(NULL),
1759: assignment_start_date => PO_TBL_DATE(NULL),

Line 1756: secondary_quantity => PO_TBL_NUMBER(NULL),

1752: req_line_id => PO_TBL_NUMBER(p_req_line_id),
1753: unit_price => PO_TBL_NUMBER(NULL),
1754: currency_unit_price => PO_TBL_NUMBER(NULL),
1755: quantity => PO_TBL_NUMBER(NULL),
1756: secondary_quantity => PO_TBL_NUMBER(NULL),
1757: need_by_date => PO_TBL_DATE(p_new_NBD),
1758: deliver_to_location_id => PO_TBL_NUMBER(NULL),
1759: assignment_start_date => PO_TBL_DATE(NULL),
1760: assignment_end_date => PO_TBL_DATE(NULL),

Line 1758: deliver_to_location_id => PO_TBL_NUMBER(NULL),

1754: currency_unit_price => PO_TBL_NUMBER(NULL),
1755: quantity => PO_TBL_NUMBER(NULL),
1756: secondary_quantity => PO_TBL_NUMBER(NULL),
1757: need_by_date => PO_TBL_DATE(p_new_NBD),
1758: deliver_to_location_id => PO_TBL_NUMBER(NULL),
1759: assignment_start_date => PO_TBL_DATE(NULL),
1760: assignment_end_date => PO_TBL_DATE(NULL),
1761: amount => PO_TBL_NUMBER(NULL));
1762:

Line 1761: amount => PO_TBL_NUMBER(NULL));

1757: need_by_date => PO_TBL_DATE(p_new_NBD),
1758: deliver_to_location_id => PO_TBL_NUMBER(NULL),
1759: assignment_start_date => PO_TBL_DATE(NULL),
1760: assignment_end_date => PO_TBL_DATE(NULL),
1761: amount => PO_TBL_NUMBER(NULL));
1762:
1763: po_wip_integration_grp.update_requisition(
1764: p_api_version => 1.0,
1765: p_req_changes => l_req_changes,

Line 2305: req_line_id => PO_TBL_NUMBER(l_update_po_qty.req_line_id),

2301: req_header_id => l_update_po_qty.req_header_id,
2302: line_changes => NULL,
2303: distribution_changes => NULL);
2304: l_req_changes.line_changes := PO_REQ_LINES_REC_TYPE(
2305: req_line_id => PO_TBL_NUMBER(l_update_po_qty.req_line_id),
2306: unit_price => PO_TBL_NUMBER(NULL),
2307: currency_unit_price => PO_TBL_NUMBER(NULL),
2308: quantity => PO_TBL_NUMBER(l_update_po_qty.new_po_qty),
2309: secondary_quantity => PO_TBL_NUMBER(NULL),

Line 2306: unit_price => PO_TBL_NUMBER(NULL),

2302: line_changes => NULL,
2303: distribution_changes => NULL);
2304: l_req_changes.line_changes := PO_REQ_LINES_REC_TYPE(
2305: req_line_id => PO_TBL_NUMBER(l_update_po_qty.req_line_id),
2306: unit_price => PO_TBL_NUMBER(NULL),
2307: currency_unit_price => PO_TBL_NUMBER(NULL),
2308: quantity => PO_TBL_NUMBER(l_update_po_qty.new_po_qty),
2309: secondary_quantity => PO_TBL_NUMBER(NULL),
2310: need_by_date => PO_TBL_DATE(NULL),

Line 2307: currency_unit_price => PO_TBL_NUMBER(NULL),

2303: distribution_changes => NULL);
2304: l_req_changes.line_changes := PO_REQ_LINES_REC_TYPE(
2305: req_line_id => PO_TBL_NUMBER(l_update_po_qty.req_line_id),
2306: unit_price => PO_TBL_NUMBER(NULL),
2307: currency_unit_price => PO_TBL_NUMBER(NULL),
2308: quantity => PO_TBL_NUMBER(l_update_po_qty.new_po_qty),
2309: secondary_quantity => PO_TBL_NUMBER(NULL),
2310: need_by_date => PO_TBL_DATE(NULL),
2311: deliver_to_location_id => PO_TBL_NUMBER(NULL),

Line 2308: quantity => PO_TBL_NUMBER(l_update_po_qty.new_po_qty),

2304: l_req_changes.line_changes := PO_REQ_LINES_REC_TYPE(
2305: req_line_id => PO_TBL_NUMBER(l_update_po_qty.req_line_id),
2306: unit_price => PO_TBL_NUMBER(NULL),
2307: currency_unit_price => PO_TBL_NUMBER(NULL),
2308: quantity => PO_TBL_NUMBER(l_update_po_qty.new_po_qty),
2309: secondary_quantity => PO_TBL_NUMBER(NULL),
2310: need_by_date => PO_TBL_DATE(NULL),
2311: deliver_to_location_id => PO_TBL_NUMBER(NULL),
2312: assignment_start_date => PO_TBL_DATE(NULL),

Line 2309: secondary_quantity => PO_TBL_NUMBER(NULL),

2305: req_line_id => PO_TBL_NUMBER(l_update_po_qty.req_line_id),
2306: unit_price => PO_TBL_NUMBER(NULL),
2307: currency_unit_price => PO_TBL_NUMBER(NULL),
2308: quantity => PO_TBL_NUMBER(l_update_po_qty.new_po_qty),
2309: secondary_quantity => PO_TBL_NUMBER(NULL),
2310: need_by_date => PO_TBL_DATE(NULL),
2311: deliver_to_location_id => PO_TBL_NUMBER(NULL),
2312: assignment_start_date => PO_TBL_DATE(NULL),
2313: assignment_end_date => PO_TBL_DATE(NULL),

Line 2311: deliver_to_location_id => PO_TBL_NUMBER(NULL),

2307: currency_unit_price => PO_TBL_NUMBER(NULL),
2308: quantity => PO_TBL_NUMBER(l_update_po_qty.new_po_qty),
2309: secondary_quantity => PO_TBL_NUMBER(NULL),
2310: need_by_date => PO_TBL_DATE(NULL),
2311: deliver_to_location_id => PO_TBL_NUMBER(NULL),
2312: assignment_start_date => PO_TBL_DATE(NULL),
2313: assignment_end_date => PO_TBL_DATE(NULL),
2314: amount => PO_TBL_NUMBER(NULL));
2315:

Line 2314: amount => PO_TBL_NUMBER(NULL));

2310: need_by_date => PO_TBL_DATE(NULL),
2311: deliver_to_location_id => PO_TBL_NUMBER(NULL),
2312: assignment_start_date => PO_TBL_DATE(NULL),
2313: assignment_end_date => PO_TBL_DATE(NULL),
2314: amount => PO_TBL_NUMBER(NULL));
2315:
2316: IF (l_logLevel <= wip_constants.full_logging) THEN
2317: l_debugMsg := 'req_header_id = ' || l_update_po_qty.req_header_id
2318: || ' ; ' || 'req_line_id = ' ||

Line 2573: p_doc_id => PO_TBL_NUMBER(l_po_req.po_header_id),

2569: po_wip_integration_grp.cancel_document
2570: (p_api_version => 1.0,
2571: p_doc_type => PO_TBL_VARCHAR30(l_po_req.document_type),
2572: p_doc_subtype => PO_TBL_VARCHAR30(l_po_req.document_subtype),
2573: p_doc_id => PO_TBL_NUMBER(l_po_req.po_header_id),
2574: p_doc_num => PO_TBL_VARCHAR30(NULL),
2575: p_release_id => PO_TBL_NUMBER(l_po_req.po_release_id),
2576: p_release_num => PO_TBL_NUMBER(NULL),
2577: p_doc_line_id => PO_TBL_NUMBER(l_po_req.po_line_id),

Line 2575: p_release_id => PO_TBL_NUMBER(l_po_req.po_release_id),

2571: p_doc_type => PO_TBL_VARCHAR30(l_po_req.document_type),
2572: p_doc_subtype => PO_TBL_VARCHAR30(l_po_req.document_subtype),
2573: p_doc_id => PO_TBL_NUMBER(l_po_req.po_header_id),
2574: p_doc_num => PO_TBL_VARCHAR30(NULL),
2575: p_release_id => PO_TBL_NUMBER(l_po_req.po_release_id),
2576: p_release_num => PO_TBL_NUMBER(NULL),
2577: p_doc_line_id => PO_TBL_NUMBER(l_po_req.po_line_id),
2578: p_doc_line_num => PO_TBL_NUMBER(NULL),
2579: p_doc_line_loc_id => PO_TBL_NUMBER(l_po_req.po_line_location_id),

Line 2576: p_release_num => PO_TBL_NUMBER(NULL),

2572: p_doc_subtype => PO_TBL_VARCHAR30(l_po_req.document_subtype),
2573: p_doc_id => PO_TBL_NUMBER(l_po_req.po_header_id),
2574: p_doc_num => PO_TBL_VARCHAR30(NULL),
2575: p_release_id => PO_TBL_NUMBER(l_po_req.po_release_id),
2576: p_release_num => PO_TBL_NUMBER(NULL),
2577: p_doc_line_id => PO_TBL_NUMBER(l_po_req.po_line_id),
2578: p_doc_line_num => PO_TBL_NUMBER(NULL),
2579: p_doc_line_loc_id => PO_TBL_NUMBER(l_po_req.po_line_location_id),
2580: p_doc_shipment_num => PO_TBL_NUMBER(NULL),

Line 2577: p_doc_line_id => PO_TBL_NUMBER(l_po_req.po_line_id),

2573: p_doc_id => PO_TBL_NUMBER(l_po_req.po_header_id),
2574: p_doc_num => PO_TBL_VARCHAR30(NULL),
2575: p_release_id => PO_TBL_NUMBER(l_po_req.po_release_id),
2576: p_release_num => PO_TBL_NUMBER(NULL),
2577: p_doc_line_id => PO_TBL_NUMBER(l_po_req.po_line_id),
2578: p_doc_line_num => PO_TBL_NUMBER(NULL),
2579: p_doc_line_loc_id => PO_TBL_NUMBER(l_po_req.po_line_location_id),
2580: p_doc_shipment_num => PO_TBL_NUMBER(NULL),
2581: p_source => NULL,

Line 2578: p_doc_line_num => PO_TBL_NUMBER(NULL),

2574: p_doc_num => PO_TBL_VARCHAR30(NULL),
2575: p_release_id => PO_TBL_NUMBER(l_po_req.po_release_id),
2576: p_release_num => PO_TBL_NUMBER(NULL),
2577: p_doc_line_id => PO_TBL_NUMBER(l_po_req.po_line_id),
2578: p_doc_line_num => PO_TBL_NUMBER(NULL),
2579: p_doc_line_loc_id => PO_TBL_NUMBER(l_po_req.po_line_location_id),
2580: p_doc_shipment_num => PO_TBL_NUMBER(NULL),
2581: p_source => NULL,
2582: p_cancel_date => SYSDATE,

Line 2579: p_doc_line_loc_id => PO_TBL_NUMBER(l_po_req.po_line_location_id),

2575: p_release_id => PO_TBL_NUMBER(l_po_req.po_release_id),
2576: p_release_num => PO_TBL_NUMBER(NULL),
2577: p_doc_line_id => PO_TBL_NUMBER(l_po_req.po_line_id),
2578: p_doc_line_num => PO_TBL_NUMBER(NULL),
2579: p_doc_line_loc_id => PO_TBL_NUMBER(l_po_req.po_line_location_id),
2580: p_doc_shipment_num => PO_TBL_NUMBER(NULL),
2581: p_source => NULL,
2582: p_cancel_date => SYSDATE,
2583: p_cancel_reason => NULL,

Line 2580: p_doc_shipment_num => PO_TBL_NUMBER(NULL),

2576: p_release_num => PO_TBL_NUMBER(NULL),
2577: p_doc_line_id => PO_TBL_NUMBER(l_po_req.po_line_id),
2578: p_doc_line_num => PO_TBL_NUMBER(NULL),
2579: p_doc_line_loc_id => PO_TBL_NUMBER(l_po_req.po_line_location_id),
2580: p_doc_shipment_num => PO_TBL_NUMBER(NULL),
2581: p_source => NULL,
2582: p_cancel_date => SYSDATE,
2583: p_cancel_reason => NULL,
2584: p_cancel_reqs_flag => 'Y',

Line 2608: p_req_header_id => PO_TBL_NUMBER(l_po_req.req_header_id),

2604: END IF;
2605: -- Call PO API to cancel requisition
2606: po_wip_integration_grp.cancel_requisition
2607: (p_api_version => 1.0,
2608: p_req_header_id => PO_TBL_NUMBER(l_po_req.req_header_id),
2609: p_req_line_id => PO_TBL_NUMBER(l_po_req.req_line_id),
2610: p_cancel_date => SYSDATE,
2611: p_cancel_reason => NULL,
2612: p_source => NULL,

Line 2609: p_req_line_id => PO_TBL_NUMBER(l_po_req.req_line_id),

2605: -- Call PO API to cancel requisition
2606: po_wip_integration_grp.cancel_requisition
2607: (p_api_version => 1.0,
2608: p_req_header_id => PO_TBL_NUMBER(l_po_req.req_header_id),
2609: p_req_line_id => PO_TBL_NUMBER(l_po_req.req_line_id),
2610: p_cancel_date => SYSDATE,
2611: p_cancel_reason => NULL,
2612: p_source => NULL,
2613: x_return_status => x_return_status,