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 250: -- will be applied to the database tables (ex. PO_HEADERS_ALL,

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

Line 612: l_currency_code PO_HEADERS_ALL.currency_code%TYPE;

608: --End of Comments
609: -------------------------------------------------------------------------------
610: PROCEDURE init_document_globals IS
611: l_proc_name CONSTANT VARCHAR2(30) := 'INIT_DOCUMENT_GLOBALS';
612: l_currency_code PO_HEADERS_ALL.currency_code%TYPE;
613: BEGIN
614: -- Retrieve header information: document subtype, revision, etc.
615: IF (g_po_header_id IS NOT NULL) THEN -- PO or PA
616:

Line 749: p_table_name => 'PO_HEADERS_ALL',

745: add_error (
746: p_api_errors => g_api_errors,
747: x_return_status => x_return_status,
748: p_message_name => 'PO_INVALID_DOC_IDS',
749: p_table_name => 'PO_HEADERS_ALL',
750: p_column_name => 'PO_HEADER_ID',
751: p_entity_type => G_ENTITY_TYPE_CHANGES
752: );
753: RETURN; -- Do not continue with the remaining checks.

Line 1185: po_headers_all POHA,

1181: p_chg.line_changes.t_manual_price_change_flag(i),
1182: p_chg.line_changes.c_preferred_grade(i) --INVCONV
1183: FROM po_lines POL,
1184: po_line_types PLT,
1185: po_headers_all POHA,
1186: mtl_system_items_b MSI,
1187: financials_system_parameters FSP
1188: WHERE POL.po_line_id = p_chg.line_changes.po_line_id(i)
1189: AND PLT.line_type_id = POL.line_type_id -- JOIN

Line 6015: p_table_name => 'PO_HEADERS_ALL',

6011:
6012: add_error ( p_api_errors => g_api_errors,
6013: x_return_status => x_return_status,
6014: p_message_name => 'PO_CHNG_PCARD_RESTRICTED',
6015: p_table_name => 'PO_HEADERS_ALL',
6016: p_column_name => 'PCARD_ID',
6017: p_entity_type => G_ENTITY_TYPE_SHIPMENTS,
6018: p_entity_id => i );
6019: END IF; -- new quantity, new price, and PCARD*/

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

6721: -- Applies the requested and derived changes to the database tables.
6722: --Pre-reqs:
6723: -- None.
6724: --Modifies:
6725: -- Updates PO_HEADERS_ALL, PO_RELEASES_ALL, PO_LINES_ALL,
6726: -- PO_LINE_LOCATIONS_ALL, PO_DISTRIBUTIONS_ALL with the changes.
6727: --Locks:
6728: -- None.
6729: --End of Comments

Line 6752: l_new_auth_status PO_HEADERS_ALL.authorization_status%TYPE;

6748: l_po_entity_type PO_PRICE_DIFFERENTIALS.entity_type%TYPE;
6749: l_po_entity_id PO_PRICE_DIFFERENTIALS.entity_id%TYPE;
6750:
6751: --
6752: l_new_auth_status PO_HEADERS_ALL.authorization_status%TYPE;
6753:
6754: l_clm_doc_flag VARCHAR2(1); -- bug#13503748
6755:
6756: BEGIN

Line 7109: UPDATE po_headers_all

7105: -- If this is a new revision, update the revised date to SYSDATE.
7106: -- Update the acceptance required flag if needed.
7107:
7108: IF g_sec_qty_grade_only_chge_doc = 'N' THEN -- sschinch 09.08.04 INVCONV
7109: UPDATE po_headers_all
7110: SET last_update_date = sysdate,
7111: last_updated_by = g_user_id,
7112: authorization_status =
7113: decode(authorization_status,

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

8147: --Parameters:
8148: --IN:
8149: --p_document_id
8150: -- This value for this parameter depends on the p_document_type:
8151: -- 'PO' or 'PA': PO_HEADERS_ALL.po_header_id
8152: -- 'RELEASE': PO_RELEASES_ALL.po_release_id
8153: --p_document_type
8154: -- 'PO', 'PA', 'RELEASE'
8155: --p_document_subtype

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

8153: --p_document_type
8154: -- 'PO', 'PA', 'RELEASE'
8155: --p_document_subtype
8156: -- The value for this parameter depends on the p_document_type:
8157: -- 'PO' or 'PA': PO_HEADERS_ALL.type_lookup_code
8158: -- 'RELEASE': PO_RELEASES_ALL.release_type
8159: --p_preparer_id
8160: -- EMPLOYEE_ID of the buyer whose approval authority should be used in the
8161: -- approval workflow; if NULL, use the buyer on the document.

Line 8201: l_preparer_id PO_HEADERS_ALL.agent_id%TYPE;

8197: l_proc_name CONSTANT VARCHAR2(30) := 'LAUNCH_PO_APPROVAL_WF';
8198: l_api_version CONSTANT NUMBER := 1.0;
8199: l_progress VARCHAR2(3) := '000';
8200:
8201: l_preparer_id PO_HEADERS_ALL.agent_id%TYPE;
8202: l_printflag VARCHAR2(1) := 'N';
8203: l_faxflag VARCHAR2(1) := 'N';
8204: l_faxnum VARCHAR2(30); --Bug 5765243
8205: l_emailflag VARCHAR2(1) := 'N';

Line 9001: l_doc_subtype PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;

8997: ,x_error_message OUT NOCOPY VARCHAR2)
8998: IS
8999: l_modify_action_allowed BOOLEAN := FALSE;
9000: l_style_disp_name PO_DOC_STYLE_LINES_TL.display_name%TYPE;
9001: l_doc_subtype PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
9002: l_closed_code PO_HEADERS_ALL.closed_code%TYPE;
9003: l_doc_approved_date PO_HEADERS_ALL.approved_date%TYPE;
9004: l_doc_approved_flag PO_HEADERS_ALL.approved_flag%TYPE;
9005: l_auth_status PO_HEADERS_ALL.authorization_status%TYPE;

Line 9002: l_closed_code PO_HEADERS_ALL.closed_code%TYPE;

8998: IS
8999: l_modify_action_allowed BOOLEAN := FALSE;
9000: l_style_disp_name PO_DOC_STYLE_LINES_TL.display_name%TYPE;
9001: l_doc_subtype PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
9002: l_closed_code PO_HEADERS_ALL.closed_code%TYPE;
9003: l_doc_approved_date PO_HEADERS_ALL.approved_date%TYPE;
9004: l_doc_approved_flag PO_HEADERS_ALL.approved_flag%TYPE;
9005: l_auth_status PO_HEADERS_ALL.authorization_status%TYPE;
9006: l_frozen_flag PO_HEADERS_ALL.frozen_flag%TYPE;

Line 9003: l_doc_approved_date PO_HEADERS_ALL.approved_date%TYPE;

8999: l_modify_action_allowed BOOLEAN := FALSE;
9000: l_style_disp_name PO_DOC_STYLE_LINES_TL.display_name%TYPE;
9001: l_doc_subtype PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
9002: l_closed_code PO_HEADERS_ALL.closed_code%TYPE;
9003: l_doc_approved_date PO_HEADERS_ALL.approved_date%TYPE;
9004: l_doc_approved_flag PO_HEADERS_ALL.approved_flag%TYPE;
9005: l_auth_status PO_HEADERS_ALL.authorization_status%TYPE;
9006: l_frozen_flag PO_HEADERS_ALL.frozen_flag%TYPE;
9007: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%type;

Line 9004: l_doc_approved_flag PO_HEADERS_ALL.approved_flag%TYPE;

9000: l_style_disp_name PO_DOC_STYLE_LINES_TL.display_name%TYPE;
9001: l_doc_subtype PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
9002: l_closed_code PO_HEADERS_ALL.closed_code%TYPE;
9003: l_doc_approved_date PO_HEADERS_ALL.approved_date%TYPE;
9004: l_doc_approved_flag PO_HEADERS_ALL.approved_flag%TYPE;
9005: l_auth_status PO_HEADERS_ALL.authorization_status%TYPE;
9006: l_frozen_flag PO_HEADERS_ALL.frozen_flag%TYPE;
9007: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%type;
9008: l_consigned_consumption_flag PO_HEADERS_ALL.consigned_consumption_flag%type;

Line 9005: l_auth_status PO_HEADERS_ALL.authorization_status%TYPE;

9001: l_doc_subtype PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
9002: l_closed_code PO_HEADERS_ALL.closed_code%TYPE;
9003: l_doc_approved_date PO_HEADERS_ALL.approved_date%TYPE;
9004: l_doc_approved_flag PO_HEADERS_ALL.approved_flag%TYPE;
9005: l_auth_status PO_HEADERS_ALL.authorization_status%TYPE;
9006: l_frozen_flag PO_HEADERS_ALL.frozen_flag%TYPE;
9007: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%type;
9008: l_consigned_consumption_flag PO_HEADERS_ALL.consigned_consumption_flag%type;
9009: l_cancel_flag PO_HEADERS_ALL.cancel_flag%type;

Line 9006: l_frozen_flag PO_HEADERS_ALL.frozen_flag%TYPE;

9002: l_closed_code PO_HEADERS_ALL.closed_code%TYPE;
9003: l_doc_approved_date PO_HEADERS_ALL.approved_date%TYPE;
9004: l_doc_approved_flag PO_HEADERS_ALL.approved_flag%TYPE;
9005: l_auth_status PO_HEADERS_ALL.authorization_status%TYPE;
9006: l_frozen_flag PO_HEADERS_ALL.frozen_flag%TYPE;
9007: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%type;
9008: l_consigned_consumption_flag PO_HEADERS_ALL.consigned_consumption_flag%type;
9009: l_cancel_flag PO_HEADERS_ALL.cancel_flag%type;
9010: l_ga_flag PO_HEADERS_ALL.global_agreement_flag%type;

Line 9007: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%type;

9003: l_doc_approved_date PO_HEADERS_ALL.approved_date%TYPE;
9004: l_doc_approved_flag PO_HEADERS_ALL.approved_flag%TYPE;
9005: l_auth_status PO_HEADERS_ALL.authorization_status%TYPE;
9006: l_frozen_flag PO_HEADERS_ALL.frozen_flag%TYPE;
9007: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%type;
9008: l_consigned_consumption_flag PO_HEADERS_ALL.consigned_consumption_flag%type;
9009: l_cancel_flag PO_HEADERS_ALL.cancel_flag%type;
9010: l_ga_flag PO_HEADERS_ALL.global_agreement_flag%type;
9011: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE;

Line 9008: l_consigned_consumption_flag PO_HEADERS_ALL.consigned_consumption_flag%type;

9004: l_doc_approved_flag PO_HEADERS_ALL.approved_flag%TYPE;
9005: l_auth_status PO_HEADERS_ALL.authorization_status%TYPE;
9006: l_frozen_flag PO_HEADERS_ALL.frozen_flag%TYPE;
9007: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%type;
9008: l_consigned_consumption_flag PO_HEADERS_ALL.consigned_consumption_flag%type;
9009: l_cancel_flag PO_HEADERS_ALL.cancel_flag%type;
9010: l_ga_flag PO_HEADERS_ALL.global_agreement_flag%type;
9011: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE;
9012: l_allow_delete VARCHAR2(1);

Line 9009: l_cancel_flag PO_HEADERS_ALL.cancel_flag%type;

9005: l_auth_status PO_HEADERS_ALL.authorization_status%TYPE;
9006: l_frozen_flag PO_HEADERS_ALL.frozen_flag%TYPE;
9007: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%type;
9008: l_consigned_consumption_flag PO_HEADERS_ALL.consigned_consumption_flag%type;
9009: l_cancel_flag PO_HEADERS_ALL.cancel_flag%type;
9010: l_ga_flag PO_HEADERS_ALL.global_agreement_flag%type;
9011: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE;
9012: l_allow_delete VARCHAR2(1);
9013: d_pos NUMBER := 0;

Line 9010: l_ga_flag PO_HEADERS_ALL.global_agreement_flag%type;

9006: l_frozen_flag PO_HEADERS_ALL.frozen_flag%TYPE;
9007: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%type;
9008: l_consigned_consumption_flag PO_HEADERS_ALL.consigned_consumption_flag%type;
9009: l_cancel_flag PO_HEADERS_ALL.cancel_flag%type;
9010: l_ga_flag PO_HEADERS_ALL.global_agreement_flag%type;
9011: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE;
9012: l_allow_delete VARCHAR2(1);
9013: d_pos NUMBER := 0;
9014: l_api_name CONSTANT VARCHAR2(30) := 'validate_delete_action';

Line 9045: FROM po_headers_all

9041: ,l_auth_status
9042: ,l_ga_flag
9043: ,l_conterms_exist_flag
9044: ,l_consigned_consumption_flag
9045: FROM po_headers_all
9046: WHERE po_header_id = p_doc_header_id;
9047:
9048: IF (PO_LOG.d_stmt) THEN
9049: 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);