eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.M4U_PARTY_QUERY dependencies on DUAL

Line 13: -- supplied as input to each individual parameter.

9: -- parse_param_list
10: -- Purpose
11: -- This procedure is called from the map m4u_230_party_qry_out.xgm
12: -- The purpose of this procedure is to parse the parameter list
13: -- supplied as input to each individual parameter.
14: -- This is used becuase multiple optional parameters to the XGM are passed
15: -- as a single Delimitor Separated Value list, since the ECXSTD/GETTPXML
16: -- activity used in the workflow does allows us to specify only 5 paramters
17: -- to the XGM

Line 227: FROM dual;

223:
224: -- obtain a unique event-id
225: SELECT m4u_wlqid_s.NEXTVAL
226: INTO l_event_key
227: FROM dual;
228:
229: l_event_key := 'M4U_QRYPT_' || l_event_key;
230:
231: -- pass Concurrent program parameters as event parameters,

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;