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_PERIODS_PUB dependencies on BSC_PERIODS_UTILITY_PKG

Line 137: l_Is_Daily_Periodicity := BSC_PERIODS_UTILITY_PKG.Is_Base_Periodicity_Daily(p_Base_Periodicity_Id);

133: FROM bsc_sys_periods
134: WHERE periodicity_id = p_Periodicity_Id;
135: BEGIN
136: IF(p_Base_Periodicity_Id IS NOT NULL) THEN
137: l_Is_Daily_Periodicity := BSC_PERIODS_UTILITY_PKG.Is_Base_Periodicity_Daily(p_Base_Periodicity_Id);
138: END IF;
139: IF(l_Is_Daily_Periodicity) THEN
140: FOR CD_Base IN C_Base_Daily_Periods LOOP
141: IF(l_Periods IS NULL) THEN

Line 223: , p_Action => BSC_PERIODS_UTILITY_PKG.C_CREATE

219: BSC_PERIODS_PUB.Validate_Periods_Action
220: ( p_Api_Version => p_Api_Version
221: , p_Commit => p_Commit
222: , p_Period_Record => l_Period_Record
223: , p_Action => BSC_PERIODS_UTILITY_PKG.C_CREATE
224: , x_Start_Period => x_Start_Period
225: , x_End_Period => x_End_Period
226: , x_Return_Status => x_Return_Status
227: , x_Msg_Count => x_Msg_Count

Line 329: , p_Action => BSC_PERIODS_UTILITY_PKG.C_UPDATE

325: BSC_PERIODS_PUB.Validate_Periods_Action
326: ( p_Api_Version => p_Api_Version
327: , p_Commit => p_Commit
328: , p_Period_Record => l_Period_Record
329: , p_Action => BSC_PERIODS_UTILITY_PKG.C_UPDATE
330: , x_Start_Period => x_Start_Period
331: , x_End_Period => x_End_Period
332: , x_Return_Status => x_Return_Status
333: , x_Msg_Count => x_Msg_Count

Line 417: , p_Action => BSC_PERIODS_UTILITY_PKG.C_DELETE

413: BSC_PERIODS_PUB.Validate_Periods_Action
414: ( p_Api_Version => p_Api_Version
415: , p_Commit => p_Commit
416: , p_Period_Record => p_Period_Record
417: , p_Action => BSC_PERIODS_UTILITY_PKG.C_DELETE
418: , x_Start_Period => NULL
419: , x_End_Period => NULL
420: , x_Return_Status => x_Return_Status
421: , x_Msg_Count => x_Msg_Count

Line 503: l_No_Base_Periods := BSC_PERIODS_UTILITY_PKG.Get_Periods_In_Base_Period(p_Period_Record.Base_Periodicity_Id);

499:
500: FND_MSG_PUB.Initialize;
501: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
502: IF(p_Period_Record.Base_Periodicity_Id IS NOT NULL) THEN
503: l_No_Base_Periods := BSC_PERIODS_UTILITY_PKG.Get_Periods_In_Base_Period(p_Period_Record.Base_Periodicity_Id);
504: l_Is_Daily_Periodicity := BSC_PERIODS_UTILITY_PKG.Is_Base_Periodicity_Daily(p_Period_Record.Base_Periodicity_Id);
505: END IF;
506:
507:

Line 504: l_Is_Daily_Periodicity := BSC_PERIODS_UTILITY_PKG.Is_Base_Periodicity_Daily(p_Period_Record.Base_Periodicity_Id);

500: FND_MSG_PUB.Initialize;
501: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
502: IF(p_Period_Record.Base_Periodicity_Id IS NOT NULL) THEN
503: l_No_Base_Periods := BSC_PERIODS_UTILITY_PKG.Get_Periods_In_Base_Period(p_Period_Record.Base_Periodicity_Id);
504: l_Is_Daily_Periodicity := BSC_PERIODS_UTILITY_PKG.Is_Base_Periodicity_Daily(p_Period_Record.Base_Periodicity_Id);
505: END IF;
506:
507:
508: IF(p_Action <> BSC_PERIODS_UTILITY_PKG.C_DELETE ) THEN

Line 508: IF(p_Action <> BSC_PERIODS_UTILITY_PKG.C_DELETE ) THEN

504: l_Is_Daily_Periodicity := BSC_PERIODS_UTILITY_PKG.Is_Base_Periodicity_Daily(p_Period_Record.Base_Periodicity_Id);
505: END IF;
506:
507:
508: IF(p_Action <> BSC_PERIODS_UTILITY_PKG.C_DELETE ) THEN
509: IF((NOT l_Is_Daily_Periodicity) AND (p_Period_Record.Base_Periodicity_Id IS NOT NULL)) THEN
510: IF(x_Start_Period <> 1 OR x_End_Period <> l_No_Base_Periods) THEN
511: FND_MESSAGE.SET_NAME('BSC','BSC_WRONG_PERIODS');
512: FND_MSG_PUB.ADD;

Line 600: l_Period_DB_Col := BSC_PERIODS_UTILITY_PKG.Get_Periodicity_Db_Col(p_Periodicity_Id);

596: x_Periodicity_View_Name := Get_Valid_Period_View_Name(p_Short_Name);
597:
598: --dbms_output.put_line('BEFORE PREPARING SQL TEXT ');
599:
600: l_Period_DB_Col := BSC_PERIODS_UTILITY_PKG.Get_Periodicity_Db_Col(p_Periodicity_Id);
601:
602: /*l_Sql_Stmt := ' CREATE OR REPLACE VIEW ' || x_Periodicity_View_Name||'(ID,VALUE,START_DATE,END_DATE) AS '||
603: ' SELECT BP.PERIOD_ID, BP.NAME, ' ||
604: ' BSC_PERIODS_UTILITY_PKG.Get_Start_Period_Date(BC.CALENDAR_ID, BP.PERIODICITY_ID, BP.PERIOD_ID, BP.YEAR), ' ||

Line 604: ' BSC_PERIODS_UTILITY_PKG.Get_Start_Period_Date(BC.CALENDAR_ID, BP.PERIODICITY_ID, BP.PERIOD_ID, BP.YEAR), ' ||

600: l_Period_DB_Col := BSC_PERIODS_UTILITY_PKG.Get_Periodicity_Db_Col(p_Periodicity_Id);
601:
602: /*l_Sql_Stmt := ' CREATE OR REPLACE VIEW ' || x_Periodicity_View_Name||'(ID,VALUE,START_DATE,END_DATE) AS '||
603: ' SELECT BP.PERIOD_ID, BP.NAME, ' ||
604: ' BSC_PERIODS_UTILITY_PKG.Get_Start_Period_Date(BC.CALENDAR_ID, BP.PERIODICITY_ID, BP.PERIOD_ID, BP.YEAR), ' ||
605: ' BSC_PERIODS_UTILITY_PKG.Get_End_Period_Date(BC.CALENDAR_ID, BP.PERIODICITY_ID, BP.PERIOD_ID, BP.YEAR) ' ||
606: ' FROM BSC_SYS_PERIODS_VL BP, BSC_SYS_CALENDARS_B BC ' ||
607: ' WHERE BP.PERIODICITY_ID = ' || p_Periodicity_Id ||
608: ' AND BC.CALENDAR_ID = ' || p_Calendar_Id ||

Line 605: ' BSC_PERIODS_UTILITY_PKG.Get_End_Period_Date(BC.CALENDAR_ID, BP.PERIODICITY_ID, BP.PERIOD_ID, BP.YEAR) ' ||

601:
602: /*l_Sql_Stmt := ' CREATE OR REPLACE VIEW ' || x_Periodicity_View_Name||'(ID,VALUE,START_DATE,END_DATE) AS '||
603: ' SELECT BP.PERIOD_ID, BP.NAME, ' ||
604: ' BSC_PERIODS_UTILITY_PKG.Get_Start_Period_Date(BC.CALENDAR_ID, BP.PERIODICITY_ID, BP.PERIOD_ID, BP.YEAR), ' ||
605: ' BSC_PERIODS_UTILITY_PKG.Get_End_Period_Date(BC.CALENDAR_ID, BP.PERIODICITY_ID, BP.PERIOD_ID, BP.YEAR) ' ||
606: ' FROM BSC_SYS_PERIODS_VL BP, BSC_SYS_CALENDARS_B BC ' ||
607: ' WHERE BP.PERIODICITY_ID = ' || p_Periodicity_Id ||
608: ' AND BC.CALENDAR_ID = ' || p_Calendar_Id ||
609: ' ORDER BY BP.PERIOD_ID, BP.MONTH '; */

Line 619: IF (l_Period_DB_Col = BSC_PERIODS_UTILITY_PKG.C_YEAR_COLUMN) THEN

615:
616: IF((p_periodicity_Type IS NULL AND l_Period_DB_Col IS NOT NULL) OR (p_periodicity_Type IS NOT NULL AND (
617: p_periodicity_Type NOT IN
618: (BSC_PERIODS_PUB.C_MONTH_DAY,BSC_PERIODS_PUB.C_MONTH_WEEK)))) THEN
619: IF (l_Period_DB_Col = BSC_PERIODS_UTILITY_PKG.C_YEAR_COLUMN) THEN
620: l_Sql_Stmt := ' CREATE OR REPLACE VIEW ' || x_Periodicity_View_Name||'(ID,VALUE,START_DATE,END_DATE) AS '||
621: ' SELECT C.YEAR,C.YEAR, ' ||
622: ' MIN(TO_DATE(C.CALENDAR_YEAR||''-''||C.CALENDAR_MONTH||''-''||C.CALENDAR_DAY, ''YYYY-MM-DD'')) START_DATE, ' ||
623: ' MAX(TO_DATE(C.CALENDAR_YEAR||''-''||C.CALENDAR_MONTH||''-''||C.CALENDAR_DAY, ''YYYY-MM-DD'')) END_DATE ' ||

Line 716: IF(BSC_PERIODS_UTILITY_PKG.Is_Base_Periodicity_Daily(TO_NUMBER(l_Source))) THEN

712: FOR Cst IN c_Source_Type LOOP
713: l_Source := Cst.SOURCE;
714: END LOOP;
715:
716: IF(BSC_PERIODS_UTILITY_PKG.Is_Base_Periodicity_Daily(TO_NUMBER(l_Source))) THEN
717: FOR Cdpl IN c_Daily_Periods_List LOOP
718: IF (l_Comma_List IS NULL) THEN
719: l_Comma_List := TO_CHAR(Cdpl.START_DATE, 'MM/DD/YY') ||',' ||TO_CHAR(Cdpl.END_DATE, 'MM/DD/YY');
720: ELSE