APPS.EGO_ITEMS_ATTRS_CHANGES_PKG dependencies on EGO_ITEMS_ATTRS_CHANGES_B

Line 22: from EGO_ITEMS_ATTRS_CHANGES_B B

18: BEGIN
19: delete from EGO_ITEMS_ATTRS_CHANGES_TL T
20: where not exists
21: (select NULL
22: from EGO_ITEMS_ATTRS_CHANGES_B B
23: where B.EXTENSION_ID = T.EXTENSION_ID
24: and B.ACD_TYPE = T.ACD_TYPE
25: and B.CHANGE_LINE_ID = T.CHANGE_LINE_ID
26: );

Line 401: -- FUNCTION : Delete the pending changes from EGO_ITEMS_ATTRS_CHANGES_B

397: -- Start of Comments
398: -- API name : Deleting_Pending_Changes
399: -- TYPE : Public
400: -- Pre-reqs : None
401: -- FUNCTION : Delete the pending changes from EGO_ITEMS_ATTRS_CHANGES_B
402: --
403: -- Parameters:
404: -- IN : p_api_version NUMBER
405: -- : p_object_name VARCHAR2

Line 478: l_delete_table_b := 'EGO_ITEMS_ATTRS_CHANGES_B';

474: CLOSE get_obj_row;
475: END IF;
476:
477: IF l_object_row.obj_name IN ('EGO_ITEM', 'EGO_ITEM_REVISION') THEN
478: l_delete_table_b := 'EGO_ITEMS_ATTRS_CHANGES_B';
479: l_delete_table_tl := 'EGO_ITEMS_ATTRS_CHANGES_TL';
480: IF p_change_id IS NULL THEN
481: IF p_change_line_id IS NULL THEN
482: -- you will never come here