DBA Data[Home] [Help]

APPS.FV_CCR_DATA_LOAD_PKG dependencies on FV_CCR_DATA_LOAD_PKG

Line 1: package body FV_CCR_DATA_LOAD_PKG AS

1: package body FV_CCR_DATA_LOAD_PKG AS
2: /* $Header: FVCCRLDB.pls 120.11.12020000.3 2013/02/12 21:10:00 snama ship $*/
3:
4: type l_bus_codes is table of fnd_lookup_values.lookup_code%type index by binary_integer;
5:

Line 4748: l_module_name VARCHAR2(1000):= 'fv_ccr_data_load_pkg.get_territory_code';

4744: --that the CCR code will behave as it does before this fix was done.
4745: FUNCTION get_territory_code(p_iso_territory_code IN VARCHAR2)
4746: RETURN varchar2 IS
4747:
4748: l_module_name VARCHAR2(1000):= 'fv_ccr_data_load_pkg.get_territory_code';
4749: l_2char_territory_code VARCHAR2(2);
4750:
4751: BEGIN
4752:

Line 4795: end FV_CCR_DATA_LOAD_PKG;

4791: open c_psc_codes;
4792: fetch c_psc_codes bulk collect into psc_code;
4793: close c_psc_codes;
4794:
4795: end FV_CCR_DATA_LOAD_PKG;