APPS.PSP_TEMPLATE_DETAILS_API SQL Statements

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

Line: 176

procedure Update_TEMPLATE_DETAILS
  (   P_VALIDATE                      in     boolean  default false
	, P_TEMPLATE_ID                     in        NUMBER
	, P_CRITERIA_LOOKUP_TYPE            in        VARCHAR2
	, P_CRITERIA_LOOKUP_CODE            in        VARCHAR2
	, P_INCLUDE_EXCLUDE_FLAG            in        VARCHAR2
	, P_CRITERIA_VALUE1                 in        VARCHAR2
	, P_CRITERIA_VALUE2                 in        VARCHAR2
	, P_CRITERIA_VALUE3                 in        VARCHAR2
    , P_TEMPLATE_DETAIL_ID            in out nocopy      NUMBER
   , P_OBJECT_VERSION_NUMBER       in out nocopy      NUMBER
   , P_WARNING                     out nocopy      boolean
   , P_RETURN_STATUS               out nocopy      boolean
  ) is
  --
  -- Declare cursors and local variables
  --
  l_in_out_parameter    number;

Line: 195

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

Line: 201

  savepoint Update_TEMPLATE_DETAILS;

Line: 216

    PSP_TEMPLATE_DETAILS_BK2.Update_TEMPLATE_DETAILS_b
      (	  P_TEMPLATE_ID           	=>	P_TEMPLATE_ID
		, P_CRITERIA_LOOKUP_TYPE		=>	P_CRITERIA_LOOKUP_TYPE
		, P_CRITERIA_LOOKUP_CODE		=>	P_CRITERIA_LOOKUP_CODE
		, P_INCLUDE_EXCLUDE_FLAG		=>	P_INCLUDE_EXCLUDE_FLAG
		, P_CRITERIA_VALUE1     		=>	P_CRITERIA_VALUE1
		, P_CRITERIA_VALUE2     		=>	P_CRITERIA_VALUE2
		, P_CRITERIA_VALUE3     		=>	P_CRITERIA_VALUE3
		 , P_TEMPLATE_DETAIL_ID		    =>	P_TEMPLATE_DETAIL_ID
      );

Line: 229

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

Line: 260

    PSP_TEMPLATE_DETAILS_BK2.Update_TEMPLATE_DETAILS_a
      (	  P_TEMPLATE_ID            		=>	P_TEMPLATE_ID
		, P_CRITERIA_LOOKUP_TYPE   		=>	P_CRITERIA_LOOKUP_TYPE
		, P_CRITERIA_LOOKUP_CODE   		=>	P_CRITERIA_LOOKUP_CODE
		, P_INCLUDE_EXCLUDE_FLAG   		=>	P_INCLUDE_EXCLUDE_FLAG
		, P_CRITERIA_VALUE1        		=>	P_CRITERIA_VALUE1
		, P_CRITERIA_VALUE2        		=>	P_CRITERIA_VALUE2
		, P_CRITERIA_VALUE3        		=>	P_CRITERIA_VALUE3
		, P_TEMPLATE_DETAIL_ID     		=>	P_TEMPLATE_DETAIL_ID
		, P_OBJECT_VERSION_NUMBER		=>	P_OBJECT_VERSION_NUMBER
		, P_WARNING              		=>	P_WARNING
		, P_RETURN_STATUS        		=>	P_RETURN_STATUS
      );

Line: 276

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

Line: 301

    rollback to Update_TEMPLATE_DETAILS;

Line: 316

    rollback to Update_TEMPLATE_DETAILS;

Line: 327

end Update_TEMPLATE_DETAILS;

Line: 346

procedure Delete_TEMPLATE_DETAILS
  ( P_VALIDATE                       in     BOOLEAN default false
  , P_TEMPLATE_DETAIL_ID            in    NUMBER
  ,P_OBJECT_VERSION_NUMBER          in out nocopy number
  ,P_WARNING                       out nocopy varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_in_out_parameter    number;

Line: 357

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

Line: 363

  savepoint Delete_TEMPLATE_DETAILS;

Line: 378

    PSP_TEMPLATE_DETAILS_BK3.Delete_TEMPLATE_DETAILS_b
      (	P_TEMPLATE_DETAIL_ID   => P_TEMPLATE_DETAIL_ID
      );

Line: 384

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

Line: 409

    PSP_TEMPLATE_DETAILS_BK3.Delete_TEMPLATE_DETAILS_a
      (			P_TEMPLATE_DETAIL_ID       		=>	P_TEMPLATE_DETAIL_ID
		,P_OBJECT_VERSION_NUMBER 		=>	P_OBJECT_VERSION_NUMBER
		,P_WARNING               		=>	P_WARNING

      );

Line: 418

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

Line: 443

    rollback to Delete_TEMPLATE_DETAILS;

Line: 458

    rollback to Delete_TEMPLATE_DETAILS;

Line: 469

end Delete_TEMPLATE_DETAILS;