APPS.BSC_PERIODICITIES_PVT dependencies on BSC_SYS_PERIODICITIES

Line 50: INSERT INTO BSC_SYS_PERIODICITIES (

46: please refer to the public and wrapper layeres
47: */
48:
49: -- Insert into Periodicity base tables
50: INSERT INTO BSC_SYS_PERIODICITIES (
51: PERIODICITY_ID
52: , NUM_OF_PERIODS
53: , SOURCE
54: , NUM_OF_SUBPERIODS

Line 89: INSERT INTO BSC_SYS_PERIODICITIES_TL (

85: , l_Periodicities_Rec_Type.Short_Name
86: );
87:
88: -- Insert into Periodicity transalatable tables
89: INSERT INTO BSC_SYS_PERIODICITIES_TL (
90: PERIODICITY_ID
91: , LANGUAGE
92: , SOURCE_LANG
93: , NAME

Line 115: FROM BSC_SYS_PERIODICITIES_TL T

111: WHERE L.INSTALLED_FLAG IN ('I', 'B')
112: AND NOT EXISTS
113: (
114: SELECT NULL
115: FROM BSC_SYS_PERIODICITIES_TL T
116: WHERE T.PERIODICITY_ID = l_Periodicities_Rec_Type.Periodicity_Id
117: AND T.LANGUAGE = L.LANGUAGE_CODE
118: );
119:

Line 199: BSC_SYS_PERIODICITIES B

195: , TL.LAST_UPDATED_BY
196: , TL.LAST_UPDATE_DATE
197: , TL.LAST_UPDATE_LOGIN
198: FROM
199: BSC_SYS_PERIODICITIES B
200: , BSC_SYS_PERIODICITIES_TL TL
201: WHERE
202: B.PERIODICITY_ID = p_Periodicities_Rec_Type.Periodicity_Id
203: AND TL.PERIODICITY_ID = B.PERIODICITY_ID

Line 200: , BSC_SYS_PERIODICITIES_TL TL

196: , TL.LAST_UPDATE_DATE
197: , TL.LAST_UPDATE_LOGIN
198: FROM
199: BSC_SYS_PERIODICITIES B
200: , BSC_SYS_PERIODICITIES_TL TL
201: WHERE
202: B.PERIODICITY_ID = p_Periodicities_Rec_Type.Periodicity_Id
203: AND TL.PERIODICITY_ID = B.PERIODICITY_ID
204: AND TL.LANGUAGE = USERENV('LANG');

Line 285: l_Base_Periodicity_Source BSC_SYS_PERIODICITIES.SOURCE%TYPE;

281: ,x_Msg_Count OUT NOCOPY NUMBER
282: ,x_Msg_Data OUT NOCOPY VARCHAR2
283: ) IS
284: l_Periodicities_Rec_Type BSC_PERIODICITIES_PUB.Periodicities_Rec_Type;
285: l_Base_Periodicity_Source BSC_SYS_PERIODICITIES.SOURCE%TYPE;
286:
287: BEGIN
288: SAVEPOINT UpdatePeriodicityPVT;
289: FND_MSG_PUB.Initialize;

Line 354: UPDATE bsc_sys_periodicities b

350:
351: --BSC_PERIODS_UTILITY_PKG.Print_Period_Metadata ('Update_Periodicity 1', l_Periodicities_Rec_Type);
352:
353:
354: UPDATE bsc_sys_periodicities b
355: SET b.num_of_periods = l_Periodicities_Rec_Type.Num_Of_Periods
356: ,b.source = l_Periodicities_Rec_Type.Source
357: ,b.custom_code = l_Periodicities_Rec_Type.Custom_Code
358: WHERE b.periodicity_id = l_Periodicities_Rec_Type.Periodicity_id;

Line 361: UPDATE bsc_sys_periodicities_tl t

357: ,b.custom_code = l_Periodicities_Rec_Type.Custom_Code
358: WHERE b.periodicity_id = l_Periodicities_Rec_Type.Periodicity_id;
359:
360:
361: UPDATE bsc_sys_periodicities_tl t
362: SET t.name = l_Periodicities_Rec_Type.Name
363: ,t.last_updated_by = l_Periodicities_Rec_Type.Last_Updated_By
364: ,t.last_update_date = l_Periodicities_Rec_Type.Last_Update_Date
365: ,t.last_update_login = l_Periodicities_Rec_Type.Last_Update_Login

Line 371: FROM bsc_sys_periodicities_vl

367: WHERE t.periodicity_id = l_Periodicities_Rec_Type.Periodicity_id
368: AND USERENV('LANG') IN (t.language, t.source_lang);
369:
370: SELECT name INTO l_Periodicities_Rec_Type.Name
371: FROM bsc_sys_periodicities_vl
372: WHERE periodicity_id = l_Periodicities_Rec_Type.Periodicity_id;
373: --dbms_output.PUT_LINE('Name - ' ||l_Periodicities_Rec_Type.Name);
374:
375:

Line 504: DELETE BSC_SYS_PERIODICITIES_TL

500:
501: DELETE BSC_SYS_PERIODS
502: WHERE PERIODICITY_ID = p_Periodicities_Rec_Type.Periodicity_Id;
503:
504: DELETE BSC_SYS_PERIODICITIES_TL
505: WHERE PERIODICITY_ID = p_Periodicities_Rec_Type.Periodicity_Id;
506:
507: DELETE BSC_SYS_PERIODICITIES
508: WHERE PERIODICITY_ID = p_Periodicities_Rec_Type.Periodicity_Id;

Line 507: DELETE BSC_SYS_PERIODICITIES

503:
504: DELETE BSC_SYS_PERIODICITIES_TL
505: WHERE PERIODICITY_ID = p_Periodicities_Rec_Type.Periodicity_Id;
506:
507: DELETE BSC_SYS_PERIODICITIES
508: WHERE PERIODICITY_ID = p_Periodicities_Rec_Type.Periodicity_Id;
509:
510: IF ((p_Commit IS NOT NULL) AND p_Commit = FND_API.G_TRUE) THEN
511: COMMIT;