APPS.ENGPKIMP dependencies on EGO_GTN_MUL_ATTR_CHG_VL

Line 325: l_multi_gdsn_item_pend_rec EGO_GTN_MUL_ATTR_CHG_VL%ROWTYPE;

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:
328: CURSOR cur_gdsn_singlerow_attr_grps IS
329: SELECT attr_group_id, attr_group_name FROM ego_attr_groups_v WHERE attr_group_type='EGO_ITEM_GTIN_ATTRS' AND application_id=431;

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

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';
341: RETURN;

Line 726: FROM ego_gtn_mul_attr_chg_vl

722:
723: -- Check if there are item GDSN Multirow attribute group changes
724: IF l_attribute_group_type = 'EGO_ITEM_GTIN_MULTI_ATTRS' THEN
725: SELECT count(*) INTO l_pending_changes_count
726: FROM ego_gtn_mul_attr_chg_vl
727: WHERE change_line_id = p_change_line_id
728: AND attr_group_id = l_current_attr_group_id
729: AND implementation_date IS NULL;
730: