PACKAGE: APPS.HZ_COMMON_PUB

Source

1 PACKAGE hz_common_pub AS
2 /*$Header: ARHCOMMS.pls 120.2 2005/10/30 04:18:12 appldev ship $ */
3 
4 procedure commit_transaction;
5 
6 procedure rollback_transaction;
7 
8 function is_TCA_installed RETURN BOOLEAN;
9 
10 procedure validate_lookup(
11         p_lookup_type           IN      VARCHAR2,
12         p_column                IN      VARCHAR2,
13         p_column_value          IN      VARCHAR2,
14         x_return_status         IN OUT NOCOPY     VARCHAR2
15 );
16 
17 PROCEDURE validate_fnd_lookup(
18         p_lookup_type   IN     VARCHAR2,
19         p_column        IN     VARCHAR2,
20         p_column_value  IN     VARCHAR2,
21         x_return_status IN OUT NOCOPY VARCHAR2
22 );
23 
24 function get_account_number RETURN NUMBER;
25 function get_party_site_number RETURN NUMBER;
26 
27 
28 function content_source_type_security(
29 	p_object_schema		IN 	VARCHAR2,
30 	p_object_name		IN	VARCHAR2
31 ) RETURN VARCHAR2;
32 
33 
34 procedure enable_cont_source_security;
35 
36 procedure disable_cont_source_security;
37 
38 function get_cust_address(v_address_id in number) return varchar2;
39 PRAGMA RESTRICT_REFERENCES (get_cust_address,WNDS,WNPS,RNPS);
40 
41 function get_cust_name(v_cust_id in number) return varchar2;
42 PRAGMA RESTRICT_REFERENCES (get_cust_name,WNDS,WNPS,RNPS);
43 
44 function get_cust_contact_name(v_contact_id in number) return varchar2;
45 PRAGMA RESTRICT_REFERENCES (get_cust_contact_name,WNDS,WNPS,RNPS);
46 
47 function get_party_name(v_party_id in number) return varchar2;
48 PRAGMA RESTRICT_REFERENCES (get_party_name,WNDS,WNPS,RNPS);
49 
50 procedure check_mandatory_str_col(
51 	create_update_flag		IN  VARCHAR2,
52 	p_col_name 				IN  VARCHAR2,
53 	p_col_val				IN  VARCHAR2,
54 	p_miss_allowed_in_c		IN  BOOLEAN,
55 	p_miss_allowed_in_u		IN  BOOLEAN,
56 	x_return_status			IN OUT NOCOPY VARCHAR2
57 );
58 
59 procedure check_mandatory_date_col(
60 	create_update_flag		IN  VARCHAR2,
61 	p_col_name 				IN	VARCHAR2,
62 	p_col_val				IN  DATE,
63 	p_miss_allowed_in_c		IN  BOOLEAN,
64 	p_miss_allowed_in_u		IN  BOOLEAN,
65 	x_return_status			IN OUT NOCOPY VARCHAR2
66 );
67 
68 procedure check_mandatory_num_col(
69 	create_update_flag		IN  VARCHAR2,
70 	p_col_name 				IN	VARCHAR2,
71 	p_col_val				IN  NUMBER,
72 	p_miss_allowed_in_c		IN  BOOLEAN,
73 	p_miss_allowed_in_u		IN  BOOLEAN,
74 	x_return_status			IN OUT NOCOPY VARCHAR2
75 );
76 
77   FUNCTION time_compare(datetime1 IN DATE, datetime2 IN DATE) RETURN NUMBER;
78   FUNCTION is_time_between (
79     datetimex   IN      DATE,
80     datetime1   IN      DATE,
81     datetime2   IN      DATE
82   ) RETURN BOOLEAN;
83   FUNCTION is_time_overlap (
84     s1          IN      DATE,
85     e1          IN      DATE,
86     s2          IN      DATE,
87     e2          IN      DATE
88   ) RETURN VARCHAR2;
89 
90 
91 FUNCTION compare
92 (date1 DATE,
93  date2 DATE)
94 RETURN NUMBER;
95 
96 -- NULL indicates infinite
97 FUNCTION is_between
98 (datex DATE,
99  date1 DATE,
100  date2 DATE)
101 RETURN BOOLEAN;
102 
103 FUNCTION is_overlap
104 -- Returns 'Y' if period [s1,e1] overlaps [s2,e2]
105 --         'N' otherwise
106 --         NULL indicates infinite for end dates
107 (s1 DATE,
108  e1 DATE,
109  s2 DATE,
110  e2 DATE)
111 RETURN VARCHAR2;
112 
113 FUNCTION cleanse
114 -- Return varchar2 with a set of characters non desired.
115 ( str IN varchar2)
116 RETURN varchar2;
117 --BugNo:3071968--
118 PROCEDURE enable_health_care_security;
119 PROCEDURE disable_health_care_security;
120 PROCEDURE add_hcare_policy_function;
121 PROCEDURE drop_hcare_policy_function;
122 FUNCTION hcare_created_by_module_sec(p_object_schema IN  VARCHAR2,
123                                      p_object_name IN VARCHAR2)
124 RETURN VARCHAR2;
125 
126 --End of bugNo:3171968
127 
128 END;