[Home] [Help]
1: PACKAGE BODY bis_pmv_portal_util_pvt AS
2: /* $Header: BISPMVPB.pls 120.2 2006/03/31 14:57:00 serao noship $ */
3: -- dbdrv: sql ~PROD ~PATH ~FILE none none none package &phase=plb \
4: -- dbdrv: checkfile(115.12=120.2):~PROD:~PATH:~FILE
5:
39:
40: IS
41:
42: l_schedule_id_arr BISVIEWER.t_num;
43: l_ref_path_tbl BIS_PMV_PORTAL_UTIL_PVT.BIS_PMV_REF_PATH_TBL_TYPE ;
44: l_return_status VARCHAR2(100) ;
45: l_msg_data VARCHAR2(1000) ;
46: l_msg_count NUMBER;
47: l_schedule_id NUMBER ;
395: -- Check for p_user_name
396: PROCEDURE get_reference_paths(
397: p_user_name IN VARCHAR2
398: ,p_page_id IN NUMBER
399: ,x_ref_path_tbl OUT NOCOPY BIS_PMV_PORTAL_UTIL_PVT.BIS_PMV_REF_PATH_TBL_TYPE
400: ,x_return_status OUT NOCOPY VARCHAR2
401: ,x_msg_count OUT NOCOPY NUMBER
402: ,x_msg_data OUT NOCOPY VARCHAR2
403: )
402: ,x_msg_data OUT NOCOPY VARCHAR2
403: )
404: IS
405:
406: l_ref_path_rec BIS_PMV_PORTAL_UTIL_PVT.BIS_PMV_REF_PATH_REC_TYPE ;
407: l_index NUMBER := 1;
408:
409: --jprabhud - 07/16/03- Make this a dynamic sql to remove portal dependency
410: TYPE All_Ref_Paths IS REF CURSOR;
467: -- where '%' represents a string of alpha-numeric characters
468: --BugFix 3417849 make ref_path_tbl as IN OUT
469: PROCEDURE get_oa_reference_paths(
470: p_page_id IN NUMBER
471: ,x_ref_path_tbl IN OUT NOCOPY BIS_PMV_PORTAL_UTIL_PVT.BIS_PMV_REF_PATH_TBL_TYPE
472: ,x_return_status OUT NOCOPY VARCHAR2
473: ,x_msg_count OUT NOCOPY NUMBER
474: ,x_msg_data OUT NOCOPY VARCHAR2
475: )
474: ,x_msg_data OUT NOCOPY VARCHAR2
475: )
476: IS
477:
478: l_ref_path_rec BIS_PMV_PORTAL_UTIL_PVT.BIS_PMV_REF_PATH_REC_TYPE ;
479: l_index NUMBER := 1;
480:
481: CURSOR c_all_ref_paths(p_page_id IN NUMBER) IS
482: select reference_path
541:
542: END DELETE_HANGING_RELATED_LINKS;
543: ----------------------Delete Hanging Related Links-------------------------------
544:
545: END bis_pmv_portal_util_pvt;
546: