DBA Data[Home] [Help]

APPS.PO_EXHIBITS_PVT dependencies on PO_TBL_VARCHAR100

Line 94: -- p_assigned_num_array PO_TBL_VARCHAR100 Set of line numbers for the given exhibit

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:

Line 103: FUNCTION NEXT_ELIN_NUM (p_assigned_num_array PO_TBL_VARCHAR100, p_header_id NUMBER, p_exhibit_name IN VARCHAR2)

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:

Line 112: l_oth_line_num_arr PO_TBL_VARCHAR100 := PO_TBL_VARCHAR100();

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;

Line 113: l_merged_line_num_arr PO_TBL_VARCHAR100 := PO_TBL_VARCHAR100();

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: