APPS.CLN_SYNCCTLG_PKG SQL Statements

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

Line: 50

   l_update_cln_event            VARCHAR2(100);

Line: 55

   l_update_cln_parameter_list   wf_parameter_list_t;

Line: 68

      select concatenated_segments
      from cln_procat_catitem_v cpcv, ecx_tp_headers eth
      where cpcv.list_header_id=p_list_header_id
      and cpcv.party_id=eth.party_id
      and eth.tp_header_id = p_tp_header_id
      and cpcv.organization_id = l_inv_org_id
      and (p_category_id is null or p_category_id in (select mcsvc.category_id from mtl_item_categories mic,
            mtl_category_set_valid_cats mcsvc where mcsvc.category_id = mic.category_id
            and mcsvc.category_set_id = mic.category_set_id and mic.inventory_item_id=cpcv.inventory_item_id
            and mic.organization_id=cpcv.organization_id))
      and ( p_from_items is null or cpcv.concatenated_segments>=p_from_items)
      and ( p_to_items is null or cpcv.concatenated_segments<=p_to_items)
      order by concatenated_segments;

Line: 116

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

Line: 120

      l_update_cln_parameter_list := wf_parameter_list_t();

Line: 130

      select eth.party_id, eth.party_site_id
      into party_id, party_site_id
      from ecx_tp_headers eth
      where eth.tp_header_id = p_tp_header_id;

Line: 140

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

Line: 153

      select haou.name, hla.ece_tp_location_code
      into l_publisher_name, l_publisher_partnridx
      from hr_all_organization_units haou, hr_locations_all hla
      where haou.location_id = hla.location_id
      and haou.organization_id = l_operating_unit_id;

Line: 221

         SELECT CLN_SYNCCTLG_S.nextval into l_syncctlg_seq from dual;

Line: 227

         SELECT sysdate into l_date from dual;

Line: 431

            l_update_cln_parameter_list := wf_parameter_list_t();

Line: 434

                                        p_parameterlist => l_update_cln_parameter_list);

Line: 437

                                        p_parameterlist => l_update_cln_parameter_list);

Line: 440

                                        p_parameterlist => l_update_cln_parameter_list);

Line: 443

                                        p_parameterlist => l_update_cln_parameter_list);

Line: 446

                                        p_parameterlist => l_update_cln_parameter_list);

Line: 449

                                        p_parameterlist => l_update_cln_parameter_list);

Line: 452

                                        p_parameterlist => l_update_cln_parameter_list);

Line: 455

                                        p_parameterlist => l_update_cln_parameter_list);

Line: 458

                                        p_parameterlist => l_update_cln_parameter_list);

Line: 461

                                        p_parameterlist => l_update_cln_parameter_list);

Line: 464

                                        p_parameterlist => l_update_cln_parameter_list);

Line: 467

                                        p_parameterlist => l_update_cln_parameter_list);

Line: 469

            x_progress := 'CLN_SYNCITEM_PKG.Syncctlg_Raise_Event : Initialize update event parameters';

Line: 475

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

Line: 479

            x_progress := 'CLN_SYNCITEM_PKG.Syncctlg_Raise_Event : Update Event Raised';

Line: 552

            SELECT CLN_SYNCCTLG_S.nextval into l_syncctlg_seq from dual;

Line: 558

            SELECT sysdate into l_date from dual;

Line: 749

            l_update_cln_parameter_list := wf_parameter_list_t();

Line: 752

                                        p_parameterlist => l_update_cln_parameter_list);

Line: 755

                                        p_parameterlist => l_update_cln_parameter_list);

Line: 758

                                        p_parameterlist => l_update_cln_parameter_list);

Line: 761

                                        p_parameterlist => l_update_cln_parameter_list);

Line: 764

                                        p_parameterlist => l_update_cln_parameter_list);

Line: 767

                                        p_parameterlist => l_update_cln_parameter_list);

Line: 770

                                        p_parameterlist => l_update_cln_parameter_list);

Line: 773

                                        p_parameterlist => l_update_cln_parameter_list);

Line: 776

                                        p_parameterlist => l_update_cln_parameter_list);

Line: 779

                                        p_parameterlist => l_update_cln_parameter_list);

Line: 782

                                        p_parameterlist => l_update_cln_parameter_list);

Line: 785

                                        p_parameterlist => l_update_cln_parameter_list);

Line: 787

            x_progress := 'CLN_SYNCCTLG_PKG.Syncctlg_Raise_Event : Initialized update event parameters';

Line: 793

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

Line: 797

            x_progress := 'CLN_SYNCCTLG_PKG.Syncctlg_Raise_Event : Update Event Raised';