APPS.IRC_DOCUMENT_API SQL Statements

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

Line: 19

    select oracle_username
      from fnd_oracle_userid
     where oracle_id = 800;

Line: 200

procedure UPDATE_DOCUMENT
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_document_id                   in     number
  ,p_mime_type                     in     varchar2 default HR_API.G_VARCHAR2
  ,p_type                          in     varchar2 default HR_API.G_VARCHAR2
  ,p_file_name                     in     varchar2 default HR_API.G_VARCHAR2
  ,p_description                   in     varchar2 default HR_API.G_VARCHAR2
  ,p_object_version_number         in out nocopy number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                  varchar2(72) := g_package||'CREATE_DOCUMENT';

Line: 227

  select
	party_id,
	assignment_id,
	person_id
  from	irc_documents
  where	document_id = p_document_id;

Line: 241

  savepoint UPDATE_DOCUMENT;

Line: 262

    IRC_DOCUMENT_BK2.UPDATE_DOCUMENT_b
    (p_effective_date                => l_effective_date
    ,p_document_id                   => p_document_id
    ,p_type                          => p_type
    ,p_mime_type                     => p_mime_type
    ,p_file_name                     => p_file_name
    ,p_description                   => p_description
    ,p_object_version_number         => p_object_version_number
    );

Line: 275

        (p_module_name => 'UPDATE_DOCUMENT'
        ,p_hook_type   => 'BP'
        );

Line: 283

    update_document_track
    ( p_validate		=> 	p_validate
     ,p_effective_date		=>	l_effective_date
     ,p_document_id		=>	p_document_id
     ,p_mime_type		=>	p_mime_type
     ,p_type			=>	p_type
     ,p_file_name		=>	p_file_name
     ,p_description		=>	p_description
     ,p_person_id		=>	l_person_id
     ,p_party_id		=>	l_party_id
     ,p_end_date		=>	l_end_date
     ,p_assignment_id		=>	l_assignment_id
     ,p_object_version_number	=>	l_object_version_number
     ,p_new_doc_id		=>	l_new_doc_id
    );

Line: 303

    IRC_DOCUMENT_BK2.UPDATE_DOCUMENT_a
    (p_effective_date                => l_effective_date
    ,p_document_id                   => p_document_id
    ,p_type                          => p_type
    ,p_mime_type                     => p_mime_type
    ,p_file_name                     => p_file_name
    ,p_description                   => p_description
    ,p_object_version_number         => p_object_version_number
    );

Line: 316

        (p_module_name => 'UPDATE_DOCUMENT'
        ,p_hook_type   => 'AP'
        );

Line: 337

    rollback to UPDATE_DOCUMENT;

Line: 349

    rollback to UPDATE_DOCUMENT;

Line: 354

end UPDATE_DOCUMENT;

Line: 361

procedure UPDATE_DOCUMENT_TRACK
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_document_id                   in     number
  ,p_mime_type                     in     varchar2 default HR_API.G_VARCHAR2
  ,p_type                          in     varchar2 default HR_API.G_VARCHAR2
  ,p_file_name                     in     varchar2 default HR_API.G_VARCHAR2
  ,p_description                   in     varchar2 default HR_API.G_VARCHAR2
  ,p_person_id			   in     number   default HR_API.G_NUMBER
  ,p_party_id			   in	  number   default HR_API.G_NUMBER
  ,p_end_date			   in	  date	   default HR_API.G_DATE
  ,p_assignment_id		   in     number   default HR_API.G_NUMBER
  ,p_object_version_number         in out nocopy number
  ,p_new_doc_id			   out nocopy number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                  varchar2(72) := g_package||'UPDATE_DOCUMENT';

Line: 410

  begin --begin For update when it Is an Internet Applicant

	--The Applicant Is an Internet Applicant, so first update his existing Document record with an End
	--Date And Then create a new Document record with the new Resume he has uploaded
	begin	--begin For updating End Date And creating new Document record
	  --
		  -- Issue a savepoint
		  --
		  savepoint UPDATE_DOCUMENT_TRACK;

Line: 431

		    IRC_DOCUMENT_BK4.UPDATE_DOCUMENT_TRACK_b
		    (p_effective_date                => l_effective_date
		    ,p_document_id                   => p_document_id
		    ,p_type                          => p_type
		    ,p_mime_type                     => p_mime_type
		    ,p_file_name                     => p_file_name
		    ,p_description                   => p_description
		    ,p_person_id		     => p_person_id
		    ,p_party_id			     => p_party_id
		    ,p_assignment_id		     => p_assignment_id
		    ,p_object_version_number         => p_object_version_number
		    ,p_end_date			     => l_end_date
		    );

Line: 448

			(p_module_name => 'UPDATE_DOCUMENT_TRACK'
			,p_hook_type   => 'BP'
			);

Line: 470

		    IRC_DOCUMENT_BK4.UPDATE_DOCUMENT_TRACK_a
		    (p_effective_date                => l_effective_date
		    ,p_document_id                   => p_document_id
		    ,p_type                          => p_type
		    ,p_mime_type                     => p_mime_type
		    ,p_file_name                     => p_file_name
		    ,p_description                   => p_description
		    ,p_person_id		     => p_person_id
		    ,p_party_id			     => p_party_id
		    ,p_assignment_id		     => p_assignment_id
		    ,p_object_version_number         => p_object_version_number
		    ,p_end_date			     => l_end_date
		    );

Line: 487

			(p_module_name => 'UPDATE_DOCUMENT_TRACK'
			,p_hook_type   => 'AP'
			);

Line: 493

		  --Select the Document id from the db sequence
		  --
		  begin
			select irc_documents_s.nextval
			into	l_new_doc_id
			from	dual;

Line: 543

		    rollback to UPDATE_DOCUMENT_TRACK;

Line: 556

		    rollback to UPDATE_DOCUMENT_TRACK;

Line: 573

		  savepoint UPDATE_DOCUMENT_TRACK;

Line: 583

		    IRC_DOCUMENT_BK4.UPDATE_DOCUMENT_TRACK_b
		    (p_effective_date                => l_effective_date
		    ,p_document_id                   => p_document_id
		    ,p_type                          => p_type
		    ,p_mime_type                     => p_mime_type
		    ,p_file_name                     => p_file_name
		    ,p_description                   => p_description
		    ,p_person_id		     => p_person_id
		    ,p_party_id			     => p_party_id
		    ,p_assignment_id		     => p_assignment_id
		    ,p_object_version_number         => p_object_version_number
		    ,p_end_date			     => p_end_date
		    );

Line: 600

			(p_module_name => 'UPDATE_DOCUMENT_TRACK'
			,p_hook_type   => 'BP'
			);

Line: 622

		    IRC_DOCUMENT_BK4.UPDATE_DOCUMENT_TRACK_a
		    (p_effective_date                => l_effective_date
		    ,p_document_id                   => p_document_id
		    ,p_type                          => p_type
		    ,p_mime_type                     => p_mime_type
		    ,p_file_name                     => p_file_name
		    ,p_description                   => p_description
		    ,p_person_id		     => p_person_id
		    ,p_party_id			     => p_party_id
		    ,p_assignment_id		     => p_assignment_id
		    ,p_object_version_number         => p_object_version_number
		    ,p_end_date			     => p_end_date
		    );

Line: 639

			(p_module_name => 'UPDATE_DOCUMENT_TRACK'
			,p_hook_type   => 'AP'
			);

Line: 661

		    rollback to UPDATE_DOCUMENT_TRACK;

Line: 674

		    rollback to UPDATE_DOCUMENT_TRACK;

Line: 686

end UPDATE_DOCUMENT_TRACK;

Line: 693

procedure DELETE_DOCUMENT
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_document_id                   in     number
  ,p_object_version_number         in     number
  ,p_person_id                     in     number
  ,p_party_id			   in	  number
  ,p_end_date			   in     date
  ,p_type                          in     varchar2
  ,p_purge			   in     varchar2 default 'N'
  ) is
  --
  -- Declare cursors and local variables
  --
  l_effective_date        date;

Line: 708

  l_proc                  varchar2(72) := g_package||'DELETE_DOCUMENT';

Line: 725

    savepoint DELETE_DOCUMENT;

Line: 754

			IRC_DOCUMENT_BK3.DELETE_DOCUMENT_b
			    (p_document_id                   => p_document_id
			    ,p_effective_date                => l_effective_date
			    ,p_object_version_number         => p_object_version_number
			    ,p_person_id		     => p_person_id
			    ,p_party_id			     => p_party_id
			    ,p_end_date			     => p_end_date
			    ,p_type                          => p_type
			    ,p_purge			     => p_purge
			    );

Line: 768

				(p_module_name => 'DELETE_DOCUMENT'
				,p_hook_type   => 'BP'
				);

Line: 780

			hr_utility.set_location('call update document: '||l_proc,113);

Line: 781

			--call the update document rowhandler to update the end_date for the document
			irc_ido_upd.upd
			(p_effective_date                => l_effective_date
			,p_type                          => p_type
			,p_document_id                   => p_document_id
			,p_object_version_number         => l_object_version_number
			,p_end_date			 => l_end_date
			);

Line: 807

			IRC_DOCUMENT_BK3.DELETE_DOCUMENT_a
				(p_document_id                   => p_document_id
				,p_effective_date                => l_effective_date
				,p_object_version_number         => p_object_version_number
				,p_person_id		     => p_person_id
				,p_party_id			     => p_party_id
				,p_end_date			     => p_end_date
				,p_type                         =>    p_type
				,p_purge			     => p_purge
				);

Line: 821

				(p_module_name => 'DELETE_DOCUMENT'
				,p_hook_type   => 'AP'
				);

Line: 839

		    rollback to DELETE_DOCUMENT;

Line: 845

		    rollback to DELETE_DOCUMENT;

Line: 850

end DELETE_DOCUMENT;

Line: 865

select rowid
from irc_documents
where document_id = p_document_id;

Line: 871

 select oracle_username
   from fnd_oracle_userid
  where oracle_id = 800;

Line: 904

      update irc_documents
      set character_doc = clob_doc
      where document_id = p_document_id;

Line: 948

select oracle_username
from fnd_oracle_userid
where oracle_id = 800;

Line: 953

select rowid
from irc_documents
where document_id = p_document_id;

Line: 957

select file_name
from irc_documents
where document_id = p_document_id;

Line: 1091

select	count(pasf.person_id)
from	per_all_people_f	paf,
	per_all_assignments_f	pasf
where
	paf.party_id	= p_party_id
and	trunc(sysdate)	between	paf.effective_start_date and paf.effective_end_date
and	trunc(sysdate)	between	pasf.effective_start_date and pasf.effective_end_date
and	pasf.person_id	= paf.person_id
and	pasf.business_group_id	in ( select bginfo.organization_id from hr_organization_information bginfo
				     where bginfo.ORG_INFORMATION_CONTEXT = 'BG Recruitment'
				     and bginfo.org_information11 = 'Y'
				    );