1 PACKAGE ENG_CHANGE_POLICY_PKG AS
2 /* $Header: ENGUCHPS.pls 120.1 2005/06/13 01:03:02 appldev $ */
3
4 PROCEDURE GetChangePolicy
5 ( p_policy_object_name IN VARCHAR2
6 , p_policy_code IN VARCHAR2
7 , p_policy_pk1_value IN VARCHAR2
8 , p_policy_pk2_value IN VARCHAR2
9 , p_policy_pk3_value IN VARCHAR2
10 , p_policy_pk4_value IN VARCHAR2
11 , p_policy_pk5_value IN VARCHAR2
12 , p_attribute_object_name IN VARCHAR2
13 , p_attribute_code IN VARCHAR2
14 , p_attribute_value IN VARCHAR2
15 , x_policy_value OUT NOCOPY VARCHAR2
16 );
17
18 -- Start of comments
19 -- API name : GET_OPATTR_CHANGEPOLICY
20 -- Type : Public
21 -- Pre-reqs : None.
22 -- Function : Gets the strict-most policy from the comma-delimited
23 -- list of operational attribute group ids.
24 -- Parameters :
25 -- Parameters :
26 -- IN : p_api_version IN NUMBER Required
27 -- p_catalog_category_id IN VARCHAR2 Required
28 -- p_item_lifecycle_id IN VARCHAR2 Required
29 -- p_lifecycle_phase_id IN VARCHAR2 Required
30 -- p_attribute_grp_ids IN VARCHAR2 Required
31 -- OUT : x_return_status OUT VARCHAR2(1)
32 -- x_policy_value OUT VARCHAR2(30)
33 -- Version : Current version 1.0
34 -- Initial version 1.0
35 --
36 -- Notes : This API is to be called ONLY to get the policies of
37 -- operational attribute groups.
38 --
39 -- End of comments
40 PROCEDURE GET_OPATTR_CHANGEPOLICY
41 ( p_api_version IN NUMBER
42 , x_return_status OUT NOCOPY VARCHAR2
43 , p_catalog_category_id IN VARCHAR2
44 , p_item_lifecycle_id IN VARCHAR2
45 , p_lifecycle_phase_id IN VARCHAR2
46 , p_attribute_grp_ids IN VARCHAR2
47 , x_policy_value OUT NOCOPY VARCHAR2
48 );
49
50 END ENG_CHANGE_POLICY_PKG ;