APPS.FII_AP_INV_PAYMTS_F_C dependencies on FII_AP_INV_PAYMTS_FSTG

Line 42: DELETE FII_AP_INV_PAYMTS_FSTG

38: PROCEDURE DELETE_STG
39: IS
40:
41: BEGIN
42: DELETE FII_AP_INV_PAYMTS_FSTG
43: WHERE COLLECTION_STATUS = 'LOCAL READY' OR ( COLLECTION_STATUS = 'RATE NOT AVAILABLE' OR COLLECTION_STATUS = 'INVALID CURRENCY')
44: AND INSTANCE = (SELECT INSTANCE_CODE
45: FROM EDW_LOCAL_INSTANCE);
46: END;

Line 68: FROM FII_AP_INV_PAYMTS_FSTG fsi

64: SELECT
65: TO_NUMBER(SUBSTR (INV_PAYMENT_PK, 1, INSTR(INV_PAYMENT_PK, '-' )-1)) ,
66: g_acct_or_inv_date
67:
68: FROM FII_AP_INV_PAYMTS_FSTG fsi
69:
70: WHERE
71:
72: fsi.COLLECTION_STATUS = 'RATE NOT AVAILABLE'

Line 131: UPDATE FII_AP_INV_PAYMTS_FSTG

127: IS
128:
129: BEGIN
130:
131: UPDATE FII_AP_INV_PAYMTS_FSTG
132: SET COLLECTION_STATUS = 'READY'
133: WHERE COLLECTION_STATUS = 'LOCAL READY'
134: AND INSTANCE = (SELECT INSTANCE_CODE
135: FROM EDW_LOCAL_INSTANCE);

Line 176: Insert Into FII_AP_INV_PAYMTS_FSTG(

172: -- completed successfully.
173: -- ------------------------------------------------
174: fii_flex_mapping.init_cache('FII_AP_INV_PAYMTS_F');
175:
176: Insert Into FII_AP_INV_PAYMTS_FSTG(
177: ACCOUNTING_DATE,
178: ACCRUAL_POSTED_FLAG,
179: ASSETS_ADDITION_FLAG,
180: BANK_ACCOUNT_ID,

Line 424: Insert Into FII_AP_INV_PAYMTS_FSTG@EDW_APPS_TO_WH(

420: FUNCTION PUSH_REMOTE RETURN NUMBER
421: IS
422:
423: BEGIN
424: Insert Into FII_AP_INV_PAYMTS_FSTG@EDW_APPS_TO_WH(
425: ACCOUNTING_DATE,
426: ACCRUAL_POSTED_FLAG,
427: ASSETS_ADDITION_FLAG,
428: BANK_ACCOUNT_ID,

Line 646: from FII_AP_INV_PAYMTS_FSTG

642: CHECK_AMT_B, -- added these four columns for New Information Enhancement
643: CHECK_AMT_T,
644: CHECK_AMT_G,
645: CHECK_NUMBER
646: from FII_AP_INV_PAYMTS_FSTG
647: WHERE collection_status = 'LOCAL READY';
648: --ensures that only the records with collection status of local ready will be pushed to remote fstg
649: RETURN(sql%rowcount);
650:

Line 794: From FII_AP_INV_PAYMTS_FSTG

790: Decode(g_acct_or_inv_date,
791: 1, ACCOUNTING_DATE,
792: INVOICE_DATE) CONVERSION_DATE,
793: COLLECTION_STATUS
794: From FII_AP_INV_PAYMTS_FSTG
795: where (COLLECTION_STATUS='RATE NOT AVAILABLE'
796: OR COLLECTION_STATUS = 'INVALID CURRENCY')
797: AND trunc(Decode(g_acct_or_inv_date,
798: 1, ACCOUNTING_DATE,

Line 815: From FII_AP_INV_PAYMTS_FSTG

811: Decode(g_acct_or_inv_date,
812: 1, ACCOUNTING_DATE,
813: INVOICE_DATE) CONVERSION_DATE,
814: COLLECTION_STATUS
815: From FII_AP_INV_PAYMTS_FSTG
816: where (COLLECTION_STATUS='RATE NOT AVAILABLE'
817: OR COLLECTION_STATUS = 'INVALID CURRENCY')
818: AND trunc(Decode(g_acct_or_inv_date,
819: 1, ACCOUNTING_DATE,

Line 899: TRUNCATE_TABLE('FII_AP_INV_PAYMTS_FSTG');

895: -- --------------------------------------------------------
896: edw_log.put_line(' ');
897: edw_log.put_line('Cleaning up unprocessed records left in local staging table');
898: IF (NOT LOCAL_SAME_AS_REMOTE) THEN
899: TRUNCATE_TABLE('FII_AP_INV_PAYMTS_FSTG');
900: ELSE
901: DELETE_STG;
902: END IF;
903: select count(*) into rows1 from FII_AP_INV_PAYMTS_FSTG;

Line 903: select count(*) into rows1 from FII_AP_INV_PAYMTS_FSTG;

899: TRUNCATE_TABLE('FII_AP_INV_PAYMTS_FSTG');
900: ELSE
901: DELETE_STG;
902: END IF;
903: select count(*) into rows1 from FII_AP_INV_PAYMTS_FSTG;
904: edw_log.put_line('Number of rows in stg after truncating or deleting'||rows1 );
905: -- --------------------------------------------------------
906: -- 2. Identify Changed AP Invoice Payments record
907: -- --------------------------------------------------------

Line 1059: TRUNCATE_TABLE('FII_AP_INV_PAYMTS_FSTG');

1055: edw_log.put_line(' ');
1056: edw_log.put_line('Cleaning local staging table');
1057:
1058: fii_util.start_timer;
1059: TRUNCATE_TABLE('FII_AP_INV_PAYMTS_FSTG');
1060: fii_util.stop_timer;
1061: fii_util.print_timer('Duration');
1062:
1063: ELSE