APPS.BSC_SYS_PERIODICITIES_PKG dependencies on BSC_SYS_PERIODICITIES_TL

Line 13: cursor C is select ROWID from BSC_SYS_PERIODICITIES_TL

9: X_LAST_UPDATE_DATE in DATE,
10: X_LAST_UPDATED_BY in NUMBER,
11: X_LAST_UPDATE_LOGIN in NUMBER
12: ) is
13: cursor C is select ROWID from BSC_SYS_PERIODICITIES_TL
14: where PERIODICITY_ID = X_PERIODICITY_ID
15: and LANGUAGE = userenv('LANG')
16: ;
17: begin

Line 18: insert into BSC_SYS_PERIODICITIES_TL (

14: where PERIODICITY_ID = X_PERIODICITY_ID
15: and LANGUAGE = userenv('LANG')
16: ;
17: begin
18: insert into BSC_SYS_PERIODICITIES_TL (
19: PERIODICITY_ID,
20: NAME,
21: CREATION_DATE ,
22: CREATED_BY,

Line 42: from BSC_SYS_PERIODICITIES_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_PERIODICITIES_TL T
43: where T.PERIODICITY_ID = X_PERIODICITY_ID
44: and T.LANGUAGE = L.LANGUAGE_CODE);
45:
46: open c;

Line 63: from BSC_SYS_PERIODICITIES_TL

59: ) is
60: cursor c1 is select
61: NAME,
62: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
63: from BSC_SYS_PERIODICITIES_TL
64: where PERIODICITY_ID = X_PERIODICITY_ID
65: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
66: for update of PERIODICITY_ID nowait;
67: begin

Line 92: update BSC_SYS_PERIODICITIES_TL set

88: X_LAST_UPDATED_BY in NUMBER,
89: X_LAST_UPDATE_LOGIN in NUMBER
90: ) is
91: begin
92: update BSC_SYS_PERIODICITIES_TL set
93: NAME = X_NAME,
94: LAST_UPDATE_DATE = DECODE(LAST_UPDATED_BY,1,X_LAST_UPDATE_DATE,LAST_UPDATE_DATE),
95: LAST_UPDATED_BY = DECODE(LAST_UPDATED_BY,1,X_LAST_UPDATED_BY,LAST_UPDATED_BY),
96: LAST_UPDATE_LOGIN = DECODE(LAST_UPDATED_BY,1,X_LAST_UPDATE_LOGIN,LAST_UPDATE_LOGIN),

Line 110: delete from BSC_SYS_PERIODICITIES_TL

106: procedure DELETE_ROW (
107: X_PERIODICITY_ID in NUMBER
108: ) is
109: begin
110: delete from BSC_SYS_PERIODICITIES_TL
111: where PERIODICITY_ID = X_PERIODICITY_ID;
112:
113: if (sql%notfound) then
114: raise no_data_found;

Line 129: update BSC_SYS_PERIODICITIES_TL T set (

125: -- row and it will fail. AUDSID is not PK. After meeting with
126: -- Vinod and Kris and Venu, we should use FNG_GLOBAL.user_id
127: l_user := BSC_APPS.fnd_global_user_id;
128:
129: update BSC_SYS_PERIODICITIES_TL T set (
130: NAME
131: ) = (select
132: B.NAME
133: from BSC_SYS_PERIODICITIES_TL B

Line 133: from BSC_SYS_PERIODICITIES_TL B

129: update BSC_SYS_PERIODICITIES_TL T set (
130: NAME
131: ) = (select
132: B.NAME
133: from BSC_SYS_PERIODICITIES_TL B
134: where B.PERIODICITY_ID = T.PERIODICITY_ID
135: and B.LANGUAGE = T.SOURCE_LANG)
136: where (
137: T.PERIODICITY_ID,

Line 142: from BSC_SYS_PERIODICITIES_TL SUBB, BSC_SYS_PERIODICITIES_TL SUBT

138: T.LANGUAGE
139: ) in (select
140: SUBT.PERIODICITY_ID,
141: SUBT.LANGUAGE
142: from BSC_SYS_PERIODICITIES_TL SUBB, BSC_SYS_PERIODICITIES_TL SUBT
143: where SUBB.PERIODICITY_ID = SUBT.PERIODICITY_ID
144: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
145: and (SUBB.NAME <> SUBT.NAME
146: ));

Line 148: insert into BSC_SYS_PERIODICITIES_TL (

144: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
145: and (SUBB.NAME <> SUBT.NAME
146: ));
147:
148: insert into BSC_SYS_PERIODICITIES_TL (
149: PERIODICITY_ID,
150: NAME,
151: CREATION_DATE ,
152: CREATED_BY,

Line 168: from BSC_SYS_PERIODICITIES_TL B, FND_LANGUAGES L

164: l_user,
165: l_user,
166: L.LANGUAGE_CODE,
167: B.SOURCE_LANG
168: from BSC_SYS_PERIODICITIES_TL B, FND_LANGUAGES L
169: where L.INSTALLED_FLAG in ('I', 'B')
170: and B.LANGUAGE = userenv('LANG')
171: and not exists
172: (select NULL

Line 173: from BSC_SYS_PERIODICITIES_TL T

169: where L.INSTALLED_FLAG in ('I', 'B')
170: and B.LANGUAGE = userenv('LANG')
171: and not exists
172: (select NULL
173: from BSC_SYS_PERIODICITIES_TL T
174: where T.PERIODICITY_ID = B.PERIODICITY_ID
175: and T.LANGUAGE = L.LANGUAGE_CODE);
176: end ADD_LANGUAGE;
177: