APPS.AS_RESOURCE_MERGE_PUB SQL Statements

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

Line: 19

FUNCTION update_resource_enddate (
    p_subscription_guid  in raw,
    p_event              in out NOCOPY wf_event_t )
RETURN VARCHAR2
IS
    l_event_key                varchar2(240) := p_event.GetEventKey();

Line: 44

        select resource_id from jtf_rs_resource_extns
        where category in ('PARTNER', 'PARTY')
          and source_id =
               (select party_id from hz_relationships
                where relationship_id=
                       (select merge_to_entity_id from hz_merge_party_details
                        where merge_from_entity_id =
                               (select relationship_id
                                from hz_relationships
                                where party_id=
                                       (select source_id
                                        from jtf_rs_resource_extns
                                        where resource_id=c_resource_id) ) ) );

Line: 64

    SELECT value
    INTO   l_logdir
    FROM   v$parameter
    WHERE  UPPER(name) = 'UTL_FILE_DIR';

Line: 121

            UTL_FILE.Put_Line(l_file_ptr,'Salesforce Update Start');

Line: 126

                update AS_ACCESSES_ALL
                set salesforce_id = l_to_resource_id
                where salesforce_id = l_resource_id;

Line: 139

                update AS_SALES_CREDITS
                set salesforce_id = l_to_resource_id
                where salesforce_id = l_resource_id;

Line: 152

                update AS_SALES_CREDITS_DENORM
                set salesforce_id = l_to_resource_id
                where salesforce_id = l_resource_id;

Line: 165

                update AS_INTERNAL_FORECASTS
                set salesforce_id = l_to_resource_id
                where salesforce_id = l_resource_id;

Line: 178

                update AS_FORECAST_WORKSHEETS
                set salesforce_id = l_to_resource_id
                where salesforce_id = l_resource_id;

Line: 191

                update AS_PROD_WORKSHEET_LINES
                set salesforce_id = l_to_resource_id
                where salesforce_id = l_resource_id;

Line: 200

            UTL_FILE.Put_Line(l_file_ptr,'Salesforce Update End');

Line: 211

    WF_CORE.CONTEXT('AS_RESOURCE_MERGE_PUB', 'update_resource_enddate',
                    p_event.getEventName(), p_subscription_guid);

Line: 220

END update_resource_enddate;