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

Line 24: g_document_id PO_HEADERS.po_header_id%TYPE;

20:
21: g_api_errors PO_API_ERRORS_REC_TYPE;
22: g_update_source VARCHAR2(100);
23:
24: g_document_id PO_HEADERS.po_header_id%TYPE;
25: g_document_type PO_DOCUMENT_TYPES_ALL_B.document_type_code%TYPE;
26: g_document_subtype PO_DOCUMENT_TYPES_ALL_B.document_subtype%TYPE;
27: g_po_header_id PO_HEADERS.po_header_id%TYPE;
28: g_po_release_id PO_RELEASES.po_release_id%TYPE;

Line 27: g_po_header_id PO_HEADERS.po_header_id%TYPE;

23:
24: g_document_id PO_HEADERS.po_header_id%TYPE;
25: g_document_type PO_DOCUMENT_TYPES_ALL_B.document_type_code%TYPE;
26: g_document_subtype PO_DOCUMENT_TYPES_ALL_B.document_subtype%TYPE;
27: g_po_header_id PO_HEADERS.po_header_id%TYPE;
28: g_po_release_id PO_RELEASES.po_release_id%TYPE;
29:
30: g_archive_mode PO_DOCUMENT_TYPES.archive_external_revision_code%TYPE;
31: g_pcard_id PO_HEADERS.pcard_id%TYPE;

Line 31: g_pcard_id PO_HEADERS.pcard_id%TYPE;

27: g_po_header_id PO_HEADERS.po_header_id%TYPE;
28: g_po_release_id PO_RELEASES.po_release_id%TYPE;
29:
30: g_archive_mode PO_DOCUMENT_TYPES.archive_external_revision_code%TYPE;
31: g_pcard_id PO_HEADERS.pcard_id%TYPE;
32: g_revision_num PO_HEADERS.revision_num%TYPE;
33: g_min_accountable_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
34: g_precision FND_CURRENCIES.precision%TYPE;
35: g_agent_id PO_HEADERS.agent_id%TYPE;

Line 32: g_revision_num PO_HEADERS.revision_num%TYPE;

28: g_po_release_id PO_RELEASES.po_release_id%TYPE;
29:
30: g_archive_mode PO_DOCUMENT_TYPES.archive_external_revision_code%TYPE;
31: g_pcard_id PO_HEADERS.pcard_id%TYPE;
32: g_revision_num PO_HEADERS.revision_num%TYPE;
33: g_min_accountable_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
34: g_precision FND_CURRENCIES.precision%TYPE;
35: g_agent_id PO_HEADERS.agent_id%TYPE;
36: g_approved_date PO_HEADERS.approved_date%TYPE;

Line 35: g_agent_id PO_HEADERS.agent_id%TYPE;

31: g_pcard_id PO_HEADERS.pcard_id%TYPE;
32: g_revision_num PO_HEADERS.revision_num%TYPE;
33: g_min_accountable_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
34: g_precision FND_CURRENCIES.precision%TYPE;
35: g_agent_id PO_HEADERS.agent_id%TYPE;
36: g_approved_date PO_HEADERS.approved_date%TYPE;
37: g_sec_qty_grade_only_chge_doc VARCHAR2(1); --sschinch 09.08.04 INVCONV
38:
39: -- For performance, we maintain several indexes of the changes:

Line 36: g_approved_date PO_HEADERS.approved_date%TYPE;

32: g_revision_num PO_HEADERS.revision_num%TYPE;
33: g_min_accountable_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
34: g_precision FND_CURRENCIES.precision%TYPE;
35: g_agent_id PO_HEADERS.agent_id%TYPE;
36: g_approved_date PO_HEADERS.approved_date%TYPE;
37: g_sec_qty_grade_only_chge_doc VARCHAR2(1); --sschinch 09.08.04 INVCONV
38:
39: -- For performance, we maintain several indexes of the changes:
40:

Line 72: g_request_id PO_HEADERS.request_id%TYPE := fnd_global.conc_request_id;

68: g_calculate_tax_flag VARCHAR2(1);
69: g_calculate_tax_status VARCHAR2(1);
70:
71: /*Bug 7278327 Global variable to store the concurrent request ID*/
72: g_request_id PO_HEADERS.request_id%TYPE := fnd_global.conc_request_id;
73:
74: --
75: g_doc_style_id NUMBER;
76:

Line 216: p_buyer_id IN PO_HEADERS.agent_id%TYPE,

212:
213: PROCEDURE apply_changes (
214: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,
215: p_override_date IN DATE,
216: p_buyer_id IN PO_HEADERS.agent_id%TYPE,
217: x_return_status OUT NOCOPY VARCHAR2
218: );
219:
220: PROCEDURE create_split_shipments (

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 629: FROM po_headers POH

625: g_pcard_id,
626: l_currency_code,
627: g_agent_id,
628: g_approved_date
629: FROM po_headers POH
630: WHERE POH.po_header_id = g_po_header_id;
631:
632: IF (g_document_subtype IN ('BLANKET','CONTRACT')) THEN
633: g_document_type := 'PA';

Line 642: FROM po_headers POH

638:
639: --
640: SELECT POH.style_id
641: INTO g_doc_style_id
642: FROM po_headers POH
643: WHERE POH.po_header_id = g_po_header_id;
644:
645: ELSE -- Release
646:

Line 659: FROM po_releases POR, po_headers POH

655: g_pcard_id,
656: l_currency_code,
657: g_agent_id,
658: g_approved_date
659: FROM po_releases POR, po_headers POH
660: WHERE POR.po_release_id = g_po_release_id
661: AND POR.po_header_id = POH.po_header_id; -- JOIN
662:
663: g_document_type := 'RELEASE';

Line 741: FROM po_headers

737: IF (g_po_header_id IS NOT NULL) THEN -- PO / PA
738: BEGIN
739: SELECT 1
740: INTO l_dummy
741: FROM po_headers
742: WHERE po_header_id = g_po_header_id;
743: EXCEPTION
744: WHEN NO_DATA_FOUND THEN -- Error: po_header_id is invalid.
745: add_error (

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 3011: CURSOR po_line_ref_csr (p_po_header_id PO_HEADERS.po_header_id%TYPE) IS

3007: -- SQL What: Retrieves all the lines of the given PO that refer to
3008: -- a global agrement or quotation.
3009: -- SQL Why: To retrieve the lines on a standard/planned PO that may
3010: -- need to be re-priced from the price breaks.
3011: CURSOR po_line_ref_csr (p_po_header_id PO_HEADERS.po_header_id%TYPE) IS
3012: SELECT po_line_id, manual_price_change_flag
3013: FROM po_lines POL
3014: WHERE POL.po_header_id = p_po_header_id
3015: AND (POL.from_header_id IS NOT NULL OR

Line 4151: l_vendor_id po_headers.vendor_id%TYPE;

4147: l_item_revision po_lines.item_revision%TYPE;
4148: l_category_id po_lines.category_id%TYPE;
4149: l_line_type_id po_lines.line_type_id%TYPE;
4150: l_vendor_product_num po_lines.vendor_product_num%TYPE;
4151: l_vendor_id po_headers.vendor_id%TYPE;
4152: l_vendor_site_id po_headers.vendor_site_id%TYPE;
4153: l_uom po_lines.unit_meas_lookup_code%TYPE;
4154: l_in_unit_price po_lines.unit_price%TYPE;
4155: l_base_unit_price po_lines.base_unit_price%TYPE;

Line 4152: l_vendor_site_id po_headers.vendor_site_id%TYPE;

4148: l_category_id po_lines.category_id%TYPE;
4149: l_line_type_id po_lines.line_type_id%TYPE;
4150: l_vendor_product_num po_lines.vendor_product_num%TYPE;
4151: l_vendor_id po_headers.vendor_id%TYPE;
4152: l_vendor_site_id po_headers.vendor_site_id%TYPE;
4153: l_uom po_lines.unit_meas_lookup_code%TYPE;
4154: l_in_unit_price po_lines.unit_price%TYPE;
4155: l_base_unit_price po_lines.base_unit_price%TYPE;
4156: l_currency_code po_headers.currency_code%TYPE;

Line 4156: l_currency_code po_headers.currency_code%TYPE;

4152: l_vendor_site_id po_headers.vendor_site_id%TYPE;
4153: l_uom po_lines.unit_meas_lookup_code%TYPE;
4154: l_in_unit_price po_lines.unit_price%TYPE;
4155: l_base_unit_price po_lines.base_unit_price%TYPE;
4156: l_currency_code po_headers.currency_code%TYPE;
4157: --
4158:
4159: BEGIN
4160: -- For quantity, ship-to location, and need-by date, use the new value

Line 4211: po_headers POH

4207: l_currency_code -- Bug 3564863
4208: --
4209: FROM po_line_locations PLL, po_lines POL,
4210: --
4211: po_headers POH
4212: WHERE PLL.line_location_id = p_line_location_id
4213: AND POL.po_line_id = PLL.po_line_id -- JOIN
4214: --
4215: AND POH.po_header_id = POL.po_header_id;

Line 5191: l_has_ga_ref PO_HEADERS.global_agreement_flag%TYPE;

5187: FROM mtl_grades
5188: WHERE grade_code = p_grade;
5189: /* sschinch 09/08/04 end INVCONV */
5190:
5191: l_has_ga_ref PO_HEADERS.global_agreement_flag%TYPE;
5192: l_po_line_id PO_LINES.po_line_id%TYPE;
5193: l_new_qty PO_LINES.quantity%TYPE;
5194: l_qty_received PO_LINE_LOCATIONS.quantity_received%TYPE;
5195: l_qty_billed PO_LINE_LOCATIONS.quantity_billed%TYPE;

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 6481: p_buyer_id IN PO_HEADERS.agent_id%TYPE,

6477: PROCEDURE unreserve_entity
6478: ( p_doc_level IN VARCHAR2,
6479: p_doc_level_id IN NUMBER,
6480: p_override_date IN DATE,
6481: p_buyer_id IN PO_HEADERS.agent_id%TYPE,
6482: x_return_status OUT NOCOPY VARCHAR2
6483: ) IS
6484: l_proc_name CONSTANT VARCHAR2(30) := 'UNRESERVE';
6485: l_progress VARCHAR2(3) := '000';

Line 6618: p_buyer_id IN PO_HEADERS.agent_id%TYPE,

6614: -------------------------------------------------------------------------------
6615: PROCEDURE unreserve
6616: ( p_chg IN PO_CHANGES_REC_TYPE,
6617: p_override_date IN DATE,
6618: p_buyer_id IN PO_HEADERS.agent_id%TYPE,
6619: x_return_status OUT NOCOPY VARCHAR2
6620: ) IS
6621: l_proc_name CONSTANT VARCHAR2(30) := 'UNRESERVE';
6622: l_progress VARCHAR2(3) := '000';

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 6734: p_buyer_id IN PO_HEADERS.agent_id%TYPE,

6730: -------------------------------------------------------------------------------
6731: PROCEDURE apply_changes (
6732: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,
6733: p_override_date IN DATE,
6734: p_buyer_id IN PO_HEADERS.agent_id%TYPE,
6735: x_return_status OUT NOCOPY VARCHAR2
6736: ) IS
6737: l_proc_name CONSTANT VARCHAR2(30) := 'APPLY_CHANGES';
6738: l_progress VARCHAR2(3) := '000';

Line 6742: l_new_revision_num PO_HEADERS.revision_num%TYPE;

6738: l_progress VARCHAR2(3) := '000';
6739:
6740: l_doc_encumbered NUMBER;
6741: l_return_status VARCHAR2(1);
6742: l_new_revision_num PO_HEADERS.revision_num%TYPE;
6743: l_acceptance_required_flag PO_HEADERS.acceptance_required_flag%TYPE := NULL;
6744: l_message VARCHAR2(50);
6745: l_new_from_line_loc_id PO_LINES.from_line_location_id%TYPE;
6746: l_ga_entity_type PO_PRICE_DIFFERENTIALS.entity_type%TYPE;

Line 6743: l_acceptance_required_flag PO_HEADERS.acceptance_required_flag%TYPE := NULL;

6739:
6740: l_doc_encumbered NUMBER;
6741: l_return_status VARCHAR2(1);
6742: l_new_revision_num PO_HEADERS.revision_num%TYPE;
6743: l_acceptance_required_flag PO_HEADERS.acceptance_required_flag%TYPE := NULL;
6744: l_message VARCHAR2(50);
6745: l_new_from_line_loc_id PO_LINES.from_line_location_id%TYPE;
6746: l_ga_entity_type PO_PRICE_DIFFERENTIALS.entity_type%TYPE;
6747: l_ga_entity_id PO_PRICE_DIFFERENTIALS.entity_id%TYPE;

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 7102: -- SQL What: Update PO_HEADERS with the last_update WHO values.

7098: l_acceptance_required_flag := 'S';
7099: END IF;
7100: --
7101:
7102: -- SQL What: Update PO_HEADERS with the last_update WHO values.
7103: -- If authorization status is Approved, change it to Requires Reapproval.
7104: -- If the approved flag is Y, change it to R.
7105: -- If this is a new revision, update the revised date to SYSDATE.
7106: -- Update the acceptance required flag if needed.

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 8208: l_document_num PO_HEADERS.segment1%TYPE;

8204: l_faxnum VARCHAR2(30); --Bug 5765243
8205: l_emailflag VARCHAR2(1) := 'N';
8206: l_emailaddress PO_VENDOR_SITES.email_address%TYPE;
8207: l_default_method PO_VENDOR_SITES.supplier_notif_method%TYPE;
8208: l_document_num PO_HEADERS.segment1%TYPE;
8209: BEGIN
8210: IF (g_fnd_debug = 'Y') THEN
8211: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
8212: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,

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);

Line 9106: PO_HEADERS_SV1.validate_delete_document(

9102: IF p_entity = PO_CORE_S.g_doc_level_HEADER
9103: THEN
9104: d_pos := 70;
9105: -- Validates the delete action on the header
9106: PO_HEADERS_SV1.validate_delete_document(
9107: p_doc_type => p_doc_type
9108: ,p_doc_header_id => p_doc_header_id
9109: ,p_doc_approved_date => l_doc_approved_date
9110: ,p_auth_status => l_auth_status

Line 9306: PO_HEADERS_SV1.delete_document( p_doc_type => p_doc_type

9302:
9303: IF p_entity = PO_CORE_S.g_doc_level_HEADER
9304: THEN
9305: d_pos := 30;
9306: PO_HEADERS_SV1.delete_document( p_doc_type => p_doc_type
9307: ,p_doc_subtype => p_doc_subtype
9308: ,p_doc_header_id => p_doc_header_id
9309: ,p_ga_flag => p_ga_flag
9310: ,p_conterms_exist_flag => p_conterms_exist_flag