[Home] [Help]
3044: from ben_person_actions bpa
3045: Where bpa.benefit_action_id = c_benefit_action_id
3046: and EXISTS
3047: ( SELECT ers.PERSON_ID
3048: FROM BEN_EXT_RSLT_ERR ers
3049: WHERE ers.person_id = bpa.person_id
3050: AND ers.EXT_RSLT_ID= c_ext_rslt_id
3051: AND typ_cd = 'E');
3052:
3069: Set bpa.action_status_cd = 'U'
3070: Where bpa.benefit_action_id = l_ben_params.benefit_action_id -- 3629 -- p_benefit_action_id
3071: and bpa.person_id -- = p_person_id;
3072: IN ( SELECT PERSON_ID
3073: FROM BEN_EXT_RSLT_ERR
3074: WHERE EXT_RSLT_ID= Ben_Ext_Thread.g_ext_rslt_id -- 2891 -- c_ext_rslt_id
3075: AND typ_cd = 'E');
3076:
3077: Update ben_batch_ranges bbr
3078: set bbr.range_status_cd = 'E'
3079: Where bbr.benefit_action_id = l_ben_params.benefit_action_id
3080: AND EXISTS(
3081: Select 1 -- distinct(bere.person_id)
3082: From ben_person_actions bpa, BEN_EXT_RSLT_ERR bere
3083: Where bpa.benefit_action_id = l_ben_params.benefit_action_id
3084: AND bbr.benefit_action_id = bpa.benefit_action_id
3085: AND (bpa.person_action_id Between
3086: bbr.starting_person_action_id And bbr.ending_person_action_id)
3130: CURSOR csr_err_person_id
3131: (p_ext_rslt_id IN NUMBER)
3132: IS
3133: SELECT distinct(ers.PERSON_ID)
3134: FROM BEN_EXT_RSLT_ERR ers
3135: WHERE ers.EXT_RSLT_ID = p_ext_rslt_id
3136: AND typ_cd = 'E';
3137:
3138: CURSOR csr_range_id
3383: -- RAISE_EXTRACT_WARNING
3384: --
3385: -- "Smart" warning function.
3386: -- When called from the Rule of a extract detail data element
3387: -- it logs a warning in the ben_ext_rslt_err table against
3388: -- the person being processed (or as specified by context of
3389: -- assignment id ). It prefixes all warning messages with a
3390: -- string "Warning raised in data element "||element_name
3391: -- This allows the same Rule to be called from different data