APPS.PO_EDA_PKG SQL Statements

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

Line: 7

    SELECT meaning
    FROM fnd_lookups
    WHERE lookup_type = 'PO_EDA_COMPLETION_STATUS'
    AND (SYSDATE BETWEEN start_date_active AND Nvl(end_date_active,SYSDATE+1))
    AND lookup_code = p_lookup_code ;

Line: 54

  SELECT clm_document_number
  FROM po_headers_all
  WHERE po_header_id = p_document_id;

Line: 59

  SELECT d.modification_number
  FROM  po_headers_draft_all h, po_drafts d
  WHERE  d.document_id = p_document_id
  AND  d.draft_id = p_draft_id
  AND  d.document_id = h.po_header_id
  AND  d.draft_id = h.draft_id;

Line: 76

  SELECT END_USER_COLUMN_NAME,DEFAULT_VALUE
  FROM FND_DESCR_FLEX_COL_USAGE_VL
  WHERE (APPLICATION_ID=201)
  and (DESCRIPTIVE_FLEXFIELD_NAME='$SRS$.POEDAFILGEN')
  order by column_seq_num;

Line: 85

  SELECT completion_text
  FROM FND_CONC_REQ_SUMMARY_V
  WHERE request_id = l_req_id;

Line: 93

SELECT po_eda_evnt_s.NEXTVAL INTO l_event_key FROM dual;

Line: 123

   ParamList.DELETE;

Line: 195

INSERT INTO po_electronic_data_access
  (
  id                     ,
  doc_id                 ,
  doc_type               ,
  draft_id               ,
  performed_by           ,
  request_date           ,
  response_date          ,
  status                 ,
  response               ,
  approved_without_check ,
  reason                 ,
  history_record         ,
  request_id             ,
  last_update_date       ,
  last_updated_by        ,
  creation_date          ,
  created_by             ,
  last_update_login
  )
VALUES (po_eda_s.NEXTVAL,
        p_document_id,
        p_document_type,
        p_draft_id,
        Fnd_Global.User_Id,
        SYSDATE,
        SYSDATE,
        l_lookup_code,
        l_completion_text,
        NULL,
        NULL,
        'Y',
        l_req_id,
        SYSDATE,
        Fnd_Global.User_Id,
        SYSDATE,
        Fnd_Global.User_Id,
        Fnd_Global.Login_Id);

Line: 257

SELECT 'Y'
FROM po_electronic_data_access
WHERE doc_id = p_document_id
AND   doc_type = p_document_type
AND   Nvl(draft_id,-1) = Nvl(p_draft_id,-1)
AND   history_record = 'N';

Line: 272

  INSERT INTO po_electronic_data_access
  (
  id                     ,
  doc_id                 ,
  doc_type               ,
  draft_id               ,
  performed_by           ,
  request_date           ,
  response_date          ,
  status                 ,
  response               ,
  approved_without_check ,
  reason                 ,
  history_record         ,
  request_id             ,
  last_update_date       ,
  last_updated_by        ,
  creation_date          ,
  created_by             ,
  last_update_login
  )
  VALUES (po_eda_s.NEXTVAL,
        p_document_id,
        p_document_type,
        p_draft_id,
        1020000,
        SYSDATE,
        SYSDATE,
        NULL,
        NULL,
        NULL,
        NULL,
        'N',
        NULL,
        SYSDATE,
        1020000,
        SYSDATE,
        1020000,
        1);

Line: 337

                               SELECT id,request_id
FROM po_electronic_data_access
WHERE doc_id = p_document_id
AND   doc_type = p_document_type
AND   Nvl(draft_id,-1) = Nvl(p_draft_id,-1)
AND   history_record = 'Y';

Line: 346

SELECT phase_code, status_code, completion_text
FROM fnd_concurrent_requests
WHERE request_id = cp_request_id;

Line: 369

  UPDATE po_electronic_data_access
  SET status = Decode(l_status_code,'C',l_lookup_code_complete,'I',l_lookup_code_complete,'R',l_lookup_code_complete,l_lookup_code_fail),
      response = l_completion_text
  WHERE id = c.id;

Line: 397

  SELECT clm_document_number
  FROM po_headers_all
  WHERE po_header_id = l_doc_id;

Line: 402

  SELECT d.modification_number
  FROM  po_headers_draft_all h, po_drafts d
  WHERE  d.document_id = l_doc_id
  AND  d.draft_id = l_draft_id
  AND  d.document_id = h.po_header_id
  AND  d.draft_id = h.draft_id;

Line: 419

  SELECT END_USER_COLUMN_NAME,DEFAULT_VALUE
  FROM FND_DESCR_FLEX_COL_USAGE_VL
  WHERE (APPLICATION_ID=201)
  and (DESCRIPTIVE_FLEXFIELD_NAME='$SRS$.POEDAFILGEN')
  order by column_seq_num;

Line: 428

  SELECT completion_text
  FROM FND_CONC_REQ_SUMMARY_V
  WHERE request_id = l_req_id;

Line: 506

INSERT INTO po_electronic_data_access
  (
  id                     ,
  doc_id                 ,
  doc_type               ,
  draft_id               ,
  performed_by           ,
  request_date           ,
  response_date          ,
  status                 ,
  response               ,
  approved_without_check ,
  reason                 ,
  history_record         ,
  request_id             ,
  last_update_date       ,
  last_updated_by        ,
  creation_date          ,
  created_by             ,
  last_update_login
  )
VALUES (po_eda_s.NEXTVAL,
        l_doc_id,
        l_doc_type,
        l_draft_id,
        Fnd_Global.User_Id,
        SYSDATE,
        SYSDATE,
        l_lookup_code,
        l_completion_text,
        NULL,
        NULL,
        'Y',
        l_req_id,
        SYSDATE,
        Fnd_Global.User_Id,
        SYSDATE,
        Fnd_Global.User_Id,
        Fnd_Global.Login_Id);