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_TAB_PAGE_PROPERTIES_BSI dependencies on HR_TAB_PAGE_PROPERTIES_B

Line 1: Package Body hr_tab_page_properties_bsi as

1: Package Body hr_tab_page_properties_bsi as
2: /* $Header: hrtppbsi.pkb 120.0 2005/05/31 03:24:32 appldev noship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: hrtppbsi.pkb 120.0 2005/05/31 03:24:32 appldev noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' hr_tab_page_properties_bsi.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |--------------------------< create_tab_page_property >--------------------|
10: -- ----------------------------------------------------------------------------

Line 222: FROM hr_tab_page_properties_b

218: --
219: CURSOR cur_tab_prop_1
220: IS
221: SELECT tab_page_property_id
222: FROM hr_tab_page_properties_b
223: WHERE form_tab_page_id = p_form_tab_page_id;
224:
225: CURSOR cur_tab_prop_2
226: IS

Line 228: FROM hr_tab_page_properties_b

224:
225: CURSOR cur_tab_prop_2
226: IS
227: SELECT tab_page_property_id
228: FROM hr_tab_page_properties_b
229: WHERE template_tab_page_id = p_template_tab_page_id;
230:
231: l_tab_page_property number;
232: l_language_code fnd_languages.language_code%TYPE;

Line 394: FROM hr_tab_page_properties_b

390: --
391: CURSOR cur_tab_prop_1
392: IS
393: SELECT tab_page_property_id
394: FROM hr_tab_page_properties_b
395: WHERE form_tab_page_id = p_form_tab_page_id;
396:
397: CURSOR cur_tab_prop_2
398: IS

Line 400: FROM hr_tab_page_properties_b

396:
397: CURSOR cur_tab_prop_2
398: IS
399: SELECT tab_page_property_id
400: FROM hr_tab_page_properties_b
401: WHERE template_tab_page_id = p_template_tab_page_id;
402:
403: l_tab_page_property number;
404: l_tab_page_property_id number;

Line 552: (navigation_direction hr_tab_page_properties_b.navigation_direction%TYPE

548: --
549: -- Declare cursors and local variables
550: --
551: Type l_rec_type Is Record
552: (navigation_direction hr_tab_page_properties_b.navigation_direction%TYPE
553: ,visible hr_tab_page_properties_b.visible%TYPE
554: ,information_category hr_tab_page_properties_b.information_category%TYPE
555: ,information1 hr_tab_page_properties_b.information1%TYPE
556: ,information2 hr_tab_page_properties_b.information2%TYPE

Line 553: ,visible hr_tab_page_properties_b.visible%TYPE

549: -- Declare cursors and local variables
550: --
551: Type l_rec_type Is Record
552: (navigation_direction hr_tab_page_properties_b.navigation_direction%TYPE
553: ,visible hr_tab_page_properties_b.visible%TYPE
554: ,information_category hr_tab_page_properties_b.information_category%TYPE
555: ,information1 hr_tab_page_properties_b.information1%TYPE
556: ,information2 hr_tab_page_properties_b.information2%TYPE
557: ,information3 hr_tab_page_properties_b.information3%TYPE

Line 554: ,information_category hr_tab_page_properties_b.information_category%TYPE

550: --
551: Type l_rec_type Is Record
552: (navigation_direction hr_tab_page_properties_b.navigation_direction%TYPE
553: ,visible hr_tab_page_properties_b.visible%TYPE
554: ,information_category hr_tab_page_properties_b.information_category%TYPE
555: ,information1 hr_tab_page_properties_b.information1%TYPE
556: ,information2 hr_tab_page_properties_b.information2%TYPE
557: ,information3 hr_tab_page_properties_b.information3%TYPE
558: ,information4 hr_tab_page_properties_b.information4%TYPE

Line 555: ,information1 hr_tab_page_properties_b.information1%TYPE

551: Type l_rec_type Is Record
552: (navigation_direction hr_tab_page_properties_b.navigation_direction%TYPE
553: ,visible hr_tab_page_properties_b.visible%TYPE
554: ,information_category hr_tab_page_properties_b.information_category%TYPE
555: ,information1 hr_tab_page_properties_b.information1%TYPE
556: ,information2 hr_tab_page_properties_b.information2%TYPE
557: ,information3 hr_tab_page_properties_b.information3%TYPE
558: ,information4 hr_tab_page_properties_b.information4%TYPE
559: ,information5 hr_tab_page_properties_b.information5%TYPE

Line 556: ,information2 hr_tab_page_properties_b.information2%TYPE

552: (navigation_direction hr_tab_page_properties_b.navigation_direction%TYPE
553: ,visible hr_tab_page_properties_b.visible%TYPE
554: ,information_category hr_tab_page_properties_b.information_category%TYPE
555: ,information1 hr_tab_page_properties_b.information1%TYPE
556: ,information2 hr_tab_page_properties_b.information2%TYPE
557: ,information3 hr_tab_page_properties_b.information3%TYPE
558: ,information4 hr_tab_page_properties_b.information4%TYPE
559: ,information5 hr_tab_page_properties_b.information5%TYPE
560: ,information6 hr_tab_page_properties_b.information6%TYPE

Line 557: ,information3 hr_tab_page_properties_b.information3%TYPE

553: ,visible hr_tab_page_properties_b.visible%TYPE
554: ,information_category hr_tab_page_properties_b.information_category%TYPE
555: ,information1 hr_tab_page_properties_b.information1%TYPE
556: ,information2 hr_tab_page_properties_b.information2%TYPE
557: ,information3 hr_tab_page_properties_b.information3%TYPE
558: ,information4 hr_tab_page_properties_b.information4%TYPE
559: ,information5 hr_tab_page_properties_b.information5%TYPE
560: ,information6 hr_tab_page_properties_b.information6%TYPE
561: ,information7 hr_tab_page_properties_b.information7%TYPE

Line 558: ,information4 hr_tab_page_properties_b.information4%TYPE

554: ,information_category hr_tab_page_properties_b.information_category%TYPE
555: ,information1 hr_tab_page_properties_b.information1%TYPE
556: ,information2 hr_tab_page_properties_b.information2%TYPE
557: ,information3 hr_tab_page_properties_b.information3%TYPE
558: ,information4 hr_tab_page_properties_b.information4%TYPE
559: ,information5 hr_tab_page_properties_b.information5%TYPE
560: ,information6 hr_tab_page_properties_b.information6%TYPE
561: ,information7 hr_tab_page_properties_b.information7%TYPE
562: ,information8 hr_tab_page_properties_b.information8%TYPE

Line 559: ,information5 hr_tab_page_properties_b.information5%TYPE

555: ,information1 hr_tab_page_properties_b.information1%TYPE
556: ,information2 hr_tab_page_properties_b.information2%TYPE
557: ,information3 hr_tab_page_properties_b.information3%TYPE
558: ,information4 hr_tab_page_properties_b.information4%TYPE
559: ,information5 hr_tab_page_properties_b.information5%TYPE
560: ,information6 hr_tab_page_properties_b.information6%TYPE
561: ,information7 hr_tab_page_properties_b.information7%TYPE
562: ,information8 hr_tab_page_properties_b.information8%TYPE
563: ,information9 hr_tab_page_properties_b.information9%TYPE

Line 560: ,information6 hr_tab_page_properties_b.information6%TYPE

556: ,information2 hr_tab_page_properties_b.information2%TYPE
557: ,information3 hr_tab_page_properties_b.information3%TYPE
558: ,information4 hr_tab_page_properties_b.information4%TYPE
559: ,information5 hr_tab_page_properties_b.information5%TYPE
560: ,information6 hr_tab_page_properties_b.information6%TYPE
561: ,information7 hr_tab_page_properties_b.information7%TYPE
562: ,information8 hr_tab_page_properties_b.information8%TYPE
563: ,information9 hr_tab_page_properties_b.information9%TYPE
564: ,information10 hr_tab_page_properties_b.information10%TYPE

Line 561: ,information7 hr_tab_page_properties_b.information7%TYPE

557: ,information3 hr_tab_page_properties_b.information3%TYPE
558: ,information4 hr_tab_page_properties_b.information4%TYPE
559: ,information5 hr_tab_page_properties_b.information5%TYPE
560: ,information6 hr_tab_page_properties_b.information6%TYPE
561: ,information7 hr_tab_page_properties_b.information7%TYPE
562: ,information8 hr_tab_page_properties_b.information8%TYPE
563: ,information9 hr_tab_page_properties_b.information9%TYPE
564: ,information10 hr_tab_page_properties_b.information10%TYPE
565: ,information11 hr_tab_page_properties_b.information11%TYPE

Line 562: ,information8 hr_tab_page_properties_b.information8%TYPE

558: ,information4 hr_tab_page_properties_b.information4%TYPE
559: ,information5 hr_tab_page_properties_b.information5%TYPE
560: ,information6 hr_tab_page_properties_b.information6%TYPE
561: ,information7 hr_tab_page_properties_b.information7%TYPE
562: ,information8 hr_tab_page_properties_b.information8%TYPE
563: ,information9 hr_tab_page_properties_b.information9%TYPE
564: ,information10 hr_tab_page_properties_b.information10%TYPE
565: ,information11 hr_tab_page_properties_b.information11%TYPE
566: ,information12 hr_tab_page_properties_b.information12%TYPE

Line 563: ,information9 hr_tab_page_properties_b.information9%TYPE

559: ,information5 hr_tab_page_properties_b.information5%TYPE
560: ,information6 hr_tab_page_properties_b.information6%TYPE
561: ,information7 hr_tab_page_properties_b.information7%TYPE
562: ,information8 hr_tab_page_properties_b.information8%TYPE
563: ,information9 hr_tab_page_properties_b.information9%TYPE
564: ,information10 hr_tab_page_properties_b.information10%TYPE
565: ,information11 hr_tab_page_properties_b.information11%TYPE
566: ,information12 hr_tab_page_properties_b.information12%TYPE
567: ,information13 hr_tab_page_properties_b.information13%TYPE

Line 564: ,information10 hr_tab_page_properties_b.information10%TYPE

560: ,information6 hr_tab_page_properties_b.information6%TYPE
561: ,information7 hr_tab_page_properties_b.information7%TYPE
562: ,information8 hr_tab_page_properties_b.information8%TYPE
563: ,information9 hr_tab_page_properties_b.information9%TYPE
564: ,information10 hr_tab_page_properties_b.information10%TYPE
565: ,information11 hr_tab_page_properties_b.information11%TYPE
566: ,information12 hr_tab_page_properties_b.information12%TYPE
567: ,information13 hr_tab_page_properties_b.information13%TYPE
568: ,information14 hr_tab_page_properties_b.information14%TYPE

Line 565: ,information11 hr_tab_page_properties_b.information11%TYPE

561: ,information7 hr_tab_page_properties_b.information7%TYPE
562: ,information8 hr_tab_page_properties_b.information8%TYPE
563: ,information9 hr_tab_page_properties_b.information9%TYPE
564: ,information10 hr_tab_page_properties_b.information10%TYPE
565: ,information11 hr_tab_page_properties_b.information11%TYPE
566: ,information12 hr_tab_page_properties_b.information12%TYPE
567: ,information13 hr_tab_page_properties_b.information13%TYPE
568: ,information14 hr_tab_page_properties_b.information14%TYPE
569: ,information15 hr_tab_page_properties_b.information15%TYPE

Line 566: ,information12 hr_tab_page_properties_b.information12%TYPE

562: ,information8 hr_tab_page_properties_b.information8%TYPE
563: ,information9 hr_tab_page_properties_b.information9%TYPE
564: ,information10 hr_tab_page_properties_b.information10%TYPE
565: ,information11 hr_tab_page_properties_b.information11%TYPE
566: ,information12 hr_tab_page_properties_b.information12%TYPE
567: ,information13 hr_tab_page_properties_b.information13%TYPE
568: ,information14 hr_tab_page_properties_b.information14%TYPE
569: ,information15 hr_tab_page_properties_b.information15%TYPE
570: ,information16 hr_tab_page_properties_b.information16%TYPE

Line 567: ,information13 hr_tab_page_properties_b.information13%TYPE

563: ,information9 hr_tab_page_properties_b.information9%TYPE
564: ,information10 hr_tab_page_properties_b.information10%TYPE
565: ,information11 hr_tab_page_properties_b.information11%TYPE
566: ,information12 hr_tab_page_properties_b.information12%TYPE
567: ,information13 hr_tab_page_properties_b.information13%TYPE
568: ,information14 hr_tab_page_properties_b.information14%TYPE
569: ,information15 hr_tab_page_properties_b.information15%TYPE
570: ,information16 hr_tab_page_properties_b.information16%TYPE
571: ,information17 hr_tab_page_properties_b.information17%TYPE

Line 568: ,information14 hr_tab_page_properties_b.information14%TYPE

564: ,information10 hr_tab_page_properties_b.information10%TYPE
565: ,information11 hr_tab_page_properties_b.information11%TYPE
566: ,information12 hr_tab_page_properties_b.information12%TYPE
567: ,information13 hr_tab_page_properties_b.information13%TYPE
568: ,information14 hr_tab_page_properties_b.information14%TYPE
569: ,information15 hr_tab_page_properties_b.information15%TYPE
570: ,information16 hr_tab_page_properties_b.information16%TYPE
571: ,information17 hr_tab_page_properties_b.information17%TYPE
572: ,information18 hr_tab_page_properties_b.information18%TYPE

Line 569: ,information15 hr_tab_page_properties_b.information15%TYPE

565: ,information11 hr_tab_page_properties_b.information11%TYPE
566: ,information12 hr_tab_page_properties_b.information12%TYPE
567: ,information13 hr_tab_page_properties_b.information13%TYPE
568: ,information14 hr_tab_page_properties_b.information14%TYPE
569: ,information15 hr_tab_page_properties_b.information15%TYPE
570: ,information16 hr_tab_page_properties_b.information16%TYPE
571: ,information17 hr_tab_page_properties_b.information17%TYPE
572: ,information18 hr_tab_page_properties_b.information18%TYPE
573: ,information19 hr_tab_page_properties_b.information19%TYPE

Line 570: ,information16 hr_tab_page_properties_b.information16%TYPE

566: ,information12 hr_tab_page_properties_b.information12%TYPE
567: ,information13 hr_tab_page_properties_b.information13%TYPE
568: ,information14 hr_tab_page_properties_b.information14%TYPE
569: ,information15 hr_tab_page_properties_b.information15%TYPE
570: ,information16 hr_tab_page_properties_b.information16%TYPE
571: ,information17 hr_tab_page_properties_b.information17%TYPE
572: ,information18 hr_tab_page_properties_b.information18%TYPE
573: ,information19 hr_tab_page_properties_b.information19%TYPE
574: ,information20 hr_tab_page_properties_b.information20%TYPE

Line 571: ,information17 hr_tab_page_properties_b.information17%TYPE

567: ,information13 hr_tab_page_properties_b.information13%TYPE
568: ,information14 hr_tab_page_properties_b.information14%TYPE
569: ,information15 hr_tab_page_properties_b.information15%TYPE
570: ,information16 hr_tab_page_properties_b.information16%TYPE
571: ,information17 hr_tab_page_properties_b.information17%TYPE
572: ,information18 hr_tab_page_properties_b.information18%TYPE
573: ,information19 hr_tab_page_properties_b.information19%TYPE
574: ,information20 hr_tab_page_properties_b.information20%TYPE
575: ,information21 hr_tab_page_properties_b.information21%TYPE

Line 572: ,information18 hr_tab_page_properties_b.information18%TYPE

568: ,information14 hr_tab_page_properties_b.information14%TYPE
569: ,information15 hr_tab_page_properties_b.information15%TYPE
570: ,information16 hr_tab_page_properties_b.information16%TYPE
571: ,information17 hr_tab_page_properties_b.information17%TYPE
572: ,information18 hr_tab_page_properties_b.information18%TYPE
573: ,information19 hr_tab_page_properties_b.information19%TYPE
574: ,information20 hr_tab_page_properties_b.information20%TYPE
575: ,information21 hr_tab_page_properties_b.information21%TYPE
576: ,information22 hr_tab_page_properties_b.information22%TYPE

Line 573: ,information19 hr_tab_page_properties_b.information19%TYPE

569: ,information15 hr_tab_page_properties_b.information15%TYPE
570: ,information16 hr_tab_page_properties_b.information16%TYPE
571: ,information17 hr_tab_page_properties_b.information17%TYPE
572: ,information18 hr_tab_page_properties_b.information18%TYPE
573: ,information19 hr_tab_page_properties_b.information19%TYPE
574: ,information20 hr_tab_page_properties_b.information20%TYPE
575: ,information21 hr_tab_page_properties_b.information21%TYPE
576: ,information22 hr_tab_page_properties_b.information22%TYPE
577: ,information23 hr_tab_page_properties_b.information23%TYPE

Line 574: ,information20 hr_tab_page_properties_b.information20%TYPE

570: ,information16 hr_tab_page_properties_b.information16%TYPE
571: ,information17 hr_tab_page_properties_b.information17%TYPE
572: ,information18 hr_tab_page_properties_b.information18%TYPE
573: ,information19 hr_tab_page_properties_b.information19%TYPE
574: ,information20 hr_tab_page_properties_b.information20%TYPE
575: ,information21 hr_tab_page_properties_b.information21%TYPE
576: ,information22 hr_tab_page_properties_b.information22%TYPE
577: ,information23 hr_tab_page_properties_b.information23%TYPE
578: ,information24 hr_tab_page_properties_b.information24%TYPE

Line 575: ,information21 hr_tab_page_properties_b.information21%TYPE

571: ,information17 hr_tab_page_properties_b.information17%TYPE
572: ,information18 hr_tab_page_properties_b.information18%TYPE
573: ,information19 hr_tab_page_properties_b.information19%TYPE
574: ,information20 hr_tab_page_properties_b.information20%TYPE
575: ,information21 hr_tab_page_properties_b.information21%TYPE
576: ,information22 hr_tab_page_properties_b.information22%TYPE
577: ,information23 hr_tab_page_properties_b.information23%TYPE
578: ,information24 hr_tab_page_properties_b.information24%TYPE
579: ,information25 hr_tab_page_properties_b.information25%TYPE

Line 576: ,information22 hr_tab_page_properties_b.information22%TYPE

572: ,information18 hr_tab_page_properties_b.information18%TYPE
573: ,information19 hr_tab_page_properties_b.information19%TYPE
574: ,information20 hr_tab_page_properties_b.information20%TYPE
575: ,information21 hr_tab_page_properties_b.information21%TYPE
576: ,information22 hr_tab_page_properties_b.information22%TYPE
577: ,information23 hr_tab_page_properties_b.information23%TYPE
578: ,information24 hr_tab_page_properties_b.information24%TYPE
579: ,information25 hr_tab_page_properties_b.information25%TYPE
580: ,information26 hr_tab_page_properties_b.information26%TYPE

Line 577: ,information23 hr_tab_page_properties_b.information23%TYPE

573: ,information19 hr_tab_page_properties_b.information19%TYPE
574: ,information20 hr_tab_page_properties_b.information20%TYPE
575: ,information21 hr_tab_page_properties_b.information21%TYPE
576: ,information22 hr_tab_page_properties_b.information22%TYPE
577: ,information23 hr_tab_page_properties_b.information23%TYPE
578: ,information24 hr_tab_page_properties_b.information24%TYPE
579: ,information25 hr_tab_page_properties_b.information25%TYPE
580: ,information26 hr_tab_page_properties_b.information26%TYPE
581: ,information27 hr_tab_page_properties_b.information27%TYPE

Line 578: ,information24 hr_tab_page_properties_b.information24%TYPE

574: ,information20 hr_tab_page_properties_b.information20%TYPE
575: ,information21 hr_tab_page_properties_b.information21%TYPE
576: ,information22 hr_tab_page_properties_b.information22%TYPE
577: ,information23 hr_tab_page_properties_b.information23%TYPE
578: ,information24 hr_tab_page_properties_b.information24%TYPE
579: ,information25 hr_tab_page_properties_b.information25%TYPE
580: ,information26 hr_tab_page_properties_b.information26%TYPE
581: ,information27 hr_tab_page_properties_b.information27%TYPE
582: ,information28 hr_tab_page_properties_b.information28%TYPE

Line 579: ,information25 hr_tab_page_properties_b.information25%TYPE

575: ,information21 hr_tab_page_properties_b.information21%TYPE
576: ,information22 hr_tab_page_properties_b.information22%TYPE
577: ,information23 hr_tab_page_properties_b.information23%TYPE
578: ,information24 hr_tab_page_properties_b.information24%TYPE
579: ,information25 hr_tab_page_properties_b.information25%TYPE
580: ,information26 hr_tab_page_properties_b.information26%TYPE
581: ,information27 hr_tab_page_properties_b.information27%TYPE
582: ,information28 hr_tab_page_properties_b.information28%TYPE
583: ,information29 hr_tab_page_properties_b.information29%TYPE

Line 580: ,information26 hr_tab_page_properties_b.information26%TYPE

576: ,information22 hr_tab_page_properties_b.information22%TYPE
577: ,information23 hr_tab_page_properties_b.information23%TYPE
578: ,information24 hr_tab_page_properties_b.information24%TYPE
579: ,information25 hr_tab_page_properties_b.information25%TYPE
580: ,information26 hr_tab_page_properties_b.information26%TYPE
581: ,information27 hr_tab_page_properties_b.information27%TYPE
582: ,information28 hr_tab_page_properties_b.information28%TYPE
583: ,information29 hr_tab_page_properties_b.information29%TYPE
584: ,information30 hr_tab_page_properties_b.information30%TYPE);

Line 581: ,information27 hr_tab_page_properties_b.information27%TYPE

577: ,information23 hr_tab_page_properties_b.information23%TYPE
578: ,information24 hr_tab_page_properties_b.information24%TYPE
579: ,information25 hr_tab_page_properties_b.information25%TYPE
580: ,information26 hr_tab_page_properties_b.information26%TYPE
581: ,information27 hr_tab_page_properties_b.information27%TYPE
582: ,information28 hr_tab_page_properties_b.information28%TYPE
583: ,information29 hr_tab_page_properties_b.information29%TYPE
584: ,information30 hr_tab_page_properties_b.information30%TYPE);
585:

Line 582: ,information28 hr_tab_page_properties_b.information28%TYPE

578: ,information24 hr_tab_page_properties_b.information24%TYPE
579: ,information25 hr_tab_page_properties_b.information25%TYPE
580: ,information26 hr_tab_page_properties_b.information26%TYPE
581: ,information27 hr_tab_page_properties_b.information27%TYPE
582: ,information28 hr_tab_page_properties_b.information28%TYPE
583: ,information29 hr_tab_page_properties_b.information29%TYPE
584: ,information30 hr_tab_page_properties_b.information30%TYPE);
585:
586: l_rec l_rec_type;

Line 583: ,information29 hr_tab_page_properties_b.information29%TYPE

579: ,information25 hr_tab_page_properties_b.information25%TYPE
580: ,information26 hr_tab_page_properties_b.information26%TYPE
581: ,information27 hr_tab_page_properties_b.information27%TYPE
582: ,information28 hr_tab_page_properties_b.information28%TYPE
583: ,information29 hr_tab_page_properties_b.information29%TYPE
584: ,information30 hr_tab_page_properties_b.information30%TYPE);
585:
586: l_rec l_rec_type;
587:

Line 584: ,information30 hr_tab_page_properties_b.information30%TYPE);

580: ,information26 hr_tab_page_properties_b.information26%TYPE
581: ,information27 hr_tab_page_properties_b.information27%TYPE
582: ,information28 hr_tab_page_properties_b.information28%TYPE
583: ,information29 hr_tab_page_properties_b.information29%TYPE
584: ,information30 hr_tab_page_properties_b.information30%TYPE);
585:
586: l_rec l_rec_type;
587:
588: CURSOR cur_check

Line 630: FROM hr_tab_page_properties_b tpp

626: ,DECODE(p_information27,hr_api.g_varchar2,tpp.information27,p_information27)
627: ,DECODE(p_information28,hr_api.g_varchar2,tpp.information28,p_information28)
628: ,DECODE(p_information29,hr_api.g_varchar2,tpp.information29,p_information29)
629: ,DECODE(p_information30,hr_api.g_varchar2,tpp.information30,p_information30)
630: FROM hr_tab_page_properties_b tpp
631: WHERE tpp.form_tab_page_id = p_form_tab_page_id;
632:
633: CURSOR cur_tab_tl
634: IS

Line 639: ,hr_tab_page_properties_b tpp

635: SELECT COUNT(0)
636: ,tpptl.source_lang
637: ,DECODE(p_label,hr_api.g_varchar2,tpptl.label,p_label) label
638: FROM hr_tab_page_properties_tl tpptl
639: ,hr_tab_page_properties_b tpp
640: WHERE tpptl.tab_page_property_id = tpp.tab_page_property_id
641: AND tpp.form_tab_page_id = p_form_tab_page_id
642: GROUP BY tpptl.source_lang
643: ,DECODE(p_label,hr_api.g_varchar2,tpptl.label,p_label)

Line 839: (navigation_direction hr_tab_page_properties_b.navigation_direction%TYPE

835: --
836: -- Declare cursors and local variables
837: --
838: Type l_rec_type Is Record
839: (navigation_direction hr_tab_page_properties_b.navigation_direction%TYPE
840: ,visible hr_tab_page_properties_b.visible%TYPE
841: ,information_category hr_tab_page_properties_b.information_category%TYPE
842: ,information1 hr_tab_page_properties_b.information1%TYPE
843: ,information2 hr_tab_page_properties_b.information2%TYPE

Line 840: ,visible hr_tab_page_properties_b.visible%TYPE

836: -- Declare cursors and local variables
837: --
838: Type l_rec_type Is Record
839: (navigation_direction hr_tab_page_properties_b.navigation_direction%TYPE
840: ,visible hr_tab_page_properties_b.visible%TYPE
841: ,information_category hr_tab_page_properties_b.information_category%TYPE
842: ,information1 hr_tab_page_properties_b.information1%TYPE
843: ,information2 hr_tab_page_properties_b.information2%TYPE
844: ,information3 hr_tab_page_properties_b.information3%TYPE

Line 841: ,information_category hr_tab_page_properties_b.information_category%TYPE

837: --
838: Type l_rec_type Is Record
839: (navigation_direction hr_tab_page_properties_b.navigation_direction%TYPE
840: ,visible hr_tab_page_properties_b.visible%TYPE
841: ,information_category hr_tab_page_properties_b.information_category%TYPE
842: ,information1 hr_tab_page_properties_b.information1%TYPE
843: ,information2 hr_tab_page_properties_b.information2%TYPE
844: ,information3 hr_tab_page_properties_b.information3%TYPE
845: ,information4 hr_tab_page_properties_b.information4%TYPE

Line 842: ,information1 hr_tab_page_properties_b.information1%TYPE

838: Type l_rec_type Is Record
839: (navigation_direction hr_tab_page_properties_b.navigation_direction%TYPE
840: ,visible hr_tab_page_properties_b.visible%TYPE
841: ,information_category hr_tab_page_properties_b.information_category%TYPE
842: ,information1 hr_tab_page_properties_b.information1%TYPE
843: ,information2 hr_tab_page_properties_b.information2%TYPE
844: ,information3 hr_tab_page_properties_b.information3%TYPE
845: ,information4 hr_tab_page_properties_b.information4%TYPE
846: ,information5 hr_tab_page_properties_b.information5%TYPE

Line 843: ,information2 hr_tab_page_properties_b.information2%TYPE

839: (navigation_direction hr_tab_page_properties_b.navigation_direction%TYPE
840: ,visible hr_tab_page_properties_b.visible%TYPE
841: ,information_category hr_tab_page_properties_b.information_category%TYPE
842: ,information1 hr_tab_page_properties_b.information1%TYPE
843: ,information2 hr_tab_page_properties_b.information2%TYPE
844: ,information3 hr_tab_page_properties_b.information3%TYPE
845: ,information4 hr_tab_page_properties_b.information4%TYPE
846: ,information5 hr_tab_page_properties_b.information5%TYPE
847: ,information6 hr_tab_page_properties_b.information6%TYPE

Line 844: ,information3 hr_tab_page_properties_b.information3%TYPE

840: ,visible hr_tab_page_properties_b.visible%TYPE
841: ,information_category hr_tab_page_properties_b.information_category%TYPE
842: ,information1 hr_tab_page_properties_b.information1%TYPE
843: ,information2 hr_tab_page_properties_b.information2%TYPE
844: ,information3 hr_tab_page_properties_b.information3%TYPE
845: ,information4 hr_tab_page_properties_b.information4%TYPE
846: ,information5 hr_tab_page_properties_b.information5%TYPE
847: ,information6 hr_tab_page_properties_b.information6%TYPE
848: ,information7 hr_tab_page_properties_b.information7%TYPE

Line 845: ,information4 hr_tab_page_properties_b.information4%TYPE

841: ,information_category hr_tab_page_properties_b.information_category%TYPE
842: ,information1 hr_tab_page_properties_b.information1%TYPE
843: ,information2 hr_tab_page_properties_b.information2%TYPE
844: ,information3 hr_tab_page_properties_b.information3%TYPE
845: ,information4 hr_tab_page_properties_b.information4%TYPE
846: ,information5 hr_tab_page_properties_b.information5%TYPE
847: ,information6 hr_tab_page_properties_b.information6%TYPE
848: ,information7 hr_tab_page_properties_b.information7%TYPE
849: ,information8 hr_tab_page_properties_b.information8%TYPE

Line 846: ,information5 hr_tab_page_properties_b.information5%TYPE

842: ,information1 hr_tab_page_properties_b.information1%TYPE
843: ,information2 hr_tab_page_properties_b.information2%TYPE
844: ,information3 hr_tab_page_properties_b.information3%TYPE
845: ,information4 hr_tab_page_properties_b.information4%TYPE
846: ,information5 hr_tab_page_properties_b.information5%TYPE
847: ,information6 hr_tab_page_properties_b.information6%TYPE
848: ,information7 hr_tab_page_properties_b.information7%TYPE
849: ,information8 hr_tab_page_properties_b.information8%TYPE
850: ,information9 hr_tab_page_properties_b.information9%TYPE

Line 847: ,information6 hr_tab_page_properties_b.information6%TYPE

843: ,information2 hr_tab_page_properties_b.information2%TYPE
844: ,information3 hr_tab_page_properties_b.information3%TYPE
845: ,information4 hr_tab_page_properties_b.information4%TYPE
846: ,information5 hr_tab_page_properties_b.information5%TYPE
847: ,information6 hr_tab_page_properties_b.information6%TYPE
848: ,information7 hr_tab_page_properties_b.information7%TYPE
849: ,information8 hr_tab_page_properties_b.information8%TYPE
850: ,information9 hr_tab_page_properties_b.information9%TYPE
851: ,information10 hr_tab_page_properties_b.information10%TYPE

Line 848: ,information7 hr_tab_page_properties_b.information7%TYPE

844: ,information3 hr_tab_page_properties_b.information3%TYPE
845: ,information4 hr_tab_page_properties_b.information4%TYPE
846: ,information5 hr_tab_page_properties_b.information5%TYPE
847: ,information6 hr_tab_page_properties_b.information6%TYPE
848: ,information7 hr_tab_page_properties_b.information7%TYPE
849: ,information8 hr_tab_page_properties_b.information8%TYPE
850: ,information9 hr_tab_page_properties_b.information9%TYPE
851: ,information10 hr_tab_page_properties_b.information10%TYPE
852: ,information11 hr_tab_page_properties_b.information11%TYPE

Line 849: ,information8 hr_tab_page_properties_b.information8%TYPE

845: ,information4 hr_tab_page_properties_b.information4%TYPE
846: ,information5 hr_tab_page_properties_b.information5%TYPE
847: ,information6 hr_tab_page_properties_b.information6%TYPE
848: ,information7 hr_tab_page_properties_b.information7%TYPE
849: ,information8 hr_tab_page_properties_b.information8%TYPE
850: ,information9 hr_tab_page_properties_b.information9%TYPE
851: ,information10 hr_tab_page_properties_b.information10%TYPE
852: ,information11 hr_tab_page_properties_b.information11%TYPE
853: ,information12 hr_tab_page_properties_b.information12%TYPE

Line 850: ,information9 hr_tab_page_properties_b.information9%TYPE

846: ,information5 hr_tab_page_properties_b.information5%TYPE
847: ,information6 hr_tab_page_properties_b.information6%TYPE
848: ,information7 hr_tab_page_properties_b.information7%TYPE
849: ,information8 hr_tab_page_properties_b.information8%TYPE
850: ,information9 hr_tab_page_properties_b.information9%TYPE
851: ,information10 hr_tab_page_properties_b.information10%TYPE
852: ,information11 hr_tab_page_properties_b.information11%TYPE
853: ,information12 hr_tab_page_properties_b.information12%TYPE
854: ,information13 hr_tab_page_properties_b.information13%TYPE

Line 851: ,information10 hr_tab_page_properties_b.information10%TYPE

847: ,information6 hr_tab_page_properties_b.information6%TYPE
848: ,information7 hr_tab_page_properties_b.information7%TYPE
849: ,information8 hr_tab_page_properties_b.information8%TYPE
850: ,information9 hr_tab_page_properties_b.information9%TYPE
851: ,information10 hr_tab_page_properties_b.information10%TYPE
852: ,information11 hr_tab_page_properties_b.information11%TYPE
853: ,information12 hr_tab_page_properties_b.information12%TYPE
854: ,information13 hr_tab_page_properties_b.information13%TYPE
855: ,information14 hr_tab_page_properties_b.information14%TYPE

Line 852: ,information11 hr_tab_page_properties_b.information11%TYPE

848: ,information7 hr_tab_page_properties_b.information7%TYPE
849: ,information8 hr_tab_page_properties_b.information8%TYPE
850: ,information9 hr_tab_page_properties_b.information9%TYPE
851: ,information10 hr_tab_page_properties_b.information10%TYPE
852: ,information11 hr_tab_page_properties_b.information11%TYPE
853: ,information12 hr_tab_page_properties_b.information12%TYPE
854: ,information13 hr_tab_page_properties_b.information13%TYPE
855: ,information14 hr_tab_page_properties_b.information14%TYPE
856: ,information15 hr_tab_page_properties_b.information15%TYPE

Line 853: ,information12 hr_tab_page_properties_b.information12%TYPE

849: ,information8 hr_tab_page_properties_b.information8%TYPE
850: ,information9 hr_tab_page_properties_b.information9%TYPE
851: ,information10 hr_tab_page_properties_b.information10%TYPE
852: ,information11 hr_tab_page_properties_b.information11%TYPE
853: ,information12 hr_tab_page_properties_b.information12%TYPE
854: ,information13 hr_tab_page_properties_b.information13%TYPE
855: ,information14 hr_tab_page_properties_b.information14%TYPE
856: ,information15 hr_tab_page_properties_b.information15%TYPE
857: ,information16 hr_tab_page_properties_b.information16%TYPE

Line 854: ,information13 hr_tab_page_properties_b.information13%TYPE

850: ,information9 hr_tab_page_properties_b.information9%TYPE
851: ,information10 hr_tab_page_properties_b.information10%TYPE
852: ,information11 hr_tab_page_properties_b.information11%TYPE
853: ,information12 hr_tab_page_properties_b.information12%TYPE
854: ,information13 hr_tab_page_properties_b.information13%TYPE
855: ,information14 hr_tab_page_properties_b.information14%TYPE
856: ,information15 hr_tab_page_properties_b.information15%TYPE
857: ,information16 hr_tab_page_properties_b.information16%TYPE
858: ,information17 hr_tab_page_properties_b.information17%TYPE

Line 855: ,information14 hr_tab_page_properties_b.information14%TYPE

851: ,information10 hr_tab_page_properties_b.information10%TYPE
852: ,information11 hr_tab_page_properties_b.information11%TYPE
853: ,information12 hr_tab_page_properties_b.information12%TYPE
854: ,information13 hr_tab_page_properties_b.information13%TYPE
855: ,information14 hr_tab_page_properties_b.information14%TYPE
856: ,information15 hr_tab_page_properties_b.information15%TYPE
857: ,information16 hr_tab_page_properties_b.information16%TYPE
858: ,information17 hr_tab_page_properties_b.information17%TYPE
859: ,information18 hr_tab_page_properties_b.information18%TYPE

Line 856: ,information15 hr_tab_page_properties_b.information15%TYPE

852: ,information11 hr_tab_page_properties_b.information11%TYPE
853: ,information12 hr_tab_page_properties_b.information12%TYPE
854: ,information13 hr_tab_page_properties_b.information13%TYPE
855: ,information14 hr_tab_page_properties_b.information14%TYPE
856: ,information15 hr_tab_page_properties_b.information15%TYPE
857: ,information16 hr_tab_page_properties_b.information16%TYPE
858: ,information17 hr_tab_page_properties_b.information17%TYPE
859: ,information18 hr_tab_page_properties_b.information18%TYPE
860: ,information19 hr_tab_page_properties_b.information19%TYPE

Line 857: ,information16 hr_tab_page_properties_b.information16%TYPE

853: ,information12 hr_tab_page_properties_b.information12%TYPE
854: ,information13 hr_tab_page_properties_b.information13%TYPE
855: ,information14 hr_tab_page_properties_b.information14%TYPE
856: ,information15 hr_tab_page_properties_b.information15%TYPE
857: ,information16 hr_tab_page_properties_b.information16%TYPE
858: ,information17 hr_tab_page_properties_b.information17%TYPE
859: ,information18 hr_tab_page_properties_b.information18%TYPE
860: ,information19 hr_tab_page_properties_b.information19%TYPE
861: ,information20 hr_tab_page_properties_b.information20%TYPE

Line 858: ,information17 hr_tab_page_properties_b.information17%TYPE

854: ,information13 hr_tab_page_properties_b.information13%TYPE
855: ,information14 hr_tab_page_properties_b.information14%TYPE
856: ,information15 hr_tab_page_properties_b.information15%TYPE
857: ,information16 hr_tab_page_properties_b.information16%TYPE
858: ,information17 hr_tab_page_properties_b.information17%TYPE
859: ,information18 hr_tab_page_properties_b.information18%TYPE
860: ,information19 hr_tab_page_properties_b.information19%TYPE
861: ,information20 hr_tab_page_properties_b.information20%TYPE
862: ,information21 hr_tab_page_properties_b.information21%TYPE

Line 859: ,information18 hr_tab_page_properties_b.information18%TYPE

855: ,information14 hr_tab_page_properties_b.information14%TYPE
856: ,information15 hr_tab_page_properties_b.information15%TYPE
857: ,information16 hr_tab_page_properties_b.information16%TYPE
858: ,information17 hr_tab_page_properties_b.information17%TYPE
859: ,information18 hr_tab_page_properties_b.information18%TYPE
860: ,information19 hr_tab_page_properties_b.information19%TYPE
861: ,information20 hr_tab_page_properties_b.information20%TYPE
862: ,information21 hr_tab_page_properties_b.information21%TYPE
863: ,information22 hr_tab_page_properties_b.information22%TYPE

Line 860: ,information19 hr_tab_page_properties_b.information19%TYPE

856: ,information15 hr_tab_page_properties_b.information15%TYPE
857: ,information16 hr_tab_page_properties_b.information16%TYPE
858: ,information17 hr_tab_page_properties_b.information17%TYPE
859: ,information18 hr_tab_page_properties_b.information18%TYPE
860: ,information19 hr_tab_page_properties_b.information19%TYPE
861: ,information20 hr_tab_page_properties_b.information20%TYPE
862: ,information21 hr_tab_page_properties_b.information21%TYPE
863: ,information22 hr_tab_page_properties_b.information22%TYPE
864: ,information23 hr_tab_page_properties_b.information23%TYPE

Line 861: ,information20 hr_tab_page_properties_b.information20%TYPE

857: ,information16 hr_tab_page_properties_b.information16%TYPE
858: ,information17 hr_tab_page_properties_b.information17%TYPE
859: ,information18 hr_tab_page_properties_b.information18%TYPE
860: ,information19 hr_tab_page_properties_b.information19%TYPE
861: ,information20 hr_tab_page_properties_b.information20%TYPE
862: ,information21 hr_tab_page_properties_b.information21%TYPE
863: ,information22 hr_tab_page_properties_b.information22%TYPE
864: ,information23 hr_tab_page_properties_b.information23%TYPE
865: ,information24 hr_tab_page_properties_b.information24%TYPE

Line 862: ,information21 hr_tab_page_properties_b.information21%TYPE

858: ,information17 hr_tab_page_properties_b.information17%TYPE
859: ,information18 hr_tab_page_properties_b.information18%TYPE
860: ,information19 hr_tab_page_properties_b.information19%TYPE
861: ,information20 hr_tab_page_properties_b.information20%TYPE
862: ,information21 hr_tab_page_properties_b.information21%TYPE
863: ,information22 hr_tab_page_properties_b.information22%TYPE
864: ,information23 hr_tab_page_properties_b.information23%TYPE
865: ,information24 hr_tab_page_properties_b.information24%TYPE
866: ,information25 hr_tab_page_properties_b.information25%TYPE

Line 863: ,information22 hr_tab_page_properties_b.information22%TYPE

859: ,information18 hr_tab_page_properties_b.information18%TYPE
860: ,information19 hr_tab_page_properties_b.information19%TYPE
861: ,information20 hr_tab_page_properties_b.information20%TYPE
862: ,information21 hr_tab_page_properties_b.information21%TYPE
863: ,information22 hr_tab_page_properties_b.information22%TYPE
864: ,information23 hr_tab_page_properties_b.information23%TYPE
865: ,information24 hr_tab_page_properties_b.information24%TYPE
866: ,information25 hr_tab_page_properties_b.information25%TYPE
867: ,information26 hr_tab_page_properties_b.information26%TYPE

Line 864: ,information23 hr_tab_page_properties_b.information23%TYPE

860: ,information19 hr_tab_page_properties_b.information19%TYPE
861: ,information20 hr_tab_page_properties_b.information20%TYPE
862: ,information21 hr_tab_page_properties_b.information21%TYPE
863: ,information22 hr_tab_page_properties_b.information22%TYPE
864: ,information23 hr_tab_page_properties_b.information23%TYPE
865: ,information24 hr_tab_page_properties_b.information24%TYPE
866: ,information25 hr_tab_page_properties_b.information25%TYPE
867: ,information26 hr_tab_page_properties_b.information26%TYPE
868: ,information27 hr_tab_page_properties_b.information27%TYPE

Line 865: ,information24 hr_tab_page_properties_b.information24%TYPE

861: ,information20 hr_tab_page_properties_b.information20%TYPE
862: ,information21 hr_tab_page_properties_b.information21%TYPE
863: ,information22 hr_tab_page_properties_b.information22%TYPE
864: ,information23 hr_tab_page_properties_b.information23%TYPE
865: ,information24 hr_tab_page_properties_b.information24%TYPE
866: ,information25 hr_tab_page_properties_b.information25%TYPE
867: ,information26 hr_tab_page_properties_b.information26%TYPE
868: ,information27 hr_tab_page_properties_b.information27%TYPE
869: ,information28 hr_tab_page_properties_b.information28%TYPE

Line 866: ,information25 hr_tab_page_properties_b.information25%TYPE

862: ,information21 hr_tab_page_properties_b.information21%TYPE
863: ,information22 hr_tab_page_properties_b.information22%TYPE
864: ,information23 hr_tab_page_properties_b.information23%TYPE
865: ,information24 hr_tab_page_properties_b.information24%TYPE
866: ,information25 hr_tab_page_properties_b.information25%TYPE
867: ,information26 hr_tab_page_properties_b.information26%TYPE
868: ,information27 hr_tab_page_properties_b.information27%TYPE
869: ,information28 hr_tab_page_properties_b.information28%TYPE
870: ,information29 hr_tab_page_properties_b.information29%TYPE

Line 867: ,information26 hr_tab_page_properties_b.information26%TYPE

863: ,information22 hr_tab_page_properties_b.information22%TYPE
864: ,information23 hr_tab_page_properties_b.information23%TYPE
865: ,information24 hr_tab_page_properties_b.information24%TYPE
866: ,information25 hr_tab_page_properties_b.information25%TYPE
867: ,information26 hr_tab_page_properties_b.information26%TYPE
868: ,information27 hr_tab_page_properties_b.information27%TYPE
869: ,information28 hr_tab_page_properties_b.information28%TYPE
870: ,information29 hr_tab_page_properties_b.information29%TYPE
871: ,information30 hr_tab_page_properties_b.information30%TYPE);

Line 868: ,information27 hr_tab_page_properties_b.information27%TYPE

864: ,information23 hr_tab_page_properties_b.information23%TYPE
865: ,information24 hr_tab_page_properties_b.information24%TYPE
866: ,information25 hr_tab_page_properties_b.information25%TYPE
867: ,information26 hr_tab_page_properties_b.information26%TYPE
868: ,information27 hr_tab_page_properties_b.information27%TYPE
869: ,information28 hr_tab_page_properties_b.information28%TYPE
870: ,information29 hr_tab_page_properties_b.information29%TYPE
871: ,information30 hr_tab_page_properties_b.information30%TYPE);
872:

Line 869: ,information28 hr_tab_page_properties_b.information28%TYPE

865: ,information24 hr_tab_page_properties_b.information24%TYPE
866: ,information25 hr_tab_page_properties_b.information25%TYPE
867: ,information26 hr_tab_page_properties_b.information26%TYPE
868: ,information27 hr_tab_page_properties_b.information27%TYPE
869: ,information28 hr_tab_page_properties_b.information28%TYPE
870: ,information29 hr_tab_page_properties_b.information29%TYPE
871: ,information30 hr_tab_page_properties_b.information30%TYPE);
872:
873: l_rec l_rec_type;

Line 870: ,information29 hr_tab_page_properties_b.information29%TYPE

866: ,information25 hr_tab_page_properties_b.information25%TYPE
867: ,information26 hr_tab_page_properties_b.information26%TYPE
868: ,information27 hr_tab_page_properties_b.information27%TYPE
869: ,information28 hr_tab_page_properties_b.information28%TYPE
870: ,information29 hr_tab_page_properties_b.information29%TYPE
871: ,information30 hr_tab_page_properties_b.information30%TYPE);
872:
873: l_rec l_rec_type;
874:

Line 871: ,information30 hr_tab_page_properties_b.information30%TYPE);

867: ,information26 hr_tab_page_properties_b.information26%TYPE
868: ,information27 hr_tab_page_properties_b.information27%TYPE
869: ,information28 hr_tab_page_properties_b.information28%TYPE
870: ,information29 hr_tab_page_properties_b.information29%TYPE
871: ,information30 hr_tab_page_properties_b.information30%TYPE);
872:
873: l_rec l_rec_type;
874:
875: CURSOR cur_check

Line 920: FROM hr_tab_page_properties_b tpp

916: ,DECODE(p_information27,hr_api.g_varchar2,tpp.information27,p_information27)
917: ,DECODE(p_information28,hr_api.g_varchar2,tpp.information28,p_information28)
918: ,DECODE(p_information29,hr_api.g_varchar2,tpp.information29,p_information29)
919: ,DECODE(p_information30,hr_api.g_varchar2,tpp.information30,p_information30)
920: FROM hr_tab_page_properties_b tpp
921: WHERE tpp.template_tab_page_id = p_template_tab_page_id_from;
922:
923: CURSOR cur_tab_tl
924: IS

Line 929: ,hr_tab_page_properties_b tpp

925: SELECT COUNT(0)
926: ,tpptl.source_lang
927: ,DECODE(p_label,hr_api.g_varchar2,tpptl.label,p_label) label
928: FROM hr_tab_page_properties_tl tpptl
929: ,hr_tab_page_properties_b tpp
930: WHERE tpptl.tab_page_property_id = tpp.tab_page_property_id
931: AND tpp.template_tab_page_id = p_template_tab_page_id_from
932: GROUP BY tpptl.source_lang
933: ,DECODE(p_label,hr_api.g_varchar2,tpptl.label,p_label)

Line 1077: end hr_tab_page_properties_bsi;

1073: hr_utility.set_location(' Leaving:'||l_proc, 90);
1074: raise;
1075: end copy_tab_page_property;
1076: --
1077: end hr_tab_page_properties_bsi;