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 71: g_request_id PO_HEADERS.request_id%TYPE := fnd_global.conc_request_id;

67: -- Determines which documents tax is calculated for
68: g_calculate_tax_flag VARCHAR2(1);
69: g_calculate_tax_status VARCHAR2(1);
70: /*Bug 7278327 Global variable to store the concurrent request ID*/
71: g_request_id PO_HEADERS.request_id%TYPE := fnd_global.conc_request_id;
72:
73: -- START Forward declarations for package private procedures:
74: PROCEDURE log_changes (
75: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE

Line 211: p_buyer_id IN PO_HEADERS.agent_id%TYPE,

207:
208: PROCEDURE apply_changes (
209: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,
210: p_override_date IN DATE,
211: p_buyer_id IN PO_HEADERS.agent_id%TYPE,
212: x_return_status OUT NOCOPY VARCHAR2
213: );
214:
215: PROCEDURE create_split_shipments (

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

618: g_pcard_id,
619: l_currency_code,
620: g_agent_id,
621: g_approved_date
622: FROM po_headers POH
623: WHERE POH.po_header_id = g_po_header_id;
624:
625: IF (g_document_subtype IN ('BLANKET','CONTRACT')) THEN
626: g_document_type := 'PA';

Line 646: FROM po_releases POR, po_headers POH

642: g_pcard_id,
643: l_currency_code,
644: g_agent_id,
645: g_approved_date
646: FROM po_releases POR, po_headers POH
647: WHERE POR.po_release_id = g_po_release_id
648: AND POR.po_header_id = POH.po_header_id; -- JOIN
649:
650: g_document_type := 'RELEASE';

Line 727: FROM po_headers

723: IF (g_po_header_id IS NOT NULL) THEN -- PO / PA
724: BEGIN
725: SELECT 1
726: INTO l_dummy
727: FROM po_headers
728: WHERE po_header_id = g_po_header_id;
729: EXCEPTION
730: WHEN NO_DATA_FOUND THEN -- Error: po_header_id is invalid.
731: add_error (

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

2984: -- SQL What: Retrieves all the lines of the given PO that refer to
2985: -- a global agrement or quotation.
2986: -- SQL Why: To retrieve the lines on a standard/planned PO that may
2987: -- need to be re-priced from the price breaks.
2988: CURSOR po_line_ref_csr (p_po_header_id PO_HEADERS.po_header_id%TYPE) IS
2989: SELECT po_line_id, manual_price_change_flag
2990: FROM po_lines POL
2991: WHERE POL.po_header_id = p_po_header_id
2992: AND (POL.from_header_id IS NOT NULL OR

Line 4114: l_vendor_id po_headers.vendor_id%TYPE;

4110: l_item_revision po_lines.item_revision%TYPE;
4111: l_category_id po_lines.category_id%TYPE;
4112: l_line_type_id po_lines.line_type_id%TYPE;
4113: l_vendor_product_num po_lines.vendor_product_num%TYPE;
4114: l_vendor_id po_headers.vendor_id%TYPE;
4115: l_vendor_site_id po_headers.vendor_site_id%TYPE;
4116: l_uom po_lines.unit_meas_lookup_code%TYPE;
4117: l_in_unit_price po_lines.unit_price%TYPE;
4118: l_base_unit_price po_lines.base_unit_price%TYPE;

Line 4115: l_vendor_site_id po_headers.vendor_site_id%TYPE;

4111: l_category_id po_lines.category_id%TYPE;
4112: l_line_type_id po_lines.line_type_id%TYPE;
4113: l_vendor_product_num po_lines.vendor_product_num%TYPE;
4114: l_vendor_id po_headers.vendor_id%TYPE;
4115: l_vendor_site_id po_headers.vendor_site_id%TYPE;
4116: l_uom po_lines.unit_meas_lookup_code%TYPE;
4117: l_in_unit_price po_lines.unit_price%TYPE;
4118: l_base_unit_price po_lines.base_unit_price%TYPE;
4119: l_currency_code po_headers.currency_code%TYPE;

Line 4119: l_currency_code po_headers.currency_code%TYPE;

4115: l_vendor_site_id po_headers.vendor_site_id%TYPE;
4116: l_uom po_lines.unit_meas_lookup_code%TYPE;
4117: l_in_unit_price po_lines.unit_price%TYPE;
4118: l_base_unit_price po_lines.base_unit_price%TYPE;
4119: l_currency_code po_headers.currency_code%TYPE;
4120: --
4121:
4122: BEGIN
4123: -- For quantity, ship-to location, and need-by date, use the new value

Line 4174: po_headers POH

4170: l_currency_code -- Bug 3564863
4171: --
4172: FROM po_line_locations PLL, po_lines POL,
4173: --
4174: po_headers POH
4175: WHERE PLL.line_location_id = p_line_location_id
4176: AND POL.po_line_id = PLL.po_line_id -- JOIN
4177: --
4178: AND POH.po_header_id = POL.po_header_id;

Line 5152: l_has_ga_ref PO_HEADERS.global_agreement_flag%TYPE;

5148: FROM mtl_grades
5149: WHERE grade_code = p_grade;
5150: /* sschinch 09/08/04 end INVCONV */
5151:
5152: l_has_ga_ref PO_HEADERS.global_agreement_flag%TYPE;
5153: l_po_line_id PO_LINES.po_line_id%TYPE;
5154: l_new_qty PO_LINES.quantity%TYPE;
5155: l_qty_received PO_LINE_LOCATIONS.quantity_received%TYPE;
5156: l_qty_billed PO_LINE_LOCATIONS.quantity_billed%TYPE;

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

6421: PROCEDURE unreserve_entity
6422: ( p_doc_level IN VARCHAR2,
6423: p_doc_level_id IN NUMBER,
6424: p_override_date IN DATE,
6425: p_buyer_id IN PO_HEADERS.agent_id%TYPE,
6426: x_return_status OUT NOCOPY VARCHAR2
6427: ) IS
6428: l_proc_name CONSTANT VARCHAR2(30) := 'UNRESERVE';
6429: l_progress VARCHAR2(3) := '000';

Line 6562: p_buyer_id IN PO_HEADERS.agent_id%TYPE,

6558: -------------------------------------------------------------------------------
6559: PROCEDURE unreserve
6560: ( p_chg IN PO_CHANGES_REC_TYPE,
6561: p_override_date IN DATE,
6562: p_buyer_id IN PO_HEADERS.agent_id%TYPE,
6563: x_return_status OUT NOCOPY VARCHAR2
6564: ) IS
6565: l_proc_name CONSTANT VARCHAR2(30) := 'UNRESERVE';
6566: l_progress VARCHAR2(3) := '000';

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

6674: -------------------------------------------------------------------------------
6675: PROCEDURE apply_changes (
6676: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,
6677: p_override_date IN DATE,
6678: p_buyer_id IN PO_HEADERS.agent_id%TYPE,
6679: x_return_status OUT NOCOPY VARCHAR2
6680: ) IS
6681: l_proc_name CONSTANT VARCHAR2(30) := 'APPLY_CHANGES';
6682: l_progress VARCHAR2(3) := '000';

Line 6686: l_new_revision_num PO_HEADERS.revision_num%TYPE;

6682: l_progress VARCHAR2(3) := '000';
6683:
6684: l_doc_encumbered NUMBER;
6685: l_return_status VARCHAR2(1);
6686: l_new_revision_num PO_HEADERS.revision_num%TYPE;
6687: l_acceptance_required_flag PO_HEADERS.acceptance_required_flag%TYPE := NULL;
6688: l_message VARCHAR2(50);
6689: l_new_from_line_loc_id PO_LINES.from_line_location_id%TYPE;
6690: l_ga_entity_type PO_PRICE_DIFFERENTIALS.entity_type%TYPE;

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

6683:
6684: l_doc_encumbered NUMBER;
6685: l_return_status VARCHAR2(1);
6686: l_new_revision_num PO_HEADERS.revision_num%TYPE;
6687: l_acceptance_required_flag PO_HEADERS.acceptance_required_flag%TYPE := NULL;
6688: l_message VARCHAR2(50);
6689: l_new_from_line_loc_id PO_LINES.from_line_location_id%TYPE;
6690: l_ga_entity_type PO_PRICE_DIFFERENTIALS.entity_type%TYPE;
6691: l_ga_entity_id PO_PRICE_DIFFERENTIALS.entity_id%TYPE;

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

6986: l_acceptance_required_flag := 'S';
6987: END IF;
6988: --
6989:
6990: -- SQL What: Update PO_HEADERS with the last_update WHO values.
6991: -- If authorization status is Approved, change it to Requires Reapproval.
6992: -- If the approved flag is Y, change it to R.
6993: -- If this is a new revision, update the revised date to SYSDATE.
6994: -- Update the acceptance required flag if needed.

Line 6997: UPDATE po_headers

6993: -- If this is a new revision, update the revised date to SYSDATE.
6994: -- Update the acceptance required flag if needed.
6995:
6996: IF g_sec_qty_grade_only_chge_doc = 'N' THEN -- sschinch 09.08.04 INVCONV
6997: UPDATE po_headers
6998: SET last_update_date = sysdate,
6999: last_updated_by = g_user_id,
7000: authorization_status =
7001: decode(authorization_status,

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

8069: l_faxnum VARCHAR2(30); --Bug 5765243
8070: l_emailflag VARCHAR2(1) := 'N';
8071: l_emailaddress PO_VENDOR_SITES.email_address%TYPE;
8072: l_default_method PO_VENDOR_SITES.supplier_notif_method%TYPE;
8073: l_document_num PO_HEADERS.segment1%TYPE;
8074: BEGIN
8075: IF (g_fnd_debug = 'Y') THEN
8076: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
8077: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,

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

Line 8971: PO_HEADERS_SV1.validate_delete_document(

8967: IF p_entity = PO_CORE_S.g_doc_level_HEADER
8968: THEN
8969: d_pos := 70;
8970: -- Validates the delete action on the header
8971: PO_HEADERS_SV1.validate_delete_document(
8972: p_doc_type => p_doc_type
8973: ,p_doc_header_id => p_doc_header_id
8974: ,p_doc_approved_date => l_doc_approved_date
8975: ,p_auth_status => l_auth_status

Line 9171: PO_HEADERS_SV1.delete_document( p_doc_type => p_doc_type

9167:
9168: IF p_entity = PO_CORE_S.g_doc_level_HEADER
9169: THEN
9170: d_pos := 30;
9171: PO_HEADERS_SV1.delete_document( p_doc_type => p_doc_type
9172: ,p_doc_subtype => p_doc_subtype
9173: ,p_doc_header_id => p_doc_header_id
9174: ,p_ga_flag => p_ga_flag
9175: ,p_conterms_exist_flag => p_conterms_exist_flag