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_CANVAS_PROPERTIES_BSI dependencies on HR_CANVAS_PROPERTIES

Line 1: Package Body hr_canvas_properties_bsi as

1: Package Body hr_canvas_properties_bsi as
2: /* $Header: hrcnpbsi.pkb 120.0 2005/05/30 23:16:05 appldev noship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: hrcnpbsi.pkb 120.0 2005/05/30 23:16:05 appldev noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' hr_canvas_properties_bsi.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |---------------------< create_canvas_property >--------------------------|
10: -- ----------------------------------------------------------------------------

Line 208: FROM hr_canvas_properties

204:
205: CURSOR cur_can_prop_1
206: IS
207: SELECT canvas_property_id
208: FROM hr_canvas_properties
209: WHERE form_canvas_id = p_form_canvas_id;
210:
211: CURSOR cur_can_prop_2
212: IS

Line 214: FROM hr_canvas_properties

210:
211: CURSOR cur_can_prop_2
212: IS
213: SELECT canvas_property_id
214: FROM hr_canvas_properties
215: WHERE template_canvas_id = p_template_canvas_id;
216:
217: l_canvas_property_id number;
218: l_proc varchar2(72) := g_package||'update_canvas_property';

Line 370: FROM hr_canvas_properties

366: --
367: CURSOR cur_can_prop_1
368: IS
369: SELECT canvas_property_id
370: FROM hr_canvas_properties
371: WHERE form_canvas_id = p_form_canvas_id;
372:
373: CURSOR cur_can_prop_2
374: IS

Line 376: FROM hr_canvas_properties

372:
373: CURSOR cur_can_prop_2
374: IS
375: SELECT canvas_property_id
376: FROM hr_canvas_properties
377: WHERE template_canvas_id = p_template_canvas_id;
378:
379: l_proc varchar2(72) := g_package||'delete_canvas_property';
380: l_canvas_property_id number;

Line 532: (height hr_canvas_properties.height%TYPE

528: --
529: -- Declare cursors and local variables
530: --
531: Type l_rec_type Is Record
532: (height hr_canvas_properties.height%TYPE
533: ,visible hr_canvas_properties.visible%TYPE
534: ,width hr_canvas_properties.width%TYPE
535: ,x_position hr_canvas_properties.x_position%TYPE
536: ,y_position hr_canvas_properties.y_position%TYPE

Line 533: ,visible hr_canvas_properties.visible%TYPE

529: -- Declare cursors and local variables
530: --
531: Type l_rec_type Is Record
532: (height hr_canvas_properties.height%TYPE
533: ,visible hr_canvas_properties.visible%TYPE
534: ,width hr_canvas_properties.width%TYPE
535: ,x_position hr_canvas_properties.x_position%TYPE
536: ,y_position hr_canvas_properties.y_position%TYPE
537: ,information_category hr_canvas_properties.information_category%TYPE

Line 534: ,width hr_canvas_properties.width%TYPE

530: --
531: Type l_rec_type Is Record
532: (height hr_canvas_properties.height%TYPE
533: ,visible hr_canvas_properties.visible%TYPE
534: ,width hr_canvas_properties.width%TYPE
535: ,x_position hr_canvas_properties.x_position%TYPE
536: ,y_position hr_canvas_properties.y_position%TYPE
537: ,information_category hr_canvas_properties.information_category%TYPE
538: ,information1 hr_canvas_properties.information1%TYPE

Line 535: ,x_position hr_canvas_properties.x_position%TYPE

531: Type l_rec_type Is Record
532: (height hr_canvas_properties.height%TYPE
533: ,visible hr_canvas_properties.visible%TYPE
534: ,width hr_canvas_properties.width%TYPE
535: ,x_position hr_canvas_properties.x_position%TYPE
536: ,y_position hr_canvas_properties.y_position%TYPE
537: ,information_category hr_canvas_properties.information_category%TYPE
538: ,information1 hr_canvas_properties.information1%TYPE
539: ,information2 hr_canvas_properties.information2%TYPE

Line 536: ,y_position hr_canvas_properties.y_position%TYPE

532: (height hr_canvas_properties.height%TYPE
533: ,visible hr_canvas_properties.visible%TYPE
534: ,width hr_canvas_properties.width%TYPE
535: ,x_position hr_canvas_properties.x_position%TYPE
536: ,y_position hr_canvas_properties.y_position%TYPE
537: ,information_category hr_canvas_properties.information_category%TYPE
538: ,information1 hr_canvas_properties.information1%TYPE
539: ,information2 hr_canvas_properties.information2%TYPE
540: ,information3 hr_canvas_properties.information3%TYPE

Line 537: ,information_category hr_canvas_properties.information_category%TYPE

533: ,visible hr_canvas_properties.visible%TYPE
534: ,width hr_canvas_properties.width%TYPE
535: ,x_position hr_canvas_properties.x_position%TYPE
536: ,y_position hr_canvas_properties.y_position%TYPE
537: ,information_category hr_canvas_properties.information_category%TYPE
538: ,information1 hr_canvas_properties.information1%TYPE
539: ,information2 hr_canvas_properties.information2%TYPE
540: ,information3 hr_canvas_properties.information3%TYPE
541: ,information4 hr_canvas_properties.information4%TYPE

Line 538: ,information1 hr_canvas_properties.information1%TYPE

534: ,width hr_canvas_properties.width%TYPE
535: ,x_position hr_canvas_properties.x_position%TYPE
536: ,y_position hr_canvas_properties.y_position%TYPE
537: ,information_category hr_canvas_properties.information_category%TYPE
538: ,information1 hr_canvas_properties.information1%TYPE
539: ,information2 hr_canvas_properties.information2%TYPE
540: ,information3 hr_canvas_properties.information3%TYPE
541: ,information4 hr_canvas_properties.information4%TYPE
542: ,information5 hr_canvas_properties.information5%TYPE

Line 539: ,information2 hr_canvas_properties.information2%TYPE

535: ,x_position hr_canvas_properties.x_position%TYPE
536: ,y_position hr_canvas_properties.y_position%TYPE
537: ,information_category hr_canvas_properties.information_category%TYPE
538: ,information1 hr_canvas_properties.information1%TYPE
539: ,information2 hr_canvas_properties.information2%TYPE
540: ,information3 hr_canvas_properties.information3%TYPE
541: ,information4 hr_canvas_properties.information4%TYPE
542: ,information5 hr_canvas_properties.information5%TYPE
543: ,information6 hr_canvas_properties.information6%TYPE

Line 540: ,information3 hr_canvas_properties.information3%TYPE

536: ,y_position hr_canvas_properties.y_position%TYPE
537: ,information_category hr_canvas_properties.information_category%TYPE
538: ,information1 hr_canvas_properties.information1%TYPE
539: ,information2 hr_canvas_properties.information2%TYPE
540: ,information3 hr_canvas_properties.information3%TYPE
541: ,information4 hr_canvas_properties.information4%TYPE
542: ,information5 hr_canvas_properties.information5%TYPE
543: ,information6 hr_canvas_properties.information6%TYPE
544: ,information7 hr_canvas_properties.information7%TYPE

Line 541: ,information4 hr_canvas_properties.information4%TYPE

537: ,information_category hr_canvas_properties.information_category%TYPE
538: ,information1 hr_canvas_properties.information1%TYPE
539: ,information2 hr_canvas_properties.information2%TYPE
540: ,information3 hr_canvas_properties.information3%TYPE
541: ,information4 hr_canvas_properties.information4%TYPE
542: ,information5 hr_canvas_properties.information5%TYPE
543: ,information6 hr_canvas_properties.information6%TYPE
544: ,information7 hr_canvas_properties.information7%TYPE
545: ,information8 hr_canvas_properties.information8%TYPE

Line 542: ,information5 hr_canvas_properties.information5%TYPE

538: ,information1 hr_canvas_properties.information1%TYPE
539: ,information2 hr_canvas_properties.information2%TYPE
540: ,information3 hr_canvas_properties.information3%TYPE
541: ,information4 hr_canvas_properties.information4%TYPE
542: ,information5 hr_canvas_properties.information5%TYPE
543: ,information6 hr_canvas_properties.information6%TYPE
544: ,information7 hr_canvas_properties.information7%TYPE
545: ,information8 hr_canvas_properties.information8%TYPE
546: ,information9 hr_canvas_properties.information9%TYPE

Line 543: ,information6 hr_canvas_properties.information6%TYPE

539: ,information2 hr_canvas_properties.information2%TYPE
540: ,information3 hr_canvas_properties.information3%TYPE
541: ,information4 hr_canvas_properties.information4%TYPE
542: ,information5 hr_canvas_properties.information5%TYPE
543: ,information6 hr_canvas_properties.information6%TYPE
544: ,information7 hr_canvas_properties.information7%TYPE
545: ,information8 hr_canvas_properties.information8%TYPE
546: ,information9 hr_canvas_properties.information9%TYPE
547: ,information10 hr_canvas_properties.information10%TYPE

Line 544: ,information7 hr_canvas_properties.information7%TYPE

540: ,information3 hr_canvas_properties.information3%TYPE
541: ,information4 hr_canvas_properties.information4%TYPE
542: ,information5 hr_canvas_properties.information5%TYPE
543: ,information6 hr_canvas_properties.information6%TYPE
544: ,information7 hr_canvas_properties.information7%TYPE
545: ,information8 hr_canvas_properties.information8%TYPE
546: ,information9 hr_canvas_properties.information9%TYPE
547: ,information10 hr_canvas_properties.information10%TYPE
548: ,information11 hr_canvas_properties.information11%TYPE

Line 545: ,information8 hr_canvas_properties.information8%TYPE

541: ,information4 hr_canvas_properties.information4%TYPE
542: ,information5 hr_canvas_properties.information5%TYPE
543: ,information6 hr_canvas_properties.information6%TYPE
544: ,information7 hr_canvas_properties.information7%TYPE
545: ,information8 hr_canvas_properties.information8%TYPE
546: ,information9 hr_canvas_properties.information9%TYPE
547: ,information10 hr_canvas_properties.information10%TYPE
548: ,information11 hr_canvas_properties.information11%TYPE
549: ,information12 hr_canvas_properties.information12%TYPE

Line 546: ,information9 hr_canvas_properties.information9%TYPE

542: ,information5 hr_canvas_properties.information5%TYPE
543: ,information6 hr_canvas_properties.information6%TYPE
544: ,information7 hr_canvas_properties.information7%TYPE
545: ,information8 hr_canvas_properties.information8%TYPE
546: ,information9 hr_canvas_properties.information9%TYPE
547: ,information10 hr_canvas_properties.information10%TYPE
548: ,information11 hr_canvas_properties.information11%TYPE
549: ,information12 hr_canvas_properties.information12%TYPE
550: ,information13 hr_canvas_properties.information13%TYPE

Line 547: ,information10 hr_canvas_properties.information10%TYPE

543: ,information6 hr_canvas_properties.information6%TYPE
544: ,information7 hr_canvas_properties.information7%TYPE
545: ,information8 hr_canvas_properties.information8%TYPE
546: ,information9 hr_canvas_properties.information9%TYPE
547: ,information10 hr_canvas_properties.information10%TYPE
548: ,information11 hr_canvas_properties.information11%TYPE
549: ,information12 hr_canvas_properties.information12%TYPE
550: ,information13 hr_canvas_properties.information13%TYPE
551: ,information14 hr_canvas_properties.information14%TYPE

Line 548: ,information11 hr_canvas_properties.information11%TYPE

544: ,information7 hr_canvas_properties.information7%TYPE
545: ,information8 hr_canvas_properties.information8%TYPE
546: ,information9 hr_canvas_properties.information9%TYPE
547: ,information10 hr_canvas_properties.information10%TYPE
548: ,information11 hr_canvas_properties.information11%TYPE
549: ,information12 hr_canvas_properties.information12%TYPE
550: ,information13 hr_canvas_properties.information13%TYPE
551: ,information14 hr_canvas_properties.information14%TYPE
552: ,information15 hr_canvas_properties.information15%TYPE

Line 549: ,information12 hr_canvas_properties.information12%TYPE

545: ,information8 hr_canvas_properties.information8%TYPE
546: ,information9 hr_canvas_properties.information9%TYPE
547: ,information10 hr_canvas_properties.information10%TYPE
548: ,information11 hr_canvas_properties.information11%TYPE
549: ,information12 hr_canvas_properties.information12%TYPE
550: ,information13 hr_canvas_properties.information13%TYPE
551: ,information14 hr_canvas_properties.information14%TYPE
552: ,information15 hr_canvas_properties.information15%TYPE
553: ,information16 hr_canvas_properties.information16%TYPE

Line 550: ,information13 hr_canvas_properties.information13%TYPE

546: ,information9 hr_canvas_properties.information9%TYPE
547: ,information10 hr_canvas_properties.information10%TYPE
548: ,information11 hr_canvas_properties.information11%TYPE
549: ,information12 hr_canvas_properties.information12%TYPE
550: ,information13 hr_canvas_properties.information13%TYPE
551: ,information14 hr_canvas_properties.information14%TYPE
552: ,information15 hr_canvas_properties.information15%TYPE
553: ,information16 hr_canvas_properties.information16%TYPE
554: ,information17 hr_canvas_properties.information17%TYPE

Line 551: ,information14 hr_canvas_properties.information14%TYPE

547: ,information10 hr_canvas_properties.information10%TYPE
548: ,information11 hr_canvas_properties.information11%TYPE
549: ,information12 hr_canvas_properties.information12%TYPE
550: ,information13 hr_canvas_properties.information13%TYPE
551: ,information14 hr_canvas_properties.information14%TYPE
552: ,information15 hr_canvas_properties.information15%TYPE
553: ,information16 hr_canvas_properties.information16%TYPE
554: ,information17 hr_canvas_properties.information17%TYPE
555: ,information18 hr_canvas_properties.information18%TYPE

Line 552: ,information15 hr_canvas_properties.information15%TYPE

548: ,information11 hr_canvas_properties.information11%TYPE
549: ,information12 hr_canvas_properties.information12%TYPE
550: ,information13 hr_canvas_properties.information13%TYPE
551: ,information14 hr_canvas_properties.information14%TYPE
552: ,information15 hr_canvas_properties.information15%TYPE
553: ,information16 hr_canvas_properties.information16%TYPE
554: ,information17 hr_canvas_properties.information17%TYPE
555: ,information18 hr_canvas_properties.information18%TYPE
556: ,information19 hr_canvas_properties.information19%TYPE

Line 553: ,information16 hr_canvas_properties.information16%TYPE

549: ,information12 hr_canvas_properties.information12%TYPE
550: ,information13 hr_canvas_properties.information13%TYPE
551: ,information14 hr_canvas_properties.information14%TYPE
552: ,information15 hr_canvas_properties.information15%TYPE
553: ,information16 hr_canvas_properties.information16%TYPE
554: ,information17 hr_canvas_properties.information17%TYPE
555: ,information18 hr_canvas_properties.information18%TYPE
556: ,information19 hr_canvas_properties.information19%TYPE
557: ,information20 hr_canvas_properties.information20%TYPE

Line 554: ,information17 hr_canvas_properties.information17%TYPE

550: ,information13 hr_canvas_properties.information13%TYPE
551: ,information14 hr_canvas_properties.information14%TYPE
552: ,information15 hr_canvas_properties.information15%TYPE
553: ,information16 hr_canvas_properties.information16%TYPE
554: ,information17 hr_canvas_properties.information17%TYPE
555: ,information18 hr_canvas_properties.information18%TYPE
556: ,information19 hr_canvas_properties.information19%TYPE
557: ,information20 hr_canvas_properties.information20%TYPE
558: ,information21 hr_canvas_properties.information21%TYPE

Line 555: ,information18 hr_canvas_properties.information18%TYPE

551: ,information14 hr_canvas_properties.information14%TYPE
552: ,information15 hr_canvas_properties.information15%TYPE
553: ,information16 hr_canvas_properties.information16%TYPE
554: ,information17 hr_canvas_properties.information17%TYPE
555: ,information18 hr_canvas_properties.information18%TYPE
556: ,information19 hr_canvas_properties.information19%TYPE
557: ,information20 hr_canvas_properties.information20%TYPE
558: ,information21 hr_canvas_properties.information21%TYPE
559: ,information22 hr_canvas_properties.information22%TYPE

Line 556: ,information19 hr_canvas_properties.information19%TYPE

552: ,information15 hr_canvas_properties.information15%TYPE
553: ,information16 hr_canvas_properties.information16%TYPE
554: ,information17 hr_canvas_properties.information17%TYPE
555: ,information18 hr_canvas_properties.information18%TYPE
556: ,information19 hr_canvas_properties.information19%TYPE
557: ,information20 hr_canvas_properties.information20%TYPE
558: ,information21 hr_canvas_properties.information21%TYPE
559: ,information22 hr_canvas_properties.information22%TYPE
560: ,information23 hr_canvas_properties.information23%TYPE

Line 557: ,information20 hr_canvas_properties.information20%TYPE

553: ,information16 hr_canvas_properties.information16%TYPE
554: ,information17 hr_canvas_properties.information17%TYPE
555: ,information18 hr_canvas_properties.information18%TYPE
556: ,information19 hr_canvas_properties.information19%TYPE
557: ,information20 hr_canvas_properties.information20%TYPE
558: ,information21 hr_canvas_properties.information21%TYPE
559: ,information22 hr_canvas_properties.information22%TYPE
560: ,information23 hr_canvas_properties.information23%TYPE
561: ,information24 hr_canvas_properties.information24%TYPE

Line 558: ,information21 hr_canvas_properties.information21%TYPE

554: ,information17 hr_canvas_properties.information17%TYPE
555: ,information18 hr_canvas_properties.information18%TYPE
556: ,information19 hr_canvas_properties.information19%TYPE
557: ,information20 hr_canvas_properties.information20%TYPE
558: ,information21 hr_canvas_properties.information21%TYPE
559: ,information22 hr_canvas_properties.information22%TYPE
560: ,information23 hr_canvas_properties.information23%TYPE
561: ,information24 hr_canvas_properties.information24%TYPE
562: ,information25 hr_canvas_properties.information25%TYPE

Line 559: ,information22 hr_canvas_properties.information22%TYPE

555: ,information18 hr_canvas_properties.information18%TYPE
556: ,information19 hr_canvas_properties.information19%TYPE
557: ,information20 hr_canvas_properties.information20%TYPE
558: ,information21 hr_canvas_properties.information21%TYPE
559: ,information22 hr_canvas_properties.information22%TYPE
560: ,information23 hr_canvas_properties.information23%TYPE
561: ,information24 hr_canvas_properties.information24%TYPE
562: ,information25 hr_canvas_properties.information25%TYPE
563: ,information26 hr_canvas_properties.information26%TYPE

Line 560: ,information23 hr_canvas_properties.information23%TYPE

556: ,information19 hr_canvas_properties.information19%TYPE
557: ,information20 hr_canvas_properties.information20%TYPE
558: ,information21 hr_canvas_properties.information21%TYPE
559: ,information22 hr_canvas_properties.information22%TYPE
560: ,information23 hr_canvas_properties.information23%TYPE
561: ,information24 hr_canvas_properties.information24%TYPE
562: ,information25 hr_canvas_properties.information25%TYPE
563: ,information26 hr_canvas_properties.information26%TYPE
564: ,information27 hr_canvas_properties.information27%TYPE

Line 561: ,information24 hr_canvas_properties.information24%TYPE

557: ,information20 hr_canvas_properties.information20%TYPE
558: ,information21 hr_canvas_properties.information21%TYPE
559: ,information22 hr_canvas_properties.information22%TYPE
560: ,information23 hr_canvas_properties.information23%TYPE
561: ,information24 hr_canvas_properties.information24%TYPE
562: ,information25 hr_canvas_properties.information25%TYPE
563: ,information26 hr_canvas_properties.information26%TYPE
564: ,information27 hr_canvas_properties.information27%TYPE
565: ,information28 hr_canvas_properties.information28%TYPE

Line 562: ,information25 hr_canvas_properties.information25%TYPE

558: ,information21 hr_canvas_properties.information21%TYPE
559: ,information22 hr_canvas_properties.information22%TYPE
560: ,information23 hr_canvas_properties.information23%TYPE
561: ,information24 hr_canvas_properties.information24%TYPE
562: ,information25 hr_canvas_properties.information25%TYPE
563: ,information26 hr_canvas_properties.information26%TYPE
564: ,information27 hr_canvas_properties.information27%TYPE
565: ,information28 hr_canvas_properties.information28%TYPE
566: ,information29 hr_canvas_properties.information29%TYPE

Line 563: ,information26 hr_canvas_properties.information26%TYPE

559: ,information22 hr_canvas_properties.information22%TYPE
560: ,information23 hr_canvas_properties.information23%TYPE
561: ,information24 hr_canvas_properties.information24%TYPE
562: ,information25 hr_canvas_properties.information25%TYPE
563: ,information26 hr_canvas_properties.information26%TYPE
564: ,information27 hr_canvas_properties.information27%TYPE
565: ,information28 hr_canvas_properties.information28%TYPE
566: ,information29 hr_canvas_properties.information29%TYPE
567: ,information30 hr_canvas_properties.information30%TYPE);

Line 564: ,information27 hr_canvas_properties.information27%TYPE

560: ,information23 hr_canvas_properties.information23%TYPE
561: ,information24 hr_canvas_properties.information24%TYPE
562: ,information25 hr_canvas_properties.information25%TYPE
563: ,information26 hr_canvas_properties.information26%TYPE
564: ,information27 hr_canvas_properties.information27%TYPE
565: ,information28 hr_canvas_properties.information28%TYPE
566: ,information29 hr_canvas_properties.information29%TYPE
567: ,information30 hr_canvas_properties.information30%TYPE);
568:

Line 565: ,information28 hr_canvas_properties.information28%TYPE

561: ,information24 hr_canvas_properties.information24%TYPE
562: ,information25 hr_canvas_properties.information25%TYPE
563: ,information26 hr_canvas_properties.information26%TYPE
564: ,information27 hr_canvas_properties.information27%TYPE
565: ,information28 hr_canvas_properties.information28%TYPE
566: ,information29 hr_canvas_properties.information29%TYPE
567: ,information30 hr_canvas_properties.information30%TYPE);
568:
569: l_rec l_rec_type;

Line 566: ,information29 hr_canvas_properties.information29%TYPE

562: ,information25 hr_canvas_properties.information25%TYPE
563: ,information26 hr_canvas_properties.information26%TYPE
564: ,information27 hr_canvas_properties.information27%TYPE
565: ,information28 hr_canvas_properties.information28%TYPE
566: ,information29 hr_canvas_properties.information29%TYPE
567: ,information30 hr_canvas_properties.information30%TYPE);
568:
569: l_rec l_rec_type;
570:

Line 567: ,information30 hr_canvas_properties.information30%TYPE);

563: ,information26 hr_canvas_properties.information26%TYPE
564: ,information27 hr_canvas_properties.information27%TYPE
565: ,information28 hr_canvas_properties.information28%TYPE
566: ,information29 hr_canvas_properties.information29%TYPE
567: ,information30 hr_canvas_properties.information30%TYPE);
568:
569: l_rec l_rec_type;
570:
571: CURSOR cur_check

Line 618: FROM hr_canvas_properties cnp

614: ,DECODE(p_information27,hr_api.g_varchar2,cnp.information27,p_information27)
615: ,DECODE(p_information28,hr_api.g_varchar2,cnp.information28,p_information28)
616: ,DECODE(p_information29,hr_api.g_varchar2,cnp.information29,p_information29)
617: ,DECODE(p_information30,hr_api.g_varchar2,cnp.information30,p_information30)
618: FROM hr_canvas_properties cnp
619: , hr_form_canvases_b hfc
620: WHERE cnp.form_canvas_id (+) = hfc.form_canvas_id
621: AND hfc.form_canvas_id = p_form_canvas_id;
622:

Line 792: (height hr_canvas_properties.height%TYPE

788: --
789: -- added a outer join so that the correct values are returned
790: -- if there are no entries in the properties table
791: Type l_rec_type Is Record
792: (height hr_canvas_properties.height%TYPE
793: ,visible hr_canvas_properties.visible%TYPE
794: ,width hr_canvas_properties.width%TYPE
795: ,x_position hr_canvas_properties.x_position%TYPE
796: ,y_position hr_canvas_properties.y_position%TYPE

Line 793: ,visible hr_canvas_properties.visible%TYPE

789: -- added a outer join so that the correct values are returned
790: -- if there are no entries in the properties table
791: Type l_rec_type Is Record
792: (height hr_canvas_properties.height%TYPE
793: ,visible hr_canvas_properties.visible%TYPE
794: ,width hr_canvas_properties.width%TYPE
795: ,x_position hr_canvas_properties.x_position%TYPE
796: ,y_position hr_canvas_properties.y_position%TYPE
797: ,information_category hr_canvas_properties.information_category%TYPE

Line 794: ,width hr_canvas_properties.width%TYPE

790: -- if there are no entries in the properties table
791: Type l_rec_type Is Record
792: (height hr_canvas_properties.height%TYPE
793: ,visible hr_canvas_properties.visible%TYPE
794: ,width hr_canvas_properties.width%TYPE
795: ,x_position hr_canvas_properties.x_position%TYPE
796: ,y_position hr_canvas_properties.y_position%TYPE
797: ,information_category hr_canvas_properties.information_category%TYPE
798: ,information1 hr_canvas_properties.information1%TYPE

Line 795: ,x_position hr_canvas_properties.x_position%TYPE

791: Type l_rec_type Is Record
792: (height hr_canvas_properties.height%TYPE
793: ,visible hr_canvas_properties.visible%TYPE
794: ,width hr_canvas_properties.width%TYPE
795: ,x_position hr_canvas_properties.x_position%TYPE
796: ,y_position hr_canvas_properties.y_position%TYPE
797: ,information_category hr_canvas_properties.information_category%TYPE
798: ,information1 hr_canvas_properties.information1%TYPE
799: ,information2 hr_canvas_properties.information2%TYPE

Line 796: ,y_position hr_canvas_properties.y_position%TYPE

792: (height hr_canvas_properties.height%TYPE
793: ,visible hr_canvas_properties.visible%TYPE
794: ,width hr_canvas_properties.width%TYPE
795: ,x_position hr_canvas_properties.x_position%TYPE
796: ,y_position hr_canvas_properties.y_position%TYPE
797: ,information_category hr_canvas_properties.information_category%TYPE
798: ,information1 hr_canvas_properties.information1%TYPE
799: ,information2 hr_canvas_properties.information2%TYPE
800: ,information3 hr_canvas_properties.information3%TYPE

Line 797: ,information_category hr_canvas_properties.information_category%TYPE

793: ,visible hr_canvas_properties.visible%TYPE
794: ,width hr_canvas_properties.width%TYPE
795: ,x_position hr_canvas_properties.x_position%TYPE
796: ,y_position hr_canvas_properties.y_position%TYPE
797: ,information_category hr_canvas_properties.information_category%TYPE
798: ,information1 hr_canvas_properties.information1%TYPE
799: ,information2 hr_canvas_properties.information2%TYPE
800: ,information3 hr_canvas_properties.information3%TYPE
801: ,information4 hr_canvas_properties.information4%TYPE

Line 798: ,information1 hr_canvas_properties.information1%TYPE

794: ,width hr_canvas_properties.width%TYPE
795: ,x_position hr_canvas_properties.x_position%TYPE
796: ,y_position hr_canvas_properties.y_position%TYPE
797: ,information_category hr_canvas_properties.information_category%TYPE
798: ,information1 hr_canvas_properties.information1%TYPE
799: ,information2 hr_canvas_properties.information2%TYPE
800: ,information3 hr_canvas_properties.information3%TYPE
801: ,information4 hr_canvas_properties.information4%TYPE
802: ,information5 hr_canvas_properties.information5%TYPE

Line 799: ,information2 hr_canvas_properties.information2%TYPE

795: ,x_position hr_canvas_properties.x_position%TYPE
796: ,y_position hr_canvas_properties.y_position%TYPE
797: ,information_category hr_canvas_properties.information_category%TYPE
798: ,information1 hr_canvas_properties.information1%TYPE
799: ,information2 hr_canvas_properties.information2%TYPE
800: ,information3 hr_canvas_properties.information3%TYPE
801: ,information4 hr_canvas_properties.information4%TYPE
802: ,information5 hr_canvas_properties.information5%TYPE
803: ,information6 hr_canvas_properties.information6%TYPE

Line 800: ,information3 hr_canvas_properties.information3%TYPE

796: ,y_position hr_canvas_properties.y_position%TYPE
797: ,information_category hr_canvas_properties.information_category%TYPE
798: ,information1 hr_canvas_properties.information1%TYPE
799: ,information2 hr_canvas_properties.information2%TYPE
800: ,information3 hr_canvas_properties.information3%TYPE
801: ,information4 hr_canvas_properties.information4%TYPE
802: ,information5 hr_canvas_properties.information5%TYPE
803: ,information6 hr_canvas_properties.information6%TYPE
804: ,information7 hr_canvas_properties.information7%TYPE

Line 801: ,information4 hr_canvas_properties.information4%TYPE

797: ,information_category hr_canvas_properties.information_category%TYPE
798: ,information1 hr_canvas_properties.information1%TYPE
799: ,information2 hr_canvas_properties.information2%TYPE
800: ,information3 hr_canvas_properties.information3%TYPE
801: ,information4 hr_canvas_properties.information4%TYPE
802: ,information5 hr_canvas_properties.information5%TYPE
803: ,information6 hr_canvas_properties.information6%TYPE
804: ,information7 hr_canvas_properties.information7%TYPE
805: ,information8 hr_canvas_properties.information8%TYPE

Line 802: ,information5 hr_canvas_properties.information5%TYPE

798: ,information1 hr_canvas_properties.information1%TYPE
799: ,information2 hr_canvas_properties.information2%TYPE
800: ,information3 hr_canvas_properties.information3%TYPE
801: ,information4 hr_canvas_properties.information4%TYPE
802: ,information5 hr_canvas_properties.information5%TYPE
803: ,information6 hr_canvas_properties.information6%TYPE
804: ,information7 hr_canvas_properties.information7%TYPE
805: ,information8 hr_canvas_properties.information8%TYPE
806: ,information9 hr_canvas_properties.information9%TYPE

Line 803: ,information6 hr_canvas_properties.information6%TYPE

799: ,information2 hr_canvas_properties.information2%TYPE
800: ,information3 hr_canvas_properties.information3%TYPE
801: ,information4 hr_canvas_properties.information4%TYPE
802: ,information5 hr_canvas_properties.information5%TYPE
803: ,information6 hr_canvas_properties.information6%TYPE
804: ,information7 hr_canvas_properties.information7%TYPE
805: ,information8 hr_canvas_properties.information8%TYPE
806: ,information9 hr_canvas_properties.information9%TYPE
807: ,information10 hr_canvas_properties.information10%TYPE

Line 804: ,information7 hr_canvas_properties.information7%TYPE

800: ,information3 hr_canvas_properties.information3%TYPE
801: ,information4 hr_canvas_properties.information4%TYPE
802: ,information5 hr_canvas_properties.information5%TYPE
803: ,information6 hr_canvas_properties.information6%TYPE
804: ,information7 hr_canvas_properties.information7%TYPE
805: ,information8 hr_canvas_properties.information8%TYPE
806: ,information9 hr_canvas_properties.information9%TYPE
807: ,information10 hr_canvas_properties.information10%TYPE
808: ,information11 hr_canvas_properties.information11%TYPE

Line 805: ,information8 hr_canvas_properties.information8%TYPE

801: ,information4 hr_canvas_properties.information4%TYPE
802: ,information5 hr_canvas_properties.information5%TYPE
803: ,information6 hr_canvas_properties.information6%TYPE
804: ,information7 hr_canvas_properties.information7%TYPE
805: ,information8 hr_canvas_properties.information8%TYPE
806: ,information9 hr_canvas_properties.information9%TYPE
807: ,information10 hr_canvas_properties.information10%TYPE
808: ,information11 hr_canvas_properties.information11%TYPE
809: ,information12 hr_canvas_properties.information12%TYPE

Line 806: ,information9 hr_canvas_properties.information9%TYPE

802: ,information5 hr_canvas_properties.information5%TYPE
803: ,information6 hr_canvas_properties.information6%TYPE
804: ,information7 hr_canvas_properties.information7%TYPE
805: ,information8 hr_canvas_properties.information8%TYPE
806: ,information9 hr_canvas_properties.information9%TYPE
807: ,information10 hr_canvas_properties.information10%TYPE
808: ,information11 hr_canvas_properties.information11%TYPE
809: ,information12 hr_canvas_properties.information12%TYPE
810: ,information13 hr_canvas_properties.information13%TYPE

Line 807: ,information10 hr_canvas_properties.information10%TYPE

803: ,information6 hr_canvas_properties.information6%TYPE
804: ,information7 hr_canvas_properties.information7%TYPE
805: ,information8 hr_canvas_properties.information8%TYPE
806: ,information9 hr_canvas_properties.information9%TYPE
807: ,information10 hr_canvas_properties.information10%TYPE
808: ,information11 hr_canvas_properties.information11%TYPE
809: ,information12 hr_canvas_properties.information12%TYPE
810: ,information13 hr_canvas_properties.information13%TYPE
811: ,information14 hr_canvas_properties.information14%TYPE

Line 808: ,information11 hr_canvas_properties.information11%TYPE

804: ,information7 hr_canvas_properties.information7%TYPE
805: ,information8 hr_canvas_properties.information8%TYPE
806: ,information9 hr_canvas_properties.information9%TYPE
807: ,information10 hr_canvas_properties.information10%TYPE
808: ,information11 hr_canvas_properties.information11%TYPE
809: ,information12 hr_canvas_properties.information12%TYPE
810: ,information13 hr_canvas_properties.information13%TYPE
811: ,information14 hr_canvas_properties.information14%TYPE
812: ,information15 hr_canvas_properties.information15%TYPE

Line 809: ,information12 hr_canvas_properties.information12%TYPE

805: ,information8 hr_canvas_properties.information8%TYPE
806: ,information9 hr_canvas_properties.information9%TYPE
807: ,information10 hr_canvas_properties.information10%TYPE
808: ,information11 hr_canvas_properties.information11%TYPE
809: ,information12 hr_canvas_properties.information12%TYPE
810: ,information13 hr_canvas_properties.information13%TYPE
811: ,information14 hr_canvas_properties.information14%TYPE
812: ,information15 hr_canvas_properties.information15%TYPE
813: ,information16 hr_canvas_properties.information16%TYPE

Line 810: ,information13 hr_canvas_properties.information13%TYPE

806: ,information9 hr_canvas_properties.information9%TYPE
807: ,information10 hr_canvas_properties.information10%TYPE
808: ,information11 hr_canvas_properties.information11%TYPE
809: ,information12 hr_canvas_properties.information12%TYPE
810: ,information13 hr_canvas_properties.information13%TYPE
811: ,information14 hr_canvas_properties.information14%TYPE
812: ,information15 hr_canvas_properties.information15%TYPE
813: ,information16 hr_canvas_properties.information16%TYPE
814: ,information17 hr_canvas_properties.information17%TYPE

Line 811: ,information14 hr_canvas_properties.information14%TYPE

807: ,information10 hr_canvas_properties.information10%TYPE
808: ,information11 hr_canvas_properties.information11%TYPE
809: ,information12 hr_canvas_properties.information12%TYPE
810: ,information13 hr_canvas_properties.information13%TYPE
811: ,information14 hr_canvas_properties.information14%TYPE
812: ,information15 hr_canvas_properties.information15%TYPE
813: ,information16 hr_canvas_properties.information16%TYPE
814: ,information17 hr_canvas_properties.information17%TYPE
815: ,information18 hr_canvas_properties.information18%TYPE

Line 812: ,information15 hr_canvas_properties.information15%TYPE

808: ,information11 hr_canvas_properties.information11%TYPE
809: ,information12 hr_canvas_properties.information12%TYPE
810: ,information13 hr_canvas_properties.information13%TYPE
811: ,information14 hr_canvas_properties.information14%TYPE
812: ,information15 hr_canvas_properties.information15%TYPE
813: ,information16 hr_canvas_properties.information16%TYPE
814: ,information17 hr_canvas_properties.information17%TYPE
815: ,information18 hr_canvas_properties.information18%TYPE
816: ,information19 hr_canvas_properties.information19%TYPE

Line 813: ,information16 hr_canvas_properties.information16%TYPE

809: ,information12 hr_canvas_properties.information12%TYPE
810: ,information13 hr_canvas_properties.information13%TYPE
811: ,information14 hr_canvas_properties.information14%TYPE
812: ,information15 hr_canvas_properties.information15%TYPE
813: ,information16 hr_canvas_properties.information16%TYPE
814: ,information17 hr_canvas_properties.information17%TYPE
815: ,information18 hr_canvas_properties.information18%TYPE
816: ,information19 hr_canvas_properties.information19%TYPE
817: ,information20 hr_canvas_properties.information20%TYPE

Line 814: ,information17 hr_canvas_properties.information17%TYPE

810: ,information13 hr_canvas_properties.information13%TYPE
811: ,information14 hr_canvas_properties.information14%TYPE
812: ,information15 hr_canvas_properties.information15%TYPE
813: ,information16 hr_canvas_properties.information16%TYPE
814: ,information17 hr_canvas_properties.information17%TYPE
815: ,information18 hr_canvas_properties.information18%TYPE
816: ,information19 hr_canvas_properties.information19%TYPE
817: ,information20 hr_canvas_properties.information20%TYPE
818: ,information21 hr_canvas_properties.information21%TYPE

Line 815: ,information18 hr_canvas_properties.information18%TYPE

811: ,information14 hr_canvas_properties.information14%TYPE
812: ,information15 hr_canvas_properties.information15%TYPE
813: ,information16 hr_canvas_properties.information16%TYPE
814: ,information17 hr_canvas_properties.information17%TYPE
815: ,information18 hr_canvas_properties.information18%TYPE
816: ,information19 hr_canvas_properties.information19%TYPE
817: ,information20 hr_canvas_properties.information20%TYPE
818: ,information21 hr_canvas_properties.information21%TYPE
819: ,information22 hr_canvas_properties.information22%TYPE

Line 816: ,information19 hr_canvas_properties.information19%TYPE

812: ,information15 hr_canvas_properties.information15%TYPE
813: ,information16 hr_canvas_properties.information16%TYPE
814: ,information17 hr_canvas_properties.information17%TYPE
815: ,information18 hr_canvas_properties.information18%TYPE
816: ,information19 hr_canvas_properties.information19%TYPE
817: ,information20 hr_canvas_properties.information20%TYPE
818: ,information21 hr_canvas_properties.information21%TYPE
819: ,information22 hr_canvas_properties.information22%TYPE
820: ,information23 hr_canvas_properties.information23%TYPE

Line 817: ,information20 hr_canvas_properties.information20%TYPE

813: ,information16 hr_canvas_properties.information16%TYPE
814: ,information17 hr_canvas_properties.information17%TYPE
815: ,information18 hr_canvas_properties.information18%TYPE
816: ,information19 hr_canvas_properties.information19%TYPE
817: ,information20 hr_canvas_properties.information20%TYPE
818: ,information21 hr_canvas_properties.information21%TYPE
819: ,information22 hr_canvas_properties.information22%TYPE
820: ,information23 hr_canvas_properties.information23%TYPE
821: ,information24 hr_canvas_properties.information24%TYPE

Line 818: ,information21 hr_canvas_properties.information21%TYPE

814: ,information17 hr_canvas_properties.information17%TYPE
815: ,information18 hr_canvas_properties.information18%TYPE
816: ,information19 hr_canvas_properties.information19%TYPE
817: ,information20 hr_canvas_properties.information20%TYPE
818: ,information21 hr_canvas_properties.information21%TYPE
819: ,information22 hr_canvas_properties.information22%TYPE
820: ,information23 hr_canvas_properties.information23%TYPE
821: ,information24 hr_canvas_properties.information24%TYPE
822: ,information25 hr_canvas_properties.information25%TYPE

Line 819: ,information22 hr_canvas_properties.information22%TYPE

815: ,information18 hr_canvas_properties.information18%TYPE
816: ,information19 hr_canvas_properties.information19%TYPE
817: ,information20 hr_canvas_properties.information20%TYPE
818: ,information21 hr_canvas_properties.information21%TYPE
819: ,information22 hr_canvas_properties.information22%TYPE
820: ,information23 hr_canvas_properties.information23%TYPE
821: ,information24 hr_canvas_properties.information24%TYPE
822: ,information25 hr_canvas_properties.information25%TYPE
823: ,information26 hr_canvas_properties.information26%TYPE

Line 820: ,information23 hr_canvas_properties.information23%TYPE

816: ,information19 hr_canvas_properties.information19%TYPE
817: ,information20 hr_canvas_properties.information20%TYPE
818: ,information21 hr_canvas_properties.information21%TYPE
819: ,information22 hr_canvas_properties.information22%TYPE
820: ,information23 hr_canvas_properties.information23%TYPE
821: ,information24 hr_canvas_properties.information24%TYPE
822: ,information25 hr_canvas_properties.information25%TYPE
823: ,information26 hr_canvas_properties.information26%TYPE
824: ,information27 hr_canvas_properties.information27%TYPE

Line 821: ,information24 hr_canvas_properties.information24%TYPE

817: ,information20 hr_canvas_properties.information20%TYPE
818: ,information21 hr_canvas_properties.information21%TYPE
819: ,information22 hr_canvas_properties.information22%TYPE
820: ,information23 hr_canvas_properties.information23%TYPE
821: ,information24 hr_canvas_properties.information24%TYPE
822: ,information25 hr_canvas_properties.information25%TYPE
823: ,information26 hr_canvas_properties.information26%TYPE
824: ,information27 hr_canvas_properties.information27%TYPE
825: ,information28 hr_canvas_properties.information28%TYPE

Line 822: ,information25 hr_canvas_properties.information25%TYPE

818: ,information21 hr_canvas_properties.information21%TYPE
819: ,information22 hr_canvas_properties.information22%TYPE
820: ,information23 hr_canvas_properties.information23%TYPE
821: ,information24 hr_canvas_properties.information24%TYPE
822: ,information25 hr_canvas_properties.information25%TYPE
823: ,information26 hr_canvas_properties.information26%TYPE
824: ,information27 hr_canvas_properties.information27%TYPE
825: ,information28 hr_canvas_properties.information28%TYPE
826: ,information29 hr_canvas_properties.information29%TYPE

Line 823: ,information26 hr_canvas_properties.information26%TYPE

819: ,information22 hr_canvas_properties.information22%TYPE
820: ,information23 hr_canvas_properties.information23%TYPE
821: ,information24 hr_canvas_properties.information24%TYPE
822: ,information25 hr_canvas_properties.information25%TYPE
823: ,information26 hr_canvas_properties.information26%TYPE
824: ,information27 hr_canvas_properties.information27%TYPE
825: ,information28 hr_canvas_properties.information28%TYPE
826: ,information29 hr_canvas_properties.information29%TYPE
827: ,information30 hr_canvas_properties.information30%TYPE);

Line 824: ,information27 hr_canvas_properties.information27%TYPE

820: ,information23 hr_canvas_properties.information23%TYPE
821: ,information24 hr_canvas_properties.information24%TYPE
822: ,information25 hr_canvas_properties.information25%TYPE
823: ,information26 hr_canvas_properties.information26%TYPE
824: ,information27 hr_canvas_properties.information27%TYPE
825: ,information28 hr_canvas_properties.information28%TYPE
826: ,information29 hr_canvas_properties.information29%TYPE
827: ,information30 hr_canvas_properties.information30%TYPE);
828:

Line 825: ,information28 hr_canvas_properties.information28%TYPE

821: ,information24 hr_canvas_properties.information24%TYPE
822: ,information25 hr_canvas_properties.information25%TYPE
823: ,information26 hr_canvas_properties.information26%TYPE
824: ,information27 hr_canvas_properties.information27%TYPE
825: ,information28 hr_canvas_properties.information28%TYPE
826: ,information29 hr_canvas_properties.information29%TYPE
827: ,information30 hr_canvas_properties.information30%TYPE);
828:
829: l_rec l_rec_type;

Line 826: ,information29 hr_canvas_properties.information29%TYPE

822: ,information25 hr_canvas_properties.information25%TYPE
823: ,information26 hr_canvas_properties.information26%TYPE
824: ,information27 hr_canvas_properties.information27%TYPE
825: ,information28 hr_canvas_properties.information28%TYPE
826: ,information29 hr_canvas_properties.information29%TYPE
827: ,information30 hr_canvas_properties.information30%TYPE);
828:
829: l_rec l_rec_type;
830:

Line 827: ,information30 hr_canvas_properties.information30%TYPE);

823: ,information26 hr_canvas_properties.information26%TYPE
824: ,information27 hr_canvas_properties.information27%TYPE
825: ,information28 hr_canvas_properties.information28%TYPE
826: ,information29 hr_canvas_properties.information29%TYPE
827: ,information30 hr_canvas_properties.information30%TYPE);
828:
829: l_rec l_rec_type;
830:
831: CURSOR cur_check

Line 879: FROM hr_canvas_properties cnp

875: ,DECODE(p_information27,hr_api.g_varchar2,cnp.information27,p_information27)
876: ,DECODE(p_information28,hr_api.g_varchar2,cnp.information28,p_information28)
877: ,DECODE(p_information29,hr_api.g_varchar2,cnp.information29,p_information29)
878: ,DECODE(p_information30,hr_api.g_varchar2,cnp.information30,p_information30)
879: FROM hr_canvas_properties cnp
880: , hr_template_canvases_b htc
881: WHERE cnp.template_canvas_id (+) = htc.template_canvas_id
882: and htc.template_canvas_id = p_template_canvas_id_from;
883:

Line 999: end hr_canvas_properties_bsi;

995: hr_utility.set_location(' Leaving:'||l_proc, 90);
996: raise;
997: end copy_canvas_property;
998: --
999: end hr_canvas_properties_bsi;