APPS.M4R_OM_CONF_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 89

            SELECT party_id
            INTO l_party_id
            FROM hz_party_sites
            WHERE party_site_id = l_party_site_id;

Line: 217

       select standard_code
       into l_standard_code
       from ecx_tp_details_v
       where tp_header_id = (select tp_header_id from ecx_tp_headers
                             where party_id = l_party_id and
                             party_site_id = l_party_site_id) and
       transaction_type ='ONT' and transaction_subtype = 'POA';

Line: 256

   FUNCTION UPDATE_CH_OM_EVENT_SUB(
        p_subscription_guid             IN RAW,
        p_event                         IN OUT NOCOPY WF_EVENT_T
   ) RETURN VARCHAR2
   IS
      l_evt_parameters                  wf_parameter_list_t;

Line: 271

              cln_debug_pub.Add('==========ENTERING UPDATE_CH_OM_EVENT_SUB===========', 2);

Line: 308

			SELECT standard_code
			into l_standard
			FROM ecx_tp_details_v
			WHERE tp_header_id = (SELECT tp_header_id FROM ecx_tp_headers
								WHERE party_id = l_tr_partner_id
								AND party_site_id = l_tr_partner_site
								AND party_type = 'C')
			  AND transaction_type ='ONT'
			  AND transaction_subtype = 'POA';

Line: 328

			      cln_debug_pub.Add('==========EXITING UPDATE_CH_OM_EVENT_SUB WITHOUT UPDATING COLLABORATION HISTORY ===========', 2);

Line: 338

              cln_debug_pub.Add('==========EXITING UPDATE_CH_OM_EVENT_SUB===========', 2);