APPS.BEN_ABR_RKU SQL Statements

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

Line: 5

procedure AFTER_UPDATE
(P_ACTY_BASE_RT_ID in NUMBER
,P_EFFECTIVE_START_DATE in DATE
,P_EFFECTIVE_END_DATE in DATE
,P_ORDR_NUM in NUMBER
,P_ACTY_TYP_CD in VARCHAR2
,P_SUB_ACTY_TYP_CD in VARCHAR2
,P_NAME in VARCHAR2
,P_RT_TYP_CD in VARCHAR2
,P_BNFT_RT_TYP_CD in VARCHAR2
,P_TX_TYP_CD in VARCHAR2
,P_USE_TO_CALC_NET_FLX_CR_FLAG in VARCHAR2
,P_ASN_ON_ENRT_FLAG in VARCHAR2
,P_ABV_MX_ELCN_VAL_ALWD_FLAG in VARCHAR2
,P_BLW_MN_ELCN_ALWD_FLAG in VARCHAR2
,P_DSPLY_ON_ENRT_FLAG in VARCHAR2
,P_PARNT_CHLD_CD in VARCHAR2
,P_USE_CALC_ACTY_BS_RT_FLAG in VARCHAR2
,P_USES_DED_SCHED_FLAG in VARCHAR2
,P_USES_VARBL_RT_FLAG in VARCHAR2
,P_VSTG_SCHED_APLS_FLAG in VARCHAR2
,P_RT_MLT_CD in VARCHAR2
,P_PROC_EACH_PP_DFLT_FLAG in VARCHAR2
,P_PRDCT_FLX_CR_WHEN_ELIG_FLAG in VARCHAR2
,P_NO_STD_RT_USED_FLAG in VARCHAR2
,P_RCRRG_CD in VARCHAR2
,P_MN_ELCN_VAL in NUMBER
,P_MX_ELCN_VAL in NUMBER
,P_LWR_LMT_VAL in NUMBER
,P_LWR_LMT_CALC_RL in NUMBER
,P_UPR_LMT_VAL in NUMBER
,P_UPR_LMT_CALC_RL in NUMBER
,P_PTD_COMP_LVL_FCTR_ID in NUMBER
,P_CLM_COMP_LVL_FCTR_ID in NUMBER
,P_ENTR_ANN_VAL_FLAG in VARCHAR2
,P_ANN_MN_ELCN_VAL in NUMBER
,P_ANN_MX_ELCN_VAL in NUMBER
,P_WSH_RL_DY_MO_NUM in NUMBER
,P_USES_PYMT_SCHED_FLAG in VARCHAR2
,P_NNMNTRY_UOM in VARCHAR2
,P_VAL in NUMBER
,P_INCRMT_ELCN_VAL in NUMBER
,P_RNDG_CD in VARCHAR2
,P_VAL_OVRID_ALWD_FLAG in VARCHAR2
,P_PRTL_MO_DET_MTHD_CD in VARCHAR2
,P_ACTY_BASE_RT_STAT_CD in VARCHAR2
,P_PROCG_SRC_CD in VARCHAR2
,P_DFLT_VAL in NUMBER
,P_DFLT_FLAG in VARCHAR2
,P_FRGN_ERG_DED_TYP_CD in VARCHAR2
,P_FRGN_ERG_DED_NAME in VARCHAR2
,P_FRGN_ERG_DED_IDENT in VARCHAR2
,P_NO_MX_ELCN_VAL_DFND_FLAG in VARCHAR2
,P_PRTL_MO_DET_MTHD_RL in NUMBER
,P_ENTR_VAL_AT_ENRT_FLAG in VARCHAR2
,P_PRTL_MO_EFF_DT_DET_RL in NUMBER
,P_RNDG_RL in NUMBER
,P_VAL_CALC_RL in NUMBER
,P_NO_MN_ELCN_VAL_DFND_FLAG in VARCHAR2
,P_PRTL_MO_EFF_DT_DET_CD in VARCHAR2
,P_ONLY_ONE_BAL_TYP_ALWD_FLAG in VARCHAR2
,P_RT_USG_CD in VARCHAR2
,P_PRORT_MN_ANN_ELCN_VAL_CD in VARCHAR2
,P_PRORT_MN_ANN_ELCN_VAL_RL in NUMBER
,P_PRORT_MX_ANN_ELCN_VAL_CD in VARCHAR2
,P_PRORT_MX_ANN_ELCN_VAL_RL in NUMBER
,P_ONE_ANN_PYMT_CD in VARCHAR2
,P_DET_PL_YTD_CNTRS_CD in VARCHAR2
,P_ASMT_TO_USE_CD in VARCHAR2
,P_ELE_RQD_FLAG in VARCHAR2
,P_SUBJ_TO_IMPTD_INCM_FLAG in VARCHAR2
,P_ELEMENT_TYPE_ID in NUMBER
,P_INPUT_VALUE_ID in NUMBER
,P_INPUT_VA_CALC_RL in NUMBER
,P_COMP_LVL_FCTR_ID in NUMBER
,P_PARNT_ACTY_BASE_RT_ID in NUMBER
,P_PGM_ID in NUMBER
,P_PL_ID in NUMBER
,P_OIPL_ID in NUMBER
,P_OPT_ID in NUMBER
,P_OIPLIP_ID in NUMBER
,P_PLIP_ID in NUMBER
,P_PTIP_ID in NUMBER
,P_CMBN_PLIP_ID in NUMBER
,P_CMBN_PTIP_ID in NUMBER
,P_CMBN_PTIP_OPT_ID in NUMBER
,P_VSTG_FOR_ACTY_RT_ID in NUMBER
,P_ACTL_PREM_ID in NUMBER
,P_TTL_COMP_LVL_FCTR_ID in NUMBER
,P_COST_ALLOCATION_KEYFLEX_ID in NUMBER
,P_ALWS_CHG_CD in VARCHAR2
,P_ELE_ENTRY_VAL_CD in VARCHAR2
,P_PAY_RATE_GRADE_RULE_ID in NUMBER
,P_RATE_PERIODIZATION_CD in VARCHAR2
,P_RATE_PERIODIZATION_RL in NUMBER
,P_MN_MX_ELCN_RL in NUMBER
,P_MAPPING_TABLE_NAME in VARCHAR2
,P_MAPPING_TABLE_PK_ID in NUMBER
,P_BUSINESS_GROUP_ID in NUMBER
,P_CONTEXT_PGM_ID in NUMBER
,P_CONTEXT_PL_ID in NUMBER
,P_CONTEXT_OPT_ID in NUMBER
,P_ELEMENT_DET_RL in NUMBER
,P_CURRENCY_DET_CD in VARCHAR2
,P_ABR_ATTRIBUTE_CATEGORY in VARCHAR2
,P_ABR_ATTRIBUTE1 in VARCHAR2
,P_ABR_ATTRIBUTE2 in VARCHAR2
,P_ABR_ATTRIBUTE3 in VARCHAR2
,P_ABR_ATTRIBUTE4 in VARCHAR2
,P_ABR_ATTRIBUTE5 in VARCHAR2
,P_ABR_ATTRIBUTE6 in VARCHAR2
,P_ABR_ATTRIBUTE7 in VARCHAR2
,P_ABR_ATTRIBUTE8 in VARCHAR2
,P_ABR_ATTRIBUTE9 in VARCHAR2
,P_ABR_ATTRIBUTE10 in VARCHAR2
,P_ABR_ATTRIBUTE11 in VARCHAR2
,P_ABR_ATTRIBUTE12 in VARCHAR2
,P_ABR_ATTRIBUTE13 in VARCHAR2
,P_ABR_ATTRIBUTE14 in VARCHAR2
,P_ABR_ATTRIBUTE15 in VARCHAR2
,P_ABR_ATTRIBUTE16 in VARCHAR2
,P_ABR_ATTRIBUTE17 in VARCHAR2
,P_ABR_ATTRIBUTE18 in VARCHAR2
,P_ABR_ATTRIBUTE19 in VARCHAR2
,P_ABR_ATTRIBUTE20 in VARCHAR2
,P_ABR_ATTRIBUTE21 in VARCHAR2
,P_ABR_ATTRIBUTE22 in VARCHAR2
,P_ABR_ATTRIBUTE23 in VARCHAR2
,P_ABR_ATTRIBUTE24 in VARCHAR2
,P_ABR_ATTRIBUTE25 in VARCHAR2
,P_ABR_ATTRIBUTE26 in VARCHAR2
,P_ABR_ATTRIBUTE27 in VARCHAR2
,P_ABR_ATTRIBUTE28 in VARCHAR2
,P_ABR_ATTRIBUTE29 in VARCHAR2
,P_ABR_ATTRIBUTE30 in VARCHAR2
,P_ABR_SEQ_NUM in NUMBER
,P_OBJECT_VERSION_NUMBER in NUMBER
,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_ORDR_NUM_O in NUMBER
,P_ACTY_TYP_CD_O in VARCHAR2
,P_SUB_ACTY_TYP_CD_O in VARCHAR2
,P_NAME_O in VARCHAR2
,P_RT_TYP_CD_O in VARCHAR2
,P_BNFT_RT_TYP_CD_O in VARCHAR2
,P_TX_TYP_CD_O in VARCHAR2
,P_USE_TO_CALC_NET_FLX_CR_FLA_O in VARCHAR2
,P_ASN_ON_ENRT_FLAG_O in VARCHAR2
,P_ABV_MX_ELCN_VAL_ALWD_FLAG_O in VARCHAR2
,P_BLW_MN_ELCN_ALWD_FLAG_O in VARCHAR2
,P_DSPLY_ON_ENRT_FLAG_O in VARCHAR2
,P_PARNT_CHLD_CD_O in VARCHAR2
,P_USE_CALC_ACTY_BS_RT_FLAG_O in VARCHAR2
,P_USES_DED_SCHED_FLAG_O in VARCHAR2
,P_USES_VARBL_RT_FLAG_O in VARCHAR2
,P_VSTG_SCHED_APLS_FLAG_O in VARCHAR2
,P_RT_MLT_CD_O in VARCHAR2
,P_PROC_EACH_PP_DFLT_FLAG_O in VARCHAR2
,P_PRDCT_FLX_CR_WHEN_ELIG_FLA_O in VARCHAR2
,P_NO_STD_RT_USED_FLAG_O in VARCHAR2
,P_RCRRG_CD_O in VARCHAR2
,P_MN_ELCN_VAL_O in NUMBER
,P_MX_ELCN_VAL_O in NUMBER
,P_LWR_LMT_VAL_O in NUMBER
,P_LWR_LMT_CALC_RL_O in NUMBER
,P_UPR_LMT_VAL_O in NUMBER
,P_UPR_LMT_CALC_RL_O in NUMBER
,P_PTD_COMP_LVL_FCTR_ID_O in NUMBER
,P_CLM_COMP_LVL_FCTR_ID_O in NUMBER
,P_ENTR_ANN_VAL_FLAG_O in VARCHAR2
,P_ANN_MN_ELCN_VAL_O in NUMBER
,P_ANN_MX_ELCN_VAL_O in NUMBER
,P_WSH_RL_DY_MO_NUM_O in NUMBER
,P_USES_PYMT_SCHED_FLAG_O in VARCHAR2
,P_NNMNTRY_UOM_O in VARCHAR2
,P_VAL_O in NUMBER
,P_INCRMT_ELCN_VAL_O in NUMBER
,P_RNDG_CD_O in VARCHAR2
,P_VAL_OVRID_ALWD_FLAG_O in VARCHAR2
,P_PRTL_MO_DET_MTHD_CD_O in VARCHAR2
,P_ACTY_BASE_RT_STAT_CD_O in VARCHAR2
,P_PROCG_SRC_CD_O in VARCHAR2
,P_DFLT_VAL_O in NUMBER
,P_DFLT_FLAG_O in VARCHAR2
,P_FRGN_ERG_DED_TYP_CD_O in VARCHAR2
,P_FRGN_ERG_DED_NAME_O in VARCHAR2
,P_FRGN_ERG_DED_IDENT_O in VARCHAR2
,P_NO_MX_ELCN_VAL_DFND_FLAG_O in VARCHAR2
,P_PRTL_MO_DET_MTHD_RL_O in NUMBER
,P_ENTR_VAL_AT_ENRT_FLAG_O in VARCHAR2
,P_PRTL_MO_EFF_DT_DET_RL_O in NUMBER
,P_RNDG_RL_O in NUMBER
,P_VAL_CALC_RL_O in NUMBER
,P_NO_MN_ELCN_VAL_DFND_FLAG_O in VARCHAR2
,P_PRTL_MO_EFF_DT_DET_CD_O in VARCHAR2
,P_ONLY_ONE_BAL_TYP_ALWD_FLAG_O in VARCHAR2
,P_RT_USG_CD_O in VARCHAR2
,P_PRORT_MN_ANN_ELCN_VAL_CD_O in VARCHAR2
,P_PRORT_MN_ANN_ELCN_VAL_RL_O in NUMBER
,P_PRORT_MX_ANN_ELCN_VAL_CD_O in VARCHAR2
,P_PRORT_MX_ANN_ELCN_VAL_RL_O in NUMBER
,P_ONE_ANN_PYMT_CD_O in VARCHAR2
,P_DET_PL_YTD_CNTRS_CD_O in VARCHAR2
,P_ASMT_TO_USE_CD_O in VARCHAR2
,P_ELE_RQD_FLAG_O in VARCHAR2
,P_SUBJ_TO_IMPTD_INCM_FLAG_O in VARCHAR2
,P_ELEMENT_TYPE_ID_O in NUMBER
,P_INPUT_VALUE_ID_O in NUMBER
,P_INPUT_VA_CALC_RL_O in NUMBER
,P_COMP_LVL_FCTR_ID_O in NUMBER
,P_PARNT_ACTY_BASE_RT_ID_O in NUMBER
,P_PGM_ID_O in NUMBER
,P_PL_ID_O in NUMBER
,P_OIPL_ID_O in NUMBER
,P_OPT_ID_O in NUMBER
,P_OIPLIP_ID_O in NUMBER
,P_PLIP_ID_O in NUMBER
,P_PTIP_ID_O in NUMBER
,P_CMBN_PLIP_ID_O in NUMBER
,P_CMBN_PTIP_ID_O in NUMBER
,P_CMBN_PTIP_OPT_ID_O in NUMBER
,P_VSTG_FOR_ACTY_RT_ID_O in NUMBER
,P_ACTL_PREM_ID_O in NUMBER
,P_TTL_COMP_LVL_FCTR_ID_O in NUMBER
,P_COST_ALLOCATION_KEYFLEX_ID_O in NUMBER
,P_ALWS_CHG_CD_O in VARCHAR2
,P_ELE_ENTRY_VAL_CD_O in VARCHAR2
,P_PAY_RATE_GRADE_RULE_ID_O in NUMBER
,P_RATE_PERIODIZATION_CD_O in VARCHAR2
,P_RATE_PERIODIZATION_RL_O in NUMBER
,P_MN_MX_ELCN_RL_O in NUMBER
,P_MAPPING_TABLE_NAME_O in VARCHAR2
,P_MAPPING_TABLE_PK_ID_O in NUMBER
,P_BUSINESS_GROUP_ID_O in NUMBER
,P_CONTEXT_PGM_ID_O in NUMBER
,P_CONTEXT_PL_ID_O in NUMBER
,P_CONTEXT_OPT_ID_O in NUMBER
,P_ELEMENT_DET_RL_O in NUMBER
,P_CURRENCY_DET_CD_O in VARCHAR2
,P_ABR_ATTRIBUTE_CATEGORY_O in VARCHAR2
,P_ABR_ATTRIBUTE1_O in VARCHAR2
,P_ABR_ATTRIBUTE2_O in VARCHAR2
,P_ABR_ATTRIBUTE3_O in VARCHAR2
,P_ABR_ATTRIBUTE4_O in VARCHAR2
,P_ABR_ATTRIBUTE5_O in VARCHAR2
,P_ABR_ATTRIBUTE6_O in VARCHAR2
,P_ABR_ATTRIBUTE7_O in VARCHAR2
,P_ABR_ATTRIBUTE8_O in VARCHAR2
,P_ABR_ATTRIBUTE9_O in VARCHAR2
,P_ABR_ATTRIBUTE10_O in VARCHAR2
,P_ABR_ATTRIBUTE11_O in VARCHAR2
,P_ABR_ATTRIBUTE12_O in VARCHAR2
,P_ABR_ATTRIBUTE13_O in VARCHAR2
,P_ABR_ATTRIBUTE14_O in VARCHAR2
,P_ABR_ATTRIBUTE15_O in VARCHAR2
,P_ABR_ATTRIBUTE16_O in VARCHAR2
,P_ABR_ATTRIBUTE17_O in VARCHAR2
,P_ABR_ATTRIBUTE18_O in VARCHAR2
,P_ABR_ATTRIBUTE19_O in VARCHAR2
,P_ABR_ATTRIBUTE20_O in VARCHAR2
,P_ABR_ATTRIBUTE21_O in VARCHAR2
,P_ABR_ATTRIBUTE22_O in VARCHAR2
,P_ABR_ATTRIBUTE23_O in VARCHAR2
,P_ABR_ATTRIBUTE24_O in VARCHAR2
,P_ABR_ATTRIBUTE25_O in VARCHAR2
,P_ABR_ATTRIBUTE26_O in VARCHAR2
,P_ABR_ATTRIBUTE27_O in VARCHAR2
,P_ABR_ATTRIBUTE28_O in VARCHAR2
,P_ABR_ATTRIBUTE29_O in VARCHAR2
,P_ABR_ATTRIBUTE30_O in VARCHAR2
,P_ABR_SEQ_NUM_O in NUMBER
,P_OBJECT_VERSION_NUMBER_O in NUMBER
)is
begin
hr_utility.set_location('Entering: ben_abr_RKU.AFTER_UPDATE', 10);

Line: 284

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

Line: 285

end AFTER_UPDATE;