APPS.PAY_AU_PAYMENT_SUMMARY dependencies on FF_ARCHIVE_ITEMS

Line 2048: p_value in out nocopy ff_archive_items.value%type) is

2044:
2045: procedure create_extract_archive_details
2046: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
2047: p_user_entity_name in ff_user_entities.user_entity_name%type,
2048: p_value in out nocopy ff_archive_items.value%type) is
2049:
2050:
2051:
2052: cursor get_user_entity_id(c_user_entity_name in varchar2)

Line 2063: v_archive_item_id ff_archive_items.archive_item_id%type;

2059: and fue.user_entity_id =dbi.user_entity_id;
2060:
2061: v_full_name per_all_people_f.full_name%type;
2062: v_user_entity_id ff_user_entities.user_entity_id%type;
2063: v_archive_item_id ff_archive_items.archive_item_id%type;
2064: v_data_type ff_database_items.data_type%type;
2065: v_object_version_number ff_archive_items.object_version_number%type;
2066: v_some_warning boolean;
2067:

Line 2065: v_object_version_number ff_archive_items.object_version_number%type;

2061: v_full_name per_all_people_f.full_name%type;
2062: v_user_entity_id ff_user_entities.user_entity_id%type;
2063: v_archive_item_id ff_archive_items.archive_item_id%type;
2064: v_data_type ff_database_items.data_type%type;
2065: v_object_version_number ff_archive_items.object_version_number%type;
2066: v_some_warning boolean;
2067:
2068: i_index NUMBER; /* Bug 6470581 */
2069:

Line 2081: i. If g_payment_summary_type = 'O' (Original) - Archive values in ff_archive_items

2077: hr_utility.set_location('Value is :' || p_value,17);
2078: END if;
2079:
2080: /* Bug 6470581 - Added Changes for Amended Payment Summary Type
2081: i. If g_payment_summary_type = 'O' (Original) - Archive values in ff_archive_items
2082: ii. If g_payment_summary_type = 'A' (Amended) - Add values to PL/SQL Table p_all_dbi_tab
2083: */
2084:
2085: IF g_payment_summary_type = 'O'

Line 2096: -- this is required because before inserting into ff_archive_items

2092:
2093: -----------------------------------------------------------------------------------------------+
2094: -- if the archive item datatype is date then convert
2095: -- it into canonical format before archiving
2096: -- this is required because before inserting into ff_archive_items
2097: -- ff_archive_api validates the value
2098: -----------------------------------------------------------------------------------------------+
2099:
2100: if (v_data_type = 'D') then

Line 5460: v_archive_item_id ff_archive_items.archive_item_id%TYPE;

5456:
5457: v_some_warning BOOLEAN;
5458: v_bal_value VARCHAR2(20);
5459: v_user_entity_id NUMBER;
5460: v_archive_item_id ff_archive_items.archive_item_id%TYPE;
5461: v_object_version_number NUMBER;
5462: e_prepost_error EXCEPTION;
5463: l_result NUMBER;
5464:

Line 9337: from ff_archive_items fai,

9333:
9334: cursor csr_get_value(p_user_entity_name varchar2,
9335: p_assignment_action_id number) is
9336: select fai.value
9337: from ff_archive_items fai,
9338: ff_user_entities fue
9339: where fai.context1 = p_assignment_action_id
9340: and fai.user_entity_id = fue.user_entity_id
9341: and fue.user_entity_name = p_user_entity_name;

Line 9344: l_value ff_archive_items.value%type;

9340: and fai.user_entity_id = fue.user_entity_id
9341: and fue.user_entity_name = p_user_entity_name;
9342:
9343:
9344: l_value ff_archive_items.value%type;
9345: e_no_value_found exception;
9346:
9347:
9348: begin