APPS.OKS_CODE_HOOK SQL Statements

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

Line: 379

 PROCEDURE Update_Merge_Account(req_id IN NUMBER
                                   ,set_number  IN NUMBER
                                   ,process_mode IN VARCHAR2
                                    ,x_hook OUT NOCOPY NUMBER
   ) IS

   BEGIN

      x_hook          := 0;

Line: 390

       They customer can write their own logic to update the TAS to update the information which was updated in OKS during customer merge*/


 EXCEPTION
 WHEN OTHERS THEN
  x_hook          := -1;

Line: 396

 END Update_Merge_Account;

Line: 416

The customer has to write their own logic to update the TAS with the information updated in OKS during Party Merge.
*/


 PROCEDURE Update_Party_Merge(
    p_entity_name                IN   VARCHAR2,
    p_from_id                    IN   NUMBER,
    p_from_fk_id                 IN   NUMBER,
    p_to_fk_id                   IN   NUMBER,
    p_parent_entity_name         IN   VARCHAR2,
    p_batch_id                   IN   NUMBER,
    p_batch_party_id             IN   NUMBER,
    x_hook                            OUT NOCOPY VARCHAR2) IS

   BEGIN

      x_hook          := 0;

Line: 435

       They customer can write their own logic to update the TAS to update the information which was updated in OKS during Party merge*/


 EXCEPTION
 WHEN OTHERS THEN
  x_hook          := -1;

Line: 441

 END Update_Party_Merge;

Line: 464

  SELECT  Op.meaning Source,
          cl.opn_code,
          (Kh.COntract_number||Kh.COntract_number_modifier) Contract,
          (Tl.line_number||'.'||Kl.Line_Number) line_Number
  FROM okc_class_operations cl
     , okc_operation_instances oip
     , okc_operation_lines ol
     , okc_operations_v Op
     , Okc_k_headers_b Kh
     , Okc_k_lines_b Kl
     ,Okc_k_lines_b Tl
  WHERE ol.subject_cle_id = p_cle_id --"Subline ID"
  AND    oip.cop_id = cl.Id
  AND    cl.cls_code = 'SERVICE'
  AND    ol.oie_id = oip.id
  AND    Op.Code = cl.opn_code
  AND    Kh.Id = Kl.dnz_chr_id
  AND    Kl.Id = ol.object_cle_id
  AND    Kl.cle_id = Tl.Id;

Line: 487

  SELECT object1_id1 from
  OKC_K_REL_OBJS_V
  WHERE cle_id = p_cle_id
  AND  JTOT_OBJECT1_CODE = p_object_code;

Line: 495

  SELECT order_number , decode( to_char(nvl(line.option_number,-99)), '-99',
                   decode(to_char(nvl(line.component_number,'-99')) , '-99' ,
                   line.line_number||'.'||line.shipment_number||'...'|| line.service_number
		   ,line.line_number||'.'||line.shipment_number||'..'||
                   line.component_number||'.'||line.service_number )
		   , decode(to_char(nvl(line.component_number,-99)) , '-99',
                   line.line_number||'.'||line.shipment_number||'.'||
                   line.option_number||'..'||line.service_number
                   ,line.line_number||'.'||line.shipment_number||'.'||line.option_number ||'.'||
                   line.component_number||'.'||line.service_number ) ) line_number
  FROM oe_order_lines_all line, oe_order_headers_all hdr
  WHERE line.line_id =  p_line_id
  AND hdr.header_id =line.header_id;

Line: 512

  SELECT Meaning
  FROM   Fnd_Lookups
  WHERE  Lookup_Type = p_type
  AND    Lookup_Code = p_code;

Line: 518

  SELECT object1_id1
  FROM okc_k_rel_objs_v
  WHERE chr_id = p_chr_id
  AND   cle_id IS NULL;

Line: 526

  SELECT order_number
  FROM okx_order_headers_v
  WHERE id1 = p_object1_id1;