You can use API HR_PERSON_API.DELETE_PERSON to delete an employee(person) and the associated person related records. Example: DECLARE — Input Variables l_validate BOOLEAN := FALSE; l_effective_date… Read More »API to Purge/Delete Employee from HRMS application
Generally we use FND_REQUEST.SUBMIT_REQUEST to submit a concurrent program using a PL/SQL script. But we can not attach a layout to the concurrent request using… Read More »How to submitt XMLP Report using a PL/SQL Script
Global temporary table is also a similar table like normal Oracle table but the data in this table is session restricted. Such that data inserted… Read More »Global Temporary Tables in Oracle
We can not place any DML statement inside a function simply and also a function with a DML statement cannot be used inside a SELECT… Read More »How to use DML Statements in a Function
We can submit a concurrent request from backend using fnd_request.submit_request API. Before submitting the API we need to set the environment context using fnd_global.apps_initialize 1… Read More »PL/SQL Script to Submit a Concurrent Request from backend
What are Oracle Alerts? Oracle Alert facilitates the flow of information within your organization by letting you create entities called alerts to monitor your business… Read More »FAQs on Oracle Alerts
We can not only create a concurrent program from backend but also assign the concurrent program to a Request Group by FND_PROGRAM.ADD_TO_GROUP api, below is… Read More »PL/SQL Script to Add a Concurrent Program to a Request Group from backend
We need to use FND_PROGRAM.PARAMETER api to create an concurrent program parameter from backend database, below is the sample script. Creating the Concurrent Program Parameter… Read More »PL/SQL Script to Create a Concurrent Program Parameter from backend
We need to use FND_PROGRAM.REGISTER api to create an concurrent program from backend database, below is the sample script. Creating the Concurrent Program from backend:… Read More »PL/SQL Script to Create a Concurrent Program from backend
We need to use FND_PROGRAM.EXECUTABLE api to create an executable from backend database, below is the sample script. Creating the Executable from backed: /************************************************** *PURPOSE:… Read More »PL/SQL Script to Create an Executable from backend