APPS.JTF_RS_DBI_CONC_PUB dependencies on JTF_RS_DBI_RES_GRP_VL

Line 7: table so that it can be accessed via view JTF_RS_DBI_RES_GRP_VL for Sales

3:
4: /****************************************************************************
5: This is a concurrent program to populate the data in JTF_RS_DBI_MGR_GROUPS
6: and JTF_RS_DBI_DENORM_RES_GROUPS
7: table so that it can be accessed via view JTF_RS_DBI_RES_GRP_VL for Sales
8: Group Hierarchy in DBI product. This program is exclusively built for DBI
9: product and is NOT included in mainline code of ATG Resource Manager.
10:
11: CREATED BY nsinghai 01/16/2003

Line 54: JTF_RS_DBI_RES_GRP_VL for Sales Group Hierarchy (usage : SALES) in DBI

50: ***************************************************************************/
51:
52: /****************************************************************************
53: This is a concurrent program to populate the data that can be accessed via view
54: JTF_RS_DBI_RES_GRP_VL for Sales Group Hierarchy (usage : SALES) in DBI
55: product.
56:
57: This program is exclusively built for DBI product and is NOT included in
58: mainline code of ATG Resource Manager.

Line 84: JTF_RS_DBI_RES_GRP_VL for usage 'FLD_SRV_DISTRICT' (Field Service District

80: END populate_res_grp;
81:
82: /****************************************************************************
83: This is concurrent program to populate the data that can be accessed via view
84: JTF_RS_DBI_RES_GRP_VL for usage 'FLD_SRV_DISTRICT' (Field Service District
85: Hierarchy) in DBI product.
86:
87: This program is exclusively built for DBI product and is NOT included in
88: mainline code of ATG Resource Manager.

Line 115: JTF_RS_DBI_RES_GRP_VL for usage 'SALES' (Sales Group Hierarchy) and

111:
112: /****************************************************************************
113: This is main procedure to populate the data in JTF_RS_DBI_MGR_GROUPS
114: and JTF_RS_DBI_DENORM_RES_GROUPS table so that it can be accessed via view
115: JTF_RS_DBI_RES_GRP_VL for usage 'SALES' (Sales Group Hierarchy) and
116: 'FLD_SRV_DISTRICT' (Field Service District Hierarchy) in DBI product.
117:
118: This program is exclusively built for DBI product and is NOT included in
119: mainline code of ATG Resource Manager.

Line 175: p_object_name => 'JTF_RS_DBI_RES_GRP_VL') = false)

171: p_retcode := '0' ;
172:
173: -- Call BIS_COLLECTION_UTILITIES to enable parallel session and other logging utilities
174: IF(BIS_COLLECTION_UTILITIES.Setup(
175: p_object_name => 'JTF_RS_DBI_RES_GRP_VL') = false)
176: THEN
177: p_errbuf := FND_MESSAGE.Get;
178: p_retcode := '-1';
179: RAISE_APPLICATION_ERROR(-20000,p_errbuf);

Line 806: FROM jtf_rs_dbi_res_grp_vl

802: SELECT id
803: INTO l_sg_id
804: FROM (
805: SELECT id, rank() over (order by value, id nulls last) rnk
806: FROM jtf_rs_dbi_res_grp_vl
807: WHERE usage = l_usage
808: AND current_id = -1111
809: AND denorm_level = 0
810: )

Line 819: FROM jtf_rs_dbi_res_grp_vl

815: SELECT id
816: INTO l_sg_id
817: FROM (
818: SELECT id, rank() over (order by current_id desc, value, id nulls last) rnk
819: FROM jtf_rs_dbi_res_grp_vl
820: WHERE usage = l_usage
821: AND current_id IN (-1111, -7777)
822: AND denorm_level = 0
823: )