APPS.AHL_MEL_CDL_ATA_SEQS_PVT dependencies on AHL_MEL_CDL_ATA_SEQUENCES

Line 50: ahl_mel_cdl_ata_sequences

46: )
47: IS
48: SELECT 'X'
49: FROM
50: ahl_mel_cdl_ata_sequences
51: WHERE
52: mel_cdl_ata_sequence_id = ata_seq_id;
53:
54: -- This cursor is used to check if the MEL/CDL status is not in Draft and Approve Rejected

Line 63: ahl_mel_cdl_ata_sequences ata,

59: IS
60: SELECT
61: hdr.status_code
62: FROM
63: ahl_mel_cdl_ata_sequences ata,
64: ahl_mel_cdl_headers hdr
65: WHERE
66: mel_cdl_ata_sequence_id = ata_seq_id
67: AND ata.mel_cdl_header_id = hdr. mel_cdl_header_id;

Line 105: FROM ahl_mel_cdl_ata_sequences

101: p_ata_sequence_id number
102: )
103: IS
104: SELECT ata_code
105: FROM ahl_mel_cdl_ata_sequences
106: WHERE mel_cdl_ata_sequence_id = p_ata_sequence_id;
107:
108: l_ata_code VARCHAR2(30);
109:

Line 117: FROM ahl_mel_cdl_ata_sequences

113: p_ata_code varchar2
114: )
115: IS
116: SELECT 'x'
117: FROM ahl_mel_cdl_ata_sequences
118: WHERE mel_cdl_header_id = p_mel_cdl_header_id AND
119: ata_code = p_ata_code;
120:
121: CURSOR get_ata_notes

Line 235: DELETE FROM ahl_mel_cdl_ata_sequences

231: DELETE FROM ahl_mel_cdl_mo_procedures
232: WHERE ata_sequence_id = p_x_ata_sequences_tbl(l_rec_idx).mel_cdl_ata_sequence_id;
233:
234: -- Delete the ATA sequence itself
235: DELETE FROM ahl_mel_cdl_ata_sequences
236: WHERE mel_cdl_ata_sequence_id = p_x_ata_sequences_tbl(l_rec_idx).mel_cdl_ata_sequence_id;
237:
238: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
239: THEN

Line 344: UPDATE ahl_mel_cdl_ata_sequences

340: -- Default attributes for update
341: p_x_ata_sequences_tbl(l_rec_idx).object_version_number := p_x_ata_sequences_tbl(l_rec_idx).object_version_number + 1;
342:
343: -- Update record in backend
344: UPDATE ahl_mel_cdl_ata_sequences
345: SET OBJECT_VERSION_NUMBER = p_x_ata_sequences_tbl(l_rec_idx).object_version_number,
346: LAST_UPDATE_DATE = sysdate,
347: LAST_UPDATED_BY = fnd_global.user_id,
348: LAST_UPDATE_LOGIN = fnd_global.login_id,

Line 605: SELECT ahl_mel_cdl_ata_sequences_s.NEXTVAL INTO p_x_ata_sequences_tbl(l_rec_idx).mel_cdl_ata_sequence_id FROM DUAL;

601: -- Default attributes for create
602: p_x_ata_sequences_tbl(l_rec_idx).object_version_number := 1;
603: IF (p_x_ata_sequences_tbl(l_rec_idx).mel_cdl_ata_sequence_id IS NULL)
604: THEN
605: SELECT ahl_mel_cdl_ata_sequences_s.NEXTVAL INTO p_x_ata_sequences_tbl(l_rec_idx).mel_cdl_ata_sequence_id FROM DUAL;
606: END IF;
607:
608: -- Insert record into backend
609: INSERT INTO ahl_mel_cdl_ata_sequences

Line 609: INSERT INTO ahl_mel_cdl_ata_sequences

605: SELECT ahl_mel_cdl_ata_sequences_s.NEXTVAL INTO p_x_ata_sequences_tbl(l_rec_idx).mel_cdl_ata_sequence_id FROM DUAL;
606: END IF;
607:
608: -- Insert record into backend
609: INSERT INTO ahl_mel_cdl_ata_sequences
610: (
611: MEL_CDL_ATA_SEQUENCE_ID,
612: OBJECT_VERSION_NUMBER,
613: LAST_UPDATE_DATE,

Line 1283: ahl_mel_cdl_ata_sequences_v a,

1279: )
1280: IS
1281: SELECT 'x'
1282: FROM
1283: ahl_mel_cdl_ata_sequences_v a,
1284: ahl_mel_cdl_ata_sequences_v b
1285: WHERE
1286: a.mel_cdl_ata_sequence_id= p_ata_seq_id
1287: AND b.mel_cdl_ata_sequence_id = p_rel_ata_seq_id

Line 1284: ahl_mel_cdl_ata_sequences_v b

1280: IS
1281: SELECT 'x'
1282: FROM
1283: ahl_mel_cdl_ata_sequences_v a,
1284: ahl_mel_cdl_ata_sequences_v b
1285: WHERE
1286: a.mel_cdl_ata_sequence_id= p_ata_seq_id
1287: AND b.mel_cdl_ata_sequence_id = p_rel_ata_seq_id
1288: AND a.mel_cdl_header_id = b.mel_cdl_header_id;

Line 1453: ahl_mel_cdl_ata_sequences_v

1449:
1450: --Get the ATA Meaning for ATA Sequence Id
1451: SELECT ata_meaning INTO l_ata_mng
1452: FROM
1453: ahl_mel_cdl_ata_sequences_v
1454: WHERE
1455: mel_cdl_ata_sequence_id = p_x_ata_relations_tbl(l_rec_idx).ata_sequence_id;
1456:
1457: --Get the ATA Meaning for Related ATA Sequence Id

Line 1460: ahl_mel_cdl_ata_sequences_v

1456:
1457: --Get the ATA Meaning for Related ATA Sequence Id
1458: SELECT ata_meaning INTO l_reln_ata_mng
1459: FROM
1460: ahl_mel_cdl_ata_sequences_v
1461: WHERE
1462: mel_cdl_ata_sequence_id = p_x_ata_relations_tbl(l_rec_idx).related_ata_sequence_id;
1463:
1464: -- Check if the Relationship already Exists (ie, ata_sequence_id is associated to related_ata_sequence_id)

Line 1890: FROM ahl_mel_cdl_ata_sequences

1886:
1887: CURSOR check_exists
1888: IS
1889: SELECT object_version_number
1890: FROM ahl_mel_cdl_ata_sequences
1891: WHERE mel_cdl_ata_sequence_id = p_ata_sequence_id;
1892:
1893: l_ovn NUMBER;
1894:

Line 2010: FROM ahl_mel_cdl_headers hdr, ahl_mel_cdl_ata_sequences ata

2006:
2007: CURSOR get_ata_mel_cdl_status
2008: IS
2009: SELECT hdr.status_code, hdr.mel_cdl_header_id
2010: FROM ahl_mel_cdl_headers hdr, ahl_mel_cdl_ata_sequences ata
2011: WHERE hdr.mel_cdl_header_id = ata.mel_cdl_header_id AND
2012: ata.mel_cdl_ata_sequence_id = p_ata_sequence_id;
2013:
2014: CURSOR get_mel_cdl_status