APPS.AMW_SIGNIFICANT_ELEMENTS_PKG dependencies on AMW_SIGNIFICANT_ELEMENTS

Line 1: PACKAGE BODY AMW_SIGNIFICANT_ELEMENTS_PKG as

1: PACKAGE BODY AMW_SIGNIFICANT_ELEMENTS_PKG as
2: /* $Header: amwvsigb.pls 120.0 2005/05/31 22:13:47 appldev noship $ */
3:
4:
5: -- ===============================================================

Line 7: -- AMW_SIGNIFICANT_ELEMENTS_PKG

3:
4:
5: -- ===============================================================
6: -- Package name
7: -- AMW_SIGNIFICANT_ELEMENTS_PKG
8: -- Purpose
9: --
10: -- History
11: -- 12/18/2003 tsho Creates

Line 35: from AMW_SIGNIFICANT_ELEMENTS

31:
32: BEGIN
33: select count(*)
34: into n
35: from AMW_SIGNIFICANT_ELEMENTS
36: where pk1 = P_OBJECT_ID
37: and object_type = P_OBJECT_TYPE
38: and element_code = P_ELEMENT_CODE;
39:

Line 96: delete from AMW_SIGNIFICANT_ELEMENTS

92:
93: -- initialize return status to success
94: x_return_status := fnd_api.g_ret_sts_success;
95:
96: delete from AMW_SIGNIFICANT_ELEMENTS
97: where pk1 = p_object_id
98: and object_type = p_object_type
99: and element_code = p_element_code;
100:

Line 111: insert into AMW_SIGNIFICANT_ELEMENTS (

107: l_object_version_number := 1;
108:
109: select AMW_SIGNIFICANT_ELEMENT_S.nextval into l_significant_element_id from dual;
110:
111: insert into AMW_SIGNIFICANT_ELEMENTS (
112: significant_element_id,
113: object_type,
114: pk1,
115: element_code,

Line 155: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AMW_SIGNIFICANT_ELEMENTS_PKG',

151: IF FND_API.to_Boolean( p_commit ) THEN
152: ROLLBACK TO PROCESS_ELEMENTS_SAVE;
153: END IF;
154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
155: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AMW_SIGNIFICANT_ELEMENTS_PKG',
156: p_procedure_name => 'PROCESS_ELEMENTS',
157: p_error_text => SUBSTRB(SQLERRM,1,240));
158:
159: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 185: from AMW_SIGNIFICANT_ELEMENTS

181: IS
182: n pls_integer;
183: BEGIN
184: select 1 into n
185: from AMW_SIGNIFICANT_ELEMENTS
186: where pk1 = P_OBJECT_ID
187: and object_type = P_OBJECT_TYPE
188: and element_code = P_ELEMENT_CODE
189: and deletion_date is null;

Line 211: from AMW_SIGNIFICANT_ELEMENTS ASE,

207: IS
208: n pls_integer;
209: BEGIN
210: select 1 into n
211: from AMW_SIGNIFICANT_ELEMENTS ASE,
212: AMW_PROCESS AP
213: where AP.process_rev_id = P_OBJECT_ID
214: and ASE.pk1 = AP.PROCESS_ID
215: and ASE.object_type = P_OBJECT_TYPE

Line 231: END AMW_SIGNIFICANT_ELEMENTS_PKG;

227: when too_many_rows then
228: return 'Y';
229: end ELEMENT_PRESENT_IN_REVISION;
230:
231: END AMW_SIGNIFICANT_ELEMENTS_PKG;