APPS.CS_SERVICEREQUEST_VERT_HOOKS SQL Statements

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

Line: 19

PROCEDURE update_servicerequest_post  (
  p_service_request_rec IN     CS_SERVICEREQUEST_PVT.service_request_rec_type,
  p_update_desc_flex    IN     VARCHAR2
) AS
BEGIN
	/* Customer to add the customization prcocedure here - for post processing */
	NULL;

Line: 26

END update_servicerequest_post;

Line: 28

PROCEDURE update_servicerequest_pre  (
  p_service_request_rec IN OUT CS_SERVICEREQUEST_PVT.service_request_rec_type,
  p_update_desc_flex    IN OUT VARCHAR2
) AS
BEGIN
	/* Customer to add the customization prcocedure here - for pre processing */
	NULL;

Line: 35

END update_servicerequest_pre;

Line: 37

PROCEDURE UPDATE_OWNER_POST  (
P_OWNER_ID			IN     NUMBER,
P_RESOURCE_TYPE			IN     VARCHAR2,
P_AUDIT_COMMENTS			IN     VARCHAR2,
P_CALLED_BY_WORKFLOW			IN     VARCHAR2,
P_WORKFLOW_PROCESS_ID			IN     NUMBER,
P_COMMENTS			IN     VARCHAR2,
P_PUBLIC_COMMENT_FLAG			IN     VARCHAR2
) AS
BEGIN
	/* Customer to add the customization prcocedure here - for post processing */
	NULL;

Line: 49

END UPDATE_OWNER_POST;

Line: 51

PROCEDURE UPDATE_OWNER_PRE  (
P_OWNER_ID			IN OUT     NUMBER,
P_RESOURCE_TYPE			IN OUT     VARCHAR2,
P_AUDIT_COMMENTS			IN OUT     VARCHAR2,
P_CALLED_BY_WORKFLOW			IN OUT     VARCHAR2,
P_WORKFLOW_PROCESS_ID			IN OUT     NUMBER,
P_COMMENTS			IN OUT     VARCHAR2,
P_PUBLIC_COMMENT_FLAG			IN OUT     VARCHAR2
) AS
BEGIN
	/* Customer to add the customization prcocedure here - for pre processing */
	NULL;

Line: 63

END UPDATE_OWNER_PRE;

Line: 65

PROCEDURE UPDATE_SEVERITY_POST  (
P_SEVERITY_ID			IN     NUMBER,
P_SEVERITY			IN     VARCHAR2,
P_AUDIT_COMMENTS			IN     VARCHAR2,
P_COMMENTS			IN     VARCHAR2,
P_PUBLIC_COMMENT_FLAG			IN     VARCHAR2
) AS
BEGIN
	/* Customer to add the customization prcocedure here - for post processing */
	NULL;

Line: 75

END UPDATE_SEVERITY_POST;

Line: 77

PROCEDURE UPDATE_SEVERITY_PRE  (
P_SEVERITY_ID			IN OUT     NUMBER,
P_SEVERITY			IN OUT     VARCHAR2,
P_AUDIT_COMMENTS			IN OUT     VARCHAR2,
P_COMMENTS			IN OUT     VARCHAR2,
P_PUBLIC_COMMENT_FLAG			IN OUT     VARCHAR2
) AS
BEGIN
	/* Customer to add the customization prcocedure here - for pre processing */
	NULL;

Line: 87

END UPDATE_SEVERITY_PRE;

Line: 89

PROCEDURE UPDATE_STATUS_POST  (
P_STATUS_ID			IN     NUMBER,
P_STATUS			IN     VARCHAR2,
P_CLOSED_DATE			IN     DATE,
P_AUDIT_COMMENTS			IN     VARCHAR2,
P_CALLED_BY_WORKFLOW			IN     VARCHAR2,
P_WORKFLOW_PROCESS_ID			IN     NUMBER,
P_COMMENTS			IN     VARCHAR2,
P_PUBLIC_COMMENT_FLAG			IN     VARCHAR2
) AS
BEGIN
	/* Customer to add the customization prcocedure here - for post processing */
	NULL;

Line: 102

END UPDATE_STATUS_POST;

Line: 104

PROCEDURE UPDATE_STATUS_PRE  (
P_STATUS_ID			IN OUT     NUMBER,
P_STATUS			IN OUT     VARCHAR2,
P_CLOSED_DATE			IN OUT     DATE,
P_AUDIT_COMMENTS			IN OUT     VARCHAR2,
P_CALLED_BY_WORKFLOW			IN OUT     VARCHAR2,
P_WORKFLOW_PROCESS_ID			IN OUT     NUMBER,
P_COMMENTS			IN OUT     VARCHAR2,
P_PUBLIC_COMMENT_FLAG			IN OUT     VARCHAR2
) AS
BEGIN
	/* Customer to add the customization prcocedure here - for pre processing */
	NULL;

Line: 117

END UPDATE_STATUS_PRE;

Line: 119

PROCEDURE UPDATE_URGENCY_POST  (
P_URGENCY_ID			IN     NUMBER,
P_URGENCY			IN     VARCHAR2,
P_AUDIT_COMMENTS			IN     VARCHAR2,
P_COMMENTS			IN     VARCHAR2,
P_PUBLIC_COMMENT_FLAG			IN     VARCHAR2
) AS
BEGIN
	/* Customer to add the customization prcocedure here - for post processing */
	NULL;

Line: 129

END UPDATE_URGENCY_POST;

Line: 131

PROCEDURE UPDATE_URGENCY_PRE  (
P_URGENCY_ID			IN OUT     NUMBER,
P_URGENCY			IN OUT     VARCHAR2,
P_AUDIT_COMMENTS			IN OUT     VARCHAR2,
P_COMMENTS			IN OUT     VARCHAR2,
P_PUBLIC_COMMENT_FLAG			IN OUT     VARCHAR2
) AS
BEGIN
	/* Customer to add the customization prcocedure here - for pre processing */
	NULL;

Line: 141

END UPDATE_URGENCY_PRE;