APPS.BSC_SYS_PERIODS_PKG dependencies on BSC_SYS_PERIODS_TL

Line 12: cursor C is select ROWID from BSC_SYS_PERIODS_TL

8: X_MONTH in NUMBER,
9: X_NAME in VARCHAR2,
10: X_SHORT_NAME in VARCHAR2
11: ) is
12: cursor C is select ROWID from BSC_SYS_PERIODS_TL
13: where YEAR = X_YEAR
14: and PERIODICITY_ID = X_PERIODICITY_ID
15: and PERIOD_ID = X_PERIOD_ID
16: and MONTH = X_MONTH

Line 20: insert into BSC_SYS_PERIODS_TL (

16: and MONTH = X_MONTH
17: and LANGUAGE = userenv('LANG')
18: ;
19: begin
20: insert into BSC_SYS_PERIODS_TL (
21: YEAR,
22: PERIODICITY_ID,
23: PERIOD_ID,
24: MONTH,

Line 42: from BSC_SYS_PERIODS_TL T

38: from FND_LANGUAGES L
39: where L.INSTALLED_FLAG in ('I', 'B')
40: and not exists
41: (select NULL
42: from BSC_SYS_PERIODS_TL T
43: where T.YEAR = X_YEAR
44: and T.PERIODICITY_ID = X_PERIODICITY_ID
45: and T.PERIOD_ID = X_PERIOD_ID
46: and T.MONTH = X_MONTH

Line 71: from BSC_SYS_PERIODS_TL

67: cursor c1 is select
68: NAME,
69: SHORT_NAME,
70: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
71: from BSC_SYS_PERIODS_TL
72: where YEAR = X_YEAR
73: and PERIODICITY_ID = X_PERIODICITY_ID
74: and PERIOD_ID = X_PERIOD_ID
75: and MONTH = X_MONTH

Line 105: update BSC_SYS_PERIODS_TL set

101: X_NAME in VARCHAR2,
102: X_SHORT_NAME in VARCHAR2
103: ) is
104: begin
105: update BSC_SYS_PERIODS_TL set
106: NAME = X_NAME,
107: SHORT_NAME = X_SHORT_NAME,
108: SOURCE_LANG = userenv('LANG')
109: where YEAR = X_YEAR

Line 127: delete from BSC_SYS_PERIODS_TL

123: X_PERIOD_ID in NUMBER,
124: X_MONTH in NUMBER
125: ) is
126: begin
127: delete from BSC_SYS_PERIODS_TL
128: where YEAR = X_YEAR
129: and PERIODICITY_ID = X_PERIODICITY_ID
130: and PERIOD_ID = X_PERIOD_ID
131: and MONTH = X_MONTH;

Line 142: update BSC_SYS_PERIODS_TL T set (

138:
139: procedure ADD_LANGUAGE
140: is
141: begin
142: update BSC_SYS_PERIODS_TL T set (
143: NAME,
144: SHORT_NAME
145: ) = (select
146: B.NAME,

Line 148: from BSC_SYS_PERIODS_TL B

144: SHORT_NAME
145: ) = (select
146: B.NAME,
147: B.SHORT_NAME
148: from BSC_SYS_PERIODS_TL B
149: where B.YEAR = T.YEAR
150: and B.PERIODICITY_ID = T.PERIODICITY_ID
151: and B.PERIOD_ID = T.PERIOD_ID
152: and B.MONTH = T.MONTH

Line 166: from BSC_SYS_PERIODS_TL SUBB, BSC_SYS_PERIODS_TL SUBT

162: SUBT.PERIODICITY_ID,
163: SUBT.PERIOD_ID,
164: SUBT.MONTH,
165: SUBT.LANGUAGE
166: from BSC_SYS_PERIODS_TL SUBB, BSC_SYS_PERIODS_TL SUBT
167: where SUBB.YEAR = SUBT.YEAR
168: and SUBB.PERIODICITY_ID = SUBT.PERIODICITY_ID
169: and SUBB.PERIOD_ID = SUBT.PERIOD_ID
170: and SUBB.MONTH = SUBT.MONTH

Line 180: insert into BSC_SYS_PERIODS_TL (

176: or (SUBB.SHORT_NAME is null and SUBT.SHORT_NAME is not null)
177: or (SUBB.SHORT_NAME is not null and SUBT.SHORT_NAME is null)
178: ));
179:
180: insert into BSC_SYS_PERIODS_TL (
181: YEAR,
182: PERIODICITY_ID,
183: PERIOD_ID,
184: MONTH,

Line 198: from BSC_SYS_PERIODS_TL B, FND_LANGUAGES L

194: B.NAME,
195: B.SHORT_NAME,
196: L.LANGUAGE_CODE,
197: B.SOURCE_LANG
198: from BSC_SYS_PERIODS_TL B, FND_LANGUAGES L
199: where L.INSTALLED_FLAG in ('I', 'B')
200: and B.LANGUAGE = userenv('LANG')
201: and not exists
202: (select NULL

Line 203: from BSC_SYS_PERIODS_TL T

199: where L.INSTALLED_FLAG in ('I', 'B')
200: and B.LANGUAGE = userenv('LANG')
201: and not exists
202: (select NULL
203: from BSC_SYS_PERIODS_TL T
204: where T.YEAR = B.YEAR
205: and T.PERIODICITY_ID = B.PERIODICITY_ID
206: and T.PERIOD_ID = B.PERIOD_ID
207: and T.MONTH = B.MONTH