APPS.PAY_AU_PAYMENT_SUMMARY dependencies on FF_ARCHIVE_ITEMS

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

1180:
1181: procedure create_extract_archive_details
1182: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
1183: p_user_entity_name in ff_user_entities.user_entity_name%type,
1184: p_value in out nocopy ff_archive_items.value%type) is
1185:
1186:
1187:
1188: cursor get_user_entity_id(c_user_entity_name in varchar2)

Line 1199: v_archive_item_id ff_archive_items.archive_item_id%type;

1195: and fue.user_entity_id =dbi.user_entity_id;
1196:
1197: v_full_name per_all_people_f.full_name%type;
1198: v_user_entity_id ff_user_entities.user_entity_id%type;
1199: v_archive_item_id ff_archive_items.archive_item_id%type;
1200: v_data_type ff_database_items.data_type%type;
1201: v_object_version_number ff_archive_items.object_version_number%type;
1202: v_some_warning boolean;
1203:

Line 1201: v_object_version_number ff_archive_items.object_version_number%type;

1197: v_full_name per_all_people_f.full_name%type;
1198: v_user_entity_id ff_user_entities.user_entity_id%type;
1199: v_archive_item_id ff_archive_items.archive_item_id%type;
1200: v_data_type ff_database_items.data_type%type;
1201: v_object_version_number ff_archive_items.object_version_number%type;
1202: v_some_warning boolean;
1203:
1204: i_index NUMBER; /* Bug 6470581 */
1205:

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

1213: hr_utility.set_location('Value is :' || p_value,17);
1214: END if;
1215:
1216: /* Bug 6470581 - Added Changes for Amended Payment Summary Type
1217: i. If g_payment_summary_type = 'O' (Original) - Archive values in ff_archive_items
1218: ii. If g_payment_summary_type = 'A' (Amended) - Add values to PL/SQL Table p_all_dbi_tab
1219: */
1220:
1221: IF g_payment_summary_type = 'O'

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

1228:
1229: -----------------------------------------------------------------------------------------------+
1230: -- if the archive item datatype is date then convert
1231: -- it into canonical format before archiving
1232: -- this is required because before inserting into ff_archive_items
1233: -- ff_archive_api validates the value
1234: -----------------------------------------------------------------------------------------------+
1235:
1236: if (v_data_type = 'D') then

Line 3167: v_archive_item_id ff_archive_items.archive_item_id%TYPE;

3163:
3164: v_some_warning BOOLEAN;
3165: v_bal_value VARCHAR2(20);
3166: v_user_entity_id NUMBER;
3167: v_archive_item_id ff_archive_items.archive_item_id%TYPE;
3168: v_object_version_number NUMBER;
3169: e_prepost_error EXCEPTION;
3170: l_result NUMBER;
3171:

Line 5597: from ff_archive_items fai,

5593:
5594: cursor csr_get_value(p_user_entity_name varchar2,
5595: p_assignment_action_id number) is
5596: select fai.value
5597: from ff_archive_items fai,
5598: ff_user_entities fue
5599: where fai.context1 = p_assignment_action_id
5600: and fai.user_entity_id = fue.user_entity_id
5601: and fue.user_entity_name = p_user_entity_name;

Line 5604: l_value ff_archive_items.value%type;

5600: and fai.user_entity_id = fue.user_entity_id
5601: and fue.user_entity_name = p_user_entity_name;
5602:
5603:
5604: l_value ff_archive_items.value%type;
5605: e_no_value_found exception;
5606:
5607:
5608: begin