APPS.AK_UPLOAD_GRP SQL Statements

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

Line: 5

  p_update_mode       IN   varchar2,
  p_return_status     OUT NOCOPY varchar2
  ) is

  l_api_name          VARCHAR2(30) := 'Upload';

Line: 32

  if (p_update_mode = 'UPDATE') then
    G_UPDATE_MODE := TRUE;

Line: 34

	-- update everything
	G_NO_CUSTOM_UPDATE := FALSE;

Line: 36

	G_COMPARE_UPDATE := FALSE;

Line: 37

  elsif (p_update_mode = 'NCUPDATE') then
	-- update non-customized data only
    G_NO_CUSTOM_UPDATE := TRUE;

Line: 40

	G_UPDATE_MODE := FALSE;

Line: 41

	G_COMPARE_UPDATE := TRUE;

Line: 42

  elsif (p_update_mode = 'NON_SEED_DATA') then
        -- update non-customized data only
    G_NO_CUSTOM_UPDATE := TRUE;

Line: 45

        G_UPDATE_MODE := FALSE;

Line: 46

        G_COMPARE_UPDATE := TRUE;

Line: 47

  elsif (p_update_mode = 'COMPAREUPDATE') then
	-- update everything, but compare date
	G_UPDATE_MODE := TRUE;

Line: 50

	G_NO_CUSTOM_UPDATE := FALSE;

Line: 51

	G_COMPARE_UPDATE := TRUE;

Line: 53

    G_UPDATE_MODE := FALSE;

Line: 54

	G_NO_CUSTOM_UPDATE := FALSE;

Line: 55

	G_COMPARE_UPDATE := FALSE;

Line: 78

        l_buffer_tbl(l_index) := 'All WHO columns, in records normally updated depending on update mode, will be updated with the information from the jlt file.';

Line: 94

  /** commit the inserts in ak_loader_temp that's done by akload **/
  commit;

Line: 98

  select sid into l_session_id
  from v$session
  where AUDSID = userenv('SESSIONID');