1: package DOM_DOCUMENT_UTIL AUTHID CURRENT_USER as
2: /*$Header: DOMPDUTS.pls 120.6 2006/07/14 22:22:43 mkimizuk noship $ */
3:
4: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_SUCCESS; --'S'
5: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_ERROR; --'E'
6: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_UNEXP_ERROR; --'U'
7:
8:
1: package DOM_DOCUMENT_UTIL AUTHID CURRENT_USER as
2: /*$Header: DOMPDUTS.pls 120.6 2006/07/14 22:22:43 mkimizuk noship $ */
3:
4: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_SUCCESS; --'S'
5: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_ERROR; --'E'
6: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_UNEXP_ERROR; --'U'
7:
8:
9: --
2: /*$Header: DOMPDUTS.pls 120.6 2006/07/14 22:22:43 mkimizuk noship $ */
3:
4: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_SUCCESS; --'S'
5: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_ERROR; --'E'
6: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_UNEXP_ERROR; --'U'
7:
8:
9: --
10: -- Fnd Lookup Type: DOM_PHASE_TYPES
18:
19:
20: Procedure Change_Doc_LC_Phase
21: ( p_api_version IN NUMBER --
22: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
23: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
24: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
25: ,p_change_id IN NUMBER
26: ,p_lc_phase_code IN NUMBER
19:
20: Procedure Change_Doc_LC_Phase
21: ( p_api_version IN NUMBER --
22: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
23: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
24: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
25: ,p_change_id IN NUMBER
26: ,p_lc_phase_code IN NUMBER
27: ,p_action_type IN VARCHAR2-- 'PROMOTE' or 'DEMOTE'
20: Procedure Change_Doc_LC_Phase
21: ( p_api_version IN NUMBER --
22: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
23: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
24: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
25: ,p_change_id IN NUMBER
26: ,p_lc_phase_code IN NUMBER
27: ,p_action_type IN VARCHAR2-- 'PROMOTE' or 'DEMOTE'
28: ,p_api_caller IN VARCHAR2
32: );
33:
34: Procedure Update_Approval_Status
35: ( p_api_version IN NUMBER --
36: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
37: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
38: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
39: ,p_change_id IN NUMBER
40: ,p_approval_status IN NUMBER
33:
34: Procedure Update_Approval_Status
35: ( p_api_version IN NUMBER --
36: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
37: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
38: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
39: ,p_change_id IN NUMBER
40: ,p_approval_status IN NUMBER
41: ,p_wf_route_status IN VARCHAR2
34: Procedure Update_Approval_Status
35: ( p_api_version IN NUMBER --
36: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
37: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
38: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
39: ,p_change_id IN NUMBER
40: ,p_approval_status IN NUMBER
41: ,p_wf_route_status IN VARCHAR2
42: ,p_api_caller IN VARCHAR2
47:
48:
49: Procedure Start_Doc_LC_Phase_WF
50: ( p_api_version IN NUMBER --
51: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
52: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
53: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
54: ,x_return_status OUT NOCOPY VARCHAR2 --
55: ,x_msg_count OUT NOCOPY NUMBER --
48:
49: Procedure Start_Doc_LC_Phase_WF
50: ( p_api_version IN NUMBER --
51: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
52: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
53: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
54: ,x_return_status OUT NOCOPY VARCHAR2 --
55: ,x_msg_count OUT NOCOPY NUMBER --
56: ,x_msg_data OUT NOCOPY VARCHAR2
49: Procedure Start_Doc_LC_Phase_WF
50: ( p_api_version IN NUMBER --
51: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
52: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
53: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
54: ,x_return_status OUT NOCOPY VARCHAR2 --
55: ,x_msg_count OUT NOCOPY NUMBER --
56: ,x_msg_data OUT NOCOPY VARCHAR2
57: ,p_change_id IN NUMBER
62:
63:
64: Procedure Abort_Doc_LC_Phase_WF
65: ( p_api_version IN NUMBER --
66: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
67: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
68: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
69: ,x_return_status OUT NOCOPY VARCHAR2 --
70: ,x_msg_count OUT NOCOPY NUMBER --
63:
64: Procedure Abort_Doc_LC_Phase_WF
65: ( p_api_version IN NUMBER --
66: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
67: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
68: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
69: ,x_return_status OUT NOCOPY VARCHAR2 --
70: ,x_msg_count OUT NOCOPY NUMBER --
71: ,x_msg_data OUT NOCOPY VARCHAR2
64: Procedure Abort_Doc_LC_Phase_WF
65: ( p_api_version IN NUMBER --
66: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
67: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
68: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
69: ,x_return_status OUT NOCOPY VARCHAR2 --
70: ,x_msg_count OUT NOCOPY NUMBER --
71: ,x_msg_data OUT NOCOPY VARCHAR2
72: ,p_change_id IN NUMBER