DBA Data[Home] [Help]

APPS.PJI_REP_MEASURE_UTIL dependencies on PA_VARCHAR2_2000_TBL_TYPE

Line 40: , x_exception_indicator_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE

36: , p_measure_set_codes_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL
37: , p_timeslices_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL
38: , p_measure_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
39: , x_measure_values_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
40: , x_exception_indicator_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
41: --, x_exception_labels_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_240_TBL_TYPE -- remove
42: , x_return_status OUT NOCOPY VARCHAR2
43: , x_msg_count OUT NOCOPY NUMBER
44: , x_msg_data OUT NOCOPY VARCHAR2

Line 57: , x_exception_indicator_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE

53: , p_measure_set_codes_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL
54: , p_timeslices_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL
55: , p_measure_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
56: , x_measure_values_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
57: , x_exception_indicator_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
58: -- , x_exception_labels_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_240_TBL_TYPE -- remove
59: , x_return_status OUT NOCOPY VARCHAR2
60: , x_msg_count OUT NOCOPY NUMBER
61: , x_msg_data OUT NOCOPY VARCHAR2

Line 538: , x_exception_indicator_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE

534: , pWBSRollupFlag VARCHAR2 DEFAULT 'Y'
535: , pRBSRollupFlag VARCHAR2 DEFAULT 'Y'
536: , pCallingType VARCHAR2
537: , p_measure_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
538: , x_exception_indicator_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
539: , x_measure_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
540: , x_ptd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
541: , x_qtd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
542: , x_ytd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

Line 546: , x_ptd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE

542: , x_ytd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
543: , x_itd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
544: , x_ac_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
545: , x_prp_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
546: , x_ptd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
547: , x_qtd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
548: , x_ytd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
549: , x_itd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
550: , x_ac_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE

Line 547: , x_qtd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE

543: , x_itd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
544: , x_ac_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
545: , x_prp_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
546: , x_ptd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
547: , x_qtd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
548: , x_ytd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
549: , x_itd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
550: , x_ac_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
551: , x_prp_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE

Line 548: , x_ytd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE

544: , x_ac_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
545: , x_prp_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
546: , x_ptd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
547: , x_qtd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
548: , x_ytd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
549: , x_itd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
550: , x_ac_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
551: , x_prp_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
552: , x_ptd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

Line 549: , x_itd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE

545: , x_prp_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
546: , x_ptd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
547: , x_qtd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
548: , x_ytd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
549: , x_itd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
550: , x_ac_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
551: , x_prp_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
552: , x_ptd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
553: , x_ytd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

Line 550: , x_ac_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE

546: , x_ptd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
547: , x_qtd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
548: , x_ytd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
549: , x_itd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
550: , x_ac_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
551: , x_prp_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
552: , x_ptd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
553: , x_ytd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
554: , x_qtd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

Line 551: , x_prp_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE

547: , x_qtd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
548: , x_ytd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
549: , x_itd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
550: , x_ac_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
551: , x_prp_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
552: , x_ptd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
553: , x_ytd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
554: , x_qtd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
555: , x_itd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE