PACKAGE: APPS.BIS_VG_REPOSITORY_MEDIATOR

Source

1 PACKAGE BIS_VG_REPOSITORY_MEDIATOR AUTHID CURRENT_USER AS
2 /* $Header: BISTRPMS.pls 115.14 2002/03/27 08:18:47 pkm ship     $ */
3 
4 --  Copyright (c) 1998 Oracle Corporation, Redwood Shores, CA, USA
5 --  All rights reserved.
6 --
7 --  FILENAME
8 --
9 --      BISTRPMS.pls
10 --
11 --  DESCRIPTION
12 --
13 --      specification of repository mediator package
14 --
15 --  NOTES
16 --
17 --  HISTORY
18 --
19 --  23-JUL-98 Created
20 --
21 --  10-DEC-01 Edited by DBOWLES Added db driver comment
22 --
23 --
24 --
25 --- ======================================================================================
26 ---   PROCEDURE : create_View_Text_Tables
27 ---   PARAMETERS:
28 ---   1. p_View_Table_Rec         view table record
29 ---   2. x_View_Create_Text_Table table of varchars to hold create view text
30 ---   3. x_View_Select_Text_Table table of varchars to hold create view text
31 ---   4. x_error_Tbl        table of error messages
32 ---
33 ---   COMMENT   : Call this procedure to retrieve the view text from the runtime repository.
34 ---   EXCEPTION : None
35 ---  ======================================================================================
36    PROCEDURE create_View_Text_Tables
37    ( p_View_name         IN  BIS_VG_TYPES.View_name_type := null
38    , x_View_Column_Text_Table OUT BIS_VG_TYPES.View_Text_Table_Type
39    , x_View_Select_Text_Table OUT BIS_VG_TYPES.View_Text_Table_Type
40    , x_error_Tbl           OUT BIS_VG_UTIL.Error_Tbl_Type
41    );
42 --
43 /* ======================================================================================
44    PROCEDURE : retrieve_Business_Views
45    PARAMETERS:
46    1. p_all_flag           retrieve all views for all products
47    2. p_App_Short_Name     application short name
48    3. p_KF_Appl_Short_Name application short name
49    4. p_Key_Flex_Code      key flexfield code
50    5. p_DF_Appl_Short_Name application short name
51    6. p_Desc_Flex_Name     descriptive flexfield name
52    7. p_Lookup_Table_Name  lookup table name
53    8. p_Lookup_Code        lookup code
54    9. p_View_Name          name of view to generate
55    10. p_View_Table         table to hold view definition
56    11. x_return_status    error or normal
57    12. x_error_Tbl        table of error messages
58 
59    COMMENT   : Call this procedure to retrieve the business views from the runtime repository.
60    EXCEPTION : None
61   ====================================================================================== */
62    PROCEDURE retrieve_Business_Views
63    ( p_all_flag            IN  VARCHAR2                         := NULL
64    , p_App_Short_name      IN  BIS_VG_TYPES.App_Short_Name_Type := NULL
65    , p_KF_Appl_Short_Name  IN  BIS_VG_TYPES.App_Short_Name_Type := NULL
66    , p_Key_Flex_Code       IN  BIS_VG_TYPES.Key_Flex_Code_Type  := NULL
67    , p_DF_Appl_Short_Name  IN  BIS_VG_TYPES.App_Short_Name_Type := NULL
68    , p_Desc_Flex_Name      IN  BIS_VG_TYPES.Desc_Flex_Name_Type := NULL
69    , p_Lookup_Table_Name   IN  VARCHAR2                         := NULL
70    , p_Lookup_Type         IN  BIS_VG_TYPES.Lookup_Code_Type    := NULL
71    , p_View_Name           IN  BIS_VG_TYPES.View_name_Type      := NULL
72    , x_View_Table          OUT BIS_VG_TYPES.View_Table_Type
73    , x_return_status       OUT VARCHAR2
74    , x_error_Tbl           OUT BIS_VG_UTIL.Error_Tbl_Type
75    );
76 --
77 --
78 END BIS_VG_REPOSITORY_MEDIATOR;