1 PACKAGE EGO_ITEM_AML_PUB AUTHID CURRENT_USER AS
2 /* $Header: EGOITAMS.pls 115.8 2004/07/01 06:08:33 srajapar noship $ */
3
4 G_FILE_NAME CONSTANT VARCHAR2(12) := 'EGOITAMS.pls';
5
6 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1)
7 := FND_API.g_RET_STS_SUCCESS; --'S'
8 G_RET_STS_ERROR CONSTANT VARCHAR2(1)
9 := FND_API.g_RET_STS_ERROR; --'E'
10 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1)
11 := FND_API.g_RET_STS_UNEXP_ERROR; --'U'
12 G_EGO_SHORT_YES CONSTANT VARCHAR2(1) := 'Y';
13 G_EGO_SHORT_NO CONSTANT VARCHAR2(1) := 'N';
14
15 -- =============================================================================
16 -- Public Procedures
17 -- =============================================================================
18
19 -- -----------------------------------------------------------------------------
20 -- API Name: Check CM Existance
21 --
22 -- Type: Public
23 --
24 -- Description: To check whether ENG product is installed
25 -- Returns 'S' if ENG is installed and active
26 -- Returns 'E' in all other cases
27 --
28 -- Version: Current version 1.0
29 -- -----------------------------------------------------------------------------
30
31 FUNCTION Check_CM_Existance RETURN VARCHAR2;
32
33 -- -----------------------------------------------------------------------------
34 -- API Name: Implement_AML_Changes
35 --
36 -- Type: Public
37 --
38 -- Description: To Implement the AML Changes
39 -- find the corresponding records in EGO_MFG_PART_NUM_CHGS
40 -- and implement the same onto MTL_MFG_PART_NUMBERS
41 --
42 -- Version: Current version 1.0
43 -- -----------------------------------------------------------------------------
44
45 Procedure Implement_AML_Changes (
46 p_api_version IN NUMBER,
47 p_init_msg_list IN VARCHAR2,
48 p_commit IN VARCHAR2,
49 p_change_id IN NUMBER,
50 p_change_line_id IN NUMBER,
51 x_return_status OUT NOCOPY VARCHAR2,
52 x_msg_count OUT NOCOPY NUMBER,
53 x_msg_data OUT NOCOPY VARCHAR2
54 );
55
56 -- -----------------------------------------------------------------------------
57 -- API Name: Delete_AML_Pending_Changes
58 --
59 -- Type: Public
60 --
61 -- Description: To delete the pending change from EGO_MFG_PART_NUM_CHGS
62 --
63 -- Version: Current version 1.0
64 -- -----------------------------------------------------------------------------
65
66 Procedure Delete_AML_Pending_Changes
67 (p_api_version IN NUMBER
68 ,p_init_msg_list IN VARCHAR2
69 ,p_commit IN VARCHAR2
70 ,p_inventory_item_id IN NUMBER
71 ,p_organization_id IN NUMBER
72 ,p_manufacturer_id IN NUMBER
73 ,p_mfg_part_num IN VARCHAR2
74 ,p_change_id IN NUMBER
75 ,p_change_line_id IN NUMBER
76 ,p_acd_type IN VARCHAR2
77 ,x_return_status OUT NOCOPY VARCHAR2
78 ,x_msg_count OUT NOCOPY VARCHAR2
79 ,x_msg_data OUT NOCOPY VARCHAR2
80 );
81
82 -- -----------------------------------------------------------------------------
83 -- API Name: Check AML Policy Allowed
84 --
85 -- Type: Public
86 --
87 -- Description: To check whether the AML Changes are allowed
88 -- on the given item in the reqd organization
89 -- returns the status in x_return_status
90 -- Returns 'Y' if the Policy is allowed
91 -- Returns 'N' in all other cases
92 --
93 -- Version: Current version 1.0
94 -- -----------------------------------------------------------------------------
95
96 Procedure Check_AML_Policy_Allowed
97 (p_api_version IN NUMBER
98 ,p_inventory_item_id IN NUMBER
99 ,p_organization_id IN NUMBER
100 ,p_catalog_category_id IN NUMBER
101 ,p_lifecycle_id IN NUMBER
102 ,p_lifecycle_phase_id IN NUMBER
103 ,p_allowable_policy IN VARCHAR2
104 ,x_return_status OUT NOCOPY VARCHAR2
105 ,x_policy_name OUT NOCOPY VARCHAR2
106 ,x_item_number OUT NOCOPY VARCHAR2
107 ,x_org_name OUT NOCOPY VARCHAR2
108 );
109
110
111 -- -----------------------------------------------------------------------------
112 -- API Name: Check AML Privilege
113 --
114 -- Type: Public
115 --
116 -- Description: To check whether the user has the specified privilege
117 -- on the given item in the reqd organization
118 -- Returns 'Y' if the item can be edited
119 -- Returns 'N' in all other cases
120 --
121 -- Version: Current version 1.0
122 -- -----------------------------------------------------------------------------
123
124 Function Check_No_AML_Priv
125 (p_api_version IN NUMBER
126 ,p_inventory_item_id IN NUMBER
127 ,p_organization_id IN NUMBER
128 ,p_privilege_name IN VARCHAR2
129 ,p_party_id IN NUMBER DEFAULT NULL
130 ,p_user_id IN NUMBER DEFAULT NULL
131 ) RETURN VARCHAR2;
132
133 -- -----------------------------------------------------------------------------
134 -- API Name: Check_No_MFG_Associations
135 --
136 -- Type: Public
137 --
138 -- Description: To check if any associations exist on the manufacturer
139 -- Returns 'Y' if no associations exist
140 -- Returns 'N' in all other cases
141 -- The message_name changes for EGO and INV
142 --
143 -- Version: Current version 1.0
144 -- -----------------------------------------------------------------------------
145 PROCEDURE Check_No_MFG_Associations
146 (p_api_version IN NUMBER
147 ,p_manufacturer_id IN NUMBER
148 ,p_manufacturer_name IN VARCHAR2
149 ,x_return_status OUT NOCOPY VARCHAR2
150 ,x_message_name OUT NOCOPY VARCHAR2
151 ,x_message_text OUT NOCOPY VARCHAR2
152 );
153
154
155 END EGO_ITEM_AML_PUB;
156