[Home] [Help]
9: function check_no_loop(p_parent_assoc_id in number,
10: p_child_assoc_id in number) return boolean is
11: cursor C is
12: select child_association_id
13: from eam_suppression_relations
14: where parent_association_id = p_child_assoc_id;
15:
16: x_child_id number;
17: begin
49: p_child_assoc_id in number) return boolean is
50: x_num number;
51: begin
52: select count(*) into x_num
53: from eam_suppression_relations sup,
54: -- eam_pm_schedulings pms,
55: mtl_eam_asset_activities eaa
56: where sup.child_association_id = p_child_assoc_id
57: -- and sup.child_association_id = pms.activity_association_id
89: -- asset group
90: /* cursor asset_supp_csr is
91: select supp.parent_association_id, supp.child_association_id,
92: msn.inventory_item_id
93: from mtl_serial_numbers msn, eam_suppression_relations supp,
94: mtl_eam_asset_activities meaa
95: where msn.gen_object_id = p_maintenance_object_id and
96: supp.tmpl_flag = 'Y' and
97: meaa.tmpl_flag = 'Y' and
100:
101: cursor asset_supp_csr is
102: select supp.parent_association_id, supp.child_association_id,
103: cii.inventory_item_id
104: from csi_item_instances cii, eam_suppression_relations supp,
105: mtl_eam_asset_activities meaa
106: where cii.instance_id = p_maintenance_object_id and
107: supp.tmpl_flag = 'Y' and
108: meaa.tmpl_flag = 'Y' and
195:
196: l_parent_assoc_id number;
197: l_child_assoc_id number;
198: cursor supp_cursor is
199: select * from eam_suppression_relations
200: where parent_association_id = p_parent_association_id
201: and child_association_id = p_child_association_id;
202: supp_rec supp_cursor%ROWTYPE;
203: BEGIN
218: open supp_cursor;
219: loop
220: fetch supp_cursor into supp_rec;
221: exit when supp_cursor%NOTFOUND;
222: insert into eam_suppression_relations(
223: parent_association_id,
224: child_association_id,
225: description,
226: tmpl_flag,