PACKAGE: APPS.FTE_COMP_CONSTRAINT_UTIL

Source

1 PACKAGE FTE_COMP_CONSTRAINT_UTIL AUTHID CURRENT_USER as
2 /* $Header: FTECCUTS.pls 115.2 2003/01/21 01:32:24 ttrichy noship $ */
3 
4 --G_PKG_NAME CONSTANT VARCHAR2(30) := 'FTE_COMP_CONSTRAINT_UTIL';
5 
6 -- Global Variables
7 
8 FUNCTION get_object_name(
9              --p_comp_class_id           IN NUMBER,
10              p_object_type             IN      VARCHAR2,
11              p_object_value_num        IN NUMBER DEFAULT NULL,
12              p_object_parent_id        IN NUMBER DEFAULT NULL,
13              p_object_value_char       IN VARCHAR2 DEFAULT NULL,
14              x_fac_company_name        OUT NOCOPY      VARCHAR2,
15              x_fac_company_type        OUT NOCOPY  VARCHAR2 ) RETURN VARCHAR2 ;
16 
17 PROCEDURE get_facility_display(
18              p_source_location_id      IN VARCHAR2,
19              p_source_location_code    IN VARCHAR2,
20              x_fac_sites               OUT NOCOPY      VARCHAR2,
21              x_fac_company_type        OUT NOCOPY      VARCHAR2,
22              x_fac_company_name        OUT NOCOPY      VARCHAR2,
23              x_return_status           OUT NOCOPY      VARCHAR2,
24 	     x_msg_count               OUT NOCOPY      NUMBER,
25 	     x_msg_data                OUT NOCOPY      VARCHAR2 );
26 
27 END FTE_COMP_CONSTRAINT_UTIL;
28