APPS.AHL_MEL_CDL_APPROVALS_PVT dependencies on AHL_MEL_CDL_HEADERS

Line 19: FROM ahl_mel_cdl_headers hdr, ahl_pc_nodes_b pcn

15: hdr.revision,
16: hdr.version_number,
17: hdr.object_version_number,
18: hdr.revision_date
19: FROM ahl_mel_cdl_headers hdr, ahl_pc_nodes_b pcn
20: WHERE pcn.pc_node_id = hdr.pc_node_id AND
21: hdr.mel_cdl_header_id = p_mel_cdl_header_id;
22:
23: -- get mel/cdl details for a NR.

Line 1747: FROM ahl_mel_cdl_headers

1743: )
1744: IS
1745: SELECT mel_cdl_header_id,
1746: revision_date
1747: FROM ahl_mel_cdl_headers
1748: WHERE pc_node_id = p_pc_node_id AND
1749: mel_cdl_type_code = p_mel_cdl_type AND
1750: version_number = p_version_number - 1;
1751:

Line 1826: UPDATE ahl_mel_cdl_headers

1822: aname => 'UPDATE_GEN_STATUS'
1823: );
1824:
1825: -- Complete the current revision and expire the old one...
1826: UPDATE ahl_mel_cdl_headers
1827: SET status_code = l_next_status,
1828: object_version_number = l_object_ovn + 1,
1829: last_update_date = sysdate,
1830: last_updated_by = fnd_global.user_id,

Line 1849: UPDATE ahl_mel_cdl_headers

1845: l_prev_expired_date := l_prev_revision_date;
1846: END IF;
1847:
1848: -- Once the current revision of the MEL/CDL is complete, need to expire the earlier revision
1849: UPDATE ahl_mel_cdl_headers
1850: SET expired_date = l_prev_expired_date,
1851: object_version_number = object_version_number + 1,
1852: last_update_date = sysdate,
1853: last_updated_by = fnd_global.user_id,

Line 2031: UPDATE ahl_mel_cdl_headers

2027: itemkey => itemkey,
2028: aname => 'ORG_STATUS_ID'
2029: );
2030:
2031: UPDATE ahl_mel_cdl_headers
2032: SET status_code = l_next_status,
2033: object_version_number = l_object_ovn + 1,
2034: last_update_date = sysdate,
2035: last_updated_by = fnd_global.user_id,

Line 2165: ahl_mel_cdl_headers mch, ahl_pc_headers_b aph, ahl_pc_nodes_b apn,

2161: from cs_incidents_all_vl cs, cs_incident_types_vl cit,
2162: ahl_unit_effectivities_b ue, ahl_unit_deferrals_b udf,
2163: csi_item_instances csi, mtl_system_items_kfv mtl,
2164: ahl_mel_cdl_ata_sequences seq, ahl_repair_categories arc,
2165: ahl_mel_cdl_headers mch, ahl_pc_headers_b aph, ahl_pc_nodes_b apn,
2166: cs_incident_urgencies_vl ciu
2167: where udf.unit_effectivity_id = ue.unit_effectivity_id
2168: and ue.cs_incident_id = cs.incident_id
2169: and cs.incident_type_id = cit.incident_type_id