APPS.PO_MODIFY_REQUISITION_PVT dependencies on PO_TBL_NUMBER

Line 117: p_quantity_tbl IN PO_TBL_NUMBER,

113: x_msg_count OUT NOCOPY NUMBER,
114: x_msg_data OUT NOCOPY VARCHAR2,
115: p_req_line_id IN NUMBER,
116: p_num_of_new_lines IN NUMBER,
117: p_quantity_tbl IN PO_TBL_NUMBER,
118: p_agent_id IN NUMBER,
119: p_calling_program IN VARCHAR2,
120: p_handle_tax_diff_if_enc IN VARCHAR2,
121: x_new_line_ids_tbl OUT NOCOPY PO_TBL_NUMBER,

Line 121: x_new_line_ids_tbl OUT NOCOPY PO_TBL_NUMBER,

117: p_quantity_tbl IN PO_TBL_NUMBER,
118: p_agent_id IN NUMBER,
119: p_calling_program IN VARCHAR2,
120: p_handle_tax_diff_if_enc IN VARCHAR2,
121: x_new_line_ids_tbl OUT NOCOPY PO_TBL_NUMBER,
122: x_error_msg_tbl OUT NOCOPY PO_TBL_VARCHAR2000
123: ) IS
124:
125: l_module CONSTANT VARCHAR2(100) := 'split_requisition_lines';

Line 310: p_quantity_tbl IN PO_TBL_NUMBER,

306: x_msg_count OUT NOCOPY NUMBER,
307: x_msg_data OUT NOCOPY VARCHAR2,
308: p_req_line_id IN NUMBER,
309: p_num_of_new_lines IN NUMBER,
310: p_quantity_tbl IN PO_TBL_NUMBER,
311: p_agent_id IN NUMBER,
312: p_calling_program IN VARCHAR2,
313: x_new_line_ids_tbl OUT NOCOPY PO_TBL_NUMBER,
314: x_error_msg_tbl OUT NOCOPY PO_TBL_VARCHAR2000

Line 313: x_new_line_ids_tbl OUT NOCOPY PO_TBL_NUMBER,

309: p_num_of_new_lines IN NUMBER,
310: p_quantity_tbl IN PO_TBL_NUMBER,
311: p_agent_id IN NUMBER,
312: p_calling_program IN VARCHAR2,
313: x_new_line_ids_tbl OUT NOCOPY PO_TBL_NUMBER,
314: x_error_msg_tbl OUT NOCOPY PO_TBL_VARCHAR2000
315: ) IS
316:
317: l_module CONSTANT VARCHAR2(100) := 'create_requisition_lines';

Line 322: new_req_line_id_rslt_tbl PO_TBL_NUMBER;

318: d_module_base CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(d_PACKAGE_BASE, l_module);
319: l_api_version CONSTANT NUMBER := 1.0;
320: d_progress NUMBER;
321: --declare the result tables.
322: new_req_line_id_rslt_tbl PO_TBL_NUMBER;
323: -- SQL What:This cursor Locks the requisition lines the api is going to
324: -- process
325: -- SQL Why :This locking ensures that the records are not touched by
326: -- any other transactions.Opening the cursor keeps the records

Line 365: l_slin_array_tbl Po_Tbl_Number;

361: l_num_of_new_lines NUMBER;
362: l_next_slin_number VARCHAR2(100);
363: TYPE l_slin_array_type IS VARRAY(6) OF VARCHAR2(20) ;
364: l_slin_array l_slin_array_type;
365: l_slin_array_tbl Po_Tbl_Number;
366: l_req_line_id_temp NUMBER;
367: l_line_num_index_passed NUMBER;
368: l_display_number VARCHAR2(100);
369: l_quantity NUMBER;

Line 474: x_new_line_ids_tbl := po_tbl_number(p_quantity_tbl.count);

470:
471: d_progress := 40;
472:
473: -- Call the function to split the requisition line
474: x_new_line_ids_tbl := po_tbl_number(p_quantity_tbl.count);
475:
476: --***CLM_SPLIT
477: l_new_clin_number:=0;
478: l_slin_array :=l_slin_array_type();

Line 479: --<>L_Uda_Template_Array:= Po_Tbl_Number();

475:
476: --***CLM_SPLIT
477: l_new_clin_number:=0;
478: l_slin_array :=l_slin_array_type();
479: --<>L_Uda_Template_Array:= Po_Tbl_Number();
480: L_Ags_Table:= Po_Tbl_Varchar30();
481: L_Attr_Group_Name:= Po_Tbl_Varchar2000();
482: l_temp_num:=1;
483:

Line 1249: p_new_line_ids_tbl IN PO_TBL_NUMBER,

1245: x_msg_count OUT NOCOPY NUMBER,
1246: x_msg_data OUT NOCOPY VARCHAR2,
1247: p_req_line_id IN NUMBER,
1248: p_handle_tax_diff_if_enc IN VARCHAR2,
1249: p_new_line_ids_tbl IN PO_TBL_NUMBER,
1250: x_error_msg_tbl OUT NOCOPY PO_TBL_VARCHAR2000) IS
1251:
1252: l_module CONSTANT VARCHAR2(100) := 'post_modify_requisition_lines';
1253: d_module_base CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(d_PACKAGE_BASE, l_module);

Line 1263: l_quantity_table PO_TBL_NUMBER;

1259: l_online_report_id PO_ONLINE_REPORT_TEXT.online_report_id%TYPE;
1260: l_success BOOLEAN;
1261: l_requisition_header_id NUMBER;
1262: l_req_encumbered_flag VARCHAR2(5);
1263: l_quantity_table PO_TBL_NUMBER;
1264: l_tax_message FND_NEW_MESSAGES.message_text%type := NULL;
1265: l_message_text FND_NEW_MESSAGES.message_text%type := NULL;
1266: l_Req_Header_Id NUMBER; /* <> */
1267: BEGIN