DBA Data[Home] [Help]

APPS.BIL_TX_OPTY_DETL_RPT_PKG dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 6: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

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
6: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
7:
8:
9:
10: l_custom_rec BIS_QUERY_ATTRIBUTES;

Line 54: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();

50: l_period_set_name := NVL(FND_PROFILE.VALUE('ASN_FRCST_FORECAST_CALENDAR'), 'Accounting');
51: l_conversion_type := nvl(FND_PROFILE.VALUE('CRMBIS:GL_CONVERSION_TYPE'), 'Corporate');
52:
53: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
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

Line 215: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

211: END OPP_DETL_TAB;
212:
213: PROCEDURE OPP_FLEX_TAB (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
214: ,x_custom_sql OUT NOCOPY VARCHAR2
215: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
216:
217:
218:
219: l_custom_rec BIS_QUERY_ATTRIBUTES;

Line 257: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();

253: END IF;
254:
255:
256: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
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

Line 371: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

367: END OPP_FLEX_TAB;
368:
369: PROCEDURE PRODUCTS_TAB (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
370: ,x_custom_sql OUT NOCOPY VARCHAR2
371: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
372:
373:
374: l_custom_rec BIS_QUERY_ATTRIBUTES;
375: l_region_id VARCHAR2(100);

Line 418: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();

414: p_msg => 'Start of Procedure '|| l_proc );
415: END IF;
416:
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,

Line 568: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

564:
565:
566: PROCEDURE SALES_TEAM_TAB (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
567: ,x_custom_sql OUT NOCOPY VARCHAR2
568: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
569:
570:
571: l_custom_rec BIS_QUERY_ATTRIBUTES;
572: l_region_id VARCHAR2(100);

Line 606: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();

602: p_msg => 'Start of Procedure '|| l_proc );
603: END IF;
604:
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,

Line 708: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

704: END SALES_TEAM_TAB;
705:
706: PROCEDURE PARTNER_TAB (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
707: ,x_custom_sql OUT NOCOPY VARCHAR2
708: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
709:
710:
711: l_custom_rec BIS_QUERY_ATTRIBUTES;
712: l_region_id VARCHAR2(100);

Line 749: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();

745: p_msg => 'Start of Procedure '|| l_proc );
746: END IF;
747:
748: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
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

Line 869: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

865:
866:
867: PROCEDURE CONTACTS_TAB (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
868: ,x_custom_sql OUT NOCOPY VARCHAR2
869: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
870:
871:
872: l_custom_rec BIS_QUERY_ATTRIBUTES;
873: l_region_id VARCHAR2(100);

Line 909: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();

905: p_msg => 'Start of Procedure '|| l_proc );
906: END IF;
907:
908: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
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

Line 1029: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

1025:
1026:
1027: PROCEDURE PROPOSAL_TAB (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
1028: ,x_custom_sql OUT NOCOPY VARCHAR2
1029: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
1030:
1031:
1032: l_custom_rec BIS_QUERY_ATTRIBUTES;
1033: l_region_id VARCHAR2(100);

Line 1070: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();

1066: p_msg => 'Start of Procedure '|| l_proc );
1067: END IF;
1068:
1069: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
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

Line 1169: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

1165:
1166:
1167: PROCEDURE QUOTE_TAB (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
1168: ,x_custom_sql OUT NOCOPY VARCHAR2
1169: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
1170:
1171:
1172:
1173: l_custom_rec BIS_QUERY_ATTRIBUTES;

Line 1211: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();

1207: p_msg => 'Start of Procedure '|| l_proc );
1208: END IF;
1209:
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,

Line 1332: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

1328: -- Except for passing param it is complete.
1329:
1330: PROCEDURE PROJECTS_TAB (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
1331: ,x_custom_sql OUT NOCOPY VARCHAR2
1332: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
1333:
1334:
1335:
1336: l_custom_rec BIS_QUERY_ATTRIBUTES;

Line 1374: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();

1370: p_msg => 'Start of Procedure '|| l_proc );
1371: END IF;
1372:
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,

Line 1495: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

1491: END PROJECTS_TAB;
1492:
1493: PROCEDURE TASKS_TAB (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
1494: ,x_custom_sql OUT NOCOPY VARCHAR2
1495: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
1496:
1497:
1498:
1499: l_custom_rec BIS_QUERY_ATTRIBUTES;

Line 1537: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();

1533: p_msg => 'Start of Procedure '|| l_proc );
1534: END IF;
1535:
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,

Line 1653: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

1649: END TASKS_TAB;
1650:
1651: PROCEDURE ATTACHMENTS_TAB (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
1652: ,x_custom_sql OUT NOCOPY VARCHAR2
1653: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
1654:
1655:
1656:
1657: l_custom_rec BIS_QUERY_ATTRIBUTES;

Line 1699: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();

1695: p_msg => 'Start of Procedure '|| l_proc );
1696: END IF;
1697:
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,

Line 1812: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

1808: END ATTACHMENTS_TAB;
1809:
1810: PROCEDURE NOTES_TAB (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
1811: ,x_custom_sql OUT NOCOPY VARCHAR2
1812: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
1813:
1814:
1815:
1816: l_custom_rec BIS_QUERY_ATTRIBUTES;

Line 1859: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();

1855: p_msg => 'Start of Procedure '|| l_proc );
1856: END IF;
1857:
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,