DBA Data[Home] [Help]

APPS.PO_RCO_VALIDATION_GRP dependencies on DBMS_SQL

Line 609: , p_req_line_id_tbl IN Dbms_Sql.number_table

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: )

Line 610: , p_req_can_qty_tbl IN Dbms_Sql.number_table

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

Line 647: , p_req_line_id_tbl IN Dbms_Sql.number_table --this needs to be table of number

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';

Line 765: , p_req_line_id_tbl IN Dbms_Sql.number_table

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

Line 766: , p_req_can_prim_qty_tbl IN Dbms_Sql.number_table

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: )

Line 767: , p_req_can_sec_qty_tbl IN Dbms_Sql.number_table

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