50:
51: l_api_name CONSTANT VARCHAR(30) := 'DERIVE_DEPENDENT_FIELDS';
52: l_progress VARCHAR2(3) := '000';
53:
54: l_sequence PO_TBL_NUMBER := PO_TBL_NUMBER();
55: l_dist_total_qty PO_TBL_NUMBER;
56: l_last_dist_index PO_TBL_NUMBER;
57: l_line_count NUMBER := p_lines.req_line_id.count;
58: l_key po_session_gt.key%type;
51: l_api_name CONSTANT VARCHAR(30) := 'DERIVE_DEPENDENT_FIELDS';
52: l_progress VARCHAR2(3) := '000';
53:
54: l_sequence PO_TBL_NUMBER := PO_TBL_NUMBER();
55: l_dist_total_qty PO_TBL_NUMBER;
56: l_last_dist_index PO_TBL_NUMBER;
57: l_line_count NUMBER := p_lines.req_line_id.count;
58: l_key po_session_gt.key%type;
59:
52: l_progress VARCHAR2(3) := '000';
53:
54: l_sequence PO_TBL_NUMBER := PO_TBL_NUMBER();
55: l_dist_total_qty PO_TBL_NUMBER;
56: l_last_dist_index PO_TBL_NUMBER;
57: l_line_count NUMBER := p_lines.req_line_id.count;
58: l_key po_session_gt.key%type;
59:
60: BEGIN
221: l_api_name CONSTANT VARCHAR(30) := 'UPDATE_REQUISITION';
222: l_api_version CONSTANT NUMBER := 1.0;
223: l_progress VARCHAR2(3) := '000';
224: l_req_status_rec PO_STATUS_REC_TYPE;
225: l_req_header_id po_tbl_number := po_tbl_number();
226: l_line_count NUMBER := p_req_changes.line_changes.req_line_id.count;
227: l_return_status VARCHAR2(1); --
228:
229: BEGIN