APPS.PO_WAGE_DETERMINATION_ONLINE SQL Statements

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

Line: 8

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

Line: 54

  SELECT  ATTACHED_DOCUMENT_ID,
  attach.DOCUMENT_ID,
  ENTITY_NAME,
  PK1_VALUE,
  PK2_VALUE,
  PK3_VALUE,
  PK4_VALUE,
  PK5_VALUE,
  AUTOMATICALLY_ADDED_FLAG,
  attach.PROGRAM_APPLICATION_ID,
  attach.PROGRAM_ID,
  attach.PROGRAM_UPDATE_DATE,
  attach.REQUEST_ID,
  attach.CATEGORY_ID,
  ORIG_ATTACH_DOC_ID
  FROM fnd_attached_documents attach, fnd_documents_tl doc
  WHERE pk1_value = l_attachment_pk1
  AND   attach.document_id = doc.document_id
  AND   doc.title =  p_input_url
  AND   doc.LANGUAGE = 'US'
  AND   attach.category_id = 1;

Line: 77

SELECT * from
(SELECT ATTACHED_DOCUMENT_ID,
       DOCUMENT_ID
       FROM fnd_attached_documents
       WHERE  pk1_value = To_Char(p_document_id)
       AND    Nvl(pk2_value,'-1') = Nvl(To_Char(p_draft_id),'-1')
       ORDER BY last_update_date DESC)
WHERE ROWNUM=1;

Line: 92

SELECT Nvl(Max(seq_num),0) maxseq
FROM fnd_attached_documents
WHERE pk1_value = l_attachment_pk1;

Line: 106

/*SELECT po_wdol_evnt_s.NEXTVAL INTO l_event_key FROM dual;

Line: 146

   ParamList.DELETE;

Line: 157

  SELECT fnd_attached_documents_s.nextval
  INTO x_attached_document_id
  FROM dual;

Line: 167

  select  decode(p_doc_type_class,'PO','PO_HEADERS','SOURCING','PON_AUCTION_HEADERS_ALL') into l_entity_name from dual;

Line: 169

fnd_attached_documents_pkg.insert_row(X_Rowid => x_row_id,
                     X_attached_document_id   => x_attached_document_id,
                     X_document_id            => X_document_id,
                     X_creation_date          => SYSDATE,
                     X_created_by             => Fnd_Global.User_Id,
                     X_last_update_date       => SYSDATE,
                     X_last_updated_by        => Fnd_Global.User_Id,
                     X_last_update_login      => Fnd_Global.Login_Id,
                     X_seq_num                => l_seq_num,
                     X_entity_name            => l_entity_name,
                     X_column1                => NULL,
                     X_pk1_value              => l_attachment_pk1,
                     X_pk2_value              => NULL,
                     X_pk3_value              => NULL,
                     X_pk4_value              => NULL,
                     X_pk5_value              => NULL,
                     X_automatically_added_flag  => 'Y',
                  /*  columns necessary for creating a document on the fly */
                     X_datatype_id               => 5,
                     X_category_id               => 33,
                     X_security_type             => 1,
                     X_security_id               => 204,
                     X_publish_flag              => 'Y',
                     X_language                  => l_lang,
                     X_description               => 'WD Statement URL',
                     X_media_id                  => l_media_id,
            		     X_create_doc                => 'Y',
                     X_url                       => p_input_URL,
                     X_title			                => 'Wage Determination Statement');

Line: 203

INSERT INTO po_wage_determination
(
  id                ,
  doc_id            ,
  doc_type          ,
  draft_id          ,
  wd_statement_url  ,
  request_date      ,
  response_date     ,
  status            ,
  error             ,
  last_update_date  ,
  last_updated_by   ,
  creation_date     ,
  created_by        ,
  last_update_login
)
VALUES (po_wage_determination_s.NEXTVAL,
        p_document_id,
        p_document_type,
        p_draft_id,
        p_input_url,
        SYSDATE,
        SYSDATE,
        l_lookup_code,
        NULL,
	SYSDATE,
	Fnd_Global.User_Id,
        SYSDATE,
        Fnd_Global.User_Id,
        Fnd_Global.Login_Id
);

Line: 242

INSERT INTO po_wage_determination
(
  id                ,
  doc_id            ,
  doc_type          ,
  draft_id          ,
  wd_statement_url  ,
  request_date      ,
  response_date     ,
  status            ,
  error             ,
  last_update_date  ,
  last_updated_by   ,
  creation_date     ,
  created_by        ,
  last_update_login
)
VALUES (po_wage_determination_s.NEXTVAL,
        p_document_id,
        p_document_type,
        p_draft_id,
        p_input_url,
        SYSDATE,
        SYSDATE,
        l_lookup_code,
        'URL Not Found',
        SYSDATE,
        Fnd_Global.User_Id,
        SYSDATE,
        Fnd_Global.User_Id,
        Fnd_Global.Login_Id
);

Line: 300

  SELECT  ATTACHED_DOCUMENT_ID,
  attach.DOCUMENT_ID,
  ENTITY_NAME,
  PK1_VALUE,
  PK2_VALUE,
  PK3_VALUE,
  PK4_VALUE,
  PK5_VALUE,
  AUTOMATICALLY_ADDED_FLAG,
  attach.PROGRAM_APPLICATION_ID,
  attach.PROGRAM_ID,
  attach.PROGRAM_UPDATE_DATE,
  attach.REQUEST_ID,
  attach.CATEGORY_ID,
  ORIG_ATTACH_DOC_ID
  FROM fnd_attached_documents attach, fnd_documents_tl doc
  WHERE pk1_value = l_attachment_pk1
  AND   attach.document_id = doc.document_id
  AND   doc.title =  l_input_url
  AND   doc.LANGUAGE = 'US'
  AND   attach.category_id = 1;

Line: 323

SELECT * from
(SELECT ATTACHED_DOCUMENT_ID,
       DOCUMENT_ID
       FROM fnd_attached_documents
       WHERE  pk1_value = To_Char(l_doc_id)
       AND    Nvl(pk2_value,'-1') = Nvl(To_Char(l_draft_id),'-1')
       ORDER BY last_update_date DESC)
WHERE ROWNUM=1;

Line: 338

SELECT Max(seq_num) maxseq
FROM fnd_attached_documents
WHERE pk1_value = l_attachment_pk1;

Line: 360

  SELECT fnd_attached_documents_s.nextval
  INTO x_attached_document_id
  FROM dual;

Line: 370

  select  decode(l_doc_type_class,'PO','PO_HEADERS','SOURCING','PON_AUCTION_HEADERS_ALL') into l_entity_name from dual;

Line: 373

fnd_attached_documents_pkg.insert_row(X_Rowid => x_row_id,
                     X_attached_document_id   => x_attached_document_id,
                     X_document_id            => X_document_id,
                     X_creation_date          => SYSDATE,
                     X_created_by             => Fnd_Global.User_Id,
                     X_last_update_date       => SYSDATE,
                     X_last_updated_by        => Fnd_Global.User_Id,
                     X_last_update_login      => Fnd_Global.Login_Id,
                     X_seq_num                => l_seq_num,
                     X_entity_name            => l_entity_name,
                     X_column1                => NULL,
                     X_pk1_value              => l_attachment_pk1,
                     X_pk2_value              => NULL,
                     X_pk3_value              => NULL,
                     X_pk4_value              => NULL,
                     X_pk5_value              => NULL,
                     X_automatically_added_flag  => 'Y',
                  /*  columns necessary for creating a document on the fly */
                     X_datatype_id               => 5,
                     X_category_id               => 33,
                     X_security_type             => 1,
                     X_security_id               => 204,
                     X_publish_flag              => 'Y',
                     X_language                  => l_lang,
                     X_description               => 'WD Statement URL',
                     X_media_id                  => l_media_id,
            		     X_create_doc                => 'Y',
                     X_url                       => l_input_url,
                     X_title			                => 'Wage Determination Statement');

Line: 423

                        X_last_update_login => Fnd_Global.Login_Id,
                        X_program_application_id => c.PROGRAM_APPLICATION_ID,
                        X_program_id => c.PROGRAM_ID,
                        X_request_id => c.REQUEST_ID,
                        X_automatically_added_flag => c.AUTOMATICALLY_ADDED_FLAG,
                        X_from_category_id => c.CATEGORY_ID,
                        X_to_category_id => 33,
                        X_orig_attach_doc_id => c.ATTACHED_DOCUMENT_ID
                        );

Line: 437

UPDATE fnd_documents_tl
SET    title = 'Wage Determination Statement',
       description = 'WD Statement URL'
WHERE  document_id = c2.DOCUMENT_ID;

Line: 451

INSERT INTO po_wage_determination
(
  id                ,
  doc_id            ,
  doc_type          ,
  draft_id          ,
  wd_statement_url  ,
  request_date      ,
  response_date     ,
  status            ,
  error             ,
  last_update_date  ,
  last_updated_by   ,
  creation_date     ,
  created_by        ,
  last_update_login
)
VALUES (po_wage_determination_s.NEXTVAL,
        l_doc_id,
        l_doc_type,
        l_draft_id,
        l_input_url,
        SYSDATE,
        SYSDATE,
        l_lookup_code,
        NULL,
	SYSDATE,
	Fnd_Global.User_Id,
        SYSDATE,
        Fnd_Global.User_Id,
        Fnd_Global.Login_Id
);

Line: 488

INSERT INTO po_wage_determination
(
  id                ,
  doc_id            ,
  doc_type          ,
  draft_id          ,
  wd_statement_url  ,
  request_date      ,
  response_date     ,
  status            ,
  error             ,
  last_update_date  ,
  last_updated_by   ,
  creation_date     ,
  created_by        ,
  last_update_login
)
VALUES (po_wage_determination_s.NEXTVAL,
        l_doc_id,
        l_doc_type,
        l_draft_id,
        l_input_url,
        SYSDATE,
        SYSDATE,
        l_lookup_code,
        'URL Not Found',
        SYSDATE,
        Fnd_Global.User_Id,
        SYSDATE,
        Fnd_Global.User_Id,
        Fnd_Global.Login_Id
);

Line: 539

SELECT org_id
FROM pon_auction_headers_all
WHERE auction_header_id = p_auction_header_id;

Line: 546

SELECT ENABLE_WDOL
FROM po_system_parameters_all
WHERE org_id = l_org_id;

Line: 553

SELECT  'Y'
FROM fnd_attached_documents attach, fnd_documents_tl doc
WHERE pk1_value = To_Char(p_auction_header_id)
AND   attach.document_id = doc.document_id
AND   doc.title =  'Wage Determination Statement'
AND   doc.description = 'WD Statement URL'
AND   doc.LANGUAGE = 'US'
AND   attach.category_id = 33;

Line: 621

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

Line: 639

INSERT INTO po_wage_determination
(
  id                ,
  doc_id            ,
  doc_type          ,
  draft_id          ,
  wd_statement_url  ,
  request_date      ,
  response_date     ,
  status            ,
  error             ,
  last_update_date  ,
  last_updated_by   ,
  creation_date     ,
  created_by        ,
  last_update_login
)
VALUES (po_wage_determination_s.NEXTVAL,
        p_document_id,
        p_document_type,
        p_draft_id,
        null,
        null,
        null,
        null,
        NULL,
	      SYSDATE,
	      Fnd_Global.User_Id,
        SYSDATE,
        Fnd_Global.User_Id,
        Fnd_Global.Login_Id
);

Line: 689

SELECT org_id
FROM pon_auction_headers_all
WHERE auction_header_id = p_document_id;

Line: 696

SELECT ENABLE_WDOL
FROM po_system_parameters_all
WHERE org_id = l_org_id;

Line: 703

SELECT 'Y'
FROM pon_auction_headers_all
WHERE Nvl(auction_status,'DRAFT') IN ('DRAFT','AUCTION_CLOSED','ACTIVE')
AND   auction_header_id = p_document_id;