[Home] [Help]
35: l_entry_status VARCHAR2(2);
36:
37: cursor csr_get_entry_status is
38: select ayi_information3
39: from per_kr_assignment_yea_info
40: where information_type = 'KR_YEA_ENTRY_STATUS'
41: and assignment_id = p_assignment_id
42: and target_year = p_target_year;
43: begin
336: info.ayi_information27,
337: info.ayi_information28,
338: info.ayi_information29,
339: info.ayi_information30
340: from per_kr_assignment_yea_info info
341: where assignment_id = p_assignment_id
342: and target_year = p_target_year
343: and information_type in ('KR_YEA_SP_TAX_EXEM_INFO'
344: ,'KR_YEA_SP_TAX_EXEM_INFO2'
390: info.ayi_information27,
391: info.ayi_information28,
392: info.ayi_information29,
393: info.ayi_information30
394: from per_kr_assignment_yea_info info
395: where assignment_id = p_assignment_id
396: and information_type = 'KR_YEA_FW_TAX_BREAK_INFO';
397:
398: Cursor csr_kr_assignment_yea_info3
429: info.ayi_information27,
430: info.ayi_information28,
431: info.ayi_information29,
432: info.ayi_information30
433: from per_kr_assignment_yea_info info
434: where assignment_id = p_assignment_id
435: and target_year = p_target_year
436: and information_type = 'KR_YEA_NON_TAXABLE_EARN_DETAIL';
437:
474: info.ayi_information30,
475: info.ayi_information31,
476: info.ayi_information32,
477: info.ayi_information33
478: from per_kr_assignment_yea_info info
479: where assignment_id = p_assignment_id
480: and target_year = p_target_year
481: and information_type = 'KR_YEA_PREV_ER_INFO';
482:
514: info.ayi_information28,
515: info.ayi_information29,
516: info.ayi_information30,
517: info.ayi_information31
518: from per_kr_assignment_yea_info info
519: where assignment_id = p_assignment_id
520: and target_year = p_target_year
521: and information_type = 'KR_YEA_TAX_EXEM_INFO';
522:
546: info.ayi_information9,
547: info.ayi_information10,
548: info.ayi_information11,
549: info.ayi_information12
550: from per_kr_assignment_yea_info info
551: where assignment_id = p_assignment_id
552: and target_year = p_target_year
553: and information_type = 'KR_YEA_TAX_EXEM_INFO2';
554: -- BUG 14321129 End
2268: p_result out nocopy varchar2)
2269: is
2270: cursor csr is
2271: select count(*)
2272: from PER_KR_ASSIGNMENT_YEA_INFO
2273: where assignment_id = p_assignment_id
2274: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
2275: and target_year = p_target_year
2276: and Ayi_information6 = p_ayi_information6;
2303: is
2304:
2305: cursor csr is
2306: select count(ayi_information2)
2307: from per_kr_assignment_yea_info
2308: where assignment_id = p_assignment_id
2309: and assignment_yea_info_id <> p_assignment_yea_info_id
2310: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
2311: and ayi_information2 = p_ayi_information2
2442: --
2443: cursor csr_get_temp_tbl_data(l_donation_year in varchar2, l_donation_code in varchar2) is
2444: select assignment_yea_info_id,
2445: object_version_number
2446: from per_kr_assignment_yea_info
2447: where assignment_id = p_assignment_id
2448: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
2449: and ayi_information2 = l_donation_year
2450: and ayi_information8 = l_donation_code
2465: close csr_get_temp_tbl_data;
2466: --
2467: if l_asg_extra_info_id is null then
2468: if (i.aei_information2 <> p_target_year) then
2469: insert into per_kr_assignment_yea_info
2470: (assignment_yea_info_id,
2471: assignment_id,
2472: information_type,
2473: target_year,
2484: ayi_information10,
2485: ayi_information11,
2486: object_version_number)
2487: values
2488: (PER_KR_ASSIGNMENT_YEA_INFO_S.nextval,
2489: p_assignment_id,
2490: 'KR_YEA_DONATION_TYPE_DETAIL',
2491: p_target_year,
2492: 'KR_YEA_DONATION_TYPE_DETAIL',
2506: else
2507: if((i.aei_information2 = p_target_year)
2508: and (pay_kr_ff_functions_pkg.display_yea_info(p_assignment_id,
2509: fnd_date.canonical_to_date(i.aei_information1)) = 'Y')) then
2510: update per_kr_assignment_yea_info
2511: set ayi_information4 = i.aei_information4,
2512: ayi_information11 = i.aei_information11,
2513: ayi_information5 = i.aei_information5
2514: where assignment_yea_info_id = l_asg_extra_info_id;
2512: ayi_information11 = i.aei_information11,
2513: ayi_information5 = i.aei_information5
2514: where assignment_yea_info_id = l_asg_extra_info_id;
2515: elsif(i.aei_information2 <> p_target_year) then
2516: update per_kr_assignment_yea_info
2517: set ayi_information3 = i.aei_information3,
2518: ayi_information4 = i.aei_information4,
2519: ayi_information5 = i.aei_information5,
2520: ayi_information9 = i.aei_information9,
2550: is
2551: --
2552: cursor csr_check_data(l_donation_code in varchar2) is
2553: select assignment_yea_info_id
2554: from per_kr_assignment_yea_info
2555: where assignment_id = p_assignment_id
2556: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
2557: and target_year = p_target_year
2558: and ayi_information2 = p_target_year
2566: is
2567: begin
2568: if ((l_asgInfoId) is not null and (l_amt > 0)) then
2569: --
2570: update per_kr_assignment_yea_info
2571: set ayi_information9 = l_amt,
2572: ayi_information10 = l_amt
2573: where assignment_yea_info_id = l_asgInfoId
2574: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
2576: --
2577: elsif ((l_asgInfoId) is not null and (l_amt = 0)) then
2578: --
2579: delete
2580: from per_kr_assignment_yea_info
2581: where assignment_yea_info_id = l_asgInfoId
2582: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
2583: and assignment_id = p_assignment_id;
2584: --
2583: and assignment_id = p_assignment_id;
2584: --
2585: elsif ((l_asgInfoId) is null and (l_amt > 0)) then
2586: --
2587: insert into per_kr_assignment_yea_info
2588: (assignment_yea_info_id,
2589: assignment_id,
2590: information_type,
2591: target_year,
2602: ayi_information10,
2603: ayi_information11,
2604: object_version_number)
2605: values
2606: (PER_KR_ASSIGNMENT_YEA_INFO_S.nextval,
2607: p_assignment_id,
2608: 'KR_YEA_DONATION_TYPE_DETAIL',
2609: p_target_year,
2610: 'KR_YEA_DONATION_TYPE_DETAIL',
2745: is
2746: --
2747: cursor csr_total_exists is
2748: select assignment_yea_info_id
2749: from per_kr_assignment_yea_info
2750: where assignment_id = p_assignment_id
2751: and information_type = 'KR_YEA_DONATION_TOTALS'
2752: and target_year = p_target_year;
2753:
2752: and target_year = p_target_year;
2753:
2754: cursor csr_ex_total_exists is
2755: select assignment_yea_info_id
2756: from per_kr_assignment_yea_info
2757: where assignment_id = p_assignment_id
2758: and information_type = 'KR_YEA_DONATION_TOTALS1'
2759: and target_year = p_target_year;
2760: --
2809: p_rel_bro_sis > 0 or
2810: p_oth_parent > 0 or
2811: p_oth_bro_sis > 0 ) then
2812: --
2813: update per_kr_assignment_yea_info
2814: set ayi_information2 = p_stat_self,
2815: ayi_information4 = p_stat_spouse,
2816: ayi_information3 = p_stat_child,
2817: ayi_information5 = p_pol_self,
2835: and information_type = 'KR_YEA_DONATION_TOTALS'
2836: and target_year = p_target_year;
2837:
2838: if l_ex_asg_info_id is null then
2839: insert into per_kr_assignment_yea_info
2840: (assignment_yea_info_id,
2841: assignment_id,
2842: information_type,
2843: target_year,
2856: ayi_information13,
2857: ayi_information17,
2858: object_version_number)
2859: values
2860: (PER_KR_ASSIGNMENT_YEA_INFO_S.nextval,
2861: p_assignment_id,
2862: 'KR_YEA_DONATION_TOTALS1',
2863: p_target_year,
2864: 'KR_YEA_DONATION_TOTALS1',
2876: p_rel_bro_sis,
2877: p_oth_bro_sis,
2878: 1);
2879: else
2880: update per_kr_assignment_yea_info
2881: set ayi_information2 = p_stat_parent,
2882: ayi_information6 = p_tax_parent,
2883: ayi_information8 = p_pledt_parent,
2884: ayi_information10 = p_spec_parent,
2895: and target_year = p_target_year;
2896: end if;
2897: else
2898: delete
2899: from per_kr_assignment_yea_info
2900: where assignment_id = p_assignment_id
2901: and information_type in ('KR_YEA_DONATION_TOTALS','KR_YEA_DONATION_TOTALS1')
2902: and target_year = p_target_year;
2903: end if;
2934: p_rel_bro_sis > 0 or
2935: p_oth_parent > 0 or
2936: p_oth_bro_sis > 0 ) then
2937: --
2938: insert into per_kr_assignment_yea_info
2939: (assignment_yea_info_id,
2940: assignment_id,
2941: information_type,
2942: target_year,
2963: ayi_information25,
2964: ayi_information24,
2965: object_version_number)
2966: values
2967: (PER_KR_ASSIGNMENT_YEA_INFO_S.nextval,
2968: p_assignment_id,
2969: 'KR_YEA_DONATION_TOTALS',
2970: p_target_year,
2971: 'KR_YEA_DONATION_TOTALS',
2991: p_oth_spouse,
2992: p_oth_child,
2993: 1);
2994: --
2995: insert into per_kr_assignment_yea_info
2996: (assignment_yea_info_id,
2997: assignment_id,
2998: information_type,
2999: target_year,
3012: ayi_information13,
3013: ayi_information17,
3014: object_version_number)
3015: values
3016: (PER_KR_ASSIGNMENT_YEA_INFO_S.nextval,
3017: p_assignment_id,
3018: 'KR_YEA_DONATION_TOTALS1',
3019: p_target_year,
3020: 'KR_YEA_DONATION_TOTALS1',