APPS.HRI_OLTP_PMV_DYNSQLGEN dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 192: p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

188: /* However reports using the time dimension need special treatment. Also in */
189: /* the "special" category are hierarchical parameters not yet supported. */
190: /******************************************************************************/
191: FUNCTION build_sql_stmt(p_region_code IN VARCHAR2,
192: p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
193: RETURN VARCHAR2 IS
194:
195: /* Loop counter */
196: l_counter NUMBER; -- used to go through sort record table

Line 756: p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

752: /* This is the procedure which builds up the main SQL statement for no viewby */
753: /* reports. It is very similar to the build_sql_stmt function */
754: /******************************************************************************/
755: FUNCTION build_no_viewby_sql_stmt(p_region_code IN VARCHAR2,
756: p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
757: RETURN VARCHAR2 IS
758:
759: /* AK Base Object */
760: l_db_object_name VARCHAR2(30);

Line 895: FUNCTION build_drill_into_sql_stmt(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL

891: /* reports can be handled generically without referring to specific objects. */
892: /* However reports using the time dimension need special treatment. Also in */
893: /* the "special" category are hierarchical parameters not yet supported. */
894: /******************************************************************************/
895: FUNCTION build_drill_into_sql_stmt(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
896: ,p_ak_region_code IN VARCHAR2)
897: RETURN VARCHAR2 IS
898:
899: /* Loop counter */

Line 1446: FUNCTION get_query(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

1442: /******************************************************************************/
1443: /* Main function which inputs the parameters and the query AK Region and */
1444: /* dynamically builds the SQL statement which forms the basis of the query. */
1445: /******************************************************************************/
1446: FUNCTION get_query(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
1447: p_ak_region_code IN VARCHAR2)
1448: return varchar2 IS
1449:
1450: l_sql_text VARCHAR2(4000);

Line 1475: FUNCTION get_no_viewby_query(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

1471: /******************************************************************************/
1472: /* Main function which inputs the parameters and the query AK Region and */
1473: /* dynamically builds the SQL statement which forms the basis of the query. */
1474: /******************************************************************************/
1475: FUNCTION get_no_viewby_query(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
1476: p_ak_region_code IN VARCHAR2)
1477: return varchar2 IS
1478:
1479: l_sql_text VARCHAR2(4000);

Line 1504: FUNCTION get_drill_into_query(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

1500: /******************************************************************************/
1501: /* Main function which inputs the parameters and the query AK Region and */
1502: /* dynamically builds the SQL statement which forms the basis of the query. */
1503: /******************************************************************************/
1504: FUNCTION get_drill_into_query(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
1505: p_ak_region_code IN VARCHAR2)
1506: return varchar2 IS
1507:
1508: l_sql_text VARCHAR2(4000);