APPS.POA_EDW_SUP_PERF_F_C dependencies on POA_EDW_SUP_PERF_INC

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

Line 44: INSERT INTO poa_edw_sup_perf_inc(primary_key)

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

Line 57: ' rows into poa_edw_sup_perf_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_sup_perf_inc table');
58: END;
59:
60: -----------------------------------------------------------
61: -- PROCEDURE DELETE_STG_MISSING_RATES

Line 535: FROM poa_edw_sup_perf_inc

531:
532: -- Cursor to delete duplicates
533: CURSOR Dup_Rec IS
534: SELECT primary_key
535: FROM poa_edw_sup_perf_inc
536: ORDER BY primary_key
537: FOR UPDATE;
538:
539: v_prev_id NUMBER;

Line 552: DELETE FROM poa_edw_sup_perf_inc

548: exit when Dup_Rec % NOTFOUND;
549:
550: -- Check if the PK already exists
551: IF (v_prev_id = v_cur_id) THEN
552: DELETE FROM poa_edw_sup_perf_inc
553: WHERE CURRENT OF Dup_Rec;
554: ELSE
555: v_prev_id := v_cur_id;
556: END IF;

Line 578: insert into poa_edw_sup_perf_inc(primary_key, seq_id)

574:
575: l_count NUMBER;
576: BEGIN
577:
578: insert into poa_edw_sup_perf_inc(primary_key, seq_id)
579: select rcv.po_line_location_id, p_seq_id
580: from rcv_transactions rcv, po_line_locations_all pll
581: where rcv.po_line_location_id = pll.line_location_id
582: and rcv.last_update_date between g_push_from_date and

Line 615: select poa_edw_sup_perf_inc_s.nextval into l_seq_id from dual;

611:
612: BEGIN
613:
614: p_count := 0;
615: select poa_edw_sup_perf_inc_s.nextval into l_seq_id from dual;
616:
617: /** Update the seq_id for records that had missing currency rates in
618: the earlier PUSH. We need to repush these records again
619: **/

Line 621: UPDATE poa_edw_sup_perf_inc

617: /** Update the seq_id for records that had missing currency rates in
618: the earlier PUSH. We need to repush these records again
619: **/
620:
621: UPDATE poa_edw_sup_perf_inc
622: SET seq_id = l_seq_id
623: WHERE seq_id IS NULL;
624:
625: p_count := sql%rowcount;

Line 629: into poa_edw_sup_perf_inc(primary_key, seq_id)

625: p_count := sql%rowcount;
626: edw_log.put_line( 'Updated ' || p_count || ' records');
627:
628: INSERT
629: into poa_edw_sup_perf_inc(primary_key, seq_id)
630: SELECT pll.line_location_id, l_seq_id
631: FROM po_lines_all pol,
632: po_line_locations_all pll,
633: po_headers_all poh