APPS.OPI_DBI_WIP_COMP_INIT_PKG dependencies on FII_CURRENCY

Line 794: OPI_DBI_WIP_COMP_STG using the fii_currency.get_global_rate_primary

790: The conversion rate work table was truncated during
791: the initialization phase.
792:
793: Get the currency conversion rates based on the data in
794: OPI_DBI_WIP_COMP_STG using the fii_currency.get_global_rate_primary
795: API for the primary global currency and
796: fii_currency.get_global_rate_secondary for the secondary global currency.
797: The primary currency API:
798: 1. finds the conversion rate if one exists.

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

792:
793: Get the currency conversion rates based on the data in
794: OPI_DBI_WIP_COMP_STG using the fii_currency.get_global_rate_primary
795: API for the primary global currency and
796: fii_currency.get_global_rate_secondary for the secondary global currency.
797: The primary currency API:
798: 1. finds the conversion rate if one exists.
799: 2. returns -1 if there is no conversion rate on that date.
800: 3. returns -2 if the currency code is not found.

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

863: invalid_rates_exist_rec invalid_rates_exist_csr%ROWTYPE;
864:
865:
866: -- Set up a cursor to get all the invalid rates.
867: -- By the logic of the fii_currency.get_global_rate_primary
868: -- and fii_currency.get_global_rate_secondary APIs, the returned value
869: -- is -ve if no rate exists:
870: -- -1 for dates with no rate.
871: -- -2 for unrecognized conversion rates.

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

864:
865:
866: -- Set up a cursor to get all the invalid rates.
867: -- By the logic of the fii_currency.get_global_rate_primary
868: -- and fii_currency.get_global_rate_secondary APIs, the returned value
869: -- is -ve if no rate exists:
870: -- -1 for dates with no rate.
871: -- -2 for unrecognized conversion rates.
872: -- -3 for missing EUR to USD rates on 01-JAN-1999 when the

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

975: END IF;
976:
977: -- By selecting distinct org and currency code from the gl_set_of_books
978: -- and hr_organization_information, take care of duplicate codes.
979: -- Use the fii_currency.get_global_rate_primary function to get the
980: -- conversion rate given a currency code and a date.
981: -- The function returns:
982: -- rate if found
983: -- -1 for dates for which there is no currency conversion rate

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

985: -- -3 for missing EUR to USD rates on 01-JAN-1999 when the
986: -- transaction_date is prior to 01-JAN-1999 (when the EUR
987: -- officially went into circulation).
988:
989: -- Use the fii_currency.get_global_rate_secondary to get the secondary
990: -- global rate. If the secondary currency has not been set up,
991: -- make the rate null. If the secondary currency/rate types are the
992: -- same as the primary, don't call the API but rather use an update
993: -- statement followed by the insert.

Line 1016: fii_currency.get_global_rate_primary (

1012: curr_codes.currency_code,
1013: to_conv.transaction_date,
1014: decode (curr_codes.currency_code,
1015: l_global_currency_code, 1,
1016: fii_currency.get_global_rate_primary (
1017: curr_codes.currency_code,
1018: to_conv.transaction_date) ),
1019: decode (l_secondary_currency_code,
1020: NULL, NULL,

Line 1024: fii_currency.get_global_rate_secondary (

1020: NULL, NULL,
1021: curr_codes.currency_code, 1,
1022: decode (l_pri_sec_curr_same,
1023: 1, C_PRI_SEC_CURR_SAME_MARKER,
1024: fii_currency.get_global_rate_secondary (
1025: curr_codes.currency_code,
1026: to_conv.transaction_date))),
1027: sysdate,
1028: sysdate,