APPS.BIS_DIM_LEVEL_VALUE_PVT dependencies on BIS_DIM_LEVEL_VALUE_PUB

Line 51: , x_Dim_Level_Value_Tbl OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type

47: --
48: Procedure Retrieve_Dim_Level_Values
49: ( p_api_version IN NUMBER
50: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
51: , x_Dim_Level_Value_Tbl OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
52: , x_return_status OUT NOCOPY VARCHAR2
53: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
54: )
55: IS

Line 65: , x_Dim_Level_Value_Tbl OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type

61: PROCEDURE Get_Org_Dim_Values
62: ( p_api_version IN NUMBER
63: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
64: , p_Responsibility_Tbl IN BIS_RESPONSIBILITY_PVT.Responsibility_Tbl_Type
65: , x_Dim_Level_Value_Tbl OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
66: , x_return_status OUT NOCOPY VARCHAR2
67: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
68: )
69: IS

Line 244: , x_Dim_Level_Value_Tbl OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type

240: PROCEDURE Get_Org_Dim_Values
241: ( p_api_version IN NUMBER
242: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
243: , p_Responsibility_ID IN NUMBER
244: , x_Dim_Level_Value_Tbl OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
245: , x_return_status OUT NOCOPY VARCHAR2
246: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
247: )
248: IS

Line 400: , x_Dim_Level_Value_Tbl OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type

396: --
397: PROCEDURE Get_Org_Dim_Values
398: ( p_api_version IN NUMBER
399: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
400: , x_Dim_Level_Value_Tbl OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
401: , x_return_status OUT NOCOPY VARCHAR2
402: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
403: )
404: IS

Line 540: , x_Dim_Level_Value_Tbl OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type

536: --
537: PROCEDURE Get_DimensionX_Values
538: ( p_api_version IN NUMBER
539: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
540: , x_Dim_Level_Value_Tbl OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
541: , x_return_status OUT NOCOPY VARCHAR2
542: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
543: )
544: IS

Line 683: , p_Dim_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type

679: --
680: PROCEDURE Get_Time_Dim_Values
681: ( p_api_version IN NUMBER
682: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
683: , p_Dim_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
684: , x_Dim_Level_Value_Tbl OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
685: , x_return_status OUT NOCOPY VARCHAR2
686: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
687: )

Line 684: , x_Dim_Level_Value_Tbl OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type

680: PROCEDURE Get_Time_Dim_Values
681: ( p_api_version IN NUMBER
682: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
683: , p_Dim_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
684: , x_Dim_Level_Value_Tbl OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
685: , x_return_status OUT NOCOPY VARCHAR2
686: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
687: )
688: IS

Line 849: , p_Dim_Level_Value_Tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type

845: --
846: --
847: PROCEDURE Remove_Dup_Dim_Level_Values
848: ( p_api_version IN NUMBER
849: , p_Dim_Level_Value_Tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
850: , x_Dim_Level_Value_Tbl OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
851: , x_return_status OUT NOCOPY VARCHAR2
852: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
853: )

Line 850: , x_Dim_Level_Value_Tbl OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type

846: --
847: PROCEDURE Remove_Dup_Dim_Level_Values
848: ( p_api_version IN NUMBER
849: , p_Dim_Level_Value_Tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
850: , x_Dim_Level_Value_Tbl OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
851: , x_return_status OUT NOCOPY VARCHAR2
852: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
853: )
854: IS

Line 1117: , p_Dim_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type

1113: --
1114: --
1115: PROCEDURE Org_ID_to_Value
1116: ( p_api_version IN NUMBER
1117: , p_Dim_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
1118: , x_Dim_Level_Value_Rec OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
1119: , x_return_status OUT NOCOPY VARCHAR2
1120: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1121: )

Line 1118: , x_Dim_Level_Value_Rec OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type

1114: --
1115: PROCEDURE Org_ID_to_Value
1116: ( p_api_version IN NUMBER
1117: , p_Dim_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
1118: , x_Dim_Level_Value_Rec OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
1119: , x_return_status OUT NOCOPY VARCHAR2
1120: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1121: )
1122: IS

Line 1218: , p_Dim_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type

1214: --
1215: --
1216: PROCEDURE Org_Value_to_ID
1217: ( p_api_version IN NUMBER
1218: , p_Dim_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
1219: , x_Dim_Level_Value_Rec OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
1220: , x_return_status OUT NOCOPY VARCHAR2
1221: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1222: )

Line 1219: , x_Dim_Level_Value_Rec OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type

1215: --
1216: PROCEDURE Org_Value_to_ID
1217: ( p_api_version IN NUMBER
1218: , p_Dim_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
1219: , x_Dim_Level_Value_Rec OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
1220: , x_return_status OUT NOCOPY VARCHAR2
1221: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1222: )
1223: IS

Line 1321: , p_Org_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type

1317: --
1318: --
1319: PROCEDURE Time_ID_to_Value
1320: ( p_api_version IN NUMBER
1321: , p_Org_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
1322: , p_Dim_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
1323: , x_Dim_Level_Value_Rec OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
1324: , x_return_status OUT NOCOPY VARCHAR2
1325: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 1322: , p_Dim_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type

1318: --
1319: PROCEDURE Time_ID_to_Value
1320: ( p_api_version IN NUMBER
1321: , p_Org_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
1322: , p_Dim_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
1323: , x_Dim_Level_Value_Rec OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
1324: , x_return_status OUT NOCOPY VARCHAR2
1325: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1326: )

Line 1323: , x_Dim_Level_Value_Rec OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type

1319: PROCEDURE Time_ID_to_Value
1320: ( p_api_version IN NUMBER
1321: , p_Org_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
1322: , p_Dim_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
1323: , x_Dim_Level_Value_Rec OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
1324: , x_return_status OUT NOCOPY VARCHAR2
1325: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1326: )
1327: IS

Line 1444: , p_Org_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type

1440: --
1441: --
1442: PROCEDURE Time_Value_to_ID
1443: ( p_api_version IN NUMBER
1444: , p_Org_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
1445: , p_Dim_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
1446: , x_Dim_Level_Value_Rec OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
1447: , x_return_status OUT NOCOPY VARCHAR2
1448: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 1445: , p_Dim_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type

1441: --
1442: PROCEDURE Time_Value_to_ID
1443: ( p_api_version IN NUMBER
1444: , p_Org_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
1445: , p_Dim_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
1446: , x_Dim_Level_Value_Rec OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
1447: , x_return_status OUT NOCOPY VARCHAR2
1448: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1449: )

Line 1446: , x_Dim_Level_Value_Rec OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type

1442: PROCEDURE Time_Value_to_ID
1443: ( p_api_version IN NUMBER
1444: , p_Org_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
1445: , p_Dim_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
1446: , x_Dim_Level_Value_Rec OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
1447: , x_return_status OUT NOCOPY VARCHAR2
1448: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1449: )
1450: IS

Line 1571: , p_Dim_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type

1567: --
1568: --
1569: PROCEDURE DimensionX_ID_to_Value
1570: ( p_api_version IN NUMBER
1571: , p_Dim_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
1572: , p_set_of_books_id IN VARCHAR2 := NULL
1573: , x_Dim_Level_Value_Rec IN OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
1574: , x_return_status OUT NOCOPY VARCHAR2
1575: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 1573: , x_Dim_Level_Value_Rec IN OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type

1569: PROCEDURE DimensionX_ID_to_Value
1570: ( p_api_version IN NUMBER
1571: , p_Dim_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
1572: , p_set_of_books_id IN VARCHAR2 := NULL
1573: , x_Dim_Level_Value_Rec IN OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
1574: , x_return_status OUT NOCOPY VARCHAR2
1575: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1576: )
1577: IS

Line 1725: , p_Dim_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type

1721: --
1722: --
1723: PROCEDURE DimensionX_Value_to_ID
1724: ( p_api_version IN NUMBER
1725: , p_Dim_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
1726: , x_Dim_Level_Value_Rec OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
1727: , x_return_status OUT NOCOPY VARCHAR2
1728: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1729: )

Line 1726: , x_Dim_Level_Value_Rec OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type

1722: --
1723: PROCEDURE DimensionX_Value_to_ID
1724: ( p_api_version IN NUMBER
1725: , p_Dim_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
1726: , x_Dim_Level_Value_Rec OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
1727: , x_return_status OUT NOCOPY VARCHAR2
1728: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1729: )
1730: IS

Line 1826: ( p_Dim_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type

1822: END DimensionX_Value_to_ID;
1823:
1824: --
1825: Function Is_Current_Time_Period
1826: ( p_Dim_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
1827: , p_Org_Level_ID IN VARCHAR2
1828: , p_Org_Level_Short_name IN VARCHAR2
1829: , x_current_time_id OUT NOCOPY VARCHAR2
1830: ) RETURN BOOLEAN

Line 1962: ( p_Dim_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type

1958: --
1959: --
1960:
1961: Function Is_Previous_Time_Period
1962: ( p_Dim_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
1963: , p_Org_Level_ID IN VARCHAR2
1964: , p_Org_Level_Short_name IN VARCHAR2
1965: , x_Previous_time_id OUT NOCOPY VARCHAR2
1966: ) RETURN BOOLEAN