APPS.POA_EDW_RCV_TXNS_F_C dependencies on POA_EDW_RCV_TXNS_INC

Line 29: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_EDW_RCV_TXNS_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_RCV_TXNS_INC';
30: EXECUTE IMMEDIATE l_stmt;
31: END IF;
32:
33: END;

Line 44: INSERT INTO poa_edw_rcv_txns_inc(primary_key)

40:
41: PROCEDURE INSERT_MISSING_RATES
42: IS
43: BEGIN
44: INSERT INTO poa_edw_rcv_txns_inc(primary_key)
45: SELECT TO_NUMBER(SUBSTR(RCV_TXN_PK, 1, INSTR(RCV_TXN_PK, '-' )-1))
46: FROM POA_EDW_RCV_TXNS_FSTG
47: where COLLECTION_STATUS = 'RATE NOT AVAILABLE' OR
48: COLLECTION_STATUS = 'INVALID CURRENCY';

Line 57: ' rows into poa_edw_rcv_txns_inc table');

53: -- Generates "Warning" message in the Status column
54: -- of Concurrent Manager "Requests" table
55: edw_log.put_line(' ');
56: edw_log.put_line('INSERTING ' || to_char(sql%rowcount) ||
57: ' rows into poa_edw_rcv_txns_inc table');
58: END;
59:
60: -----------------------------------------------------------
61: -- PROCEDURE DELETE_STG_MISSING_RATES

Line 310: FROM poa_edw_rcv_txns_inc

306:
307: -- Cursor to delete duplicates
308: CURSOR Dup_Rec IS
309: SELECT primary_key
310: FROM poa_edw_rcv_txns_inc
311: ORDER BY primary_key
312: FOR UPDATE;
313:
314: v_prev_id NUMBER;

Line 327: DELETE FROM poa_edw_rcv_txns_inc

323: exit when Dup_Rec % NOTFOUND;
324:
325: -- Check if the PK already exists
326: IF (v_prev_id = v_cur_id) THEN
327: DELETE FROM poa_edw_rcv_txns_inc
328: WHERE CURRENT OF Dup_Rec;
329: ELSE
330: v_prev_id := v_cur_id;
331: END IF;

Line 358: select poa_edw_rcv_txns_inc_s.nextval into l_seq_id from dual;

354:
355: BEGIN
356:
357: p_count := 0;
358: select poa_edw_rcv_txns_inc_s.nextval into l_seq_id from dual;
359:
360: /** Update the seq_id for records that had missing currency rates in
361: the earlier PUSH. We need to repush these records again
362: **/

Line 364: UPDATE poa_edw_rcv_txns_inc

360: /** Update the seq_id for records that had missing currency rates in
361: the earlier PUSH. We need to repush these records again
362: **/
363:
364: UPDATE poa_edw_rcv_txns_inc
365: SET seq_id = l_seq_id
366: WHERE seq_id IS NULL;
367:
368: p_count := sql%rowcount;

Line 375: INSERT INTO poa_edw_rcv_txns_inc(primary_key, seq_id)

371: /* Currently, 2 tables are considered for last_update_date; we may
372: need to pick more/less tables for this (DEBUG).
373: Here RCV_TRANSACTIONS is the base table for the fact */
374:
375: INSERT INTO poa_edw_rcv_txns_inc(primary_key, seq_id)
376: SELECT rcv.transaction_id, l_seq_id
377: FROM RCV_SHIPMENT_LINES rsl,
378: RCV_TRANSACTIONS rcv
379: WHERE rcv.SHIPMENT_LINE_ID = rsl.SHIPMENT_LINE_ID