446: p_req_line_id_tbl IN PO_TBL_NUMBER,
447: p_po_line_number_tbl IN PO_TBL_NUMBER,
448: p_add_to_po_header_id IN NUMBER,
449: p_draft_id IN NUMBER, --Autocreate grouping
450: x_message_code_tbl OUT NOCOPY PO_TBL_VARCHAR30,
451: x_token_name_tbl OUT NOCOPY PO_TBL_VARCHAR30,
452: x_token_value_tbl OUT NOCOPY PO_TBL_VARCHAR2000
453: )
454: IS
447: p_po_line_number_tbl IN PO_TBL_NUMBER,
448: p_add_to_po_header_id IN NUMBER,
449: p_draft_id IN NUMBER, --Autocreate grouping
450: x_message_code_tbl OUT NOCOPY PO_TBL_VARCHAR30,
451: x_token_name_tbl OUT NOCOPY PO_TBL_VARCHAR30,
452: x_token_value_tbl OUT NOCOPY PO_TBL_VARCHAR2000
453: )
454: IS
455: d_mod CONSTANT VARCHAR2(100) := D_check_po_line_numbers;
493: -- Get the number of lines being passed in.
494: l_num_lines := p_req_line_id_tbl.COUNT;
495:
496: -- Initialize error message values to be returned.
497: x_message_code_tbl := PO_TBL_VARCHAR30();
498: x_message_code_tbl.EXTEND(l_num_lines);
499: x_token_name_tbl := PO_TBL_VARCHAR30();
500: x_token_name_tbl.EXTEND(l_num_lines);
501: x_token_value_tbl := PO_TBL_VARCHAR2000();
495:
496: -- Initialize error message values to be returned.
497: x_message_code_tbl := PO_TBL_VARCHAR30();
498: x_message_code_tbl.EXTEND(l_num_lines);
499: x_token_name_tbl := PO_TBL_VARCHAR30();
500: x_token_name_tbl.EXTEND(l_num_lines);
501: x_token_value_tbl := PO_TBL_VARCHAR2000();
502: x_token_value_tbl.EXTEND(l_num_lines);
503:
700:
701:
702: PROCEDURE check_neg_line_numbers(
703: p_req_line_id_tbl IN PO_TBL_NUMBER,
704: p_sol_line_number_display_tbl IN PO_TBL_VARCHAR30,
705: p_sol_line_number_tbl IN PO_TBL_NUMBER,
706: p_draft_id IN NUMBER, --Autocreate grouping
707: x_message_code_tbl OUT NOCOPY PO_TBL_VARCHAR30,
708: x_token_name_tbl OUT NOCOPY PO_TBL_VARCHAR30,
703: p_req_line_id_tbl IN PO_TBL_NUMBER,
704: p_sol_line_number_display_tbl IN PO_TBL_VARCHAR30,
705: p_sol_line_number_tbl IN PO_TBL_NUMBER,
706: p_draft_id IN NUMBER, --Autocreate grouping
707: x_message_code_tbl OUT NOCOPY PO_TBL_VARCHAR30,
708: x_token_name_tbl OUT NOCOPY PO_TBL_VARCHAR30,
709: x_token_value_tbl OUT NOCOPY PO_TBL_VARCHAR2000
710: )
711: IS
704: p_sol_line_number_display_tbl IN PO_TBL_VARCHAR30,
705: p_sol_line_number_tbl IN PO_TBL_NUMBER,
706: p_draft_id IN NUMBER, --Autocreate grouping
707: x_message_code_tbl OUT NOCOPY PO_TBL_VARCHAR30,
708: x_token_name_tbl OUT NOCOPY PO_TBL_VARCHAR30,
709: x_token_value_tbl OUT NOCOPY PO_TBL_VARCHAR2000
710: )
711: IS
712: d_mod CONSTANT VARCHAR2(100) := D_check_neg_line_numbers;
750: -- Get the number of lines being passed in.
751: l_num_lines := p_req_line_id_tbl.COUNT;
752:
753: -- Initialize error message values to be returned.
754: x_message_code_tbl := PO_TBL_VARCHAR30();
755: x_message_code_tbl.EXTEND(l_num_lines);
756: x_token_name_tbl := PO_TBL_VARCHAR30();
757: x_token_name_tbl.EXTEND(l_num_lines);
758: x_token_value_tbl := PO_TBL_VARCHAR2000();
752:
753: -- Initialize error message values to be returned.
754: x_message_code_tbl := PO_TBL_VARCHAR30();
755: x_message_code_tbl.EXTEND(l_num_lines);
756: x_token_name_tbl := PO_TBL_VARCHAR30();
757: x_token_name_tbl.EXTEND(l_num_lines);
758: x_token_value_tbl := PO_TBL_VARCHAR2000();
759: x_token_value_tbl.EXTEND(l_num_lines);
760:
5115: PROCEDURE check_mod_lock_availability(
5116: p_po_line_number_tbl IN PO_TBL_NUMBER,
5117: p_add_to_po_header_id IN NUMBER,
5118: p_draft_id IN NUMBER, --Autocreate grouping
5119: x_message_code_tbl OUT NOCOPY PO_TBL_VARCHAR30,
5120: x_token_name_tbl OUT NOCOPY PO_TBL_VARCHAR30,
5121: x_token_value_tbl OUT NOCOPY PO_TBL_VARCHAR2000
5122: )
5123: IS
5116: p_po_line_number_tbl IN PO_TBL_NUMBER,
5117: p_add_to_po_header_id IN NUMBER,
5118: p_draft_id IN NUMBER, --Autocreate grouping
5119: x_message_code_tbl OUT NOCOPY PO_TBL_VARCHAR30,
5120: x_token_name_tbl OUT NOCOPY PO_TBL_VARCHAR30,
5121: x_token_value_tbl OUT NOCOPY PO_TBL_VARCHAR2000
5122: )
5123: IS
5124: d_mod CONSTANT VARCHAR2(100) := D_check_mod_lock_availability;
5136:
5137: -- Get the number of lines being passed in.
5138: l_num_lines := p_po_line_number_tbl.COUNT;
5139: -- Initialize error message values to be returned.
5140: x_message_code_tbl := PO_TBL_VARCHAR30();
5141: x_message_code_tbl.EXTEND(l_num_lines);
5142: x_token_name_tbl := PO_TBL_VARCHAR30();
5143: x_token_name_tbl.EXTEND(l_num_lines);
5144: x_token_value_tbl := PO_TBL_VARCHAR2000();
5138: l_num_lines := p_po_line_number_tbl.COUNT;
5139: -- Initialize error message values to be returned.
5140: x_message_code_tbl := PO_TBL_VARCHAR30();
5141: x_message_code_tbl.EXTEND(l_num_lines);
5142: x_token_name_tbl := PO_TBL_VARCHAR30();
5143: x_token_name_tbl.EXTEND(l_num_lines);
5144: x_token_value_tbl := PO_TBL_VARCHAR2000();
5145: x_token_value_tbl.EXTEND(l_num_lines);
5146: