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_UTILITIES_PUB

Line 42: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

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: --
45: --
46: PROCEDURE SetNULL

Line 81: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

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
84: --
85: l_Business_Plan_Rec BIS_Business_Plan_PUB.Business_Plan_Rec_Type;

Line 101: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_Business_Plan_Rec.Business_Plan_ID)

97: , x_error_Tbl => x_error_Tbl
98: );
99:
100: -- apply changes
101: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_Business_Plan_Rec.Business_Plan_ID)
102: = FND_API.G_TRUE
103: ) THEN
104: l_Business_Plan_Rec.Business_Plan_ID
105: := p_Business_Plan_Rec.Business_Plan_ID;

Line 108: IF( BIS_UTILITIES_PUB.Value_Not_Missing(

104: l_Business_Plan_Rec.Business_Plan_ID
105: := p_Business_Plan_Rec.Business_Plan_ID;
106: END IF;
107: --
108: IF( BIS_UTILITIES_PUB.Value_Not_Missing(
109: p_Business_Plan_Rec.Business_Plan_Short_Name)
110: = FND_API.G_TRUE
111: ) THEN
112: l_Business_Plan_Rec.Business_Plan_Short_Name

Line 116: IF( BIS_UTILITIES_PUB.Value_Not_Missing(

112: l_Business_Plan_Rec.Business_Plan_Short_Name
113: := p_Business_Plan_Rec.Business_Plan_Short_Name ;
114: END IF;
115: --
116: IF( BIS_UTILITIES_PUB.Value_Not_Missing(
117: p_Business_Plan_Rec.Business_Plan_Name)
118: = FND_API.G_TRUE
119: ) THEN
120: l_Business_Plan_Rec.Business_Plan_Name

Line 124: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_Business_Plan_Rec.Description)

120: l_Business_Plan_Rec.Business_Plan_Name
121: := p_Business_Plan_Rec.Business_Plan_Name;
122: END IF;
123: --
124: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_Business_Plan_Rec.Description)
125: = FND_API.G_TRUE
126: ) THEN
127: l_Business_Plan_Rec.Description
128: := p_Business_Plan_Rec.Description;

Line 131: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_Business_Plan_Rec.Version_number)

127: l_Business_Plan_Rec.Description
128: := p_Business_Plan_Rec.Description;
129: END IF;
130: --
131: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_Business_Plan_Rec.Version_number)
132: = FND_API.G_TRUE
133: ) THEN
134: l_Business_Plan_Rec.Version_number
135: := p_Business_Plan_Rec.Version_number;

Line 138: IF( BIS_UTILITIES_PUB.Value_Not_Missing(

134: l_Business_Plan_Rec.Version_number
135: := p_Business_Plan_Rec.Version_number;
136: END IF;
137: --
138: IF( BIS_UTILITIES_PUB.Value_Not_Missing(
139: p_Business_Plan_Rec.Current_Plan_Flag)
140: = FND_API.G_TRUE
141: ) THEN
142: l_Business_Plan_Rec.Current_Plan_Flag

Line 172: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

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
175:
176: l_business_plan_rec BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type;

Line 228: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

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
231: begin
232:

Line 277: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

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
280: BEGIN
281:

Line 287: , p_owner => BIS_UTILITIES_PUB.G_CUSTOM_OWNER

283: ( p_api_version => p_api_version
284: , p_commit => p_commit
285: , p_validation_level => p_validation_level
286: , p_Business_Plan_Rec => p_Business_Plan_Rec
287: , p_owner => BIS_UTILITIES_PUB.G_CUSTOM_OWNER
288: , x_return_status => x_return_status
289: , x_error_Tbl => x_error_Tbl
290: );
291:

Line 310: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER

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: )
314: IS

Line 312: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

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: )
314: IS
315: l_user_id NUMBER;
316: l_login_id NUMBER;

Line 340: IF p_owner = BIS_UTILITIES_PUB.G_SEED_OWNER THEN

336: IF( x_return_status <> FND_API.G_RET_STS_SUCCESS) then
337: RAISE FND_API.G_EXC_ERROR;
338: END IF;
339: --
340: IF p_owner = BIS_UTILITIES_PUB.G_SEED_OWNER THEN
341: l_user_id := BIS_UTILITIES_PUB.G_SEED_USER_ID;
342: ELSE
343: l_user_id := fnd_global.USER_ID;
344: END IF;

Line 341: l_user_id := BIS_UTILITIES_PUB.G_SEED_USER_ID;

337: RAISE FND_API.G_EXC_ERROR;
338: END IF;
339: --
340: IF p_owner = BIS_UTILITIES_PUB.G_SEED_OWNER THEN
341: l_user_id := BIS_UTILITIES_PUB.G_SEED_USER_ID;
342: ELSE
343: l_user_id := fnd_global.USER_ID;
344: END IF;
345:

Line 440: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

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
443: BEGIN
444:

Line 450: , p_owner => BIS_UTILITIES_PUB.G_CUSTOM_OWNER

446: ( p_api_version => p_api_version
447: , p_commit => p_commit
448: , p_validation_level => p_validation_level
449: , p_Business_Plan_Rec => p_Business_Plan_Rec
450: , p_owner => BIS_UTILITIES_PUB.G_CUSTOM_OWNER
451: , x_return_status => x_return_status
452: , x_error_Tbl => x_error_Tbl
453: );
454:

Line 472: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER

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: )
476: IS

Line 474: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

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: )
476: IS
477: l_user_id number;
478: l_login_id number;

Line 504: IF p_owner = BIS_UTILITIES_PUB.G_SEED_OWNER THEN

500: IF( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
501: RAISE FND_API.G_EXC_ERROR;
502: END IF;
503: --
504: IF p_owner = BIS_UTILITIES_PUB.G_SEED_OWNER THEN
505: l_user_id := BIS_UTILITIES_PUB.G_SEED_USER_ID;
506: ELSE
507: l_user_id := fnd_global.USER_ID;
508: END IF;

Line 505: l_user_id := BIS_UTILITIES_PUB.G_SEED_USER_ID;

501: RAISE FND_API.G_EXC_ERROR;
502: END IF;
503: --
504: IF p_owner = BIS_UTILITIES_PUB.G_SEED_OWNER THEN
505: l_user_id := BIS_UTILITIES_PUB.G_SEED_USER_ID;
506: ELSE
507: l_user_id := fnd_global.USER_ID;
508: END IF;
509:

Line 567: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

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
570: BEGIN
571:

Line 577: , p_owner => BIS_UTILITIES_PUB.G_CUSTOM_OWNER

573: ( p_api_version => p_api_version
574: , p_commit => p_commit
575: , p_validation_level => p_validation_level
576: , p_Business_Plan_Rec => p_Business_Plan_Rec
577: , p_owner => BIS_UTILITIES_PUB.G_CUSTOM_OWNER
578: , x_return_status => x_return_status
579: , x_error_Tbl => x_error_Tbl
580: );
581:

Line 599: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER

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: )
603: IS

Line 601: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

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: )
603: IS
604: l_user_id NUMBER;
605: l_login_id NUMBER;

Line 631: IF p_owner = BIS_UTILITIES_PUB.G_SEED_OWNER THEN

627: IF( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
628: RAISE FND_API.G_EXC_ERROR;
629: END IF;
630: --
631: IF p_owner = BIS_UTILITIES_PUB.G_SEED_OWNER THEN
632: l_user_id := BIS_UTILITIES_PUB.G_SEED_USER_ID;
633: ELSE
634: l_user_id := fnd_global.USER_ID;
635: END IF;

Line 632: l_user_id := BIS_UTILITIES_PUB.G_SEED_USER_ID;

628: RAISE FND_API.G_EXC_ERROR;
629: END IF;
630: --
631: IF p_owner = BIS_UTILITIES_PUB.G_SEED_OWNER THEN
632: l_user_id := BIS_UTILITIES_PUB.G_SEED_USER_ID;
633: ELSE
634: l_user_id := fnd_global.USER_ID;
635: END IF;
636:

Line 682: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

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
685: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
686: BEGIN

Line 685: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

681: , x_return_status OUT NOCOPY VARCHAR2
682: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
683: )
684: IS
685: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
686: BEGIN
687: BEGIN
688:
689: BIS_BUSINESS_PLAN_VALIDATE_PVT.Validate_Record

Line 737: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

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
740: begin
741:

Line 745: if (BIS_UTILITIES_PUB.Value_Missing(x_Business_Plan_Rec.Business_Plan_id)

741:
742: x_return_status := FND_API.G_RET_STS_SUCCESS;
743: x_Business_Plan_Rec := p_Business_Plan_Rec;
744:
745: if (BIS_UTILITIES_PUB.Value_Missing(x_Business_Plan_Rec.Business_Plan_id)
746: = FND_API.G_TRUE) then
747:
748: BIS_BUSINESS_PLAN_PVT.Value_ID_Conversion
749: ( p_api_version

Line 785: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

781: , p_Business_Plan_Short_Name IN VARCHAR2
782: , p_Business_Plan_Name IN VARCHAR2
783: , x_Business_Plan_ID OUT NOCOPY NUMBER
784: , x_return_status OUT NOCOPY VARCHAR2
785: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
786: )
787: is
788: begin
789:

Line 792: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_Business_Plan_Short_Name)

788: begin
789:
790: x_return_status := FND_API.G_RET_STS_SUCCESS;
791:
792: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_Business_Plan_Short_Name)
793: = FND_API.G_TRUE) then
794:
795: SELECT plan_id into x_Business_Plan_ID
796: FROM bis_business_plans

Line 799: elsif (BIS_UTILITIES_PUB.Value_Not_Missing(p_Business_Plan_Name)

795: SELECT plan_id into x_Business_Plan_ID
796: FROM bis_business_plans
797: WHERE short_name = p_Business_Plan_Short_Name;
798:
799: elsif (BIS_UTILITIES_PUB.Value_Not_Missing(p_Business_Plan_Name)
800: = FND_API.G_TRUE) then
801:
802: SELECT plan_id into x_Business_Plan_ID
803: FROM bis_business_plans_tl

Line 812: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

808: BIS_UTILITIES_PVT.Add_Error_Message
809: ( p_error_msg_name => 'BIS_NAME_SHORT_NAME_MISSING'
810: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
811: , p_error_proc_name => G_PKG_NAME||'.Value_ID_Conversion'
812: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
813: );
814:
815: RAISE FND_API.G_EXC_ERROR;
816: end if;