DBA Data[Home] [Help]

APPS.FII_PMV_UTIL dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 194: PROCEDURE get_parameters (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

190: when others then
191: return 'N/A';
192: END get_display_currency;
193:
194: PROCEDURE get_parameters (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
195: p_as_of_date OUT NOCOPY Date,
196: p_operating_unit OUT NOCOPY Varchar2,
197: p_supplier OUT NOCOPY Varchar2,
198: p_invoice_number OUT NOCOPY Number,

Line 405: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

401:
402: /*public procedure. binding variables is done here.*/
403: PROCEDURE Bind_Variable
404: (p_sqlstmt IN Varchar2,
405: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
406: p_sql_output OUT NOCOPY Varchar2,
407: p_bind_output_table OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL,
408: p_invoice_number IN Varchar2 Default null,
409: p_record_type_id IN Number Default Null,

Line 680: PROCEDURE get_invoice_id(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

676:
677: END;
678:
679: /*public function which gets invoice id for a given invoice number */
680: PROCEDURE get_invoice_id(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
681: p_invoice_id OUT NOCOPY Number)
682: IS
683: BEGIN
684: IF (p_page_parameter_tbl.count > 0) THEN

Line 694: PROCEDURE get_period_start(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

690: END IF;
691: END;
692: /*
693:
694: PROCEDURE get_period_start(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
695: p_period_start OUT NOCOPY Date,
696: p_days_into_period OUT NOCOPY Number,
697: p_cur_period OUT NOCOPY Number,
698: p_id_column OUT NOCOPY Varchar2)

Line 734: PROCEDURE get_period_start(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

730: p_days_into_period := l_as_of_date - p_period_start;
731: END;
732: */
733:
734: PROCEDURE get_period_start(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
735: p_period_start OUT NOCOPY Date,
736: p_days_into_period OUT NOCOPY Number,
737: p_cur_period OUT NOCOPY Number,
738: p_id_column OUT NOCOPY Varchar2)

Line 792: PROCEDURE get_period_strt(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

788: END CASE;
789:
790: END;
791:
792: PROCEDURE get_period_strt(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
793: p_period_start OUT NOCOPY Date,
794: p_days_into_period OUT NOCOPY Number,
795: p_cur_period OUT NOCOPY Number,
796: p_id_column OUT NOCOPY Varchar2)

Line 858: PROCEDURE get_report_source(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

854: END IF;
855: p_days_into_period := l_as_of_date - p_period_start;
856: END;
857:
858: PROCEDURE get_report_source(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
859: p_report_source OUT NOCOPY Varchar2)
860: IS
861: BEGIN
862: IF (p_page_parameter_tbl.count > 0) THEN

Line 871: PROCEDURE get_check_id(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

867: END LOOP;
868: END IF;
869: END;
870:
871: PROCEDURE get_check_id(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
872: p_check_id OUT NOCOPY Number)
873: IS
874: l_check_number Number;
875: BEGIN