4040: --------------------------------------------------------------------------------
4041: PROCEDURE lock_entities(
4042: p_entity_name_tbl IN PO_TBL_VARCHAR30,
4043: p_draft_id IN NUMBER,
4044: p_pk1_tbl IN PO_TBL_VARCHAR240,
4045: p_pk2_tbl IN PO_TBL_VARCHAR240,
4046: p_pk3_tbl IN PO_TBL_VARCHAR240,
4047: p_pk4_tbl IN PO_TBL_VARCHAR240,
4048: x_return_status OUT NOCOPY VARCHAR2,
4041: PROCEDURE lock_entities(
4042: p_entity_name_tbl IN PO_TBL_VARCHAR30,
4043: p_draft_id IN NUMBER,
4044: p_pk1_tbl IN PO_TBL_VARCHAR240,
4045: p_pk2_tbl IN PO_TBL_VARCHAR240,
4046: p_pk3_tbl IN PO_TBL_VARCHAR240,
4047: p_pk4_tbl IN PO_TBL_VARCHAR240,
4048: x_return_status OUT NOCOPY VARCHAR2,
4049: x_results OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
4042: p_entity_name_tbl IN PO_TBL_VARCHAR30,
4043: p_draft_id IN NUMBER,
4044: p_pk1_tbl IN PO_TBL_VARCHAR240,
4045: p_pk2_tbl IN PO_TBL_VARCHAR240,
4046: p_pk3_tbl IN PO_TBL_VARCHAR240,
4047: p_pk4_tbl IN PO_TBL_VARCHAR240,
4048: x_return_status OUT NOCOPY VARCHAR2,
4049: x_results OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
4050: )
4043: p_draft_id IN NUMBER,
4044: p_pk1_tbl IN PO_TBL_VARCHAR240,
4045: p_pk2_tbl IN PO_TBL_VARCHAR240,
4046: p_pk3_tbl IN PO_TBL_VARCHAR240,
4047: p_pk4_tbl IN PO_TBL_VARCHAR240,
4048: x_return_status OUT NOCOPY VARCHAR2,
4049: x_results OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
4050: )
4051: IS
7979: )
7980: IS
7981: l_entity_id_tbl PO_TBL_NUMBER;
7982: l_err_entity_tbl PO_TBL_VARCHAR60;
7983: l_err_pk1_tbl PO_TBL_VARCHAR240;
7984: l_lock_by_mod_num_tbl PO_TBL_VARCHAR100;
7985: l_err_msg_name VARCHAR2(60);
7986: d_api_name CONSTANT VARCHAR2(30) := 'identify_header_locks';
7987: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';