APPS.OPI_DBI_INV_CURR_RPT_PKG dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 38: (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,

34:
35: /* Current Inventory Status */
36: -- Set up the in_join table for viewby grade.
37: PROCEDURE get_curr_inv_stat_mln
38: (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
39: p_query IN OUT NOCOPY VARCHAR2);
40:
41: -- Set up the in_join table for viewby item cat.
42: PROCEDURE get_curr_inv_stat_eni

Line 43: (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,

39: p_query IN OUT NOCOPY VARCHAR2);
40:
41: -- Set up the in_join table for viewby item cat.
42: PROCEDURE get_curr_inv_stat_eni
43: (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
44: p_query IN OUT NOCOPY VARCHAR2);
45:
46: -- Get fixed view by columns for Current Inventory Status
47: -- inner SQL.

Line 55: (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,

51: p_query IN OUT NOCOPY VARCHAR2);
52:
53: -- Parameter condition where clauses
54: PROCEDURE get_curr_inv_stat_param_cond
55: (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
56: p_query IN OUT NOCOPY VARCHAR2);
57:
58: -- Security Where clause
59: PROCEDURE get_curr_inv_sec_where_clause

Line 60: (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,

56: p_query IN OUT NOCOPY VARCHAR2);
57:
58: -- Security Where clause
59: PROCEDURE get_curr_inv_sec_where_clause
60: (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
61: p_query IN OUT NOCOPY VARCHAR2);
62:
63: -- Concatenated, formatted viewby column
64: FUNCTION get_curr_inv_viewby_format (p_viewby IN VARCHAR2)

Line 100: PROCEDURE get_curr_inv_exp_stat_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,

96:
97: Date Author Action
98: 07/11/05 Dinkar Gupta Wrote Function
99: */
100: PROCEDURE get_curr_inv_exp_stat_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
101: x_custom_sql OUT NOCOPY VARCHAR2,
102: x_custom_output OUT NOCOPY
103: BIS_QUERY_ATTRIBUTES_TBL)
104: IS

Line 455: PROCEDURE get_inv_days_onh_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,

451:
452: Date Author Action
453: 07/11/05 Dinkar Gupta Wrote Function
454: */
455: PROCEDURE get_inv_days_onh_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
456: x_custom_sql OUT NOCOPY VARCHAR2,
457: x_custom_output OUT NOCOPY
458: BIS_QUERY_ATTRIBUTES_TBL)
459: IS

Line 1130: PROCEDURE get_curr_inv_stat_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,

1126:
1127: Date Author Action
1128: 07/18/05 Dinkar Gupta Wrote Function
1129: */
1130: PROCEDURE get_curr_inv_stat_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
1131: x_custom_sql OUT NOCOPY VARCHAR2,
1132: x_custom_output OUT NOCOPY
1133: BIS_QUERY_ATTRIBUTES_TBL)
1134: IS

Line 1281: (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,

1277: Date Author Action
1278: 07/18/05 Dinkar Gupta Wrote Function
1279: */
1280: PROCEDURE get_curr_inv_stat_mln
1281: (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
1282: p_query IN OUT NOCOPY VARCHAR2)
1283: IS
1284: -- {
1285:

Line 1376: (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,

1372: Date Author Action
1373: 07/18/05 Dinkar Gupta Wrote Function
1374: */
1375: PROCEDURE get_curr_inv_stat_eni
1376: (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
1377: p_query IN OUT NOCOPY VARCHAR2)
1378: IS
1379: -- {
1380: l_join_eni BOOLEAN;

Line 1576: (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,

1572: Date Author Action
1573: 07/18/05 Dinkar Gupta Wrote Function
1574: */
1575: PROCEDURE get_curr_inv_stat_param_cond
1576: (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
1577: p_query IN OUT NOCOPY VARCHAR2)
1578: IS
1579: -- {
1580:

Line 1688: (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,

1684: Date Author Action
1685: 07/18/05 Dinkar Gupta Wrote Function
1686: */
1687: PROCEDURE get_curr_inv_sec_where_clause
1688: (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
1689: p_query IN OUT NOCOPY VARCHAR2)
1690: IS
1691: -- {
1692: l_security_where_clause VARCHAR2 (2000);