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 1659: req_line_id => PO_TBL_NUMBER(p_req_line_id),

1655: line_changes => NULL,
1656: distribution_changes => NULL);
1657:
1658: l_req_changes.line_changes := PO_REQ_LINES_REC_TYPE(
1659: req_line_id => PO_TBL_NUMBER(p_req_line_id),
1660: unit_price => PO_TBL_NUMBER(NULL),
1661: currency_unit_price => PO_TBL_NUMBER(NULL),
1662: quantity => PO_TBL_NUMBER(NULL),
1663: secondary_quantity => PO_TBL_NUMBER(NULL),

Line 1660: unit_price => PO_TBL_NUMBER(NULL),

1656: distribution_changes => NULL);
1657:
1658: l_req_changes.line_changes := PO_REQ_LINES_REC_TYPE(
1659: req_line_id => PO_TBL_NUMBER(p_req_line_id),
1660: unit_price => PO_TBL_NUMBER(NULL),
1661: currency_unit_price => PO_TBL_NUMBER(NULL),
1662: quantity => PO_TBL_NUMBER(NULL),
1663: secondary_quantity => PO_TBL_NUMBER(NULL),
1664: need_by_date => PO_TBL_DATE(p_new_NBD),

Line 1661: currency_unit_price => PO_TBL_NUMBER(NULL),

1657:
1658: l_req_changes.line_changes := PO_REQ_LINES_REC_TYPE(
1659: req_line_id => PO_TBL_NUMBER(p_req_line_id),
1660: unit_price => PO_TBL_NUMBER(NULL),
1661: currency_unit_price => PO_TBL_NUMBER(NULL),
1662: quantity => PO_TBL_NUMBER(NULL),
1663: secondary_quantity => PO_TBL_NUMBER(NULL),
1664: need_by_date => PO_TBL_DATE(p_new_NBD),
1665: deliver_to_location_id => PO_TBL_NUMBER(NULL),

Line 1662: quantity => PO_TBL_NUMBER(NULL),

1658: l_req_changes.line_changes := PO_REQ_LINES_REC_TYPE(
1659: req_line_id => PO_TBL_NUMBER(p_req_line_id),
1660: unit_price => PO_TBL_NUMBER(NULL),
1661: currency_unit_price => PO_TBL_NUMBER(NULL),
1662: quantity => PO_TBL_NUMBER(NULL),
1663: secondary_quantity => PO_TBL_NUMBER(NULL),
1664: need_by_date => PO_TBL_DATE(p_new_NBD),
1665: deliver_to_location_id => PO_TBL_NUMBER(NULL),
1666: assignment_start_date => PO_TBL_DATE(NULL),

Line 1663: secondary_quantity => PO_TBL_NUMBER(NULL),

1659: req_line_id => PO_TBL_NUMBER(p_req_line_id),
1660: unit_price => PO_TBL_NUMBER(NULL),
1661: currency_unit_price => PO_TBL_NUMBER(NULL),
1662: quantity => PO_TBL_NUMBER(NULL),
1663: secondary_quantity => PO_TBL_NUMBER(NULL),
1664: need_by_date => PO_TBL_DATE(p_new_NBD),
1665: deliver_to_location_id => PO_TBL_NUMBER(NULL),
1666: assignment_start_date => PO_TBL_DATE(NULL),
1667: assignment_end_date => PO_TBL_DATE(NULL),

Line 1665: deliver_to_location_id => PO_TBL_NUMBER(NULL),

1661: currency_unit_price => PO_TBL_NUMBER(NULL),
1662: quantity => PO_TBL_NUMBER(NULL),
1663: secondary_quantity => PO_TBL_NUMBER(NULL),
1664: need_by_date => PO_TBL_DATE(p_new_NBD),
1665: deliver_to_location_id => PO_TBL_NUMBER(NULL),
1666: assignment_start_date => PO_TBL_DATE(NULL),
1667: assignment_end_date => PO_TBL_DATE(NULL),
1668: amount => PO_TBL_NUMBER(NULL));
1669:

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

1664: need_by_date => PO_TBL_DATE(p_new_NBD),
1665: deliver_to_location_id => PO_TBL_NUMBER(NULL),
1666: assignment_start_date => PO_TBL_DATE(NULL),
1667: assignment_end_date => PO_TBL_DATE(NULL),
1668: amount => PO_TBL_NUMBER(NULL));
1669:
1670: po_wip_integration_grp.update_requisition(
1671: p_api_version => 1.0,
1672: p_req_changes => l_req_changes,

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

2168: req_header_id => l_update_po_qty.req_header_id,
2169: line_changes => NULL,
2170: distribution_changes => NULL);
2171: l_req_changes.line_changes := PO_REQ_LINES_REC_TYPE(
2172: req_line_id => PO_TBL_NUMBER(l_update_po_qty.req_line_id),
2173: unit_price => PO_TBL_NUMBER(NULL),
2174: currency_unit_price => PO_TBL_NUMBER(NULL),
2175: quantity => PO_TBL_NUMBER(l_update_po_qty.new_po_qty),
2176: secondary_quantity => PO_TBL_NUMBER(NULL),

Line 2173: unit_price => PO_TBL_NUMBER(NULL),

2169: line_changes => NULL,
2170: distribution_changes => NULL);
2171: l_req_changes.line_changes := PO_REQ_LINES_REC_TYPE(
2172: req_line_id => PO_TBL_NUMBER(l_update_po_qty.req_line_id),
2173: unit_price => PO_TBL_NUMBER(NULL),
2174: currency_unit_price => PO_TBL_NUMBER(NULL),
2175: quantity => PO_TBL_NUMBER(l_update_po_qty.new_po_qty),
2176: secondary_quantity => PO_TBL_NUMBER(NULL),
2177: need_by_date => PO_TBL_DATE(NULL),

Line 2174: currency_unit_price => PO_TBL_NUMBER(NULL),

2170: distribution_changes => NULL);
2171: l_req_changes.line_changes := PO_REQ_LINES_REC_TYPE(
2172: req_line_id => PO_TBL_NUMBER(l_update_po_qty.req_line_id),
2173: unit_price => PO_TBL_NUMBER(NULL),
2174: currency_unit_price => PO_TBL_NUMBER(NULL),
2175: quantity => PO_TBL_NUMBER(l_update_po_qty.new_po_qty),
2176: secondary_quantity => PO_TBL_NUMBER(NULL),
2177: need_by_date => PO_TBL_DATE(NULL),
2178: deliver_to_location_id => PO_TBL_NUMBER(NULL),

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

2171: l_req_changes.line_changes := PO_REQ_LINES_REC_TYPE(
2172: req_line_id => PO_TBL_NUMBER(l_update_po_qty.req_line_id),
2173: unit_price => PO_TBL_NUMBER(NULL),
2174: currency_unit_price => PO_TBL_NUMBER(NULL),
2175: quantity => PO_TBL_NUMBER(l_update_po_qty.new_po_qty),
2176: secondary_quantity => PO_TBL_NUMBER(NULL),
2177: need_by_date => PO_TBL_DATE(NULL),
2178: deliver_to_location_id => PO_TBL_NUMBER(NULL),
2179: assignment_start_date => PO_TBL_DATE(NULL),

Line 2176: secondary_quantity => PO_TBL_NUMBER(NULL),

2172: req_line_id => PO_TBL_NUMBER(l_update_po_qty.req_line_id),
2173: unit_price => PO_TBL_NUMBER(NULL),
2174: currency_unit_price => PO_TBL_NUMBER(NULL),
2175: quantity => PO_TBL_NUMBER(l_update_po_qty.new_po_qty),
2176: secondary_quantity => PO_TBL_NUMBER(NULL),
2177: need_by_date => PO_TBL_DATE(NULL),
2178: deliver_to_location_id => PO_TBL_NUMBER(NULL),
2179: assignment_start_date => PO_TBL_DATE(NULL),
2180: assignment_end_date => PO_TBL_DATE(NULL),

Line 2178: deliver_to_location_id => PO_TBL_NUMBER(NULL),

2174: currency_unit_price => PO_TBL_NUMBER(NULL),
2175: quantity => PO_TBL_NUMBER(l_update_po_qty.new_po_qty),
2176: secondary_quantity => PO_TBL_NUMBER(NULL),
2177: need_by_date => PO_TBL_DATE(NULL),
2178: deliver_to_location_id => PO_TBL_NUMBER(NULL),
2179: assignment_start_date => PO_TBL_DATE(NULL),
2180: assignment_end_date => PO_TBL_DATE(NULL),
2181: amount => PO_TBL_NUMBER(NULL));
2182:

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

2177: need_by_date => PO_TBL_DATE(NULL),
2178: deliver_to_location_id => PO_TBL_NUMBER(NULL),
2179: assignment_start_date => PO_TBL_DATE(NULL),
2180: assignment_end_date => PO_TBL_DATE(NULL),
2181: amount => PO_TBL_NUMBER(NULL));
2182:
2183: IF (l_logLevel <= wip_constants.full_logging) THEN
2184: l_debugMsg := 'req_header_id = ' || l_update_po_qty.req_header_id
2185: || ' ; ' || 'req_line_id = ' ||

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

2407: po_wip_integration_grp.cancel_document
2408: (p_api_version => 1.0,
2409: p_doc_type => PO_TBL_VARCHAR30(l_po_req.document_type),
2410: p_doc_subtype => PO_TBL_VARCHAR30(l_po_req.document_subtype),
2411: p_doc_id => PO_TBL_NUMBER(l_po_req.po_header_id),
2412: p_doc_num => PO_TBL_VARCHAR30(NULL),
2413: p_release_id => PO_TBL_NUMBER(l_po_req.po_release_id),
2414: p_release_num => PO_TBL_NUMBER(NULL),
2415: p_doc_line_id => PO_TBL_NUMBER(l_po_req.po_line_id),

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

2409: p_doc_type => PO_TBL_VARCHAR30(l_po_req.document_type),
2410: p_doc_subtype => PO_TBL_VARCHAR30(l_po_req.document_subtype),
2411: p_doc_id => PO_TBL_NUMBER(l_po_req.po_header_id),
2412: p_doc_num => PO_TBL_VARCHAR30(NULL),
2413: p_release_id => PO_TBL_NUMBER(l_po_req.po_release_id),
2414: p_release_num => PO_TBL_NUMBER(NULL),
2415: p_doc_line_id => PO_TBL_NUMBER(l_po_req.po_line_id),
2416: p_doc_line_num => PO_TBL_NUMBER(NULL),
2417: p_doc_line_loc_id => PO_TBL_NUMBER(l_po_req.po_line_location_id),

Line 2414: p_release_num => PO_TBL_NUMBER(NULL),

2410: p_doc_subtype => PO_TBL_VARCHAR30(l_po_req.document_subtype),
2411: p_doc_id => PO_TBL_NUMBER(l_po_req.po_header_id),
2412: p_doc_num => PO_TBL_VARCHAR30(NULL),
2413: p_release_id => PO_TBL_NUMBER(l_po_req.po_release_id),
2414: p_release_num => PO_TBL_NUMBER(NULL),
2415: p_doc_line_id => PO_TBL_NUMBER(l_po_req.po_line_id),
2416: p_doc_line_num => PO_TBL_NUMBER(NULL),
2417: p_doc_line_loc_id => PO_TBL_NUMBER(l_po_req.po_line_location_id),
2418: p_doc_shipment_num => PO_TBL_NUMBER(NULL),

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

2411: p_doc_id => PO_TBL_NUMBER(l_po_req.po_header_id),
2412: p_doc_num => PO_TBL_VARCHAR30(NULL),
2413: p_release_id => PO_TBL_NUMBER(l_po_req.po_release_id),
2414: p_release_num => PO_TBL_NUMBER(NULL),
2415: p_doc_line_id => PO_TBL_NUMBER(l_po_req.po_line_id),
2416: p_doc_line_num => PO_TBL_NUMBER(NULL),
2417: p_doc_line_loc_id => PO_TBL_NUMBER(l_po_req.po_line_location_id),
2418: p_doc_shipment_num => PO_TBL_NUMBER(NULL),
2419: p_source => NULL,

Line 2416: p_doc_line_num => PO_TBL_NUMBER(NULL),

2412: p_doc_num => PO_TBL_VARCHAR30(NULL),
2413: p_release_id => PO_TBL_NUMBER(l_po_req.po_release_id),
2414: p_release_num => PO_TBL_NUMBER(NULL),
2415: p_doc_line_id => PO_TBL_NUMBER(l_po_req.po_line_id),
2416: p_doc_line_num => PO_TBL_NUMBER(NULL),
2417: p_doc_line_loc_id => PO_TBL_NUMBER(l_po_req.po_line_location_id),
2418: p_doc_shipment_num => PO_TBL_NUMBER(NULL),
2419: p_source => NULL,
2420: p_cancel_date => SYSDATE,

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

2413: p_release_id => PO_TBL_NUMBER(l_po_req.po_release_id),
2414: p_release_num => PO_TBL_NUMBER(NULL),
2415: p_doc_line_id => PO_TBL_NUMBER(l_po_req.po_line_id),
2416: p_doc_line_num => PO_TBL_NUMBER(NULL),
2417: p_doc_line_loc_id => PO_TBL_NUMBER(l_po_req.po_line_location_id),
2418: p_doc_shipment_num => PO_TBL_NUMBER(NULL),
2419: p_source => NULL,
2420: p_cancel_date => SYSDATE,
2421: p_cancel_reason => NULL,

Line 2418: p_doc_shipment_num => PO_TBL_NUMBER(NULL),

2414: p_release_num => PO_TBL_NUMBER(NULL),
2415: p_doc_line_id => PO_TBL_NUMBER(l_po_req.po_line_id),
2416: p_doc_line_num => PO_TBL_NUMBER(NULL),
2417: p_doc_line_loc_id => PO_TBL_NUMBER(l_po_req.po_line_location_id),
2418: p_doc_shipment_num => PO_TBL_NUMBER(NULL),
2419: p_source => NULL,
2420: p_cancel_date => SYSDATE,
2421: p_cancel_reason => NULL,
2422: p_cancel_reqs_flag => 'Y',

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

2442: END IF;
2443: -- Call PO API to cancel requisition
2444: po_wip_integration_grp.cancel_requisition
2445: (p_api_version => 1.0,
2446: p_req_header_id => PO_TBL_NUMBER(l_po_req.req_header_id),
2447: p_req_line_id => PO_TBL_NUMBER(l_po_req.req_line_id),
2448: p_cancel_date => SYSDATE,
2449: p_cancel_reason => NULL,
2450: p_source => NULL,

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

2443: -- Call PO API to cancel requisition
2444: po_wip_integration_grp.cancel_requisition
2445: (p_api_version => 1.0,
2446: p_req_header_id => PO_TBL_NUMBER(l_po_req.req_header_id),
2447: p_req_line_id => PO_TBL_NUMBER(l_po_req.req_line_id),
2448: p_cancel_date => SYSDATE,
2449: p_cancel_reason => NULL,
2450: p_source => NULL,
2451: x_return_status => x_return_status,