DBA Data[Home] [Help]

APPS.HRI_PARAMETERS dependencies on BIS_UTILITIES_PUB

Line 19: params BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type;

15: )
16: IS
17:
18: -- Create PL/SQL table
19: params BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type;
20: paramnum integer;
21: p_option integer;
22:
23: -- bug fix: 1269713, check required parameter[s]

Line 445: BIS_UTILITIES_PUB.Build_Parameter_Form('NAME="'

441: htp.formHidden('RPNAME', p_report_name);
442:
443: -- Build Parameter Form
444:
445: BIS_UTILITIES_PUB.Build_Parameter_Form('NAME="'
446: || p_report_name || '"
447: ACTION="HRI_Parameters.Param_ActionView" METHOD="GET"', params);
448:
449: htp.formClose;

Line 598: -- This uses Core BIS package called BIS_UTILITIES_PUB

594:
595: -- This procedure replaces the reports BeforePForm Trigger and
596: -- creates the banner and sets up business group id and org ver
597: -- Create Banner for top of Parameter Form
598: -- This uses Core BIS package called BIS_UTILITIES_PUB
599: -- Need to pass it Function Code and RDF Filename (without extension)
600:
601: BIS_UTILITIES_PUB.Build_Report_Title(
602: p_Function_Code => p_function_code

Line 601: BIS_UTILITIES_PUB.Build_Report_Title(

597: -- Create Banner for top of Parameter Form
598: -- This uses Core BIS package called BIS_UTILITIES_PUB
599: -- Need to pass it Function Code and RDF Filename (without extension)
600:
601: BIS_UTILITIES_PUB.Build_Report_Title(
602: p_Function_Code => p_function_code
603: ,p_Rdf_Filename => p_rdf_filename
604: ,p_Body_Attribs => NULL
605: );

Line 663: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type

659:
660: --=========================================================================================
661:
662: PROCEDURE Build_Business_Plan(
663: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
664: ,i IN NUMBER
665: ) IS
666:
667: cursor c_bpl is

Line 699: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type

695:
696: --=========================================================================================
697:
698: PROCEDURE Build_Geog_Level(
699: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
700: ,i IN NUMBER
701: ) IS
702:
703: cursor c_geog_level is

Line 747: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type

743:
744: --=========================================================================================
745:
746: PROCEDURE Build_Geog_Value(
747: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
748: ,i IN NUMBER
749: ) IS
750:
751: BEGIN

Line 771: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type

767:
768: --=========================================================================================
769:
770: PROCEDURE Build_Product (
771: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
772: ,i IN NUMBER
773: ) IS
774:
775: cursor c_product_category is

Line 805: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type

801:
802: --=========================================================================================
803:
804: PROCEDURE Build_Job_Category (
805: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
806: ,i IN OUT NOCOPY NUMBER
807: ,p_option IN NUMBER
808: ) IS
809:

Line 880: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type

876:
877: -- cbridge , 28/06/2001, added build_pqh_budget for pqh budget changes
878:
879: PROCEDURE build_pqh_budget (
880: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
881: ,i IN NUMBER
882: , p_return_status IN OUT NOCOPY NUMBER
883: ) IS
884:

Line 923: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type

919: END build_pqh_budget;
920:
921:
922: PROCEDURE Build_Budget (
923: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
924: ,i IN NUMBER
925: , p_return_status IN OUT NOCOPY NUMBER
926: ) IS
927:

Line 968: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type

964:
965: --=========================================================================================
966:
967: PROCEDURE Build_Frequency (
968: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
969: ,i IN NUMBER
970: ) IS
971:
972: cursor c_frequency is

Line 1083: BIS_UTILITIES_PUB.Build_Report_Header(java_string||java_string2||java_string3);

1079: java_string3 := java_string3|| '}' ;
1080: java_string3 := java_string3|| ' ' ;
1081:
1082: -- Build up Java Script
1083: BIS_UTILITIES_PUB.Build_Report_Header(java_string||java_string2||java_string3);
1084:
1085: -- bug 1301690 end
1086:
1087: END Geography_Cross_Validation;

Line 1092: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type

1088:
1089: --=========================================================================================
1090:
1091: PROCEDURE Build_Budget_ID(
1092: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
1093: ,i IN NUMBER
1094: ) IS
1095:
1096:

Line 1130: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type

1126:
1127: --=========================================================================================
1128:
1129: PROCEDURE Build_Competence_ID(
1130: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
1131: ,i IN NUMBER
1132: ,p_return_status IN OUT NOCOPY NUMBER
1133: ) IS
1134:

Line 1178: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type

1174:
1175: --=========================================================================================
1176:
1177: PROCEDURE Build_Report_Currency(
1178: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
1179: ,i IN NUMBER
1180: ) IS
1181: -- This function gives a drop down list showing the currencies in
1182: -- which the figures can appear on the report

Line 1213: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type

1209:
1210: --=========================================================================================
1211:
1212: PROCEDURE Build_Display_By(
1213: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
1214: ,i IN NUMBER
1215: ) IS
1216:
1217: inc_amt integer;

Line 1275: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type

1271:
1272: --=========================================================================================
1273:
1274: PROCEDURE Build_Exclude_Currency(
1275: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
1276: ,i IN NUMBER
1277: ) IS
1278:
1279: -- This list gives the option to include (or exclude)

Line 1313: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type

1309: This procedure was commented out to fix the bug 1863276.
1310: D.sheth 08-AUG-2001
1311:
1312: PROCEDURE Build_Grade_ID(
1313: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
1314: ,i IN NUMBER
1315: ) IS
1316:
1317: -- This function gives a list of grades as defined in HR,

Line 1346: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type

1342: */
1343: --=========================================================================================
1344:
1345: PROCEDURE Build_Employee_Applicant(
1346: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
1347: ,i IN NUMBER
1348: ) IS
1349:
1350: -- Facility Provided : gives an option whether to show employees or applicants on the report

Line 1373: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type

1369:
1370: --=========================================================================================
1371:
1372: PROCEDURE Build_Order_By(
1373: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
1374: ,i IN NUMBER
1375: ,p_option IN NUMBER
1376: ) IS
1377:

Line 1419: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type

1415:
1416: --=========================================================================================
1417:
1418: PROCEDURE Build_Incl_Subord(
1419: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
1420: ,i IN NUMBER
1421: ,p_option IN NUMBER
1422: ) IS
1423:

Line 1500: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type

1496:
1497: --=========================================================================================
1498:
1499: PROCEDURE Build_Payroll_ID(
1500: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
1501: ,i IN NUMBER
1502: ,p_option IN NUMBER
1503: ,p_return_status IN OUT NOCOPY NUMBER
1504: ) IS

Line 1551: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type

1547:
1548: --=========================================================================================
1549:
1550: PROCEDURE Build_Rep_Dates(
1551: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
1552: ,i IN NUMBER
1553: ,P_OPTION IN NUMBER
1554: ) IS
1555:

Line 1577: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type

1573:
1574: --=========================================================================================
1575:
1576: PROCEDURE Build_lookup_param(
1577: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
1578: ,i IN NUMBER
1579: ,P_LABEL IN VARCHAR2
1580: ,P_FORM_NAME IN VARCHAR2
1581: ,P_LOOKUP_TYPE IN VARCHAR2

Line 1622: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type

1618:
1619: --=========================================================================================
1620:
1621: PROCEDURE Build_Proficiency_Measure(
1622: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
1623: ,i IN NUMBER
1624: ) IS
1625:
1626: -- Proficiency Measure to Compare Against.

Line 1651: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type

1647:
1648: --=========================================================================================
1649:
1650: PROCEDURE Build_View_By(
1651: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
1652: ,i IN NUMBER
1653: ,p_option IN NUMBER
1654: ) IS
1655:

Line 1731: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type

1727:
1728: --=========================================================================================
1729:
1730: PROCEDURE Build_LOV(
1731: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
1732: ,i IN Number
1733: ,p_option IN Number
1734: ,param_name IN varchar2
1735: ,LOV_name IN varchar2

Line 1740: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

1736: ) IS
1737:
1738: l_where_clause varchar2(10000);
1739: l_return_status varchar2(1000);
1740: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1741:
1742: BEGIN
1743:
1744: params(i).Label := Display_Label('HR_BIS_'||LOV_Name);

Line 1763: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type

1759:
1760: END Build_LOV;
1761:
1762: Procedure Build_Organization(
1763: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
1764: ,i IN Number
1765: ,p_option IN Number
1766: ) IS
1767:

Line 1797: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type

1793:
1794:
1795:
1796: PROCEDURE Build_Job(
1797: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
1798: ,i IN Number
1799: ,p_option IN Number
1800: ,p_return_status IN OUT NOCOPY NUMBER
1801: ) IS

Line 1840: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type

1836:
1837: END Build_Job;
1838:
1839: PROCEDURE Build_Location(
1840: params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
1841: , i IN NUMBER
1842: , p_option IN NUMBER
1843: ) IS
1844: