APPS.FF_ARCHIVE_API dependencies on PAY_REPORT_FORMAT_ITEMS_F

Line 297: from pay_report_format_items_f prfi

293: --
294: cursor get_format_item (c_user_entity_id number) is
295: select 1 from dual where exists
296: (select prfi.archive_type
297: from pay_report_format_items_f prfi
298: where prfi.user_entity_id = c_user_entity_id);
299: --
300: l_proc varchar2(72) := g_package||'create_archive_item';
301: invalid_archive_type exception;

Line 315: -- exists a row in PAY_REPORT_FORMAT_ITEMS_F for this user entity.

311: -- Validation in addition to Row Handlers
312: --
313: --1)Is the parameterised or defaulted archive type in the set
314: -- 'AAC','AAP','PA'. Error if not. If so, check whether there
315: -- exists a row in PAY_REPORT_FORMAT_ITEMS_F for this user entity.
316: -- This check is only necessary for AAC and PA types, an AAP type
317: -- can be valid with no row in the format items table.
318: --
319: IF p_archive_type not in ('AAC','PA','AAP') then

Line 562: from pay_report_format_items_f prfi

558: c_user_entity_id number,
559: c_effective_date date) is
560: select prfi.updatable_flag,
561: prfi.archive_type
562: from pay_report_format_items_f prfi
563: where prfi.report_type = c_report_type
564: and prfi.report_qualifier = c_report_qualifier
565: and prfi.report_category = c_report_category
566: and prfi.user_entity_id = c_user_entity_id

Line 643: -- 2. Check the PAY_REPORT_FORMAT_ITEMS_F value of UPDATABLE_FLAG

639: close get_action_details;
640: --
641: END IF;
642: --
643: -- 2. Check the PAY_REPORT_FORMAT_ITEMS_F value of UPDATABLE_FLAG
644: -- and ARCHIVE_TYPE given this USER_ENTITY_ID and other
645: -- report information from the payroll action.
646: --
647: open get_report_details(l_payroll_action_id);

Line 669: -- row exists in pay_report_format_items_f, as this defaults

665:
666: IF l_updatable_flag = 'N' OR l_updatable_flag IS NULL OR l_fi_archive_type <> 'AAP' THEN
667: --
668: -- Cannot Update, raise error if 'N' for update, OR no
669: -- row exists in pay_report_format_items_f, as this defaults
670: -- to non-updatable where there is no row.
671: --
672: raise cannot_update_item;
673: --

Line 678: -- in PAY_REPORT_FORMAT_ITEMS_F to reach this point.

674: END IF;
675: --
676: -- 3. Check the PAY_REPORT_FORMAT_MAPPINGS_F's value of UPDATABLE_FLAG,
677: -- given the information retrieved above. There will be a link value
678: -- in PAY_REPORT_FORMAT_ITEMS_F to reach this point.
679: --
680: open get_format_mapping(l_report_type,l_report_qualifier,
681: l_report_category, p_effective_date);
682: fetch get_format_mapping into l_mapping_updatable_flag;