APPS.OPI_DBI_WIP_SCRAP_INIT_PKG dependencies on FII_CURRENCY

Line 763: OPI_DBI_WIP_SCRAP_STG using the fii_currency.get_global_rate_primary

759: The conversion rate work table was truncated during
760: the initialization phase.
761:
762: Get the currency conversion rates based on the data in
763: OPI_DBI_WIP_SCRAP_STG using the fii_currency.get_global_rate_primary
764: API for the primary global currency and
765: fii_currency.get_global_rate_secondary for the secondary global currency.
766: The primary currency API:
767: 1. finds the conversion rate if one exists.

Line 765: fii_currency.get_global_rate_secondary for the secondary global currency.

761:
762: Get the currency conversion rates based on the data in
763: OPI_DBI_WIP_SCRAP_STG using the fii_currency.get_global_rate_primary
764: API for the primary global currency and
765: fii_currency.get_global_rate_secondary for the secondary global currency.
766: The primary currency API:
767: 1. finds the conversion rate if one exists.
768: 2. returns -1 if there is no conversion rate on that date.
769: 3. returns -2 if the currency code is not found.

Line 828: -- By the logic of the fii_currency.get_global_rate_primary

824:
825: invalid_rates_exist_rec invalid_rates_exist_csr%ROWTYPE;
826:
827: -- Set up a cursor to get all the invalid rates.
828: -- By the logic of the fii_currency.get_global_rate_primary
829: -- and fii_currency.get_global_rate_secondary APIs, the returned value
830: -- is -ve if no rate exists:
831: -- -1 for dates with no rate.
832: -- -2 for unrecognized conversion rates.

Line 829: -- and fii_currency.get_global_rate_secondary APIs, the returned value

825: invalid_rates_exist_rec invalid_rates_exist_csr%ROWTYPE;
826:
827: -- Set up a cursor to get all the invalid rates.
828: -- By the logic of the fii_currency.get_global_rate_primary
829: -- and fii_currency.get_global_rate_secondary APIs, the returned value
830: -- is -ve if no rate exists:
831: -- -1 for dates with no rate.
832: -- -2 for unrecognized conversion rates.
833: -- -3 for missing EUR to USD rates on 01-JAN-1999 when the

Line 941: -- Use the fii_currency.get_global_rate_primary function to get the

937: END IF;
938:
939: -- By selecting distinct org and currency code from the gl_set_of_books
940: -- and hr_organization_information, take care of duplicate codes.
941: -- Use the fii_currency.get_global_rate_primary function to get the
942: -- conversion rate given a currency code and a date.
943: -- The function returns:
944: -- rate if found
945: -- -1 for dates for which there is no currency conversion rate

Line 951: -- Use the fii_currency.get_global_rate_secondary to get the secondary

947: -- -3 for missing EUR to USD rates on 01-JAN-1999 when the
948: -- transaction_date is prior to 01-JAN-1999 (when the EUR
949: -- officially went into circulation).
950:
951: -- Use the fii_currency.get_global_rate_secondary to get the secondary
952: -- global rate. If the secondary currency has not been set up,
953: -- make the rate null. If the secondary currency/rate types are the
954: -- same as the primary, don't call the API but rather use an update
955: -- statement followed by the insert.

Line 978: fii_currency.get_global_rate_primary (

974: curr_codes.currency_code,
975: to_conv.transaction_date,
976: decode (curr_codes.currency_code,
977: l_global_currency_code, 1,
978: fii_currency.get_global_rate_primary (
979: curr_codes.currency_code,
980: to_conv.transaction_date) ),
981: decode (l_secondary_currency_code,
982: NULL, NULL,

Line 986: fii_currency.get_global_rate_secondary (

982: NULL, NULL,
983: curr_codes.currency_code, 1,
984: decode (l_pri_sec_curr_same,
985: 1, C_PRI_SEC_CURR_SAME_MARKER,
986: fii_currency.get_global_rate_secondary (
987: curr_codes.currency_code,
988: to_conv.transaction_date))),
989: sysdate,
990: sysdate,