APPS.GMS_OVERRIDE_SCHEDULES_PKG SQL Statements

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

Line: 4

PROCEDURE Insert_Row(p_rowid          		IN OUT NOCOPY 		VARCHAR2,
		     p_award_id       		IN		NUMBER,
		     p_project_id 		IN		NUMBER,
                     p_task_id    		IN		NUMBER,
                     p_idc_schedule_id  	IN		NUMBER,
                     p_cost_ind_sch_fixed_date 	IN  		DATE,
 		     p_mode 			IN		VARCHAR2 default 'R') IS
  CURSOR 	get_rowid IS
  SELECT 	rowid
  FROM 		GMS_OVERRIDE_SCHEDULES
  WHERE 	award_id = p_award_id
  AND		project_id = p_project_id
  AND 		(task_id = p_task_id
  OR 		(task_id is NULL AND p_task_id is NULL));

Line: 19

  l_last_update_date	DATE;

Line: 20

  l_last_updated_by	NUMBER;

Line: 21

  l_last_update_login	NUMBER;

Line: 23

  l_last_update_date := SYSDATE;

Line: 25

  	l_last_updated_by := 1;

Line: 26

	l_last_update_login := 0;

Line: 28

	l_last_updated_by := FND_GLOBAL.USER_ID;

Line: 29

	IF (l_last_updated_by is NULL) THEN
      		l_last_updated_by := -1;

Line: 32

	l_last_update_login :=FND_GLOBAL.LOGIN_ID;

Line: 33

	IF (l_last_update_login is NULL) THEN
      		l_last_update_login := -1;

Line: 41

  INSERT into GMS_OVERRIDE_SCHEDULES
	(award_id,
 	 project_id,
	 task_id,
	 idc_schedule_id,
	 cost_ind_sch_fixed_date,
 	 creation_date,
	 created_by,
	 last_update_date,
	 last_updated_by,
	 last_update_login
	)
  VALUES
	(p_award_id,
	 p_project_id,
	 p_task_id,
	 p_idc_schedule_id,
	 p_cost_ind_sch_fixed_date,
	 l_last_update_date,
	 l_last_updated_by,
	 l_last_update_date,
	 l_last_updated_by,
	 l_last_update_login
	);

Line: 74

End insert_row;

Line: 77

PROCEDURE Update_Row(p_rowid          		IN 		VARCHAR2,
		     p_project_id 		IN		NUMBER,
		     p_task_id    		IN		NUMBER,
		     p_idc_schedule_id   	IN		NUMBER,
	  	     p_cost_ind_sch_fixed_date 	IN  		DATE,
		     p_mode			IN 		VARCHAR2 default 'R') IS
  l_last_update_date	DATE;

Line: 84

  l_last_updated_by	NUMBER;

Line: 85

  l_last_update_login	NUMBER;

Line: 87

  l_last_update_date := SYSDATE;

Line: 89

	l_last_updated_by := 1;

Line: 90

	l_last_update_login := 0;

Line: 92

	l_last_updated_by := FND_GLOBAL.USER_ID;

Line: 93

	IF (l_last_updated_by is NULL) THEN
      		l_last_updated_by := -1;

Line: 96

 	l_last_update_login :=FND_GLOBAL.LOGIN_ID;

Line: 97

	IF (l_last_update_login is NULL) THEN
		l_last_update_login := -1;

Line: 105

  UPDATE GMS_OVERRIDE_SCHEDULES
  SET	 project_id = p_project_id,
	 task_id =  p_task_id,
	 idc_schedule_id = p_idc_schedule_id,
	 cost_ind_sch_fixed_date =  p_cost_ind_sch_fixed_date,
	 last_update_date =  l_last_update_date,
	 last_updated_by = l_last_updated_by,
	 last_update_login = l_last_update_login
  WHERE rowid = p_rowid;

Line: 119

End update_row;

Line: 122

PROCEDURE Delete_Row(p_rowid             	IN 		VARCHAR2) IS
Begin
  DELETE	gms_override_schedules
  WHERE		rowid = p_rowid;

Line: 131

End delete_row;

Line: 140

  SELECT award_id, project_id, task_id, idc_schedule_id, cost_ind_sch_fixed_date
  FROM 	 GMS_OVERRIDE_SCHEDULES
  WHERE  rowid = p_rowid
  for update of idc_schedule_id, cost_ind_sch_fixed_date nowait;

Line: 152

	FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');