APPS.HR_FORM_PROPERTIES_BSI dependencies on HR_FORM_PROPERTIES

Line 1: Package Body hr_form_properties_bsi as

1: Package Body hr_form_properties_bsi as
2: /* $Header: hrfmpbsi.pkb 115.3 2003/09/24 02:01:09 bsubrama noship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: hrfmpbsi.pkb 115.3 2003/09/24 02:01:09 bsubrama noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' hr_form_properties_bsi.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |--------------------------< create_form_property >--------------------------|
10: -- ----------------------------------------------------------------------------

Line 201: FROM hr_form_properties

197:
198: CURSOR cur_frm_prop_1
199: IS
200: SELECT form_property_id
201: FROM hr_form_properties
202: WHERE application_id = p_application_id
203: AND form_id = p_form_id;
204:
205: CURSOR cur_frm_prop_2

Line 208: FROM hr_form_properties

204:
205: CURSOR cur_frm_prop_2
206: IS
207: SELECT form_property_id
208: FROM hr_form_properties
209: WHERE form_template_id = p_form_template_id;
210:
211: l_form_property_id number;
212: l_proc varchar2(72) := g_package||'update_form_property';

Line 364: FROM hr_form_properties

360:
361: CURSOR cur_frm_prop_1
362: IS
363: SELECT form_property_id
364: FROM hr_form_properties
365: WHERE application_id = p_application_id
366: AND form_id = p_form_id;
367:
368: CURSOR cur_frm_prop_2

Line 371: FROM hr_form_properties

367:
368: CURSOR cur_frm_prop_2
369: IS
370: SELECT form_property_id
371: FROM hr_form_properties
372: WHERE form_template_id = p_form_template_id;
373:
374: l_form_property_id number;
375: l_proc varchar2(72) := g_package||'delete_form_property';

Line 525: (help_target hr_form_properties.help_target%TYPE

521:
522: -- added a outer join so that the correct values are returned
523: -- if there are no entries in the properties table
524: Type l_rec_type Is Record
525: (help_target hr_form_properties.help_target%TYPE
526: ,information_category hr_form_properties.information_category%TYPE
527: ,information1 hr_form_properties.information1%TYPE
528: ,information2 hr_form_properties.information2%TYPE
529: ,information3 hr_form_properties.information3%TYPE

Line 526: ,information_category hr_form_properties.information_category%TYPE

522: -- added a outer join so that the correct values are returned
523: -- if there are no entries in the properties table
524: Type l_rec_type Is Record
525: (help_target hr_form_properties.help_target%TYPE
526: ,information_category hr_form_properties.information_category%TYPE
527: ,information1 hr_form_properties.information1%TYPE
528: ,information2 hr_form_properties.information2%TYPE
529: ,information3 hr_form_properties.information3%TYPE
530: ,information4 hr_form_properties.information4%TYPE

Line 527: ,information1 hr_form_properties.information1%TYPE

523: -- if there are no entries in the properties table
524: Type l_rec_type Is Record
525: (help_target hr_form_properties.help_target%TYPE
526: ,information_category hr_form_properties.information_category%TYPE
527: ,information1 hr_form_properties.information1%TYPE
528: ,information2 hr_form_properties.information2%TYPE
529: ,information3 hr_form_properties.information3%TYPE
530: ,information4 hr_form_properties.information4%TYPE
531: ,information5 hr_form_properties.information5%TYPE

Line 528: ,information2 hr_form_properties.information2%TYPE

524: Type l_rec_type Is Record
525: (help_target hr_form_properties.help_target%TYPE
526: ,information_category hr_form_properties.information_category%TYPE
527: ,information1 hr_form_properties.information1%TYPE
528: ,information2 hr_form_properties.information2%TYPE
529: ,information3 hr_form_properties.information3%TYPE
530: ,information4 hr_form_properties.information4%TYPE
531: ,information5 hr_form_properties.information5%TYPE
532: ,information6 hr_form_properties.information6%TYPE

Line 529: ,information3 hr_form_properties.information3%TYPE

525: (help_target hr_form_properties.help_target%TYPE
526: ,information_category hr_form_properties.information_category%TYPE
527: ,information1 hr_form_properties.information1%TYPE
528: ,information2 hr_form_properties.information2%TYPE
529: ,information3 hr_form_properties.information3%TYPE
530: ,information4 hr_form_properties.information4%TYPE
531: ,information5 hr_form_properties.information5%TYPE
532: ,information6 hr_form_properties.information6%TYPE
533: ,information7 hr_form_properties.information7%TYPE

Line 530: ,information4 hr_form_properties.information4%TYPE

526: ,information_category hr_form_properties.information_category%TYPE
527: ,information1 hr_form_properties.information1%TYPE
528: ,information2 hr_form_properties.information2%TYPE
529: ,information3 hr_form_properties.information3%TYPE
530: ,information4 hr_form_properties.information4%TYPE
531: ,information5 hr_form_properties.information5%TYPE
532: ,information6 hr_form_properties.information6%TYPE
533: ,information7 hr_form_properties.information7%TYPE
534: ,information8 hr_form_properties.information8%TYPE

Line 531: ,information5 hr_form_properties.information5%TYPE

527: ,information1 hr_form_properties.information1%TYPE
528: ,information2 hr_form_properties.information2%TYPE
529: ,information3 hr_form_properties.information3%TYPE
530: ,information4 hr_form_properties.information4%TYPE
531: ,information5 hr_form_properties.information5%TYPE
532: ,information6 hr_form_properties.information6%TYPE
533: ,information7 hr_form_properties.information7%TYPE
534: ,information8 hr_form_properties.information8%TYPE
535: ,information9 hr_form_properties.information9%TYPE

Line 532: ,information6 hr_form_properties.information6%TYPE

528: ,information2 hr_form_properties.information2%TYPE
529: ,information3 hr_form_properties.information3%TYPE
530: ,information4 hr_form_properties.information4%TYPE
531: ,information5 hr_form_properties.information5%TYPE
532: ,information6 hr_form_properties.information6%TYPE
533: ,information7 hr_form_properties.information7%TYPE
534: ,information8 hr_form_properties.information8%TYPE
535: ,information9 hr_form_properties.information9%TYPE
536: ,information10 hr_form_properties.information10%TYPE

Line 533: ,information7 hr_form_properties.information7%TYPE

529: ,information3 hr_form_properties.information3%TYPE
530: ,information4 hr_form_properties.information4%TYPE
531: ,information5 hr_form_properties.information5%TYPE
532: ,information6 hr_form_properties.information6%TYPE
533: ,information7 hr_form_properties.information7%TYPE
534: ,information8 hr_form_properties.information8%TYPE
535: ,information9 hr_form_properties.information9%TYPE
536: ,information10 hr_form_properties.information10%TYPE
537: ,information11 hr_form_properties.information11%TYPE

Line 534: ,information8 hr_form_properties.information8%TYPE

530: ,information4 hr_form_properties.information4%TYPE
531: ,information5 hr_form_properties.information5%TYPE
532: ,information6 hr_form_properties.information6%TYPE
533: ,information7 hr_form_properties.information7%TYPE
534: ,information8 hr_form_properties.information8%TYPE
535: ,information9 hr_form_properties.information9%TYPE
536: ,information10 hr_form_properties.information10%TYPE
537: ,information11 hr_form_properties.information11%TYPE
538: ,information12 hr_form_properties.information12%TYPE

Line 535: ,information9 hr_form_properties.information9%TYPE

531: ,information5 hr_form_properties.information5%TYPE
532: ,information6 hr_form_properties.information6%TYPE
533: ,information7 hr_form_properties.information7%TYPE
534: ,information8 hr_form_properties.information8%TYPE
535: ,information9 hr_form_properties.information9%TYPE
536: ,information10 hr_form_properties.information10%TYPE
537: ,information11 hr_form_properties.information11%TYPE
538: ,information12 hr_form_properties.information12%TYPE
539: ,information13 hr_form_properties.information13%TYPE

Line 536: ,information10 hr_form_properties.information10%TYPE

532: ,information6 hr_form_properties.information6%TYPE
533: ,information7 hr_form_properties.information7%TYPE
534: ,information8 hr_form_properties.information8%TYPE
535: ,information9 hr_form_properties.information9%TYPE
536: ,information10 hr_form_properties.information10%TYPE
537: ,information11 hr_form_properties.information11%TYPE
538: ,information12 hr_form_properties.information12%TYPE
539: ,information13 hr_form_properties.information13%TYPE
540: ,information14 hr_form_properties.information14%TYPE

Line 537: ,information11 hr_form_properties.information11%TYPE

533: ,information7 hr_form_properties.information7%TYPE
534: ,information8 hr_form_properties.information8%TYPE
535: ,information9 hr_form_properties.information9%TYPE
536: ,information10 hr_form_properties.information10%TYPE
537: ,information11 hr_form_properties.information11%TYPE
538: ,information12 hr_form_properties.information12%TYPE
539: ,information13 hr_form_properties.information13%TYPE
540: ,information14 hr_form_properties.information14%TYPE
541: ,information15 hr_form_properties.information15%TYPE

Line 538: ,information12 hr_form_properties.information12%TYPE

534: ,information8 hr_form_properties.information8%TYPE
535: ,information9 hr_form_properties.information9%TYPE
536: ,information10 hr_form_properties.information10%TYPE
537: ,information11 hr_form_properties.information11%TYPE
538: ,information12 hr_form_properties.information12%TYPE
539: ,information13 hr_form_properties.information13%TYPE
540: ,information14 hr_form_properties.information14%TYPE
541: ,information15 hr_form_properties.information15%TYPE
542: ,information16 hr_form_properties.information16%TYPE

Line 539: ,information13 hr_form_properties.information13%TYPE

535: ,information9 hr_form_properties.information9%TYPE
536: ,information10 hr_form_properties.information10%TYPE
537: ,information11 hr_form_properties.information11%TYPE
538: ,information12 hr_form_properties.information12%TYPE
539: ,information13 hr_form_properties.information13%TYPE
540: ,information14 hr_form_properties.information14%TYPE
541: ,information15 hr_form_properties.information15%TYPE
542: ,information16 hr_form_properties.information16%TYPE
543: ,information17 hr_form_properties.information17%TYPE

Line 540: ,information14 hr_form_properties.information14%TYPE

536: ,information10 hr_form_properties.information10%TYPE
537: ,information11 hr_form_properties.information11%TYPE
538: ,information12 hr_form_properties.information12%TYPE
539: ,information13 hr_form_properties.information13%TYPE
540: ,information14 hr_form_properties.information14%TYPE
541: ,information15 hr_form_properties.information15%TYPE
542: ,information16 hr_form_properties.information16%TYPE
543: ,information17 hr_form_properties.information17%TYPE
544: ,information18 hr_form_properties.information18%TYPE

Line 541: ,information15 hr_form_properties.information15%TYPE

537: ,information11 hr_form_properties.information11%TYPE
538: ,information12 hr_form_properties.information12%TYPE
539: ,information13 hr_form_properties.information13%TYPE
540: ,information14 hr_form_properties.information14%TYPE
541: ,information15 hr_form_properties.information15%TYPE
542: ,information16 hr_form_properties.information16%TYPE
543: ,information17 hr_form_properties.information17%TYPE
544: ,information18 hr_form_properties.information18%TYPE
545: ,information19 hr_form_properties.information19%TYPE

Line 542: ,information16 hr_form_properties.information16%TYPE

538: ,information12 hr_form_properties.information12%TYPE
539: ,information13 hr_form_properties.information13%TYPE
540: ,information14 hr_form_properties.information14%TYPE
541: ,information15 hr_form_properties.information15%TYPE
542: ,information16 hr_form_properties.information16%TYPE
543: ,information17 hr_form_properties.information17%TYPE
544: ,information18 hr_form_properties.information18%TYPE
545: ,information19 hr_form_properties.information19%TYPE
546: ,information20 hr_form_properties.information20%TYPE

Line 543: ,information17 hr_form_properties.information17%TYPE

539: ,information13 hr_form_properties.information13%TYPE
540: ,information14 hr_form_properties.information14%TYPE
541: ,information15 hr_form_properties.information15%TYPE
542: ,information16 hr_form_properties.information16%TYPE
543: ,information17 hr_form_properties.information17%TYPE
544: ,information18 hr_form_properties.information18%TYPE
545: ,information19 hr_form_properties.information19%TYPE
546: ,information20 hr_form_properties.information20%TYPE
547: ,information21 hr_form_properties.information21%TYPE

Line 544: ,information18 hr_form_properties.information18%TYPE

540: ,information14 hr_form_properties.information14%TYPE
541: ,information15 hr_form_properties.information15%TYPE
542: ,information16 hr_form_properties.information16%TYPE
543: ,information17 hr_form_properties.information17%TYPE
544: ,information18 hr_form_properties.information18%TYPE
545: ,information19 hr_form_properties.information19%TYPE
546: ,information20 hr_form_properties.information20%TYPE
547: ,information21 hr_form_properties.information21%TYPE
548: ,information22 hr_form_properties.information22%TYPE

Line 545: ,information19 hr_form_properties.information19%TYPE

541: ,information15 hr_form_properties.information15%TYPE
542: ,information16 hr_form_properties.information16%TYPE
543: ,information17 hr_form_properties.information17%TYPE
544: ,information18 hr_form_properties.information18%TYPE
545: ,information19 hr_form_properties.information19%TYPE
546: ,information20 hr_form_properties.information20%TYPE
547: ,information21 hr_form_properties.information21%TYPE
548: ,information22 hr_form_properties.information22%TYPE
549: ,information23 hr_form_properties.information23%TYPE

Line 546: ,information20 hr_form_properties.information20%TYPE

542: ,information16 hr_form_properties.information16%TYPE
543: ,information17 hr_form_properties.information17%TYPE
544: ,information18 hr_form_properties.information18%TYPE
545: ,information19 hr_form_properties.information19%TYPE
546: ,information20 hr_form_properties.information20%TYPE
547: ,information21 hr_form_properties.information21%TYPE
548: ,information22 hr_form_properties.information22%TYPE
549: ,information23 hr_form_properties.information23%TYPE
550: ,information24 hr_form_properties.information24%TYPE

Line 547: ,information21 hr_form_properties.information21%TYPE

543: ,information17 hr_form_properties.information17%TYPE
544: ,information18 hr_form_properties.information18%TYPE
545: ,information19 hr_form_properties.information19%TYPE
546: ,information20 hr_form_properties.information20%TYPE
547: ,information21 hr_form_properties.information21%TYPE
548: ,information22 hr_form_properties.information22%TYPE
549: ,information23 hr_form_properties.information23%TYPE
550: ,information24 hr_form_properties.information24%TYPE
551: ,information25 hr_form_properties.information25%TYPE

Line 548: ,information22 hr_form_properties.information22%TYPE

544: ,information18 hr_form_properties.information18%TYPE
545: ,information19 hr_form_properties.information19%TYPE
546: ,information20 hr_form_properties.information20%TYPE
547: ,information21 hr_form_properties.information21%TYPE
548: ,information22 hr_form_properties.information22%TYPE
549: ,information23 hr_form_properties.information23%TYPE
550: ,information24 hr_form_properties.information24%TYPE
551: ,information25 hr_form_properties.information25%TYPE
552: ,information26 hr_form_properties.information26%TYPE

Line 549: ,information23 hr_form_properties.information23%TYPE

545: ,information19 hr_form_properties.information19%TYPE
546: ,information20 hr_form_properties.information20%TYPE
547: ,information21 hr_form_properties.information21%TYPE
548: ,information22 hr_form_properties.information22%TYPE
549: ,information23 hr_form_properties.information23%TYPE
550: ,information24 hr_form_properties.information24%TYPE
551: ,information25 hr_form_properties.information25%TYPE
552: ,information26 hr_form_properties.information26%TYPE
553: ,information27 hr_form_properties.information27%TYPE

Line 550: ,information24 hr_form_properties.information24%TYPE

546: ,information20 hr_form_properties.information20%TYPE
547: ,information21 hr_form_properties.information21%TYPE
548: ,information22 hr_form_properties.information22%TYPE
549: ,information23 hr_form_properties.information23%TYPE
550: ,information24 hr_form_properties.information24%TYPE
551: ,information25 hr_form_properties.information25%TYPE
552: ,information26 hr_form_properties.information26%TYPE
553: ,information27 hr_form_properties.information27%TYPE
554: ,information28 hr_form_properties.information28%TYPE

Line 551: ,information25 hr_form_properties.information25%TYPE

547: ,information21 hr_form_properties.information21%TYPE
548: ,information22 hr_form_properties.information22%TYPE
549: ,information23 hr_form_properties.information23%TYPE
550: ,information24 hr_form_properties.information24%TYPE
551: ,information25 hr_form_properties.information25%TYPE
552: ,information26 hr_form_properties.information26%TYPE
553: ,information27 hr_form_properties.information27%TYPE
554: ,information28 hr_form_properties.information28%TYPE
555: ,information29 hr_form_properties.information29%TYPE

Line 552: ,information26 hr_form_properties.information26%TYPE

548: ,information22 hr_form_properties.information22%TYPE
549: ,information23 hr_form_properties.information23%TYPE
550: ,information24 hr_form_properties.information24%TYPE
551: ,information25 hr_form_properties.information25%TYPE
552: ,information26 hr_form_properties.information26%TYPE
553: ,information27 hr_form_properties.information27%TYPE
554: ,information28 hr_form_properties.information28%TYPE
555: ,information29 hr_form_properties.information29%TYPE
556: ,information30 hr_form_properties.information30%TYPE);

Line 553: ,information27 hr_form_properties.information27%TYPE

549: ,information23 hr_form_properties.information23%TYPE
550: ,information24 hr_form_properties.information24%TYPE
551: ,information25 hr_form_properties.information25%TYPE
552: ,information26 hr_form_properties.information26%TYPE
553: ,information27 hr_form_properties.information27%TYPE
554: ,information28 hr_form_properties.information28%TYPE
555: ,information29 hr_form_properties.information29%TYPE
556: ,information30 hr_form_properties.information30%TYPE);
557:

Line 554: ,information28 hr_form_properties.information28%TYPE

550: ,information24 hr_form_properties.information24%TYPE
551: ,information25 hr_form_properties.information25%TYPE
552: ,information26 hr_form_properties.information26%TYPE
553: ,information27 hr_form_properties.information27%TYPE
554: ,information28 hr_form_properties.information28%TYPE
555: ,information29 hr_form_properties.information29%TYPE
556: ,information30 hr_form_properties.information30%TYPE);
557:
558: l_rec l_rec_type;

Line 555: ,information29 hr_form_properties.information29%TYPE

551: ,information25 hr_form_properties.information25%TYPE
552: ,information26 hr_form_properties.information26%TYPE
553: ,information27 hr_form_properties.information27%TYPE
554: ,information28 hr_form_properties.information28%TYPE
555: ,information29 hr_form_properties.information29%TYPE
556: ,information30 hr_form_properties.information30%TYPE);
557:
558: l_rec l_rec_type;
559:

Line 556: ,information30 hr_form_properties.information30%TYPE);

552: ,information26 hr_form_properties.information26%TYPE
553: ,information27 hr_form_properties.information27%TYPE
554: ,information28 hr_form_properties.information28%TYPE
555: ,information29 hr_form_properties.information29%TYPE
556: ,information30 hr_form_properties.information30%TYPE);
557:
558: l_rec l_rec_type;
559:
560: -- ask john , bpd says default for all is information1

Line 595: FROM hr_form_properties fmp

591: ,DECODE(p_information27,hr_api.g_varchar2,fmp.information27,p_information27)
592: ,DECODE(p_information28,hr_api.g_varchar2,fmp.information28,p_information28)
593: ,DECODE(p_information29,hr_api.g_varchar2,fmp.information29,p_information29)
594: ,DECODE(p_information30,hr_api.g_varchar2,fmp.information30,p_information30)
595: FROM hr_form_properties fmp
596: , fnd_application fnd
597: WHERE fmp.application_id (+) = fnd.application_id
598: AND fnd.application_id = p_application_id
599: AND fmp.form_id (+) = p_form_id;

Line 775: (help_target hr_form_properties.help_target%TYPE

771:
772: -- added a outer join so that the correct values are returned
773: -- if there are no entries in the properties table
774: Type l_rec_type Is Record
775: (help_target hr_form_properties.help_target%TYPE
776: ,information_category hr_form_properties.information_category%TYPE
777: ,information1 hr_form_properties.information1%TYPE
778: ,information2 hr_form_properties.information2%TYPE
779: ,information3 hr_form_properties.information3%TYPE

Line 776: ,information_category hr_form_properties.information_category%TYPE

772: -- added a outer join so that the correct values are returned
773: -- if there are no entries in the properties table
774: Type l_rec_type Is Record
775: (help_target hr_form_properties.help_target%TYPE
776: ,information_category hr_form_properties.information_category%TYPE
777: ,information1 hr_form_properties.information1%TYPE
778: ,information2 hr_form_properties.information2%TYPE
779: ,information3 hr_form_properties.information3%TYPE
780: ,information4 hr_form_properties.information4%TYPE

Line 777: ,information1 hr_form_properties.information1%TYPE

773: -- if there are no entries in the properties table
774: Type l_rec_type Is Record
775: (help_target hr_form_properties.help_target%TYPE
776: ,information_category hr_form_properties.information_category%TYPE
777: ,information1 hr_form_properties.information1%TYPE
778: ,information2 hr_form_properties.information2%TYPE
779: ,information3 hr_form_properties.information3%TYPE
780: ,information4 hr_form_properties.information4%TYPE
781: ,information5 hr_form_properties.information5%TYPE

Line 778: ,information2 hr_form_properties.information2%TYPE

774: Type l_rec_type Is Record
775: (help_target hr_form_properties.help_target%TYPE
776: ,information_category hr_form_properties.information_category%TYPE
777: ,information1 hr_form_properties.information1%TYPE
778: ,information2 hr_form_properties.information2%TYPE
779: ,information3 hr_form_properties.information3%TYPE
780: ,information4 hr_form_properties.information4%TYPE
781: ,information5 hr_form_properties.information5%TYPE
782: ,information6 hr_form_properties.information6%TYPE

Line 779: ,information3 hr_form_properties.information3%TYPE

775: (help_target hr_form_properties.help_target%TYPE
776: ,information_category hr_form_properties.information_category%TYPE
777: ,information1 hr_form_properties.information1%TYPE
778: ,information2 hr_form_properties.information2%TYPE
779: ,information3 hr_form_properties.information3%TYPE
780: ,information4 hr_form_properties.information4%TYPE
781: ,information5 hr_form_properties.information5%TYPE
782: ,information6 hr_form_properties.information6%TYPE
783: ,information7 hr_form_properties.information7%TYPE

Line 780: ,information4 hr_form_properties.information4%TYPE

776: ,information_category hr_form_properties.information_category%TYPE
777: ,information1 hr_form_properties.information1%TYPE
778: ,information2 hr_form_properties.information2%TYPE
779: ,information3 hr_form_properties.information3%TYPE
780: ,information4 hr_form_properties.information4%TYPE
781: ,information5 hr_form_properties.information5%TYPE
782: ,information6 hr_form_properties.information6%TYPE
783: ,information7 hr_form_properties.information7%TYPE
784: ,information8 hr_form_properties.information8%TYPE

Line 781: ,information5 hr_form_properties.information5%TYPE

777: ,information1 hr_form_properties.information1%TYPE
778: ,information2 hr_form_properties.information2%TYPE
779: ,information3 hr_form_properties.information3%TYPE
780: ,information4 hr_form_properties.information4%TYPE
781: ,information5 hr_form_properties.information5%TYPE
782: ,information6 hr_form_properties.information6%TYPE
783: ,information7 hr_form_properties.information7%TYPE
784: ,information8 hr_form_properties.information8%TYPE
785: ,information9 hr_form_properties.information9%TYPE

Line 782: ,information6 hr_form_properties.information6%TYPE

778: ,information2 hr_form_properties.information2%TYPE
779: ,information3 hr_form_properties.information3%TYPE
780: ,information4 hr_form_properties.information4%TYPE
781: ,information5 hr_form_properties.information5%TYPE
782: ,information6 hr_form_properties.information6%TYPE
783: ,information7 hr_form_properties.information7%TYPE
784: ,information8 hr_form_properties.information8%TYPE
785: ,information9 hr_form_properties.information9%TYPE
786: ,information10 hr_form_properties.information10%TYPE

Line 783: ,information7 hr_form_properties.information7%TYPE

779: ,information3 hr_form_properties.information3%TYPE
780: ,information4 hr_form_properties.information4%TYPE
781: ,information5 hr_form_properties.information5%TYPE
782: ,information6 hr_form_properties.information6%TYPE
783: ,information7 hr_form_properties.information7%TYPE
784: ,information8 hr_form_properties.information8%TYPE
785: ,information9 hr_form_properties.information9%TYPE
786: ,information10 hr_form_properties.information10%TYPE
787: ,information11 hr_form_properties.information11%TYPE

Line 784: ,information8 hr_form_properties.information8%TYPE

780: ,information4 hr_form_properties.information4%TYPE
781: ,information5 hr_form_properties.information5%TYPE
782: ,information6 hr_form_properties.information6%TYPE
783: ,information7 hr_form_properties.information7%TYPE
784: ,information8 hr_form_properties.information8%TYPE
785: ,information9 hr_form_properties.information9%TYPE
786: ,information10 hr_form_properties.information10%TYPE
787: ,information11 hr_form_properties.information11%TYPE
788: ,information12 hr_form_properties.information12%TYPE

Line 785: ,information9 hr_form_properties.information9%TYPE

781: ,information5 hr_form_properties.information5%TYPE
782: ,information6 hr_form_properties.information6%TYPE
783: ,information7 hr_form_properties.information7%TYPE
784: ,information8 hr_form_properties.information8%TYPE
785: ,information9 hr_form_properties.information9%TYPE
786: ,information10 hr_form_properties.information10%TYPE
787: ,information11 hr_form_properties.information11%TYPE
788: ,information12 hr_form_properties.information12%TYPE
789: ,information13 hr_form_properties.information13%TYPE

Line 786: ,information10 hr_form_properties.information10%TYPE

782: ,information6 hr_form_properties.information6%TYPE
783: ,information7 hr_form_properties.information7%TYPE
784: ,information8 hr_form_properties.information8%TYPE
785: ,information9 hr_form_properties.information9%TYPE
786: ,information10 hr_form_properties.information10%TYPE
787: ,information11 hr_form_properties.information11%TYPE
788: ,information12 hr_form_properties.information12%TYPE
789: ,information13 hr_form_properties.information13%TYPE
790: ,information14 hr_form_properties.information14%TYPE

Line 787: ,information11 hr_form_properties.information11%TYPE

783: ,information7 hr_form_properties.information7%TYPE
784: ,information8 hr_form_properties.information8%TYPE
785: ,information9 hr_form_properties.information9%TYPE
786: ,information10 hr_form_properties.information10%TYPE
787: ,information11 hr_form_properties.information11%TYPE
788: ,information12 hr_form_properties.information12%TYPE
789: ,information13 hr_form_properties.information13%TYPE
790: ,information14 hr_form_properties.information14%TYPE
791: ,information15 hr_form_properties.information15%TYPE

Line 788: ,information12 hr_form_properties.information12%TYPE

784: ,information8 hr_form_properties.information8%TYPE
785: ,information9 hr_form_properties.information9%TYPE
786: ,information10 hr_form_properties.information10%TYPE
787: ,information11 hr_form_properties.information11%TYPE
788: ,information12 hr_form_properties.information12%TYPE
789: ,information13 hr_form_properties.information13%TYPE
790: ,information14 hr_form_properties.information14%TYPE
791: ,information15 hr_form_properties.information15%TYPE
792: ,information16 hr_form_properties.information16%TYPE

Line 789: ,information13 hr_form_properties.information13%TYPE

785: ,information9 hr_form_properties.information9%TYPE
786: ,information10 hr_form_properties.information10%TYPE
787: ,information11 hr_form_properties.information11%TYPE
788: ,information12 hr_form_properties.information12%TYPE
789: ,information13 hr_form_properties.information13%TYPE
790: ,information14 hr_form_properties.information14%TYPE
791: ,information15 hr_form_properties.information15%TYPE
792: ,information16 hr_form_properties.information16%TYPE
793: ,information17 hr_form_properties.information17%TYPE

Line 790: ,information14 hr_form_properties.information14%TYPE

786: ,information10 hr_form_properties.information10%TYPE
787: ,information11 hr_form_properties.information11%TYPE
788: ,information12 hr_form_properties.information12%TYPE
789: ,information13 hr_form_properties.information13%TYPE
790: ,information14 hr_form_properties.information14%TYPE
791: ,information15 hr_form_properties.information15%TYPE
792: ,information16 hr_form_properties.information16%TYPE
793: ,information17 hr_form_properties.information17%TYPE
794: ,information18 hr_form_properties.information18%TYPE

Line 791: ,information15 hr_form_properties.information15%TYPE

787: ,information11 hr_form_properties.information11%TYPE
788: ,information12 hr_form_properties.information12%TYPE
789: ,information13 hr_form_properties.information13%TYPE
790: ,information14 hr_form_properties.information14%TYPE
791: ,information15 hr_form_properties.information15%TYPE
792: ,information16 hr_form_properties.information16%TYPE
793: ,information17 hr_form_properties.information17%TYPE
794: ,information18 hr_form_properties.information18%TYPE
795: ,information19 hr_form_properties.information19%TYPE

Line 792: ,information16 hr_form_properties.information16%TYPE

788: ,information12 hr_form_properties.information12%TYPE
789: ,information13 hr_form_properties.information13%TYPE
790: ,information14 hr_form_properties.information14%TYPE
791: ,information15 hr_form_properties.information15%TYPE
792: ,information16 hr_form_properties.information16%TYPE
793: ,information17 hr_form_properties.information17%TYPE
794: ,information18 hr_form_properties.information18%TYPE
795: ,information19 hr_form_properties.information19%TYPE
796: ,information20 hr_form_properties.information20%TYPE

Line 793: ,information17 hr_form_properties.information17%TYPE

789: ,information13 hr_form_properties.information13%TYPE
790: ,information14 hr_form_properties.information14%TYPE
791: ,information15 hr_form_properties.information15%TYPE
792: ,information16 hr_form_properties.information16%TYPE
793: ,information17 hr_form_properties.information17%TYPE
794: ,information18 hr_form_properties.information18%TYPE
795: ,information19 hr_form_properties.information19%TYPE
796: ,information20 hr_form_properties.information20%TYPE
797: ,information21 hr_form_properties.information21%TYPE

Line 794: ,information18 hr_form_properties.information18%TYPE

790: ,information14 hr_form_properties.information14%TYPE
791: ,information15 hr_form_properties.information15%TYPE
792: ,information16 hr_form_properties.information16%TYPE
793: ,information17 hr_form_properties.information17%TYPE
794: ,information18 hr_form_properties.information18%TYPE
795: ,information19 hr_form_properties.information19%TYPE
796: ,information20 hr_form_properties.information20%TYPE
797: ,information21 hr_form_properties.information21%TYPE
798: ,information22 hr_form_properties.information22%TYPE

Line 795: ,information19 hr_form_properties.information19%TYPE

791: ,information15 hr_form_properties.information15%TYPE
792: ,information16 hr_form_properties.information16%TYPE
793: ,information17 hr_form_properties.information17%TYPE
794: ,information18 hr_form_properties.information18%TYPE
795: ,information19 hr_form_properties.information19%TYPE
796: ,information20 hr_form_properties.information20%TYPE
797: ,information21 hr_form_properties.information21%TYPE
798: ,information22 hr_form_properties.information22%TYPE
799: ,information23 hr_form_properties.information23%TYPE

Line 796: ,information20 hr_form_properties.information20%TYPE

792: ,information16 hr_form_properties.information16%TYPE
793: ,information17 hr_form_properties.information17%TYPE
794: ,information18 hr_form_properties.information18%TYPE
795: ,information19 hr_form_properties.information19%TYPE
796: ,information20 hr_form_properties.information20%TYPE
797: ,information21 hr_form_properties.information21%TYPE
798: ,information22 hr_form_properties.information22%TYPE
799: ,information23 hr_form_properties.information23%TYPE
800: ,information24 hr_form_properties.information24%TYPE

Line 797: ,information21 hr_form_properties.information21%TYPE

793: ,information17 hr_form_properties.information17%TYPE
794: ,information18 hr_form_properties.information18%TYPE
795: ,information19 hr_form_properties.information19%TYPE
796: ,information20 hr_form_properties.information20%TYPE
797: ,information21 hr_form_properties.information21%TYPE
798: ,information22 hr_form_properties.information22%TYPE
799: ,information23 hr_form_properties.information23%TYPE
800: ,information24 hr_form_properties.information24%TYPE
801: ,information25 hr_form_properties.information25%TYPE

Line 798: ,information22 hr_form_properties.information22%TYPE

794: ,information18 hr_form_properties.information18%TYPE
795: ,information19 hr_form_properties.information19%TYPE
796: ,information20 hr_form_properties.information20%TYPE
797: ,information21 hr_form_properties.information21%TYPE
798: ,information22 hr_form_properties.information22%TYPE
799: ,information23 hr_form_properties.information23%TYPE
800: ,information24 hr_form_properties.information24%TYPE
801: ,information25 hr_form_properties.information25%TYPE
802: ,information26 hr_form_properties.information26%TYPE

Line 799: ,information23 hr_form_properties.information23%TYPE

795: ,information19 hr_form_properties.information19%TYPE
796: ,information20 hr_form_properties.information20%TYPE
797: ,information21 hr_form_properties.information21%TYPE
798: ,information22 hr_form_properties.information22%TYPE
799: ,information23 hr_form_properties.information23%TYPE
800: ,information24 hr_form_properties.information24%TYPE
801: ,information25 hr_form_properties.information25%TYPE
802: ,information26 hr_form_properties.information26%TYPE
803: ,information27 hr_form_properties.information27%TYPE

Line 800: ,information24 hr_form_properties.information24%TYPE

796: ,information20 hr_form_properties.information20%TYPE
797: ,information21 hr_form_properties.information21%TYPE
798: ,information22 hr_form_properties.information22%TYPE
799: ,information23 hr_form_properties.information23%TYPE
800: ,information24 hr_form_properties.information24%TYPE
801: ,information25 hr_form_properties.information25%TYPE
802: ,information26 hr_form_properties.information26%TYPE
803: ,information27 hr_form_properties.information27%TYPE
804: ,information28 hr_form_properties.information28%TYPE

Line 801: ,information25 hr_form_properties.information25%TYPE

797: ,information21 hr_form_properties.information21%TYPE
798: ,information22 hr_form_properties.information22%TYPE
799: ,information23 hr_form_properties.information23%TYPE
800: ,information24 hr_form_properties.information24%TYPE
801: ,information25 hr_form_properties.information25%TYPE
802: ,information26 hr_form_properties.information26%TYPE
803: ,information27 hr_form_properties.information27%TYPE
804: ,information28 hr_form_properties.information28%TYPE
805: ,information29 hr_form_properties.information29%TYPE

Line 802: ,information26 hr_form_properties.information26%TYPE

798: ,information22 hr_form_properties.information22%TYPE
799: ,information23 hr_form_properties.information23%TYPE
800: ,information24 hr_form_properties.information24%TYPE
801: ,information25 hr_form_properties.information25%TYPE
802: ,information26 hr_form_properties.information26%TYPE
803: ,information27 hr_form_properties.information27%TYPE
804: ,information28 hr_form_properties.information28%TYPE
805: ,information29 hr_form_properties.information29%TYPE
806: ,information30 hr_form_properties.information30%TYPE);

Line 803: ,information27 hr_form_properties.information27%TYPE

799: ,information23 hr_form_properties.information23%TYPE
800: ,information24 hr_form_properties.information24%TYPE
801: ,information25 hr_form_properties.information25%TYPE
802: ,information26 hr_form_properties.information26%TYPE
803: ,information27 hr_form_properties.information27%TYPE
804: ,information28 hr_form_properties.information28%TYPE
805: ,information29 hr_form_properties.information29%TYPE
806: ,information30 hr_form_properties.information30%TYPE);
807:

Line 804: ,information28 hr_form_properties.information28%TYPE

800: ,information24 hr_form_properties.information24%TYPE
801: ,information25 hr_form_properties.information25%TYPE
802: ,information26 hr_form_properties.information26%TYPE
803: ,information27 hr_form_properties.information27%TYPE
804: ,information28 hr_form_properties.information28%TYPE
805: ,information29 hr_form_properties.information29%TYPE
806: ,information30 hr_form_properties.information30%TYPE);
807:
808: l_rec l_rec_type;

Line 805: ,information29 hr_form_properties.information29%TYPE

801: ,information25 hr_form_properties.information25%TYPE
802: ,information26 hr_form_properties.information26%TYPE
803: ,information27 hr_form_properties.information27%TYPE
804: ,information28 hr_form_properties.information28%TYPE
805: ,information29 hr_form_properties.information29%TYPE
806: ,information30 hr_form_properties.information30%TYPE);
807:
808: l_rec l_rec_type;
809:

Line 806: ,information30 hr_form_properties.information30%TYPE);

802: ,information26 hr_form_properties.information26%TYPE
803: ,information27 hr_form_properties.information27%TYPE
804: ,information28 hr_form_properties.information28%TYPE
805: ,information29 hr_form_properties.information29%TYPE
806: ,information30 hr_form_properties.information30%TYPE);
807:
808: l_rec l_rec_type;
809:
810: -- ask john , bpd says default for all is information1

Line 845: FROM hr_form_properties fmp

841: ,DECODE(p_information27,hr_api.g_varchar2,fmp.information27,p_information27)
842: ,DECODE(p_information28,hr_api.g_varchar2,fmp.information28,p_information28)
843: ,DECODE(p_information29,hr_api.g_varchar2,fmp.information29,p_information29)
844: ,DECODE(p_information30,hr_api.g_varchar2,fmp.information30,p_information30)
845: FROM hr_form_properties fmp
846: ,hr_form_templates_b hft
847: WHERE fmp.form_template_id (+) = hft.form_template_id
848: AND hft.form_template_id = p_form_template_id_from;
849:

Line 980: end hr_form_properties_bsi;

976: hr_utility.set_location(' Leaving:'||l_proc, 90);
977: raise;
978: end copy_form_property;
979: --
980: end hr_form_properties_bsi;