eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POA_DBI_UTIL_PKG dependencies on POA_DBI_UTIL_PKG

Line 1: PACKAGE BODY poa_dbi_util_pkg AS

1: PACKAGE BODY poa_dbi_util_pkg AS
2: /* $Header: poadbiutilb.pls 120.4 2006/09/04 13:21:53 sriswami noship $ */
3:
4: g_employee_id NUMBER := -1;
5:

Line 355: p_nested_pattern := poa_dbi_util_pkg.get_nested_pattern(p_xtd);

351: end if;
352:
353: if(p_as_of_date is null) then p_as_of_date := sysdate; end if;
354: p_prev_as_of_date := poa_dbi_calendar_pkg.previous_period_asof_date(p_as_of_date, p_xtd, p_comparison_type);
355: p_nested_pattern := poa_dbi_util_pkg.get_nested_pattern(p_xtd);
356:
357: if(p_comparison_type is null) then p_comparison_type := 'S'; end if;
358:
359: if(l_currency = '''FII_GLOBAL1''') then

Line 454: , p_col_tbl in out nocopy poa_DBI_UTIL_PKG.poa_dbi_col_tbl

450: can be used for the outer bucket query
451: */
452: procedure add_bucket_columns
453: (p_short_name in varchar2
454: , p_col_tbl in out nocopy poa_DBI_UTIL_PKG.poa_dbi_col_tbl
455: , p_col_name in varchar2
456: , p_alias_name in varchar2
457: , x_bucket_rec out nocopy bis_bucket_pub.bis_bucket_rec_type
458: , p_grand_total in varchar2 := 'Y'

Line 475: poa_DBI_UTIL_PKG.add_column

471: , x_error_tbl => l_error_tbl
472: );
473: if l_return_status = 'S' then
474: if l_bucket_rec.range1_name is not null then
475: poa_DBI_UTIL_PKG.add_column
476: ( p_col_tbl => p_col_tbl
477: , p_col_name => p_col_name || '_b1'
478: , p_alias_name => p_alias_name || '_b1'
479: , p_grand_total => p_grand_total

Line 485: poa_DBI_UTIL_PKG.add_column

481: , p_prior_code => p_prior_code
482: );
483: end if;
484: if l_bucket_rec.range2_name is not null then
485: poa_DBI_UTIL_PKG.add_column
486: ( p_col_tbl => p_col_tbl
487: , p_col_name => p_col_name || '_b2'
488: , p_alias_name => p_alias_name || '_b2'
489: , p_grand_total => p_grand_total

Line 495: poa_DBI_UTIL_PKG.add_column

491: , p_prior_code => p_prior_code
492: );
493: end if;
494: if l_bucket_rec.range3_name is not null then
495: poa_DBI_UTIL_PKG.add_column
496: ( p_col_tbl => p_col_tbl
497: , p_col_name => p_col_name || '_b3'
498: , p_alias_name => p_alias_name || '_b3'
499: , p_grand_total => p_grand_total

Line 505: poa_DBI_UTIL_PKG.add_column

501: , p_prior_code => p_prior_code
502: );
503: end if;
504: if l_bucket_rec.range4_name is not null then
505: poa_DBI_UTIL_PKG.add_column
506: ( p_col_tbl => p_col_tbl
507: , p_col_name => p_col_name || '_b4'
508: , p_alias_name => p_alias_name || '_b4'
509: , p_grand_total => p_grand_total

Line 515: poa_DBI_UTIL_PKG.add_column

511: , p_prior_code => p_prior_code
512: );
513: end if;
514: if l_bucket_rec.range5_name is not null then
515: poa_DBI_UTIL_PKG.add_column
516: ( p_col_tbl => p_col_tbl
517: , p_col_name => p_col_name || '_b5'
518: , p_alias_name => p_alias_name || '_b5'
519: , p_grand_total => p_grand_total

Line 525: poa_DBI_UTIL_PKG.add_column

521: , p_prior_code => p_prior_code
522: );
523: end if;
524: if l_bucket_rec.range6_name is not null then
525: poa_DBI_UTIL_PKG.add_column
526: ( p_col_tbl => p_col_tbl
527: , p_col_name => p_col_name || '_b6'
528: , p_alias_name => p_alias_name || '_b6'
529: , p_grand_total => p_grand_total

Line 535: poa_DBI_UTIL_PKG.add_column

531: , p_prior_code => p_prior_code
532: );
533: end if;
534: if l_bucket_rec.range7_name is not null then
535: poa_DBI_UTIL_PKG.add_column
536: ( p_col_tbl => p_col_tbl
537: , p_col_name => p_col_name || '_b7'
538: , p_alias_name => p_alias_name || '_b7'
539: , p_grand_total => p_grand_total

Line 545: poa_DBI_UTIL_PKG.add_column

541: , p_prior_code => p_prior_code
542: );
543: end if;
544: if l_bucket_rec.range8_name is not null then
545: poa_DBI_UTIL_PKG.add_column
546: ( p_col_tbl => p_col_tbl
547: , p_col_name => p_col_name || '_b8'
548: , p_alias_name => p_alias_name || '_b8'
549: , p_grand_total => p_grand_total

Line 555: poa_DBI_UTIL_PKG.add_column

551: , p_prior_code => p_prior_code
552: );
553: end if;
554: if l_bucket_rec.range9_name is not null then
555: poa_DBI_UTIL_PKG.add_column
556: ( p_col_tbl => p_col_tbl
557: , p_col_name => p_col_name || '_b9'
558: , p_alias_name => p_alias_name || '_b9'
559: , p_grand_total => p_grand_total

Line 565: poa_DBI_UTIL_PKG.add_column

561: , p_prior_code => p_prior_code
562: );
563: end if;
564: if l_bucket_rec.range10_name is not null then
565: poa_DBI_UTIL_PKG.add_column
566: ( p_col_tbl => p_col_tbl
567: , p_col_name => p_col_name || '_b10'
568: , p_alias_name => p_alias_name || '_b10'
569: , p_grand_total => p_grand_total

Line 921: IF poa_dbi_util_pkg.get_sec_profile <> -1 THEN

917: p_ou_value = '' or
918: p_ou_value = '''''' or
919: p_ou_value = 'All') THEN
920: --Begin MOAC changes
921: IF poa_dbi_util_pkg.get_sec_profile <> -1 THEN
922: --End MOAC changes
923: /* l_in_sec_where_clause :=
924: ' and fact.' || p_ou_fact_col || ' = orgl.organization_id
925: and orgl.security_profile_id = '; */

Line 935: l_in_sec_where_clause := l_in_sec_where_clause || poa_dbi_util_pkg.get_sec_profile || ')';

931:
932: if(p_use_bind = 'Y') then
933: l_in_sec_where_clause := l_in_sec_where_clause || '&SEC_ID ' || ')';
934: else
935: l_in_sec_where_clause := l_in_sec_where_clause || poa_dbi_util_pkg.get_sec_profile || ')';
936: end if;
937: --Begin MOAC changes
938: ELSE
939: IF (p_use_bind = 'Y') THEN

Line 942: l_in_sec_where_clause := ' and fact.org_id = ' || poa_dbi_util_pkg.get_ou_org_id ;

938: ELSE
939: IF (p_use_bind = 'Y') THEN
940: l_in_sec_where_clause := ' and fact.org_id = ' ||'&ORG_ID ';
941: ELSE
942: l_in_sec_where_clause := ' and fact.org_id = ' || poa_dbi_util_pkg.get_ou_org_id ;
943: END IF ;
944: END IF ; ---poa_dbi_util_pkg.get_sec_profile <> -1
945: --End MOAC changes
946: end if;

Line 944: END IF ; ---poa_dbi_util_pkg.get_sec_profile <> -1

940: l_in_sec_where_clause := ' and fact.org_id = ' ||'&ORG_ID ';
941: ELSE
942: l_in_sec_where_clause := ' and fact.org_id = ' || poa_dbi_util_pkg.get_ou_org_id ;
943: END IF ;
944: END IF ; ---poa_dbi_util_pkg.get_sec_profile <> -1
945: --End MOAC changes
946: end if;
947: return l_in_sec_where_clause;
948:

Line 1039: l_custom_rec.attribute_value := poa_dbi_util_pkg.get_sec_profile;

1035: x_custom_output.EXTEND;
1036: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
1037:
1038: l_custom_rec.attribute_name := '&SEC_ID';
1039: l_custom_rec.attribute_value := poa_dbi_util_pkg.get_sec_profile;
1040: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1041: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1042: x_custom_output.EXTEND;
1043: x_custom_output(x_custom_output.COUNT) := l_custom_rec;

Line 1046: l_custom_rec.attribute_value := poa_dbi_util_pkg.get_fnd_user_profile;

1042: x_custom_output.EXTEND;
1043: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
1044:
1045: l_custom_rec.attribute_name := '&FND_USER_ID';
1046: l_custom_rec.attribute_value := poa_dbi_util_pkg.get_fnd_user_profile;
1047: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1048: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1049: x_custom_output.EXTEND;
1050: x_custom_output(x_custom_output.COUNT) := l_custom_rec;

Line 1053: l_custom_rec.attribute_value := poa_dbi_util_pkg.get_fnd_employee_profile;

1049: x_custom_output.EXTEND;
1050: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
1051:
1052: l_custom_rec.attribute_name := '&FND_EMPLOYEE_ID';
1053: l_custom_rec.attribute_value := poa_dbi_util_pkg.get_fnd_employee_profile;
1054: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1055: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1056: x_custom_output.EXTEND;
1057: x_custom_output(x_custom_output.COUNT) := l_custom_rec;

Line 1061: l_custom_rec.attribute_value := poa_dbi_util_pkg.get_ou_org_id;

1057: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
1058:
1059: ---Begin MOAC changes
1060: l_custom_rec.attribute_name := '&ORG_ID';
1061: l_custom_rec.attribute_value := poa_dbi_util_pkg.get_ou_org_id;
1062: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1063: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1064: x_custom_output.EXTEND;
1065: x_custom_output(x_custom_output.COUNT) := l_custom_rec;

Line 1152: l_custom_rec.attribute_value := poa_dbi_util_pkg.get_sec_profile;

1148:
1149: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1150:
1151: l_custom_rec.attribute_name := '&SEC_ID';
1152: l_custom_rec.attribute_value := poa_dbi_util_pkg.get_sec_profile;
1153: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1154: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1155: x_custom_output.EXTEND;
1156: x_custom_output(x_custom_output.COUNT) := l_custom_rec;

Line 1159: l_custom_rec.attribute_value := poa_dbi_util_pkg.get_fnd_user_profile;

1155: x_custom_output.EXTEND;
1156: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
1157:
1158: l_custom_rec.attribute_name := '&FND_USER_ID';
1159: l_custom_rec.attribute_value := poa_dbi_util_pkg.get_fnd_user_profile;
1160: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1161: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1162: x_custom_output.EXTEND;
1163: x_custom_output(x_custom_output.COUNT) := l_custom_rec;

Line 1166: l_custom_rec.attribute_value := poa_dbi_util_pkg.get_fnd_employee_profile;

1162: x_custom_output.EXTEND;
1163: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
1164:
1165: l_custom_rec.attribute_name := '&FND_EMPLOYEE_ID';
1166: l_custom_rec.attribute_value := poa_dbi_util_pkg.get_fnd_employee_profile;
1167: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1168: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1169: x_custom_output.EXTEND;
1170: x_custom_output(x_custom_output.COUNT) := l_custom_rec;

Line 1174: l_custom_rec.attribute_value := poa_dbi_util_pkg.get_ou_org_id;

1170: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
1171:
1172: ---Begin MOAC changes
1173: l_custom_rec.attribute_name := '&ORG_ID';
1174: l_custom_rec.attribute_value := poa_dbi_util_pkg.get_ou_org_id;
1175: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1176: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1177: x_custom_output.EXTEND;
1178: x_custom_output(x_custom_output.COUNT) := l_custom_rec;

Line 1494: END poa_dbi_util_pkg;

1490:
1491: ---End Changes for spend trend graph
1492:
1493:
1494: END poa_dbi_util_pkg;