DBA Data[Home] [Help]

APPS.BIS_TARGET_PVT dependencies on BIS_TARGET_PUB

Line 46: ( p_Target_Rec BIS_TARGET_PUB.Target_Rec_Type

42: --
43: -- queries database to retrieve the target from the database
44: -- updates the record with the changes sent in
45: PROCEDURE Update_db_Target
46: ( p_Target_Rec BIS_TARGET_PUB.Target_Rec_Type
47: , x_Target_Rec IN OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type
48: , x_return_status OUT NOCOPY VARCHAR2
49: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
50: );

Line 47: , x_Target_Rec IN OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type

43: -- queries database to retrieve the target from the database
44: -- updates the record with the changes sent in
45: PROCEDURE Update_db_Target
46: ( p_Target_Rec BIS_TARGET_PUB.Target_Rec_Type
47: , x_Target_Rec IN OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type
48: , x_return_status OUT NOCOPY VARCHAR2
49: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
50: );
51: --

Line 55: ( p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type

51: --
52: -- returns the record with the G_MISS_CHAR/G_MISS_NUM replaced
53: -- by null
54: PROCEDURE Create_db_Target
55: ( p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type
56: , x_Target_Rec OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type
57: );
58:
59: -- returns the record with the G_MISS_CHAR/G_MISS_NUM replaced

Line 56: , x_Target_Rec OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type

52: -- returns the record with the G_MISS_CHAR/G_MISS_NUM replaced
53: -- by null
54: PROCEDURE Create_db_Target
55: ( p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type
56: , x_Target_Rec OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type
57: );
58:
59: -- returns the record with the G_MISS_CHAR/G_MISS_NUM replaced
60: -- by null

Line 113: , p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type

109: ( p_api_version IN NUMBER
110: , p_is_dbimeasure IN NUMBER := 0 --added by gbhaloti #3148615
111: , p_commit IN VARCHAR2 := FND_API.G_FALSE
112: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
113: , p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type
114: , x_return_status OUT NOCOPY VARCHAR2
115: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
116: )
117: IS

Line 119: l_Target_Rec BIS_TARGET_PUB.Target_Rec_Type;

115: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
116: )
117: IS
118: --
119: l_Target_Rec BIS_TARGET_PUB.Target_Rec_Type;
120: l_count NUMBER;
121: l_user_id NUMBER;
122: l_login_id NUMBER;
123: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 314: ( p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type

310: --
311: -- returns the record with the G_MISS_CHAR/G_MISS_NUM replaced
312: -- by null
313: PROCEDURE Create_db_Target
314: ( p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type
315: , x_Target_Rec OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type
316: )
317: IS
318: BEGIN

Line 315: , x_Target_Rec OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type

311: -- returns the record with the G_MISS_CHAR/G_MISS_NUM replaced
312: -- by null
313: PROCEDURE Create_db_Target
314: ( p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type
315: , x_Target_Rec OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type
316: )
317: IS
318: BEGIN
319: x_Target_Rec := p_Target_Rec;

Line 404: , x_Target_Tbl OUT NOCOPY BIS_TARGET_PUB.Target_Tbl_Type

400: PROCEDURE Retrieve_Targets
401: ( p_api_version IN NUMBER
402: , p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
403: , p_all_info IN VARCHAR2 := FND_API.G_TRUE
404: , x_Target_Tbl OUT NOCOPY BIS_TARGET_PUB.Target_Tbl_Type
405: , x_return_status OUT NOCOPY VARCHAR2
406: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
407: )
408: IS

Line 558: , p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type

554: -- If information about dimension values are not required, set all_info
555: -- to FALSE.
556: PROCEDURE Retrieve_Target
557: ( p_api_version IN NUMBER
558: , p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type
559: , p_all_info IN VARCHAR2 := FND_API.G_TRUE
560: , x_Target_Rec IN OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type
561: , x_return_status OUT NOCOPY VARCHAR2
562: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 560: , x_Target_Rec IN OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type

556: PROCEDURE Retrieve_Target
557: ( p_api_version IN NUMBER
558: , p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type
559: , p_all_info IN VARCHAR2 := FND_API.G_TRUE
560: , x_Target_Rec IN OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type
561: , x_return_status OUT NOCOPY VARCHAR2
562: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
563: )
564: IS

Line 1102: , p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type

1098: -- to FALSE.
1099: --
1100: PROCEDURE Retrieve_Target_Owners
1101: ( p_api_version IN NUMBER
1102: , p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type
1103: , p_all_info IN VARCHAR2 := FND_API.G_TRUE
1104: , x_Target_Owners_Rec OUT NOCOPY BIS_TARGET_PUB.Target_Owners_Rec_Type
1105: , x_return_status OUT NOCOPY VARCHAR2
1106: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 1104: , x_Target_Owners_Rec OUT NOCOPY BIS_TARGET_PUB.Target_Owners_Rec_Type

1100: PROCEDURE Retrieve_Target_Owners
1101: ( p_api_version IN NUMBER
1102: , p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type
1103: , p_all_info IN VARCHAR2 := FND_API.G_TRUE
1104: , x_Target_Owners_Rec OUT NOCOPY BIS_TARGET_PUB.Target_Owners_Rec_Type
1105: , x_return_status OUT NOCOPY VARCHAR2
1106: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1107: )
1108: IS

Line 1110: l_Target_owners_rec BIS_TARGET_PUB.Target_Owners_Rec_Type;

1106: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1107: )
1108: IS
1109:
1110: l_Target_owners_rec BIS_TARGET_PUB.Target_Owners_Rec_Type;
1111: l_target_rec BIS_TARGET_PUB.Target_Rec_Type;
1112: l_error_Tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
1113: l_Target_Rec_p BIS_TARGET_PUB.Target_Rec_Type;
1114:

Line 1111: l_target_rec BIS_TARGET_PUB.Target_Rec_Type;

1107: )
1108: IS
1109:
1110: l_Target_owners_rec BIS_TARGET_PUB.Target_Owners_Rec_Type;
1111: l_target_rec BIS_TARGET_PUB.Target_Rec_Type;
1112: l_error_Tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
1113: l_Target_Rec_p BIS_TARGET_PUB.Target_Rec_Type;
1114:
1115: BEGIN

Line 1113: l_Target_Rec_p BIS_TARGET_PUB.Target_Rec_Type;

1109:
1110: l_Target_owners_rec BIS_TARGET_PUB.Target_Owners_Rec_Type;
1111: l_target_rec BIS_TARGET_PUB.Target_Rec_Type;
1112: l_error_Tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
1113: l_Target_Rec_p BIS_TARGET_PUB.Target_Rec_Type;
1114:
1115: BEGIN
1116:
1117: l_target_rec := p_target_rec;

Line 1186: , p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type

1182: ( p_api_version IN NUMBER
1183: , p_is_dbimeasure IN NUMBER := 0 --gbhaloti #3148615
1184: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1185: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1186: , p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type
1187: , x_return_status OUT NOCOPY VARCHAR2
1188: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1189: )
1190: IS

Line 1192: l_Target_Rec BIS_TARGET_PUB.Target_Rec_Type;

1188: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1189: )
1190: IS
1191: --
1192: l_Target_Rec BIS_TARGET_PUB.Target_Rec_Type;
1193: l_target_id NUMBER;
1194: l_user_id NUMBER;
1195: l_login_id NUMBER;
1196: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 1198: l_Target_Rec_p BIS_TARGET_PUB.Target_Rec_Type;

1194: l_user_id NUMBER;
1195: l_login_id NUMBER;
1196: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1197:
1198: l_Target_Rec_p BIS_TARGET_PUB.Target_Rec_Type;
1199:
1200: --
1201: BEGIN
1202: --

Line 1372: , p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type

1368: --
1369: -- returns the record with the Target_ID populated
1370: PROCEDURE GetID
1371: ( p_api_version IN NUMBER
1372: , p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type
1373: , x_Target_Rec OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type
1374: , x_return_status OUT NOCOPY VARCHAR2
1375: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1376: )

Line 1373: , x_Target_Rec OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type

1369: -- returns the record with the Target_ID populated
1370: PROCEDURE GetID
1371: ( p_api_version IN NUMBER
1372: , p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type
1373: , x_Target_Rec OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type
1374: , x_return_status OUT NOCOPY VARCHAR2
1375: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1376: )
1377: IS

Line 1502: , p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type

1498: -- one target level
1499: PROCEDURE Delete_Target
1500: ( p_api_version IN NUMBER
1501: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1502: , p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type
1503: , x_return_status OUT NOCOPY VARCHAR2
1504: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1505: )
1506: IS

Line 1508: l_Target_Rec BIS_TARGET_PUB.Target_Rec_Type;

1504: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1505: )
1506: IS
1507: --
1508: l_Target_Rec BIS_TARGET_PUB.Target_Rec_Type;
1509: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1510: l_error_Tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
1511: --
1512: BEGIN

Line 1583: , p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type

1579: PROCEDURE Validate_Target
1580: ( p_api_version IN NUMBER
1581: , p_is_dbimeasure IN NUMBER := 0 --added by gbhaloti #3148615
1582: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1583: , p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type
1584: , x_return_status OUT NOCOPY VARCHAR2
1585: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1586: )
1587: IS

Line 2151: , p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type

2147: --
2148: -- Value - ID conversion
2149: PROCEDURE Value_ID_Conversion
2150: ( p_api_version IN NUMBER
2151: , p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type
2152: , x_Target_Rec IN OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type
2153: , x_return_status OUT NOCOPY VARCHAR2
2154: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2155: )

Line 2152: , x_Target_Rec IN OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type

2148: -- Value - ID conversion
2149: PROCEDURE Value_ID_Conversion
2150: ( p_api_version IN NUMBER
2151: , p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type
2152: , x_Target_Rec IN OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type
2153: , x_return_status OUT NOCOPY VARCHAR2
2154: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2155: )
2156: IS

Line 2194: ( p_Target_Rec BIS_TARGET_PUB.Target_Rec_Type

2190: END Value_ID_Conversion;
2191: --
2192: --
2193: PROCEDURE Update_db_Target
2194: ( p_Target_Rec BIS_TARGET_PUB.Target_Rec_Type
2195: , x_Target_Rec IN OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type
2196: , x_return_status OUT NOCOPY VARCHAR2
2197: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2198: )

Line 2195: , x_Target_Rec IN OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type

2191: --
2192: --
2193: PROCEDURE Update_db_Target
2194: ( p_Target_Rec BIS_TARGET_PUB.Target_Rec_Type
2195: , x_Target_Rec IN OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type
2196: , x_return_status OUT NOCOPY VARCHAR2
2197: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2198: )
2199: IS

Line 2201: l_Target_Rec BIS_TARGET_PUB.Target_Rec_Type;

2197: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2198: )
2199: IS
2200: --
2201: l_Target_Rec BIS_TARGET_PUB.Target_Rec_Type;
2202: l_return_status VARCHAR2(10);
2203: l_error_Tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
2204: --
2205: BEGIN

Line 2336: , p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type

2332: --
2333: --
2334: PROCEDURE Retrieve_Last_Update_Date
2335: ( p_api_version IN NUMBER
2336: , p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type
2337: , x_last_update_date OUT NOCOPY DATE
2338: , x_return_status OUT NOCOPY VARCHAR2
2339: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2340: )

Line 2413: , p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type

2409: --
2410: --
2411: PROCEDURE Lock_Record
2412: ( p_api_version IN NUMBER
2413: , p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type
2414: , p_timestamp IN VARCHAR := NULL
2415: , x_result OUT NOCOPY VARCHAR2
2416: , x_return_status OUT NOCOPY VARCHAR2
2417: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 2423: l_Target_Rec BIS_TARGET_PUB.Target_Rec_Type;

2419: IS
2420: --
2421: l_form_date DATE;
2422: l_last_update_date DATE;
2423: l_Target_Rec BIS_TARGET_PUB.Target_Rec_Type;
2424: l_error_Tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
2425: --
2426: BEGIN
2427: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2829: , p_target_rec IN BIS_TARGET_PUB.Target_Rec_Type

2825: --
2826: --
2827: FUNCTION Get_Target
2828: ( p_computing_function_id IN NUMBER
2829: , p_target_rec IN BIS_TARGET_PUB.Target_Rec_Type
2830: )
2831: RETURN NUMBER
2832: IS
2833: l_target NUMBER;

Line 2960: ' l_target_rec BIS_TARGET_PUB.Target_Rec_Type; '||

2956: );
2957:
2958: l_stmt :=
2959: 'Declare '||
2960: ' l_target_rec BIS_TARGET_PUB.Target_Rec_Type; '||
2961: 'Begin '||
2962: ' l_target_rec.Target_ID := ' || -- p_target_rec.Target_id||';'||
2963: nvl( to_char(p_target_rec.Target_id) , 'null') || ' ; ' ||
2964: ' l_target_rec.Target_Level_ID := '||p_target_rec.Target_Level_ID||';'||

Line 3026: l_target_rec BIS_TARGET_PUB.Target_Rec_Type;

3022: )
3023: RETURN NUMBER
3024: IS
3025: l_target NUMBER;
3026: l_target_rec BIS_TARGET_PUB.Target_Rec_Type;
3027: BEGIN
3028:
3029: l_target_rec.target_level_id := p_target_level_id;
3030: l_target := Get_Target

Line 3163: , p_Target_Rec IN BIS_Target_PUB.Target_Rec_Type

3159: -- Retrieves the time level values for the given target
3160: --
3161: PROCEDURE Retrieve_Time_level_value
3162: ( p_api_version IN NUMBER
3163: , p_Target_Rec IN BIS_Target_PUB.Target_Rec_Type
3164: , x_Dim_Level_Value_Rec OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
3165: , x_dimension_level_number OUT NOCOPY NUMBER
3166: , x_return_status OUT NOCOPY VARCHAR2
3167: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 3303: l_Target_Rec BIS_Target_PUB.Target_Rec_Type;

3299: , x_return_status OUT NOCOPY VARCHAR2
3300: )
3301: IS
3302:
3303: l_Target_Rec BIS_Target_PUB.Target_Rec_Type;
3304: l_Dim_Level_Value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
3305: l_dimension_level_number NUMBER;
3306: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3307: l_return_status VARCHAR2(32000);

Line 3335: , p_Target_Rec IN BIS_Target_PUB.Target_Rec_Type

3331: --
3332:
3333: PROCEDURE Retrieve_Org_level_value
3334: ( p_api_version IN NUMBER
3335: , p_Target_Rec IN BIS_Target_PUB.Target_Rec_Type
3336: , x_Dim_Level_Value_Rec OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
3337: , x_dimension_level_number OUT NOCOPY NUMBER
3338: , x_return_status OUT NOCOPY VARCHAR2
3339: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 3438: , p_Target_Rec IN BIS_TARGET_PUB.TARGET_REC_TYPE

3434:
3435: PROCEDURE Retrieve_Target_From_ShNms
3436: ( p_api_version IN NUMBER
3437: , p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
3438: , p_Target_Rec IN BIS_TARGET_PUB.TARGET_REC_TYPE
3439: , x_Target_Level_Rec IN OUT NOCOPY BIS_Target_Level_PUB.Target_Level_Rec_Type
3440: , x_Target_Rec IN OUT NOCOPY BIS_TARGET_PUB.TARGET_REC_TYPE
3441: , x_return_status OUT NOCOPY VARCHAR2
3442: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 3440: , x_Target_Rec IN OUT NOCOPY BIS_TARGET_PUB.TARGET_REC_TYPE

3436: ( p_api_version IN NUMBER
3437: , p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
3438: , p_Target_Rec IN BIS_TARGET_PUB.TARGET_REC_TYPE
3439: , x_Target_Level_Rec IN OUT NOCOPY BIS_Target_Level_PUB.Target_Level_Rec_Type
3440: , x_Target_Rec IN OUT NOCOPY BIS_TARGET_PUB.TARGET_REC_TYPE
3441: , x_return_status OUT NOCOPY VARCHAR2
3442: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
3443: )
3444: IS

Line 3452: l_target_rec_p BIS_TARGET_PUB.TARGET_REC_TYPE;

3448: l_dim_level_rec BIS_DIMENSION_LEVEL_PUB.DIMENSION_LEVEL_REC_TYPE;
3449: l_dim_level_value_rec BIS_DIM_lEVEL_VALUE_PUB.DIM_LEVEL_VALUE_REC_TYPE;
3450: l_target_level_id NUMBER;
3451: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3452: l_target_rec_p BIS_TARGET_PUB.TARGET_REC_TYPE;
3453: l_dim_level_rec_p BIS_DIMENSION_LEVEL_PUB.DIMENSION_LEVEL_REC_TYPE;
3454: l_dim_level_value_rec_p BIS_DIM_lEVEL_VALUE_PUB.DIM_LEVEL_VALUE_REC_TYPE;
3455:
3456: l_dim1_id NUMBER;

Line 3958: BIS_TARGET_PUB.Retrieve_Target(p_api_version => 1.0,

3954: x_target_rec.dim6_level_Value_id := l_dim6_level_value_id;
3955: x_target_rec.dim7_level_Value_id := l_dim7_level_value_id;
3956:
3957: l_target_rec_p := x_target_rec;
3958: BIS_TARGET_PUB.Retrieve_Target(p_api_version => 1.0,
3959: p_Target_Rec => l_target_rec_p,
3960: p_all_info => FND_API.G_TRUE,
3961: x_Target_Rec => x_target_rec,
3962: x_return_status => x_return_status,