[Home] [Help]
12467: l_bool_ret_sts boolean;
12468: l_preparer_id number;
12469: l_return_status VARCHAR2(1);
12470: po_return_code VARCHAR2(10);
12471: x_detailed_results po_fcout_type;
12472: l_req_line_id po_tbl_number;
12473: l_distribution_id_tbl po_tbl_number;
12474: l_old_quantity number;
12475: l_new_quantity number;
12486: l_dist_nonrec_tax NUMBER;
12487: l_new_tax NUMBER;
12488: l_fc_result_status VARCHAR2(1);
12489: l_po_return_code VARCHAR2(100) := '';
12490: l_fc_out_tbl po_fcout_type;
12491:
12492:
12493: l_req_dist_id number;
12494: CURSOR l_changed_req_dists_csr(req_line_id NUMBER) IS
12811: x_return_status OUT NOCOPY VARCHAR2)
12812: IS
12813: x_progress varchar2(3);
12814: l_bool_ret_sts boolean;
12815: l_detailed_results PO_FCOUT_TYPE;
12816: l_po_return_code VARCHAR2(50);
12817: l_return_status VARCHAR2(10);
12818: l_api_name VARCHAR2(50) := 'req_line_CANCEL';
12819: l_log_head CONSTANT VARCHAR2(100) := G_MODULE_NAME|| '.' || l_api_name;
13330: l_bool_ret_sts boolean;
13331: l_preparer_id number;
13332: l_return_status VARCHAR2(1);
13333: po_return_code VARCHAR2(10);
13334: x_detailed_results po_fcout_type;
13335: l_req_line_id po_tbl_number;
13336: l_distribution_id_tbl po_tbl_number;
13337: l_old_quantity number;
13338: l_new_quantity number;
13349: l_dist_nonrec_tax NUMBER;
13350: l_new_tax NUMBER;
13351: l_fc_result_status VARCHAR2(1);
13352: l_po_return_code VARCHAR2(100) := '';
13353: l_fc_out_tbl po_fcout_type;
13354: l_req_dist_id number;
13355: l_source_org PO_REQUISITION_LINES_ALL.SOURCE_ORGANIZATION_ID%TYPE;
13356: l_item_id PO_REQUISITION_LINES_ALL.ITEM_ID%TYPE;
13357: l_prim_qty PO_REQUISITION_LINES_ALL.QUANTITY%TYPE;