The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
P.BASE_CURRENCY_CODE,
C.PRECISION,
C.MINIMUM_ACCOUNTABLE_UNIT,
C.DESCRIPTION
INTO BASE_CURR,PREC,MIN_AU,DESCR
FROM
AP_SYSTEM_PARAMETERS P,
FND_CURRENCIES C
WHERE P.BASE_CURRENCY_CODE = C.CURRENCY_CODE;
SELECT
LY.MEANING,
LN.MEANING,
L1.DISPLAYED_FIELD,
L2.DISPLAYED_FIELD,
L3.DISPLAYED_FIELD
INTO NLS_YES,NLS_NO,NLS_ALL,NLS_VOID,NLS_NA
FROM
FND_LOOKUPS LY,
FND_LOOKUPS LN,
AP_LOOKUP_CODES L1,
AP_LOOKUP_CODES L2,
AP_LOOKUP_CODES L3
WHERE LY.LOOKUP_TYPE = 'YES_NO'
AND LY.LOOKUP_CODE = 'Y'
AND LN.LOOKUP_TYPE = 'YES_NO'
AND LN.LOOKUP_CODE = 'N'
AND L1.LOOKUP_TYPE = 'NLS REPORT PARAMETER'
AND L1.LOOKUP_CODE = 'ALL'
AND L2.LOOKUP_TYPE = 'NLS TRANSLATION'
AND L2.LOOKUP_CODE = 'VOID'
AND L3.LOOKUP_TYPE = 'NLS REPORT PARAMETER'
AND L3.LOOKUP_CODE = 'NA';
IF (AP_EMPLOYEE_UPDATE_PKG.UPDATE_EMPLOYEE(C_UPDATE_DATE
,P_FROM_SUPPLIER
,P_TO_SUPPLIER
,P_BUSINESS_GROUP_ID --bug 14353622
,P_DEBUG_SWITCH
,'After Report Trigger') <> TRUE) THEN
RAISE INIT_FAILURE;
,'AP_EMPLOYEE_UPDATE_PKG.Update_Employee')*/NULL;
SELECT
NAME,
CHART_OF_ACCOUNTS_ID
INTO L_NAME,L_CHART_OF_ACCOUNTS_ID
FROM
GL_SETS_OF_BOOKS
WHERE SET_OF_BOOKS_ID = L_SOB_ID;
SELECT
MAX(REQUESTED_START_DATE)
INTO L_REQUESTED_START_DATE
FROM
FND_CONCURRENT_PROGRAMS FCONC,
FND_CONCURRENT_REQUESTS FREQ
WHERE FCONC.APPLICATION_ID = FREQ.PROGRAM_APPLICATION_ID
AND FCONC.CONCURRENT_PROGRAM_ID = FREQ.CONCURRENT_PROGRAM_ID
AND FCONC.CONCURRENT_PROGRAM_NAME = 'APXHRUPD'
AND FREQ.STATUS_CODE = 'C';
C_UPDATE_DATE := NULL;
C_UPDATE_DATE := NVL(L_REQUESTED_START_DATE
,TO_DATE('01/01/1951'
,'DD/MM/YYYY'));
,'C_Update Date: ' || C_UPDATE_DATE)*/NULL;
FUNCTION C_DUPLICATE_YES_NOFORMULA(UPDATED_VALUE IN VARCHAR2
,UPDATED_TO IN VARCHAR2) RETURN VARCHAR2 IS
L_DUPLICATES VARCHAR2(1);
/*SRW.REFERENCE(UPDATED_VALUE)*/NULL;
IF UPDATED_VALUE = 'Name' THEN
BEGIN
SELECT
'Y'
INTO L_DUPLICATES
FROM
DUAL
WHERE EXISTS (
SELECT
'Duplicates exist in Po_Vendors'
FROM
AP_SUPPLIERS
WHERE VENDOR_NAME = UPDATED_TO );
SELECT
COUNT(PERSON_ID)
INTO L_COUNT
FROM
PER_ALL_PEOPLE_F PPF
WHERE TRUNC(SYSDATE) between PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE
AND DECODE(PPF.MIDDLE_NAMES
,NULL
,PPF.LAST_NAME || ', ' || PPF.FIRST_NAME
,PPF.LAST_NAME || ', ' || PPF.FIRST_NAME || ' ' || PPF.MIDDLE_NAMES) = UPDATED_TO;
C_NAME_UPDATE_DATE := ' ';
C_INACTIVE_UPDATE_DATE := ' ';
C_HOME_UPDATE_DATE := ' ';
C_OFFICE_UPDATE_DATE := ' ';
C_NAME_UPDATE_DATE := ' and ppf.last_update_date > ' || '''' || C_UPDATE_DATE || '''';
C_INACTIVE_UPDATE_DATE := ' and ppos.last_update_date > ' || '''' || C_UPDATE_DATE || '''';
C_HOME_UPDATE_DATE := ' and pa1.last_update_date > ' || '''' || C_UPDATE_DATE || '''';
C_OFFICE_UPDATE_DATE := ' and (trunc(paf.last_update_date) >= ' || '''' || C_UPDATE_DATE || '''' || ' OR ' || 'trunc(locs.last_update_date) >= ' || '''' || C_UPDATE_DATE || '''' || ')';
,'C_name_update_date: ' || C_NAME_UPDATE_DATE)*/NULL;
,'C_inactive_update_date: ' || C_INACTIVE_UPDATE_DATE)*/NULL;
,'C_home_update_date: ' || C_HOME_UPDATE_DATE)*/NULL;
,'C_office_update_date: ' || C_OFFICE_UPDATE_DATE)*/NULL;
FUNCTION C_NAME_UPDATE_DATE_P RETURN VARCHAR2 IS
BEGIN
RETURN C_NAME_UPDATE_DATE;
END C_NAME_UPDATE_DATE_P;
FUNCTION C_INACTIVE_UPDATE_DATE_P RETURN VARCHAR2 IS
BEGIN
RETURN C_INACTIVE_UPDATE_DATE;
END C_INACTIVE_UPDATE_DATE_P;
FUNCTION C_HOME_UPDATE_DATE_P RETURN VARCHAR2 IS
BEGIN
RETURN C_HOME_UPDATE_DATE;
END C_HOME_UPDATE_DATE_P;
FUNCTION C_OFFICE_UPDATE_DATE_P RETURN VARCHAR2 IS
BEGIN
RETURN C_OFFICE_UPDATE_DATE;
END C_OFFICE_UPDATE_DATE_P;