APPS.OKE_COMMUNICATION_PKG SQL Statements

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

Line: 50

    select k_header_id,
           communication_num,
           communication_date,
           type,
           reason_code,
           party_location,
           party_role,
           party_contact,
           action_code,
           priority_code,
           owner,
           k_party_id,
           wf_item_type,
           wf_process,
           wf_item_key,
           text,
           funding_ref1,
           funding_ref2,
           funding_ref3,
           funding_source_id,
           chg_request_id,
           k_line_id,
           deliverable_id,
           project_id,
           task_id,
           attribute_category,
           attribute1,
           attribute2,
           attribute3,
           attribute4,
           attribute5,
           attribute6,
           attribute7,
           attribute8,
           attribute9,
           attribute10,
           attribute11,
           attribute12,
           attribute13,
           attribute14,
           attribute15
      from OKE_K_COMMUNICATIONS
      where k_header_id = X_k_header_id
      and communication_num = X_communication_num
      for update of k_header_id, communication_num nowait;

Line: 104

    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 194

PROCEDURE Update_Row(
             X_k_header_id                NUMBER,
             X_communication_num          VARCHAR2,
             X_communication_date         DATE,
             X_type                       VARCHAR2,
             X_reason_code                VARCHAR2,
             X_party_location             VARCHAR2,
             X_party_role                 VARCHAR2,
             X_party_contact              VARCHAR2,
             X_action_code                VARCHAR2,
             X_priority_code              VARCHAR2,
             X_owner                      NUMBER,
             X_k_party_id                 NUMBER,
             X_wf_item_type        IN OUT NOCOPY VARCHAR2,
             X_wf_process          IN OUT NOCOPY VARCHAR2,
             X_wf_item_key         IN OUT NOCOPY VARCHAR2,
             X_text                       LONG,
             X_funding_ref1               VARCHAR2,
             X_funding_ref2               VARCHAR2,
             X_funding_ref3               VARCHAR2,
             X_funding_source_id          NUMBER,
             X_k_line_id                  NUMBER,
             X_deliverable_id             NUMBER,
             X_chg_request_id             NUMBER,
             X_project_id                 NUMBER,
             X_task_id                    NUMBER,
             X_Last_Update_Date           DATE,
             X_Last_Updated_By            NUMBER,
             X_Last_Update_Login          NUMBER,
             X_Attribute_Category         VARCHAR2,
             X_Attribute1                 VARCHAR2,
             X_Attribute2                 VARCHAR2,
             X_Attribute3                 VARCHAR2,
             X_Attribute4                 VARCHAR2,
             X_Attribute5                 VARCHAR2,
             X_Attribute6                 VARCHAR2,
             X_Attribute7                 VARCHAR2,
             X_Attribute8                 VARCHAR2,
             X_Attribute9                 VARCHAR2,
             X_Attribute10                VARCHAR2,
             X_Attribute11                VARCHAR2,
             X_Attribute12                VARCHAR2,
             X_Attribute13                VARCHAR2,
             X_Attribute14                VARCHAR2,
             X_Attribute15                VARCHAR2

  ) is

  x_prev_action_code OKE_K_COMMUNICATIONS.action_code%TYPE;

Line: 245

    select wf_item_type
    ,      wf_process
    ,      wf_item_key
    from   OKE_K_COMMUNICATIONS
    where  k_header_id = X_k_header_id
    and communication_num = X_communication_num;

Line: 253

    select action_code
    from   OKE_K_COMMUNICATIONS
    where  k_header_id = X_k_header_id
    and communication_num = X_communication_num;

Line: 264

  update OKE_K_COMMUNICATIONS
  set
       communication_date  = X_communication_date,
       type                = X_type,
       reason_code         = X_reason_code,
       party_location      = X_party_location,
       party_role          = X_party_role,
       party_contact       = X_party_contact,
       action_code         = X_action_code,
       priority_code       = X_priority_code,
       owner               = X_owner,
       k_party_id          = X_k_party_id,
       wf_item_type        = X_wf_item_type,
       wf_process          = X_wf_process,
       wf_item_key         = X_wf_item_key,
       text                = X_text,
       funding_ref1        = X_funding_ref1,
       funding_ref2        = X_funding_ref2,
       funding_ref3        = X_funding_ref3,
       funding_source_id   = X_funding_source_id,
       k_line_id           = X_k_line_id,
       deliverable_id      = X_deliverable_id,
       chg_request_id      = X_chg_request_id,
       project_id          = X_project_id,
       task_id             = X_task_id,
       Last_Update_Date    = X_Last_Update_Date,
       Last_Updated_By     = X_Last_Updated_By,
       Last_Update_Login   = X_Last_Update_Login,
       attribute_Category  = X_Attribute_Category,
       attribute1          = X_Attribute1,
       attribute2          = X_Attribute2,
       attribute3          = X_Attribute3,
       attribute4          = X_Attribute4,
       attribute5          = X_Attribute5,
       attribute6          = X_Attribute6,
       attribute7          = X_Attribute7,
       attribute8          = X_Attribute8,
       attribute9          = X_Attribute9,
       attribute10         = X_Attribute10,
       attribute11         = X_Attribute11,
       attribute12         = X_Attribute12,
       attribute13         = X_Attribute13,
       attribute14         = X_Attribute14,
       attribute15         = X_Attribute15
  where k_header_id = X_k_header_id
  and communication_num = X_communication_num;

Line: 328

    , X_Last_Updated_By
    , X_Last_Update_Date
    , X_Last_Update_Login
    , X_WF_ITEM_KEY
    );

Line: 343

end Update_Row;

Line: 345

PROCEDURE Insert_Row(
             X_Rowid               IN OUT NOCOPY VARCHAR2,
             X_k_header_id                NUMBER,
             X_communication_num          VARCHAR2,
             X_communication_date         DATE,
             X_type                       VARCHAR2,
             X_reason_code                VARCHAR2,
             X_party_location             VARCHAR2,
             X_party_role                 VARCHAR2,
             X_party_contact              VARCHAR2,
             X_action_code                VARCHAR2,
             X_priority_code              VARCHAR2,
             X_owner                      NUMBER,
             X_k_party_id                 NUMBER,
             X_wf_item_type        IN OUT NOCOPY VARCHAR2,
             X_wf_process          IN OUT NOCOPY VARCHAR2,
             X_wf_item_key         IN OUT NOCOPY VARCHAR2,
             X_text                       LONG,
             X_funding_ref1               VARCHAR2,
             X_funding_ref2               VARCHAR2,
             X_funding_ref3               VARCHAR2,
             X_funding_source_id          NUMBER,
             X_k_line_id                  NUMBER,
             X_deliverable_id             NUMBER,
             X_chg_request_id             NUMBER,
             X_project_id                 NUMBER,
             X_task_id                    NUMBER,
             X_Last_Update_Date           DATE,
             X_Last_Updated_By            NUMBER,
             X_Creation_Date              DATE,
             X_Created_By                 NUMBER,
             X_Last_Update_Login          NUMBER,
             X_Attribute_Category         VARCHAR2,
             X_Attribute1                 VARCHAR2,
             X_Attribute2                 VARCHAR2,
             X_Attribute3                 VARCHAR2,
             X_Attribute4                 VARCHAR2,
             X_Attribute5                 VARCHAR2,
             X_Attribute6                 VARCHAR2,
             X_Attribute7                 VARCHAR2,
             X_Attribute8                 VARCHAR2,
             X_Attribute9                 VARCHAR2,
             X_Attribute10                VARCHAR2,
             X_Attribute11                VARCHAR2,
             X_Attribute12                VARCHAR2,
             X_Attribute13                VARCHAR2,
             X_Attribute14                VARCHAR2,
             X_Attribute15                VARCHAR2
) is

  cursor C is
  select rowid
  ,      wf_item_type
  ,      wf_process
  ,      wf_item_key
  from   OKE_K_COMMUNICATIONS
  where  k_header_id = X_k_header_id
  and communication_num = X_communication_num;

Line: 406

  insert into OKE_K_COMMUNICATIONS(
        k_header_id,
        communication_num,
        communication_date,
        type,
        reason_code,
        party_location,
        party_role,
        party_contact,
        action_code,
        priority_code,
        owner,
        k_party_id,
        wf_item_type,
        wf_process,
        wf_item_key,
        text,
        funding_ref1,
        funding_ref2,
        funding_ref3,
        funding_source_id,
        k_line_id,
        deliverable_id,
        chg_request_id,
        project_id,
        task_id,
        Last_Update_Date,
        Last_Updated_By,
        Creation_Date,
        Created_By,
        Last_Update_Login,
        Attribute_Category,
        Attribute1,
        Attribute2,
        Attribute3,
        Attribute4,
        Attribute5,
        Attribute6,
        Attribute7,
        Attribute8,
        Attribute9,
        Attribute10,
        Attribute11,
        Attribute12,
        Attribute13,
        Attribute14,
        Attribute15
  ) VALUES (
        X_k_header_id,
        X_communication_num,
        X_communication_date,
        X_type,
        X_reason_code,
        X_party_location,
        X_party_role,
        X_party_contact,
        X_action_code,
        X_priority_code,
        X_owner,
        X_k_party_id,
        X_wf_item_type,
        X_wf_process,
        X_wf_item_key,
        X_text,
        X_funding_ref1,
        X_funding_ref2,
        X_funding_ref3,
        X_funding_source_id,
        X_k_line_id,
        X_deliverable_id,
        X_chg_request_id,
        X_project_id,
        X_task_id,
        X_Last_Update_Date,
        X_Last_Updated_By,
        X_Creation_Date,
        X_Created_By,
        X_Last_Update_Login,
        X_Attribute_Category,
        X_Attribute1,
        X_Attribute2,
        X_Attribute3,
        X_Attribute4,
        X_Attribute5,
        X_Attribute6,
        X_Attribute7,
        X_Attribute8,
        X_Attribute9,
        X_Attribute10,
        X_Attribute11,
        X_Attribute12,
        X_Attribute13,
        X_Attribute14,
        X_Attribute15
  );

Line: 518

  , X_Last_Updated_By
  , X_Last_Update_Date
  , X_Last_Update_Login
  , X_WF_ITEM_KEY
  );

Line: 532

end Insert_Row;

Line: 535

PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
BEGIN

  DELETE FROM OKE_K_COMMUNICATIONS
  WHERE rowid = X_Rowid;

Line: 549

END Delete_Row;