APPS.FII_AP_HOLD_DATA_F_C dependencies on FII_AP_HOLD_DATA_FSTG

Line 41: DELETE FII_AP_HOLD_DATA_FSTG

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

Line 70: FROM FII_AP_HOLD_DATA_FSTG fhd

66: SELECT
67: TO_NUMBER(SUBSTR (HOLD_DATA_PK, INSTR(HOLD_DATA_PK, '-')+1,INSTR(HOLD_DATA_PK,'-',1,2)-(INSTR(HOLD_DATA_PK,'-')+1))),
68: g_acct_or_inv_date
69:
70: FROM FII_AP_HOLD_DATA_FSTG fhd
71:
72: WHERE
73:
74: fhd.COLLECTION_STATUS = 'RATE NOT AVAILABLE'

Line 134: UPDATE FII_AP_HOLD_DATA_FSTG

130: IS
131:
132: BEGIN
133:
134: UPDATE FII_AP_HOLD_DATA_FSTG
135: SET COLLECTION_STATUS = 'READY'
136: WHERE COLLECTION_STATUS = 'LOCAL READY'
137: AND INSTANCE = (SELECT INSTANCE_CODE
138: FROM EDW_LOCAL_INSTANCE);

Line 186: Insert Into FII_AP_HOLD_DATA_FSTG(

182: -- Added for Currency Conversion Date Enhancement
183: -- ----------------------------------------------
184: fii_flex_mapping.init_cache('FII_AP_HOLD_DATA_F');
185:
186: Insert Into FII_AP_HOLD_DATA_FSTG(
187: CCID,
188: CREATION_DATE,
189: DUNS_FK,
190: GEOGRAPHY_FK,

Line 355: Insert Into FII_AP_HOLD_DATA_FSTG@EDW_APPS_TO_WH(

351: IS
352:
353: BEGIN
354: -- Bug 3735601. Added substrb to all the varchar2 columns.
355: Insert Into FII_AP_HOLD_DATA_FSTG@EDW_APPS_TO_WH(
356: CCID,
357: CREATION_DATE,
358: DUNS_FK,
359: GEOGRAPHY_FK,

Line 513: from FII_AP_HOLD_DATA_FSTG

509: USER_MEASURE4,
510: USER_MEASURE5,
511: NULL, -- OPERATION_CODE
512: 'READY'
513: from FII_AP_HOLD_DATA_FSTG
514: where collection_status = 'LOCAL READY';
515: --only records with collection status of local ready will be pushed to remote fstg
516:
517: RETURN(sql%rowcount);

Line 654: From FII_AP_HOLD_DATA_FSTG

650: ----------------------------------------------------------------------------------------------
651: cursor c1 is select DISTINCT FROM_CURRENCY,
652: CREATION_DATE CONVERSION_DATE,
653: COLLECTION_STATUS
654: From FII_AP_HOLD_DATA_FSTG
655: where (COLLECTION_STATUS='RATE NOT AVAILABLE'
656: OR COLLECTION_STATUS = 'INVALID CURRENCY')
657: AND trunc(CREATION_DATE) <= trunc(sysdate);
658:

Line 666: From FII_AP_HOLD_DATA_FSTG

662: ----------------------------------------------------------------------------------------------------
663: cursor c2 is select DISTINCT FROM_CURRENCY,
664: CREATION_DATE CONVERSION_DATE,
665: COLLECTION_STATUS
666: From FII_AP_HOLD_DATA_FSTG
667: where (COLLECTION_STATUS='RATE NOT AVAILABLE'
668: OR COLLECTION_STATUS = 'INVALID CURRENCY' )
669: AND trunc(CREATION_DATE) > trunc(sysdate);
670:

Line 750: TRUNCATE_TABLE('FII_AP_HOLD_DATA_FSTG');

746: -- --------------------------------------------------------
747: edw_log.put_line(' ');
748: edw_log.put_line('Cleaning up unprocessed records left in local staging table');
749: IF (NOT LOCAL_SAME_AS_REMOTE) THEN
750: TRUNCATE_TABLE('FII_AP_HOLD_DATA_FSTG');
751: ELSE
752: DELETE_STG;
753: END IF;
754:

Line 913: TRUNCATE_TABLE('FII_AP_HOLD_DATA_FSTG');

909: edw_log.put_line(' ');
910: edw_log.put_line('Cleaning local staging table');
911:
912: fii_util.start_timer;
913: TRUNCATE_TABLE('FII_AP_HOLD_DATA_FSTG');
914: fii_util.stop_timer;
915: fii_util.print_timer('Duration');
916:
917: ELSE