eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIM_I_LEAD_MGMT_PVT dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 83: FUNCTION GLbl( p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,colno in number )

79: -- Procedure to enable change of column Name's in Reports dynamically
80: -- **********************************************************************
81:
82:
83: FUNCTION GLbl( p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,colno in number )
84: RETURN VARCHAR2 IS
85: l_metric_def VARCHAR2(5000);
86: l_report_def VARCHAR2(5000);
87: l_view_by varchar2(5000);

Line 163: PROCEDURE GET_PAGE_PARAMS (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

159: -- **********************************************************************
160: -- PROCEDURE GET_PAGE_PARAMS
161: --
162: -- **********************************************************************
163: PROCEDURE GET_PAGE_PARAMS (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
164: p_period_type OUT NOCOPY VARCHAR2,
165: p_record_type OUT NOCOPY VARCHAR2,
166: p_sg_id OUT NOCOPY VARCHAR2,
167: p_resource_id OUT NOCOPY VARCHAR2,

Line 417: PROCEDURE GET_CURRENCY (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

413: -- **********************************************************************
414: -- PROCEDURE GET_CURRENCY
415: --
416: -- **********************************************************************
417: PROCEDURE GET_CURRENCY (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
418: l_currency OUT NOCOPY VARCHAR2)
419:
420: IS
421: BEGIN

Line 619: PROCEDURE GET_KPI_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

615: -- HISTORY
616: -- 08/27/2002 dmvincen created.
617: --
618: -- End of comments
619: PROCEDURE GET_KPI_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
620: x_custom_sql OUT NOCOPY VARCHAR2,
621: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
622: IS
623: l_query_rec bis_map_rec;

Line 1055: l_page_parameter_tbl BIS_PMV_PAGE_PARAMETER_TBL;

1051:
1052: PROCEDURE TEST_KPI_SQL
1053: IS
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')),

Line 1057: BIS_PMV_PAGE_PARAMETER_TBL(

1053: IS
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')),

Line 1089: PROCEDURE GET_LEAD_AGE_KPI_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

1085: --
1086: -- End of comments
1087:
1088:
1089: PROCEDURE GET_LEAD_AGE_KPI_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
1090: x_custom_sql OUT NOCOPY VARCHAR2,
1091: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1092: IS
1093: l_period_type varchar2(80) := NULL;

Line 1268: PROCEDURE GET_LEAD_ACT_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

1264: -- PURPOSE
1265: -- Returns the Lead activity and conversion query.
1266: --
1267:
1268: PROCEDURE GET_LEAD_ACT_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
1269: x_custom_sql OUT NOCOPY VARCHAR2,
1270: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1271: IS
1272: l_current_asof_date varchar2(80) := null;

Line 3120: PROCEDURE GET_LEAD_CONV_P_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

3116: END;
3117:
3118:
3119:
3120: PROCEDURE GET_LEAD_CONV_P_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
3121: x_custom_sql OUT NOCOPY VARCHAR2,
3122: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
3123: IS
3124: l_current_asof_date varchar2(80) := null;

Line 4671: PROCEDURE GET_LEAD_CONV_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

4667: l_error_msg := SQLERRM;
4668:
4669: END;
4670:
4671: PROCEDURE GET_LEAD_CONV_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
4672: x_custom_sql OUT NOCOPY VARCHAR2,
4673: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
4674: IS
4675: l_current_asof_date varchar2(80) := null;

Line 7884: PROCEDURE GET_LEAD_AGING_QU_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

7880: -- HISTORY
7881: -- 08/27/2002 dmvincen created.
7882: --
7883: -- End of comments
7884: PROCEDURE GET_LEAD_AGING_QU_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
7885: x_custom_sql OUT NOCOPY VARCHAR2,
7886: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
7887: IS
7888: l_current_asof_date varchar2(80) := null;

Line 8052: PROCEDURE GET_LEAD_QUALITY_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

8048: --
8049: --
8050: -- End of comments
8051:
8052: PROCEDURE GET_LEAD_QUALITY_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
8053: x_custom_sql OUT NOCOPY VARCHAR2,
8054: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
8055: IS
8056: l_current_asof_date varchar2(80) := null;

Line 9224: PROCEDURE GET_LEAD_AGING_SG_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

9220: --
9221: -- End of comments
9222:
9223:
9224: PROCEDURE GET_LEAD_AGING_SG_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
9225: x_custom_sql OUT NOCOPY VARCHAR2,
9226: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
9227: IS
9228: l_current_asof_date varchar2(80) := null;

Line 10213: PROCEDURE GET_LEAD_OPP_CHART_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

10209: -- 08/27/2002 dmvincen created.
10210: --
10211: -- End of comments
10212:
10213: PROCEDURE GET_LEAD_OPP_CHART_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
10214: x_custom_sql OUT NOCOPY VARCHAR2,
10215: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
10216: IS
10217: l_current_asof_date varchar2(80) := null;

Line 11567: PROCEDURE GET_LEAD_CAMP_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

11563: l_error := SQLERRM;
11564: --test('GET_LEAD_OPP_CHART_SQL','EXCEPTION',l_error);
11565: END;
11566:
11567: PROCEDURE GET_LEAD_CAMP_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
11568: x_custom_sql OUT NOCOPY VARCHAR2,
11569: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
11570: IS
11571: l_current_asof_date varchar2(80) := null;

Line 11840: PROCEDURE GET_LEAD_DETAIL_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

11836:
11837: --- commented the code having outer join ,below is the other version using MV..
11838:
11839: /*
11840: PROCEDURE GET_LEAD_DETAIL_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
11841: x_custom_sql OUT NOCOPY VARCHAR2,
11842: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
11843: IS
11844:

Line 12357: PROCEDURE GET_LEAD_DETAIL_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

12353:
12354: -- Procedure to get lead attributes from mview
12355:
12356:
12357: PROCEDURE GET_LEAD_DETAIL_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
12358: x_custom_sql OUT NOCOPY VARCHAR2,
12359: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
12360: IS
12361: