APPS.CLN_UPDTDLVY_PKG SQL Statements

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

Line: 19

   PROCEDURE Get_Updatedelivery_Params(itemtype               IN              VARCHAR2,
                                       itemkey                IN              VARCHAR2,
                                       actid                  IN              NUMBER,
                                       funcmode               IN              VARCHAR2,
                                       resultout              IN OUT NOCOPY   VARCHAR2) IS
   l_debug_level                 NUMBER;

Line: 60

         cln_debug_pub.Add('ENTERING CLN_UPDTDLVY_PKG.Get_UpdateDelivery_Params', 1);

Line: 78

      x_progress := 'CLN_UPDTDLVY_PKG.Raise_Updatedelivery_Event: Parameters Initialized';

Line: 98

      SELECT h.vendor_id, h.vendor_site_id
      INTO party_id, party_site_id
      FROM rcv_shipment_headers h
      WHERE h.shipment_header_id = p_shipment_header_id;

Line: 103

      select FND_PROFILE.VALUE('ORG_ID')
      into l_organization_id
      from dual;

Line: 108

         cln_debug_pub.Add('CLN_UPDTDLVY_PKG.Raise_Updatedelivery_Event: Parameter Lookups Completed', 1);

Line: 128

         cln_debug_pub.Add('CLN_UPDTDLVY_PKG.Raise_Updatedelivery_Event : XML Trading Partner Setup Check Done', 1);

Line: 137

         x_progress := 'CLN_UPDTDLVY_PKG.Raise_Updatedelivery_Event : XML Trading Partner Setup Check Failed';

Line: 145

         x_progress := 'CLN_UPDTDLVY_PKG.Raise_Updatedelivery_Event : XML Trading Partner Setup Check Succeeded';

Line: 150

         SELECT h.receipt_num INTO l_receipt_id FROM rcv_shipment_headers h
         WHERE h.shipment_header_id = p_shipment_header_id;

Line: 156

         SELECT CLN_UPDTDLVY_S.nextval into l_updtdlvy_seq from dual;

Line: 159

         SELECT sysdate into l_date from dual;

Line: 162

         x_progress := 'CLN_UPDTDLVY_PKG.Raise_Updatedelivery_Event : Created reference ID, unique key, and canonical date';

Line: 189

            cln_debug_pub.Add('EXITING CLN_UPDTDLVY_PKG.Raise_UpdateDelivery_Event Successfully', 1);

Line: 202

         x_progress := 'CLN_UPDTDLVY_PKG.Raise_Updatedelivery_Event : Error';

Line: 208

   END Get_Updatedelivery_Params;

Line: 244

   PROCEDURE Process_Update_Delivery   (p_receipt_id           IN              VARCHAR2,
                                        p_int_cnt_num          IN              NUMBER,
                                        p_delivery_num         IN              VARCHAR2,
                                        x_notification_code    IN OUT NOCOPY   VARCHAR2,
                                        x_doc_status           IN OUT NOCOPY   VARCHAR2) IS
   l_debug_level                 NUMBER;

Line: 260

   l_update_cln_event            VARCHAR2(100);

Line: 263

   l_update_cln_parameter_list   wf_parameter_list_t;

Line: 275

      l_update_cln_event := 'oracle.apps.cln.ch.collaboration.add';

Line: 276

      l_update_cln_parameter_list := wf_parameter_list_t();

Line: 281

         cln_debug_pub.Add('Entering CLN_UPDTDLVY_PKG.Process_Update_Delivery', 1);

Line: 291

      x_progress := 'CLN_UPDTDLVY_PKG.Raise_Updatedelivery_Event: 01';

Line: 297

      SELECT CLN_UPDTDLVY_S.nextval into l_updtdlvy_seq from dual;

Line: 300

      SELECT sysdate into l_date from dual;

Line: 311

                                  p_parameterlist => l_update_cln_parameter_list);

Line: 314

                                  p_parameterlist => l_update_cln_parameter_list);

Line: 317

                                  p_parameterlist => l_update_cln_parameter_list);

Line: 320

                                  p_parameterlist => l_update_cln_parameter_list);

Line: 323

                                  p_parameterlist => l_update_cln_parameter_list);

Line: 325

      x_progress := 'CLN_SYNCCTLG_PKG.Process_Update_Delivery : 03';

Line: 331

      wf_event.raise(p_event_name => l_update_cln_event,
                     p_event_key  => l_event_key,
                     p_parameters => l_update_cln_parameter_list);

Line: 335

      x_progress := 'CLN_SYNCCTLG_PKG.Process_Update_Delivery : 04';

Line: 347

         SELECT 1
         INTO l_temp
         FROM WSH_NEW_DELIVERIES
         WHERE name = p_delivery_num;

Line: 396

      wf_event.raise(p_event_name => l_update_cln_event,
                     p_event_key  => l_event_key||'.2',
                     p_parameters => l_second_cln_parameter_list);

Line: 413

         x_progress := 'CLN_UPDTDLVY_PKG.Raise_Updatedelivery_Event : 05';

Line: 418

   END Process_Update_Delivery;

Line: 451

      SELECT o.organization_id
      INTO   l_org_id
      FROM per_people_f p, org_organization_definitions o, rcv_shipment_headers h
      WHERE nvl(h.shipped_date, h.last_update_date)
      BETWEEN NVL(p.effective_start_date, NVL(h.shipped_date, h.last_update_date))
      AND NVL(p.effective_end_date, NVL(h.shipped_date, h.last_update_date))
      AND p.person_id (+) = h.employee_id
      AND o.organization_id (+) =NVL( h.organization_id,h.ship_to_org_id)
      AND h.shipment_header_id = P_SHIPMENT_HEADER_ID;