APPS.ENGPKIMP dependencies on EGO_GTN_MUL_ATTR_CHG_VL

Line 253: l_multi_gdsn_item_pend_rec EGO_GTN_MUL_ATTR_CHG_VL%ROWTYPE;

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:
256: CURSOR cur_gdsn_singlerow_attr_grps IS
257: 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 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;

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

Line 654: FROM ego_gtn_mul_attr_chg_vl

650:
651: -- Check if there are item GDSN Multirow attribute group changes
652: IF l_attribute_group_type = 'EGO_ITEM_GTIN_MULTI_ATTRS' THEN
653: SELECT count(*) INTO l_pending_changes_count
654: FROM ego_gtn_mul_attr_chg_vl
655: WHERE change_line_id = p_change_line_id
656: AND attr_group_id = l_current_attr_group_id
657: AND implementation_date IS NULL;
658: