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 HR_BIS

Line 251: Build_lookup_param(params,paramnum, 'HR_BIS_PERFORMANCE_RATING','PERFRT','PERFORMANCE_RATING','-1');

247: htp.formHidden('P_GRADE_NAME','');
248: END IF;
249:
250: IF instr(p_param_request,'PERFRT,') > 0 then
251: Build_lookup_param(params,paramnum, 'HR_BIS_PERFORMANCE_RATING','PERFRT','PERFORMANCE_RATING','-1');
252: paramnum := paramnum + 1;
253: ELSE
254: htp.formHidden('PERFRT', '');
255: END IF;

Line 350: Build_lookup_param(params,paramnum, 'HR_BIS_BGTTYP','BGTTYP','BUDGET_MEASUREMENT_TYPE','');

346: htp.formHidden('BGT_ID', '');
347: END IF;
348:
349: IF instr(p_param_request, 'BGTTYP,') > 0 then
350: Build_lookup_param(params,paramnum, 'HR_BIS_BGTTYP','BGTTYP','BUDGET_MEASUREMENT_TYPE','');
351: paramnum := paramnum + 1;
352: ELSE
353: htp.formHidden('BGTTYP', '');
354: END IF;

Line 357: Build_lookup_param(params,paramnum, 'HR_BIS_PROPOSAL_REASON', 'PROPRN', 'PROPOSAL_REASON', '');

353: htp.formHidden('BGTTYP', '');
354: END IF;
355:
356: IF instr(p_param_request,'PROPRN,') > 0 then
357: Build_lookup_param(params,paramnum, 'HR_BIS_PROPOSAL_REASON', 'PROPRN', 'PROPOSAL_REASON', '');
358: paramnum := paramnum + 1;
359: ELSE
360: htp.formHidden('PROPRN', '');
361: END IF;

Line 364: Build_lookup_param(params,paramnum, 'HR_BIS_SEPARATION_REASON', 'SEPRSN', 'LEAV_REAS', 'BIS_ALL');

360: htp.formHidden('PROPRN', '');
361: END IF;
362:
363: IF instr(p_param_request,'SEPRSN,') > 0 then
364: Build_lookup_param(params,paramnum, 'HR_BIS_SEPARATION_REASON', 'SEPRSN', 'LEAV_REAS', 'BIS_ALL');
365: paramnum := paramnum + 1;
366: ELSE
367: htp.formHidden('SEPRSN', '');
368: END IF;

Line 458: l_param_missing_req_label := Display_Label('HR_BIS_PAYROLL');

454: WHEN e_missing_required_parameter THEN
455: BEGIN
456:
457: IF l_param_missing_req_val_name = 'PAYRLL' THEN
458: l_param_missing_req_label := Display_Label('HR_BIS_PAYROLL');
459: END IF;
460:
461: IF l_param_missing_req_val_name = 'ORG_ID' THEN
462: l_param_missing_req_label := Display_Label('HR_BIS_ORGANIZATION');

Line 462: l_param_missing_req_label := Display_Label('HR_BIS_ORGANIZATION');

458: l_param_missing_req_label := Display_Label('HR_BIS_PAYROLL');
459: END IF;
460:
461: IF l_param_missing_req_val_name = 'ORG_ID' THEN
462: l_param_missing_req_label := Display_Label('HR_BIS_ORGANIZATION');
463: END IF;
464:
465: IF l_param_missing_req_val_name = 'COMPID' THEN
466: l_param_missing_req_label := Display_Label('HR_BIS_COMPETENCE');

Line 466: l_param_missing_req_label := Display_Label('HR_BIS_COMPETENCE');

462: l_param_missing_req_label := Display_Label('HR_BIS_ORGANIZATION');
463: END IF;
464:
465: IF l_param_missing_req_val_name = 'COMPID' THEN
466: l_param_missing_req_label := Display_Label('HR_BIS_COMPETENCE');
467: END IF;
468:
469: IF l_param_missing_req_val_name = 'JOB_ID' THEN
470: l_param_missing_req_label := Display_Label('HR_BIS_JOB');

Line 470: l_param_missing_req_label := Display_Label('HR_BIS_JOB');

466: l_param_missing_req_label := Display_Label('HR_BIS_COMPETENCE');
467: END IF;
468:
469: IF l_param_missing_req_val_name = 'JOB_ID' THEN
470: l_param_missing_req_label := Display_Label('HR_BIS_JOB');
471: END IF;
472:
473: IF l_param_missing_req_val_name = 'BGT_ID' THEN
474: l_param_missing_req_label := Display_Label('HR_BIS_BUDGET');

Line 474: l_param_missing_req_label := Display_Label('HR_BIS_BUDGET');

470: l_param_missing_req_label := Display_Label('HR_BIS_JOB');
471: END IF;
472:
473: IF l_param_missing_req_val_name = 'BGT_ID' THEN
474: l_param_missing_req_label := Display_Label('HR_BIS_BUDGET');
475: END IF;
476:
477: fnd_message.set_name('HRI','HR_BIS_PLSQL_CART_REQ_PARAM');
478: fnd_message.set_token('PARAMETER',l_param_missing_req_label);

Line 477: fnd_message.set_name('HRI','HR_BIS_PLSQL_CART_REQ_PARAM');

473: IF l_param_missing_req_val_name = 'BGT_ID' THEN
474: l_param_missing_req_label := Display_Label('HR_BIS_BUDGET');
475: END IF;
476:
477: fnd_message.set_name('HRI','HR_BIS_PLSQL_CART_REQ_PARAM');
478: fnd_message.set_token('PARAMETER',l_param_missing_req_label);
479:
480: htp.br;
481: htp.br;

Line 515: VIEWBY varchar2 default 'HR_BIS_TIME',

511: JOBCAT1 varchar2 default '__ALL__',
512: JOBCAT2 varchar2 default '__ALL__',
513: JOBCAT3 varchar2 default '__ALL__',
514: BGTTYP varchar2,
515: VIEWBY varchar2 default 'HR_BIS_TIME',
516: FRQNCY varchar2 default 'CM',
517: P_START_DATE_V varchar2,
518: P_END_DATE_V varchar2,
519: P_LOCATION_ID varchar2 default '-1',

Line 652: -- labels. Pass in the message_name (e.g. 'HR_BIS_PRODUCT_CATEGORY') and

648:
649: BEGIN
650:
651: -- This private function gets the translation for each of the report parameter
652: -- labels. Pass in the message_name (e.g. 'HR_BIS_PRODUCT_CATEGORY') and
653: -- it passes back the correct translation
654:
655: fnd_message.set_name( 'HRI', p_label_name );
656: return fnd_message.get;

Line 682: params(i).Label := Display_Label('HR_BIS_BUSINESS_PLAN');

678: BEGIN
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:

Line 707: where message_name = 'HR_BIS_AREA'

703: cursor c_geog_level is
704: select '1' lev_code,
705: message_text lev
706: from fnd_new_messages
707: where message_name = 'HR_BIS_AREA'
708: and application_id = 453
709: and language_code = userenv('LANG')
710: union
711: select '2' lev_code,

Line 714: where message_name = 'HR_BIS_COUNTRY'

710: union
711: select '2' lev_code,
712: message_text lev
713: from fnd_new_messages
714: where message_name = 'HR_BIS_COUNTRY'
715: and application_id = 453
716: and language_code = userenv('LANG')
717: union
718: select '3' lev_code,

Line 721: where message_name = 'HR_BIS_REGION'

717: union
718: select '3' lev_code,
719: message_text lev
720: from fnd_new_messages
721: where message_name = 'HR_BIS_REGION'
722: and application_id = 453
723: and language_code = userenv('LANG');
724:
725: BEGIN

Line 788: params(i).Label := Display_Label('HR_BIS_PRODUCT_CATEGORY');

784:
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:

Line 824: params(i).Label := Display_Label('HR_BIS_JOB_CATEGORY');

820:
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:

Line 837: params(i).Label := Display_Label('HR_BIS_JOB_CATEGORY1');

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
840: params(i).Value := params(i).Value ||
841: htf.formSelectOption(ci_job_category.meaning,NULL,

Line 847: params(i).Label := Display_Label('HR_BIS_JOB_CATEGORY2');

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' );
849: params(i).Value := params(i).Value ||
850: htf.formSelectOption(' ',NULL, 'VALUE="__ALL__"');
851: for ci_job_category in c_job_category loop

Line 859: params(i).Label := Display_Label('HR_BIS_JOB_CATEGORY3');

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' );
861: params(i).Value := params(i).Value ||
862: htf.formSelectOption(' ',NULL, 'VALUE="__ALL__"');
863: for ci_job_category in c_job_category loop

Line 898: params(i).Label := Display_Label('HR_BIS_BUDGET');

894:
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:

Line 942: params(i).Label := Display_Label('HR_BIS_BUDGET');

938: BEGIN
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:

Line 984: params(i).Label := Display_Label('HR_BIS_FREQUENCY');

980: BEGIN
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:

Line 1111: params(i).Label := Display_Label('HR_BIS_BUDGET');

1107: and trunc(sysdate) between bv.date_from and nvl( bv.date_to, sysdate+1 );
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 ||

Line 1151: params(i).Label := Display_Label('HR_BIS_COMPETENCE');

1147: l_comp_id_count number :=0;
1148:
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

Line 1188: where b.business_group_id = hr_bis.get_sec_profile_bg_id -- bug 2968520

1184:
1185: cursor c_currcd is
1186: select c.currency_code , c.name
1187: from per_business_groups b , fnd_currencies_vl c
1188: where b.business_group_id = hr_bis.get_sec_profile_bg_id -- bug 2968520
1189: and c.enabled_flag = 'Y'
1190: and sysdate between nvl(c.start_date_active, hr_general.start_of_time)
1191: and nvl(c.end_date_active, hr_general.end_of_time)
1192: order by decode(b.currency_code, c.currency_code, 1,2) , c.currency_code;

Line 1196: params(i).Label := Display_Label('HR_BIS_REPORT_CURRENCY');

1192: order by decode(b.currency_code, c.currency_code, 1,2) , c.currency_code;
1193:
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

Line 1231: params(i).Label := Display_Label('HR_BIS_DISPLAY');

1227: BEGIN
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:

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 1286: where message_name in ('HR_BIS_INCLUDE','HR_BIS_EXCLUDE')

1282:
1283: cursor c_exccur is
1284: select message_name , message_text
1285: from fnd_new_messages
1286: where message_name in ('HR_BIS_INCLUDE','HR_BIS_EXCLUDE')
1287: and language_code = userenv('LANG')
1288: and application_id = 453
1289: order by decode(message_name,'HR_BIS_EXCLUDE','1,2');
1290:

Line 1289: order by decode(message_name,'HR_BIS_EXCLUDE','1,2');

1285: from fnd_new_messages
1286: where message_name in ('HR_BIS_INCLUDE','HR_BIS_EXCLUDE')
1287: and language_code = userenv('LANG')
1288: and application_id = 453
1289: order by decode(message_name,'HR_BIS_EXCLUDE','1,2');
1290:
1291: BEGIN
1292:
1293: params(i).Label := Display_Label('HR_BIS_OTHER_CURRENCIES');

Line 1293: params(i).Label := Display_Label('HR_BIS_OTHER_CURRENCIES');

1289: order by decode(message_name,'HR_BIS_EXCLUDE','1,2');
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 ||

Line 1329: params(i).Label := Display_Label('HR_BIS_GRADE');

1325: order by name;
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

Line 1355: params(i).Label := Display_Label('HR_BIS_EMP_APP');

1351: -- Parameter Request String : 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,

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 1387: params(i).Label := Display_Label('HR_BIS_ORDER_BY');

1383: -- 'Separated'; value 2 returns a list for 'Increase'
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

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 1394: || ' ' || fnd_message.get_string('HRI', 'HR_BIS_SEPARATED'),

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')
1398: || ' ' || fnd_message.get_string('HRI', 'HR_BIS_SEPARATED'),

Line 1395: NULL, 'VALUE="HR_BIS_TOTAL"');

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')
1398: || ' ' || fnd_message.get_string('HRI', 'HR_BIS_SEPARATED'),
1399: NULL, 'VALUE="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 1398: || ' ' || fnd_message.get_string('HRI', 'HR_BIS_SEPARATED'),

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
1402: params(i).Value := params(i).Value ||

Line 1399: NULL, 'VALUE="HR_BIS_PERCENT"');

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
1402: params(i).Value := params(i).Value ||
1403: htf.formSelectOption(fnd_message.get_string('HRI', 'HR_BIS_PERCENT')

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 1404: || ' ' || fnd_message.get_string('HRI', 'HR_BIS_INCREASE'),

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')
1408: || ' ' || fnd_message.get_string('HRI', 'HR_BIS_INCREASE'),

Line 1405: NULL, 'VALUE="HR_BIS_PERCENT"');

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')
1408: || ' ' || fnd_message.get_string('HRI', 'HR_BIS_INCREASE'),
1409: NULL, 'VALUE="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 1408: || ' ' || fnd_message.get_string('HRI', 'HR_BIS_INCREASE'),

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:
1412: params(i).Value := params(i).Value || htf.formSelectClose;

Line 1409: NULL, 'VALUE="HR_BIS_TOTAL"');

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:
1412: params(i).Value := params(i).Value || htf.formSelectClose;
1413:

Line 1452: params(i).Label := Display_Label('HR_BIS_ROLLUP_EACH_ORG');

1448:
1449: -- If p_option = 1 then the rollup label needs to be a rollup each org
1450: -- label. Bug #1349001 - mjandrew - 01-Aug-2000
1451: IF p_option = 1 THEN
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');

Line 1454: params(i).Label := Display_Label('HR_BIS_ROLLUP_ORGANIZATIONS');

1450: -- label. Bug #1349001 - mjandrew - 01-Aug-2000
1451: IF p_option = 1 THEN
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

Line 1521: params(i).Label := Display_Label('HR_BIS_PAYROLL');

1517: l_payroll_id_counter number :=0;
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"');

Line 1562: params(i).Label := Display_Label('HR_BIS_REPORTING_DATE');

1558:
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:

Line 1565: params(i).Label := Display_Label('HR_BIS_REPORTING_DATES');

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'))
1568: ||' - '||
1569: htf.formText('P_END_DATE_V',11,NULL, to_char(sysdate,'DD-MON-YYYY'));

Line 1633: params(i).Label := Display_Label('HR_BIS_PROFICIENCY_LEVEL');

1629: -- Parameter Request String : 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,

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 1666: and message_name in ('HR_BIS_GRADE', 'HR_BIS_PERFORMANCE_RATING', 'HR_BIS_SERVICE_BAND',

1662: select message_name , message_text
1663: from fnd_new_messages
1664: where language_code = userenv('LANG')
1665: and application_id = 453
1666: and message_name in ('HR_BIS_GRADE', 'HR_BIS_PERFORMANCE_RATING', 'HR_BIS_SERVICE_BAND',
1667: 'HR_BIS_JOB', 'HR_BIS_LOCATION', 'HR_BIS_GENDER')
1668: UNION
1669: select message_name , message_text
1670: from fnd_new_messages , per_business_groups

Line 1667: 'HR_BIS_JOB', 'HR_BIS_LOCATION', 'HR_BIS_GENDER')

1663: from fnd_new_messages
1664: where language_code = userenv('LANG')
1665: and application_id = 453
1666: and message_name in ('HR_BIS_GRADE', 'HR_BIS_PERFORMANCE_RATING', 'HR_BIS_SERVICE_BAND',
1667: 'HR_BIS_JOB', 'HR_BIS_LOCATION', 'HR_BIS_GENDER')
1668: UNION
1669: select message_name , message_text
1670: from fnd_new_messages , per_business_groups
1671: where business_group_id = hr_bis.get_sec_profile_bg_id -- bug 2968520

Line 1671: where business_group_id = hr_bis.get_sec_profile_bg_id -- bug 2968520

1667: 'HR_BIS_JOB', 'HR_BIS_LOCATION', 'HR_BIS_GENDER')
1668: UNION
1669: select message_name , message_text
1670: from fnd_new_messages , per_business_groups
1671: where business_group_id = hr_bis.get_sec_profile_bg_id -- bug 2968520
1672: and legislation_code = 'US'
1673: and language_code = userenv('LANG')
1674: and application_id = 453
1675: and message_name = 'HR_BIS_EEO_CATEGORY'

Line 1675: and message_name = 'HR_BIS_EEO_CATEGORY'

1671: where business_group_id = hr_bis.get_sec_profile_bg_id -- bug 2968520
1672: and legislation_code = 'US'
1673: and language_code = userenv('LANG')
1674: and application_id = 453
1675: and message_name = 'HR_BIS_EEO_CATEGORY'
1676: UNION
1677: select message_name , message_text
1678: from fnd_new_messages fnm , per_business_groups bus
1679: where bus.business_group_id = hr_bis.get_sec_profile_bg_id -- bug 2968520

Line 1679: where bus.business_group_id = hr_bis.get_sec_profile_bg_id -- bug 2968520

1675: and message_name = 'HR_BIS_EEO_CATEGORY'
1676: UNION
1677: select message_name , message_text
1678: from fnd_new_messages fnm , per_business_groups bus
1679: where bus.business_group_id = hr_bis.get_sec_profile_bg_id -- bug 2968520
1680: and language_code = userenv('LANG')
1681: and application_id = 453
1682: and legislation_code <> 'US'
1683: and message_name = 'HR_BIS_ETHNIC_ORIGIN' order by 2;

Line 1683: and message_name = 'HR_BIS_ETHNIC_ORIGIN' order by 2;

1679: where bus.business_group_id = hr_bis.get_sec_profile_bg_id -- bug 2968520
1680: and language_code = userenv('LANG')
1681: and application_id = 453
1682: and legislation_code <> 'US'
1683: and message_name = 'HR_BIS_ETHNIC_ORIGIN' order by 2;
1684:
1685: cursor c_viewby2 is
1686: select message_name , message_text
1687: from fnd_new_messages

Line 1690: and message_name in ('HR_BIS_AGE_YEARS', 'HR_BIS_LOS_YEARS', 'HR_BIS_GRADE', 'HR_BIS_PERFORMANCE_RATING')

1686: select message_name , message_text
1687: from fnd_new_messages
1688: where language_code = userenv('LANG')
1689: and application_id = 453
1690: and message_name in ('HR_BIS_AGE_YEARS', 'HR_BIS_LOS_YEARS', 'HR_BIS_GRADE', 'HR_BIS_PERFORMANCE_RATING')
1691: order by message_name;
1692:
1693: cursor c_viewby3 is
1694: select message_name,

Line 1697: where message_name IN ('HR_BIS_TIME', 'HR_BIS_GEOGRAPHY', 'HR_BIS_PRODUCT')

1693: cursor c_viewby3 is
1694: select message_name,
1695: message_text
1696: from fnd_new_messages
1697: where message_name IN ('HR_BIS_TIME', 'HR_BIS_GEOGRAPHY', 'HR_BIS_PRODUCT')
1698: and application_id = 453
1699: and language_code = userenv('LANG')
1700: order by 1 desc;
1701:

Line 1704: params(i).Label := Display_Label('HR_BIS_VIEW_BY');

1700: order by 1 desc;
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

Line 1744: params(i).Label := Display_Label('HR_BIS_'||LOV_Name);

1740: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1741:
1742: BEGIN
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

Line 1776: params(i).Label := Display_Label('HR_BIS_ORGANIZATION');

1772:
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"');

Line 1813: params(i).Label := Display_Label('HR_BIS_JOB');

1809: l_job_id_count number :=0;
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"');

Line 1851: params(i).Label := Display_Label('HR_BIS_LOCATION');

1847: from hri_loc_lov_v;
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"');