11: (
12: p_headers IN PO_PDOI_TYPES.headers_rec_type
13: );
14:
15: PROCEDURE insert_po_ga_org_assign_draft
16: (
17: p_headers IN PO_PDOI_TYPES.headers_rec_type
18: );
19:
105: );
106:
107: d_position := 10;
108:
109: -- insert records into po_ga_org_assign_draft table
110: insert_po_ga_org_assign_draft
111: (
112: p_headers => p_headers
113: );
106:
107: d_position := 10;
108:
109: -- insert records into po_ga_org_assign_draft table
110: insert_po_ga_org_assign_draft
111: (
112: p_headers => p_headers
113: );
114:
2022: END insert_po_headers_draft_all;
2023:
2024: -----------------------------------------------------------------------
2025: --Start of Comments
2026: --Name: insert_po_ga_org_assign_draft
2027: --Function:
2028: -- insert rows into po_ga_org_assign draft table;
2029: -- this applies only to global blanket
2030: --Parameters:
2024: -----------------------------------------------------------------------
2025: --Start of Comments
2026: --Name: insert_po_ga_org_assign_draft
2027: --Function:
2028: -- insert rows into po_ga_org_assign draft table;
2029: -- this applies only to global blanket
2030: --Parameters:
2031: --IN:
2032: --p_headers
2037: --IN OUT:
2038: --OUT:
2039: --End of Comments
2040: ------------------------------------------------------------------------
2041: PROCEDURE insert_po_ga_org_assign_draft
2042: (
2043: p_headers IN PO_PDOI_TYPES.headers_rec_type
2044: ) IS
2045:
2042: (
2043: p_headers IN PO_PDOI_TYPES.headers_rec_type
2044: ) IS
2045:
2046: d_api_name CONSTANT VARCHAR2(30) := 'insert_po_ga_org_assign_draft';
2047: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2048: d_position NUMBER;
2049:
2050: BEGIN
2056:
2057: IF (PO_PDOI_PARAMS.g_request.document_type =
2058: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN
2059: FORALL i IN 1..p_headers.rec_count
2060: INSERT INTO po_ga_org_assign_draft
2061: (
2062: draft_id,
2063: delete_flag,
2064: change_accepted_flag,
2107: p_pkg_name => d_pkg_name,
2108: p_procedure_name => d_api_name || '.' || d_position
2109: );
2110: RAISE;
2111: END insert_po_ga_org_assign_draft;
2112:
2113: -----------------------------------------------------------------------
2114: --Start of Comments
2115: --Name: insert_blk_dists_draft_all