APPS.AMS_IMP_DOC_PVT dependencies on AMS_IMP_DOCUMENTS

Line 88: SELECT ams_imp_documents_s.NEXTVAL

84: l_imp_document_id NUMBER;
85: l_dummy NUMBER;
86:
87: CURSOR c_id IS
88: SELECT ams_imp_documents_s.NEXTVAL
89: FROM dual;
90:
91: CURSOR c_id_exists (l_id IN NUMBER) IS
92: SELECT 1

Line 93: FROM AMS_IMP_DOCUMENTS

89: FROM dual;
90:
91: CURSOR c_id_exists (l_id IN NUMBER) IS
92: SELECT 1
93: FROM AMS_IMP_DOCUMENTS
94: WHERE imp_document_id = l_id;
95:
96: BEGIN
97: -- Standard Start of API savepoint

Line 332: FROM AMS_IMP_DOCUMENTS

328:
329:
330: CURSOR c_get_imp_doc(imp_document_id NUMBER) IS
331: SELECT *
332: FROM AMS_IMP_DOCUMENTS
333: WHERE imp_document_id = p_imp_doc_rec.imp_document_id;
334: -- Hint: Developer need to provide Where clause
335:
336:

Line 746: FROM ams_imp_documents

742: l_imp_document_id NUMBER;
743:
744: CURSOR c_imp_doc IS
745: SELECT imp_document_id
746: FROM ams_imp_documents
747: WHERE imp_document_id = p_imp_document_id
748: AND object_version_number = p_object_version
749: FOR UPDATE NOWAIT;
750:

Line 885: 'ams_imp_documents',

881: BEGIN
882: x_return_status := FND_API.g_ret_sts_success;
883: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
884: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
885: 'ams_imp_documents',
886: 'imp_document_id = ''' || p_imp_doc_rec.imp_document_id ||''''
887: );
888: ELSE
889: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

Line 890: 'ams_imp_documents',

886: 'imp_document_id = ''' || p_imp_doc_rec.imp_document_id ||''''
887: );
888: ELSE
889: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
890: 'ams_imp_documents',
891: 'imp_document_id = ''' || p_imp_doc_rec.imp_document_id ||
892: ''' AND imp_document_id <> ' || p_imp_doc_rec.imp_document_id
893: );
894: END IF;

Line 1116: FROM ams_imp_documents

1112: l_return_status VARCHAR2(1);
1113:
1114: CURSOR c_complete IS
1115: SELECT *
1116: FROM ams_imp_documents
1117: WHERE imp_document_id = p_imp_doc_rec.imp_document_id;
1118: l_imp_doc_rec c_complete%ROWTYPE;
1119: BEGIN
1120: x_complete_rec := p_imp_doc_rec;