417: --when the last two bytes equal '='
418: IF( iPlusTwo = 64 ) THEN
419: x := iTh * 64 + iPlusOne;
420: x := floor(x/16);
421: v := v || fnd_global.local_chr( x );
422:
423: --when the last byte equals '='
424: ELSIF( iPlusThree = 64 ) THEN
425: x := iTh * 4096 + iPlusOne * 64 + iPlusTwo;
423: --when the last byte equals '='
424: ELSIF( iPlusThree = 64 ) THEN
425: x := iTh * 4096 + iPlusOne * 64 + iPlusTwo;
426: y := floor(x/1024);
427: v := v || fnd_global.local_chr( y );
428: x := x - y * 1024;
429: x := floor(x/4);
430: v := v || fnd_global.local_chr( x );
431:
426: y := floor(x/1024);
427: v := v || fnd_global.local_chr( y );
428: x := x - y * 1024;
429: x := floor(x/4);
430: v := v || fnd_global.local_chr( x );
431:
432: --when all the bytes hold values to be converted.
433: ELSE
434: x := iTh * 262144 + iPlusOne * 4096 + iPlusTwo * 64 + iPlusThree;
432: --when all the bytes hold values to be converted.
433: ELSE
434: x := iTh * 262144 + iPlusOne * 4096 + iPlusTwo * 64 + iPlusThree;
435: y := floor(x/65536);
436: v := v || fnd_global.local_chr( y );
437: x := x - y * 65536;
438: y := floor(x/256);
439: v := v || fnd_global.local_chr( y );
440: x := x - y * 256;
435: y := floor(x/65536);
436: v := v || fnd_global.local_chr( y );
437: x := x - y * 65536;
438: y := floor(x/256);
439: v := v || fnd_global.local_chr( y );
440: x := x - y * 256;
441: v := v || fnd_global.local_chr( x );
442: END IF;
443: i := i + 4;
437: x := x - y * 65536;
438: y := floor(x/256);
439: v := v || fnd_global.local_chr( y );
440: x := x - y * 256;
441: v := v || fnd_global.local_chr( x );
442: END IF;
443: i := i + 4;
444: END LOOP;
445:
590: INSERT INTO iby_view_parameters_gt
591: (name,value,created_by,creation_date,last_updated_by,last_update_date,
592: last_update_login,object_version_number)
593: VALUES
594: (p_name,p_val,fnd_global.user_id,sysdate,fnd_global.user_id,
595: sysdate,fnd_global.login_id,1);
596:
597: -- no commit, as data deleted at the end of the current
598: -- transaction
591: (name,value,created_by,creation_date,last_updated_by,last_update_date,
592: last_update_login,object_version_number)
593: VALUES
594: (p_name,p_val,fnd_global.user_id,sysdate,fnd_global.user_id,
595: sysdate,fnd_global.login_id,1);
596:
597: -- no commit, as data deleted at the end of the current
598: -- transaction
599: END set_view_param;