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.OKI_DBI_SRM_PDUE_PVT dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 21: p_param IN bis_pmv_page_parameter_tbl)

17: , l_view_by_col IN VARCHAR2)
18: RETURN VARCHAR2;
19:
20: FUNCTION get_blgopn_itd_sql (
21: p_param IN bis_pmv_page_parameter_tbl)
22: RETURN VARCHAR2;
23:
24: FUNCTION get_pdue_open_2way_sql (
25: l_pastdue_where IN VARCHAR2

Line 44: p_param IN bis_pmv_page_parameter_tbl

40: FUNCTION get_template_sel_clause
41: RETURN VARCHAR2;
42:
43: FUNCTION get_blg_itd_sql (
44: p_param IN bis_pmv_page_parameter_tbl
45: ) RETURN VARCHAR2;
46:
47: FUNCTION get_opn_itd_sql (
48: p_param IN bis_pmv_page_parameter_tbl

Line 48: p_param IN bis_pmv_page_parameter_tbl

44: p_param IN bis_pmv_page_parameter_tbl
45: ) RETURN VARCHAR2;
46:
47: FUNCTION get_opn_itd_sql (
48: p_param IN bis_pmv_page_parameter_tbl
49: ) RETURN VARCHAR2;
50:
51:
52: --DBI7.0

Line 58: p_param IN bis_pmv_page_parameter_tbl)

54: RETURN VARCHAR2;
55:
56:
57: FUNCTION get_YTD_by_cust_sql(
58: p_param IN bis_pmv_page_parameter_tbl)
59: RETURN VARCHAR2;
60: FUNCTION get_YTD_by_cust_sel_clause
61: RETURN VARCHAR2;
62: FUNCTION get_ITD_by_cust_sql(

Line 63: p_param IN bis_pmv_page_parameter_tbl)

59: RETURN VARCHAR2;
60: FUNCTION get_YTD_by_cust_sel_clause
61: RETURN VARCHAR2;
62: FUNCTION get_ITD_by_cust_sql(
63: p_param IN bis_pmv_page_parameter_tbl)
64: RETURN VARCHAR2;
65: FUNCTION get_ITD_by_cust_sel_clause
66: RETURN VARCHAR2;
67: */

Line 70: p_param IN bis_pmv_page_parameter_tbl,

66: RETURN VARCHAR2;
67: */
68:
69: PROCEDURE get_blg_opn_ytd_sql (
70: p_param IN bis_pmv_page_parameter_tbl,
71: p_backlog_ytd OUT NOCOPY VARCHAR2,
72: p_open_ytd OUT NOCOPY VARCHAR2
73: );
74:

Line 82: p_param IN bis_pmv_page_parameter_tbl

78: Table portlet
79: *******************************************************************************/
80:
81: PROCEDURE get_table_sql (
82: p_param IN bis_pmv_page_parameter_tbl
83: , x_custom_sql OUT NOCOPY VARCHAR2
84: , x_custom_output OUT NOCOPY bis_query_attributes_tbl)
85: IS
86:

Line 475: p_param IN bis_pmv_page_parameter_tbl

471: END get_ytd_sel_clause;
472:
473:
474: FUNCTION get_blgopn_itd_sql (
475: p_param IN bis_pmv_page_parameter_tbl
476: ) RETURN VARCHAR2
477: IS
478: l_view_by VARCHAR2 (120);
479: l_view_by_col VARCHAR2 (120);

Line 662: p_param IN bis_pmv_page_parameter_tbl

658: Description: Function to retrieve the sql statement for the past due renewal
659: Detail portlet
660: *******************************************************************************/
661: PROCEDURE get_pduernwldetail_sql (
662: p_param IN bis_pmv_page_parameter_tbl
663: , x_custom_sql OUT NOCOPY VARCHAR2
664: , x_custom_output OUT NOCOPY bis_query_attributes_tbl)
665: IS
666:

Line 842: p_param IN bis_pmv_page_parameter_tbl

838: portlet
839: *******************************************************************************/
840:
841: PROCEDURE get_pastdue_percent_sql (
842: p_param IN bis_pmv_page_parameter_tbl
843: , x_custom_sql OUT NOCOPY VARCHAR2
844: , x_custom_output OUT NOCOPY bis_query_attributes_tbl)
845: IS
846:

Line 1156: p_param IN bis_pmv_page_parameter_tbl

1152: TREND portlet
1153: *******************************************************************************/
1154:
1155: PROCEDURE get_trend_sql (
1156: p_param IN bis_pmv_page_parameter_tbl
1157: , x_custom_sql OUT NOCOPY VARCHAR2
1158: , x_custom_output OUT NOCOPY bis_query_attributes_tbl)
1159: IS
1160:

Line 1598: p_param IN bis_pmv_page_parameter_tbl,

1594: END get_template_sel_clause ;
1595:
1596:
1597: PROCEDURE get_blg_opn_ytd_sql (
1598: p_param IN bis_pmv_page_parameter_tbl,
1599: p_backlog_ytd OUT NOCOPY VARCHAR2,
1600: p_open_ytd OUT NOCOPY VARCHAR2
1601: )
1602: IS

Line 1817: p_param IN bis_pmv_page_parameter_tbl

1813: END get_blg_opn_ytd_sql;
1814:
1815:
1816: FUNCTION get_blg_itd_sql (
1817: p_param IN bis_pmv_page_parameter_tbl
1818: ) RETURN VARCHAR2
1819: IS
1820: l_view_by VARCHAR2 (120);
1821: l_view_by_col VARCHAR2 (120);

Line 1884: p_param IN bis_pmv_page_parameter_tbl

1880: END get_blg_itd_sql;
1881:
1882:
1883: FUNCTION get_opn_itd_sql (
1884: p_param IN bis_pmv_page_parameter_tbl
1885: ) RETURN VARCHAR2
1886: IS
1887: l_view_by VARCHAR2 (120);
1888: l_view_by_col VARCHAR2 (120);

Line 1956: p_param IN bis_pmv_page_parameter_tbl

1952: the ITD measures and YTD Measures to calculate the past due value.
1953: /*******************************************************************************/
1954:
1955: PROCEDURE get_pdueval_cust_sql (
1956: p_param IN bis_pmv_page_parameter_tbl
1957: , x_custom_sql OUT NOCOPY VARCHAR2
1958: , x_custom_output OUT NOCOPY bis_query_attributes_tbl)
1959: IS
1960: l_query VARCHAR2 (32767);

Line 1997: FUNCTION get_YTD_by_cust_sql(p_param IN bis_pmv_page_parameter_tbl)

1993: FUNCTION get_YTD_by_cust_sql() returns the portion of the SQL query containing
1994: YTD measures.
1995: /*******************************************************************************/
1996: /*
1997: FUNCTION get_YTD_by_cust_sql(p_param IN bis_pmv_page_parameter_tbl)
1998: RETURN VARCHAR2
1999: AS
2000: l_query VARCHAR2 (32767);
2001:

Line 2027: FUNCTION get_ITD_by_cust_sql(p_param IN bis_pmv_page_parameter_tbl)

2023: FUNCTION get_ITD_by_cust_sql() returns the SQL portion of the Query containing
2024: ITD measures.
2025: /******************************************************************************/
2026: /*
2027: FUNCTION get_ITD_by_cust_sql(p_param IN bis_pmv_page_parameter_tbl)
2028: RETURN VARCHAR2
2029: AS
2030: l_query VARCHAR2 (32767);
2031: BEGIN