DBA Data[Home] [Help]

APPS.BIM_I_LEAD_MGMT_PVT dependencies on BIS_PMV_PAGE_PARAMETER_REC

Line 1058: BIS_PMV_PAGE_PARAMETER_REC('TIME_COMPARISON_TYPE','SEQUENTIAL','SEQUENTIAL','TIME_COMPARISON_TYPE',NULL),

1054: l_query_tbl bis_map_tbl := NULL;
1055: l_page_parameter_tbl BIS_PMV_PAGE_PARAMETER_TBL;
1056: /* :=
1057: BIS_PMV_PAGE_PARAMETER_TBL(
1058: BIS_PMV_PAGE_PARAMETER_REC('TIME_COMPARISON_TYPE','SEQUENTIAL','SEQUENTIAL','TIME_COMPARISON_TYPE',NULL),
1059: BIS_PMV_PAGE_PARAMETER_REC('TIME+FII_TIME_WEEK_PTO','20020936','36 2002','TIME',to_date('9/8/2002','MM/DD/YYYY')),
1060: BIS_PMV_PAGE_PARAMETER_REC('AS_OF_DATE','10/09/2002','10/09/2002',null,NULL),
1061: BIS_PMV_PAGE_PARAMETER_REC('TIME+FII_TIME_WEEK_TO','20020937','37 2002','TIME',to_date('9/15/2002','MM/DD/YYYY')),
1062: BIS_PMV_PAGE_PARAMETER_REC('PERIOD_TYPE','FII_TIME_WEEK','FII_TIME_WEEK','TIME',to_date('9/9/2002','MM/DD/YYYY')),

Line 1059: BIS_PMV_PAGE_PARAMETER_REC('TIME+FII_TIME_WEEK_PTO','20020936','36 2002','TIME',to_date('9/8/2002','MM/DD/YYYY')),

1055: l_page_parameter_tbl BIS_PMV_PAGE_PARAMETER_TBL;
1056: /* :=
1057: BIS_PMV_PAGE_PARAMETER_TBL(
1058: BIS_PMV_PAGE_PARAMETER_REC('TIME_COMPARISON_TYPE','SEQUENTIAL','SEQUENTIAL','TIME_COMPARISON_TYPE',NULL),
1059: BIS_PMV_PAGE_PARAMETER_REC('TIME+FII_TIME_WEEK_PTO','20020936','36 2002','TIME',to_date('9/8/2002','MM/DD/YYYY')),
1060: BIS_PMV_PAGE_PARAMETER_REC('AS_OF_DATE','10/09/2002','10/09/2002',null,NULL),
1061: BIS_PMV_PAGE_PARAMETER_REC('TIME+FII_TIME_WEEK_TO','20020937','37 2002','TIME',to_date('9/15/2002','MM/DD/YYYY')),
1062: BIS_PMV_PAGE_PARAMETER_REC('PERIOD_TYPE','FII_TIME_WEEK','FII_TIME_WEEK','TIME',to_date('9/9/2002','MM/DD/YYYY')),
1063: BIS_PMV_PAGE_PARAMETER_REC('TIME_COMPARISON_TYPE','SEQUENTIAL','SEQUENTIAL','TIME_COMPARISON_TYPE',null),

Line 1060: BIS_PMV_PAGE_PARAMETER_REC('AS_OF_DATE','10/09/2002','10/09/2002',null,NULL),

1056: /* :=
1057: BIS_PMV_PAGE_PARAMETER_TBL(
1058: BIS_PMV_PAGE_PARAMETER_REC('TIME_COMPARISON_TYPE','SEQUENTIAL','SEQUENTIAL','TIME_COMPARISON_TYPE',NULL),
1059: BIS_PMV_PAGE_PARAMETER_REC('TIME+FII_TIME_WEEK_PTO','20020936','36 2002','TIME',to_date('9/8/2002','MM/DD/YYYY')),
1060: BIS_PMV_PAGE_PARAMETER_REC('AS_OF_DATE','10/09/2002','10/09/2002',null,NULL),
1061: BIS_PMV_PAGE_PARAMETER_REC('TIME+FII_TIME_WEEK_TO','20020937','37 2002','TIME',to_date('9/15/2002','MM/DD/YYYY')),
1062: BIS_PMV_PAGE_PARAMETER_REC('PERIOD_TYPE','FII_TIME_WEEK','FII_TIME_WEEK','TIME',to_date('9/9/2002','MM/DD/YYYY')),
1063: BIS_PMV_PAGE_PARAMETER_REC('TIME_COMPARISON_TYPE','SEQUENTIAL','SEQUENTIAL','TIME_COMPARISON_TYPE',null),
1064: BIS_PMV_PAGE_PARAMETER_REC('ORDERBY','ORDERBY','BIM_MEASURE1',null,null),

Line 1061: BIS_PMV_PAGE_PARAMETER_REC('TIME+FII_TIME_WEEK_TO','20020937','37 2002','TIME',to_date('9/15/2002','MM/DD/YYYY')),

1057: BIS_PMV_PAGE_PARAMETER_TBL(
1058: BIS_PMV_PAGE_PARAMETER_REC('TIME_COMPARISON_TYPE','SEQUENTIAL','SEQUENTIAL','TIME_COMPARISON_TYPE',NULL),
1059: BIS_PMV_PAGE_PARAMETER_REC('TIME+FII_TIME_WEEK_PTO','20020936','36 2002','TIME',to_date('9/8/2002','MM/DD/YYYY')),
1060: BIS_PMV_PAGE_PARAMETER_REC('AS_OF_DATE','10/09/2002','10/09/2002',null,NULL),
1061: BIS_PMV_PAGE_PARAMETER_REC('TIME+FII_TIME_WEEK_TO','20020937','37 2002','TIME',to_date('9/15/2002','MM/DD/YYYY')),
1062: BIS_PMV_PAGE_PARAMETER_REC('PERIOD_TYPE','FII_TIME_WEEK','FII_TIME_WEEK','TIME',to_date('9/9/2002','MM/DD/YYYY')),
1063: BIS_PMV_PAGE_PARAMETER_REC('TIME_COMPARISON_TYPE','SEQUENTIAL','SEQUENTIAL','TIME_COMPARISON_TYPE',null),
1064: BIS_PMV_PAGE_PARAMETER_REC('ORDERBY','ORDERBY','BIM_MEASURE1',null,null),
1065: BIS_PMV_PAGE_PARAMETER_REC('TIME+FII_TIME_WEEK_PFROM','20020936','36 2002','TIME',to_date('9/2/2002','MM/DD/YYYY')),

Line 1062: BIS_PMV_PAGE_PARAMETER_REC('PERIOD_TYPE','FII_TIME_WEEK','FII_TIME_WEEK','TIME',to_date('9/9/2002','MM/DD/YYYY')),

1058: BIS_PMV_PAGE_PARAMETER_REC('TIME_COMPARISON_TYPE','SEQUENTIAL','SEQUENTIAL','TIME_COMPARISON_TYPE',NULL),
1059: BIS_PMV_PAGE_PARAMETER_REC('TIME+FII_TIME_WEEK_PTO','20020936','36 2002','TIME',to_date('9/8/2002','MM/DD/YYYY')),
1060: BIS_PMV_PAGE_PARAMETER_REC('AS_OF_DATE','10/09/2002','10/09/2002',null,NULL),
1061: BIS_PMV_PAGE_PARAMETER_REC('TIME+FII_TIME_WEEK_TO','20020937','37 2002','TIME',to_date('9/15/2002','MM/DD/YYYY')),
1062: BIS_PMV_PAGE_PARAMETER_REC('PERIOD_TYPE','FII_TIME_WEEK','FII_TIME_WEEK','TIME',to_date('9/9/2002','MM/DD/YYYY')),
1063: BIS_PMV_PAGE_PARAMETER_REC('TIME_COMPARISON_TYPE','SEQUENTIAL','SEQUENTIAL','TIME_COMPARISON_TYPE',null),
1064: BIS_PMV_PAGE_PARAMETER_REC('ORDERBY','ORDERBY','BIM_MEASURE1',null,null),
1065: BIS_PMV_PAGE_PARAMETER_REC('TIME+FII_TIME_WEEK_PFROM','20020936','36 2002','TIME',to_date('9/2/2002','MM/DD/YYYY')),
1066: BIS_PMV_PAGE_PARAMETER_REC('ORGANIZATION+JTF_ORG_SALES_GROUP','''100000001'',''100000148'',''100000217''','-- LELLISON','ORGANIZATION',NULL)

Line 1063: BIS_PMV_PAGE_PARAMETER_REC('TIME_COMPARISON_TYPE','SEQUENTIAL','SEQUENTIAL','TIME_COMPARISON_TYPE',null),

1059: BIS_PMV_PAGE_PARAMETER_REC('TIME+FII_TIME_WEEK_PTO','20020936','36 2002','TIME',to_date('9/8/2002','MM/DD/YYYY')),
1060: BIS_PMV_PAGE_PARAMETER_REC('AS_OF_DATE','10/09/2002','10/09/2002',null,NULL),
1061: BIS_PMV_PAGE_PARAMETER_REC('TIME+FII_TIME_WEEK_TO','20020937','37 2002','TIME',to_date('9/15/2002','MM/DD/YYYY')),
1062: BIS_PMV_PAGE_PARAMETER_REC('PERIOD_TYPE','FII_TIME_WEEK','FII_TIME_WEEK','TIME',to_date('9/9/2002','MM/DD/YYYY')),
1063: BIS_PMV_PAGE_PARAMETER_REC('TIME_COMPARISON_TYPE','SEQUENTIAL','SEQUENTIAL','TIME_COMPARISON_TYPE',null),
1064: BIS_PMV_PAGE_PARAMETER_REC('ORDERBY','ORDERBY','BIM_MEASURE1',null,null),
1065: BIS_PMV_PAGE_PARAMETER_REC('TIME+FII_TIME_WEEK_PFROM','20020936','36 2002','TIME',to_date('9/2/2002','MM/DD/YYYY')),
1066: BIS_PMV_PAGE_PARAMETER_REC('ORGANIZATION+JTF_ORG_SALES_GROUP','''100000001'',''100000148'',''100000217''','-- LELLISON','ORGANIZATION',NULL)
1067: );*/

Line 1064: BIS_PMV_PAGE_PARAMETER_REC('ORDERBY','ORDERBY','BIM_MEASURE1',null,null),

1060: BIS_PMV_PAGE_PARAMETER_REC('AS_OF_DATE','10/09/2002','10/09/2002',null,NULL),
1061: BIS_PMV_PAGE_PARAMETER_REC('TIME+FII_TIME_WEEK_TO','20020937','37 2002','TIME',to_date('9/15/2002','MM/DD/YYYY')),
1062: BIS_PMV_PAGE_PARAMETER_REC('PERIOD_TYPE','FII_TIME_WEEK','FII_TIME_WEEK','TIME',to_date('9/9/2002','MM/DD/YYYY')),
1063: BIS_PMV_PAGE_PARAMETER_REC('TIME_COMPARISON_TYPE','SEQUENTIAL','SEQUENTIAL','TIME_COMPARISON_TYPE',null),
1064: BIS_PMV_PAGE_PARAMETER_REC('ORDERBY','ORDERBY','BIM_MEASURE1',null,null),
1065: BIS_PMV_PAGE_PARAMETER_REC('TIME+FII_TIME_WEEK_PFROM','20020936','36 2002','TIME',to_date('9/2/2002','MM/DD/YYYY')),
1066: BIS_PMV_PAGE_PARAMETER_REC('ORGANIZATION+JTF_ORG_SALES_GROUP','''100000001'',''100000148'',''100000217''','-- LELLISON','ORGANIZATION',NULL)
1067: );*/
1068: BEGIN

Line 1065: BIS_PMV_PAGE_PARAMETER_REC('TIME+FII_TIME_WEEK_PFROM','20020936','36 2002','TIME',to_date('9/2/2002','MM/DD/YYYY')),

1061: BIS_PMV_PAGE_PARAMETER_REC('TIME+FII_TIME_WEEK_TO','20020937','37 2002','TIME',to_date('9/15/2002','MM/DD/YYYY')),
1062: BIS_PMV_PAGE_PARAMETER_REC('PERIOD_TYPE','FII_TIME_WEEK','FII_TIME_WEEK','TIME',to_date('9/9/2002','MM/DD/YYYY')),
1063: BIS_PMV_PAGE_PARAMETER_REC('TIME_COMPARISON_TYPE','SEQUENTIAL','SEQUENTIAL','TIME_COMPARISON_TYPE',null),
1064: BIS_PMV_PAGE_PARAMETER_REC('ORDERBY','ORDERBY','BIM_MEASURE1',null,null),
1065: BIS_PMV_PAGE_PARAMETER_REC('TIME+FII_TIME_WEEK_PFROM','20020936','36 2002','TIME',to_date('9/2/2002','MM/DD/YYYY')),
1066: BIS_PMV_PAGE_PARAMETER_REC('ORGANIZATION+JTF_ORG_SALES_GROUP','''100000001'',''100000148'',''100000217''','-- LELLISON','ORGANIZATION',NULL)
1067: );*/
1068: BEGIN
1069: NULL;

Line 1066: BIS_PMV_PAGE_PARAMETER_REC('ORGANIZATION+JTF_ORG_SALES_GROUP','''100000001'',''100000148'',''100000217''','-- LELLISON','ORGANIZATION',NULL)

1062: BIS_PMV_PAGE_PARAMETER_REC('PERIOD_TYPE','FII_TIME_WEEK','FII_TIME_WEEK','TIME',to_date('9/9/2002','MM/DD/YYYY')),
1063: BIS_PMV_PAGE_PARAMETER_REC('TIME_COMPARISON_TYPE','SEQUENTIAL','SEQUENTIAL','TIME_COMPARISON_TYPE',null),
1064: BIS_PMV_PAGE_PARAMETER_REC('ORDERBY','ORDERBY','BIM_MEASURE1',null,null),
1065: BIS_PMV_PAGE_PARAMETER_REC('TIME+FII_TIME_WEEK_PFROM','20020936','36 2002','TIME',to_date('9/2/2002','MM/DD/YYYY')),
1066: BIS_PMV_PAGE_PARAMETER_REC('ORGANIZATION+JTF_ORG_SALES_GROUP','''100000001'',''100000148'',''100000217''','-- LELLISON','ORGANIZATION',NULL)
1067: );*/
1068: BEGIN
1069: NULL;
1070: --GET_KPI_SQL(l_page_parameter_tbl,l_query_tbl);