eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_MODIFY_REQUISITION_PVT dependencies on PO_TBL_NUMBER

Line 61: p_quantity_tbl IN PO_TBL_NUMBER,

57: x_msg_count OUT NOCOPY NUMBER,
58: x_msg_data OUT NOCOPY VARCHAR2,
59: p_req_line_id IN NUMBER,
60: p_num_of_new_lines IN NUMBER,
61: p_quantity_tbl IN PO_TBL_NUMBER,
62: p_agent_id IN NUMBER,
63: p_calling_program IN VARCHAR2,
64: p_handle_tax_diff_if_enc IN VARCHAR2,
65: x_new_line_ids_tbl OUT NOCOPY PO_TBL_NUMBER,

Line 65: x_new_line_ids_tbl OUT NOCOPY PO_TBL_NUMBER,

61: p_quantity_tbl IN PO_TBL_NUMBER,
62: p_agent_id IN NUMBER,
63: p_calling_program IN VARCHAR2,
64: p_handle_tax_diff_if_enc IN VARCHAR2,
65: x_new_line_ids_tbl OUT NOCOPY PO_TBL_NUMBER,
66: x_error_msg_tbl OUT NOCOPY PO_TBL_VARCHAR2000
67: ) IS
68:
69: l_module CONSTANT VARCHAR2(100) := 'split_requisition_lines';

Line 254: p_quantity_tbl IN PO_TBL_NUMBER,

250: x_msg_count OUT NOCOPY NUMBER,
251: x_msg_data OUT NOCOPY VARCHAR2,
252: p_req_line_id IN NUMBER,
253: p_num_of_new_lines IN NUMBER,
254: p_quantity_tbl IN PO_TBL_NUMBER,
255: p_agent_id IN NUMBER,
256: p_calling_program IN VARCHAR2,
257: x_new_line_ids_tbl OUT NOCOPY PO_TBL_NUMBER,
258: x_error_msg_tbl OUT NOCOPY PO_TBL_VARCHAR2000

Line 257: x_new_line_ids_tbl OUT NOCOPY PO_TBL_NUMBER,

253: p_num_of_new_lines IN NUMBER,
254: p_quantity_tbl IN PO_TBL_NUMBER,
255: p_agent_id IN NUMBER,
256: p_calling_program IN VARCHAR2,
257: x_new_line_ids_tbl OUT NOCOPY PO_TBL_NUMBER,
258: x_error_msg_tbl OUT NOCOPY PO_TBL_VARCHAR2000
259: ) IS
260:
261: l_module CONSTANT VARCHAR2(100) := 'create_requisition_lines';

Line 266: new_req_line_id_rslt_tbl PO_TBL_NUMBER;

262: d_module_base CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(d_PACKAGE_BASE, l_module);
263: l_api_version CONSTANT NUMBER := 1.0;
264: d_progress NUMBER;
265: --declare the result tables.
266: new_req_line_id_rslt_tbl PO_TBL_NUMBER;
267: -- SQL What:This cursor Locks the requisition lines the api is going to
268: -- process
269: -- SQL Why :This locking ensures that the records are not touched by
270: -- any other transactions.Opening the cursor keeps the records

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

365:
366: d_progress := 40;
367:
368: -- Call the function to split the requisition line
369: x_new_line_ids_tbl := po_tbl_number(p_quantity_tbl.count);
370:
371: FOR l_line_num_index IN 1 .. p_num_of_new_lines
372: LOOP
373: --ascertain the serial number for each req line created

Line 808: p_new_line_ids_tbl IN PO_TBL_NUMBER,

804: x_msg_count OUT NOCOPY NUMBER,
805: x_msg_data OUT NOCOPY VARCHAR2,
806: p_req_line_id IN NUMBER,
807: p_handle_tax_diff_if_enc IN VARCHAR2,
808: p_new_line_ids_tbl IN PO_TBL_NUMBER,
809: x_error_msg_tbl OUT NOCOPY PO_TBL_VARCHAR2000) IS
810:
811: l_module CONSTANT VARCHAR2(100) := 'post_modify_requisition_lines';
812: d_module_base CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(d_PACKAGE_BASE, l_module);

Line 822: l_quantity_table PO_TBL_NUMBER;

818: l_online_report_id PO_ONLINE_REPORT_TEXT.online_report_id%TYPE;
819: l_success BOOLEAN;
820: l_requisition_header_id NUMBER;
821: l_req_encumbered_flag VARCHAR2(5);
822: l_quantity_table PO_TBL_NUMBER;
823: l_tax_message FND_NEW_MESSAGES.message_text%type := NULL;
824: l_message_text FND_NEW_MESSAGES.message_text%type := NULL;
825: BEGIN
826: --CREATE A SAVE POINT ON ENTERING THIS PROCEDURE