APPS.CZ_SESSION SQL Statements

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

Line: 35

procedure STAMP_STRUCT_UPDATED (for_project_id in NUMBER) is
begin
	update CZ_DEVL_PROJECTS
	set LAST_STRUCT_UPDATE = SYSDATE
	where DEVL_PROJECT_ID = for_project_id;

Line: 40

end STAMP_STRUCT_UPDATED;

Line: 42

procedure STAMP_LOGIC_UPDATED (for_project_id in NUMBER) is
begin
	update CZ_DEVL_PROJECTS
	set LAST_LOGIC_UPDATE = SYSDATE
	where DEVL_PROJECT_ID = for_project_id;

Line: 47

end STAMP_LOGIC_UPDATED;

Line: 49

procedure STAMP_PROJECT_UPDATED (for_project_id in NUMBER) is
begin
	update CZ_DEVL_PROJECTS
	set LAST_STRUCT_UPDATE = SYSDATE,
		LAST_LOGIC_UPDATE = SYSDATE
	where DEVL_PROJECT_ID = for_project_id;

Line: 55

end STAMP_PROJECT_UPDATED;