DBA Data[Home] [Help]

APPS.PO_PDOI_MOVE_TO_DRAFT_TABS_PVT dependencies on PO_HEADERS_DRAFT_ALL

Line 10: PROCEDURE insert_po_headers_draft_all

6:
7: --------------------------------------------------------------------------
8: ---------------------- PRIVATE PROCEDURES PROTOTYPE ----------------------
9: --------------------------------------------------------------------------
10: PROCEDURE insert_po_headers_draft_all
11: (
12: p_headers IN PO_PDOI_TYPES.headers_rec_type
13: );
14:

Line 101: -- insert records into po_headers_draft_all table

97: END IF;
98:
99: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_HEADER_INSERT);
100:
101: -- insert records into po_headers_draft_all table
102: insert_po_headers_draft_all
103: (
104: p_headers => p_headers
105: );

Line 102: insert_po_headers_draft_all

98:
99: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_HEADER_INSERT);
100:
101: -- insert records into po_headers_draft_all table
102: insert_po_headers_draft_all
103: (
104: p_headers => p_headers
105: );
106:

Line 1742: --Name: insert_po_headers_draft_all

1738: -------------------------------------------------------------------------
1739:
1740: -----------------------------------------------------------------------
1741: --Start of Comments
1742: --Name: insert_po_headers_draft_all
1743: --Function:
1744: -- insert new documents attribute values into po_headers_draft_all
1745: --Parameters:
1746: --IN:

Line 1744: -- insert new documents attribute values into po_headers_draft_all

1740: -----------------------------------------------------------------------
1741: --Start of Comments
1742: --Name: insert_po_headers_draft_all
1743: --Function:
1744: -- insert new documents attribute values into po_headers_draft_all
1745: --Parameters:
1746: --IN:
1747: --p_headers
1748: -- record which contains processed line attributes in a batch;

Line 1756: PROCEDURE insert_po_headers_draft_all

1752: --IN OUT:
1753: --OUT:
1754: --End of Comments
1755: ------------------------------------------------------------------------
1756: PROCEDURE insert_po_headers_draft_all
1757: (
1758: p_headers IN PO_PDOI_TYPES.headers_rec_type
1759: )IS
1760:

Line 1761: d_api_name CONSTANT VARCHAR2(30) := 'insert_po_headers_draft_all';

1757: (
1758: p_headers IN PO_PDOI_TYPES.headers_rec_type
1759: )IS
1760:
1761: d_api_name CONSTANT VARCHAR2(30) := 'insert_po_headers_draft_all';
1762: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
1763: d_position NUMBER;
1764:
1765: l_valid_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

Line 1790: INSERT INTO po_headers_draft_all

1786: l_valid_intf_header_id_tbl);
1787: END IF;
1788:
1789: FORALL i IN 1..p_headers.rec_count
1790: INSERT INTO po_headers_draft_all
1791: (
1792: draft_id,
1793: org_id,
1794: delete_flag,

Line 2022: END insert_po_headers_draft_all;

2018: p_pkg_name => d_pkg_name,
2019: p_procedure_name => d_api_name || '.' || d_position
2020: );
2021: RAISE;
2022: END insert_po_headers_draft_all;
2023:
2024: -----------------------------------------------------------------------
2025: --Start of Comments
2026: --Name: insert_po_ga_org_assign_draft