APPS.FII_AP_HOLD_DATA_F_C dependencies on FII_AP_TMP_HOLD_PK

Line 63: INSERT INTO FII_AP_TMP_HOLD_PK(

59: -- The profile option stored in the global variable g_acct_or_inv_date
60: -- will be stored in the column Primary_Key5 . Modified for Currency Conversion Date Enhancement,25-APR-03
61: -----------------------------------------------------------------------------------------------------
62:
63: INSERT INTO FII_AP_TMP_HOLD_PK(
64: Primary_Key1,
65: Primary_Key5)
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))),

Line 560: l_stmt := ' INSERT INTO fii_ap_tmp_hold_pk (Primary_Key1,Primary_Key5 )

556: -- will be stored in the column Primary_Key5 . Modified for Currency Conversion Date Enhancement, 3-APR-03
557: -----------------------------------------------------------------------------------------------------
558:
559:
560: l_stmt := ' INSERT INTO fii_ap_tmp_hold_pk (Primary_Key1,Primary_Key5 )
561: SELECT
562: ah.invoice_id,
563: :g_acct_or_inv_date
564: FROM ap_holds_all ah,

Line 710: from fii_ap_tmp_hold_pk;

706: Primary_key3)
707: select Primary_key1,
708: Primary_key2,
709: Primary_Key5
710: from fii_ap_tmp_hold_pk;
711: commit;
712: else
713:
714: TRUNCATE_TABLE('FII_AP_TMP_HOLD_PK');--bug#3947925

Line 714: TRUNCATE_TABLE('FII_AP_TMP_HOLD_PK');--bug#3947925

710: from fii_ap_tmp_hold_pk;
711: commit;
712: else
713:
714: TRUNCATE_TABLE('FII_AP_TMP_HOLD_PK');--bug#3947925
715:
716: --bug#3947925
717: --move the missing rates related info. from the missing rates
718: --table to the temp table for further processing.

Line 719: Insert into fii_ap_tmp_hold_pk(Primary_Key1,

715:
716: --bug#3947925
717: --move the missing rates related info. from the missing rates
718: --table to the temp table for further processing.
719: Insert into fii_ap_tmp_hold_pk(Primary_Key1,
720: Primary_Key2,
721: Primary_Key5)
722: select Primary_Key1,
723: Primary_Key2,

Line 788: TRUNCATE_TABLE('fii_ap_tmp_hold_pk');

784: -- --------------------------------------------------------
785: -- 4. Delete all temp table records
786: -- --------------------------------------------------------
787:
788: TRUNCATE_TABLE('fii_ap_tmp_hold_pk');
789: select count(*) into rows from FII_AP_TMP_HOLD_PK;
790: edw_log.put_line('Number of rows in tmp_pk after truncating or deleting '||rows );
791:
792: -- ------------------------------------------------------------------------------------------------

Line 789: select count(*) into rows from FII_AP_TMP_HOLD_PK;

785: -- 4. Delete all temp table records
786: -- --------------------------------------------------------
787:
788: TRUNCATE_TABLE('fii_ap_tmp_hold_pk');
789: select count(*) into rows from FII_AP_TMP_HOLD_PK;
790: edw_log.put_line('Number of rows in tmp_pk after truncating or deleting '||rows );
791:
792: -- ------------------------------------------------------------------------------------------------
793: -- 4A. Insert missing rates from local fstg into tmp_pk table printing data to file

Line 950: from fii_ap_tmp_hold_pk;

946: Primary_Key3)
947: select Primary_Key1,
948: Primary_Key2,
949: Primary_Key5
950: from fii_ap_tmp_hold_pk;
951: -- -----------------------------------------------
952: -- Successful. Commit and call
953: -- wrapup to commit and insert messages into logs
954: -- -----------------------------------------------

Line 975: TRUNCATE_TABLE('FII_AP_TMP_HOLD_PK');

971: --bug#3947925
972: --Program is on the verge of completing successfully,so clean up
973: -- the temp table
974: begin
975: TRUNCATE_TABLE('FII_AP_TMP_HOLD_PK');
976: exception
977: when others then
978: null;
979: end;