APPS.PAY_KR_REPORT_PKG dependencies on FF_ARCHIVE_ITEMS

Line 15: type value_tbl is table of ff_archive_items.value%type index by binary_integer;

11: g_pre_get_balance_value_index number;
12: g_pre_get_dbitem_value_index number;
13: g_debug constant boolean := hr_utility.debug_enabled;
14: --
15: type value_tbl is table of ff_archive_items.value%type index by binary_integer;
16: type balance_name_tbl is table of pay_balance_types.balance_name%type index by binary_integer;
17: type dimension_name_tbl is table of pay_balance_dimensions.dimension_name%type index by binary_integer;
18: type defined_balance_id_tbl is table of pay_defined_balances.defined_balance_id%type index by binary_integer;
19: type user_entity_id_tbl is table of ff_user_entities.user_entity_id%type index by binary_integer;

Line 23: type user_entity_id_tbl is table of ff_archive_items.user_entity_id%type index by binary_integer;

19: type user_entity_id_tbl is table of ff_user_entities.user_entity_id%type index by binary_integer;
20: type user_entity_name_tbl is table of ff_user_entities.user_entity_name%type index by binary_integer;
21: type user_name_tbl is table of ff_database_items.user_name%type index by binary_integer;
22: /*
23: type user_entity_id_tbl is table of ff_archive_items.user_entity_id%type index by binary_integer;
24: type archive_item_rec is record(
25: user_entity_id user_entity_id_tbl,
26: value value_tbl);
27: g_archive_item archive_item_rec;

Line 575: -- l_value ff_archive_items.value%type;

571: p_user_entity_id in number) return varchar2
572: --------------------------------------------------------------------------------
573: is
574: --
575: -- l_value ff_archive_items.value%type;
576: -- l_index binary_integer;
577: -- l_found boolean := FALSE;
578: type user_entity_id_tbl is table of ff_archive_items.user_entity_id%type index by binary_integer;
579: l_user_entity_id_tbl user_entity_id_tbl;

Line 578: type user_entity_id_tbl is table of ff_archive_items.user_entity_id%type index by binary_integer;

574: --
575: -- l_value ff_archive_items.value%type;
576: -- l_index binary_integer;
577: -- l_found boolean := FALSE;
578: type user_entity_id_tbl is table of ff_archive_items.user_entity_id%type index by binary_integer;
579: l_user_entity_id_tbl user_entity_id_tbl;
580: l_archive_item_value_tbl value_tbl;
581: --
582: cursor csr_archive

Line 586: from ff_archive_items fai

582: cursor csr_archive
583: is
584: select fai.user_entity_id,
585: fai.value
586: from ff_archive_items fai
587: where fai.context1 = p_assignment_action_id
588: and fai.value is not null;
589: --
590: begin

Line 816: l_value ff_archive_items.value%type;

812: p_user_entity_id in number) return varchar2
813: --------------------------------------------------------------------------------
814: is
815: --
816: l_value ff_archive_items.value%type;
817: l_xuser_entity_id number;
818: l_business_group_id number;
819: l_archive varchar2(1);
820: l_cache varchar2(1);

Line 948: l_value ff_archive_items.value%type;

944: p_user_name in varchar2) return varchar2
945: --------------------------------------------------------------------------------
946: is
947: --
948: l_value ff_archive_items.value%type;
949: l_user_entity_id number;
950: l_business_group_id number;
951: l_cache varchar2(1);
952: --