APPS.PV_PARTNER_PROGRAM_PKG dependencies on PV_PARTNER_PROGRAM_TL

Line 231: INSERT INTO PV_PARTNER_PROGRAM_TL(

227: ,DECODE( p_last_update_login, NULL, p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)
228: ,DECODE( p_object_version_number,NULL, p_object_version_number, FND_API.g_miss_num, NULL, p_object_version_number)
229: );
230:
231: INSERT INTO PV_PARTNER_PROGRAM_TL(
232: program_id
233: ,last_update_date
234: ,last_updated_by
235: ,creation_date

Line 266: FROM PV_PARTNER_PROGRAM_TL t

262: FROM FND_LANGUAGES l
263: WHERE l.installed_flag in ('I', 'B')
264: AND NOT EXISTS(
265: SELECT NULL
266: FROM PV_PARTNER_PROGRAM_TL t
267: --WHERE t.program_id = DECODE( px_program_id, FND_API.g_miss_num, NULL, px_program_id)
268: WHERE t.program_id = DECODE( px_program_id, NULL, px_program_id, FND_API.g_miss_num, NULL, px_program_id)
269: AND t.language = l.language_code );
270:

Line 428: Update PV_PARTNER_PROGRAM_TL

424: END IF;
425: RAISE FND_API.g_exc_error;
426: END IF;
427:
428: Update PV_PARTNER_PROGRAM_TL
429: SET
430: last_update_date = SYSDATE
431: ,last_updated_by = FND_GLOBAL.user_id
432: ,last_update_login = FND_GLOBAL.conc_login_id

Line 496: Update PV_PARTNER_PROGRAM_TL

492: END IF;
493: RAISE FND_API.g_exc_error;
494: END IF;
495:
496: Update PV_PARTNER_PROGRAM_TL
497: SET
498: last_update_date = SYSDATE
499: ,last_updated_by = FND_GLOBAL.user_id
500: ,last_update_login = FND_GLOBAL.conc_login_id

Line 787: INSERT /*+ append parallel(tt) */ INTO PV_PARTNER_PROGRAM_TL tt

783: IS
784: BEGIN
785: -- changing by pukken as per performance team guidelines to fix performance issue
786: -- as described in bug 3723612 (*** RTIKKU 03/24/05 12:46pm ***)
787: INSERT /*+ append parallel(tt) */ INTO PV_PARTNER_PROGRAM_TL tt
788: (
789: PROGRAM_ID
790: ,LAST_UPDATE_DATE
791: ,LAST_UPDATED_BY

Line 814: FROM PV_PARTNER_PROGRAM_TL B , FND_LANGUAGES L

810: ,L.LANGUAGE_CODE
811: ,B.SOURCE_LANG
812: ,B.PROGRAM_NAME
813: ,B.PROGRAM_DESCRIPTION
814: FROM PV_PARTNER_PROGRAM_TL B , FND_LANGUAGES L
815: WHERE L.INSTALLED_FLAG IN ( 'I','B' ) AND B.LANGUAGE = USERENV ( 'LANG' )
816: ) v
817: , PV_PARTNER_PROGRAM_TL t
818: WHERE t.PROGRAM_ID(+) = v.PROGRAM_ID

Line 817: , PV_PARTNER_PROGRAM_TL t

813: ,B.PROGRAM_DESCRIPTION
814: FROM PV_PARTNER_PROGRAM_TL B , FND_LANGUAGES L
815: WHERE L.INSTALLED_FLAG IN ( 'I','B' ) AND B.LANGUAGE = USERENV ( 'LANG' )
816: ) v
817: , PV_PARTNER_PROGRAM_TL t
818: WHERE t.PROGRAM_ID(+) = v.PROGRAM_ID
819: AND t.language(+) = v.language_code
820: AND t.PROGRAM_ID IS NULL ;
821:

Line 853: UPDATE PV_PARTNER_PROGRAM_TL set

849:
850: IS
851:
852: BEGIN
853: UPDATE PV_PARTNER_PROGRAM_TL set
854: PROGRAM_NAME = NVL(p_program_name, program_name)
855: ,PROGRAM_DESCRIPTION = NVL(p_program_description, program_description)
856: ,SOURCE_LANG = USERENV('LANG')
857: ,LAST_UPDATE_DATE = SYSDATE