1 PACKAGE AMW_COMPLIANCE_ENV_ASSOCS_PVT AS
2 /* $Header: amwvenvs.pls 120.0 2005/05/31 20:31:01 appldev noship $ */
3
4 -- ===============================================================
5 -- Function name
6 -- COMPLIANCE_ENVS_PRESENT
7 -- Purpose
8 -- return non translated character (Y/N) to indicate the
9 -- selected(associated) Compliance Environment
10 -- History
11 -- 12.09.2004 tsho: bug 3902348 fixed
12 -- ===============================================================
13 FUNCTION COMPLIANCE_ENVS_PRESENT (
14 p_compliance_env_id IN NUMBER,
15 p_object_type IN VARCHAR2,
16 p_pk1 IN NUMBER,
17 p_pk2 IN NUMBER := NULL,
18 p_pk3 IN NUMBER := NULL,
19 p_pk4 IN NUMBER := NULL,
20 p_pk5 IN NUMBER := NULL
21 ) RETURN VARCHAR2;
22
23
24 -- ===============================================================
25 -- Function name
26 -- COMPLIANCE_ENVS_PRESENT_MEAN
27 -- Purpose
28 -- return translated meaning (Yes/No) to indicate the
29 -- selected(associated) Compliance Environment
30 -- ===============================================================
31 FUNCTION COMPLIANCE_ENVS_PRESENT_MEAN (
32 p_compliance_env_id IN NUMBER,
33 p_object_type IN VARCHAR2,
34 p_pk1 IN NUMBER,
35 p_pk2 IN NUMBER := NULL,
36 p_pk3 IN NUMBER := NULL,
37 p_pk4 IN NUMBER := NULL,
38 p_pk5 IN NUMBER := NULL
39 ) RETURN VARCHAR2;
40
41
42 -- ===============================================================
43 -- Function name
44 -- COMPLIANCE_ENVS_DISABLE
45 -- Purpose
46 -- return non translated character (Y/N) to indicate the
47 -- specified Compliance Environment should be disabled or not.
48 -- ===============================================================
49 FUNCTION COMPLIANCE_ENVS_DISABLE (
50 p_compliance_env_id IN NUMBER,
51 p_object_type IN VARCHAR2,
52 p_pk1 IN NUMBER,
53 p_object_id IN NUMBER := NULL,
54 p_pk2 IN NUMBER := NULL,
55 p_pk3 IN NUMBER := NULL,
56 p_pk4 IN NUMBER := NULL,
57 p_pk5 IN NUMBER := NULL
58 ) RETURN VARCHAR2;
59
60
61
62
63 -- ===============================================================
64 -- Procedure name
65 -- PROCESS_COMPLIANCE_ENV_ASSOCS
66 -- Purpose
67 -- Update the compliance environment associations depending
68 -- on the specified p_select_flag .
69 -- The p_pk1 is co-related with p_object_type, for exampel:
70 -- if p_object_type is SETUP_RISK_TYPE, then
71 -- p_pk1 is SETUP_RISK_TYPE_ID .
72 -- ===============================================================
73 PROCEDURE PROCESS_COMPLIANCE_ENV_ASSOCS (
74 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
75 p_commit IN VARCHAR2 := FND_API.G_FALSE,
76 p_validate_only IN VARCHAR2 := FND_API.G_FALSE,
77 p_select_flag IN VARCHAR2,
78 p_compliance_env_id IN NUMBER,
79 p_object_type IN VARCHAR2,
80 p_pk1 IN NUMBER,
81 p_pk2 IN NUMBER := NULL,
82 p_pk3 IN NUMBER := NULL,
83 p_pk4 IN NUMBER := NULL,
84 p_pk5 IN NUMBER := NULL,
85 x_return_status OUT NOCOPY VARCHAR2,
86 x_msg_count OUT NOCOPY NUMBER,
87 x_msg_data OUT NOCOPY VARCHAR2
88 );
89
90 -- ===============================================================
91 -- Function name
92 -- COMPLIANCE_ENVS_IN_USE
93 -- Purpose
94 -- return non translated character (Y/N) to indicate the
95 -- selected(associated) Compliance Environment is used for assoication
96 -- if it's in used, return 'Y', else, return 'N'.
97 -- Notes
98 -- don't need to bother which p_object_type it's associated with.
99 -- as long as it appears in amw_compliance_env_assocs table,
100 -- the return value will be 'Y'.
101 -- ===============================================================
102 FUNCTION COMPLIANCE_ENVS_IN_USE (
103 p_compliance_env_id IN NUMBER
104 ) RETURN VARCHAR2;
105
106 -- ----------------------------------------------------------------------
107 END AMW_COMPLIANCE_ENV_ASSOCS_PVT;