APPS.BIL_TX_OPTY_DETL_RPT_PKG dependencies on BIL_TX_UTIL_RPT_PKG

Line 42: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN

38: g_pkg := 'asn.patch.115.sql.BIL_TX_OPTY_DETL_RPT_PKG.';
39:
40:
41: -- FND logging standard
42: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
43:
44: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
45: p_module => g_pkg || l_proc || 'begin',
46: p_msg => 'Start of Procedure '|| l_proc );

Line 44: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

40:
41: -- FND logging standard
42: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
43:
44: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
45: p_module => g_pkg || l_proc || 'begin',
46: p_msg => 'Start of Procedure '|| l_proc );
47: END IF;
48:

Line 58: BIL_TX_UTIL_RPT_PKG.GET_DETAIL_PAGE_PARAMS

54: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
55:
56:
57: -- code for a procedure to get parameter values.
58: BIL_TX_UTIL_RPT_PKG.GET_DETAIL_PAGE_PARAMS
59: (p_page_parameter_tbl => p_page_parameter_tbl,
60: p_region_id => l_region_id,
61: x_parameter_valid => l_parameter_valid,
62: x_viewby => l_viewby,

Line 161: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

157:
158:
159: x_custom_sql := l_custom_sql ||l_where_clause ;
160:
161: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
162: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,
163: p_proc => l_proc,
164: p_query => x_custom_sql);
165: END IF;

Line 162: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,

158:
159: x_custom_sql := l_custom_sql ||l_where_clause ;
160:
161: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
162: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,
163: p_proc => l_proc,
164: p_query => x_custom_sql);
165: END IF;
166:

Line 248: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN

244: g_pkg := 'asn.patch.115.sql.BIL_TX_OPTY_DETL_RPT_PKG.';
245:
246:
247: -- FND logging standard
248: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
249:
250: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
251: p_module => g_pkg || l_proc || 'begin',
252: p_msg => 'Start of Procedure '|| l_proc );

Line 250: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

246:
247: -- FND logging standard
248: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
249:
250: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
251: p_module => g_pkg || l_proc || 'begin',
252: p_msg => 'Start of Procedure '|| l_proc );
253: END IF;
254:

Line 261: BIL_TX_UTIL_RPT_PKG.GET_DETAIL_PAGE_PARAMS

257: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
258:
259:
260: -- code for a procedure to get parameter values.
261: BIL_TX_UTIL_RPT_PKG.GET_DETAIL_PAGE_PARAMS
262: (p_page_parameter_tbl => p_page_parameter_tbl,
263: p_region_id => l_region_id,
264: x_parameter_valid => l_parameter_valid,
265: x_viewby => l_viewby,

Line 327: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

323: -- x_custom_sql := l_custom_sql||l_where_clause ;
324:
325: x_custom_sql := l_custom_sql;
326:
327: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
328: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,
329: p_proc => l_proc,
330: p_query => x_custom_sql);
331: END IF;

Line 328: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,

324:
325: x_custom_sql := l_custom_sql;
326:
327: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
328: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,
329: p_proc => l_proc,
330: p_query => x_custom_sql);
331: END IF;
332:

Line 410: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN

406: l_conversion_type := nvl(FND_PROFILE.VALUE('CRMBIS:GL_CONVERSION_TYPE'), 'Corporate');
407:
408:
409: -- FND logging standard
410: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
411:
412: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
413: p_module => g_pkg || l_proc || 'begin',
414: p_msg => 'Start of Procedure '|| l_proc );

Line 412: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

408:
409: -- FND logging standard
410: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
411:
412: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
413: p_module => g_pkg || l_proc || 'begin',
414: p_msg => 'Start of Procedure '|| l_proc );
415: END IF;
416:

Line 421: BIL_TX_UTIL_RPT_PKG.GET_DETAIL_PAGE_PARAMS

417: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
418: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
419:
420: -- code for a procedure to get parameter values.
421: BIL_TX_UTIL_RPT_PKG.GET_DETAIL_PAGE_PARAMS
422: (p_page_parameter_tbl => p_page_parameter_tbl,
423: p_region_id => l_region_id,
424: x_parameter_valid => l_parameter_valid,
425: x_viewby => l_viewby,

Line 511: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

507:
508:
509: x_custom_sql := l_custom_sql ;
510:
511: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
512: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,
513: p_proc => l_proc,
514: p_query => x_custom_sql);
515: END IF;

Line 512: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,

508:
509: x_custom_sql := l_custom_sql ;
510:
511: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
512: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,
513: p_proc => l_proc,
514: p_query => x_custom_sql);
515: END IF;
516:

Line 598: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN

594: g_pkg := 'asn.patch.115.sql.BIL_TX_OPTY_DETL_RPT_PKG.';
595:
596:
597: -- FND logging standard
598: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
599:
600: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
601: p_module => g_pkg || l_proc || 'begin',
602: p_msg => 'Start of Procedure '|| l_proc );

Line 600: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

596:
597: -- FND logging standard
598: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
599:
600: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
601: p_module => g_pkg || l_proc || 'begin',
602: p_msg => 'Start of Procedure '|| l_proc );
603: END IF;
604:

Line 609: BIL_TX_UTIL_RPT_PKG.GET_DETAIL_PAGE_PARAMS

605: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
606: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
607:
608: -- code for a procedure to get parameter values.
609: BIL_TX_UTIL_RPT_PKG.GET_DETAIL_PAGE_PARAMS
610: (p_page_parameter_tbl => p_page_parameter_tbl,
611: p_region_id => l_region_id,
612: x_parameter_valid => l_parameter_valid,
613: x_viewby => l_viewby,

Line 664: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

660:
661: x_custom_sql := l_custom_sql ;
662:
663:
664: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
665: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,
666: p_proc => l_proc,
667: p_query => x_custom_sql);
668: END IF;

Line 665: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,

661: x_custom_sql := l_custom_sql ;
662:
663:
664: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
665: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,
666: p_proc => l_proc,
667: p_query => x_custom_sql);
668: END IF;
669:

Line 741: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN

737:
738:
739:
740: -- FND logging standard
741: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
742:
743: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
744: p_module => g_pkg || l_proc || 'begin',
745: p_msg => 'Start of Procedure '|| l_proc );

Line 743: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

739:
740: -- FND logging standard
741: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
742:
743: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
744: p_module => g_pkg || l_proc || 'begin',
745: p_msg => 'Start of Procedure '|| l_proc );
746: END IF;
747:

Line 753: BIL_TX_UTIL_RPT_PKG.GET_DETAIL_PAGE_PARAMS

749: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
750:
751:
752: -- code for a procedure to get parameter values.
753: BIL_TX_UTIL_RPT_PKG.GET_DETAIL_PAGE_PARAMS
754: (p_page_parameter_tbl => p_page_parameter_tbl,
755: p_region_id => l_region_id,
756: x_parameter_valid => l_parameter_valid,
757: x_viewby => l_viewby,

Line 823: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

819:
820:
821: x_custom_sql := l_custom_sql ;
822:
823: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
824: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,
825: p_proc => l_proc,
826: p_query => x_custom_sql);
827: END IF;

Line 824: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,

820:
821: x_custom_sql := l_custom_sql ;
822:
823: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
824: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,
825: p_proc => l_proc,
826: p_query => x_custom_sql);
827: END IF;
828:

Line 901: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN

897: g_pkg := 'asn.patch.115.sql.BIL_TX_OPTY_DETL_RPT_PKG.';
898:
899:
900: -- FND logging standard
901: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
902:
903: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
904: p_module => g_pkg || l_proc || 'begin',
905: p_msg => 'Start of Procedure '|| l_proc );

Line 903: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

899:
900: -- FND logging standard
901: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
902:
903: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
904: p_module => g_pkg || l_proc || 'begin',
905: p_msg => 'Start of Procedure '|| l_proc );
906: END IF;
907:

Line 913: BIL_TX_UTIL_RPT_PKG.GET_DETAIL_PAGE_PARAMS

909: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
910:
911:
912: -- code for a procedure to get parameter values.
913: BIL_TX_UTIL_RPT_PKG.GET_DETAIL_PAGE_PARAMS
914: (p_page_parameter_tbl => p_page_parameter_tbl,
915: p_region_id => l_region_id,
916: x_parameter_valid => l_parameter_valid,
917: x_viewby => l_viewby,

Line 975: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

971:
972:
973: x_custom_sql := l_custom_sql ;
974:
975: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
976: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,
977: p_proc => l_proc,
978: p_query => x_custom_sql);
979: END IF;

Line 976: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,

972:
973: x_custom_sql := l_custom_sql ;
974:
975: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
976: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,
977: p_proc => l_proc,
978: p_query => x_custom_sql);
979: END IF;
980:

Line 1062: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN

1058:
1059:
1060:
1061: -- FND logging standard
1062: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1063:
1064: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
1065: p_module => g_pkg || l_proc || 'begin',
1066: p_msg => 'Start of Procedure '|| l_proc );

Line 1064: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

1060:
1061: -- FND logging standard
1062: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1063:
1064: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
1065: p_module => g_pkg || l_proc || 'begin',
1066: p_msg => 'Start of Procedure '|| l_proc );
1067: END IF;
1068:

Line 1074: BIL_TX_UTIL_RPT_PKG.GET_DETAIL_PAGE_PARAMS

1070: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
1071:
1072:
1073: -- code for a procedure to get parameter values.
1074: BIL_TX_UTIL_RPT_PKG.GET_DETAIL_PAGE_PARAMS
1075: (p_page_parameter_tbl => p_page_parameter_tbl,
1076: p_region_id => l_region_id,
1077: x_parameter_valid => l_parameter_valid,
1078: x_viewby => l_viewby,

Line 1122: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

1118:
1119:
1120: x_custom_sql := l_custom_sql ;
1121:
1122: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
1123: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,
1124: p_proc => l_proc,
1125: p_query => x_custom_sql);
1126: END IF;

Line 1123: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,

1119:
1120: x_custom_sql := l_custom_sql ;
1121:
1122: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
1123: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,
1124: p_proc => l_proc,
1125: p_query => x_custom_sql);
1126: END IF;
1127:

Line 1203: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN

1199: g_pkg := 'asn.patch.115.sql.BIL_TX_OPTY_DETL_RPT_PKG.';
1200:
1201:
1202: -- FND logging standard
1203: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1204:
1205: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
1206: p_module => g_pkg || l_proc || 'begin',
1207: p_msg => 'Start of Procedure '|| l_proc );

Line 1205: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

1201:
1202: -- FND logging standard
1203: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1204:
1205: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
1206: p_module => g_pkg || l_proc || 'begin',
1207: p_msg => 'Start of Procedure '|| l_proc );
1208: END IF;
1209:

Line 1214: BIL_TX_UTIL_RPT_PKG.GET_DETAIL_PAGE_PARAMS

1210: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
1211: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
1212:
1213: -- code for a procedure to get parameter values.
1214: BIL_TX_UTIL_RPT_PKG.GET_DETAIL_PAGE_PARAMS
1215: (p_page_parameter_tbl => p_page_parameter_tbl,
1216: p_region_id => l_region_id,
1217: x_parameter_valid => l_parameter_valid,
1218: x_viewby => l_viewby,

Line 1285: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

1281:
1282:
1283: x_custom_sql := l_custom_sql ;
1284:
1285: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
1286: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,
1287: p_proc => l_proc,
1288: p_query => x_custom_sql);
1289: END IF;

Line 1286: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,

1282:
1283: x_custom_sql := l_custom_sql ;
1284:
1285: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
1286: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,
1287: p_proc => l_proc,
1288: p_query => x_custom_sql);
1289: END IF;
1290:

Line 1366: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN

1362: g_pkg := 'asn.patch.115.sql.BIL_TX_OPTY_DETL_RPT_PKG.';
1363:
1364:
1365: -- FND logging standard
1366: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1367:
1368: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
1369: p_module => g_pkg || l_proc || 'begin',
1370: p_msg => 'Start of Procedure '|| l_proc );

Line 1368: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

1364:
1365: -- FND logging standard
1366: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1367:
1368: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
1369: p_module => g_pkg || l_proc || 'begin',
1370: p_msg => 'Start of Procedure '|| l_proc );
1371: END IF;
1372:

Line 1377: BIL_TX_UTIL_RPT_PKG.GET_DETAIL_PAGE_PARAMS

1373: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
1374: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
1375:
1376: -- code for a procedure to get parameter values.
1377: BIL_TX_UTIL_RPT_PKG.GET_DETAIL_PAGE_PARAMS
1378: (p_page_parameter_tbl => p_page_parameter_tbl,
1379: p_region_id => l_region_id,
1380: x_parameter_valid => l_parameter_valid,
1381: x_viewby => l_viewby,

Line 1449: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

1445:
1446:
1447: x_custom_sql := l_custom_sql ;
1448:
1449: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
1450: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,
1451: p_proc => l_proc,
1452: p_query => x_custom_sql);
1453: END IF;

Line 1450: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,

1446:
1447: x_custom_sql := l_custom_sql ;
1448:
1449: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
1450: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,
1451: p_proc => l_proc,
1452: p_query => x_custom_sql);
1453: END IF;
1454:

Line 1529: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN

1525:
1526:
1527:
1528: -- FND logging standard
1529: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1530:
1531: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
1532: p_module => g_pkg || l_proc || 'begin',
1533: p_msg => 'Start of Procedure '|| l_proc );

Line 1531: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

1527:
1528: -- FND logging standard
1529: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1530:
1531: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
1532: p_module => g_pkg || l_proc || 'begin',
1533: p_msg => 'Start of Procedure '|| l_proc );
1534: END IF;
1535:

Line 1540: BIL_TX_UTIL_RPT_PKG.GET_DETAIL_PAGE_PARAMS

1536: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
1537: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
1538:
1539: -- code for a procedure to get parameter values.
1540: BIL_TX_UTIL_RPT_PKG.GET_DETAIL_PAGE_PARAMS
1541: (p_page_parameter_tbl => p_page_parameter_tbl,
1542: p_region_id => l_region_id,
1543: x_parameter_valid => l_parameter_valid,
1544: x_viewby => l_viewby,

Line 1607: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

1603:
1604:
1605: x_custom_sql := l_custom_sql ;
1606:
1607: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
1608: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,
1609: p_proc => l_proc,
1610: p_query => x_custom_sql);
1611: END IF;

Line 1608: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,

1604:
1605: x_custom_sql := l_custom_sql ;
1606:
1607: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
1608: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,
1609: p_proc => l_proc,
1610: p_query => x_custom_sql);
1611: END IF;
1612:

Line 1691: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN

1687: g_pkg := 'asn.patch.115.sql.BIL_TX_OPTY_DETL_RPT_PKG.';
1688:
1689:
1690: -- FND logging standard
1691: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1692:
1693: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
1694: p_module => g_pkg || l_proc || 'begin',
1695: p_msg => 'Start of Procedure '|| l_proc );

Line 1693: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

1689:
1690: -- FND logging standard
1691: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1692:
1693: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
1694: p_module => g_pkg || l_proc || 'begin',
1695: p_msg => 'Start of Procedure '|| l_proc );
1696: END IF;
1697:

Line 1702: BIL_TX_UTIL_RPT_PKG.GET_DETAIL_PAGE_PARAMS

1698: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
1699: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
1700:
1701: -- code for a procedure to get parameter values.
1702: BIL_TX_UTIL_RPT_PKG.GET_DETAIL_PAGE_PARAMS
1703: (p_page_parameter_tbl => p_page_parameter_tbl,
1704: p_region_id => l_region_id,
1705: x_parameter_valid => l_parameter_valid,
1706: x_viewby => l_viewby,

Line 1767: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

1763:
1764:
1765: x_custom_sql := l_custom_sql ;
1766:
1767: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
1768: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,
1769: p_proc => l_proc,
1770: p_query => x_custom_sql);
1771: END IF;

Line 1768: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,

1764:
1765: x_custom_sql := l_custom_sql ;
1766:
1767: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
1768: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,
1769: p_proc => l_proc,
1770: p_query => x_custom_sql);
1771: END IF;
1772:

Line 1851: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN

1847:
1848:
1849:
1850: -- FND logging standard
1851: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1852:
1853: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
1854: p_module => g_pkg || l_proc || 'begin',
1855: p_msg => 'Start of Procedure '|| l_proc );

Line 1853: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

1849:
1850: -- FND logging standard
1851: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1852:
1853: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
1854: p_module => g_pkg || l_proc || 'begin',
1855: p_msg => 'Start of Procedure '|| l_proc );
1856: END IF;
1857:

Line 1862: BIL_TX_UTIL_RPT_PKG.GET_DETAIL_PAGE_PARAMS

1858: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
1859: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
1860:
1861: -- code for a procedure to get parameter values.
1862: BIL_TX_UTIL_RPT_PKG.GET_DETAIL_PAGE_PARAMS
1863: (p_page_parameter_tbl => p_page_parameter_tbl,
1864: p_region_id => l_region_id,
1865: x_parameter_valid => l_parameter_valid,
1866: x_viewby => l_viewby,

Line 1909: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

1905:
1906:
1907: x_custom_sql := l_custom_sql ;
1908:
1909: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
1910: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,
1911: p_proc => l_proc,
1912: p_query => x_custom_sql);
1913: END IF;

Line 1910: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,

1906:
1907: x_custom_sql := l_custom_sql ;
1908:
1909: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
1910: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,
1911: p_proc => l_proc,
1912: p_query => x_custom_sql);
1913: END IF;
1914: