DBA Data[Home] [Help]

APPS.M4U_PARTY_QUERY dependencies on CLN_COLLABORATION_MSG_ID_S

Line 545: SELECT cln_collaboration_msg_id_s.nextval INTO l_event_key FROM dual ;

541:
542: /* NO PROCESSING/UPDATE DEFINED */
543:
544: --create unique key for each event using CLN sequence
545: SELECT cln_collaboration_msg_id_s.nextval INTO l_event_key FROM dual ;
546:
547: l_dtl_msg := 'GLN - ' || p_org_gln || ', Name - ' || p_org_name || ', Type - ' || p_org_type;
548: l_dtl_msg := l_dtl_msg || ', Contact - ' || p_contact || ' , Status - ' || p_org_status || ', Role - ' || p_role;
549: l_dtl_msg := l_dtl_msg || ', Address - ' || p_addr1 || ', ' || p_addr2 || ', '|| p_city || ', ' || p_state || ', ' || p_zip || ', ' || p_country_code;