90: --Function:
91: --This fucntion will return the next eligible elin (exhibit line number) for the give exhibit of that document.
92: --Parameters:
93: --IN:
94: -- p_assigned_num_array PO_TBL_VARCHAR100 Set of line numbers for the given exhibit
95: -- p_header_id Document Identifier
96: -- p_exhibit_name Exhibit name
97:
98: --IN OUT:
99: --OUT:
100: --Notes:
101: --End of Comments
102: --------------------------------------------------------------------------------
103: FUNCTION NEXT_ELIN_NUM (p_assigned_num_array PO_TBL_VARCHAR100, p_header_id NUMBER, p_exhibit_name IN VARCHAR2)
104: RETURN VARCHAR2
105:
106: IS
107:
108: linNumDisplay VARCHAR2(3);
109: lineNumber NUMBER;
110: exhibit_len NUMBER;
111: lines_tbl_name VARCHAR2(50);
112: l_oth_line_num_arr PO_TBL_VARCHAR100 := PO_TBL_VARCHAR100();
113: l_merged_line_num_arr PO_TBL_VARCHAR100 := PO_TBL_VARCHAR100();
114: d_api_name CONSTANT VARCHAR2(30) := 'NEXT_ELIN_NUM';
115: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
116: d_position NUMBER;
109: lineNumber NUMBER;
110: exhibit_len NUMBER;
111: lines_tbl_name VARCHAR2(50);
112: l_oth_line_num_arr PO_TBL_VARCHAR100 := PO_TBL_VARCHAR100();
113: l_merged_line_num_arr PO_TBL_VARCHAR100 := PO_TBL_VARCHAR100();
114: d_api_name CONSTANT VARCHAR2(30) := 'NEXT_ELIN_NUM';
115: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
116: d_position NUMBER;
117: