APPS.PAY_CA_T4A_CANCEL_MAG dependencies on FF_ARCHIVE_ITEMS

Line 460: FROM ff_archive_items fai,

456:
457: CURSOR cur_archive (b_context_id IN NUMBER,
458: b_user_name VARCHAR2) IS
459: SELECT fai.value
460: FROM ff_archive_items fai,
461: ff_database_items fdi
462: WHERE fai.user_entity_id = fdi.user_entity_id
463: AND fai.context1 = b_context_id
464: AND fdi.user_name = b_user_name;

Line 656: l_context1 ff_archive_items.context1%TYPE;

652: BEGIN
653: DECLARE
654:
655: l_final_xml VARCHAR2(32000);
656: l_context1 ff_archive_items.context1%TYPE;
657: EOL VARCHAR2(5) := fnd_global.local_chr(13)
658: || fnd_global.local_chr(10);
659: l_return VARCHAR2(240);
660: l_status BOOLEAN := TRUE;

Line 927: l_context1 ff_archive_items.context1%TYPE;

923: PROCEDURE t4a_cancel_employer_record is
924: BEGIN
925: DECLARE
926: l_final_xml_string VARCHAR2(32000);
927: l_context1 ff_archive_items.context1%TYPE;
928: l_return VARCHAR2(240);
929: EOL varchar2(5) := fnd_global.local_chr(13) || fnd_global.local_chr(10);
930: l_transfer_pact_id VARCHAR2(15);
931: l_transfer_tax_unit_id VARCHAR2(10);