APPS.AMS_IMP_DOC_CON_PVT dependencies on AMS_IMP_DOC_CONTENT

Line 89: SELECT ams_imp_doc_content_s.NEXTVAL

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

Line 94: FROM ams_imp_doc_content

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

Line 329: FROM ams_imp_doc_content

325:
326:
327: CURSOR c_get_imp_doc(imp_doc_content_id NUMBER) IS
328: SELECT *
329: FROM ams_imp_doc_content
330: WHERE imp_doc_content_id = p_imp_doc_rec.imp_doc_content_id;
331: -- Hint: Developer need to provide Where clause
332:
333:

Line 740: FROM ams_imp_doc_content

736: l_imp_document_id NUMBER;
737:
738: CURSOR c_imp_doc IS
739: SELECT imp_doc_content_id
740: FROM ams_imp_doc_content
741: WHERE imp_doc_content_id = p_imp_doccontent_id
742: AND object_version_number = p_object_version
743: FOR UPDATE NOWAIT;
744:

Line 879: 'ams_imp_doc_content',

875: BEGIN
876: x_return_status := FND_API.g_ret_sts_success;
877: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
878: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
879: 'ams_imp_doc_content',
880: 'imp_doc_content_id = ''' || p_imp_doc_rec.imp_doc_content_id ||''''
881: );
882: ELSE
883: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

Line 884: 'ams_imp_doc_content',

880: 'imp_doc_content_id = ''' || p_imp_doc_rec.imp_doc_content_id ||''''
881: );
882: ELSE
883: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
884: 'ams_imp_doc_content',
885: 'imp_doc_content_id = ''' || p_imp_doc_rec.imp_doc_content_id ||
886: ''' AND imp_doc_content_id <> ' || p_imp_doc_rec.imp_doc_content_id
887: );
888: END IF;

Line 1110: FROM ams_imp_doc_content

1106: l_return_status VARCHAR2(1);
1107:
1108: CURSOR c_complete IS
1109: SELECT *
1110: FROM ams_imp_doc_content
1111: WHERE imp_doc_content_id = p_imp_doc_rec.imp_doc_content_id;
1112: l_imp_doc_rec c_complete%ROWTYPE;
1113: BEGIN
1114: x_complete_rec := p_imp_doc_rec;