APPS.PA_RP_DEFINITIONS_PKG dependencies on PA_RP_DEFINITIONS_TL

Line 12: -- Note : This API will make insert into PA_RP_DEFINITIONS_B and PA_RP_DEFINITIONS_TL table

8: -- Procedure : INSERT_ROW
9: -- Type : Table Handler
10: -- Purpose : This API will create new Reporting pack definition.
11:
12: -- Note : This API will make insert into PA_RP_DEFINITIONS_B and PA_RP_DEFINITIONS_TL table
13: PROCEDURE Insert_Row(
14: P_RP_ID IN NUMBER,
15: P_RP_NAME IN VARCHAR2,
16: P_EMAIL_TITLE IN VARCHAR2,

Line 58: Insert Into PA_RP_DEFINITIONS_TL(

54: Fnd_Global.User_Id ,
55: Fnd_Global.Login_Id );
56:
57: --MLS changes incorporated.
58: Insert Into PA_RP_DEFINITIONS_TL(
59: RP_ID ,
60: RP_NAME ,
61: EMAIL_TITLE ,
62: EMAIL_BODY ,

Line 91: PA_RP_DEFINITIONS_TL T

87: And Not Exists
88: (Select
89: Null
90: From
91: PA_RP_DEFINITIONS_TL T
92: WHere
93: T.RP_ID = RP_ID
94: And T.Language = L.Language_Code);
95:

Line 106: -- Note : This API will updates PA_RP_DEFINITIONS_B and PA_RP_DEFINITIONS_TL table

102:
103: -- Procedure : UPDATE_ROW
104: -- Type : Table Handler
105: -- Purpose : This API will be used to update Reporting pack definition.
106: -- Note : This API will updates PA_RP_DEFINITIONS_B and PA_RP_DEFINITIONS_TL table
107:
108: Procedure Update_Row(
109: P_RP_ID IN NUMBER,
110: P_RP_NAME IN VARCHAR2,

Line 140: Update PA_RP_DEFINITIONS_TL

136: Where
137: RP_ID = P_RP_ID;
138:
139: --MLS changes incorporated.
140: Update PA_RP_DEFINITIONS_TL
141: Set
142: RP_NAME = P_RP_NAME,
143: EMAIL_TITLE = P_EMAIL_TITLE,
144: EMAIL_BODY = P_EMAIL_BODY,

Line 163: delete from PA_RP_DEFINITIONS_TL T

159:
160: procedure ADD_LANGUAGE
161: is
162: begin
163: delete from PA_RP_DEFINITIONS_TL T
164: where not exists
165: (select NULL
166: from PA_RP_DEFINITIONS_B B
167: where B.RP_ID = T.RP_ID

Line 170: update PA_RP_DEFINITIONS_TL T set (

166: from PA_RP_DEFINITIONS_B B
167: where B.RP_ID = T.RP_ID
168: );
169:
170: update PA_RP_DEFINITIONS_TL T set (
171: RP_NAME,
172: DESCRIPTIONS
173: ) = (select
174: B.RP_NAME,

Line 176: from PA_RP_DEFINITIONS_TL b

172: DESCRIPTIONS
173: ) = (select
174: B.RP_NAME,
175: B.DESCRIPTIONS
176: from PA_RP_DEFINITIONS_TL b
177: where B.RP_ID = T.RP_ID
178: and B.LANGUAGE = T.SOURCE_LANG)
179: where (
180: T.RP_ID,

Line 185: from PA_RP_DEFINITIONS_TL SUBB, PA_RP_DEFINITIONS_TL SUBT

181: T.LANGUAGE
182: ) in (select
183: SUBT.RP_ID,
184: SUBT.LANGUAGE
185: from PA_RP_DEFINITIONS_TL SUBB, PA_RP_DEFINITIONS_TL SUBT
186: where SUBB.RP_ID = SUBT.RP_ID
187: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
188: and (SUBB.RP_NAME <> SUBT.RP_NAME
189: or SUBB.DESCRIPTIONS <> SUBT.DESCRIPTIONS

Line 194: insert into PA_RP_DEFINITIONS_TL (

190: or (SUBB.DESCRIPTIONS is null and SUBT.DESCRIPTIONS is not null)
191: or (SUBB.DESCRIPTIONS is not null and SUBT.DESCRIPTIONS is null)
192: ));
193:
194: insert into PA_RP_DEFINITIONS_TL (
195: RP_ID ,
196: RP_NAME ,
197: EMAIL_TITLE ,
198: EMAIL_BODY ,

Line 220: from PA_RP_DEFINITIONS_TL B, FND_LANGUAGES L

216: B.CREATED_BY ,
217: B.LAST_UPDATE_DATE ,
218: B.LAST_UPDATED_BY ,
219: B.LAST_UPDATE_LOGIN
220: from PA_RP_DEFINITIONS_TL B, FND_LANGUAGES L
221: where L.INSTALLED_FLAG in ('I', 'B')
222: and B.LANGUAGE = userenv('LANG')
223: and not exists
224: (select NULL

Line 225: from PA_RP_DEFINITIONS_TL T

221: where L.INSTALLED_FLAG in ('I', 'B')
222: and B.LANGUAGE = userenv('LANG')
223: and not exists
224: (select NULL
225: from PA_RP_DEFINITIONS_TL T
226: where T.RP_ID = B.RP_ID
227: and T.LANGUAGE = L.LANGUAGE_CODE);
228:
229: end ADD_LANGUAGE;