Search Results validate_process_date

Overview

APPS.PAY_GB_BACS_TAPE is a United Kingdom legislative payroll package that produces the magnetic tape and file formats required for the Bankers' Automated Clearing System (BACS). BACS is the UK inter-bank clearing mechanism through which employee net pay, creditor payments, and direct debits are transmitted to the banking network. The package body encapsulates the record-layout logic for the BACS submission: header records, volume and file labels, payment (debit) and receipt (credit) detail records, and trailer totals.

The package is driven by the PYUGEN concurrent program, which creates the payroll action for the magnetic tape process and its associated assignment actions. The first call passes the payroll_action_id; subsequent parameters populate the appropriate columns on PAY_PAYROLL_ACTIONS, while legislative parameters (for example SUBMISSION_NUMBER, MEDIA, OVERRIDE_DD_DATE, EXPIRATION_DATE, and MULTI_DAY) are held in the legislative parameter column using their token identifiers. This design allows a single payroll action to carry the full set of BACS submission attributes needed for tape generation.

Key Procedures and Functions

• AND — Documented routine within the package; it supports conditional logic used during BACS tape processing. The packaged body retains this because the BACS source contains compound condition handling.
• NEW_FORMULA — Handles formula creation for the payroll action, supporting the legislative calculation and validation framework that BACS processing relies on.
• GET_PROCESS_DATE — The routine associated with the user's search term. It resolves the effective processing date used for the BACS run, which determines the tape cut-off and the date stamped into the BACS header. This value derives from the override direct-debit date or the end-of-period date supplied through the payroll action.
• VALIDATE_PROCESS_DATE — Validates the resolved processing date against payroll and time-period rules, ensuring the BACS submission date falls within acceptable banking and payroll windows before tape output proceeds.
• F_GET_EFT_RECON_DATA — A function returning electronic funds transfer reconciliation data, used to reconcile BACS payments against the payment records produced by the run.

Tables Accessed

The package reads and writes a defined set of APPS synonyms. PAY_PAYROLL_ACTIONS stores the action record and receives the parameter values described above. PAY_ASSIGNMENT_ACTIONS and PAY_ACTION_INTERLOCKS drive the assignment-level processing that PYUGEN sets up. PAY_PRE_PAYMENTS, PAY_RUN_RESULTS, and PAY_RUN_RESULT_VALUES provide the payment amounts and values written to the tape. PAY_PERSONAL_PAYMENT_METHODS_F, PAY_ORG_PAYMENT_METHODS_F, PAY_PAYMENT_TYPES, and PAY_EXTERNAL_ACCOUNTS supply bank account, sort code, and payment-type details. PER_TIME_PERIODS and FND_SESSIONS support period and session context; FF_FORMULAS_F, FND_ID_FLEX_STRUCTURES, and HR_SOFT_CODING_KEYFLEX support formula and key flexfield derivation.

Usage Notes

PAY_GB_BACS_TAPE is invoked indirectly rather than from a form. The standard route is the PYUGEN concurrent program, which initiates the magnetic tape payroll action and calls the package to format the BACS output. It is not referenced by any other documented package, so customisations that need BACS formatting should call it through the same payroll action mechanism. Custom code invoking GET_PROCESS_DATE or VALIDATE_PROCESS_DATE directly should supply the payroll action context already established by PYUGEN. The package applies to Oracle EBS 12.1.1 and 12.2.2; behaviour is governed by the legislative parameters stored on the payroll action.