1 PACKAGE QA_ERES_UTIL AS
2 /* $Header: qaedruts.pls 120.3.12010000.1 2008/07/25 09:19:27 appldev ship $ */
3
4
5 -- This procedure takes in occurrence, collection_id and
6 -- plan_id of the Child Plan Result and gives out the
7 -- occurrence, collection_id and plan_id of the topmost
8 -- parent results record. .
9
10 PROCEDURE find_topmost_parent
11 (p_child_occ IN NUMBER,
12 p_child_coll_id IN NUMBER,
13 p_child_plan_id IN NUMBER,
14 p_parent_occ OUT NOCOPY NUMBER,
15 p_parent_coll_id OUT NOCOPY NUMBER,
16 p_parent_plan_id OUT NOCOPY NUMBER
17 );
18
19 -- This function takes in the occurrence, collection_id,
20 -- plan_id and char_id of the eSignature Status collection
21 -- element and returns the value in QA_RESULTS for the
22 -- eSignature Status element.
23
24 FUNCTION get_result_esig_status (p_occurrence IN NUMBER,
25 p_coll_id IN NUMBER,
26 p_plan_id IN NUMBER,
27 p_char_id IN NUMBER)
28 RETURN VARCHAR2;
29
30
31 -- This function returns the meaning from mfg_lookups
32 -- given the lookup_code and lookup_type.
33
34 FUNCTION get_mfg_lookups_meaning (p_lookup_type IN VARCHAR2,
35 p_lookup_code IN NUMBER)
36 RETURN VARCHAR2;
37
38 -- R12 ERES Support in Service Family. Bug 4345768
39 -- START
40 -- This function returns if a given plan is
41 -- enabled for deferred eSignatures. Returns Y or N
42
43 FUNCTION is_def_sig_enabled (p_plan_id IN NUMBER)
44 RETURN VARCHAR2;
45
46 -- This procedure enables a given collection plan for Deferred
47 -- Esignatures by adding the 'eSignature Status' element to the plan.
48 PROCEDURE add_esig_status ( p_plan_id IN NUMBER );
49
50 -- END
51 -- R12 ERES Support in Service Family. Bug 4345768
52
53 -- Bug 4502450. R12 Esig Status support in Multirow UQR
54 -- saugupta Wed, 24 Aug 2005 08:37:40 -0700 PDT
55
56 -- For a row in a plan Function return T if eSign
57 -- Status is PENDING else returns F
58
59 FUNCTION is_esig_status_pending(p_plan_id IN NUMBER,
60 p_collection_id IN NUMBER,
61 p_occurrence IN NUMBER) RETURN VARCHAR2;
62
63 -- R12.1 MES ERES Integration with Quality Start
64 -- This procedure takes in the collection id for a transaction
65 -- and generates the XML CLOB object for that transaction.
66 PROCEDURE generate_xml(p_collection_id IN varchar2,
67 x_xml_result OUT NOCOPY CLOB);
68
69 -- This procedure takes in the collection id, plan_id
70 -- and generates the XML CLOB object for that plan in the transaction
71 PROCEDURE generate_xml_for_plan(p_collection_id IN varchar2,
72 p_plan_id IN varchar2,
73 x_xml_result_plan OUT NOCOPY CLOB);
74
75 -- This procedure generates the XML CLOB object for for a particular
76 -- result row identified by plan_id, collection_id and occurrence
77 PROCEDURE get_xml_for_row(p_document_id IN varchar2,
78 x_xml_result_row OUT NOCOPY CLOB);
79 -- R12.1 MES ERES Integration with Quality Start
80
81 END QA_ERES_UTIL;
82