APPS.PJI_REP_MEASURE_UTIL dependencies on PA_NUM_TBL_TYPE

Line 26: , x_measure_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

22: (
23: p_measure_codes_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
24: , x_measure_set_codes_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
25: , x_timeslices_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
26: , x_measure_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
27: , x_return_status OUT NOCOPY VARCHAR2
28: , x_msg_count OUT NOCOPY NUMBER
29: , x_msg_data OUT NOCOPY VARCHAR2 -- not used
30: );

Line 38: , p_measure_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL

34: p_project_id NUMBER
35: , p_measure_codes_tbl IN SYSTEM.PA_VARCHAR2_80_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

Line 53: , p_measure_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL

49: p_project_id NUMBER
50: , p_measure_codes_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
51: , p_measure_set_codes_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL
52: , p_timeslices_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL
53: , p_measure_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
54: , x_measure_values_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
55: , x_exception_indicator_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
56: -- , x_exception_labels_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_240_TBL_TYPE -- remove
57: , x_return_status OUT NOCOPY VARCHAR2

Line 535: , p_measure_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL

531: , p_raw_text_flag VARCHAR2 DEFAULT 'Y'
532: , pWBSRollupFlag VARCHAR2 DEFAULT 'Y'
533: , pRBSRollupFlag VARCHAR2 DEFAULT 'Y'
534: , pCallingType VARCHAR2
535: , p_measure_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
536: , x_exception_indicator_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
537: , x_measure_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
538: , x_ptd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
539: , x_qtd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

Line 550: , x_ptd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

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

Line 551: , x_ytd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

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

Line 552: , x_qtd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

548: , x_ac_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
549: , x_prp_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
550: , x_ptd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
551: , x_ytd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
552: , x_qtd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
553: , x_itd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
554: , x_ac_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
555: , x_prp_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
556: , x_ptd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

Line 553: , x_itd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

549: , x_prp_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
550: , x_ptd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
551: , x_ytd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
552: , x_qtd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
553: , x_itd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
554: , x_ac_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
555: , x_prp_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
556: , x_ptd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
557: , x_ytd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

Line 554: , x_ac_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

550: , x_ptd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
551: , x_ytd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
552: , x_qtd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
553: , x_itd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
554: , x_ac_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
555: , x_prp_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
556: , x_ptd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
557: , x_ytd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
558: , x_qtd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

Line 555: , x_prp_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

551: , x_ytd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
552: , x_qtd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
553: , x_itd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
554: , x_ac_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
555: , x_prp_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
556: , x_ptd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
557: , x_ytd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
558: , x_qtd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
559: , x_itd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE