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_DOCUMENT_CANCEL_PVT dependencies on PO_HEADERS

Line 163: -- Checks if the entity(PO Headers/Line/Shipment) is either received or billed

159: --Start of Comments
160: --Name: isPartialRcvBilled
161:
162: --Function:
163: -- Checks if the entity(PO Headers/Line/Shipment) is either received or billed
164:
165: --Parameters:
166: --IN:
167: -- p_entity_level

Line 930: l_request_id PO_HEADERS.request_id%TYPE := fnd_global.conc_request_id;

926: d_module CONSTANT VARCHAR2(100) := g_module_prefix||d_api_name;
927:
928: l_progress VARCHAR2(3) := '000' ;
929: l_emp_id NUMBER := FND_GLOBAL.employee_id;
930: l_request_id PO_HEADERS.request_id%TYPE := fnd_global.conc_request_id;
931:
932: BEGIN
933: -- Start standard API initialization
934: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 1300: l_request_id PO_HEADERS.request_id%TYPE := fnd_global.conc_request_id;

1296: d_module CONSTANT VARCHAR2(100) := g_module_prefix||d_api_name;
1297:
1298: l_progress VARCHAR2(3) := '000' ;
1299: l_emp_id NUMBER := FND_GLOBAL.employee_id;
1300: l_request_id PO_HEADERS.request_id%TYPE := fnd_global.conc_request_id;
1301:
1302: BEGIN
1303: -- Start standard API initialization
1304: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 1434: -- Updates the Cancel details on PO Headers if the entity being canceled is

1430: --Name: update_po_header_cancel
1431:
1432: --Function:
1433: --
1434: -- Updates the Cancel details on PO Headers if the entity being canceled is
1435: -- PO/PA Header
1436: -- Updates the following columns :
1437: --
1438: -- Before Funds Control call

Line 1490: l_request_id PO_HEADERS.request_id%TYPE := fnd_global.conc_request_id;

1486: d_module CONSTANT VARCHAR2(100) := g_module_prefix||d_api_name;
1487:
1488: l_progress VARCHAR2(3) := '000' ;
1489: l_emp_id NUMBER := FND_GLOBAL.employee_id;
1490: l_request_id PO_HEADERS.request_id%TYPE := fnd_global.conc_request_id;
1491:
1492: BEGIN
1493: -- Start standard API initialization
1494: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 1520: UPDATE po_headers poh

1516: IF p_fc_level = c_before_FC THEN
1517:
1518: l_progress := '001' ;
1519:
1520: UPDATE po_headers poh
1521: SET poh.cancel_flag = 'I' ,
1522: poh.last_update_date = SYSDATE ,
1523: poh.note_to_vendor =p_note_to_vendor ,
1524: poh.last_updated_by = p_user_id,

Line 1541: UPDATE po_headers poh

1537: ELSE
1538: l_progress := '002' ;
1539:
1540:
1541: UPDATE po_headers poh
1542: SET poh.cancel_flag = 'Y' ,
1543: poh.closed_code = 'CLOSED',
1544: --Bug 16575765: CLOSED_DATE is always stamped(HEADER) as sysdate.
1545: --poh.closed_date = p_action_date

Line 1554: PO_DEBUG.debug_var(d_module, l_progress, 'Rows Updated in PO Headers table', SQL%ROWCOUNT);

1550: END IF;
1551:
1552:
1553: IF g_debug_stmt THEN
1554: PO_DEBUG.debug_var(d_module, l_progress, 'Rows Updated in PO Headers table', SQL%ROWCOUNT);
1555: END IF;
1556:
1557:
1558: EXCEPTION

Line 1636: l_request_id PO_HEADERS.request_id%TYPE := fnd_global.conc_request_id;

1632: d_module CONSTANT VARCHAR2(100) := g_module_prefix||d_api_name;
1633:
1634: l_progress VARCHAR2(3) := '000' ;
1635: l_emp_id NUMBER := FND_GLOBAL.employee_id;
1636: l_request_id PO_HEADERS.request_id%TYPE := fnd_global.conc_request_id;
1637:
1638: BEGIN
1639: -- Start standard API initialization
1640: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 1730: -- then updates PO Headers/Lines/Shipments/Distributions

1726: -- Updates the Cancel details on PO /Release Header/Line/Shipemnts/Distributions
1727: -- based on the entity being canceled.
1728: --
1729: -- 1. If the PO Header is Canceled i.e. entity_level=HEADER and document_type=PO
1730: -- then updates PO Headers/Lines/Shipments/Distributions
1731: --
1732: -- 2. If the Release Header is Canceled i.e. entity_level=HEADER and
1733: -- document_type =RELEASE then updates Release Header/Shipments/Distributions
1734: --

Line 4047: po_headers BLANKET

4043: PO_REQUISITION_LINES_ALL PORL_OLD,
4044: PO_REQUISITION_LINES_ALL PORL_NEW,
4045: PO_DISTRIBUTIONS_ALL POD ,
4046: PO_LINE_LOCATIONS PLL ,
4047: po_headers BLANKET
4048: WHERE
4049: PORL_NEW.requisition_line_id = p_req_line_id
4050: AND PORL_OLD.requisition_line_id = (-1) * PORL_NEW.parent_req_line_id
4051: AND PORD.requisition_line_id = PORL_OLD.requisition_line_id

Line 4358: po_headers BLANKET

4354: 'N')
4355: FROM PO_REQUISITION_LINES_ALL PORL,
4356: PO_DISTRIBUTIONS_ALL POD ,
4357: po_line_locations PLL ,
4358: po_headers BLANKET
4359: WHERE PORL.requisition_line_id = PORD.requisition_line_id
4360: AND POD.req_distribution_id = PORD.distribution_id
4361: AND POD.line_location_id = PLL.line_location_id
4362: AND PLL.shipment_type IN (

Line 5368: FROM po_headers

5364: SELECT revision_num,
5365: authorization_status
5366: INTO l_orig_revision_num,
5367: l_head_auth_status
5368: FROM po_headers
5369: WHERE PO_HEADER_ID = p_doc_id;
5370:
5371: END IF;
5372:

Line 5479: UPDATE po_headers

5475: PO_DEBUG.debug_var(d_module, l_progress, 'Rows updated in PO Releases', SQL%ROWCOUNT);
5476: END IF;
5477:
5478: ELSE
5479: UPDATE po_headers
5480: SET REVISION_NUM = l_revision_num,
5481: REVISED_DATE = DECODE(
5482: revision_num,
5483: l_revision_num,

Line 5492: PO_DEBUG.debug_var(d_module, l_progress, 'Rows updated in PO Headers', SQL%ROWCOUNT);

5488: LAST_UPDATE_LOGIN = p_login_id
5489: WHERE PO_HEADER_ID = p_doc_id;
5490:
5491: IF g_debug_stmt THEN
5492: PO_DEBUG.debug_var(d_module, l_progress, 'Rows updated in PO Headers', SQL%ROWCOUNT);
5493: END IF;
5494:
5495: END IF; --if l_document_type = c_doc_type_RELEASE
5496:

Line 5920: FROM po_headers

5916: BEGIN
5917:
5918: SELECT Nvl(encumbrance_required_flag,'N')
5919: INTO l_enc_req_flag
5920: FROM po_headers
5921: WHERE po_header_id=l_entity_rec_tbl(i).entity_id;
5922:
5923: EXCEPTION
5924: WHEN No_Data_Found THEN

Line 6539: p_doc_id IN PO_HEADERS.po_header_id%TYPE,

6535: * Notes : See Bug 4571297
6536: * : Added No_data_found execption as part of Cancel Refactoring Project
6537: */
6538: FUNCTION is_document_cto_order (
6539: p_doc_id IN PO_HEADERS.po_header_id%TYPE,
6540: p_doc_type IN PO_DOCUMENT_TYPES_ALL_B.document_type_code%TYPE )
6541:
6542: RETURN BOOLEAN
6543: IS