APPS.PAY_AU_PAYMENT_SUMMARY_AMEND dependencies on FF_ARCHIVE_ITEMS

Line 670: ,p_value1 IN ff_archive_items.value%TYPE

666: */
667:
668: FUNCTION compare_user_entity_value
669: (p_user_entity_name IN ff_user_entities.user_entity_name%TYPE
670: ,p_value1 IN ff_archive_items.value%TYPE
671: ,p_value2 IN ff_archive_items.value%TYPE
672: ,p_data_type IN ff_database_items.data_type%TYPE)
673: RETURN VARCHAR2
674: IS

Line 671: ,p_value2 IN ff_archive_items.value%TYPE

667:
668: FUNCTION compare_user_entity_value
669: (p_user_entity_name IN ff_user_entities.user_entity_name%TYPE
670: ,p_value1 IN ff_archive_items.value%TYPE
671: ,p_value2 IN ff_archive_items.value%TYPE
672: ,p_data_type IN ff_database_items.data_type%TYPE)
673: RETURN VARCHAR2
674: IS
675:

Line 746: FROM ff_archive_items fae,

742: CURSOR get_archived_user_entities
743: (c_archive_action_id pay_assignment_actions.assignment_action_id%TYPE)
744: IS
745: SELECT fue.user_entity_name
746: FROM ff_archive_items fae,
747: ff_user_entities fue
748: WHERE fae.context1 = c_archive_action_id
749: AND fue.user_entity_id = fae.user_entity_id
750: AND (

Line 894: FROM ff_archive_items fai,

890: c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
891: IS
892: SELECT fai.value
893: ,fdi.data_type
894: FROM ff_archive_items fai,
895: ff_user_entities fue,
896: ff_database_items fdi
897: WHERE fai.context1 = c_assignment_action_id
898: AND fai.user_entity_id = fue.user_entity_id

Line 906: l_old_value ff_archive_items.value%TYPE;

902: i_index NUMBER;
903: l_procedure VARCHAR2(80);
904:
905: l_item_type VARCHAR2(20);
906: l_old_value ff_archive_items.value%TYPE;
907: l_data_type ff_database_items.data_type%TYPE;
908:
909: l_compare_flag VARCHAR2(2);
910: l_etp_cmn_flag VARCHAR2(2);

Line 1372: l_archive_item_id ff_archive_items.archive_item_id%TYPE;

1368: AND fue.legislation_code = 'AU';
1369:
1370: l_procedure VARCHAR2(80);
1371: l_user_entity_id ff_user_entities.user_entity_id%TYPE;
1372: l_archive_item_id ff_archive_items.archive_item_id%TYPE;
1373: l_object_version_number ff_archive_items.object_version_number%type;
1374: l_some_warning boolean;
1375:
1376: e_ue_missing EXCEPTION;

Line 1373: l_object_version_number ff_archive_items.object_version_number%type;

1369:
1370: l_procedure VARCHAR2(80);
1371: l_user_entity_id ff_user_entities.user_entity_id%TYPE;
1372: l_archive_item_id ff_archive_items.archive_item_id%TYPE;
1373: l_object_version_number ff_archive_items.object_version_number%type;
1374: l_some_warning boolean;
1375:
1376: e_ue_missing EXCEPTION;
1377:

Line 1500: FROM ff_archive_items fai,

1496: CURSOR get_archive_item_count(c_archive_action_id pay_assignment_actions.assignment_action_id%TYPE
1497: ,c_context_id ff_contexts.context_id%TYPE)
1498: IS
1499: SELECT COUNT(*)
1500: FROM ff_archive_items fai,
1501: ff_user_entities fue,
1502: ff_archive_item_contexts faic
1503: WHERE fai.context1 = c_archive_action_id
1504: AND fue.user_entity_id = fai.user_entity_id