APPS.EGO_ITEMS_ATTRS_CHANGES_PKG dependencies on TAB

Line 423: l_delete_table_b tab.tname%TYPE;

419: l_api_version NUMBER;
420: l_api_name VARCHAR2(50);
421:
422: l_object_row FND_OBJECTS%ROWTYPE;
423: l_delete_table_b tab.tname%TYPE;
424: l_delete_table_tl tab.tname%TYPE;
425:
426: l_dynamic_sql VARCHAR2(4000);
427: l_dynamic_sql_b VARCHAR2(4000);

Line 424: l_delete_table_tl tab.tname%TYPE;

420: l_api_name VARCHAR2(50);
421:
422: l_object_row FND_OBJECTS%ROWTYPE;
423: l_delete_table_b tab.tname%TYPE;
424: l_delete_table_tl tab.tname%TYPE;
425:
426: l_dynamic_sql VARCHAR2(4000);
427: l_dynamic_sql_b VARCHAR2(4000);
428: l_dynamic_sql_tl VARCHAR2(4000);

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

Line 479: l_delete_table_tl := 'EGO_ITEMS_ATTRS_CHANGES_TL';

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
483: l_dynamic_sql := ' WHERE 1 = 1 ';

Line 517: -- assumed that the delete table column names are same as that primary column names.

513: p_instance_pk5_value IS NOT NULL
514: ) THEN
515: code_debug(' Binding Pk Values ');
516: --
517: -- assumed that the delete table column names are same as that primary column names.
518: --
519: IF p_instance_pk1_value IS NOT NULL THEN
520: l_dynamic_sql := l_dynamic_sql ||' AND '||l_object_row.pk1_column_name||' IS NULL';
521: ELSE

Line 554: l_dynamic_sql_tl := 'DELETE '||l_delete_table_tl||l_dynamic_sql;

550: END IF;
551: END IF;
552: END IF;
553:
554: l_dynamic_sql_tl := 'DELETE '||l_delete_table_tl||l_dynamic_sql;
555: code_debug(' Deleting from the TL table ');
556: EXECUTE IMMEDIATE l_dynamic_sql_tl;
557: l_dynamic_sql_b := 'DELETE '||l_delete_table_b||l_dynamic_sql;
558: code_debug(' Deleting from the base table ');

Line 555: code_debug(' Deleting from the TL table ');

551: END IF;
552: END IF;
553:
554: l_dynamic_sql_tl := 'DELETE '||l_delete_table_tl||l_dynamic_sql;
555: code_debug(' Deleting from the TL table ');
556: EXECUTE IMMEDIATE l_dynamic_sql_tl;
557: l_dynamic_sql_b := 'DELETE '||l_delete_table_b||l_dynamic_sql;
558: code_debug(' Deleting from the base table ');
559: EXECUTE IMMEDIATE l_dynamic_sql_b;

Line 557: l_dynamic_sql_b := 'DELETE '||l_delete_table_b||l_dynamic_sql;

553:
554: l_dynamic_sql_tl := 'DELETE '||l_delete_table_tl||l_dynamic_sql;
555: code_debug(' Deleting from the TL table ');
556: EXECUTE IMMEDIATE l_dynamic_sql_tl;
557: l_dynamic_sql_b := 'DELETE '||l_delete_table_b||l_dynamic_sql;
558: code_debug(' Deleting from the base table ');
559: EXECUTE IMMEDIATE l_dynamic_sql_b;
560: x_return_status := FND_API.G_RET_STS_SUCCESS;
561: EXCEPTION

Line 558: code_debug(' Deleting from the base table ');

554: l_dynamic_sql_tl := 'DELETE '||l_delete_table_tl||l_dynamic_sql;
555: code_debug(' Deleting from the TL table ');
556: EXECUTE IMMEDIATE l_dynamic_sql_tl;
557: l_dynamic_sql_b := 'DELETE '||l_delete_table_b||l_dynamic_sql;
558: code_debug(' Deleting from the base table ');
559: EXECUTE IMMEDIATE l_dynamic_sql_b;
560: x_return_status := FND_API.G_RET_STS_SUCCESS;
561: EXCEPTION
562: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN