APPS.ENGPKIMP dependencies on EGO_GTN_ATTR_CHG_VL

Line 323: l_single_gdsn_item_pend_rec EGO_GTN_ATTR_CHG_VL%ROWTYPE;

319: l_multi_changes_count NUMBER;
320: l_inventory_item_id NUMBER;
321: l_org_id NUMBER;
322: l_single_gdsn_item_prod_rec EGO_ITEM_GTN_ATTRS_VL%ROWTYPE;
323: l_single_gdsn_item_pend_rec EGO_GTN_ATTR_CHG_VL%ROWTYPE;
324: l_multi_gdsn_item_prod_rec EGO_ITEM_GTN_ATTRS_VL%ROWTYPE;
325: l_multi_gdsn_item_pend_rec EGO_GTN_MUL_ATTR_CHG_VL%ROWTYPE;
326: abort_implementation exception;
327:

Line 336: 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;

332: l_single_changes_count := 0;
333: l_multi_changes_count := 0;
334:
335: -- First Check if there are any pending changes for gdsn single or multi row attrs done through the change order.
336: 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;
337: 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;
338: -- If there are no gdsn single or multi row attrs changes return
339: IF l_single_changes_count = 0 AND l_multi_changes_count = 0 THEN
340: x_can_implement_status := 'YES';

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

348:
349: -- If gdsn single row changes exists
350: IF l_single_changes_count > 0 THEN
351: -- Get the pending and production rows for comparision
352: SELECT * INTO l_single_gdsn_item_pend_rec FROM ego_gtn_attr_chg_vl WHERE change_line_id = p_change_line_id;
353: 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;
354:
355: FOR single_attr_grps_cur IN cur_gdsn_singlerow_attr_grps
356: LOOP