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 347: UPDATE ahl_mel_cdl_ata_sequences

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

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

607: -- Default attributes for create
608: p_x_ata_sequences_tbl(l_rec_idx).object_version_number := 1;
609: IF (p_x_ata_sequences_tbl(l_rec_idx).mel_cdl_ata_sequence_id IS NULL)
610: THEN
611: SELECT ahl_mel_cdl_ata_sequences_s.NEXTVAL INTO p_x_ata_sequences_tbl(l_rec_idx).mel_cdl_ata_sequence_id FROM DUAL;
612: END IF;
613:
614: -- Insert record into backend
615: INSERT INTO ahl_mel_cdl_ata_sequences

Line 615: INSERT INTO ahl_mel_cdl_ata_sequences

611: SELECT ahl_mel_cdl_ata_sequences_s.NEXTVAL INTO p_x_ata_sequences_tbl(l_rec_idx).mel_cdl_ata_sequence_id FROM DUAL;
612: END IF;
613:
614: -- Insert record into backend
615: INSERT INTO ahl_mel_cdl_ata_sequences
616: (
617: MEL_CDL_ATA_SEQUENCE_ID,
618: OBJECT_VERSION_NUMBER,
619: LAST_UPDATE_DATE,

Line 1289: ahl_mel_cdl_ata_sequences_v a,

1285: )
1286: IS
1287: SELECT 'x'
1288: FROM
1289: ahl_mel_cdl_ata_sequences_v a,
1290: ahl_mel_cdl_ata_sequences_v b
1291: WHERE
1292: a.mel_cdl_ata_sequence_id= p_ata_seq_id
1293: AND b.mel_cdl_ata_sequence_id = p_rel_ata_seq_id

Line 1290: ahl_mel_cdl_ata_sequences_v b

1286: IS
1287: SELECT 'x'
1288: FROM
1289: ahl_mel_cdl_ata_sequences_v a,
1290: ahl_mel_cdl_ata_sequences_v b
1291: WHERE
1292: a.mel_cdl_ata_sequence_id= p_ata_seq_id
1293: AND b.mel_cdl_ata_sequence_id = p_rel_ata_seq_id
1294: AND a.mel_cdl_header_id = b.mel_cdl_header_id;

Line 1459: ahl_mel_cdl_ata_sequences_v

1455:
1456: --Get the ATA Meaning for ATA Sequence Id
1457: SELECT ata_meaning INTO l_ata_mng
1458: FROM
1459: ahl_mel_cdl_ata_sequences_v
1460: WHERE
1461: mel_cdl_ata_sequence_id = p_x_ata_relations_tbl(l_rec_idx).ata_sequence_id;
1462:
1463: --Get the ATA Meaning for Related ATA Sequence Id

Line 1466: ahl_mel_cdl_ata_sequences_v

1462:
1463: --Get the ATA Meaning for Related ATA Sequence Id
1464: SELECT ata_meaning INTO l_reln_ata_mng
1465: FROM
1466: ahl_mel_cdl_ata_sequences_v
1467: WHERE
1468: mel_cdl_ata_sequence_id = p_x_ata_relations_tbl(l_rec_idx).related_ata_sequence_id;
1469:
1470: -- Check if the Relationship already Exists (ie, ata_sequence_id is associated to related_ata_sequence_id)

Line 1896: FROM ahl_mel_cdl_ata_sequences

1892:
1893: CURSOR check_exists
1894: IS
1895: SELECT object_version_number
1896: FROM ahl_mel_cdl_ata_sequences
1897: WHERE mel_cdl_ata_sequence_id = p_ata_sequence_id;
1898:
1899: l_ovn NUMBER;
1900:

Line 2016: FROM ahl_mel_cdl_headers hdr, ahl_mel_cdl_ata_sequences ata

2012:
2013: CURSOR get_ata_mel_cdl_status
2014: IS
2015: SELECT hdr.status_code, hdr.mel_cdl_header_id
2016: FROM ahl_mel_cdl_headers hdr, ahl_mel_cdl_ata_sequences ata
2017: WHERE hdr.mel_cdl_header_id = ata.mel_cdl_header_id AND
2018: ata.mel_cdl_ata_sequence_id = p_ata_sequence_id;
2019:
2020: CURSOR get_mel_cdl_status