APPS.PV_PARTNER_PGM_TYPE_PKG dependencies on PV_PARTNER_PROGRAM_TYPE_TL

Line 83: INSERT INTO PV_PARTNER_PROGRAM_TYPE_TL(

79: ,DECODE( p_last_update_login, NULL, p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)
80: );
81:
82:
83: INSERT INTO PV_PARTNER_PROGRAM_TYPE_TL(
84: PROGRAM_TYPE_ID
85: ,creation_date
86: ,created_by
87: ,last_update_date

Line 110: FROM PV_PARTNER_PROGRAM_TYPE_TL t

106: FROM FND_LANGUAGES l
107: WHERE l.installed_flag IN ('I','B')
108: AND NOT EXISTS(
109: SELECT NULL
110: FROM PV_PARTNER_PROGRAM_TYPE_TL t
111: WHERE t.PROGRAM_TYPE_ID = DECODE( px_PROGRAM_TYPE_ID, NULL, px_PROGRAM_TYPE_ID, FND_API.g_miss_num, NULL, px_PROGRAM_TYPE_ID)
112: AND t.language = l.language_code
113: );
114:

Line 180: UPDATE PV_PARTNER_PROGRAM_TYPE_TL

176: END IF;
177: RAISE FND_API.g_exc_error;
178: END IF;
179:
180: UPDATE PV_PARTNER_PROGRAM_TYPE_TL
181: SET
182: last_update_date = SYSDATE
183: ,last_updated_by = FND_GLOBAL.user_id
184: ,last_update_login = FND_GLOBAL.conc_login_id

Line 222: DELETE FROM PV_PARTNER_PROGRAM_TYPE_TL

218: )
219: IS
220: BEGIN
221:
222: DELETE FROM PV_PARTNER_PROGRAM_TYPE_TL
223: WHERE PROGRAM_TYPE_ID = p_PROGRAM_TYPE_ID;
224:
225: IF (SQL%NOTFOUND) THEN
226: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 346: INSERT /*+ append parallel(tt) */ INTO PV_PARTNER_PROGRAM_TYPE_TL tt (

342: IS
343: BEGIN
344: -- changing by ktsao as per performance team guidelines to fix performance issue
345: -- as described in bug 3723612 (*** RTIKKU 03/24/05 12:46pm ***)
346: INSERT /*+ append parallel(tt) */ INTO PV_PARTNER_PROGRAM_TYPE_TL tt (
347: PROGRAM_TYPE_ID
348: ,LAST_UPDATE_DATE
349: ,LAST_UPDATED_BY
350: ,CREATION_DATE

Line 371: FROM PV_PARTNER_PROGRAM_TYPE_TL B ,

367: ,B.SOURCE_LANG
368: ,B.PROGRAM_TYPE_NAME
369: ,B.PROGRAM_TYPE_DESCRIPTION
370:
371: FROM PV_PARTNER_PROGRAM_TYPE_TL B ,
372: FND_LANGUAGES L
373: WHERE L.INSTALLED_FLAG IN ( 'I','B' )
374: AND B.LANGUAGE = USERENV ( 'LANG' )
375: ) v, PV_PARTNER_PROGRAM_TYPE_TL t

Line 375: ) v, PV_PARTNER_PROGRAM_TYPE_TL t

371: FROM PV_PARTNER_PROGRAM_TYPE_TL B ,
372: FND_LANGUAGES L
373: WHERE L.INSTALLED_FLAG IN ( 'I','B' )
374: AND B.LANGUAGE = USERENV ( 'LANG' )
375: ) v, PV_PARTNER_PROGRAM_TYPE_TL t
376: WHERE t.PROGRAM_TYPE_ID(+) = v.PROGRAM_TYPE_ID
377: AND t.language(+) = v.language_code
378: AND t.PROGRAM_TYPE_ID IS NULL;
379:

Line 407: UPDATE PV_PARTNER_PROGRAM_TYPE_TL SET

403:
404: IS
405:
406: BEGIN
407: UPDATE PV_PARTNER_PROGRAM_TYPE_TL SET
408: PROGRAM_TYPE_NAME = NVL(p_program_type_name, program_type_name)
409: ,PROGRAM_TYPE_DESCRIPTION = NVL(p_program_type_description, program_type_description)
410: ,SOURCE_LANG = USERENV('LANG')
411: ,LAST_UPDATE_DATE = SYSDATE