4151: x_return_status VARCHAR2(10);
4152: x_retMsg VARCHAR2(2000):='';
4153: x_errTable PO_REQ_CHANGE_ERR_TABLE;
4154: x_errCode VARCHAR2(10);
4155: l_dummy_table_number po_tbl_number := po_tbl_number();
4156:
4157: /* Bug 7422622 - Added the following variables to check whether AME
4158: the setup is done. If yes then clear the approval list. - Start*/
4159:
4167: x_retMsg :='';
4168: x_progress := 'INITIATERCOFLOW:000';
4169:
4170: l_change_table:=PO_REQ_CHANGE_TABLE(
4171: req_line_id => po_tbl_number(),
4172: req_dist_id => po_tbl_number(),
4173: price => po_tbl_number(),
4174: quantity => po_tbl_number(),
4175: need_by => po_tbl_date(),
4168: x_progress := 'INITIATERCOFLOW:000';
4169:
4170: l_change_table:=PO_REQ_CHANGE_TABLE(
4171: req_line_id => po_tbl_number(),
4172: req_dist_id => po_tbl_number(),
4173: price => po_tbl_number(),
4174: quantity => po_tbl_number(),
4175: need_by => po_tbl_date(),
4176: start_date => po_tbl_date(),
4169:
4170: l_change_table:=PO_REQ_CHANGE_TABLE(
4171: req_line_id => po_tbl_number(),
4172: req_dist_id => po_tbl_number(),
4173: price => po_tbl_number(),
4174: quantity => po_tbl_number(),
4175: need_by => po_tbl_date(),
4176: start_date => po_tbl_date(),
4177: END_date => po_tbl_date(),
4170: l_change_table:=PO_REQ_CHANGE_TABLE(
4171: req_line_id => po_tbl_number(),
4172: req_dist_id => po_tbl_number(),
4173: price => po_tbl_number(),
4174: quantity => po_tbl_number(),
4175: need_by => po_tbl_date(),
4176: start_date => po_tbl_date(),
4177: END_date => po_tbl_date(),
4178: amount => po_tbl_number(),
4174: quantity => po_tbl_number(),
4175: need_by => po_tbl_date(),
4176: start_date => po_tbl_date(),
4177: END_date => po_tbl_date(),
4178: amount => po_tbl_number(),
4179: type => po_tbl_varchar60(),
4180: change_reason => po_tbl_VARCHAR2000());
4181:
4182: if p_po_release_id is not null then
4423: x_retMsg VARCHAR2(2000):='';
4424: x_errTable PO_REQ_CHANGE_ERR_TABLE;
4425: x_errCode VARCHAR2(10);
4426: x_progress varchar2(1000);
4427: l_dummy_table_number po_tbl_number := po_tbl_number();
4428:
4429:
4430: BEGIN
4431: