DBA Data[Home] [Help]

APPS.BIL_TX_OPTY_DETL_RPT_PKG dependencies on BIL_TX_OPTY_DETL_RPT_PKG

Line 1: PACKAGE BODY BIL_TX_OPTY_DETL_RPT_PKG AS

1: PACKAGE BODY BIL_TX_OPTY_DETL_RPT_PKG AS
2: /* $Header: biltxodb.pls 120.15 2006/01/03 15:32 syeddana ship $ */
3:
4: PROCEDURE OPP_DETL_TAB (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
5: ,x_custom_sql OUT NOCOPY VARCHAR2

Line 38: g_pkg := 'asn.patch.115.sql.BIL_TX_OPTY_DETL_RPT_PKG.';

34: l_region_id := 'BIL_TX_OPTY_DETL_RPT';
35: l_parameter_valid := FALSE;
36: l_rpt_str := 'BIL_TX_OPTY_DETL_RPT_R';
37: l_proc := 'OPP_DETL_TAB.';
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

Line 244: g_pkg := 'asn.patch.115.sql.BIL_TX_OPTY_DETL_RPT_PKG.';

240: l_region_id := 'BIL_TX_OPTY_FLEX_RPT';
241: l_parameter_valid := FALSE;
242: l_rpt_str := 'BIL_TX_OPTY_FLEX_RPT_R';
243: l_proc := 'OPP_FLEX_TAB.';
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

Line 403: g_pkg := 'asn.patch.115.sql.BIL_TX_OPTY_DETL_RPT_PKG.';

399: l_region_id := 'BIL_TX_OPTY_DETL_PROD_RPT';
400: l_parameter_valid := FALSE;
401: l_rpt_str := 'BIL_TX_OPTY_DETL_PROD_RPT_R';
402: l_proc := 'PRODUCTS_TAB.';
403: g_pkg := 'asn.patch.115.sql.BIL_TX_OPTY_DETL_RPT_PKG.';
404:
405: l_period_set_name := NVL(FND_PROFILE.VALUE('ASN_FRCST_FORECAST_CALENDAR'), 'Accounting');
406: l_conversion_type := nvl(FND_PROFILE.VALUE('CRMBIS:GL_CONVERSION_TYPE'), 'Corporate');
407:

Line 594: g_pkg := 'asn.patch.115.sql.BIL_TX_OPTY_DETL_RPT_PKG.';

590: l_region_id := 'BIL_TX_OPTY_DETL_STEAM_RPT';
591: l_parameter_valid := FALSE;
592: l_rpt_str := 'BIL_TX_OPTY_DETL_STEAM_RPT_R';
593: l_proc := 'SALES_TEAM_TAB.';
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

Line 736: g_pkg := 'asn.patch.115.sql.BIL_TX_OPTY_DETL_RPT_PKG.';

732: l_region_id := 'BIL_TX_OPTY_DETL_PTNR_RPT';
733: l_parameter_valid := FALSE;
734: l_rpt_str := 'BIL_TX_OPTY_DETL_PTNR_RPT_R';
735: l_proc := 'PARTNER_TAB.';
736: g_pkg := 'asn.patch.115.sql.BIL_TX_OPTY_DETL_RPT_PKG.';
737:
738:
739:
740: -- FND logging standard

Line 897: g_pkg := 'asn.patch.115.sql.BIL_TX_OPTY_DETL_RPT_PKG.';

893: l_region_id := 'BIL_TX_OPTY_DETL_CONT_RPT';
894: l_parameter_valid := FALSE;
895: l_rpt_str := 'BIL_TX_OPTY_DETL_CONT_RPT_R';
896: l_proc := 'CONTACTS_TAB.';
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

Line 1057: g_pkg := 'asn.patch.115.sql.BIL_TX_OPTY_DETL_RPT_PKG.';

1053: l_region_id := 'BIL_TX_OPTY_DETL_PROP_RPT';
1054: l_parameter_valid := FALSE;
1055: l_rpt_str := 'BIL_TX_OPTY_DETL_PROP_RPT_R';
1056: l_proc := 'PROPOSAL_TAB.';
1057: g_pkg := 'asn.patch.115.sql.BIL_TX_OPTY_DETL_RPT_PKG.';
1058:
1059:
1060:
1061: -- FND logging standard

Line 1199: g_pkg := 'asn.patch.115.sql.BIL_TX_OPTY_DETL_RPT_PKG.';

1195: l_region_id := 'BIL_TX_OPTY_DETL_QUOTE_RPT';
1196: l_parameter_valid := FALSE;
1197: l_rpt_str := 'BIL_TX_OPTY_DETL_QUOTE_RPT_R';
1198: l_proc := 'QUOTE_TAB.';
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

Line 1362: g_pkg := 'asn.patch.115.sql.BIL_TX_OPTY_DETL_RPT_PKG.';

1358: l_region_id := 'BIL_TX_OPTY_DETL_PROJ_RPT';
1359: l_parameter_valid := FALSE;
1360: l_rpt_str := 'BIL_TX_OPTY_DETL_PROJ_RPT_R';
1361: l_proc := 'PROJECTS_TAB.';
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

Line 1524: g_pkg := 'asn.patch.115.sql.BIL_TX_OPTY_DETL_RPT_PKG.';

1520: l_region_id := 'BIL_TX_OPTY_DETL_TASK_RPT';
1521: l_parameter_valid := FALSE;
1522: l_rpt_str := 'BIL_TX_OPTY_DETL_TASK_RPT_R';
1523: l_proc := 'TASKS_TAB.';
1524: g_pkg := 'asn.patch.115.sql.BIL_TX_OPTY_DETL_RPT_PKG.';
1525:
1526:
1527:
1528: -- FND logging standard

Line 1687: g_pkg := 'asn.patch.115.sql.BIL_TX_OPTY_DETL_RPT_PKG.';

1683: l_region_id := 'BIL_TX_OPTY_DETL_ATCH_RPT';
1684: l_parameter_valid := FALSE;
1685: l_rpt_str := 'BIL_TX_OPTY_DETL_ATCH_RPT_R';
1686: l_proc := 'ATTACHMENTS_TAB.';
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

Line 1846: g_pkg := 'asn.patch.115.sql.BIL_TX_OPTY_DETL_RPT_PKG.';

1842: l_region_id := 'BIL_TX_OPTY_DETL_NOTES_RPT';
1843: l_parameter_valid := FALSE;
1844: l_rpt_str := 'BIL_TX_OPTY_DETL_NOTES_RPT_R';
1845: l_proc := 'NOTES_TAB.';
1846: g_pkg := 'asn.patch.115.sql.BIL_TX_OPTY_DETL_RPT_PKG.';
1847:
1848:
1849:
1850: -- FND logging standard

Line 1953: END BIL_TX_OPTY_DETL_RPT_PKG;

1949: l_bind_ctr:=l_bind_ctr+1;
1950:
1951: END NOTES_TAB;
1952:
1953: END BIL_TX_OPTY_DETL_RPT_PKG;
1954: