DBA Data[Home] [Help]

APPS.OKS_CUSTOMER_ACCEPTANCE_PVT dependencies on FND_NEW_MESSAGES

Line 275: FROM fnd_new_messages

271: AND r.chr_id = p_chr_id;
272:
273: CURSOR csr_customer_token_exists IS
274: SELECT 'Y'
275: FROM fnd_new_messages
276: WHERE message_name = 'OKS_CUST_ACCEPT_CLAUSE'
277: AND language_code = USERENV ('LANG')
278: AND regexp_like (MESSAGE_TEXT,
279: 'CUSTOMER_NAME',

Line 285: FROM fnd_new_messages

281: );
282:
283: CURSOR csr_vendor_token_exists IS
284: SELECT 'Y'
285: FROM fnd_new_messages
286: WHERE message_name = 'OKS_CUST_ACCEPT_CLAUSE'
287: AND language_code = USERENV ('LANG')
288: AND regexp_like (MESSAGE_TEXT,
289: 'VENDOR_NAME',

Line 426: FROM fnd_new_messages

422: AND r.chr_id = p_chr_id;
423:
424: CURSOR csr_customer_token_exists IS
425: SELECT 'Y'
426: FROM fnd_new_messages
427: WHERE message_name = 'OKS_CUST_DECLINE_CLAUSE'
428: AND language_code = USERENV ('LANG')
429: AND regexp_like (MESSAGE_TEXT,
430: 'CUSTOMER_NAME',

Line 436: FROM fnd_new_messages

432: );
433:
434: CURSOR csr_vendor_token_exists IS
435: SELECT 'Y'
436: FROM fnd_new_messages
437: WHERE message_name = 'OKS_CUST_DECLINE_CLAUSE'
438: AND language_code = USERENV ('LANG')
439: AND regexp_like (MESSAGE_TEXT,
440: 'VENDOR_NAME',