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_PERIODICITIES_PUB dependencies on BSC_PERIODICITIES_PUB

Line 1: PACKAGE BODY BSC_PERIODICITIES_PUB AS

1: PACKAGE BODY BSC_PERIODICITIES_PUB AS
2: /* $Header: BSCPPERB.pls 120.13.12000000.4 2007/05/16 12:51:35 ppandey ship $ */
3: /*
4: REM +=======================================================================+
5: REM | Copyright (c) 2002 Oracle Corporation, Redwood Shores, CA, USA |

Line 29: G_PKG_NAME CONSTANT VARCHAR2(30):='BSC_PERIODICITIES_PUB';

25: REM | 21-MAR-2006 ashankar Fixed bug#5099465 Modified Validate_Periodicity |
26: REM +=======================================================================+
27: */
28:
29: G_PKG_NAME CONSTANT VARCHAR2(30):='BSC_PERIODICITIES_PUB';
30:
31:
32: /*
33: Procedure Name

Line 51: ,p_Periodicities_Rec_Type IN BSC_PERIODICITIES_PUB.Periodicities_Rec_Type

47:
48: PROCEDURE Create_Periodicity (
49: p_Api_Version IN NUMBER
50: ,p_Commit IN VARCHAR2
51: ,p_Periodicities_Rec_Type IN BSC_PERIODICITIES_PUB.Periodicities_Rec_Type
52: ,p_disable_period_val_flag IN VARCHAR2
53: ,x_Return_Status OUT NOCOPY VARCHAR2
54: ,x_Msg_Count OUT NOCOPY NUMBER
55: ,x_Msg_Data OUT NOCOPY VARCHAR2

Line 57: l_Periodicities_Rec_Type BSC_PERIODICITIES_PUB.Periodicities_Rec_Type;

53: ,x_Return_Status OUT NOCOPY VARCHAR2
54: ,x_Msg_Count OUT NOCOPY NUMBER
55: ,x_Msg_Data OUT NOCOPY VARCHAR2
56: ) IS
57: l_Periodicities_Rec_Type BSC_PERIODICITIES_PUB.Periodicities_Rec_Type;
58: l_Dim_Short_Name BSC_SYS_CALENDARS_B.SHORT_NAME%TYPE;
59: l_Periodicity_View_Name VARCHAR2(30);
60: l_Dimobj_Name BIS_LEVELS_TL.NAME%TYPE;
61: l_Dim_Enabled VARCHAR2(10);

Line 70: BSC_PERIODICITIES_PUB.Populate_Periodicity_Record (

66: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
67: l_Dim_Enabled := FND_API.G_TRUE;
68: l_Periodicities_Rec_Type := p_Periodicities_Rec_Type;
69:
70: BSC_PERIODICITIES_PUB.Populate_Periodicity_Record (
71: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0
72: ,p_Periodicities_Rec_Type => p_Periodicities_Rec_Type
73: ,x_Periodicities_Rec_Type => l_Periodicities_Rec_Type
74: ,x_Return_Status => x_Return_Status

Line 82: BSC_PERIODICITIES_PUB.Validate_Periodicity (

78: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
79: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
80: END IF;
81:
82: BSC_PERIODICITIES_PUB.Validate_Periodicity (
83: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0
84: ,p_Periodicities_Rec_Type => l_Periodicities_Rec_Type
85: ,p_Action_Type => BSC_PERIODS_UTILITY_PKG.C_CREATE
86: ,x_Return_Status => x_Return_Status

Line 106: BSC_PERIODICITIES_PUB.Populate_Period_Metadata (

102: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
104: END IF;
105:
106: BSC_PERIODICITIES_PUB.Populate_Period_Metadata (
107: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0
108: ,p_Commit => p_Commit
109: ,p_Action_Type => BSC_PERIODS_UTILITY_PKG.C_CREATE
110: ,p_Periodicities_Rec_Type => l_Periodicities_Rec_Type

Line 120: BSC_PERIODICITIES_PUB.Update_Annually_Source (

116: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
118: END IF;
119:
120: BSC_PERIODICITIES_PUB.Update_Annually_Source (
121: p_Calendar_Id => l_Periodicities_Rec_Type.Calendar_Id
122: ,p_Periodicity_Id => l_Periodicities_Rec_Type.Periodicity_Id
123: ,p_Action => 1 -- Action for new/updated Period.
124: ,x_Return_Status => x_Return_Status

Line 224: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PUB.Create_Periodicity ';

220: WHEN NO_DATA_FOUND THEN
221: ROLLBACK TO CreatePeriodicityPUB;
222: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
223: IF (x_msg_data IS NOT NULL) THEN
224: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PUB.Create_Periodicity ';
225: ELSE
226: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Create_Periodicity ';
227: END IF;
228: WHEN OTHERS THEN

Line 226: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Create_Periodicity ';

222: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
223: IF (x_msg_data IS NOT NULL) THEN
224: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PUB.Create_Periodicity ';
225: ELSE
226: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Create_Periodicity ';
227: END IF;
228: WHEN OTHERS THEN
229: ROLLBACK TO CreatePeriodicityPUB;
230: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 232: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PUB.Create_Periodicity ';

228: WHEN OTHERS THEN
229: ROLLBACK TO CreatePeriodicityPUB;
230: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
231: IF (x_msg_data IS NOT NULL) THEN
232: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PUB.Create_Periodicity ';
233: ELSE
234: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Create_Periodicity ';
235: END IF;
236: END Create_Periodicity;

Line 234: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Create_Periodicity ';

230: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
231: IF (x_msg_data IS NOT NULL) THEN
232: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PUB.Create_Periodicity ';
233: ELSE
234: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Create_Periodicity ';
235: END IF;
236: END Create_Periodicity;
237:
238:

Line 242: ,p_Periodicities_Rec_Type IN BSC_PERIODICITIES_PUB.Periodicities_Rec_Type

238:
239: PROCEDURE Update_Periodicity (
240: p_Api_Version IN NUMBER
241: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
242: ,p_Periodicities_Rec_Type IN BSC_PERIODICITIES_PUB.Periodicities_Rec_Type
243: ,p_disable_period_val_flag IN VARCHAR2
244: ,x_Return_Status OUT NOCOPY VARCHAR2
245: ,x_Msg_Count OUT NOCOPY NUMBER
246: ,x_Msg_Data OUT NOCOPY VARCHAR2

Line 248: l_Periodicities_Rec_Type BSC_PERIODICITIES_PUB.Periodicities_Rec_Type;

244: ,x_Return_Status OUT NOCOPY VARCHAR2
245: ,x_Msg_Count OUT NOCOPY NUMBER
246: ,x_Msg_Data OUT NOCOPY VARCHAR2
247: ) IS
248: l_Periodicities_Rec_Type BSC_PERIODICITIES_PUB.Periodicities_Rec_Type;
249: l_Structural_Flag VARCHAR2(1);
250: l_Periodicity_View_Name VARCHAR2(30);
251: l_Message_Name BSC_MESSAGES.MESSAGE_NAME%TYPE;
252: l_Objective_List VARCHAR2(2000);

Line 266: BSC_PERIODICITIES_PUB.Validate_Periodicity (

262: l_Periodicities_Rec_Type := p_Periodicities_Rec_Type;
263:
264: l_Structural_Flag := FND_API.G_FALSE;
265:
266: BSC_PERIODICITIES_PUB.Validate_Periodicity (
267: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0
268: ,p_Periodicities_Rec_Type => l_Periodicities_Rec_Type
269: ,p_Action_Type => BSC_PERIODS_UTILITY_PKG.C_UPDATE
270: ,x_Return_Status => x_Return_Status

Line 278: BSC_PERIODICITIES_PUB.Get_Incr_Change (

274: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
276: END IF;
277:
278: BSC_PERIODICITIES_PUB.Get_Incr_Change (
279: p_Periodicity_Id => l_Periodicities_Rec_Type.Periodicity_Id
280: ,p_Calendar_ID => l_Periodicities_Rec_Type.Calendar_Id
281: ,p_Base_Periodicity_Id => l_Periodicities_Rec_Type.Base_Periodicity_Id
282: ,p_Num_Of_Periods => l_Periodicities_Rec_Type.Num_Of_Periods

Line 306: BSC_PERIODICITIES_PUB.Populate_Period_Metadata (

302: IF (l_Message_Name IS NOT NULL) THEN
303: l_Structural_Flag := FND_API.G_TRUE;
304: END IF ;
305:
306: BSC_PERIODICITIES_PUB.Populate_Period_Metadata (
307: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0
308: ,p_Commit => p_Commit
309: ,p_Action_Type => BSC_PERIODS_UTILITY_PKG.C_UPDATE
310: ,p_Periodicities_Rec_Type => l_Periodicities_Rec_Type

Line 320: BSC_PERIODICITIES_PUB.Update_Annually_Source(

316: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
318: END IF;
319:
320: BSC_PERIODICITIES_PUB.Update_Annually_Source(
321: p_Calendar_Id => l_Periodicities_Rec_Type.Calendar_Id
322: ,p_Periodicity_Id => l_Periodicities_Rec_Type.Periodicity_Id
323: ,p_Action => 1 -- Action for new/updated Period.
324: ,x_Return_Status => x_Return_Status

Line 446: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PUB.Update_Periodicity ';

442: WHEN NO_DATA_FOUND THEN
443: ROLLBACK TO UpdatePeriodicityPUB;
444: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
445: IF (x_msg_data IS NOT NULL) THEN
446: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PUB.Update_Periodicity ';
447: ELSE
448: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Update_Periodicity ';
449: END IF;
450: WHEN OTHERS THEN

Line 448: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Update_Periodicity ';

444: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
445: IF (x_msg_data IS NOT NULL) THEN
446: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PUB.Update_Periodicity ';
447: ELSE
448: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Update_Periodicity ';
449: END IF;
450: WHEN OTHERS THEN
451: ROLLBACK TO UpdatePeriodicityPUB;
452: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 454: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PUB.Update_Periodicity ';

450: WHEN OTHERS THEN
451: ROLLBACK TO UpdatePeriodicityPUB;
452: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
453: IF (x_msg_data IS NOT NULL) THEN
454: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PUB.Update_Periodicity ';
455: ELSE
456: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Update_Periodicity ';
457: END IF;
458: END Update_Periodicity;

Line 456: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Update_Periodicity ';

452: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
453: IF (x_msg_data IS NOT NULL) THEN
454: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PUB.Update_Periodicity ';
455: ELSE
456: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Update_Periodicity ';
457: END IF;
458: END Update_Periodicity;
459:
460:

Line 466: ,p_Periodicities_Rec_Type IN BSC_PERIODICITIES_PUB.Periodicities_Rec_Type

462: -- Delete periodicity API
463: PROCEDURE Delete_Periodicity (
464: p_Api_Version IN NUMBER
465: ,p_Commit IN VARCHAR2
466: ,p_Periodicities_Rec_Type IN BSC_PERIODICITIES_PUB.Periodicities_Rec_Type
467: ,x_Return_Status OUT NOCOPY VARCHAR2
468: ,x_Msg_Count OUT NOCOPY NUMBER
469: ,x_Msg_Data OUT NOCOPY VARCHAR2
470: ) IS

Line 492: BSC_PERIODICITIES_PUB.Validate_Periodicity (

488: --dbms_output.PUT_LINE('p_Periodicities_Rec_Type.Periodicity_Id - ' ||p_Periodicities_Rec_Type.Periodicity_Id);
489: --dbms_output.PUT_LINE('p_Periodicities_Rec_Type.Calendar_Id - ' ||p_Periodicities_Rec_Type.Calendar_Id);
490:
491:
492: BSC_PERIODICITIES_PUB.Validate_Periodicity (
493: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0
494: ,p_Periodicities_Rec_Type => p_Periodicities_Rec_Type
495: ,p_Action_Type => BSC_PERIODS_UTILITY_PKG.C_DELETE
496: ,x_Return_Status => x_Return_Status

Line 539: BSC_PERIODICITIES_PUB.Update_Annually_Source(

535: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
537: END IF;
538:
539: BSC_PERIODICITIES_PUB.Update_Annually_Source(
540: p_Calendar_Id => p_Periodicities_Rec_Type.Calendar_Id
541: ,p_Periodicity_Id => p_Periodicities_Rec_Type.Periodicity_Id
542: ,p_Action => 2 -- Action for Period Delete.
543: ,x_Return_Status => x_Return_Status

Line 630: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PUB.Delete_Periodicity ';

626: WHEN NO_DATA_FOUND THEN
627: ROLLBACK TO DeletePeriodicityPUB;
628: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
629: IF (x_msg_data IS NOT NULL) THEN
630: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PUB.Delete_Periodicity ';
631: ELSE
632: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Delete_Periodicity ';
633: END IF;
634: WHEN OTHERS THEN

Line 632: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Delete_Periodicity ';

628: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
629: IF (x_msg_data IS NOT NULL) THEN
630: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PUB.Delete_Periodicity ';
631: ELSE
632: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Delete_Periodicity ';
633: END IF;
634: WHEN OTHERS THEN
635: ROLLBACK TO DeletePeriodicityPUB;
636: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 638: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PUB.Delete_Periodicity ';

634: WHEN OTHERS THEN
635: ROLLBACK TO DeletePeriodicityPUB;
636: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
637: IF (x_msg_data IS NOT NULL) THEN
638: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PUB.Delete_Periodicity ';
639: ELSE
640: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Delete_Periodicity ';
641: END IF;
642: END Delete_Periodicity;

Line 640: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Delete_Periodicity ';

636: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
637: IF (x_msg_data IS NOT NULL) THEN
638: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PUB.Delete_Periodicity ';
639: ELSE
640: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Delete_Periodicity ';
641: END IF;
642: END Delete_Periodicity;
643:
644:

Line 647: ,p_Periodicities_Rec_Type IN BSC_PERIODICITIES_PUB.Periodicities_Rec_Type

643:
644:
645: PROCEDURE Validate_Periodicity (
646: p_Api_Version IN NUMBER
647: ,p_Periodicities_Rec_Type IN BSC_PERIODICITIES_PUB.Periodicities_Rec_Type
648: ,p_Action_Type IN VARCHAR2
649: ,x_Return_Status OUT NOCOPY VARCHAR2
650: ,x_Msg_Count OUT NOCOPY NUMBER
651: ,x_Msg_Data OUT NOCOPY VARCHAR2

Line 654: BSC_PERIODICITIES_PUB.Validate_Periodicity

650: ,x_Msg_Count OUT NOCOPY NUMBER
651: ,x_Msg_Data OUT NOCOPY VARCHAR2
652: )IS
653: BEGIN
654: BSC_PERIODICITIES_PUB.Validate_Periodicity
655: (
656: p_Api_Version => p_Api_Version
657: ,p_Periodicities_Rec_Type => p_Periodicities_Rec_Type
658: ,p_Action_Type => p_Action_Type

Line 670: ,p_Periodicities_Rec_Type IN BSC_PERIODICITIES_PUB.Periodicities_Rec_Type

666:
667:
668: PROCEDURE Validate_Periodicity (
669: p_Api_Version IN NUMBER
670: ,p_Periodicities_Rec_Type IN BSC_PERIODICITIES_PUB.Periodicities_Rec_Type
671: ,p_Action_Type IN VARCHAR2
672: ,p_disable_period_val_flag IN VARCHAR2
673: ,x_Return_Status OUT NOCOPY VARCHAR2
674: ,x_Msg_Count OUT NOCOPY NUMBER

Line 905: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PUB.Validate_Periodicity ';

901: WHEN NO_DATA_FOUND THEN
902: ROLLBACK TO ValidatePeriodicityPUB;
903: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
904: IF (x_msg_data IS NOT NULL) THEN
905: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PUB.Validate_Periodicity ';
906: ELSE
907: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Validate_Periodicity ';
908: END IF;
909: WHEN OTHERS THEN

Line 907: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Validate_Periodicity ';

903: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
904: IF (x_msg_data IS NOT NULL) THEN
905: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PUB.Validate_Periodicity ';
906: ELSE
907: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Validate_Periodicity ';
908: END IF;
909: WHEN OTHERS THEN
910: ROLLBACK TO ValidatePeriodicityPUB;
911: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 913: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PUB.Validate_Periodicity ';

909: WHEN OTHERS THEN
910: ROLLBACK TO ValidatePeriodicityPUB;
911: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
912: IF (x_msg_data IS NOT NULL) THEN
913: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PUB.Validate_Periodicity ';
914: ELSE
915: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Validate_Periodicity ';
916: END IF;
917: END Validate_Periodicity;

Line 915: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Validate_Periodicity ';

911: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
912: IF (x_msg_data IS NOT NULL) THEN
913: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PUB.Validate_Periodicity ';
914: ELSE
915: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Validate_Periodicity ';
916: END IF;
917: END Validate_Periodicity;
918:
919: -- This API tries to populate the periodicity record with pre-req/default values.

Line 923: ,p_Periodicities_Rec_Type IN BSC_PERIODICITIES_PUB.Periodicities_Rec_Type

919: -- This API tries to populate the periodicity record with pre-req/default values.
920:
921: PROCEDURE Populate_Periodicity_Record (
922: p_Api_Version IN NUMBER
923: ,p_Periodicities_Rec_Type IN BSC_PERIODICITIES_PUB.Periodicities_Rec_Type
924: ,x_Periodicities_Rec_Type OUT NOCOPY BSC_PERIODICITIES_PUB.Periodicities_Rec_Type
925: ,x_Return_Status OUT NOCOPY VARCHAR2
926: ,x_Msg_Count OUT NOCOPY NUMBER
927: ,x_Msg_Data OUT NOCOPY VARCHAR2

Line 924: ,x_Periodicities_Rec_Type OUT NOCOPY BSC_PERIODICITIES_PUB.Periodicities_Rec_Type

920:
921: PROCEDURE Populate_Periodicity_Record (
922: p_Api_Version IN NUMBER
923: ,p_Periodicities_Rec_Type IN BSC_PERIODICITIES_PUB.Periodicities_Rec_Type
924: ,x_Periodicities_Rec_Type OUT NOCOPY BSC_PERIODICITIES_PUB.Periodicities_Rec_Type
925: ,x_Return_Status OUT NOCOPY VARCHAR2
926: ,x_Msg_Count OUT NOCOPY NUMBER
927: ,x_Msg_Data OUT NOCOPY VARCHAR2
928: ) IS

Line 1064: ,p_Periodicities_Rec_Type IN BSC_PERIODICITIES_PUB.Periodicities_Rec_Type

1060: PROCEDURE Populate_Period_Metadata (
1061: p_Api_Version IN NUMBER
1062: ,p_Commit IN VARCHAR2
1063: ,p_Action_Type IN VARCHAR2
1064: ,p_Periodicities_Rec_Type IN BSC_PERIODICITIES_PUB.Periodicities_Rec_Type
1065: ,p_disable_period_val_flag IN VARCHAR2
1066: ,x_Return_Status OUT NOCOPY VARCHAR2
1067: ,x_Msg_Count OUT NOCOPY NUMBER
1068: ,x_Msg_Data OUT NOCOPY VARCHAR2

Line 1162: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PUB.Populate_Period_Metadata ';

1158: WHEN NO_DATA_FOUND THEN
1159: ROLLBACK TO PopulatePeriodsPUB;
1160: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1161: IF (x_msg_data IS NOT NULL) THEN
1162: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PUB.Populate_Period_Metadata ';
1163: ELSE
1164: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Populate_Period_Metadata ';
1165: END IF;
1166: WHEN OTHERS THEN

Line 1164: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Populate_Period_Metadata ';

1160: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1161: IF (x_msg_data IS NOT NULL) THEN
1162: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PUB.Populate_Period_Metadata ';
1163: ELSE
1164: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Populate_Period_Metadata ';
1165: END IF;
1166: WHEN OTHERS THEN
1167: ROLLBACK TO PopulatePeriodsPUB;
1168: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1170: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PUB.Populate_Period_Metadata ';

1166: WHEN OTHERS THEN
1167: ROLLBACK TO PopulatePeriodsPUB;
1168: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1169: IF (x_msg_data IS NOT NULL) THEN
1170: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PUB.Populate_Period_Metadata ';
1171: ELSE
1172: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Populate_Period_Metadata ';
1173: END IF;
1174: END Populate_Period_Metadata;

Line 1172: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Populate_Period_Metadata ';

1168: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1169: IF (x_msg_data IS NOT NULL) THEN
1170: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PUB.Populate_Period_Metadata ';
1171: ELSE
1172: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Populate_Period_Metadata ';
1173: END IF;
1174: END Populate_Period_Metadata;
1175:
1176: -- Public Retrieve API

Line 1179: ,p_Periodicities_Rec_Type IN BSC_PERIODICITIES_PUB.Periodicities_Rec_Type

1175:
1176: -- Public Retrieve API
1177: PROCEDURE Retrieve_Periodicity (
1178: p_Api_Version IN NUMBER
1179: ,p_Periodicities_Rec_Type IN BSC_PERIODICITIES_PUB.Periodicities_Rec_Type
1180: ,x_Periodicities_Rec_Type OUT NOCOPY BSC_PERIODICITIES_PUB.Periodicities_Rec_Type
1181: ,x_Return_Status OUT NOCOPY VARCHAR2
1182: ,x_Msg_Count OUT NOCOPY NUMBER
1183: ,x_Msg_Data OUT NOCOPY VARCHAR2

Line 1180: ,x_Periodicities_Rec_Type OUT NOCOPY BSC_PERIODICITIES_PUB.Periodicities_Rec_Type

1176: -- Public Retrieve API
1177: PROCEDURE Retrieve_Periodicity (
1178: p_Api_Version IN NUMBER
1179: ,p_Periodicities_Rec_Type IN BSC_PERIODICITIES_PUB.Periodicities_Rec_Type
1180: ,x_Periodicities_Rec_Type OUT NOCOPY BSC_PERIODICITIES_PUB.Periodicities_Rec_Type
1181: ,x_Return_Status OUT NOCOPY VARCHAR2
1182: ,x_Msg_Count OUT NOCOPY NUMBER
1183: ,x_Msg_Data OUT NOCOPY VARCHAR2
1184: ) IS

Line 1223: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PUB.Retrieve_Periodicity ';

1219: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1220: WHEN NO_DATA_FOUND THEN
1221: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1222: IF (x_msg_data IS NOT NULL) THEN
1223: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PUB.Retrieve_Periodicity ';
1224: ELSE
1225: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Retrieve_Periodicity ';
1226: END IF;
1227: WHEN OTHERS THEN

Line 1225: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Retrieve_Periodicity ';

1221: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1222: IF (x_msg_data IS NOT NULL) THEN
1223: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PUB.Retrieve_Periodicity ';
1224: ELSE
1225: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Retrieve_Periodicity ';
1226: END IF;
1227: WHEN OTHERS THEN
1228: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1229: IF (x_msg_data IS NOT NULL) THEN

Line 1230: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PUB.Retrieve_Periodicity ';

1226: END IF;
1227: WHEN OTHERS THEN
1228: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1229: IF (x_msg_data IS NOT NULL) THEN
1230: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PUB.Retrieve_Periodicity ';
1231: ELSE
1232: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Retrieve_Periodicity ';
1233: END IF;
1234: END Retrieve_Periodicity;

Line 1232: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Retrieve_Periodicity ';

1228: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1229: IF (x_msg_data IS NOT NULL) THEN
1230: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PUB.Retrieve_Periodicity ';
1231: ELSE
1232: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Retrieve_Periodicity ';
1233: END IF;
1234: END Retrieve_Periodicity;
1235: /**********************************************************************************************/
1236: PROCEDURE Update_Annually_Source

Line 1305: l1_Periodicities_Rec_Type BSC_PERIODICITIES_PUB.Periodicities_Rec_Type;

1301: ,p_Return_Values IN VARCHAR2
1302: ,x_Message_Name OUT NOCOPY VARCHAR2
1303: ,x_Objective_List OUT NOCOPY VARCHAR2
1304: ) IS
1305: l1_Periodicities_Rec_Type BSC_PERIODICITIES_PUB.Periodicities_Rec_Type;
1306: l2_Periodicities_Rec_Type BSC_PERIODICITIES_PUB.Periodicities_Rec_Type;
1307: l_Period_Record BSC_PERIODS_PUB.Period_Record;
1308: l_Structural_Flag VARCHAR2(1);
1309: l_Comma_List VARCHAR2(12228);

Line 1306: l2_Periodicities_Rec_Type BSC_PERIODICITIES_PUB.Periodicities_Rec_Type;

1302: ,x_Message_Name OUT NOCOPY VARCHAR2
1303: ,x_Objective_List OUT NOCOPY VARCHAR2
1304: ) IS
1305: l1_Periodicities_Rec_Type BSC_PERIODICITIES_PUB.Periodicities_Rec_Type;
1306: l2_Periodicities_Rec_Type BSC_PERIODICITIES_PUB.Periodicities_Rec_Type;
1307: l_Period_Record BSC_PERIODS_PUB.Period_Record;
1308: l_Structural_Flag VARCHAR2(1);
1309: l_Comma_List VARCHAR2(12228);
1310: l_Return_Status VARCHAR2(1);

Line 1327: BSC_PERIODICITIES_PUB.Retrieve_Periodicity (

1323:
1324: l1_Periodicities_Rec_Type.Periodicity_Id := p_Periodicity_Id;
1325: l_Structural_Flag := FND_API.G_FALSE;
1326:
1327: BSC_PERIODICITIES_PUB.Retrieve_Periodicity (
1328: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0
1329: ,p_Periodicities_Rec_Type => l1_Periodicities_Rec_Type
1330: ,x_Periodicities_Rec_Type => l2_Periodicities_Rec_Type
1331: ,x_Return_Status => l_Return_Status

Line 1379: ,p_Periodicities_Rec_Type IN BSC_PERIODICITIES_PUB.Periodicities_Rec_Type

1375:
1376: PROCEDURE Create_Periodicity (
1377: p_Api_Version IN NUMBER
1378: ,p_Commit IN VARCHAR2
1379: ,p_Periodicities_Rec_Type IN BSC_PERIODICITIES_PUB.Periodicities_Rec_Type
1380: ,x_Return_Status OUT NOCOPY VARCHAR2
1381: ,x_Msg_Count OUT NOCOPY NUMBER
1382: ,x_Msg_Data OUT NOCOPY VARCHAR2
1383: ) IS

Line 1386: BSC_PERIODICITIES_PUB.Create_Periodicity (

1382: ,x_Msg_Data OUT NOCOPY VARCHAR2
1383: ) IS
1384: BEGIN
1385:
1386: BSC_PERIODICITIES_PUB.Create_Periodicity (
1387: p_Api_Version => p_Api_Version
1388: ,p_Commit => p_Commit
1389: ,p_Periodicities_Rec_Type => p_Periodicities_Rec_Type
1390: ,p_disable_period_val_flag => FND_API.G_FALSE

Line 1402: ,p_Periodicities_Rec_Type IN BSC_PERIODICITIES_PUB.Periodicities_Rec_Type

1398:
1399: PROCEDURE Update_Periodicity (
1400: p_Api_Version IN NUMBER
1401: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
1402: ,p_Periodicities_Rec_Type IN BSC_PERIODICITIES_PUB.Periodicities_Rec_Type
1403: ,x_Return_Status OUT NOCOPY VARCHAR2
1404: ,x_Msg_Count OUT NOCOPY NUMBER
1405: ,x_Msg_Data OUT NOCOPY VARCHAR2
1406: ) IS

Line 1408: BSC_PERIODICITIES_PUB.Update_Periodicity (

1404: ,x_Msg_Count OUT NOCOPY NUMBER
1405: ,x_Msg_Data OUT NOCOPY VARCHAR2
1406: ) IS
1407: BEGIN
1408: BSC_PERIODICITIES_PUB.Update_Periodicity (
1409: p_Api_Version => p_Api_Version
1410: ,p_Commit => p_Commit
1411: ,p_Periodicities_Rec_Type => p_Periodicities_Rec_Type
1412: ,p_disable_period_val_flag => FND_API.G_FALSE

Line 1423: ,p_Periodicities_Rec_Type IN BSC_PERIODICITIES_PUB.Periodicities_Rec_Type

1419:
1420: PROCEDURE Translate_Periodicity (
1421: p_Api_Version IN NUMBER
1422: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
1423: ,p_Periodicities_Rec_Type IN BSC_PERIODICITIES_PUB.Periodicities_Rec_Type
1424: ,p_disable_period_val_flag IN VARCHAR2
1425: ,x_Return_Status OUT NOCOPY VARCHAR2
1426: ,x_Msg_Count OUT NOCOPY NUMBER
1427: ,x_Msg_Data OUT NOCOPY VARCHAR2

Line 1448: ,p_Periodicities_Rec_Type IN BSC_PERIODICITIES_PUB.Periodicities_Rec_Type

1444:
1445: PROCEDURE Load_Periodicity (
1446: p_Api_Version IN NUMBER
1447: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
1448: ,p_Periodicities_Rec_Type IN BSC_PERIODICITIES_PUB.Periodicities_Rec_Type
1449: ,p_disable_period_val_flag IN VARCHAR2
1450: ,x_Return_Status OUT NOCOPY VARCHAR2
1451: ,x_Msg_Count OUT NOCOPY NUMBER
1452: ,x_Msg_Data OUT NOCOPY VARCHAR2

Line 1558: END BSC_PERIODICITIES_PUB;

1554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1555: END IF;
1556: END Load_Periodicity;
1557:
1558: END BSC_PERIODICITIES_PUB;