APPS.POA_SAVINGS_MAIN dependencies on POA_EDW_PO_DIST_INC

Line 85: -- check if we need to populate the INC table poa_edw_po_dist_inc.

81: select sysdate into l_start_time from dual;
82: POA_LOG.debug_line('Populate_savings: entered');
83: POA_LOG.debug_line(' ');
84:
85: -- check if we need to populate the INC table poa_edw_po_dist_inc.
86: -- For EDW, we don't need to, since that is taken care in Push program.
87: -- For OLTP, we should.
88:
89: if p_populate_inc then

Line 92: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema ||'.POA_EDW_PO_DIST_INC';

88:
89: if p_populate_inc then
90:
91: IF (FND_INSTALLATION.GET_APP_INFO('POA',l_status,l_industry,l_poa_schema)) THEN
92: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema ||'.POA_EDW_PO_DIST_INC';
93: EXECUTE IMMEDIATE l_stmt;
94: END IF;
95: open v_changed_rows(p_start_date,p_end_date,l_batch_size);
96: loop

Line 102: INSERT INTO poa_edw_po_dist_inc (primary_key, seq_id,batch_id) values(l_primary_key(i),l_seq_id(i),l_batch_id(i));

98: fetch v_changed_rows bulk collect into
99: l_primary_key,l_seq_id,l_batch_id limit l_batch_size;
100: l_count := l_primary_key.count;
101: forall i in 1..l_count
102: INSERT INTO poa_edw_po_dist_inc (primary_key, seq_id,batch_id) values(l_primary_key(i),l_seq_id(i),l_batch_id(i));
103: EXIT WHEN l_count < l_batch_size;
104: end loop;
105: close v_changed_rows;
106: select sysdate into l_end_time from dual;

Line 126: select max(batch_id) into l_no_batch from poa_edw_po_dist_inc;

122: -- date and date of creation.
123:
124: x_progress := '020';
125:
126: select max(batch_id) into l_no_batch from poa_edw_po_dist_inc;
127:
128: SELECT sysdate INTO v_start_time from sys.dual;
129:
130: if (l_no_batch is NOT NULL) then