44: to a view.
45: EXCEPTION : None
46: ===========================================================================*/
47: PROCEDURE add_Lookup_Info
48: ( p_View_Column_Table IN BIS_VG_TYPES.View_Text_Table_Type
49: , p_View_Select_Table IN BIS_VG_TYPES.View_Text_Table_Type
50: , p_Mode IN NUMBER
51: , p_Column_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
52: , p_Select_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
45: EXCEPTION : None
46: ===========================================================================*/
47: PROCEDURE add_Lookup_Info
48: ( p_View_Column_Table IN BIS_VG_TYPES.View_Text_Table_Type
49: , p_View_Select_Table IN BIS_VG_TYPES.View_Text_Table_Type
50: , p_Mode IN NUMBER
51: , p_Column_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
52: , p_Select_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
53: , x_Column_Table OUT BIS_VG_TYPES.View_Text_Table_Type
47: PROCEDURE add_Lookup_Info
48: ( p_View_Column_Table IN BIS_VG_TYPES.View_Text_Table_Type
49: , p_View_Select_Table IN BIS_VG_TYPES.View_Text_Table_Type
50: , p_Mode IN NUMBER
51: , p_Column_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
52: , p_Select_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
53: , x_Column_Table OUT BIS_VG_TYPES.View_Text_Table_Type
54: , x_Select_Table OUT BIS_VG_TYPES.View_Text_Table_Type
55: , x_Column_Pointer OUT BIS_VG_TYPES.View_Character_Pointer_Type
48: ( p_View_Column_Table IN BIS_VG_TYPES.View_Text_Table_Type
49: , p_View_Select_Table IN BIS_VG_TYPES.View_Text_Table_Type
50: , p_Mode IN NUMBER
51: , p_Column_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
52: , p_Select_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
53: , x_Column_Table OUT BIS_VG_TYPES.View_Text_Table_Type
54: , x_Select_Table OUT BIS_VG_TYPES.View_Text_Table_Type
55: , x_Column_Pointer OUT BIS_VG_TYPES.View_Character_Pointer_Type
56: , x_Select_Pointer OUT BIS_VG_TYPES.View_Character_Pointer_Type
49: , p_View_Select_Table IN BIS_VG_TYPES.View_Text_Table_Type
50: , p_Mode IN NUMBER
51: , p_Column_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
52: , p_Select_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
53: , x_Column_Table OUT BIS_VG_TYPES.View_Text_Table_Type
54: , x_Select_Table OUT BIS_VG_TYPES.View_Text_Table_Type
55: , x_Column_Pointer OUT BIS_VG_TYPES.View_Character_Pointer_Type
56: , x_Select_Pointer OUT BIS_VG_TYPES.View_Character_Pointer_Type
57: , x_return_status OUT VARCHAR2
50: , p_Mode IN NUMBER
51: , p_Column_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
52: , p_Select_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
53: , x_Column_Table OUT BIS_VG_TYPES.View_Text_Table_Type
54: , x_Select_Table OUT BIS_VG_TYPES.View_Text_Table_Type
55: , x_Column_Pointer OUT BIS_VG_TYPES.View_Character_Pointer_Type
56: , x_Select_Pointer OUT BIS_VG_TYPES.View_Character_Pointer_Type
57: , x_return_status OUT VARCHAR2
58: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
51: , p_Column_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
52: , p_Select_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
53: , x_Column_Table OUT BIS_VG_TYPES.View_Text_Table_Type
54: , x_Select_Table OUT BIS_VG_TYPES.View_Text_Table_Type
55: , x_Column_Pointer OUT BIS_VG_TYPES.View_Character_Pointer_Type
56: , x_Select_Pointer OUT BIS_VG_TYPES.View_Character_Pointer_Type
57: , x_return_status OUT VARCHAR2
58: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
59: );
52: , p_Select_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
53: , x_Column_Table OUT BIS_VG_TYPES.View_Text_Table_Type
54: , x_Select_Table OUT BIS_VG_TYPES.View_Text_Table_Type
55: , x_Column_Pointer OUT BIS_VG_TYPES.View_Character_Pointer_Type
56: , x_Select_Pointer OUT BIS_VG_TYPES.View_Character_Pointer_Type
57: , x_return_status OUT VARCHAR2
58: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
59: );
60:
76: -- information to a view.
77: --EXCEPTION : None
78: -- ==========================================================================
79: PROCEDURE parse_LA_select
80: ( p_View_Select_Table IN BIS_VG_TYPES.View_Text_Table_Type
81: , p_Select_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
82: , x_expr OUT VARCHAR2
83: , x_lookup_table OUT VARCHAR2
84: , x_lookup_type OUT VARCHAR2
77: --EXCEPTION : None
78: -- ==========================================================================
79: PROCEDURE parse_LA_select
80: ( p_View_Select_Table IN BIS_VG_TYPES.View_Text_Table_Type
81: , p_Select_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
82: , x_expr OUT VARCHAR2
83: , x_lookup_table OUT VARCHAR2
84: , x_lookup_type OUT VARCHAR2
85: , x_lookup_column OUT VARCHAR2
82: , x_expr OUT VARCHAR2
83: , x_lookup_table OUT VARCHAR2
84: , x_lookup_type OUT VARCHAR2
85: , x_lookup_column OUT VARCHAR2
86: , x_Select_Pointer OUT BIS_VG_TYPES.View_Character_Pointer_Type
87: , x_return_status OUT VARCHAR2
88: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
89: );
90: