[Home] [Help]
PACKAGE: APPS.FPA_VALIDATION_PVT
Source
1 PACKAGE FPA_VALIDATION_PVT as
2 /* $Header: FPAVVALS.pls 120.5 2006/03/20 19:11:32 appldev noship $ */
3 G_API_NAME CONSTANT VARCHAR2(80) := 'FPA_VALIDATION_PVT';
4
5 SUBTYPE FPA_VALIDATION_LINES_REC IS FPA_VALIDATION_LINES%ROWTYPE;
6 TYPE PROJECT_ID_TBL_TYPE is TABLE of varchar2(4000) index by binary_integer;
7
8 G_ERROR CONSTANT VARCHAR2(1) := 'E';
9 G_WARNING CONSTANT VARCHAR2(1) := 'W';
10 G_INFORMATION CONSTANT VARCHAR2(1) := 'I';
11
12 G_NO_RESOURCE_REC CONSTANT INTEGER := 0;
13 G_RESOURCE_LOCKED CONSTANT INTEGER := 1;
14 G_RESOURCE_BUSY CONSTANT INTEGER := 2;
15
16 /* ***********************************************************************
17 Desc:
18 parameters:
19 return:
20 ***************************************************************************/
21
22 PROCEDURE Validate
23 (
24 p_api_version IN NUMBER,
25 p_init_msg_list IN VARCHAR2,
26 p_validation_set IN VARCHAR2,
27 p_header_object_id IN NUMBER,
28 p_header_object_type IN VARCHAR2,
29 p_line_projects_tbl IN PROJECT_ID_TBL_TYPE,
30 x_return_status OUT NOCOPY VARCHAR2,
31 x_msg_count OUT NOCOPY NUMBER,
32 x_msg_data OUT NOCOPY VARCHAR2
33 );
34
35
36 PROCEDURE Validate
37 (
38 p_api_version IN NUMBER,
39 p_init_msg_list IN VARCHAR2,
40 p_validation_set IN VARCHAR2,
41 p_header_object_id IN NUMBER,
42 p_header_object_type IN VARCHAR2,
43 x_return_status OUT NOCOPY VARCHAR2,
44 x_msg_count OUT NOCOPY NUMBER,
45 x_msg_data OUT NOCOPY VARCHAR2
46 );
47
48 FUNCTION Add_Validation
49 (
50 p_validation IN VARCHAR2,
51 p_severity_code IN VARCHAR2,
52 p_object_id IN NUMBER,
53 p_object_type IN VARCHAR2
54 ) RETURN BOOLEAN;
55
56 PROCEDURE Create_Validation_Line
57 (
58 p_api_version IN NUMBER,
59 p_init_msg_list IN VARCHAR2,
60 p_validation_set IN VARCHAR2,
61 p_validation_lines_rec IN FPA_VALIDATION_LINES_REC,
62 x_validation_id OUT NOCOPY NUMBER,
63 x_return_status OUT NOCOPY VARCHAR2,
64 x_msg_count OUT NOCOPY NUMBER,
65 x_msg_data OUT NOCOPY VARCHAR2
66 );
67
68
69 PROCEDURE Initialize;
70
71 PROCEDURE Close_Validations;
72
73 FUNCTION Count_Validations RETURN NUMBER;
74
75 FUNCTION Check_Error_Level
76 (
77 p_object_id IN NUMBER,
78 p_object_type IN VARCHAR2,
79 p_error_level IN VARCHAR2) RETURN BOOLEAN;
80
81 FUNCTION Validation RETURN BOOLEAN;
82
83 END FPA_VALIDATION_PVT;