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

Line 1: PACKAGE BODY OKI_DBI_UTIL_PVT AS

1: PACKAGE BODY OKI_DBI_UTIL_PVT AS
2: /* $Header: OKIRDBIB.pls 120.2 2006/02/06 00:50:15 pubalasu noship $ */
3:
4: PROCEDURE populate_mv_bmap (
5: p_mv_bmap_tbl OUT NOCOPY oki_dbi_mv_bmap_tbl

Line 45: , VALUE => 'OKI_DBI_UTIL_PVT.current_period_start_date ');

41: bis_collection_utilities.put_line (SQLERRM || '' || SQLCODE);
42: fnd_message.set_name (application => 'FND'
43: , NAME => 'CRM-DEBUG ERROR');
44: fnd_message.set_token (token => 'ROUTINE'
45: , VALUE => 'OKI_DBI_UTIL_PVT.current_period_start_date ');
46: bis_collection_utilities.put_line (fnd_message.get);
47: raise_application_error (-20000
48: , 'Stack Dump Follows =>'
49: , TRUE);

Line 84: , VALUE => 'OKI_DBI_UTIL_PVT.current_period_end_date ');

80: bis_collection_utilities.put_line (SQLERRM || '' || SQLCODE);
81: fnd_message.set_name (application => 'FND'
82: , NAME => 'CRM-DEBUG ERROR');
83: fnd_message.set_token (token => 'ROUTINE'
84: , VALUE => 'OKI_DBI_UTIL_PVT.current_period_end_date ');
85: bis_collection_utilities.put_line (fnd_message.get);
86: raise_application_error (-20000
87: , 'Stack Dump Follows =>'
88: , TRUE);

Line 328: , VALUE => 'OKI_DBI_UTIL_PVT.get_sec_profile ');

324: bis_collection_utilities.put_line (SQLERRM || '' || SQLCODE);
325: fnd_message.set_name (application => 'FND'
326: , NAME => 'CRM-DEBUG ERROR');
327: fnd_message.set_token (token => 'ROUTINE'
328: , VALUE => 'OKI_DBI_UTIL_PVT.get_sec_profile ');
329: bis_collection_utilities.put_line (fnd_message.get);
330: raise_application_error (-20000
331: , 'Stack Dump Follows =>'
332: , TRUE);

Line 373: , VALUE => 'OKI_DBI_UTIL_PVT.get_org_where ');

369: bis_collection_utilities.put_line (SQLERRM || '' || SQLCODE);
370: fnd_message.set_name (application => 'FND'
371: , NAME => 'CRM-DEBUG ERROR');
372: fnd_message.set_token (token => 'ROUTINE'
373: , VALUE => 'OKI_DBI_UTIL_PVT.get_org_where ');
374: bis_collection_utilities.put_line (fnd_message.get);
375: raise_application_error (-20000
376: , 'Stack Dump Follows =>'
377: , TRUE);

Line 589: , VALUE => 'OKI_DBI_UTIL_PVT.get_dbi_params ');

585: bis_collection_utilities.put_line (SQLERRM || '' || SQLCODE);
586: fnd_message.set_name (application => 'FND'
587: , NAME => 'CRM-DEBUG ERROR');
588: fnd_message.set_token (token => 'ROUTINE'
589: , VALUE => 'OKI_DBI_UTIL_PVT.get_dbi_params ');
590: bis_collection_utilities.put_line (fnd_message.get);
591: raise_application_error (-20000
592: , 'Stack Dump Follows =>'
593: , TRUE);

Line 611: , VALUE => 'OKI_DBI_UTIL_PVT.get_global_currency ');

607: bis_collection_utilities.put_line (SQLERRM || '' || SQLCODE);
608: fnd_message.set_name (application => 'FND'
609: , NAME => 'CRM-DEBUG ERROR');
610: fnd_message.set_token (token => 'ROUTINE'
611: , VALUE => 'OKI_DBI_UTIL_PVT.get_global_currency ');
612: bis_collection_utilities.put_line (fnd_message.get);
613: raise_application_error (-20000
614: , 'Stack Dump Follows =>'
615: , TRUE);

Line 822: , VALUE => 'OKI_DBI_UTIL_PVT.get_parameter_values ');

818: bis_collection_utilities.put_line (SQLERRM || '' || SQLCODE);
819: fnd_message.set_name (application => 'FND'
820: , NAME => 'CRM-DEBUG ERROR');
821: fnd_message.set_token (token => 'ROUTINE'
822: , VALUE => 'OKI_DBI_UTIL_PVT.get_parameter_values ');
823: bis_collection_utilities.put_line (fnd_message.get);
824: raise_application_error (-20000
825: , 'Stack Dump Follows =>'
826: , TRUE);

Line 901: , VALUE => 'OKI_DBI_UTIL_PVT.get_drill_across_param_val ');

897: bis_collection_utilities.put_line (SQLERRM || '' || SQLCODE);
898: fnd_message.set_name (application => 'FND'
899: , NAME => 'CRM-DEBUG ERROR');
900: fnd_message.set_token (token => 'ROUTINE'
901: , VALUE => 'OKI_DBI_UTIL_PVT.get_drill_across_param_val ');
902: bis_collection_utilities.put_line (fnd_message.get);
903: raise_application_error (-20000
904: , 'Stack Dump Follows =>'
905: , TRUE);

Line 985: oki_dbi_util_pvt.get_where_clauses(l_dim_map, p_trend, p_view_by,p_mv_set)

981: IF (p_mv_set IN ('SRM_DTL_RPT','SRM_CDTL_RPT')) then
982: p_where_clause := get_dtl_param_where(p_param);
983: ELSE -- summary reports and trends
984: p_where_clause :=
985: oki_dbi_util_pvt.get_where_clauses(l_dim_map, p_trend, p_view_by,p_mv_set)
986: || get_security_where_clauses (l_dim_map
987: , p_func_area
988: , p_version
989: , p_role

Line 1093: IF (oki_dbi_util_pvt.g_resource_id IS NULL) THEN

1089: END IF;
1090:
1091: END LOOP;
1092:
1093: IF (oki_dbi_util_pvt.g_resource_id IS NULL) THEN
1094: l_resource := ' ';
1095: l_rgroup := ' AND fact.resource_group_id = rs_grp.rg_id
1096: AND rs_grp.prg_id = &OKI_RG ';
1097: ELSE

Line 1711: IF (oki_dbi_util_pvt.g_resource_id IS NULL) then

1707: THEN
1708: --Pushkala : 71 MVs for Detail reports
1709: p_mv_bmap_tbl.EXTEND (1);
1710: l_rec.mv_bmap := g_oper_unit_bmap + g_sales_grp_bmap + g_sitem_bmap+g_prd_ctgy_bmap;
1711: IF (oki_dbi_util_pvt.g_resource_id IS NULL) then
1712: l_rec.mv_name := ' OKI_RS_GROUP_MV rs_grp, OKI_SRM_004_MV ';
1713: ELSE
1714: l_rec.mv_name := ' OKI_SRM_004_MV ';
1715: END IF;

Line 2461: END oki_dbi_util_pvt;

2457: ', NULL)'; -- NEW CODE
2458: */
2459: END change_clause;
2460:
2461: END oki_dbi_util_pvt;