Results for “p_org_hierarchy”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.PAY_GB_P11D_PDF_CONTROL is a United Kingdom localization package within the Oracle E-Business Suite Payroll module. Its principal business function is to govern the generation of P11D-related PDF output for UK statutory end-of-year reporting. P11D forms report employee benefits-in-kind and expenses to HM Revenue & Customs (HMRC), and supplementary documents such as the P11D summary, an address page, and a working sheet (WS) are routinely produced alongside the core forms.
The package exposes a single documented procedure, PRINT_PDF, whose extensive parameter interface reflects the range of user selections required for this reporting: flags controlling whether the address page, P11D forms, P11D summary, and working sheet are produced; identification parameters for payroll action, organization, business group, and assignment; hierarchy, assignment set, location, and person type filters; sorting options; and output-control parameters covering an output folder profile, records per file, and chunk size. This combination indicates the procedure both drives report content selection and manages how the resulting PDF artefacts are assembled and partitioned.
Key Procedures and Functions
- PRINT_PDF — The sole documented procedure in the package. Its purpose is to produce the PDF output for the UK P11D process, accepting control flags that determine which components (address page, P11D, P11D summary, working sheet) are printed, alongside parameters identifying the payroll action, business group, and optional organization, hierarchy, assignment set, location, assignment action, and person type. Output characteristics are controlled through profile-based output folder, records per file, and chunk size parameters, and result rows can be ordered through two sort-order parameters. The procedure follows the standard concurrent-program entry point convention of returning errbuf and retcode to the caller.
Tables Accessed
The documented metadata records only DBMS_SQL and DUAL as referenced objects via APPS synonyms. DUAL confirms that the procedure performs value computations, validations, or lookups independent of application data tables. DBMS_SQL indicates that PRINT_PDF builds and executes dynamic SQL, which is consistent with a reporting routine whose data extraction depends on the selection and filter parameters passed at runtime — the actual payroll and assignment queries are constructed dynamically rather than compiled as static cursor definitions. Because the dynamic statements are not visible in the package specification metadata, the underlying payroll, assignment, and person tables read at runtime are not enumerated here.
Usage Notes
PAY_GB_P11D_PDF_CONTROL is an internal localization controller rather than a general-purpose payroll API. In Oracle EBS 12.1.1 and 12.2.2 it is typically invoked from the concurrent program infrastructure that drives the UK P11D reporting process, with the standard errbuf/retcode signatures aligned to concurrent manager expectations. The print flags and filter parameters map directly to the selection screen of the corresponding concurrent program, so the caller supplies them from report parameters rather than from interactive form logic.
No other packages reference this package per the documented metadata, meaning it sits at the leaf of the dependency chain and is called by the concurrent program definition or a thin localization driver. The chunk size and records per file parameters are significant where very large payroll populations must be split across multiple physical PDF files to avoid size and performance limits. Any custom extension should call PRINT_PDF through the same concurrent program interface rather than by direct invocation, preserving the parameter defaults and the folder-profile resolution expected by the localized output stage.