DBA Data[Home] [Help]

APPS.INV_CACHE dependencies on MTL_CLIENT_PARAMETERS

Line 598: | x_client_parameters_rec - It returns the record of mtl_client_parameters |

594: | p_client_id - The client ID for which the record needs to be passed. |
595: | Output Parameters: |
596: | x_return_status - fnd_api.g_ret_sts_success, if succeeded |
597: | fnd_api.g_ret_sts_error, if error occurred |
598: | x_client_parameters_rec - It returns the record of mtl_client_parameters |
599: | for the passed client_id |
600: | and can be queried in the following format |
601: | Dbms_Output.put_line('Client ID -'||ct_rec.client_rec.client_id) |
602: *================================================================================== */

Line 606: p_client_id IN MTL_CLIENT_PARAMETERS.CLIENT_ID%TYPE

602: *================================================================================== */
603:
604: PROCEDURE get_client_default_parameters
605: (
606: p_client_id IN MTL_CLIENT_PARAMETERS.CLIENT_ID%TYPE
607: , x_return_status OUT NOCOPY VARCHAR2
608: , x_client_parameters_rec OUT NOCOPY ct_rec_type
609: )
610: AS

Line 613: IS SELECT * FROM MTL_CLIENT_PARAMETERS

609: )
610: AS
611:
612: CURSOR client_info(p_client_id NUMBER)
613: IS SELECT * FROM MTL_CLIENT_PARAMETERS
614: WHERE client_id = p_client_id ;
615:
616: BEGIN
617: x_return_status := fnd_api.g_ret_sts_success;