DBA Data[Home] [Help]

APPS.PER_RI_CONFIG_TECH_SUMMARY dependencies on PER_RI_CONFIG_UTILITIES

Line 584: '''' || per_ri_config_utilities.get_location_prompt(l_style,'ADDRESS_LINE_1') ||''''||' ADDRESS_LINE1_PROMPT ,'||

580: '''' || replace(p_location_tab(i).location_code,'''','''''') ||''''||' LOCATION_CODE ,'||
581: '''' || replace(p_location_tab(i).description,'''','''''') ||''''||' DESCRIPTION ,'||
582: '''' || l_style_val ||''''||' STYLE ,'||
583: '''' || replace(p_location_tab(i).address_line_1,'''','''''') ||''''||' ADDRESS_LINE_1 ,'||
584: '''' || per_ri_config_utilities.get_location_prompt(l_style,'ADDRESS_LINE_1') ||''''||' ADDRESS_LINE1_PROMPT ,'||
585: '''' || nvl(replace(p_location_tab(i).address_line_2,'''',''''''),' ') ||'''' ||' ADDRESS_LINE_2 ,'||
586: '''' || per_ri_config_utilities.get_location_prompt(l_style,'ADDRESS_LINE_2') ||''''||' ADDRESS_LINE2_PROMPT ,'||
587: '''' || nvl(replace(p_location_tab(i).address_line_3,'''',''''''),' ') ||''''||' ADDRESS_LINE_3 ,'||
588: '''' || per_ri_config_utilities.get_location_prompt(l_style,'ADDRESS_LINE_3') ||''''||' ADDRESS_LINE3_PROMPT ,'||

Line 586: '''' || per_ri_config_utilities.get_location_prompt(l_style,'ADDRESS_LINE_2') ||''''||' ADDRESS_LINE2_PROMPT ,'||

582: '''' || l_style_val ||''''||' STYLE ,'||
583: '''' || replace(p_location_tab(i).address_line_1,'''','''''') ||''''||' ADDRESS_LINE_1 ,'||
584: '''' || per_ri_config_utilities.get_location_prompt(l_style,'ADDRESS_LINE_1') ||''''||' ADDRESS_LINE1_PROMPT ,'||
585: '''' || nvl(replace(p_location_tab(i).address_line_2,'''',''''''),' ') ||'''' ||' ADDRESS_LINE_2 ,'||
586: '''' || per_ri_config_utilities.get_location_prompt(l_style,'ADDRESS_LINE_2') ||''''||' ADDRESS_LINE2_PROMPT ,'||
587: '''' || nvl(replace(p_location_tab(i).address_line_3,'''',''''''),' ') ||''''||' ADDRESS_LINE_3 ,'||
588: '''' || per_ri_config_utilities.get_location_prompt(l_style,'ADDRESS_LINE_3') ||''''||' ADDRESS_LINE3_PROMPT ,'||
589: '''' || nvl(replace(p_location_tab(i).town_or_city,'''',''''''),' ') ||''''||' TOWN_OR_CITY ,'||
590: '''' || per_ri_config_utilities.get_location_prompt(l_style,'TOWN_OR_CITY') ||''''||' TOWN_OR_CITY_PROMPT ,'||

Line 588: '''' || per_ri_config_utilities.get_location_prompt(l_style,'ADDRESS_LINE_3') ||''''||' ADDRESS_LINE3_PROMPT ,'||

584: '''' || per_ri_config_utilities.get_location_prompt(l_style,'ADDRESS_LINE_1') ||''''||' ADDRESS_LINE1_PROMPT ,'||
585: '''' || nvl(replace(p_location_tab(i).address_line_2,'''',''''''),' ') ||'''' ||' ADDRESS_LINE_2 ,'||
586: '''' || per_ri_config_utilities.get_location_prompt(l_style,'ADDRESS_LINE_2') ||''''||' ADDRESS_LINE2_PROMPT ,'||
587: '''' || nvl(replace(p_location_tab(i).address_line_3,'''',''''''),' ') ||''''||' ADDRESS_LINE_3 ,'||
588: '''' || per_ri_config_utilities.get_location_prompt(l_style,'ADDRESS_LINE_3') ||''''||' ADDRESS_LINE3_PROMPT ,'||
589: '''' || nvl(replace(p_location_tab(i).town_or_city,'''',''''''),' ') ||''''||' TOWN_OR_CITY ,'||
590: '''' || per_ri_config_utilities.get_location_prompt(l_style,'TOWN_OR_CITY') ||''''||' TOWN_OR_CITY_PROMPT ,'||
591: '''' || nvl(replace(l_country,'''',''''''),' ') ||''''||' COUNTRY ,'||
592: '''' || per_ri_config_utilities.get_location_prompt(l_style,'COUNTRY') ||''''||' COUNTRY_PROMPT ,'||

Line 590: '''' || per_ri_config_utilities.get_location_prompt(l_style,'TOWN_OR_CITY') ||''''||' TOWN_OR_CITY_PROMPT ,'||

586: '''' || per_ri_config_utilities.get_location_prompt(l_style,'ADDRESS_LINE_2') ||''''||' ADDRESS_LINE2_PROMPT ,'||
587: '''' || nvl(replace(p_location_tab(i).address_line_3,'''',''''''),' ') ||''''||' ADDRESS_LINE_3 ,'||
588: '''' || per_ri_config_utilities.get_location_prompt(l_style,'ADDRESS_LINE_3') ||''''||' ADDRESS_LINE3_PROMPT ,'||
589: '''' || nvl(replace(p_location_tab(i).town_or_city,'''',''''''),' ') ||''''||' TOWN_OR_CITY ,'||
590: '''' || per_ri_config_utilities.get_location_prompt(l_style,'TOWN_OR_CITY') ||''''||' TOWN_OR_CITY_PROMPT ,'||
591: '''' || nvl(replace(l_country,'''',''''''),' ') ||''''||' COUNTRY ,'||
592: '''' || per_ri_config_utilities.get_location_prompt(l_style,'COUNTRY') ||''''||' COUNTRY_PROMPT ,'||
593: '''' || nvl(replace(p_location_tab(i).postal_code,'''',''''''),' ') ||''''||' POSTAL_CODE ,'||
594: '''' || per_ri_config_utilities.get_location_prompt(l_style,'POSTAL_CODE') ||''''||' POSTAL_CODE_PROMPT ,'||

Line 592: '''' || per_ri_config_utilities.get_location_prompt(l_style,'COUNTRY') ||''''||' COUNTRY_PROMPT ,'||

588: '''' || per_ri_config_utilities.get_location_prompt(l_style,'ADDRESS_LINE_3') ||''''||' ADDRESS_LINE3_PROMPT ,'||
589: '''' || nvl(replace(p_location_tab(i).town_or_city,'''',''''''),' ') ||''''||' TOWN_OR_CITY ,'||
590: '''' || per_ri_config_utilities.get_location_prompt(l_style,'TOWN_OR_CITY') ||''''||' TOWN_OR_CITY_PROMPT ,'||
591: '''' || nvl(replace(l_country,'''',''''''),' ') ||''''||' COUNTRY ,'||
592: '''' || per_ri_config_utilities.get_location_prompt(l_style,'COUNTRY') ||''''||' COUNTRY_PROMPT ,'||
593: '''' || nvl(replace(p_location_tab(i).postal_code,'''',''''''),' ') ||''''||' POSTAL_CODE ,'||
594: '''' || per_ri_config_utilities.get_location_prompt(l_style,'POSTAL_CODE') ||''''||' POSTAL_CODE_PROMPT ,'||
595: '''' || nvl(replace(p_location_tab(i).region_1,'''',''''''),' ') ||''''||' REGION1 ,'||
596: '''' || per_ri_config_utilities.get_location_prompt(l_style,'REGION_1') ||''''||' REGION1_PROMPT ,'||

Line 594: '''' || per_ri_config_utilities.get_location_prompt(l_style,'POSTAL_CODE') ||''''||' POSTAL_CODE_PROMPT ,'||

590: '''' || per_ri_config_utilities.get_location_prompt(l_style,'TOWN_OR_CITY') ||''''||' TOWN_OR_CITY_PROMPT ,'||
591: '''' || nvl(replace(l_country,'''',''''''),' ') ||''''||' COUNTRY ,'||
592: '''' || per_ri_config_utilities.get_location_prompt(l_style,'COUNTRY') ||''''||' COUNTRY_PROMPT ,'||
593: '''' || nvl(replace(p_location_tab(i).postal_code,'''',''''''),' ') ||''''||' POSTAL_CODE ,'||
594: '''' || per_ri_config_utilities.get_location_prompt(l_style,'POSTAL_CODE') ||''''||' POSTAL_CODE_PROMPT ,'||
595: '''' || nvl(replace(p_location_tab(i).region_1,'''',''''''),' ') ||''''||' REGION1 ,'||
596: '''' || per_ri_config_utilities.get_location_prompt(l_style,'REGION_1') ||''''||' REGION1_PROMPT ,'||
597: '''' || nvl(replace(p_location_tab(i).region_2,'''',''''''),' ') ||''''||' REGION2 ,'||
598: '''' || per_ri_config_utilities.get_location_prompt(l_style,'REGION_2') ||''''||' REGION2_PROMPT ,'||

Line 596: '''' || per_ri_config_utilities.get_location_prompt(l_style,'REGION_1') ||''''||' REGION1_PROMPT ,'||

592: '''' || per_ri_config_utilities.get_location_prompt(l_style,'COUNTRY') ||''''||' COUNTRY_PROMPT ,'||
593: '''' || nvl(replace(p_location_tab(i).postal_code,'''',''''''),' ') ||''''||' POSTAL_CODE ,'||
594: '''' || per_ri_config_utilities.get_location_prompt(l_style,'POSTAL_CODE') ||''''||' POSTAL_CODE_PROMPT ,'||
595: '''' || nvl(replace(p_location_tab(i).region_1,'''',''''''),' ') ||''''||' REGION1 ,'||
596: '''' || per_ri_config_utilities.get_location_prompt(l_style,'REGION_1') ||''''||' REGION1_PROMPT ,'||
597: '''' || nvl(replace(p_location_tab(i).region_2,'''',''''''),' ') ||''''||' REGION2 ,'||
598: '''' || per_ri_config_utilities.get_location_prompt(l_style,'REGION_2') ||''''||' REGION2_PROMPT ,'||
599: '''' || nvl(replace(p_location_tab(i).region_3,'''',''''''),' ') ||''''||' REGION3 ,'||
600: '''' || per_ri_config_utilities.get_location_prompt(l_style,'REGION_3') ||''''||' REGION3_PROMPT ,'||

Line 598: '''' || per_ri_config_utilities.get_location_prompt(l_style,'REGION_2') ||''''||' REGION2_PROMPT ,'||

594: '''' || per_ri_config_utilities.get_location_prompt(l_style,'POSTAL_CODE') ||''''||' POSTAL_CODE_PROMPT ,'||
595: '''' || nvl(replace(p_location_tab(i).region_1,'''',''''''),' ') ||''''||' REGION1 ,'||
596: '''' || per_ri_config_utilities.get_location_prompt(l_style,'REGION_1') ||''''||' REGION1_PROMPT ,'||
597: '''' || nvl(replace(p_location_tab(i).region_2,'''',''''''),' ') ||''''||' REGION2 ,'||
598: '''' || per_ri_config_utilities.get_location_prompt(l_style,'REGION_2') ||''''||' REGION2_PROMPT ,'||
599: '''' || nvl(replace(p_location_tab(i).region_3,'''',''''''),' ') ||''''||' REGION3 ,'||
600: '''' || per_ri_config_utilities.get_location_prompt(l_style,'REGION_3') ||''''||' REGION3_PROMPT ,'||
601: '''' || nvl(replace(p_location_tab(i).telephone_number_1,'''',''''''),' ')||''''||' TELEPHONE_NUMBER_1 ,'||
602: '''' || per_ri_config_utilities.get_location_prompt(l_style,'TELEPHONE_NUMBER_1')||''''||' TELEPHONE_NUMBER1_PROMPT ,'||

Line 600: '''' || per_ri_config_utilities.get_location_prompt(l_style,'REGION_3') ||''''||' REGION3_PROMPT ,'||

596: '''' || per_ri_config_utilities.get_location_prompt(l_style,'REGION_1') ||''''||' REGION1_PROMPT ,'||
597: '''' || nvl(replace(p_location_tab(i).region_2,'''',''''''),' ') ||''''||' REGION2 ,'||
598: '''' || per_ri_config_utilities.get_location_prompt(l_style,'REGION_2') ||''''||' REGION2_PROMPT ,'||
599: '''' || nvl(replace(p_location_tab(i).region_3,'''',''''''),' ') ||''''||' REGION3 ,'||
600: '''' || per_ri_config_utilities.get_location_prompt(l_style,'REGION_3') ||''''||' REGION3_PROMPT ,'||
601: '''' || nvl(replace(p_location_tab(i).telephone_number_1,'''',''''''),' ')||''''||' TELEPHONE_NUMBER_1 ,'||
602: '''' || per_ri_config_utilities.get_location_prompt(l_style,'TELEPHONE_NUMBER_1')||''''||' TELEPHONE_NUMBER1_PROMPT ,'||
603: '''' || nvl(replace(p_location_tab(i).telephone_number_2,'''',''''''),' ')||''''||' TELEPHONE_NUMBER_2 ,'||
604: '''' || per_ri_config_utilities.get_location_prompt(l_style,'TELEPHONE_NUMBER_2')||''''||' TELEPHONE_NUMBER2_PROMPT ,'||

Line 602: '''' || per_ri_config_utilities.get_location_prompt(l_style,'TELEPHONE_NUMBER_1')||''''||' TELEPHONE_NUMBER1_PROMPT ,'||

598: '''' || per_ri_config_utilities.get_location_prompt(l_style,'REGION_2') ||''''||' REGION2_PROMPT ,'||
599: '''' || nvl(replace(p_location_tab(i).region_3,'''',''''''),' ') ||''''||' REGION3 ,'||
600: '''' || per_ri_config_utilities.get_location_prompt(l_style,'REGION_3') ||''''||' REGION3_PROMPT ,'||
601: '''' || nvl(replace(p_location_tab(i).telephone_number_1,'''',''''''),' ')||''''||' TELEPHONE_NUMBER_1 ,'||
602: '''' || per_ri_config_utilities.get_location_prompt(l_style,'TELEPHONE_NUMBER_1')||''''||' TELEPHONE_NUMBER1_PROMPT ,'||
603: '''' || nvl(replace(p_location_tab(i).telephone_number_2,'''',''''''),' ')||''''||' TELEPHONE_NUMBER_2 ,'||
604: '''' || per_ri_config_utilities.get_location_prompt(l_style,'TELEPHONE_NUMBER_2')||''''||' TELEPHONE_NUMBER2_PROMPT ,'||
605: '''' || nvl(replace(p_location_tab(i).telephone_number_3,'''',''''''),' ')||''''||' TELEPHONE_NUMBER_3 ,'||
606: '''' || per_ri_config_utilities.get_location_prompt(l_style,'TELEPHONE_NUMBER_3')||''''||' TELEPHONE_NUMBER3_PROMPT ,'||

Line 604: '''' || per_ri_config_utilities.get_location_prompt(l_style,'TELEPHONE_NUMBER_2')||''''||' TELEPHONE_NUMBER2_PROMPT ,'||

600: '''' || per_ri_config_utilities.get_location_prompt(l_style,'REGION_3') ||''''||' REGION3_PROMPT ,'||
601: '''' || nvl(replace(p_location_tab(i).telephone_number_1,'''',''''''),' ')||''''||' TELEPHONE_NUMBER_1 ,'||
602: '''' || per_ri_config_utilities.get_location_prompt(l_style,'TELEPHONE_NUMBER_1')||''''||' TELEPHONE_NUMBER1_PROMPT ,'||
603: '''' || nvl(replace(p_location_tab(i).telephone_number_2,'''',''''''),' ')||''''||' TELEPHONE_NUMBER_2 ,'||
604: '''' || per_ri_config_utilities.get_location_prompt(l_style,'TELEPHONE_NUMBER_2')||''''||' TELEPHONE_NUMBER2_PROMPT ,'||
605: '''' || nvl(replace(p_location_tab(i).telephone_number_3,'''',''''''),' ')||''''||' TELEPHONE_NUMBER_3 ,'||
606: '''' || per_ri_config_utilities.get_location_prompt(l_style,'TELEPHONE_NUMBER_3')||''''||' TELEPHONE_NUMBER3_PROMPT ,'||
607: '''' || nvl(replace(p_location_tab(i).loc_information13,'''',''''''),' ')||''''||' LOC_INFORMATION13 ,'||
608: '''' || per_ri_config_utilities.get_location_prompt(l_style,'LOC_INFORMATION13') ||''''||' LOC_INFORMATION13_PROMPT ,'||

Line 606: '''' || per_ri_config_utilities.get_location_prompt(l_style,'TELEPHONE_NUMBER_3')||''''||' TELEPHONE_NUMBER3_PROMPT ,'||

602: '''' || per_ri_config_utilities.get_location_prompt(l_style,'TELEPHONE_NUMBER_1')||''''||' TELEPHONE_NUMBER1_PROMPT ,'||
603: '''' || nvl(replace(p_location_tab(i).telephone_number_2,'''',''''''),' ')||''''||' TELEPHONE_NUMBER_2 ,'||
604: '''' || per_ri_config_utilities.get_location_prompt(l_style,'TELEPHONE_NUMBER_2')||''''||' TELEPHONE_NUMBER2_PROMPT ,'||
605: '''' || nvl(replace(p_location_tab(i).telephone_number_3,'''',''''''),' ')||''''||' TELEPHONE_NUMBER_3 ,'||
606: '''' || per_ri_config_utilities.get_location_prompt(l_style,'TELEPHONE_NUMBER_3')||''''||' TELEPHONE_NUMBER3_PROMPT ,'||
607: '''' || nvl(replace(p_location_tab(i).loc_information13,'''',''''''),' ')||''''||' LOC_INFORMATION13 ,'||
608: '''' || per_ri_config_utilities.get_location_prompt(l_style,'LOC_INFORMATION13') ||''''||' LOC_INFORMATION13_PROMPT ,'||
609: '''' || nvl(replace(p_location_tab(i).loc_information14,'''',''''''),' ')||''''||' LOC_INFORMATION14 ,'||
610: '''' || per_ri_config_utilities.get_location_prompt(l_style,'LOC_INFORMATION14') ||''''||' LOC_INFORMATION14_PROMPT ,'||

Line 608: '''' || per_ri_config_utilities.get_location_prompt(l_style,'LOC_INFORMATION13') ||''''||' LOC_INFORMATION13_PROMPT ,'||

604: '''' || per_ri_config_utilities.get_location_prompt(l_style,'TELEPHONE_NUMBER_2')||''''||' TELEPHONE_NUMBER2_PROMPT ,'||
605: '''' || nvl(replace(p_location_tab(i).telephone_number_3,'''',''''''),' ')||''''||' TELEPHONE_NUMBER_3 ,'||
606: '''' || per_ri_config_utilities.get_location_prompt(l_style,'TELEPHONE_NUMBER_3')||''''||' TELEPHONE_NUMBER3_PROMPT ,'||
607: '''' || nvl(replace(p_location_tab(i).loc_information13,'''',''''''),' ')||''''||' LOC_INFORMATION13 ,'||
608: '''' || per_ri_config_utilities.get_location_prompt(l_style,'LOC_INFORMATION13') ||''''||' LOC_INFORMATION13_PROMPT ,'||
609: '''' || nvl(replace(p_location_tab(i).loc_information14,'''',''''''),' ')||''''||' LOC_INFORMATION14 ,'||
610: '''' || per_ri_config_utilities.get_location_prompt(l_style,'LOC_INFORMATION14') ||''''||' LOC_INFORMATION14_PROMPT ,'||
611: '''' || nvl(replace(p_location_tab(i).loc_information15,'''',''''''),' ')||''''||' LOC_INFORMATION15 ,'||
612: '''' || per_ri_config_utilities.get_location_prompt(l_style,'LOC_INFORMATION15') ||''''||' LOC_INFORMATION15_PROMPT ,'||

Line 610: '''' || per_ri_config_utilities.get_location_prompt(l_style,'LOC_INFORMATION14') ||''''||' LOC_INFORMATION14_PROMPT ,'||

606: '''' || per_ri_config_utilities.get_location_prompt(l_style,'TELEPHONE_NUMBER_3')||''''||' TELEPHONE_NUMBER3_PROMPT ,'||
607: '''' || nvl(replace(p_location_tab(i).loc_information13,'''',''''''),' ')||''''||' LOC_INFORMATION13 ,'||
608: '''' || per_ri_config_utilities.get_location_prompt(l_style,'LOC_INFORMATION13') ||''''||' LOC_INFORMATION13_PROMPT ,'||
609: '''' || nvl(replace(p_location_tab(i).loc_information14,'''',''''''),' ')||''''||' LOC_INFORMATION14 ,'||
610: '''' || per_ri_config_utilities.get_location_prompt(l_style,'LOC_INFORMATION14') ||''''||' LOC_INFORMATION14_PROMPT ,'||
611: '''' || nvl(replace(p_location_tab(i).loc_information15,'''',''''''),' ')||''''||' LOC_INFORMATION15 ,'||
612: '''' || per_ri_config_utilities.get_location_prompt(l_style,'LOC_INFORMATION15') ||''''||' LOC_INFORMATION15_PROMPT ,'||
613: '''' || nvl(replace(p_location_tab(i).loc_information16,'''',''''''),' ')||''''||' LOC_INFORMATION16 ,'||
614: '''' || per_ri_config_utilities.get_location_prompt(l_style,'LOC_INFORMATION16') ||''''||' LOC_INFORMATION16_PROMPT ,'||

Line 612: '''' || per_ri_config_utilities.get_location_prompt(l_style,'LOC_INFORMATION15') ||''''||' LOC_INFORMATION15_PROMPT ,'||

608: '''' || per_ri_config_utilities.get_location_prompt(l_style,'LOC_INFORMATION13') ||''''||' LOC_INFORMATION13_PROMPT ,'||
609: '''' || nvl(replace(p_location_tab(i).loc_information14,'''',''''''),' ')||''''||' LOC_INFORMATION14 ,'||
610: '''' || per_ri_config_utilities.get_location_prompt(l_style,'LOC_INFORMATION14') ||''''||' LOC_INFORMATION14_PROMPT ,'||
611: '''' || nvl(replace(p_location_tab(i).loc_information15,'''',''''''),' ')||''''||' LOC_INFORMATION15 ,'||
612: '''' || per_ri_config_utilities.get_location_prompt(l_style,'LOC_INFORMATION15') ||''''||' LOC_INFORMATION15_PROMPT ,'||
613: '''' || nvl(replace(p_location_tab(i).loc_information16,'''',''''''),' ')||''''||' LOC_INFORMATION16 ,'||
614: '''' || per_ri_config_utilities.get_location_prompt(l_style,'LOC_INFORMATION16') ||''''||' LOC_INFORMATION16_PROMPT ,'||
615: '''' || nvl(replace(p_location_tab(i).loc_information17,'''',''''''),' ')||''''||' LOC_INFORMATION17 ,'||
616: '''' || per_ri_config_utilities.get_location_prompt(l_style,'LOC_INFORMATION17')||''''||' LOC_INFORMATION17_PROMPT ,'||

Line 614: '''' || per_ri_config_utilities.get_location_prompt(l_style,'LOC_INFORMATION16') ||''''||' LOC_INFORMATION16_PROMPT ,'||

610: '''' || per_ri_config_utilities.get_location_prompt(l_style,'LOC_INFORMATION14') ||''''||' LOC_INFORMATION14_PROMPT ,'||
611: '''' || nvl(replace(p_location_tab(i).loc_information15,'''',''''''),' ')||''''||' LOC_INFORMATION15 ,'||
612: '''' || per_ri_config_utilities.get_location_prompt(l_style,'LOC_INFORMATION15') ||''''||' LOC_INFORMATION15_PROMPT ,'||
613: '''' || nvl(replace(p_location_tab(i).loc_information16,'''',''''''),' ')||''''||' LOC_INFORMATION16 ,'||
614: '''' || per_ri_config_utilities.get_location_prompt(l_style,'LOC_INFORMATION16') ||''''||' LOC_INFORMATION16_PROMPT ,'||
615: '''' || nvl(replace(p_location_tab(i).loc_information17,'''',''''''),' ')||''''||' LOC_INFORMATION17 ,'||
616: '''' || per_ri_config_utilities.get_location_prompt(l_style,'LOC_INFORMATION17')||''''||' LOC_INFORMATION17_PROMPT ,'||
617: '''' || nvl(replace(p_location_tab(i).loc_information18,'''',''''''),' ')||''''||' LOC_INFORMATION18 ,'||
618: '''' || per_ri_config_utilities.get_location_prompt(l_style,'LOC_INFORMATION18')||''''||' LOC_INFORMATION18_PROMPT ,'||

Line 616: '''' || per_ri_config_utilities.get_location_prompt(l_style,'LOC_INFORMATION17')||''''||' LOC_INFORMATION17_PROMPT ,'||

612: '''' || per_ri_config_utilities.get_location_prompt(l_style,'LOC_INFORMATION15') ||''''||' LOC_INFORMATION15_PROMPT ,'||
613: '''' || nvl(replace(p_location_tab(i).loc_information16,'''',''''''),' ')||''''||' LOC_INFORMATION16 ,'||
614: '''' || per_ri_config_utilities.get_location_prompt(l_style,'LOC_INFORMATION16') ||''''||' LOC_INFORMATION16_PROMPT ,'||
615: '''' || nvl(replace(p_location_tab(i).loc_information17,'''',''''''),' ')||''''||' LOC_INFORMATION17 ,'||
616: '''' || per_ri_config_utilities.get_location_prompt(l_style,'LOC_INFORMATION17')||''''||' LOC_INFORMATION17_PROMPT ,'||
617: '''' || nvl(replace(p_location_tab(i).loc_information18,'''',''''''),' ')||''''||' LOC_INFORMATION18 ,'||
618: '''' || per_ri_config_utilities.get_location_prompt(l_style,'LOC_INFORMATION18')||''''||' LOC_INFORMATION18_PROMPT ,'||
619: '''' || nvl(replace(p_location_tab(i).loc_information19,'''',''''''),' ')||''''||' LOC_INFORMATION19 ,'||
620: '''' || per_ri_config_utilities.get_location_prompt(l_style,'LOC_INFORMATION19')||''''||' LOC_INFORMATION19_PROMPT ,'||

Line 618: '''' || per_ri_config_utilities.get_location_prompt(l_style,'LOC_INFORMATION18')||''''||' LOC_INFORMATION18_PROMPT ,'||

614: '''' || per_ri_config_utilities.get_location_prompt(l_style,'LOC_INFORMATION16') ||''''||' LOC_INFORMATION16_PROMPT ,'||
615: '''' || nvl(replace(p_location_tab(i).loc_information17,'''',''''''),' ')||''''||' LOC_INFORMATION17 ,'||
616: '''' || per_ri_config_utilities.get_location_prompt(l_style,'LOC_INFORMATION17')||''''||' LOC_INFORMATION17_PROMPT ,'||
617: '''' || nvl(replace(p_location_tab(i).loc_information18,'''',''''''),' ')||''''||' LOC_INFORMATION18 ,'||
618: '''' || per_ri_config_utilities.get_location_prompt(l_style,'LOC_INFORMATION18')||''''||' LOC_INFORMATION18_PROMPT ,'||
619: '''' || nvl(replace(p_location_tab(i).loc_information19,'''',''''''),' ')||''''||' LOC_INFORMATION19 ,'||
620: '''' || per_ri_config_utilities.get_location_prompt(l_style,'LOC_INFORMATION19')||''''||' LOC_INFORMATION19_PROMPT ,'||
621: '''' || nvl(replace(p_location_tab(i).loc_information20,'''',''''''),' ')||''''||' LOC_INFORMATION20 ,'||
622: '''' || per_ri_config_utilities.get_location_prompt(l_style,'LOC_INFORMATION20')||''''||' LOC_INFORMATION20_PROMPT '||

Line 620: '''' || per_ri_config_utilities.get_location_prompt(l_style,'LOC_INFORMATION19')||''''||' LOC_INFORMATION19_PROMPT ,'||

616: '''' || per_ri_config_utilities.get_location_prompt(l_style,'LOC_INFORMATION17')||''''||' LOC_INFORMATION17_PROMPT ,'||
617: '''' || nvl(replace(p_location_tab(i).loc_information18,'''',''''''),' ')||''''||' LOC_INFORMATION18 ,'||
618: '''' || per_ri_config_utilities.get_location_prompt(l_style,'LOC_INFORMATION18')||''''||' LOC_INFORMATION18_PROMPT ,'||
619: '''' || nvl(replace(p_location_tab(i).loc_information19,'''',''''''),' ')||''''||' LOC_INFORMATION19 ,'||
620: '''' || per_ri_config_utilities.get_location_prompt(l_style,'LOC_INFORMATION19')||''''||' LOC_INFORMATION19_PROMPT ,'||
621: '''' || nvl(replace(p_location_tab(i).loc_information20,'''',''''''),' ')||''''||' LOC_INFORMATION20 ,'||
622: '''' || per_ri_config_utilities.get_location_prompt(l_style,'LOC_INFORMATION20')||''''||' LOC_INFORMATION20_PROMPT '||
623: ' FROM DUAL UNION';
624:

Line 622: '''' || per_ri_config_utilities.get_location_prompt(l_style,'LOC_INFORMATION20')||''''||' LOC_INFORMATION20_PROMPT '||

618: '''' || per_ri_config_utilities.get_location_prompt(l_style,'LOC_INFORMATION18')||''''||' LOC_INFORMATION18_PROMPT ,'||
619: '''' || nvl(replace(p_location_tab(i).loc_information19,'''',''''''),' ')||''''||' LOC_INFORMATION19 ,'||
620: '''' || per_ri_config_utilities.get_location_prompt(l_style,'LOC_INFORMATION19')||''''||' LOC_INFORMATION19_PROMPT ,'||
621: '''' || nvl(replace(p_location_tab(i).loc_information20,'''',''''''),' ')||''''||' LOC_INFORMATION20 ,'||
622: '''' || per_ri_config_utilities.get_location_prompt(l_style,'LOC_INFORMATION20')||''''||' LOC_INFORMATION20_PROMPT '||
623: ' FROM DUAL UNION';
624:
625: dbms_lob.writeappend(l_location_clob,length(l_temp_sql),l_temp_sql);
626: