APPS.AHL_MEL_CDL_ATA_SEQS_PVT dependencies on AHL_MEL_CDL_MO_PROCEDURES

Line 231: DELETE FROM ahl_mel_cdl_mo_procedures

227: WHERE ata_sequence_id = p_x_ata_sequences_tbl(l_rec_idx).mel_cdl_ata_sequence_id
228: OR related_ata_sequence_id = p_x_ata_sequences_tbl(l_rec_idx).mel_cdl_ata_sequence_id;
229:
230: -- Delete Inter-relationships associated with the ATA sequence
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

Line 971: DELETE FROM ahl_mel_cdl_mo_procedures

967: -- For U/D, verify mel_cdl_mo_procedures_id + ovn is correct
968: Check_MO_Proc_Exists(p_x_mo_procedures_tbl(l_rec_idx).mel_cdl_mo_procedure_id, p_x_mo_procedures_tbl(l_rec_idx).object_version_number);
969:
970: -- Delete MandO procedures from the MO Procedure Table
971: DELETE FROM ahl_mel_cdl_mo_procedures
972: WHERE mel_cdl_mo_procedure_id = p_x_mo_procedures_tbl(l_rec_idx).mel_cdl_mo_procedure_id;
973:
974: END IF;
975: END LOOP;

Line 1062: ahl_mel_cdl_mo_procedures

1058: BEGIN
1059: SELECT 'X' INTO l_dummy_varchar FROM DUAL WHERE NOT EXISTS
1060: (SELECT 'x'
1061: FROM
1062: ahl_mel_cdl_mo_procedures
1063: WHERE
1064: ata_sequence_id = p_x_mo_procedures_tbl(l_rec_idx).ata_sequence_id
1065: AND mr_header_id = p_x_mo_procedures_tbl(l_rec_idx).mr_header_id);
1066:

Line 1086: SELECT ahl_mel_cdl_mo_procedures_s.NEXTVAL INTO p_x_mo_procedures_tbl(l_rec_idx).mel_cdl_mo_procedure_id FROM DUAL;

1082: -- Default attributes for create
1083: p_x_mo_procedures_tbl(l_rec_idx).object_version_number := 1;
1084: IF (p_x_mo_procedures_tbl(l_rec_idx).mel_cdl_mo_procedure_id IS NULL)
1085: THEN
1086: SELECT ahl_mel_cdl_mo_procedures_s.NEXTVAL INTO p_x_mo_procedures_tbl(l_rec_idx).mel_cdl_mo_procedure_id FROM DUAL;
1087: END IF;
1088:
1089:
1090: -- Insert record into backend

Line 1091: INSERT INTO ahl_mel_cdl_mo_procedures

1087: END IF;
1088:
1089:
1090: -- Insert record into backend
1091: INSERT INTO ahl_mel_cdl_mo_procedures
1092: (
1093: MEL_CDL_MO_PROCEDURE_ID,
1094: OBJECT_VERSION_NUMBER,
1095: LAST_UPDATE_DATE,

Line 1697: FROM ahl_mel_cdl_mo_procedures

1693: p_mr_header_id number
1694: )
1695: IS
1696: SELECT ata_sequence_id
1697: FROM ahl_mel_cdl_mo_procedures
1698: WHERE mr_header_id = p_mr_header_id;
1699:
1700: l_ata_seq_id number;
1701:

Line 1744: INSERT INTO ahl_mel_cdl_mo_procedures

1740: FETCH get_all_ata_for_mo_pro INTO l_ata_seq_id;
1741: EXIT WHEN get_all_ata_for_mo_pro%NOTFOUND;
1742:
1743: -- Create association of such ATA sequences with the new revision of the M and O Procedure
1744: INSERT INTO ahl_mel_cdl_mo_procedures
1745: (
1746: MEL_CDL_MO_PROCEDURE_ID,
1747: OBJECT_VERSION_NUMBER,
1748: LAST_UPDATE_DATE,

Line 1774: ahl_mel_cdl_mo_procedures_s.nextval,

1770: ATTRIBUTE15
1771: )
1772: VALUES
1773: (
1774: ahl_mel_cdl_mo_procedures_s.nextval,
1775: 1,
1776: sysdate,
1777: fnd_global.user_id,
1778: sysdate,

Line 2070: FROM ahl_mel_cdl_mo_procedures

2066:
2067: CURSOR check_exists
2068: IS
2069: SELECT object_version_number
2070: FROM ahl_mel_cdl_mo_procedures
2071: WHERE mel_cdl_mo_procedure_id = p_mo_procedure_id;
2072:
2073: l_ovn NUMBER;
2074: