[Home] [Help]
PACKAGE: APPS.ZPB_EXCP_PVT
Source
1 PACKAGE zpb_excp_pvt AS
2 /* $Header: ZPBVEXCS.pls 120.0.12010.2 2005/12/23 06:06:18 appldev noship $ */
3
4 g_req_child_nodes CONSTANT number := 0;
5 g_child_nodes_populated CONSTANT number := 1;
6 g_req_explanation CONSTANT number := 2;
7 g_value_none CONSTANT number := 0;
8 g_value_number CONSTANT number := 1;
9 g_value_char CONSTANT number := 2;
10 g_value_date CONSTANT number := 3;
11
12 EXCEPTION_LIMIT CONSTANT varchar2(15) := 'EXCEPTION_LIMIT';
13 QUERY_OBJECT_PATH CONSTANT varchar2(17) := 'QUERY_OBJECT_PATH';
14 QUERY_OBJECT_NAME CONSTANT varchar2(17) := 'QUERY_OBJECT_NAME';
15
16 PROCEDURE request_children (
17 p_api_version IN NUMBER,
18 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
19 p_commit IN VARCHAR2 := FND_API.G_FALSE,
20 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
21 x_return_status OUT NOCOPY VARCHAR2,
22 x_msg_count OUT NOCOPY number,
23 x_msg_data OUT NOCOPY varchar2,
24 p_notification_id IN zpb_excp_explanations.notification_id%type,
25 p_task_id IN zpb_excp_explanations.task_id%type);
26
27 PROCEDURE run_exception (
28 p_api_version IN NUMBER,
29 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
30 p_commit IN VARCHAR2 := FND_API.G_FALSE,
31 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
32 x_return_status OUT NOCOPY varchar2,
33 x_msg_count OUT NOCOPY number,
34 x_msg_data OUT NOCOPY varchar2,
35 p_task_id IN NUMBER,
36 p_user_id IN NUMBER );
37
38 PROCEDURE test_run_exception;
39
40 procedure request_child_nodes(
41 p_api_version IN NUMBER,
42 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
43 p_commit IN VARCHAR2 := FND_API.G_FALSE,
44 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
45 x_return_status OUT NOCOPY VARCHAR2,
46 x_msg_count OUT NOCOPY number,
47 x_msg_data OUT NOCOPY varchar2,
48 p_task_id IN zpb_excp_explanations.task_id%type,
49 p_notification_id IN zpb_excp_explanations.notification_id%type);
50
51 PROCEDURE test_req_child;
52
53 END zpb_excp_pvt;