DBA Data[Home] [Help]

APPS.HRI_OLTP_PMV_LBRCST_ORGMGR dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 14: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

10: -- ----------------------------------------------------
11:
12: PROCEDURE GET_ORG_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
13: x_custom_sql OUT NOCOPY VARCHAR2,
14: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
15:
16: l_sqltext VARCHAR2(32767);
17: l_custom_rec BIS_QUERY_ATTRIBUTES;
18:

Line 30: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

26:
27: /* Initialize out parameters */
28:
29: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
30: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
31:
32: /* Get common parameter values */
33: hri_oltp_pmv_util_param.get_parameters_from_table
34: (p_page_parameter_tbl => p_page_parameter_tbl,

Line 210: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

206: -- ----------------------------------------------------
207:
208: PROCEDURE GET_KPI_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
209: x_custom_sql OUT NOCOPY VARCHAR2,
210: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
211:
212: l_sqltext VARCHAR2(32767);
213: l_custom_rec BIS_QUERY_ATTRIBUTES;
214:

Line 226: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

222:
223: /* Initialize out parameters */
224:
225: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
226: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
227:
228: /* Get common parameter values */
229: hri_oltp_pmv_util_param.get_parameters_from_table
230: (p_page_parameter_tbl => p_page_parameter_tbl,

Line 671: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

667: -- ----------------------------------------------------
668:
669: PROCEDURE GET_POS_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
670: x_custom_sql OUT NOCOPY VARCHAR2,
671: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
672:
673: l_sqltext VARCHAR2(32767);
674: l_custom_rec BIS_QUERY_ATTRIBUTES;
675:

Line 686: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

682:
683: /* Initialize out parameters */
684:
685: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
686: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
687:
688: /* Get common parameter values */
689: /* hri_oltp_pmv_util_param.get_parameters_from_table
690: (p_page_parameter_tbl => p_page_parameter_tbl,

Line 807: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

803: -- ----------------------------------------------------
804:
805: PROCEDURE GET_POS_DTL_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
806: x_custom_sql OUT NOCOPY VARCHAR2,
807: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
808:
809: l_lnk_profile_chk NUMBER;
810: l_lnk_emp_name VARCHAR2(255);
811: l_sqltext VARCHAR2(32767);

Line 823: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

819:
820: /* Initialize out parameters */
821:
822: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
823: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
824:
825:
826: /* Get common parameter values */
827: hri_oltp_pmv_util_param.get_parameters_from_table

Line 983: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

979: -- ----------------------------------------------------
980:
981: PROCEDURE GET_ELE_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
982: x_custom_sql OUT NOCOPY VARCHAR2,
983: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
984:
985: l_sqltext VARCHAR2(32767);
986: l_custom_rec BIS_QUERY_ATTRIBUTES;
987:

Line 997: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

993:
994: /* Initialize out parameters */
995:
996: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
997: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
998:
999: /* Get common parameter values */
1000: hri_oltp_pmv_util_param.get_parameters_from_table
1001: (p_page_parameter_tbl => p_page_parameter_tbl,

Line 1177: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

1173: -- ----------------------------------------------------
1174:
1175: PROCEDURE GET_FSC_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
1176: x_custom_sql OUT NOCOPY VARCHAR2,
1177: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
1178:
1179: l_sqltext VARCHAR2(32767);
1180: l_custom_rec BIS_QUERY_ATTRIBUTES;
1181:

Line 1192: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

1188:
1189: /* Initialize out parameters */
1190:
1191: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1192: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
1193:
1194:
1195: /* Get common parameter values */
1196: hri_oltp_pmv_util_param.get_parameters_from_table