APPS.PAY_HK_IR56_ARCHIVE dependencies on FF_ARCHIVE_ITEMS

Line 137: g_archive_message ff_archive_items.value%TYPE := NULL;

133: --* GLobal variables (populated in archive_code procedure)
134: g_assignment_id pay_assignment_actions.assignment_id%TYPE;
135: g_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
136: g_payroll_Action_id pay_payroll_actions.payroll_action_id%TYPE;
137: g_archive_message ff_archive_items.value%TYPE := NULL;
138: g_error_in_quarter BOOLEAN := FALSE;
139: g_business_group_id hr_organization_units.business_group_id%TYPE; -- for submitting the PAYHKCTL report
140:
141: --* Bug 2189137

Line 554: item_value ff_archive_items.value%type);

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;
558:

Line 1635: p_archive_value IN ff_archive_items.value%TYPE)

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;
1638: v_archive_item_id ff_archive_items.archive_item_id%TYPE;
1639: v_object_version_number ff_archive_items.object_version_number%TYPE;

Line 1638: v_archive_item_id ff_archive_items.archive_item_id%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:
1642: CURSOR user_entity_id(c_user_entity_name ff_user_entities.user_entity_name%TYPE)

Line 1639: v_object_version_number ff_archive_items.object_version_number%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:
1642: CURSOR user_entity_id(c_user_entity_name ff_user_entities.user_entity_name%TYPE)
1643: IS