[Home] [Help]
97: DECODE( p_invited_by_partner_id, FND_API.G_MISS_NUM, NULL, p_invited_by_partner_id),
98: DECODE( p_trxn_extension_id, FND_API.G_MISS_NUM, NULL, p_trxn_extension_id)
99: );
100:
101: INSERT INTO pv_pg_invite_headers_tl(
102: invite_header_id ,
103: language ,
104: last_update_date ,
105: last_updated_by ,
120: USERENV('LANG'),
121: DECODE( p_EMAIL_CONTENT , FND_API.G_MISS_CHAR, NULL, p_EMAIL_CONTENT)
122: FROM fnd_languages l
123: WHERE l.installed_flag IN ('I','B')
124: AND NOT EXISTS(SELECT NULL FROM pv_pg_invite_headers_tl t
125: WHERE t.invite_header_id = DECODE( px_invite_header_id, FND_API.G_MISS_NUM, NULL, px_invite_header_id)
126: AND t.language = l.language_code);
127: END Insert_Row;
128:
177: trxn_extension_id = DECODE( p_trxn_extension_id, null, trxn_extension_id, FND_API.G_MISS_NUM, null, p_trxn_extension_id)
178: WHERE invite_header_id = p_invite_header_id
179: AND object_version_number = p_object_version_number;
180:
181: UPDATE pv_pg_invite_headers_tl
182: set EMAIL_CONTENT = DECODE( p_EMAIL_CONTENT, null, EMAIL_CONTENT, FND_API.g_miss_char, null, p_EMAIL_CONTENT),
183: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
184: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
185: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
280: IS
281: BEGIN
282: -- changing by ktsao as per performance team guidelines to fix performance issue
283: -- as described in bug 3723612 (*** RTIKKU 03/24/05 12:46pm ***)
284: INSERT /*+ append parallel(tt) */ INTO pv_pg_invite_headers_tl tt (
285: INVITE_HEADER_ID,
286: creation_date,
287: created_by,
288: last_update_date,
302: b.last_update_login,
303: b.email_content,
304: l.language_code,
305: b.source_lang
306: FROM pv_pg_invite_headers_tl B ,
307: FND_LANGUAGES L
308: WHERE L.INSTALLED_FLAG IN ( 'I','B' )
309: AND B.LANGUAGE = USERENV ( 'LANG' )
310: ) v, pv_pg_invite_headers_tl t
306: FROM pv_pg_invite_headers_tl B ,
307: FND_LANGUAGES L
308: WHERE L.INSTALLED_FLAG IN ( 'I','B' )
309: AND B.LANGUAGE = USERENV ( 'LANG' )
310: ) v, pv_pg_invite_headers_tl t
311: WHERE t.INVITE_HEADER_ID(+) = v.INVITE_HEADER_ID
312: AND t.language(+) = v.language_code
313: AND t.INVITE_HEADER_ID IS NULL;
314: