APPS.FII_AP_SCH_PAYMTS_F_C dependencies on FII_AP_SCH_PAYMTS_FSTG

Line 44: DELETE FII_AP_SCH_PAYMTS_FSTG

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

Line 75: FROM fii_ap_sch_paymts_fstg fsp

71: TO_NUMBER(SUBSTR (SCH_PAYMENT_PK, 1, INSTR(SCH_PAYMENT_PK, '-' )-1)),
72: TO_NUMBER(SUBSTR (SCH_PAYMENT_PK, INSTR(SCH_PAYMENT_PK, '-')+1,INSTR(SCH_PAYMENT_PK, '-',1,2) - (INSTR(SCH_PAYMENT_PK,'-')+1))) ,
73: g_acct_or_inv_date
74:
75: FROM fii_ap_sch_paymts_fstg fsp
76:
77: WHERE
78:
79: fsp.COLLECTION_STATUS = 'RATE NOT AVAILABLE'

Line 139: UPDATE FII_AP_SCH_PAYMTS_FSTG

135: IS
136:
137: BEGIN
138:
139: UPDATE FII_AP_SCH_PAYMTS_FSTG
140: SET COLLECTION_STATUS = 'READY'
141: WHERE COLLECTION_STATUS = 'LOCAL READY'
142: AND INSTANCE = (SELECT INSTANCE_CODE
143: FROM EDW_LOCAL_INSTANCE);

Line 190: Insert Into FII_AP_SCH_PAYMTS_FSTG(

186: -- ----------------------------------------------
187:
188: fii_flex_mapping.init_cache('FII_AP_SCH_PAYMTS_F');
189:
190: Insert Into FII_AP_SCH_PAYMTS_FSTG(
191: CCID,
192: COMPLETELY_PAID_PAYMENT_COUNT,
193: CREATION_DATE,
194: DISC_AMT_LOST_B,

Line 446: Insert Into FII_AP_SCH_PAYMTS_FSTG@EDW_APPS_TO_WH(

442: FUNCTION PUSH_REMOTE RETURN NUMBER
443: IS
444:
445: BEGIN
446: Insert Into FII_AP_SCH_PAYMTS_FSTG@EDW_APPS_TO_WH(
447: CCID,
448: COMPLETELY_PAID_PAYMENT_COUNT,
449: CREATION_DATE,
450: DISC_AMT_LOST_B,

Line 662: from FII_AP_SCH_PAYMTS_FSTG

658: USER_MEASURE4,
659: USER_MEASURE5,
660: NULL, -- OPERATION_CODE
661: 'READY'
662: from FII_AP_SCH_PAYMTS_FSTG
663: WHERE collection_status = 'LOCAL READY';
664: --ensures that only the records with collection status of local ready will be pushed to remote fstg
665:
666: RETURN(sql%rowcount);

Line 818: From FII_AP_SCH_PAYMTS_FSTG

814:
815: cursor c1 is select DISTINCT FROM_CURRENCY,
816: CREATION_DATE CONVERSION_DATE,
817: COLLECTION_STATUS
818: From FII_AP_SCH_PAYMTS_FSTG
819: where (COLLECTION_STATUS='RATE NOT AVAILABLE'
820: OR COLLECTION_STATUS = 'INVALID CURRENCY')
821: AND trunc(CREATION_DATE) <= trunc(sysdate);
822:

Line 830: From FII_AP_SCH_PAYMTS_FSTG

826: ----------------------------------------------------------------------------------------------------
827: cursor c2 is select DISTINCT FROM_CURRENCY,
828: CREATION_DATE CONVERSION_DATE,
829: COLLECTION_STATUS
830: From FII_AP_SCH_PAYMTS_FSTG
831: where (COLLECTION_STATUS='RATE NOT AVAILABLE'
832: OR COLLECTION_STATUS = 'INVALID CURRENCY' )
833: AND trunc(CREATION_DATE) > trunc(sysdate);
834:

Line 913: TRUNCATE_TABLE('FII_AP_SCH_PAYMTS_FSTG');

909: -- --------------------------------------------------------
910: edw_log.put_line(' ');
911: edw_log.put_line('Cleaning up unprocessed records left in local staging table');
912: IF (NOT LOCAL_SAME_AS_REMOTE) THEN
913: TRUNCATE_TABLE('FII_AP_SCH_PAYMTS_FSTG');
914: ELSE
915: DELETE_STG;
916: END IF;
917: select count(*) into rows1 from FII_AP_SCH_PAYMTS_FSTG;

Line 917: select count(*) into rows1 from FII_AP_SCH_PAYMTS_FSTG;

913: TRUNCATE_TABLE('FII_AP_SCH_PAYMTS_FSTG');
914: ELSE
915: DELETE_STG;
916: END IF;
917: select count(*) into rows1 from FII_AP_SCH_PAYMTS_FSTG;
918: edw_log.put_line('Number of rows in stg after truncating or deleting'||rows1 );
919: -- --------------------------------------------------------
920: -- 2. Identify Changed AP Scheduled Payments record
921: -- --------------------------------------------------------

Line 1070: TRUNCATE_TABLE('FII_AP_SCH_PAYMTS_FSTG');

1066: edw_log.put_line(to_char(g_row_count));
1067: edw_log.put_line('Cleaning local staging table');
1068:
1069: fii_util.start_timer;
1070: TRUNCATE_TABLE('FII_AP_SCH_PAYMTS_FSTG');
1071: fii_util.stop_timer;
1072: fii_util.print_timer('Duration');
1073:
1074: ELSE