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.HR_WINDOW_PROPERTIES_BSI dependencies on HR_WINDOW_PROPERTIES_B

Line 1: Package Body hr_window_properties_bsi as

1: Package Body hr_window_properties_bsi as
2: /* $Header: hrwnpbsi.pkb 115.2 2002/12/03 14:14:10 raranjan noship $ */
3: --
4: -- Package Variables
5: --

Line 6: g_package varchar2(33) := ' hr_window_properties_bsi.';

2: /* $Header: hrwnpbsi.pkb 115.2 2002/12/03 14:14:10 raranjan noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' hr_window_properties_bsi.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |--------------------------< create_window_property >----------------------|
10: -- ----------------------------------------------------------------------------

Line 222: FROM hr_window_properties_b

218: --
219: CURSOR cur_win_prop_1
220: IS
221: SELECT window_property_id
222: FROM hr_window_properties_b
223: WHERE form_window_id = p_form_window_id;
224:
225: CURSOR cur_win_prop_2
226: IS

Line 228: FROM hr_window_properties_b

224:
225: CURSOR cur_win_prop_2
226: IS
227: SELECT window_property_id
228: FROM hr_window_properties_b
229: WHERE template_window_id = p_template_window_id;
230:
231: l_window_property_id number;
232: l_proc varchar2(72) := g_package||'update_window_property';

Line 397: FROM hr_window_properties_b

393: --
394: CURSOR cur_win_prop_1
395: IS
396: SELECT window_property_id
397: FROM hr_window_properties_b
398: WHERE form_window_id = p_form_window_id;
399:
400: CURSOR cur_win_prop_2
401: IS

Line 403: FROM hr_window_properties_b

399:
400: CURSOR cur_win_prop_2
401: IS
402: SELECT window_property_id
403: FROM hr_window_properties_b
404: WHERE template_window_id = p_template_window_id;
405:
406: l_window_property_id number;
407: l_proc varchar2(72) := g_package||'delete_window_property';

Line 559: (height hr_window_properties_b.height%TYPE

555: --
556: -- Declare cursors and local variables
557: --
558: Type l_rec_type Is Record
559: (height hr_window_properties_b.height%TYPE
560: -- ,title hr_window_properties_b.title%TYPE
561: ,width hr_window_properties_b.width%TYPE
562: ,x_position hr_window_properties_b.x_position%TYPE
563: ,y_position hr_window_properties_b.y_position%TYPE

Line 560: -- ,title hr_window_properties_b.title%TYPE

556: -- Declare cursors and local variables
557: --
558: Type l_rec_type Is Record
559: (height hr_window_properties_b.height%TYPE
560: -- ,title hr_window_properties_b.title%TYPE
561: ,width hr_window_properties_b.width%TYPE
562: ,x_position hr_window_properties_b.x_position%TYPE
563: ,y_position hr_window_properties_b.y_position%TYPE
564: ,information_category hr_window_properties_b.information_category%TYPE

Line 561: ,width hr_window_properties_b.width%TYPE

557: --
558: Type l_rec_type Is Record
559: (height hr_window_properties_b.height%TYPE
560: -- ,title hr_window_properties_b.title%TYPE
561: ,width hr_window_properties_b.width%TYPE
562: ,x_position hr_window_properties_b.x_position%TYPE
563: ,y_position hr_window_properties_b.y_position%TYPE
564: ,information_category hr_window_properties_b.information_category%TYPE
565: ,information1 hr_window_properties_b.information1%TYPE

Line 562: ,x_position hr_window_properties_b.x_position%TYPE

558: Type l_rec_type Is Record
559: (height hr_window_properties_b.height%TYPE
560: -- ,title hr_window_properties_b.title%TYPE
561: ,width hr_window_properties_b.width%TYPE
562: ,x_position hr_window_properties_b.x_position%TYPE
563: ,y_position hr_window_properties_b.y_position%TYPE
564: ,information_category hr_window_properties_b.information_category%TYPE
565: ,information1 hr_window_properties_b.information1%TYPE
566: ,information2 hr_window_properties_b.information2%TYPE

Line 563: ,y_position hr_window_properties_b.y_position%TYPE

559: (height hr_window_properties_b.height%TYPE
560: -- ,title hr_window_properties_b.title%TYPE
561: ,width hr_window_properties_b.width%TYPE
562: ,x_position hr_window_properties_b.x_position%TYPE
563: ,y_position hr_window_properties_b.y_position%TYPE
564: ,information_category hr_window_properties_b.information_category%TYPE
565: ,information1 hr_window_properties_b.information1%TYPE
566: ,information2 hr_window_properties_b.information2%TYPE
567: ,information3 hr_window_properties_b.information3%TYPE

Line 564: ,information_category hr_window_properties_b.information_category%TYPE

560: -- ,title hr_window_properties_b.title%TYPE
561: ,width hr_window_properties_b.width%TYPE
562: ,x_position hr_window_properties_b.x_position%TYPE
563: ,y_position hr_window_properties_b.y_position%TYPE
564: ,information_category hr_window_properties_b.information_category%TYPE
565: ,information1 hr_window_properties_b.information1%TYPE
566: ,information2 hr_window_properties_b.information2%TYPE
567: ,information3 hr_window_properties_b.information3%TYPE
568: ,information4 hr_window_properties_b.information4%TYPE

Line 565: ,information1 hr_window_properties_b.information1%TYPE

561: ,width hr_window_properties_b.width%TYPE
562: ,x_position hr_window_properties_b.x_position%TYPE
563: ,y_position hr_window_properties_b.y_position%TYPE
564: ,information_category hr_window_properties_b.information_category%TYPE
565: ,information1 hr_window_properties_b.information1%TYPE
566: ,information2 hr_window_properties_b.information2%TYPE
567: ,information3 hr_window_properties_b.information3%TYPE
568: ,information4 hr_window_properties_b.information4%TYPE
569: ,information5 hr_window_properties_b.information5%TYPE

Line 566: ,information2 hr_window_properties_b.information2%TYPE

562: ,x_position hr_window_properties_b.x_position%TYPE
563: ,y_position hr_window_properties_b.y_position%TYPE
564: ,information_category hr_window_properties_b.information_category%TYPE
565: ,information1 hr_window_properties_b.information1%TYPE
566: ,information2 hr_window_properties_b.information2%TYPE
567: ,information3 hr_window_properties_b.information3%TYPE
568: ,information4 hr_window_properties_b.information4%TYPE
569: ,information5 hr_window_properties_b.information5%TYPE
570: ,information6 hr_window_properties_b.information6%TYPE

Line 567: ,information3 hr_window_properties_b.information3%TYPE

563: ,y_position hr_window_properties_b.y_position%TYPE
564: ,information_category hr_window_properties_b.information_category%TYPE
565: ,information1 hr_window_properties_b.information1%TYPE
566: ,information2 hr_window_properties_b.information2%TYPE
567: ,information3 hr_window_properties_b.information3%TYPE
568: ,information4 hr_window_properties_b.information4%TYPE
569: ,information5 hr_window_properties_b.information5%TYPE
570: ,information6 hr_window_properties_b.information6%TYPE
571: ,information7 hr_window_properties_b.information7%TYPE

Line 568: ,information4 hr_window_properties_b.information4%TYPE

564: ,information_category hr_window_properties_b.information_category%TYPE
565: ,information1 hr_window_properties_b.information1%TYPE
566: ,information2 hr_window_properties_b.information2%TYPE
567: ,information3 hr_window_properties_b.information3%TYPE
568: ,information4 hr_window_properties_b.information4%TYPE
569: ,information5 hr_window_properties_b.information5%TYPE
570: ,information6 hr_window_properties_b.information6%TYPE
571: ,information7 hr_window_properties_b.information7%TYPE
572: ,information8 hr_window_properties_b.information8%TYPE

Line 569: ,information5 hr_window_properties_b.information5%TYPE

565: ,information1 hr_window_properties_b.information1%TYPE
566: ,information2 hr_window_properties_b.information2%TYPE
567: ,information3 hr_window_properties_b.information3%TYPE
568: ,information4 hr_window_properties_b.information4%TYPE
569: ,information5 hr_window_properties_b.information5%TYPE
570: ,information6 hr_window_properties_b.information6%TYPE
571: ,information7 hr_window_properties_b.information7%TYPE
572: ,information8 hr_window_properties_b.information8%TYPE
573: ,information9 hr_window_properties_b.information9%TYPE

Line 570: ,information6 hr_window_properties_b.information6%TYPE

566: ,information2 hr_window_properties_b.information2%TYPE
567: ,information3 hr_window_properties_b.information3%TYPE
568: ,information4 hr_window_properties_b.information4%TYPE
569: ,information5 hr_window_properties_b.information5%TYPE
570: ,information6 hr_window_properties_b.information6%TYPE
571: ,information7 hr_window_properties_b.information7%TYPE
572: ,information8 hr_window_properties_b.information8%TYPE
573: ,information9 hr_window_properties_b.information9%TYPE
574: ,information10 hr_window_properties_b.information10%TYPE

Line 571: ,information7 hr_window_properties_b.information7%TYPE

567: ,information3 hr_window_properties_b.information3%TYPE
568: ,information4 hr_window_properties_b.information4%TYPE
569: ,information5 hr_window_properties_b.information5%TYPE
570: ,information6 hr_window_properties_b.information6%TYPE
571: ,information7 hr_window_properties_b.information7%TYPE
572: ,information8 hr_window_properties_b.information8%TYPE
573: ,information9 hr_window_properties_b.information9%TYPE
574: ,information10 hr_window_properties_b.information10%TYPE
575: ,information11 hr_window_properties_b.information11%TYPE

Line 572: ,information8 hr_window_properties_b.information8%TYPE

568: ,information4 hr_window_properties_b.information4%TYPE
569: ,information5 hr_window_properties_b.information5%TYPE
570: ,information6 hr_window_properties_b.information6%TYPE
571: ,information7 hr_window_properties_b.information7%TYPE
572: ,information8 hr_window_properties_b.information8%TYPE
573: ,information9 hr_window_properties_b.information9%TYPE
574: ,information10 hr_window_properties_b.information10%TYPE
575: ,information11 hr_window_properties_b.information11%TYPE
576: ,information12 hr_window_properties_b.information12%TYPE

Line 573: ,information9 hr_window_properties_b.information9%TYPE

569: ,information5 hr_window_properties_b.information5%TYPE
570: ,information6 hr_window_properties_b.information6%TYPE
571: ,information7 hr_window_properties_b.information7%TYPE
572: ,information8 hr_window_properties_b.information8%TYPE
573: ,information9 hr_window_properties_b.information9%TYPE
574: ,information10 hr_window_properties_b.information10%TYPE
575: ,information11 hr_window_properties_b.information11%TYPE
576: ,information12 hr_window_properties_b.information12%TYPE
577: ,information13 hr_window_properties_b.information13%TYPE

Line 574: ,information10 hr_window_properties_b.information10%TYPE

570: ,information6 hr_window_properties_b.information6%TYPE
571: ,information7 hr_window_properties_b.information7%TYPE
572: ,information8 hr_window_properties_b.information8%TYPE
573: ,information9 hr_window_properties_b.information9%TYPE
574: ,information10 hr_window_properties_b.information10%TYPE
575: ,information11 hr_window_properties_b.information11%TYPE
576: ,information12 hr_window_properties_b.information12%TYPE
577: ,information13 hr_window_properties_b.information13%TYPE
578: ,information14 hr_window_properties_b.information14%TYPE

Line 575: ,information11 hr_window_properties_b.information11%TYPE

571: ,information7 hr_window_properties_b.information7%TYPE
572: ,information8 hr_window_properties_b.information8%TYPE
573: ,information9 hr_window_properties_b.information9%TYPE
574: ,information10 hr_window_properties_b.information10%TYPE
575: ,information11 hr_window_properties_b.information11%TYPE
576: ,information12 hr_window_properties_b.information12%TYPE
577: ,information13 hr_window_properties_b.information13%TYPE
578: ,information14 hr_window_properties_b.information14%TYPE
579: ,information15 hr_window_properties_b.information15%TYPE

Line 576: ,information12 hr_window_properties_b.information12%TYPE

572: ,information8 hr_window_properties_b.information8%TYPE
573: ,information9 hr_window_properties_b.information9%TYPE
574: ,information10 hr_window_properties_b.information10%TYPE
575: ,information11 hr_window_properties_b.information11%TYPE
576: ,information12 hr_window_properties_b.information12%TYPE
577: ,information13 hr_window_properties_b.information13%TYPE
578: ,information14 hr_window_properties_b.information14%TYPE
579: ,information15 hr_window_properties_b.information15%TYPE
580: ,information16 hr_window_properties_b.information16%TYPE

Line 577: ,information13 hr_window_properties_b.information13%TYPE

573: ,information9 hr_window_properties_b.information9%TYPE
574: ,information10 hr_window_properties_b.information10%TYPE
575: ,information11 hr_window_properties_b.information11%TYPE
576: ,information12 hr_window_properties_b.information12%TYPE
577: ,information13 hr_window_properties_b.information13%TYPE
578: ,information14 hr_window_properties_b.information14%TYPE
579: ,information15 hr_window_properties_b.information15%TYPE
580: ,information16 hr_window_properties_b.information16%TYPE
581: ,information17 hr_window_properties_b.information17%TYPE

Line 578: ,information14 hr_window_properties_b.information14%TYPE

574: ,information10 hr_window_properties_b.information10%TYPE
575: ,information11 hr_window_properties_b.information11%TYPE
576: ,information12 hr_window_properties_b.information12%TYPE
577: ,information13 hr_window_properties_b.information13%TYPE
578: ,information14 hr_window_properties_b.information14%TYPE
579: ,information15 hr_window_properties_b.information15%TYPE
580: ,information16 hr_window_properties_b.information16%TYPE
581: ,information17 hr_window_properties_b.information17%TYPE
582: ,information18 hr_window_properties_b.information18%TYPE

Line 579: ,information15 hr_window_properties_b.information15%TYPE

575: ,information11 hr_window_properties_b.information11%TYPE
576: ,information12 hr_window_properties_b.information12%TYPE
577: ,information13 hr_window_properties_b.information13%TYPE
578: ,information14 hr_window_properties_b.information14%TYPE
579: ,information15 hr_window_properties_b.information15%TYPE
580: ,information16 hr_window_properties_b.information16%TYPE
581: ,information17 hr_window_properties_b.information17%TYPE
582: ,information18 hr_window_properties_b.information18%TYPE
583: ,information19 hr_window_properties_b.information19%TYPE

Line 580: ,information16 hr_window_properties_b.information16%TYPE

576: ,information12 hr_window_properties_b.information12%TYPE
577: ,information13 hr_window_properties_b.information13%TYPE
578: ,information14 hr_window_properties_b.information14%TYPE
579: ,information15 hr_window_properties_b.information15%TYPE
580: ,information16 hr_window_properties_b.information16%TYPE
581: ,information17 hr_window_properties_b.information17%TYPE
582: ,information18 hr_window_properties_b.information18%TYPE
583: ,information19 hr_window_properties_b.information19%TYPE
584: ,information20 hr_window_properties_b.information20%TYPE

Line 581: ,information17 hr_window_properties_b.information17%TYPE

577: ,information13 hr_window_properties_b.information13%TYPE
578: ,information14 hr_window_properties_b.information14%TYPE
579: ,information15 hr_window_properties_b.information15%TYPE
580: ,information16 hr_window_properties_b.information16%TYPE
581: ,information17 hr_window_properties_b.information17%TYPE
582: ,information18 hr_window_properties_b.information18%TYPE
583: ,information19 hr_window_properties_b.information19%TYPE
584: ,information20 hr_window_properties_b.information20%TYPE
585: ,information21 hr_window_properties_b.information21%TYPE

Line 582: ,information18 hr_window_properties_b.information18%TYPE

578: ,information14 hr_window_properties_b.information14%TYPE
579: ,information15 hr_window_properties_b.information15%TYPE
580: ,information16 hr_window_properties_b.information16%TYPE
581: ,information17 hr_window_properties_b.information17%TYPE
582: ,information18 hr_window_properties_b.information18%TYPE
583: ,information19 hr_window_properties_b.information19%TYPE
584: ,information20 hr_window_properties_b.information20%TYPE
585: ,information21 hr_window_properties_b.information21%TYPE
586: ,information22 hr_window_properties_b.information22%TYPE

Line 583: ,information19 hr_window_properties_b.information19%TYPE

579: ,information15 hr_window_properties_b.information15%TYPE
580: ,information16 hr_window_properties_b.information16%TYPE
581: ,information17 hr_window_properties_b.information17%TYPE
582: ,information18 hr_window_properties_b.information18%TYPE
583: ,information19 hr_window_properties_b.information19%TYPE
584: ,information20 hr_window_properties_b.information20%TYPE
585: ,information21 hr_window_properties_b.information21%TYPE
586: ,information22 hr_window_properties_b.information22%TYPE
587: ,information23 hr_window_properties_b.information23%TYPE

Line 584: ,information20 hr_window_properties_b.information20%TYPE

580: ,information16 hr_window_properties_b.information16%TYPE
581: ,information17 hr_window_properties_b.information17%TYPE
582: ,information18 hr_window_properties_b.information18%TYPE
583: ,information19 hr_window_properties_b.information19%TYPE
584: ,information20 hr_window_properties_b.information20%TYPE
585: ,information21 hr_window_properties_b.information21%TYPE
586: ,information22 hr_window_properties_b.information22%TYPE
587: ,information23 hr_window_properties_b.information23%TYPE
588: ,information24 hr_window_properties_b.information24%TYPE

Line 585: ,information21 hr_window_properties_b.information21%TYPE

581: ,information17 hr_window_properties_b.information17%TYPE
582: ,information18 hr_window_properties_b.information18%TYPE
583: ,information19 hr_window_properties_b.information19%TYPE
584: ,information20 hr_window_properties_b.information20%TYPE
585: ,information21 hr_window_properties_b.information21%TYPE
586: ,information22 hr_window_properties_b.information22%TYPE
587: ,information23 hr_window_properties_b.information23%TYPE
588: ,information24 hr_window_properties_b.information24%TYPE
589: ,information25 hr_window_properties_b.information25%TYPE

Line 586: ,information22 hr_window_properties_b.information22%TYPE

582: ,information18 hr_window_properties_b.information18%TYPE
583: ,information19 hr_window_properties_b.information19%TYPE
584: ,information20 hr_window_properties_b.information20%TYPE
585: ,information21 hr_window_properties_b.information21%TYPE
586: ,information22 hr_window_properties_b.information22%TYPE
587: ,information23 hr_window_properties_b.information23%TYPE
588: ,information24 hr_window_properties_b.information24%TYPE
589: ,information25 hr_window_properties_b.information25%TYPE
590: ,information26 hr_window_properties_b.information26%TYPE

Line 587: ,information23 hr_window_properties_b.information23%TYPE

583: ,information19 hr_window_properties_b.information19%TYPE
584: ,information20 hr_window_properties_b.information20%TYPE
585: ,information21 hr_window_properties_b.information21%TYPE
586: ,information22 hr_window_properties_b.information22%TYPE
587: ,information23 hr_window_properties_b.information23%TYPE
588: ,information24 hr_window_properties_b.information24%TYPE
589: ,information25 hr_window_properties_b.information25%TYPE
590: ,information26 hr_window_properties_b.information26%TYPE
591: ,information27 hr_window_properties_b.information27%TYPE

Line 588: ,information24 hr_window_properties_b.information24%TYPE

584: ,information20 hr_window_properties_b.information20%TYPE
585: ,information21 hr_window_properties_b.information21%TYPE
586: ,information22 hr_window_properties_b.information22%TYPE
587: ,information23 hr_window_properties_b.information23%TYPE
588: ,information24 hr_window_properties_b.information24%TYPE
589: ,information25 hr_window_properties_b.information25%TYPE
590: ,information26 hr_window_properties_b.information26%TYPE
591: ,information27 hr_window_properties_b.information27%TYPE
592: ,information28 hr_window_properties_b.information28%TYPE

Line 589: ,information25 hr_window_properties_b.information25%TYPE

585: ,information21 hr_window_properties_b.information21%TYPE
586: ,information22 hr_window_properties_b.information22%TYPE
587: ,information23 hr_window_properties_b.information23%TYPE
588: ,information24 hr_window_properties_b.information24%TYPE
589: ,information25 hr_window_properties_b.information25%TYPE
590: ,information26 hr_window_properties_b.information26%TYPE
591: ,information27 hr_window_properties_b.information27%TYPE
592: ,information28 hr_window_properties_b.information28%TYPE
593: ,information29 hr_window_properties_b.information29%TYPE

Line 590: ,information26 hr_window_properties_b.information26%TYPE

586: ,information22 hr_window_properties_b.information22%TYPE
587: ,information23 hr_window_properties_b.information23%TYPE
588: ,information24 hr_window_properties_b.information24%TYPE
589: ,information25 hr_window_properties_b.information25%TYPE
590: ,information26 hr_window_properties_b.information26%TYPE
591: ,information27 hr_window_properties_b.information27%TYPE
592: ,information28 hr_window_properties_b.information28%TYPE
593: ,information29 hr_window_properties_b.information29%TYPE
594: ,information30 hr_window_properties_b.information30%TYPE);

Line 591: ,information27 hr_window_properties_b.information27%TYPE

587: ,information23 hr_window_properties_b.information23%TYPE
588: ,information24 hr_window_properties_b.information24%TYPE
589: ,information25 hr_window_properties_b.information25%TYPE
590: ,information26 hr_window_properties_b.information26%TYPE
591: ,information27 hr_window_properties_b.information27%TYPE
592: ,information28 hr_window_properties_b.information28%TYPE
593: ,information29 hr_window_properties_b.information29%TYPE
594: ,information30 hr_window_properties_b.information30%TYPE);
595:

Line 592: ,information28 hr_window_properties_b.information28%TYPE

588: ,information24 hr_window_properties_b.information24%TYPE
589: ,information25 hr_window_properties_b.information25%TYPE
590: ,information26 hr_window_properties_b.information26%TYPE
591: ,information27 hr_window_properties_b.information27%TYPE
592: ,information28 hr_window_properties_b.information28%TYPE
593: ,information29 hr_window_properties_b.information29%TYPE
594: ,information30 hr_window_properties_b.information30%TYPE);
595:
596: l_rec l_rec_type;

Line 593: ,information29 hr_window_properties_b.information29%TYPE

589: ,information25 hr_window_properties_b.information25%TYPE
590: ,information26 hr_window_properties_b.information26%TYPE
591: ,information27 hr_window_properties_b.information27%TYPE
592: ,information28 hr_window_properties_b.information28%TYPE
593: ,information29 hr_window_properties_b.information29%TYPE
594: ,information30 hr_window_properties_b.information30%TYPE);
595:
596: l_rec l_rec_type;
597:

Line 594: ,information30 hr_window_properties_b.information30%TYPE);

590: ,information26 hr_window_properties_b.information26%TYPE
591: ,information27 hr_window_properties_b.information27%TYPE
592: ,information28 hr_window_properties_b.information28%TYPE
593: ,information29 hr_window_properties_b.information29%TYPE
594: ,information30 hr_window_properties_b.information30%TYPE);
595:
596: l_rec l_rec_type;
597:
598: CURSOR cur_win_prop

Line 636: FROM hr_window_properties_b wnp

632: ,DECODE(p_information27,hr_api.g_varchar2,wnp.information27,p_information27)
633: ,DECODE(p_information28,hr_api.g_varchar2,wnp.information28,p_information28)
634: ,DECODE(p_information29,hr_api.g_varchar2,wnp.information29,p_information29)
635: ,DECODE(p_information30,hr_api.g_varchar2,wnp.information30,p_information30)
636: FROM hr_window_properties_b wnp
637: WHERE wnp.form_window_id = p_form_window_id;
638:
639: CURSOR cur_check
640: IS

Line 652: ,hr_window_properties_b wnp

648: SELECT COUNT(0)
649: ,wnptl.source_lang
650: ,DECODE(p_title,hr_api.g_varchar2,wnptl.title,p_title) title
651: FROM hr_window_properties_tl wnptl
652: ,hr_window_properties_b wnp
653: WHERE wnptl.window_property_id = wnp.window_property_id
654: AND wnp.form_window_id = p_form_window_id
655: GROUP BY wnptl.source_lang
656: ,DECODE(p_title,hr_api.g_varchar2,wnptl.title,p_title)

Line 868: (height hr_window_properties_b.height%TYPE

864: --
865: -- Declare cursors and local variables
866: --
867: Type l_rec_type Is Record
868: (height hr_window_properties_b.height%TYPE
869: --,title hr_window_properties_b.title%TYPE
870: ,width hr_window_properties_b.width%TYPE
871: ,x_position hr_window_properties_b.x_position%TYPE
872: ,y_position hr_window_properties_b.y_position%TYPE

Line 869: --,title hr_window_properties_b.title%TYPE

865: -- Declare cursors and local variables
866: --
867: Type l_rec_type Is Record
868: (height hr_window_properties_b.height%TYPE
869: --,title hr_window_properties_b.title%TYPE
870: ,width hr_window_properties_b.width%TYPE
871: ,x_position hr_window_properties_b.x_position%TYPE
872: ,y_position hr_window_properties_b.y_position%TYPE
873: ,information_category hr_window_properties_b.information_category%TYPE

Line 870: ,width hr_window_properties_b.width%TYPE

866: --
867: Type l_rec_type Is Record
868: (height hr_window_properties_b.height%TYPE
869: --,title hr_window_properties_b.title%TYPE
870: ,width hr_window_properties_b.width%TYPE
871: ,x_position hr_window_properties_b.x_position%TYPE
872: ,y_position hr_window_properties_b.y_position%TYPE
873: ,information_category hr_window_properties_b.information_category%TYPE
874: ,information1 hr_window_properties_b.information1%TYPE

Line 871: ,x_position hr_window_properties_b.x_position%TYPE

867: Type l_rec_type Is Record
868: (height hr_window_properties_b.height%TYPE
869: --,title hr_window_properties_b.title%TYPE
870: ,width hr_window_properties_b.width%TYPE
871: ,x_position hr_window_properties_b.x_position%TYPE
872: ,y_position hr_window_properties_b.y_position%TYPE
873: ,information_category hr_window_properties_b.information_category%TYPE
874: ,information1 hr_window_properties_b.information1%TYPE
875: ,information2 hr_window_properties_b.information2%TYPE

Line 872: ,y_position hr_window_properties_b.y_position%TYPE

868: (height hr_window_properties_b.height%TYPE
869: --,title hr_window_properties_b.title%TYPE
870: ,width hr_window_properties_b.width%TYPE
871: ,x_position hr_window_properties_b.x_position%TYPE
872: ,y_position hr_window_properties_b.y_position%TYPE
873: ,information_category hr_window_properties_b.information_category%TYPE
874: ,information1 hr_window_properties_b.information1%TYPE
875: ,information2 hr_window_properties_b.information2%TYPE
876: ,information3 hr_window_properties_b.information3%TYPE

Line 873: ,information_category hr_window_properties_b.information_category%TYPE

869: --,title hr_window_properties_b.title%TYPE
870: ,width hr_window_properties_b.width%TYPE
871: ,x_position hr_window_properties_b.x_position%TYPE
872: ,y_position hr_window_properties_b.y_position%TYPE
873: ,information_category hr_window_properties_b.information_category%TYPE
874: ,information1 hr_window_properties_b.information1%TYPE
875: ,information2 hr_window_properties_b.information2%TYPE
876: ,information3 hr_window_properties_b.information3%TYPE
877: ,information4 hr_window_properties_b.information4%TYPE

Line 874: ,information1 hr_window_properties_b.information1%TYPE

870: ,width hr_window_properties_b.width%TYPE
871: ,x_position hr_window_properties_b.x_position%TYPE
872: ,y_position hr_window_properties_b.y_position%TYPE
873: ,information_category hr_window_properties_b.information_category%TYPE
874: ,information1 hr_window_properties_b.information1%TYPE
875: ,information2 hr_window_properties_b.information2%TYPE
876: ,information3 hr_window_properties_b.information3%TYPE
877: ,information4 hr_window_properties_b.information4%TYPE
878: ,information5 hr_window_properties_b.information5%TYPE

Line 875: ,information2 hr_window_properties_b.information2%TYPE

871: ,x_position hr_window_properties_b.x_position%TYPE
872: ,y_position hr_window_properties_b.y_position%TYPE
873: ,information_category hr_window_properties_b.information_category%TYPE
874: ,information1 hr_window_properties_b.information1%TYPE
875: ,information2 hr_window_properties_b.information2%TYPE
876: ,information3 hr_window_properties_b.information3%TYPE
877: ,information4 hr_window_properties_b.information4%TYPE
878: ,information5 hr_window_properties_b.information5%TYPE
879: ,information6 hr_window_properties_b.information6%TYPE

Line 876: ,information3 hr_window_properties_b.information3%TYPE

872: ,y_position hr_window_properties_b.y_position%TYPE
873: ,information_category hr_window_properties_b.information_category%TYPE
874: ,information1 hr_window_properties_b.information1%TYPE
875: ,information2 hr_window_properties_b.information2%TYPE
876: ,information3 hr_window_properties_b.information3%TYPE
877: ,information4 hr_window_properties_b.information4%TYPE
878: ,information5 hr_window_properties_b.information5%TYPE
879: ,information6 hr_window_properties_b.information6%TYPE
880: ,information7 hr_window_properties_b.information7%TYPE

Line 877: ,information4 hr_window_properties_b.information4%TYPE

873: ,information_category hr_window_properties_b.information_category%TYPE
874: ,information1 hr_window_properties_b.information1%TYPE
875: ,information2 hr_window_properties_b.information2%TYPE
876: ,information3 hr_window_properties_b.information3%TYPE
877: ,information4 hr_window_properties_b.information4%TYPE
878: ,information5 hr_window_properties_b.information5%TYPE
879: ,information6 hr_window_properties_b.information6%TYPE
880: ,information7 hr_window_properties_b.information7%TYPE
881: ,information8 hr_window_properties_b.information8%TYPE

Line 878: ,information5 hr_window_properties_b.information5%TYPE

874: ,information1 hr_window_properties_b.information1%TYPE
875: ,information2 hr_window_properties_b.information2%TYPE
876: ,information3 hr_window_properties_b.information3%TYPE
877: ,information4 hr_window_properties_b.information4%TYPE
878: ,information5 hr_window_properties_b.information5%TYPE
879: ,information6 hr_window_properties_b.information6%TYPE
880: ,information7 hr_window_properties_b.information7%TYPE
881: ,information8 hr_window_properties_b.information8%TYPE
882: ,information9 hr_window_properties_b.information9%TYPE

Line 879: ,information6 hr_window_properties_b.information6%TYPE

875: ,information2 hr_window_properties_b.information2%TYPE
876: ,information3 hr_window_properties_b.information3%TYPE
877: ,information4 hr_window_properties_b.information4%TYPE
878: ,information5 hr_window_properties_b.information5%TYPE
879: ,information6 hr_window_properties_b.information6%TYPE
880: ,information7 hr_window_properties_b.information7%TYPE
881: ,information8 hr_window_properties_b.information8%TYPE
882: ,information9 hr_window_properties_b.information9%TYPE
883: ,information10 hr_window_properties_b.information10%TYPE

Line 880: ,information7 hr_window_properties_b.information7%TYPE

876: ,information3 hr_window_properties_b.information3%TYPE
877: ,information4 hr_window_properties_b.information4%TYPE
878: ,information5 hr_window_properties_b.information5%TYPE
879: ,information6 hr_window_properties_b.information6%TYPE
880: ,information7 hr_window_properties_b.information7%TYPE
881: ,information8 hr_window_properties_b.information8%TYPE
882: ,information9 hr_window_properties_b.information9%TYPE
883: ,information10 hr_window_properties_b.information10%TYPE
884: ,information11 hr_window_properties_b.information11%TYPE

Line 881: ,information8 hr_window_properties_b.information8%TYPE

877: ,information4 hr_window_properties_b.information4%TYPE
878: ,information5 hr_window_properties_b.information5%TYPE
879: ,information6 hr_window_properties_b.information6%TYPE
880: ,information7 hr_window_properties_b.information7%TYPE
881: ,information8 hr_window_properties_b.information8%TYPE
882: ,information9 hr_window_properties_b.information9%TYPE
883: ,information10 hr_window_properties_b.information10%TYPE
884: ,information11 hr_window_properties_b.information11%TYPE
885: ,information12 hr_window_properties_b.information12%TYPE

Line 882: ,information9 hr_window_properties_b.information9%TYPE

878: ,information5 hr_window_properties_b.information5%TYPE
879: ,information6 hr_window_properties_b.information6%TYPE
880: ,information7 hr_window_properties_b.information7%TYPE
881: ,information8 hr_window_properties_b.information8%TYPE
882: ,information9 hr_window_properties_b.information9%TYPE
883: ,information10 hr_window_properties_b.information10%TYPE
884: ,information11 hr_window_properties_b.information11%TYPE
885: ,information12 hr_window_properties_b.information12%TYPE
886: ,information13 hr_window_properties_b.information13%TYPE

Line 883: ,information10 hr_window_properties_b.information10%TYPE

879: ,information6 hr_window_properties_b.information6%TYPE
880: ,information7 hr_window_properties_b.information7%TYPE
881: ,information8 hr_window_properties_b.information8%TYPE
882: ,information9 hr_window_properties_b.information9%TYPE
883: ,information10 hr_window_properties_b.information10%TYPE
884: ,information11 hr_window_properties_b.information11%TYPE
885: ,information12 hr_window_properties_b.information12%TYPE
886: ,information13 hr_window_properties_b.information13%TYPE
887: ,information14 hr_window_properties_b.information14%TYPE

Line 884: ,information11 hr_window_properties_b.information11%TYPE

880: ,information7 hr_window_properties_b.information7%TYPE
881: ,information8 hr_window_properties_b.information8%TYPE
882: ,information9 hr_window_properties_b.information9%TYPE
883: ,information10 hr_window_properties_b.information10%TYPE
884: ,information11 hr_window_properties_b.information11%TYPE
885: ,information12 hr_window_properties_b.information12%TYPE
886: ,information13 hr_window_properties_b.information13%TYPE
887: ,information14 hr_window_properties_b.information14%TYPE
888: ,information15 hr_window_properties_b.information15%TYPE

Line 885: ,information12 hr_window_properties_b.information12%TYPE

881: ,information8 hr_window_properties_b.information8%TYPE
882: ,information9 hr_window_properties_b.information9%TYPE
883: ,information10 hr_window_properties_b.information10%TYPE
884: ,information11 hr_window_properties_b.information11%TYPE
885: ,information12 hr_window_properties_b.information12%TYPE
886: ,information13 hr_window_properties_b.information13%TYPE
887: ,information14 hr_window_properties_b.information14%TYPE
888: ,information15 hr_window_properties_b.information15%TYPE
889: ,information16 hr_window_properties_b.information16%TYPE

Line 886: ,information13 hr_window_properties_b.information13%TYPE

882: ,information9 hr_window_properties_b.information9%TYPE
883: ,information10 hr_window_properties_b.information10%TYPE
884: ,information11 hr_window_properties_b.information11%TYPE
885: ,information12 hr_window_properties_b.information12%TYPE
886: ,information13 hr_window_properties_b.information13%TYPE
887: ,information14 hr_window_properties_b.information14%TYPE
888: ,information15 hr_window_properties_b.information15%TYPE
889: ,information16 hr_window_properties_b.information16%TYPE
890: ,information17 hr_window_properties_b.information17%TYPE

Line 887: ,information14 hr_window_properties_b.information14%TYPE

883: ,information10 hr_window_properties_b.information10%TYPE
884: ,information11 hr_window_properties_b.information11%TYPE
885: ,information12 hr_window_properties_b.information12%TYPE
886: ,information13 hr_window_properties_b.information13%TYPE
887: ,information14 hr_window_properties_b.information14%TYPE
888: ,information15 hr_window_properties_b.information15%TYPE
889: ,information16 hr_window_properties_b.information16%TYPE
890: ,information17 hr_window_properties_b.information17%TYPE
891: ,information18 hr_window_properties_b.information18%TYPE

Line 888: ,information15 hr_window_properties_b.information15%TYPE

884: ,information11 hr_window_properties_b.information11%TYPE
885: ,information12 hr_window_properties_b.information12%TYPE
886: ,information13 hr_window_properties_b.information13%TYPE
887: ,information14 hr_window_properties_b.information14%TYPE
888: ,information15 hr_window_properties_b.information15%TYPE
889: ,information16 hr_window_properties_b.information16%TYPE
890: ,information17 hr_window_properties_b.information17%TYPE
891: ,information18 hr_window_properties_b.information18%TYPE
892: ,information19 hr_window_properties_b.information19%TYPE

Line 889: ,information16 hr_window_properties_b.information16%TYPE

885: ,information12 hr_window_properties_b.information12%TYPE
886: ,information13 hr_window_properties_b.information13%TYPE
887: ,information14 hr_window_properties_b.information14%TYPE
888: ,information15 hr_window_properties_b.information15%TYPE
889: ,information16 hr_window_properties_b.information16%TYPE
890: ,information17 hr_window_properties_b.information17%TYPE
891: ,information18 hr_window_properties_b.information18%TYPE
892: ,information19 hr_window_properties_b.information19%TYPE
893: ,information20 hr_window_properties_b.information20%TYPE

Line 890: ,information17 hr_window_properties_b.information17%TYPE

886: ,information13 hr_window_properties_b.information13%TYPE
887: ,information14 hr_window_properties_b.information14%TYPE
888: ,information15 hr_window_properties_b.information15%TYPE
889: ,information16 hr_window_properties_b.information16%TYPE
890: ,information17 hr_window_properties_b.information17%TYPE
891: ,information18 hr_window_properties_b.information18%TYPE
892: ,information19 hr_window_properties_b.information19%TYPE
893: ,information20 hr_window_properties_b.information20%TYPE
894: ,information21 hr_window_properties_b.information21%TYPE

Line 891: ,information18 hr_window_properties_b.information18%TYPE

887: ,information14 hr_window_properties_b.information14%TYPE
888: ,information15 hr_window_properties_b.information15%TYPE
889: ,information16 hr_window_properties_b.information16%TYPE
890: ,information17 hr_window_properties_b.information17%TYPE
891: ,information18 hr_window_properties_b.information18%TYPE
892: ,information19 hr_window_properties_b.information19%TYPE
893: ,information20 hr_window_properties_b.information20%TYPE
894: ,information21 hr_window_properties_b.information21%TYPE
895: ,information22 hr_window_properties_b.information22%TYPE

Line 892: ,information19 hr_window_properties_b.information19%TYPE

888: ,information15 hr_window_properties_b.information15%TYPE
889: ,information16 hr_window_properties_b.information16%TYPE
890: ,information17 hr_window_properties_b.information17%TYPE
891: ,information18 hr_window_properties_b.information18%TYPE
892: ,information19 hr_window_properties_b.information19%TYPE
893: ,information20 hr_window_properties_b.information20%TYPE
894: ,information21 hr_window_properties_b.information21%TYPE
895: ,information22 hr_window_properties_b.information22%TYPE
896: ,information23 hr_window_properties_b.information23%TYPE

Line 893: ,information20 hr_window_properties_b.information20%TYPE

889: ,information16 hr_window_properties_b.information16%TYPE
890: ,information17 hr_window_properties_b.information17%TYPE
891: ,information18 hr_window_properties_b.information18%TYPE
892: ,information19 hr_window_properties_b.information19%TYPE
893: ,information20 hr_window_properties_b.information20%TYPE
894: ,information21 hr_window_properties_b.information21%TYPE
895: ,information22 hr_window_properties_b.information22%TYPE
896: ,information23 hr_window_properties_b.information23%TYPE
897: ,information24 hr_window_properties_b.information24%TYPE

Line 894: ,information21 hr_window_properties_b.information21%TYPE

890: ,information17 hr_window_properties_b.information17%TYPE
891: ,information18 hr_window_properties_b.information18%TYPE
892: ,information19 hr_window_properties_b.information19%TYPE
893: ,information20 hr_window_properties_b.information20%TYPE
894: ,information21 hr_window_properties_b.information21%TYPE
895: ,information22 hr_window_properties_b.information22%TYPE
896: ,information23 hr_window_properties_b.information23%TYPE
897: ,information24 hr_window_properties_b.information24%TYPE
898: ,information25 hr_window_properties_b.information25%TYPE

Line 895: ,information22 hr_window_properties_b.information22%TYPE

891: ,information18 hr_window_properties_b.information18%TYPE
892: ,information19 hr_window_properties_b.information19%TYPE
893: ,information20 hr_window_properties_b.information20%TYPE
894: ,information21 hr_window_properties_b.information21%TYPE
895: ,information22 hr_window_properties_b.information22%TYPE
896: ,information23 hr_window_properties_b.information23%TYPE
897: ,information24 hr_window_properties_b.information24%TYPE
898: ,information25 hr_window_properties_b.information25%TYPE
899: ,information26 hr_window_properties_b.information26%TYPE

Line 896: ,information23 hr_window_properties_b.information23%TYPE

892: ,information19 hr_window_properties_b.information19%TYPE
893: ,information20 hr_window_properties_b.information20%TYPE
894: ,information21 hr_window_properties_b.information21%TYPE
895: ,information22 hr_window_properties_b.information22%TYPE
896: ,information23 hr_window_properties_b.information23%TYPE
897: ,information24 hr_window_properties_b.information24%TYPE
898: ,information25 hr_window_properties_b.information25%TYPE
899: ,information26 hr_window_properties_b.information26%TYPE
900: ,information27 hr_window_properties_b.information27%TYPE

Line 897: ,information24 hr_window_properties_b.information24%TYPE

893: ,information20 hr_window_properties_b.information20%TYPE
894: ,information21 hr_window_properties_b.information21%TYPE
895: ,information22 hr_window_properties_b.information22%TYPE
896: ,information23 hr_window_properties_b.information23%TYPE
897: ,information24 hr_window_properties_b.information24%TYPE
898: ,information25 hr_window_properties_b.information25%TYPE
899: ,information26 hr_window_properties_b.information26%TYPE
900: ,information27 hr_window_properties_b.information27%TYPE
901: ,information28 hr_window_properties_b.information28%TYPE

Line 898: ,information25 hr_window_properties_b.information25%TYPE

894: ,information21 hr_window_properties_b.information21%TYPE
895: ,information22 hr_window_properties_b.information22%TYPE
896: ,information23 hr_window_properties_b.information23%TYPE
897: ,information24 hr_window_properties_b.information24%TYPE
898: ,information25 hr_window_properties_b.information25%TYPE
899: ,information26 hr_window_properties_b.information26%TYPE
900: ,information27 hr_window_properties_b.information27%TYPE
901: ,information28 hr_window_properties_b.information28%TYPE
902: ,information29 hr_window_properties_b.information29%TYPE

Line 899: ,information26 hr_window_properties_b.information26%TYPE

895: ,information22 hr_window_properties_b.information22%TYPE
896: ,information23 hr_window_properties_b.information23%TYPE
897: ,information24 hr_window_properties_b.information24%TYPE
898: ,information25 hr_window_properties_b.information25%TYPE
899: ,information26 hr_window_properties_b.information26%TYPE
900: ,information27 hr_window_properties_b.information27%TYPE
901: ,information28 hr_window_properties_b.information28%TYPE
902: ,information29 hr_window_properties_b.information29%TYPE
903: ,information30 hr_window_properties_b.information30%TYPE);

Line 900: ,information27 hr_window_properties_b.information27%TYPE

896: ,information23 hr_window_properties_b.information23%TYPE
897: ,information24 hr_window_properties_b.information24%TYPE
898: ,information25 hr_window_properties_b.information25%TYPE
899: ,information26 hr_window_properties_b.information26%TYPE
900: ,information27 hr_window_properties_b.information27%TYPE
901: ,information28 hr_window_properties_b.information28%TYPE
902: ,information29 hr_window_properties_b.information29%TYPE
903: ,information30 hr_window_properties_b.information30%TYPE);
904:

Line 901: ,information28 hr_window_properties_b.information28%TYPE

897: ,information24 hr_window_properties_b.information24%TYPE
898: ,information25 hr_window_properties_b.information25%TYPE
899: ,information26 hr_window_properties_b.information26%TYPE
900: ,information27 hr_window_properties_b.information27%TYPE
901: ,information28 hr_window_properties_b.information28%TYPE
902: ,information29 hr_window_properties_b.information29%TYPE
903: ,information30 hr_window_properties_b.information30%TYPE);
904:
905: l_rec l_rec_type;

Line 902: ,information29 hr_window_properties_b.information29%TYPE

898: ,information25 hr_window_properties_b.information25%TYPE
899: ,information26 hr_window_properties_b.information26%TYPE
900: ,information27 hr_window_properties_b.information27%TYPE
901: ,information28 hr_window_properties_b.information28%TYPE
902: ,information29 hr_window_properties_b.information29%TYPE
903: ,information30 hr_window_properties_b.information30%TYPE);
904:
905: l_rec l_rec_type;
906:

Line 903: ,information30 hr_window_properties_b.information30%TYPE);

899: ,information26 hr_window_properties_b.information26%TYPE
900: ,information27 hr_window_properties_b.information27%TYPE
901: ,information28 hr_window_properties_b.information28%TYPE
902: ,information29 hr_window_properties_b.information29%TYPE
903: ,information30 hr_window_properties_b.information30%TYPE);
904:
905: l_rec l_rec_type;
906:
907: CURSOR cur_win_prop

Line 945: FROM hr_window_properties_b wnp

941: ,DECODE(p_information27,hr_api.g_varchar2,wnp.information27,p_information27)
942: ,DECODE(p_information28,hr_api.g_varchar2,wnp.information28,p_information28)
943: ,DECODE(p_information29,hr_api.g_varchar2,wnp.information29,p_information29)
944: ,DECODE(p_information30,hr_api.g_varchar2,wnp.information30,p_information30)
945: FROM hr_window_properties_b wnp
946: WHERE wnp.template_window_id = p_template_window_id_from;
947:
948: l_form_window_id number;
949:

Line 966: ,hr_window_properties_b wnp

962: SELECT COUNT(0)
963: ,wnptl.source_lang
964: ,DECODE(p_title,hr_api.g_varchar2,wnptl.title,p_title) title
965: FROM hr_window_properties_tl wnptl
966: ,hr_window_properties_b wnp
967: WHERE wnptl.window_property_id = wnp.window_property_id
968: AND wnp.form_window_id = l_form_window_id
969: GROUP BY wnptl.source_lang
970: ,DECODE(p_title,hr_api.g_varchar2,wnptl.title,p_title)

Line 1126: end hr_window_properties_bsi;

1122: hr_utility.set_location(' Leaving:'||l_proc, 90);
1123: raise;
1124: end copy_window_property;
1125: --
1126: end hr_window_properties_bsi;