APPS.PSP_REPORT_TEMPLATE_API SQL Statements

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

Line: 39

   , P_SELECTION_MATCH_LEVEL         in		VARCHAR2
  ) is
  --
  -- Declare cursors and local variables
  --
--  l_in_out_parameter    number;

Line: 56

select distinct Template_Name
from   Psp_Report_Templates
where  Template_Name =  P_TEMPLATE_NAME
and    report_type = p_report_type ;

Line: 124

		,P_SELECTION_MATCH_LEVEL 		=>	P_SELECTION_MATCH_LEVEL
	);

Line: 164

		,P_SELECTION_MATCH_LEVEL 			=>	P_SELECTION_MATCH_LEVEL
     );

Line: 194

		,P_SELECTION_MATCH_LEVEL 			=>	P_SELECTION_MATCH_LEVEL
     );

Line: 259

procedure Update_Report_Template
  (P_VALIDATE                      in     boolean  default false
   , P_TEMPLATE_ID                 in     NUMBER
   , P_TEMPLATE_NAME               in      VARCHAR2
   , P_BUSINESS_GROUP_ID           in    NUMBER
   , P_SET_OF_BOOKS_ID             in    NUMBER
   , P_REPORT_TYPE                 in    VARCHAR2
   , P_PERIOD_FREQUENCY_ID         in    NUMBER
   , P_REPORT_TEMPLATE_CODE        in    VARCHAR2
   , P_DISPLAY_ALL_EMP_DISTRIB_FLAG in              VARCHAR2
   , P_MANUAL_ENTRY_OVERRIDE_FLAG  in              VARCHAR2
   , P_APPROVAL_TYPE               in              VARCHAR2
   , P_SUP_LEVELS                  in              NUMBER
   , P_PREVIEW_EFFORT_REPORT_FLAG  in    VARCHAR2
   , P_NOTIFICATION_REMINDER in             NUMBER
   , P_SPRCD_TOLERANCE_AMT           in            NUMBER
   , P_SPRCD_TOLERANCE_PERCENT       in            NUMBER
   , P_DESCRIPTION                   in            VARCHAR2
   , P_EGISLATION_CODE               in           VARCHAR2
   , P_OBJECT_VERSION_NUMBER       in out nocopy      NUMBER
   , P_WARNING                     out nocopy      boolean
   , P_RETURN_STATUS               out nocopy      boolean
    ,P_CUSTOM_APPROVAL_CODE	     in		VARCHAR2
   , P_HUNDRED_PCENT_EFF_AT_PER_ASG  in		VARCHAR2
   , P_SELECTION_MATCH_LEVEL         in		VARCHAR2
) is
  --
  -- Declare cursors and local variables
  --
  l_in_out_parameter    number;

Line: 296

  savepoint Update_Report_Template;

Line: 311

    PSP_Report_Template_BK2.Update_Report_Template_b

    (  	 	  P_TEMPLATE_ID                 		=>	P_TEMPLATE_ID
		, P_TEMPLATE_NAME               		=>	P_TEMPLATE_NAME
		, P_BUSINESS_GROUP_ID           		=>	P_BUSINESS_GROUP_ID
		, P_SET_OF_BOOKS_ID             		=>	P_SET_OF_BOOKS_ID
		, P_REPORT_TYPE                 		=>	P_REPORT_TYPE
		, P_PERIOD_FREQUENCY_ID         		=>	P_PERIOD_FREQUENCY_ID
		, P_REPORT_TEMPLATE_CODE        		=>	P_REPORT_TEMPLATE_CODE
		, P_DISPLAY_ALL_EMP_DISTRIB_FLAG		=>	P_DISPLAY_ALL_EMP_DISTRIB_FLAG
		, P_MANUAL_ENTRY_OVERRIDE_FLAG  		=>	P_MANUAL_ENTRY_OVERRIDE_FLAG
		, P_APPROVAL_TYPE               		=>	P_APPROVAL_TYPE
		, P_SUP_LEVELS                  		=>	P_SUP_LEVELS
		, P_PREVIEW_EFFORT_REPORT_FLAG  		=>	P_PREVIEW_EFFORT_REPORT_FLAG
		, P_NOTIFICATION_REMINDER			=>	P_NOTIFICATION_REMINDER
		, P_SPRCD_TOLERANCE_AMT         		=>	P_SPRCD_TOLERANCE_AMT
		, P_SPRCD_TOLERANCE_PERCENT     		=>	P_SPRCD_TOLERANCE_PERCENT
		, P_DESCRIPTION                 		=>	P_DESCRIPTION
		, P_EGISLATION_CODE             		=>	P_EGISLATION_CODE
		,P_CUSTOM_APPROVAL_CODE				=>	P_CUSTOM_APPROVAL_CODE
		,P_HUNDRED_PCENT_EFF_AT_PER_ASG 		=>	P_HUNDRED_PCENT_EFF_AT_PER_ASG
		,P_SELECTION_MATCH_LEVEL 			=>	P_SELECTION_MATCH_LEVEL
   );

Line: 337

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

Line: 371

		,P_SELECTION_MATCH_LEVEL 			=>	P_SELECTION_MATCH_LEVEL
        );

Line: 379

     PSP_Report_Template_BK2.Update_Report_Template_a
      (		  P_TEMPLATE_ID                 		=>	P_TEMPLATE_ID
		, P_TEMPLATE_NAME               		=>	P_TEMPLATE_NAME
		, P_BUSINESS_GROUP_ID           		=>	P_BUSINESS_GROUP_ID
		, P_SET_OF_BOOKS_ID             		=>	P_SET_OF_BOOKS_ID
		, P_REPORT_TYPE                 		=>	P_REPORT_TYPE
		, P_PERIOD_FREQUENCY_ID         		=>	P_PERIOD_FREQUENCY_ID
		, P_REPORT_TEMPLATE_CODE        		=>	P_REPORT_TEMPLATE_CODE
		, P_DISPLAY_ALL_EMP_DISTRIB_FLAG		=>	P_DISPLAY_ALL_EMP_DISTRIB_FLAG
		, P_MANUAL_ENTRY_OVERRIDE_FLAG  		=>	P_MANUAL_ENTRY_OVERRIDE_FLAG
		, P_APPROVAL_TYPE               		=>	P_APPROVAL_TYPE
		, P_SUP_LEVELS                  		=>	P_SUP_LEVELS
		, P_PREVIEW_EFFORT_REPORT_FLAG  		=>	P_PREVIEW_EFFORT_REPORT_FLAG
		, P_NOTIFICATION_REMINDER   			=>	P_NOTIFICATION_REMINDER
		, P_SPRCD_TOLERANCE_AMT         		=>	P_SPRCD_TOLERANCE_AMT
		, P_SPRCD_TOLERANCE_PERCENT     		=>	P_SPRCD_TOLERANCE_PERCENT
		, P_DESCRIPTION                 		=>	P_DESCRIPTION
		, P_EGISLATION_CODE             		=>	P_EGISLATION_CODE
		, P_OBJECT_VERSION_NUMBER       		=>	P_OBJECT_VERSION_NUMBER
		, P_WARNING                     		=>	P_WARNING
		, P_RETURN_STATUS               		=>	P_RETURN_STATUS
 		,P_CUSTOM_APPROVAL_CODE				=>	P_CUSTOM_APPROVAL_CODE
		,P_HUNDRED_PCENT_EFF_AT_PER_ASG 		=>	P_HUNDRED_PCENT_EFF_AT_PER_ASG
		,P_SELECTION_MATCH_LEVEL 			=>	P_SELECTION_MATCH_LEVEL
    );

Line: 407

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

Line: 432

    rollback to Update_Report_Template;

Line: 447

    rollback to Update_Report_Template;

Line: 458

end Update_Report_Template;

Line: 467

procedure Delete_Report_Template
  (  P_VALIDATE                       in     BOOLEAN default false
  ,P_TEMPLATE_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: 484

  savepoint Delete_Report_template;

Line: 499

    PSP_Report_Template_BK3.Delete_Report_template_b
    (  	 P_TEMPLATE_ID      	=>	P_TEMPLATE_ID
   );

Line: 505

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

Line: 530

     PSP_Report_Template_BK3.Delete_Report_template_a
      (	 P_TEMPLATE_ID                 		=>	 P_TEMPLATE_ID
		,P_OBJECT_VERSION_NUMBER     		=>	P_OBJECT_VERSION_NUMBER
		,P_WARNING                   		=>	P_WARNING

     );

Line: 539

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

Line: 564

    rollback to Delete_Report_template;

Line: 579

    rollback to Delete_Report_template;

Line: 590

end Delete_Report_template;