PACKAGE: APPS.PER_JP_VALIDATIONS

Source

1 PACKAGE per_jp_validations AUTHID CURRENT_USER AS
2 /* $Header: pejpvald.pkh 115.6 2003/08/11 21:04:33 ytohya ship $ */
3 /*      p_format allows the following mask.
4 
5 	0 : 0-9		Numbers only, non-omittable
6 	9 : 0-9		Numbers only, omittable
7 	A : A-Z		Capital alphabet only, non-omittable
8 	P : A-Z		Capital alphabet only, omittable
9 	a : a-z		Small alphabet only, non-omittable
10 	p : a-z		Small alphabet only, omittable
11 	L : 0-9, A-Z	Numbers and capital alphabet only, non-omittable
12 	C : 0-9, A-Z	Numbers and capital alphabet only, omittable
13 	l : 0-9, a-z	Numbers and small alphabet only, non-omittable
14 	c : 0-9, a-z	Numbers and small alphabet only, omittable */
15 	FUNCTION CHECK_FORMAT(
16 			p_value		IN VARCHAR2,
17 			p_format	IN VARCHAR2) RETURN VARCHAR2;
18 --	pragma restrict_references(check_format,WNDS,WNPS);
19 --
20 	FUNCTION CHECK_DATE_FORMAT(
21 			p_value		IN VARCHAR2,
22 			p_format	IN VARCHAR2) RETURN VARCHAR2;
23 --
24 	FUNCTION DISTRICT_CODE_CHECK_DIGIT(
25 			p_district_code IN VARCHAR2) RETURN NUMBER;
26 --	pragma restrict_references(district_code_check_digit,WNDS,WNPS);
27 --
28 	FUNCTION DISTRICT_CODE_EXISTS(
29 			p_district_code	IN VARCHAR2,
30 			p_check_digit	IN VARCHAR2 DEFAULT 'TRUE') RETURN VARCHAR2;
31 --
32 	FUNCTION ORG_EXISTS(
33 			p_business_group_id	IN NUMBER,
34 			p_effective_date	IN DATE,
35 			p_organization_id	IN NUMBER,
36 			p_org_class		IN VARCHAR2) RETURN VARCHAR2;
37 --	pragma restrict_references(org_exists,WNDS,WNPS);
38 	FUNCTION CHECK_HALF_KANA(
39 			p_value			IN VARCHAR2) RETURN VARCHAR2;
40 --
41 	FUNCTION VEHICLE_EXISTS(
42 			p_business_group_id	IN NUMBER,
43 			p_assignment_id		IN NUMBER,
44 			p_effective_date	IN DATE,
45 			p_vehicle_allocation_id	IN NUMBER) RETURN VARCHAR2;
46 --
47 END per_jp_validations;