[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure INSERT_ROW (
X_ROWID in out NOCOPY VARCHAR2,
X_RESOURCE_AUDIT_ID in NUMBER,
X_RESOURCE_ID in NUMBER,
X_NEW_CATEGORY in VARCHAR2,
X_OLD_CATEGORY in VARCHAR2,
X_NEW_RESOURCE_NUMBER in VARCHAR2,
X_OLD_RESOURCE_NUMBER in VARCHAR2,
X_NEW_SOURCE_ID in NUMBER,
X_OLD_SOURCE_ID in NUMBER,
X_NEW_ADDRESS_ID in NUMBER,
X_OLD_ADDRESS_ID in NUMBER,
X_NEW_CONTACT_ID in NUMBER,
X_OLD_CONTACT_ID in NUMBER,
X_NEW_MANAGING_EMPLOYEE_ID in NUMBER,
X_OLD_MANAGING_EMPLOYEE_ID in NUMBER,
X_OLD_START_DATE_ACTIVE in DATE,
X_NEW_START_DATE_ACTIVE in DATE,
X_OLD_END_DATE_ACTIVE in DATE,
X_NEW_END_DATE_ACTIVE in DATE,
X_NEW_TIME_ZONE in NUMBER,
X_OLD_TIME_ZONE in NUMBER,
X_NEW_COST_PER_HR in NUMBER,
X_OLD_COST_PER_HR in NUMBER,
X_NEW_PRIMARY_LANGUAGE in VARCHAR2,
X_OLD_PRIMARY_LANGUAGE in VARCHAR2,
X_NEW_SECONDARY_LANGUAGE in VARCHAR2,
X_OLD_SECONDARY_LANGUAGE in VARCHAR2,
X_NEW_SUPPORT_SITE_ID in NUMBER,
X_OLD_SUPPORT_SITE_ID in NUMBER,
X_NEW_IES_AGENT_LOGIN in VARCHAR2,
X_OLD_IES_AGENT_LOGIN in VARCHAR2,
X_NEW_SERVER_GROUP_ID in NUMBER,
X_OLD_SERVER_GROUP_ID in NUMBER,
X_NEW_ASSIGNED_TO_GROUP_ID in NUMBER,
X_OLD_ASSIGNED_TO_GROUP_ID in NUMBER,
X_NEW_COST_CENTER in VARCHAR2,
X_OLD_COST_CENTER in VARCHAR2,
X_NEW_CHARGE_TO_COST_CENTER in VARCHAR2,
X_OLD_CHARGE_TO_COST_CENTER in VARCHAR2,
X_NEW_COMPENSATION_CURRENCY_CO in VARCHAR2,
X_OLD_COMPENSATION_CURRENCY_CO in VARCHAR2,
X_NEW_COMMISSIONABLE_FLAG in VARCHAR2,
X_OLD_COMMISSIONABLE_FLAG in VARCHAR2,
X_NEW_HOLD_REASON_CODE in VARCHAR2,
X_OLD_HOLD_REASON_CODE in VARCHAR2,
X_NEW_HOLD_PAYMENT in VARCHAR2,
X_OLD_HOLD_PAYMENT in VARCHAR2,
X_NEW_COMP_SERVICE_TEAM_ID in NUMBER,
X_OLD_COMP_SERVICE_TEAM_ID in NUMBER,
X_NEW_TRANSACTION_NUMBER in NUMBER,
X_OLD_TRANSACTION_NUMBER in NUMBER,
X_NEW_OBJECT_VERSION_NUMBER in NUMBER,
X_OLD_OBJECT_VERSION_NUMBER in NUMBER,
X_NEW_USER_ID in NUMBER,
X_OLD_USER_ID in NUMBER,
--X_OLD_LOCATION in MDSYS.SDO_GEOMETRY,
--X_NEW_LOCATION in MDSYS.SDO_GEOMETRY,
X_CREATION_DATE in DATE,
X_CREATED_BY in NUMBER,
X_LAST_UPDATE_DATE in DATE,
X_LAST_UPDATED_BY in NUMBER,
X_LAST_UPDATE_LOGIN in NUMBER,
X_NEW_RESOURCE_NAME in VARCHAR2,
X_OLD_RESOURCE_NAME in VARCHAR2,
X_NEW_SOURCE_NAME in VARCHAR2,
X_OLD_SOURCE_NAME in VARCHAR2,
X_NEW_SOURCE_NUMBER in VARCHAR2,
X_OLD_SOURCE_NUMBER in VARCHAR2,
X_NEW_SOURCE_JOB_TITLE in VARCHAR2,
X_OLD_SOURCE_JOB_TITLE in VARCHAR2,
X_NEW_SOURCE_EMAIL in VARCHAR2,
X_OLD_SOURCE_EMAIL in VARCHAR2,
X_NEW_SOURCE_PHONE in VARCHAR2,
X_OLD_SOURCE_PHONE in VARCHAR2,
X_NEW_SOURCE_ORG_ID in NUMBER,
X_OLD_SOURCE_ORG_ID in NUMBER,
X_NEW_SOURCE_ORG_NAME in VARCHAR2,
X_OLD_SOURCE_ORG_NAME in VARCHAR2,
X_NEW_SOURCE_ADDRESS1 in VARCHAR2,
X_OLD_SOURCE_ADDRESS1 in VARCHAR2,
X_NEW_SOURCE_ADDRESS2 in VARCHAR2,
X_OLD_SOURCE_ADDRESS2 in VARCHAR2,
X_NEW_SOURCE_ADDRESS3 in VARCHAR2,
X_OLD_SOURCE_ADDRESS3 in VARCHAR2,
X_NEW_SOURCE_ADDRESS4 in VARCHAR2,
X_OLD_SOURCE_ADDRESS4 in VARCHAR2,
X_NEW_SOURCE_CITY in VARCHAR2,
X_OLD_SOURCE_CITY in VARCHAR2,
X_NEW_SOURCE_POSTAL_CODE in VARCHAR2,
X_OLD_SOURCE_POSTAL_CODE in VARCHAR2,
X_NEW_SOURCE_STATE in VARCHAR2,
X_OLD_SOURCE_STATE in VARCHAR2,
X_NEW_SOURCE_PROVINCE in VARCHAR2,
X_OLD_SOURCE_PROVINCE in VARCHAR2,
X_NEW_SOURCE_COUNTY in VARCHAR2,
X_OLD_SOURCE_COUNTY in VARCHAR2,
X_NEW_SOURCE_COUNTRY in VARCHAR2,
X_OLD_SOURCE_COUNTRY in VARCHAR2,
X_NEW_SOURCE_MGR_ID in NUMBER,
X_OLD_SOURCE_MGR_ID in NUMBER,
X_NEW_SOURCE_MGR_NAME in VARCHAR2,
X_OLD_SOURCE_MGR_NAME in VARCHAR2,
X_NEW_SOURCE_BUSINESS_GRP_ID in NUMBER,
X_OLD_SOURCE_BUSINESS_GRP_ID in NUMBER,
X_NEW_SOURCE_BUSINESS_GRP_NAME in VARCHAR2,
X_OLD_SOURCE_BUSINESS_GRP_NAME in VARCHAR2,
X_NEW_SOURCE_FIRST_NAME in VARCHAR2,
X_OLD_SOURCE_FIRST_NAME in VARCHAR2,
X_NEW_SOURCE_MIDDLE_NAME in VARCHAR2,
X_OLD_SOURCE_MIDDLE_NAME in VARCHAR2,
X_NEW_SOURCE_LAST_NAME in VARCHAR2,
X_OLD_SOURCE_LAST_NAME in VARCHAR2,
X_NEW_SOURCE_CATEGORY in VARCHAR2,
X_OLD_SOURCE_CATEGORY in VARCHAR2,
X_NEW_SOURCE_STATUS in VARCHAR2,
X_OLD_SOURCE_STATUS in VARCHAR2,
X_NEW_SOURCE_OFFICE in VARCHAR2,
X_OLD_SOURCE_OFFICE in VARCHAR2,
X_NEW_SOURCE_LOCATION in VARCHAR2,
X_OLD_SOURCE_LOCATION in VARCHAR2,
X_NEW_SOURCE_MAILSTOP in VARCHAR2,
X_OLD_SOURCE_MAILSTOP in VARCHAR2,
X_NEW_USER_NAME in VARCHAR2,
X_OLD_USER_NAME in VARCHAR2,
X_NEW_SOURCE_JOB_ID in VARCHAR2,
X_OLD_SOURCE_JOB_ID in VARCHAR2,
X_NEW_PARTY_ID in VARCHAR2,
X_OLD_PARTY_ID in VARCHAR2,
X_NEW_SOURCE_MOBILE_PHONE in VARCHAR2,
X_OLD_SOURCE_MOBILE_PHONE in VARCHAR2,
X_NEW_SOURCE_PAGER in VARCHAR2,
X_OLD_SOURCE_PAGER in VARCHAR2
) is
cursor C is select ROWID from JTF_RS_RESOURCE_EXTN_AUD
where RESOURCE_AUDIT_ID = X_RESOURCE_AUDIT_ID
;
insert into JTF_RS_RESOURCE_EXTN_AUD (
RESOURCE_AUDIT_ID,
RESOURCE_ID,
NEW_CATEGORY,
OLD_CATEGORY,
NEW_RESOURCE_NUMBER,
OLD_RESOURCE_NUMBER,
NEW_SOURCE_ID,
OLD_SOURCE_ID,
NEW_ADDRESS_ID,
OLD_ADDRESS_ID,
NEW_CONTACT_ID,
OLD_CONTACT_ID,
NEW_MANAGING_EMPLOYEE_ID,
OLD_MANAGING_EMPLOYEE_ID,
OLD_START_DATE_ACTIVE,
NEW_START_DATE_ACTIVE,
OLD_END_DATE_ACTIVE,
NEW_END_DATE_ACTIVE,
NEW_TIME_ZONE,
OLD_TIME_ZONE,
NEW_COST_PER_HR,
OLD_COST_PER_HR,
NEW_PRIMARY_LANGUAGE,
OLD_PRIMARY_LANGUAGE,
NEW_SECONDARY_LANGUAGE,
OLD_SECONDARY_LANGUAGE,
NEW_SUPPORT_SITE_ID,
OLD_SUPPORT_SITE_ID,
NEW_IES_AGENT_LOGIN,
OLD_IES_AGENT_LOGIN,
NEW_SERVER_GROUP_ID,
OLD_SERVER_GROUP_ID,
NEW_ASSIGNED_TO_GROUP_ID,
OLD_ASSIGNED_TO_GROUP_ID,
NEW_COST_CENTER,
OLD_COST_CENTER,
NEW_CHARGE_TO_COST_CENTER,
OLD_CHARGE_TO_COST_CENTER,
NEW_COMPENSATION_CURRENCY_CODE,
OLD_COMPENSATION_CURRENCY_CODE,
NEW_COMMISSIONABLE_FLAG,
OLD_COMMISSIONABLE_FLAG,
NEW_HOLD_REASON_CODE,
OLD_HOLD_REASON_CODE,
NEW_HOLD_PAYMENT,
OLD_HOLD_PAYMENT,
NEW_COMP_SERVICE_TEAM_ID,
OLD_COMP_SERVICE_TEAM_ID,
NEW_TRANSACTION_NUMBER,
OLD_TRANSACTION_NUMBER,
NEW_OBJECT_VERSION_NUMBER,
OLD_OBJECT_VERSION_NUMBER,
NEW_USER_ID,
OLD_USER_ID,
--OLD_LOCATION,
-- NEW_LOCATION,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
NEW_RESOURCE_NAME ,
OLD_RESOURCE_NAME ,
NEW_SOURCE_NAME ,
OLD_SOURCE_NAME ,
NEW_SOURCE_NUMBER ,
OLD_SOURCE_NUMBER ,
NEW_SOURCE_JOB_TITLE ,
OLD_SOURCE_JOB_TITLE ,
NEW_SOURCE_EMAIL ,
OLD_SOURCE_EMAIL ,
NEW_SOURCE_PHONE ,
OLD_SOURCE_PHONE ,
NEW_SOURCE_ORG_ID ,
OLD_SOURCE_ORG_ID ,
NEW_SOURCE_ORG_NAME ,
OLD_SOURCE_ORG_NAME ,
NEW_SOURCE_ADDRESS1 ,
OLD_SOURCE_ADDRESS1 ,
NEW_SOURCE_ADDRESS2 ,
OLD_SOURCE_ADDRESS2 ,
NEW_SOURCE_ADDRESS3 ,
OLD_SOURCE_ADDRESS3 ,
NEW_SOURCE_ADDRESS4 ,
OLD_SOURCE_ADDRESS4 ,
NEW_SOURCE_CITY ,
OLD_SOURCE_CITY ,
NEW_SOURCE_POSTAL_CODE ,
OLD_SOURCE_POSTAL_CODE ,
NEW_SOURCE_STATE ,
OLD_SOURCE_STATE ,
NEW_SOURCE_PROVINCE ,
OLD_SOURCE_PROVINCE ,
NEW_SOURCE_COUNTY ,
OLD_SOURCE_COUNTY ,
NEW_SOURCE_COUNTRY ,
OLD_SOURCE_COUNTRY,
NEW_SOURCE_MGR_ID,
OLD_SOURCE_MGR_ID,
NEW_SOURCE_MGR_NAME,
OLD_SOURCE_MGR_NAME,
NEW_SOURCE_BUSINESS_GRP_ID,
OLD_SOURCE_BUSINESS_GRP_ID,
NEW_SOURCE_BUSINESS_GRP_NAME,
OLD_SOURCE_BUSINESS_GRP_NAME,
NEW_SOURCE_FIRST_NAME ,
OLD_SOURCE_FIRST_NAME,
NEW_SOURCE_LAST_NAME ,
OLD_SOURCE_LAST_NAME,
NEW_SOURCE_MIDDLE_NAME,
OLD_SOURCE_MIDDLE_NAME ,
NEW_SOURCE_CATEGORY ,
OLD_SOURCE_CATEGORY ,
NEW_SOURCE_STATUS ,
OLD_SOURCE_STATUS ,
NEW_SOURCE_OFFICE,
OLD_SOURCE_OFFICE,
NEW_SOURCE_LOCATION,
OLD_SOURCE_LOCATION,
NEW_SOURCE_MAILSTOP,
OLD_SOURCE_MAILSTOP,
NEW_USER_NAME,
OLD_USER_NAME,
NEW_SOURCE_JOB_ID,
OLD_SOURCE_JOB_ID,
NEW_PARTY_ID,
OLD_PARTY_ID,
NEW_SOURCE_MOBILE_PHONE,
OLD_SOURCE_MOBILE_PHONE,
NEW_SOURCE_PAGER,
OLD_SOURCE_PAGER
) values (
X_RESOURCE_AUDIT_ID,
X_RESOURCE_ID,
X_NEW_CATEGORY,
X_OLD_CATEGORY,
X_NEW_RESOURCE_NUMBER,
X_OLD_RESOURCE_NUMBER,
X_NEW_SOURCE_ID,
X_OLD_SOURCE_ID,
X_NEW_ADDRESS_ID,
X_OLD_ADDRESS_ID,
X_NEW_CONTACT_ID,
X_OLD_CONTACT_ID,
X_NEW_MANAGING_EMPLOYEE_ID,
X_OLD_MANAGING_EMPLOYEE_ID,
X_OLD_START_DATE_ACTIVE,
X_NEW_START_DATE_ACTIVE,
X_OLD_END_DATE_ACTIVE,
X_NEW_END_DATE_ACTIVE,
X_NEW_TIME_ZONE,
X_OLD_TIME_ZONE,
X_NEW_COST_PER_HR,
X_OLD_COST_PER_HR,
X_NEW_PRIMARY_LANGUAGE,
X_OLD_PRIMARY_LANGUAGE,
X_NEW_SECONDARY_LANGUAGE,
X_OLD_SECONDARY_LANGUAGE,
X_NEW_SUPPORT_SITE_ID,
X_OLD_SUPPORT_SITE_ID,
X_NEW_IES_AGENT_LOGIN,
X_OLD_IES_AGENT_LOGIN,
X_NEW_SERVER_GROUP_ID,
X_OLD_SERVER_GROUP_ID,
X_NEW_ASSIGNED_TO_GROUP_ID,
X_OLD_ASSIGNED_TO_GROUP_ID,
X_NEW_COST_CENTER,
X_OLD_COST_CENTER,
X_NEW_CHARGE_TO_COST_CENTER,
X_OLD_CHARGE_TO_COST_CENTER,
X_NEW_COMPENSATION_CURRENCY_CO,
X_OLD_COMPENSATION_CURRENCY_CO,
X_NEW_COMMISSIONABLE_FLAG,
X_OLD_COMMISSIONABLE_FLAG,
X_NEW_HOLD_REASON_CODE,
X_OLD_HOLD_REASON_CODE,
X_NEW_HOLD_PAYMENT,
X_OLD_HOLD_PAYMENT,
X_NEW_COMP_SERVICE_TEAM_ID,
X_OLD_COMP_SERVICE_TEAM_ID,
X_NEW_TRANSACTION_NUMBER,
X_OLD_TRANSACTION_NUMBER,
X_NEW_OBJECT_VERSION_NUMBER,
X_OLD_OBJECT_VERSION_NUMBER,
X_NEW_USER_ID,
X_OLD_USER_ID,
-- X_OLD_LOCATION,
-- X_NEW_LOCATION,
X_CREATED_BY,
X_CREATION_DATE,
X_LAST_UPDATED_BY,
X_LAST_UPDATE_DATE,
X_LAST_UPDATE_LOGIN,
X_NEW_RESOURCE_NAME ,
X_OLD_RESOURCE_NAME ,
X_NEW_SOURCE_NAME ,
X_OLD_SOURCE_NAME ,
X_NEW_SOURCE_NUMBER ,
X_OLD_SOURCE_NUMBER ,
X_NEW_SOURCE_JOB_TITLE ,
X_OLD_SOURCE_JOB_TITLE ,
X_NEW_SOURCE_EMAIL ,
X_OLD_SOURCE_EMAIL ,
X_NEW_SOURCE_PHONE ,
X_OLD_SOURCE_PHONE ,
X_NEW_SOURCE_ORG_ID ,
X_OLD_SOURCE_ORG_ID ,
X_NEW_SOURCE_ORG_NAME ,
X_OLD_SOURCE_ORG_NAME ,
X_NEW_SOURCE_ADDRESS1 ,
X_OLD_SOURCE_ADDRESS1 ,
X_NEW_SOURCE_ADDRESS2 ,
X_OLD_SOURCE_ADDRESS2 ,
X_NEW_SOURCE_ADDRESS3 ,
X_OLD_SOURCE_ADDRESS3 ,
X_NEW_SOURCE_ADDRESS4 ,
X_OLD_SOURCE_ADDRESS4 ,
X_NEW_SOURCE_CITY ,
X_OLD_SOURCE_CITY ,
X_NEW_SOURCE_POSTAL_CODE ,
X_OLD_SOURCE_POSTAL_CODE ,
X_NEW_SOURCE_STATE ,
X_OLD_SOURCE_STATE ,
X_NEW_SOURCE_PROVINCE ,
X_OLD_SOURCE_PROVINCE ,
X_NEW_SOURCE_COUNTY ,
X_OLD_SOURCE_COUNTY ,
X_NEW_SOURCE_COUNTRY ,
X_OLD_SOURCE_COUNTRY ,
X_NEW_SOURCE_MGR_ID,
X_OLD_SOURCE_MGR_ID,
X_NEW_SOURCE_MGR_NAME,
X_OLD_SOURCE_MGR_NAME,
X_NEW_SOURCE_BUSINESS_GRP_ID,
X_OLD_SOURCE_BUSINESS_GRP_ID,
X_NEW_SOURCE_BUSINESS_GRP_NAME,
X_OLD_SOURCE_BUSINESS_GRP_NAME,
X_NEW_SOURCE_FIRST_NAME ,
X_OLD_SOURCE_FIRST_NAME,
X_NEW_SOURCE_LAST_NAME ,
X_OLD_SOURCE_LAST_NAME,
X_NEW_SOURCE_MIDDLE_NAME,
X_OLD_SOURCE_MIDDLE_NAME ,
X_NEW_SOURCE_CATEGORY ,
X_OLD_SOURCE_CATEGORY ,
X_NEW_SOURCE_STATUS ,
X_OLD_SOURCE_STATUS ,
X_NEW_SOURCE_OFFICE,
X_OLD_SOURCE_OFFICE,
X_NEW_SOURCE_LOCATION,
X_OLD_SOURCE_LOCATION,
X_NEW_SOURCE_MAILSTOP,
X_OLD_SOURCE_MAILSTOP,
X_NEW_USER_NAME,
X_OLD_USER_NAME,
X_NEW_SOURCE_JOB_ID,
X_OLD_SOURCE_JOB_ID,
X_NEW_PARTY_ID,
X_OLD_PARTY_ID,
X_NEW_SOURCE_MOBILE_PHONE,
X_OLD_SOURCE_MOBILE_PHONE,
X_NEW_SOURCE_PAGER,
X_OLD_SOURCE_PAGER
);
end INSERT_ROW;
cursor c1 is select
RESOURCE_ID,
NEW_CATEGORY,
OLD_CATEGORY,
NEW_RESOURCE_NUMBER,
OLD_RESOURCE_NUMBER,
NEW_SOURCE_ID,
OLD_SOURCE_ID,
NEW_ADDRESS_ID,
OLD_ADDRESS_ID,
NEW_CONTACT_ID,
OLD_CONTACT_ID,
NEW_MANAGING_EMPLOYEE_ID,
OLD_MANAGING_EMPLOYEE_ID,
OLD_START_DATE_ACTIVE,
NEW_START_DATE_ACTIVE,
OLD_END_DATE_ACTIVE,
NEW_END_DATE_ACTIVE,
NEW_TIME_ZONE,
OLD_TIME_ZONE,
NEW_COST_PER_HR,
OLD_COST_PER_HR,
NEW_PRIMARY_LANGUAGE,
OLD_PRIMARY_LANGUAGE,
NEW_SECONDARY_LANGUAGE,
OLD_SECONDARY_LANGUAGE,
NEW_SUPPORT_SITE_ID,
OLD_SUPPORT_SITE_ID,
NEW_IES_AGENT_LOGIN,
OLD_IES_AGENT_LOGIN,
NEW_SERVER_GROUP_ID,
OLD_SERVER_GROUP_ID,
NEW_ASSIGNED_TO_GROUP_ID,
OLD_ASSIGNED_TO_GROUP_ID,
NEW_COST_CENTER,
OLD_COST_CENTER,
NEW_CHARGE_TO_COST_CENTER,
OLD_CHARGE_TO_COST_CENTER,
NEW_COMPENSATION_CURRENCY_CODE,
OLD_COMPENSATION_CURRENCY_CODE,
NEW_COMMISSIONABLE_FLAG,
OLD_COMMISSIONABLE_FLAG,
NEW_HOLD_REASON_CODE,
OLD_HOLD_REASON_CODE,
NEW_HOLD_PAYMENT,
OLD_HOLD_PAYMENT,
NEW_COMP_SERVICE_TEAM_ID,
OLD_COMP_SERVICE_TEAM_ID,
NEW_TRANSACTION_NUMBER,
OLD_TRANSACTION_NUMBER,
NEW_OBJECT_VERSION_NUMBER,
OLD_OBJECT_VERSION_NUMBER,
NEW_USER_ID,
OLD_USER_ID
--OLD_LOCATION,
--NEW_LOCATION
from JTF_RS_RESOURCE_EXTN_AUD
where RESOURCE_AUDIT_ID = X_RESOURCE_AUDIT_ID
for update of RESOURCE_AUDIT_ID nowait;
fnd_message.set_name('FND','FORM_RECORD_DELETED');
procedure UPDATE_ROW (
X_RESOURCE_AUDIT_ID in NUMBER,
X_RESOURCE_ID in NUMBER,
X_NEW_CATEGORY in VARCHAR2,
X_OLD_CATEGORY in VARCHAR2,
X_NEW_RESOURCE_NUMBER in VARCHAR2,
X_OLD_RESOURCE_NUMBER in VARCHAR2,
X_NEW_SOURCE_ID in NUMBER,
X_OLD_SOURCE_ID in NUMBER,
X_NEW_ADDRESS_ID in NUMBER,
X_OLD_ADDRESS_ID in NUMBER,
X_NEW_CONTACT_ID in NUMBER,
X_OLD_CONTACT_ID in NUMBER,
X_NEW_MANAGING_EMPLOYEE_ID in NUMBER,
X_OLD_MANAGING_EMPLOYEE_ID in NUMBER,
X_OLD_START_DATE_ACTIVE in DATE,
X_NEW_START_DATE_ACTIVE in DATE,
X_OLD_END_DATE_ACTIVE in DATE,
X_NEW_END_DATE_ACTIVE in DATE,
X_NEW_TIME_ZONE in NUMBER,
X_OLD_TIME_ZONE in NUMBER,
X_NEW_COST_PER_HR in NUMBER,
X_OLD_COST_PER_HR in NUMBER,
X_NEW_PRIMARY_LANGUAGE in VARCHAR2,
X_OLD_PRIMARY_LANGUAGE in VARCHAR2,
X_NEW_SECONDARY_LANGUAGE in VARCHAR2,
X_OLD_SECONDARY_LANGUAGE in VARCHAR2,
X_NEW_SUPPORT_SITE_ID in NUMBER,
X_OLD_SUPPORT_SITE_ID in NUMBER,
X_NEW_IES_AGENT_LOGIN in VARCHAR2,
X_OLD_IES_AGENT_LOGIN in VARCHAR2,
X_NEW_SERVER_GROUP_ID in NUMBER,
X_OLD_SERVER_GROUP_ID in NUMBER,
X_NEW_ASSIGNED_TO_GROUP_ID in NUMBER,
X_OLD_ASSIGNED_TO_GROUP_ID in NUMBER,
X_NEW_COST_CENTER in VARCHAR2,
X_OLD_COST_CENTER in VARCHAR2,
X_NEW_CHARGE_TO_COST_CENTER in VARCHAR2,
X_OLD_CHARGE_TO_COST_CENTER in VARCHAR2,
X_NEW_COMPENSATION_CURRENCY_CO in VARCHAR2,
X_OLD_COMPENSATION_CURRENCY_CO in VARCHAR2,
X_NEW_COMMISSIONABLE_FLAG in VARCHAR2,
X_OLD_COMMISSIONABLE_FLAG in VARCHAR2,
X_NEW_HOLD_REASON_CODE in VARCHAR2,
X_OLD_HOLD_REASON_CODE in VARCHAR2,
X_NEW_HOLD_PAYMENT in VARCHAR2,
X_OLD_HOLD_PAYMENT in VARCHAR2,
X_NEW_COMP_SERVICE_TEAM_ID in NUMBER,
X_OLD_COMP_SERVICE_TEAM_ID in NUMBER,
X_NEW_TRANSACTION_NUMBER in NUMBER,
X_OLD_TRANSACTION_NUMBER in NUMBER,
X_NEW_OBJECT_VERSION_NUMBER in NUMBER,
X_OLD_OBJECT_VERSION_NUMBER in NUMBER,
X_NEW_USER_ID in NUMBER,
X_OLD_USER_ID in NUMBER,
--X_OLD_LOCATION in MDSYS.SDO_GEOMETRY,
--X_NEW_LOCATION in MDSYS.SDO_GEOMETRY,
X_LAST_UPDATE_DATE in DATE,
X_LAST_UPDATED_BY in NUMBER,
X_LAST_UPDATE_LOGIN in NUMBER,
X_NEW_RESOURCE_NAME in VARCHAR2,
X_OLD_RESOURCE_NAME in VARCHAR2,
X_NEW_SOURCE_NAME in VARCHAR2,
X_OLD_SOURCE_NAME in VARCHAR2,
X_NEW_SOURCE_NUMBER in VARCHAR2,
X_OLD_SOURCE_NUMBER in VARCHAR2,
X_NEW_SOURCE_JOB_TITLE in VARCHAR2,
X_OLD_SOURCE_JOB_TITLE in VARCHAR2,
X_NEW_SOURCE_EMAIL in VARCHAR2,
X_OLD_SOURCE_EMAIL in VARCHAR2,
X_NEW_SOURCE_PHONE in VARCHAR2,
X_OLD_SOURCE_PHONE in VARCHAR2,
X_NEW_SOURCE_ORG_ID in NUMBER,
X_OLD_SOURCE_ORG_ID in NUMBER,
X_NEW_SOURCE_ORG_NAME in VARCHAR2,
X_OLD_SOURCE_ORG_NAME in VARCHAR2,
X_NEW_SOURCE_ADDRESS1 in VARCHAR2,
X_OLD_SOURCE_ADDRESS1 in VARCHAR2,
X_NEW_SOURCE_ADDRESS2 in VARCHAR2,
X_OLD_SOURCE_ADDRESS2 in VARCHAR2,
X_NEW_SOURCE_ADDRESS3 in VARCHAR2,
X_OLD_SOURCE_ADDRESS3 in VARCHAR2,
X_NEW_SOURCE_ADDRESS4 in VARCHAR2,
X_OLD_SOURCE_ADDRESS4 in VARCHAR2,
X_NEW_SOURCE_CITY in VARCHAR2,
X_OLD_SOURCE_CITY in VARCHAR2,
X_NEW_SOURCE_POSTAL_CODE in VARCHAR2,
X_OLD_SOURCE_POSTAL_CODE in VARCHAR2,
X_NEW_SOURCE_STATE in VARCHAR2,
X_OLD_SOURCE_STATE in VARCHAR2,
X_NEW_SOURCE_PROVINCE in VARCHAR2,
X_OLD_SOURCE_PROVINCE in VARCHAR2,
X_NEW_SOURCE_COUNTY in VARCHAR2,
X_OLD_SOURCE_COUNTY in VARCHAR2,
X_NEW_SOURCE_COUNTRY in VARCHAR2,
X_OLD_SOURCE_COUNTRY in VARCHAR2,
X_NEW_SOURCE_MGR_ID in NUMBER,
X_OLD_SOURCE_MGR_ID in NUMBER,
X_NEW_SOURCE_MGR_NAME in VARCHAR2,
X_OLD_SOURCE_MGR_NAME in VARCHAR2,
X_NEW_SOURCE_BUSINESS_GRP_ID in NUMBER,
X_OLD_SOURCE_BUSINESS_GRP_ID in NUMBER,
X_NEW_SOURCE_BUSINESS_GRP_NAME in VARCHAR2,
X_OLD_SOURCE_BUSINESS_GRP_NAME in VARCHAR2,
X_NEW_SOURCE_FIRST_NAME in VARCHAR2,
X_OLD_SOURCE_FIRST_NAME in VARCHAR2,
X_NEW_SOURCE_MIDDLE_NAME in VARCHAR2,
X_OLD_SOURCE_MIDDLE_NAME in VARCHAR2,
X_NEW_SOURCE_LAST_NAME in VARCHAR2,
X_OLD_SOURCE_LAST_NAME in VARCHAR2,
X_NEW_SOURCE_CATEGORY in VARCHAR2,
X_OLD_SOURCE_CATEGORY in VARCHAR2,
X_NEW_SOURCE_STATUS in VARCHAR2,
X_OLD_SOURCE_STATUS in VARCHAR2,
X_NEW_SOURCE_OFFICE in VARCHAR2,
X_OLD_SOURCE_OFFICE in VARCHAR2,
X_NEW_SOURCE_LOCATION in VARCHAR2,
X_OLD_SOURCE_LOCATION in VARCHAR2,
X_NEW_SOURCE_MAILSTOP in VARCHAR2,
X_OLD_SOURCE_MAILSTOP in VARCHAR2,
X_NEW_USER_NAME in VARCHAR2,
X_OLD_USER_NAME in VARCHAR2,
X_NEW_SOURCE_JOB_ID in VARCHAR2,
X_OLD_SOURCE_JOB_ID in VARCHAR2,
X_NEW_PARTY_ID in VARCHAR2,
X_OLD_PARTY_ID in VARCHAR2,
X_NEW_SOURCE_MOBILE_PHONE in VARCHAR2,
X_OLD_SOURCE_MOBILE_PHONE in VARCHAR2,
X_NEW_SOURCE_PAGER in VARCHAR2,
X_OLD_SOURCE_PAGER in VARCHAR2
) is
begin
update JTF_RS_RESOURCE_EXTN_AUD set
RESOURCE_ID = X_RESOURCE_ID,
NEW_CATEGORY = X_NEW_CATEGORY,
OLD_CATEGORY = X_OLD_CATEGORY,
NEW_RESOURCE_NUMBER = X_NEW_RESOURCE_NUMBER,
OLD_RESOURCE_NUMBER = X_OLD_RESOURCE_NUMBER,
NEW_SOURCE_ID = X_NEW_SOURCE_ID,
OLD_SOURCE_ID = X_OLD_SOURCE_ID,
NEW_ADDRESS_ID = X_NEW_ADDRESS_ID,
OLD_ADDRESS_ID = X_OLD_ADDRESS_ID,
NEW_CONTACT_ID = X_NEW_CONTACT_ID,
OLD_CONTACT_ID = X_OLD_CONTACT_ID,
NEW_MANAGING_EMPLOYEE_ID = X_NEW_MANAGING_EMPLOYEE_ID,
OLD_MANAGING_EMPLOYEE_ID = X_OLD_MANAGING_EMPLOYEE_ID,
OLD_START_DATE_ACTIVE = X_OLD_START_DATE_ACTIVE,
NEW_START_DATE_ACTIVE = X_NEW_START_DATE_ACTIVE,
OLD_END_DATE_ACTIVE = X_OLD_END_DATE_ACTIVE,
NEW_END_DATE_ACTIVE = X_NEW_END_DATE_ACTIVE,
NEW_TIME_ZONE = X_NEW_TIME_ZONE,
OLD_TIME_ZONE = X_OLD_TIME_ZONE,
NEW_COST_PER_HR = X_NEW_COST_PER_HR,
OLD_COST_PER_HR = X_OLD_COST_PER_HR,
NEW_PRIMARY_LANGUAGE = X_NEW_PRIMARY_LANGUAGE,
OLD_PRIMARY_LANGUAGE = X_OLD_PRIMARY_LANGUAGE,
NEW_SECONDARY_LANGUAGE = X_NEW_SECONDARY_LANGUAGE,
OLD_SECONDARY_LANGUAGE = X_OLD_SECONDARY_LANGUAGE,
NEW_SUPPORT_SITE_ID = X_NEW_SUPPORT_SITE_ID,
OLD_SUPPORT_SITE_ID = X_OLD_SUPPORT_SITE_ID,
NEW_IES_AGENT_LOGIN = X_NEW_IES_AGENT_LOGIN,
OLD_IES_AGENT_LOGIN = X_OLD_IES_AGENT_LOGIN,
NEW_SERVER_GROUP_ID = X_NEW_SERVER_GROUP_ID,
OLD_SERVER_GROUP_ID = X_OLD_SERVER_GROUP_ID,
NEW_ASSIGNED_TO_GROUP_ID = X_NEW_ASSIGNED_TO_GROUP_ID,
OLD_ASSIGNED_TO_GROUP_ID = X_OLD_ASSIGNED_TO_GROUP_ID,
NEW_COST_CENTER = X_NEW_COST_CENTER,
OLD_COST_CENTER = X_OLD_COST_CENTER,
NEW_CHARGE_TO_COST_CENTER = X_NEW_CHARGE_TO_COST_CENTER,
OLD_CHARGE_TO_COST_CENTER = X_OLD_CHARGE_TO_COST_CENTER,
NEW_COMPENSATION_CURRENCY_CODE = X_NEW_COMPENSATION_CURRENCY_CO,
OLD_COMPENSATION_CURRENCY_CODE = X_OLD_COMPENSATION_CURRENCY_CO,
NEW_COMMISSIONABLE_FLAG = X_NEW_COMMISSIONABLE_FLAG,
OLD_COMMISSIONABLE_FLAG = X_OLD_COMMISSIONABLE_FLAG,
NEW_HOLD_REASON_CODE = X_NEW_HOLD_REASON_CODE,
OLD_HOLD_REASON_CODE = X_OLD_HOLD_REASON_CODE,
NEW_HOLD_PAYMENT = X_NEW_HOLD_PAYMENT,
OLD_HOLD_PAYMENT = X_OLD_HOLD_PAYMENT,
NEW_COMP_SERVICE_TEAM_ID = X_NEW_COMP_SERVICE_TEAM_ID,
OLD_COMP_SERVICE_TEAM_ID = X_OLD_COMP_SERVICE_TEAM_ID,
NEW_TRANSACTION_NUMBER = X_NEW_TRANSACTION_NUMBER,
OLD_TRANSACTION_NUMBER = X_OLD_TRANSACTION_NUMBER,
NEW_OBJECT_VERSION_NUMBER = X_NEW_OBJECT_VERSION_NUMBER,
OLD_OBJECT_VERSION_NUMBER = X_OLD_OBJECT_VERSION_NUMBER,
NEW_USER_ID = X_NEW_USER_ID,
OLD_USER_ID = X_OLD_USER_ID,
--OLD_LOCATION = X_OLD_LOCATION,
-- NEW_LOCATION = X_NEW_LOCATION,
LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
LAST_UPDATED_BY = X_LAST_UPDATED_BY,
LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
NEW_RESOURCE_NAME = X_NEW_RESOURCE_NAME ,
OLD_RESOURCE_NAME = X_OLD_RESOURCE_NAME ,
NEW_SOURCE_NAME = X_NEW_SOURCE_NAME ,
OLD_SOURCE_NAME = X_OLD_SOURCE_NAME ,
NEW_SOURCE_NUMBER = X_NEW_SOURCE_NUMBER ,
OLD_SOURCE_NUMBER = X_OLD_SOURCE_NUMBER ,
NEW_SOURCE_JOB_TITLE = X_NEW_SOURCE_JOB_TITLE ,
OLD_SOURCE_JOB_TITLE = X_OLD_SOURCE_JOB_TITLE ,
NEW_SOURCE_EMAIL = X_NEW_SOURCE_EMAIL ,
OLD_SOURCE_EMAIL = X_OLD_SOURCE_EMAIL ,
NEW_SOURCE_PHONE = X_NEW_SOURCE_PHONE ,
OLD_SOURCE_PHONE = X_OLD_SOURCE_PHONE ,
NEW_SOURCE_ORG_ID = X_NEW_SOURCE_ORG_ID ,
OLD_SOURCE_ORG_ID = X_OLD_SOURCE_ORG_ID ,
NEW_SOURCE_ORG_NAME = X_NEW_SOURCE_ORG_NAME ,
OLD_SOURCE_ORG_NAME = X_OLD_SOURCE_ORG_NAME ,
NEW_SOURCE_ADDRESS1 = X_NEW_SOURCE_ADDRESS1 ,
OLD_SOURCE_ADDRESS1 = X_OLD_SOURCE_ADDRESS1 ,
NEW_SOURCE_ADDRESS2 = X_NEW_SOURCE_ADDRESS2 ,
OLD_SOURCE_ADDRESS2 = X_OLD_SOURCE_ADDRESS2 ,
NEW_SOURCE_ADDRESS3 = X_NEW_SOURCE_ADDRESS3 ,
OLD_SOURCE_ADDRESS3 = X_OLD_SOURCE_ADDRESS3 ,
NEW_SOURCE_ADDRESS4 = X_NEW_SOURCE_ADDRESS4 ,
OLD_SOURCE_ADDRESS4 = X_OLD_SOURCE_ADDRESS4 ,
NEW_SOURCE_CITY = X_NEW_SOURCE_CITY ,
OLD_SOURCE_CITY = X_OLD_SOURCE_CITY ,
NEW_SOURCE_POSTAL_CODE = X_NEW_SOURCE_POSTAL_CODE ,
OLD_SOURCE_POSTAL_CODE = X_OLD_SOURCE_POSTAL_CODE ,
NEW_SOURCE_STATE = X_NEW_SOURCE_STATE ,
OLD_SOURCE_STATE = X_OLD_SOURCE_STATE ,
NEW_SOURCE_PROVINCE = X_NEW_SOURCE_PROVINCE ,
OLD_SOURCE_PROVINCE = X_OLD_SOURCE_PROVINCE ,
NEW_SOURCE_COUNTY = X_NEW_SOURCE_COUNTY ,
OLD_SOURCE_COUNTY = X_OLD_SOURCE_COUNTY ,
NEW_SOURCE_COUNTRY = X_NEW_SOURCE_COUNTRY ,
OLD_SOURCE_COUNTRY = X_OLD_SOURCE_COUNTRY ,
NEW_SOURCE_MGR_ID = X_NEW_SOURCE_MGR_ID,
OLD_SOURCE_MGR_ID = X_OLD_SOURCE_MGR_ID,
NEW_SOURCE_MGR_NAME = X_NEW_SOURCE_MGR_NAME,
OLD_SOURCE_MGR_NAME = X_OLD_SOURCE_MGR_NAME,
NEW_SOURCE_BUSINESS_GRP_ID = X_NEW_SOURCE_BUSINESS_GRP_ID,
OLD_SOURCE_BUSINESS_GRP_ID = X_OLD_SOURCE_BUSINESS_GRP_ID,
NEW_SOURCE_BUSINESS_GRP_NAME = X_NEW_SOURCE_BUSINESS_GRP_NAME,
OLD_SOURCE_BUSINESS_GRP_NAME = X_OLD_SOURCE_BUSINESS_GRP_NAME,
NEW_SOURCE_FIRST_NAME = X_NEW_SOURCE_FIRST_NAME ,
OLD_SOURCE_FIRST_NAME = X_OLD_SOURCE_FIRST_NAME ,
NEW_SOURCE_LAST_NAME = X_NEW_SOURCE_LAST_NAME ,
OLD_SOURCE_LAST_NAME = X_OLD_SOURCE_LAST_NAME ,
NEW_SOURCE_MIDDLE_NAME = X_NEW_SOURCE_MIDDLE_NAME ,
OLD_SOURCE_MIDDLE_NAME = X_OLD_SOURCE_MIDDLE_NAME ,
NEW_SOURCE_CATEGORY = X_NEW_SOURCE_CATEGORY ,
OLD_SOURCE_CATEGORY = X_OLD_SOURCE_CATEGORY ,
NEW_SOURCE_STATUS = X_NEW_SOURCE_STATUS ,
OLD_SOURCE_STATUS = X_OLD_SOURCE_STATUS ,
NEW_SOURCE_OFFICE = X_NEW_SOURCE_OFFICE,
OLD_SOURCE_OFFICE = X_OLD_SOURCE_OFFICE,
NEW_SOURCE_LOCATION = X_NEW_SOURCE_LOCATION,
OLD_SOURCE_LOCATION = X_OLD_SOURCE_LOCATION,
NEW_SOURCE_MAILSTOP = X_NEW_SOURCE_MAILSTOP,
OLD_SOURCE_MAILSTOP = X_OLD_SOURCE_MAILSTOP,
NEW_USER_NAME = X_NEW_USER_NAME,
OLD_USER_NAME = X_OLD_USER_NAME,
NEW_SOURCE_JOB_ID = X_NEW_SOURCE_JOB_ID,
OLD_SOURCE_JOB_ID = X_OLD_SOURCE_JOB_ID,
NEW_PARTY_ID = X_NEW_PARTY_ID,
OLD_PARTY_ID = X_OLD_PARTY_ID,
NEW_SOURCE_MOBILE_PHONE = X_NEW_SOURCE_MOBILE_PHONE,
OLD_SOURCE_MOBILE_PHONE = X_OLD_SOURCE_MOBILE_PHONE,
NEW_SOURCE_PAGER = X_NEW_SOURCE_PAGER,
OLD_SOURCE_PAGER = X_OLD_SOURCE_PAGER
where RESOURCE_AUDIT_ID = X_RESOURCE_AUDIT_ID;
end UPDATE_ROW;
procedure DELETE_ROW (
X_RESOURCE_AUDIT_ID in NUMBER
) is
begin
delete from JTF_RS_RESOURCE_EXTN_AUD
where RESOURCE_AUDIT_ID = X_RESOURCE_AUDIT_ID;
end DELETE_ROW;