APPS.M4U_UCC_UTILS SQL Statements

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

Line: 71

           SELECT meaning INTO v_meaning
                FROM fnd_lookups
                WHERE lookup_type = p_lookup_type
                AND   lookup_code = p_lookup_code
                AND   ROWNUM =1 ;

Line: 577

                        select length(p_attr_value) into l_attr_len from dual;

Line: 587

                        select to_number(p_attr_value,'9999999999999') into l_attr_value from dual;

Line: 611

                        select length(p_attr_value) into l_attr_len from dual;

Line: 623

                        select to_number(p_attr_value,'99999999999999') into l_attr_value from dual;

Line: 651

                        select length(p_attr_value) into l_attr_len from dual;

Line: 698

                SELECT          to_char(e.party_id), to_char(e.party_site_id)
                INTO            g_party_id,          g_party_site_id
                FROM            hr_locations_all h,
                                ecx_tp_headers   e
                WHERE           h.location_id   = e.party_id
                        AND     UPPER(e.party_type)    = UPPER(c_party_type)
                        AND     UPPER(h.location_code) = UPPER(c_party_site_name);

Line: 715

                SELECT          name
                INTO            g_local_system
                FROM            wf_systems
                WHERE           guid = wf_core.translate('WF_SYSTEM_GUID');

Line: 725

                SELECT          FND_PROFILE.VALUE('ORG_ID'),
                                FND_PROFILE.VALUE('M4U_UCCNET_GLN'),
                                FND_PROFILE.VALUE('M4U_SUPP_GLN')
                INTO            g_org_id,g_host_gln,g_supp_gln
                FROM            DUAL;