36: ------------------------------------------------------------------------
37: PROCEDURE open_attr_values
38: (
39: p_max_intf_attr_values_id IN NUMBER,
40: x_attr_values_csr OUT NOCOPY PO_PDOI_TYPES.intf_cursor_type
41: ) IS
42:
43: d_api_name CONSTANT VARCHAR2(30) := 'open_attr_values';
44: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
120: --End of Comments
121: ------------------------------------------------------------------------
122: PROCEDURE fetch_attr_values
123: (
124: x_attr_values_csr IN OUT NOCOPY PO_PDOI_TYPES.intf_cursor_type,
125: x_attr_values OUT NOCOPY PO_PDOI_TYPES.attr_values_rec_type
126: ) IS
127:
128: d_api_name CONSTANT VARCHAR2(30) := 'fetch_attr_values';
121: ------------------------------------------------------------------------
122: PROCEDURE fetch_attr_values
123: (
124: x_attr_values_csr IN OUT NOCOPY PO_PDOI_TYPES.intf_cursor_type,
125: x_attr_values OUT NOCOPY PO_PDOI_TYPES.attr_values_rec_type
126: ) IS
127:
128: d_api_name CONSTANT VARCHAR2(30) := 'fetch_attr_values';
129: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
206: ------------------------------------------------------------------------
207: PROCEDURE check_attr_actions
208: (
209: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
210: x_attr_values IN OUT NOCOPY PO_PDOI_TYPES.attr_values_rec_type,
211: x_merge_row_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
212: x_sync_attr_id_tbl OUT NOCOPY PO_TBL_NUMBER,
213: x_sync_draft_id_tbl OUT NOCOPY PO_TBL_NUMBER
214: ) IS
406: ------------------------------------------------------------------------
407: PROCEDURE open_attr_values_tlp
408: (
409: p_max_intf_attr_values_tlp_id IN NUMBER,
410: x_attr_values_tlp_csr IN OUT NOCOPY PO_PDOI_TYPES.intf_cursor_type
411: ) IS
412:
413: d_api_name CONSTANT VARCHAR2(30) := 'open_attr_values_tlp';
414: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
493: --End of Comments
494: ------------------------------------------------------------------------
495: PROCEDURE fetch_attr_values_tlp
496: (
497: x_attr_values_tlp_csr IN OUT NOCOPY PO_PDOI_TYPES.intf_cursor_type,
498: x_attr_values_tlp IN OUT NOCOPY PO_PDOI_TYPES.attr_values_tlp_rec_type
499: ) IS
500:
501: d_api_name CONSTANT VARCHAR2(30) := 'fetch_attr_values_tlp';
494: ------------------------------------------------------------------------
495: PROCEDURE fetch_attr_values_tlp
496: (
497: x_attr_values_tlp_csr IN OUT NOCOPY PO_PDOI_TYPES.intf_cursor_type,
498: x_attr_values_tlp IN OUT NOCOPY PO_PDOI_TYPES.attr_values_tlp_rec_type
499: ) IS
500:
501: d_api_name CONSTANT VARCHAR2(30) := 'fetch_attr_values_tlp';
502: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
582: ------------------------------------------------------------------------
583: PROCEDURE check_attr_tlp_actions
584: (
585: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
586: x_attr_values_tlp IN OUT NOCOPY PO_PDOI_TYPES.attr_values_tlp_rec_type,
587: x_merge_row_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
588: x_sync_attr_tlp_id_tbl OUT NOCOPY PO_TBL_NUMBER,
589: x_sync_draft_id_tbl OUT NOCOPY PO_TBL_NUMBER
590: ) IS