DBA Data[Home] [Help]

APPS.BIX_PMV_AO_ACTCSCH_RPT_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 37: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

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;

Line 605: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

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;

Line 606: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

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:

Line 616: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

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;

Line 617: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

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;

Line 626: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

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;

Line 627: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

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;

Line 637: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

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;

Line 638: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

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;

Line 647: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

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;

Line 648: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

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;

Line 659: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;

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();

Line 660: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;

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;