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.BSC_DIMENSION_GROUPS_PVT dependencies on BSC_DIMENSION_GROUPS_PUB

Line 67: p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type

63: RETURN l_count;
64: END Validate_Dim_Group_Id;
65: /**********************************************************************************/
66: procedure Retrieve_Dim_Group(
67: p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
68: ,x_Dim_Grp_Rec OUT NOCOPY BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
69: ,x_return_status OUT NOCOPY VARCHAR2
70: ,x_msg_count OUT NOCOPY NUMBER
71: ,x_msg_data OUT NOCOPY VARCHAR2

Line 68: ,x_Dim_Grp_Rec OUT NOCOPY BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type

64: END Validate_Dim_Group_Id;
65: /**********************************************************************************/
66: procedure Retrieve_Dim_Group(
67: p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
68: ,x_Dim_Grp_Rec OUT NOCOPY BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
69: ,x_return_status OUT NOCOPY VARCHAR2
70: ,x_msg_count OUT NOCOPY NUMBER
71: ,x_msg_data OUT NOCOPY VARCHAR2
72: );

Line 79: ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type

75: --: This procedure is part of the Dimension Group API.
76:
77: procedure Create_Dimension_Group(
78: p_commit IN varchar2 := FND_API.G_FALSE
79: ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
80: ,x_return_status OUT NOCOPY varchar2
81: ,x_msg_count OUT NOCOPY number
82: ,x_msg_data OUT NOCOPY varchar2
83: ) is

Line 85: l_Dim_Grp_Rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;

81: ,x_msg_count OUT NOCOPY number
82: ,x_msg_data OUT NOCOPY varchar2
83: ) is
84:
85: l_Dim_Grp_Rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;
86:
87: l_count number;
88: l_dim_group_short_name varchar2(40);
89: l_dim_level_short_name varchar2(30);

Line 225: ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type

221: ************************************************************************************/
222:
223: procedure Retrieve_Dimension_Group(
224: p_commit IN varchar2 := FND_API.G_FALSE
225: ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
226: ,x_Dim_Grp_Rec IN OUT NOCOPY BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
227: ,x_return_status OUT NOCOPY varchar2
228: ,x_msg_count OUT NOCOPY number
229: ,x_msg_data OUT NOCOPY varchar2

Line 226: ,x_Dim_Grp_Rec IN OUT NOCOPY BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type

222:
223: procedure Retrieve_Dimension_Group(
224: p_commit IN varchar2 := FND_API.G_FALSE
225: ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
226: ,x_Dim_Grp_Rec IN OUT NOCOPY BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
227: ,x_return_status OUT NOCOPY varchar2
228: ,x_msg_count OUT NOCOPY number
229: ,x_msg_data OUT NOCOPY varchar2
230: ) is

Line 290: ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type

286: ************************************************************************************/
287:
288: procedure Update_Dimension_Group(
289: p_commit IN varchar2 := FND_API.G_FALSE
290: ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
291: ,x_return_status OUT NOCOPY varchar2
292: ,x_msg_count OUT NOCOPY number
293: ,x_msg_data OUT NOCOPY varchar2
294: ) is

Line 297: l_Dim_Grp_Rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;

293: ,x_msg_data OUT NOCOPY varchar2
294: ) is
295:
296: l_count number;
297: l_Dim_Grp_Rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;
298:
299: CURSOR c_dim_lvls_by_group (p_grp_short_name VARCHAR2)
300: IS
301: SELECT dim_group_id

Line 432: ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type

428: ************************************************************************************/
429:
430: procedure Delete_Dimension_Group(
431: p_commit IN varchar2 := FND_API.G_FALSE
432: ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
433: ,x_return_status OUT NOCOPY varchar2
434: ,x_msg_count OUT NOCOPY number
435: ,x_msg_data OUT NOCOPY varchar2
436: ) is

Line 438: l_Dim_Grp_Rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;

434: ,x_msg_count OUT NOCOPY number
435: ,x_msg_data OUT NOCOPY varchar2
436: ) is
437:
438: l_Dim_Grp_Rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;
439:
440: l_count number;
441:
442: CURSOR c_dim_lvls_by_group (p_grp_short_name VARCHAR2)

Line 582: ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type

578: --: This procedure is part of the Dimension Group API.
579:
580: procedure Create_Dim_Levels_In_Group(
581: p_commit IN varchar2 := FND_API.G_FALSE
582: ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
583: ,x_return_status OUT NOCOPY varchar2
584: ,x_msg_count OUT NOCOPY number
585: ,x_msg_data OUT NOCOPY varchar2
586: ) is

Line 588: l_Dim_Grp_Rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;

584: ,x_msg_count OUT NOCOPY number
585: ,x_msg_data OUT NOCOPY varchar2
586: ) is
587:
588: l_Dim_Grp_Rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;
589:
590: l_count number;
591:
592: CURSOR c_dim_lvls_by_group (p_grp_short_name VARCHAR2)

Line 781: ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type

777: ************************************************************************************/
778:
779: procedure Retrieve_Dim_Levels_In_Group(
780: p_commit IN varchar2 := FND_API.G_FALSE
781: ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
782: ,x_Dim_Grp_Rec IN OUT NOCOPY BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
783: ,x_return_status OUT NOCOPY varchar2
784: ,x_msg_count OUT NOCOPY number
785: ,x_msg_data OUT NOCOPY varchar2

Line 782: ,x_Dim_Grp_Rec IN OUT NOCOPY BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type

778:
779: procedure Retrieve_Dim_Levels_In_Group(
780: p_commit IN varchar2 := FND_API.G_FALSE
781: ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
782: ,x_Dim_Grp_Rec IN OUT NOCOPY BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
783: ,x_return_status OUT NOCOPY varchar2
784: ,x_msg_count OUT NOCOPY number
785: ,x_msg_data OUT NOCOPY varchar2
786: ) is

Line 854: ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type

850: ************************************************************************************/
851:
852: procedure Update_Dim_Levels_In_Group(
853: p_commit IN varchar2 := FND_API.G_FALSE
854: ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
855: ,x_return_status OUT NOCOPY varchar2
856: ,x_msg_count OUT NOCOPY number
857: ,x_msg_data OUT NOCOPY varchar2
858: ) is

Line 860: l_Dim_Grp_Rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;

856: ,x_msg_count OUT NOCOPY number
857: ,x_msg_data OUT NOCOPY varchar2
858: ) is
859:
860: l_Dim_Grp_Rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;
861: l_Dim_Grp_Rec_in BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;
862:
863: l_count number;
864:

Line 861: l_Dim_Grp_Rec_in BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;

857: ,x_msg_data OUT NOCOPY varchar2
858: ) is
859:
860: l_Dim_Grp_Rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;
861: l_Dim_Grp_Rec_in BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;
862:
863: l_count number;
864:
865: CURSOR c_dim_lvls_by_group (p_grp_short_name VARCHAR2)

Line 1060: ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type

1056: ************************************************************************************/
1057:
1058: procedure Delete_Dim_Levels_In_Group(
1059: p_commit IN varchar2 := FND_API.G_FALSE
1060: ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
1061: ,x_return_status OUT NOCOPY varchar2
1062: ,x_msg_count OUT NOCOPY number
1063: ,x_msg_data OUT NOCOPY varchar2
1064: ) is

Line 1066: l_Dim_Grp_Rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;

1062: ,x_msg_count OUT NOCOPY number
1063: ,x_msg_data OUT NOCOPY varchar2
1064: ) is
1065:
1066: l_Dim_Grp_Rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;
1067:
1068: l_count number;
1069:
1070: CURSOR c_dim_lvls_by_group (p_grp_short_name VARCHAR2)

Line 1230: ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type

1226:
1227: --
1228: PROCEDURE Translate_Dimension_Group
1229: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
1230: ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
1231: ,x_return_status OUT NOCOPY VARCHAR2
1232: ,x_msg_count OUT NOCOPY NUMBER
1233: ,x_msg_data OUT NOCOPY VARCHAR2
1234: ) IS

Line 1235: l_Dim_Grp_rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;

1231: ,x_return_status OUT NOCOPY VARCHAR2
1232: ,x_msg_count OUT NOCOPY NUMBER
1233: ,x_msg_data OUT NOCOPY VARCHAR2
1234: ) IS
1235: l_Dim_Grp_rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;
1236: BEGIN
1237: SAVEPOINT TranslateBSCDimGrpPVT;
1238: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1239:

Line 1314: p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type

1310:
1311: --====================================================================
1312:
1313: procedure Retrieve_Dim_Group(
1314: p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
1315: ,x_Dim_Grp_Rec OUT NOCOPY BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
1316: ,x_return_status OUT NOCOPY VARCHAR2
1317: ,x_msg_count OUT NOCOPY NUMBER
1318: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1315: ,x_Dim_Grp_Rec OUT NOCOPY BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type

1311: --====================================================================
1312:
1313: procedure Retrieve_Dim_Group(
1314: p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
1315: ,x_Dim_Grp_Rec OUT NOCOPY BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
1316: ,x_return_status OUT NOCOPY VARCHAR2
1317: ,x_msg_count OUT NOCOPY NUMBER
1318: ,x_msg_data OUT NOCOPY VARCHAR2
1319: ) is

Line 1375: , p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type

1371: *************************************************************************************/
1372:
1373: procedure Translate_Dim_by_given_lang
1374: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
1375: , p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
1376: , x_return_status OUT NOCOPY VARCHAR2
1377: , x_msg_count OUT NOCOPY NUMBER
1378: , x_msg_data OUT NOCOPY VARCHAR2
1379: )