APPS.POA_DBI_UTIL_PKG dependencies on FND_GLOBAL

Line 235: l_fnd_user_profile := fnd_global.user_id;

231: l_fnd_user_profile NUMBER;
232:
233: BEGIN
234:
235: l_fnd_user_profile := fnd_global.user_id;
236:
237: return l_fnd_user_profile;
238:
239: END get_fnd_user_profile;

Line 244: return fnd_global.employee_id;

240:
241: Function get_fnd_employee_profile RETURN NUMBER
242: IS
243: BEGIN
244: return fnd_global.employee_id;
245: END get_fnd_employee_profile;
246:
247:
248: FUNCTION bitor(x in number,y in number) return number

Line 641: l_query := l_query || fnd_global.newline ||

637: l_query := get_bucket_clause(1, p_col_name, p_alias_name,
638: p_prefix, p_suffix, p_total_flag);
639: end if;
640: if p_bucket_rec.range2_name is not null then
641: l_query := l_query || fnd_global.newline ||
642: get_bucket_clause(2, p_col_name, p_alias_name,
643: p_prefix, p_suffix, p_total_flag);
644: end if;
645: if p_bucket_rec.range3_name is not null then

Line 646: l_query := l_query || fnd_global.newline ||

642: get_bucket_clause(2, p_col_name, p_alias_name,
643: p_prefix, p_suffix, p_total_flag);
644: end if;
645: if p_bucket_rec.range3_name is not null then
646: l_query := l_query || fnd_global.newline ||
647: get_bucket_clause(3, p_col_name, p_alias_name,
648: p_prefix, p_suffix, p_total_flag);
649:
650: end if;

Line 652: l_query := l_query || fnd_global.newline ||

648: p_prefix, p_suffix, p_total_flag);
649:
650: end if;
651: if p_bucket_rec.range4_name is not null then
652: l_query := l_query || fnd_global.newline ||
653: get_bucket_clause(4, p_col_name, p_alias_name,
654: p_prefix, p_suffix, p_total_flag);
655: end if;
656: if p_bucket_rec.range5_name is not null then

Line 657: l_query := l_query || fnd_global.newline ||

653: get_bucket_clause(4, p_col_name, p_alias_name,
654: p_prefix, p_suffix, p_total_flag);
655: end if;
656: if p_bucket_rec.range5_name is not null then
657: l_query := l_query || fnd_global.newline ||
658: get_bucket_clause(5, p_col_name, p_alias_name,
659: p_prefix, p_suffix, p_total_flag);
660: end if;
661: if p_bucket_rec.range6_name is not null then

Line 662: l_query := l_query || fnd_global.newline ||

658: get_bucket_clause(5, p_col_name, p_alias_name,
659: p_prefix, p_suffix, p_total_flag);
660: end if;
661: if p_bucket_rec.range6_name is not null then
662: l_query := l_query || fnd_global.newline ||
663: get_bucket_clause(6, p_col_name, p_alias_name,
664: p_prefix, p_suffix, p_total_flag);
665: end if;
666: if p_bucket_rec.range7_name is not null then

Line 667: l_query := l_query || fnd_global.newline ||

663: get_bucket_clause(6, p_col_name, p_alias_name,
664: p_prefix, p_suffix, p_total_flag);
665: end if;
666: if p_bucket_rec.range7_name is not null then
667: l_query := l_query || fnd_global.newline ||
668: get_bucket_clause(7, p_col_name, p_alias_name,
669: p_prefix, p_suffix, p_total_flag);
670: end if;
671: if p_bucket_rec.range8_name is not null then

Line 672: l_query := l_query || fnd_global.newline ||

668: get_bucket_clause(7, p_col_name, p_alias_name,
669: p_prefix, p_suffix, p_total_flag);
670: end if;
671: if p_bucket_rec.range8_name is not null then
672: l_query := l_query || fnd_global.newline ||
673: get_bucket_clause(8, p_col_name, p_alias_name,
674: p_prefix, p_suffix, p_total_flag);
675: end if;
676: if p_bucket_rec.range9_name is not null then

Line 677: l_query := l_query || fnd_global.newline ||

673: get_bucket_clause(8, p_col_name, p_alias_name,
674: p_prefix, p_suffix, p_total_flag);
675: end if;
676: if p_bucket_rec.range9_name is not null then
677: l_query := l_query || fnd_global.newline ||
678: get_bucket_clause(9, p_col_name, p_alias_name,
679: p_prefix, p_suffix, p_total_flag);
680: end if;
681: if p_bucket_rec.range10_name is not null then

Line 682: l_query := l_query || fnd_global.newline ||

678: get_bucket_clause(9, p_col_name, p_alias_name,
679: p_prefix, p_suffix, p_total_flag);
680: end if;
681: if p_bucket_rec.range10_name is not null then
682: l_query := l_query || fnd_global.newline ||
683: get_bucket_clause(10, p_col_name, p_alias_name,
684: p_prefix, p_suffix, p_total_flag);
685: end if;
686: return l_query;

Line 721: l_query := l_query || fnd_global.newline ||

717: l_query := get_bucket_url_clause(1, p_alias_name, p_prefix,
718: p_suffix, p_add_bucket_num);
719: end if;
720: if p_bucket_rec.range2_name is not null then
721: l_query := l_query || fnd_global.newline ||
722: get_bucket_url_clause(2, p_alias_name, p_prefix,
723: p_suffix, p_add_bucket_num);
724: end if;
725: if p_bucket_rec.range3_name is not null then

Line 726: l_query := l_query || fnd_global.newline ||

722: get_bucket_url_clause(2, p_alias_name, p_prefix,
723: p_suffix, p_add_bucket_num);
724: end if;
725: if p_bucket_rec.range3_name is not null then
726: l_query := l_query || fnd_global.newline ||
727: get_bucket_url_clause(3, p_alias_name, p_prefix,
728: p_suffix, p_add_bucket_num);
729: end if;
730: if p_bucket_rec.range4_name is not null then

Line 731: l_query := l_query || fnd_global.newline ||

727: get_bucket_url_clause(3, p_alias_name, p_prefix,
728: p_suffix, p_add_bucket_num);
729: end if;
730: if p_bucket_rec.range4_name is not null then
731: l_query := l_query || fnd_global.newline ||
732: get_bucket_url_clause(4, p_alias_name, p_prefix,
733: p_suffix, p_add_bucket_num);
734: end if;
735: if p_bucket_rec.range5_name is not null then

Line 736: l_query := l_query || fnd_global.newline ||

732: get_bucket_url_clause(4, p_alias_name, p_prefix,
733: p_suffix, p_add_bucket_num);
734: end if;
735: if p_bucket_rec.range5_name is not null then
736: l_query := l_query || fnd_global.newline ||
737: get_bucket_url_clause(5, p_alias_name, p_prefix,
738: p_suffix, p_add_bucket_num);
739: end if;
740: if p_bucket_rec.range6_name is not null then

Line 741: l_query := l_query || fnd_global.newline ||

737: get_bucket_url_clause(5, p_alias_name, p_prefix,
738: p_suffix, p_add_bucket_num);
739: end if;
740: if p_bucket_rec.range6_name is not null then
741: l_query := l_query || fnd_global.newline ||
742: get_bucket_url_clause(6, p_alias_name, p_prefix,
743: p_suffix, p_add_bucket_num);
744: end if;
745: if p_bucket_rec.range7_name is not null then

Line 746: l_query := l_query || fnd_global.newline ||

742: get_bucket_url_clause(6, p_alias_name, p_prefix,
743: p_suffix, p_add_bucket_num);
744: end if;
745: if p_bucket_rec.range7_name is not null then
746: l_query := l_query || fnd_global.newline ||
747: get_bucket_url_clause(7, p_alias_name, p_prefix,
748: p_suffix, p_add_bucket_num);
749: end if;
750: if p_bucket_rec.range8_name is not null then

Line 751: l_query := l_query || fnd_global.newline ||

747: get_bucket_url_clause(7, p_alias_name, p_prefix,
748: p_suffix, p_add_bucket_num);
749: end if;
750: if p_bucket_rec.range8_name is not null then
751: l_query := l_query || fnd_global.newline ||
752: get_bucket_url_clause(8, p_alias_name, p_prefix,
753: p_suffix, p_add_bucket_num);
754: end if;
755: if p_bucket_rec.range9_name is not null then

Line 756: l_query := l_query || fnd_global.newline ||

752: get_bucket_url_clause(8, p_alias_name, p_prefix,
753: p_suffix, p_add_bucket_num);
754: end if;
755: if p_bucket_rec.range9_name is not null then
756: l_query := l_query || fnd_global.newline ||
757: get_bucket_url_clause(9, p_alias_name, p_prefix,
758: p_suffix, p_add_bucket_num);
759: end if;
760: if p_bucket_rec.range10_name is not null then

Line 761: l_query := l_query || fnd_global.newline ||

757: get_bucket_url_clause(9, p_alias_name, p_prefix,
758: p_suffix, p_add_bucket_num);
759: end if;
760: if p_bucket_rec.range10_name is not null then
761: l_query := l_query || fnd_global.newline ||
762: get_bucket_url_clause(10, p_alias_name, p_prefix,
763: p_suffix, p_add_bucket_num);
764: end if;
765: return l_query;