DBA Data[Home] [Help]

APPS.PAY_KR_SEP_ARCHIVE_PKG dependencies on FF_ARCHIVE_ITEMS

Line 42: p_value in out NOCOPY ff_archive_items.value%type) is

38: procedure archive_item
39: ( p_item in ff_user_entities.user_entity_name%type,
40: p_context1 in pay_assignment_actions.assignment_action_id%type,
41: p_context2 in pay_element_entries_f.element_entry_id%type,
42: p_value in out NOCOPY ff_archive_items.value%type) is
43: cursor get_user_entity_id(c_user_entity_name in varchar2)
44: is
45: select fue.user_entity_id,
46: dbi.data_type

Line 53: v_archive_item_id ff_archive_items.archive_item_id%type;

49: where user_entity_name =c_user_entity_name
50: and fue.user_entity_id =dbi.user_entity_id;
51:
52: v_user_entity_id ff_user_entities.user_entity_id%type;
53: v_archive_item_id ff_archive_items.archive_item_id%type;
54: v_data_type ff_database_items.data_type%type;
55: v_object_version_number ff_archive_items.object_version_number%type;
56: v_some_warning boolean;
57:

Line 55: v_object_version_number ff_archive_items.object_version_number%type;

51:
52: v_user_entity_id ff_user_entities.user_entity_id%type;
53: v_archive_item_id ff_archive_items.archive_item_id%type;
54: v_data_type ff_database_items.data_type%type;
55: v_object_version_number ff_archive_items.object_version_number%type;
56: v_some_warning boolean;
57:
58:
59: begin