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.

[Home] [Help]

APPS.PJI_REP_MEASURE_UTIL dependencies on PJI_EXCP_IND_REC

Line 10018: , x_exception_indicator_tbl OUT NOCOPY SYSTEM.PJI_EXCP_IND_REC_TBL_TYPE

10014: , p_measure_set_codes_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL
10015: , p_timeslices_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL
10016: , p_measure_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
10017: , x_measure_values_tbl OUT NOCOPY SYSTEM.PJI_FIN_MEAS_REC_TBL_TYPE
10018: , x_exception_indicator_tbl OUT NOCOPY SYSTEM.PJI_EXCP_IND_REC_TBL_TYPE
10019: --, x_exception_labels_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_240_TBL_TYPE
10020: , x_return_status OUT NOCOPY VARCHAR2
10021: , x_msg_count OUT NOCOPY NUMBER
10022: , x_msg_data OUT NOCOPY VARCHAR2 -- not used

Line 10038: l_pji_excp_ind_rec SYSTEM.PJI_EXCP_IND_REC;

10034:
10035: l_pji_fin_meas_rec SYSTEM.PJI_FIN_MEAS_REC;
10036: l_pji_fin_meas_rec_tbl SYSTEM.PJI_FIN_MEAS_REC_TBL_TYPE ;
10037:
10038: l_pji_excp_ind_rec SYSTEM.PJI_EXCP_IND_REC;
10039: l_pji_excp_ind_rec_tbl SYSTEM.PJI_EXCP_IND_REC_TBL_TYPE;
10040:
10041: l_project_id_tbl SYSTEM.pa_num_tbl_type;
10042:

Line 10039: l_pji_excp_ind_rec_tbl SYSTEM.PJI_EXCP_IND_REC_TBL_TYPE;

10035: l_pji_fin_meas_rec SYSTEM.PJI_FIN_MEAS_REC;
10036: l_pji_fin_meas_rec_tbl SYSTEM.PJI_FIN_MEAS_REC_TBL_TYPE ;
10037:
10038: l_pji_excp_ind_rec SYSTEM.PJI_EXCP_IND_REC;
10039: l_pji_excp_ind_rec_tbl SYSTEM.PJI_EXCP_IND_REC_TBL_TYPE;
10040:
10041: l_project_id_tbl SYSTEM.pa_num_tbl_type;
10042:
10043: BEGIN

Line 10061: l_pji_excp_ind_rec := NULL ;

10057:
10058: l_pji_fin_meas_rec_tbl.extend((p_project_id_tbl.COUNT - 1 ));
10059:
10060: -------------
10061: l_pji_excp_ind_rec := NULL ;
10062: l_pji_excp_ind_rec_tbl := SYSTEM.PJI_EXCP_IND_REC_TBL_TYPE();
10063: l_pji_excp_ind_rec_tbl := SYSTEM.PJI_EXCP_IND_REC_TBL_TYPE (l_pji_excp_ind_rec); -- initialize
10064:
10065: l_pji_excp_ind_rec_tbl.extend((p_project_id_tbl.COUNT - 1 ));

Line 10062: l_pji_excp_ind_rec_tbl := SYSTEM.PJI_EXCP_IND_REC_TBL_TYPE();

10058: l_pji_fin_meas_rec_tbl.extend((p_project_id_tbl.COUNT - 1 ));
10059:
10060: -------------
10061: l_pji_excp_ind_rec := NULL ;
10062: l_pji_excp_ind_rec_tbl := SYSTEM.PJI_EXCP_IND_REC_TBL_TYPE();
10063: l_pji_excp_ind_rec_tbl := SYSTEM.PJI_EXCP_IND_REC_TBL_TYPE (l_pji_excp_ind_rec); -- initialize
10064:
10065: l_pji_excp_ind_rec_tbl.extend((p_project_id_tbl.COUNT - 1 ));
10066:

Line 10063: l_pji_excp_ind_rec_tbl := SYSTEM.PJI_EXCP_IND_REC_TBL_TYPE (l_pji_excp_ind_rec); -- initialize

10059:
10060: -------------
10061: l_pji_excp_ind_rec := NULL ;
10062: l_pji_excp_ind_rec_tbl := SYSTEM.PJI_EXCP_IND_REC_TBL_TYPE();
10063: l_pji_excp_ind_rec_tbl := SYSTEM.PJI_EXCP_IND_REC_TBL_TYPE (l_pji_excp_ind_rec); -- initialize
10064:
10065: l_pji_excp_ind_rec_tbl.extend((p_project_id_tbl.COUNT - 1 ));
10066:
10067: --------------

Line 10065: l_pji_excp_ind_rec_tbl.extend((p_project_id_tbl.COUNT - 1 ));

10061: l_pji_excp_ind_rec := NULL ;
10062: l_pji_excp_ind_rec_tbl := SYSTEM.PJI_EXCP_IND_REC_TBL_TYPE();
10063: l_pji_excp_ind_rec_tbl := SYSTEM.PJI_EXCP_IND_REC_TBL_TYPE (l_pji_excp_ind_rec); -- initialize
10064:
10065: l_pji_excp_ind_rec_tbl.extend((p_project_id_tbl.COUNT - 1 ));
10066:
10067: --------------
10068:
10069: FOR i IN l_project_id_tbl.FIRST .. l_project_id_tbl.LAST LOOP

Line 10282: l_pji_excp_ind_rec := SYSTEM.PJI_EXCP_IND_REC( p_project_id_tbl(i),

10278: l_pji_fin_meas_rec_tbl(i) := l_pji_fin_meas_rec;
10279:
10280: ----------------
10281:
10282: l_pji_excp_ind_rec := SYSTEM.PJI_EXCP_IND_REC( p_project_id_tbl(i),
10283: l_exception_indicator_tbl(1) ,
10284: l_exception_indicator_tbl(2) ,
10285: l_exception_indicator_tbl(3) ,
10286: l_exception_indicator_tbl(4) ,

Line 10447: l_pji_excp_ind_rec_tbl(i) := l_pji_excp_ind_rec;

10443: l_exception_indicator_tbl(161) ,
10444: l_exception_indicator_tbl(162) ,
10445: l_exception_indicator_tbl(163) ); -- Bug 8810949 : End
10446:
10447: l_pji_excp_ind_rec_tbl(i) := l_pji_excp_ind_rec;
10448:
10449: END IF ; -- IF (x_sec_ret_code = 'T')
10450:
10451: END LOOP ;

Line 10454: x_exception_indicator_tbl := l_pji_excp_ind_rec_tbl;

10450:
10451: END LOOP ;
10452:
10453: x_measure_values_tbl := l_pji_fin_meas_rec_tbl;
10454: x_exception_indicator_tbl := l_pji_excp_ind_rec_tbl;
10455:
10456: END Get_Financial_Measures_wrp;
10457:
10458: BEGIN