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_BUSINESS_PLAN_PVT dependencies on BIS_BUSINESS_PLAN_PUB

Line 31: ( p_Business_Plan_Rec IN BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type

27: -- returns the record with the G_MISS_CHAR/G_MISS_NUM replaced
28: -- by null
29: --
30: PROCEDURE SetNULL
31: ( p_Business_Plan_Rec IN BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type
32: , x_Business_Plan_Rec OUT NOCOPY BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type
33: );
34: --
35: -- queries database to retrieve the business plan from the database

Line 32: , x_Business_Plan_Rec OUT NOCOPY BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type

28: -- by null
29: --
30: PROCEDURE SetNULL
31: ( p_Business_Plan_Rec IN BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type
32: , x_Business_Plan_Rec OUT NOCOPY BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type
33: );
34: --
35: -- queries database to retrieve the business plan from the database
36: -- updates the record with the changes sent in

Line 39: ( p_Business_Plan_Rec BIS_Business_Plan_PUB.Business_Plan_Rec_Type

35: -- queries database to retrieve the business plan from the database
36: -- updates the record with the changes sent in
37: --
38: PROCEDURE UpdateRecord
39: ( p_Business_Plan_Rec BIS_Business_Plan_PUB.Business_Plan_Rec_Type
40: , x_Business_Plan_Rec OUT NOCOPY BIS_Business_Plan_PUB.Business_Plan_Rec_Type
41: , x_return_status OUT NOCOPY VARCHAR2
42: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
43: );

Line 40: , x_Business_Plan_Rec OUT NOCOPY BIS_Business_Plan_PUB.Business_Plan_Rec_Type

36: -- updates the record with the changes sent in
37: --
38: PROCEDURE UpdateRecord
39: ( p_Business_Plan_Rec BIS_Business_Plan_PUB.Business_Plan_Rec_Type
40: , x_Business_Plan_Rec OUT NOCOPY BIS_Business_Plan_PUB.Business_Plan_Rec_Type
41: , x_return_status OUT NOCOPY VARCHAR2
42: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
43: );
44: --

Line 47: ( p_Business_Plan_Rec IN BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type

43: );
44: --
45: --
46: PROCEDURE SetNULL
47: ( p_Business_Plan_Rec IN BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type
48: , x_Business_Plan_Rec OUT NOCOPY BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type
49: )
50: IS
51: BEGIN

Line 48: , x_Business_Plan_Rec OUT NOCOPY BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type

44: --
45: --
46: PROCEDURE SetNULL
47: ( p_Business_Plan_Rec IN BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type
48: , x_Business_Plan_Rec OUT NOCOPY BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type
49: )
50: IS
51: BEGIN
52:

Line 78: ( p_Business_Plan_Rec BIS_Business_Plan_PUB.Business_Plan_Rec_Type

74:
75: END SetNULL;
76: --
77: PROCEDURE UpdateRecord
78: ( p_Business_Plan_Rec BIS_Business_Plan_PUB.Business_Plan_Rec_Type
79: , x_Business_Plan_Rec OUT NOCOPY BIS_Business_Plan_PUB.Business_Plan_Rec_Type
80: , x_return_status OUT NOCOPY VARCHAR2
81: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
82: )

Line 79: , x_Business_Plan_Rec OUT NOCOPY BIS_Business_Plan_PUB.Business_Plan_Rec_Type

75: END SetNULL;
76: --
77: PROCEDURE UpdateRecord
78: ( p_Business_Plan_Rec BIS_Business_Plan_PUB.Business_Plan_Rec_Type
79: , x_Business_Plan_Rec OUT NOCOPY BIS_Business_Plan_PUB.Business_Plan_Rec_Type
80: , x_return_status OUT NOCOPY VARCHAR2
81: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
82: )
83: IS

Line 85: l_Business_Plan_Rec BIS_Business_Plan_PUB.Business_Plan_Rec_Type;

81: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
82: )
83: IS
84: --
85: l_Business_Plan_Rec BIS_Business_Plan_PUB.Business_Plan_Rec_Type;
86: l_return_status VARCHAR2(10);
87: --
88: BEGIN
89: x_return_status:= FND_API.G_RET_STS_SUCCESS;

Line 170: , x_Business_Plan_Tbl OUT NOCOPY BIS_BUSINESS_PLAN_PUB.Business_Plan_Tbl_Type

166: --
167: --
168: Procedure Retrieve_Business_Plans
169: ( p_api_version IN NUMBER
170: , x_Business_Plan_Tbl OUT NOCOPY BIS_BUSINESS_PLAN_PUB.Business_Plan_Tbl_Type
171: , x_return_status OUT NOCOPY VARCHAR2
172: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
173: )
174: IS

Line 176: l_business_plan_rec BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type;

172: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
173: )
174: IS
175:
176: l_business_plan_rec BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type;
177: cursor cr_all_business_plans is
178: select plan_id
179: , short_name
180: , name

Line 225: , p_Business_Plan_Rec IN BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type

221: END Retrieve_Business_Plans;
222: --
223: Procedure Retrieve_Business_Plan
224: ( p_api_version IN NUMBER
225: , p_Business_Plan_Rec IN BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type
226: , x_Business_Plan_Rec OUT NOCOPY BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type
227: , x_return_status OUT NOCOPY VARCHAR2
228: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
229: )

Line 226: , x_Business_Plan_Rec OUT NOCOPY BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type

222: --
223: Procedure Retrieve_Business_Plan
224: ( p_api_version IN NUMBER
225: , p_Business_Plan_Rec IN BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type
226: , x_Business_Plan_Rec OUT NOCOPY BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type
227: , x_return_status OUT NOCOPY VARCHAR2
228: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
229: )
230: is

Line 275: , p_Business_Plan_Rec IN BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type

271: Procedure Create_Business_Plan
272: ( p_api_version IN NUMBER
273: , p_commit IN VARCHAR2 := FND_API.G_FALSE
274: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
275: , p_Business_Plan_Rec IN BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type
276: , x_return_status OUT NOCOPY VARCHAR2
277: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
278: )
279: IS

Line 309: , p_Business_Plan_Rec IN BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type

305: Procedure Create_Business_Plan
306: ( p_api_version IN NUMBER
307: , p_commit IN VARCHAR2 := FND_API.G_FALSE
308: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
309: , p_Business_Plan_Rec IN BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type
310: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
311: , x_return_status OUT NOCOPY VARCHAR2
312: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
313: )

Line 318: l_business_plan_rec BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type;

314: IS
315: l_user_id NUMBER;
316: l_login_id NUMBER;
317: l_id NUMBER;
318: l_business_plan_rec BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type;
319: BEGIN
320:
321: x_return_status := FND_API.G_RET_STS_SUCCESS;
322: l_business_plan_Rec := p_business_plan_Rec;

Line 438: , p_Business_Plan_Rec IN BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type

434: Procedure Update_Business_Plan
435: ( p_api_version IN NUMBER
436: , p_commit IN VARCHAR2 := FND_API.G_FALSE
437: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
438: , p_Business_Plan_Rec IN BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type
439: , x_return_status OUT NOCOPY VARCHAR2
440: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
441: )
442: IS

Line 471: , p_Business_Plan_Rec IN BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type

467: Procedure Update_Business_Plan
468: ( p_api_version IN NUMBER
469: , p_commit IN VARCHAR2 := FND_API.G_FALSE
470: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
471: , p_Business_Plan_Rec IN BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type
472: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
473: , x_return_status OUT NOCOPY VARCHAR2
474: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
475: )

Line 480: l_business_plan_rec BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type;

476: IS
477: l_user_id number;
478: l_login_id number;
479: l_count NUMBER := 0;
480: l_business_plan_rec BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type;
481:
482: BEGIN
483:
484: -- retrieve record from database and apply changes

Line 565: , p_Business_Plan_Rec IN BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type

561: Procedure Translate_Business_Plan
562: ( p_api_version IN NUMBER
563: , p_commit IN VARCHAR2 := FND_API.G_FALSE
564: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
565: , p_Business_Plan_Rec IN BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type
566: , x_return_status OUT NOCOPY VARCHAR2
567: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
568: )
569: IS

Line 598: , p_Business_Plan_Rec IN BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type

594: Procedure Translate_Business_Plan
595: ( p_api_version IN NUMBER
596: , p_commit IN VARCHAR2 := FND_API.G_FALSE
597: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
598: , p_Business_Plan_Rec IN BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type
599: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
600: , x_return_status OUT NOCOPY VARCHAR2
601: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
602: )

Line 607: l_business_plan_rec BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type;

603: IS
604: l_user_id NUMBER;
605: l_login_id NUMBER;
606: l_count NUMBER := 0;
607: l_business_plan_rec BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type;
608:
609: BEGIN
610:
611: -- retrieve record from database and apply changes

Line 680: , p_Business_Plan_Rec IN BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type

676: --
677: PROCEDURE Validate_Business_Plan
678: ( p_api_version IN NUMBER
679: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
680: , p_Business_Plan_Rec IN BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type
681: , x_return_status OUT NOCOPY VARCHAR2
682: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
683: )
684: IS

Line 734: , p_Business_Plan_Rec IN BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type

730: --
731: -- Value - ID conversion
732: PROCEDURE Value_ID_Conversion
733: ( p_api_version IN NUMBER
734: , p_Business_Plan_Rec IN BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type
735: , x_Business_Plan_Rec OUT NOCOPY BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type
736: , x_return_status OUT NOCOPY VARCHAR2
737: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
738: )

Line 735: , x_Business_Plan_Rec OUT NOCOPY BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type

731: -- Value - ID conversion
732: PROCEDURE Value_ID_Conversion
733: ( p_api_version IN NUMBER
734: , p_Business_Plan_Rec IN BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type
735: , x_Business_Plan_Rec OUT NOCOPY BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type
736: , x_return_status OUT NOCOPY VARCHAR2
737: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
738: )
739: is