DBA Data[Home] [Help]

APPS.OKI_DBI_NSCM_EXP_PVT dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 30: , x_custom_output OUT NOCOPY bis_query_attributes_tbl)

26:
27: PROCEDURE get_expirations_sql (
28: p_param IN bis_pmv_page_parameter_tbl
29: , x_custom_sql OUT NOCOPY VARCHAR2
30: , x_custom_output OUT NOCOPY bis_query_attributes_tbl)
31: IS
32:
33: l_query VARCHAR2 (32767);
34: l_view_by VARCHAR2 (120);

Line 137: , x_custom_output OUT NOCOPY bis_query_attributes_tbl)

133:
134: PROCEDURE get_period_expiring_sql (
135: p_param IN bis_pmv_page_parameter_tbl
136: , x_custom_sql OUT NOCOPY VARCHAR2
137: , x_custom_output OUT NOCOPY bis_query_attributes_tbl)
138: IS
139:
140: l_query VARCHAR2 (32767);
141: l_view_by VARCHAR2 (120);

Line 680: , x_custom_output OUT NOCOPY bis_query_attributes_tbl)

676:
677: PROCEDURE get_expirations_detail_sql (
678: p_param IN bis_pmv_page_parameter_tbl
679: , x_custom_sql OUT NOCOPY VARCHAR2
680: , x_custom_output OUT NOCOPY bis_query_attributes_tbl)
681: IS
682:
683: l_query VARCHAR2 (32767);
684: l_view_by VARCHAR2 (120);

Line 881: , x_custom_output OUT NOCOPY bis_query_attributes_tbl)

877:
878: PROCEDURE get_prd_exp_cont_dtl_sql (
879: p_param IN bis_pmv_page_parameter_tbl
880: , x_custom_sql OUT NOCOPY VARCHAR2
881: , x_custom_output OUT NOCOPY bis_query_attributes_tbl)
882: IS
883:
884: l_query VARCHAR2 (32767);
885: l_view_by VARCHAR2 (120);

Line 1054: , x_custom_output OUT NOCOPY bis_query_attributes_tbl) IS

1050:
1051: PROCEDURE get_exp_dist_sql (
1052: p_param IN bis_pmv_page_parameter_tbl
1053: , x_custom_sql OUT NOCOPY VARCHAR2
1054: , x_custom_output OUT NOCOPY bis_query_attributes_tbl) IS
1055:
1056: l_query VARCHAR2 (32767);
1057: l_as_of_date DATE;
1058: l_prev_as_of_date DATE;