DBA Data[Home] [Help]

APPS.PO_AUTOCREATE_GROUPING_PVT dependencies on PO_TBL_VARCHAR2000

Line 452: x_token_value_tbl OUT NOCOPY PO_TBL_VARCHAR2000

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;
456: d_position NUMBER := 0;

Line 501: x_token_value_tbl := PO_TBL_VARCHAR2000();

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:
504: -- Initialize table of flags indicating whether lines are combined.
505: l_line_combined_flag_tbl := PO_TBL_VARCHAR1();

Line 709: x_token_value_tbl OUT NOCOPY PO_TBL_VARCHAR2000

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;
713: d_position NUMBER := 0;

Line 758: x_token_value_tbl := PO_TBL_VARCHAR2000();

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:
761: BEGIN
762: SELECT paha.contract_type,pon_auction_pkg.get_message_suffix(doc.internal_name)

Line 5121: x_token_value_tbl OUT NOCOPY PO_TBL_VARCHAR2000

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;
5125: d_position NUMBER := 0;

Line 5144: x_token_value_tbl := PO_TBL_VARCHAR2000();

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:
5147:
5148: /*We need to check for lock availability only when the action is 'Add PR line to Modifications'