DBA Data[Home] [Help]

APPS.PAY_HK_IR56_ARCHIVE dependencies on FF_USER_ENTITIES

Line 553: archive_rec IS RECORD (item_name ff_user_entities.user_entity_name%type,

549:
550: /* Bug No : 2829320 - declared item_name and item_value using %type */
551:
552: TYPE
553: archive_rec IS RECORD (item_name ff_user_entities.user_entity_name%type,
554: item_value ff_archive_items.value%type);
555: TYPE
556: archive_tab IS TABLE OF archive_rec INDEX BY BINARY_INTEGER;
557: tab_empl archive_tab;

Line 1633: (p_user_entity_name IN ff_user_entities.user_entity_name%TYPE,

1629: -- Calls the archive utility to actually perform the archive of the item.
1630: ---------------------------------------------------------------------------
1631:
1632: PROCEDURE archive_item
1633: (p_user_entity_name IN ff_user_entities.user_entity_name%TYPE,
1634: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,
1635: p_archive_value IN ff_archive_items.value%TYPE)
1636: IS
1637: v_user_entity_id ff_user_entities.user_entity_id%TYPE;

Line 1637: v_user_entity_id ff_user_entities.user_entity_id%TYPE;

1633: (p_user_entity_name IN ff_user_entities.user_entity_name%TYPE,
1634: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,
1635: p_archive_value IN ff_archive_items.value%TYPE)
1636: IS
1637: v_user_entity_id ff_user_entities.user_entity_id%TYPE;
1638: v_archive_item_id ff_archive_items.archive_item_id%TYPE;
1639: v_object_version_number ff_archive_items.object_version_number%TYPE;
1640: v_some_warning boolean;
1641:

Line 1642: CURSOR user_entity_id(c_user_entity_name ff_user_entities.user_entity_name%TYPE)

1638: v_archive_item_id ff_archive_items.archive_item_id%TYPE;
1639: v_object_version_number ff_archive_items.object_version_number%TYPE;
1640: v_some_warning boolean;
1641:
1642: CURSOR user_entity_id(c_user_entity_name ff_user_entities.user_entity_name%TYPE)
1643: IS
1644: SELECT user_entity_id
1645: FROM ff_user_entities
1646: WHERE user_entity_name = c_user_entity_name;

Line 1645: FROM ff_user_entities

1641:
1642: CURSOR user_entity_id(c_user_entity_name ff_user_entities.user_entity_name%TYPE)
1643: IS
1644: SELECT user_entity_id
1645: FROM ff_user_entities
1646: WHERE user_entity_name = c_user_entity_name;
1647:
1648: Begin
1649: hr_utility.set_location('Start of archive_item',10);