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.BIL_BI_UTIL_PKG dependencies on BIL_BI_UTIL_PKG

Line 1: PACKAGE BODY BIL_BI_UTIL_PKG AS

1: PACKAGE BODY BIL_BI_UTIL_PKG AS
2: /* $Header: bilbutb.pls 120.7 2005/11/21 01:46:56 hrpandey noship $ */
3:
4: g_pkg VARCHAR2(1000);
5:

Line 34: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';

30:
31:
32: BEGIN
33: /* Variable Intialization */
34: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';
35:
36: IF (p_log_level >= fnd_log.G_CURRENT_RUNTIME_LEVEL) THEN
37:
38: RETURN TRUE;

Line 88: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';

84: l_as_of_date DATE;
85:
86: BEGIN
87: /* Variable Intialization */
88: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';
89: l_parameter_valid := TRUE;
90:
91: -- if as_of_date is greater than sysdate, then pass sysdate
92: l_as_of_date:= p_as_of_date;

Line 163: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';

159: AS
160:
161: BEGIN
162: /* Variable Intialization */
163: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';
164:
165: SELECT current_date_id INTO x_curr_date FROM bis_system_date;
166:
167: EXCEPTION

Line 200: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';

196: AS
197:
198: BEGIN
199: /* Variable Intialization */
200: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';
201:
202:
203: IF (p_page_parameter_tbl.count > 0) THEN
204: FOR i IN p_page_parameter_tbl.first..p_page_parameter_tbl.last LOOP

Line 229: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';

225:
226: BEGIN
227:
228: /* Variable Intialization */
229: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';
230:
231: BEGIN
232: l_sg_id:= JTF_RS_DBI_CONC_PUB.GET_SG_ID();
233:

Line 278: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';

274: l_sg_id VARCHAR2(100);
275:
276: BEGIN
277: /* Variable Intialization */
278: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';
279:
280: BEGIN
281: l_sg_id:= JTF_RS_DBI_CONC_PUB.GET_SG_ID();
282:

Line 340: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';

336:
337:
338: BEGIN
339: /* Variable Intialization */
340: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';
341:
342: temp_sql:= 'SELECT null viewby';
343:
344:

Line 393: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';

389: x_FstCrdtType OUT NOCOPY VARCHAR2
390: ) AS
391: BEGIN
392: /* Variable Intialization */
393: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';
394:
395: -- IF(FND_PROFILE.Value('BIL_BI_ASN_IMPLEMENTED') = 'Y') THEN
396:
397: /*

Line 398: IF(BIL_BI_UTIL_PKG.GET_ASN_PROFILE = 'Y') THEN

394:
395: -- IF(FND_PROFILE.Value('BIL_BI_ASN_IMPLEMENTED') = 'Y') THEN
396:
397: /*
398: IF(BIL_BI_UTIL_PKG.GET_ASN_PROFILE = 'Y') THEN
399: x_FstCrdtType := FND_PROFILE.Value('ASN_FRCST_CREDIT_TYPE_ID');
400: ELSE
401: x_FstCrdtType := FND_PROFILE.Value('AS_FORECAST_CREDIT_TYPE_ID');
402: END IF;

Line 454: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';

450: )AS
451: l_curr_date DATE;
452: BEGIN
453: /* Variable Intialization */
454: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';
455:
456: x_bitand_id := 512;
457: x_calendar_id := -1;
458: x_fii_struct := 'FII_TIME_STRUCTURES';

Line 517: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';

513: l_proc VARCHAR2(50);
514:
515: BEGIN
516: /* Variable Intialization */
517: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';
518: l_proc := 'GET_LATEST_SNAP_DATE';
519: l_as_of_date := trunc(p_as_of_date);
520: l_yesterday := trunc(sysdate) - 1;
521: l_period_type := p_period_type;

Line 528: BIL_BI_UTIL_PKG.GET_CURR_START_DATE(p_page_parameter_tbl =>p_page_parameter_tbl,

524: IF p_as_of_date <> trunc(sysdate) THEN
525: x_snapshot_date := p_as_of_date;
526: ELSE
527: --get current start_date
528: BIL_BI_UTIL_PKG.GET_CURR_START_DATE(p_page_parameter_tbl =>p_page_parameter_tbl,
529: p_as_of_date => l_as_of_date,
530: p_period_type => l_period_type,
531: x_curr_start_date => l_start_date);
532:

Line 605: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';

601: ) AS
602:
603: BEGIN
604: /* Variable Intialization */
605: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';
606: x_DebugMode := FND_PROFILE.Value('BIS_PMF_DEBUG');
607:
608: EXCEPTION
609: WHEN OTHERS THEN

Line 664: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';

660: l_parent_sls_grp_id VARCHAR2(100);
661:
662: BEGIN
663: /* Variable Intialization */
664: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';
665: l_parameter_valid := True;
666: l_err_msg := 'Null parameter(s)';
667: l_err_desc := 'Please run with a valid ';
668: l_proc := ' GET.PAGE.PARAMS ';

Line 756: BIL_BI_UTIL_PKG.PARSE_SALES_GROUP_ID(

752: WHEN 'ORGANIZATION+JTF_ORG_SALES_GROUP' THEN
753:
754: l_salesgroup_id := p_page_parameter_tbl(i).parameter_id;
755:
756: BIL_BI_UTIL_PKG.PARSE_SALES_GROUP_ID(
757: p_salesgroup_id =>l_salesgroup_id,
758: x_resource_id =>l_resource_id);
759:
760: x_sg_id:= l_salesgroup_id;

Line 907: bil_bi_util_pkg.GET_CONV_RATE(p_as_of_date => l_as_of_date

903: l_err_desc := l_err_desc || ', PRIOR_AS_OF_DATE';
904: END IF;
905:
906:
907: bil_bi_util_pkg.GET_CONV_RATE(p_as_of_date => l_as_of_date
908: ,p_currency => l_currency
909: ,x_conv_rate_selected => l_conv_rate_selected
910: ,x_err_desc => l_err_desc
911: ,x_err_msg => l_err_msg

Line 943: BIL_BI_UTIL_PKG.GET_PARENT_SLS_GRP_ID(p_sales_grp_id => l_salesgroup_id,

939: END IF;
940:
941: END IF;
942:
943: BIL_BI_UTIL_PKG.GET_PARENT_SLS_GRP_ID(p_sales_grp_id => l_salesgroup_id,
944: x_parent_sls_grp_id => l_parent_sls_grp_id,
945: x_parameter_valid => l_parameter_valid);
946:
947:

Line 1040: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';

1036: l_parent_sls_grp_id NUMBER;
1037:
1038: BEGIN
1039:
1040: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';
1041: l_parameter_valid := TRUE;
1042:
1043: select parent_group_id
1044: into l_parent_sls_grp_id

Line 1095: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';

1091: l_product_where_clause VARCHAR2(1000);
1092: l_proc VARCHAR2(50);
1093: BEGIN
1094: /* Variable Intialization */
1095: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';
1096: l_denorm :=' ';
1097: l_product_where_clause := ' ';
1098: l_proc := 'get_Product_Where_Clause.';
1099:

Line 1193: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';

1189: l_product_where_clause VARCHAR2(1000);
1190: l_proc VARCHAR2(50);
1191: BEGIN
1192: /* Variable Intialization */
1193: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';
1194: l_denorm :=' ';
1195: l_product_where_clause := ' ';
1196: l_proc := 'get_Pipe_Product_Where_Clause.';
1197: IF 'ITEM+ENI_ITEM_VBH_CAT' = p_viewby THEN

Line 1288: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';

1284:
1285:
1286: BEGIN
1287: /* Variable Intialization */
1288: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';
1289:
1290: IF (p_page_parameter_tbl.count > 0) THEN
1291: FOR i IN p_page_parameter_tbl.first..p_page_parameter_tbl.last LOOP
1292:

Line 1473: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';

1469: l_isUserCurrency BOOLEAN;
1470:
1471: BEGIN
1472: /* Variable Intialization */
1473: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';
1474: l_isUserCurrency := FALSE;
1475:
1476: IF p_page_parameter_tbl IS NOT NULL THEN
1477:

Line 1515: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';

1511:
1512:
1513: BEGIN
1514: /* Variable Intialization */
1515: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';
1516:
1517: SELECT a.leaf_node_flag INTO leaf_node
1518: FROM ENI_DENORM_HIERARCHIES A,
1519: MTL_DEFAULT_CATEGORY_SETS B

Line 1583: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';

1579: l_dot NUMBER;
1580:
1581: BEGIN
1582: /* Variable Intialization */
1583: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';
1584:
1585: l_dot:= INSTR(p_salesgroup_id, '.');
1586: IF(l_dot > 0) then
1587: l_sg_id := SUBSTR(p_salesgroup_id,l_dot + 1) ;

Line 1619: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';

1615: l_cat_assign VARCHAR2(4000);
1616:
1617: BEGIN
1618: /* Variable Intialization */
1619: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';
1620:
1621: SELECT Meaning INTO l_cat_assign
1622: FROM FND_LOOKUP_VALUES
1623: WHERE LOOKUP_TYPE = p_lookuptype

Line 1672: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';

1668: l_proc VARCHAR2(50);
1669:
1670: BEGIN
1671:
1672: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';
1673: l_proc := 'get_prior_prior_time';
1674:
1675:
1676: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1865: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';

1861: l_proc VARCHAR2(50);
1862:
1863: BEGIN
1864:
1865: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';
1866: l_proc := 'GET_DRILL_LINKS';
1867:
1868:
1869: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1943: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';

1939: l_proc VARCHAR2(50);
1940:
1941: BEGIN
1942:
1943: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';
1944: l_proc := 'GET_LBL_SGFST';
1945:
1946: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1947:

Line 1961: BIL_BI_UTIL_PKG.PARSE_SALES_GROUP_ID(

1957: IF p_page_parameter_tbl(i).parameter_name = 'ORGANIZATION+JTF_ORG_SALES_GROUP' THEN
1958:
1959: l_salesgroup_id := p_page_parameter_tbl(i).parameter_id;
1960:
1961: BIL_BI_UTIL_PKG.PARSE_SALES_GROUP_ID(
1962: p_salesgroup_id =>l_salesgroup_id,
1963: x_resource_id =>l_resource_id);
1964: END IF;
1965: END LOOP;

Line 2036: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';

2032: l_coll_st_date := p_coll_st_date;
2033: l_coll_end_date := p_coll_end_date;
2034: l_period_type := p_period_type;
2035:
2036: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';
2037: l_proc := 'GET_PIPE_SNAP_DATE';
2038:
2039: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2040:

Line 2055: l_snapshot_date := BIL_BI_UTIL_PKG.GET_HIST_SNAPSHOT_DATE(l_as_of_date, p_period_type);

2051: ELSE
2052: IF(l_as_of_date >= l_coll_st_date) THEN
2053: l_snapshot_date := l_as_of_date;
2054: ELSE
2055: l_snapshot_date := BIL_BI_UTIL_PKG.GET_HIST_SNAPSHOT_DATE(l_as_of_date, p_period_type);
2056: END IF;
2057: END IF;
2058: */
2059:

Line 2066: l_snapshot_date := BIL_BI_UTIL_PKG.GET_HIST_SNAPSHOT_DATE(l_as_of_date, p_period_type);

2062: l_snapshot_date := l_as_of_date;
2063:
2064: IF(l_as_of_date < l_coll_st_date) THEN
2065:
2066: l_snapshot_date := BIL_BI_UTIL_PKG.GET_HIST_SNAPSHOT_DATE(l_as_of_date, p_period_type);
2067:
2068: IF p_prev_date IS NOT NULL THEN
2069: l_prev_snap_date := BIL_BI_UTIL_PKG.GET_HIST_SNAPSHOT_DATE(p_prev_date, p_period_type);
2070: END IF;

Line 2069: l_prev_snap_date := BIL_BI_UTIL_PKG.GET_HIST_SNAPSHOT_DATE(p_prev_date, p_period_type);

2065:
2066: l_snapshot_date := BIL_BI_UTIL_PKG.GET_HIST_SNAPSHOT_DATE(l_as_of_date, p_period_type);
2067:
2068: IF p_prev_date IS NOT NULL THEN
2069: l_prev_snap_date := BIL_BI_UTIL_PKG.GET_HIST_SNAPSHOT_DATE(p_prev_date, p_period_type);
2070: END IF;
2071: END IF;
2072:
2073: ELSE --- (l_as_of_date = sysdate)

Line 2075: BIL_BI_UTIL_PKG.GET_CURR_START_DATE(p_page_parameter_tbl =>p_page_parameter_tbl,

2071: END IF;
2072:
2073: ELSE --- (l_as_of_date = sysdate)
2074:
2075: BIL_BI_UTIL_PKG.GET_CURR_START_DATE(p_page_parameter_tbl =>p_page_parameter_tbl,
2076: p_as_of_date => l_as_of_date,
2077: p_period_type => l_period_type,
2078: x_curr_start_date => l_period_start_date);
2079:

Line 2095: -- l_prev_snap_date := BIL_BI_UTIL_PKG.GET_HIST_SNAPSHOT_DATE(p_prev_date, p_period_type);

2091: l_snapshot_date := l_as_of_date;
2092: END IF;
2093: END IF;
2094:
2095: -- l_prev_snap_date := BIL_BI_UTIL_PKG.GET_HIST_SNAPSHOT_DATE(p_prev_date, p_period_type);
2096:
2097:
2098: x_snap_date := l_snapshot_date;
2099: x_prev_snap_date := l_prev_snap_date;

Line 2158: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';

2154:
2155:
2156: BEGIN
2157:
2158: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';
2159: l_proc := 'GET_PIPE_MV';
2160: l_as_of_date := trunc(p_asof_date);
2161: l_period_type := p_period_type ;
2162:

Line 2214: BIL_BI_UTIL_PKG.GET_PIPE_SNAP_DATE( p_as_of_date => l_as_of_date

2210: l_pipe_mv := 'BIL_BI_PIPE_G_MV';
2211: END IF;
2212:
2213:
2214: BIL_BI_UTIL_PKG.GET_PIPE_SNAP_DATE( p_as_of_date => l_as_of_date
2215: ,p_prev_date => p_prev_date
2216: ,p_period_type => l_period_type
2217: ,p_coll_st_date => l_coll_st_date
2218: ,p_coll_end_date => l_coll_end_date

Line 2283: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';

2279: l_proc VARCHAR2(1000);
2280:
2281: BEGIN
2282:
2283: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';
2284: l_proc := 'GET_HIST_SNAPSHOT_DATE';
2285:
2286: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2287:

Line 2385: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';

2381: l_proc VARCHAR2(1000);
2382:
2383: BEGIN
2384:
2385: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';
2386: l_proc := 'GET_PIPE_COL_NAMES';
2387:
2388: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2389:

Line 2520: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';

2516: l_sysdate DATE:= TRUNC(sysdate);
2517:
2518: BEGIN
2519:
2520: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';
2521: l_proc := 'GET_PIPE_TREND_SOURCE';
2522:
2523: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2524:

Line 2589: BIL_BI_UTIL_PKG.GET_PIPE_SNAP_DATE(p_as_of_date => l_as_of_date

2585: END IF;
2586: */
2587: --to get snapshot date
2588:
2589: BIL_BI_UTIL_PKG.GET_PIPE_SNAP_DATE(p_as_of_date => l_as_of_date
2590: ,p_prev_date => p_prev_date
2591: ,p_period_type => p_period_type
2592: ,p_coll_st_date => l_coll_st_date
2593: ,p_coll_end_date => l_coll_end_date

Line 2600: l_prev_snap_date := BIL_BI_UTIL_PKG.GET_HIST_SNAPSHOT_DATE(p_prev_date, p_period_type);

2596: ,x_prev_snap_date => l_prev_snap_date);
2597:
2598: IF (p_prev_date IS NOT NULL AND l_prev_snap_date IS NULL) THEN
2599:
2600: l_prev_snap_date := BIL_BI_UTIL_PKG.GET_HIST_SNAPSHOT_DATE(p_prev_date, p_period_type);
2601:
2602: END IF;
2603:
2604: x_pipe_mv := l_pipe_mv;

Line 2642: END BIL_BI_UTIL_PKG;

2638: END IF;
2639:
2640: END GET_PIPE_TREND_SOURCE;
2641:
2642: END BIL_BI_UTIL_PKG;