1 PACKAGE OKC_TERMS_TMPL_APPROVAL_GRP AS
2 /* $Header: OKCGTMPLAPPS.pls 120.0 2005/05/25 22:40:29 appldev noship $ */
3
4 /* added 2 new IN params and 1 out param
5 p_validation_level : 'A' or 'E' do all checks or checks with severity = E
6 p_check_for_drafts : 'Y' or 'N' if Y checks for drafts and inserts them
7 in the OKC_TMPL_DRAFT_CLAUSES table
8 x_sequence_id : contains the sequence id for table OKC_QA_ERRORS_T
9 that contains the validation results
10
11 Existing out param x_qa_return_status will change to
12 have the following statues
13 x_qa_return_status : S if the template was succesfully submitted
14 W if qa check resulted in warnings. Use x_sequence_id
15 to display the qa results.
16 E if qa check resulted in errors. Use x_sequence_id
17 to display the qa results
18 D if there are draft articles and the user should be
19 redirected to the new submit page. Use x_sequence_id
20 if not null, to display a warnings link on the
21 new submit page.
22
23 p_validation_level p_check_for_drafts
24 Search/View/Update : A Y
25 New Submit Page : A N
26 Validation Page : E N
27
28 */
29 PROCEDURE start_approval (
30 p_api_version IN Number,
31 p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
32 p_commit IN Varchar2 default FND_API.G_FALSE,
33 p_template_id IN Number,
34 p_object_version_number IN Number default NULL,
35 x_return_status OUT NOCOPY Varchar2,
36 x_msg_data OUT NOCOPY Varchar2,
37 x_msg_count OUT NOCOPY Number,
38 x_qa_return_status OUT NOCOPY Varchar2,
39
40 p_validation_level IN VARCHAR2 DEFAULT 'A',
41 p_check_for_drafts IN VARCHAR2 DEFAULT 'N',
42 x_sequence_id OUT NOCOPY NUMBER);
43
44
45 END OKC_TERMS_TMPL_APPROVAL_GRP;