DBA Data[Home] [Help]

APPS.PAY_HK_IR56_ARCHIVE dependencies on FF_ARCHIVE_ITEMS

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

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

Line 519: item_value ff_archive_items.value%type);

515: /* Bug No : 2829320 - declared item_name and item_value using %type */
516:
517: TYPE
518: archive_rec IS RECORD (item_name ff_user_entities.user_entity_name%type,
519: item_value ff_archive_items.value%type);
520: TYPE
521: archive_tab IS TABLE OF archive_rec INDEX BY BINARY_INTEGER;
522: tab_empl archive_tab;
523:

Line 1566: p_archive_value IN ff_archive_items.value%TYPE)

1562:
1563: PROCEDURE archive_item
1564: (p_user_entity_name IN ff_user_entities.user_entity_name%TYPE,
1565: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,
1566: p_archive_value IN ff_archive_items.value%TYPE)
1567: IS
1568: v_user_entity_id ff_user_entities.user_entity_id%TYPE;
1569: v_archive_item_id ff_archive_items.archive_item_id%TYPE;
1570: v_object_version_number ff_archive_items.object_version_number%TYPE;

Line 1569: v_archive_item_id ff_archive_items.archive_item_id%TYPE;

1565: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,
1566: p_archive_value IN ff_archive_items.value%TYPE)
1567: IS
1568: v_user_entity_id ff_user_entities.user_entity_id%TYPE;
1569: v_archive_item_id ff_archive_items.archive_item_id%TYPE;
1570: v_object_version_number ff_archive_items.object_version_number%TYPE;
1571: v_some_warning boolean;
1572:
1573: CURSOR user_entity_id(c_user_entity_name ff_user_entities.user_entity_name%TYPE)

Line 1570: v_object_version_number ff_archive_items.object_version_number%TYPE;

1566: p_archive_value IN ff_archive_items.value%TYPE)
1567: IS
1568: v_user_entity_id ff_user_entities.user_entity_id%TYPE;
1569: v_archive_item_id ff_archive_items.archive_item_id%TYPE;
1570: v_object_version_number ff_archive_items.object_version_number%TYPE;
1571: v_some_warning boolean;
1572:
1573: CURSOR user_entity_id(c_user_entity_name ff_user_entities.user_entity_name%TYPE)
1574: IS