DBA Data[Home] [Help]

APPS.PO_AUTOCREATE_GROUPING_PVT dependencies on PO_TBL_VARCHAR30

Line 450: x_message_code_tbl OUT NOCOPY PO_TBL_VARCHAR30,

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

Line 451: x_token_name_tbl OUT NOCOPY PO_TBL_VARCHAR30,

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;

Line 497: x_message_code_tbl := PO_TBL_VARCHAR30();

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();

Line 499: x_token_name_tbl := PO_TBL_VARCHAR30();

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:

Line 704: p_sol_line_number_display_tbl IN PO_TBL_VARCHAR30,

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,

Line 707: x_message_code_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

Line 708: x_token_name_tbl OUT NOCOPY PO_TBL_VARCHAR30,

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;

Line 754: x_message_code_tbl := PO_TBL_VARCHAR30();

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();

Line 756: x_token_name_tbl := PO_TBL_VARCHAR30();

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:

Line 5119: x_message_code_tbl OUT NOCOPY PO_TBL_VARCHAR30,

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

Line 5120: x_token_name_tbl OUT NOCOPY PO_TBL_VARCHAR30,

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;

Line 5140: x_message_code_tbl := PO_TBL_VARCHAR30();

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();

Line 5142: x_token_name_tbl := PO_TBL_VARCHAR30();

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: