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 977: DELETE FROM ahl_mel_cdl_mo_procedures

973: -- For U/D, verify mel_cdl_mo_procedures_id + ovn is correct
974: 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);
975:
976: -- Delete MandO procedures from the MO Procedure Table
977: DELETE FROM ahl_mel_cdl_mo_procedures
978: WHERE mel_cdl_mo_procedure_id = p_x_mo_procedures_tbl(l_rec_idx).mel_cdl_mo_procedure_id;
979:
980: END IF;
981: END LOOP;

Line 1068: ahl_mel_cdl_mo_procedures

1064: BEGIN
1065: SELECT 'X' INTO l_dummy_varchar FROM DUAL WHERE NOT EXISTS
1066: (SELECT 'x'
1067: FROM
1068: ahl_mel_cdl_mo_procedures
1069: WHERE
1070: ata_sequence_id = p_x_mo_procedures_tbl(l_rec_idx).ata_sequence_id
1071: AND mr_header_id = p_x_mo_procedures_tbl(l_rec_idx).mr_header_id);
1072:

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

1088: -- Default attributes for create
1089: p_x_mo_procedures_tbl(l_rec_idx).object_version_number := 1;
1090: IF (p_x_mo_procedures_tbl(l_rec_idx).mel_cdl_mo_procedure_id IS NULL)
1091: THEN
1092: SELECT ahl_mel_cdl_mo_procedures_s.NEXTVAL INTO p_x_mo_procedures_tbl(l_rec_idx).mel_cdl_mo_procedure_id FROM DUAL;
1093: END IF;
1094:
1095:
1096: -- Insert record into backend

Line 1097: INSERT INTO ahl_mel_cdl_mo_procedures

1093: END IF;
1094:
1095:
1096: -- Insert record into backend
1097: INSERT INTO ahl_mel_cdl_mo_procedures
1098: (
1099: MEL_CDL_MO_PROCEDURE_ID,
1100: OBJECT_VERSION_NUMBER,
1101: LAST_UPDATE_DATE,

Line 1703: FROM ahl_mel_cdl_mo_procedures

1699: p_mr_header_id number
1700: )
1701: IS
1702: SELECT ata_sequence_id
1703: FROM ahl_mel_cdl_mo_procedures
1704: WHERE mr_header_id = p_mr_header_id;
1705:
1706: l_ata_seq_id number;
1707:

Line 1750: INSERT INTO ahl_mel_cdl_mo_procedures

1746: FETCH get_all_ata_for_mo_pro INTO l_ata_seq_id;
1747: EXIT WHEN get_all_ata_for_mo_pro%NOTFOUND;
1748:
1749: -- Create association of such ATA sequences with the new revision of the M and O Procedure
1750: INSERT INTO ahl_mel_cdl_mo_procedures
1751: (
1752: MEL_CDL_MO_PROCEDURE_ID,
1753: OBJECT_VERSION_NUMBER,
1754: LAST_UPDATE_DATE,

Line 1780: ahl_mel_cdl_mo_procedures_s.nextval,

1776: ATTRIBUTE15
1777: )
1778: VALUES
1779: (
1780: ahl_mel_cdl_mo_procedures_s.nextval,
1781: 1,
1782: sysdate,
1783: fnd_global.user_id,
1784: sysdate,

Line 2076: FROM ahl_mel_cdl_mo_procedures

2072:
2073: CURSOR check_exists
2074: IS
2075: SELECT object_version_number
2076: FROM ahl_mel_cdl_mo_procedures
2077: WHERE mel_cdl_mo_procedure_id = p_mo_procedure_id;
2078:
2079: l_ovn NUMBER;
2080: