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_UPDATE_PVT dependencies on PO_HEADERS_ALL

Line 245: -- will be applied to the database tables (ex. PO_HEADERS_ALL,

241: -- resp_id => ,
242: -- resp_appl_id => 201 );
243: --Modifies:
244: -- If all validations are successful, the requested and derived changes
245: -- will be applied to the database tables (ex. PO_HEADERS_ALL,
246: -- PO_LINES_ALL, etc.).
247: -- p_changes will be updated with all of the derived changes, including
248: -- the new LINE_LOCATION_ID and PO_DISTRIBUTION_ID for each split shipment
249: -- and split distribution.

Line 605: l_currency_code PO_HEADERS_ALL.currency_code%TYPE;

601: --End of Comments
602: -------------------------------------------------------------------------------
603: PROCEDURE init_document_globals IS
604: l_proc_name CONSTANT VARCHAR2(30) := 'INIT_DOCUMENT_GLOBALS';
605: l_currency_code PO_HEADERS_ALL.currency_code%TYPE;
606: BEGIN
607: -- Retrieve header information: document subtype, revision, etc.
608: IF (g_po_header_id IS NOT NULL) THEN -- PO or PA
609:

Line 735: p_table_name => 'PO_HEADERS_ALL',

731: add_error (
732: p_api_errors => g_api_errors,
733: x_return_status => x_return_status,
734: p_message_name => 'PO_INVALID_DOC_IDS',
735: p_table_name => 'PO_HEADERS_ALL',
736: p_column_name => 'PO_HEADER_ID',
737: p_entity_type => G_ENTITY_TYPE_CHANGES
738: );
739: RETURN; -- Do not continue with the remaining checks.

Line 1162: po_headers_all POHA,

1158: p_chg.line_changes.t_manual_price_change_flag(i),
1159: p_chg.line_changes.c_preferred_grade(i) --INVCONV
1160: FROM po_lines POL,
1161: po_line_types PLT,
1162: po_headers_all POHA,
1163: mtl_system_items_b MSI,
1164: financials_system_parameters FSP
1165: WHERE POL.po_line_id = p_chg.line_changes.po_line_id(i)
1166: AND PLT.line_type_id = POL.line_type_id -- JOIN

Line 5965: p_table_name => 'PO_HEADERS_ALL',

5961:
5962: add_error ( p_api_errors => g_api_errors,
5963: x_return_status => x_return_status,
5964: p_message_name => 'PO_CHNG_PCARD_RESTRICTED',
5965: p_table_name => 'PO_HEADERS_ALL',
5966: p_column_name => 'PCARD_ID',
5967: p_entity_type => G_ENTITY_TYPE_SHIPMENTS,
5968: p_entity_id => i );
5969: END IF; -- new quantity, new price, and PCARD*/

Line 6669: -- Updates PO_HEADERS_ALL, PO_RELEASES_ALL, PO_LINES_ALL,

6665: -- Applies the requested and derived changes to the database tables.
6666: --Pre-reqs:
6667: -- None.
6668: --Modifies:
6669: -- Updates PO_HEADERS_ALL, PO_RELEASES_ALL, PO_LINES_ALL,
6670: -- PO_LINE_LOCATIONS_ALL, PO_DISTRIBUTIONS_ALL with the changes.
6671: --Locks:
6672: -- None.
6673: --End of Comments

Line 6696: l_new_auth_status PO_HEADERS_ALL.authorization_status%TYPE;

6692: l_po_entity_type PO_PRICE_DIFFERENTIALS.entity_type%TYPE;
6693: l_po_entity_id PO_PRICE_DIFFERENTIALS.entity_id%TYPE;
6694:
6695: --
6696: l_new_auth_status PO_HEADERS_ALL.authorization_status%TYPE;
6697:
6698: BEGIN
6699: IF (g_fnd_debug = 'Y') THEN
6700: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

Line 8016: -- 'PO' or 'PA': PO_HEADERS_ALL.po_header_id

8012: --Parameters:
8013: --IN:
8014: --p_document_id
8015: -- This value for this parameter depends on the p_document_type:
8016: -- 'PO' or 'PA': PO_HEADERS_ALL.po_header_id
8017: -- 'RELEASE': PO_RELEASES_ALL.po_release_id
8018: --p_document_type
8019: -- 'PO', 'PA', 'RELEASE'
8020: --p_document_subtype

Line 8022: -- 'PO' or 'PA': PO_HEADERS_ALL.type_lookup_code

8018: --p_document_type
8019: -- 'PO', 'PA', 'RELEASE'
8020: --p_document_subtype
8021: -- The value for this parameter depends on the p_document_type:
8022: -- 'PO' or 'PA': PO_HEADERS_ALL.type_lookup_code
8023: -- 'RELEASE': PO_RELEASES_ALL.release_type
8024: --p_preparer_id
8025: -- EMPLOYEE_ID of the buyer whose approval authority should be used in the
8026: -- approval workflow; if NULL, use the buyer on the document.

Line 8066: l_preparer_id PO_HEADERS_ALL.agent_id%TYPE;

8062: l_proc_name CONSTANT VARCHAR2(30) := 'LAUNCH_PO_APPROVAL_WF';
8063: l_api_version CONSTANT NUMBER := 1.0;
8064: l_progress VARCHAR2(3) := '000';
8065:
8066: l_preparer_id PO_HEADERS_ALL.agent_id%TYPE;
8067: l_printflag VARCHAR2(1) := 'N';
8068: l_faxflag VARCHAR2(1) := 'N';
8069: l_faxnum VARCHAR2(30); --Bug 5765243
8070: l_emailflag VARCHAR2(1) := 'N';

Line 8866: l_doc_subtype PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;

8862: ,x_error_message OUT NOCOPY VARCHAR2)
8863: IS
8864: l_modify_action_allowed BOOLEAN := FALSE;
8865: l_style_disp_name PO_DOC_STYLE_LINES_TL.display_name%TYPE;
8866: l_doc_subtype PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
8867: l_closed_code PO_HEADERS_ALL.closed_code%TYPE;
8868: l_doc_approved_date PO_HEADERS_ALL.approved_date%TYPE;
8869: l_doc_approved_flag PO_HEADERS_ALL.approved_flag%TYPE;
8870: l_auth_status PO_HEADERS_ALL.authorization_status%TYPE;

Line 8867: l_closed_code PO_HEADERS_ALL.closed_code%TYPE;

8863: IS
8864: l_modify_action_allowed BOOLEAN := FALSE;
8865: l_style_disp_name PO_DOC_STYLE_LINES_TL.display_name%TYPE;
8866: l_doc_subtype PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
8867: l_closed_code PO_HEADERS_ALL.closed_code%TYPE;
8868: l_doc_approved_date PO_HEADERS_ALL.approved_date%TYPE;
8869: l_doc_approved_flag PO_HEADERS_ALL.approved_flag%TYPE;
8870: l_auth_status PO_HEADERS_ALL.authorization_status%TYPE;
8871: l_frozen_flag PO_HEADERS_ALL.frozen_flag%TYPE;

Line 8868: l_doc_approved_date PO_HEADERS_ALL.approved_date%TYPE;

8864: l_modify_action_allowed BOOLEAN := FALSE;
8865: l_style_disp_name PO_DOC_STYLE_LINES_TL.display_name%TYPE;
8866: l_doc_subtype PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
8867: l_closed_code PO_HEADERS_ALL.closed_code%TYPE;
8868: l_doc_approved_date PO_HEADERS_ALL.approved_date%TYPE;
8869: l_doc_approved_flag PO_HEADERS_ALL.approved_flag%TYPE;
8870: l_auth_status PO_HEADERS_ALL.authorization_status%TYPE;
8871: l_frozen_flag PO_HEADERS_ALL.frozen_flag%TYPE;
8872: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%type;

Line 8869: l_doc_approved_flag PO_HEADERS_ALL.approved_flag%TYPE;

8865: l_style_disp_name PO_DOC_STYLE_LINES_TL.display_name%TYPE;
8866: l_doc_subtype PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
8867: l_closed_code PO_HEADERS_ALL.closed_code%TYPE;
8868: l_doc_approved_date PO_HEADERS_ALL.approved_date%TYPE;
8869: l_doc_approved_flag PO_HEADERS_ALL.approved_flag%TYPE;
8870: l_auth_status PO_HEADERS_ALL.authorization_status%TYPE;
8871: l_frozen_flag PO_HEADERS_ALL.frozen_flag%TYPE;
8872: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%type;
8873: l_consigned_consumption_flag PO_HEADERS_ALL.consigned_consumption_flag%type;

Line 8870: l_auth_status PO_HEADERS_ALL.authorization_status%TYPE;

8866: l_doc_subtype PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
8867: l_closed_code PO_HEADERS_ALL.closed_code%TYPE;
8868: l_doc_approved_date PO_HEADERS_ALL.approved_date%TYPE;
8869: l_doc_approved_flag PO_HEADERS_ALL.approved_flag%TYPE;
8870: l_auth_status PO_HEADERS_ALL.authorization_status%TYPE;
8871: l_frozen_flag PO_HEADERS_ALL.frozen_flag%TYPE;
8872: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%type;
8873: l_consigned_consumption_flag PO_HEADERS_ALL.consigned_consumption_flag%type;
8874: l_cancel_flag PO_HEADERS_ALL.cancel_flag%type;

Line 8871: l_frozen_flag PO_HEADERS_ALL.frozen_flag%TYPE;

8867: l_closed_code PO_HEADERS_ALL.closed_code%TYPE;
8868: l_doc_approved_date PO_HEADERS_ALL.approved_date%TYPE;
8869: l_doc_approved_flag PO_HEADERS_ALL.approved_flag%TYPE;
8870: l_auth_status PO_HEADERS_ALL.authorization_status%TYPE;
8871: l_frozen_flag PO_HEADERS_ALL.frozen_flag%TYPE;
8872: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%type;
8873: l_consigned_consumption_flag PO_HEADERS_ALL.consigned_consumption_flag%type;
8874: l_cancel_flag PO_HEADERS_ALL.cancel_flag%type;
8875: l_ga_flag PO_HEADERS_ALL.global_agreement_flag%type;

Line 8872: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%type;

8868: l_doc_approved_date PO_HEADERS_ALL.approved_date%TYPE;
8869: l_doc_approved_flag PO_HEADERS_ALL.approved_flag%TYPE;
8870: l_auth_status PO_HEADERS_ALL.authorization_status%TYPE;
8871: l_frozen_flag PO_HEADERS_ALL.frozen_flag%TYPE;
8872: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%type;
8873: l_consigned_consumption_flag PO_HEADERS_ALL.consigned_consumption_flag%type;
8874: l_cancel_flag PO_HEADERS_ALL.cancel_flag%type;
8875: l_ga_flag PO_HEADERS_ALL.global_agreement_flag%type;
8876: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE;

Line 8873: l_consigned_consumption_flag PO_HEADERS_ALL.consigned_consumption_flag%type;

8869: l_doc_approved_flag PO_HEADERS_ALL.approved_flag%TYPE;
8870: l_auth_status PO_HEADERS_ALL.authorization_status%TYPE;
8871: l_frozen_flag PO_HEADERS_ALL.frozen_flag%TYPE;
8872: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%type;
8873: l_consigned_consumption_flag PO_HEADERS_ALL.consigned_consumption_flag%type;
8874: l_cancel_flag PO_HEADERS_ALL.cancel_flag%type;
8875: l_ga_flag PO_HEADERS_ALL.global_agreement_flag%type;
8876: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE;
8877: l_allow_delete VARCHAR2(1);

Line 8874: l_cancel_flag PO_HEADERS_ALL.cancel_flag%type;

8870: l_auth_status PO_HEADERS_ALL.authorization_status%TYPE;
8871: l_frozen_flag PO_HEADERS_ALL.frozen_flag%TYPE;
8872: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%type;
8873: l_consigned_consumption_flag PO_HEADERS_ALL.consigned_consumption_flag%type;
8874: l_cancel_flag PO_HEADERS_ALL.cancel_flag%type;
8875: l_ga_flag PO_HEADERS_ALL.global_agreement_flag%type;
8876: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE;
8877: l_allow_delete VARCHAR2(1);
8878: d_pos NUMBER := 0;

Line 8875: l_ga_flag PO_HEADERS_ALL.global_agreement_flag%type;

8871: l_frozen_flag PO_HEADERS_ALL.frozen_flag%TYPE;
8872: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%type;
8873: l_consigned_consumption_flag PO_HEADERS_ALL.consigned_consumption_flag%type;
8874: l_cancel_flag PO_HEADERS_ALL.cancel_flag%type;
8875: l_ga_flag PO_HEADERS_ALL.global_agreement_flag%type;
8876: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE;
8877: l_allow_delete VARCHAR2(1);
8878: d_pos NUMBER := 0;
8879: l_api_name CONSTANT VARCHAR2(30) := 'validate_delete_action';

Line 8910: FROM po_headers_all

8906: ,l_auth_status
8907: ,l_ga_flag
8908: ,l_conterms_exist_flag
8909: ,l_consigned_consumption_flag
8910: FROM po_headers_all
8911: WHERE po_header_id = p_doc_header_id;
8912:
8913: IF (PO_LOG.d_stmt) THEN
8914: PO_LOG.stmt(d_module,d_pos,'l_doc_subtype', l_doc_subtype); PO_LOG.stmt(d_module,d_pos,'l_closed_code', l_closed_code); PO_LOG.stmt(d_module,d_pos,'l_doc_approved_date', l_doc_approved_date);