[Home] [Help]
100: DECLARE
101:
102: CURSOR c_ams_deliverables (p_package_item_id igr_i_pkg_item.package_item_id%TYPE) IS
103: SELECT deliverable_id
104: FROM ams_deliverables_all_b
105: WHERE deliverable_id = p_package_item_id;
106: l_deliverable_id AMS_DELIVERABLES_ALL_B.deliverable_id%TYPE;
107: BEGIN
108:
102: CURSOR c_ams_deliverables (p_package_item_id igr_i_pkg_item.package_item_id%TYPE) IS
103: SELECT deliverable_id
104: FROM ams_deliverables_all_b
105: WHERE deliverable_id = p_package_item_id;
106: l_deliverable_id AMS_DELIVERABLES_ALL_B.deliverable_id%TYPE;
107: BEGIN
108:
109: IF (((old_references.package_item_id = new_references.package_item_id)) OR
110: ((new_references.package_item_id IS NULL))) THEN