PACKAGE: APPS.QA_SPECS_PKG

Source

1 PACKAGE qa_specs_pkg AS
2 /* $Header: qaspecs.pls 120.2 2006/07/17 04:18:44 bso noship $ */
3 
4     --
5     -- General utilities for QA_SPECS entity.
6     -- bso Thu May 12 16:52:19 PDT 2005
7     --
8 
9 
10     --
11     -- Find out if an item is subsumed by a Spec's setup.
12     -- It is if any one is true:
13     --   p_item_id = p_spec_item_id
14     --   p_spec_item_id is null and
15     --      p_item_id is within the given item category
16     --      and item category set.
17     --   p_spec_item_id is null and p_spec_cat_id is null and
18     --      p_item_id is within the given item category set.
19     --   Return 'T' or 'F'
20     --
21     -- bso Thu May 12 16:54:59 PDT 2005
22     --
23     FUNCTION spec_item_matched(
24         p_organization_id NUMBER,
25         p_item_id NUMBER,
26         p_spec_item_id NUMBER,
27         p_spec_cat_id NUMBER,
28         p_spec_cat_set_id NUMBER)
29     RETURN VARCHAR2;
30 
31 
32     --
33     -- Supporting functions that may be useful for
34     -- other purposes, thus making them public.
35     --
36         FUNCTION item_in_cat_set(
37             p_organization_id NUMBER,
38             p_item_id NUMBER,
39             p_spec_cat_set_id NUMBER)
40         RETURN BOOLEAN;
41 
42 
43         FUNCTION item_in_cat(
44             p_organization_id NUMBER,
45             p_item_id NUMBER,
46             p_spec_cat_id NUMBER,
47             p_spec_cat_set_id NUMBER)
48         RETURN BOOLEAN;
49 
50 
51     --
52     -- Tracking Bug 4939897
53     -- R12 Forms Tech Stack Upgrade - Obsolete Oracle Graphics
54     -- Also a generically useful function.
55     -- bso Tue Feb  7 15:41:15 PST 2006
56     --
57     FUNCTION get_spec_name(p_spec_id NUMBER) RETURN VARCHAR2;
58 
59 
60     --
61     -- Bug 5231952
62     -- Add a utility to copy attachments when assigning a parent
63     -- spec to a child.
64     -- bso Sun Jul 16 20:27:24 PDT 2006
65     --
66     PROCEDURE copy_attachment(p_from_spec_id NUMBER, p_to_spec_id NUMBER);
67 
68 
69 END qa_specs_pkg;