APPS.AMS_IMP_DOC_CON_PKG dependencies on AMS_IMP_DOC_CONTENT

Line 65: INSERT INTO ams_imp_doc_content (

61:
62: px_object_version_number := nvl(px_object_version_number, 1);
63:
64:
65: INSERT INTO ams_imp_doc_content (
66: imp_doc_content_id,
67: last_updated_by,
68: object_version_number,
69: created_by,

Line 118: Update ams_imp_doc_content

114: )
115:
116: IS
117: BEGIN
118: Update ams_imp_doc_content
119: SET
120: imp_doc_content_id = DECODE( p_imp_doc_content_id, null, imp_doc_content_id, FND_API.G_MISS_NUM, null, p_imp_doc_content_id),
121: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
122: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),

Line 159: DELETE FROM ams_imp_doc_content

155: p_imp_doc_content_id NUMBER,
156: p_object_version_number NUMBER)
157: IS
158: BEGIN
159: DELETE FROM ams_imp_doc_content
160: WHERE imp_doc_content_id = p_imp_doc_content_id
161: AND object_version_number = p_object_version_number;
162: If (SQL%NOTFOUND) then
163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 188: FROM ams_imp_doc_content

184: p_imp_doc_content_id NUMBER)
185: IS
186: CURSOR C IS
187: SELECT *
188: FROM ams_imp_doc_content
189: WHERE imp_doc_content_id = p_imp_doc_content_id
190: FOR UPDATE OF imp_doc_content_id NOWAIT;
191: Recinfo C%ROWTYPE;
192: BEGIN