[Home] [Help]
12: procedure update_cer_with_target(p_copy_entity_txn_id number)
13: is
14: l_counter number;
15: begin
16: l_counter := nvl(ben_pd_copy_to_ben_one.g_pk_tbl.LAST, 0);
17: if l_counter > 0 then
18: for i in 1..l_counter loop
19: update ben_copy_entity_results
20: set information9 = ben_pd_copy_to_ben_one.g_pk_tbl(i).copy_reuse_type||'-'||ben_pd_copy_to_ben_one.g_pk_tbl(i).new_value
16: l_counter := nvl(ben_pd_copy_to_ben_one.g_pk_tbl.LAST, 0);
17: if l_counter > 0 then
18: for i in 1..l_counter loop
19: update ben_copy_entity_results
20: set information9 = ben_pd_copy_to_ben_one.g_pk_tbl(i).copy_reuse_type||'-'||ben_pd_copy_to_ben_one.g_pk_tbl(i).new_value
21: where copy_entity_txn_id = p_copy_entity_txn_id
22: and table_route_id = ben_pd_copy_to_ben_one.g_pk_tbl(i).table_route_id
23: and nvl(information1,-999) = nvl(ben_pd_copy_to_ben_one.g_pk_tbl(i).old_value,-999) ;
24: end loop;
18: for i in 1..l_counter loop
19: update ben_copy_entity_results
20: set information9 = ben_pd_copy_to_ben_one.g_pk_tbl(i).copy_reuse_type||'-'||ben_pd_copy_to_ben_one.g_pk_tbl(i).new_value
21: where copy_entity_txn_id = p_copy_entity_txn_id
22: and table_route_id = ben_pd_copy_to_ben_one.g_pk_tbl(i).table_route_id
23: and nvl(information1,-999) = nvl(ben_pd_copy_to_ben_one.g_pk_tbl(i).old_value,-999) ;
24: end loop;
25: end if;
26:
19: update ben_copy_entity_results
20: set information9 = ben_pd_copy_to_ben_one.g_pk_tbl(i).copy_reuse_type||'-'||ben_pd_copy_to_ben_one.g_pk_tbl(i).new_value
21: where copy_entity_txn_id = p_copy_entity_txn_id
22: and table_route_id = ben_pd_copy_to_ben_one.g_pk_tbl(i).table_route_id
23: and nvl(information1,-999) = nvl(ben_pd_copy_to_ben_one.g_pk_tbl(i).old_value,-999) ;
24: end loop;
25: end if;
26:
27: /* Using FORALL gives compilation error -
28: ** Cannot reference fields of BULK In-BIND table of records
29: */
30:
31: /*
32: forall i in ben_pd_copy_to_ben_one.g_pk_tbl.FIRST..ben_pd_copy_to_ben_one.g_pk_tbl.LAST
33: update ben_copy_entity_results
34: set information9 = ben_pd_copy_to_ben_one.g_pk_tbl(i).copy_reuse_type||'-'||ben_pd_copy_to_ben_one.g_pk_tbl(i).new_value
35: where copy_entity_txn_id = p_copy_entity_txn_id
36: and table_route_id = ben_pd_copy_to_ben_one.g_pk_tbl(i).table_route_id
30:
31: /*
32: forall i in ben_pd_copy_to_ben_one.g_pk_tbl.FIRST..ben_pd_copy_to_ben_one.g_pk_tbl.LAST
33: update ben_copy_entity_results
34: set information9 = ben_pd_copy_to_ben_one.g_pk_tbl(i).copy_reuse_type||'-'||ben_pd_copy_to_ben_one.g_pk_tbl(i).new_value
35: where copy_entity_txn_id = p_copy_entity_txn_id
36: and table_route_id = ben_pd_copy_to_ben_one.g_pk_tbl(i).table_route_id
37: and information1 = ben_pd_copy_to_ben_one.g_pk_tbl(i).old_value ;
38: */
32: forall i in ben_pd_copy_to_ben_one.g_pk_tbl.FIRST..ben_pd_copy_to_ben_one.g_pk_tbl.LAST
33: update ben_copy_entity_results
34: set information9 = ben_pd_copy_to_ben_one.g_pk_tbl(i).copy_reuse_type||'-'||ben_pd_copy_to_ben_one.g_pk_tbl(i).new_value
35: where copy_entity_txn_id = p_copy_entity_txn_id
36: and table_route_id = ben_pd_copy_to_ben_one.g_pk_tbl(i).table_route_id
37: and information1 = ben_pd_copy_to_ben_one.g_pk_tbl(i).old_value ;
38: */
39:
40: end update_cer_with_target ;
33: update ben_copy_entity_results
34: set information9 = ben_pd_copy_to_ben_one.g_pk_tbl(i).copy_reuse_type||'-'||ben_pd_copy_to_ben_one.g_pk_tbl(i).new_value
35: where copy_entity_txn_id = p_copy_entity_txn_id
36: and table_route_id = ben_pd_copy_to_ben_one.g_pk_tbl(i).table_route_id
37: and information1 = ben_pd_copy_to_ben_one.g_pk_tbl(i).old_value ;
38: */
39:
40: end update_cer_with_target ;
41:
3132: );
3133:
3134:
3135: -- Programs
3136: if ben_pd_copy_to_ben_one.g_pgm_tbl_copied_count > 0 then
3137: create_process_log
3138: (p_module_cd => l_module_cd
3139: ,p_txn_id => p_copy_entity_txn_id
3140: ,p_message_text => l_label_start_tag||l_pgm_label||l_label_end_tag||l_blank_line
3140: ,p_message_text => l_label_start_tag||l_pgm_label||l_label_end_tag||l_blank_line
3141: ,p_message_type_cd => l_label
3142: );
3143:
3144: for i in ben_pd_copy_to_ben_one.g_pgm_tbl_copied.first .. ben_pd_copy_to_ben_one.g_pgm_tbl_copied.last
3145: loop
3146: create_process_log
3147: (p_module_cd => l_module_cd
3148: ,p_txn_id => p_copy_entity_txn_id
3146: create_process_log
3147: (p_module_cd => l_module_cd
3148: ,p_txn_id => p_copy_entity_txn_id
3149: ,p_message_text => l_value_start_tag ||l_para_spacer
3150: ||ben_pd_copy_to_ben_one.g_pgm_tbl_copied(i).new_name
3151: || l_value_end_tag||l_blank_line
3152: ,p_message_type_cd => l_value
3153: );
3154: end loop;
3154: end loop;
3155: end if;
3156:
3157: -- Plan Types
3158: if ben_pd_copy_to_ben_one.g_ptp_tbl_copied_count > 0 then
3159: create_process_log
3160: (p_module_cd => l_module_cd
3161: ,p_txn_id => p_copy_entity_txn_id
3162: ,p_message_text => l_label_start_tag||l_ptp_label||l_label_end_tag||l_blank_line
3162: ,p_message_text => l_label_start_tag||l_ptp_label||l_label_end_tag||l_blank_line
3163: ,p_message_type_cd => l_label
3164: );
3165:
3166: for i in ben_pd_copy_to_ben_one.g_ptp_tbl_copied.first .. ben_pd_copy_to_ben_one.g_ptp_tbl_copied.last
3167: loop
3168: create_process_log
3169: (p_module_cd => l_module_cd
3170: ,p_txn_id => p_copy_entity_txn_id
3168: create_process_log
3169: (p_module_cd => l_module_cd
3170: ,p_txn_id => p_copy_entity_txn_id
3171: ,p_message_text => l_value_start_tag ||l_para_spacer
3172: ||ben_pd_copy_to_ben_one.g_ptp_tbl_copied(i).new_name
3173: ||l_value_end_tag||l_blank_line
3174: ,p_message_type_cd => l_value
3175: );
3176: end loop;
3176: end loop;
3177: end if;
3178:
3179: -- Plans
3180: if ben_pd_copy_to_ben_one.g_pln_tbl_copied_count > 0 then
3181: create_process_log
3182: (p_module_cd => l_module_cd
3183: ,p_txn_id => p_copy_entity_txn_id
3184: ,p_message_text => l_label_start_tag||l_pln_label||l_label_end_tag||l_blank_line
3184: ,p_message_text => l_label_start_tag||l_pln_label||l_label_end_tag||l_blank_line
3185: ,p_message_type_cd => l_label
3186: );
3187:
3188: for i in ben_pd_copy_to_ben_one.g_pln_tbl_copied.first .. ben_pd_copy_to_ben_one.g_pln_tbl_copied.last
3189: loop
3190: create_process_log
3191: (p_module_cd => l_module_cd
3192: ,p_txn_id => p_copy_entity_txn_id
3190: create_process_log
3191: (p_module_cd => l_module_cd
3192: ,p_txn_id => p_copy_entity_txn_id
3193: ,p_message_text => l_value_start_tag ||l_para_spacer
3194: ||ben_pd_copy_to_ben_one.g_pln_tbl_copied(i).new_name
3195: ||l_value_end_tag||l_blank_line
3196: ,p_message_type_cd => l_value
3197: );
3198: end loop;
3198: end loop;
3199: end if;
3200:
3201: -- Options
3202: if ben_pd_copy_to_ben_one.g_opt_tbl_copied_count > 0 then
3203: create_process_log
3204: (p_module_cd => l_module_cd
3205: ,p_txn_id => p_copy_entity_txn_id
3206: ,p_message_text => l_label_start_tag||l_opt_label||l_label_end_tag||l_blank_line
3206: ,p_message_text => l_label_start_tag||l_opt_label||l_label_end_tag||l_blank_line
3207: ,p_message_type_cd => l_label
3208: );
3209:
3210: for i in ben_pd_copy_to_ben_one.g_opt_tbl_copied.first .. ben_pd_copy_to_ben_one.g_opt_tbl_copied.last
3211: loop
3212: create_process_log
3213: (p_module_cd => l_module_cd
3214: ,p_txn_id => p_copy_entity_txn_id
3212: create_process_log
3213: (p_module_cd => l_module_cd
3214: ,p_txn_id => p_copy_entity_txn_id
3215: ,p_message_text => l_value_start_tag ||l_para_spacer
3216: ||ben_pd_copy_to_ben_one.g_opt_tbl_copied(i).new_name
3217: ||l_value_end_tag||l_blank_line
3218: ,p_message_type_cd => l_value
3219: );
3220: end loop;
3220: end loop;
3221: end if;
3222:
3223: -- Rates
3224: if ben_pd_copy_to_ben_one.g_abr_tbl_copied_count > 0 then
3225: create_process_log
3226: (p_module_cd => l_module_cd
3227: ,p_txn_id => p_copy_entity_txn_id
3228: ,p_message_text => l_label_start_tag||l_abr_label||l_label_end_tag||l_blank_line
3229: ,p_message_type_cd => l_label
3230: );
3231:
3232:
3233: for i in ben_pd_copy_to_ben_one.g_abr_tbl_copied.first .. ben_pd_copy_to_ben_one.g_abr_tbl_copied.last
3234: loop
3235: create_process_log
3236: (p_module_cd => l_module_cd
3237: ,p_txn_id => p_copy_entity_txn_id
3235: create_process_log
3236: (p_module_cd => l_module_cd
3237: ,p_txn_id => p_copy_entity_txn_id
3238: ,p_message_text => l_value_start_tag ||l_para_spacer
3239: ||ben_pd_copy_to_ben_one.g_abr_tbl_copied(i).new_name
3240: ||l_value_end_tag||l_blank_line
3241: ,p_message_type_cd => l_value
3242: );
3243: end loop;
3258:
3259: end if;
3260:
3261: -- Benefit Pools
3262: if ben_pd_copy_to_ben_one.g_bpp_tbl_copied_count > 0 then
3263: create_process_log
3264: (p_module_cd => l_module_cd
3265: ,p_txn_id => p_copy_entity_txn_id
3266: ,p_message_text => l_label_start_tag||l_bpp_label||l_label_end_tag||l_blank_line
3266: ,p_message_text => l_label_start_tag||l_bpp_label||l_label_end_tag||l_blank_line
3267: ,p_message_type_cd => l_label
3268: );
3269:
3270: for i in ben_pd_copy_to_ben_one.g_bpp_tbl_copied.first .. ben_pd_copy_to_ben_one.g_bpp_tbl_copied.last
3271: loop
3272: create_process_log
3273: (p_module_cd => l_module_cd
3274: ,p_txn_id => p_copy_entity_txn_id
3272: create_process_log
3273: (p_module_cd => l_module_cd
3274: ,p_txn_id => p_copy_entity_txn_id
3275: ,p_message_text => l_value_start_tag ||l_para_spacer
3276: ||ben_pd_copy_to_ben_one.g_bpp_tbl_copied(i).new_name
3277: ||l_value_end_tag||l_blank_line
3278: ,p_message_type_cd => l_value
3279: );
3280: end loop;
3280: end loop;
3281: end if;
3282:
3283: -- Actual Premiums
3284: if ben_pd_copy_to_ben_one.g_apr_tbl_copied_count > 0 then
3285: create_process_log
3286: (p_module_cd => l_module_cd
3287: ,p_txn_id => p_copy_entity_txn_id
3288: ,p_message_text => l_label_start_tag||l_apr_label||l_label_end_tag||l_blank_line
3288: ,p_message_text => l_label_start_tag||l_apr_label||l_label_end_tag||l_blank_line
3289: ,p_message_type_cd => l_label
3290: );
3291:
3292: for i in ben_pd_copy_to_ben_one.g_apr_tbl_copied.first .. ben_pd_copy_to_ben_one.g_apr_tbl_copied.last
3293: loop
3294: create_process_log
3295: (p_module_cd => l_module_cd
3296: ,p_txn_id => p_copy_entity_txn_id
3294: create_process_log
3295: (p_module_cd => l_module_cd
3296: ,p_txn_id => p_copy_entity_txn_id
3297: ,p_message_text => l_value_start_tag ||l_para_spacer
3298: ||ben_pd_copy_to_ben_one.g_apr_tbl_copied(i).new_name
3299: ||l_value_end_tag||l_blank_line
3300: ,p_message_type_cd => l_value
3301: );
3302: end loop;
3302: end loop;
3303: end if;
3304:
3305: -- Coverages
3306: if ben_pd_copy_to_ben_one.g_ccm_tbl_copied_count > 0 then
3307: create_process_log
3308: (p_module_cd => l_module_cd
3309: ,p_txn_id => p_copy_entity_txn_id
3310: ,p_message_text => l_label_start_tag||l_ccm_label||l_label_end_tag||l_blank_line
3310: ,p_message_text => l_label_start_tag||l_ccm_label||l_label_end_tag||l_blank_line
3311: ,p_message_type_cd => l_label
3312: );
3313:
3314: for i in ben_pd_copy_to_ben_one.g_ccm_tbl_copied.first .. ben_pd_copy_to_ben_one.g_ccm_tbl_copied.last
3315: loop
3316: create_process_log
3317: (p_module_cd => l_module_cd
3318: ,p_txn_id => p_copy_entity_txn_id
3316: create_process_log
3317: (p_module_cd => l_module_cd
3318: ,p_txn_id => p_copy_entity_txn_id
3319: ,p_message_text => l_value_start_tag ||l_para_spacer
3320: ||ben_pd_copy_to_ben_one.g_ccm_tbl_copied(i).new_name
3321: ||l_value_end_tag||l_blank_line
3322: ,p_message_type_cd => l_value
3323: );
3324: end loop;
3324: end loop;
3325: end if;
3326:
3327: -- Coverage across Plan Types
3328: if ben_pd_copy_to_ben_one.g_acp_tbl_copied_count > 0 then
3329: create_process_log
3330: (p_module_cd => l_module_cd
3331: ,p_txn_id => p_copy_entity_txn_id
3332: ,p_message_text => l_label_start_tag||l_acp_label||l_label_end_tag||l_blank_line
3332: ,p_message_text => l_label_start_tag||l_acp_label||l_label_end_tag||l_blank_line
3333: ,p_message_type_cd => l_label
3334: );
3335:
3336: for i in ben_pd_copy_to_ben_one.g_acp_tbl_copied.first .. ben_pd_copy_to_ben_one.g_acp_tbl_copied.last
3337: loop
3338: create_process_log
3339: (p_module_cd => l_module_cd
3340: ,p_txn_id => p_copy_entity_txn_id
3338: create_process_log
3339: (p_module_cd => l_module_cd
3340: ,p_txn_id => p_copy_entity_txn_id
3341: ,p_message_text => l_value_start_tag ||l_para_spacer
3342: ||ben_pd_copy_to_ben_one.g_acp_tbl_copied(i).new_name
3343: ||l_value_end_tag||l_blank_line
3344: ,p_message_type_cd => l_value
3345: );
3346: end loop;
3347: end if;
3348:
3349:
3350: -- Life Events
3351: if ben_pd_copy_to_ben_one.g_ler_tbl_copied_count > 0 then
3352: create_process_log
3353: (p_module_cd => l_module_cd
3354: ,p_txn_id => p_copy_entity_txn_id
3355: ,p_message_text => l_label_start_tag||l_ler_label||l_label_end_tag||l_blank_line
3355: ,p_message_text => l_label_start_tag||l_ler_label||l_label_end_tag||l_blank_line
3356: ,p_message_type_cd => l_label
3357: );
3358:
3359: for i in ben_pd_copy_to_ben_one.g_ler_tbl_copied.first .. ben_pd_copy_to_ben_one.g_ler_tbl_copied.last
3360: loop
3361: create_process_log
3362: (p_module_cd => l_module_cd
3363: ,p_txn_id => p_copy_entity_txn_id
3361: create_process_log
3362: (p_module_cd => l_module_cd
3363: ,p_txn_id => p_copy_entity_txn_id
3364: ,p_message_text => l_value_start_tag ||l_para_spacer
3365: ||ben_pd_copy_to_ben_one.g_ler_tbl_copied(i).new_name
3366: ||l_value_end_tag||l_blank_line
3367: ,p_message_type_cd => l_value
3368: );
3369: end loop;
3369: end loop;
3370: end if;
3371:
3372: -- Life Events(Person Change)
3373: if ben_pd_copy_to_ben_one.g_psl_tbl_copied_count > 0 then
3374: create_process_log
3375: (p_module_cd => l_module_cd
3376: ,p_txn_id => p_copy_entity_txn_id
3377: ,p_message_text => l_label_start_tag||l_psl_label||l_label_end_tag||l_blank_line
3377: ,p_message_text => l_label_start_tag||l_psl_label||l_label_end_tag||l_blank_line
3378: ,p_message_type_cd => l_label
3379: );
3380:
3381: for i in ben_pd_copy_to_ben_one.g_psl_tbl_copied.first .. ben_pd_copy_to_ben_one.g_psl_tbl_copied.last
3382: loop
3383: create_process_log
3384: (p_module_cd => l_module_cd
3385: ,p_txn_id => p_copy_entity_txn_id
3383: create_process_log
3384: (p_module_cd => l_module_cd
3385: ,p_txn_id => p_copy_entity_txn_id
3386: ,p_message_text => l_value_start_tag ||l_para_spacer
3387: ||ben_pd_copy_to_ben_one.g_psl_tbl_copied(i).new_name
3388: ||l_value_end_tag||l_blank_line
3389: ,p_message_type_cd => l_value
3390: );
3391: end loop;
3391: end loop;
3392: end if;
3393:
3394: -- Eligibility profiles
3395: if ben_pd_copy_to_ben_one.g_elp_tbl_copied_count > 0 then
3396: create_process_log
3397: (p_module_cd => l_module_cd
3398: ,p_txn_id => p_copy_entity_txn_id
3399: ,p_message_text => l_label_start_tag||l_elp_label||l_label_end_tag||l_blank_line
3399: ,p_message_text => l_label_start_tag||l_elp_label||l_label_end_tag||l_blank_line
3400: ,p_message_type_cd => l_label
3401: );
3402:
3403: for i in ben_pd_copy_to_ben_one.g_elp_tbl_copied.first .. ben_pd_copy_to_ben_one.g_elp_tbl_copied.last
3404: loop
3405: create_process_log
3406: (p_module_cd => l_module_cd
3407: ,p_txn_id => p_copy_entity_txn_id
3405: create_process_log
3406: (p_module_cd => l_module_cd
3407: ,p_txn_id => p_copy_entity_txn_id
3408: ,p_message_text => l_value_start_tag ||l_para_spacer
3409: ||ben_pd_copy_to_ben_one.g_elp_tbl_copied(i).new_name
3410: ||l_value_end_tag||l_blank_line
3411: ,p_message_type_cd => l_value
3412: );
3413: end loop;
3413: end loop;
3414: end if;
3415:
3416: -- Dependent Eligibility profiles
3417: if ben_pd_copy_to_ben_one.g_dce_tbl_copied_count > 0 then
3418: create_process_log
3419: (p_module_cd => l_module_cd
3420: ,p_txn_id => p_copy_entity_txn_id
3421: ,p_message_text => l_label_start_tag||l_dce_label||l_label_end_tag||l_blank_line
3421: ,p_message_text => l_label_start_tag||l_dce_label||l_label_end_tag||l_blank_line
3422: ,p_message_type_cd => l_label
3423: );
3424:
3425: for i in ben_pd_copy_to_ben_one.g_dce_tbl_copied.first .. ben_pd_copy_to_ben_one.g_dce_tbl_copied.last
3426: loop
3427: create_process_log
3428: (p_module_cd => l_module_cd
3429: ,p_txn_id => p_copy_entity_txn_id
3427: create_process_log
3428: (p_module_cd => l_module_cd
3429: ,p_txn_id => p_copy_entity_txn_id
3430: ,p_message_text => l_value_start_tag ||l_para_spacer
3431: ||ben_pd_copy_to_ben_one.g_dce_tbl_copied(i).new_name
3432: ||l_value_end_tag||l_blank_line
3433: ,p_message_type_cd => l_value
3434: );
3435: end loop;
3435: end loop;
3436: end if;
3437:
3438: -- Variable Rate Profiles
3439: if ben_pd_copy_to_ben_one.g_vpf_tbl_copied_count > 0 then
3440: create_process_log
3441: (p_module_cd => l_module_cd
3442: ,p_txn_id => p_copy_entity_txn_id
3443: ,p_message_text => l_label_start_tag||l_vpf_label||l_label_end_tag||l_blank_line
3443: ,p_message_text => l_label_start_tag||l_vpf_label||l_label_end_tag||l_blank_line
3444: ,p_message_type_cd => l_label
3445: );
3446:
3447: for i in ben_pd_copy_to_ben_one.g_vpf_tbl_copied.first .. ben_pd_copy_to_ben_one.g_vpf_tbl_copied.last
3448: loop
3449: create_process_log
3450: (p_module_cd => l_module_cd
3451: ,p_txn_id => p_copy_entity_txn_id
3449: create_process_log
3450: (p_module_cd => l_module_cd
3451: ,p_txn_id => p_copy_entity_txn_id
3452: ,p_message_text => l_value_start_tag ||l_para_spacer
3453: ||ben_pd_copy_to_ben_one.g_vpf_tbl_copied(i).new_name
3454: ||l_value_end_tag||l_blank_line
3455: ,p_message_type_cd => l_value
3456: );
3457: end loop;
3459: --
3460: -- Bug 4169120 : Rate By Criteria
3461: -- Eligibility Criteria
3462: --
3463: if ben_pd_copy_to_ben_one.g_egl_tbl_copied_count > 0 then
3464: create_process_log
3465: (p_module_cd => l_module_cd
3466: ,p_txn_id => p_copy_entity_txn_id
3467: ,p_message_text => l_label_start_tag||l_egl_label||l_label_end_tag||l_blank_line
3467: ,p_message_text => l_label_start_tag||l_egl_label||l_label_end_tag||l_blank_line
3468: ,p_message_type_cd => l_label
3469: );
3470:
3471: for i in ben_pd_copy_to_ben_one.g_egl_tbl_copied.first .. ben_pd_copy_to_ben_one.g_egl_tbl_copied.last
3472: loop
3473: create_process_log
3474: (p_module_cd => l_module_cd
3475: ,p_txn_id => p_copy_entity_txn_id
3473: create_process_log
3474: (p_module_cd => l_module_cd
3475: ,p_txn_id => p_copy_entity_txn_id
3476: ,p_message_text => l_value_start_tag ||l_para_spacer
3477: ||ben_pd_copy_to_ben_one.g_egl_tbl_copied(i).new_name
3478: ||l_value_end_tag||l_blank_line
3479: ,p_message_type_cd => l_value
3480: );
3481: end loop;
3481: end loop;
3482: end if;
3483: --
3484: -- Benefit Balances
3485: if ben_pd_copy_to_ben_one.g_bnb_tbl_copied_count > 0 then
3486: create_process_log
3487: (p_module_cd => l_module_cd
3488: ,p_txn_id => p_copy_entity_txn_id
3489: ,p_message_text => l_label_start_tag||l_bnb_label||l_label_end_tag||l_blank_line
3489: ,p_message_text => l_label_start_tag||l_bnb_label||l_label_end_tag||l_blank_line
3490: ,p_message_type_cd => l_label
3491: );
3492:
3493: for i in ben_pd_copy_to_ben_one.g_bnb_tbl_copied.first .. ben_pd_copy_to_ben_one.g_bnb_tbl_copied.last
3494: loop
3495: create_process_log
3496: (p_module_cd => l_module_cd
3497: ,p_txn_id => p_copy_entity_txn_id
3495: create_process_log
3496: (p_module_cd => l_module_cd
3497: ,p_txn_id => p_copy_entity_txn_id
3498: ,p_message_text => l_value_start_tag ||l_para_spacer
3499: ||ben_pd_copy_to_ben_one.g_bnb_tbl_copied(i).new_name
3500: ||l_value_end_tag||l_blank_line
3501: ,p_message_type_cd => l_value
3502: );
3503: end loop;
3503: end loop;
3504: end if;
3505:
3506: -- Comp Level Factor
3507: if ben_pd_copy_to_ben_one.g_clf_tbl_copied_count > 0 then
3508: create_process_log
3509: (p_module_cd => l_module_cd
3510: ,p_txn_id => p_copy_entity_txn_id
3511: ,p_message_text => l_label_start_tag||l_clf_label||l_label_end_tag||l_blank_line
3511: ,p_message_text => l_label_start_tag||l_clf_label||l_label_end_tag||l_blank_line
3512: ,p_message_type_cd => l_label
3513: );
3514:
3515: for i in ben_pd_copy_to_ben_one.g_clf_tbl_copied.first .. ben_pd_copy_to_ben_one.g_clf_tbl_copied.last
3516: loop
3517: create_process_log
3518: (p_module_cd => l_module_cd
3519: ,p_txn_id => p_copy_entity_txn_id
3517: create_process_log
3518: (p_module_cd => l_module_cd
3519: ,p_txn_id => p_copy_entity_txn_id
3520: ,p_message_text => l_value_start_tag ||l_para_spacer
3521: ||ben_pd_copy_to_ben_one.g_clf_tbl_copied(i).new_name
3522: ||l_value_end_tag||l_blank_line
3523: ,p_message_type_cd => l_value
3524: );
3525: end loop;
3525: end loop;
3526: end if;
3527:
3528: -- Hours Worked Factor
3529: if ben_pd_copy_to_ben_one.g_hwf_tbl_copied_count > 0 then
3530: create_process_log
3531: (p_module_cd => l_module_cd
3532: ,p_txn_id => p_copy_entity_txn_id
3533: ,p_message_text => l_label_start_tag||l_hwf_label||l_label_end_tag||l_blank_line
3533: ,p_message_text => l_label_start_tag||l_hwf_label||l_label_end_tag||l_blank_line
3534: ,p_message_type_cd => l_label
3535: );
3536:
3537: for i in ben_pd_copy_to_ben_one.g_hwf_tbl_copied.first .. ben_pd_copy_to_ben_one.g_hwf_tbl_copied.last
3538: loop
3539: create_process_log
3540: (p_module_cd => l_module_cd
3541: ,p_txn_id => p_copy_entity_txn_id
3539: create_process_log
3540: (p_module_cd => l_module_cd
3541: ,p_txn_id => p_copy_entity_txn_id
3542: ,p_message_text => l_value_start_tag ||l_para_spacer
3543: ||ben_pd_copy_to_ben_one.g_hwf_tbl_copied(i).new_name
3544: ||l_value_end_tag||l_blank_line
3545: ,p_message_type_cd => l_value
3546: );
3547: end loop;
3547: end loop;
3548: end if;
3549:
3550: -- Age Factor
3551: if ben_pd_copy_to_ben_one.g_agf_tbl_copied_count > 0 then
3552: create_process_log
3553: (p_module_cd => l_module_cd
3554: ,p_txn_id => p_copy_entity_txn_id
3555: ,p_message_text => l_label_start_tag||l_agf_label||l_label_end_tag||l_blank_line
3555: ,p_message_text => l_label_start_tag||l_agf_label||l_label_end_tag||l_blank_line
3556: ,p_message_type_cd => l_label
3557: );
3558:
3559: for i in ben_pd_copy_to_ben_one.g_agf_tbl_copied.first .. ben_pd_copy_to_ben_one.g_agf_tbl_copied.last
3560: loop
3561: create_process_log
3562: (p_module_cd => l_module_cd
3563: ,p_txn_id => p_copy_entity_txn_id
3561: create_process_log
3562: (p_module_cd => l_module_cd
3563: ,p_txn_id => p_copy_entity_txn_id
3564: ,p_message_text => l_value_start_tag ||l_para_spacer
3565: ||ben_pd_copy_to_ben_one.g_agf_tbl_copied(i).new_name
3566: ||l_value_end_tag||l_blank_line
3567: ,p_message_type_cd => l_value
3568: );
3569: end loop;
3569: end loop;
3570: end if;
3571:
3572: -- Length of Service Factor
3573: if ben_pd_copy_to_ben_one.g_lsf_tbl_copied_count > 0 then
3574: create_process_log
3575: (p_module_cd => l_module_cd
3576: ,p_txn_id => p_copy_entity_txn_id
3577: ,p_message_text => l_label_start_tag||l_lsf_label||l_label_end_tag||l_blank_line
3577: ,p_message_text => l_label_start_tag||l_lsf_label||l_label_end_tag||l_blank_line
3578: ,p_message_type_cd => l_label
3579: );
3580:
3581: for i in ben_pd_copy_to_ben_one.g_lsf_tbl_copied.first .. ben_pd_copy_to_ben_one.g_lsf_tbl_copied.last
3582: loop
3583: create_process_log
3584: (p_module_cd => l_module_cd
3585: ,p_txn_id => p_copy_entity_txn_id
3583: create_process_log
3584: (p_module_cd => l_module_cd
3585: ,p_txn_id => p_copy_entity_txn_id
3586: ,p_message_text => l_value_start_tag ||l_para_spacer
3587: ||ben_pd_copy_to_ben_one.g_lsf_tbl_copied(i).new_name
3588: ||l_value_end_tag||l_blank_line
3589: ,p_message_type_cd => l_value
3590: );
3591: end loop;
3591: end loop;
3592: end if;
3593:
3594: -- Percent Full Time factor
3595: if ben_pd_copy_to_ben_one.g_pff_tbl_copied_count > 0 then
3596: create_process_log
3597: (p_module_cd => l_module_cd
3598: ,p_txn_id => p_copy_entity_txn_id
3599: ,p_message_text => l_label_start_tag||l_pff_label||l_label_end_tag||l_blank_line
3599: ,p_message_text => l_label_start_tag||l_pff_label||l_label_end_tag||l_blank_line
3600: ,p_message_type_cd => l_label
3601: );
3602:
3603: for i in ben_pd_copy_to_ben_one.g_pff_tbl_copied.first .. ben_pd_copy_to_ben_one.g_pff_tbl_copied.last
3604: loop
3605: create_process_log
3606: (p_module_cd => l_module_cd
3607: ,p_txn_id => p_copy_entity_txn_id
3605: create_process_log
3606: (p_module_cd => l_module_cd
3607: ,p_txn_id => p_copy_entity_txn_id
3608: ,p_message_text => l_value_start_tag ||l_para_spacer
3609: ||ben_pd_copy_to_ben_one.g_pff_tbl_copied(i).new_name
3610: ||l_value_end_tag||l_blank_line
3611: ,p_message_type_cd => l_value
3612: );
3613: end loop;
3613: end loop;
3614: end if;
3615:
3616: -- Combined LOS and Age Factor
3617: if ben_pd_copy_to_ben_one.g_cla_tbl_copied_count > 0 then
3618: create_process_log
3619: (p_module_cd => l_module_cd
3620: ,p_txn_id => p_copy_entity_txn_id
3621: ,p_message_text => l_label_start_tag||l_cla_label||l_label_end_tag||l_blank_line
3621: ,p_message_text => l_label_start_tag||l_cla_label||l_label_end_tag||l_blank_line
3622: ,p_message_type_cd => l_label
3623: );
3624:
3625: for i in ben_pd_copy_to_ben_one.g_cla_tbl_copied.first .. ben_pd_copy_to_ben_one.g_cla_tbl_copied.last
3626: loop
3627: create_process_log
3628: (p_module_cd => l_module_cd
3629: ,p_txn_id => p_copy_entity_txn_id
3627: create_process_log
3628: (p_module_cd => l_module_cd
3629: ,p_txn_id => p_copy_entity_txn_id
3630: ,p_message_text => l_value_start_tag ||l_para_spacer
3631: ||ben_pd_copy_to_ben_one.g_cla_tbl_copied(i).new_name
3632: ||l_value_end_tag||l_blank_line
3633: ,p_message_type_cd => l_value
3634: );
3635: end loop;
3635: end loop;
3636: end if;
3637:
3638: -- Regulations
3639: if ben_pd_copy_to_ben_one.g_reg_tbl_copied_count > 0 then
3640: create_process_log
3641: (p_module_cd => l_module_cd
3642: ,p_txn_id => p_copy_entity_txn_id
3643: ,p_message_text => l_label_start_tag||l_reg_label||l_label_end_tag||l_blank_line
3643: ,p_message_text => l_label_start_tag||l_reg_label||l_label_end_tag||l_blank_line
3644: ,p_message_type_cd => l_label
3645: );
3646:
3647: for i in ben_pd_copy_to_ben_one.g_reg_tbl_copied.first .. ben_pd_copy_to_ben_one.g_reg_tbl_copied.last
3648: loop
3649: create_process_log
3650: (p_module_cd => l_module_cd
3651: ,p_txn_id => p_copy_entity_txn_id
3649: create_process_log
3650: (p_module_cd => l_module_cd
3651: ,p_txn_id => p_copy_entity_txn_id
3652: ,p_message_text => l_value_start_tag ||l_para_spacer
3653: ||ben_pd_copy_to_ben_one.g_reg_tbl_copied(i).new_name
3654: ||l_value_end_tag||l_blank_line
3655: ,p_message_type_cd => l_value
3656: );
3657: end loop;
3657: end loop;
3658: end if;
3659:
3660: -- Reporting Groups
3661: if ben_pd_copy_to_ben_one.g_bnr_tbl_copied_count > 0 then
3662: create_process_log
3663: (p_module_cd => l_module_cd
3664: ,p_txn_id => p_copy_entity_txn_id
3665: ,p_message_text => l_label_start_tag||l_bnr_label||l_label_end_tag||l_blank_line
3665: ,p_message_text => l_label_start_tag||l_bnr_label||l_label_end_tag||l_blank_line
3666: ,p_message_type_cd => l_label
3667: );
3668:
3669: for i in ben_pd_copy_to_ben_one.g_bnr_tbl_copied.first .. ben_pd_copy_to_ben_one.g_bnr_tbl_copied.last
3670: loop
3671: create_process_log
3672: (p_module_cd => l_module_cd
3673: ,p_txn_id => p_copy_entity_txn_id
3671: create_process_log
3672: (p_module_cd => l_module_cd
3673: ,p_txn_id => p_copy_entity_txn_id
3674: ,p_message_text => l_value_start_tag ||l_para_spacer
3675: ||ben_pd_copy_to_ben_one.g_bnr_tbl_copied(i).new_name
3676: ||l_value_end_tag||l_blank_line
3677: ,p_message_type_cd => l_value
3678: );
3679: end loop;
3679: end loop;
3680: end if;
3681:
3682: -- Benefits Group
3683: if ben_pd_copy_to_ben_one.g_bng_tbl_copied_count > 0 then
3684: create_process_log
3685: (p_module_cd => l_module_cd
3686: ,p_txn_id => p_copy_entity_txn_id
3687: ,p_message_text => l_label_start_tag||l_bng_label||l_label_end_tag||l_blank_line
3687: ,p_message_text => l_label_start_tag||l_bng_label||l_label_end_tag||l_blank_line
3688: ,p_message_type_cd => l_label
3689: );
3690:
3691: for i in ben_pd_copy_to_ben_one.g_bng_tbl_copied.first .. ben_pd_copy_to_ben_one.g_bng_tbl_copied.last
3692: loop
3693: create_process_log
3694: (p_module_cd => l_module_cd
3695: ,p_txn_id => p_copy_entity_txn_id
3693: create_process_log
3694: (p_module_cd => l_module_cd
3695: ,p_txn_id => p_copy_entity_txn_id
3696: ,p_message_text => l_value_start_tag ||l_para_spacer
3697: ||ben_pd_copy_to_ben_one.g_bng_tbl_copied(i).new_name
3698: ||l_value_end_tag||l_blank_line
3699: ,p_message_type_cd => l_value
3700: );
3701: end loop;
3701: end loop;
3702: end if;
3703:
3704: -- Goods or services
3705: if ben_pd_copy_to_ben_one.g_gos_tbl_copied_count > 0 then
3706: create_process_log
3707: (p_module_cd => l_module_cd
3708: ,p_txn_id => p_copy_entity_txn_id
3709: ,p_message_text => l_label_start_tag||l_gos_label||l_label_end_tag||l_blank_line
3709: ,p_message_text => l_label_start_tag||l_gos_label||l_label_end_tag||l_blank_line
3710: ,p_message_type_cd => l_label
3711: );
3712:
3713: for i in ben_pd_copy_to_ben_one.g_gos_tbl_copied.first .. ben_pd_copy_to_ben_one.g_gos_tbl_copied.last
3714: loop
3715: create_process_log
3716: (p_module_cd => l_module_cd
3717: ,p_txn_id => p_copy_entity_txn_id
3715: create_process_log
3716: (p_module_cd => l_module_cd
3717: ,p_txn_id => p_copy_entity_txn_id
3718: ,p_message_text => l_value_start_tag ||l_para_spacer
3719: ||ben_pd_copy_to_ben_one.g_gos_tbl_copied(i).new_name
3720: ||l_value_end_tag||l_blank_line
3721: ,p_message_type_cd => l_value
3722: );
3723: end loop;
3723: end loop;
3724: end if;
3725:
3726: -- Period To Date Limits
3727: if ben_pd_copy_to_ben_one.g_pdl_tbl_copied_count > 0 then
3728: create_process_log
3729: (p_module_cd => l_module_cd
3730: ,p_txn_id => p_copy_entity_txn_id
3731: ,p_message_text => l_label_start_tag||l_pdl_label||l_label_end_tag||l_blank_line
3731: ,p_message_text => l_label_start_tag||l_pdl_label||l_label_end_tag||l_blank_line
3732: ,p_message_type_cd => l_label
3733: );
3734:
3735: for i in ben_pd_copy_to_ben_one.g_pdl_tbl_copied.first .. ben_pd_copy_to_ben_one.g_pdl_tbl_copied.last
3736: loop
3737: create_process_log
3738: (p_module_cd => l_module_cd
3739: ,p_txn_id => p_copy_entity_txn_id
3737: create_process_log
3738: (p_module_cd => l_module_cd
3739: ,p_txn_id => p_copy_entity_txn_id
3740: ,p_message_text => l_value_start_tag ||l_para_spacer
3741: ||ben_pd_copy_to_ben_one.g_pdl_tbl_copied(i).new_name
3742: ||l_value_end_tag||l_blank_line
3743: ,p_message_type_cd => l_value
3744: );
3745: end loop;
3745: end loop;
3746: end if;
3747:
3748: -- Service Area
3749: if ben_pd_copy_to_ben_one.g_sva_tbl_copied_count > 0 then
3750: create_process_log
3751: (p_module_cd => l_module_cd
3752: ,p_txn_id => p_copy_entity_txn_id
3753: ,p_message_text => l_label_start_tag||l_sva_label||l_label_end_tag||l_blank_line
3753: ,p_message_text => l_label_start_tag||l_sva_label||l_label_end_tag||l_blank_line
3754: ,p_message_type_cd => l_label
3755: );
3756:
3757: for i in ben_pd_copy_to_ben_one.g_sva_tbl_copied.first .. ben_pd_copy_to_ben_one.g_sva_tbl_copied.last
3758: loop
3759: create_process_log
3760: (p_module_cd => l_module_cd
3761: ,p_txn_id => p_copy_entity_txn_id
3759: create_process_log
3760: (p_module_cd => l_module_cd
3761: ,p_txn_id => p_copy_entity_txn_id
3762: ,p_message_text => l_value_start_tag ||l_para_spacer
3763: ||ben_pd_copy_to_ben_one.g_sva_tbl_copied(i).new_name
3764: ||l_value_end_tag||l_blank_line
3765: ,p_message_type_cd => l_value
3766: );
3767: end loop;
3769:
3770:
3771: /*
3772: -- Action Types
3773: if ben_pd_copy_to_ben_one.g_eat_tbl_copied_count > 0 then
3774: create_process_log
3775: (p_module_cd => l_module_cd
3776: ,p_txn_id => p_copy_entity_txn_id
3777: ,p_message_text => l_label_start_tag||l_eat_label||l_label_end_tag||l_blank_line
3777: ,p_message_text => l_label_start_tag||l_eat_label||l_label_end_tag||l_blank_line
3778: ,p_message_type_cd => l_label
3779: );
3780:
3781: for i in ben_pd_copy_to_ben_one.g_eat_tbl_copied.first .. ben_pd_copy_to_ben_one.g_eat_tbl_copied.last
3782: loop
3783: create_process_log
3784: (p_module_cd => l_module_cd
3785: ,p_txn_id => p_copy_entity_txn_id
3783: create_process_log
3784: (p_module_cd => l_module_cd
3785: ,p_txn_id => p_copy_entity_txn_id
3786: ,p_message_text => l_value_start_tag ||l_para_spacer
3787: ||ben_pd_copy_to_ben_one.g_eat_tbl_copied(i).new_name
3788: ||l_value_end_tag||l_blank_line
3789: ,p_message_type_cd => l_value
3790: );
3791: end loop;
3792: end if;
3793: */
3794:
3795: -- Combination PLIP
3796: if ben_pd_copy_to_ben_one.g_cpl_tbl_copied_count > 0 then
3797: create_process_log
3798: (p_module_cd => l_module_cd
3799: ,p_txn_id => p_copy_entity_txn_id
3800: ,p_message_text => l_label_start_tag||l_cpl_label||l_label_end_tag||l_blank_line
3800: ,p_message_text => l_label_start_tag||l_cpl_label||l_label_end_tag||l_blank_line
3801: ,p_message_type_cd => l_label
3802: );
3803:
3804: for i in ben_pd_copy_to_ben_one.g_cpl_tbl_copied.first .. ben_pd_copy_to_ben_one.g_cpl_tbl_copied.last
3805: loop
3806: create_process_log
3807: (p_module_cd => l_module_cd
3808: ,p_txn_id => p_copy_entity_txn_id
3806: create_process_log
3807: (p_module_cd => l_module_cd
3808: ,p_txn_id => p_copy_entity_txn_id
3809: ,p_message_text => l_value_start_tag ||l_para_spacer
3810: ||ben_pd_copy_to_ben_one.g_cpl_tbl_copied(i).new_name
3811: ||l_value_end_tag||l_blank_line
3812: ,p_message_type_cd => l_value
3813: );
3814: end loop;
3814: end loop;
3815: end if;
3816:
3817: -- Combination PTIP
3818: if ben_pd_copy_to_ben_one.g_cbp_tbl_copied_count > 0 then
3819: create_process_log
3820: (p_module_cd => l_module_cd
3821: ,p_txn_id => p_copy_entity_txn_id
3822: ,p_message_text => l_label_start_tag||l_cbp_label||l_label_end_tag||l_blank_line
3822: ,p_message_text => l_label_start_tag||l_cbp_label||l_label_end_tag||l_blank_line
3823: ,p_message_type_cd => l_label
3824: );
3825:
3826: for i in ben_pd_copy_to_ben_one.g_cbp_tbl_copied.first .. ben_pd_copy_to_ben_one.g_cbp_tbl_copied.last
3827: loop
3828: create_process_log
3829: (p_module_cd => l_module_cd
3830: ,p_txn_id => p_copy_entity_txn_id
3828: create_process_log
3829: (p_module_cd => l_module_cd
3830: ,p_txn_id => p_copy_entity_txn_id
3831: ,p_message_text => l_value_start_tag ||l_para_spacer
3832: ||ben_pd_copy_to_ben_one.g_cbp_tbl_copied(i).new_name
3833: ||l_value_end_tag||l_blank_line
3834: ,p_message_type_cd => l_value
3835: );
3836: end loop;
3836: end loop;
3837: end if;
3838:
3839: -- Combination PTIP OPT
3840: if ben_pd_copy_to_ben_one.g_cpt_tbl_copied_count > 0 then
3841: create_process_log
3842: (p_module_cd => l_module_cd
3843: ,p_txn_id => p_copy_entity_txn_id
3844: ,p_message_text => l_label_start_tag||l_cpt_label||l_label_end_tag||l_blank_line
3844: ,p_message_text => l_label_start_tag||l_cpt_label||l_label_end_tag||l_blank_line
3845: ,p_message_type_cd => l_label
3846: );
3847:
3848: for i in ben_pd_copy_to_ben_one.g_cpt_tbl_copied.first .. ben_pd_copy_to_ben_one.g_cpt_tbl_copied.last
3849: loop
3850: create_process_log
3851: (p_module_cd => l_module_cd
3852: ,p_txn_id => p_copy_entity_txn_id
3850: create_process_log
3851: (p_module_cd => l_module_cd
3852: ,p_txn_id => p_copy_entity_txn_id
3853: ,p_message_text => l_value_start_tag ||l_para_spacer
3854: ||ben_pd_copy_to_ben_one.g_cpt_tbl_copied(i).new_name
3855: ||l_value_end_tag||l_blank_line
3856: ,p_message_type_cd => l_value
3857: );
3858: end loop;
3858: end loop;
3859: end if;
3860:
3861: -- Fast Formulas
3862: if ben_pd_copy_to_ben_one.g_fff_tbl_copied_count > 0 then
3863: create_process_log
3864: (p_module_cd => l_module_cd
3865: ,p_txn_id => p_copy_entity_txn_id
3866: ,p_message_text => l_label_start_tag||l_fff_label||l_label_end_tag||l_blank_line
3866: ,p_message_text => l_label_start_tag||l_fff_label||l_label_end_tag||l_blank_line
3867: ,p_message_type_cd => l_label
3868: );
3869:
3870: for i in ben_pd_copy_to_ben_one.g_fff_tbl_copied.first .. ben_pd_copy_to_ben_one.g_fff_tbl_copied.last
3871: loop
3872: create_process_log
3873: (p_module_cd => l_module_cd
3874: ,p_txn_id => p_copy_entity_txn_id
3872: create_process_log
3873: (p_module_cd => l_module_cd
3874: ,p_txn_id => p_copy_entity_txn_id
3875: ,p_message_text => l_value_start_tag ||l_para_spacer
3876: ||ben_pd_copy_to_ben_one.g_fff_tbl_copied(i).new_name
3877: ||l_value_end_tag||l_blank_line
3878: ,p_message_type_cd => l_value
3879: );
3880: end loop;
3910: ,p_message_type_cd => l_spacer
3911: );
3912:
3913: -- Programs
3914: if ben_pd_copy_to_ben_one.g_pgm_tbl_reused_count > 0 then
3915: create_process_log
3916: (p_module_cd => l_module_cd
3917: ,p_txn_id => p_copy_entity_txn_id
3918: ,p_message_text => l_label_start_tag||l_pgm_label||l_label_end_tag||l_blank_line
3918: ,p_message_text => l_label_start_tag||l_pgm_label||l_label_end_tag||l_blank_line
3919: ,p_message_type_cd => l_label
3920: );
3921:
3922: for i in ben_pd_copy_to_ben_one.g_pgm_tbl_reused.first .. ben_pd_copy_to_ben_one.g_pgm_tbl_reused.last
3923: loop
3924: create_process_log
3925: (p_module_cd => l_module_cd
3926: ,p_txn_id => p_copy_entity_txn_id
3924: create_process_log
3925: (p_module_cd => l_module_cd
3926: ,p_txn_id => p_copy_entity_txn_id
3927: ,p_message_text => l_value_start_tag ||l_para_spacer
3928: ||ben_pd_copy_to_ben_one.g_pgm_tbl_reused(i).new_name
3929: ||l_value_end_tag||l_blank_line
3930: ,p_message_type_cd => l_value
3931: );
3932: end loop;
3932: end loop;
3933: end if;
3934:
3935: -- Plan Types
3936: if ben_pd_copy_to_ben_one.g_ptp_tbl_reused_count > 0 then
3937: create_process_log
3938: (p_module_cd => l_module_cd
3939: ,p_txn_id => p_copy_entity_txn_id
3940: ,p_message_text => l_label_start_tag||l_ptp_label||l_label_end_tag||l_blank_line
3940: ,p_message_text => l_label_start_tag||l_ptp_label||l_label_end_tag||l_blank_line
3941: ,p_message_type_cd => l_label
3942: );
3943:
3944: for i in ben_pd_copy_to_ben_one.g_ptp_tbl_reused.first .. ben_pd_copy_to_ben_one.g_ptp_tbl_reused.last
3945: loop
3946: create_process_log
3947: (p_module_cd => l_module_cd
3948: ,p_txn_id => p_copy_entity_txn_id
3946: create_process_log
3947: (p_module_cd => l_module_cd
3948: ,p_txn_id => p_copy_entity_txn_id
3949: ,p_message_text => l_value_start_tag ||l_para_spacer
3950: ||ben_pd_copy_to_ben_one.g_ptp_tbl_reused(i).new_name
3951: ||l_value_end_tag||l_blank_line
3952: ,p_message_type_cd => l_value
3953: );
3954: end loop;
3954: end loop;
3955: end if;
3956:
3957: -- Plans
3958: if ben_pd_copy_to_ben_one.g_pln_tbl_reused_count > 0 then
3959: create_process_log
3960: (p_module_cd => l_module_cd
3961: ,p_txn_id => p_copy_entity_txn_id
3962: ,p_message_text => l_label_start_tag||l_pln_label||l_label_end_tag||l_blank_line
3962: ,p_message_text => l_label_start_tag||l_pln_label||l_label_end_tag||l_blank_line
3963: ,p_message_type_cd => l_label
3964: );
3965:
3966: for i in ben_pd_copy_to_ben_one.g_pln_tbl_reused.first .. ben_pd_copy_to_ben_one.g_pln_tbl_reused.last
3967: loop
3968: create_process_log
3969: (p_module_cd => l_module_cd
3970: ,p_txn_id => p_copy_entity_txn_id
3968: create_process_log
3969: (p_module_cd => l_module_cd
3970: ,p_txn_id => p_copy_entity_txn_id
3971: ,p_message_text => l_value_start_tag ||l_para_spacer
3972: ||ben_pd_copy_to_ben_one.g_pln_tbl_reused(i).new_name
3973: ||l_value_end_tag||l_blank_line
3974: ,p_message_type_cd => l_value
3975: );
3976: end loop;
3976: end loop;
3977: end if;
3978:
3979: -- Options
3980: if ben_pd_copy_to_ben_one.g_opt_tbl_reused_count > 0 then
3981: create_process_log
3982: (p_module_cd => l_module_cd
3983: ,p_txn_id => p_copy_entity_txn_id
3984: ,p_message_text => l_label_start_tag||l_opt_label||l_label_end_tag||l_blank_line
3984: ,p_message_text => l_label_start_tag||l_opt_label||l_label_end_tag||l_blank_line
3985: ,p_message_type_cd => l_label
3986: );
3987:
3988: for i in ben_pd_copy_to_ben_one.g_opt_tbl_reused.first .. ben_pd_copy_to_ben_one.g_opt_tbl_reused.last
3989: loop
3990: create_process_log
3991: (p_module_cd => l_module_cd
3992: ,p_txn_id => p_copy_entity_txn_id
3990: create_process_log
3991: (p_module_cd => l_module_cd
3992: ,p_txn_id => p_copy_entity_txn_id
3993: ,p_message_text => l_value_start_tag ||l_para_spacer
3994: ||ben_pd_copy_to_ben_one.g_opt_tbl_reused(i).new_name
3995: ||l_value_end_tag||l_blank_line
3996: ,p_message_type_cd => l_value
3997: );
3998: end loop;
3998: end loop;
3999: end if;
4000:
4001: -- Rates
4002: if ben_pd_copy_to_ben_one.g_abr_tbl_reused_count > 0 then
4003: create_process_log
4004: (p_module_cd => l_module_cd
4005: ,p_txn_id => p_copy_entity_txn_id
4006: ,p_message_text => l_label_start_tag||l_abr_label||l_label_end_tag||l_blank_line
4006: ,p_message_text => l_label_start_tag||l_abr_label||l_label_end_tag||l_blank_line
4007: ,p_message_type_cd => l_label
4008: );
4009:
4010: for i in ben_pd_copy_to_ben_one.g_abr_tbl_reused.first .. ben_pd_copy_to_ben_one.g_abr_tbl_reused.last
4011: loop
4012: create_process_log
4013: (p_module_cd => l_module_cd
4014: ,p_txn_id => p_copy_entity_txn_id
4012: create_process_log
4013: (p_module_cd => l_module_cd
4014: ,p_txn_id => p_copy_entity_txn_id
4015: ,p_message_text => l_value_start_tag ||l_para_spacer
4016: ||ben_pd_copy_to_ben_one.g_abr_tbl_reused(i).new_name
4017: ||l_value_end_tag||l_blank_line
4018: ,p_message_type_cd => l_value
4019: );
4020: end loop;
4020: end loop;
4021: end if;
4022:
4023: -- Benefit Pools
4024: if ben_pd_copy_to_ben_one.g_bpp_tbl_reused_count > 0 then
4025: create_process_log
4026: (p_module_cd => l_module_cd
4027: ,p_txn_id => p_copy_entity_txn_id
4028: ,p_message_text => l_label_start_tag||l_bpp_label||l_label_end_tag||l_blank_line
4028: ,p_message_text => l_label_start_tag||l_bpp_label||l_label_end_tag||l_blank_line
4029: ,p_message_type_cd => l_label
4030: );
4031:
4032: for i in ben_pd_copy_to_ben_one.g_bpp_tbl_reused.first .. ben_pd_copy_to_ben_one.g_bpp_tbl_reused.last
4033: loop
4034: create_process_log
4035: (p_module_cd => l_module_cd
4036: ,p_txn_id => p_copy_entity_txn_id
4034: create_process_log
4035: (p_module_cd => l_module_cd
4036: ,p_txn_id => p_copy_entity_txn_id
4037: ,p_message_text => l_value_start_tag ||l_para_spacer
4038: ||ben_pd_copy_to_ben_one.g_bpp_tbl_reused(i).new_name
4039: ||l_value_end_tag||l_blank_line
4040: ,p_message_type_cd => l_value
4041: );
4042: end loop;
4042: end loop;
4043: end if;
4044:
4045: -- Actual Premiums
4046: if ben_pd_copy_to_ben_one.g_apr_tbl_reused_count > 0 then
4047: create_process_log
4048: (p_module_cd => l_module_cd
4049: ,p_txn_id => p_copy_entity_txn_id
4050: ,p_message_text => l_label_start_tag||l_apr_label||l_label_end_tag||l_blank_line
4050: ,p_message_text => l_label_start_tag||l_apr_label||l_label_end_tag||l_blank_line
4051: ,p_message_type_cd => l_label
4052: );
4053:
4054: for i in ben_pd_copy_to_ben_one.g_apr_tbl_reused.first .. ben_pd_copy_to_ben_one.g_apr_tbl_reused.last
4055: loop
4056: create_process_log
4057: (p_module_cd => l_module_cd
4058: ,p_txn_id => p_copy_entity_txn_id
4056: create_process_log
4057: (p_module_cd => l_module_cd
4058: ,p_txn_id => p_copy_entity_txn_id
4059: ,p_message_text => l_value_start_tag ||l_para_spacer
4060: ||ben_pd_copy_to_ben_one.g_apr_tbl_reused(i).new_name
4061: ||l_value_end_tag||l_blank_line
4062: ,p_message_type_cd => l_value
4063: );
4064: end loop;
4064: end loop;
4065: end if;
4066:
4067: -- Coverages
4068: if ben_pd_copy_to_ben_one.g_ccm_tbl_reused_count > 0 then
4069: create_process_log
4070: (p_module_cd => l_module_cd
4071: ,p_txn_id => p_copy_entity_txn_id
4072: ,p_message_text => l_label_start_tag||l_ccm_label||l_label_end_tag||l_blank_line
4072: ,p_message_text => l_label_start_tag||l_ccm_label||l_label_end_tag||l_blank_line
4073: ,p_message_type_cd => l_label
4074: );
4075:
4076: for i in ben_pd_copy_to_ben_one.g_ccm_tbl_reused.first .. ben_pd_copy_to_ben_one.g_ccm_tbl_reused.last
4077: loop
4078: create_process_log
4079: (p_module_cd => l_module_cd
4080: ,p_txn_id => p_copy_entity_txn_id
4078: create_process_log
4079: (p_module_cd => l_module_cd
4080: ,p_txn_id => p_copy_entity_txn_id
4081: ,p_message_text => l_value_start_tag ||l_para_spacer
4082: ||ben_pd_copy_to_ben_one.g_ccm_tbl_reused(i).new_name
4083: ||l_value_end_tag||l_blank_line
4084: ,p_message_type_cd => l_value
4085: );
4086: end loop;
4086: end loop;
4087: end if;
4088:
4089: -- Coverage across Plan Types
4090: if ben_pd_copy_to_ben_one.g_acp_tbl_reused_count > 0 then
4091: create_process_log
4092: (p_module_cd => l_module_cd
4093: ,p_txn_id => p_copy_entity_txn_id
4094: ,p_message_text => l_label_start_tag||l_acp_label||l_label_end_tag||l_blank_line
4094: ,p_message_text => l_label_start_tag||l_acp_label||l_label_end_tag||l_blank_line
4095: ,p_message_type_cd => l_label
4096: );
4097:
4098: for i in ben_pd_copy_to_ben_one.g_acp_tbl_reused.first .. ben_pd_copy_to_ben_one.g_acp_tbl_reused.last
4099: loop
4100: create_process_log
4101: (p_module_cd => l_module_cd
4102: ,p_txn_id => p_copy_entity_txn_id
4100: create_process_log
4101: (p_module_cd => l_module_cd
4102: ,p_txn_id => p_copy_entity_txn_id
4103: ,p_message_text => l_value_start_tag ||l_para_spacer
4104: ||ben_pd_copy_to_ben_one.g_acp_tbl_reused(i).new_name
4105: ||l_value_end_tag||l_blank_line
4106: ,p_message_type_cd => l_value
4107: );
4108: end loop;
4108: end loop;
4109: end if;
4110:
4111: -- Life Events
4112: if ben_pd_copy_to_ben_one.g_ler_tbl_reused_count > 0 then
4113: create_process_log
4114: (p_module_cd => l_module_cd
4115: ,p_txn_id => p_copy_entity_txn_id
4116: ,p_message_text => l_label_start_tag||l_ler_label||l_label_end_tag||l_blank_line
4116: ,p_message_text => l_label_start_tag||l_ler_label||l_label_end_tag||l_blank_line
4117: ,p_message_type_cd => l_label
4118: );
4119:
4120: for i in ben_pd_copy_to_ben_one.g_ler_tbl_reused.first .. ben_pd_copy_to_ben_one.g_ler_tbl_reused.last
4121: loop
4122: create_process_log
4123: (p_module_cd => l_module_cd
4124: ,p_txn_id => p_copy_entity_txn_id
4122: create_process_log
4123: (p_module_cd => l_module_cd
4124: ,p_txn_id => p_copy_entity_txn_id
4125: ,p_message_text => l_value_start_tag ||l_para_spacer
4126: ||ben_pd_copy_to_ben_one.g_ler_tbl_reused(i).new_name
4127: ||l_value_end_tag||l_blank_line
4128: ,p_message_type_cd => l_value
4129: );
4130: end loop;
4131: end if;
4132:
4133:
4134: -- Life Events(Person Changes)
4135: if ben_pd_copy_to_ben_one.g_psl_tbl_reused_count > 0 then
4136: create_process_log
4137: (p_module_cd => l_module_cd
4138: ,p_txn_id => p_copy_entity_txn_id
4139: ,p_message_text => l_label_start_tag||l_psl_label||l_label_end_tag||l_blank_line
4139: ,p_message_text => l_label_start_tag||l_psl_label||l_label_end_tag||l_blank_line
4140: ,p_message_type_cd => l_label
4141: );
4142:
4143: for i in ben_pd_copy_to_ben_one.g_psl_tbl_reused.first .. ben_pd_copy_to_ben_one.g_psl_tbl_reused.last
4144: loop
4145: create_process_log
4146: (p_module_cd => l_module_cd
4147: ,p_txn_id => p_copy_entity_txn_id
4145: create_process_log
4146: (p_module_cd => l_module_cd
4147: ,p_txn_id => p_copy_entity_txn_id
4148: ,p_message_text => l_value_start_tag ||l_para_spacer
4149: ||ben_pd_copy_to_ben_one.g_psl_tbl_reused(i).new_name
4150: ||l_value_end_tag||l_blank_line
4151: ,p_message_type_cd => l_value
4152: );
4153: end loop;
4153: end loop;
4154: end if;
4155:
4156: -- Eligibility profiles
4157: if ben_pd_copy_to_ben_one.g_elp_tbl_reused_count > 0 then
4158: create_process_log
4159: (p_module_cd => l_module_cd
4160: ,p_txn_id => p_copy_entity_txn_id
4161: ,p_message_text => l_label_start_tag||l_elp_label||l_label_end_tag||l_blank_line
4161: ,p_message_text => l_label_start_tag||l_elp_label||l_label_end_tag||l_blank_line
4162: ,p_message_type_cd => l_label
4163: );
4164:
4165: for i in ben_pd_copy_to_ben_one.g_elp_tbl_reused.first .. ben_pd_copy_to_ben_one.g_elp_tbl_reused.last
4166: loop
4167: create_process_log
4168: (p_module_cd => l_module_cd
4169: ,p_txn_id => p_copy_entity_txn_id
4167: create_process_log
4168: (p_module_cd => l_module_cd
4169: ,p_txn_id => p_copy_entity_txn_id
4170: ,p_message_text => l_value_start_tag ||l_para_spacer
4171: ||ben_pd_copy_to_ben_one.g_elp_tbl_reused(i).new_name
4172: ||l_value_end_tag||l_blank_line
4173: ,p_message_type_cd => l_value
4174: );
4175: end loop;
4175: end loop;
4176: end if;
4177:
4178: -- Dependent Eligibility profiles
4179: if ben_pd_copy_to_ben_one.g_dce_tbl_reused_count > 0 then
4180: create_process_log
4181: (p_module_cd => l_module_cd
4182: ,p_txn_id => p_copy_entity_txn_id
4183: ,p_message_text => l_label_start_tag||l_dce_label||l_label_end_tag||l_blank_line
4183: ,p_message_text => l_label_start_tag||l_dce_label||l_label_end_tag||l_blank_line
4184: ,p_message_type_cd => l_label
4185: );
4186:
4187: for i in ben_pd_copy_to_ben_one.g_dce_tbl_reused.first .. ben_pd_copy_to_ben_one.g_dce_tbl_reused.last
4188: loop
4189: create_process_log
4190: (p_module_cd => l_module_cd
4191: ,p_txn_id => p_copy_entity_txn_id
4189: create_process_log
4190: (p_module_cd => l_module_cd
4191: ,p_txn_id => p_copy_entity_txn_id
4192: ,p_message_text => l_value_start_tag ||l_para_spacer
4193: ||ben_pd_copy_to_ben_one.g_dce_tbl_reused(i).new_name
4194: ||l_value_end_tag||l_blank_line
4195: ,p_message_type_cd => l_value
4196: );
4197: end loop;
4197: end loop;
4198: end if;
4199:
4200: -- Variable Rate Profiles
4201: if ben_pd_copy_to_ben_one.g_vpf_tbl_reused_count > 0 then
4202: create_process_log
4203: (p_module_cd => l_module_cd
4204: ,p_txn_id => p_copy_entity_txn_id
4205: ,p_message_text => l_label_start_tag||l_vpf_label||l_label_end_tag||l_blank_line
4205: ,p_message_text => l_label_start_tag||l_vpf_label||l_label_end_tag||l_blank_line
4206: ,p_message_type_cd => l_label
4207: );
4208:
4209: for i in ben_pd_copy_to_ben_one.g_vpf_tbl_reused.first .. ben_pd_copy_to_ben_one.g_vpf_tbl_reused.last
4210: loop
4211: create_process_log
4212: (p_module_cd => l_module_cd
4213: ,p_txn_id => p_copy_entity_txn_id
4211: create_process_log
4212: (p_module_cd => l_module_cd
4213: ,p_txn_id => p_copy_entity_txn_id
4214: ,p_message_text => l_value_start_tag ||l_para_spacer
4215: ||ben_pd_copy_to_ben_one.g_vpf_tbl_reused(i).new_name
4216: ||l_value_end_tag||l_blank_line
4217: ,p_message_type_cd => l_value
4218: );
4219: end loop;
4221: --
4222: -- Bug 4169120 : Rate By Criteria
4223: -- Eligibility Criteria
4224: --
4225: if ben_pd_copy_to_ben_one.g_egl_tbl_reused_count > 0 then
4226: create_process_log
4227: (p_module_cd => l_module_cd
4228: ,p_txn_id => p_copy_entity_txn_id
4229: ,p_message_text => l_label_start_tag||l_egl_label||l_label_end_tag||l_blank_line
4229: ,p_message_text => l_label_start_tag||l_egl_label||l_label_end_tag||l_blank_line
4230: ,p_message_type_cd => l_label
4231: );
4232:
4233: for i in ben_pd_copy_to_ben_one.g_egl_tbl_reused.first .. ben_pd_copy_to_ben_one.g_egl_tbl_reused.last
4234: loop
4235: create_process_log
4236: (p_module_cd => l_module_cd
4237: ,p_txn_id => p_copy_entity_txn_id
4235: create_process_log
4236: (p_module_cd => l_module_cd
4237: ,p_txn_id => p_copy_entity_txn_id
4238: ,p_message_text => l_value_start_tag ||l_para_spacer
4239: ||ben_pd_copy_to_ben_one.g_egl_tbl_reused(i).new_name
4240: ||l_value_end_tag||l_blank_line
4241: ,p_message_type_cd => l_value
4242: );
4243: end loop;
4243: end loop;
4244: end if;
4245: --
4246: -- Benefit Balances
4247: if ben_pd_copy_to_ben_one.g_bnb_tbl_reused_count > 0 then
4248: create_process_log
4249: (p_module_cd => l_module_cd
4250: ,p_txn_id => p_copy_entity_txn_id
4251: ,p_message_text => l_label_start_tag||l_bnb_label||l_label_end_tag||l_blank_line
4251: ,p_message_text => l_label_start_tag||l_bnb_label||l_label_end_tag||l_blank_line
4252: ,p_message_type_cd => l_label
4253: );
4254:
4255: for i in ben_pd_copy_to_ben_one.g_bnb_tbl_reused.first .. ben_pd_copy_to_ben_one.g_bnb_tbl_reused.last
4256: loop
4257: create_process_log
4258: (p_module_cd => l_module_cd
4259: ,p_txn_id => p_copy_entity_txn_id
4257: create_process_log
4258: (p_module_cd => l_module_cd
4259: ,p_txn_id => p_copy_entity_txn_id
4260: ,p_message_text => l_value_start_tag ||l_para_spacer
4261: ||ben_pd_copy_to_ben_one.g_bnb_tbl_reused(i).new_name
4262: ||l_value_end_tag||l_blank_line
4263: ,p_message_type_cd => l_value
4264: );
4265: end loop;
4265: end loop;
4266: end if;
4267:
4268: -- Comp Level Factor
4269: if ben_pd_copy_to_ben_one.g_clf_tbl_reused_count > 0 then
4270: create_process_log
4271: (p_module_cd => l_module_cd
4272: ,p_txn_id => p_copy_entity_txn_id
4273: ,p_message_text => l_label_start_tag||l_clf_label||l_label_end_tag||l_blank_line
4273: ,p_message_text => l_label_start_tag||l_clf_label||l_label_end_tag||l_blank_line
4274: ,p_message_type_cd => l_label
4275: );
4276:
4277: for i in ben_pd_copy_to_ben_one.g_clf_tbl_reused.first .. ben_pd_copy_to_ben_one.g_clf_tbl_reused.last
4278: loop
4279: create_process_log
4280: (p_module_cd => l_module_cd
4281: ,p_txn_id => p_copy_entity_txn_id
4279: create_process_log
4280: (p_module_cd => l_module_cd
4281: ,p_txn_id => p_copy_entity_txn_id
4282: ,p_message_text => l_value_start_tag ||l_para_spacer
4283: ||ben_pd_copy_to_ben_one.g_clf_tbl_reused(i).new_name
4284: ||l_value_end_tag||l_blank_line
4285: ,p_message_type_cd => l_value
4286: );
4287: end loop;
4287: end loop;
4288: end if;
4289:
4290: -- Hours Worked Factor
4291: if ben_pd_copy_to_ben_one.g_hwf_tbl_reused_count > 0 then
4292: create_process_log
4293: (p_module_cd => l_module_cd
4294: ,p_txn_id => p_copy_entity_txn_id
4295: ,p_message_text => l_label_start_tag||l_hwf_label||l_label_end_tag||l_blank_line
4295: ,p_message_text => l_label_start_tag||l_hwf_label||l_label_end_tag||l_blank_line
4296: ,p_message_type_cd => l_label
4297: );
4298:
4299: for i in ben_pd_copy_to_ben_one.g_hwf_tbl_reused.first .. ben_pd_copy_to_ben_one.g_hwf_tbl_reused.last
4300: loop
4301: create_process_log
4302: (p_module_cd => l_module_cd
4303: ,p_txn_id => p_copy_entity_txn_id
4301: create_process_log
4302: (p_module_cd => l_module_cd
4303: ,p_txn_id => p_copy_entity_txn_id
4304: ,p_message_text => l_value_start_tag ||l_para_spacer
4305: ||ben_pd_copy_to_ben_one.g_hwf_tbl_reused(i).new_name
4306: ||l_value_end_tag||l_blank_line
4307: ,p_message_type_cd => l_value
4308: );
4309: end loop;
4309: end loop;
4310: end if;
4311:
4312: -- Age Factor
4313: if ben_pd_copy_to_ben_one.g_agf_tbl_reused_count > 0 then
4314: create_process_log
4315: (p_module_cd => l_module_cd
4316: ,p_txn_id => p_copy_entity_txn_id
4317: ,p_message_text => l_label_start_tag||l_agf_label||l_label_end_tag||l_blank_line
4317: ,p_message_text => l_label_start_tag||l_agf_label||l_label_end_tag||l_blank_line
4318: ,p_message_type_cd => l_label
4319: );
4320:
4321: for i in ben_pd_copy_to_ben_one.g_agf_tbl_reused.first .. ben_pd_copy_to_ben_one.g_agf_tbl_reused.last
4322: loop
4323: create_process_log
4324: (p_module_cd => l_module_cd
4325: ,p_txn_id => p_copy_entity_txn_id
4323: create_process_log
4324: (p_module_cd => l_module_cd
4325: ,p_txn_id => p_copy_entity_txn_id
4326: ,p_message_text => l_value_start_tag ||l_para_spacer
4327: ||ben_pd_copy_to_ben_one.g_agf_tbl_reused(i).new_name
4328: ||l_value_end_tag||l_blank_line
4329: ,p_message_type_cd => l_value
4330: );
4331: end loop;
4331: end loop;
4332: end if;
4333:
4334: -- Length of Service Factor
4335: if ben_pd_copy_to_ben_one.g_lsf_tbl_reused_count > 0 then
4336: create_process_log
4337: (p_module_cd => l_module_cd
4338: ,p_txn_id => p_copy_entity_txn_id
4339: ,p_message_text => l_label_start_tag||l_lsf_label||l_label_end_tag||l_blank_line
4339: ,p_message_text => l_label_start_tag||l_lsf_label||l_label_end_tag||l_blank_line
4340: ,p_message_type_cd => l_label
4341: );
4342:
4343: for i in ben_pd_copy_to_ben_one.g_lsf_tbl_reused.first .. ben_pd_copy_to_ben_one.g_lsf_tbl_reused.last
4344: loop
4345: create_process_log
4346: (p_module_cd => l_module_cd
4347: ,p_txn_id => p_copy_entity_txn_id
4345: create_process_log
4346: (p_module_cd => l_module_cd
4347: ,p_txn_id => p_copy_entity_txn_id
4348: ,p_message_text => l_value_start_tag ||l_para_spacer
4349: ||ben_pd_copy_to_ben_one.g_lsf_tbl_reused(i).new_name
4350: ||l_value_end_tag||l_blank_line
4351: ,p_message_type_cd => l_value
4352: );
4353: end loop;
4353: end loop;
4354: end if;
4355:
4356: -- Percent Full Time factor
4357: if ben_pd_copy_to_ben_one.g_pff_tbl_reused_count > 0 then
4358: create_process_log
4359: (p_module_cd => l_module_cd
4360: ,p_txn_id => p_copy_entity_txn_id
4361: ,p_message_text => l_label_start_tag||l_pff_label||l_label_end_tag||l_blank_line
4361: ,p_message_text => l_label_start_tag||l_pff_label||l_label_end_tag||l_blank_line
4362: ,p_message_type_cd => l_label
4363: );
4364:
4365: for i in ben_pd_copy_to_ben_one.g_pff_tbl_reused.first .. ben_pd_copy_to_ben_one.g_pff_tbl_reused.last
4366: loop
4367: create_process_log
4368: (p_module_cd => l_module_cd
4369: ,p_txn_id => p_copy_entity_txn_id
4367: create_process_log
4368: (p_module_cd => l_module_cd
4369: ,p_txn_id => p_copy_entity_txn_id
4370: ,p_message_text => l_value_start_tag ||l_para_spacer
4371: ||ben_pd_copy_to_ben_one.g_pff_tbl_reused(i).new_name
4372: ||l_value_end_tag||l_blank_line
4373: ,p_message_type_cd => l_value
4374: );
4375: end loop;
4375: end loop;
4376: end if;
4377:
4378: -- Combined LOS and Age Factor
4379: if ben_pd_copy_to_ben_one.g_cla_tbl_reused_count > 0 then
4380: create_process_log
4381: (p_module_cd => l_module_cd
4382: ,p_txn_id => p_copy_entity_txn_id
4383: ,p_message_text => l_label_start_tag||l_cla_label||l_label_end_tag||l_blank_line
4383: ,p_message_text => l_label_start_tag||l_cla_label||l_label_end_tag||l_blank_line
4384: ,p_message_type_cd => l_label
4385: );
4386:
4387: for i in ben_pd_copy_to_ben_one.g_cla_tbl_reused.first .. ben_pd_copy_to_ben_one.g_cla_tbl_reused.last
4388: loop
4389: create_process_log
4390: (p_module_cd => l_module_cd
4391: ,p_txn_id => p_copy_entity_txn_id
4389: create_process_log
4390: (p_module_cd => l_module_cd
4391: ,p_txn_id => p_copy_entity_txn_id
4392: ,p_message_text => l_value_start_tag ||l_para_spacer
4393: ||ben_pd_copy_to_ben_one.g_cla_tbl_reused(i).new_name
4394: ||l_value_end_tag||l_blank_line
4395: ,p_message_type_cd => l_value
4396: );
4397: end loop;
4397: end loop;
4398: end if;
4399:
4400: -- Regulations
4401: if ben_pd_copy_to_ben_one.g_reg_tbl_reused_count > 0 then
4402: create_process_log
4403: (p_module_cd => l_module_cd
4404: ,p_txn_id => p_copy_entity_txn_id
4405: ,p_message_text => l_label_start_tag||l_reg_label||l_label_end_tag||l_blank_line
4405: ,p_message_text => l_label_start_tag||l_reg_label||l_label_end_tag||l_blank_line
4406: ,p_message_type_cd => l_label
4407: );
4408:
4409: for i in ben_pd_copy_to_ben_one.g_reg_tbl_reused.first .. ben_pd_copy_to_ben_one.g_reg_tbl_reused.last
4410: loop
4411: create_process_log
4412: (p_module_cd => l_module_cd
4413: ,p_txn_id => p_copy_entity_txn_id
4411: create_process_log
4412: (p_module_cd => l_module_cd
4413: ,p_txn_id => p_copy_entity_txn_id
4414: ,p_message_text => l_value_start_tag ||l_para_spacer
4415: ||ben_pd_copy_to_ben_one.g_reg_tbl_reused(i).new_name
4416: ||l_value_end_tag||l_blank_line
4417: ,p_message_type_cd => l_value
4418: );
4419: end loop;
4419: end loop;
4420: end if;
4421:
4422: -- Reporting Groups
4423: if ben_pd_copy_to_ben_one.g_bnr_tbl_reused_count > 0 then
4424: create_process_log
4425: (p_module_cd => l_module_cd
4426: ,p_txn_id => p_copy_entity_txn_id
4427: ,p_message_text => l_label_start_tag||l_bnr_label||l_label_end_tag||l_blank_line
4427: ,p_message_text => l_label_start_tag||l_bnr_label||l_label_end_tag||l_blank_line
4428: ,p_message_type_cd => l_label
4429: );
4430:
4431: for i in ben_pd_copy_to_ben_one.g_bnr_tbl_reused.first .. ben_pd_copy_to_ben_one.g_bnr_tbl_reused.last
4432: loop
4433: create_process_log
4434: (p_module_cd => l_module_cd
4435: ,p_txn_id => p_copy_entity_txn_id
4433: create_process_log
4434: (p_module_cd => l_module_cd
4435: ,p_txn_id => p_copy_entity_txn_id
4436: ,p_message_text => l_value_start_tag ||l_para_spacer
4437: ||ben_pd_copy_to_ben_one.g_bnr_tbl_reused(i).new_name
4438: ||l_value_end_tag||l_blank_line
4439: ,p_message_type_cd => l_value
4440: );
4441: end loop;
4441: end loop;
4442: end if;
4443:
4444: -- Benefits Group
4445: if ben_pd_copy_to_ben_one.g_bng_tbl_reused_count > 0 then
4446: create_process_log
4447: (p_module_cd => l_module_cd
4448: ,p_txn_id => p_copy_entity_txn_id
4449: ,p_message_text => l_label_start_tag||l_bng_label||l_label_end_tag||l_blank_line
4449: ,p_message_text => l_label_start_tag||l_bng_label||l_label_end_tag||l_blank_line
4450: ,p_message_type_cd => l_label
4451: );
4452:
4453: for i in ben_pd_copy_to_ben_one.g_bng_tbl_reused.first .. ben_pd_copy_to_ben_one.g_bng_tbl_reused.last
4454: loop
4455: create_process_log
4456: (p_module_cd => l_module_cd
4457: ,p_txn_id => p_copy_entity_txn_id
4455: create_process_log
4456: (p_module_cd => l_module_cd
4457: ,p_txn_id => p_copy_entity_txn_id
4458: ,p_message_text => l_value_start_tag ||l_para_spacer
4459: ||ben_pd_copy_to_ben_one.g_bng_tbl_reused(i).new_name
4460: ||l_value_end_tag||l_blank_line
4461: ,p_message_type_cd => l_value
4462: );
4463: end loop;
4463: end loop;
4464: end if;
4465:
4466: -- Goods or services
4467: if ben_pd_copy_to_ben_one.g_gos_tbl_reused_count > 0 then
4468: create_process_log
4469: (p_module_cd => l_module_cd
4470: ,p_txn_id => p_copy_entity_txn_id
4471: ,p_message_text => l_label_start_tag||l_gos_label||l_label_end_tag||l_blank_line
4471: ,p_message_text => l_label_start_tag||l_gos_label||l_label_end_tag||l_blank_line
4472: ,p_message_type_cd => l_label
4473: );
4474:
4475: for i in ben_pd_copy_to_ben_one.g_gos_tbl_reused.first .. ben_pd_copy_to_ben_one.g_gos_tbl_reused.last
4476: loop
4477: create_process_log
4478: (p_module_cd => l_module_cd
4479: ,p_txn_id => p_copy_entity_txn_id
4477: create_process_log
4478: (p_module_cd => l_module_cd
4479: ,p_txn_id => p_copy_entity_txn_id
4480: ,p_message_text => l_value_start_tag ||l_para_spacer
4481: ||ben_pd_copy_to_ben_one.g_gos_tbl_reused(i).new_name
4482: ||l_value_end_tag||l_blank_line
4483: ,p_message_type_cd => l_value
4484: );
4485: end loop;
4485: end loop;
4486: end if;
4487:
4488: -- Period To Date Limits
4489: if ben_pd_copy_to_ben_one.g_pdl_tbl_reused_count > 0 then
4490: create_process_log
4491: (p_module_cd => l_module_cd
4492: ,p_txn_id => p_copy_entity_txn_id
4493: ,p_message_text => l_label_start_tag||l_pdl_label||l_label_end_tag||l_blank_line
4493: ,p_message_text => l_label_start_tag||l_pdl_label||l_label_end_tag||l_blank_line
4494: ,p_message_type_cd => l_label
4495: );
4496:
4497: for i in ben_pd_copy_to_ben_one.g_pdl_tbl_reused.first .. ben_pd_copy_to_ben_one.g_pdl_tbl_reused.last
4498: loop
4499: create_process_log
4500: (p_module_cd => l_module_cd
4501: ,p_txn_id => p_copy_entity_txn_id
4499: create_process_log
4500: (p_module_cd => l_module_cd
4501: ,p_txn_id => p_copy_entity_txn_id
4502: ,p_message_text => l_value_start_tag ||l_para_spacer
4503: ||ben_pd_copy_to_ben_one.g_pdl_tbl_reused(i).new_name
4504: ||l_value_end_tag||l_blank_line
4505: ,p_message_type_cd => l_value
4506: );
4507: end loop;
4507: end loop;
4508: end if;
4509:
4510: -- Service Area
4511: if ben_pd_copy_to_ben_one.g_sva_tbl_reused_count > 0 then
4512: create_process_log
4513: (p_module_cd => l_module_cd
4514: ,p_txn_id => p_copy_entity_txn_id
4515: ,p_message_text => l_label_start_tag||l_sva_label||l_label_end_tag||l_blank_line
4515: ,p_message_text => l_label_start_tag||l_sva_label||l_label_end_tag||l_blank_line
4516: ,p_message_type_cd => l_label
4517: );
4518:
4519: for i in ben_pd_copy_to_ben_one.g_sva_tbl_reused.first .. ben_pd_copy_to_ben_one.g_sva_tbl_reused.last
4520: loop
4521: create_process_log
4522: (p_module_cd => l_module_cd
4523: ,p_txn_id => p_copy_entity_txn_id
4521: create_process_log
4522: (p_module_cd => l_module_cd
4523: ,p_txn_id => p_copy_entity_txn_id
4524: ,p_message_text => l_value_start_tag ||l_para_spacer
4525: ||ben_pd_copy_to_ben_one.g_sva_tbl_reused(i).new_name
4526: ||l_value_end_tag||l_blank_line
4527: ,p_message_type_cd => l_value
4528: );
4529: end loop;
4531:
4532:
4533: /*
4534: -- Action Types
4535: if ben_pd_copy_to_ben_one.g_eat_tbl_reused_count > 0 then
4536: create_process_log
4537: (p_module_cd => l_module_cd
4538: ,p_txn_id => p_copy_entity_txn_id
4539: ,p_message_text => l_label_start_tag||l_eat_label||l_label_end_tag||l_blank_line
4539: ,p_message_text => l_label_start_tag||l_eat_label||l_label_end_tag||l_blank_line
4540: ,p_message_type_cd => l_label
4541: );
4542:
4543: for i in ben_pd_copy_to_ben_one.g_eat_tbl_reused.first .. ben_pd_copy_to_ben_one.g_eat_tbl_reused.last
4544: loop
4545: create_process_log
4546: (p_module_cd => l_module_cd
4547: ,p_txn_id => p_copy_entity_txn_id
4545: create_process_log
4546: (p_module_cd => l_module_cd
4547: ,p_txn_id => p_copy_entity_txn_id
4548: ,p_message_text => l_value_start_tag ||l_para_spacer
4549: ||ben_pd_copy_to_ben_one.g_eat_tbl_reused(i).new_name
4550: ||l_value_end_tag||l_blank_line
4551: ,p_message_type_cd => l_value
4552: );
4553: end loop;
4554: end if;
4555: */
4556:
4557: -- Combination PLIP
4558: if ben_pd_copy_to_ben_one.g_cpl_tbl_reused_count > 0 then
4559: create_process_log
4560: (p_module_cd => l_module_cd
4561: ,p_txn_id => p_copy_entity_txn_id
4562: ,p_message_text => l_label_start_tag||l_cpl_label||l_label_end_tag||l_blank_line
4562: ,p_message_text => l_label_start_tag||l_cpl_label||l_label_end_tag||l_blank_line
4563: ,p_message_type_cd => l_label
4564: );
4565:
4566: for i in ben_pd_copy_to_ben_one.g_cpl_tbl_reused.first .. ben_pd_copy_to_ben_one.g_cpl_tbl_reused.last
4567: loop
4568: create_process_log
4569: (p_module_cd => l_module_cd
4570: ,p_txn_id => p_copy_entity_txn_id
4568: create_process_log
4569: (p_module_cd => l_module_cd
4570: ,p_txn_id => p_copy_entity_txn_id
4571: ,p_message_text => l_value_start_tag ||l_para_spacer
4572: ||ben_pd_copy_to_ben_one.g_cpl_tbl_reused(i).new_name
4573: ||l_value_end_tag||l_blank_line
4574: ,p_message_type_cd => l_value
4575: );
4576: end loop;
4576: end loop;
4577: end if;
4578:
4579: -- Combination PTIP
4580: if ben_pd_copy_to_ben_one.g_cbp_tbl_reused_count > 0 then
4581: create_process_log
4582: (p_module_cd => l_module_cd
4583: ,p_txn_id => p_copy_entity_txn_id
4584: ,p_message_text => l_label_start_tag||l_cbp_label||l_label_end_tag||l_blank_line
4584: ,p_message_text => l_label_start_tag||l_cbp_label||l_label_end_tag||l_blank_line
4585: ,p_message_type_cd => l_label
4586: );
4587:
4588: for i in ben_pd_copy_to_ben_one.g_cbp_tbl_reused.first .. ben_pd_copy_to_ben_one.g_cbp_tbl_reused.last
4589: loop
4590: create_process_log
4591: (p_module_cd => l_module_cd
4592: ,p_txn_id => p_copy_entity_txn_id
4590: create_process_log
4591: (p_module_cd => l_module_cd
4592: ,p_txn_id => p_copy_entity_txn_id
4593: ,p_message_text => l_value_start_tag ||l_para_spacer
4594: ||ben_pd_copy_to_ben_one.g_cbp_tbl_reused(i).new_name
4595: ||l_value_end_tag||l_blank_line
4596: ,p_message_type_cd => l_value
4597: );
4598: end loop;
4598: end loop;
4599: end if;
4600:
4601: -- Combination PTIP OPT
4602: if ben_pd_copy_to_ben_one.g_cpt_tbl_reused_count > 0 then
4603: create_process_log
4604: (p_module_cd => l_module_cd
4605: ,p_txn_id => p_copy_entity_txn_id
4606: ,p_message_text => l_label_start_tag||l_cpt_label||l_label_end_tag||l_blank_line
4606: ,p_message_text => l_label_start_tag||l_cpt_label||l_label_end_tag||l_blank_line
4607: ,p_message_type_cd => l_label
4608: );
4609:
4610: for i in ben_pd_copy_to_ben_one.g_cpt_tbl_reused.first .. ben_pd_copy_to_ben_one.g_cpt_tbl_reused.last
4611: loop
4612: create_process_log
4613: (p_module_cd => l_module_cd
4614: ,p_txn_id => p_copy_entity_txn_id
4612: create_process_log
4613: (p_module_cd => l_module_cd
4614: ,p_txn_id => p_copy_entity_txn_id
4615: ,p_message_text => l_value_start_tag ||l_para_spacer
4616: ||ben_pd_copy_to_ben_one.g_cpt_tbl_reused(i).new_name
4617: ||l_value_end_tag||l_blank_line
4618: ,p_message_type_cd => l_value
4619: );
4620: end loop;
4620: end loop;
4621: end if;
4622:
4623: -- Fast Formulas
4624: if ben_pd_copy_to_ben_one.g_fff_tbl_reused_count > 0 then
4625: create_process_log
4626: (p_module_cd => l_module_cd
4627: ,p_txn_id => p_copy_entity_txn_id
4628: ,p_message_text => l_label_start_tag||l_fff_label||l_label_end_tag||l_blank_line
4628: ,p_message_text => l_label_start_tag||l_fff_label||l_label_end_tag||l_blank_line
4629: ,p_message_type_cd => l_label
4630: );
4631:
4632: for i in ben_pd_copy_to_ben_one.g_fff_tbl_reused.first .. ben_pd_copy_to_ben_one.g_fff_tbl_reused.last
4633: loop
4634: create_process_log
4635: (p_module_cd => l_module_cd
4636: ,p_txn_id => p_copy_entity_txn_id
4634: create_process_log
4635: (p_module_cd => l_module_cd
4636: ,p_txn_id => p_copy_entity_txn_id
4637: ,p_message_text => l_value_start_tag ||l_para_spacer
4638: ||ben_pd_copy_to_ben_one.g_fff_tbl_reused(i).new_name
4639: ||l_value_end_tag||l_blank_line
4640: ,p_message_type_cd => l_value
4641: );
4642: end loop;