33:
34: BEGIN
35: /* Initialize p_custom_output and l_custom_rec */
36: p_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
37: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
38:
39: l_where_clause := NULL;
40: l_call_center := NULL;
41: l_view_by := NULL;
601: p_sql_text := l_sqltext;
602:
603: l_custom_rec.attribute_name := ':l_unknown' ;
604: l_custom_rec.attribute_value:= l_unknown;
605: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
606: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
607:
608: p_custom_output.Extend();
609: p_custom_output(p_custom_output.count) := l_custom_rec;
602:
603: l_custom_rec.attribute_name := ':l_unknown' ;
604: l_custom_rec.attribute_value:= l_unknown;
605: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
606: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
607:
608: p_custom_output.Extend();
609: p_custom_output(p_custom_output.count) := l_custom_rec;
610:
612: -- p_custom_output.EXTEND();
613: IF l_call_center IS NOT NULL THEN
614: l_custom_rec.attribute_name := ':l_call_center' ;
615: l_custom_rec.attribute_value:= l_call_center;
616: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
617: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
618:
619: p_custom_output.Extend();
620: p_custom_output(p_custom_output.count) := l_custom_rec;
613: IF l_call_center IS NOT NULL THEN
614: l_custom_rec.attribute_name := ':l_call_center' ;
615: l_custom_rec.attribute_value:= l_call_center;
616: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
617: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
618:
619: p_custom_output.Extend();
620: p_custom_output(p_custom_output.count) := l_custom_rec;
621: END IF;
622: IF l_campaign_id IS NOT NULL
623: THEN
624: l_custom_rec.attribute_name := ':l_campaign_id';
625: l_custom_rec.attribute_value:= l_campaign_id;
626: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
627: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
628:
629: p_custom_output.Extend();
630: p_custom_output(p_custom_output.count) := l_custom_rec;
623: THEN
624: l_custom_rec.attribute_name := ':l_campaign_id';
625: l_custom_rec.attribute_value:= l_campaign_id;
626: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
627: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
628:
629: p_custom_output.Extend();
630: p_custom_output(p_custom_output.count) := l_custom_rec;
631: END IF;
633: IF l_schedule_id IS NOT NULL
634: THEN
635: l_custom_rec.attribute_name := ':l_schedule_id';
636: l_custom_rec.attribute_value:= l_schedule_id;
637: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
638: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
639:
640: p_custom_output.Extend();
641: p_custom_output(p_custom_output.count) := l_custom_rec;
634: THEN
635: l_custom_rec.attribute_name := ':l_schedule_id';
636: l_custom_rec.attribute_value:= l_schedule_id;
637: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
638: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
639:
640: p_custom_output.Extend();
641: p_custom_output(p_custom_output.count) := l_custom_rec;
642: END IF;
643: IF l_source_code_id IS NOT NULL
644: THEN
645: l_custom_rec.attribute_name := ':l_source_code_id';
646: l_custom_rec.attribute_value:= l_source_code_id;
647: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
648: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
649:
650: p_custom_output.Extend();
651: p_custom_output(p_custom_output.count) := l_custom_rec;
644: THEN
645: l_custom_rec.attribute_name := ':l_source_code_id';
646: l_custom_rec.attribute_value:= l_source_code_id;
647: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
648: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
649:
650: p_custom_output.Extend();
651: p_custom_output(p_custom_output.count) := l_custom_rec;
652: END IF;
655:
656:
657:
658:
659: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
660: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
661: l_custom_rec.attribute_value := l_view_by;
662:
663: p_custom_output.EXTEND();
656:
657:
658:
659: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
660: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
661: l_custom_rec.attribute_value := l_view_by;
662:
663: p_custom_output.EXTEND();
664: p_custom_output(p_custom_output.COUNT) := l_custom_rec;