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,
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,
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,
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,
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,
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,
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,
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,