15: --Function:
16: -- Inserts the given exhibits for the given document if it does not exists for that document
17: --Parameters:
18: --IN:
19: -- p_document_type_tbl IN PO_TBL_VARCHAR30;
20: -- p_document_id_tbl IN PO_TBL_NUMBER;
21: -- p_exhibit_name_tbl IN PO_TBL_VARCHAR30;
22: -- p_exhibit_description_tbl IN PO_TBL_VARCHAR240;
23: -- p_is_cdrl_tbl IN PO_TBL_VARCHAR1;
17: --Parameters:
18: --IN:
19: -- p_document_type_tbl IN PO_TBL_VARCHAR30;
20: -- p_document_id_tbl IN PO_TBL_NUMBER;
21: -- p_exhibit_name_tbl IN PO_TBL_VARCHAR30;
22: -- p_exhibit_description_tbl IN PO_TBL_VARCHAR240;
23: -- p_is_cdrl_tbl IN PO_TBL_VARCHAR1;
24: -- p_revision_num_tbl IN PO_TBL_NUMBER;
25: --IN OUT:
30: --End of Comments
31: ------------------------------------------------------------------------
32: PROCEDURE insert_exhibits
33: (
34: p_document_type_tbl IN PO_TBL_VARCHAR30,
35: p_document_id_tbl IN PO_TBL_NUMBER,
36: p_exhibit_name_tbl IN PO_TBL_VARCHAR30,
37: p_exhibit_description_tbl IN PO_TBL_VARCHAR240,
38: p_is_cdrl_tbl IN PO_TBL_VARCHAR1,
32: PROCEDURE insert_exhibits
33: (
34: p_document_type_tbl IN PO_TBL_VARCHAR30,
35: p_document_id_tbl IN PO_TBL_NUMBER,
36: p_exhibit_name_tbl IN PO_TBL_VARCHAR30,
37: p_exhibit_description_tbl IN PO_TBL_VARCHAR240,
38: p_is_cdrl_tbl IN PO_TBL_VARCHAR1,
39: p_revision_num_tbl IN PO_TBL_NUMBER,
40: x_return_status OUT NOCOPY VARCHAR2,
93: --Function:
94: -- Inserts the given exhibits for the given document if it does not exists for that document
95: --Parameters:
96: --IN:
97: -- p_document_type_tbl IN PO_TBL_VARCHAR30;
98: -- p_document_id_tbl IN PO_TBL_NUMBER;
99: -- p_exhibit_name_tbl IN PO_TBL_VARCHAR30;
100: -- p_is_cdrl_tbl IN PO_TBL_VARCHAR1;
101: --IN OUT:
95: --Parameters:
96: --IN:
97: -- p_document_type_tbl IN PO_TBL_VARCHAR30;
98: -- p_document_id_tbl IN PO_TBL_NUMBER;
99: -- p_exhibit_name_tbl IN PO_TBL_VARCHAR30;
100: -- p_is_cdrl_tbl IN PO_TBL_VARCHAR1;
101: --IN OUT:
102: --OUT:
103: --Returns:
106: --End of Comments
107: ------------------------------------------------------------------------
108: PROCEDURE delete_exhibits
109: (
110: p_document_type_tbl IN PO_TBL_VARCHAR30,
111: p_document_id_tbl IN PO_TBL_NUMBER,
112: p_exhibit_name_tbl IN PO_TBL_VARCHAR30,
113: p_is_cdrl_tbl IN PO_TBL_VARCHAR1,
114: x_return_status OUT NOCOPY VARCHAR2,
108: PROCEDURE delete_exhibits
109: (
110: p_document_type_tbl IN PO_TBL_VARCHAR30,
111: p_document_id_tbl IN PO_TBL_NUMBER,
112: p_exhibit_name_tbl IN PO_TBL_VARCHAR30,
113: p_is_cdrl_tbl IN PO_TBL_VARCHAR1,
114: x_return_status OUT NOCOPY VARCHAR2,
115: x_return_msg OUT NOCOPY VARCHAR2
116: ) IS