eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 55: , p_measure_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL

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

Line 537: , p_measure_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL

533: , p_raw_text_flag VARCHAR2 DEFAULT 'Y'
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

Line 552: , x_ptd_trans_id OUT NOCOPY SYSTEM.PA_NUM_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
556: , x_ac_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

Line 553: , x_ytd_trans_id OUT NOCOPY SYSTEM.PA_NUM_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
556: , x_ac_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
557: , x_prp_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

Line 554: , x_qtd_trans_id OUT NOCOPY SYSTEM.PA_NUM_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
556: , x_ac_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
557: , x_prp_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
558: , x_ptd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

Line 555: , x_itd_trans_id OUT NOCOPY SYSTEM.PA_NUM_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
556: , x_ac_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
557: , x_prp_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
558: , x_ptd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
559: , x_ytd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

Line 556: , x_ac_trans_id OUT NOCOPY SYSTEM.PA_NUM_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
556: , x_ac_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
557: , x_prp_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
558: , x_ptd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
559: , x_ytd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
560: , x_qtd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

Line 557: , x_prp_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
556: , x_ac_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
557: , x_prp_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
558: , x_ptd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
559: , x_ytd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
560: , x_qtd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
561: , x_itd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

Line 587: p_project_id_tbl IN SYSTEM.pa_num_tbl_type

583: * and returns back 2 tables of records
584: */
585: PROCEDURE Get_Financial_Measures_wrp
586: (
587: p_project_id_tbl IN SYSTEM.pa_num_tbl_type
588: , p_measure_codes_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
589: , p_measure_set_codes_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL
590: , p_timeslices_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL
591: , p_measure_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL

Line 591: , p_measure_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL

587: p_project_id_tbl IN SYSTEM.pa_num_tbl_type
588: , p_measure_codes_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
589: , p_measure_set_codes_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL
590: , p_timeslices_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL
591: , p_measure_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
592: , x_measure_values_tbl OUT NOCOPY SYSTEM.PJI_FIN_MEAS_REC_TBL_TYPE
593: , x_exception_indicator_tbl OUT NOCOPY SYSTEM.PJI_EXCP_IND_REC_TBL_TYPE
594: --, x_exception_labels_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_240_TBL_TYPE
595: , x_return_status OUT NOCOPY VARCHAR2