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
6: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
7:
8:
209: l_bind_ctr:=l_bind_ctr+1;
210:
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:
365: l_bind_ctr:=l_bind_ctr+1;
366:
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:
562:
563: END PRODUCTS_TAB;
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:
702: l_bind_ctr:=l_bind_ctr+1;
703:
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:
863:
864: END PARTNER_TAB;
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:
1023:
1024: END CONTACTS_TAB;
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:
1163: END PROPOSAL_TAB;
1164:
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:
1326: END QUOTE_TAB;
1327:
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:
1489: l_bind_ctr:=l_bind_ctr+1;
1490:
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:
1647: l_bind_ctr:=l_bind_ctr+1;
1648:
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:
1806: l_bind_ctr:=l_bind_ctr+1;
1807:
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: