eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PRC_RKU SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 5


procedure AFTER_UPDATE
(P_PRTT_REIMBMT_RQST_ID in NUMBER
,P_EFFECTIVE_START_DATE in DATE
,P_EFFECTIVE_END_DATE in DATE
,P_INCRD_FROM_DT in DATE
,P_INCRD_TO_DT in DATE
,P_RQST_NUM in NUMBER
,P_RQST_AMT in NUMBER
,P_RQST_AMT_UOM in VARCHAR2
,P_RQST_BTCH_NUM in NUMBER
,P_PRTT_REIMBMT_RQST_STAT_CD in VARCHAR2
,P_REIMBMT_CTFN_TYP_PRVDD_CD in VARCHAR2
,P_RCRRG_CD in VARCHAR2
,P_SUBMITTER_PERSON_ID in NUMBER
,P_RECIPIENT_PERSON_ID in NUMBER
,P_PROVIDER_PERSON_ID in NUMBER
,P_PROVIDER_SSN_PERSON_ID in NUMBER
,P_PL_ID in NUMBER
,P_GD_OR_SVC_TYP_ID in NUMBER
,P_CONTACT_RELATIONSHIP_ID in NUMBER
,P_BUSINESS_GROUP_ID in NUMBER
,P_OPT_ID in NUMBER
,P_POPL_YR_PERD_ID_1 in NUMBER
,P_POPL_YR_PERD_ID_2 in NUMBER
,P_AMT_YEAR1 in NUMBER
,P_AMT_YEAR2 in NUMBER
,P_PRC_ATTRIBUTE_CATEGORY in VARCHAR2
,P_PRC_ATTRIBUTE1 in VARCHAR2
,P_PRC_ATTRIBUTE2 in VARCHAR2
,P_PRC_ATTRIBUTE3 in VARCHAR2
,P_PRC_ATTRIBUTE4 in VARCHAR2
,P_PRC_ATTRIBUTE5 in VARCHAR2
,P_PRC_ATTRIBUTE6 in VARCHAR2
,P_PRC_ATTRIBUTE7 in VARCHAR2
,P_PRC_ATTRIBUTE8 in VARCHAR2
,P_PRC_ATTRIBUTE9 in VARCHAR2
,P_PRC_ATTRIBUTE10 in VARCHAR2
,P_PRC_ATTRIBUTE11 in VARCHAR2
,P_PRC_ATTRIBUTE12 in VARCHAR2
,P_PRC_ATTRIBUTE13 in VARCHAR2
,P_PRC_ATTRIBUTE14 in VARCHAR2
,P_PRC_ATTRIBUTE15 in VARCHAR2
,P_PRC_ATTRIBUTE16 in VARCHAR2
,P_PRC_ATTRIBUTE17 in VARCHAR2
,P_PRC_ATTRIBUTE18 in VARCHAR2
,P_PRC_ATTRIBUTE19 in VARCHAR2
,P_PRC_ATTRIBUTE20 in VARCHAR2
,P_PRC_ATTRIBUTE21 in VARCHAR2
,P_PRC_ATTRIBUTE22 in VARCHAR2
,P_PRC_ATTRIBUTE23 in VARCHAR2
,P_PRC_ATTRIBUTE24 in VARCHAR2
,P_PRC_ATTRIBUTE25 in VARCHAR2
,P_PRC_ATTRIBUTE26 in VARCHAR2
,P_PRC_ATTRIBUTE27 in VARCHAR2
,P_PRC_ATTRIBUTE28 in VARCHAR2
,P_PRC_ATTRIBUTE29 in VARCHAR2
,P_PRC_ATTRIBUTE30 in VARCHAR2
,P_PRTT_ENRT_RSLT_ID in NUMBER
,P_COMMENT_ID in NUMBER
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_STAT_RSN_CD in VARCHAR2
,P_PYMT_STAT_CD in VARCHAR2
,P_PYMT_STAT_RSN_CD in VARCHAR2
,P_STAT_OVRDN_FLAG in VARCHAR2
,P_STAT_OVRDN_RSN_CD in VARCHAR2
,P_STAT_PRR_TO_OVRD in VARCHAR2
,P_PYMT_STAT_OVRDN_FLAG in VARCHAR2
,P_PYMT_STAT_OVRDN_RSN_CD in VARCHAR2
,P_PYMT_STAT_PRR_TO_OVRD in VARCHAR2
,P_ADJMT_FLAG in VARCHAR2
,P_SUBMTD_DT in DATE
,P_TTL_RQST_AMT in NUMBER
,P_APRVD_FOR_PYMT_AMT in NUMBER
,P_EXP_INCURD_DT in DATE
,P_EFFECTIVE_DATE in DATE
,P_DATETRACK_MODE in VARCHAR2
,P_VALIDATION_START_DATE in DATE
,P_VALIDATION_END_DATE in DATE
,P_EFFECTIVE_START_DATE_O in DATE
,P_EFFECTIVE_END_DATE_O in DATE
,P_INCRD_FROM_DT_O in DATE
,P_INCRD_TO_DT_O in DATE
,P_RQST_NUM_O in NUMBER
,P_RQST_AMT_O in NUMBER
,P_RQST_AMT_UOM_O in VARCHAR2
,P_RQST_BTCH_NUM_O in NUMBER
,P_PRTT_REIMBMT_RQST_STAT_CD_O in VARCHAR2
,P_REIMBMT_CTFN_TYP_PRVDD_CD_O in VARCHAR2
,P_RCRRG_CD_O in VARCHAR2
,P_SUBMITTER_PERSON_ID_O in NUMBER
,P_RECIPIENT_PERSON_ID_O in NUMBER
,P_PROVIDER_PERSON_ID_O in NUMBER
,P_PROVIDER_SSN_PERSON_ID_O in NUMBER
,P_PL_ID_O in NUMBER
,P_GD_OR_SVC_TYP_ID_O in NUMBER
,P_CONTACT_RELATIONSHIP_ID_O in NUMBER
,P_BUSINESS_GROUP_ID_O in NUMBER
,P_OPT_ID_O in NUMBER
,P_POPL_YR_PERD_ID_1_O in NUMBER
,P_POPL_YR_PERD_ID_2_O in NUMBER
,P_AMT_YEAR1_O in NUMBER
,P_AMT_YEAR2_O in NUMBER
,P_PRC_ATTRIBUTE_CATEGORY_O in VARCHAR2
,P_PRC_ATTRIBUTE1_O in VARCHAR2
,P_PRC_ATTRIBUTE2_O in VARCHAR2
,P_PRC_ATTRIBUTE3_O in VARCHAR2
,P_PRC_ATTRIBUTE4_O in VARCHAR2
,P_PRC_ATTRIBUTE5_O in VARCHAR2
,P_PRC_ATTRIBUTE6_O in VARCHAR2
,P_PRC_ATTRIBUTE7_O in VARCHAR2
,P_PRC_ATTRIBUTE8_O in VARCHAR2
,P_PRC_ATTRIBUTE9_O in VARCHAR2
,P_PRC_ATTRIBUTE10_O in VARCHAR2
,P_PRC_ATTRIBUTE11_O in VARCHAR2
,P_PRC_ATTRIBUTE12_O in VARCHAR2
,P_PRC_ATTRIBUTE13_O in VARCHAR2
,P_PRC_ATTRIBUTE14_O in VARCHAR2
,P_PRC_ATTRIBUTE15_O in VARCHAR2
,P_PRC_ATTRIBUTE16_O in VARCHAR2
,P_PRC_ATTRIBUTE17_O in VARCHAR2
,P_PRC_ATTRIBUTE18_O in VARCHAR2
,P_PRC_ATTRIBUTE19_O in VARCHAR2
,P_PRC_ATTRIBUTE20_O in VARCHAR2
,P_PRC_ATTRIBUTE21_O in VARCHAR2
,P_PRC_ATTRIBUTE22_O in VARCHAR2
,P_PRC_ATTRIBUTE23_O in VARCHAR2
,P_PRC_ATTRIBUTE24_O in VARCHAR2
,P_PRC_ATTRIBUTE25_O in VARCHAR2
,P_PRC_ATTRIBUTE26_O in VARCHAR2
,P_PRC_ATTRIBUTE27_O in VARCHAR2
,P_PRC_ATTRIBUTE28_O in VARCHAR2
,P_PRC_ATTRIBUTE29_O in VARCHAR2
,P_PRC_ATTRIBUTE30_O in VARCHAR2
,P_PRTT_ENRT_RSLT_ID_O in NUMBER
,P_COMMENT_ID_O in NUMBER
,P_OBJECT_VERSION_NUMBER_O in NUMBER
,P_STAT_RSN_CD_O in VARCHAR2
,P_PYMT_STAT_CD_O in VARCHAR2
,P_PYMT_STAT_RSN_CD_O in VARCHAR2
,P_STAT_OVRDN_FLAG_O in VARCHAR2
,P_STAT_OVRDN_RSN_CD_O in VARCHAR2
,P_STAT_PRR_TO_OVRD_O in VARCHAR2
,P_PYMT_STAT_OVRDN_FLAG_O in VARCHAR2
,P_PYMT_STAT_OVRDN_RSN_CD_O in VARCHAR2
,P_PYMT_STAT_PRR_TO_OVRD_O in VARCHAR2
,P_ADJMT_FLAG_O in VARCHAR2
,P_SUBMTD_DT_O in DATE
,P_TTL_RQST_AMT_O in NUMBER
,P_APRVD_FOR_PYMT_AMT_O in NUMBER
,P_EXP_INCURD_DT_O in DATE
)is
begin
hr_utility.set_location('Entering: ben_prc_RKU.AFTER_UPDATE', 10);

Line: 158


hr_utility.set_location(' Leaving: ben_prc_RKU.AFTER_UPDATE', 20);

Line: 159


end AFTER_UPDATE;