APPS.FII_AP_SCH_PAYMTS_F_C dependencies on FII_AP_TMP_SCHP_PK

Line 66: INSERT INTO fii_ap_tmp_schp_pk(

62: -- The profile option stored in the global variable g_acct_or_inv_date
63: -- will be stored in the column Primary_Key5 . Modified for Currency Conversion Date Enhancement,25-APR-03
64: -----------------------------------------------------------------------------------------------------
65:
66: INSERT INTO fii_ap_tmp_schp_pk(
67: Primary_Key1,
68: Primary_Key2,
69: Primary_Key5 )
70: SELECT

Line 708: l_stmt := ' INSERT INTO fii_ap_tmp_schp_pk(

704: -- The value of the profile option stored in the global variable g_acct_or_inv_date
705: -- will be stored in the column Primary_Key5 . Modified for Currency Conversion Enhancement, 4-APR-03
706: -----------------------------------------------------------------------------------------------------
707:
708: l_stmt := ' INSERT INTO fii_ap_tmp_schp_pk(
709: Primary_Key1,
710: Primary_Key2,
711: Primary_Key5)
712:

Line 874: from fii_ap_tmp_schp_pk;

870: Primary_key3)
871: select Primary_key1,
872: Primary_key2,
873: Primary_Key5
874: from fii_ap_tmp_schp_pk;
875: commit;
876: else
877:
878: TRUNCATE_TABLE('FII_AP_TMP_SCHP_PK');--bug#3947925

Line 878: TRUNCATE_TABLE('FII_AP_TMP_SCHP_PK');--bug#3947925

874: from fii_ap_tmp_schp_pk;
875: commit;
876: else
877:
878: TRUNCATE_TABLE('FII_AP_TMP_SCHP_PK');--bug#3947925
879:
880: --bug#3947925
881: --move the missing rates related info. from the missing rates
882: --table to the temp table for further processing.

Line 883: Insert into fii_ap_tmp_schp_pk(Primary_Key1,

879:
880: --bug#3947925
881: --move the missing rates related info. from the missing rates
882: --table to the temp table for further processing.
883: Insert into fii_ap_tmp_schp_pk(Primary_Key1,
884: Primary_Key2,
885: Primary_Key5)
886: select Primary_Key1,
887: Primary_Key2,

Line 951: TRUNCATE_TABLE('fii_ap_tmp_schp_pk');

947:
948: -- --------------------------------------------------------------------
949: -- 4. Delete records generated from previous session from tmp_pk table
950: -- --------------------------------------------------------------------
951: TRUNCATE_TABLE('fii_ap_tmp_schp_pk');
952: select count(*) into rows from fii_ap_tmp_schp_pk ;
953: edw_log.put_line('Number of rows in tmp_pk after truncating or deleting '||rows );
954: -- ------------------------------------------------------------------------------------------------
955: -- 4A. Insert missing rates from local fstg into tmp_pk table printing data to file

Line 952: select count(*) into rows from fii_ap_tmp_schp_pk ;

948: -- --------------------------------------------------------------------
949: -- 4. Delete records generated from previous session from tmp_pk table
950: -- --------------------------------------------------------------------
951: TRUNCATE_TABLE('fii_ap_tmp_schp_pk');
952: select count(*) into rows from fii_ap_tmp_schp_pk ;
953: edw_log.put_line('Number of rows in tmp_pk after truncating or deleting '||rows );
954: -- ------------------------------------------------------------------------------------------------
955: -- 4A. Insert missing rates from local fstg into tmp_pk table printing data to file
956: -- ------------------------------------------------------------------------------------------------

Line 1107: from fii_ap_tmp_schp_pk;

1103: Primary_Key3)
1104: select Primary_Key1,
1105: Primary_Key2,
1106: Primary_Key5
1107: from fii_ap_tmp_schp_pk;
1108: -- -----------------------------------------------
1109: -- Successful. Commit and call
1110: -- wrapup to commit and insert messages into logs
1111: -- -----------------------------------------------

Line 1127: TRUNCATE_TABLE('FII_AP_TMP_SCHP_PK');

1123: --bug#3947925
1124: --Program is on the verge of completing successfully,so clean up
1125: -- the temp table
1126: begin
1127: TRUNCATE_TABLE('FII_AP_TMP_SCHP_PK');
1128: exception
1129: when others then
1130: null;
1131: end;