605: * version change from 2.0 to 3.0
606: */
607: PROCEDURE update_reqcancel_from_so(
608: p_api_version IN NUMBER
609: , p_req_line_id_tbl IN Dbms_Sql.number_table
610: , p_req_can_qty_tbl IN Dbms_Sql.number_table
611: , p_req_can_all IN Boolean
612: , x_return_status OUT NOCOPY VARCHAR2
613: )
606: */
607: PROCEDURE update_reqcancel_from_so(
608: p_api_version IN NUMBER
609: , p_req_line_id_tbl IN Dbms_Sql.number_table
610: , p_req_can_qty_tbl IN Dbms_Sql.number_table
611: , p_req_can_all IN Boolean
612: , x_return_status OUT NOCOPY VARCHAR2
613: )
614: IS
643: */
644: PROCEDURE update_reqcancel_from_so(
645: p_api_version IN NUMBER
646: , x_return_status OUT NOCOPY VARCHAR2
647: , p_req_line_id_tbl IN Dbms_Sql.number_table --this needs to be table of number
648: )
649: IS
650:
651: l_api_name CONSTANT VARCHAR2(30) := 'update_ReqCancel_from_SO';
761: * @param x_return_status returns the tstatus of the api.
762: */
763: PROCEDURE update_reqcancel_from_so(
764: p_api_version IN NUMBER
765: , p_req_line_id_tbl IN Dbms_Sql.number_table
766: , p_req_can_prim_qty_tbl IN Dbms_Sql.number_table
767: , p_req_can_sec_qty_tbl IN Dbms_Sql.number_table
768: , p_req_can_all IN Boolean
769: , x_return_status OUT NOCOPY VARCHAR2
762: */
763: PROCEDURE update_reqcancel_from_so(
764: p_api_version IN NUMBER
765: , p_req_line_id_tbl IN Dbms_Sql.number_table
766: , p_req_can_prim_qty_tbl IN Dbms_Sql.number_table
767: , p_req_can_sec_qty_tbl IN Dbms_Sql.number_table
768: , p_req_can_all IN Boolean
769: , x_return_status OUT NOCOPY VARCHAR2
770: )
763: PROCEDURE update_reqcancel_from_so(
764: p_api_version IN NUMBER
765: , p_req_line_id_tbl IN Dbms_Sql.number_table
766: , p_req_can_prim_qty_tbl IN Dbms_Sql.number_table
767: , p_req_can_sec_qty_tbl IN Dbms_Sql.number_table
768: , p_req_can_all IN Boolean
769: , x_return_status OUT NOCOPY VARCHAR2
770: )
771: IS