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.

APPS.BIS_TARGET_LEVEL_PVT dependencies on BIS_TARGET_LEVEL_PUB

Line 29: REM | populate BIS_Target_Level_PUB.Target_Level_Rec_Type|

25: REM | parameters (bug#2758428) |
26: REM | 17-MAR-03 smuruges Modified the WHERE clause for the cursor ind_res |
27: REM | Replaced the OR clause with nvl on sysdate. |
28: REM | 30-JUN-03 rchandra Selected DATASET_ID from bisfv_target_levels to |
29: REM | populate BIS_Target_Level_PUB.Target_Level_Rec_Type|
30: REM | for bug 3004651 |
31: REM | 21-OCT-04 arhegde bug# 3634587 The SQL used shows up on performance |
32: REM | repository top-20, Removed Retrieve_Measure_Notify_Resps() |
33: REM | 05-jul-04 rpenneru Modified for bug#3735203 |

Line 64: p_target_level_tbl IN BIS_TARGET_LEVEL_PUB.Target_Level_Tbl_Type

60:
61: --==================================================================
62:
63: PROCEDURE retrieve_sql(
64: p_target_level_tbl IN BIS_TARGET_LEVEL_PUB.Target_Level_Tbl_Type
65: ,x_is_bind OUT NOCOPY BOOLEAN
66: ,x_is_execute OUT NOCOPY BOOLEAN
67: ,x_sql OUT NOCOPY VARCHAR2
68: ,x_bind_variables_tbl OUT NOCOPY bind_variables_tbl_type

Line 75: p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type

71: --==================================================================
72:
73: PROCEDURE Level_Correspond_To_Dim -- Procedure added for 2486702
74: (
75: p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
76: , p_measure_rec IN BIS_MEASURE_PUB.MEASURE_REC_TYPE
77: , x_return_status OUT NOCOPY VARCHAR2
78: , x_return_msg OUT NOCOPY VARCHAR2
79: );

Line 113: ( p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type

109: );
110:
111:
112: PROCEDURE GET_TL_LVLS_ARRAY -- Procedure added for 2486702
113: ( p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
114: , x_lvl_tbl_type OUT NOCOPY lvl_tbl_type
115: , x_num_lvls OUT NOCOPY NUMBER
116: , x_return_status OUT NOCOPY VARCHAR2
117: , x_return_msg OUT NOCOPY VARCHAR2

Line 192: ( p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type

188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
189:
190: END SetNULL;
191: PROCEDURE Set_NULL
192: ( p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
193: , x_Target_Level_Rec OUT NOCOPY BIS_Target_Level_PUB.Target_Level_Rec_Type
194: )
195: IS
196: BEGIN

Line 193: , x_Target_Level_Rec OUT NOCOPY BIS_Target_Level_PUB.Target_Level_Rec_Type

189:
190: END SetNULL;
191: PROCEDURE Set_NULL
192: ( p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
193: , x_Target_Level_Rec OUT NOCOPY BIS_Target_Level_PUB.Target_Level_Rec_Type
194: )
195: IS
196: BEGIN
197:

Line 299: ( p_tl_rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type

295: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.SOURCE);
296: END;
297:
298: FUNCTION Get_Level_Id_From_Short_Name
299: ( p_tl_rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
300: ) RETURN NUMBER
301: IS
302: cursor short_name_cursor IS
303: select target_level_id

Line 322: ( p_tl_rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type

318:
319: END Get_Level_Id_From_Short_Name;
320:
321: FUNCTION Get_Level_Id_From_Dimlevels
322: ( p_tl_rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
323: ) RETURN NUMBER
324: IS
325: --changed cursor
326: cursor dimlevel_cursor(p_tl_curs_rec BIS_Target_Level_PUB.Target_Level_Rec_Type) IS

Line 326: cursor dimlevel_cursor(p_tl_curs_rec BIS_Target_Level_PUB.Target_Level_Rec_Type) IS

322: ( p_tl_rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
323: ) RETURN NUMBER
324: IS
325: --changed cursor
326: cursor dimlevel_cursor(p_tl_curs_rec BIS_Target_Level_PUB.Target_Level_Rec_Type) IS
327: select target_level_id
328: from bis_target_levels
329: where NVL(INDICATOR_ID, -1) = NVL(p_tl_curs_rec.Measure_Id, -1)
330: AND (p_tl_curs_rec.Org_Level_Id IS NULL OR NVL(ORG_LEVEL_ID, -1) = NVL(p_tl_curs_rec.Org_Level_Id, -1))

Line 341: l_tl_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;

337: AND NVL(DIMENSION6_LEVEL_ID, -1) = NVL(p_tl_curs_rec.Dimension6_Level_Id, -1)
338: AND NVL(DIMENSION7_LEVEL_ID, -1) = NVL(p_tl_curs_rec.Dimension7_Level_Id, -1);
339:
340: l_dummy number;
341: l_tl_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
342: BEGIN
343: --set null first
344: Set_NULL( p_Target_Level_Rec => p_tl_Rec
345: , x_Target_Level_Rec => l_tl_Rec);

Line 365: ( p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type

361: -- New Function to return TargetLevelId given the DimensionLevel ShortNames
362: -- and the Measure Short Name
363:
364: FUNCTION Get_Id_From_DimLevelShortNames
365: ( p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
366: ) RETURN NUMBER
367: IS
368:
369: l_target_level_id number;

Line 373: l_target_level_rec BIS_Target_Level_PUB.Target_Level_Rec_Type;

369: l_target_level_id number;
370:
371: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
372: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
373: l_target_level_rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
374: l_return_status VARCHAR2(100);
375: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
376: l_Measure_Rec_p BIS_MEASURE_PUB.Measure_Rec_Type;
377: l_Dimension_Level_Rec_p BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;

Line 645: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type

641: PROCEDURE Create_Target_Level
642: ( p_api_version IN NUMBER
643: , p_commit IN VARCHAR2 := FND_API.G_FALSE
644: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
645: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
646: , x_return_status OUT NOCOPY VARCHAR2
647: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
648: )
649: IS

Line 685: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type

681: PROCEDURE Create_Target_Level
682: ( p_api_version IN NUMBER
683: , p_commit IN VARCHAR2 := FND_API.G_FALSE
684: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
685: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
686: , p_owner IN VARCHAR2
687: , x_return_status OUT NOCOPY VARCHAR2
688: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
689: )

Line 694: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;

690: IS
691: l_user_id NUMBER;
692: l_login_id NUMBER;
693: l_id NUMBER;
694: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
695: l_Target_Level_Id NUMBER;
696: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
697:
698: -- l_msg VARCHAR2(3000); -- 2515991

Line 966: , x_Target_Level_tbl OUT NOCOPY BIS_Target_Level_PUB.Target_Level_Tbl_Type

962: PROCEDURE Retrieve_Target_Levels
963: ( p_api_version IN NUMBER
964: , p_all_info IN VARCHAR2 := FND_API.G_TRUE
965: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
966: , x_Target_Level_tbl OUT NOCOPY BIS_Target_Level_PUB.Target_Level_Tbl_Type
967: , x_return_status OUT NOCOPY VARCHAR2
968: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
969: )
970: IS

Line 974: l_Target_Level_rec BIS_Target_Level_PUB.Target_Level_Rec_Type;

970: IS
971:
972: i NUMBER := 0;
973: l_Measure_id NUMBER;
974: l_Target_Level_rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
975: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
976:
977: cursor tar_level_bv IS
978: Select measure_id

Line 1217: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type

1213: -- Gets Information for one Indicator Level
1214: -- If information about the dimension are not required, set all_info to FALSE.
1215: PROCEDURE Retrieve_Target_Level
1216: ( p_api_version IN NUMBER
1217: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
1218: , p_all_info IN VARCHAR2 := FND_API.G_TRUE
1219: , x_Target_Level_Rec IN OUT NOCOPY BIS_Target_Level_PUB.Target_Level_Rec_Type
1220: , x_return_status OUT NOCOPY VARCHAR2
1221: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 1219: , x_Target_Level_Rec IN OUT NOCOPY BIS_Target_Level_PUB.Target_Level_Rec_Type

1215: PROCEDURE Retrieve_Target_Level
1216: ( p_api_version IN NUMBER
1217: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
1218: , p_all_info IN VARCHAR2 := FND_API.G_TRUE
1219: , x_Target_Level_Rec IN OUT NOCOPY BIS_Target_Level_PUB.Target_Level_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 1226: l_Target_Level_rec BIS_Target_Level_PUB.Target_Level_Rec_Type;

1222: )
1223: IS
1224: l_ID NUMBER;
1225: l_indicator_id NUMBER;
1226: l_Target_Level_rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
1227: l_wf_process_short_name VARCHAR2(30);
1228: l_wf_process_name VARCHAR2(80);
1229: l_Def_Notify_Resp_short_name VARCHAR2(100);
1230: l_Def_Notify_Resp_name VARCHAR2(240);

Line 1462: ,p_target_level_tbl IN BIS_TARGET_LEVEL_PUB.target_level_tbl_type

1458: -- details of all required target level short names with one call.
1459: -- As of now, the input table structure into this should start from 1 incremented by 1
1460: PROCEDURE retrieve_mult_targ_levels(
1461: p_api_version IN NUMBER
1462: ,p_target_level_tbl IN BIS_TARGET_LEVEL_PUB.target_level_tbl_type
1463: ,p_all_info IN VARCHAR2 := FND_API.G_TRUE
1464: ,x_target_level_tbl OUT NOCOPY BIS_TARGET_LEVEL_PUB.target_level_tbl_type
1465: ,x_return_status OUT NOCOPY VARCHAR2
1466: ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 1464: ,x_target_level_tbl OUT NOCOPY BIS_TARGET_LEVEL_PUB.target_level_tbl_type

1460: PROCEDURE retrieve_mult_targ_levels(
1461: p_api_version IN NUMBER
1462: ,p_target_level_tbl IN BIS_TARGET_LEVEL_PUB.target_level_tbl_type
1463: ,p_all_info IN VARCHAR2 := FND_API.G_TRUE
1464: ,x_target_level_tbl OUT NOCOPY BIS_TARGET_LEVEL_PUB.target_level_tbl_type
1465: ,x_return_status OUT NOCOPY VARCHAR2
1466: ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1467: )
1468: IS

Line 1472: l_target_level_rec BIS_TARGET_LEVEL_PUB.target_level_rec_type;

1468: IS
1469: TYPE ref_cursor_type IS REF CURSOR;
1470: c_targ_level_details ref_cursor_type;
1471:
1472: l_target_level_rec BIS_TARGET_LEVEL_PUB.target_level_rec_type;
1473: l_bind_var_tbl bind_variables_tbl_type;
1474: l_index NUMBER;
1475: l_sql VARCHAR2(32000);
1476: l_is_bind BOOLEAN := FALSE;

Line 1554: p_target_level_tbl IN BIS_TARGET_LEVEL_PUB.Target_Level_Tbl_Type

1550:
1551: --====================================================================
1552:
1553: PROCEDURE retrieve_sql(
1554: p_target_level_tbl IN BIS_TARGET_LEVEL_PUB.Target_Level_Tbl_Type
1555: ,x_is_bind OUT NOCOPY BOOLEAN
1556: ,x_is_execute OUT NOCOPY BOOLEAN
1557: ,x_sql OUT NOCOPY VARCHAR2
1558: ,x_bind_variables_tbl OUT NOCOPY bind_variables_tbl_type

Line 1621: ( p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type

1617:
1618: --=================================================================
1619:
1620: Procedure Check_Changed
1621: ( p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
1622: , p_Target_Level_Rec1 IN BIS_Target_Level_PUB.Target_Level_Rec_Type
1623: , p_up_loaded IN VARCHAR2 := FND_API.G_TRUE
1624: , x_changed OUT NOCOPY VARCHAR2
1625: )

Line 1622: , p_Target_Level_Rec1 IN BIS_Target_Level_PUB.Target_Level_Rec_Type

1618: --=================================================================
1619:
1620: Procedure Check_Changed
1621: ( p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
1622: , p_Target_Level_Rec1 IN BIS_Target_Level_PUB.Target_Level_Rec_Type
1623: , p_up_loaded IN VARCHAR2 := FND_API.G_TRUE
1624: , x_changed OUT NOCOPY VARCHAR2
1625: )
1626: IS

Line 1627: a BIS_Target_Level_PUB.Target_Level_Rec_Type;

1623: , p_up_loaded IN VARCHAR2 := FND_API.G_TRUE
1624: , x_changed OUT NOCOPY VARCHAR2
1625: )
1626: IS
1627: a BIS_Target_Level_PUB.Target_Level_Rec_Type;
1628: b BIS_Target_Level_PUB.Target_Level_Rec_Type;
1629:
1630: BEGIN
1631:

Line 1628: b BIS_Target_Level_PUB.Target_Level_Rec_Type;

1624: , x_changed OUT NOCOPY VARCHAR2
1625: )
1626: IS
1627: a BIS_Target_Level_PUB.Target_Level_Rec_Type;
1628: b BIS_Target_Level_PUB.Target_Level_Rec_Type;
1629:
1630: BEGIN
1631:
1632: a := p_target_level_rec1;

Line 1705: ( p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type

1701: NULL;
1702: END Check_Changed;
1703: --
1704: PROCEDURE Update_Target_Level_Rec
1705: ( p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
1706: , p_Target_Level_Rec1 IN BIS_Target_Level_PUB.Target_Level_Rec_Type
1707: , p_up_loaded IN VARCHAR2 := FND_API.G_TRUE
1708: , x_Target_Level_Rec OUT NOCOPY BIS_Target_Level_PUB.Target_Level_Rec_Type
1709: , x_changed OUT NOCOPY VARCHAR2

Line 1706: , p_Target_Level_Rec1 IN BIS_Target_Level_PUB.Target_Level_Rec_Type

1702: END Check_Changed;
1703: --
1704: PROCEDURE Update_Target_Level_Rec
1705: ( p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
1706: , p_Target_Level_Rec1 IN BIS_Target_Level_PUB.Target_Level_Rec_Type
1707: , p_up_loaded IN VARCHAR2 := FND_API.G_TRUE
1708: , x_Target_Level_Rec OUT NOCOPY BIS_Target_Level_PUB.Target_Level_Rec_Type
1709: , x_changed OUT NOCOPY VARCHAR2
1710: )

Line 1708: , x_Target_Level_Rec OUT NOCOPY BIS_Target_Level_PUB.Target_Level_Rec_Type

1704: PROCEDURE Update_Target_Level_Rec
1705: ( p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
1706: , p_Target_Level_Rec1 IN BIS_Target_Level_PUB.Target_Level_Rec_Type
1707: , p_up_loaded IN VARCHAR2 := FND_API.G_TRUE
1708: , x_Target_Level_Rec OUT NOCOPY BIS_Target_Level_PUB.Target_Level_Rec_Type
1709: , x_changed OUT NOCOPY VARCHAR2
1710: )
1711: IS
1712: a BIS_Target_Level_PUB.Target_Level_Rec_Type;

Line 1712: a BIS_Target_Level_PUB.Target_Level_Rec_Type;

1708: , x_Target_Level_Rec OUT NOCOPY BIS_Target_Level_PUB.Target_Level_Rec_Type
1709: , x_changed OUT NOCOPY VARCHAR2
1710: )
1711: IS
1712: a BIS_Target_Level_PUB.Target_Level_Rec_Type;
1713: b BIS_Target_Level_PUB.Target_Level_Rec_Type;
1714:
1715: BEGIN
1716:

Line 1713: b BIS_Target_Level_PUB.Target_Level_Rec_Type;

1709: , x_changed OUT NOCOPY VARCHAR2
1710: )
1711: IS
1712: a BIS_Target_Level_PUB.Target_Level_Rec_Type;
1713: b BIS_Target_Level_PUB.Target_Level_Rec_Type;
1714:
1715: BEGIN
1716:
1717: a := p_target_level_rec1;

Line 1907: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type

1903: PROCEDURE Update_Target_Level
1904: ( p_api_version IN NUMBER
1905: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1906: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1907: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
1908: , x_return_status OUT NOCOPY VARCHAR2
1909: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1910: )
1911: IS

Line 1948: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type

1944: PROCEDURE Update_Target_Level
1945: ( p_api_version IN NUMBER
1946: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1947: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1948: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
1949: , p_owner IN VARCHAR2
1950: , p_up_loaded IN VARCHAR2 := FND_API.G_FALSE
1951: , x_return_status OUT NOCOPY VARCHAR2
1952: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 1957: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;

1953: )
1954: IS
1955: l_user_id NUMBER;
1956: l_login_id NUMBER;
1957: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
1958: l_Target_Level_orig BIS_Target_Level_PUB.Target_Level_Rec_Type;
1959: l_changed VARCHAR2(10) := FND_API.G_FALSE;
1960: l_target_level_id NUMBER;
1961: l_Target_Tbl BIS_TARGET_PUB.Target_Tbl_Type;

Line 1958: l_Target_Level_orig BIS_Target_Level_PUB.Target_Level_Rec_Type;

1954: IS
1955: l_user_id NUMBER;
1956: l_login_id NUMBER;
1957: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
1958: l_Target_Level_orig BIS_Target_Level_PUB.Target_Level_Rec_Type;
1959: l_changed VARCHAR2(10) := FND_API.G_FALSE;
1960: l_target_level_id NUMBER;
1961: l_Target_Tbl BIS_TARGET_PUB.Target_Tbl_Type;
1962: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 2183: , p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type

2179: Procedure Translate_Target_Level
2180: ( p_api_version IN NUMBER
2181: , p_commit IN VARCHAR2 := FND_API.G_FALSE
2182: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2183: , p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
2184: , x_return_status OUT NOCOPY VARCHAR2
2185: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2186: )
2187: IS

Line 2222: , p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type

2218: Procedure Translate_Target_Level
2219: ( p_api_version IN NUMBER
2220: , p_commit IN VARCHAR2 := FND_API.G_FALSE
2221: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2222: , p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
2223: , p_owner IN VARCHAR2
2224: , x_return_status OUT NOCOPY VARCHAR2
2225: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2226: )

Line 2232: l_Target_Level_rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;

2228: l_user_id NUMBER;
2229: l_login_id NUMBER;
2230: l_count NUMBER := 0;
2231: l_changed VARCHAR2(10) := FND_API.G_FALSE;
2232: l_Target_Level_rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
2233: l_Target_Level_orig BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
2234: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2235:
2236: BEGIN

Line 2233: l_Target_Level_orig BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;

2229: l_login_id NUMBER;
2230: l_count NUMBER := 0;
2231: l_changed VARCHAR2(10) := FND_API.G_FALSE;
2232: l_Target_Level_rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
2233: l_Target_Level_orig BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
2234: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2235:
2236: BEGIN
2237:

Line 2346: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type

2342: PROCEDURE Delete_Target_Level
2343: ( p_api_version IN NUMBER
2344: , p_force_delete IN NUMBER := 0--gbhaloti #3148615
2345: , p_commit IN VARCHAR2 := FND_API.G_FALSE
2346: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
2347: , x_return_status OUT NOCOPY VARCHAR2
2348: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2349: )
2350: IS

Line 2434: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type

2430: --PROCEDURE @Target_Level
2431: PROCEDURE Validate_Target_Level
2432: ( p_api_version IN NUMBER
2433: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2434: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
2435: , x_return_status OUT NOCOPY VARCHAR2
2436: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2437: )
2438: IS

Line 2783: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type

2779:
2780: -- Value - ID conversion
2781: PROCEDURE Value_ID_Conversion
2782: ( p_api_version IN NUMBER
2783: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
2784: , x_Target_Level_Rec OUT NOCOPY BIS_Target_Level_PUB.Target_Level_Rec_Type
2785: , x_return_status OUT NOCOPY VARCHAR2
2786: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2787: )

Line 2784: , x_Target_Level_Rec OUT NOCOPY BIS_Target_Level_PUB.Target_Level_Rec_Type

2780: -- Value - ID conversion
2781: PROCEDURE Value_ID_Conversion
2782: ( p_api_version IN NUMBER
2783: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
2784: , x_Target_Level_Rec OUT NOCOPY BIS_Target_Level_PUB.Target_Level_Rec_Type
2785: , x_return_status OUT NOCOPY VARCHAR2
2786: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2787: )
2788: IS

Line 2791: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;

2787: )
2788: IS
2789: l_convert VARCHAR2(10);
2790: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2791: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
2792: BEGIN
2793: x_return_status := FND_API.G_RET_STS_SUCCESS;
2794: x_Target_Level_Rec := p_Target_Level_Rec;
2795:

Line 3077: , x_Target_Level_Tbl OUT NOCOPY BIS_Target_LEVEL_PUB.Target_Level_Tbl_Type

3073: Procedure Retrieve_User_Target_Levels
3074: ( p_api_version IN NUMBER
3075: , p_user_id IN NUMBER
3076: , p_all_info IN VARCHAR2 := FND_API.G_TRUE
3077: , x_Target_Level_Tbl OUT NOCOPY BIS_Target_LEVEL_PUB.Target_Level_Tbl_Type
3078: , x_return_status OUT NOCOPY VARCHAR2
3079: , x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
3080: )
3081: IS

Line 3097: l_Target_Level_rec BIS_Target_LEVEL_PUB.Target_Level_Rec_Type;

3093: AND nvl(ur.end_date, sysdate) >= sysdate
3094: and il.target_level_id = ir.target_level_id
3095: order by UPPER(target_level_name);
3096:
3097: l_Target_Level_rec BIS_Target_LEVEL_PUB.Target_Level_Rec_Type;
3098: l_Target_Level_rec_p BIS_Target_LEVEL_PUB.Target_Level_Rec_Type;
3099: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3100:
3101: BEGIN

Line 3098: l_Target_Level_rec_p BIS_Target_LEVEL_PUB.Target_Level_Rec_Type;

3094: and il.target_level_id = ir.target_level_id
3095: order by UPPER(target_level_name);
3096:
3097: l_Target_Level_rec BIS_Target_LEVEL_PUB.Target_Level_Rec_Type;
3098: l_Target_Level_rec_p BIS_Target_LEVEL_PUB.Target_Level_Rec_Type;
3099: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3100:
3101: BEGIN
3102:

Line 3166: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type

3162: --
3163: --
3164: PROCEDURE Retrieve_Last_Update_Date
3165: ( p_api_version IN NUMBER
3166: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
3167: , x_last_update_date OUT NOCOPY DATE
3168: , x_return_status OUT NOCOPY VARCHAR2
3169: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
3170: )

Line 3227: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type

3223: --
3224: --
3225: PROCEDURE Lock_Record
3226: ( p_api_version IN NUMBER
3227: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
3228: , p_timestamp IN VARCHAR := NULL
3229: , x_return_status OUT NOCOPY VARCHAR2
3230: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
3231: )

Line 3236: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;

3232: IS
3233: --
3234: l_form_date DATE;
3235: l_last_update_date DATE;
3236: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
3237: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3238: --
3239: BEGIN
3240: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3290: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type

3286: -- Retrieves the time level for the given target level
3287: --
3288: PROCEDURE Retrieve_Time_level
3289: ( p_api_version IN NUMBER
3290: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
3291: , x_Dimension_Level_Rec OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
3292: , x_dimension_level_number OUT NOCOPY NUMBER
3293: , x_return_status OUT NOCOPY VARCHAR2
3294: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 3476: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;

3472: , x_return_status OUT NOCOPY VARCHAR2
3473: )
3474: IS
3475:
3476: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
3477: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
3478: l_dimension_level_number NUMBER;
3479: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3480: l_return_status VARCHAR2(32000);

Line 3510: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type

3506: --
3507:
3508: PROCEDURE Retrieve_Org_level
3509: ( p_api_version IN NUMBER
3510: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
3511: , x_Dimension_Level_Rec OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
3512: , x_dimension_level_number OUT NOCOPY NUMBER
3513: , x_return_status OUT NOCOPY VARCHAR2
3514: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 3724: , p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type

3720:
3721: PROCEDURE Retrieve_TL_From_DimLvlShNms
3722: (
3723: p_api_version IN NUMBER
3724: , p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
3725: , x_Target_Level_Rec OUT NOCOPY BIS_Target_Level_PUB.Target_Level_Rec_Type
3726: , x_return_status OUT NOCOPY VARCHAR2
3727: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
3728: )

Line 3725: , x_Target_Level_Rec OUT NOCOPY BIS_Target_Level_PUB.Target_Level_Rec_Type

3721: PROCEDURE Retrieve_TL_From_DimLvlShNms
3722: (
3723: p_api_version IN NUMBER
3724: , p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
3725: , x_Target_Level_Rec OUT NOCOPY BIS_Target_Level_PUB.Target_Level_Rec_Type
3726: , x_return_status OUT NOCOPY VARCHAR2
3727: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
3728: )
3729: IS

Line 4289: p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type,

4285:
4286:
4287: PROCEDURE Validate_Dimensions -- Procedure added for 2486702
4288: (
4289: p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type,
4290: x_return_status OUT NOCOPY VARCHAR2,
4291: x_return_msg OUT NOCOPY VARCHAR2
4292: ) IS
4293: l_measure_id NUMBER;

Line 4364: p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type

4360:
4361:
4362: PROCEDURE Level_Correspond_To_Dim -- Procedure added for 2486702
4363: (
4364: p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
4365: , p_measure_rec IN BIS_MEASURE_PUB.MEASURE_REC_TYPE
4366: , x_return_status OUT NOCOPY VARCHAR2
4367: , x_return_msg OUT NOCOPY VARCHAR2
4368: ) IS

Line 4656: ( p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type

4652: END ADD_TO_MEASURE_ARRAY;
4653:
4654:
4655: PROCEDURE GET_TL_LVLS_ARRAY -- Procedure added for 2486702
4656: ( p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
4657: , x_lvl_tbl_type OUT NOCOPY lvl_tbl_type
4658: , x_num_lvls OUT NOCOPY NUMBER
4659: , x_return_status OUT NOCOPY VARCHAR2
4660: , x_return_msg OUT NOCOPY VARCHAR2