APPS.POA_EDW_CONTRACT_F_C dependencies on POA_EDW_CONTRACT_INC

Line 28: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_EDW_CONTRACT_INC';

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

Line 42: INSERT INTO poa_edw_contract_inc(primary_key)

38:
39: PROCEDURE INSERT_MISSING_RATES
40: IS
41: BEGIN
42: INSERT INTO poa_edw_contract_inc(primary_key)
43: SELECT po_header_id
44: FROM POA_EDW_CONTRACT_FSTG
45: where COLLECTION_STATUS = 'RATE NOT AVAILABLE' OR
46: COLLECTION_STATUS = 'INVALID CURRENCY';

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

Line 296: FROM poa_edw_contract_inc

292:
293: -- Cursor to delete duplicates
294: CURSOR Dup_Rec IS
295: SELECT primary_key
296: FROM poa_edw_contract_inc
297: ORDER BY primary_key
298: FOR UPDATE;
299:
300: v_prev_id NUMBER;

Line 312: DELETE FROM poa_edw_contract_inc

308: exit when Dup_Rec % NOTFOUND;
309:
310: -- Check if the PK already exists
311: IF (v_prev_id = v_cur_id) THEN
312: DELETE FROM poa_edw_contract_inc
313: WHERE CURRENT OF Dup_Rec;
314: ELSE
315: v_prev_id := v_cur_id;
316: END IF;

Line 343: select poa_edw_contract_inc_s.nextval into l_seq_id from dual;

339:
340: BEGIN
341:
342: p_count := 0;
343: select poa_edw_contract_inc_s.nextval into l_seq_id from dual;
344:
345: /** Update the seq_id for records that had missing currency rates in
346: the earlier PUSH. We need to repush these records again
347: **/

Line 349: UPDATE poa_edw_contract_inc

345: /** Update the seq_id for records that had missing currency rates in
346: the earlier PUSH. We need to repush these records again
347: **/
348:
349: UPDATE poa_edw_contract_inc
350: SET seq_id = l_seq_id
351: WHERE seq_id IS NULL;
352:
353: p_count := sql%rowcount;

Line 356: INSERT INTO poa_edw_contract_inc(primary_key, seq_id)

352:
353: p_count := sql%rowcount;
354: edw_log.put_line( 'Updated ' || p_count || ' records');
355:
356: INSERT INTO poa_edw_contract_inc(primary_key, seq_id)
357: SELECT po_header_id, l_seq_id
358: FROM PO_HEADERS_ALL
359: WHERE type_lookup_code in ('CONTRACT', 'BLANKET')
360: AND approved_flag = 'Y'