12: --Function:
13: -- Inserts the given exhibits for the given document if it does not exists for that document
14: --Parameters:
15: --IN:
16: -- p_document_type_tbl IN PO_TBL_VARCHAR30;
17: -- p_document_id_tbl IN PO_TBL_NUMBER;
18: -- p_exhibit_name_tbl IN PO_TBL_VARCHAR30;
19: -- p_exhibit_description_tbl IN PO_TBL_VARCHAR240;
20: -- p_is_cdrl_tbl IN PO_TBL_VARCHAR1;
14: --Parameters:
15: --IN:
16: -- p_document_type_tbl IN PO_TBL_VARCHAR30;
17: -- p_document_id_tbl IN PO_TBL_NUMBER;
18: -- p_exhibit_name_tbl IN PO_TBL_VARCHAR30;
19: -- p_exhibit_description_tbl IN PO_TBL_VARCHAR240;
20: -- p_is_cdrl_tbl IN PO_TBL_VARCHAR1;
21: -- p_revision_num_tbl IN PO_TBL_NUMBER;
22: --IN OUT:
27: --End of Comments
28: ------------------------------------------------------------------------
29: PROCEDURE insert_exhibits
30: (
31: p_document_type_tbl IN PO_TBL_VARCHAR30,
32: p_document_id_tbl IN PO_TBL_NUMBER,
33: p_exhibit_name_tbl IN PO_TBL_VARCHAR30,
34: p_exhibit_description_tbl IN PO_TBL_VARCHAR240,
35: p_is_cdrl_tbl IN PO_TBL_VARCHAR1,
29: PROCEDURE insert_exhibits
30: (
31: p_document_type_tbl IN PO_TBL_VARCHAR30,
32: p_document_id_tbl IN PO_TBL_NUMBER,
33: p_exhibit_name_tbl IN PO_TBL_VARCHAR30,
34: p_exhibit_description_tbl IN PO_TBL_VARCHAR240,
35: p_is_cdrl_tbl IN PO_TBL_VARCHAR1,
36: p_revision_num_tbl IN PO_TBL_NUMBER,
37: x_return_status OUT NOCOPY VARCHAR2,
51: --Function:
52: -- Deletes the given exhibits for the given document
53: --Parameters:
54: --IN:
55: -- p_document_type_tbl IN PO_TBL_VARCHAR30;
56: -- p_document_id_tbl IN PO_TBL_NUMBER;
57: -- p_exhibit_name_tbl IN PO_TBL_VARCHAR30;
58: -- p_is_cdrl_tbl IN PO_TBL_VARCHAR1;
59: --IN OUT:
53: --Parameters:
54: --IN:
55: -- p_document_type_tbl IN PO_TBL_VARCHAR30;
56: -- p_document_id_tbl IN PO_TBL_NUMBER;
57: -- p_exhibit_name_tbl IN PO_TBL_VARCHAR30;
58: -- p_is_cdrl_tbl IN PO_TBL_VARCHAR1;
59: --IN OUT:
60: --OUT:
61: --Returns:
64: --End of Comments
65: ------------------------------------------------------------------------
66: PROCEDURE delete_exhibits
67: (
68: p_document_type_tbl IN PO_TBL_VARCHAR30,
69: p_document_id_tbl IN PO_TBL_NUMBER,
70: p_exhibit_name_tbl IN PO_TBL_VARCHAR30,
71: p_is_cdrl_tbl IN PO_TBL_VARCHAR1,
72: x_return_status OUT NOCOPY VARCHAR2,
66: PROCEDURE delete_exhibits
67: (
68: p_document_type_tbl IN PO_TBL_VARCHAR30,
69: p_document_id_tbl IN PO_TBL_NUMBER,
70: p_exhibit_name_tbl IN PO_TBL_VARCHAR30,
71: p_is_cdrl_tbl IN PO_TBL_VARCHAR1,
72: x_return_status OUT NOCOPY VARCHAR2,
73: x_return_msg OUT NOCOPY VARCHAR2
74: );