APPS.ENGPKIMP dependencies on EGO_GTN_ATTR_CHG_VL

Line 251: l_single_gdsn_item_pend_rec EGO_GTN_ATTR_CHG_VL%ROWTYPE;

247: l_multi_changes_count NUMBER;
248: l_inventory_item_id NUMBER;
249: l_org_id NUMBER;
250: l_single_gdsn_item_prod_rec EGO_ITEM_GTN_ATTRS_VL%ROWTYPE;
251: l_single_gdsn_item_pend_rec EGO_GTN_ATTR_CHG_VL%ROWTYPE;
252: l_multi_gdsn_item_prod_rec EGO_ITEM_GTN_ATTRS_VL%ROWTYPE;
253: l_multi_gdsn_item_pend_rec EGO_GTN_MUL_ATTR_CHG_VL%ROWTYPE;
254: abort_implementation exception;
255:

Line 264: SELECT count(*) INTO l_single_changes_count FROM ego_gtn_attr_chg_vl WHERE change_line_id = p_change_line_id AND implementation_date IS NULL;

260: l_single_changes_count := 0;
261: l_multi_changes_count := 0;
262:
263: -- First Check if there are any pending changes for gdsn single or multi row attrs done through the change order.
264: SELECT count(*) INTO l_single_changes_count FROM ego_gtn_attr_chg_vl WHERE change_line_id = p_change_line_id AND implementation_date IS NULL;
265: SELECT count(*) INTO l_multi_changes_count FROM ego_gtn_mul_attr_chg_vl WHERE change_line_id = p_change_line_id AND implementation_date IS NULL;
266: -- If there are no gdsn single or multi row attrs changes return
267: IF l_single_changes_count = 0 AND l_multi_changes_count = 0 THEN
268: x_can_implement_status := 'YES';

Line 280: SELECT * INTO l_single_gdsn_item_pend_rec FROM ego_gtn_attr_chg_vl WHERE change_line_id = p_change_line_id;

276:
277: -- If gdsn single row changes exists
278: IF l_single_changes_count > 0 THEN
279: -- Get the pending and production rows for comparision
280: SELECT * INTO l_single_gdsn_item_pend_rec FROM ego_gtn_attr_chg_vl WHERE change_line_id = p_change_line_id;
281: SELECT * INTO l_single_gdsn_item_prod_rec FROM ego_item_gtn_attrs_vl WHERE inventory_item_id = l_inventory_item_id AND organization_id = l_org_id;
282:
283: FOR single_attr_grps_cur IN cur_gdsn_singlerow_attr_grps
284: LOOP