APPS.AMS_IMP_XML_ELEMENTS_PKG dependencies on AMS_IMP_XML_ELEMENTS

Line 1: PACKAGE BODY AMS_IMP_XML_ELEMENTS_PKG as

1: PACKAGE BODY AMS_IMP_XML_ELEMENTS_PKG as
2: /* $Header: amslxelb.pls 115.6 2002/11/14 21:56:56 jieli noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_IMP_XML_ELEMENTS_PKG

2: /* $Header: amslxelb.pls 115.6 2002/11/14 21:56:56 jieli noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMS_IMP_XML_ELEMENTS_PKG
7: -- Purpose
8: -- Manage XML Elements.
9: --
10: -- History

Line 21: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_IMP_XML_ELEMENTS_PKG';

17: -- End of Comments
18: -- ===============================================================
19:
20:
21: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_IMP_XML_ELEMENTS_PKG';
22: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amslxelb.pls';
23:
24:
25: ----------------------------------------------------------

Line 73: INSERT INTO AMS_IMP_XML_ELEMENTS(

69:
70: px_object_version_number := 1;
71:
72:
73: INSERT INTO AMS_IMP_XML_ELEMENTS(
74: imp_xml_element_id,
75: last_updated_by,
76: object_version_number,
77: created_by,

Line 146: Update AMS_IMP_XML_ELEMENTS

142: p_error_text VARCHAR2)
143:
144: IS
145: BEGIN
146: Update AMS_IMP_XML_ELEMENTS
147: SET
148: imp_xml_element_id = DECODE( p_imp_xml_element_id, FND_API.g_miss_num, imp_xml_element_id, p_imp_xml_element_id),
149: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
150: object_version_number = object_version_number + 1, --DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),

Line 193: DELETE FROM AMS_IMP_XML_ELEMENTS

189: PROCEDURE Delete_Row(
190: p_IMP_XML_ELEMENT_ID NUMBER)
191: IS
192: BEGIN
193: DELETE FROM AMS_IMP_XML_ELEMENTS
194: WHERE IMP_XML_ELEMENT_ID = p_IMP_XML_ELEMENT_ID;
195: If (SQL%NOTFOUND) then
196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
197: End If;

Line 239: FROM AMS_IMP_XML_ELEMENTS

235:
236: IS
237: CURSOR C IS
238: SELECT *
239: FROM AMS_IMP_XML_ELEMENTS
240: WHERE IMP_XML_ELEMENT_ID = p_IMP_XML_ELEMENT_ID
241: FOR UPDATE of IMP_XML_ELEMENT_ID NOWAIT;
242: Recinfo C%ROWTYPE;
243: BEGIN

Line 307: END AMS_IMP_XML_ELEMENTS_PKG;

303: APP_EXCEPTION.RAISE_EXCEPTION;
304: END IF;
305: END Lock_Row;
306:
307: END AMS_IMP_XML_ELEMENTS_PKG;