APPS.OKE_FLOWDOWN_UTILS SQL Statements

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

Line: 24

  SELECT function_id
  FROM   fnd_form_functions
  WHERE  function_name=C_Function_Name;

Line: 29

  SELECT project_id , task_id
  FROM   wip_discrete_jobs
  WHERE  organization_id = C_Org_ID
  AND    wip_entity_id = C_Job_ID;

Line: 35

  SELECT distinct L.oke_contract_header_id , D.oke_contract_line_id
  FROM   po_distributions_all D , po_lines_all L
  WHERE  D.po_line_id = C_Line_ID
  AND    L.po_line_id = D.po_line_id;

Line: 41

  SELECT L.oke_contract_header_id , D.oke_contract_line_id , D.project_id , D.task_id
  FROM   po_distributions_all D , po_lines_all L
  WHERE  D.po_distribution_id = C_Dist_ID
  AND    L.po_line_id         = D.po_line_id;

Line: 47

  SELECT distinct L.oke_contract_header_id , D.oke_contract_line_id
  FROM   po_req_distributions_all D , po_requisition_lines_all L
  WHERE  D.requisition_line_id = C_Line_ID
  AND    L.requisition_line_id = D.requisition_line_id;

Line: 53

  SELECT L.oke_contract_header_id , D.oke_contract_line_id , D.project_id , D.task_id
  FROM   po_req_distributions_all D , po_requisition_lines_all L
  WHERE  D.distribution_id     = C_Dist_ID
  AND    L.requisition_line_id = D.requisition_line_id;

Line: 59

  SELECT d.k_header_id ,D.k_line_id , d.project_id , d.task_id
  FROM   wsh_delivery_details W , oke_k_deliverables_b D
  WHERE  W.delivery_detail_id = C_Delivery_detail_ID
  AND    W.source_code        ='OKE'
  AND    D.deliverable_id     = W.source_line_id;

Line: 253

PROCEDURE INSERT_ROW
( P_BUSINESS_AREA_CODE   IN  VARCHAR2
, P_FLOWDOWN_TYPE        IN  VARCHAR2
, P_FLOWDOWN_CODE        IN  VARCHAR2
, P_ATTRIBUTE_GROUP_TYPE IN  VARCHAR2
) IS
  L_CREATION_DATE        DATE;

Line: 261

  L_LAST_UPDATE_LOGIN    NUMBER;

Line: 267

  L_LAST_UPDATE_LOGIN    := FND_GLOBAL.LOGIN_ID;

Line: 269

  INSERT INTO OKE_FLOWDOWNS
  ( BUSINESS_AREA_CODE
  , FLOWDOWN_TYPE
  , FLOWDOWN_CODE
  , ATTRIBUTE_GROUP_TYPE
  , CREATION_DATE
  , CREATED_BY
  , LAST_UPDATE_DATE
  , LAST_UPDATED_BY
  , LAST_UPDATE_LOGIN
  ) VALUES
  ( P_BUSINESS_AREA_CODE
  , P_FLOWDOWN_TYPE
  , P_FLOWDOWN_CODE
  , Decode(P_FLOWDOWN_TYPE,'ATTRIBUTE',P_ATTRIBUTE_GROUP_TYPE,'NONE')
  , L_CREATION_DATE
  , L_CREATED_BY
  , L_CREATION_DATE
  , L_CREATED_BY
  , L_LAST_UPDATE_LOGIN
  );

Line: 291

END INSERT_ROW;

Line: 293

PROCEDURE DELETE_ROW
( P_BUSINESS_AREA_CODE    IN     VARCHAR2
, P_FLOWDOWN_TYPE         IN     VARCHAR2
, P_FLOWDOWN_CODE         IN     VARCHAR2
, P_ATTRIBUTE_GROUP_TYPE  IN     VARCHAR2
) IS

BEGIN

  DELETE FROM OKE_FLOWDOWNS
  WHERE BUSINESS_AREA_CODE = P_BUSINESS_AREA_CODE
    AND FLOWDOWN_TYPE = P_FLOWDOWN_TYPE
    AND ( P_FLOWDOWN_CODE IS NULL
      OR FLOWDOWN_CODE = P_FLOWDOWN_CODE
       AND ATTRIBUTE_GROUP_TYPE =
        Decode( P_FLOWDOWN_TYPE, 'ATTRIBUTE', P_ATTRIBUTE_GROUP_TYPE, 'NONE') );

Line: 310

END DELETE_ROW;