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.HRI_PARAMETERS dependencies on HTF

Line 683: params(i).Value := htf.formSelectOpen( 'BPL_ID' );

679:
680: -- Creates Business Plan Parameter
681:
682: params(i).Label := Display_Label('HR_BIS_BUSINESS_PLAN');
683: params(i).Value := htf.formSelectOpen( 'BPL_ID' );
684:
685: for ci_bpl in c_bpl loop
686:
687: params(i).Value := params(i).Value ||

Line 688: htf.formSelectOption(ci_bpl.plan_name,NULL,

684:
685: for ci_bpl in c_bpl loop
686:
687: params(i).Value := params(i).Value ||
688: htf.formSelectOption(ci_bpl.plan_name,NULL,
689: 'VALUE="'||ci_bpl.plan_id||'"');
690: end loop;
691:
692: params(i).Value := params(i).Value || htf.formSelectClose;

Line 692: params(i).Value := params(i).Value || htf.formSelectClose;

688: htf.formSelectOption(ci_bpl.plan_name,NULL,
689: 'VALUE="'||ci_bpl.plan_id||'"');
690: end loop;
691:
692: params(i).Value := params(i).Value || htf.formSelectClose;
693:
694: END Build_Business_Plan;
695:
696: --=========================================================================================

Line 729: params(i).Label := htf.formSelectOpen( 'GEOLVL',NULL, NULL,

725: BEGIN
726:
727: -- Creates Geography Dimension Level Parameter
728:
729: params(i).Label := htf.formSelectOpen( 'GEOLVL',NULL, NULL,
730: 'OnChange="getGeog(document.params.GEOVAL, '||
731: 'document.params.GEOLVL.selectedIndex)" ' );
732:
733: for ci_geog_level in c_geog_level loop

Line 736: htf.formSelectOption(ci_geog_level.lev,NULL,

732:
733: for ci_geog_level in c_geog_level loop
734:
735: params(i).Label := params(i).Label ||
736: htf.formSelectOption(ci_geog_level.lev,NULL,
737: 'VALUE="'||ci_geog_level.lev_code||'"');
738: end loop;
739:
740: params(i).Label := params(i).Label || htf.formSelectClose;

Line 740: params(i).Label := params(i).Label || htf.formSelectClose;

736: htf.formSelectOption(ci_geog_level.lev,NULL,
737: 'VALUE="'||ci_geog_level.lev_code||'"');
738: end loop;
739:
740: params(i).Label := params(i).Label || htf.formSelectClose;
741:
742: END Build_Geog_Level;
743:
744: --=========================================================================================

Line 755: params(i).Value := htf.formSelectOpen( 'GEOVAL' );

751: BEGIN
752:
753: -- Creates Geography Dimension Value Parameter
754:
755: params(i).Value := htf.formSelectOpen( 'GEOVAL' );
756:
757: for ci_area in c_area loop
758:
759: params(i).Value := params(i).Value ||

Line 760: htf.formSelectOption(ci_area.area,NULL,

756:
757: for ci_area in c_area loop
758:
759: params(i).Value := params(i).Value ||
760: htf.formSelectOption(ci_area.area,NULL,
761: 'VALUE="'||ci_area.area_code||'"');
762: end loop;
763:
764: params(i).Value := params(i).Value || htf.formSelectClose;

Line 764: params(i).Value := params(i).Value || htf.formSelectClose;

760: htf.formSelectOption(ci_area.area,NULL,
761: 'VALUE="'||ci_area.area_code||'"');
762: end loop;
763:
764: params(i).Value := params(i).Value || htf.formSelectClose;
765:
766: END Build_Geog_Value;
767:
768: --=========================================================================================

Line 789: params(i).Value := htf.formSelectOpen( 'PRODID' );

785: BEGIN
786:
787: -- Create Product Category parameter
788: params(i).Label := Display_Label('HR_BIS_PRODUCT_CATEGORY');
789: params(i).Value := htf.formSelectOpen( 'PRODID' );
790:
791: for ci_product_category in c_product_category loop
792:
793: params(i).Value := params(i).Value ||

Line 794: htf.formSelectOption(ci_product_category.value,NULL,

790:
791: for ci_product_category in c_product_category loop
792:
793: params(i).Value := params(i).Value ||
794: htf.formSelectOption(ci_product_category.value,NULL,
795: 'VALUE="'||ci_product_category.id||'"');
796: end loop;
797:
798: params(i).Value := params(i).Value || htf.formSelectClose;

Line 798: params(i).Value := params(i).Value || htf.formSelectClose;

794: htf.formSelectOption(ci_product_category.value,NULL,
795: 'VALUE="'||ci_product_category.id||'"');
796: end loop;
797:
798: params(i).Value := params(i).Value || htf.formSelectClose;
799:
800: END Build_Product;
801:
802: --=========================================================================================

Line 825: params(i).Value := htf.formSelectOpen( 'JOBCAT' );

821: -- This procedure creates the Job Category parameter
822:
823: IF p_option = 0 THEN
824: params(i).Label := Display_Label('HR_BIS_JOB_CATEGORY');
825: params(i).Value := htf.formSelectOpen( 'JOBCAT' );
826: params(i).Value := params(i).Value ||
827: htf.formSelectOption(' ',NULL, 'VALUE="__ALL__"');
828:
829: for ci_job_category in c_job_category loop

Line 827: htf.formSelectOption(' ',NULL, 'VALUE="ALL"');

823: IF p_option = 0 THEN
824: params(i).Label := Display_Label('HR_BIS_JOB_CATEGORY');
825: params(i).Value := htf.formSelectOpen( 'JOBCAT' );
826: params(i).Value := params(i).Value ||
827: htf.formSelectOption(' ',NULL, 'VALUE="__ALL__"');
828:
829: for ci_job_category in c_job_category loop
830: params(i).Value := params(i).Value ||
831: htf.formSelectOption(ci_job_category.meaning,NULL,

Line 831: htf.formSelectOption(ci_job_category.meaning,NULL,

827: htf.formSelectOption(' ',NULL, 'VALUE="__ALL__"');
828:
829: for ci_job_category in c_job_category loop
830: params(i).Value := params(i).Value ||
831: htf.formSelectOption(ci_job_category.meaning,NULL,
832: 'VALUE="'||ci_job_category.lookup_code||'"');
833: end loop;
834:
835: params(i).Value := params(i).Value || htf.formSelectClose;

Line 835: params(i).Value := params(i).Value || htf.formSelectClose;

831: htf.formSelectOption(ci_job_category.meaning,NULL,
832: 'VALUE="'||ci_job_category.lookup_code||'"');
833: end loop;
834:
835: params(i).Value := params(i).Value || htf.formSelectClose;
836: ELSE
837: params(i).Label := Display_Label('HR_BIS_JOB_CATEGORY1');
838: params(i).Value := htf.formSelectOpen( 'JOBCAT1' );
839: for ci_job_category in c_job_category loop

Line 838: params(i).Value := htf.formSelectOpen( 'JOBCAT1' );

834:
835: params(i).Value := params(i).Value || htf.formSelectClose;
836: ELSE
837: params(i).Label := Display_Label('HR_BIS_JOB_CATEGORY1');
838: params(i).Value := htf.formSelectOpen( 'JOBCAT1' );
839: for ci_job_category in c_job_category loop
840: params(i).Value := params(i).Value ||
841: htf.formSelectOption(ci_job_category.meaning,NULL,
842: 'VALUE="'||ci_job_category.lookup_code||'"');

Line 841: htf.formSelectOption(ci_job_category.meaning,NULL,

837: params(i).Label := Display_Label('HR_BIS_JOB_CATEGORY1');
838: params(i).Value := htf.formSelectOpen( 'JOBCAT1' );
839: for ci_job_category in c_job_category loop
840: params(i).Value := params(i).Value ||
841: htf.formSelectOption(ci_job_category.meaning,NULL,
842: 'VALUE="'||ci_job_category.lookup_code||'"');
843: end loop;
844: params(i).Value := params(i).Value || htf.formSelectClose;
845: i := i + 1;

Line 844: params(i).Value := params(i).Value || htf.formSelectClose;

840: params(i).Value := params(i).Value ||
841: htf.formSelectOption(ci_job_category.meaning,NULL,
842: 'VALUE="'||ci_job_category.lookup_code||'"');
843: end loop;
844: params(i).Value := params(i).Value || htf.formSelectClose;
845: i := i + 1;
846:
847: params(i).Label := Display_Label('HR_BIS_JOB_CATEGORY2');
848: params(i).Value := htf.formSelectOpen( 'JOBCAT2' );

Line 848: params(i).Value := htf.formSelectOpen( 'JOBCAT2' );

844: params(i).Value := params(i).Value || htf.formSelectClose;
845: i := i + 1;
846:
847: params(i).Label := Display_Label('HR_BIS_JOB_CATEGORY2');
848: params(i).Value := htf.formSelectOpen( 'JOBCAT2' );
849: params(i).Value := params(i).Value ||
850: htf.formSelectOption(' ',NULL, 'VALUE="__ALL__"');
851: for ci_job_category in c_job_category loop
852: params(i).Value := params(i).Value ||

Line 850: htf.formSelectOption(' ',NULL, 'VALUE="ALL"');

846:
847: params(i).Label := Display_Label('HR_BIS_JOB_CATEGORY2');
848: params(i).Value := htf.formSelectOpen( 'JOBCAT2' );
849: params(i).Value := params(i).Value ||
850: htf.formSelectOption(' ',NULL, 'VALUE="__ALL__"');
851: for ci_job_category in c_job_category loop
852: params(i).Value := params(i).Value ||
853: htf.formSelectOption(ci_job_category.meaning,NULL,
854: 'VALUE="'||ci_job_category.lookup_code||'"');

Line 853: htf.formSelectOption(ci_job_category.meaning,NULL,

849: params(i).Value := params(i).Value ||
850: htf.formSelectOption(' ',NULL, 'VALUE="__ALL__"');
851: for ci_job_category in c_job_category loop
852: params(i).Value := params(i).Value ||
853: htf.formSelectOption(ci_job_category.meaning,NULL,
854: 'VALUE="'||ci_job_category.lookup_code||'"');
855: end loop;
856: params(i).Value := params(i).Value || htf.formSelectClose;
857: i := i + 1;

Line 856: params(i).Value := params(i).Value || htf.formSelectClose;

852: params(i).Value := params(i).Value ||
853: htf.formSelectOption(ci_job_category.meaning,NULL,
854: 'VALUE="'||ci_job_category.lookup_code||'"');
855: end loop;
856: params(i).Value := params(i).Value || htf.formSelectClose;
857: i := i + 1;
858:
859: params(i).Label := Display_Label('HR_BIS_JOB_CATEGORY3');
860: params(i).Value := htf.formSelectOpen( 'JOBCAT3' );

Line 860: params(i).Value := htf.formSelectOpen( 'JOBCAT3' );

856: params(i).Value := params(i).Value || htf.formSelectClose;
857: i := i + 1;
858:
859: params(i).Label := Display_Label('HR_BIS_JOB_CATEGORY3');
860: params(i).Value := htf.formSelectOpen( 'JOBCAT3' );
861: params(i).Value := params(i).Value ||
862: htf.formSelectOption(' ',NULL, 'VALUE="__ALL__"');
863: for ci_job_category in c_job_category loop
864: params(i).Value := params(i).Value ||

Line 862: htf.formSelectOption(' ',NULL, 'VALUE="ALL"');

858:
859: params(i).Label := Display_Label('HR_BIS_JOB_CATEGORY3');
860: params(i).Value := htf.formSelectOpen( 'JOBCAT3' );
861: params(i).Value := params(i).Value ||
862: htf.formSelectOption(' ',NULL, 'VALUE="__ALL__"');
863: for ci_job_category in c_job_category loop
864: params(i).Value := params(i).Value ||
865: htf.formSelectOption(ci_job_category.meaning,NULL,
866: 'VALUE="'||ci_job_category.lookup_code||'"');

Line 865: htf.formSelectOption(ci_job_category.meaning,NULL,

861: params(i).Value := params(i).Value ||
862: htf.formSelectOption(' ',NULL, 'VALUE="__ALL__"');
863: for ci_job_category in c_job_category loop
864: params(i).Value := params(i).Value ||
865: htf.formSelectOption(ci_job_category.meaning,NULL,
866: 'VALUE="'||ci_job_category.lookup_code||'"');
867: end loop;
868: params(i).Value := params(i).Value || htf.formSelectClose;
869:

Line 868: params(i).Value := params(i).Value || htf.formSelectClose;

864: params(i).Value := params(i).Value ||
865: htf.formSelectOption(ci_job_category.meaning,NULL,
866: 'VALUE="'||ci_job_category.lookup_code||'"');
867: end loop;
868: params(i).Value := params(i).Value || htf.formSelectClose;
869:
870: END IF;
871:
872: END Build_Job_Category;

Line 899: params(i).Value := htf.formSelectOpen( 'BGT_ID' );

895: BEGIN
896:
897: -- This procedure creates the Budget parameter
898: params(i).Label := Display_Label('HR_BIS_BUDGET');
899: params(i).Value := htf.formSelectOpen( 'BGT_ID' );
900:
901: for ci_bgt_id in c_bgt_id loop
902:
903: params(i).Value := params(i).Value ||

Line 904: htf.formSelectOption(ci_bgt_id.budget_name, NULL,

900:
901: for ci_bgt_id in c_bgt_id loop
902:
903: params(i).Value := params(i).Value ||
904: htf.formSelectOption(ci_bgt_id.budget_name, NULL,
905: 'VALUE="'||ci_bgt_id.budget_id||'"');
906:
907: l_budget_id_count := l_budget_id_count+1;
908:

Line 911: params(i).Value := params(i).Value || htf.formSelectClose;

907: l_budget_id_count := l_budget_id_count+1;
908:
909: end loop;
910:
911: params(i).Value := params(i).Value || htf.formSelectClose;
912:
913: IF l_budget_id_count = 0 THEN
914: p_return_status := 0; -- error, no budget set up
915: ELSE

Line 943: params(i).Value := htf.formSelectOpen( 'BGT_ID' );

939:
940: -- This procedure creates the Budget Measurement Type parameter
941:
942: params(i).Label := Display_Label('HR_BIS_BUDGET');
943: params(i).Value := htf.formSelectOpen( 'BGT_ID' );
944:
945: for ci_bgt_id in c_bgt_id loop
946:
947: params(i).Value := params(i).Value ||

Line 948: htf.formSelectOption(ci_bgt_id.name, NULL,

944:
945: for ci_bgt_id in c_bgt_id loop
946:
947: params(i).Value := params(i).Value ||
948: htf.formSelectOption(ci_bgt_id.name, NULL,
949: 'VALUE="'||ci_bgt_id.budget_id||'"');
950:
951: l_budget_id_count := l_budget_id_count+1;
952:

Line 955: params(i).Value := params(i).Value || htf.formSelectClose;

951: l_budget_id_count := l_budget_id_count+1;
952:
953: end loop;
954:
955: params(i).Value := params(i).Value || htf.formSelectClose;
956:
957: IF l_budget_id_count = 0 THEN
958: p_return_status := 0; -- error, no budget set up
959: ELSE

Line 985: params(i).Value := htf.formSelectOpen( 'FRQNCY' );

981:
982: -- This procedure creates the Frequency Parameter
983:
984: params(i).Label := Display_Label('HR_BIS_FREQUENCY');
985: params(i).Value := htf.formSelectOpen( 'FRQNCY' );
986:
987: for ci_frequency in c_frequency loop
988:
989: params(i).Value := params(i).Value ||

Line 990: htf.formSelectOption(ci_frequency.meaning, NULL,

986:
987: for ci_frequency in c_frequency loop
988:
989: params(i).Value := params(i).Value ||
990: htf.formSelectOption(ci_frequency.meaning, NULL,
991: 'VALUE="'||ci_frequency.lookup_code||'"');
992: end loop;
993:
994: params(i).Value := params(i).Value || htf.formSelectClose;

Line 994: params(i).Value := params(i).Value || htf.formSelectClose;

990: htf.formSelectOption(ci_frequency.meaning, NULL,
991: 'VALUE="'||ci_frequency.lookup_code||'"');
992: end loop;
993:
994: params(i).Value := params(i).Value || htf.formSelectClose;
995:
996: END Build_Frequency;
997:
998: --=========================================================================================

Line 1112: params(i).Value := htf.formSelectOpen('BGT_ID');

1108:
1109: BEGIN
1110:
1111: params(i).Label := Display_Label('HR_BIS_BUDGET');
1112: params(i).Value := htf.formSelectOpen('BGT_ID');
1113:
1114: for ci_bgt_id in c_bgt_id loop
1115: params(i).Value := params(i).Value ||
1116: htf.formSelectOption(ci_bgt_id.name, NULL,

Line 1116: htf.formSelectOption(ci_bgt_id.name, NULL,

1112: params(i).Value := htf.formSelectOpen('BGT_ID');
1113:
1114: for ci_bgt_id in c_bgt_id loop
1115: params(i).Value := params(i).Value ||
1116: htf.formSelectOption(ci_bgt_id.name, NULL,
1117: 'VALUE="'||ci_bgt_id.budget_id||'"');
1118:
1119:
1120: end loop;

Line 1122: params(i).Value := params(i).Value || htf.formSelectClose;

1118:
1119:
1120: end loop;
1121:
1122: params(i).Value := params(i).Value || htf.formSelectClose;
1123:
1124:
1125: END Build_Budget_ID;
1126:

Line 1153: params(i).Value := htf.formSelectOpen('COMPID');

1149: BEGIN
1150:
1151: params(i).Label := Display_Label('HR_BIS_COMPETENCE');
1152:
1153: params(i).Value := htf.formSelectOpen('COMPID');
1154:
1155: for ci_compid in c_compid loop
1156: params(i).Value := params(i).Value ||
1157: htf.formSelectOption(ci_compid.name, NULL,

Line 1157: htf.formSelectOption(ci_compid.name, NULL,

1153: params(i).Value := htf.formSelectOpen('COMPID');
1154:
1155: for ci_compid in c_compid loop
1156: params(i).Value := params(i).Value ||
1157: htf.formSelectOption(ci_compid.name, NULL,
1158: 'VALUE="'||ci_compid.competence_id||'"');
1159:
1160: l_comp_id_count := l_comp_id_count+1;
1161:

Line 1164: params(i).Value := params(i).Value || htf.formSelectClose;

1160: l_comp_id_count := l_comp_id_count+1;
1161:
1162: end loop;
1163:
1164: params(i).Value := params(i).Value || htf.formSelectClose;
1165:
1166: IF l_comp_id_count = 0 THEN
1167: p_return_status := 0; -- error, no competencies set up
1168: ELSE

Line 1198: params(i).Value := htf.formSelectOpen('CURRCD');

1194: BEGIN
1195:
1196: params(i).Label := Display_Label('HR_BIS_REPORT_CURRENCY');
1197:
1198: params(i).Value := htf.formSelectOpen('CURRCD');
1199:
1200: for ci_currcd in c_currcd loop
1201: params(i).Value := params(i).Value ||
1202: htf.formSelectOption(ci_currcd.currency_code||' - '||ci_currcd.name, NULL,

Line 1202: htf.formSelectOption(ci_currcd.currency_code||' - '||ci_currcd.name, NULL,

1198: params(i).Value := htf.formSelectOpen('CURRCD');
1199:
1200: for ci_currcd in c_currcd loop
1201: params(i).Value := params(i).Value ||
1202: htf.formSelectOption(ci_currcd.currency_code||' - '||ci_currcd.name, NULL,
1203: 'VALUE="'||ci_currcd.currency_code||'"');
1204: end loop;
1205:
1206: params(i).Value := params(i).Value || htf.formSelectClose;

Line 1206: params(i).Value := params(i).Value || htf.formSelectClose;

1202: htf.formSelectOption(ci_currcd.currency_code||' - '||ci_currcd.name, NULL,
1203: 'VALUE="'||ci_currcd.currency_code||'"');
1204: end loop;
1205:
1206: params(i).Value := params(i).Value || htf.formSelectClose;
1207:
1208: END Build_Report_Currency;
1209:
1210: --=========================================================================================

Line 1232: params(i).Value := htf.formSelectOpen('DISPLY');

1228:
1229: -- Parameter Request String : DISPLY
1230:
1231: params(i).Label := Display_Label('HR_BIS_DISPLAY');
1232: params(i).Value := htf.formSelectOpen('DISPLY');
1233: params(i).Value := params(i).Value || htf.formSelectOption(fnd_message.get_string( 'HRI' ,'HR_BIS_TOP'), NULL, 'VALUE="'||'HR_BIS_TOP'||'"');
1234: params(i).Value := params(i).Value || htf.formSelectOption(fnd_message.get_string( 'HRI' ,'HR_BIS_BOTTOM'), NULL, 'VALUE="'||'HR_BIS_BOTTOM'||'"');
1235:
1236: params(i).Value := params(i).Value || htf.formSelectClose;

Line 1233: params(i).Value := params(i).Value || htf.formSelectOption(fnd_message.get_string( 'HRI' ,'HR_BIS_TOP'), NULL, 'VALUE="'||'HR_BIS_TOP'||'"');

1229: -- Parameter Request String : DISPLY
1230:
1231: params(i).Label := Display_Label('HR_BIS_DISPLAY');
1232: params(i).Value := htf.formSelectOpen('DISPLY');
1233: params(i).Value := params(i).Value || htf.formSelectOption(fnd_message.get_string( 'HRI' ,'HR_BIS_TOP'), NULL, 'VALUE="'||'HR_BIS_TOP'||'"');
1234: params(i).Value := params(i).Value || htf.formSelectOption(fnd_message.get_string( 'HRI' ,'HR_BIS_BOTTOM'), NULL, 'VALUE="'||'HR_BIS_BOTTOM'||'"');
1235:
1236: params(i).Value := params(i).Value || htf.formSelectClose;
1237:

Line 1234: params(i).Value := params(i).Value || htf.formSelectOption(fnd_message.get_string( 'HRI' ,'HR_BIS_BOTTOM'), NULL, 'VALUE="'||'HR_BIS_BOTTOM'||'"');

1230:
1231: params(i).Label := Display_Label('HR_BIS_DISPLAY');
1232: params(i).Value := htf.formSelectOpen('DISPLY');
1233: params(i).Value := params(i).Value || htf.formSelectOption(fnd_message.get_string( 'HRI' ,'HR_BIS_TOP'), NULL, 'VALUE="'||'HR_BIS_TOP'||'"');
1234: params(i).Value := params(i).Value || htf.formSelectOption(fnd_message.get_string( 'HRI' ,'HR_BIS_BOTTOM'), NULL, 'VALUE="'||'HR_BIS_BOTTOM'||'"');
1235:
1236: params(i).Value := params(i).Value || htf.formSelectClose;
1237:
1238: params(i).Value := params(i).Value || htf.formSelectOpen('DCOUNT');

Line 1236: params(i).Value := params(i).Value || htf.formSelectClose;

1232: params(i).Value := htf.formSelectOpen('DISPLY');
1233: params(i).Value := params(i).Value || htf.formSelectOption(fnd_message.get_string( 'HRI' ,'HR_BIS_TOP'), NULL, 'VALUE="'||'HR_BIS_TOP'||'"');
1234: params(i).Value := params(i).Value || htf.formSelectOption(fnd_message.get_string( 'HRI' ,'HR_BIS_BOTTOM'), NULL, 'VALUE="'||'HR_BIS_BOTTOM'||'"');
1235:
1236: params(i).Value := params(i).Value || htf.formSelectClose;
1237:
1238: params(i).Value := params(i).Value || htf.formSelectOpen('DCOUNT');
1239:
1240: inc_amt := 1;

Line 1238: params(i).Value := params(i).Value || htf.formSelectOpen('DCOUNT');

1234: params(i).Value := params(i).Value || htf.formSelectOption(fnd_message.get_string( 'HRI' ,'HR_BIS_BOTTOM'), NULL, 'VALUE="'||'HR_BIS_BOTTOM'||'"');
1235:
1236: params(i).Value := params(i).Value || htf.formSelectClose;
1237:
1238: params(i).Value := params(i).Value || htf.formSelectOpen('DCOUNT');
1239:
1240: inc_amt := 1;
1241: for inc_val IN 1 .. 9
1242: LOOP

Line 1243: params(i).Value := params(i).Value || htf.formSelectOption(inc_val, NULL, 'VALUE="'||inc_val||'"');

1239:
1240: inc_amt := 1;
1241: for inc_val IN 1 .. 9
1242: LOOP
1243: params(i).Value := params(i).Value || htf.formSelectOption(inc_val, NULL, 'VALUE="'||inc_val||'"');
1244: END LOOP;
1245:
1246: params(i).Value := params(i).Value || htf.formSelectOption(10, 'Yes', 'VALUE="10"');
1247:

Line 1246: params(i).Value := params(i).Value || htf.formSelectOption(10, 'Yes', 'VALUE="10"');

1242: LOOP
1243: params(i).Value := params(i).Value || htf.formSelectOption(inc_val, NULL, 'VALUE="'||inc_val||'"');
1244: END LOOP;
1245:
1246: params(i).Value := params(i).Value || htf.formSelectOption(10, 'Yes', 'VALUE="10"');
1247:
1248: for inc_val IN 11.. 30
1249: LOOP
1250: params(i).Value := params(i).Value || htf.formSelectOption(inc_val, NULL, 'VALUE="'||inc_val||'"');

Line 1250: params(i).Value := params(i).Value || htf.formSelectOption(inc_val, NULL, 'VALUE="'||inc_val||'"');

1246: params(i).Value := params(i).Value || htf.formSelectOption(10, 'Yes', 'VALUE="10"');
1247:
1248: for inc_val IN 11.. 30
1249: LOOP
1250: params(i).Value := params(i).Value || htf.formSelectOption(inc_val, NULL, 'VALUE="'||inc_val||'"');
1251: END LOOP;
1252: inc_amt := 2;
1253:
1254: for inc_val IN 16 .. 24

Line 1256: params(i).Value := params(i).Value || htf.formSelectOption(inc_amtinc_val, NULL, 'VALUE="'||inc_amtinc_val||'"');

1252: inc_amt := 2;
1253:
1254: for inc_val IN 16 .. 24
1255: LOOP
1256: params(i).Value := params(i).Value || htf.formSelectOption(inc_amt*inc_val, NULL, 'VALUE="'||inc_amt*inc_val||'"');
1257: END LOOP;
1258:
1259: inc_amt := 5;
1260:

Line 1263: params(i).Value := params(i).Value || htf.formSelectOption(inc_amtinc_val, NULL, 'VALUE="'||inc_amtinc_val||'"');

1259: inc_amt := 5;
1260:
1261: for inc_val IN 10 .. 19
1262: LOOP
1263: params(i).Value := params(i).Value || htf.formSelectOption(inc_amt*inc_val, NULL, 'VALUE="'||inc_amt*inc_val||'"');
1264: END LOOP;
1265:
1266: params(i).Value := params(i).Value || htf.formSelectOption('99', NULL, 'VALUE="99"');
1267:

Line 1266: params(i).Value := params(i).Value || htf.formSelectOption('99', NULL, 'VALUE="99"');

1262: LOOP
1263: params(i).Value := params(i).Value || htf.formSelectOption(inc_amt*inc_val, NULL, 'VALUE="'||inc_amt*inc_val||'"');
1264: END LOOP;
1265:
1266: params(i).Value := params(i).Value || htf.formSelectOption('99', NULL, 'VALUE="99"');
1267:
1268: params(i).Value := params(i).Value || htf.formSelectClose;
1269:
1270: END Build_Display_by;

Line 1268: params(i).Value := params(i).Value || htf.formSelectClose;

1264: END LOOP;
1265:
1266: params(i).Value := params(i).Value || htf.formSelectOption('99', NULL, 'VALUE="99"');
1267:
1268: params(i).Value := params(i).Value || htf.formSelectClose;
1269:
1270: END Build_Display_by;
1271:
1272: --=========================================================================================

Line 1294: params(i).Value := htf.formSelectOpen('EXCCUR');

1290:
1291: BEGIN
1292:
1293: params(i).Label := Display_Label('HR_BIS_OTHER_CURRENCIES');
1294: params(i).Value := htf.formSelectOpen('EXCCUR');
1295:
1296: for ci_exccur in c_exccur loop
1297: params(i).Value := params(i).Value ||
1298: htf.formSelectOption(ci_exccur.message_text, NULL,

Line 1298: htf.formSelectOption(ci_exccur.message_text, NULL,

1294: params(i).Value := htf.formSelectOpen('EXCCUR');
1295:
1296: for ci_exccur in c_exccur loop
1297: params(i).Value := params(i).Value ||
1298: htf.formSelectOption(ci_exccur.message_text, NULL,
1299: 'VALUE="'||ci_exccur.message_name||'"');
1300: end loop;
1301:
1302: params(i).Value := params(i).Value || htf.formSelectClose;

Line 1302: params(i).Value := params(i).Value || htf.formSelectClose;

1298: htf.formSelectOption(ci_exccur.message_text, NULL,
1299: 'VALUE="'||ci_exccur.message_name||'"');
1300: end loop;
1301:
1302: params(i).Value := params(i).Value || htf.formSelectClose;
1303:
1304: END Build_Exclude_Currency;
1305:
1306: --=========================================================================================

Line 1330: params(i).Value := htf.formSelectOpen('GRD_ID');

1326:
1327: BEGIN
1328:
1329: params(i).Label := Display_Label('HR_BIS_GRADE');
1330: params(i).Value := htf.formSelectOpen('GRD_ID');
1331: params(i).Value := params(i).Value || htf.formSelectOption(' ', NULL, 'VALUE="-1"');
1332:
1333: for ci_grd_id in c_grd_id loop
1334: params(i).Value := params(i).Value ||

Line 1331: params(i).Value := params(i).Value || htf.formSelectOption(' ', NULL, 'VALUE="-1"');

1327: BEGIN
1328:
1329: params(i).Label := Display_Label('HR_BIS_GRADE');
1330: params(i).Value := htf.formSelectOpen('GRD_ID');
1331: params(i).Value := params(i).Value || htf.formSelectOption(' ', NULL, 'VALUE="-1"');
1332:
1333: for ci_grd_id in c_grd_id loop
1334: params(i).Value := params(i).Value ||
1335: htf.formSelectOption(ci_grd_id.name, NULL,

Line 1335: htf.formSelectOption(ci_grd_id.name, NULL,

1331: params(i).Value := params(i).Value || htf.formSelectOption(' ', NULL, 'VALUE="-1"');
1332:
1333: for ci_grd_id in c_grd_id loop
1334: params(i).Value := params(i).Value ||
1335: htf.formSelectOption(ci_grd_id.name, NULL,
1336: 'VALUE="'||ci_grd_id.grade_id||'"');
1337: end loop;
1338:
1339: params(i).Value := params(i).Value || htf.formSelectClose;

Line 1339: params(i).Value := params(i).Value || htf.formSelectClose;

1335: htf.formSelectOption(ci_grd_id.name, NULL,
1336: 'VALUE="'||ci_grd_id.grade_id||'"');
1337: end loop;
1338:
1339: params(i).Value := params(i).Value || htf.formSelectClose;
1340:
1341: END Build_Grade_ID;
1342: */
1343: --=========================================================================================

Line 1356: params(i).Value := htf.formSelectOpen('EMPAPL');

1352:
1353: BEGIN
1354:
1355: params(i).Label := Display_Label('HR_BIS_EMP_APP');
1356: params(i).Value := htf.formSelectOpen('EMPAPL');
1357: params(i).Value := params(i).Value
1358: || htf.formSelectOption(fnd_message.get_string( 'HRI' ,'HR_BIS_CURRENT_EMPL_IN_JOB'),
1359: NULL,
1360: 'VALUE="E"');

Line 1358: || htf.formSelectOption(fnd_message.get_string( 'HRI' ,'HR_BIS_CURRENT_EMPL_IN_JOB'),

1354:
1355: params(i).Label := Display_Label('HR_BIS_EMP_APP');
1356: params(i).Value := htf.formSelectOpen('EMPAPL');
1357: params(i).Value := params(i).Value
1358: || htf.formSelectOption(fnd_message.get_string( 'HRI' ,'HR_BIS_CURRENT_EMPL_IN_JOB'),
1359: NULL,
1360: 'VALUE="E"');
1361: params(i).Value := params(i).Value
1362: || htf.formSelectOption(fnd_message.get_string( 'HRI' ,'HR_BIS_CURRENT_APPL_FOR_JOB'),

Line 1362: || htf.formSelectOption(fnd_message.get_string( 'HRI' ,'HR_BIS_CURRENT_APPL_FOR_JOB'),

1358: || htf.formSelectOption(fnd_message.get_string( 'HRI' ,'HR_BIS_CURRENT_EMPL_IN_JOB'),
1359: NULL,
1360: 'VALUE="E"');
1361: params(i).Value := params(i).Value
1362: || htf.formSelectOption(fnd_message.get_string( 'HRI' ,'HR_BIS_CURRENT_APPL_FOR_JOB'),
1363: NULL,
1364: 'VALUE="A"');
1365:
1366: params(i).Value := params(i).Value || htf.formSelectClose;

Line 1366: params(i).Value := params(i).Value || htf.formSelectClose;

1362: || htf.formSelectOption(fnd_message.get_string( 'HRI' ,'HR_BIS_CURRENT_APPL_FOR_JOB'),
1363: NULL,
1364: 'VALUE="A"');
1365:
1366: params(i).Value := params(i).Value || htf.formSelectClose;
1367:
1368: END Build_Employee_Applicant;
1369:
1370: --=========================================================================================

Line 1388: params(i).Value := htf.formSelectOpen('ORDERB');

1384:
1385: BEGIN
1386:
1387: params(i).Label := Display_Label('HR_BIS_ORDER_BY');
1388: params(i).Value := htf.formSelectOpen('ORDERB');
1389:
1390: IF p_option = 1
1391: THEN
1392: params(i).Value := params(i).Value ||

Line 1393: htf.formSelectOption(fnd_message.get_string('HRI' ,'HR_BIS_TOTAL')

1389:
1390: IF p_option = 1
1391: THEN
1392: params(i).Value := params(i).Value ||
1393: htf.formSelectOption(fnd_message.get_string('HRI' ,'HR_BIS_TOTAL')
1394: || ' ' || fnd_message.get_string('HRI', 'HR_BIS_SEPARATED'),
1395: NULL, 'VALUE="HR_BIS_TOTAL"');
1396: params(i).Value := params(i).Value ||
1397: htf.formSelectOption(fnd_message.get_string('HRI', 'HR_BIS_PERCENT')

Line 1397: htf.formSelectOption(fnd_message.get_string('HRI', 'HR_BIS_PERCENT')

1393: htf.formSelectOption(fnd_message.get_string('HRI' ,'HR_BIS_TOTAL')
1394: || ' ' || fnd_message.get_string('HRI', 'HR_BIS_SEPARATED'),
1395: NULL, 'VALUE="HR_BIS_TOTAL"');
1396: params(i).Value := params(i).Value ||
1397: htf.formSelectOption(fnd_message.get_string('HRI', 'HR_BIS_PERCENT')
1398: || ' ' || fnd_message.get_string('HRI', 'HR_BIS_SEPARATED'),
1399: NULL, 'VALUE="HR_BIS_PERCENT"');
1400: ELSIF p_option = 2
1401: THEN

Line 1403: htf.formSelectOption(fnd_message.get_string('HRI', 'HR_BIS_PERCENT')

1399: NULL, 'VALUE="HR_BIS_PERCENT"');
1400: ELSIF p_option = 2
1401: THEN
1402: params(i).Value := params(i).Value ||
1403: htf.formSelectOption(fnd_message.get_string('HRI', 'HR_BIS_PERCENT')
1404: || ' ' || fnd_message.get_string('HRI', 'HR_BIS_INCREASE'),
1405: NULL, 'VALUE="HR_BIS_PERCENT"');
1406: params(i).Value := params(i).Value ||
1407: htf.formSelectOption(fnd_message.get_string('HRI' ,'HR_BIS_TOTAL')

Line 1407: htf.formSelectOption(fnd_message.get_string('HRI' ,'HR_BIS_TOTAL')

1403: htf.formSelectOption(fnd_message.get_string('HRI', 'HR_BIS_PERCENT')
1404: || ' ' || fnd_message.get_string('HRI', 'HR_BIS_INCREASE'),
1405: NULL, 'VALUE="HR_BIS_PERCENT"');
1406: params(i).Value := params(i).Value ||
1407: htf.formSelectOption(fnd_message.get_string('HRI' ,'HR_BIS_TOTAL')
1408: || ' ' || fnd_message.get_string('HRI', 'HR_BIS_INCREASE'),
1409: NULL, 'VALUE="HR_BIS_TOTAL"');
1410: END IF;
1411:

Line 1412: params(i).Value := params(i).Value || htf.formSelectClose;

1408: || ' ' || fnd_message.get_string('HRI', 'HR_BIS_INCREASE'),
1409: NULL, 'VALUE="HR_BIS_TOTAL"');
1410: END IF;
1411:
1412: params(i).Value := params(i).Value || htf.formSelectClose;
1413:
1414: END Build_Order_By;
1415:
1416: --=========================================================================================

Line 1456: params(i).Value := htf.formSelectOpen('ORGPRC');

1452: params(i).Label := Display_Label('HR_BIS_ROLLUP_EACH_ORG');
1453: ELSE
1454: params(i).Label := Display_Label('HR_BIS_ROLLUP_ORGANIZATIONS');
1455: END IF;
1456: params(i).Value := htf.formSelectOpen('ORGPRC');
1457:
1458: for ci_lookup in c_lookup loop
1459: IF ci_lookup.lookup_code = 'Y'
1460: THEN

Line 1471: htf.formSelectOption(lookup_yes, NULL, 'VALUE="ISRO"');

1467: if p_option = 1
1468: THEN
1469: -- 'ISRO'-'Y' 'ISNR'-'N'
1470: params(i).Value := params(i).Value ||
1471: htf.formSelectOption(lookup_yes, NULL, 'VALUE="ISRO"');
1472:
1473: -- this one is the default selection, so has 'Yes' instead of NULL for the second parameter.
1474: params(i).Value := params(i).Value ||
1475: htf.formSelectOption(lookup_no, 'Yes', 'VALUE="ISNR"');

Line 1475: htf.formSelectOption(lookup_no, 'Yes', 'VALUE="ISNR"');

1471: htf.formSelectOption(lookup_yes, NULL, 'VALUE="ISRO"');
1472:
1473: -- this one is the default selection, so has 'Yes' instead of NULL for the second parameter.
1474: params(i).Value := params(i).Value ||
1475: htf.formSelectOption(lookup_no, 'Yes', 'VALUE="ISNR"');
1476:
1477: ELSIF p_option = 2
1478: THEN
1479: -- 'ISNR'-'Y' 'SINR'-'N'

Line 1481: htf.formSelectOption(lookup_yes, NULL, 'VALUE="ISNR"');

1477: ELSIF p_option = 2
1478: THEN
1479: -- 'ISNR'-'Y' 'SINR'-'N'
1480: params(i).Value := params(i).Value ||
1481: htf.formSelectOption(lookup_yes, NULL, 'VALUE="ISNR"');
1482: params(i).Value := params(i).Value ||
1483: htf.formSelectOption(lookup_no, NULL, 'VALUE="SINR"');
1484: ELSIF p_option = 3
1485: THEN

Line 1483: htf.formSelectOption(lookup_no, NULL, 'VALUE="SINR"');

1479: -- 'ISNR'-'Y' 'SINR'-'N'
1480: params(i).Value := params(i).Value ||
1481: htf.formSelectOption(lookup_yes, NULL, 'VALUE="ISNR"');
1482: params(i).Value := params(i).Value ||
1483: htf.formSelectOption(lookup_no, NULL, 'VALUE="SINR"');
1484: ELSIF p_option = 3
1485: THEN
1486: -- 'SIRO'-'Y' 'SINR'-'N'
1487: params(i).Value := params(i).Value ||

Line 1488: htf.formSelectOption(lookup_yes, NULL, 'VALUE="SIRO"');

1484: ELSIF p_option = 3
1485: THEN
1486: -- 'SIRO'-'Y' 'SINR'-'N'
1487: params(i).Value := params(i).Value ||
1488: htf.formSelectOption(lookup_yes, NULL, 'VALUE="SIRO"');
1489: params(i).Value := params(i).Value ||
1490: htf.formSelectOption(lookup_no, NULL, 'VALUE="SINR"');
1491: END IF;
1492:

Line 1490: htf.formSelectOption(lookup_no, NULL, 'VALUE="SINR"');

1486: -- 'SIRO'-'Y' 'SINR'-'N'
1487: params(i).Value := params(i).Value ||
1488: htf.formSelectOption(lookup_yes, NULL, 'VALUE="SIRO"');
1489: params(i).Value := params(i).Value ||
1490: htf.formSelectOption(lookup_no, NULL, 'VALUE="SINR"');
1491: END IF;
1492:
1493: params(i).Value := params(i).Value || htf.formSelectClose;
1494:

Line 1493: params(i).Value := params(i).Value || htf.formSelectClose;

1489: params(i).Value := params(i).Value ||
1490: htf.formSelectOption(lookup_no, NULL, 'VALUE="SINR"');
1491: END IF;
1492:
1493: params(i).Value := params(i).Value || htf.formSelectClose;
1494:
1495: END Build_Incl_Subord;
1496:
1497: --=========================================================================================

Line 1522: params(i).Value := htf.formSelectOpen('PAYRLL');

1518:
1519: BEGIN
1520:
1521: params(i).Label := Display_Label('HR_BIS_PAYROLL');
1522: params(i).Value := htf.formSelectOpen('PAYRLL');
1523:
1524: IF p_option = 1 THEN
1525: params(i).Value := params(i).Value || htf.formSelectOption(' ', NULL, 'VALUE="-1"');
1526: END IF;

Line 1525: params(i).Value := params(i).Value || htf.formSelectOption(' ', NULL, 'VALUE="-1"');

1521: params(i).Label := Display_Label('HR_BIS_PAYROLL');
1522: params(i).Value := htf.formSelectOpen('PAYRLL');
1523:
1524: IF p_option = 1 THEN
1525: params(i).Value := params(i).Value || htf.formSelectOption(' ', NULL, 'VALUE="-1"');
1526: END IF;
1527:
1528: for ci_payrll in c_payrll loop
1529: params(i).Value := params(i).Value ||

Line 1530: htf.formSelectOption(ci_payrll.payroll_name, NULL,

1526: END IF;
1527:
1528: for ci_payrll in c_payrll loop
1529: params(i).Value := params(i).Value ||
1530: htf.formSelectOption(ci_payrll.payroll_name, NULL,
1531: 'VALUE="'||ci_payrll.payroll_id||'"');
1532:
1533: l_payroll_id_counter := l_payroll_id_counter +1;
1534:

Line 1537: params(i).Value := params(i).Value || htf.formSelectClose;

1533: l_payroll_id_counter := l_payroll_id_counter +1;
1534:
1535: end loop;
1536:
1537: params(i).Value := params(i).Value || htf.formSelectClose;
1538:
1539: IF l_payroll_id_counter = 0 THEN
1540: p_return_status := 0; -- error, no payrolls set up
1541: ELSE

Line 1563: params(i).Value := htf.formtext('P_REPORT_DATE_V', 11, NULL, to_char(sysdate,'DD-MON-YYYY'));

1559: BEGIN
1560:
1561: If p_option = 1 THEN
1562: params(i).Label := Display_Label('HR_BIS_REPORTING_DATE');
1563: params(i).Value := htf.formtext('P_REPORT_DATE_V', 11, NULL, to_char(sysdate,'DD-MON-YYYY'));
1564: else
1565: params(i).Label := Display_Label('HR_BIS_REPORTING_DATES');
1566:
1567: params(i).Value := htf.formText('P_START_DATE_V',11,NULL, to_char(add_months(sysdate,-12)+1,'DD-MON-YYYY'))

Line 1567: params(i).Value := htf.formText('P_START_DATE_V',11,NULL, to_char(add_months(sysdate,-12)+1,'DD-MON-YYYY'))

1563: params(i).Value := htf.formtext('P_REPORT_DATE_V', 11, NULL, to_char(sysdate,'DD-MON-YYYY'));
1564: else
1565: params(i).Label := Display_Label('HR_BIS_REPORTING_DATES');
1566:
1567: params(i).Value := htf.formText('P_START_DATE_V',11,NULL, to_char(add_months(sysdate,-12)+1,'DD-MON-YYYY'))
1568: ||' - '||
1569: htf.formText('P_END_DATE_V',11,NULL, to_char(sysdate,'DD-MON-YYYY'));
1570: end if;
1571:

Line 1569: htf.formText('P_END_DATE_V',11,NULL, to_char(sysdate,'DD-MON-YYYY'));

1565: params(i).Label := Display_Label('HR_BIS_REPORTING_DATES');
1566:
1567: params(i).Value := htf.formText('P_START_DATE_V',11,NULL, to_char(add_months(sysdate,-12)+1,'DD-MON-YYYY'))
1568: ||' - '||
1569: htf.formText('P_END_DATE_V',11,NULL, to_char(sysdate,'DD-MON-YYYY'));
1570: end if;
1571:
1572: END Build_Rep_Dates;
1573:

Line 1603: params(i).Value := htf.formSelectOpen(P_FORM_NAME);

1599:
1600: BEGIN
1601:
1602: params(i).Label := Display_Label(P_LABEL);
1603: params(i).Value := htf.formSelectOpen(P_FORM_NAME);
1604:
1605: IF P_ALL_OPTION IS NOT NULL THEN
1606: params(i).Value := params(i).Value || htf.formSelectOption(' ', NULL, 'VALUE="' || P_ALL_OPTION || '"');
1607: END IF;

Line 1606: params(i).Value := params(i).Value || htf.formSelectOption(' ', NULL, 'VALUE="' || P_ALL_OPTION || '"');

1602: params(i).Label := Display_Label(P_LABEL);
1603: params(i).Value := htf.formSelectOpen(P_FORM_NAME);
1604:
1605: IF P_ALL_OPTION IS NOT NULL THEN
1606: params(i).Value := params(i).Value || htf.formSelectOption(' ', NULL, 'VALUE="' || P_ALL_OPTION || '"');
1607: END IF;
1608:
1609: for ci_lookup in c_lookup(P_LOOKUP_TYPE) loop
1610: params(i).Value := params(i).Value ||

Line 1611: htf.formSelectOption(ci_lookup.meaning, NULL,

1607: END IF;
1608:
1609: for ci_lookup in c_lookup(P_LOOKUP_TYPE) loop
1610: params(i).Value := params(i).Value ||
1611: htf.formSelectOption(ci_lookup.meaning, NULL,
1612: 'VALUE="'||ci_lookup.lookup_code||'"');
1613: end loop;
1614:
1615: params(i).Value := params(i).Value || htf.formSelectClose;

Line 1615: params(i).Value := params(i).Value || htf.formSelectClose;

1611: htf.formSelectOption(ci_lookup.meaning, NULL,
1612: 'VALUE="'||ci_lookup.lookup_code||'"');
1613: end loop;
1614:
1615: params(i).Value := params(i).Value || htf.formSelectClose;
1616:
1617: END Build_lookup_param;
1618:
1619: --=========================================================================================

Line 1634: params(i).Value := htf.formSelectOpen('PFMEAS');

1630:
1631: BEGIN
1632:
1633: params(i).Label := Display_Label('HR_BIS_PROFICIENCY_LEVEL');
1634: params(i).Value := htf.formSelectOpen('PFMEAS');
1635: params(i).Value := params(i).Value ||
1636: htf.formSelectOption(fnd_message.get_string('HRI','HR_BIS_MINIMUM_PROFICIENCY'),
1637: NULL,
1638: 'VALUE="M"');

Line 1636: htf.formSelectOption(fnd_message.get_string('HRI','HR_BIS_MINIMUM_PROFICIENCY'),

1632:
1633: params(i).Label := Display_Label('HR_BIS_PROFICIENCY_LEVEL');
1634: params(i).Value := htf.formSelectOpen('PFMEAS');
1635: params(i).Value := params(i).Value ||
1636: htf.formSelectOption(fnd_message.get_string('HRI','HR_BIS_MINIMUM_PROFICIENCY'),
1637: NULL,
1638: 'VALUE="M"');
1639: params(i).Value := params(i).Value ||
1640: htf.formSelectOption(fnd_message.get_string('HRI','HR_BIS_PROFICIENCY_RANGE'),

Line 1640: htf.formSelectOption(fnd_message.get_string('HRI','HR_BIS_PROFICIENCY_RANGE'),

1636: htf.formSelectOption(fnd_message.get_string('HRI','HR_BIS_MINIMUM_PROFICIENCY'),
1637: NULL,
1638: 'VALUE="M"');
1639: params(i).Value := params(i).Value ||
1640: htf.formSelectOption(fnd_message.get_string('HRI','HR_BIS_PROFICIENCY_RANGE'),
1641: NULL,
1642: 'VALUE="R"');
1643:
1644: params(i).Value := params(i).Value || htf.formSelectClose;

Line 1644: params(i).Value := params(i).Value || htf.formSelectClose;

1640: htf.formSelectOption(fnd_message.get_string('HRI','HR_BIS_PROFICIENCY_RANGE'),
1641: NULL,
1642: 'VALUE="R"');
1643:
1644: params(i).Value := params(i).Value || htf.formSelectClose;
1645:
1646: END Build_Proficiency_Measure;
1647:
1648: --=========================================================================================

Line 1705: params(i).Value := htf.formSelectOpen('VIEWBY');

1701:
1702: BEGIN
1703:
1704: params(i).Label := Display_Label('HR_BIS_VIEW_BY');
1705: params(i).Value := htf.formSelectOpen('VIEWBY');
1706:
1707: IF p_option = 1 THEN
1708: for ci_viewby in c_viewby1 loop
1709: params(i).Value := params(i).Value ||

Line 1710: htf.formSelectOption(ci_viewby.message_text, NULL, 'VALUE="'||ci_viewby.message_name||'"');

1706:
1707: IF p_option = 1 THEN
1708: for ci_viewby in c_viewby1 loop
1709: params(i).Value := params(i).Value ||
1710: htf.formSelectOption(ci_viewby.message_text, NULL, 'VALUE="'||ci_viewby.message_name||'"');
1711: end loop;
1712: ELSIF p_option = 2 THEN
1713: for ci_viewby in c_viewby2 loop
1714: params(i).Value := params(i).Value ||

Line 1715: htf.formSelectOption(ci_viewby.message_text, NULL, 'VALUE="'||ci_viewby.message_name||'"');

1711: end loop;
1712: ELSIF p_option = 2 THEN
1713: for ci_viewby in c_viewby2 loop
1714: params(i).Value := params(i).Value ||
1715: htf.formSelectOption(ci_viewby.message_text, NULL, 'VALUE="'||ci_viewby.message_name||'"');
1716: end loop;
1717: ELSIF p_option = 3 THEN
1718: for ci_viewby in c_viewby3 loop
1719: params(i).Value := params(i).Value ||

Line 1720: htf.formSelectOption(ci_viewby.message_text, NULL, 'VALUE="'||ci_viewby.message_name||'"');

1716: end loop;
1717: ELSIF p_option = 3 THEN
1718: for ci_viewby in c_viewby3 loop
1719: params(i).Value := params(i).Value ||
1720: htf.formSelectOption(ci_viewby.message_text, NULL, 'VALUE="'||ci_viewby.message_name||'"');
1721: end loop;
1722: END IF;
1723:
1724: params(i).Value := params(i).Value || htf.formSelectClose;

Line 1724: params(i).Value := params(i).Value || htf.formSelectClose;

1720: htf.formSelectOption(ci_viewby.message_text, NULL, 'VALUE="'||ci_viewby.message_name||'"');
1721: end loop;
1722: END IF;
1723:
1724: params(i).Value := params(i).Value || htf.formSelectClose;
1725:
1726: END Build_View_By;
1727:
1728: --=========================================================================================

Line 1747: htf.formHidden(param_name)|| -- AK Attribute 1

1743:
1744: params(i).Label := Display_Label('HR_BIS_'||LOV_Name);
1745:
1746: params(i).Value :=
1747: htf.formHidden(param_name)|| -- AK Attribute 1
1748: htf.formText('P_'||LOV_name||'_NAME',30,200,''); -- AK Attribute 2
1749:
1750: params(i).Action := ' 1751: (453
1752: ,''P_'||LOV_name||'_NAME''

Line 1777: params(i).Value := htf.formSelectOpen('P_ORGANIZATION_ID');

1773:
1774: BEGIN
1775:
1776: params(i).Label := Display_Label('HR_BIS_ORGANIZATION');
1777: params(i).Value := htf.formSelectOpen('P_ORGANIZATION_ID');
1778:
1779: IF p_option = 1 THEN
1780: params(i).Value := params(i).Value || htf.formSelectOption(' ', NULL, 'VALUE="-1"');
1781: END IF;

Line 1780: params(i).Value := params(i).Value || htf.formSelectOption(' ', NULL, 'VALUE="-1"');

1776: params(i).Label := Display_Label('HR_BIS_ORGANIZATION');
1777: params(i).Value := htf.formSelectOpen('P_ORGANIZATION_ID');
1778:
1779: IF p_option = 1 THEN
1780: params(i).Value := params(i).Value || htf.formSelectOption(' ', NULL, 'VALUE="-1"');
1781: END IF;
1782:
1783: for ci_org_list in c_organization_list loop
1784: params(i).Value := params(i).Value ||

Line 1785: htf.formSelectOption(ci_org_list.organization_name, NULL,

1781: END IF;
1782:
1783: for ci_org_list in c_organization_list loop
1784: params(i).Value := params(i).Value ||
1785: htf.formSelectOption(ci_org_list.organization_name, NULL,
1786: 'VALUE="'||ci_org_list.organization_id||'"');
1787:
1788: end loop;
1789:

Line 1790: params(i).Value := params(i).Value || htf.formSelectClose;

1786: 'VALUE="'||ci_org_list.organization_id||'"');
1787:
1788: end loop;
1789:
1790: params(i).Value := params(i).Value || htf.formSelectClose;
1791:
1792: END Build_Organization;
1793:
1794:

Line 1814: params(i).Value := htf.formSelectOpen('P_JOB_ID');

1810:
1811: BEGIN
1812:
1813: params(i).Label := Display_Label('HR_BIS_JOB');
1814: params(i).Value := htf.formSelectOpen('P_JOB_ID');
1815:
1816: IF p_option = 1 THEN
1817: params(i).Value := params(i).Value || htf.formSelectOption(' ', NULL, 'VALUE="-1"');
1818: END IF;

Line 1817: params(i).Value := params(i).Value || htf.formSelectOption(' ', NULL, 'VALUE="-1"');

1813: params(i).Label := Display_Label('HR_BIS_JOB');
1814: params(i).Value := htf.formSelectOpen('P_JOB_ID');
1815:
1816: IF p_option = 1 THEN
1817: params(i).Value := params(i).Value || htf.formSelectOption(' ', NULL, 'VALUE="-1"');
1818: END IF;
1819:
1820: for ci_job_list in c_job_list loop
1821: params(i).Value := params(i).Value ||

Line 1822: htf.formSelectOption(ci_job_list.job_name, NULL,

1818: END IF;
1819:
1820: for ci_job_list in c_job_list loop
1821: params(i).Value := params(i).Value ||
1822: htf.formSelectOption(ci_job_list.job_name, NULL,
1823: 'VALUE="'||ci_job_list.job_id||'"');
1824:
1825: l_job_id_count := l_job_id_count+1;
1826:

Line 1829: params(i).Value := params(i).Value || htf.formSelectClose;

1825: l_job_id_count := l_job_id_count+1;
1826:
1827: end loop;
1828:
1829: params(i).Value := params(i).Value || htf.formSelectClose;
1830:
1831: IF l_job_id_count = 0 THEN
1832: p_return_status := 0; -- error, no jobs set up
1833: ELSE

Line 1852: params(i).Value := htf.formSelectOpen('P_LOCATION_ID');

1848:
1849: BEGIN
1850:
1851: params(i).Label := Display_Label('HR_BIS_LOCATION');
1852: params(i).Value := htf.formSelectOpen('P_LOCATION_ID');
1853:
1854: IF p_option = 1 THEN
1855: params(i).Value := params(i).Value || htf.formSelectOption(' ', NULL, 'VALUE="-1"');
1856: END IF;

Line 1855: params(i).Value := params(i).Value || htf.formSelectOption(' ', NULL, 'VALUE="-1"');

1851: params(i).Label := Display_Label('HR_BIS_LOCATION');
1852: params(i).Value := htf.formSelectOpen('P_LOCATION_ID');
1853:
1854: IF p_option = 1 THEN
1855: params(i).Value := params(i).Value || htf.formSelectOption(' ', NULL, 'VALUE="-1"');
1856: END IF;
1857:
1858: for ci_loc_list in c_loc_list loop
1859: params(i).Value := params(i).Value ||

Line 1860: htf.formSelectOption(ci_loc_list.location_name, NULL,

1856: END IF;
1857:
1858: for ci_loc_list in c_loc_list loop
1859: params(i).Value := params(i).Value ||
1860: htf.formSelectOption(ci_loc_list.location_name, NULL,
1861: 'VALUE="'||ci_loc_list.location_id||'"');
1862:
1863: end loop;
1864:

Line 1865: params(i).Value := params(i).Value || htf.formSelectClose;

1861: 'VALUE="'||ci_loc_list.location_id||'"');
1862:
1863: end loop;
1864:
1865: params(i).Value := params(i).Value || htf.formSelectClose;
1866:
1867: END Build_Location;
1868:
1869: -- LINK_ procedures modified to make them call the LINK_PARAMPAGE