1 PACKAGE qa_audit_pkg AUTHID CURRENT_USER AS
2 /* $Header: qaaudits.pls 120.1 2005/07/14 03:31 srhariha noship $ */
3
4 --
5 -- General utilities for audit.
6 --
7
8
9 --
10 -- Search paramters
11 --
12 TYPE summary_param_rec IS RECORD (standard varchar2(150));
13 TYPE cat_summary_param_rec IS RECORD (standard varchar2(150),
14 section varchar2(150),
15 area varchar2(150),
16 category varchar2(150));
17
18 TYPE SummaryParamArray IS TABLE OF summary_param_rec INDEX BY BINARY_INTEGER;
19 TYPE CatSummaryParamArray IS TABLE OF cat_summary_param_rec INDEX BY BINARY_INTEGER;
20
21
22 --
23 -- Copy questions from Audit Question Bank to Audit Questions and Response plan.
24 -- It also does the following.
25 -- (1) Copy context elements from audit master.
26 -- (2) Create history records for audit questions.
27 --
28 -- Parameters IN :
29 --
30 -- Audit Question Bank details :-
31 -- p_audit_bank_plan_id - Question Bank Plan id
32 -- p_audit_bank_org_id - Organization in which Question bank is stored.
33 --
34 -- Audit Questions and Response plan details :-
35 -- p_audit_question_plan_id - Audit Questions Plan id
36 -- p_audit_question_org_id - Audit Questions org id
37 --
38 -- Search parameters :-
39 -- p_summary_params - Audit Summary search param (standard)
40 -- p_cat_summary_params - Audit Category Summary search param (standard,section,area,cat)
41 --
42 -- Parameters OUT :
43 -- x_count - Number of rows copied
44 --
45 --
46 -- IMPORTANT:
47 -- Currently we use Rosetta tool to generate wrapper for this function. Following
48 -- files are dependent on this procedure and package types.
49 --
50 -- (1) java/audit/server/QuestionBankAMImpl.java
51 -- (2) java/audit/SummaryParamRec.java
52 -- (3) java/audit/CatSummaryParamRec.java
53 -- (4) patch/115/sql/qaaudwrs.pls
54 -- (5) patch/115/sql/qaaudwrb.pls
55 --
56 -- If someone changes signature of this procedure or TYPES defined in this package,
57 -- they must generate wrappers using Rosetta tool to reflect the changes in wrappers.
58 --
59 -- Please refer helper document for more details :
60 -- http://files.oraclecorp.com/content/AllPublic/SharedFolders/Manufacturing-Public/SADBILMO/Quality%20Management/Build/11.5.11/Audits/Copy%20Audit%20UI/Helper%20document%20to%20use%20Rosetta%20tool.doc
61
62
63
64
65 PROCEDURE copy_questions(
66 p_audit_bank_plan_id NUMBER,
67 p_audit_bank_org_id NUMBER,
68 p_summary_params qa_audit_pkg.SummaryParamArray,
69 p_cat_summary_params qa_audit_pkg.CatSummaryParamArray,
70 p_audit_question_plan_id NUMBER,
71 p_audit_question_org_id NUMBER,
72 p_audit_num VARCHAR2,
73 x_count OUT NOCOPY NUMBER,
74 x_msg_count OUT NOCOPY NUMBER,
75 x_msg_data OUT NOCOPY VARCHAR2,
76 x_return_status OUT NOCOPY VARCHAR2);
77
78 END qa_audit_pkg;
[Home] [Help]