APPS.POA_EDW_PO_DIST_F_C dependencies on POA_EDW_PO_DIST_INC

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

25:
26: BEGIN
27:
28: IF (FND_INSTALLATION.GET_APP_INFO('POA', l_status, l_industry, l_poa_schema)) THEN
29: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema ||'.POA_EDW_PO_DIST_INC';
30: EXECUTE IMMEDIATE l_stmt;
31: END IF;
32:
33: END;

Line 44: DELETE from poa_edw_po_dist_inc

40: IS
41:
42: BEGIN
43:
44: DELETE from poa_edw_po_dist_inc
45: WHERE batch_id <> 0;
46:
47: END;
48:

Line 57: INSERT INTO poa_edw_po_dist_inc(primary_key,batch_id)

53:
54: PROCEDURE INSERT_MISSING_RATES
55: IS
56: BEGIN
57: INSERT INTO poa_edw_po_dist_inc(primary_key,batch_id)
58: SELECT DESTRIBUTION_ID,0
59: FROM POA_EDW_PO_DIST_FSTG fstg
60: WHERE fstg.COLLECTION_STATUS = 'RATE NOT AVAILABLE'
61: OR fstg.COLLECTION_STATUS = 'INVALID CURRENCY';

Line 71: ' rows into poa_edw_po_dist_inc table');

67: -- Generates "Warning" message in the Status column
68: -- of Concurrent Manager "Requests" table
69: edw_log.put_line(' ');
70: edw_log.put_line('INSERTING ' || to_char(sql%rowcount) ||
71: ' rows into poa_edw_po_dist_inc table');
72: END;
73:
74: -----------------------------------------------------------
75: -- PROCEDURE DELETE_STG_MISSING_RATES

Line 155: UPDATE poa_edw_po_dist_inc

151: -- This is used to replace the API calls "POA_EDW_SPEND_PKG.get_check_cut_date" and
152: -- "POA_EDW_SPEND_PKG.get_invoice_received_date" for performance improvement.
153: --
154:
155: UPDATE poa_edw_po_dist_inc
156: SET (check_cut_date, invoice_received_date) =
157: (SELECT min(ack.check_date), min(ain.invoice_received_date)
158: FROM ap_invoice_distributions_all aid,
159: ap_invoice_payments_all aip,

Line 506: FROM poa_edw_po_dist_inc

502:
503: -- Cursor to delete duplicates
504: CURSOR Dup_Rec IS
505: SELECT primary_key
506: FROM poa_edw_po_dist_inc
507: ORDER BY primary_key
508: FOR UPDATE;
509:
510: v_prev_id NUMBER;

Line 523: DELETE FROM poa_edw_po_dist_inc

519: exit when Dup_Rec % NOTFOUND;
520:
521: -- Check if the PK already exists
522: IF (v_prev_id = v_cur_id) THEN
523: DELETE FROM poa_edw_po_dist_inc
524: WHERE CURRENT OF Dup_Rec;
525: ELSE
526: v_prev_id := v_cur_id;
527: END IF;

Line 598: select poa_edw_po_dist_inc_s.nextval into l_seq_id from dual;

594:
595: BEGIN
596:
597: p_count := 0;
598: select poa_edw_po_dist_inc_s.nextval into l_seq_id from dual;
599:
600: /** Update the seq_id for records that had missing currency rates in
601: the earlier PUSH. We need to repush these records again
602: **/

Line 604: UPDATE poa_edw_po_dist_inc

600: /** Update the seq_id for records that had missing currency rates in
601: the earlier PUSH. We need to repush these records again
602: **/
603:
604: UPDATE poa_edw_po_dist_inc
605: SET seq_id = l_seq_id
606: WHERE seq_id IS NULL;
607:
608: p_count := sql%rowcount;

Line 617: INSERT into poa_edw_po_dist_inc(primary_key, seq_id, batch_id)

613: fetch v_changed_rows bulk collect into
614: l_primary_key, l_batch_id limit l_batch_size;
615: l_count := l_primary_key.count;
616: forall i in 1..l_count
617: INSERT into poa_edw_po_dist_inc(primary_key, seq_id, batch_id)
618: values(l_primary_key(i), l_seq_id, l_batch_id(i));
619: p_count := p_count + l_count;
620: EXIT WHEN l_count < l_batch_size;
621: end loop;

Line 626: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_poa_schema, TABNAME => 'POA_EDW_PO_DIST_INC') ;

622: close v_changed_rows;
623:
624: COMMIT;
625: IF (FND_INSTALLATION.GET_APP_INFO('POA', l_status, l_industry, l_poa_schema)) THEN
626: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_poa_schema, TABNAME => 'POA_EDW_PO_DIST_INC') ;
627: END IF;
628:
629: RETURN(l_seq_id);
630: