1 package DOM_DOCUMENT_UTIL 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 --
10 -- Fnd Lookup Type: DOM_PHASE_TYPES
11 -- Used for Document Lifecycle Phase Type
12 --
13 G_PHASE_TYPE_CREATE CONSTANT NUMBER := 1 ; -- Create
14 G_PHASE_TYPE_RELEASE CONSTANT NUMBER := 7 ; -- Release
15 G_PHASE_TYPE_APPROVAL CONSTANT NUMBER := 8 ; -- Approval
16 G_PHASE_TYPE_REVIEW CONSTANT NUMBER := 12 ; -- Review
17 G_PHASE_TYPE_ARCHIVE CONSTANT NUMBER := 40 ; -- Archive
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
27 ,p_action_type IN VARCHAR2-- 'PROMOTE' or 'DEMOTE'
28 ,p_api_caller IN VARCHAR2
29 ,x_return_status OUT NOCOPY VARCHAR2 --
30 ,x_msg_count OUT NOCOPY NUMBER --
31 ,x_msg_data OUT NOCOPY 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
41 ,p_wf_route_status IN VARCHAR2
42 ,p_api_caller 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
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
58 ,p_route_id IN NUMBER
59 ,p_lc_phase_code IN NUMBER := NULL
60 ,p_api_caller IN VARCHAR2
61 );
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 --
71 ,x_msg_data OUT NOCOPY VARCHAR2
72 ,p_change_id IN NUMBER
73 ,p_route_id IN NUMBER
74 ,p_lc_phase_code IN NUMBER := NULL
75 ,p_api_caller IN VARCHAR2
76 );
77
78
79
80 -- -----------------------------------------------------------------------------
81 -- API Name: Generate_Seq_For_Doc_Catalog
82 -- Nisar
83 -- Description:
84 -- Generates the Item Sequence For Number Generation or Revision Generation.
85 -- -----------------------------------------------------------------------------
86 PROCEDURE Generate_Seq_For_Doc_Category
87 (
88 p_doc_category_id IN NUMBER
89 ,p_seq_start_num IN NUMBER
90 ,p_seq_increment_by IN NUMBER
91 ,x_return_status OUT NOCOPY VARCHAR2
92 ,x_errorcode OUT NOCOPY NUMBER
93 ,x_msg_count OUT NOCOPY NUMBER
94 ,x_msg_data OUT NOCOPY VARCHAR2
95 ,p_num_rev_type IN VARCHAR2
96 );
97
98 ----------------------------------------------------------------------
99
100 -- -----------------------------------------------------------------------------
101 -- API Name: Drop_Sequence_For_Doc_Category
102 -- Nisar
103 -- Description:
104 -- Generates the Item Sequence For Number Generation
105 -- -----------------------------------------------------------------------------
106 PROCEDURE Drop_Sequence_For_Category (
107 p_doc_category_seq_name IN VARCHAR2
108 ,x_return_status OUT NOCOPY VARCHAR2
109 ,x_errorcode OUT NOCOPY NUMBER
110 ,x_msg_count OUT NOCOPY NUMBER
111 ,x_msg_data OUT NOCOPY VARCHAR2
112 );
113
114 -------------------------------------------------------------------------
115
116 FUNCTION GET_DOC_NUM_SCHEME
117 ( P_CATEGORY_ID IN NUMBER
118 ) RETURN VARCHAR2 ;
119
120 -- -----------------------------------------------------------------------------
121 -- API Name: rowtocol
122 -- Srinivas Chintamani
123 -- Description:
124 -- Generic function to convert rows returned by arbitrary SQL into
125 -- a list using the passed in seperator character.
126 -- -----------------------------------------------------------------------------
127 FUNCTION rowtocol
128
129 ( p_slct IN VARCHAR2,
130 p_dlmtr IN VARCHAR2 DEFAULT ','
131
132 ) RETURN VARCHAR2;
133
134 -- -----------------------------------------------------------------------------
135
136 END DOM_DOCUMENT_UTIL;