APPS.BIS_BIA_RSG_PSTATE dependencies on BIS_PMV_PARAMETERS_PUB

Line 450: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

446: --END OF l_sql_stmt
447: end if;
448:
449: debug ('IN MAIN after if');
450: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
451: x_custom_output := bis_query_attributes_tbl();
452:
453: l_sql_stmt := l_sql_stmt || ' and DISP.ID = :CONTENT_NAME' ;
454:

Line 457: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

453: l_sql_stmt := l_sql_stmt || ' and DISP.ID = :CONTENT_NAME' ;
454:
455: l_custom_rec.attribute_name := ':CONTENT_NAME';
456: l_custom_rec.attribute_value := content_name;
457: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
458: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
459: x_custom_output.extend;
460: x_custom_output(1) := l_custom_rec;
461: --- we have inserted the parameter directly in the query, as pmv does not allow

Line 458: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

454:
455: l_custom_rec.attribute_name := ':CONTENT_NAME';
456: l_custom_rec.attribute_value := content_name;
457: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
458: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
459: x_custom_output.extend;
460: x_custom_output(1) := l_custom_rec;
461: --- we have inserted the parameter directly in the query, as pmv does not allow
462: ---- bind parameter length to exceed more than 255..

Line 468: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

464: IF(CONTENT_TYPE='REPORT') THEN
465: debug ('IN MAIN setting up rs name');
466: l_custom_rec.attribute_name := ':RS_NAME';
467: l_custom_rec.attribute_value := l_rs_names;
468: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
469: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
470: x_custom_output.extend;
471: x_custom_output(2) := l_custom_rec;
472: END IF;*/

Line 469: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

465: debug ('IN MAIN setting up rs name');
466: l_custom_rec.attribute_name := ':RS_NAME';
467: l_custom_rec.attribute_value := l_rs_names;
468: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
469: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
470: x_custom_output.extend;
471: x_custom_output(2) := l_custom_rec;
472: END IF;*/
473: