APPS.AMS_IS_LINE_PVT dependencies on AMS_IMP_SOURCE_LINES

Line 50: SELECT AMS_IMP_SOURCE_LINES_s.NEXTVAL

46: l_IMPORT_SOURCE_LINE_ID NUMBER;
47: l_dummy NUMBER;
48:
49: CURSOR c_id IS
50: SELECT AMS_IMP_SOURCE_LINES_s.NEXTVAL
51: FROM dual;
52:
53: CURSOR c_id_exists (l_id IN NUMBER) IS
54: SELECT 1

Line 55: FROM AMS_IMP_SOURCE_LINES

51: FROM dual;
52:
53: CURSOR c_id_exists (l_id IN NUMBER) IS
54: SELECT 1
55: FROM AMS_IMP_SOURCE_LINES
56: WHERE IMPORT_SOURCE_LINE_ID = l_id;
57:
58: BEGIN
59: -- Standard Start of API savepoint

Line 143: -- Invoke table handler(AMS_IMP_SOURCE_LINES_PKG.Insert_Row)

139:
140: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
141: END IF;
142:
143: -- Invoke table handler(AMS_IMP_SOURCE_LINES_PKG.Insert_Row)
144: AMS_IMP_SOURCE_LINES_PKG.Insert_Row(
145: px_import_source_line_id => l_import_source_line_id,
146: px_object_version_number => l_object_version_number,
147: p_last_update_date => SYSDATE,

Line 144: AMS_IMP_SOURCE_LINES_PKG.Insert_Row(

140: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
141: END IF;
142:
143: -- Invoke table handler(AMS_IMP_SOURCE_LINES_PKG.Insert_Row)
144: AMS_IMP_SOURCE_LINES_PKG.Insert_Row(
145: px_import_source_line_id => l_import_source_line_id,
146: px_object_version_number => l_object_version_number,
147: p_last_update_date => SYSDATE,
148: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 527: FROM AMS_IMP_SOURCE_LINES

523: IS
524:
525: CURSOR c_get_is_line(import_source_line_id NUMBER) IS
526: SELECT *
527: FROM AMS_IMP_SOURCE_LINES
528: where import_source_line_id=p_is_line_rec.import_source_line_id;
529:
530: CURSOR c_get_batch_id IS
531: SELECT AS_IMPORT_INTERFACE_S.NEXTVAL

Line 654: -- Invoke table handler(AMS_IMP_SOURCE_LINES_PKG.Update_Row)

650: END IF;
651:
652:
653:
654: -- Invoke table handler(AMS_IMP_SOURCE_LINES_PKG.Update_Row)
655: AMS_IMP_SOURCE_LINES_PKG.Update_Row(
656: p_import_source_line_id => p_is_line_rec.import_source_line_id,
657: p_object_version_number => p_is_line_rec.object_version_number,
658: p_last_update_date => SYSDATE,

Line 655: AMS_IMP_SOURCE_LINES_PKG.Update_Row(

651:
652:
653:
654: -- Invoke table handler(AMS_IMP_SOURCE_LINES_PKG.Update_Row)
655: AMS_IMP_SOURCE_LINES_PKG.Update_Row(
656: p_import_source_line_id => p_is_line_rec.import_source_line_id,
657: p_object_version_number => p_is_line_rec.object_version_number,
658: p_last_update_date => SYSDATE,
659: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 1103: -- Invoke table handler(AMS_IMP_SOURCE_LINES_PKG.Delete_Row)

1099:
1100: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
1101: END IF;
1102:
1103: -- Invoke table handler(AMS_IMP_SOURCE_LINES_PKG.Delete_Row)
1104: AMS_IMP_SOURCE_LINES_PKG.Delete_Row(
1105: p_IMPORT_SOURCE_LINE_ID => p_IMPORT_SOURCE_LINE_ID);
1106: --
1107: -- End of API body

Line 1104: AMS_IMP_SOURCE_LINES_PKG.Delete_Row(

1100: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
1101: END IF;
1102:
1103: -- Invoke table handler(AMS_IMP_SOURCE_LINES_PKG.Delete_Row)
1104: AMS_IMP_SOURCE_LINES_PKG.Delete_Row(
1105: p_IMPORT_SOURCE_LINE_ID => p_IMPORT_SOURCE_LINE_ID);
1106: --
1107: -- End of API body
1108: --

Line 1192: FROM AMS_IMP_SOURCE_LINES

1188: l_IMPORT_SOURCE_LINE_ID NUMBER;
1189:
1190: CURSOR c_Is_Line IS
1191: SELECT IMPORT_SOURCE_LINE_ID
1192: FROM AMS_IMP_SOURCE_LINES
1193: WHERE IMPORT_SOURCE_LINE_ID = p_IMPORT_SOURCE_LINE_ID
1194: AND object_version_number = p_object_version
1195: FOR UPDATE NOWAIT;
1196:

Line 1311: 'AMS_IMP_SOURCE_LINES',

1307: BEGIN
1308: x_return_status := FND_API.g_ret_sts_success;
1309: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1310: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1311: 'AMS_IMP_SOURCE_LINES',
1312: 'IMPORT_SOURCE_LINE_ID = ''' || p_is_line_rec.IMPORT_SOURCE_LINE_ID ||''''
1313: );
1314: ELSE
1315: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

Line 1316: 'AMS_IMP_SOURCE_LINES',

1312: 'IMPORT_SOURCE_LINE_ID = ''' || p_is_line_rec.IMPORT_SOURCE_LINE_ID ||''''
1313: );
1314: ELSE
1315: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1316: 'AMS_IMP_SOURCE_LINES',
1317: 'IMPORT_SOURCE_LINE_ID = ''' || p_is_line_rec.IMPORT_SOURCE_LINE_ID ||
1318: ''' AND IMPORT_SOURCE_LINE_ID <> ' || p_is_line_rec.IMPORT_SOURCE_LINE_ID
1319: );
1320: END IF;

Line 1536: FROM ams_imp_source_lines

1532: l_return_status VARCHAR2(1);
1533:
1534: CURSOR c_complete IS
1535: SELECT *
1536: FROM ams_imp_source_lines
1537: WHERE import_source_line_id = p_is_line_rec.import_source_line_id;
1538: l_is_line_rec c_complete%ROWTYPE;
1539: BEGIN
1540: x_complete_rec := p_is_line_rec;