1 PACKAGE AMW_SIGNIFICANT_ELEMENTS_PKG AUTHID CURRENT_USER as
2 /* $Header: amwvsigs.pls 120.0 2005/05/31 23:13:29 appldev noship $ */
3
4 -- ===============================================================
5 -- Package name
6 -- AMW_SIGNIFICANT_ELEMENTS_PKG
7 -- Purpose
8 --
9 -- History
10 -- 12/18/2003 tsho Creates
11 -- ===============================================================
12
13
14
15 -- ===============================================================
16 -- Function name
17 -- ELEMENT_PRESENT
18 -- Purpose
19 -- return 'Y' if there's element for the specified object_id;
20 -- return 'N' otherwise.
21 -- ===============================================================
22 FUNCTION ELEMENT_PRESENT (
23 P_OBJECT_ID IN NUMBER,
24 P_OBJECT_TYPE IN VARCHAR2,
25 P_ELEMENT_CODE IN VARCHAR2
26 ) RETURN VARCHAR2;
27
28
29 -- ===============================================================
30 -- Procedure name
31 -- PROCESS_ELEMENTS
32 -- Purpose
33 -- update the elements for specified object_id
34 -- Notes
35 -- OBJECT_TYPE = 'PROCESS' with PK1 = PROCESS_REV_ID
36 -- OBJECT_TYPE = 'PROCESS_ORG' with PK1 = PROCESS_ORGANIZATION_ID
37 -- ===============================================================
38 PROCEDURE PROCESS_ELEMENTS (
39 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
40 p_commit IN VARCHAR2 := FND_API.G_FALSE,
41 p_validate_only IN VARCHAR2 := FND_API.G_FALSE,
42 p_select_flag IN VARCHAR2,
43 p_object_id IN NUMBER,
44 p_object_type IN VARCHAR2,
45 p_element_code IN VARCHAR2,
46 x_return_status OUT NOCOPY VARCHAR2,
47 x_msg_count OUT NOCOPY NUMBER,
48 x_msg_data OUT NOCOPY VARCHAR2
49 );
50
51 -- ===============================================================
52 -- Function name
53 -- ELEMENT_PRESENT_IN_LATEST
54 -- Purpose
55 -- return 'Y' if there's element for the specified object_id;
56 -- return 'N' otherwise.
57 -- Created nirmakum
58 -- Reason AMW.D, for knowing if there is a latest association of a significant element
59 -- to a process
60 -- ===============================================================
61
62 FUNCTION ELEMENT_PRESENT_IN_LATEST (
63 P_OBJECT_ID IN NUMBER,
64 P_OBJECT_TYPE IN VARCHAR2,
65 P_ELEMENT_CODE IN VARCHAR2
66 ) RETURN VARCHAR2;
67 -- ----------------------------------------------------------------------
68 -- ===============================================================
69 -- Function name
70 -- ELEMENT_PRESENT_IN_REVISION
71 -- Purpose
72 -- return 'Y' if there's element for the specified object_id;
73 -- return 'N' otherwise.
74 -- Created kosriniv
75 -- Reason AMW.D, for knowing if there is an association of a significant element
76 -- to a process revision
77 -- ===============================================================
78 FUNCTION ELEMENT_PRESENT_IN_REVISION (
79 P_OBJECT_ID IN NUMBER,
80 P_OBJECT_TYPE IN VARCHAR2,
81 P_ELEMENT_CODE IN VARCHAR2
82 ) RETURN VARCHAR2;
83 -- --------------------------------------------------------------------------------
84 END AMW_SIGNIFICANT_ELEMENTS_PKG;