APPS.EDW_TRD_PARTNER_M_C dependencies on EDW_PO_VENDOR_HIERARCHIES

Line 18: * This procedure will populate the EDW_PO_VENDOR_HIERARCHIES table *

14: p_to_date IN DATE) IS
15:
16: /**********************************************************************
17: * *
18: * This procedure will populate the EDW_PO_VENDOR_HIERARCHIES table *
19: * *
20: * Author: tom.olick Date: April 3, 2002 *
21: * *
22: **********************************************************************/

Line 45: g_stmt := 'TRUNCATE TABLE ' || g_schema || '.EDW_PO_VENDOR_HIERARCHIES';

41:
42: edw_log.put_line(' ');
43: edw_log.put_line('Truncating Vendor Hierarchies table...');
44:
45: g_stmt := 'TRUNCATE TABLE ' || g_schema || '.EDW_PO_VENDOR_HIERARCHIES';
46: EXECUTE IMMEDIATE g_stmt;
47:
48: edw_log.put_line(' ');
49: edw_log.put_line('Populating Vendor Hierachies table...');

Line 53: Insert Into EDW_PO_VENDOR_HIERARCHIES (

49: edw_log.put_line('Populating Vendor Hierachies table...');
50:
51: l_temp_date := sysdate;
52:
53: Insert Into EDW_PO_VENDOR_HIERARCHIES (
54: hierarchy_level,
55: last_update_date,
56: vendor_id,
57: parent_vendor_id)

Line 75: ' rows into the HIERARCHY table: EDW_PO_VENDOR_HIERARCHIES');

71: l_rows_inserted := sql%rowcount;
72: l_duration := sysdate - l_temp_date;
73:
74: edw_log.put_line('Inserted ' || to_char(nvl(l_rows_inserted, 0))||
75: ' rows into the HIERARCHY table: EDW_PO_VENDOR_HIERARCHIES');
76: edw_log.put_line('Process Time: ' || edw_log.duration(l_duration));
77: edw_log.put_line(' ');
78:
79: Exception When others then

Line 127: FROM EDW_PO_VENDOR_HIERARCHIES_V

123: v_hierarchyTable t_hierarchyTable;
124:
125: CURSOR h4_cur IS
126: SELECT hierarchy_level, vendor_id, parent_vendor_id
127: FROM EDW_PO_VENDOR_HIERARCHIES_V
128: WHERE hierarchy_level >= 4
129: AND last_update_date between p_from_date and p_to_date
130: ORDER BY hierarchy_level;
131: